[Znote AAC] Last deaths

<?php require_once 'engine/init.php'; include 'layout/overall/header.php'; ?>

<h1>Last deaths</h1>
<?php
	
	$getdeaths = mysql_query("SELECT * FROM player_deaths ORDER BY time DESC LIMIT 10")or die(mysql_error());
	echo '<table border="0">
	<tr class="yellow"><td>Player</td><td>Level</td><td>Killed by</td></tr>';
	while ($showdeaths = mysql_fetch_assoc($getdeaths)) {
	$yd = $showdeaths['player_id'];
	$level = $showdeaths['level'];
	$player = $showdeaths['is_player'];
	$killedby = $showdeaths['killed_by'];
	$getname = mysql_query("SELECT name FROM players WHERE id = '$yd'");
	while ($parse = mysql_fetch_assoc($getname)) {
	$name = $parse['name'];
	echo '<tr><td>';
	echo '<a href="characterprofile.php?name='.$name.'">'.$name.'</a>';
	echo '</td><td>';
	echo $level;
	echo '</td><td>';
	if ($player == 1) {
		echo '<a href="characterprofile.php?name='.$killedby .'">'.$killedby.'</a> ( PVP )';
	} else {
	echo $killedby;
	}
	echo '</td></tr>';
	}
	}
	echo '</table>';
?>
<?php include 'layout/overall/footer.php'; ?>

if ($config['TFSVersion'] == 'TFS_02') {
	// TFS 0.2 code here
} else if ($config['TFSVersion'] == 'TFS_03') {
	// TFS 0.3 code here
}

// TFS .3 compatibility
function user_fetch_deathlist03($char_id) {
	$char_id = (int)$char_id;
	$query = mysql_query("SELECT * FROM `player_deaths` WHERE `player_id`='$char_id' order by `date` DESC LIMIT 0, 10") or die(mysql_error());
	while($row = mysql_fetch_assoc($query)) {
		$row['time'] = $row['date'];
		$array[] = $row;
	} 
	return !empty($array) ? $array : false;
}
// same
function user_get_kid($did) {
	$did = (int)$did;
	return mysql_result(mysql_query("SELECT `id` FROM `killers` WHERE `death_id`='$did';"), 0, 'id');
}
// same
function user_get_killer_id($kn) {
	$kn = (int)$kn;
	return mysql_result(mysql_query("SELECT `player_id` FROM `player_killers` WHERE `kill_id`='$kn';"), 0, 'player_id');
}
// same
function user_get_killer_m_name($mn) {
	$mn = (int)$mn;
	return mysql_result(mysql_query("SELECT `name` FROM `environment_killers` WHERE `kill_id`='$mn';"), 0, 'name');
}

Notice: Undefined index: is_player in C:\xampp\htdocs\deaths.php on line 12

Notice: Undefined index: killed_by in C:\xampp\htdocs\deaths.php on line 13

function user_name($id) { //USERNAME FROM PLAYER ID
	$id= sanitize($id);
	return mysql_result(mysql_query("SELECT `name` FROM `players` WHERE `id`='$id';"), 0, 'name');
}

<?php 
     
    $getdeaths = mysql_query("SELECT * FROM player_deaths ORDER BY date DESC LIMIT 40")or die(mysql_error()); 
    echo '<table border="0"> 
    <tr class="yellow"><td>Player</td><td>Level</td><td>Killed by</td></tr>'; 
    while ($showdeaths = mysql_fetch_assoc($getdeaths)) { 
		$yd = $showdeaths['player_id']; 
		$level = $showdeaths['level']; 
		$kid = user_get_kid($showdeaths['id']);
			if (user_get_killer_id($kid)) {
				$player = 1;
				$killedby = user_name(user_get_killer_id($kid));
			}
			else {
				$killedby = user_get_killer_m_name($kid);
				$player = 0;
			}
		$getname = mysql_query("SELECT name FROM players WHERE id = '$yd'"); 
			while ($parse = mysql_fetch_assoc($getname)) { 
				$name = $parse['name']; 
				echo '<tr><td>'; 
				echo '<a href="characterprofile.php?name='.$name.'">'.$name.'</a>'; 
				echo '</td><td>'; 
				echo $level; 
				echo '</td><td>'; 
					if ($player) { 
						echo '<a href="characterprofile.php?name='.$killedby .'">'.$killedby.'</a>'; 
					} else echo $killedby; 
			} 
		echo '</td></tr>'; 
    } 
 echo '</table>'; 
 ?>

<?php
// Select which parameters you want, this example: fetch player name and vocation from players table (based on player id).
$data = user_character_data($charid, 'name', 'vocation');

echo $data['name']; // Result: playername
echo $data['vocation'] // Result: 1 (if its a sorcerer, etc...).
?>