Welcome, Guest
Username: Password: Remember me

TOPIC: Locations database

Locations database 2 years 6 months ago #2730

I need you to send me a SQL database so that I can install locations automatically. My site needs to look like craigslist. I have asked you before and haven't received it yet. Please send it ASAP.



Thank you.
The administrator has disabled public write access.

Locations database 2 years 6 months ago #2733

  • Super User
  • Super User's Avatar
  • Offline
  • Administrator
  • Posts: 2756
  • Thank you received: 291
  • Karma: 40
Please check our below sample SQL query to add the locations in the database.
INSERT INTO `#__jomcl_locations` (`id`, `name`, `alias`, `type`, `parent`, `ordering`, `published`) VALUES ('', 'USA','', '', 0, 1, 1),('','INDIA','','',0,1,1),('','CANADA','','',0,1,1),('','ENGLAND','','',0,1,1),('','SPAIN','','',0,1,1),('','AUSTRALIA','','',0,1,1),('','GERMANY','','',0,1,1)

Kindly replace the "#_" with your table prefix in the above query and add all your locations in the above format. you just add ",('','GERMANY','','',0,1,1)" and change only the Location name (GERMANY).

Please check the below video for the tutorial to run the SQL query in phpmyadmin database.

Last Edit: 2 years 6 months ago by Super User.
The administrator has disabled public write access.
Time to create page: 0.192 seconds