Contributions
Supertracker v3.1a
WHAT IT IS FOR
==============
The supertracker contrib is designed to give you more information on which to base marketing decisions for your osCommerce store. I created the supertracker contrib because, although there were some contribs around that provide a more detailed who's online tool, nothing quite gave me the information I was after.
Here is the information that is recorded for each customer arriving at your site:
referring page
referring query (so we can get at keywords used if search engine)
landing page (including query string - important for Pay Per Click campaign assessment)
arrival time
exit time
exit page
IP address
country code / country name
customer's cart contents
Number of clicks on the site (accuracy is not 100% as this is recorded based on session ID)
Categories Viewed
Products viewed
Customer ID (if signed in)
Order ID (if order was placed)
Were products added to cart (true/false)
Did the customer Checkout (true/false)
This is a full install package as the existing contribution mysteriously vanished a week or so ago.
Existing users are strongly advised to upgrade their installations - there is a just one file to replace if you are running the previous version.
Expand All / Collapse All
* Updated the installation and update instructions.
* Added recording of region and city of visitors (CityLite upgrade).
* Added and completed spanish, french and german language files
* Added a admin/supertracker.php version with "Version-Checker: http://addons.oscommerce.com/info/7148" code included.
* Added the bug fixes since v3.4 except the "Bugfix SuperTracker 3.4 and PDF Customer Invoice" which caused my supertracker installation not to work
* Note: The OSC 2.3.1. compatibility update is not included in this package. I separated the OSC 2.3.1. Version to a new package here:
* FULL PACKAGE
[EN]
When I installed the contribution for some time noticed that the flags were not displayed in the list of recent visitors to the site or in the country of origin of the visits.
The first point the path to the flags is not complete and the second point is simply not.
There are two options to make them visible, you can choose what you want.
The first is to move all the flags to another folder and provide the path for the second point.
The second is to indicate the correct path on the first point and provide the path to the second point.
This is not full package, only the instructions in English and Spanish.
[ES]
Cuando instalé la contribución hace tiempo observé que no se mostraban las banderas en el listado de los últimos visitantes del sitio ni en el pais de origen de las visitas.
En el primer punto la ruta a las banderas no está completa y en el segundo punto simplemente no está.
Hay dos opciones para conseguir que sean visibles, puede elegir la que desee.
La primera es mover todas las banderas a otra carpeta y facilitar la ruta para el segundo punto.
La segunda es indicar la ruta correcta en el primer punto y facilitar la ruta en el segundo punto.
No es un paquete completo, solo las instrucciones en español e inglés.
I know this is old now but I love this addon, I managed to add it to /admin/includes/boxes/reports.php after reading tuts on the forums, unfortunately it broke my admin menu in the new oscommerce and left me stuck for a while. Easy fix just edit /admin/supertracker.php.
Add near the top around line 34:
require(DIR_WS_INCLUDES . 'template_top.php');
This restores the nice admin menu .
Remove from line 88:
<?php require(DIR_WS_INCLUDES . 'column_left.php');?>
or you will end up with 2 left side menus
Short bug fix for Supertracker 3.4.1 if you are also using PDF Customer Invoice 1.1 (12 March 2008).
Using both of these contributions breaks PDF Customer Invoice. You will see an error message like below when a customer attempts to view their PDF invoice:
FPDF error: Some data has already been output, can't send PDF file
Simple fix. Took me some time to narrow it down, so hoping to save others the aggravation. :)
The problem is that Supertracker inserts data into the HTML stream before the PDF completes, which basically interrupts the PDF, causing it to abort. If you use any sort of FPDF application, I suspect you may run into this problem. The solution is to skip use of Supertracker when user is viewing a PHP account related form.
-----------
open /includes/application_top.php
from:
// Supertracker
require(DIR_WS_CLASSES . 'supertracker.php');
$tracker = new supertracker;
$tracker->update();
}
TO:
// Supertracker
if (strpos(basename($PHP_SELF),'account') !== false) {
require(DIR_WS_CLASSES . 'supertracker.php');
$tracker = new supertracker;
$tracker->update();
}
This is a fix of Package by fruchtge / 23 Feb 2010
Every so slight but will help lighten server loads.
We need to only call domain name lookup if the bot does not declare itself in User Agent string.
added a small
else { } around the function
as below
if ($bot_here) {
$record_session = false;
} else (
$host_name = gethostbyaddr($ip_address);
if(preg_match("/search.msn.com$/", $host_name) || preg_match("/search.live.com$/", $host_name)){
//the hostname does belong to either search.msn.com or search.live.com.
//Remember the User Agent did not say it was a Bot.
//So it's a misbehaving spider.
$record_session = false;
}
}
THIS IS NOT FULL PACKAGE install v3.4 then CityLite Upgrade first ...
I might get around to packaging full soon
This is an upgrade for 3.4 CityLite upgrade so please install first.
Changes:
- added Region of Origin stat to dropdown list
- added City of Origin stat to dropdown list
- added which browser was used to dropdown list
INSTALL:
Backup your files and Database...
Just copy the two files of the package and overwrite your existing files ore use a file compare tool to merge it.
Add a field "browser" to table supertracker. Use Phpmyadmin etc. with:
ALTER TABLE supertracker ADD browser VARCHAR(100) NULL;
Finished!
NOT A FULL PACKAGE
Wehn viewng last 10 visitors people like googlebot and other hgh users would cause scroll bars to appear. i have set it to 8 per row and put them in a small table so the scroll bars dont appear any more.
PACKAGE JUST CONTAINS FILE ADMIN/SUPERTRACKER.PHP and is direct rplacement (standard version 3.4 edited file)
Install otherwise is simple with the new code being added under the orignial code around line 609 onwards
THIS IS NOT FULL PACKAGE INSTALL v3.4 first
Wrong classes/supertracker.php file was archived.
This is the corrected version.
This adds recording of region and city of visitors.
Bot exclusion is turned ON by default.
Add exclude by domain to ignore msnbot's that give bad user agent strings.
Removed link to showmyip.com in "Last Ten Visitors" report.
Download the latest GeoCityLite.dat file from maxmind.com first
NOT FULL PACKAGE this is addon for V3.4
Made the possibility to chose how many listings we want to show for each page (Last Ten Site Visitors)
NOT full package!
traducción del archivo de lenguaje del admin al español
Just traduct in french languages.
juste une traduction en français
le fichier tar.gz est réalisé sous Mandriva 2009.
contact:Didier.louvet@login-users.eu
you also have to add this button in adminimages
(or you can put it wherever you like but don't forget to change the path in adminsupertracker.php line 634)
sorry for the double post for the same fix
When showing the last ten visitors sometimes (or maybe always to some of us) the next ten results button wasn't doing anything! Fixed this and added a back button - please replace the adminsupertracker.php with this one (you can see what i changed from line 632 to 644)*
*just a very small thanks to oscommerce family from me!
This is NOT the complete package it is just a fix - download Supertracker v3.4 package a few lines lower for the complete package!
Were you getting a blank page? Included file /includes/geopip.dat
FULL PACKAGE with UPDATE instructions
Since v3.3
----------
* Added "no image" file and check for no image in catalog/admin/supertracker.php
* Added troubleshooting section
Scott
Add the German Language file.
Att: * Added "Next Ten Results" button to last 10 visitors
did not work
Bug not fixed - sorry:-)
this is the full package again
FULL PACKAGE
Since v3.2b
-----------
* Stylesheet edit greatly reduced
* Major formatting changes
* Added "Next Ten Results" button to last 10 visitors
* Removed the "Go" button as it is not necessary
* Cleaned up the english file considerably (removed the redundancies and non-called defines)
* Cleaned up the instruction and updated the fileset
This is multi-language ready now, but needs translating...
Scott
Traduzione della contrib in lingua italiana
This is just an update to the classes/supertracker.php to use the value 'rep' rather than agent as it was conflicting with the variable used for saving the browser agent.
this is the full package again.
This install includes built on Supertracker v3.2b Mr Absinthe update of 21 Mar 2006. This is a full package, installation instructions for the AGENT feature are included in the package.
In this agent tracker version I added a feature to allow the tracking of an agent via the landing page get variable 'agent'. This means if you have sales reps who are selling for you and you need to track sales by agents, you can use this feature.
Then, the supertracker will add this agent flag to the database entry and you are able report by agent.
Updates were made to the reporting to allow any referrer report to also be reported on by Agent.
Additional updates included for the Last 10 Visitors report are:
- Agent ID to detail view
- a filter option for landing page,
- an exclude GoogleBot option. (In enabled the skip tracking of bots option in the classes/supertracker.php but this didnt completely work).
- Order ID is added to the Last 10 Visitors report, with a link directly to view that order.
Found an SQL Injection risk with Supertracker, to see if you are at risk, pull up a product page:
/index/product_info.php/ ... some_product_name
Now insert a some roque characters into the product name. ie.
som'e"produc(t<)name
Hit return, if you see a SQL error message, then your site can be hacked from here.
Attached is my copy of the general.php and supertracker.php. I've added clean_url function to general and use it to clean all POST data in Supertracker.php. This should solve most risks, but you may want to further define 'allowed' characters for each field. I also use a deep_clean function added in general to clean any input form fields.
Based on version from 13 Jan 2006
The below Monika's keyword filtering is included, added few defines to language files to make it multilingual.
- corrected few texts for defines
- changed overlapping coding in headings for TABLE_TEXT_KEY_PHRASE causing the text not being displayed
- amended use of class in tables to correspond with install
- added table heading for Countries Stats
- dropped espanol language folder as it was in English anyway
This is a full install package.
A quick hack for those that find the keywords search confusing as the database grows. I caught myself emptying the supertracker table so I could see the latest/new search strings - not the best idea!
With this hack you have the added option of seeing only keywords from the
- last 24h
- last 72h
- last week
- last month (30d)
- changed hard coded englsih by define in the language file
- cosmetic changes for strong caracteres
- few langauge correction
- commented the support links to gain palce in the admin webpage
-> the several languages need to finished to translate
support http://forums.oscommerce.com/index.php?showtopic=166141
Development Thread href="http://forums.oscommerce.com/index.php?showtopic=166839
WHAT IT IS FOR
==============
The supertracker contrib is designed to give you more information on which to base marketing decisions for your osCommerce store. I created the supertracker contrib because, although there were some contribs around that provide a more detailed who's online tool, nothing quite gave me the information I was after.
Here is the information that is recorded for each customer arriving at your site:
referring page
referring query (so we can get at keywords used if search engine)
landing page (including query string - important for Pay Per Click campaign assessment)
arrival time
exit time
exit page
IP address
country code / country name
customer's cart contents
Number of clicks on the site (accuracy is not 100% as this is recorded based on session ID)
Categories Viewed
Products viewed
Customer ID (if signed in)
Order ID (if order was placed)
Were products added to cart (true/false)
Did the customer Checkout (true/false)
This is a full install package as the existing contribution mysteriously vanished a week or so ago.
Existing users are strongly advised to upgrade their installations - there is a just one file to replace if you are running the previous version.
Note: Contributions are used at own risk.
Supertracker 3.5 for OSC 2.2.
flags