GesiorACC Click Item

[president vankk]

I wanted a scripter, you have X points in the shopping gesior acc.
You go on the server, and click the item and you win the item, you will lose points at the shopping ^_^

Rep++ :wub::wub: :thumbup:

 

[Serginov]

add action id in actions.xml yes.

Dude you've been on otland for a year now and you don't know a SHIT about ot? ;s

 

[president vankk]

I know.

but I do not understand anything! example of action

<action actionid="5000-5010" script="gesior.lua" /> CORRECT?

EXEMPLE:

		local items = 
{2160 = ACTIONID 5000
{2142 = ACTIONID 5001

 

[Serginov]

<action actionid="5000" event="script" value="gesior.lua" />

and use the one existance gave you

local function getPoints(cid)
    local result = db.getResult("SELECT `points` FROM `accounts` WHERE `id` = " .. getPlayerAccountId(cid) .. ";")
    if result:getID() ~= -1 then
        result:free()
        return result:getDataInt("points")
    end
end
local function setPoints(cid, count)
    return db.executeQuery("UPDATE `accounts` SET `points` = `points` - " .. count .. " WHERE `id` = " .. getPlayerAccountId(cid) .. ";")
end
function onUse(cid, item, fromPosition, itemEx, toPosition)
    if getPoints(cid) >= 100 then
        [COLOR=Red]local items = {2160, 2142, 2472, 2470, 2473}[/COLOR]
        if math.random(0, 1) then
            for i = 1, #items do
                doPlayerAddItem(cid, items[i], 1)
            end
            setPoints(cid, 100)
        else
            setPoints(cid, 100)
        end
    else
        doPlayerSendTextMessage(cid, 27, "You dont have enough points.")
    end
    return true
end

and add item ids at the red line

 

[QuaS]

@up i bet he say that he doesn't have file "gesior.lua"

 

[Serginov]

okay..?

 

[president vankk]

<action actionid="5000" event="script" value="gesior.lua" />

and use the one existance gave you

local function getPoints(cid)
    local result = db.getResult("SELECT `points` FROM `accounts` WHERE `id` = " .. getPlayerAccountId(cid) .. ";")
    if result:getID() ~= -1 then
        result:free()
        return result:getDataInt("points")
    end
end
local function setPoints(cid, count)
    return db.executeQuery("UPDATE `accounts` SET `points` = `points` - " .. count .. " WHERE `id` = " .. getPlayerAccountId(cid) .. ";")
end
function onUse(cid, item, fromPosition, itemEx, toPosition)
    if getPoints(cid) >= 100 then
        [COLOR=Red]local items = {2160, 2142, 2472, 2470, 2473}[/COLOR]
        if math.random(0, 1) then
            for i = 1, #items do
                doPlayerAddItem(cid, items[i], 1)
            end
            setPoints(cid, 100)
        else
            setPoints(cid, 100)
        end
    else
        doPlayerSendTextMessage(cid, 27, "You dont have enough points.")
    end
    return true
end

and add item ids at the red line

I KNOW!

EXEMPLE:
local items = {2160 = POINTS,ACTIONID
2142 = POINTS,ACTIONID
2472 = POINTS,ACTIONID
2470 = POINTS,ACTIONID

	local shop = {
		[5000]ID = {
			id = ID ITEM, points = 2000
		},
		[5001] = {
			id = ID ITEM, points = 7876

 

[Diath]

@Existance:
Why do u first free result, then try to get it's data? !

 

[Fallen]

@Existance:
Why do u first free result, then try to get it's data? !

thanks, edited my post

 

[Diath]

thanks, edited my post

Best solution:

local function getPoints(cid)
	local result = db.getResult("SELECT `points` FROM `accounts` WHERE `id` = " .. getPlayerAccountId(cid) .. ";")
	if result:getID() ~= -1 then
		local r = result:getDataInt("points")
		result:free()
		return r
	end
end

 

[Delirium]

Since you guys think that you can chat wherever you want without following rules I will make it clear and simple for you. Next one to post something irrelevant will be given an infraction. However, this does not apply for Existance and Cykotitan. You two are going to be banned for 1 week due to your high amount of infractions and your low understanding.

 

[zieworski denero]

Since you guys think that you can chat wherever you want without following rules I will make it clear and simple for you. Next one to post something irrelevant will be given an infraction. However, this does not apply for Existance and Cykotitan. You two are going to be banned for 1 week due to your high amount of infractions and your low understanding.

Who died!?!?!?

why bold red text.. :S