Strip Tags in Description

[benn600]

With our new online store, we are using descriptions and data from our previous system. Unfortunately, we do not want to strip out all the code that we have in them but we would like to remove it on the fly. Where can I find the spot that I can insert the PHP strip_tags function to apply to the data from the database?

I want the short description limiting (to ~200 characters) to be done after the tags are removed of course.

[benn600]

Where does Zencart keep all its MySQL queries? For example, where is select * from products?? (where...)

[Chrome Orange]

Where does Zencart keep all its MySQL queries? For example, where is select * from products?? (where...)

you need to look at the developers tool kit in the admin section of your site

[benn600]

I'm looking there. Where should I see queries? My issue is (maybe you can help solve it) that I need to run a php function on the "products_description" field for the main product text. It's a function I wrote to give all our descriptions a similar look (it finds and replaces some things). So if I can find where the queries are at and where they are run, I can just change it there so I don't have to change it on every page.

In looking through the Zencart files I'm having trouble finding a single query!

[DrByte]

Reference: http://www.zen-cart.com/index.php?ma...roducts_id=378

For the product page, you're probably needing to look at the /includes/modules/pages/product/main_template_vars.php or header_php.php

For the product-listings, try /includes/modules/product_listing.php

[benn600]

main_template_vars worked PERFECTLY for fixing the product info display page. The SQL is in there and I was able to fix the result right there.

Now for the product listing on search results (category listing) I can't seem to find the same thing.

Where is the SQL statement that gets info for listing products on a product_listing page?

Your assistance is greatly appreciated. Thanks!

[DrByte]

Where is the SQL statement that gets info for listing products on a product_listing page?

As I said, the product listing is built in /includes/modules/product_listing.php via:

zen_trunc_string(zen_clean_html(stripslashes(zen_get_products_description($listing->fields['products_id'], $_SESSION['languages_id']))), PRODUCT_LIST_DESCRIPTION)

If you don't want to modify it there, then go change the zen_get_products_description() function in the functions folder instead.

[benn600]

Now I am clicking on a category and all the products that list is where I'm seeing the problem.

zen_trunc_string(zen_clean_html(stripslashes(zen_get_products_description($listi ng->fields['products_id'], $_SESSION['languages_id']))), PRODUCT_LIST_DESCRIPTION)

if I change this to
zen_trunc_string(zen_clean_html(stripslashes('TESTING' . zen_get_products_description($listing->fields['products_id'], $_SESSION['languages_id']))), PRODUCT_LIST_DESCRIPTION)

it doesn't seem to change anything on the description list.

[DrByte]

There are two instances of that in the file ... one which fires if a manufacturer filter has been selected, and one where no filter is selected.
Which one did you alter?

[benn600]

Amazing! Thanks! There are two lines. I fixed both of them.

Now one final question. We have a secondary ID for all our products to link with another system. Where is the actual SQL that gets this data? I need to add a field for it to get.

Thank you!