db.executeQuery? - Mystic Spirit 0.2.15 (9.86)

[Cadyan]

I can't seem to find a way to get this function to work properly.
Can anyone help me out?
I am using Znote 1.4 and Mystic Spirit 0.2.15

This is what I have right now:

guid = getPlayerGUID(cid)
doRemoveCreature(cid)
db.executeQuery("UPDATE `player_skills` SET `value` = '30' WHERE id = " .. guid .. ";")

 

[Cadyan]

bump

 

[Critico]

local pid = getPlayerGUID(cid)
doRemoveCreature(cid)
db.executeQuery("UPDATE `player_skills` SET `value` = 30 WHERE `player_id` = "..pid)

 

[Cadyan]

ill try it now - failed

[19/12/2013 00:37:49] Lua Script Error: [CreatureScript Interface] 
[19/12/2013 00:37:49] data/creaturescripts/scripts/login.lua:onLogin
[19/12/2013 00:37:49] data/creaturescripts/scripts/login.lua:5: attempt to call field 'executeQuery' (a nil value)
[19/12/2013 00:37:49] stack traceback:
[19/12/2013 00:37:49]     [C]: in function 'executeQuery'
[19/12/2013 00:37:49]     data/creaturescripts/scripts/login.lua:5: in function <data/creaturescripts/scripts/login.lua:1>

 

[Ninja]

Try with db.query

 

[Cadyan]

Try with db.query

Trying it now - failed
I am using Znote 1.4 and Mystic Spirit 0.2.15

[19/12/2013 21:40:25] Lua Script Error: [CreatureScript Interface]
[19/12/2013 21:40:25] data/creaturescripts/scripts/login.lua:onLogin
[19/12/2013 21:40:25] data/creaturescripts/scripts/login.lua:5: attempt to call field 'Query' (a nil value)
[19/12/2013 21:40:25] stack traceback:
[19/12/2013 21:40:25]    [C]: in function 'Query'
[19/12/2013 21:40:25]    data/creaturescripts/scripts/login.lua:5: in function <data/creaturescripts/scripts/login.lua:1>

 

[Limos]

Without capital Q, like Ninja posted: db.query

 

[Cadyan]

Works - thanks!