WordPress, Shopify ir PHPFusion programuotojų bendruomenė

Parašė Slezas· 2008 Rugs. 18 14:09:58

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&#235;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();