Notes to IpToCountry services

Discussions about Servers
User avatar
Sp0ngeb0b
Adept
Posts: 376
Joined: Wed Feb 13, 2008 9:16 pm
Location: Cologne
Contact:

Re: Notes to IpToCountry services

Post by Sp0ngeb0b »

I assume you mean wrong countries being displayed with 'fake results'? This is caused by the SQL database not being up to date, not a fault of Ip2Country. I personally don't maintain an Ip2Country database server, but I rarely have any issues with the public ones provided by community members.
However, I maintain the country assignment database of my UTStats database, and have recently adjusted UTStats to utilize the free GeoLite2 files which are updated weekly. They provide IP to Country data either in binary format (.mmdb) or as human-readable in .csv. The binary file is processed via a provided php script and accessed from UTStats' php files.

Regarding Ip2Country: Using an external SQL database has the clear advantage of not straining the gameserver with the lookup process. The latest csv file contains about 300k entries so I don't see any promising way to perform lookups in UScript. I do agree that the additional communication with the Ip2Country DB server is not necessarily required if you are able to process the data directly on the gameserver. This would require a native mod though I suppose.
Website, Forum & UTStats

Image
******************************************************************************
Nexgen Server Controller || My plugins & mods on GitHub
******************************************************************************
User avatar
sektor2111
Godlike
Posts: 6403
Joined: Sun May 09, 2010 6:15 pm
Location: On the roof.

Re: Notes to IpToCountry services

Post by sektor2111 »

Note: Database computed previously looks incomplete - lol services so I went to gain other resources for 2020.
These newer calculations looks more optimized and I think I'll try some lousy conversion of old mutator trying to keep original integrity but operating a local query instead the old one VIA network. A state code probably can simulate a Web communication smoothly looking around an array having 212.513 lines and returning similar results. I only have to see how much breaking I need in order to prevent iterations boundary but maintaining a quicker response as possible. XC_Engine is capable to deal with dynamic arrays and here I only need to figure a solution for porting code into a similar local format, or... a fixed array attached to an actor could be another way instead of using Network Channels.

Edit: I went to do a research because Not a single time a player has asked something another one and... it was confusing, no answer because Country was WRONG reported ("I don't understand your language"), so these services must be updated. I figured one player reported as being from my country having a ping which was surprising to me, and later I could figure his address as being from UK, LOL, not even closer from me.
Sample from "INI" which will have a dynamic array deal:

Code: Select all

Country=220.158.148.0-220.158.151.255:Cambodia:KHM:KH
Country=221.120.160.0-221.120.163.255:Cambodia:KHM:KH
Country=223.223.168.0-223.223.175.255:Cambodia:KHM:KH
Country=41.77.80.0-41.77.87.255:Cameroon:CMR:CM
Country=41.77.208.0-41.77.215.255:Cameroon:CMR:CM
Country=41.78.204.0-41.78.207.255:Cameroon:CMR:CM
And so on for the rest...
User avatar
asosed
Adept
Posts: 277
Joined: Fri May 15, 2020 2:36 pm
Location: Russia
Contact:

Re: Notes to IpToCountry services

Post by asosed »

Hey. Serbian flag not displayed.
The country is determined by this service:
http://forum.gameclan.pl/iptocountry/in ... 48.172.123
I am using CountryFlags2.utx. Maybe this flag is missing there?

UPD: Serbian flag is missing in CountryFlags2.utx
I will try CountryFlags3.utx
Attachments
photo_2020-06-03_21-53-29.jpg
serbia-flag.jpg
serbia-flag.jpg (12.23 KiB) Viewed 2805 times
Image
User avatar
Sp0ngeb0b
Adept
Posts: 376
Joined: Wed Feb 13, 2008 9:16 pm
Location: Cologne
Contact:

Re: Notes to IpToCountry services

Post by Sp0ngeb0b »

asosed wrote: Fri Jun 05, 2020 10:14 am I will try CountryFlags3.utx
I did the exact same thing and used CountryFlags3.utx which was released in XBrowser 200. However, players on my server reported a version missmatch with this file. So you may want to be careful, there might be a different version floating around as well.
Website, Forum & UTStats

Image
******************************************************************************
Nexgen Server Controller || My plugins & mods on GitHub
******************************************************************************
User avatar
asosed
Adept
Posts: 277
Joined: Fri May 15, 2020 2:36 pm
Location: Russia
Contact:

Re: Notes to IpToCountry services

Post by asosed »

Sp0ngeb0b wrote: Fri Jun 05, 2020 1:29 pm
asosed wrote: Fri Jun 05, 2020 10:14 am I will try CountryFlags3.utx
I did the exact same thing and used CountryFlags3.utx which was released in XBrowser 200. However, players on my server reported a version missmatch with this file. So you may want to be careful, there might be a different version floating around as well.
I already noticed that. Due to this version mismatch, it is not allowed to the server.I renamed the file on the server the CountryFlags3.utx file to CountryFlags3_v2.utx and it worked
Image
User avatar
shoq_jedi
Novice
Posts: 13
Joined: Sun Nov 03, 2019 3:08 am
Personal rank: Jedi Master
Location: DavidM2
Contact:

Re: Notes to IpToCountry services

Post by shoq_jedi »

