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:-
Code:
UPDATE geoLiteCity_Location SET city=NULL;
UPDATE geoLiteCity_Location SET city=''
You will also have to reload and restart daemon just to make sure this works.