Prašom:
nesu tikras ar veikia ant v7
openside("Statistika");
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();
|