• 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!
  • 2026 staff recruitment is open! Check it out and consider applying!

Website Gesior Request! Easy php! :D

V

Vrotz

Member
Joined
Apr 7, 2011
Messages
1,071
Reaction score
7
Location
Brazil
Hello,

How i do to show the Kill and Deaths in this pvp? Isn't the "Frags". Just Killers and Deaths (All Frags/Killers/Deaths) in the characters.php

Please i need just the tables..

I cant post here, the forum said the message is too long.
sorry.
 
Sort by date Sort by votes
Vrotz said:
Hello,

How i do to show the Kill and Deaths in this pvp? Isn't the "Frags". Just Killers and Deaths (All Frags/Killers/Deaths) in the characters.php

Please i need just the tables..

I cant post here, the forum said the message is too long.
sorry.
Click to expand...

If it is easy php can't you do it yourself then?
If the script is to long for message, paste it on : http://pastebin.com/ and link it
 
Upvote 0 Downvote
What exactly are you looking for? Showing the amount of kills and deaths a player has or is it something else?
 
Upvote 0 Downvote
Code: 
$v = $SQL->query('SELECT (SELECT COUNT(`death_id`) FROM `killers` k LEFT JOIN `player_killers` pk ON `k`.`id` = `pk`.`kill_id` LEFT JOIN `players` p ON `pk`.`player_id` = `p`.`id` WHERE `k`.`unjustified` = 1 AND `k`.`final_hit` = 1 AND `player_id` = ' . $player->getId() . '), COUNT(`player_id`) FROM `player_deaths` WHERE `player_id` = '.$player->getId())->fetch();
$bgcolor = (($number_of_rows++ % 2 == 1) ?  $config['site']['darkborder'] : $config['site']['lightborder']);
$main_content .= '<tr bgcolor='.$bgcolor.'><td>Kills and Deaths:</td><td>' . htmlspecialchars($v[0]) . ' kills and ' . htmlspecialchars($v[1]) . ' deaths</td></tr>';
 
Upvote 0 Downvote
Back
Top