Joomla Extensions by Joomdonation
OS Property support center

How to update cities to published with 1 sql query

  • sean01
  • Topic Author
  • Offline
  • Senior Member
  • Senior Member
  • here to help!
More
12 years 4 months ago #22396 by sean01
How to update cities to published with 1 sql query was created by sean01
I would like to update all cities to published with one mySQL QUERY.. having to manually all records is taking up too much time!

many thanks for any help

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

More
12 years 4 months ago #22407 by Tuan Pham Ngoc
Replied by Tuan Pham Ngoc on topic Re: How to update cities to published with 1 sql query
Hi Sean

Could you please explain more details ? What are the cities you are talking about ?

Tuan

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

  • sean01
  • Topic Author
  • Offline
  • Senior Member
  • Senior Member
  • here to help!
More
12 years 4 months ago #22471 by sean01
Replied by sean01 on topic Re: How to update cities to published with 1 sql query
I purchased osproperty, i have installed all countries,States and Cities, by default all are unpublished, i would like to know how to publish all of the cities for each country as doing it manually is taking hours. Sean

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

More
12 years 4 months ago #22500 by Tuan Pham Ngoc
Replied by Tuan Pham Ngoc on topic Re: How to update cities to published with 1 sql query
Hi Sean

I moved this post to the correct from so that Dam (the developer of OS Property) will check and guide you !

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

More
12 years 4 months ago #22515 by Mr. Dam
Replied by Mr. Dam on topic Re: How to update cities to published with 1 sql query
Hi
To publish all your cities, please use this query
UPDATE (PREFIX)_osrs_cities SET `published` = 1

Thanks
Dam

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

  • sean01
  • Topic Author
  • Offline
  • Senior Member
  • Senior Member
  • here to help!
More
12 years 4 months ago #22536 by sean01
Replied by sean01 on topic Re: How to update cities to published with 1 sql query

damdt wrote: Hi
To publish all your cities, please use this query
UPDATE (PREFIX)_osrs_cities SET `published` = 1

Thanks
Dam


That did the trick, thank you Dam :)

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

Moderators: Mr. Dam, Nguyen Phu Quan

Support

Documentation

Information

Copyright © 2025 Joomla Extensions by Joomdonation. All Rights Reserved.
joomdonation.com is not affiliated with or endorsed by the Joomla! Project or Open Source Matters.
The Joomla! name and logo is used under a limited license granted by Open Source Matters the trademark holder in the United States and other countries.

Connect Us