aboriginart Posted September 24, 2005 Share Posted September 24, 2005 Hi, I love the idea of the more detailed whos_online enhancement [vers 1.7 ] I like the click thru to my store to see what clients are looking at and to the ISP to see where they are from. BUT the bots never seem to show up as bots - I know what some of the ISP numbers [especially google] are and they just dont seem to be picked up by the program as bots? I'm sure I have installed it correctly. Do I need I do something to the catalog/includes/spiders file? Suggestions and help appreciated Peter Folks, I updated Who's Online Enhancement to v1.4. Post any and all comments, suggestions, questions, complaints here. Ed <{POST_SNAPBACK}> Quote Link to comment Share on other sites More sharing options...
Guest Posted September 24, 2005 Share Posted September 24, 2005 Hi, I love the idea of the more detailed whos_online enhancement [vers 1.7 ] I like the click thru to my store to see what clients are looking at and to the ISP to see where they are from. BUT the bots never seem to show up as bots - I know what some of the ISP numbers [especially google] are and they just dont seem to be picked up by the program as bots? I'm sure I have installed it correctly. Do I need I do something to the catalog/includes/spiders file? Suggestions and help appreciated Peter <{POST_SNAPBACK}> Peter, Update catalog/includes/spiders.txt with the latest spiders.txt contrib and then make sure that Prevent Spider Sessions is turned on in Admin->Configuration->Sessions ed Quote Link to comment Share on other sites More sharing options...
guy1974 Posted September 30, 2005 Share Posted September 30, 2005 QUOTE(shaytaan @ Sep 15 2005, 03:43 PM)I install the newest one v1.7 but I it won't work :,( And my Sessions store in mySQL I got this error: Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in C:\sokkit\site\shop\admin\includes\functions\database.php on line 45 0 - select time_entry, time_last_click from whos_online where session_id='944852f178a076e8232ab99778276554' [TEP STOP] Some one please help Look at this line C:\sokkit\site\shop\admin\includes\functions\database.php on line 45 You have done something where it is trying to reference a file on you computer. This can't be right unless you are hosting your own site on your computer. Go back and hav another look at you paths etc. I have the same problem but this error : Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /home/.sites/36/site228/web/admin/includes/functions/database.php on line 450 - select time_entry, time_last_click from whos_online where session_id='14527e4f3a8e4b2dbfaeb11e570c3fa1' [TEP STOP] I just intalled the "who is online" 1.7 and didn't modify the "database.php" file Does someone have the same problem or an answer ? Quote Link to comment Share on other sites More sharing options...
Guest Posted October 4, 2005 Share Posted October 4, 2005 i have set my sessions file to full path (/home/public_html, etc) - this is correct? i still have empty user agents and referrers. did i overlook something? Quote Link to comment Share on other sites More sharing options...
Guest Posted October 5, 2005 Share Posted October 5, 2005 i have set my sessions file to full path (/home/public_html, etc) - this is correct? i still have empty user agents and referrers. did i overlook something? any suggestions? Quote Link to comment Share on other sites More sharing options...
zboyblue Posted October 5, 2005 Share Posted October 5, 2005 I have installed this but I cannot get anything to display in Who's Online. I have went to my site from my computer and from another computer in the office and nothing comes up. I looked in the database and the sessions are in the table. What am I doing wrong? Craig Quote Link to comment Share on other sites More sharing options...
radders Posted October 5, 2005 Share Posted October 5, 2005 any suggestions? Did you remember to install the catalog part of the code as well as the admin part? Quote Link to comment Share on other sites More sharing options...
Guest Posted October 6, 2005 Share Posted October 6, 2005 forgot it last night, but i put it in. all the referrers are showing up as my site. is this supposed to be correct? when i go to my cpanel stats, the referrer is from google or links, etc. Quote Link to comment Share on other sites More sharing options...
zboyblue Posted October 6, 2005 Share Posted October 6, 2005 Can anyone help me? pwease. : ) Craig Quote Link to comment Share on other sites More sharing options...
zboyblue Posted October 6, 2005 Share Posted October 6, 2005 One thing I just figured out ... If there are no sessions in the table (no visitors on the website) the Who's online page will display "Currently there are 0 visitors online". If there is something in the table it will not display anything. I mean the page is still there with the color circle key at the top and all that, there is just no data displayed. Why would this be? apparently the info is making it into the database so why is it not displayed? Craig Quote Link to comment Share on other sites More sharing options...
Guest Posted October 7, 2005 Share Posted October 7, 2005 forgot it last night, but i put it in.all the referrers are showing up as my site. is this supposed to be correct? when i go to my cpanel stats, the referrer is from google or links, etc. eww, No, they should be from off-site, usually. ed One thing I just figured out ... If there are no sessions in the table (no visitors on the website) the Who's online page will display "Currently there are 0 visitors online". If there is something in the table it will not display anything. I mean the page is still there with the color circle key at the top and all that, there is just no data displayed. Why would this be? apparently the info is making it into the database so why is it not displayed? Craig Craig, That can happen on any web page if a table tag is messed up. Look at View Page Source using your browser and see if the data is really there. ed Quote Link to comment Share on other sites More sharing options...
gregy Posted October 7, 2005 Share Posted October 7, 2005 Hi i updated Who's online .. in admin part it works great .. no problems .. but on catalog side it shows like ... Trenutno imamo 6 gostov in 5 član-a-ov (, , , Gregor, ) online. nevermind the language :) 6 guestas and 5 members ... but the only member shown is me, admin IP .. hmm strange .. Quote Link to comment Share on other sites More sharing options...
zboyblue Posted October 7, 2005 Share Posted October 7, 2005 Medvid, This is not a html problem. This is some problem with code somewhere. I am not saying the page is blank, I am saying it is displaying no data. Again, if there is no data in the database it will SAY "Currently there are 0 visitors online" but if there IS data in the table it will not say anything at all. In other words it knows there is something there (so it is not saying there is nothing there) but what IS there is not making it to the screen. Any idea's? Craig Quote Link to comment Share on other sites More sharing options...
gregy Posted October 8, 2005 Share Posted October 8, 2005 Medvid, This is not a html problem. This is some problem with code somewhere. I am not saying the page is blank, I am saying it is displaying no data. Again, if there is no data in the database it will SAY "Currently there are 0 visitors online" but if there IS data in the table it will not say anything at all. In other words it knows there is something there (so it is not saying there is nothing there) but what IS there is not making it to the screen. Any idea's? Craig i looked at code to find something .. but still not working .. it is not displaying members by names .. only numbers .. guests are OK Quote Link to comment Share on other sites More sharing options...
zboyblue Posted October 8, 2005 Share Posted October 8, 2005 Is there anyone out there that can help me with this? I have CRE Loaded which should not matter since the admin does not use templates, I cannot think of anything else that would affect this contrib. The old Who's Online page worked ... Can anyone think of ANYTHING that I could try. This is really drving me crazy and since there is no error I am at a dead end. The data is just not displaying. Please help if you can. Craig Quote Link to comment Share on other sites More sharing options...
Guest Posted October 9, 2005 Share Posted October 9, 2005 Medvid, This is not a html problem. This is some problem with code somewhere. I am not saying the page is blank, I am saying it is displaying no data. Again, if there is no data in the database it will SAY "Currently there are 0 visitors online" but if there IS data in the table it will not say anything at all. In other words it knows there is something there (so it is not saying there is nothing there) but what IS there is not making it to the screen. Any idea's? Craig Craig, Did you check the show source? ed i looked at code to find something .. but still not working .. it is not displaying members by names .. only numbers .. guests are OK Gregor, Verify that in admin/whos_online.php, around line 164, it says: /* Display the details about a visitor */ function display_details() { global $whos_online, $is_bot, $is_admin, $is_guest, $is_account; // Display Name echo '<b>' . TABLE_HEADING_FULL_NAME . ':</b> ' . $whos_online['full_name']; And around 398 it says: <!-- Name Column --> <td class="dataTableContent" valign="top"><font color="<?php echo $fg_color; ?>"> <?php // WOL 1.6 Restructured to Check for Guest or Admin if ( $is_guest || $is_admin ) { echo $whos_online['full_name'] . ' '; And in catalog/includes/functions/whos_online.php, on line 53, it says: $wo_full_name = $customer['customers_firstname'] . ' ' . $customer['customers_lastname']; These are the places where the customer name is entered in the table on the catalog and then pulled out on the admin side. ed Quote Link to comment Share on other sites More sharing options...
zboyblue Posted October 9, 2005 Share Posted October 9, 2005 What do you mean view source? What am I looking for? Craig Quote Link to comment Share on other sites More sharing options...
Guest Posted October 9, 2005 Share Posted October 9, 2005 What do you mean view source? What am I looking for? Craig Craig, When Who's Online is messed up (soemone's online but the admin page is mostly blank), go to the admin page and do a View->Page Source on the browser menu. (Different brwsers may say Source or Show Source.) That should open a text editor with teh who's online.php HTML code. Look for the code UNDER the lights (which you said shows up) and see if there is anything there. If a Table tag gets messed up, the table and its contents will be in the Source but the browser may not display it, so you'll see a lot of blank space on the page. ed Quote Link to comment Share on other sites More sharing options...
zboyblue Posted October 9, 2005 Share Posted October 9, 2005 Thanks so much for the help ... Here is the bottom part of view source. It does seem like much is missing. Where do I go from here? Craig <!-- Display Profile links --> <br clear="all"> <span class="smallText" style="color:#909090">Profile Display:</span> <a href="whos_online.php"><b>None</b></a> · <a href="whos_online.php?showAll"><b>All</b></a> · <a href="whos_online.php?showBots"><b>Bots</b></a> · <a href="whos_online.php?showCust"><b>Customers</b></a> </span> </td> <!-- Status Legend - Uses variables for image names --> <td rowspan="2" align="right" class="smallText"> <table border="0" cellspacing="0" cellpadding="0"> <tr> <td class="smallText"><img src="images/icon_status_green.gif" border="0" alt="Active/Cart" title=" Active/Cart "> Active/Cart </td> <td class="smallText"><img src="images/icon_status_red.gif" border="0" alt="Inactive/Cart" title=" Inactive/Cart "> Inactive/Cart </td> </tr> <tr> <td class="smallText"><img src="images/icon_status_green_light.gif" border="0" alt="Active/NoCart" title=" Active/NoCart "> Active/NoCart </td> <td class="smallText"><img src="images/icon_status_red_light.gif" border="0" alt="Inactive/NoCart" title=" Inactive/NoCart "> Inactive/NoCart </td> </tr> <tr> <td class="smallText"><img src="images/icon_status_green_border_light.gif" border="0" alt="Active/Bot" title=" Active/Bot "> Active/Bot </td> <td class="smallText"><img src="images/icon_status_red_border_light.gif" border="0" alt="Inactive/Bot" title=" Inactive/Bot "> Inactive/Bot </td> </tr> </table> </td> </tr> <tr> <td><img src="images/pixel_trans.gif" border="0" alt="" width="1" height="10"> </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> </td> <td class="dataTableHeadingContent">Online</td> <td class="dataTableHeadingContent">Name</td> <td class="dataTableHeadingContent">IP Address</td> <td class="dataTableHeadingContent">Entry</td> <td class="dataTableHeadingContent">Last Click</td> <td class="dataTableHeadingContent">Last URL </td> <td class="dataTableHeadingContent" align="center">Session? </td> <td class="dataTableHeadingContent" align="center">Refer? </td> </tr> <tr id="defaultSelected" class="dataTableRowSelected" onmouseover="rowOverEffect(this)" onmouseout="rowOutEffect(this)"> <!-- Status Light Column --> <td class="dataTableContent" align="left" valign="top"> Quote Link to comment Share on other sites More sharing options...
gregy Posted October 9, 2005 Share Posted October 9, 2005 Craig, Did you check the show source? ed Gregor, Verify that in admin/whos_online.php, around line 164, it says: /* Display the details about a visitor */ function display_details() { global $whos_online, $is_bot, $is_admin, $is_guest, $is_account; // Display Name echo '<b>' . TABLE_HEADING_FULL_NAME . ':</b> ' . $whos_online['full_name']; And around 398 it says: <!-- Name Column --> <td class="dataTableContent" valign="top"><font color="<?php echo $fg_color; ?>"> <?php // WOL 1.6 Restructured to Check for Guest or Admin if ( $is_guest || $is_admin ) { echo $whos_online['full_name'] . ' '; And in catalog/includes/functions/whos_online.php, on line 53, it says: $wo_full_name = $customer['customers_firstname'] . ' ' . $customer['customers_lastname']; These are the places where the customer name is entered in the table on the catalog and then pulled out on the admin side. ed hmm .. found the problem .. those members are bots .. they are displayed on admin part .. but blank names on public pages .. Quote Link to comment Share on other sites More sharing options...
Guest Posted October 10, 2005 Share Posted October 10, 2005 When I click on Who's Online, this comes up: 1054 - Unknown column 'user_agent' in 'field list' select customer_id, full_name, ip_address, time_entry, time_last_click, last_page_url, http_referer, user_agent, session_id from whos_online order by time_last_click DESC I did everything I needed to do listed in the read Me file with the contribution. What is wrong? Thanks for your help, B. Quote Link to comment Share on other sites More sharing options...
Guest Posted October 10, 2005 Share Posted October 10, 2005 Actually, I am getting this on my home page of the site now: 1054 - Unknown column 'http_referer' in 'field list' insert into whos_online (customer_id, full_name, session_id, ip_address, time_entry, time_last_click, last_page_url, http_referer, user_agent) values ('0', 'Guest', 'f242c419c3b75f5d8f2262dc36525452', '12.219.85.245', '1128928477', '1128928477', '/ecommerce/os/catalog/', '', '') What do I need to do? Quote Link to comment Share on other sites More sharing options...
zboyblue Posted October 10, 2005 Share Posted October 10, 2005 Read through this thread, this queston has been answered maybe 10 times. At the bottom of this page use te search box and search for http_referer and/or user_agent. Craig Quote Link to comment Share on other sites More sharing options...
sharpstuff Posted October 10, 2005 Share Posted October 10, 2005 I ran the sql...added the files and now I get this error. Anyone know what I am doing wrong? I searched the thread but may have missed it. Fatal error: Call to undefined function: tep_get_ip_address() in /home/xxxxx/public_html/catalog/admin/whos_online.php on line 551 Quote Link to comment Share on other sites More sharing options...
Guest Posted October 11, 2005 Share Posted October 11, 2005 I ran the sql...added the files and now I get this error. Anyone know what I am doing wrong? I searched the thread but may have missed it.Fatal error: Call to undefined function: tep_get_ip_address() in /home/xxxxx/public_html/catalog/admin/whos_online.php on line 551 Step 4 of the readme.html says: 4) You may need to add the following code to the bottom (just before the final ?> tag) of admin\includes\functions\general.php: function tep_get_ip_address() { if (isset($_SERVER)) { if (isset($_SERVER['HTTP_X_FORWARDED_FOR'])) { $ip = $_SERVER['HTTP_X_FORWARDED_FOR']; } elseif (isset($_SERVER['HTTP_CLIENT_IP'])) { $ip = $_SERVER['HTTP_CLIENT_IP']; } else { $ip = $_SERVER['REMOTE_ADDR']; } } else { if (getenv('HTTP_X_FORWARDED_FOR')) { $ip = getenv('HTTP_X_FORWARDED_FOR'); } elseif (getenv('HTTP_CLIENT_IP')) { $ip = getenv('HTTP_CLIENT_IP'); } else { $ip = getenv('REMOTE_ADDR'); } } return $ip; } Change "may" to "will". ed 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.