-- Update core settings
UPDATE cscart_settings_objects
SET value = REPLACE(value, 'login=Y', 'login=Y&recover=Y')
WHERE
section_id = (
SELECT section_id
FROM cscart_settings_sections
WHERE name = 'Image_verification'
AND type = 'CORE'
)
AND name = 'use_for'
AND value LIKE '%login=Y%';
-- Update vendor-specific core settings
UPDATE cscart_settings_vendor_values
SET value = REPLACE(value, 'login=Y', 'login=Y&recover=Y')
WHERE
object_id = (
SELECT object_id
FROM cscart_settings_objects
WHERE section_id = (
SELECT section_id
FROM cscart_settings_sections
WHERE name = 'Image_verification'
AND type = 'CORE'
)
AND name = 'use_for'
AND value LIKE '%login=Y%'
)
AND value LIKE '%login=Y%';
-- Update reCAPTCHA settings
UPDATE cscart_settings_objects
SET value = CONCAT('a:1:{s:7:"recover";s:', LENGTH(value) - 1, ':"', SUBSTRING(value, 2, LENGTH(value) - 2), '";}')
WHERE
section_id = (
SELECT section_id
FROM cscart_settings_sections
WHERE name = 'recaptcha'
AND type = 'ADDON'
)
AND name = 'recaptcha_use_for_value';
-- Update vendor-specific reCAPTCHA settings
UPDATE cscart_settings_vendor_values
SET value = CONCAT('a:1:{s:7:"recover";s:', LENGTH(value) - 1, ':"', SUBSTRING(value, 2, LENGTH(value) - 2), '";}')
WHERE
object_id = (
SELECT object_id
FROM cscart_settings_objects
WHERE section_id = (
SELECT section_id
FROM cscart_settings_sections
WHERE name = 'recaptcha'
AND type = 'ADDON'
)
AND name = 'recaptcha_use_for_value'
);