I've tried everything. Over and over again. No idea what is wrong. My best guess is that maybe my game server host in blocking something outgoing from the server to http://ip2c.xantaz.net/?ip=8.8.8.8
User avatar
Barbie
Godlike
Posts: 2792
Joined: Fri Sep 25, 2015 9:01 pm
Location: moved without proper hashing

Re: Notes to IpToCountry services

Post by Barbie »

shoq_jedi wrote: Wed Aug 19, 2020 11:32 am I've tried everything. Over and over again. No idea what is wrong. My best guess is that maybe my game server host in blocking something outgoing from the server to http://ip2c.xantaz.net/?ip=8.8.8.8
If I use Firefox and follow the link you have given it shows that the IpToCountry service is working (19 Aug 2020 22:00 MEST):
ip2c.xantaz.jpg
ip2c.xantaz.jpg (13.79 KiB) Viewed 2578 times
What happens if you follow the link with your browser?
"Multiple exclamation marks," he went on, shaking his head, "are a sure sign of a diseased mind." --Terry Pratchett
User avatar
shoq_jedi
Novice
Posts: 13
Joined: Sun Nov 03, 2019 3:08 am
Personal rank: Jedi Master
Location: DavidM2
Contact:

Re: Notes to IpToCountry services

Post by shoq_jedi »

The same thing. The webserver & service appear to be working fine as you have confirmed. It must be on the game server side. They are not on the same server as I am using https://www.nfoservers.com/ for both my game and web servers. The only other thing I can think is that it could be and issue with https://dash.cloudflare.com/login, which I use for increased security.

Here are my settings

[IpToCountry.LinkActor]
;viewtopic.php?f=33&t=11568
QueryServerHost[0]=ip2c.xantaz.net
QueryServerHost[2]=ip2c.xantaz.net:80
QueryServerHost[3]=ip2c.xantaz.net
QueryServerFilePath[0]=/index.php
QueryServerFilePath[1]=/index.php
QueryServerFilePath[2]=/iptocountry16.php
QueryServerFilePath[3]=index.php
QueryServerPort[0]=80
QueryServerPort[1]=80
QueryServerPort[2]=80
QueryServerPort[3]=80
resolvedAddress[0]=104.27.166.19
resolvedAddress[1]=34.98.99.30
resolvedAddress[2]=104.24.102.120
resolvedAddress[3]=104.24.102.120
MaxTimeout=10
ErrorLimit=5
bNeverPurgeAddress=False
bSpawnAddon=True
IPData[0]=.....
....
....
IPDataIndex=0
QueryServerHost[1]=www.ut-slv.com
User avatar
[rev]rato.skt
Adept
Posts: 438
Joined: Mon Aug 16, 2010 1:09 pm

Re: Notes to IpToCountry services

Post by [rev]rato.skt »

hi,

I would like to know why some brazilian players do not show the flag, i use CountryFlags3 path 469b server in linux.

Image

Code: Select all

