Code For DataBase

[Elexonic]

I need to fix this code and that is wrong = /

function onThink(interval, lastExecution, thinkInterval)
    db.query('UPDATE `player_storage` SET `value` = '0' WHERE `key` = '155'')
    return true
end

 

[JDB]

Um, try this... :huh:

function onThink(interval)
    db.executeQuery("UPDATE `player_storage` SET `value` = "0" WHERE `key` = "155"")
    return true
end

 

[Elexonic]

Error->

 

[gooberboy]

Try this.

function onThink(interval)
    db.executeQuery("UPDATE `player_storage` SET value = 0 WHERE key = 155;")
    return true
end

 

[PhoOwned]

It should be:

function onThink(interval)
    db.executeQuery("UPDATE `player_storage` SET `value` = '0' WHERE `key` = '155'")
    return true
end

and if you want to use any string or value from player you should use:

function onThink(interval)
    db.executeQuery("UPDATE `player_storage` SET `value` = ".. db.escapeString(param1) .." WHERE `key` = ".. db.escapeString(param2))
    return true
end

 

[Elexonic]

now I have no time to test proves hope after all that work ..

Also if anyone would know do not work a scrtip that you remove the log in storage?

Onlogout
if getPlayerStorageValue(cid, 155) < 1 then

 

[Jano]

you all wrong guys ^^ "key" is a reserved word in mysql, use it this way

player_storage.key