hallo com habe vergeblichst versucht das script umzuschreiben so das anstadt exp die online zeit abgelesen wird beckomme staendig i welche errors
hoffe es schreibt mir ein kenner kurz um so das das ranking von der online zeit
erstaelt wird und nicht laut dem exp
mfg
hoffe es schreibt mir ein kenner kurz um so das das ranking von der online zeit
erstaelt wird und nicht laut dem exp
mfg
PHP Code:
<?PHP
$CPSeite = 25;
$markierteZeile=0;
if(isset($_GET['p'])) {
if(!checkInt($_GET['p']) || !($_GET['p']>0)) $aSeite = 1;
else $aSeite = $_GET['p'];
}
else { $aSeite = 1; }
if(isset($_POST['suche']) && $_POST['suche']=='Αναζήτηση') {
if(!empty($_POST['charakter'])) {
$sqlCmd="SELECT id, name, level, exp, empire, guild_name, rang
FROM (
SELECT id, name, level, exp, empire, guild_name, @num := @num +1 AS rang
FROM (
SELECT player.id, player.name, player.level, player.exp, player_index.empire, guild.name AS guild_name, @num :=0
FROM player.player
LEFT JOIN player.player_index ON player_index.id = player.account_id
LEFT JOIN player.guild_member ON guild_member.pid = player.id
LEFT JOIN player.guild ON guild.id = guild_member.guild_id
INNER JOIN account.account ON account.id=player.account_id
WHERE player.name NOT LIKE '[%]%' AND account.status!='BLOCK'
ORDER BY player.level DESC , player.exp DESC
) AS t1
) AS t2
WHERE name = '".mysql_real_escape_string($_POST['charakter'])."' LIMIT 1";
$sqlQry=mysql_query($sqlCmd,$sqlServ);
if(mysql_num_rows($sqlQry)>0) {
$getRang = mysql_fetch_object($sqlQry);
$aSeite = ceil($getRang->rang/$CPSeite);
$markierteZeile = $getRang->rang;
}
}
}
$sqlCmd = "SELECT COUNT(*) as summeChars
FROM player.player
LEFT JOIN player.player_index
ON player_index.id=player.account_id
LEFT JOIN player.guild_member
ON guild_member.pid=player.id
LEFT JOIN player.guild
ON guild.id=guild_member.guild_id
INNER JOIN account.account
ON account.id=player.account_id
WHERE player.name NOT LIKE '[%]%' AND account.status!='BLOCK'
ORDER BY player.level DESC, player.exp DESC";
$sqlQry = mysql_query($sqlCmd,$sqlServ);
$getSum = mysql_fetch_object($sqlQry);
$cSeite = calcPages($getSum->summeChars,$aSeite,$CPSeite);
?>
<div id="con-top">Κατάταξη χαρακτήρων</div>
<div id="con-mid">
<div class="center">
<form name="form">
<select name="link" SIZE="1" onChange="window.location.href = document.form.link.options[document.form.link.selectedIndex].value;">
<option selected value="#">Κατάταξη χαρακτήρων</option>
<option value="?s=ranking_gilden">Κατάταξη Συντεχνιών</option>
</select>
</form>
<br/>
<form action="?s=ranking_chars" method="POST">
<b>Suche:</b>
<input type="text" name="charakter" maxlength="20" size="20" class="txt"/>
<input type="submit" name="suche" value="Αναζήτηση" maxlength="20" size="20" class="button"/>
</form>
</div>
<table>
<tr>
<th class="topLine">Βαθμ</th>
<th class="topLine">Όνομα</th>
<th class="topLine">Επίπεδο</th>
<th class="topLine">EXP</th>
<th class="topLine">Συντεχνία</th>
<th class="topLine">Βασίλειο</th>
</tr>
<?PHP
$sqlCmd = "SELECT player.id,player.name,player.level,player.exp,player_index.empire,guild.name AS guild_name,guild.id AS guild_id
FROM player.player
LEFT JOIN player.player_index
ON player_index.id=player.account_id
LEFT JOIN player.guild_member
ON guild_member.pid=player.id
LEFT JOIN player.guild
ON guild.id=guild_member.guild_id
INNER JOIN account.account
ON account.id=player.account_id
WHERE player.name NOT LIKE '[%]%' AND account.status!='BLOCK'
ORDER BY player.level DESC, player.exp DESC
LIMIT ".$cSeite[1].",".$CPSeite;
$sqlCmd2 = "SELECT player.name,player.account_id FROM player.player
INNER JOIN account.account
ON account.id=player.account_id
WHERE player.name NOT LIKE '[%]%' AND account.status!='BLOCK'";
$sqlQry = mysql_query($sqlCmd,$sqlServ);
$numrows = mysql_num_rows(mysql_query($sqlCmd2,$sqlServ));
$x=$cSeite[1]+1;
while($getPlayers = mysql_fetch_object($sqlQry)) {
$zF = ($x%2==0) ? "thell" : "tdunkel";
if(checkInt($markierteZeile) && $markierteZeile==$x) { $zF = "tmarkiert"; }
echo "<tr>";
echo "<td class=\"$zF\">".$x."</td>";
echo "<td class=\"$zF\"><a href='index.php?s=char&char=".$getPlayers->name."'>".$getPlayers->name."</a></td>";
echo "<td class=\"$zF\">".$getPlayers->level."</td>";
echo "<td class=\"$zF\">".$getPlayers->exp."</td>";
echo "<td class=\"$zF\"><a href='index.php?s=guild&guild=".$getPlayers->guild_name."'>".$getPlayers->guild_name."</a></td>";
echo "<td class=\"$zF\">";
if(!empty($getPlayers->empire)) {
echo '<img src="img/reiche/'.$getPlayers->empire.'_kl.jpg" title="Reich" alt="Reich"/>';
}
echo "</td>";
echo "</tr>";
$x++;
}
?>
</table>
<div class="center">
<?PHP
$maxRange = 4;
$maxStep = 15;
$totalpages = ceil($numrows/$CPSeite);
if(($aSeite-$maxRange)>0) $sStart = $aSeite-$maxRange;
else $sStart = 1;
if(($aSeite+$maxRange)<=$cSeite[0]) $sEnde = $aSeite+$maxRange;
else $sEnde = $cSeite[0];
if(($aSeite)>1) echo '<span class="ranking2"><a href="index.php?s=ranking_chars&p=1">Erste</a></span> « ';
for($i=$sStart;$i<=$sEnde;$i++) {
$sKlasse = ($i==$aSeite) ? "ranking1" : "ranking2";
echo'<span class="'.$sKlasse.'">';
echo'<a href="index.php?s=ranking_chars&p='.$i.'">'.$i.'</a></span>';
}
if(($aSeite+$maxStep)<=$cSeite[0]) echo ' » <span class="ranking2"><a href="index.php?s=ranking_chars&p='.$totalpages.'">Letzte</span></a>';
?>
</div>
</div>
<div id="con-bot"></div>