PokemonRO Posted July 14, 2012 Posted July 14, 2012 (edited) Here is my Daily Points/Event Token with my own twist to it. 1. There is an IP Checker, It can be redeemed once per IP every 24 hours upon login. if((getd("$G_LIP_"+@lastIP$)+(60*60*24)) <= @now) { Change 60*60*24 to the time you want. It is set for 24 hours right now. 2. You can either set it to give an item or points //getitem 7227,1; //set(#pvppoints,#pvppoints+10); You can change the ID of the item and the amount. You can also use points if you want, just change the variable and the amount to your liking. daily.txt Edited July 14, 2012 by PokemonRO Quote
jTynne Posted July 14, 2012 Posted July 14, 2012 I'm confused: query_sql("SELECT REPLACE(`last_ip`,'.','_') FROM `login` WHERE `account_id` = "+getcharid(3),@lastIP$); Wouldn't just query_sql("SELECT `last_ip` from `login` WHERE `account_id` = "+getcharid(3),@lastIP$); Be feasible? o.o What's the REPLACE for? o.o I'm not that SQL-savvy, so I'm asking you to educate me! ) Quote
PokemonRO Posted July 14, 2012 Author Posted July 14, 2012 (edited) Oh, yep! your method works too. I just copied and pasted the sql line from another script and did a quick test to see if it worked, never actually looked to see that the replace was there. Both methods work fine, they will both record in your global reg values and tick properly for that IP. Edited July 14, 2012 by PokemonRO Quote
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.