Code:
ALTER TABLE customers ADD customers_extrafield varchar(32) NOT NULL AFTER customers_fax;
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES ('Display Extra Field #1', 'DISPLAY_EXTRAFIELD', 'true', 'Display Extra Field #1 on Sign Up page and My Account page', '5', '6', 'zen_cfg_select_option(array(\'true\', \'false\'), ', now());
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES ('Require Extra Field #1', 'EXTRAFIELD_REQUIRED', 'true', 'Require Extra Field #1 on Sign Up page and My Account page', '5', '7', 'zen_cfg_select_option(array(\'true\', \'false\'), ', now());
ALTER TABLE customers ADD customers_extrafield2 varchar(32) NOT NULL AFTER customers_extrafield;
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES ('Display Extra Field #2', 'DISPLAY_EXTRAFIELD2', 'true', 'Display Extra Field #2 on Sign Up page and My Account page', '5', '6', 'zen_cfg_select_option(array(\'true\', \'false\'), ', now());
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES ('Require Extra Field #2', 'EXTRAFIELD_REQUIRED2', 'true', 'Require Extra Field #2 on Sign Up page and My Account page', '5', '7', 'zen_cfg_select_option(array(\'true\', \'false\'), ', now());
ALTER TABLE customers ADD customers_extrafield3 varchar(32) NOT NULL AFTER customers_extrafield2;
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES ('Display Extra Field #3', 'DISPLAY_EXTRAFIELD3', 'true', 'Display Extra Field #3 on Sign Up page and My Account page', '5', '6', 'zen_cfg_select_option(array(\'true\', \'false\'), ', now());
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES ('Require Extra Field #3', 'EXTRAFIELD_REQUIRED3', 'true', 'Require Extra Field #3 on Sign Up page and My Account page', '5', '7', 'zen_cfg_select_option(array(\'true\', \'false\'), ', now());
ALTER TABLE customers ADD customers_extrafield4 TEXT NOT NULL AFTER customers_extrafield3;
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES ('Display Extra Field #4', 'DISPLAY_EXTRAFIELD4', 'true', 'Display Extra Field #4 on Sign Up page and My Account page', '5', '6', 'zen_cfg_select_option(array(\'true\', \'false\'), ', now());
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES ('Require Extra Field #4', 'EXTRAFIELD_REQUIRED4', 'false', 'Require Extra Field #4 on Sign Up page and My Account page', '5', '7', 'zen_cfg_select_option(array(\'true\', \'false\'), ', now());
ALTER TABLE customers ADD customers_extrafield5 varchar(32) NOT NULL AFTER customers_extrafield4;
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES ('Display Extra Field #5', 'DISPLAY_EXTRAFIELD5', 'true', 'Display Extra Field #5 on Sign Up page and My Account page', '5', '6', 'zen_cfg_select_option(array(\'true\', \'false\'), ', now());
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES ('Require Extra Field #5', 'EXTRAFIELD_REQUIRED5', 'true', 'Require Extra Field #5 on Sign Up page and My Account page', '5', '7', 'zen_cfg_select_option(array(\'true\', \'false\'), ', now());
I was using this to get 3 custom fields during signup in the past, that I no longer use. But this has been gone since last version of Zen Cart and no issues till now. So not sure if its related, but might still have this in my database. Also, I don't ever remember removing this module manually or upgrading.
Bookmarks