Supertracker

[limelites]

Since upgrading to PHP 5.3, this mod no longer works. Bailed carts, Successful Checkouts and other features are not working on PHP 5.3

Does anyone know if the author will be releasing a PHP 5.3 compatible update as I really liked this mod a lot.

[photovoltaik]

The "SuperTracker" is the principal input source for Federal Express' Cosmos II Package Tracking System, which won the prestigious Malcolm Baldridge award for technical excellence in 1990. It also gave them a significant advantage in this highly competitive market.

The SuperTracker hand-held device carried by FedEx collection and delivery agents uses a Hitachi 6303 8-bit microcontroller. It has a 32K PROM and extended RAM for program and data storage. A bar-code scanner in the tip of the SuperTracker device is used to scan package IDs which are kept, along with other data entered from the keyboard on the device, in a database in the RAM. The scanner is also used to communicate with a processor in its rack, which contains a battery charger and a RF transmitter used for up-loading package information to the computers at the FedEx regional centres.

[davewest]

Since upgrading to PHP 5.3, this mod no longer works. Bailed carts, Successful Checkouts and other features are not working on PHP 5.3

Does anyone know if the author will be releasing a PHP 5.3 compatible update as I really liked this mod a lot.

Did you get this to work for you?

I been having the same problem.... for now, soved it by removing the time checks...

includes\classes\supertracker.php
Removing this from the sql tests... all three tests.

AND last_click > '" . $thirty_mins_ago . "'

Got my bailed and completed carts back... also its tracking the same user in one entry now.

From my testing it look like a difference in server and MySQL database times, but I couldn't resolve it without removing the time tests.

[limelites]

Did you get this to work for you?

I been having the same problem.... for now, soved it by removing the time checks...

includes\classes\supertracker.php
Removing this from the sql tests... all three tests.

AND last_click > '" . $thirty_mins_ago . "'

Got my bailed and completed carts back... also its tracking the same user in one entry now.

From my testing it look like a difference in server and MySQL database times, but I couldn't resolve it without removing the time tests.

Thanks for posting this fix, works like a charm for me. I'm so glad to have my bailed carts and single user tracking back that I couldn't carre less about the time checks. Thank you!

[davewest]

Thanks for posting this fix, works like a charm for me. I'm so glad to have my bailed carts and single user tracking back that I couldn't carre less about the time checks. Thank you!

After running without the time test for a while.... its is needed.

I went back and started testing to see what or how to do time... and I think its a difference in MySQL database time and server or scripting time.... anyway, inshort, found that using the standard NOW() in the SQL statement to store the time was setting the clock different then the server time. (I changed the time in php.ini not the PC) Put the checks back in as they was and add this line above them.. line in red.

        $arrived_time = date('Y-m-d H:i:s', time());
        $thirty_mins_ago = date('Y-m-d H:i:s', (time() - (30*60)));

Then down near the bottom make the changes to the SQL statements that are in red..

$db->Execute("UPDATE " . TABLE_SUPERTRACKER . "
                    SET last_click = '" . $arrived_time . "',
                        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'] . "'");

and in the next set below the last one...

$db->Execute("INSERT INTO " . TABLE_SUPERTRACKER . " 
                    (ip_address, 
                    browser_string, 
                    country_code, 
                    customer_id,
                    referrer, 
                    referrer_query_string, 
                    landing_page, 
                    landing_page_name, 
                    exit_page, 
                    exit_page_name, 
                    time_arrived, 
                    last_click, 
                    products_viewed) 
                VALUES ('" . zen_db_input($_SERVER['REMOTE_ADDR']) . "', 
                '" . zen_db_input($user_agent) . "', 
                '" . $country_code . "', 
                '" . (int)$_SESSION['customer_id'] . "', 
                '" . zen_db_input($referrer) . "', 
                '" . zen_db_input($referrer_query_string) . "', 
                '" . $this_page . "', 
                '" . $page_title . "', 
                '" . $this_page . "', 
                '" . $page_title . "', 
                '" . $arrived_time . "', 
                '" . $arrived_time . "',
                '" . zen_db_input($products_viewed) . "')");

This is working for me so far.... you can test this on a testing server by setting the php.ini timezone to something other then your PC timezone....

What you see in the code above may be different then what you have in your file..... Please edit and not copy&paste.... then backup your database before running the code....

[nohart]

Can someone upload a corrected version? It seems that there is some errors after reading this thread and I am running the latest v1.3.9g. Or can someone point us to a corrected version on the internet?

[SWLady]

Can someone upload a corrected version? It seems that there is some errors after reading this thread and I am running the latest v1.3.9g. Or can someone point us to a corrected version on the internet?

I would appreciate this also. Am upgrading now and really love Supertracker!

[stanislawl]

Hi,

First of all thank you for the great extension.

I have a problem with countries codes - they are not stored in the table; the filed 'country code' is always '--'. What may be the reason? I use ZC v. 1.3.9h.

Best regards,
Stan

[stanislawl]

Sorry, that's my fault. I did not install GeoIP.dat...

[stanislawl]

Hello,

It seems to me there is something missed from the file admin/supertracker.php. When I choose Top Landing Pages (No Sale, but added to cart) from the pull-down list (language variable: TEXT_TOP_LANDING_PAGES_NO_SALE) there is no result displayed.

I have added this piece of the code:

[FONT="Courier New"]case 'landing_added':
$title = TEXT_TOP_LANDING_PAGES_NO_SALE;
$headings[] = TEXT_SERIAL;
$headings[] = TEXT_LANDING_PAGE;
$headings[] = TEXT_NUMBER_OF_OCCURRENCES;
$row_data[] = 'landing_page';
$row_data[] = 'total';
$tracker_query_raw="SELECT landing_page, COUNT(*) as total FROM " . TABLE_SUPERTRACKER . " WHERE completed_purchase='false' AND added_cart='true' GROUP BY landing_page ORDER BY total DESC";
break;
[/FONT]
after the line 292. Now it is OK.

Am I right?

Best regards,
Stan