Points Scripttt

[killing]

Hello
I need a Donation Acces for my OT.
When player use item ID 2266 i want to player get 10 points on site evry 3 hours for 7 days.
Im using 0.3.6 (8.60)
Rep++

 

[averatec]

action for item

function onUse(cid, item)
	if (item.itemid == 2266) then
		doCreatureSetStorage(cid, 22661, 1)
	end
end

globalevent - set it on 3hours interval

function onThink(interval, lastExecution, thinkInterval)
	db.executeQuery("UPDATE accounts SET premium_points = premium_points + 10 WHERE id IN (SELECT DISTINCT players.account_id FROM player_storage LEFT JOIN players ON players.id = player_storage.player_id WHERE key = 22661 AND value = \"1\")")
end

 

[killing]

I want to player keep getting Points for 7 Days.

- - - Updated - - -

Do i have to register it?

- - - Updated - - -

I want to player keep getting Points for 7 Days.

 

[averatec]

function onThink(interval, lastExecution, thinkInterval)
	--24/3 = 8 then 8*7 = 56
	db.executeQuery("UPDATE accounts SET premium_points = premium_points + 10 WHERE id IN (SELECT DISTINCT players.account_id FROM player_storage LEFT JOIN players ON players.id = player_storage.player_id WHERE key = 22661 AND value >= \"1\" AND value <= \"56\")")
	db.executeQuery("UPDATE player_storage SET value = value + 1 WHERE key = 22661")
end

Try this but remember item after every use will reset counter of days

- - - Updated - - -

<globalevent name="points_by_averatec" interval="10800" event="script" value="nameOfScript.lua"/>

globalevents.xml

 

[killing]

Action script.
where is in the Script Doremoveitem.?
I want when player use item to item Delete

 

[averatec]

then add it, it's not hard, look how it's in other scripts

 

[killing]

okay..
Well it then reset counter of days?

 

[averatec]

if player will not use item again, then would not reset

 

[killing]

Thanks i have rep++ you

 

[averatec]

function onThink(interval, lastExecution, thinkInterval)
	--24/3 = 8 then 8*7 = 56
	db.executeQuery("UPDATE `accounts` SET `premium_points` = `premium_points` + 10 WHERE `id` IN (SELECT DISTINCT `players`.`account_id` FROM `player_storage` LEFT JOIN `players` ON `players`.id` = `player_storage`.`player_id` WHERE `key` = 22661 AND `value` >= '1' AND `value` <= '56')")
	db.executeQuery("UPDATE `player_storage` SET `value` = `value` + 1 WHERE `key` = 22661")
end

fixed version

 

[killing]

 

[averatec]

try use this query in pma and show me results

 

[killing]

i have did

- - - Updated - - -

- - - Updated - - -

its not workinggggg

 

[averatec]

put this query into PMA and show me result from PMA -.-

 

[killing]

im NOT USING PMA!

 

[averatec]

function onThink(interval, lastExecution, thinkInterval)
	--24/3 = 8 then 8*7 = 56
	db.executeQuery("UPDATE `accounts` SET `premium_points` = `premium_points` + 10 WHERE `id` IN (SELECT DISTINCT account_id FROM players RIGHT JOIN player_storage ON player_storage.player_id = players.id WHERE `key` = 22661 AND `value` >= 1 AND `value` <= 56)")
	db.executeQuery("UPDATE `player_storage` SET `value` = `value` + 1 WHERE `key` = 22661")
	return true
end

 

[killing]

Now im just getting this

 

[averatec]

add return true before end

 

[killing]

did not help.
agend sam problem

- - - Updated - - -

i think i have fixd it

- - - Updated - - -

nop i didint

- - - Updated - - -

- - - Updated - - -

I think to problem is in name="DonationTime"

- - - Updated - - -

xml

 

[LucasFerraz]

show full script ..