Welcome, Guest
Username: Password: Remember me

TOPIC: Locations database

Locations database 5 years 11 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 5 years 11 months ago #2733

  • Super User
  • Super User's Avatar
  • Offline
  • Administrator
  • Posts: 3039
  • Thank you received: 353
  • Karma: 46
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: 5 years 11 months ago by Super User.
The administrator has disabled public write access.
Time to create page: 0.180 seconds

Contact us

  No.2/A, Venkateshwara Nagar,
1st Main Road, 100 Feet Road, SBM Towers, Velachery,Chennai - 600 042,India.
Copyright © 2013-2020 Jomclassifieds.com. All rights reserved. The Joomla! name, and logo are used under a limited license granted in the United States and other countries.