search automatically add points to sms shop

[krzysiek1434]

hi
search script automatically add points to sms shop for level
tfs 0.3.6

 

[ikulol]

creaturescript.xml

<event type="advance" name="Pointsforlevel" event="script" value="pointforlevel.lua"/>

pointforlevel.lua

local config = {
	points=200,
	storage=23421,
	level=300

}

function onAdvance(cid, skill, oldLevel, newLevel)

	if(oldLevel<config.level and newLevel >=config.level) then
		if(getPlayerStorageValue(cid,config.storage)==-1) then
			local result_plr = db.getResult("SELECT * FROM accounts WHERE `id` = " .. getPlayerAccountId(cid) .. ";")
			local money = tonumber(result_plr:getDataInt("premium_points"))
			money = money+config.points
			db.executeQuery("UPDATE `accounts` SET `premium_points` = " .. money .. " WHERE id = " .. getPlayerAccountId(cid) .. ";")
			doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_BLUE, "Congratulations you have recived " .. config.points .." premium points.")
			setPlayerStorageValue(cid,config.storage,1)
		end
	end

	return true
end

login.lua
AFTER

registerCreatureEvent(cid, "AdvanceSave")

PASTE

registerCreatureEvent(cid, "Pointsforlevel")

this is not checked and will give item on advance for lvl or skills, cose i don't know skill types and don't have time to check it