**System Flow Diagram
**[url removed, login to view]**
**Part 1 - Fix vipcode check on [url removed, login to view]**
The vipcheck code check function currently on the page is not sufficient. It loads all the vip codes, puts them into a string, and then checks the vipcode text field against it onSubmit. This in not currently working up to par because the field will accept values that are found in the string.
For example, if the vip codes in the database are (1548,9818,5476,1885) and I enter 1886, it will display an invalid code. However, if I enter 188, it will accept because 188 does exist within the string created from the database codes even though 188 is not a valid vip code. A better solution might be to use an array and check the whole array values. Other robust solutions would also be acceptable.
We need a solution coded where it would prevent these incorrect codes from working.
**Part 2 - Pass and store registrant data user data into Aweber and database**
There are 2 kinds of system users. There are partners and registrants. A partner signs up at [url removed, login to view] and is saved in the database in the table called 'users'. Partners has already been programmed. Registrants sign up at [url removed, login to view] using a vipcode they obtained from a partner.
Registrants will need to be saved in a database table called 'registrants'
On our index page we are loading the database table 'users' which contains all the partners information on page load.
When a registrant registers, we need to pass the following fields to Aweber.
? registrant email (done)
? partner vipcode(done)
? partner firstname
? partner lastname
? partner phonenumber
? partner email
These need to be saved into Aweber using custom fields. Aweber will then pass these variables back to a thankyou page where they will be pulled from the URL using PHP Get and saved into the database into the table registrants. The registrant table will be constructed as follows.
registrant[id(PK), email address, pvipcode, pfname, plname, pphone, pemail, pid(FK)] **
**Part3 - Webinar Login**
We need to create a webinar login page ([url removed, login to view]) where a registrant will go to login to the webinar using their e-mail address. When they submit, they will be redirected to webinar.php. We have designed [url removed, login to view] and the psd is attached. We need this psd converted into the login page.
When the form is submitted, the registrant information will be passed into aweber to a new list called 3ss-webinarview. Again we will need to use custom fields in Aweber. This info will then be passed out of aweber to [url removed, login to view]
When the registrant lands on [url removed, login to view], an e-mail will be sent using php mail to the partner who's vipcode they are attached to. This e-mail will confirm that the registrant logged into the webinar and give the date and time of login.