[UPDATED][GESIORACC] Deathlist (characters.php) for TFS 0.3.5 with new rl system.

[richux]

0.3.5? How you get that? Why you released it when 0.3.5 is not ready yet ._.

Anyway, 10 queries to this is far to much. It can be done with 1 query, and as I remember Elf have already done it and posted long time ago on donators board.

Can u give me link cuz I can't find it on donators board?

Thank you Quas! =***

 

[Saj]

Thanks for this script.

 

[Jgarder]

script works great.. thanks for this.. although its not very efficient.. its a nice hack for right now

 

[QuaS]

It is my first php code, so.. i think nto bad

 

[Fare]

.... 0.3.5 wasn't released yet ;S too much spoilers on otland ;<
and as slawkens said, Elf already released this 5 weeks ago

 

[widnet]

Nice
I use must cope alone

//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;

 

[mattew]

@quas,

your gesior aac works in 0.3.5 tfs?

in my house doesn't works

 

[QuaS]

@up

i posted on 1st page, files nessesary to make it works

 

[Specjalist]

1 query ?:| not possible... there are 4 tables which are identify killer :|

Well, actually elf did it using 2 queries, that's not 1 neither it's 4

 

[mattew]

yes is the pot that is not correct!

Can you post the new ots_player.php configured for 0.3.5 tfs?

I would appreciate that

 

[widnet]

For you Not
Because i don't like you

 

[Tairone]

Please, post for me pot/OTS_Player.php and install.php for TFS 0.3.5

i waiting u


att

 

[QuaS]

UPDATED!

/// Thanks Archez! )

 

[dervin13]

Nice man!

Now its perfect!

Only one problem in gesior 0.3.5, to enter or out guilds, the player has to be off line!

But its a wonderfull site!

How can i donate to gesior?

 

[Mazen]

Nice script, but I have a problem. I've replaced the 2 files, installed the AAC and added the deathlist script. But when I try to enter a character page I get this error:

Warning: Error parsing C:/Users/Adrian/Desktop/Workstation/binaire3/config.lua on line 226 in D:\xampp\htdocs\config-and-functions.php on line 13

Fatal error: Call to a member function isLoaded() on a non-object in D:\xampp\htdocs\characters.php on line 22

 

[Dragonas1]

Hi,
I use tfs 0.3.5 pl1
If i pasted thist script on my ots then write this error:

Warning: mysql_query() [function.mysql-query]: Access denied for user 'www-data'@'localhost' (using password: NO) in /var/www/characters.php on line 406

Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in /var/www/characters.php on line 406

Very sory for my English.
Please for fast help

/Dragonas

 

[Rizzla]

Epic failed on this

 

[Erikas Kontenis]

Very Very Nice ! Big Rep From Me !

 

[Comtek]

anyone can help me? i need a SQL Table for player_killers in PHPmyadmin i deleted this table because i had a problem with the deathlist.. but now character shower doesnt work anymore so i need it back pls help

 

[Rodo]

why deleted the link?