Disable City Location
 

Hello I'm using HLX:CE 1.6.19 on my webpage and currently setting it up. However I noticed some problems that I'm trying to resolve.

How to Disable City Location as my players don't want their town/city location broadcasted - despite the fact that Maxmind GeoLite doesn't really give out their exactly ISP location. I told them that GeoLite isn't 100% accurate but insisted that I should disable their town/city location shown on their stats profile.

But I've found the solution!

What I did is I loaded up MySQL Database Server from Webmin and looked up on 'geoLiteCity_Location' Table and clicked on 'city' Field Name. Then I changed the type width from 50 to 0. And hey presto the city location is hidden!

I've not done this with phpmyadmin before but this similar should work, if I am not mistaken.

To remove the data from the 'city' field column you with need to Execute into SQL by typing EITHER those two lines:-

You will also have to reload and restart daemon just to make sure this works.

Re: Disable City Location
 

Thanks RoboCop :)

P.s: If you want delete city in existing players go to hlstats_Players click on city field and changed from 50 to 0 [phpmyadmin].