========================================
ENCRYPTED VALUES FOR DATABASE
========================================

Copy and paste these UPDATE statements into your MySQL client:

-- Encrypted Settings Updates
-- Run these to populate your site_settings table with encrypted values

UPDATE site_settings SET setting_value = 'kGNW+R1wR9boAPZSz7d2MmY1dWlRZ0J5QlpYVCt0TmYyZ21tZWUxUGRkc2NBeGJIcHRVSEI5NDMwQXUxeThYYiswZ2hpekxndE0wb2ZLcnJrR1dCd2lzZmcwcVV4NGV5TFZ6U2FnPT0=' WHERE setting_key = 'paystack_secret_key';
UPDATE site_settings SET setting_value = 'tVZ70yw2MSygMFLlDWgnTnYxQk55cGJpZ29xOVl1bGRJTHJhNGdROE40elptaFBoYnJnTWVVK0tTTjV5a0tVNHZ4eWVidVVyOW40RGRxWHNqeWQ5bHhDc2IyK3RMV21mb1NSTGdBPT0=' WHERE setting_key = 'paystack_public_key';
UPDATE site_settings SET setting_value = '5hU4BUi/YlvBpo42De+iSjJoSHlKWGcrNEFWTDNuRjh1QkFTYTdWRXBtZDFvYTZPWVpHeVUxTmN4NkM4YUJyOTdjTlZCbnN2bENDRy9Uelo4WHFCOGVRSEFtR2hvZTVyNExJQ3VMQ01EaThURVk4aDBLM244TUJGbnZnPQ==' WHERE setting_key = 'shipbubble_api_key';
UPDATE site_settings SET setting_value = 'joTD9s4mGyjDawVbnc6wvUQwYW9VVFJ0T2RJT2ZRSkNSUVBLSXZGNE04eDlrZU02UXpTTVdJVFpjUmc9' WHERE setting_key = 'smtp_pass';
UPDATE site_settings SET setting_value = 's/WscwoGMZvWrgcsuP4eRUJ1YzBHOEg3VlJ3RTE5QlBBT2N1eXRvMEYxdGt4elZKNWs4QzM3UzQ1QzI2cEdiZ2YxU0w4SC94Tk1XSk5FOWg=' WHERE setting_key = 'whmcs_api_key';

-- Non-encrypted settings (plain text values)
UPDATE site_settings SET setting_value = 'smtp.zoho.com' WHERE setting_key = 'smtp_host';
UPDATE site_settings SET setting_value = '587' WHERE setting_key = 'smtp_port';
UPDATE site_settings SET setting_value = 'seyi@karrybiz.com' WHERE setting_key = 'smtp_user';
UPDATE site_settings SET setting_value = 'seyi@karrybiz.com' WHERE setting_key = 'smtp_from';
UPDATE site_settings SET setting_value = 'Karrybiz' WHERE setting_key = 'smtp_from_name';
UPDATE site_settings SET setting_value = 'tls' WHERE setting_key = 'smtp_secure';

-- WHMCS Settings (plain text)
UPDATE site_settings SET setting_value = 'https://your-whmcs-domain.com/includes/api.php' WHERE setting_key = 'whmcs_api_url';
UPDATE site_settings SET setting_value = 'nvzt3lTCdWFSsLv1W9m8aG9fR6oGgFZp' WHERE setting_key = 'whmcs_api_identifier';

========================================
VERIFICATION (Encrypted Values)
========================================

Setting: paystack_secret_key
Original: sk_test_7d3a737ebea36ac8513766efb05284458c8956c2
Encrypted: jVheXCMtV5OslkkGh4JsNnl5WTlXWVM0S2pFOSt6VFR6SSthaFVxZ21MVEc3U3BOeTNMR2dOekFZK1lIUTJORUllT1hSbk15U1VYMmQvQ01JbE14SDNNSjZHVTJiWWhHSlRQKzJ3PT0=
Length: 140 characters
---

Setting: paystack_public_key
Original: pk_test_6699c7875928efa22d3a987c1a73eee491f6d774
Encrypted: xih/aPzn/I30tiUNTVH2AnBlSkhkazR3RHB1ZHErVEp1ZWswTU9CMmdpTkgyMGZ4SE1TODlneDZzWUlERyt6Y1Q0YVdES1ovd0xVU2VPaEJ3Y0hhSW5lYkM0bDh4dFJFS25nWmNBPT0=
Length: 140 characters
---

Setting: shipbubble_api_key
Original: sb_sandbox_806e4bccf9988a7d697a2e6d8a17451341b5eafa389ed26e5c1785b14af4247b
Encrypted: 0I2jX/wZQblrEoH1zCinZXZCcXRHQ3BHbFg0L2o2M0VsVlQzK1JyNHJiT1EzbUlwb1hRdGFXQTZCNTdzTSs3WEZ1Q2pGYjZwcGJhaDUzYit1dVIwMWZCTllrZmV0cjBWY1dUbnVhWGViUXBVbzVLSmIwcFlYMi9SWStVPQ==
Length: 168 characters
---

Setting: smtp_pass
Original: @BenjaminSEYI#123
Encrypted: yAhBsYu/PxN5i0+5xyT3FWJkVGlaTFRIalZsd1lYcHF5TDNiSEZlV0NZU2xpTWZNZU5jS1dnSmdxOFE9
Length: 80 characters
---

Setting: whmcs_api_key
Original: tkpwERG4mshL5T3nSAs3V8leFzX5ijku
Encrypted: yYNV56VTi298dFXA9h8inHVDTEFTZFdJQjFPeVE4S0hvQzAydWxxZHZxNTFPVEdpOGllcWJyYS9QaHdUcHhwUThIME9oQ0Y5M0pZMTFuRWU=
Length: 108 characters
---


Done! Copy the UPDATE statements above and run them in your MySQL database.