joeyjgarcia Posted May 30, 2004 Share Posted May 30, 2004 Let's use this are to discuss issues. Quote Link to comment Share on other sites More sharing options...
Guest Posted May 30, 2004 Share Posted May 30, 2004 <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.... Quote Link to comment Share on other sites More sharing options...
joeyjgarcia Posted May 30, 2004 Author Share Posted May 30, 2004 Put the URL from your browser's address bar for another Admin page, such as your Configuration's My Store Page. I want to see exactly what leads up to the "/admin/" directory. Joey Quote Link to comment Share on other sites More sharing options...
Guest Posted May 30, 2004 Share Posted May 30, 2004 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! Quote Link to comment Share on other sites More sharing options...
nrlatsha Posted May 30, 2004 Share Posted May 30, 2004 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 Quote 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 More sharing options...
Dennisra Posted May 30, 2004 Share Posted May 30, 2004 Noel: Yes, please list it and thank you. Quote Link to comment Share on other sites More sharing options...
nrlatsha Posted May 30, 2004 Share Posted May 30, 2004 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 Quote 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 More sharing options...
Dennisra Posted May 30, 2004 Share Posted May 30, 2004 That's great!! Thank you very kindly. Quote Link to comment Share on other sites More sharing options...
thdt98 Posted July 22, 2004 Share Posted July 22, 2004 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. Quote Link to comment Share on other sites More sharing options...
Graveyard666 Posted August 27, 2004 Share Posted August 27, 2004 anyone know how to make it display the product_name the person is looking at instead of the last_url Quote Link to comment Share on other sites More sharing options...
DriWashSolutions Posted October 18, 2004 Share Posted October 18, 2004 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? Quote John Skurka Link to comment Share on other sites More sharing options...
volupp Posted November 8, 2004 Share Posted November 8, 2004 (edited) 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 November 8, 2004 by volupp Quote Link to comment Share on other sites More sharing options...
imfinlay Posted November 8, 2004 Share Posted November 8, 2004 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. <{POST_SNAPBACK}> Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.