simplexjay2 Posted May 7, 2021 Group: Members Topic Count: 56 Topics Per Day: 0.01 Content Count: 224 Reputation: 4 Joined: 02/09/12 Last Seen: Saturday at 01:46 AM Share Posted May 7, 2021 Buggy Script But Luckily i already have 1 Quote Link to comment Share on other sites More sharing options...
Snaehild Posted May 14, 2021 Group: Members Topic Count: 16 Topics Per Day: 0.00 Content Count: 72 Reputation: 7 Joined: 06/23/14 Last Seen: November 13, 2022 Share Posted May 14, 2021 Is it possible to use an NPC instead of @claim? Quote Link to comment Share on other sites More sharing options...
mawjustin Posted July 5, 2021 Group: Members Topic Count: 47 Topics Per Day: 0.01 Content Count: 121 Reputation: 6 Joined: 09/26/14 Last Seen: September 8, 2023 Share Posted July 5, 2021 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; */ Quote Link to comment Share on other sites More sharing options...
Styx15 Posted February 22, 2023 Group: Members Topic Count: 25 Topics Per Day: 0.02 Content Count: 47 Reputation: 0 Joined: 09/28/20 Last Seen: November 25, 2023 Share Posted February 22, 2023 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.... Quote Link to comment Share on other sites More sharing options...
InfectedX Posted June 11, 2023 Group: Members Topic Count: 9 Topics Per Day: 0.00 Content Count: 65 Reputation: 1 Joined: 01/12/12 Last Seen: Saturday at 12:32 AM Share Posted June 11, 2023 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... Quote Link to comment Share on other sites More sharing options...
someoneloveyou Posted October 29, 2023 Group: Members Topic Count: 12 Topics Per Day: 0.04 Content Count: 31 Reputation: 0 Joined: 06/13/23 Last Seen: Yesterday at 05:23 AM Share Posted October 29, 2023 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$) + "'"; Quote Link to comment Share on other sites More sharing options...
Queen Freya Posted March 15 Group: Members Topic Count: 0 Topics Per Day: 0 Content Count: 5 Reputation: 0 Joined: 06/15/21 Last Seen: 19 hours ago Share Posted March 15 On 10/30/2023 at 3:19 AM, someoneloveyou said: Can this method overcome unlimited reclaim? Quote Link to comment Share on other sites More sharing options...
Raki Posted April 6 Group: Members Topic Count: 2 Topics Per Day: 0.05 Content Count: 5 Reputation: 0 Joined: 03/13/24 Last Seen: Thursday at 01:14 PM Share Posted April 6 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 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.