+ Reply to Thread
Page 1 of 3 123 LastLast
Results 1 to 10 of 21

Thread: Location / IP Geo plugin restrict to one country

  1. #1
    Senior Member
    Join Date
    Aug 2014
    Posts
    105

    Location / IP Geo plugin restrict to one country

    Hi,

    My website only targets the United Kingdom. How do I install only the locations / IP Geo database for just the UK?

    The default database table : fl_ipgeo has over 9 million entries which takes a lot of server resources when searching by location.

    Many thanks

  2. #2
    Need to run 2 mysql queries in turn:

    DELETE `T1` FROM `fl_ipgeo` AS `T1` LEFT JOIN `fl_ipgeo_locations` AS `T2` ON `T1`.`Loc_ID` = `T2`.`Loc_ID` WHERE `T2`.`Country_code` <> 'GB';
    DELETE FROM `fl_ipgeo_locations` WHERE `Country_code` <> 'GB';

    screenshot after 1-st request: https://prnt.sc/rzoms7
    screenshot after 2-nd request: https://prnt.sc/rzonm3
    Viktor,
    Flynax technical department,
    Best wishes.

  3. #3
    Senior Member
    Join Date
    Aug 2014
    Posts
    105
    Thanks Victor, that works great!

    Just one other thing, when using the Search by Distance plugin. When typing in a location it is still offering locations from all around the world as suggestions, how do I limit it to just locations and Post Codes in the United Kingdom?

    Many thanks

  4. #4
    I have checked Search by distance on your site and I see locations into Autocomplete field form the United Kingdom only.
    Viktor,
    Flynax technical department,
    Best wishes.

  5. #5
    Why do we need this plugin? Without it the website geo filter still works great. Is there any greater benefit using it?

    Thank you

  6. #6
    Senior Member
    Join Date
    Aug 2014
    Posts
    105

    Search by distance

    Quote Originally Posted by Viktor View Post
    I have checked Search by distance on your site and I see locations into Autocomplete field form the United Kingdom only.
    Hi Viktor,

    Thanks for your help.

    If I start to search for a location, say London, I get results from all around the world. I've attached a screen shot for the London search.



    Any help would be great.

    Many thanks
    Attached Images Attached Images

  7. #7
    Would you please send ftp access to my PM I will check and solve it.
    Viktor,
    Flynax technical department,
    Best wishes.

  8. #8
    Hello Viktor,

    Could you please explain this thread further?

  9. #9
    What exactly do you want me to explain to you?
    Viktor,
    Flynax technical department,
    Best wishes.

  10. #10
    Quote Originally Posted by Viktor View Post
    Need to run 2 mysql queries in turn:

    DELETE `T1` FROM `fl_ipgeo` AS `T1` LEFT JOIN `fl_ipgeo_locations` AS `T2` ON `T1`.`Loc_ID` = `T2`.`Loc_ID` WHERE `T2`.`Country_code` <> 'GB';
    DELETE FROM `fl_ipgeo_locations` WHERE `Country_code` <> 'GB';

    screenshot after 1-st request: https://prnt.sc/rzoms7
    screenshot after 2-nd request: https://prnt.sc/rzonm3
    I just need more explanation regarding how to run 2 mysql queries inorder to minimize the size of locations/IP Geo database for just one country?

+ Reply to Thread