Solved [Movements] OnStepIn update player skills(db.query)

[elnelson]

Solved thanks

 

[Limos]

Move

local pid = getPlayerGUID(cid)

Under

function onStepIn(cid, item, position, fromPosition)

And under

if (not isPlayer(cid)) then
return true
end

Incase a monster or npc walks on it.

It is using cid, so it needs to be in a function with the parameter cid (function onStepIn(cid, item, position, fromPosition)).

 

[elnelson]

@Limos thanks, now here

if (getPlayerStorageValue(cid, 1254) == 1) and isPaladin(cid) == true then
            setPlayerStorageValue(cid, 1254, 0)
             doRemoveCreature(cid)  
            db.executeQuery("UPDATE players SET level = 20, experience = 98800, maglevel = 0, health = 185, mana = 35, healthmax = 185, manamax = 35, WHERE name ='"..name.."';")
             db.executeQuery("UPDATE `player_skills` SET `value` = '30' WHERE player_id = " .. pid)
            return true
end

i get this error:

OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: near "WHERE": syntax error (UPDATE players SET level = 20, experience = 98800, maglevel = 0, health = 185, mana = 35, healthmax = 185, manamax = 35, WHERE name ='Nelsin';)

 

[Limos]

Remove the comma after manamax = 35
manamax = 35,

 

[elnelson]

thanks solved