Geoip accuracy

[Arta]

There is a small problem with the accuracy of tracking emails sent to Yahoo.

It seems that Yahoo requires and serve images from its IP. In these circumstances, more then half of the readings seems to come from a foreign location (in the case Ireland, Leinster, Dublin), while I am sure those readings come from my country. It is about a few IPs, which can be easily identified.

I have requested and did not find any method to modify GeoLite2-City.mmdb.

I am writing to this forum to ask for help as follows:

a) Is it possible to modify something in code or create a custom php that makes it possible to replace any ip from 212.82.108.XXX to a fixed IP address that belongs to my country?

If not,

b) How to create a script and run a cron job to periodically update the DB replacing any 212.82.108.XXX with an single IP that belongs to my country?

Thank you in advance

 

[twisted1919]

@Arta - The problem is Yahoo / GMail use images proxies to serve faster images and this affects our tracking pixels in various ways. We do have some tools in place to avoid this but they don't work each time as you have noted.
I don't think there's much you can do in this case, we always try to cope with such issues, they have nothing to do with the ip location library.

 

[Arta]

Thank you @twisted1999
I found an opportunistic solution:
UPDATE
mw_ip_location
SET
country_code = "",
country_name = "",
zone_name = "",
city_name = "",
latitude="",
longitude="",
timezone=""
WHERE city_name = "Dublin";