EDITOR APPLICATION FORM
PROPOSED TABLE STRUCTURE
The table structure is mostly modeled after the fields used by the sign-up form on my own site, plus a custom field for any type of information you want to add (text). The application form will be template based and fully customizable... you can choose which field to use, and which to omit, depending on your setup.
ID => Reserved
Username => Auto generated from login name
Email => Auto generated from user details
RealName => Applicant's Real Name
Address => Applicant's Address
Occupation => Applicant's Occupation
Preference_A => Category Preference 1st
PID_A => Reserved
Preference_B => Category Preference 2nd
PID_B => Reserved
App_Text_A => Custom Field A, I use this for "why I would make a good editor"
App_Text_B => Custom Field B - what ever you like... 255 char limit
Languages => Languages spoken/fluent
Reference => Username of another editor for a reference - 75 char limit - use for whatever you like
Application_Status => Reserved
Application_Date => Auto generated date/time stamp when the form was submitted
The new table 'EditorPending' will be included in 1.0.7, but not used. This is simply to allow for easier upgrade when the time comes. Comments welcome. You can click on 'Become an Editor' on my site to see an example of this form in use. Please do NOT submit!
http://www.iuni.com/...tware/web/index.html
Links Plugins