• There is NO official Otland's Discord server and NO official Otland's server list. The Otland's Staff does not manage any Discord server or server list. Moderators or administrator of any Discord server or server lists have NO connection to the Otland's Staff. Do not get scammed!
  • 2026 staff recruitment is open! Check it out and consider applying!

Skrypt php ,poprawienie za rep++

legolas23

New Member
Joined
Jan 8, 2009
Messages
537
Reaction score
3
Mógłby ktoś poprawić?
Skrypt ma wyświetlać 5 osób z największym storage value 16969.

Code:
<?PHP 
$players_deaths_data = $SQL->query('SELECT * FROM player_storage WHERE key = 16969 player_storage.player_id ORDER BY value DESC LIMIT 5;'); 
foreach($players_storage_data as $dead) { 
$vowels = array("e", "y", "u", "i", "o", "a"); 
  $players_row5 .= '<b><td align="left"><br><br><font size= "1" color="silver"><b><a href="?subtopic=characters&name='.$dead['name'].'"><B>'.$dead['name'].'</B></a>  <b>'.$dead['level'].'</b> level by <br> '; 
  if(is_numeric($dead['killed_by'])) 
  { 
    $player_char = new OTS_Player(); 
    $player_char->load($dead['killed_by']); 
    if($player_char->isLoaded()) 
      $players_row5 .= '<font size= "1" color="silver"><a href="?subtopic=characters&name='.$player_char->getName().'"><b>'.$player_char->getName().'</b></a><br></font>'; 
    else 
      $players_row5 .= '<font size= "1" color="silver"><b>DELETED PLAYER</b></font>'; 
  } 
  else 
    if($dead['killed_by'] == "-1") 
    { 
      $players_row5 .= "item or field"; 
    } 
    else 
    { 
      if(in_array(substr(strtolower($dead['killed_by']), 0, 1), $vowels)) 
      { 
        $players_row5 .= "an "; 
      } 
      else 
      { 
        $players_row5 .= "a "; 
      } 
      $players_row5 .= $dead['killed_by']; 
    } 
    } 
  $players_row5 .= '</font></TD></font></font></b></align></TR><br>'; 
echo ''.$players_row5.'' 
?>

Błąd :

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'key = 16969 player_storage.player_id ORDER BY value DESC LIMIT 5' at line 1' in /var/www/layouts/kungsv3/layout.php:252 Stack trace: #0 /var/www/layouts/kungsv3/layout.php(252): PDO->query('SELECT * FROM p...') #1 /var/www/index.php(313): include('/var/www/layout...') #2 {main} thrown in /var/www/layouts/kungsv3/layout.ph
 
PHP:
<?PHP 
$storages = $SQL->query("SELECT `players`.`name`, `player_storage`.`value` FROM `player_storage`, `players` WHERE `player_storage`.`player_id` = `players`.`id` AND `key` = '16969' ORDER BY `value` DESC LIMIT 5;"); 
foreach($storages as $storage)
{
	$main_content .= $storage['name'] . " " . $storage['value'];
}
?>
 
Back
Top