Nope, made it myself
you can have the script, but iam not giving out support for it
learn php !
playersonline.php
PHP Code:
<?php
$mssql = array(
'host' => "localhost",
'user' => "sa",
'pass' => "YOURPASSWORD"
);
echo "<center>Player Online List<br><br>";
echo "<table border='0'>
<tr>
<td align='center'>------ Character Name ------</td>
<td align='center'>---- Level ----</td>
<td align='center'>-------- Class --------</td>
<td align='center'>------ Map ------</td>
<td align='center'>------ Pos. X ------</td>
<td align='center'>------ Pos. Y ------</td>
<td align='center'>------ Reborn ------</td>
<td align='center'>---------- Login ----------</td>
</tr>";
$con = mssql_connect($mssql['host'],$mssql['user'],$mssql['pass']) or die($language['mssql_e1']);
$result1 = mssql_query("SELECT user_no FROM account.dbo.USER_PROFILE WHERE login_flag = '1100'",$con);
$classes = array('0' => "Azure Knight", '1' => "Segita Hunter", '2' => "Incar Magician", '3' => "Vicious Summoner", '4' => "Segnale", '5' => "Bagi Warrior");
while($row1 = mssql_fetch_row($result1)) {
$result2 = mssql_query("SELECT character_name,wLevel,byPCClass,wMapIndex,wPosX,wPosY,Reborn,login_time FROM character.dbo.user_character WHERE user_no = '".$row1[0]."' ORDER by login_time DESC",$con);
$row2 = mssql_fetch_row($result2);
echo "<tr>
<td align='left'>".$row2[0]."</td>
<td align='center'>".$row2[1]."</td>
<td align='left'>".$classes[$row2[2]]."</td>
<td align='center'>".$row2[3]."</td>
<td align='center'>".$row2[4]."</td>
<td align='center'>".$row2[5]."</td>
<td align='center'>".$row2[6]."</td>
<td align='lect'>".$row2[7]."</td>
</tr>";
}
echo "</table></center>";
?>
?
