//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)
{
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['time']).'</TD><TD>Killed at Level '.$dead['level'].' by ';
if(is_numeric($dead['killed_by']))
{
$player_char = new OTS_Player();
$player_char->load($dead['killed_by']);
if($player_char->isLoaded())
$dead_add_content .= '<a href="?subtopic=characters&name='.urlencode($player_char->getName()).'"><b>'.$player_char->getName().'</b></a>';
else
$dead_add_content .= '<b>DELETED PLAYER</b>';
}
else
if($dead['killed_by'] == "-1")
$dead_add_content .= "item or field";
else
{
if(in_array(substr(strtolower($dead['killed_by']), 0, 1), $vowels))
$dead_add_content .= "an ";
else
$dead_add_content .= "a ";
$dead_add_content .= $dead['killed_by'];
}
if(!empty($dead['altkilled_by']) && $dead['killed_by'] != $dead['altkilled_by'])
if(is_numeric($dead['altkilled_by']))
{
$player_char = new OTS_Player();
$player_char->load($dead['altkilled_by']);
if($player_char->isLoaded())
$dead_add_content .= ' and <a href="?subtopic=characters&name='.urlencode($player_char->getName()).'"><b>'.$player_char->getName().'</b></a>';
else
$dead_add_content .= '<b>DELETED PLAYER</b>';
}
else
if($dead['altkilled_by'] == "-1")
$dead_add_content .= "item or field";
else
{
if(in_array(substr(strtolower($dead['altkilled_by']), 0, 1), $vowels))
$dead_add_content .= " and an ";
else
$dead_add_content .= " and a ";
$dead_add_content .= $dead['altkilled_by'];
}
$dead_add_content .= '.</TD></TR>';
}
}
$dead_add_content .= '</TABLE>';
if($number_of_player_deaths > 0)
$main_content .= $dead_add_content;