petro:
1:) is ok
2:)
3:) snapshot above was from the live tpl_footer file
4:) I never got the database SQL file to function properly.... The very first time I tried the copypasta into the admin>tools>install sql patches of the "new_install_user_tracking" sql file and got an error. then I tried it in myphpadmin and got a "duplicate" error, then based on some info In here I changed "TYPE=MyISAM" to "ENGINE=MyISAM" still get "duplicate" error. then I tried to run it one line at a time and got a "duplicate" error when I did these two lines by themselves:
INSERT INTO admin_pages (page_key, language_key, main_page, page_params, menu_key, display_on_menu, sort_order) VALUES ('UserTrackingConfig', 'BOX_TOOLS_USER_TRACKING_CONFIG', 'FILENAME_USER_TRACKING_CONFIG', '', 'tools', 'Y', 10001);
>
> After these two lines the remaining lines went off without a hitch...
>
> ```
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 '',
`customers_host_address` varchar(64) NOT NULL default ''
) ENGINE=MyISAM;
DELETE FROM configuration where configuration_group_id = '1084';
INSERT INTO configuration_group (`configuration_group_id`, `configuration_group_title`, `configuration_group_description`, `sort_order`, `visible`) VALUES (1084, '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)', 1084, 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)', 1084, 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 !', 1084, 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)', 1084, 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)', 1084, 1, '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 (Show Product Category when tracking product clicks)', 'ZEN_CONFIG_SHOW_USER_TRACKING_CATEGORY', 'true', 'Show Product Category when tracking product clicks', 1084, 60, '2006-12-05 11:19:26', '2006-12-05 21:20:07', NULL, 'zen_cfg_select_option(array(''true'', ''false''),');
So, couple of things some related to your original problem, some not. I've looked through the SQL files and I do see that there is a potential to receive the error you had when either applying the SQL update file or the SQL new install file. The error message received though does not bear on the lack of data collection that you are experiencing; however, when I get back to updating this plug-in some more I will incorporate sufficient checks/direction. There really should be no reason to have run the SQL more than the first time it was installed or if upgrading from a version that is older than User Tracking Ver 1.4.0. If any of the times the problem was experienced with the SQL file, then something else was going on or an issue with the database.
To be sure I understood, the tpl_footer file you presented above. Let's assume that you have an active template called ZenCart, so the end of the file shown above is from /includes/templates/ZenCart/common/tpl_footer.php?
With that in mind, I suggest verifying that the two added files /includes/auto_loaders/config.user_tracking.php and includes/classes/observers/class.user_tracking.php be reuploaded. These two files "listen" for the footer code to activate tracking of the users visiting the site. Currently tracking is occurring; however, it is only on the admin side.
