function fetchLatestDeaths_03($rowz = 30, $killers = false)
{
$countz = 0;
if ($rowz === false || $killers === true) {
$getdeaths = mysql_select_multi("SELECT * FROM player_deaths ORDER BY date DESC;");
} else {
$getdeaths = mysql_select_multi("SELECT * FROM `player_deaths` ORDER BY `date` DESC LIMIT 0, {$rowz};");
}
$data = false;
//while ($showdeaths = mysql_fetch_assoc($getdeaths)) {
if ($getdeaths !== false) {
for ($i = 0; $i < count($getdeaths); $i++) {
$pid = $getdeaths[$i]['player_id'];
$level = $getdeaths[$i]['level'];
$kid = user_get_kid($getdeaths[$i]['id']);
$killedby = user_name(user_get_killer_id($kid));
if ($killedby == false) {
$killedby = user_get_killer_m_name($kid);
$player = 0;
} else {
$player = 1;
}
if ($killedby === false) {
$player = 2;
$killedby = "Deleted player.";
}
$getname = mysql_select_single("SELECT `name` FROM `players` WHERE `id` = '{$pid}' LIMIT 1;");
$name = $getname['name'];
$row = array();
$row['level'] = $level;
$row['victim'] = $name;
$row['time'] = $getdeaths[$i]['date'];
$row['is_player'] = $player;
$row['killed_by'] = $killedby;
if ($killers) {
if ($player == 1) {
if ($rowz !== false) {
if ($countz < $rowz) {
$data[] = $row;
$countz++;
}
} else {
$data[] = $row;
}
}
} else {
$data[] = $row;
}
}
}
return $data;
}
<ul>
<?php
// Design and present the list
foreach ($array as $value) {
echo '<li>';
$value[3] = user_get_killer_id(user_get_kid($value['id']));
if ($value[3] !== false && $value[3] >= 1) {
$namedata = user_character_data((int) $value[3], 'name');
if ($namedata !== false) {
$value[3] = $namedata['name'];
$value[3] = 'player: <a href="characterprofile.php?name=' . $value[3] . '">' . $value[3] . '</a>';
} else {
$value[3] = 'deleted player.';
}
} else {
$value[3] = user_get_killer_m_name(user_get_kid($value['id']));
if ($value[3] === false) {
$value[3] = 'deleted player.';
}
}
echo '[' . getClock($value['date'], true) . '] Killed at level ' . $value['level'] . ' by ' . $value[3];
echo '</li>';
}
?>
</ul>
<?php
} else {
echo '<b><font color="green">This player has never died.</font></b>';
}
}
}
