[Function] Event points

[LucasFerraz]

Type: Function
Author: Antharaz
Tested Version: 0.4.0

Execute this query:

ALTER TABLE `accounts` ADD `event_points` INT NOT NULL DEFAULT '0'
ALTER TABLE `players` ADD `event_points` INT NOT NULL DEFAULT '0'

in data/lib create 027-events.lua and add:

function getEventPoints(cid,type)
    local pid = type == "accounts" and getPlayerAccountId(cid) or getPlayerGUID(cid)
    local hname = db.getResult("SELECT `event_points` FROM `"..type.."` WHERE `id` = "..pid.." ;")
    return hname:getID() ~= -1 and hname:getDataInt("event_points") or false
end
 
function addEventPoints(cid,points)
    local pid = getPlayerGUID(cid)
    local aid = getPlayerAccountId(cid)
    local point = (getEventPoints(cid,"accounts") + points) 
    local point = point > 0 and point or 0
    db.executeQuery("UPDATE `accounts` SET `event_points` = "..point.." WHERE `id` = "..aid..";")
    point = (getEventPoints(cid,"players") + points) 
    point = point > 0 and point or 0
    db.executeQuery("UPDATE `players` SET `event_points` = "..point.." WHERE `id` = "..pid..";")
end

How to use:
getEventPoints(cid,type) return how much events points player/account has.
getEventPoints(cid,"players") events will return the player points that he did.
getEventPoints(cid,"accounts") will return the sum of events points to all players that this account has.
addEventPoints(cid, 145) will add 145 event points
addEventPoints(cid, -145) will remove 145 event points


------------
Talkaction

made by VirrageS

<talkaction access="5" words="/addpoints" event="script" value="addEventPoints.lua"/>

function onSay(cid, words, param)
	local t = param.explode(param, ',')
	local pid = getPlayerByNameWildcard(t[1])
	if pid ~= nil then
		addEventPoints(pid, t[2])
		doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_ORANGE, 'You added '..t[2]..' points to '..t[1]..'.')
		return true
	end
	doPlayerSendCancel(cid, 'Player with name '..t[1]..' doesn\'t exist or isn\'t online.')
	return true
end

Use:

/addpoints [B]NAME[/B], [B]POINTS[/B]

 

[Lava Titan]

Pretty Cool System

btw can you make a talkaction with this?

/addpoints

=p

 

[VirrageS]

<talkaction access="5" words="/addpoints" event="script" value="addEventPoints.lua"/>

function onSay(cid, words, param)
	local t = param.explode(param, ',')
	local pid = getPlayerByNameWildcard(t[1])
	if pid ~= nil then
		addEventPoints(pid, t[2])
		doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_ORANGE, 'You added '..t[2]..' points to '..t[1]..'.')
		return true
	end
	doPlayerSendCancel(cid, 'Player with name '..t[1]..' doesn\'t exist or isn\'t online.')
	return true
end

Use:

/addpoints [B]NAME[/B], [B]POINTS[/B]

 

[Lava Titan]

thanks for talkaction =p

 

[nardosky]

btw can you make a npc with this? for change items for event points??

 

[Berensergen]

Can you make a npc for it?

 

[Eazy M]

Good job

 

[LucasFerraz]

bump

 

[Sh4rk]

Why you didnt use storage? Its better no....?

 

[bok]

how to add script?
every time he wins an event?

 

[LucasFerraz]

Add this next to reward:

addEventPoints(cid, 1)

 

[leverage]

[9/4/2017 15:0:58] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: near "LIMIT": syntax error (UPDATE "accounts" SET "premium_points" = 50 WHERE "name"='jibran' LIMIT 1

 

[leverage]

Hello who helps me with that error that I get when I give points and the other when I add the script to the sql

[9/4/2017 15:0:58] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: near "LIMIT": syntax error (UPDATE "accounts" SET "premium_points" = 50 WHERE "name"='jibran' LIMIT 1

Error ejecutando consulta: near "ALTER": syntax error
<simple query executor>

 

[Aldo Axel]

how can i create a custom shop in znote acc with some differents items, i mean, Classic Shop with Premium Points and Events Points...
for znote 1.5