vip script

[taha94]

I have a vip script and 4 items when you right click on one of these items you will get vip

The script worked before now suddenly when you press one of the items a box appears wich you can write things in.. How do i fix this? im using bronze goblet,silver goblet,gold golbet and medal of hounor.
I get this error when i press it

[22:34:17.618] [Error - Action Interface]
[22:34:17.618] data/actions/scripts/vip/vipmedal.luanUse
[22:34:17.618] Description:
[22:34:17.618] data/lib/099-VIPf.lua:13: attempt to call field 'executeQuery' (a nil value)
[22:34:17.618] stack traceback:
[22:34:17.618] data/lib/099-VIPf.lua:13: in function 'doAddVipDays'
[22:34:17.618] data/actions/scripts/vip/vipmedal.lua:13: in function <data/actions/scripts/vip/vipmedal.lua:1>
[22:34:22.861] mysql_real_query(): SELECT `id`, `guild_id`, `enemy_id` FROM `guild_wars` WHERE (`guild_id` = 1 OR `enemy_id` = 1) AND `status` IN (1,4) - MYSQL ERROR: Table 'tfs.guild_wars' doesn't exist (1146)

And i have this in vipf

--- Vip functions by Kekox
function getPlayerVipDays(cid)
    local Info = db.getResult("SELECT `vipdays` FROM `accounts` WHERE `id` = " .. getPlayerAccountId(cid) .. " LIMIT 1")
        if Info:getID() ~= LUA_ERROR then
        local days= Info:getDataInt("vipdays")
        Info:free()
        return days
    end
     return LUA_ERROR
end
 
function doAddVipDays(cid, days)
    db.executeQuery("UPDATE `accounts` SET `vipdays` = `vipdays` + " .. days .. " WHERE `id` = " .. getPlayerAccountId(cid) .. ";")
end
 
function doRemoveVipDays(cid, days)
    db.executeQuery("UPDATE `accounts` SET `vipdays` = `vipdays` - " .. days .. " WHERE `id` = " .. getPlayerAccountId(cid) .. ";")
end

I think in generall my data/lib is bugged can someone uppload another one

 

[sn3ejk]

What version of theforgottenserver have you got?

 

[taha94]

using this one http://otland.net/f18/8-60-forgotten-server-0-3-6-crying-damson-v5-147913/..Also when someone buys something from the vip shop the item multiplies.. Someone bought a zaoan legs from the shop and now his backpack is spamming with zaoan legs.. This is the error i get

[11:38:01.483] [Error - GlobalEvent Interface]
[11:38:01.483] data/globalevents/scripts/shop.luanThink
[11:38:01.483] Description:
[11:38:01.483] data/globalevents/scripts/shop.lua:23: attempt to call field 'executeQuery' (a nil value)
[11:38:01.483] stack traceback:
[11:38:01.483] data/globalevents/scripts/shop.lua:23: in function <data/globalevents/scripts/shop.lua:1>
[11:38:01.483] [Error - GlobalEvents::think] Couldn't execute event: shop

 

[Bufo]

Do you have `vipdays` in account table ?

 

[taha94]

What do you mean? This is the error i get from the shop, if you buy something from the shop the items multiply and you get like 100 of them

[Error - GlobalEvent Interface]
[13:7:20.498] data/globalevents/scripts/shop.luanThink
[13:7:20.498] Description:
[13:7:20.498] data/globalevents/scripts/shop.lua:23: attempt to call field 'executeQuery' (a nil value)
[13:7:20.498] stack traceback:
[13:7:20.498] data/globalevents/scripts/shop.lua:23: in function <data/globalevents/scripts/shop.lua:1>

And this is the error when i try to use my vip medal

[13:9:22.513] [Error - Action Interface]
[13:9:22.513] data/actions/scripts/vip/vipmedal.luanUse

 

[Bufo]

Try change

db.executeQuery

for

db.query

 

[taha94]

Were should i change that?

 

[Bufo]

Creaturescript in file shop.lua everywhere

 

[taha94]

Ok i changed it in global events,shop and in my lib file.. My vip creaturescript file does not have anything that says

db.executeQuery

it all works but i get this bug

[14:34:58.163] [Error - CreatureScript Interface] 
[14:34:58.163] data/creaturescripts/scripts/VIP/vipExp.lua:onThink
[14:34:58.163] Description: 
[14:34:58.163] data/lib/004-database.lua:60: [Result:getDataInt] Result not set!
[14:34:58.163] stack traceback:
[14:34:58.163] 	[C]: in function 'error'
[14:34:58.163] 	data/lib/004-database.lua:60: in function 'getDataInt'
[14:34:58.163] 	data/lib/099-VIPf.lua:5: in function 'getPlayerVipDays'
[14:34:58.163] 	data/creaturescripts/scripts/VIP/vipExp.lua:4: in function <data/creaturescripts/scripts/VIP/vipExp.lua:1>

 

[Bufo]

You have table `vipdays` in your database ?

 

[taha94]

I have no idea, i had a database and it worked perfectly then, now after i bought hosting service it dosn't work anymore..

This is what i constantly get

[14:58:22.057] [Error - CreatureScript Interface] 
[14:58:22.057] data/creaturescripts/scripts/VIP/vipExp.lua:onThink
[14:58:22.057] Description: 
[14:58:22.057] data/lib/004-database.lua:60: [Result:getDataInt] Result not set!
[14:58:22.057] stack traceback:
[14:58:22.057] 	[C]: in function 'error'
[14:58:22.057] 	data/lib/004-database.lua:60: in function 'getDataInt'
[14:58:22.057] 	data/lib/099-VIPf.lua:5: in function 'getPlayerVipDays'
[14:58:22.057] 	data/creaturescripts/scripts/VIP/vipExp.lua:4: in function <data/creaturescripts/scripts/VIP/vipExp.lua:1>

[14:58:22.558] [Error - CreatureScript Interface] 
[14:58:22.558] data/creaturescripts/scripts/VIP/vipExp.lua:onThink
[14:58:22.558] Description: 
[14:58:22.558] data/lib/004-database.lua:60: [Result:getDataInt] Result not set!
[14:58:22.558] stack traceback:
[14:58:22.558] 	[C]: in function 'error'
[14:58:22.558] 	data/lib/004-database.lua:60: in function 'getDataInt'
[14:58:22.558

 

[taha94]

bump

 

[taha94]

bump

 

[taha94]

bump

 

[taha94]

bump