OrdaSoft forum
Welcome, Guest
Please Login or Register.    Lost Password?
VehicleManager component support
Go to bottom Favoured: 0
TOPIC: SQL To update listing type
#18548
davec (User)
Fresh Boarder
Posts: 19
graphgraph
User Offline Click here to see the profile of this user
SQL To update listing type 9 Months, 1 Week 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 (Admin)
Admin
Posts: 2858
graphgraph
User Offline Click here to see the profile of this user
Re:SQL To update listing type 9 Months, 1 Week ago Karma: 55  
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)
Fresh Boarder
Posts: 19
graphgraph
User Offline Click here to see the profile of this user
Re:SQL To update listing type 9 Months, 1 Week 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 (Admin)
Admin
Posts: 2858
graphgraph
User Offline Click here to see the profile of this user
Re:SQL To update listing type 9 Months, 1 Week ago Karma: 55  
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)
Fresh Boarder
Posts: 19
graphgraph
User Offline Click here to see the profile of this user
Re:SQL To update listing type 9 Months, 1 Week ago Karma: 0  
Hi

I have now done this manually.

Dave
 
Logged Logged  
  The administrator has disabled public write access.
#18560
Taras (Admin)
Admin
Posts: 2858
graphgraph
User Offline Click here to see the profile of this user
Re:SQL To update listing type 9 Months, 1 Week ago Karma: 55  
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
What are you looking for?
Anti-spam question: How many eyes has a typical person?