Ran To / From the Gym Today

I tried something new today & ran to and from the gym, doing my workout in-between. I have to say it’s not something I plan on doing again anytime soon.


View Larger Map

Now it was nice burning an extra 435 calories, but I was a mess during class. Maybe I’ll carry my hand towel with me next time. Look at that, I’m already talking about next time. I didn’t like it, but the extra calories burned make it worth it.

Indoor Rock Climbing

Last night Laura, Jason and I went rock climbing last night w/ my gym buddies at the Niagara Climbing Center in N. Tonawanda, which I haven’t been to in 10-11 years. Boy, have they changed things.

Last time I was there you’d have to tie in each time, get it inspected, and your belayer would have to actually work to keep you up. Now you just quickly clip in and the belayer has a safety latch to keep you from falling to your death (or, at least from getting hurt). That gave us a lot more time to climb, instead of goofing around w/ strapping in.

I wasn’t too fond of being up so high - I have to get over that. There were a couple climbs I just couldn’t do because of the lack of places to grab onto. But, overall, I was quite happy w/ how I did. Jason was a maniac, flying up the walls (and sometimes flying off of them!).

Both Jason and Laura want to go back, and since it’s pretty cheap ($10 all day pass, $2 harness rental) I’m sure we’ll be going back soon.

Garden Week 4-1/2

OK, so I haven’t posted about the garden in a while. Things haven’t been too exciting, but they’re now beginning to get interesting.

Some of the plants were just massive, so I moved them outside. Then I kept going. So the pumpkins, zucchini, spinach, tomatoes, green peppers, and some lettuce are now outside. The spinach actually looks tasty, and I may steal a few leaves soon.

Oh, and Becca’s sunflowers are now 13″ tall - well on their way to their 12′ expected height!

iFrame a Link & Still Track Conversions

@IamJustinM asked the other day

Is it even possible to track visitors and conversions when you have the landing page in an iframe??? Can’t figure it out….

I gave a quick answer, “at top of iframe page, write tracking data to db, then get unique id and use that as your sid w/ the network” but wanted to show it a bit more in detail. So I took 5 minutes I whipped up this quick script:


<?php
    
// http://yourdomain.com/iframe.php?cSource=google&q=my+keyword

    mysql_connect(’server’, ‘username’, ‘password’);
    
mysql_select_db(‘databasename’);

    $cTable = ‘iframetrack’;
    
/*
    CREATE TABLE `iframetrack` (
        `nID` INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY ,
        `cSource` VARCHAR( 20 ) NOT NULL ,
        `cKeyword` VARCHAR( 200 ) NOT NULL ,
        `cBrowser` VARCHAR( 200 ) NOT NULL ,
        `nIP` VARCHAR( 16 ) NOT NULL ,
        `tsDatetime` DATETIME NOT NULL
    ) ENGINE = MYISAM ;
    */

    if (empty($_GET['q'])) {

        list(, $cRefererQS) = explode(‘?’, $_SERVER['HTTP_REFERER'], 2);
        
parse_str($cRefererQS, $_RefererGET);

        $_GET['q'] = $_RefererGET['q'];
    }
// ends if (empty($_GET['q']))

    $cQuery = “insert into $cTable (cSource, cKeyword, cBrowser, nIP, tsDatetime) values (’” . mysql_real_escape_string(stripslashes($_GET['cSource'])) . “‘, ‘” . mysql_real_escape_string(stripslashes($_GET['q'])) . “‘, ‘” . mysql_real_escape_string(stripslashes($_SERVER['HTTP_USER_AGENT'])) . “‘, ‘” . mysql_real_escape_string(stripslashes($_SERVER['REMOTE_ADDR'])) . “‘, now())”;

    mysql_query($cQuery);
    
$nID = mysql_insert_id();

    $cAffLink = ‘http://www.cpaclicks.com/redirect.asp?a=2429&b=27673&d=0&l=0&o=’ . $nID . ‘&p=0′;

?><!DOCTYPE HTML PUBLIC “-//W3C//DTD HTML 4.01 Transitional//EN”>
<html lang=”UTF-8″>
<head>
<title>Title</title>
<meta http-equiv=”Content-Type” content=”text/html; charset=UTF-8″ />
<meta http-equiv=”Content-Language” content=”UTF-8″ />
</head>

<body style=”padding:0px; margin:0px;”>
    <iframe name=”mainsp” id=”mainsp” src=”<?= $cAffLink ?>” width=”100%” height=”100%” scrolling=”auto” frameborder=”0″>
          <p><a href=”<?= $cAffLink ?>“>Click to continue.</a></p>
      </iframe>
</body>

</html>

Now it’s probably not perfect, but it gives you a way to track this info. When you link to this iframe, set cSource to the source of the visitor (can be just the source, or source & ad number combined - whatever) and (optionally) set “q” to the keyword. If you omit this, it’ll look at “q” from the HTTP_REFERER, which is what most search engines use for the keyword field.

I’m not going to go into detail on how to change things - if you need help, just ask.

PS - Sorry about the funky quotes - WordPress is being “smart”. Find / replace to fix it.