OrdaSoft forum
Welcome, Guest
Please Login or Register.    Lost Password?

VehicleManager component support

Go to bottom Favoured: 0

SQL To update listing type

#18548
davec (User)
Junior Boarder
Posts: 36
graphgraph
User Offline Click here to see the profile of this user
SQL To update listing type 8 Years, 1 Month ago
Karma: 0  
Hi

I have a list of vehicles that I imported but they do not have a listing type attached, ie To Rent or For Sale. Is there an SQL query that I could run to update the database so that all verhicles are for sale?

Thanks

Dave
Logged Logged
The administrator has disabled public write access.
#18549
Taras (User)
Platinum Boarder
Posts: 2857
graphgraph
User Offline Click here to see the profile of this user
Re:SQL To update listing type 8 Years, 1 Month ago
Karma: 58  
Dear Dave,

Thank you for your question.

In database you need find table "_vehiclemanager_vehicles"

and edit in it "listing type". You need change values for listing type from 1 to 2 and you will get all vehicles for sale.

check attached image

thanks
Logged Logged
Last Edit: 2016/02/26 15:13 By Taras.
The administrator has disabled public write access.
#18550
davec (User)
Junior Boarder
Posts: 36
graphgraph
User Offline Click here to see the profile of this user
Re:SQL To update listing type 8 Years, 1 Month ago
Karma: 0  
Hi Taras

Thanks for the reply. I have found the table no problem. What I was looking for was query I could run via PhpMyadmin that would update those values. Manually doing this for each vehicle is what I was looking to avoid.

Thanks

Dave
Logged Logged
The administrator has disabled public write access.
#18558
Taras (User)
Platinum Boarder
Posts: 2857
graphgraph
User Offline Click here to see the profile of this user
Re:SQL To update listing type 8 Years, 1 Month ago
Karma: 58  
Hello,

If You knowing PHP you can set query by yourself or write on our contact form and ask about customization service.
ordasoft.com/contact-us-form
Our team will make for you that update.

Best Wishes,
Taras
OrdaSoft team
Logged Logged
The administrator has disabled public write access.
#18559
davec (User)
Junior Boarder
Posts: 36
graphgraph
User Offline Click here to see the profile of this user
Re:SQL To update listing type 8 Years, 1 Month ago
Karma: 0  
Hi

I have now done this manually.

Dave
Logged Logged
The administrator has disabled public write access.
#18560
Taras (User)
Platinum Boarder
Posts: 2857
graphgraph
User Offline Click here to see the profile of this user
Re:SQL To update listing type 8 Years, 1 Month ago
Karma: 58  
Hello,

Good.

If you will have any questions, please ask.
Best Wishes,
Taras
OrdaSoft team
Logged Logged
The administrator has disabled public write access.
Go to top
Powered by OrdaSoft
 
What are you looking for?
»