caquinha
Member
- Joined
- Aug 8, 2016
- Messages
- 248
- Solutions
- 1
- Reaction score
- 24
How to add some items for parcel to offline players?
I would like to do /addcoin Darknight,50
I tried:
<talkaction log="yes" words="/addcoin" access="5" event="script" value="add_tokens.lua"/>
I would like to do /addcoin Darknight,50
I tried:
<talkaction log="yes" words="/addcoin" access="5" event="script" value="add_tokens.lua"/>
Code:
function onSay(cid, words, param)
if(param ~= "") then
local result = db.getResult("SELECT `name`, `town_id` FROM `players` WHERE `name` = " .. param)
if (result) then
local town_id = result:getDataString("town_id")
local chest = doCreateItemEx(2595)
doAddContainerItem(chest, 6527, 50)
doPlayerSendMailByName(param, chest, town_id)
end
end
return true
end
Code:
[16:39:48.393] mysql_real_query(): SELECT `name`, `town_id` FROM `players` WHERE `name` = Darknight - MYSQL ERROR: Unknown column 'Darknight' in 'where clause' (1054)
[16:39:48.394] [Error - TalkAction Interface]
[16:39:48.394] data/talkactions/scripts/add_tokens.lua:onSay
[16:39:48.394] Description:
[16:39:48.394] data/lib/004-database.lua:76: [Result:getDataString] Result not set!
[16:39:48.394] stack traceback:
[16:39:48.394] [C]: in function 'error'
[16:39:48.394] data/lib/004-database.lua:76: in function 'getDataString'
[16:39:48.394] data/talkactions/scripts/add_tokens.lua:5: in function <data/talkactions/scripts/add_tokens.lua:1>