Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- function online_players($realm)
- {
- // Nastavení
- $db_host = "192.168.1.2:3307"; // IP adresa serveru (default = "127.0.0.1")
- $db_user = ""; // Prihlašovací jméno do DataBáze
- $db_pass = ""; // Prihlašovací heslo do DataBáze
- $db_name_mangos = "wow_wotlk_world"; // Název MANGOS DataBáze
- $db_name_realmd = "wow_realmd"; // Název REALMD DataBáze
- $db_name_characters = "wow_wotlk_fun_characters"; // Název DB s CHARAKTERY
- // pripojení do characters
- mysql_connect($db_host, $db_user, $db_pass) or die('Nastala CHYBA: Nepovedlo se navazat spojeni se serverem. [KEY: SERVER DB] ' );
- // Prepneme DB do World
- mysql_select_db($db_name_mangos) or die ('Nepovedlo se navazat spojeni k DataBazi! MySQL_Error: ' . mysql_error());
- // vypiš všechny online charaktery
- $result_webstats = mysql_query("SELECT `time`, `overall`, `viponline`, `gmonline` FROM `webstats` ORDER BY `webstats`.`time` DESC LIMIT 0 , 1") or die (mysql_error());
- $row_webstats = mysql_fetch_array($result_webstats);
- // skopiruj fetchnuty array do pomocnej premennej
- $resarray = array(
- 'webstats_online_time' => $row_webstats[0],
- 'online_all_players' => $row_webstats[1],
- 'online_vip_players' => $row_webstats[2],
- 'overall_vip_players' => $count_vip_overall,
- 'online_gmt_players' => $row_webstats[3],
- 'overall_gmt_players' => $count_gmt_overall,
- );
- // uvolni vysledok, nech to DB zbytocne nedrzi
- mysql_free_result($result_webstats);
- //ukonci pripojeni do characters
- mysql_close();
- // funkce vraci pole s poctem
- return($resarray);
- }
Add Comment
Please, Sign In to add comment