Lua Script for remove promotion

[Elite Brasil]

I need a script that removes the promotion so vipdays = 0

example: vipdays = 0 and transform promotion in 1


I tried to do a script did not work more

onLogout function (cid)
if (db.getResult ("SELECT` promotion `FROM` players `WHERE` name `= '" .. getCreatureName (cid ).."';") == 2) THEN
if (db.getResult ("SELECT` vipdays `FROM` `WHERE accounts` name `= '" .. getPlayerAccount (cid ).."';") <1) then
db.executeQuery ("UPDATE` players `SET` promotion `= 1 WHERE` name `= '" .. getCreatureName (cid ).."';")
end
end
return TRUE
end

Could someone help?

 

[Cykotitan]

function onLogout(cid)
	local a = db.getResult('SELECT `promotion` FROM `players` WHERE `id` = ' .. getPlayerGUID(cid) .. ' LIMIT 1;')
	if a:getDataInt('promotion') == 2 then
		local b = db.getResult("SELECT `vipdays` FROM `accounts` WHERE `name` = '" .. getPlayerAccount(cid) .. "' LIMIT 1;")
		if b:getDataInt('vipdays') < 1 then
			db.executeQuery('UPDATE `players` SET `promotion` = 1 WHERE `id` = ' .. getPlayerGUID(cid) .. ' LIMIT 1;')
		end
		b:free()
	end
	a:free()
	return true
end

 

[Elite Brasil]

function onLogout works in tfs 0.4 ?


need places

registerCreatureEvent (cid, "RemovePromotionl)

in login.lua?

 

[Cykotitan]

Yeah, try adding.

 

[Elite Brasil]

did not work: (

 

[Sonical]

login.lua
after

function onLogin(cid)

add

local Info = db.getResult("SELECT `vipdays` FROM `accounts` WHERE `id` = " .. getPlayerAccountId(cid) .. " LIMIT 1")
if Info < 1 then
doPlayerSetPromotionLevel(cid, 0)
doPlayerSave(cid, true)
end

and save

 

[Elite Brasil]

Thanks Sonical


REP++