MultiSite Module Support Thread

[Gerome]

Version 0.4 is released.

It can be downloaded from here:
http://www.medea.co.uk/dev/

Last changes:
- lots of minor bugs fixed
- Admin tools in: Tools -> Multisite Tools allows an easy management of categories
- Multi languages now supported
- cPath calculation integrated with the category filter
- The category filter can now be desactivated with this line:

define('ALLOW_CAT_FILTER','no'); //Desactivate the cat_filter for a site 

- You can now change the root category of your store by writing this line in your config files:

define('CATEGORIES_ROOT','21'); //root categories is 21 for this site 

[stav]

One sindax error.
File:
includes/functions/extrafunctions/cat_filter.php

Line: 76
from
INNER JOIN categories_description c
to
INNER JOIN ".TABLE_CATEGORIES_DESCRIPTION." cd

Line: 80
from
INNER JOIN categories as c
to
INNER JOIN ".TABLE_CATEGORIES." as c


For me, in this new version all filtering with multilangual installation working fine exept the main_page=products_new

Congratulation Gerome :)

[HiPCTech]

Hello Gerome,

I have added all my products through Easy Populate. I don't know of another module that would do that. The thing is that when I add all my products with this module the master_categories_id is not populated so I run into problems with listing my products.

I found a quick fix though. in the cat_filter.php function I changed line 90 with the following code:

$sql = substr($sql,0,$add_pos).
        " INNER JOIN ".TABLE_CATEGORIES_DESCRIPTION." cd
        ON (p.master_categories_id = cd.categories_id
        AND cd.language_id=".$_SESSION['languages_id']."
        AND cd.categories_description LIKE '%-".SITE_NAME."-%') ".
        substr($sql,$add_pos); 

to this:

if(preg_match("/from zc_products_description pd, zc_products p left join zc_manufacturers m on p.manufacturers_id = m.manufacturers_id, zc_products_to_categories p2c left join zc_specials s on p2c.products_id = s.products_id/",$sql))
{
    $sql = substr($sql,0,$add_pos).
            " INNER JOIN ".TABLE_CATEGORIES_DESCRIPTION." cd
              ON (cd.categories_id = p2c.categories_id
              AND cd.language_id=".$_SESSION['languages_id']."
              AND cd.categories_description LIKE '%-".SITE_NAME."-%') ".
            substr($sql,$add_pos);
} else {
    $sql = substr($sql,0,$add_pos).
            " INNER JOIN ".TABLE_CATEGORIES_DESCRIPTION." cd
              ON (p.master_categories_id = cd.categories_id
              AND cd.language_id=".$_SESSION['languages_id']."
              AND cd.categories_description LIKE '%-".SITE_NAME."-%') ".
            substr($sql,$add_pos);
} 

I just made it to check after the products_to_categories table instead of the products.master_categories_id field. It has solved the problem for me for now. The problem that I should really solve is the one with EP but that is in the future.
I hope that this helps someone.

God bless. Amazing Discoveries.

[HiPCTech]

Actually forget about the earlier post. The Lord answered my prayers even better and led me to this post: Here

Where DrByte tells how to reset the master_categories_id. so it is all solved without changing your code!

Praise the Lord

[HiPCTech]

I think I found a bug in the cat_filter.php function on line 76. I didn't have time to check the forum but I downloaded the latest version.

This is the warning:

1146 Table '[#database#].categories_description' doesn't exist
in:
[select p2c.categories_id from zc_products p, zc_products_to_categories p2c 
INNER JOIN [COLOR="Red"]categories_description[/COLOR] cd ON 
(p2c.categories_id=cd.categories_id AND cd.language_id=1 AND cd.categories_description LIKE '%-[#Site_name#]-%') 
INNER JOIN categories as c ON 
(cd.categories_id=c.categories_id 
AND c.categories_status=1)
where p.products_id = '75' and p.products_status = '1' 
and p.products_id = p2c.products_id limit 1]

the table in red is the problem. The code in the function file is at line 76 and

INNER JOIN categories_description cd 

should be changed to

INNER JOIN ".TABLE_CATEGORIES_DESCRIPTION." cd 

Same it is with line 80

Thank you for the contribution.
God bless. Amazing Discoveries.

[Gerome]

Hi HiPCTech,

Actually, stav signaled this problem last week before you and I fixed it in the version beta 0.4.1 that I released as soon as I heard from it.

You can just swap your cat_filter.php by the one from this new version and it will be solved.

Regards,

Gerome.

I think I found a bug in the cat_filter.php function on line 76. I didn't have time to check the forum but I downloaded the latest version.

This is the warning:

1146 Table '[#database#].categories_description' doesn't exist
in:
[select p2c.categories_id from zc_products p, zc_products_to_categories p2c 
INNER JOIN [color="Red"]categories_description[/color] cd ON 
(p2c.categories_id=cd.categories_id AND cd.language_id=1 AND cd.categories_description LIKE '%-[#Site_name#]-%') 
INNER JOIN categories as c ON 
(cd.categories_id=c.categories_id 
AND c.categories_status=1)
where p.products_id = '75' and p.products_status = '1' 
and p.products_id = p2c.products_id limit 1]

the table in red is the problem. The code in the function file is at line 76 and

INNER JOIN categories_description cd 

should be changed to

INNER JOIN ".TABLE_CATEGORIES_DESCRIPTION." cd 

Same it is with line 80

Thank you for the contribution.
God bless. Amazing Discoveries.

[stav]

Gerome

The filtering for the main_page=products_new don't work for me.
But if i add in includes/templates/template_default/templates/tpl_modules_products_new_listing.php

from

$products_new = $db->Execute($products_new_split->sql_query); 

to

$products_new = $db->Execute(cat_filter($products_new_split->sql_query)); 

The filtering is working OK. but the counting for the split page is not working ok
p.x. (1 to 9 from 21) the counter is showing all the products.

Thesame problem with the counter I have in the feautured products too.
All other filtering working ok.


BTW below is one more filter that is missing for the categories dropdown in product list by manufacturers.

File:
includes/index_filters/default_filter.php

Line:167
from

$filterlist = $db->Execute($filterlist_sql); 

to

$filterlist = $db->Execute(cat_filter($filterlist_sql)); 

Thanks!!.