WebOrbiton
v1.0.0.6

Publisium

19 lines · 680 B
  1. <?php
  2. ​
  3. declare(strict_types=1);
  4. ​
  5. if (!Auth::hasRoleAtLeast(Auth::ROLE_EDITOR_IN_CHIEF)) {
  6. return;
  7. }
  8. ​
  9. $db = Database::site();
  10. ​
  11. $columnsJson = FooterLinks::sanitizeColumns((string) ($_POST['footer_columns_json'] ?? '[]'));
  12. $socialJson = FooterLinks::sanitizeSocialLinks((string) ($_POST['footer_social_json'] ?? '[]'));
  13. ​
  14. $upsert = $db->prepare(
  15. 'INSERT INTO site_settings (setting_key, setting_value) VALUES (:key, :value) ON DUPLICATE KEY UPDATE setting_value = :value2'
  16. );
  17. $upsert->execute(['key' => 'footer_columns', 'value' => $columnsJson, 'value2' => $columnsJson]);
  18. $upsert->execute(['key' => 'footer_social_links', 'value' => $socialJson, 'value2' => $socialJson]);
  19. ​