Supertracker

[damiantaylor]

Is there a way to stop intenal links appearing on the 'Top referrers' list?

for example, I have the following in my list:

Rank Referring URL
11 http://www.snowrepublic.co.uk/Clearance
14 http://www.snowrepublic.co.uk/helmets 1
15 http://www.snowrepublic.co.uk/tools/pocket

They are all internal links from my site so are muddying the waters for me a little when I'm trying to see who my top referrers are.

Thanks for the mod bye the way, it's already helped me figure out why a customer binned their cart!

[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.

[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]

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

[davewest]

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

Good catch....

replace TEXT_LANDING_PAGE with TABLE_TEXT_LANDING_PAGE

[stanislawl]

Hello again,

I have a problem with my website http://www.olaf.legnica.pl. Yesterday everything was OK and today... The correct look of the website is in shown in pic. 1. This morning it changed to the blank screen shown in pic. 2. The problem may be corrected by deleting the file includes/MY_TEMPLATE/jscript/jscript_supertracker.php. What's going on? Have I made something wrong?

Best regards,
Stan