[PoliticalGateway]

Columnists Project

Budget: Less than 100 (depends on time and scope of project completed) Bonuses can be given for quality work and fast delivery

Languages: PHP and MySQL

Time: Less than a week

NOTE: This is just a simple user authentication and allow for some data addition in to a table by a user, a small admin section, and no html design..please do not read more into this then is presented.

Summary:

A writer registers on the site and is approved or denied, also an invitation with auto approve that can be sent to an email address, and if denied- deleted, if accepted, then their material is published immediately. After they register, whether they are approved or not, they may add a story, edit their story, add a photo of themselves, and do all functions normal to a 'approved user', just nothing will be shown on site until approved.



User walkthrough

Register

name
email
password and
small comment in a textarea.
"proposed category"


upon submit;
Users account is set up and can function as a normal user, but until approved their writings will remain 'hidden' from surfers/viewers
Email is sent to admin with the comments, name, category,and email of the person.

User is then sent to log in page to log in to their account

Log In

Navigation Menu items; add photo, Add story, Edit story, List stories, edit account information, biography, login, logout

Account information

Ability to change information (email, password, username)
ability to add optimal info, mailing address, phone, different email that viewers will see
They do not have the ability to change category they are in.
Ability to have an 'alias' name and have their name, photo, and email hidden from viewers
Ability to decide what is shown with their articles (alias name, photo, email, phone, address, different email)

Add Photo

only one photo can be uploaded., size limits and Kb limits....settable by me in either admin or actual script code

add story, Edit Story, List Story

Date of Story (I will use a special javascript "calendar"for this textarea)
Title textarea
Summary textarea
Full Story Text Area

Edit page will echo values of story and allow for change/modify and deletion of story

List story page will have a list of stories by date and clicking on a story brings up the 'edit story page'

Biography- simple textarea for 'biography'

Must have a log in and log out button, and a login page with 'forgot password'

Obviously a 'register page' also.

That is basically it for the user...



admin

admin will receive mails from people who are registered and awaiting approval.

admin signs in (logs in as admin) and has a few buttons/pages for him.

1) List users approved

clicking on a user will bring up their account listing their account info and a list of stories. clicking on a story should allow me to modify it, and I should be able to modify the account info also. a button should also be there for 'suspend user' thereby stopping all showing of articles (basically putting them back in to 'waiting for approval')

A special drop box, not included in the users side, is a "category" box. I will select the category they should be in (liberal, conservative, humor, etc) and use this to update and in the approve.

There should be options to "approve" disapprove" and a "suspend user" (disapprove should be set to delete all user info and articles and photos)

Upon approve, disapprove, or suspend, a letter should be sent to the user telling them 'you are in or out'

2) A way to send out a mail to all users

Viewers/Surfers

Viewer enters "column" area

Viewer sees list of columnists, separated by 'category'

Viewer clicks on 'columnist's' name and is shown their recent article with a link to 'past articles'

click on 'view information about this writer' will show 'biography' and contact info the author allows to be printed.

'Past Articles' link brings up a list of articles, by date, with title and summary..clicking on title/summary takes them to view article as above.

Backend

Each time a article is viewed, a counter is added to in the database for that article (this allows the viewer and author to see how many times the article was viewed.)

Optional add-ons

"Rate this article" (1 thru 10, and average the ratings for the article based upon number of votes and rating..)

notes

budget can be lowered or raised depending on time to develop and quality and scope of project.

No html design is really need, just the php includes and any instructions (for things that are a bit different than normal, if any)....basically just plain pages delivered , I will add them to my templates.

database must start with 'pgcomcolumnists'.

rough outline of database...(not complete)
This is for your better understanding of what I desire

table- admin

user/password/ID/adminID

table- columns

colid (incremental) (column ID)
Idist (id of the columnist for which the column is for)
date (supplied by the user when entering the story/column)
Descr (short description/summary of story)
Fulltext - full text of story
count- (number of times viewed)
(optional fields- rataverage, numvotes, totalrate {a surfer will 'rate a story' from 1 to 10, the rataverage is the result of the total of the ratings divided by the number of votes}...this would be done by script on the page viewed.)

table- columnists

IDist (incremental, ID of each columnist)
Username
Password
Name
Email

category
biography
approve
suspend
Photo
allow photo
address
allow address
difemail (use email other than the original contact one)
showdifemail (shows the different email and not the contact one that I use)
Phone number
allow phone (only way to allow phone to show up)
anonymous- (hides name, phone, email, everything from a viewer except the story...)
alias- (name to show up if anonymous)