Supertracker

[Necsy]

My English is also very bad. So bad that some are allowed to laugh over this. But, unlike them, my php is good

Lol! Will we say that a nice pair in English discussions

I never questioned your php the contrary, your expected contribution not to disasters

Now everything is working and it is truly a beautiful mod, I thank you very much, good job.

[bhunted]

Hi gang..

Slightly unusual and different problem. I have this mod installed on 2 carts. Works fine on one and the other, works fine but some things are not logged.

Ex: In the last 10 visitors list, it doesn't show people adding stuff to the cart, their names, etc. It shows activity, but not the actual things like the sales and such once a user is logged in.

In my first install, it works fine and shows all that stuff. Any ideas why that might not be showing that info like normal? Thanks!

[vin]

I you use module from dl-area replace

$db->Execute("UPDATE " . TABLE_SUPERTRACKER . " SET last_click = NOW(), exit_page='" . zen_db_prepare_input(urldecode($_SERVER['REQUEST_URI'])) . "', exit_page_name='" . $page_title . "', num_clicks=num_clicks+1, added_cart='" . $tracking_data->fields['added_cart'] . "', categories_viewed='" . $categories_viewed . "', products_viewed='" . $tracking_data->fields['products_viewed'] . "', customer_id='" . $customer_id . "', completed_purchase='" . $completed_purchase . "', cart_contents='" . $cart_contents . "', cart_total = '" . $cart_total . "', order_id = '" . $order_id . "' WHERE tracking_id='" . $tracking_data->fields['tracking_id'] . "'");

by

$db->Execute("UPDATE " . TABLE_SUPERTRACKER . " SET last_click = NOW(), exit_page='" . zen_db_input(zen_db_prepare_input(urldecode($_SERVER['REQUEST_URI']))) . "', exit_page_name='" . $page_title . "', num_clicks=num_clicks+1, added_cart='" . $tracking_data->fields['added_cart'] . "', categories_viewed='" . $categories_viewed . "', products_viewed='" . $tracking_data->fields['products_viewed'] . "', customer_id='" . $customer_id . "', completed_purchase='" . $completed_purchase . "', cart_contents='" . $cart_contents . "', cart_total = '" . $cart_total . "', order_id = '" . $order_id . "' WHERE tracking_id='" . $tracking_data->fields['tracking_id'] . "'");

P.S. Why you talk about ' in products name? Error when ' in uri.

Hi
Have a similar issue but the above code did not fix it. Not sure what else is wrong. Any help is appreciated. Error shows up when an " 's " is done with names.

1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 's peak needed.";}}}', cart_total = '749', order_id = '0' WHERE tracking_id='1431' at line 1
in:
[UPDATE supertracker SET last_click = NOW(), exit_page='/index.php?main_page=shopping_cart&number_of_uploads=2', exit_page_name='Your Shopping Bag', num_clicks=num_clicks+1, added_cart='true', categories_viewed='b:0;', products_viewed='*152?*218?*199?', customer_id='106', completed_purchase='false', cart_contents='a:1:{s:36:"218:5e68c4e2abb050dcafedc16da51fb45c";a:3:{s:3:"qty";d :1;s:10:"attributes";a:24:{i:67;s:3:"329";i:80;s:3:"383";i:23;s:2:"20";i:50;s:2: "43";i:28;s:2:"21";i:59;s:3:"297";i:24;s:2:"46";i:26;s:2:"49";i:22;s:2:"16";i:37 ;s:2:"27";i:29;s:3:"109";i:30;s:3:"137";i:42;s:3:"138";i:43;s:3:"139";i:31;s:1:" 0";i:32;s:1:"0";i:33;s:1:"0";i:34;s:1:"0";i:35;s:1:"0";i:36;s:1:"0";i:58;s:1:"0" ;i:62;s:3:"313";s:9:"75_chk358";s:3:"358";s:9:"81_chk387";s:3:"387";}s:17:"attri butes_values";a:7:{i:31;s:4:"21.5";i:32;s:5:"13.25";i:33;s:2:"12";i:34;s:4:"11.5 ";i:35;s:5:"13.25";i:36;s:1:"5";i:58;s:65:"For Bricia Pini/Model Release Needed. 1 inch widow's peak needed.";}}}', cart_total = '749', order_id = '0' WHERE tracking_id='14312']

Thanks in advance.

[a_berezin]

Replace

$db->Execute("UPDATE " . TABLE_SUPERTRACKER . " SET last_click = NOW(), exit_page='" . zen_db_input(zen_db_prepare_input(urldecode($_SERVER['REQUEST_URI']))) . "', exit_page_name='" . $page_title . "', num_clicks=num_clicks+1, added_cart='" . $tracking_data->fields['added_cart'] . "', categories_viewed='" . $categories_viewed . "', products_viewed='" . $tracking_data->fields['products_viewed'] . "', customer_id='" . $customer_id . "', completed_purchase='" . $completed_purchase . "', cart_contents='" . $cart_contents . "', cart_total = '" . $cart_total . "', order_id = '" . $order_id . "' WHERE tracking_id='" . $tracking_data->fields['tracking_id'] . "'");

by

      $db->Execute("UPDATE " . TABLE_SUPERTRACKER . "
                    SET last_click = NOW(),
                        exit_page='" . zen_db_input(zen_db_prepare_input(urldecode($_SERVER['REQUEST_URI']))) . "',
                        exit_page_name='" . $page_title . "',
                        num_clicks=num_clicks+1,
                        added_cart='" . zen_db_input($tracking_data->fields['added_cart']) . "',
                        categories_viewed='" . zen_db_input($categories_viewed) . "',
                        products_viewed='" . zen_db_input($tracking_data->fields['products_viewed']) . "',
                        customer_id='" . (int)$customer_id . "',
                        completed_purchase='" . zen_db_input($completed_purchase) . "',
                        cart_contents='" . zen_db_input($cart_contents) . "',
                        cart_total = '" . zen_db_input($cart_total) . "',
                        order_id = '" . (int)$order_id . "'
                    WHERE tracking_id='" . (int)$tracking_data->fields['tracking_id'] . "'");

[samson_ite]

Newbie to Zen-Cart here, and I just want to thank you for developing this mod. Works great, and I hope to add some contributions as well.

Thanks again!

[bhunted]

Bez.... any ideas why my issue exists? Any help would be appreciated.

[Arliss61]

Hi Andrew

I have had Supertracker loaded for a few days without GeoIP.dat and it worked fine (except the country report).

Yesterday I unzipped GeoIP and loaded it to my shop/includes directory but now get the following error reports:

Warning: supertracker::include(includes/geoip.inc) [function.supertracker-include]: failed to open stream: No such file or directory in /home/charcool/public_html/shop/includes/classes/supertracker.php on line 190

Warning: supertracker::include() [function.include]: Failed opening 'includes/geoip.inc' for inclusion (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/charcool/public_html/shop/includes/classes/supertracker.php on line 190

Fatal error: Call to undefined function geoip_open() in /home/charcool/public_html/shop/includes/classes/supertracker.php on line 191

My site is at www.charcool.com

Have I messed up the unzipping or have I loaded it to the wrong place?

Thanks for your help

[longstockings]

The file geoip.inc should be in /shop/admin/includes/

Just had a look at your site and this file does not exist.

[coolglobal]

Will installing Supertracker slow the website? Is it using logfile analysis?

[Arliss61]

longstockings, thanks.

I have moved GeoIP to the includes/admin/folder and seems to be working ok now. It is really a pretty good mod.

cheers and happy new year