+ Reply to Thread
Page 2 of 3 FirstFirst 123 LastLast
Results 11 to 20 of 21

Thread: Location / IP Geo plugin restrict to one country

  1. #11
    Do you want to minimize your database too? Do you want to use your site in 1 country and the country United Kingdom?
    Viktor,
    Flynax technical department,
    Best wishes.

  2. #12
    Quote Originally Posted by Viktor View Post
    Do you want to minimize your database too? Do you want to use your site in 1 country and the country United Kingdom?
    yes i want to restrict my site to 3 countries inorder to minimize data storage, but recently, Flynax announced that you're working on the Multifield plugin inorder to optimizing data storage, so i can wait until then.

  3. #13
    Senior Member
    Join Date
    Mar 2016
    Posts
    181
    Victor. How to implement this in my case. I want to target 1 country = Philippines only.

  4. #14
    You can use similar MySQL queries with your country code:

    Code:
    Only registered members can view the code.
    Viktor,
    Flynax technical department,
    Best wishes.

  5. #15
    Senior Member
    Join Date
    Mar 2016
    Posts
    181
    Hi Viktor.. Can you please give some further instruction about the MySQL queries.. and please see the attached image.
    Screen Shot 2020-05-13 at 12.04.42 AM.png

  6. #16
    What instruction do you want? Need to run only 2 MySQL queries which I wrote above.
    Viktor,
    Flynax technical department,
    Best wishes.

  7. #17
    Senior Member
    Join Date
    Mar 2016
    Posts
    181
    when i update the query the "nothing selected" appears. Screen Shot 2020-05-14 at 12.21.40 AM.png

  8. #18
    Senior Member
    Join Date
    Mar 2016
    Posts
    181
    oh i successfully run into SQL tab, but i don't see the difference.
    and the listings and plugins i think still able to search to another country. please see the attached image. Screen Shot 2020-05-14 at 12.42.32 AM.pngScreen Shot 2020-05-14 at 12.41.44 AM.png

    and the size of database are also still the same. How can i reduce the size of DB?Screen Shot 2020-05-14 at 12.37.39 AM.png.

  9. #19
    Flynax developer Rudi's Avatar
    Join Date
    Dec 2014
    Location
    Planet Earth
    Posts
    3,138
    IP geo database has nothing to do with maps

    see this thread: https://forum.flynax.com/showthread....to-one-country

  10. #20
    Senior Member
    Join Date
    Mar 2016
    Posts
    181
    thank you Viktor and Rudi..
    ... and Rudi, i just want to followup my ticket .... # RTN-106457

+ Reply to Thread