Raised This Month: $256 Target: $400

Disable City Location

Post New Thread Reply   
Thread Tools Display Modes
Author Message
Join Date: Dec 2010
Location: Scotland
Old 03-03-2017 , 18:29   Disable City Location
Reply With Quote #1

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:-

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.
vBulletin Webmaster Since 2001

Last edited by RoboCop; 03-05-2017 at 19:27.
RoboCop is offline
Send a message via Skype™ to RoboCop
Join Date: Jan 2009
Old 03-20-2017 , 19:53   Re: Disable City Location
Reply With Quote #2

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].

Last edited by gRfd; 03-20-2017 at 19:54.
gRfd is offline

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

All times are GMT -4. The time now is 02:12.

Powered by vBulletin®
Copyright ©2000 - 2018, vBulletin Solutions, Inc.
Theme made by Freecode