I’ve been using Stickybits for several months now but with the Holidays right around the corner I’ve found a great new use for it. I have kids and the one thing family members near and far ask is “What do the kids want for Christmas?” Unfortunately at times this can be a touch question since you can walk into a store with the hopes of remembering everything that gets pointed to but end up walking out of the toy store with remembering only a few ideas.

What is Stickybits?
From their FAQ:

Stickybits is a free app that lets you scan barcodes with your iPhone or Android phone. Each barcode has a wall of digital content associated with it, and some have promotions and deals that will be revealed on scan. Stickybits works with all existing barcodes, QR codes, and also custom barcodes.

This little app will scan anything with a barcode and post to your activity wall. When you launch your scanner you get a neat Terminator-like display that you just place over any barcode. If the item has previously been scanned by someone there may be an image attached to it or you can take your own photo and attached it to your scan. The great thing is that everything you scan gets archived to your profile.

Creating Your Shopping List!
We ended up going to the store late in the day and my battery was very low but that didn’t stop me from starting our kids “wanted” list. We went down the isles and when items were chosen (and approved by us parentals) I simply scanned the barcodes with the Stickybits app. Not only do I have a list that I can easily share online but I also have pictures attached so that my sisters know exactly which dinosaur my son wants for Christmas, feel free to view my feed, don’t mind the video games.

Hand a kid the The Great Big Christmas Book Store from Toys R Us and you’ll probably get pages with every toy circled, hand a parent a smartphone with Stickybits installed and you could end up with an smart shopping wish list!

Go ahead and give it a try. Leave a comment with your URL or just follow me on Stickbits!

There may be times when certain comments pass by your WordPress SPAM filter and end up in your pending comments section. You can bulk edit the comments for deletion but that’s usually a page at a time, which is fine for 50-100 pending comments but what happens when you have upwards of 1000 pending comments to delete…or in my friend’s case 5500+ comments. Lucky for us you can mass delete pending WordPress comments with one simple SQL query.

Log into phpMyAdmin
This can usually be done via your hosts control panel. If you have no idea where to find it, just go to your hosts help section and search for phpMyAdmin and follow the instruction of how to launch it. What is phpMyAdmin…well it lets you administer your MySQL servers which contain all of your WordPress information.

Select your WordPress database

Choose your WordPress install’s database. If you only have one database, you are all set. If you have multiple databases there will be a dropdown on the left hand side in which you can choose the database that contains all of the pending comments. The default WordPress install extension for tables is wp_, so when you choose your database on the left hand, your WordPress tables will display on the right. Also some plugins will write to your database, so you may notice some plugins names in the table to the right.

Enter and run your SQL query
The default view of your database is the “Structure” tab, this tab displays all your tables. We need to work in the “SQL” tab so navigate a tab over and you will be presented with a box labelled:
“Run SQL query/queries on database yourdatabasename”

This box is where the magic happens but before proceeding let’s just make sure we are in the correct database. On the left you will see your database name in two places, in the drop-down box as well as underneath the drop-down. On the right side you will also see your database name in two locations, on the very top in the breadcrumb and right above the text box in the heading that reads: “Run SQL query/queries on database yourdatabasename.” Once you are confident that you are in right database, paste the following into the text box.
DELETE FROM wp_comments WHERE comment_approved = ’0′
The above basically means delete all pending comments (comments marked 0) from the wp_comments table.

Once you are all set to run your query, cross your fingers and click go. You may be prompted with a “Are you sure” popup box, just click yes and if all goes well you will be presented with a green highlighted status box that gives you the rundown of your query.

If your query was successful now when you log into your WordPress admin panel you will see that all of your previous pending comments have now been deleted, enjoy!

The Pitch

While established photo sharing sites already exist, Yogile is different because it lets multiple people contribute with ease. Once you create an album, you get a customizable URL and e-mail address to share with anyone who wants to add photos, either as e-mail attachments or uploads through the site. There’s no need for these users to register, keeping the process simple and hassle-free.

Take a wedding, for example. Dozens of attendees take their own photos, all from different cameras and angles. While you might try asking everyone for their shots afterward, Yogile offers a smart alternative.

There are many photo sites out there for where you can upload photos and share the URL with your friends and family but Yogile takes this idea a step further and enables anyone to be able to contribute their pictures to a public or private photo album.

It Works!
You can upload pictures in three ways, via the web, via email or via MMS. The last two options are done via a unique email address which uses the name of your photo album URL. When you upload a photo via email the Subject line is the title of your image while I can only guess that any text in the body of your email would be the image description. Submitting an email via MMS also works wonderfully but any text included in the MMS will not get used at the image title nor for an image description but those can be added/edited via the web. You have the option, as the album creator, to receive notifications of new photos added to your albums and the nice part is that the email comes with image previews which is much better than a new image message with a link to your album.

Personalize It!
After I uploaded images via the web, email and MMS I thought back to the example that Yogile spoke about, a wedding, and how this site could be useful.

Imagine being able to give all your wedding guests an email address and URL and all of your photos would be in one location. No need to have photos spread across multiple sharing sites or going around tagging people so that they would know where to see their pics you have access to one central location for all your pics!! There’s only one issue that I could see…the automatic URL when you first register is just some random characters (mine was yt8colz) and putting this string of characters in print would be rather ugly and telling all your guests these characters would result in no one remembering the email/URL. I thought it would be great if you were able to customize the email/URL and when I went to create a private photo album I learned that you could actually name your own photo album! By being able to name your own album you also end up creating a custom submission email and a custom Yogile URL, perfect!

