User tracking mod

[JeffD]

Hi all:

I have uploaded a new version of the user tracking tool to the Zencart downloads area. Until it is released I updated the user tracking archive posted previously in (post 131) above to include the full fileset with all recent changes.

Taken from the readme, here are a list of the changes:

Modified the user_tracking.sql by extending the size of the last_page_url field from 64 characters to 128 characters as this was previously too short and would often truncate URL link data.

Truncated the session_id field from 128 characters to 32 characters as this was wasted space.

Changed the script itself into a form and added a popup date selection menu so you can select a specific date to begin the listing.

Fixed the functions to work with sql 5.x and for longer last_page_url field writes.

Added a missing country flag or two.

Included the latest GeoIP.dat file.

Updated language defines for the popup additions.

Installation is simple, just replace all current files with those in the archive and execute the sql provided in the readme.

Please let me know if you find any issues?

Jeff

[Woodymon]

It is possible this behaved differently in 1.2x Zencart as there were changes made to the logoff and the session handling since that version but at least for now I don't see an easy way to change this behavior.

Yes I don't see this same behavior in a 1.27 shop yet to be upgraded.

Firefox2 provides an ability to manually clear "authenticated sessions" from private data. When I do this and then log back in to the customer account, User Tracking running on the 1.3x shop, indeed shows a new session was created.

Pity the changes from 1.2x to 1.3x decreased the usefulness of the User Tracking mod.

Thanks for the info.

Woody

[Woodymon]

Modified the user_tracking.sql by extending the size of the last_page_url field from 64 characters to 128 characters as this was previously too short and would often truncate URL link data.

Hi Jeff-

My assumption is the sql below is for those updating from the previous version of User Tracking (08/31/2006 - Version: 20060805 by PingHead)?

Below is the commands necessary for the sql patch tool to alter the table to the new format described in the user_tracking.sql and described above:

ALTER TABLE `user_tracking` CHANGE `session_id` `session_id` VARCHAR(32);
ALTER TABLE `user_tracking` CHANGE `last_page_url` `last_page_url` VARCHAR(128);

Thanks for the update,
Woody

[JeffD]

Yes, if you want to keep current table data intact just execute those two commands or if you don't care and want to drop the table and create a fresh one execute the user_tracking.sql contents.

Jeff

[Woodymon]

Regarding Jeff's new update...

Using previous version I implemented the following solution provided by Andrew (a_berezin) in post #129 of this thread, to make User Tracking work correctly with Admin Profiles installed (solves issue with User Tracking Config incorrectly displaying twice in the admin menus, so instead of also showng up in the Tools menu, it now only displays on the Configuration menu).

21st November 2006, 01:51 PM

1. Run this sql-patch:

UPDATE configuration_group SET visible = '1' WHERE configuration_group_id =999 LIMIT 1 ;

2. Remove user_tracking_config.php from user_tracking_tools_dhtml.php box (for admin_profile):

$options = array( array('box' => BOX_TOOLS_USER_TRACKING, 'page' => FILENAME_USER_TRACKING) );

3. Remove user_tracking_config.php file from admin directory.

Following step 3 above should I not upload /admin/user_tracking_config.php for the new version?

Thanks,
Woody

[irischant]

I've just installed this for the first time & am getting the following error when I try to access User Tracking Configuration in admin:

Fatal error: Cannot use object of type queryFactoryResult as array in /home/blubrix/public_html/admin/user_tracking_config.php on line 107

The main User Tracking page in admin seems to be working just fine, it's just the configuration that's not pulling through here. I'm using 1.3.6...no previous installs of this mod & no Admin Profiles installs either.

[JeffD]

Woody:

Yes, if you can somehow force the session id to change once you logoff as the customer (by any means available) then the user tracking data should display as "Guest" for the balance of the browser session.

The problem is simply when you logoff as a customer the session id remains the same (even though the session has been destroyed) so the session tracking continues to record (as Guest) but under the existing (same) session id and since the session id was previously associated with the customer account, continues to display this way. I am not aware of any PHP call that could be made at this point to aquire a different session id.

Jeff

[Woodymon]

