CreatureEvent Level cap system with points!

[Darad]

Couldn't get it in a mod, so here's some scraps of code!

What does it do?
This script keeps players at a certain level. Creating a max level on your server. For every level they gain over the max they get a point. This points can be used in a shop or whatever you like.

Script includes a talkaction "!getpoints" that will give players a message of how many points they have.

Add this to player table.

ALTER TABLE players ADD cap_points int(11) DEFAULT 0

levelcap.lua

local config = {
	levelcap = 100000
}

function onAdvance(cid, skill, oldlevel, newlevel)
	if skill == SKILL__LEVEL then

		if newlevel > config.levelcap then
			doPlayerAddExperience(cid, -(getExperienceForLevel(getPlayerLevel(cid)) - getExperienceForLevel(config.levelcap)))
			
			local points = newlevel - config.levelcap
			
			setPlayerPoints(cid, points)
			doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_ORANGE, 'You gained ' .. points .. ' points.')
			return FALSE
		end
	end
	return TRUE
end

Add to creaturescripts.xml

<event type="advance" name="levelup" script="levelcap.lua"/>

Add to login.lua

registerCreatureEvent(cid, "levelup")

Add to lib/function.lua

function setPlayerPoints(cid, points)
	db.executeQuery("UPDATE `players` SET `cap_points` = `cap_points` +" .. points .. " WHERE `name` = '" .. getPlayerName(cid) .. "'")
end

function getPlayerPoints(cid)
	local result = db.getResult("SELECT `cap_points` FROM `players` WHERE `name` = '" .. getPlayerName(cid) .. "'")
	return result:getDataInt("cap_points")
	
end

Add to talkactions.xml

<talkaction words="!getpoints" event="script" hide="yes" value="getpoints.lua"/>

talkactions/scripts/getpoints.lua

function onSay(cid, words, param, channel)
	local points = getPlayerPoints(cid)
	doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_ORANGE, "You have " .. points .. " points available.")
	return true
end

 

[Your Master]

Thanks, it works
rep +

Little bug:
If player get from 29 to 31 or 30 to 31 (instand) then player get more cap, hp, mp

I dont mean bug in server(client) or sth but player get more cap, mana or hp

 

[Darad]

Uhm so if you level over the maximum the player doesn't get downgraded on hp etc? But downgraded on level. I'll look into it

Edit: Can you specify the bug?
I tested what I thought you mean, but no bug there. After the downgrade my hp/mana/cap were back to normal.

 

[Jaed Le Raep]

This is actually very useful for me... but.. I'm wondering something.. Wouldn't this be futile if i desired to raise my level cap over time?

 

[Darad]

This is actually very useful for me... but.. I'm wondering something.. Wouldn't this be futile if i desired to raise my level cap over time?

In what way? Just make sure you've got the content for the new levels. Tons of mmo's do this for ages now

 

[Jaed Le Raep]

Lol, what I mean is, what would be the point of having lvl cap points if I decided to raise the level cap over time and new players joined? Wouldn't they feel they had some unfair disadvantage?>

 

[Darad]

Don't think so no, maybe they're behind in points, but that's all. Up to you to find a good balance in that