Did you put these queries?
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 '0000-00-00 00:00:00',
`limit` INT(10) UNSIGNED NOT NULL DEFAULT '0',
`pool` INT(10) UNSIGNED NOT NULL DEFAULT '0',
PRIMARY KEY (`promo`)
) ENGINE = MYISAM;
CREATE TABLE `reward_logs` (
`code` VARCHAR( 26 ) NOT NULL DEFAULT '',
`account_id` int(11) unsigned NOT NULL default '0',
`last_ip` BINARY( 9 ) NOT NULL DEFAULT '',
`name` VARCHAR( 26 ) NOT NULL DEFAULT '',
`redeem_time` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
`claim` INT( 10 ) NOT NULL default '0',
PRIMARY KEY (`code`)
) ENGINE = MYISAM;
Yes. still player's can spam it. with upper case letter.