• There is NO official Otland's Discord server and NO official Otland's server list. The Otland's Staff does not manage any Discord server or server list. Moderators or administrator of any Discord server or server lists have NO connection to the Otland's Staff. Do not get scammed!
  • 2026 staff recruitment is open! Check it out and consider applying!

How I can use this script with SQL fuction

Ghazer

Member
Joined
Mar 13, 2009
Messages
350
Reaction score
6
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?

LUA:
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
wawPl.png
 
Last edited:
Back
Top