Tai vat noriu kad padetumete pakoregoti statistikos panele.
As joje noreciau pakeisti y kiekvienos kategorijos siuntiniu skaiciu.
Daleiskim yra muzikos tinklapis ir nori padaryt kad paneleje rodytu
Popsas [18]dainu
Club [25]
Rokas[2] t.t.
Stai kodas:openside("Statistika");
echo "
<br>
<b><img src='http://imghost.ux-tm.net/images/XCp53039.gif'>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'>° Naujausias Narys</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 "° Nauji nariai vakar: ".dbcount("(user_id)", "users", "user_joined >='".$ganfang."' AND user_joined <='".$gende."'")."<br>";
echo "° Nauji nariai Siandien: ".dbcount("(user_id)", "users", "user_joined >='".$hanfang."' AND user_joined <='".$hende."'")."<br>";
echo "<span class='small'>° Is viso nariu: </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 Administratoriai: ".$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 "° Administratoriai: ".$num_rows."</a><br>\n";
$result = dbquery("SELECT count(group_id) FROM ".$db_prefix."user_groups");
echo "° Vartotojo grupes: [".dbresult($result, 0)."]<br>";
echo "
<hr>
<b><img src='http://imghost.ux-tm.net/images/XCp53039.gif'>Svetainës Statistika:</b><br>";
$result = dbquery("SELECT count(news_id) FROM ".$db_prefix."news");
echo "° Naujienos: [".dbresult($result, 0)."]<br>";
$result = dbquery("SELECT count(article_id) FROM ".$db_prefix."articles");
echo "° Straipsniai: [".dbresult($result, 0)."]<br>";
$result = dbquery("SELECT count(download_id) FROM ".$db_prefix."downloads");
echo "° Dainos: [".dbresult($result, 0)."]<br>";
$result = dbquery("SELECT count(photo_id) FROM ".$db_prefix."photos");
echo "° Nuotraukos: [".dbresult($result, 0)."]<br>";
$result = dbquery("SELECT count(weblink_id) FROM ".$db_prefix."weblinks");
echo "° Nuorodos: [".dbresult($result, 0)."]<br>";
$result = dbquery("SELECT count(post_id) FROM ".$db_prefix."posts");
echo "° Forumo pranesimai: [".dbresult($result, 0)."]<br>";
$result = dbquery("SELECT count(comment_id) FROM ".$db_prefix."comments");
echo "° Komentarai: [".dbresult($result, 0)."]<br>";
$result = dbquery("SELECT count(shout_id) FROM ".$db_prefix."shoutbox");
echo "° Saukyklos pranesimai: [".dbresult($result, 0)."]<br>";
$result = dbquery("SELECT count(poll_id) FROM ".$db_prefix."polls");
echo "° Apklausos: [".dbresult($result, 0)."]<br>";
closeside();
K-S |