[Help] Rankings дава всичко Offline..

[Holder]

[Help] Rankings дава всичко Offline.. докато има Online играчи..

Предполагам търси дали играча е на линия в грешна таблица и за това излизат оффлайн ама не му разбирам толкова.. Дори и играча да е на линия го дава като Оффлайн.

<? if (eregi("modules/", $_SERVER['SCRIPT_NAME'])) { header("Location: ../?op=home"); } ?>

<?
require("config.php");
include("Config.php");
include_once("modules/ranking_menu.php"); 
error_reporting (E_ALL ^ E_NOTICE);
$query_allcharacters = "Select TOP 99  Name,Class,cLevel,Resets,LevelUpPoint,Experience,Strength,Dexterity,Vitality,Energy,Life,MaxLife,Mana,MaxMana,MapNumber,Money,MapPosX,MapPosY,PkCount,PkLevel,PkTime,AccountID from Character order by resets desc ,clevel desc";
$result = mssql_query($query_allcharacters);

echo '<br>
<table width="520" class="sort-table" border="0" cellspacing="1" cellpadding="0" align="center">           
<thead>
</thead></table><br>
<table border="0" width="480" cellpadding="0" cellspacing="1" align="center">
<tr>
<td align="center">
<table border="0" class=sort-table width="480" cellpadding="0" cellspacing="1" align="center">
<thead>
<tr>
<td align="center" width=20><font size=1 color=white><b>&nbsp;ID</font></td>
<td align="center" width=75><font size=1 color=white><b>&nbsp;Name</font></td>
<td align="center" width=30><font size=1 color=white><b>&nbsp;Level</font></td>
<td align="center" width=30><font size=1 color=#ff0000><b>&nbsp;Reset</font></td>
<td align="center" width=100><font size=1 color=white><b>&nbsp;Map</font></td>
<td align="center" width=120><font size=1 color=white><b>&nbsp;Class</font></td>
<td align="center" width=35><font size=1 color=white><b>&nbsp;Status</font></td>
</tr></thead></table></td></tr>';

