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.
Printable View
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.
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.http://sunrent.de/smileynormal.ico
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.http://sunrent.de/smileynormal.ico
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.
Got my bailed and completed carts back... also its tracking the same user in one entry now.Code:AND last_click > '" . $thirty_mins_ago . "'
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.
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.
Then down near the bottom make the changes to the SQL statements that are in red..Code:$arrived_time = date('Y-m-d H:i:s', time());
$thirty_mins_ago = date('Y-m-d H:i:s', (time() - (30*60)));
and in the next set below the last one...Code:$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'] . "'");
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....Code:$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) . "')");
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....
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?
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
Sorry, that's my fault. I did not install GeoIP.dat...
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