[IpToCountry.LinkActor]
QueryServerHost[0]=iptocountry.ut-files.com
QueryServerHost[1]=iptocountry.unrealteam.de
QueryServerHost[2]=www.unrealkillers.com
QueryServerHost[3]=utgl.unrealadmin.org
QueryServerFilePath[0]=/iptocountry16.php
QueryServerFilePath[1]=/iptocountry16.php
QueryServerFilePath[2]=/iptocountry/iptocountry16.php
QueryServerFilePath[3]=/iptocountry16.php
QueryServerPort[0]=80
QueryServerPort[1]=80
QueryServerPort[2]=80
QueryServerPort[3]=80
resolvedAddress[0]=192.111.155.210
resolvedAddress[1]=188.68.47.21
resolvedAddress[2]=172.67.137.125
resolvedAddress[3]=158.106.137.11
MaxTimeout=10
ErrorLimit=5
bNeverPurgeAddress=False
bSpawnAddon=True
IPData[0]=181.202.38.48:181-202-38-48.bam.movistar.cl:CHILE:CHL:cl
IPData[1]=177.36.181.25:177-36-181-25.gegnet.com.br:BRAZIL:BRA:br
IPData[2]=45.162.54.114:45.162.54.114.completa.net.br:Unknown::
IPData[3]=179.183.46.222:179.183.46.222.dynamic.adsl.gvt.net.br:BRAZIL:BRA:br
IPData[4]=191.30.135.77:191.30.135.77.dynamic.adsl.gvt.net.br:BRAZIL:BRA:br
IPData[5]=189.90.251.74:ip-189-90-251-74.isp.valenet.com.br:BRAZIL:BRA:br
IPData[6]=86.171.187.58:host86-171-187-58.range86-171.btcentralplus.com:UNITED KINGDOM:GBR:gb
IPData[7]=177.18.108.168:177.18.108.168:BRAZIL:BRA:br
IPData[8]=186.106.87.143:186.106.87.143:CHILE:CHL:cl
IPData[9]=181.169.8.5:5-8-169-181.fibertel.com.ar:ARGENTINA:ARG:ar
IPData[10]=168.194.232.114:host-168-194-232-114.telered.com.ar:ARGENTINA:ARG:ar
IPData[11]=190.121.70.72:190.121.70.72:CHILE:CHL:cl
IPData[12]=177.45.6.178:177-45-6-178.user.ajato.com.br:BRAZIL:BRA:br
IPData[13]=76.16.240.132:c-76-16-240-132.hsd1.il.comcast.net:UNITED STATES:USA:us
IPData[14]=201.219.239.229:ip-229-239-219-201.wom.cl:CHILE:CHL:cl
IPData[15]=200.86.66.142:pc-142-66-86-200.cm.vtr.net:CHILE:CHL:cl
IPData[16]=191.114.79.144:191-114-79-144.baf.movistar.cl:CHILE:CHL:cl
IPData[17]=190.20.72.0:190.20.72.0:CHILE:CHL:cl
IPData[18]=45.232.89.225:45.232.89.225:Unknown::
IPData[19]=195.191.163.148:195191163148.dynamic-2-waw-k-1-3-0.vectranet.pl:POLAND:POL:pl
IPData[20]=201.188.179.31:201.188.179.31:CHILE:CHL:cl
IPData[21]=181.160.117.38:181.160.117.38:CHILE:CHL:cl
IPData[22]=187.189.166.188:fixed-187-189-166-188.totalplay.net:MEXICO:MEX:mx
IPData[23]=200.91.35.251:251-35-91-200.iparatodos.com.ar:ARGENTINA:ARG:ar
IPData[24]=181.10.133.243:host243.181-10-133.telecom.net.ar:ARGENTINA:ARG:ar
IPData[25]=181.118.73.166:181.118.73-166.supercanal.com.ar:ARGENTINA:ARG:ar
IPData[26]=181.95.205.25:host25.181-95-205.telecom.net.ar:ARGENTINA:ARG:ar
IPData[27]=190.191.7.3:3-7-191-190.cab.prima.net.ar:ARGENTINA:ARG:ar
IPData[28]=170.83.146.215:170-83-146-215.acessanet.com.br:BRAZIL:BRA:br
IPData[29]=190.163.163.163:pc-163-163-163-190.cm.vtr.net:CHILE:CHL:cl
IPData[30]=207.248.193.115:host207.248.193.115.dynamic.pacificonet.cl:CHILE:CHL:cl
IPData[31]=190.124.158.156:customer-190-124-158-156.megacable.com.ar:ARGENTINA:ARG:ar
IPData[32]=104.158.192.4:4.192.158.104.in-addr.arpa:CANADA:CAN:ca
IPData[33]=95.169.224.10:95.169.224.10:SPAIN:ESP:es
IPData[34]=138.186.165.135:138.186.165.135:BRAZIL:BRA:br
IPData[35]=45.185.73.200:customer.yeptv.com.br:Unknown::
IPData[36]=131.196.79.62:conexaotelecom.net.br:UNITED STATES:USA:us
IPData[37]=189.6.248.125:bd06f87d.virtua.com.br:BRAZIL:BRA:br
IPData[38]=5.3.172.140:5x3x172x140.dynamic.izhevsk.ertelecom.ru:RUSSIAN FEDERATION:RUS:ru
IPData[39]=89.164.16.140:16-140.dsl.iskon.hr:CROATIA:HRV:hr
IPData[40]=177.132.110.88:177.132.110.88.dynamic.adsl.gvt.net.br:BRAZIL:BRA:br
IPData[41]=191.250.126.63:191.250.126.63.dynamic.adsl.gvt.net.br:BRAZIL:BRA:br
IPData[42]=181.46.137.77:cpe-181-46-137-77.telecentro-reversos.com.ar:ARGENTINA:ARG:ar
IPData[43]=200.104.161.161:pc-161-161-104-200.cm.vtr.net:CHILE:CHL:cl
IPData[44]=73.142.235.176:c-73-142-235-176.hsd1.ma.comcast.net:UNITED STATES:USA:us
IPData[45]=170.51.101.138:host138.170-51-101.static.telmex.net.ar:URUGUAY:URY:uy
IPData[46]=207.248.193.18:host207.248.193.18.dynamic.pacificonet.cl:CHILE:CHL:cl
IPData[47]=143.255.107.221:143.255.107.221:CHILE:CHL:cl
IPData[48]=181.160.115.114:181.160.115.114:CHILE:CHL:cl
IPData[49]=177.128.104.214:177-128-104-214.supercabotv.com.br:BRAZIL:BRA:br
IPData[50]=186.13.119.64:host64.186-13-119.telmex.net.ar:ARGENTINA:ARG:ar
IPData[51]=190.164.237.239:pc-239-237-164-190.cm.vtr.net:CHILE:CHL:cl
IPData[52]=190.102.54.9:190.102.54.9:BOLIVIA:BOL:bo
IPData[53]=193.200.207.96:193.200.207.96:SLOVENIA:SVN:si
IPData[54]=168.194.162.230:230.162.194.168.rfc6598.dynamic.copelfibra.com.br:BRAZIL:BRA:br
IPData[55]=174.70.46.178:ip174-70-46-178.om.om.cox.net:UNITED STATES:USA:us
IPData[56]=177.156.22.136:177.156.22.136.dynamic.adsl.gvt.net.br:BRAZIL:BRA:br
IPData[57]=177.87.220.74:177.87.220.74:BRAZIL:BRA:br
IPData[58]=170.82.200.72:170.82.200.72:BRAZIL:BRA:br
IPData[59]=177.36.181.19:177-36-181-19.gegnet.com.br:BRAZIL:BRA:br
IPData[60]=177.132.59.113:177.132.59.113.dynamic.adsl.gvt.net.br:BRAZIL:BRA:br
IPData[61]=187.112.131.105:187.112.131.105.static.host.gvt.net.br:BRAZIL:BRA:br
IPData[62]=168.194.161.224:224.161.194.168.rfc6598.dynamic.copelfibra.com.br:BRAZIL:BRA:br
IPData[63]=189.111.46.10:189-111-46-10.dsl.telesp.net.br:BRAZIL:BRA:br
IPData[64]=186.205.144.74:bacd904a.virtua.com.br:BRAZIL:BRA:br
IPData[65]=74.73.62.111:cpe-74-73-62-111.nyc.res.rr.com:UNITED STATES:USA:us
IPData[66]=177.235.5.79:b1eb054f.virtua.com.br:BRAZIL:BRA:br
IPData[67]=176.78.129.25:dsl-129-25.bl26.telepac.pt:PORTUGAL:PRT:pt
IPData[68]=181.12.41.63:host63.181-12-41.telecom.net.ar:ARGENTINA:ARG:ar
IPData[69]=195.98.73.166:195.98.73.166:RUSSIAN FEDERATION:RUS:ru
IPData[70]=191.177.185.20:bfb1b914.virtua.com.br:BRAZIL:BRA:br
IPData[71]=177.204.215.28:177.204.215.28.dynamic.adsl.gvt.net.br:BRAZIL:BRA:br
IPData[72]=87.123.133.250:87.123.133.250:GERMANY:DEU:de
IPData[73]=45.162.54.212:45.162.54.212.completa.net.br:Unknown::
IPData[74]=45.228.26.34:45.228.26.34:Unknown::
IPData[75]=177.201.196.50:177.201.196.50:BRAZIL:BRA:br
IPData[76]=201.188.190.201:201.188.190.201:CHILE:CHL:cl
IPData[77]=181.31.163.84:84-163-31-181.fibertel.com.ar:ARGENTINA:ARG:ar
IPData[78]=45.232.95.179:45.232.95.179:Unknown::
IPData[79]=143.176.58.119:ip119-58-176-143.adsl2.static.versatel.nl:NETHERLANDS:NLD:nl
IPData[80]=181.42.35.18:z217.entelchile.net:CHILE:CHL:cl
IPData[81]=47.142.184.71:47.142.184.71:UNITED STATES:USA:us
IPData[82]=168.194.162.190:190.162.194.168.rfc6598.dynamic.copelfibra.com.br:BRAZIL:BRA:br
IPData[83]=191.177.180.238:bfb1b4ee.virtua.com.br:BRAZIL:BRA:br
IPData[84]=190.237.143.116:190.237.143.116:PERU:PER:pe
IPData[85]=186.106.91.77:186.106.91.77:CHILE:CHL:cl
IPData[86]=138.255.144.132:138.255.144.132:BRAZIL:BRA:br
IPData[87]=187.121.33.249:187.121.33.249:BRAZIL:BRA:br
IPData[88]=24.218.159.25:c-24-218-159-25.hsd1.ma.comcast.net:UNITED STATES:USA:us
IPData[89]=177.194.96.176:b1c260b0.virtua.com.br:BRAZIL:BRA:br
IPData[90]=143.255.87.131:143.255.87.131:VENEZUELA:VEN:ve
IPData[91]=45.232.32.183:45.232.32.183:CHILE:CHL:cl
IPData[92]=174.86.55.35:174-086-055-035.res.spectrum.com:UNITED STATES:USA:us
IPData[93]=179.56.186.69:179.56.186.69:CHILE:CHL:cl
IPData[94]=195.191.163.138:195191163138.dynamic-2-waw-k-1-3-0.vectranet.pl:POLAND:POL:pl
IPData[95]=200.115.234.220:cpe-200-115-234-220.telecentro-reversos.com.ar:ARGENTINA:ARG:ar
IPData[96]=190.3.30.148:host148.190-3-30.dynamic.telmex.net.ar:ARGENTINA:ARG:ar
IPData[97]=190.3.30.243:host243.190-3-30.dynamic.telmex.net.ar:ARGENTINA:ARG:ar
IPData[98]=187.37.88.70:bb255846.virtua.com.br:BRAZIL:BRA:br
IPData[99]=177.246.223.205:customer-FW-LPAZ-223-205.megared.net.mx:MEXICO:MEX:mx
IPData[100]=196.20.252.32:196.20.252.32:MAURITIUS:MUS:mu
IPData[101]=200.56.88.223:as1-200-56-88-223.gdlja.axtel.net:MEXICO:MEX:mx
IPData[102]=181.160.100.138:181.160.100.138:CHILE:CHL:cl
IPData[103]=190.100.127.40:pc-40-127-100-190.cm.vtr.net:CHILE:CHL:cl
IPData[104]=187.121.55.61:187-121-55-61.user.ajato.com.br:BRAZIL:BRA:br
IPData[105]=191.178.179.174:bfb2b3ae.virtua.com.br:BRAZIL:BRA:br
IPData[106]=168.181.48.23:23.48.181.168.rfc6598.dynamic.copelfibra.com.br:BRAZIL:BRA:br
IPData[107]=189.30.54.29:189-30-54-29.paemt700.dsl.brasiltelecom.net.br:BRAZIL:BRA:br
IPData[108]=191.31.30.179:191.31.30.179.dynamic.adsl.gvt.net.br:BRAZIL:BRA:br
IPData[109]=187.58.199.75:187.58.199.75.static.host.gvt.net.br:BRAZIL:BRA:br
IPData[110]=188.252.198.63:188.252.198.63:CROATIA:HRV:hr
IPData[111]=190.20.66.215:190-20-66-215.baf.movistar.cl:CHILE:CHL:cl
IPData[112]=207.248.198.236:host207.248.198.236.dynamic.pacificonet.cl:CHILE:CHL:cl
IPData[113]=190.44.182.155:pc-155-182-44-190.cm.vtr.net:CHILE:CHL:cl
IPData[114]=186.23.28.88:cpe-186-23-28-88.telecentro-reversos.com.ar:ARGENTINA:ARG:ar
IPData[115]=170.79.235.32:static-32.235.79.170.tnasolutions.cl:CHILE:CHL:cl
IPData[116]=201.215.248.155:pc-155-248-215-201.cm.vtr.net:CHILE:CHL:cl
IPData[117]=177.220.174.75:75.174.220.177.rfc6598.dynamic.copelfibra.com.br:BRAZIL:BRA:br
IPData[118]=187.252.250.157:187.252.250.157.cable.dyn.cableonline.com.mx:MEXICO:MEX:mx
IPData[119]=181.65.125.77:181.65.125.77:PERU:PER:pe
IPData[120]=190.47.69.207:pc-207-69-47-190.cm.vtr.net:CHILE:CHL:cl
IPData[121]=96.47.239.215:96.47.239.215.static.quadranet.com:UNITED STATES:USA:us
IPData[122]=186.10.11.11:b1111.entelchile.net:CHILE:CHL:cl
IPData[123]=138.186.167.199:199.167.186.138.clicrapido.com.br:BRAZIL:BRA:br
IPData[124]=201.66.143.80:201-66-143-80.user3p.brasiltelecom.net.br:BRAZIL:BRA:br
IPData[125]=69.130.177.102:h69-130-177-102.bendor.broadband.dynamic.tds.net:UNITED STATES:USA:us
IPData[126]=177.37.146.164:177.37.146.164:BRAZIL:BRA:br
IPData[127]=179.218.198.248:b3dac6f8.virtua.com.br:BRAZIL:BRA:br
IPData[128]=186.148.13.201:186-148-13-201.static.mundo.movistar.cl:CHILE:CHL:cl
IPData[129]=170.79.235.30:wi-plus.tnasolutions.cl:CHILE:CHL:cl
IPData[130]=177.235.7.33:b1eb0721.virtua.com.br:BRAZIL:BRA:br
IPData[131]=45.232.91.224:45.232.91.224:Unknown::
IPData[132]=177.201.247.23:177.201.247.23:BRAZIL:BRA:br
IPData[133]=64.246.110.24:64-246-110-24.car1-wispds4-pool54.amplex.net:UNITED STATES:USA:us
IPData[134]=201.234.32.2:201-234-32-2.static.impsat.net.ar:ARGENTINA:ARG:ar
IPData[135]=201.188.185.231:201.188.185.231:CHILE:CHL:cl
IPData[136]=45.166.180.129:ip-45-166-180-129.netparque.net.br:Unknown::
IPData[137]=187.58.184.63:187.58.184.63.static.host.gvt.net.br:BRAZIL:BRA:br
IPData[138]=69.173.132.138:138.132.173.69.v.cable.oricom.ca:UNITED STATES:USA:us
IPData[139]=181.67.112.223:181.67.112.223:PERU:PER:pe
IPData[140]=177.141.142.222:b18d8ede.virtua.com.br:BRAZIL:BRA:br
IPData[141]=189.105.6.99:189-105-6-99.user3p.veloxzone.com.br:BRAZIL:BRA:br
IPData[142]=161.132.197.134:161.132.197.134:PERU:PER:pe
IPData[143]=45.166.180.138:ip-45-166-180-138.netparque.net.br:Unknown::
IPData[144]=190.234.181.210:190.234.181.210:PERU:PER:pe
IPData[145]=45.166.251.47:45.166.251.47:Unknown::
IPData[146]=207.248.193.161:host207.248.193.161.dynamic.pacificonet.cl:CHILE:CHL:cl
IPData[147]=190.5.39.196:host190.5.39.196.dynamic.pacificonet.cl:CHILE:CHL:cl
IPData[148]=157.100.171.83:host-157-100-171-83.ecua.net.ec:ECUADOR:ECU:ec
IPData[149]=181.160.114.81:181.160.114.81:CHILE:CHL:cl
IPData[150]=200.7.119.144:200-7-119-144.sunway.com.br:BRAZIL:BRA:br
IPData[151]=186.67.249.14:186.67.249.14:CHILE:CHL:cl
IPData[152]=95.169.237.234:95.169.237.234:SPAIN:ESP:es
IPData[153]=138.186.165.132:138.186.165.132:BRAZIL:BRA:br
IPData[154]=177.235.217.45:b1ebd92d.virtua.com.br:BRAZIL:BRA:br
IPData[155]=187.74.41.181:187-74-41-181.dsl.telesp.net.br:BRAZIL:BRA:br
IPData[156]=5.165.65.239:5x165x65x239.dynamic.voronezh.ertelecom.ru:RUSSIAN FEDERATION:RUS:ru
IPData[157]=189.10.222.147:189-10-222-147.paebv701.dsl.brasiltelecom.net.br:BRAZIL:BRA:br
IPData[158]=45.226.117.12:45.226.117.12:Unknown::
IPData[159]=189.61.69.214:bd3d45d6.virtua.com.br:BRAZIL:BRA:br
IPData[160]=177.201.230.176:177.201.230.176:BRAZIL:BRA:br
IPData[161]=75.191.82.147:cpe-75-191-82-147.triad.res.rr.com:UNITED STATES:USA:us
IPData[162]=5.3.166.186:5x3x166x186.dynamic.izhevsk.ertelecom.ru:RUSSIAN FEDERATION:RUS:ru
IPData[163]=181.114.226.60:host-181-114-226-60.as52431.net:ARGENTINA:ARG:ar
IPData[164]=186.214.196.180:186.214.196.180.static.host.gvt.net.br:BRAZIL:BRA:br
IPData[165]=177.2.171.196:177.2.171.196:BRAZIL:BRA:br
IPData[166]=177.235.120.83:b1eb7853.virtua.com.br:BRAZIL:BRA:br
IPData[167]=190.164.125.157:pc-157-125-164-190.cm.vtr.net:CHILE:CHL:cl
IPData[168]=168.0.149.79:168-0-149-79.inbnet.com.br:BRAZIL:BRA:br
IPData[169]=190.20.18.58:190-20-18-58.baf.movistar.cl:CHILE:CHL:cl
IPData[170]=170.51.104.111:host111.170-51-104.telmex.net.ar:URUGUAY:URY:uy
IPData[171]=186.129.112.192:186-129-112-192.speedy.com.ar:ARGENTINA:ARG:ar
IPData[172]=186.18.154.53:cpe-186-18-154-53.telecentro-reversos.com.ar:ARGENTINA:ARG:ar
IPData[173]=201.4.7.98:201-4-7-98.user3p.veloxzone.com.br:BRAZIL:BRA:br
IPData[174]=190.100.24.12:pc-12-24-100-190.cm.vtr.net:CHILE:CHL:cl
IPData[175]=45.232.90.177:45.232.90.177:Unknown::
IPData[176]=176.187.162.112:176.187.162.112:FRANCE:FRA:fr
IPData[177]=201.214.86.177:pc-177-86-214-201.cm.vtr.net:CHILE:CHL:cl
IPData[178]=179.181.50.46:179.181.50.46.dynamic.adsl.gvt.net.br:BRAZIL:BRA:br
IPData[179]=177.66.136.98:177-66-136-98.clonix.srv.br:BRAZIL:BRA:br
IPData[180]=187.38.63.249:bb263ff9.virtua.com.br:BRAZIL:BRA:br
IPData[181]=181.164.115.125:125-115-164-181.fibertel.com.ar:ARGENTINA:ARG:ar
IPData[182]=201.186.91.71:201.186.91.71:CHILE:CHL:cl
IPData[183]=181.160.99.190:181.160.99.190:CHILE:CHL:cl
IPData[184]=174.197.69.148:148.sub-174-197-69.myvzw.com:UNITED STATES:USA:us
IPData[185]=31.14.249.181:249.14.31.181.bcube.co.uk:ROMANIA:ROM:ro
IPData[186]=152.169.156.15:15-156-169-152.fibertel.com.ar:ARGENTINA:ARG:ar
IPData[187]=201.188.186.229:201.188.186.229:CHILE:CHL:cl
IPData[188]=181.44.131.93:cpe-181-44-131-93.telecentro-reversos.com.ar:ARGENTINA:ARG:ar
IPData[189]=181.42.22.23:z222.entelchile.net:CHILE:CHL:cl
IPData[190]=186.11.5.221:client-186-11-5-221.imovil.entelpcs.cl:CHILE:CHL:cl
IPData[191]=68.185.140.244:068-185-140-244.res.spectrum.com:UNITED STATES:USA:us
IPData[192]=200.86.207.199:pc-199-207-86-200.cm.vtr.net:CHILE:CHL:cl
IPData[193]=177.40.104.218:177.40.104.218.static.host.gvt.net.br:BRAZIL:BRA:br
IPData[194]=92.109.63.109:92-109-63-109.cable.dynamic.v4.ziggo.nl:NETHERLANDS:NLD:nl
IPData[195]=191.163.195.47:47.195.163.191.isp.timbrasil.com.br:BRAZIL:BRA:br
IPData[196]=177.132.76.161:177.132.76.161.dynamic.adsl.gvt.net.br:BRAZIL:BRA:br
IPData[197]=201.189.13.193:201.189.13.193:CHILE:CHL:cl
IPData[198]=190.20.31.244:190-20-31-244.baf.movistar.cl:CHILE:CHL:cl
IPData[199]=144.134.152.155:cpe-144-134-152-155.qb05.qld.asp.telstra.net:AUSTRALIA:AUS:au
IPData[200]=45.178.2.60:45.178.2.60:Unknown::
IPData[201]=24.50.225.141:24.50.225.141:PUERTO RICO:PRI:pr
IPData[202]=73.60.66.100:c-73-60-66-100.hsd1.ma.comcast.net:UNITED STATES:USA:us
IPData[203]=190.102.240.32:host190.102.240.32.dynamic.pacificonet.cl:CHILE:CHL:cl
IPData[204]=187.86.76.166:187.86.76.166:BRAZIL:BRA:br
IPData[205]=190.114.51.91:host190.114.51-91.dynamic.pacificored.cl:CHILE:CHL:cl
IPData[206]=95.212.17.141:95.212.17.141:EGYPT:EGY:eg
IPData[207]=86.210.102.146:lfbn-mon-1-134-146.w86-210.abo.wanadoo.fr:FRANCE:FRA:fr
IPData[208]=181.224.164.153:181.224.164.153:ARGENTINA:ARG:ar
IPData[209]=152.169.49.127:127-49-169-152.fibertel.com.ar:ARGENTINA:ARG:ar
IPData[210]=200.115.231.56:cpe-200-115-231-56.telecentro-reversos.com.ar:ARGENTINA:ARG:ar
IPData[211]=138.186.165.130:138.186.165.130:BRAZIL:BRA:br
IPData[212]=177.132.79.197:177.132.79.197.dynamic.adsl.gvt.net.br:BRAZIL:BRA:br
IPData[213]=190.21.198.14:190-21-198-14.baf.movistar.cl:CHILE:CHL:cl
IPData[214]=95.169.225.237:95.169.225.237:SPAIN:ESP:es
IPData[215]=189.6.245.221:bd06f5dd.virtua.com.br:BRAZIL:BRA:br
IPData[216]=201.87.205.72:201.87.205.72:BRAZIL:BRA:br
IPData[217]=190.215.11.199:190.215.11.199:CHILE:CHL:cl
IPData[218]=181.118.101.211:181.118.101-211.supercanal.com.ar:ARGENTINA:ARG:ar
IPData[219]=190.114.50.108:host190.114.50.108.dynamic.pacificonet.cl:CHILE:CHL:cl
IPData[220]=190.100.178.50:pc-50-178-100-190.cm.vtr.net:CHILE:CHL:cl
IPData[221]=81.25.151.39:81-25-151-39.junet.se:SWEDEN:SWE:se
IPData[222]=45.178.2.174:45.178.2.174:Unknown::
IPData[223]=190.114.87.62:190-114-87-62.sanluisctv.com.ar:ARGENTINA:ARG:ar
IPData[224]=77.21.34.117:ip4d152275.dynamic.kabel-deutschland.de:GERMANY:DEU:de
IPData[225]=81.96.104.197:cpc141572-mfl22-2-0-cust196.13-1.cable.virginm.net:UNITED KINGDOM:GBR:gb
IPData[226]=190.20.45.68:190-20-45-68.baf.movistar.cl:CHILE:CHL:cl
IPData[227]=138.229.165.220:138-229-165-220.res.spectrum.com:UNITED STATES:USA:us
IPData[228]=181.202.75.23:181-202-75-23.bam.movistar.cl:CHILE:CHL:cl
IPData[229]=181.202.76.233:181-202-76-233.bam.movistar.cl:CHILE:CHL:cl
IPData[230]=181.202.75.168:181-202-75-168.bam.movistar.cl:CHILE:CHL:cl
IPData[231]=181.202.73.15:181-202-73-15.bam.movistar.cl:CHILE:CHL:cl
IPData[232]=181.170.1.18:18-1-170-181.fibertel.com.ar:ARGENTINA:ARG:ar
IPData[233]=187.55.229.143:187-55-229-143.user3p.brasiltelecom.net.br:BRAZIL:BRA:br
IPData[234]=191.179.134.101:bfb38665.virtua.com.br:BRAZIL:BRA:br
IPData[235]=187.95.158.144:144.158.95.187.static.horizonstelecom.com.br:BRAZIL:BRA:br
IPData[236]=177.96.11.78:177.96.11.78.dynamic.adsl.gvt.net.br:BRAZIL:BRA:br
IPData[237]=177.42.17.202:177.42.17.202.static.host.gvt.net.br:BRAZIL:BRA:br
IPData[238]=191.176.129.211:bfb081d3.virtua.com.br:BRAZIL:BRA:br
IPData[239]=190.114.63.162:host190.114.63.162.dynamic.pacificonet.cl:CHILE:CHL:cl
IPData[240]=191.32.0.119:191.32.0.119.static.adsl.gvt.net.br:BRAZIL:BRA:br
IPData[241]=170.79.235.3:sznet.tnasolutions.cl:CHILE:CHL:cl
IPData[242]=201.188.179.178:201.188.179.178:CHILE:CHL:cl
IPData[243]=181.160.113.59:181.160.113.59:CHILE:CHL:cl
IPData[244]=45.232.93.104:45.232.93.104:Unknown::
IPData[245]=179.191.200.86:179.191.200.86:BRAZIL:BRA:br
IPData[246]=186.153.51.119:host119.186-153-51.telecom.net.ar:ARGENTINA:ARG:ar
IPData[247]=138.186.166.127:127.166.186.138.clicrapido.com.br:BRAZIL:BRA:br
IPData[248]=181.160.124.104:181.160.124.104:CHILE:CHL:cl
IPData[249]=190.20.47.110:190-20-47-110.baf.movistar.cl:CHILE:CHL:cl
IPData[250]=181.226.129.118:181.226.129.118:CHILE:CHL:cl
IPData[251]=162.228.221.243:162-228-221-243.lightspeed.sntcca.sbcglobal.net:UNITED STATES:USA:us
IPData[252]=170.244.163.73:170-244-163-73.gtxnet.com.br:BRAZIL:BRA:br
IPData[253]=181.202.35.106:181-202-35-106.bam.movistar.cl:CHILE:CHL:cl
IPData[254]=181.202.34.42:181-202-34-42.bam.movistar.cl:CHILE:CHL:cl
IPData[255]=181.202.34.192:181-202-34-192.bam.movistar.cl:CHILE:CHL:cl
IPDataIndex=162

