Support Forums

guillopuig · 11-04-2009, 04:16 PM

What is the name of the table holding the classified ads?

i am looking to import a bunch of ads under my own admin account but I am not sure which table it is.

Lhotch · 11-04-2009, 04:50 PM

_products.

If you have to ask that question I recommend extreme caustion when importing your ads or you could make a huge mess of things in a hurry.

guillopuig · 11-04-2009, 05:37 PM

well... i already went through all of my tables and had singled out listings as the table i needed to import too.

the products table is meant only for the price plans i am using, not for the actual ads.

Check out class_1listings. that seems to be the one.

I have noticed though that the optional parent child fields are not showing up in that particular table. Im guessing it gets requested when the ad id gets shown.

Please let me know what you think.

thanks

Lhotch · 11-04-2009, 05:57 PM

oops, yes, my fault, the table names were changed from v3 to v4.

All of the extra fields are stored in different tables. One holds the names, one the values and one the association of fields to categories if memory serves right.

Your best bet really is to just look at the checkout process and follow the queries the script makes and how it collects and writes the info.

11-04-2009, 04:16 PM	#1
guillopuig Senior Member Join Date: Oct 2009 Posts: 184 Rep Power: 4	Database Tables What is the name of the table holding the classified ads? i am looking to import a bunch of ads under my own admin account but I am not sure which table it is.

11-04-2009, 04:50 PM	#2
Lhotch Coder Join Date: Mar 2006 Posts: 4,895 Rep Power: 119	_products. If you have to ask that question I recommend extreme caustion when importing your ads or you could make a huge mess of things in a hurry. __________________ Larry Knowledge *learned* is more valuable than knowledge *given*.

11-04-2009, 05:57 PM	#4
Lhotch Coder Join Date: Mar 2006 Posts: 4,895 Rep Power: 119	oops, yes, my fault, the table names were changed from v3 to v4. All of the extra fields are stored in different tables. One holds the names, one the values and one the association of fields to categories if memory serves right. Your best bet really is to just look at the checkout process and follow the queries the script makes and how it collects and writes the info. __________________ Larry Knowledge *learned* is more valuable than knowledge *given*.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
UTF-8 tables	Tim_A	Technical Support	5	03-27-2008 03:52 PM
Database tables	calaf6	v3.1 Questions & Support	2	10-16-2007 07:30 PM
Copying backed up database to a new database	GSP	v3.1 Questions & Support	7	03-17-2007 10:44 AM
What are these tables?	Chad	v3.1 Questions & Support	4	10-11-2006 09:11 AM
Tables resizing	calaf6	Templates, HTML, CSS, and Design Help	3	03-29-2006 06:14 PM

11-04-2009, 05:37 PM	#3
guillopuig Senior Member Join Date: Oct 2009 Posts: 184 Rep Power: 4	well... i already went through all of my tables and had singled out listings as the table i needed to import too. the products table is meant only for the price plans i am using, not for the actual ads. Check out class_1listings. that seems to be the one. I have noticed though that the optional parent child fields are not showing up in that particular table. Im guessing it gets requested when the ad id gets shown. Please let me know what you think. thanks

Support Forums

Database Tables

This topic is resolved.