Guest Posted March 17, 2003 Share Posted March 17, 2003 now if you just post with making it huge bold fonts that could help you make some friends..... 8) Quote Link to comment Share on other sites More sharing options...
Druide Posted March 17, 2003 Author Share Posted March 17, 2003 My opinion: i am not giving an answer to such posts :evil: I am sorry but we 'try' to help eachother, and we like to be treaten like human beings. I you have any idea how many hours there go into a single contribution then you would have a little more respect for those who make it and SHARE it with the rest of this well behaved community. We try to make it work for every platform version, and trust me that's not the easiest job there is. Keep your head 'cool' :!: WE ALL want a perfect working shopping cart with all contributions working but that takes effort and lots of time,' even by answering questions by mail, PM and here ofcourse. Time is something everyone hasn't got too much, because we all have also a PRIVATE LIFE (at least i have, and many more...) Friendly questions get faster replies, if you dont like a contribution then uninstall it right away, that shouldn't be that difficult because YOU have made a backup before you started. If you didn't do that then you are at the wrong place with your attitude We all are doing this for FREE, nobody gets paid to answer questions or to make modifications for themself and then even take the time to share those modifications with you. My 2 cents Quote Robert We all need to learn it once, how hard it may seem when you look at it, also you will master it someday ;) Link to comment Share on other sites More sharing options...
Druide Posted March 17, 2003 Author Share Posted March 17, 2003 :sneaky: the above message was directed to [email protected] and to him ONLY Quote Robert We all need to learn it once, how hard it may seem when you look at it, also you will master it someday ;) Link to comment Share on other sites More sharing options...
Guest Posted March 17, 2003 Share Posted March 17, 2003 robert - two questions: 1) is there a way to selectively delete tracks (such as being able to delete robot tracking histories but retain human visitor tracks to 'study' them)? 2) in your next rev I think it would be cool to add the netgeo thing keep up the great work sign at the door ----> no sense - no service 8) Quote Link to comment Share on other sites More sharing options...
Druide Posted March 17, 2003 Author Share Posted March 17, 2003 robert - two questions: 1) is there a way to selectively delete tracks (such as being able to delete robot tracking histories but retain human visitor tracks to 'study' them)? i have in my TODO list (in my memory...lol) in stead of putting the track paths everytime in the database (causes too much data on busy sites) i thought to put those links in a new table with an unique number, this number will be stored into the user tracking table. The only problem is that every page load will be slower because of this :( because this tracking path has to be found in the database - if it exist it will put the unique number in the user tracking table - if not create a new unique number with path I think this table needs an INDEX on it to speed up the process, put i never have used this function into php code. (maybe mattice can help out here) first this has to be programmed and i am short on time here because i am translating my project www.ruddlesmills.com in 3 EXTRA languages at the moment. My client is so happy with his new shopping cart that he want to get ready for the world :) Just kidding this is my idea because i get a percentage of each delivered order. :cool: (that's for my daughters education in a few years, she's now 8 months...LOL ) 2) in your next rev I think it would be cool to add the netgeo thing you can add it yourself already :) take care m8t Quote Robert We all need to learn it once, how hard it may seem when you look at it, also you will master it someday ;) Link to comment Share on other sites More sharing options...
Guest Posted March 17, 2003 Share Posted March 17, 2003 actually I think you had said previously that one of the things on your todo list was to add multiple ip tracking - that would actually allow for entering robot ips and blocking them from being tracked so that would be an easier method (imho) 8 months old - i dont even want to think what enrollment fees will be by then.... :shock: Quote Link to comment Share on other sites More sharing options...
Druide Posted March 17, 2003 Author Share Posted March 17, 2003 i installed this contri works great, but i got this errors in the admin/categories.php : Fatal error: Call to undefined function: tep_parse_category_path() in /home/httpd/vhosts/phpcube.com/httpdocs/includes/functions/user_tracking.php on line 47 how can i fix it? thanks sean place in admin/includes/functions/general_napoleans_hot_chicken.php :twisted: just before ?> function tep_string_to_int($string) { return (int)$string; } //// // Parse and secure the cPath parameter values function tep_parse_category_path($cPath) { // make sure the category IDs are integers $cPath_array = array_map('tep_string_to_int', explode('_', $cPath)); // make sure no duplicate category IDs exist which could lock the server in a loop $tmp_array = array(); $n = sizeof($cPath_array); for ($i=0; $i<$n; $i++) { if (!in_array($cPath_array[$i], $tmp_array)) { $tmp_array[] = $cPath_array[$i]; } } return $tmp_array; } :twisted: :twisted: took me 3 minutes to solve it IF you would ask it properly Quote Robert We all need to learn it once, how hard it may seem when you look at it, also you will master it someday ;) Link to comment Share on other sites More sharing options...
Cerberus Posted March 17, 2003 Share Posted March 17, 2003 Is there a problem with tracking pages which have an apostrophe in the title? Somebody went to a page on my site and got the following error: 1064 - You have an error in your SQL syntax near 's Leather Wallet')' at line 1 insert into user_tracking (customer_id, full_name, session_id, ip_address, time_entry, time_last_click, last_page_url, page_desc) values ('', 'Guest', '4419b1407aeea2bf8249e5e4edcb6810', '195.152.56.2', '1047915782', '1047915782', '/product_info.php?products_id=127', 'Men's Leather Wallet') [TEP STOP] The title was Men's Leather Wallet. I have since taken out the apostrophe and it appears to be ok now. Quote Link to comment Share on other sites More sharing options...
Druide Posted March 17, 2003 Author Share Posted March 17, 2003 Is there a problem with tracking pages which have an apostrophe in the title? Somebody went to a page on my site and got the following error: 1064 - You have an error in your SQL syntax near 's Leather Wallet')' at line 1 insert into user_tracking (customer_id, full_name, session_id, ip_address, time_entry, time_last_click, last_page_url, page_desc) values ('', 'Guest', '4419b1407aeea2bf8249e5e4edcb6810', '195.152.56.2', '1047915782', '1047915782', '/product_info.php?products_id=127', 'Men's Leather Wallet') [TEP STOP] The title was Men's Leather Wallet. I have since taken out the apostrophe and it appears to be ok now. please put it back and try this code, replace at bottom of catalog/includes/functions/user_tracking.php start at $current_time = time(); // my replacement code for the server time issue // if (!defined("TIME")) { $current_time = time(); } else { $current_time = TIME;} $current_time = time(); if ($skip_tracking[$wo_ip_address] != 1) $corrected_page_desc = ereg_replace("[']", "'", $page_desc); tep_db_query("insert into " . TABLE_USER_TRACKING . " (customer_id, full_name, session_id, ip_address, time_entry, time_last_click, last_page_url, page_desc) values ('" . $wo_customer_id . "', '" . $wo_full_name . "', '" . $wo_session_id . "', '" . $wo_ip_address . "', '" . $current_time . "', '" . $current_time . "', '" . $wo_last_page_url . "', '" . $corrected_page_desc . "')"); } ?> let me know if it works, i'm not 100% sure just put some code together in a minute Quote Robert We all need to learn it once, how hard it may seem when you look at it, also you will master it someday ;) Link to comment Share on other sites More sharing options...
Cerberus Posted March 17, 2003 Share Posted March 17, 2003 Thanks Robert, I'll give it a try and let you know what happens. Quote Link to comment Share on other sites More sharing options...
Cerberus Posted March 17, 2003 Share Posted March 17, 2003 Seems to have done the trick - thanks. Quote Link to comment Share on other sites More sharing options...
Druide Posted March 17, 2003 Author Share Posted March 17, 2003 COOL !!! that makes me happy another todo item from the list Quote Robert We all need to learn it once, how hard it may seem when you look at it, also you will master it someday ;) Link to comment Share on other sites More sharing options...
Guest Posted March 17, 2003 Share Posted March 17, 2003 Hi, I am not getting this error in my customer's admin area ONLY when they click on one of the folders under categories/products or if they use the "top" box to change to the inside of another folder. Fatal error: Call to undefined function: tep_parse_category_path() in /home/bandtobo/public_html/catalog/includes/functions/user_tracking.php on line 47 Any idea how to fix this? Quote Link to comment Share on other sites More sharing options...
Druide Posted March 17, 2003 Author Share Posted March 17, 2003 Hi, I am not getting this error in my customer's admin area ONLY when they click on one of the folders under categories/products or if they use the "top" box to change to the inside of another folder. Fatal error: Call to undefined function: tep_parse_category_path() in /home/bandtobo/public_html/catalog/includes/functions/user_tracking.php on line 47 Any idea how to fix this? you sure are a WIKI MODERATOR...lol read a few post above this one http://www.oscommerce.com/forums/viewtopic.php...p=131691#131691 good luck & enjoy the fix Quote Robert We all need to learn it once, how hard it may seem when you look at it, also you will master it someday ;) Link to comment Share on other sites More sharing options...
Druide Posted March 17, 2003 Author Share Posted March 17, 2003 that function does exists already in your catalog/includes/functions/general.php so i don't understand why it's not called with your setup did you do all your installed modifications the right way ? Quote Robert We all need to learn it once, how hard it may seem when you look at it, also you will master it someday ;) Link to comment Share on other sites More sharing options...
Guest Posted March 17, 2003 Share Posted March 17, 2003 Robert, This comment: you sure are a WIKI MODERATOR...lol I try to help people by looking through the forums for things that work and testing them out from all the nice people who post who try to help others and put it in a central location like the wiki site so it is easy to find. I have never said I was a programmer but I am learning each day. I think we all have a part in helping whether a programmer or not. I have your user tracking installed just like your new instructions and as I said before it that error only happens in the admin at the bottom of the page when someone clicks to get inside another folder to add products or clicks on the main product folder itself. If you get that error by clicking on the category folder listings and then immediately go and click on the user tracking link the problem shows up but not if you go into the admin and click on the user tracking first. The tables for the catalog folder are now all listed in a file called catalog/includes/database_tables.php although I did try it exactly as your instructions said to put in application_top.php and still the same problem. Do you think possible this is a problem you may have overlooked? Quote Link to comment Share on other sites More sharing options...
Guest Posted March 17, 2003 Share Posted March 17, 2003 I added the code from the link you gave me to general.php and now it is working. Quote Link to comment Share on other sites More sharing options...
Druide Posted March 17, 2003 Author Share Posted March 17, 2003 MODOM: i was just kidding to you, don't take it too serious :) Keep up the good work that you and all others do around here :!: Many peeps can learn a whole lot from that Quote Robert We all need to learn it once, how hard it may seem when you look at it, also you will master it someday ;) Link to comment Share on other sites More sharing options...
Dan1113 Posted March 25, 2003 Share Posted March 25, 2003 Great contribution! Working great here. :) Quote Dan1113 Tailfeathers Network Link to comment Share on other sites More sharing options...
gdfwilliams Posted March 26, 2003 Share Posted March 26, 2003 I've added Eddy Schindmes' great contribution, whos_online with country and flag, to display the flag and country name of each tracked user (or their ISP, anyway). New install files available here: http://www.oscommerce.com/community/contributions,1055 Here's a peek: Enjoy, Greg Quote Link to comment Share on other sites More sharing options...
gdfwilliams Posted March 26, 2003 Share Posted March 26, 2003 If anyone can help to span results over multiple pages (say, 10 per page), please let me know. I've been having trouble getting it to work... Quote Link to comment Share on other sites More sharing options...
Druide Posted March 26, 2003 Author Share Posted March 26, 2003 got the same troubles, but still have to look deeper to fix it i was thinking to use overlib for this one Quote Robert We all need to learn it once, how hard it may seem when you look at it, also you will master it someday ;) Link to comment Share on other sites More sharing options...
mazza Posted March 26, 2003 Share Posted March 26, 2003 Greg, I cant get the originating URL to work. I know there are some since visitors contribution show them. Quote "Use no way as way, have no limitation as limitation." - Bruce Lee Link to comment Share on other sites More sharing options...
Guest Posted March 27, 2003 Share Posted March 27, 2003 i just installed this on my local machine with the GeoIP addon and the flag is not showing up - it is getting a null value. looking at the parsed code, here is what shows up: <img src="images/flags/.gif" border="0" alt=""> </td> any ideas :? Quote Link to comment Share on other sites More sharing options...
Druide Posted March 27, 2003 Author Share Posted March 27, 2003 i hope this is not another Global issue if you know what i mean, haven't looked at it yet Quote Robert We all need to learn it once, how hard it may seem when you look at it, also you will master it someday ;) 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.