Promotional Code NPC

[Dvrstle]

I want to request this NPC to have a formal rewarding npc.. it can be also use in events

Heres the info

prontera,142,180,6

sprite = 112

If a player talked to the Promotional Code NPC, the selections are:

Input Promotional Code

>>> The should input the code given by the GM... And after that the player will get the

reward. (If the player inputted a wrong code, the NPC will just say that "Sorry this code

is incorrect or it was already taken)

Who are you?

Close

If a GM level 99 talked to the NPC, the selections are:

Administrator Settings

>>> Input Code

After inputing the code, the GM should input the item ID of the reward when a

player inputted the code correctly. As well as the amount of the item

Input Promotional Code

Who are you?

Close

Anyone can also add additional infos to improve this NPC. . .

Thank you in advance!!

anyone? hehe

[GM Takumirai]

Script Name : Information Center

- Script Created By : ManiacSociety

- Helper : Emistry & Kenpachi

MYSQL FUNCTION :

CREATE TABLE `supportsystem` (

`account_name` INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,

`subject` TEXT NOT NULL,

`message` TEXT NOT NULL,

`email` TEXT NOT NULL,

PRIMARY KEY (`account_name`)

)

ENGINE = InnoDB;

CREATE TABLE `donatesystem` (

`account_name` INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,

`phonenumber` TEXT NOT NULL,

`amount` TEXT NOT NULL,

`validation` TEXT NOT NULL,

`code` TEXT NOT NULL,

`status` TEXT NOT NULL,

PRIMARY KEY (`account_name`)

)

ENGINE = InnoDB;

CREATE TABLE `encodesystem` (

`codelist` INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,

`status` TEXT NOT NULL,

`validation` TEXT NOT NULL,

PRIMARY KEY (`codelist`)

)

ENGINE = InnoDB;

Edit Lines :

//=========================================================================//

// Npc Location

//=========================================================================//

prontera.gat,153,181,5 script Information Center 910,{

//=========================================================================//

// Configuration

//=========================================================================//

set .@npcname$,"^FF0000[information Center Assistant]^000000";

set .@code$,"^FFF000[Encoder Department Assistant]^000000";

set .@donate$,"^0000FF[Donation Department Assistant]^000000";

set .@server$,"^FFFF00[National Ragnarok Online]^000000";

set .@admincp$,"^FF0000[09993591472]^000000";

L_GML:

next;

mes .@npcname$;

mes "Here are the list of Game Master";

mes "^FF0000Admin Chivas^000000";

mes "- Server Owner";

mes "- Main Admin";

mes "- Server Host";

next;

mes .@npcname$;

mes "^FFF000Admin Glade^000000";

mes "- Scripter";

mes "- Developer";

mes "- Co-Admin";

mes "- Co-Owner";

next;

mes .@npcname$;

mes "^0000FFGM Force^000000";

mes "- Event GM";

mes "- Customier";

close;

cutin "", 255;

end;

Functions :

- MySQL

- In Game Donation

Game Master :

- Only administrator are allowed to add,delete,edit and view codes.

- Code Generate (No need to enter code automatic)

Normal Player :

- Enter Code

Process :

- GM will add the generated code and will automatically added to the database.

- If theres a donator and you wanted to give the codes you have to give the verification code and they have to activate it, once the VC is verified and correct the npc will automatically give the generated or promotion code.

- If the player receive the code already they have to enter the code and direct to the shop.

(WARNING)

- Edit shop 1 code = 1 items chosen (Much better to use box instead of items.)

If you have problem with that kindly post here.

And also please wait for mysql commands im fixing what you have to add.

http://pastebin.com/QBYjjrjj

- Note this is not mine

- and i don't know if this is going to work

- copyright goes to the maker

[Jhosef]

is this script is working????

[Littlefoot]

I will try this script if someone will say its working. I am afraid to take some risk. xD

[Dvrstle]

gonna try it later hehe tnx for the post

[Jhosef]

i cant understand this script and they have a error ..

that's why i plan to revised this and to make it more Friendly

[Jzz]

I have tested this one and it works fine you have to set the database correctly.