Raised This Month: $153 Target: $400
 38% 

Disable City Location


Post New Thread Reply   
 
Thread Tools Display Modes
Author Message
RoboCop
Member
Join Date: Dec 2010
Location: Scotland
Old 03-03-2017 , 19: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:-

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

Last edited by RoboCop; 03-05-2017 at 20:27.
RoboCop is offline
Send a message via Skype™ to RoboCop
gRfd
Member
Join Date: Jan 2009
Old 03-20-2017 , 20: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 20:54.
gRfd is offline
Reply


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 20:11.


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