Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Whois_online contribution discussion


Recommended Posts

            <td class="pageHeading">
           <?php echo HEADING_TITLE; ?>
           <span class="dataTableContent" style="font-size: 10px; color:#909090">Set Refresh Rate:</span>
           
           
           <input type='button' value='None' onClick="location.href='http://5alarmgifts.netfirms.com/store/nfoscomm/catalog/admin/whos_online.php'">
           <input type='button' value='10 min' onClick="location.href='http://5alarmgifts.netfirms.com/store/nfoscomm/catalog/admin/whos_online.php?600'">
           <input type='button' value='5 min' onClick="location.href='http://5alarmgifts.netfirms.com/store/nfoscomm/catalog/admin/whos_online.php?300'">
           <input type='button' value='60 sec' onClick="location.href='http://5alarmgifts.netfirms.com/store/nfoscomm/catalog/admin/whos_online.php?60'">
           <input type='button' value='30 sec' onClick="location.href='http://5alarmgifts.netfirms.com/store/nfoscomm/catalog/admin/whos_online.php?30'">
           
           
  </td>
         </tr>
       </table></td>

 

These are lines from 60 to 74... I still don't get it... what am I missing....

Link to comment
Share on other sites

Ok, I figured it out, I was putting the wrong link in there.... So, now everything is working out perfectly!

 

Thanks a lot for the help!

Link to comment
Share on other sites

Hello,

 

I noticed this thread and the new contrib, just wanted to share what I did to my whos_online file, its very similar to the contrib. I only made a couple of differences:

 

1. I have the refresh time as a database entry, so it can be changed to what I see fit. Similar to the buttons I see now, but I don't know if those values stay the next time you visit.

 

2. I have User Tracking installed and use the database entry to exclude my IP address from the results all together. Of course you can do this without that contrib too...

 

3. I got rid of the separate whois field and turned the IP address into the link to whois server to help it be less cluttered.

 

If anybody is interested, I can post them here. I see the current contrib does pretty much the same thing, just differently (cept for the exclude IP thing).

 

Noel

9 times out of 10 its a PEBCAK Error (Problem exists between chair and keyboard)

 

Replace that and you're fine...

Link to comment
Share on other sites

Ask and you shall receive...

 

I also added an area so you can input your own DNS query address.

 

Keep in mind, if you have user_tracking installed, you won't need to add the first two queries.

 

Run this on mysql:

 

INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('', 'User Tracking (exclude this IP-Address)', 'CONFIG_USER_TRACKING_EXCLUDED', 'your IP', 'Do NOT record this IP Address<br>(like webmaster/owners/Beta-testers)', 1, 2, 'now()', 'now()', NULL, NULL);

INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('', 'User Tracking (your favorite WHOIS URL)', 'USER_TRACKING_WHOIS_URL', 'http://www.dnsstuff.com/tools/whois.ch?ip=', 'Put here you favorite WHOIS tracking site<br>(the IP will follow automatically after this url)', 1, 3, 'now()', 'now()', NULL, NULL);

INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('', 'Who\'s Online Refresh Time', 'WHOS_ONLINE_REFRESH', '60', 'Who\'s Online Refresh Time', 1, 3, 'now()', 'now()', NULL, NULL);

 

Use this as your whos_online.php:

 

<?php
/*
 $Id: whos_online.php,v 1.32 2003/06/29 22:50:52 hpdl Exp $

 osCommerce, Open Source E-Commerce Solutions
 http://www.oscommerce.com

 Copyright (c) 2003 osCommerce

 Released under the GNU General Public License
 
 Updated by Noel Latsha www.nabcomdiamonds.com
*/

 $xx_mins_ago = (time() - 900);

 require('includes/application_top.php');

 require(DIR_WS_CLASSES . 'currencies.php');
 $currencies = new currencies();
 $refresh = WHOS_ONLINE_REFRESH; // Mod by Noel
// remove entries that have expired
 tep_db_query("delete from " . TABLE_WHOS_ONLINE . " where time_last_click < '" . $xx_mins_ago . "'");
?>
<!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN">
<html <?php echo HTML_PARAMS; ?>>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=<?php echo CHARSET; ?>">
<title><?php echo TITLE; ?></title>
<META HTTP-EQUIV="Refresh"
CONTENT="<? echo $refresh; ?>;"> 
<link rel="stylesheet" type="text/css" href="includes/stylesheet.css">
<script language="javascript" src="includes/general.js"></script>
</head>
<body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0" bgcolor="#FFFFFF">
<!-- header //-->
<?php require(DIR_WS_INCLUDES . 'header.php'); ?>
<!-- header_eof //-->

