Database is loaded with test data
Image filenames are fetched from database
Hard coded violations (text and links) and location types
Unavailable functions are struck-through
"Who are we?" page online
Queries operational
Dealing with PHP's mysql_*() brutality
Display page works as expected
Comments online
Location types online (Commercial, Municipal, State/Federal, Other)
Primary query now uses JOIN, dropping queries from four to three
Added active entry detection to display and image scripts
More table ALTERations to match application needs
Flag user information now pulled in two queries one query (using multiple JOINs) per page rather than two per flag
Logins and logouts working
Meta-moderation (flagging) working
ORDER BY FlagID DESC (show newest entry first)
It *IS* possible for meta-moderating to cause a blank home page :)
Display (home) page now done in ONE SINGLE query!
User permissions: flagmod, usermod, dba(ooh!), flagdel, userdel, and all
mysql_db_query() is deprecated, use mysql_select_db() and mysql_query() instead
Upload new picture (OH MY GOD this took six hours!!)
Display page and logout clean up after aborted submissions
Upload page now transactionalized to make it safe for concurrency
Flag moderation functions working
Queries condensed where bummage is recognizable and practical
READY TO TURN IN!
Formatted queries shown to dba users for readability(regex in PHP a bitch)
A few layout changes, header implementation
Put a note about logins versus unencrypted WiFi
Comment killer problem in upload form found and executed
Project graded 100%! Looking forward to some R&R
Display page pagination (new variables, and LIMIT/OFFSET in query)
Upload script now using ImageCopyResampled() instead of ImageCopyResized() for better quality
Images output to the browser are currently manipulated real-time, adding the watermark and time stamp

Playing with watermarks and time stamps, and use of EXIF for photo info and thumbnails
Will include PEL library for EXIF manipulations
Flag owner correction link
Allow moderators to change certain information before accepting an entry
Entry submitters may make changes to owned entries, but not meta-mod them
User moderation functions
Moderator "remove" and "resubmit" functions on display page
Searchable locations
New user application
Object (flag/user) modification
Forgot login and reset password functions
Logins are not logged

Transaction table to store actions, timestamps, and comments
Expand user table dates to timestamps
User profile, resubmission pages
Photo replacement option
Entry locks: meta-moderation, remove, resubmit
Site search, sorting
GPS coordinates
More OO-style programming
Clean-up sloppy code
Thumbnail images in-line with HTML
Thumbnail images stored inside full-size JPEG as IFD1 (EXIF thumbnail)