Comparing the contents of /admin/images/flags in the new version of User Tracking with he previous version.

I observe two new flag image files
ps.gif
sv.gif

The flags directory for the new version contains 170 flag images.

I observe the following files are no longer provided:
kw.gif (Kuwait)
.gif
0.gif

Any thoughts why the flag for Kuwait was deleted from /admin/images/flags and which countries PS & SV represent?

And what did 0.gif and .gif. I know they both were the same image but could not identify the flag.

I observe the 'countries' table for Zen Cart 1.36 contains 240 records. Any ideas on how to round up additional 70 missing flag images?

In the 'countries' table I observe no reference to any country with PS or SV in the countries_iso_code_2 field.

Anyone know of a quick method to confirm the number of countries listed in the GeoIP.dat database?

Anyone know if the ISO is the authoritative source for the actual number of countries "in existence" at a particular time.

Woody

[JeffD]

irischant:

I'm sorry there were errors and ommisions in the sql of the archive.

Please execute the following in the sql patch too and it should get you fixed up:

DROP TABLE IF EXISTS user_tracking;
CREATE TABLE user_tracking (
  `customer_id` int(11) default NULL,
  `click_id` int(11) default NULL,
  `full_name` varchar(64) NOT NULL default '',
  `session_id` varchar(32) NOT NULL default '',
  `ip_address` varchar(15) NOT NULL default '',
  `time_entry` varchar(14) NOT NULL default '',
  `time_last_click` varchar(14) NOT NULL default '',
  `last_page_url` varchar(128) NOT NULL default '',
  `referer_url` varchar(254) NOT NULL default '',
  `page_desc` varchar(64) NOT NULL default ''
) TYPE=MyISAM;




DELETE FROM configuration where configuration_group_id = '999';
INSERT INTO `configuration_group` (`configuration_group_id`, `configuration_group_title`, `configuration_group_description`, `sort_order`, `visible`) VALUES (999, 'User Tracking Config', 'User Tracking', 31, 1);
INSERT INTO configuration VALUES ('', 'User Tracking (ADMIN)', 'ADMIN_CONFIG_USER_TRACKING', 'true', 'Check the ADMINs behaviour ? (each click will be recorded)', 999, 2, '2003-03-03 11:19:26', '2003-02-09 21:20:07', NULL, 'zen_cfg_select_option(array(''true'', ''false''),');
INSERT INTO configuration VALUES ('', 'User Tracking (exclude this IP-Address)', 'CONFIG_USER_TRACKING_EXCLUDED', 'your IP', 'Do NOT record this IP Address<br>(like webmaster/owners/Beta-testers)', 999, 10, '2003-03-04 23:08:38', '2003-02-09 21:20:07', NULL, NULL);
INSERT INTO configuration VALUES ('', 'User Tracking (Session Limit)', 'CONFIG_USER_TRACKING_SESSION_LIMIT', '50', 'Displaying the latest # sessions of this 24 hour period.<br>(SET to 999999 for unlimited per 24 hour period)<br>NOTE:<BR>Watch you space !', 999, 15, '2003-03-03 11:19:13', '2003-02-09 21:20:07', NULL, NULL);
INSERT INTO configuration VALUES ('', 'User Tracking (your favorite WHOIS URL)', 'USER_TRACKING_WHOIS_URL', 'http://www.dnsstuff.com/tools/whois.ch?ip=', 'Put here you favorite WHOIS tracking site<br>(the IP will follow automaticly after this url)', 999, 50, '2003-03-03 11:19:13', '2003-03-11 11:40:01', NULL, NULL);
INSERT INTO configuration VALUES ('', 'User Tracking Visitors', 'ZEN_CONFIG_USER_TRACKING', 'true', 'Check the Customers/Guests behaviour ? (each click will be recorded)', 999, 1, '2003-03-03 11:19:26', '2003-02-09 21:20:07', NULL, 'zen_cfg_select_option(array(''true'', ''false''),');

I will correct the archive sql and re-upload in a few minutes.

Jeff

[irischant]

Hi Jeff

I just applied that patch, cleared my browser cache & am still getting the same error.