• There is NO official Otland's Discord server and NO official Otland's server list. The Otland's Staff does not manage any Discord server or server list. Moderators or administrator of any Discord server or server lists have NO connection to the Otland's Staff. Do not get scammed!

Problem with killstatistics!!

Bonnen888

Bonnen888

Member
Joined
Oct 19, 2008
Messages
99
Reaction score
7
Location
Sweden
Can someone help me with it. Im using Crying Damson 0.3.6. I dont know how to fix it. I Think i neeed a upgraded Killstaticts. That includes,environment_killers, killers, player_deaths.
Look at picture:


Uploaded with ImageShack.us

PHP: 
<?PHP
$players_deaths_data = $SQL->query('SELECT * FROM players,player_deaths WHERE players.id = player_deaths.player_id ORDER BY date DESC LIMIT '.$config['site']['last_deaths_limit']);
$number_of_players_deaths = 0;
if(!empty($players_deaths_data))
{
	$vowels = array("e", "y", "u", "i", "o", "a");
	foreach($players_deaths_data as $dead)
	{
		$number_of_players_deaths++;
		if(is_int($number_of_players_deaths / 2))
			$bgcolor = $config['site']['darkborder'];
		else
			$bgcolor = $config['site']['lightborder'];
		$players_rows .= '<TR BGCOLOR="'.$bgcolor.'"><TD WIDTH="30"><center>'.$number_of_players_deaths.'.</center></TD><TD WIDTH="125"><small>'.date("j.m.Y, G:i:s",$dead['time']).'</small></TD><TD><a href="?subtopic=characters&name='.urlencode($dead['name']).'"><b>'.$dead['name'].'</b></a> killed at level <b>'.$dead['level'].'</b> by ';
		if(is_numeric($dead['killed_by']))
		{
			$player_char = new OTS_Player();
			$player_char->load($dead['killed_by']);
			if($player_char->isLoaded())
				$players_rows .= '<a href="?subtopic=characters&name='.urlencode($player_char->getName()).'"><b>'.$player_char->getName().'</b></a>';
			else
				$players_rows .= '<b>DELETED PLAYER</b>';
		}
		else
			if($dead['killed_by'] == "-1")
				$players_rows .= "item or field";
			else
			{
				if(in_array(substr(strtolower($dead['killed_by']), 0, 1), $vowels))
					$players_rows .= "an ";
				else
					$players_rows .= "a ";
				$players_rows .= $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())
					$players_rows .= ' and <a href="?subtopic=characters&name='.urlencode($player_char->getName()).'"><b>'.$player_char->getName().'</b></a>';
				else
					$players_rows .= '<b>DELETED PLAYER</b>';
			}
			else
				if($dead['altkilled_by'] == "-1")
					$players_rows .= "item or field";
				else
				{
					if(in_array(substr(strtolower($dead['altkilled_by']), 0, 1), $vowels))
						$players_rows .= " and an ";
					else
						$players_rows .= " and a ";
					$players_rows .= $dead['altkilled_by'];
				}
		$players_rows .= '.</TD><TD>'.$config['site']['worlds'][(int) $dead['world_id']].'</TD></TR>';
	}
}
if($number_of_players_deaths == 0)
	$main_content .= '<TABLE BORDER=0 CELLSPACING=1 CELLPADDING=4 WIDTH=100%><TR BGCOLOR="'.$config['site']['vdarkborder'].'"><TD CLASS=white><B>Last Deaths</B></TD></TR><TR BGCOLOR='.$config['site']['darkborder'].'><TD><TABLE BORDER=0 CELLSPACING=1 CELLPADDING=1><TR><TD>No one died on '.$config['server']['serverName'].'.</TD></TR></TABLE></TD></TR></TABLE><BR>';
else
	$main_content .= '<TABLE BORDER=0 CELLSPACING=1 CELLPADDING=4 WIDTH=100%><TR BGCOLOR="'.$config['site']['vdarkborder'].'"><TD CLASS=white><B>Last Deaths</B></TD></TR></TABLE><TABLE BORDER=0 CELLSPACING=1 CELLPADDING=4 WIDTH=100%>'.$players_rows.'</TABLE>';
?>
 
