turn into Gesior acc

[xLosT]

Excuse my ignorance but I tried a lot and nothing came.


someone could help me add this script in character.php?
below the level
example

Name: XXXXXX
Sex: male
Profession: Druid
Level: 203
Killed: 20
Died: 12

script
http://otland.net/f82/kills-deaths-look-166381/

 

[Ninja]

Should work I guess. :ninja:

//frags
    $kills = $SQL->query('SELECT COUNT(*) as `frags`     
    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())->fetch();

//deaths
$deaths = $SQL->query('SELECT COUNT(*) as `dedek` FROM `player_deaths` WHERE `player_id` = '.$player->getId())->fetch();

'.$kills['frags'].'
'.$deaths['dedek'].'

 

[xLosT]

does not work well


look:

Game:

18:50 You see Micos (Level 169). He is a elite knight
He has Killed: [290] Players.
He has Died: [15] Times. He is Leader of the Sem Guild (Forever Alone).

WebSite:

Name: Micos
Sex: male
Profession: Knight
Level: 167
Killed: 4
Died: 15

 

[Ninja]

What if you replace

WHERE `k`.`unjustified` = 1 AND `k`.`final_hit` = 1 AND `player_id` = '.$player->getId())->fetch();

with

WHERE `player_id` = '.$player->getId())->fetch();

 

[xLosT]

100% very thx
++REP

 

[rodolfo]

ninja, you can help me put this php code where you quoted?

thank you

 

[Ninja]

ninja, you can help me put this php code where you quoted?

thank you

Send me a PM with your characters.php and I'll insert the code for you.