User tracking mod

[mc12345678]

Regarding ip blocker, if on the allowed list, selection takes to no list so that next selection. Takes to blocked.

Another is that active shopper with cart items is only record that shows with items in cart.

[torvista]

Looking at the big picture, would this not be a better fit as a mod to who's online?

I have only "fixed" minor errors or things i found broken but one issue is the install sql, which tries to use an array of an array which does not work, I would like to fix that at least but it's a bit involved to understand :

INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, use_function, set_function) VALUES ('User Tracking (Purge Units)', 'CONFIG_USER_TRACKING_PURGE_UNITS', '1440', 'Pick the units associate with the periodicity to allow purging data.<br/>', @UserTrackgID, 31, NOW(), NULL, '
zen_cfg_select_option(array
(array(''id''=>''60'', ''text''=>''Hours''),
array(''id''=>''1440'', ''text''=>''Days''),
array(''id''=>''10080'', ''text''=>''Weeks''),
array(''id''=>''43200'', ''text''=>''Months (Based on 30 days)'
')),');

[mc12345678]

Looking at the big picture, would this not be a better fit as a mod to who's online?

I have only "fixed" minor errors or things i found broken but one issue is the install sql, which tries to use an array of an array which does not work, I would like to fix that at least but it's a bit involved to understand :

If I remember how I. Have gotten through this correctly is to escape the quotes... Ie. The concept is correct, but implementation within the construct is incorrect.

[mc12345678]

Looking at the big picture, would this not be a better fit as a mod to who's online?

I have only "fixed" minor errors or things i found broken but one issue is the install sql, which tries to use an array of an array which does not work, I would like to fix that at least but it's a bit involved to understand :

If I remember how I. Have gotten through this correctly is to escape the quotes... Ie. The concept is correct, but implementation within the construct is incorrect.

Sorry that I did not also give the comment/question more of an explanation.

The array of arrays is to provide a dropdown that is 1) understandable to users, but with stored data that does not require manipulation when used in the calculations... The look of the install is "more complicated", but when the sql is properly formatted and applied, the configuration panel use is simplified and clearer. This reduces the need to use statements such as:

Choose 60 for hours, 1440 for days, etc... Instead one chooses hours, or days and the value 60 or 1440, respectively is stored in the database and used in calculations...

The SQL that has worked for me, recognizing the "issue" with the incorrect use of double quotes which was also identified through review of the ZC default installation sql for similar type of options to be provided is:

# If this script has been run before, this line is likely to cause an error. Check logs folder (ZC V >=1.5.1) or cache folder (ZC V <= 1.5.0)  If this is the SQL command that caused an error, it may be removed or commented.
INSERT INTO admin_pages (page_key, language_key, main_page, menu_key, display_on_menu, sort_order) VALUES ('UserTracking', 'BOX_TOOLS_USER_TRACKING', 'FILENAME_USER_TRACKING', 'tools', 'Y', 10000);

# If this script has been run before, this line is likely to cause an error. Check logs folder (ZC V >=1.5.1) or cache folder (ZC V <= 1.5.0)  If this is the SQL command that caused an error, it may be removed or commented.
INSERT INTO configuration_group (`configuration_group_title`, `configuration_group_description`, `visible`) VALUES ('User Tracking Config', 'User Tracking', 1);

# Do not remove these SQL lines.  They are needed for further processing.
SELECT @UserTrackgID := configuration_group_id
FROM configuration_group where configuration_group_title = 'User Tracking Config';
UPDATE configuration_group SET sort_order = @UserTrackgID WHERE configuration_group_id = @UserTrackgID AND configuration_group_id != 0;

# If this script has been run before, this line is likely to cause an error. Check logs folder (ZC V >=1.5.1) or cache folder (ZC V <= 1.5.0)  If this is the SQL command that caused an error, it may be removed or commented.
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_CONFIGURATION', CONCAT('gID=', @UserTrackgID), 'configuration', 'Y', @UserTrackgID);

# DROP TABLE IF EXISTS user_tracking;  
/* The above line is not necessary on a new install as there is no expectation of another plugin
 naming the table the same.  If however, the below line is a problem, then either the above DROP TABLE should be uncommented
 or the below CREATE TABLE should be commented using double forward slashes.  This will depend on whether the table exists by running this previously or if another application has created this table. */
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 = @UserTrackgID and @UserTrackgID != 0;  
/* The above line is not necessary for a new installation as this information is not already entered in the database; however, if while attempting to run this query, there may be an error at the insert below and therefore this may need to be uncommented to move forward with it.  Be advised, this will remove all options that are currently on the User Trackings configuration menu. */

# If this script has been run before, one or more of the below lines are likely to cause an error. Check logs folder (ZC V >=1.5.1) or cache folder (ZC V <= 1.5.0). The line(s) below up to the SQL command that caused the error may be removed or commented out.

INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, use_function, set_function) VALUES ('User Tracking Visitors', 'ZEN_CONFIG_USER_TRACKING', 'true', 'Check the Customers/Guests behaviour? (each click will be recorded)', @UserTrackgID, 1, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),');
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, use_function, set_function) VALUES ('User Tracking (ADMIN)', 'ADMIN_CONFIG_USER_TRACKING', 'true', 'Check the ADMINs behaviour? (each click will be recorded)', @UserTrackgID, 2, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),');
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, use_function, set_function) 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)', @UserTrackgID, 10, NOW(), NULL, NULL);
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, use_function, set_function) 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 !', @UserTrackgID, 15, NOW(), NULL, NULL);
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, use_function, set_function) VALUES ('User Tracking (Admin User Can Delete)', 'CONFIG_USER_TRACKING_ADMIN_CAN_DELETE', 'true', 'Allow Record Deletion to be Active?<br/>Setting this to true will override ENTRY and SESSION purges.<br/>Default <b>true</b><br/>', @UserTrackgID, 25, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),');
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, use_function, set_function) VALUES ('User Tracking (Admin User Can Delete Historical Data)', 'CONFIG_USER_TRACKING_ADMIN_CAN_DELETE_RECORDS', 'false', 'Allow Record Deletion of records older than now - the purge duration set below.<br/>This value is ignored if Admin User Can Delete is set to true.  Otherwise set this to true to allow deletion of visits.<br/>Default <b>false</b>.<br/>', @UserTrackgID, 26, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),');
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, use_function, set_function) VALUES ('User Tracking (Admin User Can Delete SESSIONS)', 'CONFIG_USER_TRACKING_ADMIN_CAN_DELETE_SESSIONS', 'false', 'Allow SESSION Deletion to be Active?<br/>This setting is ignored if Admin User Can Delete is set to true.<br/>Default <b>false</b><br/>', @UserTrackgID, 27, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),');
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, use_function, set_function) VALUES ('User Tracking (Admin User Can Delete IP)', 'CONFIG_USER_TRACKING_ADMIN_CAN_DELETE_IP', 'false', 'Allow Deletion of records that match the identified IP address?<br/>This setting is ignored if Admin User Can Delete is set to true.<br/>Default <b>false</b><br/>', @UserTrackgID, 28, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),');
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, use_function, set_function) VALUES ('User Tracking (Purge this Number)', 'CONFIG_USER_TRACKING_PURGE_NUMBER', '3', 'What is the number associated with purging before the current date/time?<br/><br/>An example would be to choose 3 here and units of days to delete data greater than 3 days before today.<br/>', @UserTrackgID, 30, NOW(), NULL, NULL);
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, use_function, set_function) VALUES ('User Tracking (Purge Units)', 'CONFIG_USER_TRACKING_PURGE_UNITS', '1440', 'Pick the units associate with the periodicity to allow purging data.<br/>', @UserTrackgID, 31, NOW(), NULL, 'zen_cfg_select_option(array(array(\'id\'=>\'60\', \'text\'=>\'Hours\'), array(\'id\'=>\'1440\', \'text\'=>\'Days\'),array(\'id\'=>\'10080\', \'text\'=>\'Weeks\'),array(\'id\'=>\'43200\', \'text\'=>\'Months (Based on 30 days)\')),');
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, use_function, set_function) VALUES ('User Tracking (Type of User Interaction to Record)', 'CONFIG_USER_TRACKING_TRACK_TYPE_RECORD', '1', 'Type of user tracking to record?<br/><br/>1 - All visitors.<br/>2 - Visitors views where sessions have been started.<br/>3 - All users except bots/spiders ( requires Configuration->Sessions->Prevent Spider Sessions->true)  (Don\'t know if this works with Zen-Cart versions older than 1.2.6d)<br/><br/>Related to above: If you set Force Cookie Use->true, then at the first user entry, sessions do not start!!! And in variants 2 and 3, user-tracking will not have started. In this case you lose one click and do not log the referal. But if this user is a returning user and has an old/previous zen cookie the session started and your tracking system will collect this info. So, the result beforehand is not logged or will not be known.<br/>', @UserTrackgID, 40, NOW(), NULL, 'zen_cfg_select_option(array(\'1\', \'2\',\'3\'),');
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, use_function, set_function) 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)', @UserTrackgID, 50, NOW(), NULL, NULL);
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, use_function, set_function) VALUES ('User Tracking (Show Product Category when tracking product clicks)', 'ZEN_CONFIG_SHOW_USER_TRACKING_CATEGORY', 'true', 'Show Product Category when tracking product clicks', @UserTrackgID, 60, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),');
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, use_function, set_function) VALUES ('User Tracking (Version Installed)', 'CONFIG_USER_TRACKING_VERSION', '1.5', 'Shows the version number associated with user tracking and should be updated with each upgrade', @UserTrackgID, 1000, NOW(), NULL, 'zen_cfg_select_option(array(\'CONFIG_USER_TRACKING_VERSION\'),'); 

