User referral system in WPUser, PHP MySQL.

General information for the website: Need a user referral system created
Kind of development: Customization of existing website
Num. of web pages/modules: MySQL table & app, various WP pages
Description of every page/module: Site: http://thewshikyclub.com.au
Tech: Wordpress, Woocommerce (session information will be saved at time of successful order placement), PHP, MySQL

Create Code & Registration Process
- a randomized or serialised unique referral code
- back-assign current members with unique referral code (and subsequent email to them to alert them to the program)
- registration/order process to auto-assign new unique referral code for each new user
- referral code in link emailed to user with Welcome email

Refer-A-Friend box/widget and page
- create a Refer-A-Friend widget email box which can be placed on any page, and separate referrer page with 5 boxes.
- box to ascertain current system session and alert members to login (to ensure they don't miss out on referrals)

Account settings
- have the refer code accessible and shareable from their account page
- requires integration of their code into one-click share for main social media outlets (those on the front page and also from their account page)

Referral Table
- to keep a register of referred people viewable in their account, with notice as to whether the referral has subsequently signed up
- to record not only the number of referrals for each member on new registration
- but the referred user details as well so that we can create a holistic overview of who has referred who

Tally Table & Process
- referral table stores each newly registered member against the referring member
- sets tally point counters, both up-to-5 and running total 
- with auto-alert to site owner and member on each 5 tally points, (confirms it has been sent, then saves a log for safety)
- resets up-to-5 counter, 
- while still keeping an overall tally for each member
- allows for future additional promotions based on total number of members referred

Referrer Leader Board
- top ten referrers
- being able to sort that tally by date range so milestones/rewards ('last 3 months" or "2014" etc.)
- means including a prize table and a leaderboard of the top ten referrers, with allotted prizes
Description of requirements/features: My client wants to be able to reward members for referring friends. This involves creating and including a unique referral code into links that the member distributes via referral emails or social media. The WP registration system needs to be able to recognise and store the incoming referral link and on successfully ordering a subscription to the site the referral code needs to be stored under the member's referrals. After each 5 referrals the member (and my client) will be notified and will get a reward however there must be a running total so that we can provide a Leaderboard for who has the most referrals.. The name/ID of each referred member is to be stored so that each member knows who they have referred.
CMS and Admin requirements: FTP & WP admin access provided.
I can provide a duplicate development installation or you can work on your own dev installation (preferred).
When it comes to final installation absolute care must be taken as it is a LIVE site so
Extra services needed: Customization
Extra notes: Please do not bother responding to the quote unless you have knowledge in the user session system of Wordpress, a good knowledge (at least 2 years) in PHP / MySQL and integration with WP modules. The solution required will need to be as streamlined as possible to match the quality of the rest of the site.

It is expected that a separate MySQL table (referenced by WPUser ID) will be required, a knowledge of CRON, and cookie session handling. Also it is probable that knowledge in AJAX social media code will be required to extend the social media shares with the unique session code, or at least include a share link with the referral code.

The site uses Woocommerce, and knowledge in that may be useful as the unique referral code/session information will probably be saved in a cookie at the time entry to the site and then stored into the referral table etc. at time of successful Woocommerce order placement so the unique order.