<!-- body //-->
<table border="0" width="100%" cellspacing="2" cellpadding="2">
 <tr>
   <td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="1" cellpadding="1" class="columnLeft">
<!-- left_navigation //-->
<?php require(DIR_WS_INCLUDES . 'column_left.php'); ?>
<!-- left_navigation_eof //-->
   </table></td>
<!-- body_text //-->
   <td width="100%" valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="2">
     <tr>
       <td><table border="0" width="100%" cellspacing="0" cellpadding="0">
         <tr>
           <td class="pageHeading"><?php echo HEADING_TITLE; ?></td>
           <td class="pageHeading" align="right"><?php echo tep_draw_separator('pixel_trans.gif', HEADING_IMAGE_WIDTH, HEADING_IMAGE_HEIGHT); ?></td>
         </tr>
       </table></td>
     </tr>
     <tr>
       <td><table border="0" width="100%" cellspacing="0" cellpadding="0">
         <tr>
           <td valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="2">
             <tr class="dataTableHeadingRow">
               <td class="dataTableHeadingContent"><?php echo TABLE_HEADING_ONLINE; ?></td>
               <td class="dataTableHeadingContent" align="center"><?php echo TABLE_HEADING_CUSTOMER_ID; ?></td>
               <td class="dataTableHeadingContent"><?php echo TABLE_HEADING_FULL_NAME; ?></td>
               <td class="dataTableHeadingContent" align="center"><?php echo TABLE_HEADING_IP_ADDRESS; ?></td>
             <!--  <td class="dataTableHeadingContent" align="center"><?php echo WhoIs ?></td> -->
               <td class="dataTableHeadingContent"><?php echo TABLE_HEADING_ENTRY_TIME; ?></td>
               <td class="dataTableHeadingContent" align="center"><?php echo TABLE_HEADING_LAST_CLICK; ?></td>
               <td class="dataTableHeadingContent"><?php echo TABLE_HEADING_LAST_PAGE_URL; ?> </td>
             </tr>
<?php
// Modified by Noel  
 $whos_online_query = tep_db_query("select customer_id, full_name, ip_address, time_entry, time_last_click, last_page_url, session_id from " . TABLE_WHOS_ONLINE . "   where ip_address != '" . CONFIG_USER_TRACKING_EXCLUDED . "' order by ip_address");
   while ($whos_online = tep_db_fetch_array($whos_online_query)) {
   $time_online = (time() - $whos_online['time_entry']);
   if ((!isset($HTTP_GET_VARS['info']) || (isset($HTTP_GET_VARS['info']) && ($HTTP_GET_VARS['info'] == $whos_online['session_id']))) && !isset($info)) {
     $info = $whos_online['session_id'];
   }

/* BEGIN COUNT MOD */
   if ($old_array['ip_address'] == $whos_online['ip_address']) {
  	 $i++;
   }
/* END COUNT MOD */

   if ($whos_online['session_id'] == $info) {
     echo '              <tr id="defaultSelected" class="dataTableRowSelected" onmouseover="rowOverEffect(this)" onmouseout="rowOutEffect(this)">' . "\n";
   } else {
     echo '              <tr class="dataTableRow" onmouseover="rowOverEffect(this)" onmouseout="rowOutEffect(this)" onclick="document.location.href=\'' . tep_href_link(FILENAME_WHOS_ONLINE, tep_get_all_get_params(array('info', 'action')) . 'info=' . $whos_online['session_id'], 'NONSSL') . '\'">' . "\n";
   }
?>
               <td class="dataTableContent"><?php echo gmdate('H:i:s', $time_online); ?></td>
               <td class="dataTableContent" align="center"><a HREF="customers.php?selected_box=customers&cID=<?php echo $whos_online['customer_id']; ?>&action=edit"><?php echo $whos_online['customer_id']; ?></a></td>
               <td class="dataTableContent"><?php echo $whos_online['full_name']; ?></td>
   
   <!-- BEGIN LINK MOD -->
               <td class="dataTableContent" align="center"><a href="<?php echo USER_TRACKING_WHOIS_URL; echo $whos_online['ip_address']; ?>" target="_blank"><?php echo $whos_online['ip_address']; ?></a></td>
               <!-- END LINK MOD -->
   
               <td class="dataTableContent"><?php echo date('H:i:s', $whos_online['time_entry'] - 7200 ); ?></td>
               <td class="dataTableContent" align="center"><?php echo date('H:i:s', $whos_online['time_last_click'] - 7200 ); ?></td>
               <td class="dataTableContent"><a HREF="<?php echo (($request_type == 'SSL') ? HTTPS_SERVER : HTTP_SERVER) .  $whos_online['last_page_url']; ?>" target=\"_blank\"><?php if (eregi('^(.*)' . tep_session_name() . '=[a-f,0-9]+[&]*(.*)', $whos_online['last_page_url'], $array)) { echo $array[1] . $array[2]; } else { echo $whos_online['last_page_url']; } ?></a> </td>
             </tr>
<?php
$old_array = $whos_online;
 }
 if (!$i) {
	 $i=0;
 }
 $total_dupes = $i;
 $total_sess = tep_db_num_rows($whos_online_query);
 $total_cust = $total_sess - $total_dupes;
