Есть 2 скрипта.
Один выводит рейтинг пользователей(Игроков):
CODE (htmlphp):
скопировать код в буфер обмена
скопировать код в буфер обмена
- <?PHP
- $CPSeite = 10;
- $markierteZeile=0;
- if(isset($_GET['p'])) {
- if(!checkInt($_GET['p']) || !($_GET['p']>0)) $aSeite = 1;
- else $aSeite = $_GET['p'];
- }
- else { $aSeite = 1; }{
- if(!empty($_POST['charakter'])) {
- $sqlCmd="SELECT id, name, level
- 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 LIKE '".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";
- $sql = "SELECT * FROM player.player WHERE name NOT LIKE 'xtd' AND name NOT LIKE '[SGA]%' ORDER BY level desc, exp desc LIMIT 10";
- $sqlQry = mysql_query($sqlCmd,$sqlServ);
- $getSum = mysql_fetch_object($sqlQry);
- $cSeite = calcPages($getSum->summeChars,$aSeite,$CPSeite);
- ?>
- <table>
- <?PHP
- $sqlCmd = "SELECT player.id,player.name,player.level,player.exp,player_index.empire,guild.name AS guild_name
- 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 player.name NOT LIKE 'Estray' AND account.status!='BLOCK'
- ORDER BY player.level DESC, player.exp DESC
- LIMIT ".$cSeite[1].",".$CPSeite;
- //echo $sqlCmd;
- $sqlQry = mysql_query($sqlCmd,$sqlServ);
- $x=$cSeite[1]+1;
- while($getPlayers = mysql_fetch_object($sqlQry)) {
- $zF = ($x%2==0) ? "t-rank" : "t-rank";
- if(checkInt($markierteZeile) && $markierteZeile==$x) { $zF = "tmarkiert"; }
- echo "<td width=\"0\">";
- echo "<td class=\"t-rank\"\>".$x."</td> <th />";
- echo "<td class=\"t-name\"\>".$getPlayers->name."</td> <td />";
- echo "<td class=\"t-lvl\"\>".$getPlayers->level."</td> <td />";
- if(!empty($getPlayers->empire)) {
- }
- echo "</td>";
- echo "</tr>";
- $x++;
- }
- ?>
- </table>