Adding to SQL query (creaturescripts)

[Faraonekkk]

Hello otlanders,

Is there any script to place "1" into players.level (DB) if someone log in? (At creaturescripts, globalevents etc)
I saw something like this can anyone gimme simple code? P:

Ty <3

i have added

mysql_query("UPDATE players SET level = 1 WHERE name = '.getPlayerName(cid).'");

but got error attempt to call global "mysql_query"

 

[Ninja]

db.query('UPDATE `players` SET `level` = 1 WHERE `name` = ' .. getPlayerName(cid) .. ';')

 

[Faraonekkk]

attempt to index global 'db'

can you send me your db function from globals or functions.lua?

 

[Scarlet Ayleid]

function onLogin(cid)
    if(getPlayerLevel(cid) >= 1 and true) then --Replace true with other conditions you might want to give, or the players will go back to level 1 everytime they login
        doRemoveCreature(cid)
        db.query('UPDATE `players` SET `level` = 1 WHERE `name` = ' .. getPlayerName(cid) .. ';')
    end
    return true
end

you have to first remove the player from the game, otherwise the player will first load its current level and ignore the fact that you made it level 1

 

[Ninja]

attempt to index global 'db'

can you send me your db function from globals or functions.lua?

What server are you using?

 

[Faraonekkk]

avesta, bro there is needed functions to db

- - - Updated - - -

any ideas where to add ? its 7,6 engine there is no libs its using global.lua and functions.lua

 

[Tai]

Its an onLogin so Creatureevents silly.

 

[Faraonekkk]

any help how to fix it?.

 

[Summ]

By porting a sql function from a newer version and making it work on Avesta or by creating one.