Brazilian Server:
Alma Negra - 34.95.189.187:7777
Classic - madruga.utbr.cf:7777
Duel - x1.utbr.cf:6666
User avatar
Barbie
Godlike
Posts: 2792
Joined: Fri Sep 25, 2015 9:01 pm
Location: moved without proper hashing

Re: Notes to IpToCountry services

Post by Barbie »

I guess their IP addresses do not exist in the Ip2Country database that is used by your UT.
If you have their IP addresses you can try a look up with other services where that IP is located.
"Multiple exclamation marks," he went on, shaking his head, "are a sure sign of a diseased mind." --Terry Pratchett
User avatar
[rev]rato.skt
Adept
Posts: 438
Joined: Mon Aug 16, 2010 1:09 pm

Re: Notes to IpToCountry services

Post by [rev]rato.skt »

Hi,

Other QueryServerHost, resolvedAddress ?
Barbie wrote: Fri Jun 25, 2021 10:23 am I guess their IP addresses do not exist in the Ip2Country database that is used by your UT.
If you have their IP addresses you can try a look up with other services where that IP is located.
Brazilian Server:
Alma Negra - 34.95.189.187:7777
Classic - madruga.utbr.cf:7777
Duel - x1.utbr.cf:6666
rdy2bz
Novice
Posts: 22
Joined: Thu Nov 26, 2015 11:42 am

