whos_online.php File Reference

Go to the source code of this file.

Functions

Detailed Description

Definition in file whos_online.php.

Function Documentation

tep_update_whos_online (  ) 

Definition at line 15 of file whos_online.php.

00015                                     {
00016     global $customer_id;
00017     $DB=Database::getInstance();
00018 
00019     if (tep_session_is_registered('customer_id')) {
00020       $wo_customer_id = $customer_id;
00021 
00022       $customer_query = $DB->query("select customers_firstname, customers_lastname from " . TABLE_CUSTOMERS . " where customers_id = '" . (int)$customer_id . "'");
00023       $customer = $customer_query->fetchAssoc();
00024 
00025       $wo_full_name = $customer['customers_firstname'] . ' ' . $customer['customers_lastname'];
00026     } else {
00027       $wo_customer_id = '';
00028       $wo_full_name = 'Guest';
00029     }
00030 
00031     $wo_session_id = tep_session_id();
00032     $wo_ip_address = getenv('REMOTE_ADDR');
00033     $wo_last_page_url = getenv('REQUEST_URI');
00034 
00035     $current_time = time();
00036     $xx_mins_ago = ($current_time - 900);
00037 
00038 // remove entries that have expired
00039     $DB->query("delete from " . TABLE_WHOS_ONLINE . " where time_last_click < '" . $xx_mins_ago . "'");
00040 
00041     $stored_customer_query = $DB->query("select count(*) as count from " . TABLE_WHOS_ONLINE . " where session_id = '" . $DB->db_input($wo_session_id) . "'");
00042     $stored_customer = $stored_customer_query->fetchAssoc();
00043 
00044     if ($stored_customer['count'] > 0) {
00045       $DB->query("update " . TABLE_WHOS_ONLINE . " set customer_id = '" . (int)$wo_customer_id . "', full_name = '" . $DB->db_input($wo_full_name) . "', ip_address = '" . $DB->db_input($wo_ip_address) . "', time_last_click = '" . $DB->db_input($current_time) . "', last_page_url = '" . $DB->db_input($wo_last_page_url) . "' where session_id = '" . $DB->db_input($wo_session_id) . "'");
00046     } else {
00047       $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 . "', '" . $DB->db_input($wo_full_name) . "', '" . $DB->db_input($wo_session_id) . "', '" . $DB->db_input($wo_ip_address) . "', '" . $DB->db_input($current_time) . "', '" . $DB->db_input($current_time) . "', '" . $DB->db_input($wo_last_page_url) . "')");
00048     }
00049   }