Hello, i have one more problem and a Question.
I have panels code. This is a "Last seen user + User statistic + Site statistic."
When i wan't to put it the panel brings errors. Here i the Code of Panel.
openside("Statistika"
;
[syntaxhighlighter brush=php,first-line=1,highlight=0,collapse=false,html-script=false]echo "<table width='100%' border='0' cellspacing='0' cellpadding='0'>
<tr><td><div>";
echo "n";
$result=dbquery("SELECT * FROM ".$db_prefix."users WHERE user_lastvisit>'0' AND user_status='0' ORDER BY user_lastvisit DESC LIMIT 0,10"
;
if(dbrows($result)!=0){
while($data=dbarray($result)){
$lastseen=time()-$data['user_lastvisit'];
$iW=sprintf("%2d",floor($lastseen/604800));
$iD=sprintf("%2d",floor($lastseen/(60*60*24)));
$iH=sprintf("%02d",floor((($lastseen%604800)%86400)/3600));
$iM=sprintf("%02d",floor(((($lastseen%604800)%86400)%3600)/60));
$iS=sprintf("%02d",floor((((($lastseen%604800)%86400)%3600)%60)));
if($lastseen<60){
$lastseen="<img src='".IMAGES."online.gif' height='11' width='62'>n"; //<<uzytkownik online //
}elseif($lastseen<160){
$lastseen="<img src='".IMAGES."offline.gif' height='11' width='62'>n"; //<<uzytkownik odchchodzi, po 360 sek od czasu wylogowania//
}elseif($iW>0){
if($iW==1) $Text="".$locale['XXX_007']."";
elseif($iW==2 || $iW==3 || $iW==4) $Text="".$locale['XXX_011']."";
else $Text="".$locale['XXX_008']."";
$lastseen="$iW $Text";
}elseif($iD>0){
if($iD==1) $Text="".$locale['XXX_009']."";
else $Text="".$locale['XXX_010']."";
$lastseen="$iD $Text";
}else{
$lastseen="$iH:$iM:$iS";
}
echo "<tr>n<td class='side-small' align='left'><img src='".THEME."images/bullet.gif' alt=''>n";
echo "<a href='".BASEDIR."profile.php?lookup=".$data['user_id']."' title='".$data['user_name']."' class='side'>n";
echo trimlink($data['user_name'], 15)."</a></td><td class='side-small' align='right'>".$lastseen."</td>n</tr>n";
}
}
echo "</table><br>";
echo "
<br><img src='http://www.iconarchive.com/icons/fasticon/fast-icon-users/16/user-icon.png'>Narių Statistika:</b><br>";
$data = dbarray(dbquery("SELECT user_id,user_name FROM ".$db_prefix."users WHERE user_status='0' ORDER BY user_joined DESC LIMIT 0,1"
);
echo "<span class='small'>°</span> ".$locale['on117']."<a href='".BASEDIR."profile.php?lookup=".$data['user_id']."' class='side' title='".$data['user_name']."'>".trimlink($data['user_name'], 12)."</a><br />n";$tag1= date('d'
;
$tag1= date('d'
;
$monat1= date('m'
;
$jahr1= date('Y'
;
$hanfang = mktime(0,0,0,$monat1,$tag1,$jahr1);
$hende = mktime(23,59,59,$monat1,$tag1,$jahr1);
$ganfang = mktime(0,0,0,$monat1,$tag1-1,$jahr1);
$gende = mktime(23,59,59,$monat1,$tag1-1,$jahr1);
echo "° Naujų narių vakar: ".dbcount("(user_id)", "users", "user_joined >='".$ganfang."' AND user_joined <='".$gende."'"
."<br>";
echo "° Naujų narių šiandien: ".dbcount("(user_id)", "users", "user_joined >='".$hanfang."' AND user_joined <='".$hende."'"
."<br>";
echo "<span class='small'>° Iš viso narių: </span> ".number_format(dbcount("(user_id)", "users", "user_status<='1'"
)."<br />n";
$result = mysql_query("SELECT user_level FROM ".$db_prefix."users where user_level=103"
;
$num_rows = mysql_num_rows($result);
//display the result
echo "° Super Administratorių: ".$num_rows."</a><br>n";
$result = mysql_query("SELECT user_level FROM ".$db_prefix."users where user_level=102"
;
$num_rows = mysql_num_rows($result);
//display the result
echo "° Administratorių: ".$num_rows."</a><br>n";
$result = mysql_query("SELECT user_level FROM ".$db_prefix."users where user_level=102"
;
$num_rows = mysql_num_rows($result);
//display the result
echo "° Forumo Moderatorių: ".$num_rows."</a><br>n";
$result = dbquery("SELECT count(group_id) FROM ".$db_prefix."user_groups"
;
echo "° Vartotojų grupių: [".dbresult($result, 0)."]<br>";
echo "
<hr>
<b><img src='http://www.iconarchive.com/icons/dan-wiersma/solar-system/16/Earth-icon.png'>Svetainės Statistika:</b><br>";
$result = dbquery("SELECT count(news_id) FROM ".$db_prefix."news"
;
echo "° Naujienų: [".dbresult($result, 0)."]<br>";
$result = dbquery("SELECT count(article_id) FROM ".$db_prefix."articles"
;
echo "° Straipsnių: [".dbresult($result, 0)."]<br>";
$result = dbquery("SELECT count(download_id) FROM ".$db_prefix."downloads"
;
echo "° Siuntinių: [".dbresult($result, 0)."]<br>";
$result = dbquery("SELECT count(photo_id) FROM ".$db_prefix."photos"
;
echo "° Nuotraukų: [".dbresult($result, 0)."]<br>";
$result = dbquery("SELECT count(weblink_id) FROM ".$db_prefix."weblinks"
;
echo "° Nuorodų: [".dbresult($result, 0)."]<br>";
$result = dbquery("SELECT count(post_id) FROM ".$db_prefix."posts"
;
echo "° Forumo pranešimų: [".dbresult($result, 0)."]<br>";
$result = dbquery("SELECT count(comment_id) FROM ".$db_prefix."comments"
;
echo "° Komentarų: [".dbresult($result, 0)."]<br>";
$result = dbquery("SELECT count(shout_id) FROM ".$db_prefix."shoutbox"
;
echo "° Šaukyklos pranešimų: [".dbresult($result, 0)."]<br>";
$result = dbquery("SELECT count(poll_id) FROM ".$db_prefix."polls"
;
echo "° Apklausų: [".dbresult($result, 0)."]<br>";
closeside();[/syntaxhighlighter]
And here is the error:
[syntaxhighlighter brush=php,first-line=1,highlight=0,collapse=false,html-script=false]Notice: Undefined index: XXX_010 in /home/pbmasters/domains/pbmasters.ipp.lt/public_html/themes/templates/panels.php(78) : eval()'d code on line 53
Notice: Undefined index: XXX_010 in /home/pbmasters/domains/pbmasters.ipp.lt/public_html/themes/templates/panels.php(78) : eval()'d code on line 53
Notice: Undefined index: XXX_010 in /home/pbmasters/domains/pbmasters.ipp.lt/public_html/themes/templates/panels.php(78) : eval()'d code on line 53
DominiC [Here is the Online pic.]
PBMasters 00:07:10
SkyWocker 21:31:15
Asiliukas 2 [Here must be days but here is showing just number]
ogis 2 [And I think that These error uper is from these day]
HSmaker 3
Narių Statistika:
Notice: Undefined index: on117 in /home/pbmasters/domains/pbmasters.ipp.lt/public_html/themes/templates/panels.php(78) : eval()'d code on line 81
° ogis
Table 'pbmasters_pb.users' doesn't exist° Naujų narių vakar:
Table 'pbmasters_pb.users' doesn't exist° Naujų narių šiandien:
Table 'pbmasters_pb.users' doesn't exist° Iš viso narių: 0
° Super Administratorių: 2
° Administratorių: 1
° Forumo Moderatorių: 1
° Vartotojų grupių: [2]
Svetainės Statistika:
° Naujienų: [2]
° Straipsnių: []
° Siuntinių: []
° Nuotraukų: []
° Nuorodų: []
° Forumo pranešimų: [14]
° Komentarų: [1]
° Šaukyklos pranešimų: [25]
° Apklausų: [1][/syntaxhighlighter]
Sorry for my bad English and the Lithuania Panel