Overheard At Four Rivers

Just going back through my backups and archives I found something fun. I used (and still do!) to love to build little services and solutions for friends. In the IRC days there was always a fun “quote” database lingering around the servers I frequently. You’d could quote people in… or out… of context, have a laugh, remember important bits, etc.

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)