The above worked on a ZC 1.5.4 installation and is finally correct... Torvista may have other improvements in mind.

[mc12345678]

Sorry that I did not also give the comment/question more of an explanation.

The array of arrays is to provide a dropdown that is 1) understandable to users, but with stored data that does not require manipulation when used in the calculations... The look of the install is "more complicated", but when the sql is properly formatted and applied, the configuration panel use is simplified and clearer. This reduces the need to use statements such as:

Choose 60 for hours, 1440 for days, etc... Instead one chooses hours, or days and the value 60 or 1440, respectively is stored in the database and used in calculations...

The SQL that has worked for me, recognizing the "issue" with the incorrect use of double quotes which was also identified through review of the ZC default installation sql for similar type of options to be provided is:



The above worked on a ZC 1.5.4 installation and was finally error free... Didn't perform as desired, but didn't "throw an error"... Torvista may have other improvements in mind.

Acckkkk.. Worked, but didn't... Ie. It installed without error, but it did not provide the desired result... Feel like I should hang up my hat...

Incorrectly identified that one liner as a select_option instead of a select drop_down...

Therefore, now with that one change... The SQL to install User Tracking for the first time should be:

# If this script has been run before, this line is likely to cause an  error. Check logs folder (ZC V >=1.5.1) or cache folder (ZC V <=  1.5.0)  If this is the SQL command that caused an error, it may be  removed or commented.
INSERT INTO admin_pages (page_key, language_key, main_page, menu_key,  display_on_menu, sort_order) VALUES ('UserTracking',  'BOX_TOOLS_USER_TRACKING', 'FILENAME_USER_TRACKING', 'tools', 'Y',  10000);

