Greenguy's Board - View Single Post - Anybody know of a script that checks what LLs are linking to a freesite?

Halfdeck · 2005-08-23, 02:04 AM

I used to have a small php script on my free site index that tracked hits. I have a MYSQL db entry for all the major LLs, their domain urls, etc. And another table for free sites I've submitted. Tracking hits for a LL was pretty straight forward. Get referer info $_SERVER['HTTP_REFERER'], pull the base domain using parse_url() I think, and then do a MYSQL update using the index url $_SERVER['REQUEST_URI'] and the LL domain name. Each hit would increment the hit count by 1.

Of course, if a site got unlisted, then the script wouldn't realize it. Probably the best way is to timestamp every incoming hit or restart the counter at the start of every month.

If you wanted to parse the LL pages, then like you said, the LL's with multiple pages would cause problems. One possible solution is for the script to look up google using "site:LL.com "yourfreesitetitle" and then parse the resulting page for your site url, but that's assuming its been listed long enough for the page to get crawled, and other variables, like mutlie google results. Sounds like overkill to me.

Checking for incoming hits seems to me like the easiest solution.

2005-08-23, 02:04 AM	#3
Halfdeck You can now put whatever you want in this space :) Join Date: Oct 2004 Location: New Haven, CT Posts: 985	I used to have a small php script on my free site index that tracked hits. I have a MYSQL db entry for all the major LLs, their domain urls, etc. And another table for free sites I've submitted. Tracking hits for a LL was pretty straight forward. Get referer info $_SERVER['HTTP_REFERER'], pull the base domain using parse_url() I think, and then do a MYSQL update using the index url $_SERVER['REQUEST_URI'] and the LL domain name. Each hit would increment the hit count by 1. Of course, if a site got unlisted, then the script wouldn't realize it. Probably the best way is to timestamp every incoming hit or restart the counter at the start of every month. If you wanted to parse the LL pages, then like you said, the LL's with multiple pages would cause problems. One possible solution is for the script to look up google using "site:LL.com "yourfreesitetitle" and then parse the resulting page for your site url, but that's assuming its been listed long enough for the page to get crawled, and other variables, like mutlie google results. Sounds like overkill to me. Checking for incoming hits seems to me like the easiest solution. __________________ Success is going from failure to failure without a loss of enthusiasm.