Request Daily Rewards NPC

[Limestone]

can i request a Daily Rewards NPC like this:

Day 1 (Monday) : AFM 100% 2 PC's

Day 2 (TUEsday): Bubble Gum 2PC's

and so on..

Thank you so much!

[Joseph]

Edit the items yourself.

http://upaste.me/7ed1763602656f7

Case 0: getitem 671,1; break;
Case 1: getitem 672,1; break;
Case 2: getitem 673,1; break;
Case 3: getitem 674,1; break;
Case 4: getitem 675,1; break;
Case 5: getitem 676,1; break;
Case 6: getitem 677,1; break;

Note: Case 0 is Sunday.

[melvincruz03]

how can i make this like 1 ip 1 account. to avoid creating plenty of accounts and abusing the items or creating plenty of characters.

[Euphy]

Change dr_time$ to #dr_time$ to make it account-based.

Blocking multiple IPs is more complicated. The basic form would be:

1. Create a new SQL table, ex. `daily_ip`.
   
2. Query attached player's `login`.`last_ip` into `daily_ip`.
   
3. Check if other players' IPs are in `daily_ip` (more queries!).
   
4. Each new day (OnHour00), clear `daily_ip`.
   

[KoolKat29]

Thanks Euphy it's working great on my server.

[eJay]

Change dr_time$ to #dr_time$ to make it account-based.

Blocking multiple IPs is more complicated. The basic form would be:

1. Create a new SQL table, ex. `daily_ip`.
   
2. Query attached player's `login`.`last_ip` into `daily_ip`.
   
3. Check if other players' IPs are in `daily_ip` (more queries!).
   
4. Each new day (OnHour00), clear `daily_ip`.
   

Sir Euphy can you make me a script, ready to insert in sql. Thanks

Edited January 5, 2013 by eJay