[Summary view] [Print] [Text view]

   1  <?php
   2  /*

   3  

   4    osCommerce, Open Source E-Commerce Solutions

   5    http://www.oscommerce.com

   6  

   7    Copyright (c) 2003 osCommerce

   8    

   9    osCommRes, Services Online

  10    http://www.oscommres.com

  11  

  12    Copyright (c) 2005 osCommRes

  13  

  14    Released under the GNU General Public License

  15  */
  16    function tep_update_whos_online() {
  17      global $customer_id;
  18  
  19      if (tep_session_is_registered('customer_id')) {
  20        $wo_customer_id = $customer_id;
  21  
  22        $customer_query = tep_db_query("select customers_firstname, customers_lastname from " . TABLE_CUSTOMERS . " where customers_id = '" . (int)$customer_id . "'");
  23        $customer = tep_db_fetch_array($customer_query);
  24  
  25        $wo_full_name = $customer['customers_firstname'] . ' ' . $customer['customers_lastname'];
  26      } else {
  27        $wo_customer_id = '';
  28        $wo_full_name = 'Guest';
  29      }
  30  
  31      $wo_session_id = tep_session_id();
  32      $wo_ip_address = getenv('REMOTE_ADDR');
  33      $wo_last_page_url = getenv('REQUEST_URI');
  34  
  35      $current_time = time();
  36      $xx_mins_ago = ($current_time - 900);
  37  
  38  // remove entries that have expired

  39      tep_db_query("delete from " . TABLE_WHOS_ONLINE . " where time_last_click < '" . $xx_mins_ago . "'");
  40  
  41      $stored_customer_query = tep_db_query("select count(*) as count from " . TABLE_WHOS_ONLINE . " where session_id = '" . tep_db_input($wo_session_id) . "'");
  42      $stored_customer = tep_db_fetch_array($stored_customer_query);
  43  
  44      if ($stored_customer['count'] > 0) {
  45        tep_db_query("update " . TABLE_WHOS_ONLINE . " set customer_id = '" . (int)$wo_customer_id . "', full_name = '" . tep_db_input($wo_full_name) . "', ip_address = '" . tep_db_input($wo_ip_address) . "', time_last_click = '" . tep_db_input($current_time) . "', last_page_url = '" . tep_db_input($wo_last_page_url) . "' where session_id = '" . tep_db_input($wo_session_id) . "'");
  46      } else {
  47        tep_db_query("insert into " . TABLE_WHOS_ONLINE . " (customer_id, full_name, session_id, ip_address, time_entry, time_last_click, last_page_url) values ('" . (int)$wo_customer_id . "', '" . tep_db_input($wo_full_name) . "', '" . tep_db_input($wo_session_id) . "', '" . tep_db_input($wo_ip_address) . "', '" . tep_db_input($current_time) . "', '" . tep_db_input($current_time) . "', '" . tep_db_input($wo_last_page_url) . "')");
  48      }
  49    }
  50  ?>