R>Promotional Code NPC

[GM Winter]

can i request a promotional code that is simply to config and theres no bug thanks in advance

[Poring King]

You can use my modified from lil troll . You can check it out from my collection in script collection section
Name is : CoolEvent Corp. Employee ( PRO Style - Coupon ) ^HOT! 

[amanikoko]

On 2/11/2021 at 12:20 PM, Poring King said:

You can use my modified from lil troll . You can check it out from my collection in script collection section

Hi Sir @Poring King,

May i ask for this script? couldn't find this script in your script collection section.

Your gesture is greatly appreciated.

[mR L]

 

[WillJocker]

On 3/29/2022 at 7:08 PM, Poring King said:

Name is : CoolEvent Corp. Employee ( PRO Style - Coupon ) ^HOT! 

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 '00-00-0000 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 IF NOT EXISTS `reward_logs` (
	`account_id` int(11) unsigned NOT NULL default '0',
	`last_ip` BINARY( 9 ) NOT NULL,
	`code` VARCHAR( 26 ) NOT NULL,
	`redeem_time` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
	`claim` INT( 10 ) NOT NULL,
	PRIMARY KEY (`code`)
) ENGINE = MYISAM;

error in database, #1067 - Valor padrão (default) inválido para 'time_created'

invalid format     `time_created` DATETIME NOT NULL DEFAULT '00-00-0000 00:00:00',
. Help plis?

 

[Poring King]

On 4/7/2022 at 5:43 AM, WillJocker said:

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 '00-00-0000 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 IF NOT EXISTS `reward_logs` (
	`account_id` int(11) unsigned NOT NULL default '0',
	`last_ip` BINARY( 9 ) NOT NULL,
	`code` VARCHAR( 26 ) NOT NULL,
	`redeem_time` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
	`claim` INT( 10 ) NOT NULL,
	PRIMARY KEY (`code`)
) ENGINE = MYISAM;

error in database, #1067 - Valor padrão (default) inválido para 'time_created'

invalid format     `time_created` DATETIME NOT NULL DEFAULT '00-00-0000 00:00:00',
. Help plis?

 

At the top of the script . There is a guide that you will need to install manually and automatically ...

[WillJocker]

On 4/10/2022 at 12:33 AM, Poring King said:

At the top of the script . There is a guide that you will need to install manually and automatically ...

Sorry, i can't see...

[Poring King]

On 4/13/2022 at 3:28 PM, WillJocker said:

Sorry, i can't see...

I already fix everything on my script . Seems like thats not my modified promotional code