Hourly Reward Script Request

[behemothcze]

Hi Guys ! 

Can anyone give me some script for Hourly Rewards that gives #cashpoints 

1hr 10
2hrs 15
3hrs 20
4hrs 25
5hrs 30
6hrs 35 

 

thanks

[Stolao]

i recently (like 5 mins ago) wrote a new hourly rewards script, its fairly configurable if you want to give it a try and give feedback.
https://github.com/Stolao/Npc_Release/tree/master/Hourly_Rewards

it uses quest_db to track hours so it doesn't have the issue that some other hourly have, it also have a separate timer for each character that doesnt reset on logout but a max amount of rewards per week

[AnnieRuru]

@Stolao

I mean like .... can you guys stop spreading this kind of technique ?

OnHour00:
	if(gettime(DT_DAYOFWEEK) == SUNDAY){
		query_sql("DELETE FROM `acc_reg_num` WHERE `key` = '#HReward'");
		addrid(0);
		#HReward = 0;
	}
end;

in the `acc_reg_num` table, the `key` column isn't index

if even as a developer is teaching this method, might as well go index the `key` column

 

CREATE TABLE IF NOT EXISTS `acc_reg_num` (
  `account_id` int(11) unsigned NOT NULL default '0',
  `key` varchar(32) binary NOT NULL default '',
  `index` int(11) unsigned NOT NULL default '0',
  `value` int(11) NOT NULL default '0',
  PRIMARY KEY (`account_id`,`key`,`index`),
  KEY `account_id` (`account_id`),
  KEY `key` (`key`), # <-- PLEASE ADD THIS IN YOUR main.sql
) ENGINE=MyISAM;

CREATE TABLE IF NOT EXISTS `char_reg_num` (
  `char_id` int(11) unsigned NOT NULL default '0',
  `key` varchar(32) binary NOT NULL default '',
  `index` int(11) unsigned NOT NULL default '0',
  `value` int(11) NOT NULL default '0',
  PRIMARY KEY (`char_id`,`key`,`index`),
  KEY `char_id` (`char_id`),
  KEY `key` (`key`), # <-- ALSO ADD THIS IN YOUR main.sql
) ENGINE=MyISAM;

 

[behemothcze]

On 4/16/2018 at 7:27 AM, Stolao said:

i recently (like 5 mins ago) wrote a new hourly rewards script, its fairly configurable if you want to give it a try and give feedback.
https://github.com/Stolao/Npc_Release/tree/master/Hourly_Rewards

it uses quest_db to track hours so it doesn't have the issue that some other hourly have, it also have a separate timer for each character that doesnt reset on logout but a max amount of rewards per week

+1 can you add some commands on it sir like @check where i can see how much points i have.

[behemothcze]

On 4/16/2018 at 7:27 AM, Stolao said:

i recently (like 5 mins ago) wrote a new hourly rewards script, its fairly configurable if you want to give it a try and give feedback.
https://github.com/Stolao/Npc_Release/tree/master/Hourly_Rewards

it uses quest_db to track hours so it doesn't have the issue that some other hourly have, it also have a separate timer for each character that doesnt reset on logout but a max amount of rewards per week

+1 can you add some @check so i can check how much points i have . and also can stop the hourly if afk for 30minutes and ned to relog. thanks

[Poring King]

You can use our search engine to find a hourlypoints. regarding to the time/hour/minute of the script you can read more details about it inside your server files doc / script_commands.txt using OnClock/Ontime/Onhour etc.