Гость
Покинул форум
Сообщений всего: 66
Дата рег-ции: Июнь 2012
Помог: 0 раз(а)
[+]
|
Т.к. не очень хорошо знаком с MySQL прошу помощи в решении еще одной задачи...
Есть 2 скрипта.
Один выводит рейтинг пользователей(Игроков):
CODE ( htmlphp):
скопировать код в буфер обмена
<?PHP $CPSeite = 10; $markierteZeile=0; 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 $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"; $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; $x=$cSeite[1]+1; $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>
Второй выводит рейтинг сообществ(кланов):
PHP:
скопировать код в буфер обмена
<table><?PHP $db = "player"; $sql = "SELECT * FROM guild WHERE name NOT LIKE '' ORDER BY ladder_point desc, level desc LIMIT 10"; $i = "0" ; { $i = $i + 1 ; $leader = $row->master; $zF = ($x%5==0) ? "t-name" : "t-rank"; echo " <tr> <th width=\"0\"></th> <th class=\"t-rank\">$i</th> <th class=\"t-name\">$row->name</th> <th class=\"t-lvl\">$row->level</th> </tr>"; } ?> </table>
как мне привести выводы этих скриптов вот к такому виду:
CODE ( htmlphp):
скопировать код в буфер обмена
<table> /// шапка <tr> <th>Игрок</th> <th>Клан</th> </tr> /// Вывод из БД <tr> <th>Игрок из бд</th> <th>Клан из бд</th> </tr> </table>
в итоге должна получится таблица мини-рейтинга в 10 строк и 2 столбца (игроки и кланы)
C уважением,
valkiriy.
|