Quest of donation points

[Swizi]

Sup guys. im searching for some help, im gonna make a really hard quest (maybe the hardest on my server ) and i wanna know if its possible to make special reward at the end. Instead of making items / exp as a reward for making the quest i want it to be donation points. So when a player clicks on the chest he will get X ammount of points added to he's account.

Is that possible to make, if it is could someone help me out to make that script? eace:

 

[Grehy]

Yes, simple. Just remove the line of the script that adds an item, and replace it with a db function that modifies a table. You can find both by searching

 

[Black Reaper]

Took a stab at it, if its wrong I'd appreciate if someone could point out what, I'm learning.

local query = {yourquerygoeshere}
function onUse(cid, item, fromPosition, itemEx, toPosition)
	if getPlayerStorageValue(cid, 700) == false then
		db.executeQuery(query)
		doPlayerSendTextMessage(cid, 21, "x donation points have been credited to your account!")
		setPlayerStorageValue(cid, 700)
	else
		doPlayerSendCancel(cid,"You have already done this quest.")
	return TRUE
end

 

[Grehy]

db.executeQuery(query)

That does nothing. Thats the function, but you need to designate a query for it to execute

 

[Black Reaper]

I know.

query = {yourquerygoeshere}

I don't know how to write query's so I figured he can search for it. Forgot to add local, but added it.

 

[Grehy]

and

setPlayerStorageValue(cid, 700, 1)

should be changed to

setPlayerStorageValue(cid, 700)

Since you are just checking for the storage, not the value (don't know what it is called)

 

[Black Reaper]

Thanks.

 

[legolas23]

local howmuch = 100 --how much points the quest will add
function onUse(cid, item, fromPosition, itemEx, toPosition)
        if getPlayerStorageValue(cid, 700) < 1 then
                db.executeQuery(db.executeQuery("UPDATE `accounts` SET `premium_points`=`premium_points`+' ..howmuch.. ' WHERE `name` = '' ..getPlayerAccount(cid).. '';"))
                doPlayerSendTextMessage(cid, 21, " '..howmuch.. ' donation points have been credited to your account!")
                setPlayerStorageValue(cid, 700, 1)
        else
                doPlayerSendCancel(cid,"You have already done this quest.")
        return TRUE
		end

I hope it will work

@down
First ;p

 

[Cykotitan]

local t = {
	storage = 700,
	points = 10
}
function onUse(cid, item, fromPosition, itemEx, toPosition)
	if getPlayerStorageValue(cid, t.storage) < 1 then
		db.executeQuery("UPDATE `accounts` SET `premium_points` = `premium_points` + " .. t.points .. " WHERE `name` = '" .. getPlayerAccount(cid) .. "';")
		doPlayerSendTextMessage(cid, 21, t.points .. ' donation points have been credited to your account!')
		setPlayerStorageValue(cid, t.storage, 1)
	else
		doPlayerSendCancel(cid, 'You have already done this quest.')
	end
	return true
end

and

[B][COLOR="Red"]set[/COLOR][/B]PlayerStorageValue(cid, 700, 1)

should be changed to

[B][COLOR="Red"]set[/COLOR][/B]PlayerStorageValue(cid, 700)

Since you are just checking for the storage, not the value (don't know what it is called)

no.

 

[Black Reaper]

Thanks, understand it now Cykotitan.