Supertracker

[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

[knighs2]

Hi Guys,

Ive had this mod installed for a while now, but for some reason it doesnt track Top Sales Generating Referrers.

Has anyone else noticed this ? Im also using Super Orders so not sure if this would make a difference ?

Thanks
Shane

[phark]

I've installed this mod and it says Database Info: the Supertracker database currently holds 0 rows.

I have geoip.inc and geoip.dat installed in admin/includes. Any suggestions?

Thanks!

[BlessIsaacola]

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'] . "'");

Where is the file location where this patch needs to be applied?