Welcome, Guest
Username: Password: Remember me

TOPIC: Locations database

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

  • Super User
  • Super User's Avatar
  • Offline
  • Administrator
  • Posts: 3019
  • Thank you received: 352
  • 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 6 months ago by Super User.
The administrator has disabled public write access.
Time to create page: 0.123 seconds

Contact us

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