Guest dizzy Posted January 18, 2012 Share Posted January 18, 2012 Server Status: < ?$fp = @fsockopen("127.0.0.1", 55901, $errno, $errstr, 1);if($fp >= 1){echo '<font color=00FF00>Online</font>';}else{ echo '<font color=990000>Offline</font>'; }?> Nr. de useri banati: < ?php $sql = mssql_query("SELECT count(*) FROM Character where ctlcode=1");echo mssql_result($sql, 0, 0); ?>[/code] [/color] [b][color=#4A4A4A]Nr. de useri Online:[/color][/b] [color=#4A4A4A][code]<? Php$ Sql = mssql_query ("SELECT count (*) FROM WHERE MEMB_STAT ConnectStat = 1");if (mssql_result ($ sql, 0, 0) <= 50) (/ / this script to set the color of the numbersecho "<font color=black>" / / 00-50 is black 50-100 is orangemssql_result echo ($ sql, 0, 0);) / / and up to 100 turns redelseif (mssql_result ($ sql, 0, 0)> = 50 AND mssql_result ($ sql, 0, 0) <= 100) (echo "<font color=FF6600>";mssql_result echo ($ sql 0, 0);)elseif (mssql_result ($ sql, 0, 0)> 100) (echo "<font color=990000>";mssql_result echo ($ sql, 0, 0);)>[/color][color=#4A4A4A][/code] [/color] [color=#4A4A4A][b]Nr. de conturi[/b]:[/color] [color=#4A4A4A][code]< ?php$tacountresult= mssql_query("select memb___id from MEMB_INFO");$tacount = mssql_num_rows ($tacountresult);?>< ?php print "$tacount"; ?>[/code] [/color] [b][color=#4A4A4A]Nr. de Caractere:[/color][/b] [color=#4A4A4A][code]< ?php$tcharsresult = mssql_query("select Name from Character");$tchars = mssql_num_rows ($tcharsresult);?>< ?php print "$tchars"; ?>[/color][color=#4A4A4A][/code] [/color] [b][color=#4A4A4A]Arata timpul de la eventurile BC si DS:[/color][/b] [color=#4A4A4A][CODE]<? Php$ Alogin = sa;$ Apassimento = "SQL password";$ Db = 'MuOnline';$ Host = "Your IP Here";$ Msconnect = mssql_connect ($ host, $ alogin, $ apassimento);$ Msdb = mssql_select_db ("$ db", $ msconnect)$ Query = 'select Name, Class, cLevel, Strength, Dexterity, Vitality, Ener gy, LevelUpPoint, CtlCode, resetsCharacter from order by resets desc cLevel desc ';$ Result = mssql_query ($ query);echo '<html>';echo "<head> \ n";echo '<body>';echo '<font face=Verdana>';echo '<center> <table cellSpacing=1 width=100% align=center>';echo '<tr><Td bgcolor = F5F5F5> <center> <b> Rank </ td><Td bgcolor = F5F5F5> <b> Character </ td><Td bgcolor = F5F5F5> <b> Class </ td><Td bgcolor = F5F5F5> <b> Level </ td><Td bgcolor = F5F5F5> <b> Strength </ td><Td bgcolor = F5F5F5> <b> Agility </ td><Td bgcolor = F5F5F5> <b> Vitality </ td><Td bgcolor = F5F5F5> <b> Energy </ font> </ td><Td bgcolor = F5F5F5> <b> Resets </ font> </ td> ';/ / Here you put the number of rank/ / In this case top 100/ / If you want to change you're just swap the 100 for the desired numberfor ($ i = 0, $ i <100; + + $ i)($ Row = mssql_fetch_row ($ result);$ Personage = htmlentities ($ row [0]);echo '<tr> <td width=5% bgcolor=F5F5F5> <center> <b>';echo $ i + 1;echo 'º </ td> <td width=21% bgcolor=F5F5F5> <table>';echo $ character;echo '</ table> </ td> <td width=19% bgcolor=F5F5F5>';if ($ row [8] == 8) (echo 'Game Master';)else (if ($ row [1] == 0) (echo 'Dark Wizard';)if ($ row [1] == 1) (echo 'Soul Master';)if ($ row [1] == 16) (echo 'Dark Knight';)if ($ row [1] == 17) (echo 'Blade Knight';)if ($ row [1] == 32) (echo 'Elf';)if ($ row [a] == 33) (echo 'Muse Elf';)if ($ row [1] == 48) (echo 'Magic Gladiator';)if ($ row [1] == 64) (echo 'Dark Lord';))echo '</ td> <td width=8% bgcolor=F5F5F5>';echo $ row [2];echo '</ td> <td width=9% bgcolor=F5F5F5>';echo $ row [3];echo '</ td> <td width=9% bgcolor=F5F5F5>';echo $ row [4];echo '</ td> <td width=9% bgcolor=F5F5F5>';echo $ row [5];echo '</ td> <td width=9% bgcolor=F5F5F5>';echo $ row [6];echo '</ td> <td width=9% bgcolor=F5F5F5>';echo $ row [9];echo '</ td> </ tr>';)echo '</ table>';echo '</ body>';echo '</ html>';$ Conn = mssql_close ();?>[/color][color=#4A4A4A][/code][/color] Link to comment Share on other sites More sharing options...
Recommended Posts