MultiSite Module Support Thread

[Magnus Wester]

I dont't know why you need different zencart_root/index.php pages for each site.

No, as I wrote in my post you don't.

But if your Zen cart is in a folder, it has nothing to do with the index page in the root folder. And then you need a different solution, outside the Zen Cart environment.

[streetglow]

Now is the day that I release the EZPages Filter.

Sadly I haven't made the admin tool "release-ready".

ezpages_filter_multisite_expansion_by_streetglow.zip

All the shops must use the same currency.

Hmm... really?!
I don't really believe so.
I have made a kind of simulation mode which I can turn on or off in every shop connected to the same database.
This simulation mode simulates array containing the input I want for that shop.
Try debugging a few things...

For example:
What is the currencies variable?
All the info is pumped into this currencies variable by an array.
Simply use the function "print_r();" to see what's inside the array, with this data you can "simulate" the array but now with other data.
Give it a try :-)

[Magnus Wester]

Hi Streetglow,

Perhaps you should post your contribution at http://www.zen-cart.com/index.php?main_page=add_contrib? If you change your module name to begin with "Multisite" and you store it in the "Other modules" category it will end up next to the Multisite Module itself.

Regarding the currency in the shopping basket: all multisite shops share the same shopping basket. I don't believe it's safe to mix currencies in a shopping basket. At least I'm pretty sure that most backend systems haven't been tested for that. That's why I said that all shops should use the same currency. I don't know if it works technically anyway, but I believe it should be avoided.

[stav]

What's New Scrollbox 1.3 xhtml Filter

You can get it from here

After download the sidebox

Oen File: tpl_whats_new.php

Line 54
Find

  $random_product_query = "select products_id, products_image, products_tax_class_id, products_price
                           from " . TABLE_PRODUCTS . "
                           where products_status = '1'
                           order by products_date_added desc
                           limit " . MAX_RANDOM_SELECT_NEW;

	//var_export($random_product);
	
	$random_product = $db->Execute($random_product_query);

and replace with

  $random_product_query = "select p.products_id, p.products_image, p.products_tax_class_id, p.products_price
                           from " . TABLE_PRODUCTS . " p
                           where p.products_status = '1'
                           order by p.products_date_added desc
                           limit " . MAX_RANDOM_SELECT_NEW;

	//var_export($random_product);
	
	$random_product = $db->Execute(cat_filter($random_product_query));

[streetglow]

At least I'm pretty sure that most backend systems haven't been tested for that.

I agree with that, but as I always say:
"A code that hasn't been tested yet, doesn't and will not work".

I've been modifieing Zen Cart since 2006, so I pretty well know what I'm doing. So I agree with the fact if you don't know what you are doing, don't try it.

My currency modification only shows the customer in the currency he want.
For example there are 2 different shops, one for in Brittain and the other for the rest of the EU who has the Euro.
In the UK shop it shows pounds, in the EU shop it shows Euro. But in the backend system it shows the currency where the shop owner is from, in my case it will be euro.

It is possible to have different currencies, but not supported by this module (yet). Believe me... it will take a lot modification and time to archieve supporting different currencies.

[jvoce]

I've been able intigrate the MultiSite Module quite well with my online test stores: 1 2.

The only ability I'm still struggling with is trying to filter customers. All customers should be able to access store1, and only authorized customers should be able to access store2.

In Post 121 I was given this lead:

constants define tables; you can override these constants (TABLE_CUSTOMERS, ...) from the confg files of your sites, and then have different tables for different sites

Basically what I'm looking for is 1 of two things, either we are able to manually enter the authoized customer's email/ID No. or automatically authorizing anyone with a specific e-mail address ending (ex. ##########################).

Any and all help is greatly appreciated as this will help our various locations around the country. And we are always kept on a tight budget being a charity.

Blessings,

[streetglow]

jvoce:

I will have to do out of my head since I'm at home now and not even willing to think about accessing my work's FTP, so sorry if I'm wrong about something...

This is exactly an aspect which I will have to work out very soon.
It can't be that hard tho, I believe if you make another field in the table customers called "customers_allowance" with the option "TEXT".

Then you will have to search the query which logs the customer on your site.
Also not that hard to locate "includes/modules/pages/login/header_php.php".
Edit the query which verifies the customer with the data inside the table.
Add " AND customers_allowance = '-%".SITE_NAME."%-' to it.

All that's left is creating an admin tool.
I can't help you with that yet...

[jvoce]

streetglow:

So what I've done thus far:

1) SQL Command: ALTER TABLE customers ADD customers_allowance TEXT NOT NULL;

2)Added red text below to includes/modules/pages/login/header_php.php

  $check_customer_query = "SELECT customers_id, customers_firstname,  customers_password,
                                          customers_email_address, customers_default_address_id,
                                          customers_authorization, customers_referral
                                          FROM " . TABLE_CUSTOMERS . "
                                          WHERE customers_email_address = :email
	   AND customers_allowance = '-%".SITE_NAME."%-'";

Now obviously, I assume I'll need to place text in the database to allow some customers complete access. Something as simple as Yes or No should do?

The next question is how would I go about setting the site switch for that?

[streetglow]

Sorry my bad, ofcourse it shouldn't be "=" but "LIKE".

$check_customer_query = "SELECT customers_id, customers_firstname, customers_password,
customers_email_address, customers_default_address_id,
customers_authorization, customers_referral
FROM " . TABLE_CUSTOMERS . "
WHERE customers_email_address = :email
AND customers_allowance LIKE '-%".SITE_NAME."%-'";

In the text field you should add the names of your sites delimited by "--".
Example:

--domain1.com--domain2.com--domain3.com--

Thats it.

[jvoce]

In the text field you should add the names of your sites delimited by "--".
Example:

--domain1.com--domain2.com--domain3.com--

Okay just a couple of more questions for you.
I don't have access to the database admin screen, so I sometimes feel a little limited not being able to really edit or experiement with the tables.

I'd like to set a default for the customers_allowance field to access one or two of the sites. What would I need to add to the previously used SQL command?

ALTER TABLE customers ADD customers_allowance TEXT NOT NULL;

Second question is what SQL Command would I need to enter when someone is given permission to access the more restricted site?

Thanks again for your patience and help. It's grealy appreciated!