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.

Sheesh, it’s already been almost three weeks since my last post.  Good thing no one reads this thing.

Anyway, a slew of updates for qrisper.com.

• totally redesigned the layout…well, not really.  Just got rid of the image tabs and combined the center columns.  I spent so much time making those tabs though…oh well.  I’ve been meaning to get rid of them…just couldn’t get myself to do it.  I think the site looks cleaner and more open.
• also changed the content, design and navigation of the logged in pages.  The question page contains one question and a bunch of your recently answered questions.  Still trying to add the answers of the people you follow.  I’m basically ripping off Twitter.  But hey, whatever works right?
• added a feedback tab to give it more of a presence.  Hopefully, users will hear the feedback tab beckoning for feedback and do its bidding.
• fixed the user thumbnail uploader.  So you can upload pictures of yourselves into qrisper.  Hooray!  Problem was that I was trying to insert the image path into a mySQL table when I should have been updating the table.  Duh.
• built out the account settings page.  Now you can update your info, password and profile pic.  Still working on the functionality that will autopost your answers to Twitter.
• built out the find and follow people page.
• added the timestamp of when you answered the question.  That was one major pain in the ass.  Could not for the life of me figure out the proper syntax for the mySQL query.
• last but not least, I create profile pages for each user.  Whereas before you could only see your own activity, you can now peruse other users’ answers and questions.  Much easier than I had expected.

With all of that accomplished, I felt pretty good for like a minute.  But there’s still so much that I need to do.  I want to integrate Facebook Connect and create a FB page for qrisper.  Need to get the Twitter post working.  Also need to add a few more navigational features and content.  But I finally feel like I’m getting close to an official launch.  Been thinking long and hard about how to approach that.  Just gotta do it I guess.