Dogsitting
May 29, 2008 // Comments are Closed
Mom dropped off Echo last night, and I’m happy to say Scout & Echo are getting along great!
It took a while for both of them to take 3 seconds & sit down for a photo. Echo is the tiny one on the left; Scout is the big fat one on the right.
The morning workout. This went on for about 10 minutes.
Every morning I get a cup of coffee & shout, “Let’s go to work!” and Scout runs upstairs as fast as she can. Today I’ve got both of them up here with me. Lots of panting going on behind me. Hopefully they’ll calm down & take a nap soon.
This entry was posted by Eric on Thursday, May 29th, 2008 at 9:45 am and is filed under Uncategorized. You can follow any responses to this entry through the RSS 2.0 feed. Both comments and pings are currently closed.
iFrame a Link & Still Track Conversions
May 3, 2008 // Comments are Closed
@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.
This entry was posted by Eric on Saturday, May 3rd, 2008 at 3:35 pm and is filed under Affiliate Marketing, Uncategorized. You can follow any responses to this entry through the RSS 2.0 feed. Both comments and pings are currently closed.
WordPress Comment Blacklist
April 15, 2008 // Comments are Closed
Even though I have Akismet’s spam filter (Akismet has stopped 26,324 comments so far) and reCAPTCHA installed, I as still getting lots of comment spam on my blog. So I use the Comment Blacklist in WordPress (Settings > Discussion) and automatically block many comments from certain IPs or with certain keywords in them:
payday loan
casino
poker
ringtones
homeowners insurance
term insurance quote
life insurance
accident insurance
casualty insurance
phentermine
porn
cialis
p***y
c**k
car insurance
auto insurance
health insurance
Viagra
61.133.87.226
216.195.53.11
70.86.141.82
87.101.244.6
87.101.244.9
222.82.226.145
80.227.1.100
80.227.1.101
217.141.105.203
206.245.173.42
64.22.110.34
64.22.110.2
207.41.73.13
222.240.212.3
218.63.252.219
210.212.228.7
202.115.130.23
220.178.98.59
216.213.199.53
210.22.158.132
194.68.238.7
222.127.228.5
148.233.159.58
74.53.227.178
222.221.6.144
217.141.109.205
196.207.40.213
80.231.198.77
200.68.73.193
83.136.195.229
64.22.107.90
86.96.226.13
86.96.226.15
86.96.226.14
196.207.15.201
221.122.43.124
88.147.165.40
219.209.194.156
217.65.31.167
201.234.19.13
74.86.121.13
200.65.127.161
125.47.41.166
217.141.250.204
201.210.1.148
195.250.160.37
24.222.34.242
200.51.41.29
189.4.80.48
213.239.210.120
196.217.249.190
217.141.249.203
72.34.55.196
195.244.128.237
88.198.107.250
165.29.58.126
189.19.60.94
58.68.34.59
85.13.219.98
217.141.106.201
I cleaned up a couple of the words because my Mom reads this blog, but if you’re having trouble with comment spam, try using this list, and add your own as you see the spammers sneak in.
This entry was posted by Eric on Tuesday, April 15th, 2008 at 6:28 pm and is filed under Uncategorized. You can follow any responses to this entry through the RSS 2.0 feed. Both comments and pings are currently closed.
Panaro’s
April 10, 2008 // Comments are Closed
Steve and I got together for lunch yesterday, after I ran a bunch of errands and before I sat around in a county building for 3+ hours just to be rescheduled for next month. Well played. I hope you enjoy the guests coming your way.
Anyway, Steve and I ate at Panaro’s, a restaurant on Delaware that Steve’s good friend Mike owns. Steve’s always bugging me to come his way for lunch, so since I was heading down there, we decided to meet up.
We must have looked a little odd ordering the exact same thing; funny how that works out. At least I ordered first 
Of course, we started with a cup of Pasta Fagioli. Then we each got their Mandarin Walnut Salad:
Mesculin Greens tossed with mandarin orange wedges, toasted walnuts, dried cranberries, red onion, and topped with orange raspberry vinaigrette dressing
Yum!
So besides the great food and helping a friend, why am I telling you about Panaro’s? Because they use Twitter to send out daily updates about their specials. Follow them at http://twitter.com/Panaros. After seeing those daily specials come across each morning, eventually you’ll cave in (like I did) and visit Panaro’s.
This entry was posted by Eric on Thursday, April 10th, 2008 at 1:52 pm and is filed under Uncategorized. You can follow any responses to this entry through the RSS 2.0 feed. Both comments and pings are currently closed.
Endorsements Add Snow to a Snowball
January 31, 2008 // 2 Comments
Funny thing about politics lately are the endorsements coming in. The Kennedy’s are endorsing Obama, Guliani is endorsing McCain. I’m sure there are others, and more to come.
Endorsements are like the nail in the coffin for the other candidates. Why? Because nobody wants to support a loser, so they wait until their adviser tells them who will win, then they endorse that person (whether they believe in him/her or not).
That endorsement swings voters, making the candidate even stronger. Then other politicians, unions, etc. endorse the candidate, bringing in more voters to his/her side. The snowball continues to grow. And when those candidates win, the endorsers look enlightened to the general public and are sure to receive perks from the winners.
I thought Levitt & Dubner wrote about this in Freakonomics, but can’t find a reference now.
Looks like McCain & Obama will be going head to head in November. The question is, who’s going to be their running-mates?
This entry was posted by Eric on Thursday, January 31st, 2008 at 1:03 pm and is filed under Uncategorized. You can follow any responses to this entry through the RSS 2.0 feed. Both comments and pings are currently closed.
I’ll Wait for the Book
January 24, 2008 // Comments are Closed
I’ve been hearing a lot about Cloverfield lately, but I just heard on CNN that it’s causing some people to experience vertigo. Well, cross that one off the list of movies I’d like to see. Heck, I was feeling sick just watching the CNN news report.
BTW - Cloverfield was produced by J. J. Abrams of Lost fame. Lost Season 4 starts in just 1 week (woot!)
This entry was posted by Eric on Thursday, January 24th, 2008 at 4:02 pm and is filed under Uncategorized. You can follow any responses to this entry through the RSS 2.0 feed. Both comments and pings are currently closed.
