organizing database

This is for [login to view URL] -organize it to the format I gave you. (the template I attached to you from the last email) -facebook, twitter, and print links – printing posts, sharing post links, am I right? -no repost (craigslist does not allow users to repost similar post within the 7day AD) - how the tracking of posting something similar should work? I need some ideas here -make sure the site posting works, but need a confirmation email for the userto finish the posting process – ok. so until user verifies, the post is on hold. it should have a auto-delete options for posts which are not verified through emails to save space in hosting. -make sure that when the user clicks on a category (on the "search template" page), posts for that category will show up. (similar to craigslist) ok -on the homepage, when selecting a different city, it stay on the same page, but will now search in that particular city location. ok -"add picture option" for the post. ok - add a camera icon for posts that has pictures ok -For Posting. add a photo upload option (up to 4 pictures) if possible, shrink photo quality so it can save memory