偵測連線 IP 的來源國別

[DarkSkyline]

下載位置:
http://www.maxmind.com/download/geoip/d ... tryCSV.zip
EXCEL 的 CSV 格式,裏面有世界各國的 IP 分配資料,資料分六欄,為[起始 IP],[終止 IP],[起始 IP 10進制],],[終止 IP 10進制],[國別簡稱],[國別全名].

說明:
"222.168.0.0","222.223.255.255","3735552000","3739222015","CN","China"
"222.224.0.0","222.230.255.255","3739222016","3739680767","JP","Japan"
"222.231.0.0","222.231.63.255","3739680768","3739697151","KR","Korea"
"222.232.0.0","222.239.255.255","3739746304","3740270591","KR","Korea"
"222.240.0.0","222.249.255.255","3740270592","3740925951","CN","China"
"222.250.0.0","222.251.255.255","3740925952","3741057023","TW","Taiwan"
"222.252.0.0","222.255.255.255","3741057024","3741319167","VN","Vietnam"

IP 判別關鍵在如何分辨 24.24.24.24 這種格式,如果將 IP 這樣表示 IP Address = w.x.y.z ,那換算為 10 進制的方法是 :

10 進數 = (w * 16777216) + (x * 65536) + ( y * 256) + z

404232216 = 16777216*24 + 65536*24 + 256*24 + 24

所以該文件中的[起始 IP 10進制],[終止 IP 10進制]是這樣計算來的.

展示範例:
http://www.clwu.idv.tw/~clwu/newcount.php

資料來源:http://www.maxmind.com