Woo!  Two major accomplishments, both for qrisper and myself.

I finally figured out how to post qrisper answers to Twitter.  Users now have the option to auto-post all of their qrisper answers onto Twitter.  A small step for some but a giant leap for Jungkind.

Also finally figured out the correct MySQL query that displays on your question page your submitted answers plus the answers that your followees submitted.  The key piece that I was missing…parentheses.  Blerg.  Think I need to more schooling on PHP and MySQL.

My next intended major tasks were going to be a qrisper app on Facebook and learning how to use Amazon Web Services.  However, I decided that I had nothing compelling to offer Facebook at the moment.  So that has been pushed back.  As for AWS, I’ve discovered that implementing qrisper in the cloud might be a tad complex for me at the moment.  Going to need a systems engineer to manage that for me.

Here are some additional updates:

• minor tweaks to the follow/do not follow functionality
• added a list of newly suggested questions into the suggest question page (for registered users)
• updated my php version of the sitemap but removed that page althogether and am now using an xml version
• with all of recent redesigns to the current layout, I had neglected the admin pages.  Those pages are now macking the new look
• added a list view for skipped questions (in addition to the current top ten view)

I also fixed the category navigation in the splash page so that clicking on a specific category will keep you in that category question pool.

I had been getting some comments that the color scheme in qrisper was a bit noisy.  It might simply be personal taste (I like loud, bright colors) but I decided to tone it down a notch.  The one thing I cannot back down from is the yellow background.  I’ve tried different colors but so far haven’t been able to find one that maintains the qrisper vibe.  Think the new creamier yellow looks pretty good.

I’ve been mostly in planning and thought mode for the past two weeks.  But here are a few updates.

• added a new image uploader for user profile thumbnails.  The upload process works but still having issues with updating the mySQL table with the image path.  Still a work in progress…
• created a new account settings page where users can manage their info, password and profile pic.
• created a user-follow functionality that will allow users to follow other people and their answers.  The following functionality works but still having issues with displaying friends’ answers in the users’ question page.  Still a work in progress…
• created a new find page for searching other users and to keep track of followers and followings
• there’s a new recent tab in the main homepage where users can now see the most recent answers as well as the most recent suggested questions

I also have a new forum in progress but still debating whether or not I need such a heavy platform.  Thinking about setting up a Twitter account to keep track of feedback and questions.  Also looking into Get Satisfaction…though I really don’t like their feedback tab on the side of the screen.

I’ve also been testing out Twitterfeed and other similar services to figure out how I can let users tweet qrisper answers to Twitter.  Still working on that.  And finally, being the optimist that I am, I’ve been researching AWS because I’m certain that qrisper will have a massive spike in usage with the next 10 years.  Have to be prepared for that eventuality.