Time lapse video from your GoPro using Picassa

1. Set the GoPro camera to time interval shots either 2,5,10,30 or 60 seconds

2. Take a bunch of shots

3. Copy the photos to your computer

4. Open Picassa and select the folder with all the photos and select them all by pressing “Ctrl+A”

5. Click on Movie on the lower middle of the screen, change a couple settings on the right side of the screen and then click “Create Movie”

6. And if you did everything right you should be able to make something like this

Coppermine Photo Gallery Hack, Crash and Restore broken album links

Hack: So recently I found out some malicious code was injected into my webpages on www.OHVguide.com, I contacted my host to have them investigate. They fixed the problem removed the code and let me know that the code was inserted through a security whole in my coppermine gallery than I had manually installed year back and tried to keep it up to date as best I could, but admit I was a few versions behind 1.4.x vs 1.5.x I think about 1 1/2 years since I last updated the version.

Crash: Well long story short I downloaded the latest package, unzipped it as directed, backed up my anycontent and include files and made sure not to overwrite them or the albums folder when I uploaded the new files (I’ve upgraded coppermine on both my sites many times) but when I went to the upgrade page this time sql and fatal errors galore, not a big deal I thought i’ll just re-install coppermine though my host since they now offer it as an “easy app” and thought if I installed it into the same folder I wouldn’t have broken links and 404 errors, I was wrong. Got coppermine up and running recreated the albums, batch added all 1334 files, luckily I copied them through my webhost to a root folder so I wouldn’t have to upload them again. Most of my main links worked, but all the specific albums were listing different album numbers as reference some being non-existant even, well this wasn’t going to work I get hundreds of visitors a day and I can’t have broken links on almost 4 dozen pages that I would have to edit each by hand to fix.

Restore broken album links: After searching and searching google to find out out to change the album numbers, which apparently is given out in a numerical order for each album you create in order I couldn’t find anything on it. So I decided to look into editing the the sql php data base. Using phpMyAdmin I opened the database for my coppermine gallery found a table named cpg15x_albums “Used to store albums” I opened it and noticed the AID numbers were all different for each gallery, so one by one I changed the AID numbers to match the album number from the broken links to the right album on my new gallery, This fixed the broken links, but I still had to delete all the files from each gallery because now the photos in the gallery still reflected the old album numbering, but deleting and batch adding is a lot easy to me that updating 50 html pages by hand, took a few hours to do everything but now it all works and I have the updated version on coppermine www.OHVguide.com/gallery

The Morning After

Thought of a new post to post “The Morning After” pictures of the house and the leftovers from the night before from three roommates and a “party” house bottles, cans, glasses, cups, people and trash

morningafter1 The Morning After

Matching background colors on templates with ads

After trying numerous approaches to match the hex color code background color on my AdSense ads, backgrounds or any other color matches I finally figured out an easier way than looking through lines and lines of php code on the templates or guessing the 6 digit hex code with color swatches.

1. Printscreen or screenshot the color you are trying to identify or match

2. Open up Photoshop or another similar program and paste the screenshot into a new file, using the programs color picker or “eye dropper” on Photoshops tools, select the mystery color you are trying to match and in the detailed view you can get the 6 digit hex color code.

It may sound to simple to explain, and easy for most but hopeful if this small amount of information helps one person that’s all that matters

6 digit hex color code Matching background colors on templates with ads

Sample of hex color code chart

How To Be Happier

Are you getting too stressed out? Here are a few easy things you can do to make you life much happier. Number 9 seems to be the one to do. What do you think?

1: Make daily lists/updates of short-term and long-term goal

2: Plan out your meals for the week

3: Schedule your vacations two months in advance

4: Plan out your social activities four days in advance

5: Try one new hobby every three months 6: Take a nap

7: Unplug to relax

8: Get sunlight every day

9: Have regular sex

10: Treat exercise as a non-negotiable

WordPress SEO fine-tune by Meta SEO Pack from Poradnik Webmastera