script to add pics
Posted: 04 Jan 2009, 09:47
Hi,
I have a lot of pics, approx 20000.
I 'd like to resize them and insert the needed info in the database quickly. I did some "/usr/bin/convert -size -resize...", some "INSERT INTO jos_phocagallery..." in a shell script but I have problems, thumbnails don't seem to be ok.
What must be inserted in the database?
Can you help me please?
I have a lot of pics, approx 20000.
I 'd like to resize them and insert the needed info in the database quickly. I did some "/usr/bin/convert -size -resize...", some "INSERT INTO jos_phocagallery..." in a shell script but I have problems, thumbnails don't seem to be ok.
What must be inserted in the database?
Can you help me please?