Hello Anyone has a search tagcloud mod?

[adam9110]

I have seen this mod in oscommerce cart.
But can not find it in zencart.

Many cool website has these features..

Maybe someone can change the code from Oscommerce to zencart .

check the link of search tagcloud in OS.

addons.oscommerce.com/info/5498

Kind Regards,
Adam

[lankeeyankee]

A zen beta version has been released. Go to http://www.madteckhead.com/blog/zentagcloud to download it.

Matt

[adam9110]

Hello Lankeeyankee,
Thanks for your kind reply.

I have tried this mod days ago.
It works,
But it can not limit the numbers of the tags to be shown.

THe problem is Your webpage will be mass!

I have been contact the author. It seems he dont follow this project currently.

So hope , anyone can get it work.
Thanks

[yellow1912]

Should be an easy fix, you just need to use LIMIT in the sql query, if you know what I mean. Check the file includes/functions/extra_functions/zentagcloud_func.php, I suspect that you need to change

function zen_get_metatags_keywords1($product_id, $language_id) {
    global $db;
    $product = $db->Execute("select metatags_keywords
                             from " . TABLE_META_TAGS_PRODUCTS_DESCRIPTION . "
                             where products_id = '" . (int)$product_id . "'
                             and language_id = '" . (int)$language_id . "'");

    return $product->fields['metatags_keywords'];
  } 

to:

function zen_get_metatags_keywords1($product_id, $language_id) {
    global $db;
    $product = $db->Execute("select metatags_keywords
                             from " . TABLE_META_TAGS_PRODUCTS_DESCRIPTION . "
                             where products_id = '" . (int)$product_id . "'
                             and language_id = '" . (int)$language_id . "' LIMIT 50");

    return $product->fields['metatags_keywords'];
  } 

See the limit i put there? Change it to any number you want.
Again, I dont use this mod, so I'm not 100% sure that it's the query to get the tags (I just think it's the one because of the function's name), but it's the way you do it: find the query that gets the tags, and put a limit there.
yellow1912

[adam9110]

Hello Yellow1912,

you are right. I got it work.

Thanks for your help

Regards,

[adam9110]

Hello yellow1912 ,

It is so weird, i test you method as you indicated above.

I can only limit the category's number and the max is 4. If you Limit 5 above , the all category will be shown.

And I have no method to limit numbers of the Meta keywords.
Please check it back.
Thanks very much

[swguy]

Adam, if you give this feedback to the original author, perhaps he can build these things in.

[yellow1912]

Hello yellow1912 ,

It is so weird, i test you method as you indicated above.

I can only limit the category's number and the max is 4. If you Limit 5 above , the all category will be shown.

And I have no method to limit numbers of the Meta keywords.
Please check it back.
Thanks very much

Are you sure you modify the correct query? The one I show you to modify should not have anything to do with the number of categories.

[yellow1912]

Try to change:

$products_new_query_raw = "SELECT products_id 
                             FROM " . TABLE_PRODUCTS . " p 
                             WHERE products_status = 1 

to

$products_new_query_raw = "SELECT products_id FROM zen_products p WHERE products_status = 1 ORDER BY RAND() LIMIT 50 

You can remove the part ORDER BY RAND() if you want, that part helps you to get random products_ids each time it does a query

Note: this will make the keywords' weight incorrect since it will consider only a limited number of products each time. You will need to dig deeper into the code to find a better way to fix this, I don't have time to do that now

[tonibarcelona]

Any url with a working example of this mod?