Skip to Content Skip to Menu

🎃 Happy Halloween! Treat yourself with an awesome discount on memberships! Get 20% off now with code SPOOKY-2024!

CB Query Field Plugin

  • sacromar
  • sacromar
  • OFFLINE
  • Posts: 38
  • Thanks: 0
  • Karma: 0
8 years 8 months ago - 8 years 8 months ago #277829 by sacromar
CB Query Field Plugin was created by sacromar
Hi, I need to insert territorial fields to registration form of my site created with Joomla 3.4.x and 2.0.x between CB Builder Registration fields, with Italian Regions, Provinces and Cities. I would like to use CB Query field plugin, as explained in this tutorial : www.joomlapolis.com/support/tutorials/107-use-cases/18533-configuring-dynamic-usa-state-city-zip-fields-with-cb-query-field-plugin

Is there a similar tutorial for Italian regions including sql file for Italy ?
Thank you
Last edit: 8 years 8 months ago by sacromar.

Please Log in or Create an account to join the conversation.

  • krileon
  • krileon
  • ONLINE
  • Posts: 48460
  • Thanks: 8280
  • Karma: 1443
8 years 8 months ago #277848 by krileon
Replied by krileon on topic CB Query Field Plugin
The tutorial is valid for any region. You just need to supply your own database tables. If you had CBSubs you could use the tables provided by CBSubs Tax, but beyond that you'll just need to Google around for some SQL files that fit your needs. There's quite a few SQL dumps on GIST that'll probably work for you.

gist.github.com/

Example searches as follows.

gist.github.com/search?l=sql&q=country+list+sql

gist.github.com/search?l=sql&q=city+list+sql

There's also several free geo database sites available around the web. Just takes some searching to find what fits your needs. It's a lot of information for your database though, but regardless has been a widely desired feature.


Kyle (Krileon)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Documentation + Search the forums
CB links: Documentation - Localization - CB Quickstart - CB Paid Subscriptions - Add-Ons - Forge
--
If you are a Professional, Developer, or CB Paid Subscriptions subscriber and have a support issue please always post in your respective support forums for best results!
--
If I've missed your support post with a delay of 3 days or greater and are a Professional, Developer, or CBSubs subscriber please send me a private message with your thread and will reply when possible!
--
Please note I am available Monday - Friday from 8:00 AM CST to 4:00 PM CST. I am away on weekends (Saturday and Sunday) and if I've missed your post on or before a weekend after business hours please wait for the next following business day (Monday) and will get to your issue as soon as possible, thank you.
--
My role here is to provide guidance and assistance. I cannot provide custom code for each custom requirement. Please do not inquire me about custom development.

Please Log in or Create an account to join the conversation.

Moderators: beatnantkrileon
Powered by Kunena Forum