Custom CMS Script - Need New Custom Feature

Greetings!

Our website is designed and written for a World of Warcraft private server project called Vanilla-Exuberance. On this website members can read news, change account information, make use of features which affets their in-game character and also pruchase in-game items from a shop system on the site. Now we're looking to implement a new feature to this website, and it is the reason for posting this project on Freelancer.

The purpose of this feature is to reward players based on how long they have played on the game server. The server application collects this information all the time and saves it in a MySQL database. It can also be viewed while in-game by typing /played in the chat box. Now at first, this seems quite straight forward: Just read the character's played info table each time he logs on and then reward if the number is adequate for such. Well we thought about doing it this way but it would prevend members from playing on different alternative characters, because to get rewards they would need to have a high number of played time on one signel character. So, let me explain how we want this feature to work.

This new system should colled the played time of all characters that is assigned to the given account then add those numbers up to a single one. If this number is high enough to hang out an award, a button should pup up in the users control panel saying something like "Redeem Reward!". Also, at first login after the play time for this account has become adequate for a reward, it should pup up a box in the browser saying "congratulations, you have won!" with two options saying "redeem reward" and "redeem later".

We want the players to be rewarded multiple times throughout their journey, like the following:

5 days = reward

10 days = reward

15 days = reward

20 days = reward

30 days = reward

50 days = reward

And so forth. We need this new feature to me managable in the admin control panel as well, so that we can change and modify the rewards, and also modify when the rewards will be given out.

The rewards will be handed to the players by sending a command through telnet combined with SQL queries to save these occurances in a log. Now the rewards are given in two different ways, depending on what type of reward it is. Let's say on 10 days played, the user is rewarded with an in-game item. The ID for this item will be retrieved from the database and used in the telnet communication command. Then let's say on the 20th day played, the user will be rewarded with 20 donation points, this will be done simply by using an sql query that modifies the amount of donation points which the given member has.

That's about what I can think of right now. Post your bids!!

AJAX MySQL PHP Website Design Windows Server

Project ID: #1747223

About the project