Gesior Skull/frag remover Help!

[Kjosen]

Okey, I am using TFS 0.3.6pl1,

Problem:

The problem i have is when i am using Gesiors or anny other script i cant get the skull remover to delete the frags! (the skull remover is working)

In the gesior aac its like this on the redskullremover: (shopsystem)

('UPDATE players SET skull=0, skulltime=0 WHERE id='. $my_acc_id .';');

And i think it shuld be some thing like this, but i dont get it to work... :/


("UPDATE `killers` SET `unjustified` = 0 WHERE `id` IN (SELECT `kill_id` FROM `player_killers` WHERE `player_id` = " .. getPlayerGUID(cid) .. ");")


Please help me!

 

[Helga]

('UPDATE players SET skulltime=0, skull=0 WHERE id='. $my_acc_id .';');

 

[Kjosen]

It do not remove the frags..!

 

[Helga]

It do not remove the frags..!

ops sorry, wrong line xD
here it is:

('UPDATE killers SET unjustified=0 WHERE id IN (SELECT kill_id FROM player_killers WHERE player_id='. $my_acc_id .');');

 

[Tuchol]

use this script :
in actions/actions.xml add

<action itemid="9969" script="blackskull.lua"/>

in actions/sctipts/blackskull.lua paste

function onUse(cid, item, fromPosition, itemEx, toPosition)
       doCreatureSay(cid, "Frags sucesfully removed.", TALKTYPE_ORANGE_1)
       db.executeQuery("UPDATE `killers` SET `unjustified` = 0 WHERE `id` IN (SELECT `kill_id` FROM `player_killers` WHERE `player_id` = " .. getPlayerGUID(cid) .. ")")
	doPlayerSetSkullEnd(cid, 0, SKULL_RED) 
       doTransformItem(item.uid, 2320)
end

 

[Kjosen]

ops sorry, wrong line xD
here it is:

('UPDATE killers SET unjustified=0 WHERE id IN (SELECT kill_id FROM player_killers WHERE player_id='. $my_acc_id .');');

the problem i have with this one is that its removing the frags but not the skull...


Thanks alot Tuchol that workd!

 

[Helga]

the problem i have with this one is that its removing the frags but not the skull...


Thanks alot Tuchol that workd!

Then use both?!! I posted the skull remover first.

$SQL->query('UPDATE killers SET unjustified=0 WHERE id IN (SELECT kill_id FROM player_killers WHERE player_id='. $my_acc_id .');');
$SQL->query('UPDATE players SET skulltime=0, skull=0 WHERE id='. $my_acc_id .';');

Much easier, faster and better than a talkaction

 

[Kjosen]

Thanks Helga! that workd!! you are the best!

REP++