Jump to content


Photo

Being able to moderate submitted entries?


  • Please log in to reply
5 replies to this topic

#1 Solarpitch

Solarpitch
  • Members
  • PipPipPip
  • Advanced Member
  • 708 posts
  • LocationDublin, Ireland

Posted 17 October 2006 - 07:37 PM

Hey guys,

I am developing a site that involves user's being able to submit information in the form of an advertisment of a product they want to sell.

After the user submits the add I want to be able to moderate all the submitted adds before they get updated in the database!

I've thought hard about this but I'am not quite sure where to start, or even how it would be implemented!

I'd love some advice, Ger.
Welcome to 9AM Monday, the furthest point away from 5PM Friday.

#2 hostfreak

hostfreak
  • Members
  • PipPipPip
  • Advanced Member
  • 581 posts

Posted 17 October 2006 - 08:05 PM

I think the best way to go about it would to create another table that contains all the fields that the main table has (the ones you require). Once a user submits something, insert it into the "pending" table. You could then make a page that calls all entries from that table.

Then make another page that allows you to approve or deny etc. If you approve, it will add it to the main table and delete it from the "pending" table. Or if you deny, maybe add in a feature that will have it send a message to them that asks them to contact you for further questioning.

#3 LazyJones

LazyJones
  • Members
  • PipPipPip
  • Advanced Member
  • 78 posts

Posted 17 October 2006 - 08:07 PM

Or (to save some resources) have a validation field in the table (simple boolean value. 0 for not validated, 1 for validated). Then you could list all not validated adds and update the validation values for those you want.

#4 hostfreak

hostfreak
  • Members
  • PipPipPip
  • Advanced Member
  • 581 posts

Posted 17 October 2006 - 08:09 PM

^ah didn't even think about that. Good idea.

#5 Solarpitch

Solarpitch
  • Members
  • PipPipPip
  • Advanced Member
  • 708 posts
  • LocationDublin, Ireland

Posted 17 October 2006 - 08:11 PM

Thanks guys! I cant believe i didnt think of that . . . so simple! Sometimes the answer is right under yout nose! :)

Cheers!
Welcome to 9AM Monday, the furthest point away from 5PM Friday.

#6 Solarpitch

Solarpitch
  • Members
  • PipPipPip
  • Advanced Member
  • 708 posts
  • LocationDublin, Ireland

Posted 17 October 2006 - 09:48 PM

Yup . . I just implemented that and it worked great! Thanks LazyJones . . the validation option was very clever!
Welcome to 9AM Monday, the furthest point away from 5PM Friday.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users