Any expert PHP still around here????

[NeedHelpAti]

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>";

?>

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

[Farius~]

It is very easy to do, just add the query to the column you want to add.

I have made a simple ranking for my old server and for dekaron exilium

Just do a little research on how to make queries in the database, sql server and the rest will be very easy, because the php is already done, you just have to add the extra.

[NeedHelpAti]

searching and watching youtube cant even know what all these php language XD....Your look so pro share me a simple one thx u .....

[[DEV]Dekaron]

<?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>";

?>

how this [login_flag] can recognize that some user are online if missing part of code [login_flag = y] or [login_flag = 20] login flag should read what is in this column.

[delkiller]

Does anyone own php code lv rankings ?