Gesior accmaker 2 Question . LAST KILLS FIXED? how to FIX? <screen> help.

[aququ]

I have two question about death list and last deaths in gesior accmaker.
How to make it work.
I will explain it with screen is much easier ;>

Of course I will Repp ++

 

[Pykera]

I need help with this too

 

[Herpicus]

These should already be included in Gesior..

In characters.php, above if(!$player->getHideChar()) {
Add:

$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\"><nobr>".date("j M Y, g:i a", $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 .= "Death <b>".$death['level']."</b> for ";
            else if($i == $count)
                $dead_add_content .= " and for ";
            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>';