Shamil Salakhetdinov
shamil at users.mns.ru
Fri Feb 10 03:21:54 CST 2006
Rocky, Internet servers are usually able to keep raw logs of HTTP requests - these are seperate ASCII files and their records are well formatted and look like the sample log records from my site's today HTTP requests log in the P.S. of this message. I did plan for quite some time to write code to parse these records and to put them into database for further analysis but I didn't have good reasons to that for myself. Now, if nobody here will point on a ready to use solution then we can write, test and use such TCP/IP log parser together and when well done make it available on AccessD site for download... How about this idea? I can write some code for starters on weekend... Shamil P.S. HTTP requests sample log: 139.18.2.214 - - [10/Feb/2006:00:04:09 +0300] "GET /robots.txt HTTP/1.1" 404 297 "-" "findlinks/1.1.1-a1 (+http://wortschatz.uni-leipzig.de/findlinks/)" 70.85.193.178 - - [10/Feb/2006:00:05:57 +0300] "HEAD /shamil_s HTTP/1.1" 301 - "-" "LWP::Simple/5.803" 70.85.193.178 - - [10/Feb/2006:00:06:00 +0300] "HEAD /shamil_s/ HTTP/1.1" 200 - "-" "LWP::Simple/5.803" 70.85.193.178 - - [10/Feb/2006:00:06:03 +0300] "GET /shamil_s HTTP/1.1" 301 334 "http://www.jaja-jak-globusy.com/" "Poirot" ... 70.78.74.47 - - [10/Feb/2006:05:33:36 +0300] "GET /shamil_s/pics/clearday.jpg HTTP/1.1" 200 5675 "http://smsconsulting.spb.ru/shamil_s/" "Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322)" 70.78.74.47 - - [10/Feb/2006:05:33:36 +0300] "GET /shamil_s/pics/pole2.gif HTTP/1.1" 200 226 "http://smsconsulting.spb.ru/shamil_s/" "Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322)" ... 68.142.249.46 - - [10/Feb/2006:11:31:19 +0300] "GET /robots.txt HTTP/1.0" 404 297 "-" "Mozilla/5.0 (compatible; Yahoo! Slurp; http://help.yahoo.com/help/us/ysearch/slurp)" 68.142.251.104 - - [10/Feb/2006:11:31:20 +0300] "GET /.net/tutorials/vb.net/ncm.htm HTTP/1.0" 200 37707 "-" "Mozilla/5.0 (compatible; Yahoo! Slurp; http://help.yahoo.com/help/us/ysearch/slurp)" 68.142.250.147 - - [10/Feb/2006:11:34:21 +0300] "GET /shamil_s/topics/tstmodex.htm HTTP/1.0" 200 3088 "-" "Mozilla/5.0 (compatible; Yahoo! Slurp; http://help.yahoo.com/help/us/ysearch/slurp)" ... ----- Original Message ----- From: "Rocky Smolin - Beach Access Software" <bchacc at san.rr.com> To: "Access Developers discussion and problem solving" <accessd at databaseadvisors.com> Sent: Friday, February 10, 2006 9:53 AM Subject: [AccessD] OT: Affiliate Program > Dear List: > > I have a web site where we are selling The Sleep Advisor > (www.thesleepadvisor.com). Someone with an alternative health site has > proposed to promote The Sleep Advisor on her site and send folks to our > site. She asks if we have an affiliate program. Which we ain't. > > I looked into it a bit and it doesn't look trivial. Basically we need a > way to know if someone visiting our site and buying The Sleep Advisor > originated from her site. We're hosted by Affinity and have Urchin > statistics but I don't see anything there that would be helpful right off. > > Does anyone know a slick, quick way to do this? > > MTIA > > Rocky > > -- > Rocky Smolin > Beach Access Software > 858-259-4334 > www.e-z-mrp.com > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com