# If this script has been run before, this line is likely to cause an  error. Check logs folder (ZC V >=1.5.1) or cache folder (ZC V <=  1.5.0)  If this is the SQL command that caused an error, it may be  removed or commented.
INSERT INTO configuration_group (`configuration_group_title`,  `configuration_group_description`, `visible`) VALUES ('User Tracking  Config', 'User Tracking', 1);

# Do not remove these SQL lines.  They are needed for further processing.
SELECT @UserTrackgID := configuration_group_id
FROM configuration_group where configuration_group_title = 'User Tracking Config';
UPDATE configuration_group SET sort_order = @UserTrackgID WHERE  configuration_group_id = @UserTrackgID AND configuration_group_id != 0;

# If this script has been run before, this line is likely to cause an  error. Check logs folder (ZC V >=1.5.1) or cache folder (ZC V <=  1.5.0)  If this is the SQL command that caused an error, it may be  removed or commented.
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_CONFIGURATION',  CONCAT('gID=', @UserTrackgID), 'configuration', 'Y', @UserTrackgID);

# DROP TABLE IF EXISTS user_tracking;  
/* The above line is not necessary on a new install as there is no expectation of another plugin
 naming the table the same.  If however, the below line is a problem, then either the above DROP TABLE should be uncommented
 or the below CREATE TABLE should be commented using double forward  slashes.  This will depend on whether the table exists by running this  previously or if another application has created this table. */
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 = @UserTrackgID and @UserTrackgID != 0;  
/* The above line is not necessary for a new installation as this  information is not already entered in the database; however, if while  attempting to run this query, there may be an error at the insert below  and therefore this may need to be uncommented to move forward with it.   Be advised, this will remove all options that are currently on the User  Trackings configuration menu. */

# If this script has been run before, one or more of the below lines are  likely to cause an error. Check logs folder (ZC V >=1.5.1) or cache  folder (ZC V <= 1.5.0). The line(s) below up to the SQL command that  caused the error may be removed or commented out.

