Pradinis
Pagalba
Užsisakyk!
- Reklamą
- Hostingą
- El. pašto dėžutę
Užsisakyk!
Įrankiai
Pasidalink
- Visos temos
Forumas | PHP-Fusion, WordPress, Shopify, PHP ir MySQL (PROGRAMAVIMAS) | Kiti PHP, HTML, MySQL klausimai |
Autorius: ausska | Peržiūrų: 1105 |
ausska Narys Žalias Pranešimai: 9 Įstojęs: 2008 Rugs. 14 12:09:48 | |
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 ? asdasdfasd |
|
--- Narys Viršesnis už Dievą Pranešimai: 5618 Įstojęs: 2007 Bir. 3 19:06:09 | |
o tai kas blogai? |
|
ausska Narys Žalias Pranešimai: 9 Įstojęs: 2008 Rugs. 14 12:09:48 | |
neveike ir as neturiu ant data basiu psw tai gal delto netinka ? asdasdfasd |
Peršokti į forumą: |