importing old data

[ombre +]

Hi,
have a classifieds site and would like to import my users, ads and photos in the 68classifieds mysql schema.

What is the relationship between users, ads and photos in 68classifieds schema.

in my photos table i have photo_id and ad_id columns and can identify which photos belong to a listing,
how is this achieved in 68classifieds database schema?

Regards,
ombre

[Mike-N-Tosh +]

There is one table that holds the image information called "prodimages".

It has the following fields:
id <== image id defined by the database
pid <== same as the oid in the orders table (this is the listing id join)
title <== optional text for individual picture
image <== file name of the individual picture
rank <== ranking number used for when there are multiple pictures for one ad.

When a picture is uploaded the picture is assigned an id and the pid tying it to the ad listing id. It is also given a numeric image filename. It is resized with the parameters set in admin and is saved to the "photos" directory for the normal sized pic and also resized for the thumbnail pic with the same file name, but with a prefix of "small_" and is saved to the "thumbs" directory.

Hope that helps,
-Mike

[Lhotch +]

Part of the 68c image upload process resizes images and makes thumbnails as well so thats something to think about.

[Maffo +]

I have a bulk upload system that we could somehow configure to do this. Details can be found by going to my website (links in my signature). If they outlay is too much I could do this for you using the system.

[ombre +]

Originally Posted by Maffo

I have a bulk upload system that we could somehow configure to do this. Details can be found by going to my website (links in my signature). If they outlay is too much I could do this for you using the system.

thanks, the upload script is, with a PRICE: £150.00, to much for me :-).

[Maffo +]

Thats why I said if the outlay is too much I could do it for you. The system is meant for people who want to contact dealers etc.

[ombre +]

Originally Posted by Mike-N-Tosh

There is one table that holds the image information called "prodimages".

It has the following fields:
id <== image id defined by the database
pid <== same as the oid in the orders table (this is the listing id join)

title <== optional text for individual picture
image <== file name of the individual picture
rank <== ranking number used for when there are multiple pictures for one ad.

When a picture is uploaded the picture is assigned an id and the pid tying it to the ad listing id. It is also given a numeric image filename. It is resized with the parameters set in admin and is saved to the "photos" directory for the normal sized pic and also resized for the thumbnail pic with the same file name, but with a prefix of "small_" and is saved to the "thumbs" directory.

Hope that helps,
-Mike

So you say that the pid is not the same as listing id ? That means that when i import my ads (listings) i must also make a
reference to the orders table and from there to gain the pid, or ?

[ombre +]

Originally Posted by Maffo

Thats why I said if the outlay is too much I could do it for you. The system is meant for people who want to contact dealers etc.

Ok, tell me more on PM, maybe we can make something :-)

[ombre +]

now i can upload my old users in the system. it is a long perl script