Death list on Nicaw 3.16

[Samme]

Hello.

I need some help in nicaw configuration, as You know nicaw not support TFS deathlist, so there is any way to edit this, for work correctly?

I really need that AAC since is the best of AAC's at the moment...

 

[Avarian]

I can try and make my death list work with nicaws AAC if thats what you would like?

 

[Samme]

sure, but I need that option, when player die it will be show when I search any player.

For example;

Nick: Samme
Level: 50
Proffesion: No Vocation
Guild: None
Last Login: xxx
----------------
Deaths:

Died at level 51 by rat. Time~

 

[Samme]

aff... refresh

 

[Avarian]

Alright, i'll see what I can do.

 

[Samme]

Then I wait for it )

I know, its possible because I saw one OT using TFS engine and death list work perfect there.

 

[Rabbe]

I would need this script too thanks.

 

[Samme]

hey, avarian when you gonna release that?

 

[Avarian]

Haven't had a chance to work on it yet, sorry. I'll get to it soon though.

 

[buzzbuzz2]

Yes this would be great... I have messed around with it for a while and still yet cant get it working.

 

[Thuggeh]

I have it working for Nicaw just fine. It probably isn't the best way to go about it (in fact, I know it's not), but it works for me. Someone can probably make a much better way.

In characters.php you can use this instead of the old way. If you can't figure it out still, I'll help. Make sure to add it after the "foreach ($deaths as $death){"

$host = 'localhost';
$usern = 'root';
$password = 'password';
$database = 'theforgottenserver';
$con = mysql_connect("$host","$usern","$password");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
$killa = $death['killer'];
mysql_select_db("$database", $con);
$query = "SELECT name FROM players WHERE name='$killa'";
$query = mysql_query($query);
$query = mysql_fetch_array($query);
if ($query)
$name = '<a href="characters.php?player_name='.$death['killer'].'">'.$death['killer'].'</a>';
else
$name = $death['killer'];
echo '<i>'.date("jS F Y H:i:s",$death['date']).'</i> Killed at level '.$death['level'].' by '.$name.'<br/>';
mysql_close($con);
}
}else{
echo "No deaths found.";