B??d characters.php

[Batonek]

Witam. Gdy chc? zobaczy? posta? na acc makerze to cz??? pokazuje si? normalnie, a przy drugiej cz??ci pojawia si? co? takiego:

[B]Fatal error[/B]:  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:366 Stack trace: #0 C:\xampp\htdocs\characters.php(366): PDO->query('SELECT * FROM  p...') #1 C:\xampp\htdocs\index.php(154): include('C:\xampp\htdocs...') #2 {main}   thrown in [B]C:\xampp\htdocs\characters.php[/B] on line [B]366[/B]

Z g?ry dzi?ki za pomoc,
pozdrawiam.

#edit
Z tego co wida? chodzi o zgony - 366 linijka:

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

 

[Jazper]

Odp: B??d characters.php

poka? mo?e 366 linijk?? bo tak troche ci??ko bd ci pom?c ;/

 

[Batonek]

Odp: B??d characters.php

...::r.e.f.r.e.s.h::..​

 

[Xart Irok]

Odp: B??d characters.php

Jak dla mnie u?ywasz pra historycznej listy, trzymaj tu now? pod nowe TFS:

				// start deaths list
				$deads = 0;
				$player_deaths = $SQL->query('SELECT `id`, `date`, `level` FROM `player_deaths` WHERE `player_id` = '.$player->getId().' ORDER BY `date` DESC LIMIT 0,10;');
				foreach($player_deaths as $death)
				{
					if(is_int($number_of_rows / 2))
						$bgcolor = $config['site']['darkborder']; else $bgcolor = $config['site']['lightborder'];
					$number_of_rows++; $deads++;
					$dead_add_content .= "<tr bgcolor=\"".$bgcolor."\">
					<td width=\"20%\" align=\"center\">".date("j M Y, H:i", $death['date'])."</td>
					<td>";
					$killers = $SQL->query("SELECT environment_killers.name AS monster_name, players.name AS player_name, players.deleted AS player_exists FROM killers LEFT JOIN environment_killers ON killers.id = environment_killers.kill_id	LEFT JOIN player_killers ON killers.id = player_killers.kill_id LEFT JOIN players ON players.id = player_killers.player_id WHERE killers.death_id = ".$SQL->quote($death['id'])." ORDER BY killers.final_hit DESC, killers.id ASC")->fetchAll();
					$i = 0;
					$count = count($killers);
					foreach($killers as $killer)
					{
						$i++;
						if(in_array($i, array(1, $count)))
							$killer['monster_name'] = str_replace(array("an ", "a "), array("", ""), $killer['monster_name']);
						if($killer['player_name'] != "")
						{
							if($i == 1)
								$dead_add_content .= "Killed at level <b>".$death['level']."</b> by ";
							else if($i == $count)
								$dead_add_content .= " and by ";
							else
								$dead_add_content .= ", ";
							if($killer['monster_name'] != "")
								$dead_add_content .= $killer['monster_name']." summoned by ";
							if($killer['player_exists'] == 0)
								$dead_add_content .= "<a href=\"index.php?subtopic=characters&name=".urlencode($killer['player_name'])."\">";
							$dead_add_content .= $killer['player_name'];
							if($killer['player_exists'] == 0)
								$dead_add_content .= "</a>";
						}
						else
						{
							if($i == 1)
								$dead_add_content .= "Died at level <b>".$death['level']."</b> by ";
							else if($i == $count)
								$dead_add_content .= " and by ";
							else
								$dead_add_content .= ", ";
							$dead_add_content .= $killer['monster_name'];
						}
						if($i == $count)
							$dead_add_content .= ".";
					}
					$dead_add_content .= "</td></tr>";
				}
				if($deads > 0)
					$main_content .= '<TABLE BORDER=0 CELLSPACING=1 CELLPADDING=4 WIDTH=100%><TR BGCOLOR='.$config['site']['vdarkborder'].'><TD COLSPAN=2 CLASS=white><B>Deaths</B></TD></TR>' . $dead_add_content . '</TABLE><br />';
				//end deaths list