https://rathena.org/board/topic/115232-script-doesnt-recognize-spaces/?do=findComment&comment=344440
seriously this is getting on my nerve whenever somebody bring this script up
can't everyone just recognize this script is just bug as hell ?
and promotion code can always bypass by players no matter how hard you try
block by IP is just plain stupid
better use getitembound instead of getitem so players will realize the reward item is bound to the account only
and when the script made as getitembound, means this VERY OLD script is invalid to use in today's script method
-------------------------------
ok enough being grumpy,
1. the SQL table has to be case-sensitive
2. use varchar
CREATE TABLE IF NOT EXISTS `reward_logs` (
`account_id` int unsigned NOT NULL default '0',
`last_ip` varchar(16) NOT NULL,
`code` VARCHAR(26) NOT NULL,
`redeem_time` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
`claim` INT NOT NULL,
PRIMARY KEY (`code`)
) ENGINE = MYISAM;
and I'm not fixing this script
better just write a new one with *getitembound