[Gesior ACC] Błąd z informacjami o graczu. --ROZWIĄZANY--

kurczok666 · Oct 16, 2009

Witam. Mam problem ponieważ po zainstalowaniu Gęsior ACC 0.3.5 fixed v6 po kliknięciu na name gracza w dowolnym miejscu (highscores, Characters itd.) wywala błąd:

Code:

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:366 Stack trace: #0 C:\xampp\htdocs
\characters.php(366): 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 366

Nic w pliku characters.php nie było zmieniane.
TFS 0.3.5pl1.

Samme · Oct 16, 2009

Poka skrypt w linii 366.

kurczok666 · Oct 16, 2009

Code:

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

Samme · Oct 16, 2009

Weź pokaż cały skrypt odpowiedzialny za deady zaczyna się chyba //death list czy jakoś tak :d

kurczok666 · Oct 17, 2009

Proszę.

Code:

//deaths list
            $player_deaths = $SQL->query('SELECT * FROM player_deaths WHERE '.$player->getId().' = player_id ORDER BY date DESC');
            $dead_add_content .= '<br><TABLE BORDER=0 CELLSPACING=1 CELLPADDING=4 WIDTH=100%><TR BGCOLOR='.$config['site']['vdarkborder'].'><TD COLSPAN=2 CLASS=white><B>Deaths</B></TD></TR>';
            if(!empty($player_deaths))
            {
                $vowels = array("e", "y", "u", "i", "o", "a");
                foreach($player_deaths as $dead)
                {
                            $player_env_id = $dead['id'];
                            $player_env = $SQL->query('SELECT * FROM killers WHERE death_id = '.$player_env_id.' and final_hit = 1');
                            $player_env1 = $SQL->query('SELECT * FROM killers WHERE death_id = '.$player_env_id.' GROUP BY id');
                            foreach($player_env as $env)
                            {
                            $player_ki = $env['id'];
                            }
                            foreach($player_env1 as $env1)
                            {
                            $player_ki1 = $env1['id'];
                            }

                    $player_kil = $SQL->query('SELECT * FROM environment_killers WHERE kill_id = '.$player_ki.'');
                    $player_kill = $SQL->query('SELECT * FROM player_killers WHERE kill_id = '.$player_ki.'');
                    $player_kill1 = $SQL->query('SELECT COUNT(*) as liczba FROM killers WHERE death_id = '.$player_env_id.'');

                    foreach($player_kill as $killl)
                            {
                            $player_kurwa = $killl['player_id'];
                            }

                            foreach($player_kill1 as $killl1)
                            {
                            $player_kurwa2 = $killl1['liczba'];
                            }

                            if(empty($player_kurwa))
                            {
                            foreach($player_kil as $kilere)
                            {
                            $player_kills = $kilere['name'];
                            }
                            }
                            else
                            {
                            $player_killed_by_pks = 1;
                            }

                    if(is_int($number_of_player_deaths / 2))
                        $bgcolor = $config['site']['darkborder'];
                    else
                        $bgcolor = $config['site']['lightborder'];
                    $number_of_player_deaths++;


                    $dead_add_content .= '<TR BGCOLOR="'.$bgcolor.'"><TD WIDTH=20%>'.date("j M Y, H:i", $dead['date']).'</TD>';
                    if($player_killed_by_pks == 1)
                    {
                    if ($player_kurwa2 < 5)
                    {

                    $dead_add_content .= '<TD>Killed at Level '.$dead['level'].' by ';
                    }
                    elseif ($player_kurwa2 > 4 and $player_kurwa2 < 10)
                    {
                    $dead_add_content .= '<TD>Slain at Level '.$dead['level'].' by ';
                    }
                    elseif ($player_kurwa2 > 9 and $player_kurwa2 < 15)
                    {
                    $dead_add_content .= '<TD>Crushed  at Level '.$dead['level'].' by ';
                    }
                    elseif ($player_kurwa2 > 14)
                    {
                    $dead_add_content .= '<TD>Eliminated   at Level '.$dead['level'].' by ';
                    }

                    if ($player_kurwa2 == 1)
                    {
                        $player_kurwa1 = $SQL->query('SELECT * FROM players WHERE id = '.$player_kurwa.';');
                            foreach($player_kurwa1 as $kurwa)
                            {
                            $player_kills = $kurwa['name'];
                            }
                            $dead_add_content .= '<a href="?subtopic=characters&name='.urlencode($player_kills).'"><b>'.$player_kills.'</b></a>.';
                    }
                    else
                    {
                            foreach($player_env1 as $killl2)
                            {
                            $player_kurwa = $killl2['player_id'];
                            }
                    $player_kurwa8 = $SQL->query('SELECT * FROM players WHERE id = '.$player_kurwa.';');

                            foreach($player_kurwa8 as $kurwa8)
                            {
                            $player_kills = $kurwa8['name'];
                            }
                            $dead_add_content .= '<a href="?subtopic=characters&name='.urlencode($player_kills).'"><b>'.$player_kills.'</b></a>';

                    $iui = 1;
                    while ($iui != $player_kurwa2)
                    {
                    $player_env1 = $SQL->query('SELECT * FROM killers WHERE death_id = '.$player_env_id.' GROUP BY death_id');

                    foreach($player_env1 as $kurwa30)
                    {
                    $kurwa31 = $kurwa30['id'] + $iui;
                    }
                    $player_killerr = $SQL->query('SELECT * FROM player_killers WHERE kill_id = '.$kurwa31.'');

                    foreach($player_killerr as $kurwa32)
                    {
                    $player_kd = $kurwa32['kill_id'];
                    }
                    $player_killerr12 = $SQL->query('SELECT * FROM player_killers WHERE kill_id = '.$player_kd.'');

                    foreach($player_killerr12 as $player_kds)
                    {
                    $kurwa33 = $player_kds['player_id'];
                    }
                        $iui++;
                    $player_killerr1 = $SQL->query('SELECT * FROM players WHERE id = '.$kurwa33.'');
                    foreach($player_killerr1 as $kurwa34)
                    {
                    $kurwa35 = $kurwa34['name'];
                    }
                    $player_kills1 = $kurwa35;
                        if ($iui < $player_kurwa2)
                        {
                        $dead_add_content .= ', <a href="?subtopic=characters&name='.urlencode($player_kills1).'"><b>'.$player_kills1.'</b></a>';
                        }
                        elseif ($iui == $player_kurwa2)
                        {
                        $dead_add_content .= ' and <a href="?subtopic=characters&name='.urlencode($player_kills1).'"><b>'.$player_kills1.'</b></a>.';
                        }
                        }
                    }
                    }
                    else
                    {
                            $dead_add_content .= '<TD>Killed at Level '.$dead['level'].' by ';
                            $dead_add_content .= $player_kills;
                            }
                }
            }
            $dead_add_content .= '</TABLE>';
            if($number_of_player_deaths > 0)
                $main_content .= $dead_add_content;

