[GESIOR A.C.C] characters.php

[frankfarmer]

Aff..

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 '' at line 1' in E:\OTSERVER\xampp\htdocs\characters.php:366 Stack trace: #0 E:\OTSERVER\xampp\htdocs\characters.php(366): PDO->query('SELECT * FROM p...') #1 E:\OTSERVER\xampp\htdocs\index.php(148): include('E:\OTSERVER\xam...') #2 {main} thrown in E:\OTSERVER\xampp\htdocs\characters.php on line 366

Why and why? Trying to lookup a character and this happends. Some players is working but some aren't.. whats the problem?

Happends when you "look" statistics on a character on the website


Thanks in advance

 

[Helga]

Got the same problem, if u search for a character that have been killed by another player, you get this error.
This is on line 366:

$player_killerr12 = $SQL->query('SELECT * FROM player_killers WHERE kill_id = '.$player_kd.'');

 

[Helga]

Anyone help us please ?

 

[Zoriath]

Replace it with this:

$player_killerr12 = $SQL->query('SELECT * FROM `player_killers` WHERE `kill_id` = '".$player_kd."';');

Might work, not sure though.

 

[frankfarmer]

Parse error: syntax error, unexpected '"' in E:\OTSERVER\xampp\htdocs\characters.php on line 366

aff

 

[Helga]

Replace it with this:

$player_killerr12 = $SQL->query('SELECT * FROM `player_killers` WHERE `kill_id` = '".$player_kd."';');

Might work, not sure though.

Doesn't work

 

[Chris]

This will remove the unexpected " error caused by Zoriaths code. Not sure if it will solve the issue.

$player_killerr12 = $SQL->query('SELECT * FROM `player_killers` WHERE `kill_id` = \''.$player_kd.'\';');

 

[Zoriath]

Yeah sorry you guys are right.. Didn't see gesior used single quotes

You can do this too (which looks a bit nicer)

$player_killerr12 = $SQL->query("SELECT * FROM `player_killers` WHERE `kill_id` = '".$player_kd."';");

 

[skitzo]

Fixed my first problem, then i got this

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 '' at line 1' in C:\xampp\htdocs\characters.php:373 Stack trace: #0 C:\xampp\htdocs\characters.php(373): PDO->query('SELECT * FROM p...') #1 C:\xampp\htdocs\index.php(148): include('C:\xampp\htdocs...') #2 {main} thrown in C:\xampp\htdocs\characters.php on line 373


which i have written $player_killerr1 = $SQL->query('SELECT * FROM players WHERE id = '.$kurwa34.'');


Thanks in advance, rep to you all!

 

[Zoriath]

$player_killerr1 = $SQL->query("SELECT * FROM players WHERE id = '".$kurwa34."';");

Try it