SOMEBODY CAN HELP ME WITH THE LUASQL PART?
Code:
function onUse(cid, item, fromPosition, itemEx, toPosition)
local donatorgroup = 4
local target = getPlayerName (cid)
local ticket = 2345
dofile("./config.lua")
if sqlType == "mysql" then
env = assert(luasql.mysql())
con = assert(env:connect(mysqlDatabase, mysqlUser, mysqlPass, mysqlHost, mysqlPort))
cur = assert(con:execute("UPDATE players SET group_id = 4 WHERE name = "..target..";"))
if isPlayer (cid) then
setPlayerGroupId(cid, donatorgroup)
doSendAnimatedText(getCreaturePosition(cid),"Donator!",198)
doSendMagicEffect(getCreaturePosition(cid), CONST_ME_HOLYAREA)
doSendMagicEffect(getCreaturePosition(cid), CONST_ME_BIGPLANTS)
doSendMagicEffect(getCreaturePosition(cid), CONST_ME_GIANTICE)
doSendMagicEffect(getCreaturePosition(cid), CONST_ME_HOLYAREA)
end
end
doPlayerRemoveItem(cid,ticket,1)
end