news/reviews submission engine

[vfx]

hi. do you guys know any php script that allows users to submit news and reviews. or movie/music php database driven.

there is a script called phpnuke or the similar advanced web managment can do those stuff. but they are not cuztomized the way i like. (left, middle, right column and those home, dl buttons, etc)

Any help would be very appreciated.

Thank you so much!

vfx

[michaelk]

i'd recommend using a "review" bitswitch and having forms that add to the database that anyone can use, which can be basic.

the bitswitch would be a column called 'review'. it would be a 1 or yes (it has been reviewed) or 0 (no, it has not.)

after the user has submitted the review, that record in the table would have the column 'review' set at 0. in a simple admin form, that only authorized users can use, you can have your database select all records that are not yet reviewed by the staff. after viewing the record and it's contents you can either delete the record, or resubmit the information, if it's acceptable, using UPDATE and setting the review to be 1. now, on your site, you will be able to show all the current information to the users by changing your SQL to WHERE review = 1, to only get the records that you have looked over and accepted.