User tracking mod

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

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

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

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

[JeffD]

Woody:

Open the file admin/includes/geoip.inc to see the possible GEO_IP country return codes. Hope this helps!

Jeff

[Woodymon]

Open the file admin/includes/geoip.inc to see the possible GEO_IP country return codes. Hope this helps!

Good eye. From the include file I calculated the latest version of GeoIP.dat supports 243 countries.

So the countries' table Zen Cart 1.36' is missing 3 countries. Or maybe not. I see GeoIP includes EU which is not a country per se.

I found an ISO list at:
http://www.iso.org/iso/en/prods-serv.../list-en1.html

ISO site currently shows 244 official short names and code elements.

I see a good source of medium and larger sized flags at https://www.cia.gov/cia/publications...ftheworld.html

What is the generally acceptable source for those tiny flag gif files? I think the same are used by AWStats.

So my tally is:
Zen Cart = 240
ISO = 244
GeoIP = 243
CIA = 237
UT flags = 170

I never know when a potential customer from the ÅLAND ISLANDS may visit my shop and then submit a huge order. Need to be ready for that day ;-)

-Woody

[JeffD]

Woody:

AFAIK they are simply 18px wide by 12px high gif images.

BTW, I think you just volunteered to be the official user_tracking country flag provider! When you have them all ready... send them to me and I'll update the archive.

Thanks!
Jeff