felipecoder
09/06/2017, 05:34 PM
Bom vi um membro pedindo uma query simples então decidi postar a minha
<table class="table table-striped mt-20"> <thead>
<tr>
<th>#</th>
<th width="30%">Personagem</th>
<th>Classe</th>
<th>Guild</th>
<th>Level</th>
<th>Resets</th>
<th>Tempo ON</th>
</tr>
</thead>
<tbody>
<?
$db->Query("SELECT TOP 50 Name,ResetCount,cLevel,OnlineTime,AccountID,Class FROM Character ORDER BY ResetCount DESC");
$NumRows2= $db->NumRows();
for($i=0;$i < $NumRows2;++$i){
$row = $db->GetRow();
$namez=$row['Name'];
$resets=$row['ResetCount'];
$level=$row['cLevel'];
$horas=floor($row['OnlineTime'] / 60);
$minutos=floor($row['OnlineTime'] - ($horas * 60));
$rst[3]="".$horas."h e ".$minutos."min";
$LoginChar=$row['AccountID'];
$db2->Query("SELECT * FROM GuildMember WHERE Name ='$namez'");
$row2=$db2->GetRow();
$NumRows=$db2->NumRows();
$db3->Query("SELECT TOP 1 * FROM MEMB_INFO WHERE memb___id ='".$LoginChar."'");
$row3=$db3->GetRow();
if($NumRows == 0){
$guildname="Sem Guild";
} else {
$guildname=$row2['G_Name'];
}
if($row['Class'] == 0){$classe="Dark Wizard";}
elseif($row['Class'] == 1){$classe="Soul Master";}
elseif($row['Class'] == 2){$classe="Grand Master";}
elseif($row['Class'] == 3){$classe="Grand Master";}
elseif($row['Class'] == 16){$classe="Dark Knight";}
elseif($row['Class'] == 17){$classe="Blade Knight";}
elseif($row['Class'] == 18){$classe="Blade Master";}
elseif($row['Class'] == 19){$classe="Blade Master";}
elseif($row['Class'] == 32){$classe="Fairy Elf";}
elseif($row['Class'] == 33){$classe="Muse Elf";}
elseif($row['Class'] == 34){$classe="High Elf";}
elseif($row['Class'] == 35){$classe="High Elf";}
elseif($row['Class'] == 48){$classe="Magic Gladiator";}
elseif($row['Class'] == 49){$classe="Duel Master";}
elseif($row['Class'] == 50){$classe="Duel Master";}
elseif($row['Class'] == 64){$classe="Dark Lord";}
elseif($row['Class'] == 65){$classe="Lord Emperor";}
elseif($row['Class'] == 66){$classe="Lord Emperor";}
elseif($row['Class'] == 80){$classe="Summoner";}
elseif($row['Class'] == 81){$classe="Blood Summoner";}
elseif($row['Class'] == 82){$classe="Dimension Master";}
elseif($row['Class'] == 83){$classe="Dimension Master";}
elseif($row['Class'] == 96){$classe="Rage Fighter";}
elseif($row['Class'] == 97){$classe="First Master";}
elseif($row['Class'] == 98){$classe="First Master";}
$db4->Query("SELECT AccountLevel FROM MEMB_INFO WHERE memb___id ='".$LoginChar."'");
$row4=$db4->GetRow();
if($row4['AccountLevel']==0){$vip="";}
elseif($row4['AccountLevel']==1){$vip="<span style='background-color: #235782; margin-left: 45px;' class='badge badge-float'>".$VIP_1_Name."</span>";}
elseif($row4['AccountLevel']==2){$vip="<span style='background-color: #235782; margin-left: 45px;' class='badge badge-float'>".$VIP_2_Name."</span>";}
elseif($row4['AccountLevel']==3){$vip="<span style='background-color: #235782; margin-left: 45px;' class='badge badge-float'>".$VIP_3_Name."</span>";}
$db5->Query("SELECT TOP 1 * FROM MEMB_STAT WHERE memb___id ='".$LoginChar."'");
$row5=$db5->GetRow();
if ($row5['ConnectStat']==0) { $online="";}
elseif ($row5['ConnectStat']==1) {$online="<span style='background-color: #1ca500; margin-left: 2px;' class='badge badge-float'>Online</span>";}
$rank = $i+1;
?>
<tr>
<td scope="row"><?=$rank?></td>
<td><?=$namez;?><?=$vip?><?=$online?></td>
<td><?=$classe?></td>
<td><?=$guildname?></td>
<td><?=$level;?></td>
<td><?=$resets;?></td>
<td><?=$rst[3];?> h</td>
</tr>
<?
}
?>
</tbody>
</table>
Imagem de Preview
[Only registered and activated users can see links]
<table class="table table-striped mt-20"> <thead>
<tr>
<th>#</th>
<th width="30%">Personagem</th>
<th>Classe</th>
<th>Guild</th>
<th>Level</th>
<th>Resets</th>
<th>Tempo ON</th>
</tr>
</thead>
<tbody>
<?
$db->Query("SELECT TOP 50 Name,ResetCount,cLevel,OnlineTime,AccountID,Class FROM Character ORDER BY ResetCount DESC");
$NumRows2= $db->NumRows();
for($i=0;$i < $NumRows2;++$i){
$row = $db->GetRow();
$namez=$row['Name'];
$resets=$row['ResetCount'];
$level=$row['cLevel'];
$horas=floor($row['OnlineTime'] / 60);
$minutos=floor($row['OnlineTime'] - ($horas * 60));
$rst[3]="".$horas."h e ".$minutos."min";
$LoginChar=$row['AccountID'];
$db2->Query("SELECT * FROM GuildMember WHERE Name ='$namez'");
$row2=$db2->GetRow();
$NumRows=$db2->NumRows();
$db3->Query("SELECT TOP 1 * FROM MEMB_INFO WHERE memb___id ='".$LoginChar."'");
$row3=$db3->GetRow();
if($NumRows == 0){
$guildname="Sem Guild";
} else {
$guildname=$row2['G_Name'];
}
if($row['Class'] == 0){$classe="Dark Wizard";}
elseif($row['Class'] == 1){$classe="Soul Master";}
elseif($row['Class'] == 2){$classe="Grand Master";}
elseif($row['Class'] == 3){$classe="Grand Master";}
elseif($row['Class'] == 16){$classe="Dark Knight";}
elseif($row['Class'] == 17){$classe="Blade Knight";}
elseif($row['Class'] == 18){$classe="Blade Master";}
elseif($row['Class'] == 19){$classe="Blade Master";}
elseif($row['Class'] == 32){$classe="Fairy Elf";}
elseif($row['Class'] == 33){$classe="Muse Elf";}
elseif($row['Class'] == 34){$classe="High Elf";}
elseif($row['Class'] == 35){$classe="High Elf";}
elseif($row['Class'] == 48){$classe="Magic Gladiator";}
elseif($row['Class'] == 49){$classe="Duel Master";}
elseif($row['Class'] == 50){$classe="Duel Master";}
elseif($row['Class'] == 64){$classe="Dark Lord";}
elseif($row['Class'] == 65){$classe="Lord Emperor";}
elseif($row['Class'] == 66){$classe="Lord Emperor";}
elseif($row['Class'] == 80){$classe="Summoner";}
elseif($row['Class'] == 81){$classe="Blood Summoner";}
elseif($row['Class'] == 82){$classe="Dimension Master";}
elseif($row['Class'] == 83){$classe="Dimension Master";}
elseif($row['Class'] == 96){$classe="Rage Fighter";}
elseif($row['Class'] == 97){$classe="First Master";}
elseif($row['Class'] == 98){$classe="First Master";}
$db4->Query("SELECT AccountLevel FROM MEMB_INFO WHERE memb___id ='".$LoginChar."'");
$row4=$db4->GetRow();
if($row4['AccountLevel']==0){$vip="";}
elseif($row4['AccountLevel']==1){$vip="<span style='background-color: #235782; margin-left: 45px;' class='badge badge-float'>".$VIP_1_Name."</span>";}
elseif($row4['AccountLevel']==2){$vip="<span style='background-color: #235782; margin-left: 45px;' class='badge badge-float'>".$VIP_2_Name."</span>";}
elseif($row4['AccountLevel']==3){$vip="<span style='background-color: #235782; margin-left: 45px;' class='badge badge-float'>".$VIP_3_Name."</span>";}
$db5->Query("SELECT TOP 1 * FROM MEMB_STAT WHERE memb___id ='".$LoginChar."'");
$row5=$db5->GetRow();
if ($row5['ConnectStat']==0) { $online="";}
elseif ($row5['ConnectStat']==1) {$online="<span style='background-color: #1ca500; margin-left: 2px;' class='badge badge-float'>Online</span>";}
$rank = $i+1;
?>
<tr>
<td scope="row"><?=$rank?></td>
<td><?=$namez;?><?=$vip?><?=$online?></td>
<td><?=$classe?></td>
<td><?=$guildname?></td>
<td><?=$level;?></td>
<td><?=$resets;?></td>
<td><?=$rst[3];?> h</td>
</tr>
<?
}
?>
</tbody>
</table>
Imagem de Preview
[Only registered and activated users can see links]