Utility : Promotional Code

[simplexjay2]

Buggy Script But Luckily i already have 1

[Snaehild]

Is it possible to use an NPC instead of @claim? 

[mawjustin]

For IP, time_created, and redeem_time problems use this.

 

/*
DROP TABLE IF EXISTS `reward_codes`;
DROP TABLE IF EXISTS `reward_logs`;
CREATE TABLE IF NOT EXISTS `reward_codes` (
	`promo` VARCHAR(26) NOT NULL DEFAULT '',
	`nameid` INT(11) UNSIGNED NOT NULL DEFAULT '0',
	`item_name` VARCHAR(50) NOT NULL DEFAULT '',
	`amount` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0',
	`time_created` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
	`limit` INT(10) UNSIGNED NOT NULL DEFAULT '0',
	`pool` INT(10) UNSIGNED NOT NULL DEFAULT '0',
	PRIMARY KEY (`promo`)
) ENGINE = MYISAM;
CREATE TABLE IF NOT EXISTS `reward_logs` (
	`account_id` int(11) unsigned NOT NULL default '0',
	`last_ip` BINARY( 15 ) NOT NULL,
	`code` VARCHAR( 26 ) NOT NULL,
	`redeem_time` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
	`claim` INT( 10 ) NOT NULL,
	PRIMARY KEY (`code`)
) ENGINE = MYISAM;	
*/

 

[Styx15]

On 7/5/2021 at 5:24 PM, mawjustin said:

For IP, time_created, and redeem_time problems use this.

 

/*
DROP TABLE IF EXISTS `reward_codes`;
DROP TABLE IF EXISTS `reward_logs`;
CREATE TABLE IF NOT EXISTS `reward_codes` (
	`promo` VARCHAR(26) NOT NULL DEFAULT '',
	`nameid` INT(11) UNSIGNED NOT NULL DEFAULT '0',
	`item_name` VARCHAR(50) NOT NULL DEFAULT '',
	`amount` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0',
	`time_created` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
	`limit` INT(10) UNSIGNED NOT NULL DEFAULT '0',
	`pool` INT(10) UNSIGNED NOT NULL DEFAULT '0',
	PRIMARY KEY (`promo`)
) ENGINE = MYISAM;
CREATE TABLE IF NOT EXISTS `reward_logs` (
	`account_id` int(11) unsigned NOT NULL default '0',
	`last_ip` BINARY( 15 ) NOT NULL,
	`code` VARCHAR( 26 ) NOT NULL,
	`redeem_time` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
	`claim` INT( 10 ) NOT NULL,
	PRIMARY KEY (`code`)
) ENGINE = MYISAM;	
*/

 

i test and still can abuse unlimited reclaim ..helpppp....

[InfectedX]

On 2/22/2023 at 2:45 AM, Styx15 said:

i test and still can abuse unlimited reclaim ..helpppp....

This is because last_ip data sent from the npc is too long... 

[someoneloveyou]

On 2/22/2023 at 3:45 PM, Styx15 said:

i test and still can abuse unlimited reclaim ..helpppp....

try to change it in your database using phpmyadmin
reward_logs > structure > change last_ip
Change last_ip type and value become Type 'Varchar' Value '15'

and change this 'ragnarok_db' to your ragnarok db
 

query_sql "DELETE FROM `ragnarok_db`.`reward_codes` WHERE `promo` = '" + escape_sql(.@dcode$) + "'"; 
query_sql "DELETE FROM `ragnarok_db`.`reward_logs` WHERE `code` = '" + escape_sql(.@dcode$) + "'";

 

[Queen Freya]

On 10/30/2023 at 3:19 AM, someoneloveyou said:

Can this method overcome unlimited reclaim?

[RagProject]

On 3/15/2024 at 11:17 AM, Queen Freya said:

Can this method overcome unlimited reclaim?

delete older sql and run this sql in phpmyadmin
 

CREATE TABLE `reward_codes` (
  `promo` varchar(26) NOT NULL DEFAULT '',
  `nameid` int UNSIGNED NOT NULL DEFAULT '0',
  `item_name` varchar(50) NOT NULL DEFAULT '',
  `amount` smallint UNSIGNED NOT NULL DEFAULT '0',
  `time_created` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `limit` int UNSIGNED NOT NULL DEFAULT '0',
  `pool` int UNSIGNED NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

CREATE TABLE `reward_logs` (
  `account_id` int UNSIGNED NOT NULL DEFAULT '0',
  `last_ip` varchar(15) NOT NULL,
  `code` varchar(26) NOT NULL,
  `redeem_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `claim` int NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

Please let me know if this code doesn't work