RodG:
Instead of using ZenCarts' HTTP_SERVER CONSTANT, try using one of the Global variables.
$_SERVER['HTTP_HOST']
or
$_SERVER['SERVER_NAME']
Cheers
RodG
That won't work, because that will give you the admin $_SERVER['HTTP_HOST'].
I have the solution down below, but it involves some code changes.
First add a field to the Who's online table:
[URL="http://multistore.zen4all-dev.nl/mysqladmin/url.php?url=http%3A%2F%2Fdev.mysql.com%2Fdoc%2Frefman%2F5.5%2Fen%2Falter-table.html&server=0&token=51b79b105ae00c1ee10591f7daf23215"]ALTER[/URL] [URL="http://multistore.zen4all-dev.nl/mysqladmin/url.php?url=http%3A%2F%2Fdev.mysql.com%2Fdoc%2Frefman%2F5.5%2Fen%2Falter-table.html&server=0&token=51b79b105ae00c1ee10591f7daf23215"]TABLE[/URL] `whos_online` ADD `store_address2` [URL="http://multistore.zen4all-dev.nl/mysqladmin/url.php?url=http%3A%2F%2Fdev.mysql.com%2Fdoc%2Frefman%2F5.5%2Fen%2Fstring-types.html&server=0&token=51b79b105ae00c1ee10591f7daf23215"]TEXT[/URL] [URL="http://multistore.zen4all-dev.nl/mysqladmin/url.php?url=http%3A%2F%2Fdev.mysql.com%2Fdoc%2Frefman%2F5.5%2Fen%2Flogical-operators.html&server=0&token=51b79b105ae00c1ee10591f7daf23215#operator_not"]NOT[/URL] NULL ;
then open the file includes\functions\whos_online.php
find:```php
if ($stored_customer->fields['count'] > 0) {
$sql = "update " . TABLE_WHOS_ONLINE . "
set customer_id = '" . (int)$wo_customer_id . "',
full_name = '" . zen_db_input($wo_full_name) . "',
ip_address = '" . zen_db_input($wo_ip_address) . "',
time_last_click = '" . zen_db_input($current_time) . "',
last_page_url = '" . zen_db_input($wo_last_page_url) . "',
host_address = '" . zen_db_input($_SESSION['customers_host_address']) . "',
user_agent = '" . zen_db_input($wo_user_agent) . "'
where session_id = '" . zen_db_input($wo_session_id) . "' and ip_address='" . zen_db_input($wo_ip_address) . "'";
$db->Execute($sql);
} else {
$sql = "insert into " . TABLE_WHOS_ONLINE . "
(customer_id, full_name, session_id, ip_address, time_entry,
time_last_click, last_page_url, host_address, user_agent )
values ('" . (int)$wo_customer_id . "', '" . zen_db_input($wo_full_name) . "', '"
. zen_db_input($wo_session_id) . "', '" . zen_db_input($wo_ip_address)
. "', '" . zen_db_input($current_time) . "', '" . zen_db_input($current_time)
. "', '" . zen_db_input($wo_last_page_url)
. "', '" . zen_db_input($_SESSION['customers_host_address'])
. "', '" . zen_db_input($wo_user_agent)
. "')";
$db->Execute($sql);
and change to:
```php
if ($stored_customer->fields['count'] > 0) {
$sql = "update " . TABLE_WHOS_ONLINE . "
set customer_id = '" . (int)$wo_customer_id . "',
full_name = '" . zen_db_input($wo_full_name) . "',
ip_address = '" . zen_db_input($wo_ip_address) . "',
time_last_click = '" . zen_db_input($current_time) . "',
last_page_url = '" . zen_db_input($wo_last_page_url) . "',
host_address = '" . zen_db_input($_SESSION['customers_host_address']) . "',
user_agent = '" . zen_db_input($wo_user_agent) . "',
store_address = '" . zen_db_input($_SERVER['HTTP_HOST']) . "'
where session_id = '" . zen_db_input($wo_session_id) . "' and ip_address='" . zen_db_input($wo_ip_address) . "'";
$db->Execute($sql);
} else {
$sql = "insert into " . TABLE_WHOS_ONLINE . "
(customer_id, full_name, session_id, ip_address, time_entry,
time_last_click, last_page_url, host_address, user_agent, store_address )
values ('" . (int)$wo_customer_id . "', '" . zen_db_input($wo_full_name) . "', '"
. zen_db_input($wo_session_id) . "', '" . zen_db_input($wo_ip_address)
. "', '" . zen_db_input($current_time) . "', '" . zen_db_input($current_time)
. "', '" . zen_db_input($wo_last_page_url)
. "', '" . zen_db_input($_SESSION['customers_host_address'])
. "', '" . zen_db_input($wo_user_agent)
. "', '" . zen_db_input($_SERVER['HTTP_HOST'])
. "')";
$db->Execute($sql);
Next open YOUR_ADMIN\whos_online.php
around line 158 find:
$sql = "select customer_id, full_name, ip_address, time_entry, time_last_click, last_page_url, session_id, host_address, user_agent
change to:
$sql = "select customer_id, full_name, ip_address, time_entry, time_last_click, last_page_url, session_id, host_address, user_agent, store_address
find:
$lastURLlink = '<a href="' . zen_output_string_protected($whos_online->fields['last_page_url']) . '" target="_blank">' . '<u>'. zen_output_string_protected($whos_online->fields['last_page_url']) . '</u>' . '</a>';
change to:
$lastURLlink = '<a href="' . zen_output_string_protected($whos_online->fields['last_page_url']) . '" target="_blank">' . '<u>' . zen_output_string_protected($whos_online->fields['store_address']) . zen_output_string_protected($whos_online->fields['last_page_url']) . '</u>' . '</a>';
