![[Help]PHP who's online script](https://www.elitepvpers.com/forum/iconimages/shaiya-pserver-development/help-php-whos-online-script_ltr.gif){kind=small}
was wondering if anyone could spot it i may be just having a blonde moment but you never know
<?php
$server = '127.0.0.1';
$dbuser = 'shaiya';
$dbpass = 'shaiya123';
$count=1;
$count2=1;
$conn = mssql_connect($server, $dbuser, $dbpass)
or die("Couldn't connect to SQL Server on $myServer");
BY Level desc";
$query = "SELECT * FROM PS_GameData.dbo.Chars c inner join PS_UserData.dbo.Users_Master as um on um.UserUID = c.UserUID WHERE c.LoginStatus=1 and c.Del=0 AND um.Status =0 and Country=1";
$query2 = "SELECT * FROM PS_GameData.dbo.Chars c inner join PS_UserData.dbo.Users_Master as um on um.UserUID = c.UserUID WHERE c.LoginStatus=1 and c.Del=0 AND um.Status =0 and Country=2";
BY Level desc";
$result = mssql_query($query);
$result2 = mssql_query($query2);
echo "<html><head><STYLE TYPE=\"text/css\">
<!--
td { background:url(image.png) no-repeat; }
td.i0{ background-position: 0 0; width: 28px; height: 16px; }
td.i1{ background-position: 0 -26px; width: 28px; height: 16px; }
td.i2{ background-position: 0 -52px; width: 28px; height: 16px; }
td.i3{ background-position: 0 -78px; width: 29px; height: 16px; }
td.i4{ background-position: 0 -104px; width: 29px; height: 15px; }
td.i5{ background-position: 0 -129px; width: 28px; height: 18px; }
td.i6{ background-position: 0 -157px; width: 30px; height: 17px; }
td.i7{ background-position: 0 -184px; width: 29px; height: 17px; }
td.i8{ background-position: 0 -211px; width: 28px; height: 16px; }
td.i9{ background-position: 0 -237px; width: 28px; height: 18px; }
td.i10{ background-position: 0 -265px; width: 29px; height: 18px; }
td.i11{ background-position: 0 -293px; width: 29px; height: 24px; }
td.i12{ background-position: 0 -327px; width: 29px; height: 18px; }
td.i13{ background-position: 0 -355px; width: 29px; height: 18px; }
td.i14{ background-position: 0 -383px; width: 29px; height: 18px; }
td.i15{ background-position: 0 -411px; width: 29px; height: 18px; }
td.i16{ background-position: 0 -439px; width: 29px; height: 18px; }
td.i17{ background-position: 0 -467px; width: 24px; height: 24px; }
td.i18{ background-position: 0 -501px; width: 24px; height: 24px; }
td.i19{ background-position: 0 -535px; width: 24px; height: 24px; }
td.i20{ background-position: 0 -569px; width: 24px; height: 24px; }
td.i21{ background-position: 0 -603px; width: 24px; height: 24px; }
td.i22{ background-position: 0 -637px; width: 24px; height: 24px; }
</STYLE>
<title>Who online</title></head>";
echo "<body bgcolor=\"black\"><center>
<table cellspacing=10 cellpadding=0 border=0 bgcolor=\"black\"><tr><td><img
src=\"http://i113.photobucket.com/albums/n236/outc4st/aol.png\"></td><td></td><td><img
src=\"http://i113.photobucket.com/albums/n236/outc4st/uof.png\"></td></tr><td align=\"center\">
<table cellspacing=10 cellpadding=0 border=0 bgcolor=\"black\">
<td align=\"center\" style=\"color:#FC9700\" bgcolor=\"black\">Rank</td>
<td align=\"center\" style=\"color:#FC9700\" bgcolor=\"black\">Guild Name</td>
<td align=\"center\" style=\"color:#FC9700\" bgcolor=\"black\">GRB Point</td>";
while(($row2 = mssql_fetch_array($result2))||($count2 <= 10))
{
echo "<tr style=\"color:white\">";
echo "<td> $count2</td><td>". $row2[2] ."</td><td align=\"center\">". $row2[8] ."</td>";
$count2++;
}
echo "</td>";
echo "</table>
<td align=\"center\" width=\"200\"></td><td align=\"center\">
<table cellspacing=10 cellpadding=0 border=0 bgcolor=\"black\">
<td align=\"center\" style=\"color:#FC9700\" bgcolor=\"black\">Rank</td>
<td align=\"center\" style=\"color:#FC9700\" bgcolor=\"black\">Guild Name</td>
<td align=\"center\" style=\"color:#FC9700\" bgcolor=\"black\">GRB Point</td>";
while(($row = mssql_fetch_array($result))||($count <= 10))
{
echo "<tr style=\"color:white\">";
echo "<td> $count</td><td>". $row[2] ."</td><td align=\"center\">". $row[8] ."</td>";
$count++;
}
echo "</table>";
echo "</td>";
echo "</table>";
echo "</html>";
mssql_close($conn);
?>
$server = '127.0.0.1';
$dbuser = 'shaiya';
$dbpass = 'shaiya123';
$count=1;
$count2=1;
$conn = mssql_connect($server, $dbuser, $dbpass)
or die("Couldn't connect to SQL Server on $myServer");
BY Level desc";
$query = "SELECT * FROM PS_GameData.dbo.Chars c inner join PS_UserData.dbo.Users_Master as um on um.UserUID = c.UserUID WHERE c.LoginStatus=1 and c.Del=0 AND um.Status =0 and Country=1";
$query2 = "SELECT * FROM PS_GameData.dbo.Chars c inner join PS_UserData.dbo.Users_Master as um on um.UserUID = c.UserUID WHERE c.LoginStatus=1 and c.Del=0 AND um.Status =0 and Country=2";
BY Level desc";
$result = mssql_query($query);
$result2 = mssql_query($query2);
echo "<html><head><STYLE TYPE=\"text/css\">
<!--
td { background:url(image.png) no-repeat; }
td.i0{ background-position: 0 0; width: 28px; height: 16px; }
td.i1{ background-position: 0 -26px; width: 28px; height: 16px; }
td.i2{ background-position: 0 -52px; width: 28px; height: 16px; }
td.i3{ background-position: 0 -78px; width: 29px; height: 16px; }
td.i4{ background-position: 0 -104px; width: 29px; height: 15px; }
td.i5{ background-position: 0 -129px; width: 28px; height: 18px; }
td.i6{ background-position: 0 -157px; width: 30px; height: 17px; }
td.i7{ background-position: 0 -184px; width: 29px; height: 17px; }
td.i8{ background-position: 0 -211px; width: 28px; height: 16px; }
td.i9{ background-position: 0 -237px; width: 28px; height: 18px; }
td.i10{ background-position: 0 -265px; width: 29px; height: 18px; }
td.i11{ background-position: 0 -293px; width: 29px; height: 24px; }
td.i12{ background-position: 0 -327px; width: 29px; height: 18px; }
td.i13{ background-position: 0 -355px; width: 29px; height: 18px; }
td.i14{ background-position: 0 -383px; width: 29px; height: 18px; }
td.i15{ background-position: 0 -411px; width: 29px; height: 18px; }
td.i16{ background-position: 0 -439px; width: 29px; height: 18px; }
td.i17{ background-position: 0 -467px; width: 24px; height: 24px; }
td.i18{ background-position: 0 -501px; width: 24px; height: 24px; }
td.i19{ background-position: 0 -535px; width: 24px; height: 24px; }
td.i20{ background-position: 0 -569px; width: 24px; height: 24px; }
td.i21{ background-position: 0 -603px; width: 24px; height: 24px; }
td.i22{ background-position: 0 -637px; width: 24px; height: 24px; }
</STYLE>
<title>Who online</title></head>";
echo "<body bgcolor=\"black\"><center>
<table cellspacing=10 cellpadding=0 border=0 bgcolor=\"black\"><tr><td><img
src=\"http://i113.photobucket.com/albums/n236/outc4st/aol.png\"></td><td></td><td><img
src=\"http://i113.photobucket.com/albums/n236/outc4st/uof.png\"></td></tr><td align=\"center\">
<table cellspacing=10 cellpadding=0 border=0 bgcolor=\"black\">
<td align=\"center\" style=\"color:#FC9700\" bgcolor=\"black\">Rank</td>
<td align=\"center\" style=\"color:#FC9700\" bgcolor=\"black\">Guild Name</td>
<td align=\"center\" style=\"color:#FC9700\" bgcolor=\"black\">GRB Point</td>";
while(($row2 = mssql_fetch_array($result2))||($count2 <= 10))
{
echo "<tr style=\"color:white\">";
echo "<td> $count2</td><td>". $row2[2] ."</td><td align=\"center\">". $row2[8] ."</td>";
$count2++;
}
echo "</td>";
echo "</table>
<td align=\"center\" width=\"200\"></td><td align=\"center\">
<table cellspacing=10 cellpadding=0 border=0 bgcolor=\"black\">
<td align=\"center\" style=\"color:#FC9700\" bgcolor=\"black\">Rank</td>
<td align=\"center\" style=\"color:#FC9700\" bgcolor=\"black\">Guild Name</td>
<td align=\"center\" style=\"color:#FC9700\" bgcolor=\"black\">GRB Point</td>";
while(($row = mssql_fetch_array($result))||($count <= 10))
{
echo "<tr style=\"color:white\">";
echo "<td> $count</td><td>". $row[2] ."</td><td align=\"center\">". $row[8] ."</td>";
$count++;
}
echo "</table>";
echo "</td>";
echo "</table>";
echo "</html>";
mssql_close($conn);
?>