?>
             <tr>
               <td class="smallText" colspan="7"><?php echo sprintf(TEXT_NUMBER_OF_CUSTOMERS, $total_sess); print "<br>Duplicate IPs: $total_dupes<br>Real customers: $total_cust";?></td>
             </tr>
           </table></td>

<?php
 $heading = array();
 $contents = array();

 if (isset($info)) {
   $heading[] = array('text' => '<b>' . TABLE_HEADING_SHOPPING_CART . '</b>');

   if (STORE_SESSIONS == 'mysql') {
     $session_data = tep_db_query("select value from " . TABLE_SESSIONS . " WHERE sesskey = '" . $info . "'");
     $session_data = tep_db_fetch_array($session_data);
     $session_data = trim($session_data['value']);
   } else {
     if ( (file_exists(tep_session_save_path() . '/sess_' . $info)) && (filesize(tep_session_save_path() . '/sess_' . $info) > 0) ) {
       $session_data = file(tep_session_save_path() . '/sess_' . $info);
       $session_data = trim(implode('', $session_data));
     }
   }

   if ($length = strlen($session_data)) {
     if (PHP_VERSION < 4) {
       $start_id = strpos($session_data, 'customer_id[==]s');
       $start_cart = strpos($session_data, 'cart[==]o');
       $start_currency = strpos($session_data, 'currency[==]s');
       $start_country = strpos($session_data, 'customer_country_id[==]s');
       $start_zone = strpos($session_data, 'customer_zone_id[==]s');
     } else {
       $start_id = strpos($session_data, 'customer_id|s');
       $start_cart = strpos($session_data, 'cart|O');
       $start_currency = strpos($session_data, 'currency|s');
       $start_country = strpos($session_data, 'customer_country_id|s');
       $start_zone = strpos($session_data, 'customer_zone_id|s');
     }

     for ($i=$start_cart; $i<$length; $i++) {
       if ($session_data[$i] == '{') {
         if (isset($tag)) {
           $tag++;
         } else {
           $tag = 1;
         }
       } elseif ($session_data[$i] == '}') {
         $tag--;
       } elseif ( (isset($tag)) && ($tag < 1) ) {
         break;
       }
     }

     $session_data_id = substr($session_data, $start_id, (strpos($session_data, ';', $start_id) - $start_id + 1));
     $session_data_cart = substr($session_data, $start_cart, $i);
     $session_data_currency = substr($session_data, $start_currency, (strpos($session_data, ';', $start_currency) - $start_currency + 1));
     $session_data_country = substr($session_data, $start_country, (strpos($session_data, ';', $start_country) - $start_country + 1));
     $session_data_zone = substr($session_data, $start_zone, (strpos($session_data, ';', $start_zone) - $start_zone + 1));

     session_decode($session_data_id);
     session_decode($session_data_currency);
     session_decode($session_data_country);
     session_decode($session_data_zone);
     session_decode($session_data_cart);

     if (PHP_VERSION < 4) {
       $broken_cart = $cart;
       $cart = new shoppingCart;
       $cart->unserialize($broken_cart);
     }

     if (is_object($cart)) {
       $products = $cart->get_products();
       for ($i = 0, $n = sizeof($products); $i < $n; $i++) {
         $contents[] = array('text' => $products[$i]['quantity'] . ' x ' . $products[$i]['name']);
       }

       if (sizeof($products) > 0) {
         $contents[] = array('text' => tep_draw_separator('pixel_black.gif', '100%', '1'));
         $contents[] = array('align' => 'right', 'text'  => TEXT_SHOPPING_CART_SUBTOTAL . ' ' . $currencies->format($cart->show_total(), true, $currency));
       } else {
         $contents[] = array('text' => ' ');
       }
     }
   }
 }

 if ( (tep_not_null($heading)) && (tep_not_null($contents)) ) {
   echo '            <td width="25%" valign="top">' . "\n";

   $box = new box;
   echo $box->infoBox($heading, $contents);

   echo '            </td>' . "\n";
 }