It Could Break!
When I created my account on Yogile it automatically created an album along with an email that I could use to submit photos to, this album was yt8colz with an email address of yt8colz@yogile.com. When I discovered you could create custom album names I went back and edited the first album that was created with a custom name of GabeDiaz. So my public album could now be found at yogile.com/gabediaz and you can email pics to gabediaz@yogile.com but what happens to yogile.com/yt8colz and yt8colz@yogile.com? Well visiting my original URL yogile.com/yt8colz results in a page not found and sending emails to the original email of yt8colz@yogile.com disappeared into the internet without any bounce-back email…not good.

This issue of renaming your albums could cause issues if an excited user creates an account and starts to send out the email address to all of his/her friends for submissions and then later edits the name of the folder. Can a person’s URL be assigned to someone else or can a person switch back? I’m actually a little surprised that Yogile doesn’t forward or associate your old URL with your custom one.

Overall
Yogile is a site that simplifies group photo sharing and although there could be issues, specifically with the name changing of your own albums, the site works like a charm. Yes there are other sites out there which offer group photo sharing; with one that specifically that comes to mind, Posterous, but Yogile allows you to create an email to share with your group to upload to versus having to add others via their email address’. Think back to the wedding example, it’s much easier to give your wedding guests a single email to submit to versus trying to collect everyone’s email address and then adding them to your photo sharing site. Let’s be honest not everyone wants to register to a new service in order to submit pictures, so the email feature from Yogile is great and I wouldn’t be surprised if something similar gets rolled out to your favorite photo sites or if the Yogile team gets acquired and integrated into a larger photo site.

Participate
As you saw above my submission email is
gabediaz@yogile.com and my public album is yogile.com/gabediaz feel free to submit any pictures!

Disclosure
For anyone who comes across this post I just want to let you know that I was made aware of Yogile and it’s service by one of their team members. The above is my honest opinion upon first using the site. Unless otherwise noted by a Disclosure statement all of my other “First Impressions” are based on products that I personally use or come across.

Have something you want me to look at to share with my readers? My contact information is above and to the right, cheers!

Early last week Chase released an update to their Chase iPhone App in which it rolled out several new features including a QuickPay Service along with being able to deposit checks to your account via your phone. Snapping a pic of your check and depositing it to your account is not ground breaking technology but I believe Chase is the first major US bank to offer it. Lucky for me I have a Chase account and last week I had a check that was sitting in an envelope in my back pocket which needed to be deposited.

In order to deposit a check via the Chase mobile iPhone app is an internet connection and a well lit area, stipulations for depositing via Chase Mobile is that you are only allowed to deposit a maximum of $1000 a day and $3000 a week. The app requires you to choose an account to deposit to, a deposit amount and then to take a picture of your check via the app and once it’s done will display the checks relevant information on your phone. Truthfully it took me 3 times to get this to work as the app wasn’t able to read the check properly.

1st Attempt
My first attempt resulted in the app reading the correct amount to deposit(it verifies the deposit amount) but had issues reading the account number on the check, although it did read the routing number fine. I was asked to type in the routing number in the missing field but I figured I’d try again to see if it was an issue with how I took the photo.

2nd Attempt
My second started out a little differently. The Chase app asks you to take the photo of your check from an overhead position. On my first attempt I did as such but because I was overhead and taking the picture in my office, the lights from the ceiling cast a little bit of a shadow from my head, throw in a slight glare from the fluorescent lights and I now understood why the app couldn’t read all of the information. So for my second shot I moved from underneath the ceiling lights and positioned the phone to an overhead position but made sure to stand aside so that my head didn’t cast any shadow at all. Once the front and back shots were taken the app did it’s magic and tried to read the information on the check. Luckily this time it read the account number and the routing number but it told me it couldn’t verify the deposit amount…the app read the check as having a $0.00 value!! This was not good so I shut down the app and tried again.

3rd Attempt
I knew what I had to do for the 3rd time around. I needed no glare from the lights, no shadow from my head and just to make sure the app read everything correctly I made sure the check was evenly flat, after being in a folded envelope, by doing the drag the check along the corner of your desk trick. I guess there’s a reason they say “third times the charm” because this time the Chase iPhone app worked as expected by verifying and reading the deposit amount, account number and routing number all by the picture taken by my iPhone. Once you have all your information displayed properly on your phone you are able to submit the deposit to your account. You then get taken to a verification screen which acts as your confirmation and since you already in the app you can quickly go to your account and see the status of your deposit.

Total time taken for depositing a check via the app was less than 10 mins although if I hadn’t run into issues would probably have taken 3-5 mins. The total time for the check to clear and get credited to my account was less than 24 hours, not sure if this is the norm but I’m guessing deposit time will vary and it will not be instant availability as it has to be reviewed. After using the Chase Mobile app successfully I can now say that if I ever have a check that falls under the deposit requirements of the app I will definitely think twice about getting into the car and driving to the nearest bank. The hard part for me is over; I deposited a check for $900 via my phone, it was a large amount to use as a test amount and believe me I was scared of something going wrong but in the end it worked out and it saved me around 20 mins by not having to leave the office. So if you’re apprehensive about depositing a check via your phone, don’t be…it actually works.