INSERT INTO configuration (configuration_title, configuration_key,  configuration_value, configuration_description, configuration_group_id,  sort_order, date_added, use_function, set_function) VALUES ('User  Tracking Visitors', 'ZEN_CONFIG_USER_TRACKING', 'true', 'Check the  Customers/Guests behaviour? (each click will be recorded)',  @UserTrackgID, 1, NOW(), NULL, 'zen_cfg_select_option(array(\'true\',  \'false\'),');
INSERT INTO configuration (configuration_title, configuration_key,  configuration_value, configuration_description, configuration_group_id,  sort_order, date_added, use_function, set_function) VALUES ('User  Tracking (ADMIN)', 'ADMIN_CONFIG_USER_TRACKING', 'true', 'Check the  ADMINs behaviour? (each click will be recorded)', @UserTrackgID, 2,  NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),');
INSERT INTO configuration (configuration_title, configuration_key,  configuration_value, configuration_description, configuration_group_id,  sort_order, date_added, use_function, set_function) 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)', @UserTrackgID, 10, NOW(), NULL, NULL);
INSERT INTO configuration (configuration_title, configuration_key,  configuration_value, configuration_description, configuration_group_id,  sort_order, date_added, use_function, set_function) 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 !', @UserTrackgID, 15,  NOW(), NULL, NULL);
INSERT INTO configuration (configuration_title, configuration_key,  configuration_value, configuration_description, configuration_group_id,  sort_order, date_added, use_function, set_function) VALUES ('User  Tracking (Admin User Can Delete)',  'CONFIG_USER_TRACKING_ADMIN_CAN_DELETE', 'true', 'Allow Record Deletion  to be Active?<br/>Setting this to true will override ENTRY and  SESSION purges.<br/>Default <b>true</b><br/>',  @UserTrackgID, 25, NOW(), NULL, 'zen_cfg_select_option(array(\'true\',  \'false\'),');
INSERT INTO configuration (configuration_title, configuration_key,  configuration_value, configuration_description, configuration_group_id,  sort_order, date_added, use_function, set_function) VALUES ('User  Tracking (Admin User Can Delete Historical Data)',  'CONFIG_USER_TRACKING_ADMIN_CAN_DELETE_RECORDS', 'false', 'Allow Record  Deletion of records older than now - the purge duration set  below.<br/>This value is ignored if Admin User Can Delete is set  to true.  Otherwise set this to true to allow deletion of  visits.<br/>Default <b>false</b>.<br/>',  @UserTrackgID, 26, NOW(), NULL, 'zen_cfg_select_option(array(\'true\',  \'false\'),');
INSERT INTO configuration (configuration_title, configuration_key,  configuration_value, configuration_description, configuration_group_id,  sort_order, date_added, use_function, set_function) VALUES ('User  Tracking (Admin User Can Delete SESSIONS)',  'CONFIG_USER_TRACKING_ADMIN_CAN_DELETE_SESSIONS', 'false', 'Allow  SESSION Deletion to be Active?<br/>This setting is ignored if  Admin User Can Delete is set to true.<br/>Default  <b>false</b><br/>', @UserTrackgID, 27, NOW(), NULL,  'zen_cfg_select_option(array(\'true\', \'false\'),');
INSERT INTO configuration (configuration_title, configuration_key,  configuration_value, configuration_description, configuration_group_id,  sort_order, date_added, use_function, set_function) VALUES ('User  Tracking (Admin User Can Delete IP)',  'CONFIG_USER_TRACKING_ADMIN_CAN_DELETE_IP', 'false', 'Allow Deletion of  records that match the identified IP address?<br/>This setting is  ignored if Admin User Can Delete is set to true.<br/>Default  <b>false</b><br/>', @UserTrackgID, 28, NOW(), NULL,  'zen_cfg_select_option(array(\'true\', \'false\'),');
INSERT INTO configuration (configuration_title, configuration_key,  configuration_value, configuration_description, configuration_group_id,  sort_order, date_added, use_function, set_function) VALUES ('User  Tracking (Purge this Number)', 'CONFIG_USER_TRACKING_PURGE_NUMBER', '3',  'What is the number associated with purging before the current  date/time?<br/><br/>An example would be to choose 3 here and  units of days to delete data greater than 3 days before  today.<br/>', @UserTrackgID, 30, NOW(), NULL, NULL);
INSERT INTO configuration (configuration_title, configuration_key,  configuration_value, configuration_description, configuration_group_id,  sort_order, date_added, use_function, set_function) VALUES ('User  Tracking (Purge Units)', 'CONFIG_USER_TRACKING_PURGE_UNITS', '1440',  'Pick the units associate with the periodicity to allow purging  data.<br/>', @UserTrackgID, 31, NOW(), NULL,  'zen_cfg_select_drop_down(array(array(\'id\'=>\'60\',  \'text\'=>\'Hours\'), array(\'id\'=>\'1440\',  \'text\'=>\'Days\'),array(\'id\'=>\'10080\',  \'text\'=>\'Weeks\'),array(\'id\'=>\'43200\',  \'text\'=>\'Months (Based on 30 days)\')),');
INSERT INTO configuration (configuration_title, configuration_key,  configuration_value, configuration_description, configuration_group_id,  sort_order, date_added, use_function, set_function) VALUES ('User  Tracking (Type of User Interaction to Record)',  'CONFIG_USER_TRACKING_TRACK_TYPE_RECORD', '1', 'Type of user tracking to  record?<br/><br/>1 - All visitors.<br/>2 - Visitors  views where sessions have been started.<br/>3 - All users except  bots/spiders ( requires Configuration->Sessions->Prevent Spider  Sessions->true)  (Don\'t know if this works with Zen-Cart versions  older than 1.2.6d)<br/><br/>Related to above: If you set  Force Cookie Use->true, then at the first user entry, sessions do not  start!!! And in variants 2 and 3, user-tracking will not have started.  In this case you lose one click and do not log the referal. But if this  user is a returning user and has an old/previous zen cookie the session  started and your tracking system will collect this info. So, the result  beforehand is not logged or will not be known.<br/>',  @UserTrackgID, 40, NOW(), NULL, 'zen_cfg_select_option(array(\'1\',  \'2\',\'3\'),');
INSERT INTO configuration (configuration_title, configuration_key,  configuration_value, configuration_description, configuration_group_id,  sort_order, date_added, use_function, set_function) 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)', @UserTrackgID, 50, NOW(), NULL, NULL);
INSERT INTO configuration (configuration_title, configuration_key,  configuration_value, configuration_description, configuration_group_id,  sort_order, date_added, use_function, set_function) VALUES ('User  Tracking (Show Product Category when tracking product clicks)',  'ZEN_CONFIG_SHOW_USER_TRACKING_CATEGORY', 'true', 'Show Product Category  when tracking product clicks', @UserTrackgID, 60, NOW(), NULL,  'zen_cfg_select_option(array(\'true\', \'false\'),');
INSERT INTO configuration (configuration_title, configuration_key,  configuration_value, configuration_description, configuration_group_id,  sort_order, date_added, use_function, set_function) VALUES ('User  Tracking (Version Installed)', 'CONFIG_USER_TRACKING_VERSION', '1.5',  'Shows the version number associated with user tracking and should be  updated with each upgrade', @UserTrackgID, 1000, NOW(), NULL,  'zen_cfg_select_option(array(\'CONFIG_USER_TRACKING_VERSION\'),'); 

