Reward NPC: enter code and redeem for item

[GMKoji]

RE: http://rathena.org/board/topic/79159-scripting-with-a-little-bit-of-sql/

would it be possible that only 1 code per person?

ex. code 1 is claimed by one player then other players wont be able to claim it anymore. hehe

[archilles89]

I am using this, it's very good but after the first person uses the code, the second, and third and so on users can spam the same code and get the items indefinitely. Is there a way to stop this?

[Brian]

Is your script based on the example in post #13?

There is already a line that updates the SQL table when a code is redeemed.

query_sql "UPDATE `reward_codes` SET `redeem_time`=NOW(), `char_id`="+getcharid(0)+" WHERE `code`='"+escape_sql(.@pc$)+"'";

[Lil Troll]

RE: http://rathena.org/board/topic/79159-scripting-with-a-little-bit-of-sql/

would it be possible that only 1 code per person?

ex. code 1 is claimed by one player then other players wont be able to claim it anymore. hehe

Please do check this out, i really need help on improving the script.