- Katılım
- 26 Eyl 2021
- Mesajlar
- 396
- Konu Çözümleri
- 4
- Tepki puanı
- 23
- Puanları
- 48
Merhaba değerli forum üyeleri.
Clan sıralamasında herhangi bir clana tıkladığımda hep 1. Clanı gösteriyor.
Bunu nasıl düzeltebilirim?
Denemek için:
ClanRankings.php
Clan sıralamasında herhangi bir clana tıkladığımda hep 1. Clanı gösteriyor.
Bunu nasıl düzeltebilirim?
Denemek için:
Ziyaretçiler için gizlenmiş link,görmek için
Giriş yap veya üye ol.
ClanRankings.php
PHP:
<?php
$pageTitle = "Klan Sıralaması";
?>
<title><?=$ServerName;?> ~ <?=$pageTitle;?></title>
<div id="cover"></div>
<link rel="stylesheet" type="text/css" href="<?=$path;?>css/sub.css" />
<section id="CNT">
<!-- [Start] Ranking Area -->
<article id="Guide">
<h2><?=$pageTitle;?> </h2>
<!--[Start]Race and Server Select Options-->
<div class="select_server">
<form name="serverForm" style="display: inline-block;">Sunucu:
<select id="server" class="server" name="server">
<option value="1" selected=""><?=$ServerName;?></option>
</select>
<span class="select_arrow"></span>
</form>
</div>
<div class="top_ranking unselected">
<?php
$i = 0;
$rank = "SELECT TOP 3 k.Nation,k.IDNum, k.IDName, k.Members, k.Chief, k.ViceChief_1, k.ViceChief_2, k.ViceChief_3, SUM(u.Loyalty) FROM knights k, user_knightdata ku, userdata u WHERE k.IDNum = ku.sClanID AND ku.strUserID = u.strUserID GROUP BY k.Nation,k.IDNum,k.IDName,k.Members,k.Chief,k.ViceChief_1,k.ViceChief_2,k.ViceChief_3 ORDER BY SUM(u.Loyalty) DESC";
$genel = $dbo->doquery($rank);
while($dbo->row($genel)):
$strUserID = $dbo->result('IDName');
$Loyalty = $dbo->result(9);
$i++;
?>
<dl class="top_ranking_no<?=$i;?>">
<dt><?=$strUserID;?></dt>
<dd>Puan: <?=number_format($Loyalty);?></dd>
</dl>
<?php endwhile;?>
</div>
<!--[End]Race and Server Select Options-->
<script>
function onSelectChange(){
document.getElementById('raceForm').submit();
}
</script>
<!--[Start]Top Ranking No.1,2,3-->
<table id="tableRanking" class="ranking">
<thead>
<tr>
<th>#</th>
<th>Klan Adı</th>
<th>Klan Lideri</th>
<th>Üyeler</th>
<th>Puan</th>
<th>Puan (Bağış)</th>
</tr>
</thead>
<tbody>
<?php
$i = 0;
/* top 100 clan*/
$top100clan = $dbo->doquery("SELECT TOP 100 k.Nation,k.IDNum, k.IDName, k.Members, k.Chief, k.Points, k.Flag ,k.ClanPointFund FROM knights k, userdata u WHERE k.Chief = u.strUserID GROUP BY k.Nation,k.IDNum, k.IDName, k.Members, k.Chief, k.Points, k.Flag ,k.ClanPointFund ORDER BY SUM(k.Points) DESC");
while($dbo->row($top100clan)):
$bagis = $dbo->result('ClanPointFund');
$grades = $dbo->result('Points');
$flag = $dbo->result('Flag');
/*Training Grade*/
if($grades <= 73999 and $dbo->result('Flag')< 3):
$grade = 5 ;
elseif($grades <= 143999 and $dbo->result('Flag')< 3):
$grade = 4 ;
elseif($grades <= 359000 and $dbo->result('Flag')< 3):
$grade = 3 ;
elseif($grades <= 719999 and $dbo->result('Flag')< 3):
$grade = 2 ;
elseif($grades >= 720000 and $dbo->result('Flag')< 3):
$grade = 1 ;
/*Accredited Grade*/
elseif($dbo->result('Flag') == 3):
$grade = 6 ;
elseif($dbo->result('Flag') == 4):
$grade = 7 ;
elseif($dbo->result('Flag') == 5):
$grade = 8 ;
elseif($dbo->result('Flag') == 6):
$grade = 9 ;
elseif($dbo->result('Flag') == 7):
$grade = 10 ;
/*Royal Grade*/
elseif($dbo->result('Flag') == 8):
$grade = 11 ;
elseif($dbo->result('Flag') == 9):
$grade = 12 ;
elseif($dbo->result('Flag') == 10):
$grade = 13 ;
elseif($dbo->result('Flag') == 11):
$grade = 14 ;
elseif($dbo->result('Flag') == 12):
$grade = 15 ;
endif;
$nation = $dbo->result('Nation');
$clanname = $dbo->result('IDName');
$chief = $dbo->result('Chief');
$members = $dbo->result('Members');
?>
<tr>
<td style="text-align:center;">#<?=$i;?> <span class="nation n<?=$nation;?>"></span><span class="grade g<?=$grade;?>"></span></td>
<td><a href="<?=$base_url;?>ClanProfile/<?=trim(iconv('ISO-8859-9', 'UTF-8',$dbo->result('IDName')));?>"><?=$clanname;?></a></td>
<td><a href="<?=$base_url;?>UserProfile/<?=trim(iconv('ISO-8859-9', 'UTF-8',$dbo->result('Chief')));?>"><?=$chief;?></a></td>
<td><?=$members;?> / 50</td>
<td><?=number_format($grades);?></td>
<td><?=number_format($bagis);?></td>
</tr>
<?php endwhile;?>
</tbody>
</table>
<!--[End]Ranking list-->
</article>
<!-- [End] Ranking Area -->
</section>
