!frags

[xLosT]

need talkaction to say !frags show result of the query
exemple You Have XX Frags!

($SQL->query('SELECT `p`.`name` AS `name`, COUNT(`p`.`name`) 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

 

[Critico]

function onSay(cid, words, param)
return doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_ORANGE,"You Have "..getPlayerFrags(cid).." Frags!")
end

 

[hodleo]

doesn't your TFS have it by default? \talkactions\scripts\frags.lua
well, you users tend to not specify which server do you use

 

[xLosT]

the script default show only the frags
my server is war want to show all frags on all time character

 

[hodleo]

you can either make the frags not expire in config.lua, or make a creaturescript to store frags in player storage
and by server version I meant if is (0.3.7, 0.4, 1.0, 0.2.15, etc)

 

[xLosT]

I already have it, I already sent the query so I need to know how can I do to run the command it shows the result

 

[Roddet]

Or u can add FragsPoints on Table "Players" (Also u need create the functions on lib) then u can use something like this getPlayerFragsPoints(cid), and for the player to win a frag would be something like this doPlayerAddFragsPoints(cid, 1) in a script on creaturescripts, then you can see all frags.

 

[xLosT]

is more easier to make my request

 

[xLosT]

i need command men!.

 

[xLosT]

bump

 

[xLosT]

bump

 

[GOD Fito]

You are owner of total-war.org and u don't know how to do this? xd lol

 

[GOD Fito]

Heroswar's suggestion is the solution, since the frags are deleted after some time and does not appear all the frags, unless you edit that part in the sources

find

bool Player::addUnjustifiedKill(const Player* attacked, bool countNow)

delete

 time_t now = time(NULL), today = (now - 84600), week = (now - (7 * 84600));

im not sure
if that dont work set 0 or highest time

or

may you need create a function using that query