// hostname or ip of server
$servername='localhost';
// username and password to log onto db server
$dbusername='root';
$dbpassword='csqx795y';
// name of database
$dbname='aseco';
$pos="1";
$colors= new tmfcolorparser;
////////////// Do not edit below/////////
connecttodb($servername,$dbname,$dbusername,$dbpassword);
function connecttodb($servername,$dbname,$dbuser,$dbpassword)
{
global $link;
$link=mysql_connect ("$servername","$dbuser","$dbpassword");
if(!$link){die("Could not connect to MySQL");}
mysql_select_db("$dbname",$link) or die ("could not open db".mysql_error());
}
?>
Rank
Player Name
Score
// get and print result
$query="select * from tmos_scores where envirid=\"a\" ORDER BY score DESC";
$result = mysql_query($query);
//sort($result);
echo mysql_error();
while($nt=mysql_fetch_array($result))
if($pos<21)
{
$queryad = "SELECT player FROM tmos_players where playerid=\"$nt[ownerid]\"";
$resultad = mysql_query ($queryad);
$rowad = mysql_fetch_array($resultad);
$player = $rowad[0];
$PlayerLogin = $colors->toHTML($player);
$PlayerLogin = str_replace('"', '', $PlayerLogin);
//$PlayerLogin = str_replace(',', '', $PlayerLogin);
//$PlayerLogin = str_replace('=', '', $PlayerLogin);
$format ="