Product Extra Fields for text, pdfs and flash

[oavs]

How can you delete or un associate the once you upload a pdf file?

For example I have uploaded a pdf for product and it shows fine.
Now I duplicate the product and then rename the product but I want to remove previously uploaded file. I do not want to link to any file. Just leave as blank.

How?

[delia]

well, that wasn't anticipated! and therefore not possible in admin if I remember correctly. It would have to be a database change. If you are comfortable with working with phpmyadmin, this information is all stored in one table named products_extra_fields. Do a search for the product id that you are wanting to change and edit the field that pdf is in. The only checks for displaying is to have something/ anything in that database field.

[oavs]

Thank you for getting back to my question. Yes as you said I basically deleted in phpMyAdmin.
It would be great if there was an option to delete in case file was old/incorrect one.

Thank you

[jimmie]

hello, instead of uploading file,( i have problems uploading) is there a way we can add a field to put in file name, like we can do for images on product info page?
like this Or, select an existing file from server, filename: ########################################_

[delia]

It's simply way more complicated than that. Otherwise there would be no need for a full mod.

[jimmie]

i figured it out,
i changed it to this,

<td class="main"><?php echo zen_draw_separator('pixel_trans.gif', '24', '15') . '&nbsp;' . zen_draw_input_field('file_1') .  '&nbsp;'. TEXT_PRODUCTS_FILE_DESCRIPTION . ' ' . zen_draw_input_field('file_1_title', $pInfo->file_1_title) . zen_draw_hidden_field('previous_file_1', $pInfo->file_1).' '.$pInfo->file_1; ?></td>

. first i upload file through ftp than put in info.

[jimmie]

how can i add your modification into this modification?

FROM " . TABLE_PRODUCTS . " p
                              LEFT JOIN " . TABLE_PRODUCTS_DESCRIPTION . " pd ON (p.products_id = pd.products_id)" . $npf_tables . "
                              WHERE p.products_id = '" . (int)$_GET['pID'] . "'
                              AND pd.language_id = '" . (int)$_SESSION['languages_id'] . "'");

from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd,
                                   " . TABLE_PRODUCT_EXTRA_FIELDS . " pe
                              where p.products_id = '" . (int)$_GET['pID'] . "'
                              and p.products_id = pd.products_id and p.products_id = pe.products_id
                              and pd.language_id = '" . (int)$_SESSION['languages_id'] . "'");

[jimmie]

installed this on v 1.56 and it seems to work except when clicking the link, it goes to homepage

[delia]

last version updated to is 1.5.4

[jimmie]

last version updated to is 1.5.4

anyway of making it compatible with v 1.56c