Guest Posted July 12, 2005 Share Posted July 12, 2005 (edited) Jimmy, Thanks. My releases never had that but I think someone else posted a comment in the contrib page explaining how to do it. ed Edited July 12, 2005 by medvid Quote Link to comment Share on other sites More sharing options...
elv1s Posted July 12, 2005 Share Posted July 12, 2005 I thought I made a good guess at what you said B) ed <{POST_SNAPBACK}> Yeah you did a good job! Wanne try it in the dutch language now??? :D Just one question i have... Now the Sessions are saved in the place i told them to do so! That?s great, but are those sessions deleted automaticaly sometime... or do i have to do this manually? :blink: ps.... maybe i have something hanging before my eyes... but i couldn?t find the answer to my question and i still would like to hear from you what is the best way to deal with the sessions.... Mysql or files? >_< Thanks again to everybody and to ed for giving us a great contribution! cheers Kasper Quote My Contribs: - ORDERS AT-A-GLANCE -CUSTOMERS AT-A-GLANCE Link to comment Share on other sites More sharing options...
osCshop Posted July 12, 2005 Share Posted July 12, 2005 Thanks for this nice contribution :thumbsup: A very minor thing; After the "Set refresh rate" in 1.7.1 it shows "Last Refresh: 7/12/105 10:20 p.m." instead of "Last Refresh: 7/12/2005 10:20 p.m.". In my case (Europe) "Last Refresh: 12/7/2005 22:20" would be perfect... Quote Link to comment Share on other sites More sharing options...
Guest Posted July 13, 2005 Share Posted July 13, 2005 Yeah you did a good job! Wanne try it in the dutch language now??? :D No :P Just one question i have... Now the Sessions are saved in the place i told them to do so! That?s great, but are those sessions deleted automaticaly sometime... or do i have to do this manually? :blink: Yes. The catalog side and admin side both delete any session that hasn't been updated in 15 minutes (900 seconds). ps.... maybe i have something hanging before my eyes... but i couldn?t find the answer to my question and i still would like to hear from you what is the best way to deal with the sessions.... Mysql or files? >_< It's a trade-off. MySQL storage is more secure but increases the DB traffic for every page load on the catalog side. Files are relatively faster but less secure as you have to create a folder and assign Write privileges to it so the web server can update it. ed Quote Link to comment Share on other sites More sharing options...
Guest Posted July 13, 2005 Share Posted July 13, 2005 Is there a reason why some of the IP's have a comma (,) after them and in the clickable IP Lookup URL? Quote Link to comment Share on other sites More sharing options...
Guest Posted July 13, 2005 Share Posted July 13, 2005 Thanks for this nice contribution :thumbsup: A very minor thing; After the "Set refresh rate" in 1.7.1 it shows "Last Refresh: 7/12/105 10:20 p.m." instead of "Last Refresh: 7/12/2005 10:20 p.m.". In my case (Europe) "Last Refresh: 12/7/2005 22:20" would be perfect... <{POST_SNAPBACK}> The Time stamp is based on your computer settings. It does not get the date or time from anywhere else. So perhaps your bois clock is not set correctly. Quote Link to comment Share on other sites More sharing options...
Guest Posted July 13, 2005 Share Posted July 13, 2005 Is there a reason why some of the IP's have a comma (,) after them and in the clickable IP Lookup URL? <{POST_SNAPBACK}> I personally have never seen that error nor has anyone else according to this forum so far. Perhaps you should reinstall the contrib from scratch, because it sounds like a slip of theys upon entering the coding. John Quote Link to comment Share on other sites More sharing options...
Guest Posted July 13, 2005 Share Posted July 13, 2005 Ed I don't know if this is normal with the latest contrib, but I'm seeing a number of duplicate IP's. I think they are spiders but there showing up as Guests, but also Entry times and last click are comonly the same. Can you check this please? John Quote Link to comment Share on other sites More sharing options...
Guest Posted July 13, 2005 Share Posted July 13, 2005 Ed Just looked up the IP and no it's definetly not a spider. Quote Link to comment Share on other sites More sharing options...
Guest Posted July 14, 2005 Share Posted July 14, 2005 Ed I don't know if this is normal with the latest contrib, but I'm seeing a number of duplicate IP's. I think they are spiders but there showing up as Guests, but also Entry times and last click are comonly the same. Can you check this please? John <{POST_SNAPBACK}> John, Are the osCsid's the same? ed Quote Link to comment Share on other sites More sharing options...
Guest Posted July 14, 2005 Share Posted July 14, 2005 Thanks for this nice contribution :thumbsup: A very minor thing; After the "Set refresh rate" in 1.7.1 it shows "Last Refresh: 7/12/105 10:20 p.m." instead of "Last Refresh: 7/12/2005 10:20 p.m.". In my case (Europe) "Last Refresh: 12/7/2005 22:20" would be perfect... <{POST_SNAPBACK}> This is easy. Around line 248 of /admin/whos_online.php replace this line: document.write(' - Last Refresh: ' + (Stamp.getMonth() + 1) +"/"+Stamp.getDate()+ "/"+Stamp.getYear() + ' '); with this line: document.write(' - Last Refresh: ' +Stamp.getDate()+ "/"+ (Stamp.getMonth() + 1) +"/"+Stamp.getYear() + ' '); and your date will be in DD/MM/YYYY format. Quote Link to comment Share on other sites More sharing options...
Guest Posted July 14, 2005 Share Posted July 14, 2005 This is easy. Around line 248 of /admin/whos_online.php replace this line: document.write(' - Last Refresh: ' + (Stamp.getMonth() + 1) +"/"+Stamp.getDate()+ "/"+Stamp.getYear() + ' '); with this line: document.write(' - Last Refresh: ' +Stamp.getDate()+ "/"+ (Stamp.getMonth() + 1) +"/"+Stamp.getYear() + ' '); and your date will be in DD/MM/YYYY format. <{POST_SNAPBACK}> You might be right there as to what the question actually was. I thought osCshop's issue was that it was somehow showing "105" instead of "2005" Quote Link to comment Share on other sites More sharing options...
osCshop Posted July 14, 2005 Share Posted July 14, 2005 The Time stamp is based on your computer settings. It does not get the date or time from anywhere else.So perhaps your bois clock is not set correctly. <{POST_SNAPBACK}> Looked at my admin on another pc and the year is correct. Back to my laptop, with FireFox it shows 105 instead of 2005. In I.E. it shows 2005! No FireFox on the other pc so not sure if it is a FireFox issue... @Gamer, thanks for the help! Is showing 22.20 instead of 10.20 p.m. just as easy? Quote Link to comment Share on other sites More sharing options...
Guest Posted July 14, 2005 Share Posted July 14, 2005 Looked at my admin on another pc and the year is correct.Back to my laptop, with FireFox it shows 105 instead of 2005. In I.E. it shows 2005! No FireFox on the other pc so not sure if it is a FireFox issue... @Gamer, thanks for the help! Is showing 22.20 instead of 10.20 p.m. just as easy? <{POST_SNAPBACK}> It's just a simple javascript dropped into the code. There is no guarantee it is completely compatible with all browsers. I have found that for a large part this cart is largely built around IE, hence that's all use because I could be bothered playing around with other browsers as well. Lifes to short! Quote Link to comment Share on other sites More sharing options...
trippintees Posted July 15, 2005 Share Posted July 15, 2005 No :P Yes. The catalog side and admin side both delete any session that hasn't been updated in 15 minutes (900 seconds). It's a trade-off. MySQL storage is more secure but increases the DB traffic for every page load on the catalog side. Files are relatively faster but less secure as you have to create a folder and assign Write privileges to it so the web server can update it. ed <{POST_SNAPBACK}> Quote Link to comment Share on other sites More sharing options...
trippintees Posted July 15, 2005 Share Posted July 15, 2005 This contrib looks like very cool, but I keep getting the same error as mentioned in others post. Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /home/trippint/public_html/admin/includes/functions/database.php on line 45 0 - select value from sessions WHERE sesskey = '74013b4dc1a6Td3d97dfca075961d452' I tried mysql and files, made sure the the path was direct and waited a couple dof days. Even deleted old session from the folder. Read through the thread, changed settings in Config > Sessions, No luck. It will work properly for a short while and then give the error. Also, I noticed that when I had storage-sessions set to '' or files, the sessions where not being deleted. I had a few that where a day or so old. Could that have something to do with it? Any help would be appreciated. : Thanks! Quote Link to comment Share on other sites More sharing options...
Guest Posted July 15, 2005 Share Posted July 15, 2005 Ron, Do you have your session storage set the same in BOTH catalog/includes/configure.php AND admin/includes/configure.php? ed Quote Link to comment Share on other sites More sharing options...
Guest Posted July 15, 2005 Share Posted July 15, 2005 Bots are not showing up as bots for me under 1.7.1 What do I need to check to correct this? Scott Quote Link to comment Share on other sites More sharing options...
trippintees Posted July 15, 2005 Share Posted July 15, 2005 Ron, Do you have your session storage set the same in BOTH catalog/includes/configure.php AND admin/includes/configure.php? ed <{POST_SNAPBACK}> Yes, I have tried both set as files and both set as mysql. Like I said whichever way I set it up it will work properly for the first few minutes and then return the error. It is almost like the session get too old and are not deleted or someone puts something in the cart and it causes the error. Can't figure it out. :blink: Quote Link to comment Share on other sites More sharing options...
Guest Posted July 16, 2005 Share Posted July 16, 2005 (edited) Bots are not showing up as bots for me under 1.7.1 What do I need to check to correct this? Scott <{POST_SNAPBACK}> Scott, You need to have Prevent Spider Sessions set to True under Configuration->Sessions in the Admin screens. Also, an updated copy of the spiders.txt contrib. ed Edited July 16, 2005 by medvid Quote Link to comment Share on other sites More sharing options...
Guest Posted July 16, 2005 Share Posted July 16, 2005 Yes, I have tried both set as files and both set as mysql. Like I said whichever way I set it up it will work properly for the first few minutes and then return the error. It is almost like the session get too old and are not deleted or someone puts something in the cart and it causes the error. Can't figure it out. :blink: <{POST_SNAPBACK}> Ron, Do you want to give us your settings here? Paste the contents of: - Admin->Configuration->Sessions - The fields in the whos_online table (not the values, just the names and data types) - The session related settings of catalog/includes/configure.php and admin/includes/configure.php. Thanks, Ed Quote Link to comment Share on other sites More sharing options...
trippintees Posted July 16, 2005 Share Posted July 16, 2005 Ron,Do you want to give us your settings here? Paste the contents of: - Admin->Configuration->Sessions - The fields in the whos_online table (not the values, just the names and data types) - The session related settings of catalog/includes/configure.php and admin/includes/configure.php. Thanks, Ed <{POST_SNAPBACK}> Sure Session Directory /home/trippint/tmp/ Force Cookie Use False Check SSL Session ID True Check User Agent False Check IP Address False Prevent Spider Sessions True Recreate Session True Table customer_id int(11) Yes NULL full_name varchar(64) No session_id varchar(128) No ip_address varchar(15) No time_entry varchar(14) No time_last_click varchar(14) No last_page_url varchar(64) No http_referer varchar(255) No user_agent varchar(255) No Both configs are currently 'mysql' but I have tried both set at '' Thanks! Quote Link to comment Share on other sites More sharing options...
Guest Posted July 16, 2005 Share Posted July 16, 2005 Ron, Stupid question but did you put the new version of whos_online.php in catalog/includes? It's the only catalog side file. ed Quote Link to comment Share on other sites More sharing options...
Guest Posted July 16, 2005 Share Posted July 16, 2005 Ron More than likely you probably at a guess are on shared server (most people are). Assuming this is the case you can not just set your sessions before the public to TMP. Create a directory called "sessions" before the "public_html" ( you should be able to get to this through an FTP client or even Cpanel if using this) Then set the "sessions" directory CHMOD to 777 Then set your sessions in the Admin to: /home/trippint/sessions (/public_html would be the next directory if you were to enter it, but don't) Putting the directory before the public will help in security since it has to be set to 777 and is not a publicly available directory. Also Note, do not put a trailing forward slash "/" at the end of the path. Looking at what you have there is probably a combination of 2 problems 1. you have a trailing slash 2. The standard TMP directory is also commonly used by a number of programs that you may have running, all should have there own TMP directory where possible. This multi use directory means that the session data may be getting mixed up with some other session data from another program or even worse getting mixed up with someone elses cart data. John Quote Link to comment Share on other sites More sharing options...
trippintees Posted July 16, 2005 Share Posted July 16, 2005 Ron, Stupid question but did you put the new version of whos_online.php in catalog/includes? It's the only catalog side file. ed <{POST_SNAPBACK}> I placed it in the catalog/includes/functions/ directory. Should it be one up? 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.