export ?

[daniolo]

Hello

does it offer any export possibility pixelpost ? I would export all the images on my "nature" category to my computer . Any idea how to do that please ?

Thank you
Graziano

[dhdesign]

The only way you can export the images in your Pixelpost is to download them via FTP to your local computer. PP doesn't have any export functionality.

[daniolo]

I understand , however on my /images folder I have thousand images , and it's hard (impossible) to find/extract images from this folder only from my category "nature"

Is there any way to know images name collected on "nature" using a search on "phpmyadmin" . I tried but I was not able . Anyone can suggest me the SQL search (I need to know images name for my "nature" category) ?

[Crossie]

I understand , however on my /images folder I have thousand images , and it's hard (impossible) to find/extract images from this folder only from my category "nature"

Is there any way to know images name collected on "nature" using a search on "phpmyadmin" . I tried but I was not able . Anyone can suggest me the SQL search (I need to know images name for my "nature" category) ?

That's easy, the SQL statement reads:

SELECT image FROM pixelpost_pixelpost WHERE category is <your category id>;

The Output will list all imagenames associated with the selected category-id.
Check the table pixelpost_categories for the id of your nature category.

Regards
Uwe

[daniolo]

Thank you , but it does not work.

I am using


SELECT image FROM pixelpost_pixelpost WHERE category is 2


but I am receiving an sql error. Also note that I have 18 categories , and the category numbers shown on pixelpost_pixelpost are only 2 (!)

I found the correct category on pixelpost_categories , but this table does not contains images filename .

Any help please ?

[Dennis]

if you have the category number corresponding to the name then the correct SQL would be:


SELECT image FROM pixelpost_pixelpost WHERE category=2

[daniolo]

if you have the category number corresponding to the name then the correct SQL would be:


SELECT image FROM pixelpost_pixelpost WHERE category=2


this query works , however I have a big result with a lot of photos from other
categories , not only my category . I do not know what "categories" on pixelpost_pixelpost table is , however is NOT the same cat_id in pixelpost_pixelpost .

In other words , I would return the image filename for cat_id 2 in pixelpost_pixelpost (and not category 2 in pixelpost_pixelpost) . Is it possible to execute this quest ? If , please how ?

Thank you

[dakwegmo]

In phpMyAdmin if you browse the Table: pixelpost_categories. You'll see which Category ID corresponds to which name.

In order to get a complete list of which images are in that category though, you'll need to execute something like this in phpMyAdmin.


SELECT 1,t2.id,headline,image,datetime
FROM pixelpost_catassoc as t1
INNER JOIN pixelpost_pixelpost t2 on t2.id = t1.image_id
WHERE t1.cat_id = '2'


Assuming the category you're looking for is in fact 2. If not change the 2 on the last line to whatever the category ID actually is.

[daniolo]

Thank you it works g r e a t .