tr0n

Please read the rules: http://rathena.org/board/forum-30/announcement-9-scripting-support-easy-as-1-2-3/

WTF IS WRONG WITH ME ? I totally lost my brain! <.< and yes this works, thanks. Fixed it finally

I heard waiting is about 3-4 months ? I did the survey. Hopefully I get it soon.

Fixed. please test!

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.

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

does the server gives you any errors ? if something is wrong with the query the server should output a error

I don't understand how this is possible..

I uploaded it again with changes: { 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$+"'"; sleep2 3000; close2; getitem @available_item[@i],@available_amount[@i]; end; } this should work maybe.

query works after it is triggered not after you're going to character select.

wow the magical and mystical search button showed me something tr0ns Questboard: http://rathena.org/b...questboard-133/ Mission Boards: http://rathena.org/b...mission-boards/ Quest Template: http://rathena.org/b...quest-template/ Quest NPC Function: http://rathena.org/b...t-npc-function/ Sry, I couldn't find any "special" script that you want. ^^

Global Offensive isn't released ? How can it be your favorite game then. Games that I like and have: Origins: - Battlefield 3 Steam: - Counter Strike Source - Day of Defeat Source - Insurgency - Team Fortress 2 - Dungeon Defenders Others: - APB RELOADED - Metal Gear Solid 1-4

I will check it and find the bug. Last time I tested it, it worked bugless

internationale Server haben bessere Aussichten auf Erfolg als nur deutsche. Das liegt aber auch daran das die meisten deutschen Spieler schon ihre Stammserver haben und es weniger deutsche Spieler gibt im allgemeinen.

it would be private not unique. unique is something else

@Emistry how could this be bugged then when the query deletes the data before it gets the item ? - would look nicer ? it checks '@coupon_item' 2 times so I would need to write it down again. that's why I use label to avoid this. That's better. And why I shouldn't use a label ? - that's just a style of me. But yea you're right. Would be better if I put it in OnInit.

argh, I copied it from Emistry i'll fix that quick. thanks EDIT: DONE

Update Changelogs 1.1.1: Fixed a bug that caused duplicating items (Thanks to Emistry)

Emistry, how it can be that you get the item before it gets deleted in sql ? the query is before getitem. Does the query need a bit of time ?

I don't know how this could happen. I checked the script and found nothing. If you didn't entered 400-500 item amount in your database this shouldn't happen

UPDATE Changelogs 1.1.0: 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

Ich würde dir davon abraten. Sehr viele rechtschreibfehler und sehr outdated.

just restart the server. _____________________________________________________________ For everyone: PLEASE READ THE DESCRIPTION AND THE SCRIPT. It can't be that I make a friggin easy script and get 100posts about "how to use it correct" or "please make it different with this and that". If you can't understand basic logic mechanics then please learn the basics, if you open a server, learn basic scripting! Actually i really like suggestions and here are some good suggestions. But it's kinda rude to tell the author to make a whole different version of the script just because 1 person likes to. I don't even hear a "thank you" or a suggestion to improve my script. Some people say it and thank you for that, you are the reason why I do this! Please people, it's not like I don't like to make public scripts for the community. Sry but I had to say that.

you want to give gm's access to the coupon npc ? well okay, I actualy could add it. I will do it for the next update.