Product Extra Fields for text, pdfs and flash

[BillsWebBiz]

How long does it take for the new version of the plugin to show up on the Add-Ons Page? Are they usually this slow?

Thanks,
Bill

[Lowie]

I finally got the checking if the video field in database is filled function done. Just need a little copy-paste so ill explain it to you guys. This adds a column to your prodcut listing showing if there is a flash file or not linked to the product.

You need to edit one of the excisting columns so i picked WEIGHT (so this function can be turned off or on when you disable WEIGHT at Admin->Product Listing)

Go to includes/modules/product_listing.php and then go to case 'PRODUCT_LIST_WEIGHT':

Delete the whole code within the case 'PRODUCT_LIST_WEIGHT': and the break; tag. Then add the following code:

    $sql5 = "select * from " . TABLE_PRODUCT_EXTRA_FIELDS . "
            where products_id = '" . $listing->fields['products_id'] . "'";

    $files = $db->Execute($sql5);
    $products_video = $files->fields['video'];

if (!empty($products_video))
{ 
$lc_text = 'This product has a flash file'; 

} else {

$lc_text = '';

}

This is a quick solution and i havent tested it fully yet, but it seems to work perfect. Good luck

Example:
http://alturl.com/in5vr
(check the column to the left named Movie)

[Techiescot]

Hi

I seem to almost have this working with the latest zen cart (1.3.9h) but not quite ....

When I go to look at one of the files, I get the following error message:

Forbidden

You don't have permission to access /product_extra_files/ on this server.

Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.

Any idea what I need to do? I have changed the permissions ... and uploaded the document (a pdf) but cannot get it to open.

Arrrgghhh ... so close and yet so far. When I hover over the link, it shows the folder but not the particular file ...

Any help, gratefully received ...

Gillian

[delia]

You shouldn't be able to view that folder in a browser - only thru ftp.

If the file itself isn't showing in the link, then something isn't working.

At this point, I'll send the newest version via email since it hasn't been added to this site. Obviously, whoever is in charge is on vacation.

Just PM me with your email address.

[delia]

The newest version for 1.3.9h is up in the contributions finally:
http://www.zen-cart.com/index.php?ma...oducts_id=1331

[Techiescot]

Hi Delia

I have gone through the new files and merged the changes to my Zen Cart. However, I still cannot get it to work entirely. Attached is a screen shot of what is showing.

The top section are some fields I altered using product_weight as a starting point. Most of those work (except one which inexplicably will work if I populate it from the database but not from the admin pages).

Below are your extra fields. The first is a Youtube video but all I get is text. The other documents are pdf but when I go to click on them I get the following error message ...

Forbidden

You don't have permission to access /product_extra_files/ on this server.

Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.

Any ideas what I am doing wrong?

Many thanks.


Gillian

[delia]

I would guess you are on zen cart version 1.3.9g - upgrade to h, the problems have been fixed.

[Techiescot]

Hi Delia

No, I have already upgraded to h ...


Gillian

[Techiescot]

Hi

I have compared all files and ensured that I have everything updated correctly (using 1.3.9h and product_extra_fields ver. 5)

Slowly getting closer but still not got it working ...

Now when I add a file (e.g. Redwood.pdf), I can see the file in the link ... See the attached jpg. At the top of the attachment you can see it shows that the pdf has been successfully added and at the bottom it shows the location of the file when I hover over the link ...

For some reason, it is showing the product_extra_fields folder as being in the Admin folder. I had put it into the main folder ... So that is the first problem ....

Next, when I update the product, and then hover over the link, it no longer shows the document, nor does it show it as being in the ADMIN folder ... so there is something going wrong there.

Also, when I go to the store, the file is not showing up ... still just going to the folder and not the file itself.


Any ideas?


Gillian

[Techiescot]

Oops here is the attachment ...