Re: Notes to IpToCountry services

Post by rdy2bz »

Beginning from PHP 8 the original iptocountry16.php fails to run. Problem is that it uses thh mktime() function that was changed in PHP8 (see here for details). Fortunately, the time handling in PHP can be done in an easier way, so you can make the script run again with the following change.

in iptocountry16.php, line 35, delete (or make them a comment by adding // at the line start) the following line:

Code: Select all

$timestamp = mktime(gmdate("H, i, s, m, d, Y")); // UTC time
and replace it with this line:

Code: Select all

$timestamp = time();
Hopefully this prevents the dying of the services once they need to upgrad to the latest php version.
Eternity
Skilled
Posts: 166
Joined: Sat Nov 30, 2019 10:56 pm

Re: Notes to IpToCountry services

Post by Eternity »

The fix for PHP8 issue was already posted here, also with recently updated geoip databases (in old maxmind format) compatible with iptocountry16.php.

It was also mentioned in this topic.
This PHP8 fix and updated databases now is a proven way to make it return actual geoip data and run on a modern server OS like Ubuntu 22.04.

UT servers admins now rather run fixed iptocountry16.php on their own servers, because known public iptocountry service providers didn't hurry up to get updated, some of them work unstable, some are already offline for a long time...
rdy2bz
Novice
Posts: 22
Joined: Thu Nov 26, 2015 11:42 am

Re: Notes to IpToCountry services

Post by rdy2bz »

Thanks for the links, I didn't find them when i searched the forums and the rest of the internet for iptocountry16 php8. The updated GeoIP is very much appreciated.

The code patch from that link looks buggy, though.
The original code used mktime() to produce the timestamp of a date string, which gmtime() provided for the current time.
The time() from my patch does exactly this: it provides the timestamp for the current time. The result is in seconds.

The patch from your link feeds the timestamp from time() - measured in seconds - into mktime() as the only parameter. But if you provide only 1 parameter to mktime(), it will interpret it as hours.

You can debug it for yourself and compare it to the current epoch Unix timestamp. The hh:mm output fom your patch gives a random hour output. My patch gives the correct output.
Eternity
Skilled
Posts: 166
Joined: Sat Nov 30, 2019 10:56 pm

Re: Notes to IpToCountry services

Post by Eternity »

Now i see... It returns minutes properly, but hours - whatever number from 0 to 23.
It seems this value isn't used anywhere in UC part, that explains why this issue was remaining unnoticed so far. The HTTPClient script contains a "GMT" String variable which this value is being assigned to, but i see no references to it anywhere else (maybe it was meant to use by another mods?). Also, comments in UC part indicate older versions format apparently didn't use to pass the time value from master to client at all.

Anyway, i fixed this bug and it returns proper time value now. Thanks for this info.

That message on unrealadmin.org site was the only related info i have found in search. Info about iptocountry16 if very little in public resources these days, many UT sites got closed so that related links appear dead, it wasn't even that easy to find that php script itself in search engines. So, good to have it at least in several places now and with few still alive links.
Post Reply