========================================
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 = 'FPMV4g4s8fPFEgWGWLKv11dLc0UzK1ZuNzR3WkdEMTZDT1NaYjJBRWhHVE5tMThFbmErc1BWbmRoSXE2dUtsQjEwbjd5UCttT3lYUEZIQ3Z1cDVGdVdkSnRxV2ZqbVViejJnZXd3PT0=' WHERE setting_key = 'paystack_secret_key';
UPDATE site_settings SET setting_value = 'HMJv7cpNx12p0Xm0VIj55jFwOGpGTzZFaEFIaDZ6N0RQbXJXMWxYcld3VmNPREs1WmQ2MG1YU2pGLzZ3OENiaXUrYmE1OXlOeld5dW9STUpEbTdWMUNYb1J0T3VWa3JIUmdmTEh3PT0=' WHERE setting_key = 'paystack_public_key';
UPDATE site_settings SET setting_value = 'Tm2FxEyw6vUVhKUxzCxsZGlrYUsvaUJXTEpzaTBHZEJWeWlQWEt0cW1OejdyRk1SM3RDbGdveU1TSEZydlBiQ2ZlcFYzenV6ek9yb1BCaytIbHVhOFlUdVc0TklQbko1aVNwNDJVejRNcWZhMnFXclpIencyL3dPVms4PQ==' WHERE setting_key = 'shipbubble_api_key';
UPDATE site_settings SET setting_value = '9tqGYMo09+BF8lBFoYmeKU5WaHo1d1BuNjNlMitEekdOQVpDVVBSVzVGemt5Mm1ndlE5ZFhxeDIzSVk9' WHERE setting_key = 'smtp_pass';
UPDATE site_settings SET setting_value = 'fIBZ8xw49VMMqTR/6QHjolJHU3FCWUtXWHZvSWF1cWs3QzFWZnFySUdWTVlwYWVjRVFIUm9JUnlmS1JhVmVpaStoVnRlbGxsekNsaFhEYlI=' 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: tSIQZfFp6IrEKvokRMSYrERjamhDTURYdW16akNRbkt5WmkwdW5LdlNtcEJibFZ0R1hyRUNsQWdVWnR0VHd3MTB4cFhtRVZsSEJVbTFoekdWVTRlUG5ybmNmYXU0Y3d4aW11YXpBPT0=
Length: 140 characters
---

Setting: paystack_public_key
Original: pk_test_6699c7875928efa22d3a987c1a73eee491f6d774
Encrypted: rwKu9xlXhtnUrIxi68oPf0pYT2RZakNNMHNtZkN3dU9JbzlPajdKUXovOUhDa3ljT2JXcW5JN3VjQmVmUnkzVDVUQ2NMeDNZdU1EUnkzT0tmeHV0aXdSU1VLMDA3RW90MWZNMmZBPT0=
Length: 140 characters
---

Setting: shipbubble_api_key
Original: sb_sandbox_806e4bccf9988a7d697a2e6d8a17451341b5eafa389ed26e5c1785b14af4247b
Encrypted: 9Pu/lS07L6xp609xSjwubDBseGRSalVIQjBaZ3pyc3hTUmpUcjZRcHNWNU1OWGI5ajhrVXJXKzg5UkRXSnhSeTVwbjh3NWY0L0orbFgzOFZuMXpjRmNlREpzdUJtUDZHZUxkQXl5SWM2dFErVDB1clFNR2thNkNpcnJJPQ==
Length: 168 characters
---

Setting: smtp_pass
Original: @BenjaminSEYI#123
Encrypted: /AmgCdMSwLq0v3G+vF+Szko3RGpvajF1c0U3Q1ZIUGdtdzByYkZzV3VpNWpmSHNlK0orOEhrYXdmQ289
Length: 80 characters
---

Setting: whmcs_api_key
Original: tkpwERG4mshL5T3nSAs3V8leFzX5ijku
Encrypted: 00AglMH199OnxydrvzHs5UVxdndaOXhhTzZnSDcwT0tyaFFnWUdQdHdxMXVsMHBDS2w2eXFvV0lybXJiRWdNUjdERDYydTRGR0RoS00zc0s=
Length: 108 characters
---


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