Quote:
|
Originally Posted by Stizerg
Hi guys!
This mod works very vell, but now I'm wondering how can we update the database of IPs. Here http://www.maxmind.com/app/geolitecountry you can download GeoIP database in CSV updating monthly, but how can we use it? Couldn't it be easer to make this mod compatable with maxmind's csv file? |
It is not possible to use csv directly, what you can do is to make an sql query from the csv file, send it to me and I will update the first post in the thread. The easiest way to do that is through Excel. Open the csv file with Excel, make a formula in the last column, copy it to the end and than copy all formula cells into the Notepad. Split it into two pieces, save it as ip-range_1.sql and ip-range_2.sql, zip it and send it to the forum. I'll copy it into the first post.