for($i=0;$i < mssql_num_rows($result);++$i)
{
$row = mssql_fetch_row($result);

$rank = $i+1;

$status_check="Select ConnectStat from MEMB_STAT where memb___id='$row[5]'";
$status_reults = mssql_query($status_check);
$status = mssql_fetch_row($status_reults);

if($status[0] == 0){ $status[0] ='<font size=1 color=#9d0a0e><b>Off</b></a></span></td>';
}
if($status[0] == 1){ $status[0] ='<font size=1 color=green><b>On</b></a></span></td>';
}
//Class
if ($row['1'] == 0) { $row[1] = "Dark Wizard"; }
if ($row['1'] == 1) { $row[1] = "Soul Master"; }
if ($row['1'] == 2) { $row[1] = "Grand Master"; }
if ($row['1'] == 16) { $row[1] = "Dark Knight"; }
if ($row['1'] == 17) { $row[1] = "Blade Knight"; }
if ($row['1'] == 18) { $row[1] = "Blade Master"; }
if ($row['1'] == 32) { $row[1] = "Elf"; }
if ($row['1'] == 33) { $row[1] = "Muse Elf"; }
if ($row['1'] == 34) { $row[1] = "High Elf"; }
if ($row['1'] == 48) { $row[1] = "Magic Gladiator"; }
if ($row['1'] == 50) { $row[1] = "Duel Master"; }
if ($row['1'] == 64) { $row[1] = "Dark Lord"; }
if ($row['1'] == 66) { $row[1] = "Lord Emperor"; }
if ($row['1'] == 80) { $row[1] = "Summoner"; }
if ($row['1'] == 81) { $row[1] = "Bloody Summoner"; }
if ($row['1'] == 82) { $row[1] = "Dimension Master"; }
if ($row['1'] == 83) { $row[1] = "Dimension Master"; }

//Location
if ($row['14'] == 0) { $row[14] = 'Lorencia'; }
if ($row['14'] == 1) { $row[14] = 'Dungeon'; }
if ($row['14'] == 2) { $row[14] = 'Davias'; }
if ($row['14'] == 3) { $row[14] = 'Noria'; }
if ($row['14'] == 4) { $row[14] = 'Lost tower'; }
if ($row['14'] == 5) { $row[14] = 'Lorencia'; }
if ($row['14'] == 6) { $row[14] = 'Arena'; }
if ($row['14'] == 7) { $row[14] = 'Atlans'; }
if ($row['14'] == 8) { $row[14] = 'Tarkan'; }
if ($row['14'] == 9) { $row[14] = 'Devil Square'; }
if ($row['14'] == 32) { $row[14] = 'Devil Square'; }
if ($row['14'] == 10) { $row[14] = 'Icarus'; }
if ($row['14'] == 11) { $row[14] = 'Blood castle 1'; }
if ($row['14'] == 12) { $row[14] = 'Blood castle 2'; }
if ($row['14'] == 13) { $row[14] = 'Blood castle 3'; }
if ($row['14'] == 14) { $row[14] = 'Blood castle 4'; }
if ($row['14'] == 15) { $row[14] = 'Blood castle 5'; }
if ($row['14'] == 16) { $row[14] = 'Blood castle 6'; }
if ($row['14'] == 17) { $row[14] = 'Blood castle 7'; }
if ($row['14'] == 52) { $row[14] = 'Blood castle 8'; }
if ($row['14'] == 18) { $row[14] = 'Chaos castle 1'; }
if ($row['14'] == 19) { $row[14] = 'Chaos castle 2'; }
if ($row['14'] == 20) { $row[14] = 'Chaos castle 3'; }
if ($row['14'] == 21) { $row[14] = 'Chaos castle 4'; }
if ($row['14'] == 22) { $row[14] = 'Chaos castle 5'; }
if ($row['14'] == 23) { $row[14] = 'Chaos castle 6'; }
if ($row['14'] == 53) { $row[14] = 'Chaos castle 7'; }
if ($row['14'] == 24) { $row[14] = 'Kalima 1'; }
if ($row['14'] == 25) { $row[14] = 'Kalima 2'; }
if ($row['14'] == 26) { $row[14] = 'Kalima 3'; }
if ($row['14'] == 27) { $row[14] = 'Kalima 4'; }
if ($row['14'] == 28) { $row[14] = 'Kalima 5'; }
if ($row['14'] == 29) { $row[14] = 'Kalima 6'; }
if ($row['14'] == 36) { $row[14] = 'Kalima 7'; }
if ($row['14'] == 30) { $row[14] = 'Valery Of Loren'; }
if ($row['14'] == 55) { $row[14] = 'Valery Of Loren'; }
if ($row['14'] == 31) { $row[14] = 'Land of Trials'; }
if ($row['14'] == 54) { $row[14] = 'Aida'; }
if ($row['14'] == 33) { $row[14] = 'Aida 2'; }
if ($row['14'] == 34) { $row[14] = 'Cry Wolf'; }
if ($row['14'] == 35) { $row[14] = 'Silent Map'; }
if ($row['14'] == 36) { $row[14] = 'Lost Kalima'; }
if ($row['14'] == 37) { $row[14] = 'Kanturu Ruin'; }
if ($row['14'] == 38) { $row[14] = 'Kanturu Remain'; }
if ($row['14'] == 39) { $row[14] = 'Kanturu Tower'; }
if ($row['14'] == 41) { $row[14] = 'Barracks'; }
if ($row['14'] == 42) { $row[14] = 'Refuge'; }
if ($row['14'] == 45) { $row[14] = 'Illusion Temple 1'; }
if ($row['14'] == 46) { $row[14] = 'Illusion Temple 2'; }
if ($row['14'] == 47) { $row[14] = 'Illusion Temple 3'; }
if ($row['14'] == 48) { $row[14] = 'Illusion Temple 4'; }
if ($row['14'] == 49) { $row[14] = 'Illusion Temple 5'; }
if ($row['14'] == 50) { $row[14] = 'Illusion Temple 6'; }
if ($row['14'] == 51) { $row[14] = 'Elbeland'; }

echo "
<table border=0 width=480 cellpadding=1 cellspacing=0 align=center>
<tr><td align=center>
<table border=0 width=480 cellpadding=1 cellspacing=1 align=center>
<thead>
<tr>
<td align=center class=bars width='20'><font size=1 color=#FFFFFF>&nbsp;$rank.</center></b></font></td>
<td align=center class=bars width='75'><font size=1 color=#FFFFFF><b>&nbsp;$row[0]</center></b></font></a></div></td>
<td align=center class=bars width='30'><font size=1 color=#FFFFFF>&nbsp;$row[2]</center></b></td>
<td align=center class=bars width='30'><font size=1 color=#ff0000>&nbsp;$row[3]</font></center></b></td>
<td align=center class=bars width='100'><font size=1 color=#005825>&nbsp;$row[14]</b></td>
<td align=center class=bars width='120'><font size=1 color=#0076a3>&nbsp;$row[1]</center></td>
<td align=center class=bars width=35><font size=1 >&nbsp;$status[0]</center></b></td>
</tr></table></td></tr>
";

}
?></table>

 

[Holder]

Up

 

[oveRLuckEd]

Ми като селектираш Experience и после искаш да го ползваш за акаунт, какво очакваш И не виждам що си изброил всички полета като никъде не ги използваш, също така може да ги селектираш просто с *, от края на селекцията махни AccountID и го сложи на мястото на Experience.

 

[Holder]

Хаха мс бате , намерих го така и си работи а щом работи не пипам, че като пипам за красота и има навика да спира да работи