Overheard At Four Rivers

Quote board I built for my high school on benvirgilio.com. Submit overheard quotes, vote, flag, search, admin approval queue. PHP/MySQL.

So I built a quote submission board on nebriv.com called “Overheard At Four Rivers” (my high school). People could submit overheard quotes, vote them up or down, flag inappropriate ones, search, all that. I also built a full admin panel with an approval queue, quote editing, IP banning with expiration dates, and page view counters. Database was frcsquotedb on mysql.nebriv.com. Wish I could find that database now, but it’s probably… for the best that its gone! Who knows what kind of goldmine that would be for my peers, right?

Some Recovery notes:

Features: quote submission with optional context (when, where, who), upvote/downvote rating, moderation queue (approved/unapproved), search/sort by ID/date/rating/info, flagging system, IP banning with expiration, hit counter
Admin panel at /admin/, password-protected via cookie hash, view/edit/approve quotes, block IPs, change password
Database frcsquotedb on Dreamhost mysql.nebriv.com; data is lost, never migrated off Dreamhost apaprently.
Uses deprecated mysql_* PHP functions, has SQL injection vulnerabilities (educational artifact)