92930 PHP/MySQL *EXPERT* Needed

I need some PHP/MySQL work done, and I need an EXPERT to do it. This site will be very busy, therefore your script needs to be very clean and efficient. I know some PHP and I know how to write sloppy code - if you give me sloppy code I will know it and I will not be happy. Therefore, if you are not extremely good at what you do, and if you do not want to work with someone who is very picky about getting the code perfect, then please do not bid. This site will be integrated with the API of a popular social networking site. The integration is not a difficult one - essentially you must just make sure that the user is logged into the social networking site in order for our user to use various features of the site, and capture that user's UserID (because that is what we'll be using to identify the user on our site). I know very little about working with APIs but I do not believe that this should be difficult at all for someone who has worked with APIs before. Here are the things you'll need to do. 1) The site will have a referral system. Due to the limitations of the API we're working with we will track referrals based only on cookies. So, you will have to set a cookie when a user comes to the website from a referral link. If the users comes from a referral link then the cookie should be written over so the new referrer gets credit for the referral. We'll have a "Join Now" button or something smiliar. When this button is clicked we'll need to write to the MySQL database a) the UserID of the user and b) the UserID of that user's referrer - first by checking for a referral ID passed through the URL, and if one does not exist by checking the contents of the cookie. I hope this part makes sense - it really isn't as confusing as I might make it sound. It is just very basic cookie work and then writing some information to a MySQL database. 2) This is an incentive site and therefore we need to list offers for completion by the users. We need an admin panel to enter offer information - 'title', 'description', 'payout', 'network', 'link'. In the password-protected admin area there will be form fields to enter all of this information and a submit button. When the submit button is clicked the offer information is written to a database and each offer is assigned a unique 4-digit number. There should be seperate pages in the Admin Panel for "Add an Offer" (desribed above) and "Edit/Delete an Offer". The Edit/Delete page will list all of the offers minus the desriptions, with an "Edit" link, and a "Delete" link. If "Edit" is clicked then the admin should be taken to a page like the "Add Offer" page where all of that offer's information can be edited and saved. If the "Delete" link is clicked then obviously the offer record is deleted from the database. 3) We need a page to display all offers in the offer database (minus the "Network" field). The links to go with these offers will be in the form of [login to view URL], with "XXXXXX" being the user's UserID from the social networking site. Therefore, we must be able to pass that information from the user's login into those links. Should not be difficult. The offers do not change very much and therefore I want this query to be cached somehow to save on server resources. So instead of reading the information for each offer every time a person comes to the offer page, the script should read a cached version of all offers which is updated every 12 hours maybe? You'll need to help me out on this one. The (possibly) tricky part is that we need to delete completed offers from the list. So, the script should retrieve the offer file and then delete from the display all of the offers that have already been completed. Again, this is about speed so you get to tell me how to make this work the fastest. 4) In the Admin Panel there should also be a "Credit Offer" link where the admin can type in the a) UserID of the person who completed the offer and b) the 4-digit offer code...and then this information will be written to a database (and this information will be checked by the script in #3 so the offers in this part do not appear in the display in #3). There should also be a "Pay User" link where the admin can enter a UserID and an 'amount' and this information is stored in a MySQL database. 5) There needs to be a User Account Display page. The User (who must be logged in) can see how much money they have earned (by adding up the 'payout' from each completed offer as entered in #4) which will be displayed as "Personal Earnings". This User Account Display page will also check the database for the user's referrals, then check to see how much their referrals have earned, muliply this by .1, and then display this amount as "Referral Earnings". There should also be a "Referral Count" displayed, showing the number of users that this user has referred. Then "Personal Earnings" + "Referral Earnings" should be displayed as "Total Earnings" Then the amount payed out (from the "Pay User" database in #4) should be displayed as "Amount Payed". Then "Account Balance" should be displayed (Total Earnings minus Amount Payed). 6) On the User Account Display page there needs to be a link to "Transaction History". Here it will display all information for that user from "Credit Offer" and "Pay User". There will also be a "Referral Links" page which is very simply - it just needs to display that user's referral link which will be [login to view URL] (not exactly, but you get the idea) with XXXXXX being that user's UserID. 7) On the User Account Display page there also needs to be a link that says "Request Payment". The User will then be able to choose PayPal, Check, or Visa ePassporte. Upon making their choice they will enter their PayPal Address, Postal Address and Name, or Visa #. After entering this information it should be sent, along with the user's IP address and UserID, as an email to a specified email address (me at [login to view URL]), and some sort of Thank You message will appear. The details on this page need to be worked out, but you get the idea. Also on this page: When a user clicks submit the script should see if a cookie from this page has been set yet. If not, the cookie should be set with contents = UserID. If so, the contens of that cookie should be included in the email to me at domain.com. There may be some SMALL modifications to what I need done as we go along, but nothing major. Major changes will be paid for, don't worry. ALL WORK MUST BE DONE CUSTOM - NO COOKIE-CUTTER SCRIPTS. Again, script must be fast, clean, and efficient. You must also be able to finish quickly and install script on my server if needed. And again, you must integrate this with the API. It is simple, but details will be given out once we begin the project. Oh, and for the display pages - you don't really need to do much design work. As long as the links and MySQL/PHP stuff is there I can move stuff around and modify things to look how I need it to look. Any questions? Just ask. I realize this description is probably bad but ASK QUESTIONS ABOUT REQUIREMENTS so we both are on the same page. Thanks Brandon