Форумы портала PHP.SU

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>

PHP:
скопировать код в буфер обмена

<table><?PHP  
        $db     = "player";
        mysql_connect(SQL_HOST, SQL_USER, SQL_PASS) OR
        die("ERROR: Connection failed. ".mysql_error());                
        mysql_select_db($db) OR
        die("ERROR: DB allready open. ".mysql_error());
$sql = "SELECT * FROM guild WHERE name NOT LIKE '' ORDER BY ladder_point desc, level desc LIMIT 10";
 
        $i = "0" ;
 $ergebnis = mysql_query($sql);
while($row = mysql_fetch_object($ergebnis))
   {
   $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>