?>
         </tr>
       </table></td>
     </tr>
   </table></td>
<!-- body_text_eof //-->
 </tr>
</table>
<!-- body_eof //-->

<!-- footer //-->
<?php require(DIR_WS_INCLUDES . 'footer.php'); ?>
<!-- footer_eof //-->
<br>
</body>
</html>
<?php require(DIR_WS_INCLUDES . 'application_bottom.php'); ?>

 

Also - anywhere you see "- 7200" is where I set up the times to be local to MST. You can delete that for EST or modify it for your time zone.

 

You'll need to go into admin->my store to set up the "your IP" field at least. Refresh is default of 60 and NSLookup is the original one...

 

Lemme know if you have any problems... Or if its of use to you...

 

Noel

9 times out of 10 its a PEBCAK Error (Problem exists between chair and keyboard)

 

Replace that and you're fine...

Link to comment
Share on other sites

  • 1 month later...

We noticed that the site given in Who's online does not work anymore therefore we changed it or rather we added 2 choices.

 

                <td class="dataTableContent" align="center"><a HREF="http://www.dnsstuff.com/tools/whois.ch?ip=<?php echo $whos_online['ip_address']; ?>" target="_blank">1</A>   <a HREF="http://openrbl.org/#<?php echo $whos_online['ip_address']; ?>" target="_blank">2</A></td>

 

 

Thanks for Oneill (french Oscommerce) for the code

 

A question:

 

Time to time we see in Users chopping cart the text >nfbo or >nbo.

What does it mean ?

 

Thanks in advance

 

Great Contrib.

Link to comment
Share on other sites

  • 1 month later...
  • 1 month later...

Having an issue with the latest version of Who's Online.

 

When one of the buttons for automatic refresh is invoked, after a random amount of time, the site bombs and I get this message.

 

Warning: main(includes/languages/engli): failed to open stream: No such file or directory in /home/www/shop/admin/includes/application_top.php on line 135

Fatal error: main(): Failed opening required 'includes/languages/engli' (include_path='.:/usr/local/lib/php') in /home/www/shop/admin/includes/application_top.php on line 135

 

Anyone else have this issue?

John Skurka

Link to comment
Share on other sites

  • 3 weeks later...

I have in the newest version the same problem;

 

Warning: main(includes/languages/ger): failed to open stream: No such file or directory in /gesnskwd/www.geschenke-gags.de/admin/includes/application_top.php on line 139

 

Warning: main(includes/languages/ger): failed to open stream: No such file or directory in /gesnskwd/www.geschenke-gags.de/admin/includes/application_top.php on line 139

 

Fatal error: main(): Failed opening required 'includes/languages/ger' (include_path='.:/usr/local/lib/php') in /gesnskwd/www.geschenke-gags.de/admin/includes/application_top.php on line 139

 

It seems that the languagevariable ist destroying.

Edited by volupp
Link to comment
Share on other sites

I just installed this on my test site - it looks ok, but after a few moments I get a blank page. Any use of the back button returns more blank pages.

 

Ian

 

I have in the newest version the same problem;

 

Warning: main(includes/languages/ger): failed to open stream: No such file or directory in /gesnskwd/www.geschenke-gags.de/admin/includes/application_top.php on line 139

 

Warning: main(includes/languages/ger): failed to open stream: No such file or directory in /gesnskwd/www.geschenke-gags.de/admin/includes/application_top.php on line 139

 

Fatal error: main(): Failed opening required 'includes/languages/ger' (include_path='.:/usr/local/lib/php') in /gesnskwd/www.geschenke-gags.de/admin/includes/application_top.php on line 139

 

It seems that the languagevariable ist destroying.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...