User tracking mod

[gilby]

The source found reports to update every week, so yes the current DAT file is WAY out-of-date.

Will also continue to consider how better to provide the package and associated changes.

If you are updating the GeoIP.dat file, you have to also get the latest geoip.inc file to access it correctly.

[mc12345678]

If you are updating the GeoIP.dat file, you have to also get the latest geoip.inc file to access it correctly.

I'm a little curious about the above statement, and of course welcome input. I decided to try to incorporate the latest GeoIP.dat file into my active site. I renamed the previous file (kept the extension, though haven't looked to see what the effect of that is), and added the new file. It appears to me (right or wrong) that the file is successfully being used to report accurate locations.

Now I haven't looked to see what happens in the display of information if an "error" comes up in the search/presentation of the information, but I was previously seeing host names that in no way matched the flag/country identified. Now that I have loaded the newer file, I have gone back to ping addresses that show up as international and they have the correct association of country to IP address... I've been toying with the idea of transitioning to GeoIP2; however, am having to interpret the guidance provided and see if the available IPN like information can be condensed down to a ZC specific implementation removing extraneous files and code.

Is this something that you have implemented/toyed with and could provide some insight into?

[gilby]

I'm a little curious about the above statement, and of course welcome input. I decided to try to incorporate the latest GeoIP.dat file into my active site. I renamed the previous file (kept the extension, though haven't looked to see what the effect of that is), and added the new file. It appears to me (right or wrong) that the file is successfully being used to report accurate locations.

Now I haven't looked to see what happens in the display of information if an "error" comes up in the search/presentation of the information, but I was previously seeing host names that in no way matched the flag/country identified. Now that I have loaded the newer file, I have gone back to ping addresses that show up as international and they have the correct association of country to IP address... I've been toying with the idea of transitioning to GeoIP2; however, am having to interpret the guidance provided and see if the available IPN like information can be condensed down to a ZC specific implementation removing extraneous files and code.

Is this something that you have implemented/toyed with and could provide some insight into?

If you compare the older to the most recent version of geoip.inc you will see that they have switched a couple of names around (the older version was wrong) and have added approx 4 new countries.

Of more interest is they have edited the names of quite a few of the countries to their current proper names.

Also support has been added for ipv6

In practical terms, if you only deal with the major english speaking or european countries you probably won't see much difference in using either.

[mc12345678]

If you compare the older to the most recent version of geoip.inc you will see that they have switched a couple of names around (the older version was wrong) and have added approx 4 new countries.

Of more interest is they have edited the names of quite a few of the countries to their current proper names.

Also support has been added for ipv6

In practical terms, if you only deal with the major english speaking or european countries you probably won't see much difference in using either.

Well, the only way I see that I can "look" at the older and newer geoip.inc, is to pay for the newer one. (At least as it looked to me.) I didn't see where it was possible to obtain a newer .inc (interpreter) file.

Now, yes the geoip2 data definitely needs a new inc file in order to properly capture/identify the data.

[gilby]

Here's one here that I googled that's about 12 months old
geoip.inc

There is one from about May this year but I can't find it quickly

[mc12345678]

Here's one here that I googled that's about 12 months old
geoip.inc

There is one from about May this year but I can't find it quickly

Well, imagine all that. I could have sworn that I looked for that last week... It's even simpler... It's on github... and only a month old.. :)

https://github.com/maxmind/geoip-api...ree/master/src

[BlessIsaacola]

Here is my latest error:

[28-Nov-2013 23:43:25 America/New_York] PHP Fatal error: 1064:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 's%20Science%20Club%20Microscope%20and%20Journal', 'Educational Insights Nancy B\' at line 1 :: insert into user_tracking (customer_id, full_name, session_id, ip_address, time_entry, time_last_click, last_page_url, referer_url, page_desc, customers_host_address) values ('0', 'Guest', 'fb6d3871016ffbebde95586b802f0414', '24.236.229.133', '1385700205', '1385700205', '/index.php?main_page=product_info&products_id=86402&gclid=CMaL_cSXibsCFclcMgod1Eg Apg', 'http://www.google.com/aclk?sa=l&ai=Cyn7UaBuYUtPBHIm2-QOijoGwAZ6CsMYD_sil-0HugcP8xQEIBhAHILlUKAhQ3K-m6P##########_AWDJ1qyJkKSIEKAB1Mar_QPIAQeqBCZP0Cblz5bDyrb-EQlFVMnZDBH2UaHp-4bpeMgbY-bt0Hxgh8aBL4AFkE7ABQWgBiaAB5S51AKQBwHgEqahzP2QlLS2Jw&sig=AOD64_1_SNzCkGTlRdatFOv qeL5RNJzEBw&ctype=5&ved=0CLsBELsX&adurl=http://www.clevershoppers.com/index.php%3Fmain_page%3Dproduct_info%26products_id%3D86402&rct=j&q=Nancy%20B's%2 0Science%20Club%20Microscope%20and%20Journal', 'Educational Insights Nancy B\'s Science Club Microscope and Act', 'OFFICE_IP_TO_HOST_ADDRESS') in /includes/classes/db/mysql/query_factory.php on line 120