GMKoji Posted March 31, 2013 Group: Members Topic Count: 17 Topics Per Day: 0.00 Content Count: 43 Reputation: 0 Joined: 02/17/12 Last Seen: October 11, 2015 Share Posted March 31, 2013 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 Quote Link to comment Share on other sites More sharing options...
archilles89 Posted September 14, 2013 Group: Members Topic Count: 16 Topics Per Day: 0.00 Content Count: 72 Reputation: 0 Joined: 10/28/12 Last Seen: December 1, 2017 Share Posted September 14, 2013 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? Quote Link to comment Share on other sites More sharing options...
Brian Posted September 14, 2013 Group: Members Topic Count: 75 Topics Per Day: 0.02 Content Count: 2223 Reputation: 593 Joined: 10/26/11 Last Seen: June 2, 2018 Share Posted September 14, 2013 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$)+"'"; Quote Link to comment Share on other sites More sharing options...
Lil Troll Posted September 14, 2013 Group: Members Topic Count: 38 Topics Per Day: 0.01 Content Count: 276 Reputation: 24 Joined: 07/06/13 Last Seen: April 19, 2014 Share Posted September 14, 2013 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. Quote Link to comment Share on other sites More sharing options...
Question
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
Link to comment
Share on other sites
3 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.