Adding HTTP_SERVER to who's online

[simon1066]

Yes, I see this is going to be tricky, I'll dig around a bit more and see what I can come up with.

Thanks again

[RodG]

Yes, I see this is going to be tricky, I'll dig around a bit more and see what I can come up with.

Thanks again

Instead of using ZenCarts' HTTP_SERVER CONSTANT, try using one of the Global variables.


$_SERVER['HTTP_HOST']
or
$_SERVER['SERVER_NAME']

Cheers
RodG

[Design75]

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:

ALTER TABLE `whos_online`  ADD `store_address2` TEXT NOT NULL ;

then open the file includes\functions\whos_online.php

find:

  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:

  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>'; 

[Design75]

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:

ALTER TABLE `whos_online`  ADD `store_address2` TEXT NOT NULL ;

then open the file includes\functions\whos_online.php

find:

  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:

  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>'; 

ALTER TABLE `whos_online`  ADD `store_address2` TEXT NOT NULL ;

should of course be

ALTER TABLE `whos_online`  ADD `store_address` TEXT NOT NULL ;

[mc12345678]

ALTER TABLE `whos_online`  ADD `store_address2` TEXT NOT NULL ;

should of course be

ALTER TABLE `whos_online`  ADD `store_address` TEXT NOT NULL ;

Trust me, that sort of mistake happens...

I'm curious though, why the change to the database table(s)? Why not prepend the last_page_uri with the associated server name? Do you have a unique reason to pull the servername out to it's own field?

Thought is that url would be fully presented both as text (where needed) and as a functional link to the exact location.

[Design75]

Trust me, that sort of mistake happens...

I'm curious though, why the change to the database table(s)? Why not prepend the last_page_uri with the associated server name? Do you have a unique reason to pull the servername out to it's own field?

Thought is that url would be fully presented both as text (where needed) and as a functional link to the exact location.

I wanted to leave the original last_url in tact, because I was not sure what other processes us this, and was lacking the time to find out.

[mc12345678]

I wanted to leave the original last_url in tact, because I was not sure what other processes us this, and was lacking the time to find out.

Could understand from that perspective. Think a query on the code through developer's tool kit will help answer that question, first would try with the entire var name, then would try with just the field name to see if it is used elsewhere. While possible to have renamed the base variable name, so likely, and even more unlikely to transfer the variable to another and completely change the field's name.

So, if someone else were to follow up on this thread, there is a solution that will display the full path name; however, it leaves other pieces of data untouched.

[simon1066]

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:

..................

Just revisiting this topic, and hadn't realised how busty the thread had got.

Thank you so much for this Design75, does exactly what I needed.

Could understand from that perspective. Think a query on the code through developer's tool kit will help answer that question, first would try with the entire var name, then would try with just the field name to see if it is used elsewhere. While possible to have renamed the base variable name, so likely, and even more unlikely to transfer the variable to another and completely change the field's name.

So, if someone else were to follow up on this thread, there is a solution that will display the full path name; however, it leaves other pieces of data untouched.

I think, although I'll look into it, that this is beyond my capabilities so I'll stick with the posted code for the moment. Thanks for your thoughts though.

                    $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>'; 

It seems strange that the original of this posted code, in fact all in that post, does not have a horizontal scroll on my screen, I had to expand the window to max to see all of it, luckily I'm on a big screen.

[simon1066]

Just revisiting this topic, and hadn't realised how busty the thread had got.

...

should of course be 'busy' - apologies

[RodG]

should of course be 'busy' - apologies

I liked it better when it was busty :)

Cheers
RodG