Parašė ausska· 2009 Sau. 14 17:01:54
#1
openside("Statistics");
$host = "localhost";
$user = "Jusu_Duomenu_bazes_vartotojo_vardas";
$pass = "Jusu_Duomenu_Bazes_slaptazodis";
$db1 = "Duomenu_Bazes_pavadinimas";
$link = mysql_connect ($host, $user, $pass)
or die ('Cant connect, check your setings');
mysql_select_db ($db1);
$acc = mysql_query ("SELECT login FROM accounts ");
$acc_count = mysql_num_rows ($acc);
$characters = mysql_query ("SELECT char_name FROM characters WHERE level > 0");
$char_count = mysql_num_rows ($characters);
$clan = mysql_query ("SELECT *FROM clan_data");
$clan_count = mysql_num_rows ($clan);
$online = mysql_query ("SELECT * FROM characters WHERE online = 1");
$on_count = mysql_num_rows ($online);
$human = mysql_query ("SELECT*FROM characters WHERE race = 0");
$human_count = mysql_num_rows ($human);
$elf = mysql_query ("SELECT*FROM characters WHERE race = 1");
$elf_count = mysql_num_rows ($elf);
$delf = mysql_query ("SELECT*FROM characters WHERE race = 2");
$delf_count = mysql_num_rows ($delf);
$orc = mysql_query ("SELECT*FROM characters WHERE race = 3");
$orc_count = mysql_num_rows ($orc);
$dwarf = mysql_query ("SELECT*FROM characters WHERE race = 4");
$dwarf_count = mysql_num_rows ($dwarf);
$kamael = mysql_query ("SELECT*FROM characters WHERE race = 5");
$kamael_count = mysql_num_rows ($kamael);
echo ("<b>");
echo ("<font color=green> Accounts Created: </font>");
echo ("<font color=red> $acc_count</font><br>");
echo ("<font color= green> Characters created: </font>");
echo("<font color=red><b> $char_count </b></font><ul>");
echo ("<font color=green> Where: </font><ul>");
echo ("<li><font color=green>Humans: </font><font color=red> $human_count</font></li>");
echo ("<li><font color=green>Elfs: </font><font color=red> $elf_count</font></li>");
echo ("<li><font color=green>Dark Elfs: </font><font color=red> $delf_count</font></li>");
echo ("<li><font color=green>Orcs: </font><font color=red> $orc_count</font></li>");
echo ("<li><font color=green>Dwarfs: </font><font color=red> $dwarf_count</font></li>");
echo ("<li><font color=green>Kamaels: </font><font color=red> $kamael_count</font></li></ul></ul>");
echo ("<font color=green><b>Clans created: </b></font>");
echo ("<font color=red><b> $clan_count</b></font><br>");
echo ("<font color=green><b>Online: </b></font>");
echo ("<font color=red><b> $on_count</b></font><br>");
echo ("</b>");
mysql_close ($link, $user, $pass, $db1);
;
closeside();
KASS CE GALI BUTI BLOGAI ?