MS_Analysis little trick

Worker Joined: Nov 22, 2004 Posts: 208 Location: Italy

I used this one for a while to save database space
This hack will use sentinel's ip2country table instead of the native for MS_analysis. save 60,000 duplicate records.
in file mstrack.php

locate

Code:




      // Determine Domain


      $result = $db->sql_query( "select c2code from ".$prefix."_msanalysis_iplookup WHERE inet_aton('$MSAdata[real_ip]') >= ip_from AND inet_aton('$MSAdata[real_ip]') <= ip_to" );

replace with

Code:




// Determine Domain


$result = $db->sql_query( "select c2c from $prefix"._nsnst_ip2country." WHERE inet_aton('$MSAdata[real_ip]') >= ip_lo AND inet_aton('$MSAdata[real_ip]') <= ip_hi" );

This was already on Maty's script forum, but it is currently down, so i reposted it here.
Ciao, Guido

Posted: Wed Apr 26, 2006 6:36 am

Excellent hack! Thank you for sharing this over here.

Posted: Wed Apr 26, 2006 10:10 am

Smart

Wanted to make sure I wasn't behind on IP countries tables either. Maybe just set the Sentinel ones for all scripts I am planning

Posted: Wed Apr 26, 2006 11:23 am

MSA countries table store much more infos than Sentinel, but it's is much smaller than ip2c. I left it alone...