Last edited:
Sort by date Sort by votes
Maybe try this 'killstatic' :thumbup::
PHP: 
<?PHP
$players_deaths = $SQL->query('SELECT `player_deaths`.`id`, `player_deaths`.`date`, `player_deaths`.`level`, `players`.`name`, `players`.`world_id` FROM `player_deaths` LEFT JOIN `players` ON `player_deaths`.`player_id` = `players`.`id` ORDER BY `date` DESC LIMIT 0,'.$config['site']['last_deaths_limit']);
$players_deaths_count = 0;
if(!empty($players_deaths))
{
	foreach($players_deaths as $death)
	{
		$players_deaths_count++;
		if(is_int($players_deaths_count / 2))
			$bgcolor = $config['site']['darkborder'];
		else
			$bgcolor = $config['site']['lightborder'];

		$players_rows .= '<TR BGCOLOR="'.$bgcolor.'"><TD WIDTH="30"><center>'.$players_deaths_count.'.</center></TD><TD WIDTH="125"><small>'.date("j.m.Y, G:i:s",$death['date']).'</small></TD><TD><a href="?subtopic=characters&name='.urlencode($death['name']).'"><b>'.$death['name'].'</b></a> ';
		$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 = '".$death['id']."' ORDER BY killers.final_hit DESC, killers.id ASC")->fetchAll();

		$i = 0;
		$count = count($killers);
		foreach($killers as $killer)
		{
			$i++;
			if($killer['player_name'] != "")
			{
				if($i == 1)
					$players_rows .= "killed at level <b>".$death['level']."</b>";
				else if($i == $count)
					$players_rows .= " and";
				else
					$players_rows .= ",";

				$players_rows .= " by ";
				if($killer['monster_name'] != "")
					$players_rows .= $killer['monster_name']." summoned by ";

				if($killer['player_exists'] == 0)
					$players_rows .= "<a href=\"index.php?subtopic=characters&name=".urlencode($killer['player_name'])."\">";

				$players_rows .= $killer['player_name'];
				if($killer['player_exists'] == 0)
					$players_rows .= "</a>";
			}
			else
			{
				if($i == 1)
					$players_rows .= "died at level <b>".$death['level']."</b>";
				else if($i == $count)
					$players_rows .= " and";
				else
					$players_rows .= ",";

				$players_rows .= " by ".$killer['monster_name'];
			}
		}

		$players_rows .= '.</TD><TD>'.$config['site']['worlds'][(int)$death['world_id']].'</TD></TR>';
	}
}

if($players_deaths_count == 0)
	$main_content .= '<TABLE BORDER=0 CELLSPACING=1 CELLPADDING=4 WIDTH=100%><TR BGCOLOR="'.$config['site']['vdarkborder'].'"><TD CLASS=white><B>Last Deaths</B></TD></TR><TR BGCOLOR='.$config['site']['darkborder'].'><TD><TABLE BORDER=0 CELLSPACING=1 CELLPADDING=1><TR><TD>No one died on '.$config['server']['serverName'].'.</TD></TR></TABLE></TD></TR></TABLE><BR>';
else
	$main_content .= '<TABLE BORDER=0 CELLSPACING=1 CELLPADDING=4 WIDTH=100%><TR BGCOLOR="'.$config['site']['vdarkborder'].'"><TD CLASS=white><B>Last Deaths</B></TD></TR></TABLE><TABLE BORDER=0 CELLSPACING=1 CELLPADDING=4 WIDTH=100%>'.$players_rows.'</TABLE>';
?>
 
Upvote 0 Downvote

Similar threads

Czorcik
  • Question
Problem with Gesior Acc HIGHSCORE (offline player)
Replies
2
Views
499
Czorcik
Czorcik
O
  • Question
Solved Problem after ssl Myaac
Replies
2
Views
263
slaw
slaw
ralke
  • Question
AAC ZnoteAAC show killing assists at characterprofile deathlist
Replies
0
Views
185
ralke
ralke
Czorcik
  • Question
Highscore reborn system in acc maker
Replies
0
Views
285
Czorcik
Czorcik
O
  • Question
help name of the invisible towns in myacc
Replies
2
Views
421
tobi132
T
Back
Top