PHPXRef 0.7 : NEABExplorer : /home/top_online.php source [ Index ] PHP Cross Reference of NEABExplorer if (gwGetCookie('xrefnav')=='off') document.write('[ Show Explorer ]'); else document.write('[ Hide Explorer ]'); [ Show Explorer ] [ Hide Navbar ] titleBody[close] /home/ -> top_online.php (source) [Summary view] [Print] [Text view] 1 <?PHP 2 /** 3 * Shows the top online players. 4 */ 5 6 $limit=50; 7 8 echo "<CENTER><TABLE BORDER=0 CELLSPACING=0 CELLPADDING=1 STYLE='border-style: solid;border-color: #3B4A78;border-width: 1px;' WIDTH=400>\n"; 9 echo "<TR><TH COLSPAN=4 BGCOLOR=#3B4A78><B><FONT COLOR=#FFFFFF>Top Online Players</FONT></B></TH></TR>\n"; 10 echo "<TR>\n"; 11 echo "<TD BGCOLOR=#4C5E98><B><FONT COLOR=#FFFFFF>&nbsp;&nbsp;&nbsp;&nbsp;Name</FONT></B></TD>\n"; 12 echo "<TD BGCOLOR=#4C5E98 ALIGN=RIGHT><B><FONT COLOR=#FFFFFF>Level</FONT></B></TD>\n"; 13 echo "<TD BGCOLOR=#4C5E98><B><FONT COLOR=#FFFFFF>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Class</FONT></B></TD>\n"; 14 echo "<TD BGCOLOR=#4C5E98><B><FONT COLOR=#FFFFFF>Island Owned</FONT></B></TD>\n"; 15 echo "</TR>\n"; 16 17 $sql="SELECT PLAYER.USERNAME,PLAYER.LEVEL,PLAYER.SCHOOL,LOCATIONS.NAME 18 FROM PLAYER LEFT JOIN ISLAND_STATUS ON (ISLAND_STATUS.USERID=PLAYER.ID AND ISLAND_STATUS.STATUS='C') 19 LEFT JOIN LOCATIONS ON (ISLAND_STATUS.LOCATION=LOCATIONS.ID) 20 WHERE UNIX_TIMESTAMP(LASTACTION) > UNIX_TIMESTAMP(CURRENT_TIMESTAMP)-15*60 21 AND PLAYER.AUTHORIZED = 'Y' ORDER BY EXPERIENCE DESC"; 22 23 $class=array("F"=>"Fire Mage","I"=>"Ice Mage","E"=>"Earth Mage","A"=>"Air Mage","V"=>"Vampire Mage","B"=>"Vandale Warrior","C"=>"Cavaliar Warrior","M"=>"Marauder Warrior","R"=>"Rogue Warrior",""=>"Adventurer"); 24 25 $r=$db->Execute($sql); 26 $l=1; 27 while(!$r->EOF) 28 { 29 if(($l%2) == 0) 30 echo "<TR BGCOLOR=#5F74B6>\n"; 31 else 32 echo "<TR>"; 33 echo "<TD>&nbsp;".$r->fields[0]."</TD>"; 34 echo "<TD ALIGN=RIGHT>&nbsp;".number_format($r->fields[1]+0, 0, ".", "'")."&nbsp;</TD>\n"; 35 echo "<TD>&nbsp;".$class[$r->fields[2]]."</TD>\n"; 36 echo "<TD>&nbsp;".remove_tags($r->fields[3])."</TD></TR>\n"; 37 $r->MoveNext(); 38 $l++; 39 } 40 $r->Close(); 41 42 echo "</TABLE></CENTER>\n"; 43 ?> FUNC_DATA={ 'movenext': ['movenext', '', [['libs','db_conn_5.php',89],['libs','db_conn_4.php',89]], 104], 'close': ['close', '', [['libs','db_conn_5.php',35],['libs','db_conn_5.php',87],['libs','db_conn_4.php',35],['libs','db_conn_4.php',87]], 380], 'remove_tags': ['remove_tags', 'Removes the tags from the string. ', [['libs','misc_util.php',1241]], 4], 'execute': ['execute', '', [['libs','db_conn_5.php',37],['libs','db_conn_4.php',37]], 652], 'number_format': ['number_format', '', [], 13]}; CLASS_DATA={ }; CONST_DATA={ }; titleDescriptionBody titleDescriptionBody titleDescriptionBody titleBody Generated: Sun Jul 8 18:11:25 2007 Cross-referenced by PHPXref 0.7