CreatureEvent Reach x level get x points

[Amiroslo]

Hello,
Someone requested this script and I made it.

Here is how it works, you get X level then you receive x Premium Point.

Add in creaturescript.xml

	<event type="advance" name="5points" event="script" value="5pts.lua"/>

I made it so it gives 5points at level 300
add 5pts.lua to /script

--- Created by Amiroslo----
local t = {}

local points = 5 -- amount of premium points

function onAdvance(cid, type, oldlevel, newlevel)
   if (oldlevel ~= newlevel and type == SKILL__LEVEL) then
   if (newlevel >= 300 and getPlayerStorageValue(cid, 12345) == -1) then
        local p = "UPDATE `accounts` SET `premium_points` = `premium_points` + "..points.." where id="..getPlayerAccountId(cid)
                 db.executeQuery(p)
    doSendAnimatedText(pos, 'You have reached level 300 and you have received 5 Points!', RED)
    setPlayerStorageValue(cid, 12345, 1)
  end
  end
  return true
end

Change

if (newlevel >= 300

>>> to the level you want
and

local points = 5 -- amount of premium points

and in login.lua

	registerCreatureEvent(cid, "5points")

Rep++ if I helped you

 

[Korrex]

Tabbing.
Use it.

 

[Amiroslo]

I know, didnt have time
will when I have

edit: fixed it, not really good tabbing, did it fast!

 

[Cyro]

I miss read the db.execute sorry.

 

[Amiroslo]

it will
I tried it, It added 5, tied again, had 10

 

[Korrex]

"UPDATE `accounts` SET `premium_points` = `premium_points` + "..points.." where id="

This will "SET" his premium points to 5 or w/e not add 5 to them

Actually it will.
It'll set the premium points to old value + 5 .

 

[Cyro]

I just read Set then pasted the comment didn't read the full line, and if he used add it would be better.

 

[GarQet]

Better (with tables) - http://otland.net/f82/points-onadvance-level-auto-broadcast-151288/

 

[Santy]

Script is exploitable. If you die >300 lvl, you'll get moar points.

 

[Korrex]

Script is exploitable. If you die >300 lvl, you'll get moar points.

What?
It checks for storage value before executing?

 

[Bogart]

Please use the tab button that is near the caps lock key.

 

[Amiroslo]

Please use the tab button that is near the caps lock key.

No I tab my way, that tabbing button looks ugly xD

 

[Bogart]

local t = {}
local points = 5 -- amount of premium points
function onAdvance(cid, type, oldlevel, newlevel)
	if (oldlevel ~= newlevel and type == SKILL__LEVEL) then
		if (newlevel >= 300 and getPlayerStorageValue(cid, 12345) == -1) then
			local p = "UPDATE `accounts` SET `premium_points` = `premium_points` + "..points.." where id="..getPlayerAccountId(cid)
			db.executeQuery(p)
			doSendAnimatedText(pos, 'You have reached level 300 and you have received 5 Points!', RED)
			setPlayerStorageValue(cid, 12345, 1)
		end
	end
return true
end

Kinda looks cleaner this way.
But, it is your script, so tab it however you want.

 

[blazeradis]

I dont get the messege in game "You have reached level 300 and you have received 5 Points!"
Here is a picture on the bug at my tfs

 

[blazeradis]

I dont get the messege in game "You have reached level 250 and you have received 4 Points!"
Here is a picture on the bug at my tfs
View attachment 13343

local t = {}
local points = 4 -- amount of premium points
function onAdvance(cid, type, oldlevel, newlevel)
if (oldlevel ~= newlevel and type == SKILL__LEVEL) then
if (newlevel >= 250 and getPlayerStorageValue(cid, 12345) == -1) then
local p = "UPDATE `accounts` SET `premium_points` = `premium_points` + "..points.." where id="..getPlayerAccountId(cid)
db.executeQuery(p)
doSendAnimatedText(pos, 'You have reached level 250 and you have received 4 Points!', RED)
setPlayerStorageValue(cid, 12345, 1)
end
end
return true
end

 

[gotille]

Aww :/

Dubblepost?

Get another tfs?

 

[Amiroslo]

I dont get the messege in game "You have reached level 250 and you have received 4 Points!"
Here is a picture on the bug at my tfs
View attachment 13343

try this

local t = {}
local points = 4 -- amount of premium points
function onAdvance(cid, type, oldlevel, newlevel)
if (oldlevel ~= newlevel and type == SKILL__LEVEL) then
if (newlevel >= 250 and getPlayerStorageValue(cid, 12345) == -1) then
local p = "UPDATE `accounts` SET `premium_points` = `premium_points` + "..points.." where id="..getPlayerAccountId(cid)
db.executeQuery(p)
doCreatureSay(cid, 'You have reached level 250 and you have received 4 Points!')
setPlayerStorageValue(cid, 12345, 1)
end
end
return true
end

 

[Amiroslo]

bump

 

[kozmo]

Thanks sir i will be using this Rep++

 

[Amiroslo]

You're welcome