Yes that "feature" appeared with zen-cart v1.3.9
I had a quick look and couldn't see a quick fix
I can live without it for the time being as the other
info that this mod provides is more important to me.
Printable View
Hello, I have a fresh install on 1.39h using the User Tracking v.1.3.6.2 for ZEN1.3.7 mod for user tracking. I hope this is the right thread for questions...
user tracking comes up in my configuration menu, but not under the tools menu. Anybody have this problem, or am I looking in the wrong place? I have looked at over 100 posts, hope I am not repeating a solved problem.
My FTP program told me it uploaded the pages, but it did not, so that is the reason why it did not work. Had to go into webshell to figure that out, sorry that I could not find a delete or edit function on the forum for my previous post. Mike
In user Tracking Config I've entered the IP address of Google in the "Exclude this IP" heading.
Am I restricted to one IP address, I'm getting visited all the time by crawl.yahoo.net and would also like to exclude this IP address.
It's a toss-up which of these visits the most, but I'd like to not track them both.
Is both possible, or am I restricted to one.
Great add-on by the way. Really useful if users have any problems. You can see where they've been and what they've done.:clap:
Just tried that. No errors show, but not sure if that actually works.Quote:
Try entering the ips with comma's such as
104.105.151.123, 123.123.123.122
At the top of the User Tracking page where I haveClicking it doesn't remove the Yahoo records.Quote:
Delete all info from IP-Address 66.249.71.141, 67.195.37.98 purge all records
When only the Google bot was listedclicking on the ;purge all records link removed the record of Google visits.Quote:
Delete all info from IP-Address 66.249.71.141 purge all records
Tried that. See post 457.
Hi, I installed this and I would like to remove it. It does not have the remove sql file. I am trying to figure it out how to do that but I am very limited on programming.
Here's the sql file:
INSERT INTO admin_pages (page_key, language_key, main_page, page_params, menu_key, display_on_menu, sort_order) VALUES ('UserTracking', 'BOX_TOOLS_USER_TRACKING', 'FILENAME_USER_TRACKING', '', 'tools', 'Y', 10000);
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);
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 ''
) 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''),');
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', 999, 60, '2006-12-05 11:19:26', '2006-12-05 21:20:07', NULL, 'zen_cfg_select_option(array(''true'', ''false''),');
I am trying to figure it out. This is what I have so far BUT desparately need help.
SET @user_tracking=0;
SELECT (@user_tracking:=configuration_group_id) as user_tracking
FROM configuration_group
WHERE configuration_group_title= 'UserTrackingr';
DELETE FROM configuration WHERE configuration_group_id = @user_tracking;
DELETE FROM configuration_group WHERE configuration_group_id = @user_tracking;
Need some guru programming help to delete this addon from my database.
Thanks.