direct sql (insert new listing)

[Aleksander Godzilo-godlewski]

Hi all,
I'm looking for the simplest way to inser new listing into only one category from specific user with Title, price, description and 3 photos.
I already did home work and analyzed mysql. log but I don't want to force open doors and maybe someone already did some script (bash/php/other)?

[Rudi]

Hello,

you can use sql request for inserting listing but without photos:



INSERT INTO `fl_listings` ( `Plan_ID`, `Plan_type`, `Last_type`, `Date`, `Category_ID`, `Account_ID`, `Status`, `Pay_date`, `title`, `price`, `additional_information`)
VALUES ( '1', 'listing', 'standard', NOW(), '122', '1', 'active', NOW(), 'Test AD', '15000|dollar', 'some text')

[Aleksander Godzilo-godlewski]

Thank you.