User Tracking

This module tracks your visitors hits on your sitepages and displays pages visited and searches done by users, lists the result in admin, sorted by user-sessions.
Compatible with Zen Cart v1.2.6 thru v1.3.x

Forum Support Thread

Zen Cart® Versions v1.5.1, v1.5.3, v1.5.4, v1.5.5, v1.5.6, v1.5.7
Original Author DrByte
Last Updated by mc12345678 - 14 Jan 2021
Downloads 16,472

Version History

User Tracking   -   Version: v1.5.10
Updated 01/02/2020 Version 1.5.10 mc12345678:
1. Addressed strict error reporting associated with admin_id as an array key.
2. Verified operational in ZC 1.5.7. up to PHP 7.3.
3. Revised the display of session data so that the date/time was not wrapped and allowed the URI to be displayed over a longer row.
4. Added javascript to bring the selected session to view.
5. Began using array variable to simplify consistent modification of page html.
6. Added ability to disable display of admin activity.
7. Refactored the observer class. Eliminated excess else statements.
8. Moved code to a variable assignment instead of processing within a function.
9. Made use of some of the unused internal variables.
10. Removed redundant checks against the value of some global variables.
11. Added database removal code to observer so can be used more robustly, even possibly automatically.
12. Simplified zen_check_bot function.
13. Updated the installer to remove variable $current_version, ensure operation,
14. provide compatibility for longer version identifiers,
Zen Cart® Versions v1.5.1, v1.5.3, v1.5.4, v1.5.5, v1.5.6, v1.5.7
Date Added 14 Jan 2021
Author mc12345678
File Size 832.5 KB
PHP 5.3 Safe? No
Downloads 124
User Tracking   -   Version: 1.5.8
* Version 1.5.8:
* - Add an additional check to prevent an admin mydebug log being when the selection is made to display filtered entries to hide entries that accessed an item on the list of filtered URIs.
* - Incorporate optimizations provided by DrByte to improve the quality of the program.
* - Joined admin/includes/functions/extra_functions/user_tracking.php into the function code for the catalog side which meant that was able to incorporate into the catalog observer. Functions can be reached through the use of $user_tracking_observe->zen_update_user_tracking() instead of just zen_update_user_tracking().
* - Installer is expected to remove admin/includes/classes/class.user_tracking.php and admin/includes/functions/extra_functions/user_tracking.php if it is present because these files are no longer needed.
* - Incorporated ip data collection code into the program to support compatibility between ZC versions where for example the admin side doesn't have the same ip collection code.
* - Cleaned up the look of the code to be consistent within an individual file.
Zen Cart® Versions v1.5.1, v1.5.3, v1.5.4, v1.5.5
Date Added 24 Jul 2017
Author mc12345678
File Size 841.5 KB
PHP 5.3 Safe? Yes
Downloads 471
User Tracking   -   Version: 1.5.5
Version 1.5.5:
1. Removed HTML that was in the middle of PHP code.
2. Moved Admin menu option "name" to the languages folder to support multiple languages.
3. Improved sanitization for catalog and store side data capture.
4. Made radio labels clickable to support radio button activation.
5. Added feature to filter URL information that was captured when the site was visited.
6. Added default settings to the top of the admin/user_tracking.php file.
7. Removed unused code/variables in the two detection files.
8. Updated version compare software to latest available in the ZC 1.5.5 series (not identified yet to a specific version)
Zen Cart® Versions v1.5.0, v1.5.1, v1.5.3, v1.5.4, v1.5.5
Date Added 3 Jul 2017
Author mc12345678
File Size 832.1 KB
PHP 5.3 Safe? Yes
Downloads 45
User Tracking   -   Version: 1.5.4
Updated 06/10/2017 Version 1.5.4 mc12345678:
1. Revised the installer to restore the expected operation. Bug had been introduced that prevented recognition of full installation.
2. Incorporated an additional check/correction to support reperformance of the installation if an error was introduced during installation, helping to move forward from the above problem.
3. Generalized the installer further to not depend on the file extension taking only 4 characters in length.
4. Added install file to recognize this version.
5. Updated the geodata to the 8 June 2017 version.
6. Cleaned up code a little by removing closing php statements.
7. Prevent the install auto_loader from activating from the catalog side.
8. Rename class constructors to be PHP 7.0 compliant.
9. Modified the display of the User Tracking information to use the generic admin table type class/object.
10. The idea is/was that it may make transition to ZC 1.6.0 easier, though could also be undone as necessary.
11. Further completed the transition of GET links to POST buttons.
12. Incorporated the type conversion issue identified by davewest at:
13. Generally adjusted the lines of the main page to use spaces instead of tabs, aligned code to support improved readability.
14. Incorporated associated language file modifications,even if the language is/was not translated yet.
Zen Cart® Versions v1.5.0, v1.5.1, v1.5.3, v1.5.4, v1.5.5
Date Added 10 Jun 2017
Author mc12345678
File Size 828.2 KB
PHP 5.3 Safe? Yes
Downloads 61
User Tracking   -   Version: 1.5.3
1. Implemented an installation/upgrade script instead of expecting users to try to successfully run the installation sql and to
remove the need of clearing the database of existing records when performing an update that does not modify the records table.
2. Tightened security controls on the plugin by using focused database entry/record sanitization as well as output control to
reduce the likelihood of script being executed by display of attempted url. The captured session data only includes what is needed
to support the desired information to be displayed.
3. Updated code to be php 7.2 compliant based on reported deprecation of the each() function.
4. Modified the cart content display to provide cart data adjacent only to the record applicable to that cart.
5. Added a filter to show records that meet a minimum number of hits for that session.
6. Moved some standard html table code into using the default admin ZC table style code.
7. Converted the submit button to a post style submission instead of a get format.
8. Incorporated additional cod changes suggested by torvista as well as DrByte's most recent in forum posted version.
9. Basically restored the code back to the condition it was in at version 1.5.1.
10. Added the day forward/backward at the bottom of the page (so not just at the top).
11. Updated the geoip.dat file to the February 2017 version.
12. Removed the included User Tracking Configuration file to instead rely on the admin's configuration code.
Zen Cart® Versions v1.5.0, v1.5.1, v1.5.3, v1.5.4, v1.5.5
Date Added 23 Feb 2017
Author mc12345678
File Size 810.8 KB
PHP 5.3 Safe? Yes
Downloads 156
User Tracking   -   Version: 1.5.2
Corrected a bug in the 'new install user tracking.sql' file. Now works with the latest mySQL version. Old install file is included as well.  
Zen Cart® Versions v1.5.4
Date Added 23 Feb 2015
Author corseter
File Size 838.5 KB
PHP 5.3 Safe? Unknown
Downloads 652
User Tracking   -   Version: v1.5 Full
Updated 12/08/2013 Version 1.5

