Any expert PHP still around here????

06/06/2020 02:08 NeedHelpAti#1
[Only registered and activated users can see links. Click Here To Register...]
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
06/06/2020 02:37 Farius~#2
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.

[Only registered and activated users can see links. Click Here To Register...]
06/06/2020 11:27 NeedHelpAti#3
searching and watching youtube cant even know what all these php language XD....Your look so pro share me a simple one thx u .....
06/06/2020 14:17 [DEV]Dekaron#4
<?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.

[Only registered and activated users can see links. Click Here To Register...][Only registered and activated users can see links. Click Here To Register...]
06/10/2020 06:27 delkiller#5
Does anyone own php code lv rankings ? :(