WebOrbiton
v3.0.0.2

FlatlyPage

← Changes All versions
138 lines · 4.2 KB
  1. <?php
  2. if (!file_exists('config.php')) {
  3. header('Location: newsletter-unavailable.php');
  4. exit;
  5. }
  7. require_once 'config.php';
  9. $token = $_GET['token'] ?? '';
  11. if (empty($token)) {
  12. showMessage('Error', 'Invalid confirmation link', 'error');
  13. }
  15. $pdo = getDB();
  16. if (!$pdo) {
  17. showMessage('Error', 'Server problem. Please try again later.', 'error');
  18. }
  20. try {
  21. $stmt = $pdo->prepare("
  22. UPDATE newsletter_subscribers
  23. SET confirmed = 1, confirmed_at = NOW()
  24. WHERE token = ? AND confirmed = 0
  25. ");
  27. $stmt->execute([$token]);
  29. if ($stmt->rowCount() > 0) {
  30. showMessage(
  31. 'Success!',
  32. 'Your newsletter subscription has been confirmed. Thank you!',
  33. 'success'
  34. );
  35. } else {
  36. $stmt = $pdo->prepare("SELECT confirmed FROM newsletter_subscribers WHERE token = ?");
  37. $stmt->execute([$token]);
  38. $result = $stmt->fetch();
  40. if ($result && $result['confirmed']) {
  41. showMessage(
  42. 'Info',
  43. 'This subscription has already been confirmed.',
  44. 'info'
  45. );
  46. } else {
  47. showMessage(
  48. 'Error',
  49. 'Invalid or expired confirmation link.',
  50. 'error'
  51. );
  52. }
  53. }
  55. } catch (PDOException $e) {
  56. error_log("Confirmation error: " . $e->getMessage());
  57. showMessage('Error', 'An error occurred. Please try again later.', 'error');
  58. }
  60. function showMessage($title, $message, $type) {
  61. $colors = [
  62. 'success' => ['bg' => '#d4edda', 'border' => '#c3e6cb', 'text' => '#155724'],
  63. 'error' => ['bg' => '#f8d7da', 'border' => '#f5c6cb', 'text' => '#721c24'],
  64. 'info' => ['bg' => '#d1ecf1', 'border' => '#bee5eb', 'text' => '#0c5460']
  65. ];
  67. $color = $colors[$type] ?? $colors['info'];
  68. ?>
  69. <!DOCTYPE html>
  70. <html lang="en">
  71. <head>
  72. <meta charset="UTF-8">
  73. <meta name="viewport" content="width=device-width, initial-scale=1.0">
  74. <link rel="icon" href="nl.ico?v=<?= filemtime(__DIR__ . '/newsletter/nl.ico') ?>" type="image/x-icon">
  75. <title><?= htmlspecialchars($title) ?></title>
  76. <style>
  77. * { margin: 0; padding: 0; box-sizing: border-box; }
  78. body {
  79. font-family: -apple-system, BlinkMacSystemFont, 'Segoe UI', Roboto, sans-serif;
  80. background: #f5f5f5;
  81. display: flex;
  82. align-items: center;
  83. justify-content: center;
  84. min-height: 100vh;
  85. padding: 20px;
  86. }
  87. .message-box {
  88. background: white;
  89. border-radius: 8px;
  90. box-shadow: 0 2px 10px rgba(0,0,0,0.1);
  91. max-width: 500px;
  92. width: 100%;
  93. overflow: hidden;
  94. }
  95. .message-header {
  96. background: <?= $color['bg'] ?>;
  97. border-bottom: 2px solid <?= $color['border'] ?>;
  98. color: <?= $color['text'] ?>;
  99. padding: 20px;
  100. text-align: center;
  101. }
  102. .message-content {
  103. padding: 30px;
  104. text-align: center;
  105. color: #333;
  106. line-height: 1.6;
  107. }
  108. .btn {
  109. display: inline-block;
  110. margin-top: 20px;
  111. padding: 12px 30px;
  112. background: #007bff;
  113. color: white;
  114. text-decoration: none;
  115. border-radius: 5px;
  116. transition: background 0.3s;
  117. }
  118. .btn:hover {
  119. background: #0056b3;
  120. }
  121. </style>
  122. </head>
  123. <body>
  124. <div class="message-box">
  125. <div class="message-header">
  126. <h1><?= htmlspecialchars($title) ?></h1>
  127. </div>
  128. <div class="message-content">
  129. <p><?= htmlspecialchars($message) ?></p>
  130. <a href="<?= SITE_URL ?>" class="btn">Back to homepage</a>
  131. </div>
  132. </div>
  133. </body>
  134. </html>
  135. <?php
  136. exit;
  137. }
  138. ?>