Dodam że problem jest tylko z niektórymi postaciami (rożne lvle, profesje itd.)

pirl0 · Oct 17, 2009

Przyłączam się do tego problemu: )

Samme · Oct 17, 2009

Skrypt wygląda na dobry, wklej na wklej.org - strona główna cały characters.php, popatrzę.

kurczok666 · Oct 17, 2009

Proszę bardzo:

Code:

http://wklej.org/id/177219/

Plik jest taki sam jak w Gesior ACC 0.3.5 fixed v6. Nic nie było zmieniane.

Ref~ Potrafi ktoś pomóc?

elf · Oct 17, 2009

wklej.org - wklejka nr 177720

Proszę. Na beatshifa nie zwracaj uwagi, on potrafi robić tylko kompatybilnych z najnowszymi TFSami NPC i dorzuca własne modyfikacje.

kurczok666 · Oct 17, 2009

Dzięki Elf pomogło.

Proszę o zamknięcie.

[Gesior ACC] Błąd z informacjami o graczu. --ROZWIĄZANY--

kurczok666

New Member

Samme

.::EmmaS-SammE::.

kurczok666

New Member

Samme

.::EmmaS-SammE::.

kurczok666

New Member

pirl0

Scripter

Samme

.::EmmaS-SammE::.

kurczok666

New Member

elf

Sing, sing blue silver

kurczok666

New Member