Coupon NPC [1.1.2]

[tr0n]

but that could only mean that the code wasn't deleted. Or am I wrong ?

[WhatFT]

The code is deleted in the sql but the codes in-game doesn't erased. I restarted my server and everything. The first version is working fine but the problem is, it has some bugs that can dupe.

[tr0n]

I think i found the bug ! the codes will be selected from database and saved into a array and it doesn't erase before relog. so i need to clean them ! FINALLY ! I'm going to fix that now.

[Tonetzkii]

Exactly thats why ill put the kick commands.

[tr0n]

Fixed. please test!

[quesoph]

You don't need to add newlines.. you just simply change these:

@available_code$, @available_item, @available_amount

to these:

.@available_code$, .@available_item, .@available_amount

and every line that contains these variable.

works fine with me.

[tr0n]

You don't need to add newlines.. you just simply change these:

@available_code$, @available_item, @available_amount

to these:

.@available_code$, .@available_item, .@available_amount

and every line that contains these variable.

works fine with me.

WTF IS WRONG WITH ME ? I totally lost my brain! <.<

and yes this works, thanks.

Fixed it finally

[quesoph]

Glad it helped.

[WhatFT]

It's working now ! Thanks tr0n and quesoph..

I added the codes and gave it to my testing char, and finally... it was deleted immediately and I tried even typing the same code, it has no bugs at all, instant delete in "Show Coupons" and in database, looking forward to have improvements and others ~ THANKS !

Suggestions :

Try adding some broadcast on it, example <name> obtained <amount> <item id> in Coupon Jack !

.[/b].

Edited May 19, 2012 by Paulinds

[Tonetzkii]

Thank you for fast update more power!. im not using @kick script command now.

Suggestion is possible to add the logs?

[quesoph]

It's working now ! Thanks tr0n and quesoph..

I added the codes and gave it to my testing char, and finally... it was deleted immediately and I tried even typing the same code, it has no bugs at all, instant delete in "Show Coupons" and in database, looking forward to have improvements and others ~ THANKS !

Suggestions :

Try adding some broadcast on it, example <name> obtained <amount> <item id> in Coupon Jack !

.[/b].
[/quote]

try this:
[code]
mes "[^FF7700Coupon Jack^000000]";
mes "You get ^0000FF" + getitemname(.@available_item[@i]) + " - " + .@available_amount[@i] + " ea.^000000";
query_sql "DELETE FROM `coupons` WHERE `code`='"+@my_code$+"'";
getitem .@available_item[@i],.@available_amount[@i];
announce strcharinfo(0)+" Has Claimed "+ .@available_amount[@i] +"x "+ getitemname(.@available_item[@i]) +" for entering the coupon number: "+@my_code$,0;
close;

Thank you for fast update more power!. im not using @kick script command now.

Suggestion is possible to add the logs?

../conf/log_athena.conf

enable this:

0x00020 - (N) Log Script transactions (items deleted/acquired through quests)

Edited May 21, 2012 by quesoph

[WhatFT]

@quesoph

Thank you sir ~ It's working now

[tr0n]

UPDATE TO 1.1.2

Now you're able to activate announce if a player gets a item.

uncomment line '104' to activate it.

[Uncle Drew]

+99 for this ! thanks!

[LOVE0825]

You can set the number of records in the account at what time to use this serial number to get the serial number of items

[Haikenz]

On 12/05/2012 at 11:36 PM, tr0n said:

Coupon NPC

I had the idea from here: http://rathena.org/b...ional-code-npc/

I decided to make my own script. How does this works ?

The admin speaks to the npc and he/she can add a new coupon. The code will be

generated randomly and automatic and everything will be saved in database.

You can set the code length in script. You only need to enter the item id and the amount.

If a player speaks to the npc he/she can submit a coupon and get the stuff.

The code will be deleted from database after it was used.

Notice: Coupon Codes are limited to 128 (array limit)

Files

• coupon_system.txt
• coupon_npc_1.1.0.txt
• coupon_npc_1.1.1.txt
• coupon_npc_1.1.2.txt

 

Changelogs

• 1.0.0 Release
• 1.1.0 Added code type feature (normal|md5-hash)
• 1.1.0 Added prevention for typing 0 into Item ID or Amount
• 1.1.0 Added a feature for gms to see available coupons
• 1.1.0 Minor bug fixes
• 1.1.1 Fixed a bug that caused duplicating items
• 1.1.2 Added announce if player got a item

 

Features

• Saves coupons in database
• randomly generated codes
• very easy to use

 

How can you help me ?

• Give me feedback
• Report bugs
• Tell me if you like it

 

tr0n

1. How to add the duration of a coupon? ex: valid only for 1 week, valid for 1 month...

2. how to use code on account, not to be used repeatedly in other chars

3. has some way the code stays in this form: aaaa-bbbb-cccc  separated by: - from 3 in 3 code

4. how to add multiple items to win in just 1 coupon

Edited September 3, 2017 by Haikenz