This is a full copy of the installation package. Unfortunately a smaller size of images has not yet been incorporated.

This version should correct any concerns regarding potential SQL injection.

1. Corrected a long standing issue with capturing data from the URL. The URLs are still truncated; however, they are now sent through for cleansing using Zen Carts db class prior to being sent to the SQL. This should reduce the occurrences of/prevent the SQL statement failure.
2. Incorporated a new GeoIP.dat file (recent as of: Dec-05-2013. Similar updates can be obtained from:
3. Incorporated a new file to accompany the GeoIP.dat file. The file can be obtained from:
4. Incorporated zen_href_link to generate links.

For SQL statements: If updating from version 1.4.2, then: Use the UPDATE_VER.sql after any other SQL statements (This will update the version number of User Tracking)
otherwise same instructions as applicable from the 11/10/2013 update.

Files Updated from Version 1.4.4:

Added UPDATE_VER.sql
Zen Cart® Versions v1.5.0, v1.5.1
Date Added 9 Dec 2013
Author mc12345678
File Size 553.0 KB
PHP 5.3 Safe? Yes
Downloads 789
User Tracking   -   Version: 1.4.4
Updated 11/26/2013 Version 1.4.4
1. Corrected a PHP warning that appeared because of use of the incorrect programming language.
2. Corrected a problem that could appear in the tracking_user_config area introduced in Version 1.4.3.

For SQL statements: same instructions as applicable from the 11/10/2013 update.

Files updated from 1.4.3b are:

Files updated from 1.4.3 or 1.4.3a are:
Zen Cart® Versions v1.5.0, v1.5.1
Date Added 27 Nov 2013
Author mc12345678
File Size 544.5 KB
PHP 5.3 Safe? Yes
Downloads 94
User Tracking   -   Version: 1.4.3b
Updated 11/24/2013 Version 1.4.3b
1. Corrected a PHP warning that appears if there are no visits tracked for the date being reviewed.
2. Corrected an issue that had the possibility of generating an error log: If a product's description included a character that would be translated by use of an escape character as part of a SQL command, (eg: he's would be changed to he\'s) then, if that escape character landed in just the right position, it would end up as the last character in the string prior to a single quote as part of the SQL statement. This would then cause an error in the execution of the SQL statement and an error log to be generated. Resolution was to remove the last character if that last character is a \. This issue has been resolved for: page description, last page URI, and referrer URI.
3. Updated the button display of spiders, such that if option 3 is chosen in system setup that a message appears.

For SQL statemenst: same instructions as applicable from the 11/10/2013 update.

Files updated from 1.4.3 or 1.4.3a are:
Zen Cart® Versions v1.5.0, v1.5.1
Date Added 25 Nov 2013
Author mc12345678
File Size 544.4 KB
PHP 5.3 Safe? Yes
Downloads 100
User Tracking   -   Version: 1.4.3
Previous file submission did not provide a complete list of files to be updated.
Please link this plug-in to forum

1. Added settings to Admin Config:
1.1) User visiting the User tracking page ability to delete log entries.
1.2) Ability to modify how much history to keep when purging/deleting entries using standard units of measure (hours, days, weeks, months (determined using 30 days)
1.3) Added option of data to submit into log based on user forum input.
1.4) Added a version field to the configuration utility.
2. Modified English Language File to show the duration and units of the record(s) being kept/purged.
3. Updated the shop's class.user_tracking observer to support logging of visits based on entries of the Zen-Cart user forum.
4. Changed the Update SQL file to reflect only those changes applicable with this upgrade (I.e. old update SQL which was only really applicable to upgrading older versions of User Tracking to an earlier version.
5. Added the number of unique visitors and spiders to the beginning of the list of sessions, so that it is now at top and bottom.
6. Hid all options to delete information if the admin has set the delete option to false, which means not only does it not display, but also that should not be able to use a get statement to delete the old data. The ability to delete all of the items overrides the inability to delete any one item. (ie., if delete all is on and delete IP set to off then delete IP will still be possible.)
7. Added uninstall_user_tracking.sql file.

Have not modified the logging/tracking to show more of the spiders that have been worked out of the log data. There are a few other improvements yet considered (such as an auto-installer) that have not been incorporated; however, there have been issues in the installation process that have been addressed in the forum but not incorporated into the files. A majority of that has been done.
Zen Cart® Versions v1.5.0, v1.5.1
Date Added 11 Nov 2013
Author mc12345678
File Size 673.5 KB
PHP 5.3 Safe? Yes
Downloads 145
User Tracking   -   Version: 1.4.2
Discovered that the OnChange event did not consistently work as expected so changed the new spider buttons to respond to OnClick events.
Added the functionality of using the notify/observer actions (Still requires a mod to the footer of the shop and the admin area for respective tracking)
Moved text into the language files.
Forced display of 0 instead of a blank value for responses that are equivalent to zero.
Added additional links to go Back to Today or Forward to Today respectively if two or more days away from the date that the user tracking log was shown.
Compressed the Readme's a little to attempt to simplify them and maintain the history that has been captured.
Zen Cart® Versions v1.5.0
Date Added 9 Jul 2013
Author mc12345678
File Size 658.0 KB
PHP 5.3 Safe? Yes
Downloads 342
User Tracking   -   Version: 1.4.1
Added ability to hide/show spider visits using the spiders.txt file of Zen Cart. Default view is to hide spider visits.

Modified the information shown at the bottom of the view to show the number of users and number of bots/spiders that have visited.
This spider/bot information will show whether the actual visit is or is not shown.

Also incorporated modifications published in the thread ( related to display of the Idle time of a visitor. (Previous calculations lead to incorrect display depending on timezone.)

Change only affected the admin/user_tracking.php file.
Zen Cart® Versions v1.5.0
Date Added 16 Jun 2013
Author mc12345678
File Size 656.2 KB
PHP 5.3 Safe? Unknown
Downloads 166
User Tracking   -   Version: 1.4.0
UPDATED 07/28/2011

Removed admin --_ includes --_ boxes (Entire Folder and Sub Folders)
SQL Added for Drop Down Link Under Tools Section

Rearranged and added Readme, Sql Directories
Added HOW_TO_UPDATE-V1.5.0.txt
Zen Cart® Versions v1.5.0
Date Added 29 Jul 2011
Author knuckle-101
File Size 655.4 KB
PHP 5.3 Safe? Yes
Downloads 1,919
User Tracking   -   Version:
Contribution: User Tracking
Version: user_tracking_for_zen
Designed for: Zen Cart v1.2 Release
Converted into Zen by: Dave Kennelly [email protected]
License: under the GPL - See attached License for info.
Support: Only given via the forums, please.

assembled: reza:02/15/2007,
I have not changed any thing in this contribution. when I got problem after installation of user tracker version 1.3.6 on zen 1.3.7 and reading all comments of the forum, I found that most of the peoples got the same problems due to the separation of original package and upgraded package. for This I decided to put all together for zen 1.3.7.

with thanks to Jeff and Woodymon for their supports in the forum. please address your donations to them.

rapid , fresh installation procedure:
1- the files in the contribution are arranges to zen 1.3.7 directory, just put them in the appropriate places
2- install sql patch file, preferabely by phpMyAdmin than add sql patch of zen ( as recommended in the forum)
3- File Modifications:
3-1- add the following to the end of /includes/templates/ YOUR TEMPLATE /common/tpl_footer.php

_?php if (ZEN_CONFIG_USER_TRACKING == 'true') { zen_update_user_tracking(); } ?_

3-2- add if you want to track admin pages viewed add the following to the end of /admin/includes/footer.php

_?php if (ADMIN_CONFIG_USER_TRACKING == 'true') { zen_update_user_tracking(); } ?_

4- go to admin of zen, in admin/configuration and or in admin/tools you should see user tracking config, by clicking on this you should see:
User Tracking Configuration

Title Value Action
User Tracking Visitors true
User Tracking (ADMIN) true
User Tracking (exclude this IP-Address) your IP
User Tracking (Session Limit) 50
User Tracking (your favorite WHOIS URL)
User Tracking (Show Product Category when tracking product clicks) true
User Tracking Visitors

Check the Customers/Guests behaviour ? (each click will be recorded)

Date Added: 09/02/2003
Last Modified: 03/03/2003
5- in admin/tools click on user tracking, you should see:

User Tracking Start:

This tool allows for you to see the click patterns of the users through your site, organized by sessions. This data can be very valuable to those looking for how to improve your site by watching how customers actually use it. You can surf back and forth through the days by using the link below.
SELECT VIEW: Back to Feb 15, 2007

Now displaying the latest 50 sessions of this 24 hour period. You can also purge all records past the last 72 hours of data.

Delete all info from IP-Address your IP purge all records

There have been 0 page views in this 24 hour period.
Session ID User Shopping Cart

6- troubelshootings:
6-1- first check again if all files are correctly located in the zen directories.
6-2- go to phpmyadmin, in table, configuration, delete all values related to user tracker , in table configuration-group, delete the table user tracking
6-3- try install sql package with alternative methode (if the first time was phpmyadmin, so this time do with zen admin add sql patch tools)
6-4- chack again if you have added two modifications to tpl.footer.php and footer.php
6-5- still problem, take a look at forum and submitt your question.
Zen Cart® Versions v1.3.7
Date Added 16 Feb 2007
Author reza
File Size 644.0 KB
PHP 5.3 Safe? Unknown
Downloads 7,951
User Tracking   -   Version:
Fixed omission and errors in supplied installation sql.
Added customers_host_address field support.
Revised the report query and listing to begin at midnight on the requested day rather than (the current time - 24 hours) as was the case previously. This just seems more useful and intuitive.
Zen Cart® Versions v1.3.6
Date Added 30 Nov 2006
Author JeffD
File Size 648.7 KB
PHP 5.3 Safe? Unknown
Downloads 1,401
User Tracking   -   Version: 1.3.6
Updated version of the User Tracking tool which includes support for dropdown menu for begin date selection, latest GeoIP.dat, additional flag images, fixes for mySQL 5.x and updated tracking table schema. Tested with 1.2.x and 1.3.x  
Zen Cart® Versions v1.3.6
Date Added 27 Nov 2006
Author JeffD
File Size 648.2 KB
PHP 5.3 Safe? Unknown
Downloads 476
User Tracking   -   Version: 20060805
Zen Cart® Versions
Date Added 31 Aug 2006
Author DrByte
File Size 633.0 KB
PHP 5.3 Safe? Unknown
Downloads 1,580

Zen-Cart, Internet Selling Services, Klamath Falls, OR