[torvista]

Incorrectly identified that one liner as a select_option instead of a select drop_down...

Correct...I found that yesterday but didn't have time to post it. The select_option function cannot handle multi arrays.

[torvista]

@mc12345678
You need to clean out your pms...you cannot receive any more.

[mc12345678]

@mc12345678
You need to clean out your pms...you cannot receive any more.

Saw the failed attempts and rectified for immediate use.

[Chargin]

Hi, is the latest version compatible with 1.39h?
I know on the download page it says "Compatible with Zen Cart v1.2.6 thru v1.3.x " but I just want to be sure. The readme in the download only talks of 1.50 and a 1.50 directory structure etc.
Which version should i download for 1.39h if the latest doesnt work? 1.4.3 perhaps?

I did search this thread for 1.39 but there was no reference in the thread at all...

[mc12345678]

Hi, is the latest version compatible with 1.39h?
I know on the download page it says "Compatible with Zen Cart v1.2.6 thru v1.3.x " but I just want to be sure. The readme in the download only talks of 1.50 and a 1.50 directory structure etc.
Which version should i download for 1.39h if the latest doesnt work? 1.4.3 perhaps?

I did search this thread for 1.39 but there was no reference in the thread at all...

The. Forum seach will not return results for any thread if searched on the text representing a ZC version.

As to compatibility, the version uploaded as the "latest" as stated above does not include several improvements incorporated over the last couple of years.

As to compatibility, well, nothing that I know of. Has removed the ability to use it with ZC. 1.3.9, but I would suggest upgrading before the site becomes inoperable when the PHP version is increased beyond the support ofthe software.