PHP [KONKURS][MODERN]Ostatnie ?mierci w widoku postaci

[Kuzirashi]

Demo:

Nie masz wystarczających uprawnień, aby zobaczyć link. Zaloguj or Rejestracja

Tworzymy plik /injections/character_view/naszaNazwa/injection.php

<?php

/// Deathlist /// 

/// Space /// 
ECHO '<BR>'; 
/// Space /// 
/* Connection */ 
$ots = POT::getInstance(); 
$ots->connect(POT::DB_MYSQL, connection()); 
$SQL = POT::getInstance()->getDBHandle(); 
// The list 
            $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 = darkBorder; } else { @$bgcolor = lightBorder; } @$number_of_rows++; 
                @$number_of_rows++; @$deads++; 
                @$dead_add_content .= "<tr class='tablerow'> 
                <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=".WEBSITE."/index.php/character/view/".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 Dislay form // 
ECHO '<div class="header" style="margin-bottom: 0px;">Deaths</div><TABLE BORDER=0 CELLSPACING=1 CELLPADDING=4 WIDTH=100%>' . $dead_add_content . '</TABLE><br />'; 
} 
/// Space /// 
ECHO '<BR>'; 

?>

Reput mile widziany.

Zabraniam kopiowania zawarto?ci na inne fora/serwisy.

Notka moderatorska:

+10pkt do konkursu!