[Avesta] Remove Redskull Script

[Veterana]

Need a script for Avesta that make a item remove all frags from a player when used.

Item ID should be: 5541

Anyone got the skills to make this? Please help! I will REP++

 

[Calon]

<action itemid="5541" event="script" value="xxxx.lua"/>

and in actions/scripts

local config =
{
    item = 5541, 
    level = 1,
    count = 0
}
function onUse(cid, item, frompos, item2, topos)
if getPlayerLevel(cid) >= config.level then
        doPlayerSendTextMessage(cid, MESSAGE_INFO_DESCR, "Your frags have been removed.")
        doRemoveItem(item.uid)
        db.executeQuery("UPDATE `killers` SET `unjustified` = 0 WHERE `id` IN (SELECT `kill_id` FROM `player_killers` WHERE `player_id` = " .. getPlayerGUID(cid) .. ")")
    else
        doPlayerSendCancel(cid, "You dot have enough level")
    end
    return TRUE
end

 

[Veterana]

<action itemid="5541" event="script" value="xxxx.lua"/>

and in actions/scripts

local config =
{
    item = 5541, 
    level = 1,
    count = 0
}
function onUse(cid, item, frompos, item2, topos)
if getPlayerLevel(cid) >= config.level then
        doPlayerSendTextMessage(cid, MESSAGE_INFO_DESCR, "Your frags have been removed.")
        doRemoveItem(item.uid)
        db.executeQuery("UPDATE `killers` SET `unjustified` = 0 WHERE `id` IN (SELECT `kill_id` FROM `player_killers` WHERE `player_id` = " .. getPlayerGUID(cid) .. ")")
    else
        doPlayerSendCancel(cid, "You dot have enough level")
    end
    return TRUE
end

It tells you "Your frags have been removed." but the frags doesnt get removed.


The message i get in console is:

Lua Script Error: [Action Interface]
data/actions/scripts/scroll_frag_remover.luanUse

data/actions/scripts/scroll_frag_remover.lua:11: attempt to index global 'db' <a nil value>
stack traceback:
data/actions/scripts/scroll_frag_remover.lua:11: in function <data/data/actions/scripts/scroll_frag_remover.lua:7>

 

[Hiromath]

Do you use Mysql or sqlite as your database?

and what version of tfs do you use?

 

[Veterana]

Do you use Mysql or sqlite as your database?

and what version of tfs do you use?

I use Mysql and the server is Avesta.

 

[StreamSide]

should works, db.query works on avesta (I see it here AVESTA jajaja

 

[Veterana]

should works, db.query works on avesta (I see it here AVESTA jajaja

You have any idea why it is not working?

 

[StreamSide]

you use that avesta version?

 

[Veterana]

you use that avesta version?

I dont know, but is there any way to make it remove the frags from player??
I gave you the console error.

 

[StreamSide]

you have the function executequery? post here your functions also the file (if exist) db/database.lua

 

[Veterana]

you have the function executequery? post here your functions also the file (if exist) db/database.lua

I dont know mate. I dont have sources, my friend has sources and he is offline right now.
Sorry, do you have any idea how to solve it? Maybe? bro

 

[StreamSide]

database.lua isnt a source file bro, its in data pack...

 

[Veterana]

database.lua isnt a source file bro, its in data pack...

It is not there, sorry.
Can we fix this somehow anyways?



Please also take a look at my other post, need help for that here: http://otland.net/f16/avesta-item-gives-access-door-187397/#post1811744

- - - Updated - - -

Bump