SQL Fuction how to add in script?

[Ghazer]

How I can use this script with SQL "update players set mag_level = 60" because that set magic level to 60...
and doPlayerAddMagLevel add one by one and that produce lag

I create that can you repair or optmize please?

function onLogin(cid)
    if getPlayerVocation(cid) == 1 or getPlayerVocation(cid) == 2 or getPlayerVocation(cid) == 5 or getPlayerVocation(cid) == 6 then
	    doRemoveCreature(cid)
        db.query('UPDATE `players` SET `mag_level` = 60 WHERE `name` = ' .. getPlayerName(cid) .. ';')
        getPlayerStorageValue(cid, 56364)
    end
    return true
end

When I use i have this error

 

[Summ]

function onLogin(cid)
    if getPlayerStorageValue(cid, 56364) < 1 and (getPlayerVocation(cid) == 1 or getPlayerVocation(cid) == 2 or getPlayerVocation(cid) == 5 or getPlayerVocation(cid) == 6) then
	    doRemoveCreature(cid)
        db.query('UPDATE `players` SET `mag_level` = 60 WHERE `name` = \'' .. db.escapeString(getPlayerName(cid)) .. '\';')
        doCreatureSetStorage(cid, 56364, 1)
    end
    return true
end

 

[Ghazer]

I have this error:

 

[Ninja]

db.query("UPDATE `players` SET `mag_level` = 60 WHERE `name` = " .. db.escapeString(getPlayerName(cid)) .. ";")

 

[Diath]

And there goes another fail...

 

[Summ]

function onLogin(cid)
    if getPlayerStorageValue(cid, 56364) < 1 and (getPlayerVocation(cid) == 1 or getPlayerVocation(cid) == 2 or getPlayerVocation(cid) == 5 or getPlayerVocation(cid) == 6) then
	    doRemoveCreature(cid)
        db.query('UPDATE `players` SET `mag_level` = 60 WHERE `name` = ' .. db.escapeString(getPlayerName(cid)) .. ';')
        doCreatureSetStorage(cid, 56364, 1)
    end
    return true
end

Didnt know that escape string add the ' symbols around the string also.


___
@Diath
What is the fail about Ninja's line? First he had a fail one, now it seems fine though.

 

[Diath]

@Diath
What is the fail about Ninja's line? First he had a fail one, now it seems fine though.

I posted before he's edited his post, you derpy.

 

[Summ]

Well you posted at the same time I did and his script was fixed by then

 

[Ninja]

I thought my mistake would go unnoticed but oh well, haha.

 

[Diath]

Do you take for consideration that I could have loaded the page between the time he edited his post and I actually posted? I wouldn't point out his mistake if it was edited because there would be nothing to point out, right? Please stop defending his mistakes and making yourself a fool.

 

[Ghazer]

I have this error:

In my SQLITE table the name of mag_level is maglevel I change that and I dont have errors in console but script doesnt work
HELP PLEASE! I really need that

 

[Diath]

It of course will not work this way because you update database fields while player is online.

 

[Ghazer]

script have that
doRemoveCreature(cid)

- - - Updated - - -

but when enter players his player no is kicked to add magic level... I think the error is doRemoveCreature(cid)

 

[Diath]

No, it's not. Either add a delayed event that will update magic level after the player gets kicked or add the magic level while creating a character.

 

[Ghazer]

Can you create that for me please? I'm new on ots servers
I dont know how to do it

- - - Updated - - -

bump

- - - Updated - - -

bump

 

[Ghazer]

Bump!

 

[Polat Alemdar]

Close your server by writing /closeserver (ingame)

then edit on phpmyadmin a sql script then write /openserver (ingame) login with the character and now test give him magic level!!

 

[Ghazer]

lol? do you want to do that every time someone create a character to give ML?

 

[Polat Alemdar]

No you dont need read what your console says!!

 

[Ghazer]

@Polat Alemdar, I think you dont understand what I want...

I think that scripts is good but not work in doRemoveCreature... its possible to set magic level 60 when druid or sorcerer is created? before of first login

- - - Updated - - -

function onLogin(cid)
    if getPlayerStorageValue(cid, 56364) < 1 and (getPlayerVocation(cid) == 1 or getPlayerVocation(cid) == 2 or getPlayerVocation(cid) == 5 or getPlayerVocation(cid) == 6) then
	    doRemoveCreature(cid)
        db.query('UPDATE `players` SET `mag_level` = 60 WHERE `name` = ' .. db.escapeString(getPlayerName(cid)) .. ';')
        doCreatureSetStorage(cid, 56364, 1)
    end
    return true
end