Promo Codes NPC

[Linkin Park]

Hi,

I want to request something similar to this one http://rathena.org/b...ional-code-npc/ , but just want to use the promotional codes system.

What I want is just the promotional codes system where the Admin can insert a code and an item that will be given out when the player entered the code.

Let's say for example, Admin talked to the NPC, added code HJ78SD with the prize of 100x TCG Cards. The player that will enter HJ78SD when he tries to redeem the code, he'll get the specific prize.

There will be different prizes for each code, of course to be set by the Admin. 1 code is only redeemable ONCE. So once the code has been redeemed, it will be automatically removed from the database instead of having the status set to 1 like from the link above.

Already made my own.

Edited October 4, 2012 by RaGERO

[Bin4ry]

No need of SQL db tho. Just use following elements:

// CP
input .PromoCode$;
mes "Promo code is set to " + .PromoCode$ + ".";
set .PromoClaimed,0;
close;
// Redeem
input @PromoCode$;
if (@PromoCode$ != .PromoCode$) {
mes "Code not exist!";
close;
}
if (.PromoClaimed == 1) {
mes "Code has redeemed by someone else.";
close;
}
getitem <item id>,<quantity>;
set .PromoClaimed,1;
close;

Edited October 3, 2012 by darristan

[Linkin Park]

No need of SQL db tho. Just use following elements:

// CP
input .PromoCode$;
mes "Promo code is set to " + .PromoCode$ + ".";
set .PromoClaimed,0;
close;
// Redeem
input @PromoCode$;
if (@PromoCode$ != .PromoCode$) {
mes "Code not exist!";
close;
}
if (.PromoClaimed == 1) {
mes "Code has redeemed by someone else.";
close;
}
getitem <item id>,<quantity>;
set .PromoClaimed,1;
close;

Did you ever read the whole post? That's exactly what the link I posted does. The reason I want to use SQL is so that I can add codes anytime without having to reload the NPC again or using up variables.

Edited October 3, 2012 by RaGERO

[Bin4ry]

Not sure why you need to use the SQL, unless you want to keep a log of those codes. You don't have to reload the NPC everytime because it uses temp var that your GM account input.

[Linkin Park]

Not sure why you need to use the SQL, unless you want to keep a log of those codes. You don't have to reload the NPC everytime because it uses temp var that your GM account input.

Geez, your example uses 1 variable for the code, what if I want to add 100 codes with different prizes for EACH code? Got my point?

Table structure would be

code, item id, amount

Once the code has been redeemed, it will be automatically removed from the database.

[Bin4ry]

You can still use string array. and the way you talk is a lil bit arrogant.

[Linkin Park]

You can still use string array. and the way you talk is a lil bit arrogant.

How to insert a value on a string array whenever I want to add a new code? and how would I remove it from the array once it has been redeemed?

[Bin4ry]

Well now I understand what's your point.

[Linkin Park]

Well now I understand what's your point.

Thanks, also with SQL I can hook up the codes anywhere in the website.

[Phantasm]

Can have Promo Code Generator, automatic make and add promo code in sql ??

[Linkin Park]

NVM, I made one myself.

[returnerza]

How to Promo Codes NPC On SQL

[ekis]

NVM, I made one myself.

can you share your script? with sql?