[Only registered and activated users can see links. Click Here To Register...]
im using this script it dont show any players online.....i tried login with GM and normal player Characters it dun show up like the Picture above....only worked on Ranking-Guild-TopPKPVP and im using MSSQL 2014.....Any expert php or anyone have script work with mssql2014?Share please n thanks
PHP Code:
<?php
error_reporting(0);
ini_set("display_error", false);
include("config/mssql.conf.php");
echo "<center>Player Online List<br>";
echo "<table border='1'>
<tr>
<td align='center'>Char.Name</td>
<td align='center'>Level</td>
<td align='center'>Class</td>
</tr>";
$con = mssql_connect($mssql['host'],$mssql['user'],$mssql['pass']) or die("Verbinndung zum MSSQL Server fehlgeschlagen,bitte zu einem späteren zeitpunkt erneut probieren.");
$result1 = mssql_query("SELECT user_no FROM account.dbo.USER_PROFILE WHERE user_no = '$user_no'",$link);
$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 FROM character.user_character WHERE ,[login_flag] > ,[logout_time]",$link);
$row2 = mssql_fetch_row($result2);
if(!preg_match("/[[]]/i",$row2[0])) {
echo "<tr>
<td align='center'>".$row2[0]."</td>
<td align='center'>".$row2[1]."</td>
<td align='center'>".$classes[$row2[2]]."</td>
</tr>";
}
}
echo "</table></center>";
?>