[ 'page_title' => 'Διαχείριση Κειμένων & Logo - Hockey CMS', 'header_title' => '✏️ Διαχείριση Στατικών Κειμένων & Logo', 'logo_title' => '🖼️ Λογότυπο Site (Logo)', 'btn_logo' => '📤 Ανέβασμα & Αποθήκευση Logo', 'texts_title' => '📝 Δίγλωσσα Στατικά Λεκτικά', 'texts_desc' => 'Συμπληρώστε τα κείμενα και για τις δύο γλώσσες.', 'th_key' => 'Κλειδί / Περιγραφή', 'th_gr' => '🇬🇷 Ελληνικά (Greek)', 'th_en' => '🇬🇧 Αγγλικά (English)', 'btn_save' => '💾 Αποθήκευση Γλωσσών', 'msg_texts_ok' => 'Όλα τα δίγλωσσα κείμενα ενημερώθηκαν επιτυχώς!', 'msg_logo_ok' => 'Το λογότυπο ανέβηκε επιτυχώς!', 'msg_err_type' => 'Μη επιτρεπτός τύπος αρχείου.', 'msg_err_sql' => 'Προσοχή: Δεν βρέθηκαν τα πεδία. Τρέξατε το SQL query;', 'no_texts' => 'Δεν βρέθηκαν κείμενα στη βάση.' ], 'en' => [ 'page_title' => 'Texts & Logo Management - Hockey CMS', 'header_title' => '✏️ Static Texts & Logo Management', 'logo_title' => '🖼️ Site Logo', 'btn_logo' => '📤 Upload & Save Logo', 'texts_title' => '📝 Bilingual Static Texts', 'texts_desc' => 'Fill in the texts for both languages.', 'th_key' => 'Key / Description', 'th_gr' => '🇬🇷 Greek', 'th_en' => '🇬🇧 English', 'btn_save' => '💾 Save Languages', 'msg_texts_ok' => 'All bilingual texts updated successfully!', 'msg_logo_ok' => 'Logo uploaded successfully!', 'msg_err_type' => 'Invalid file type.', 'msg_err_sql' => 'Warning: Fields not found. Did you run the SQL query?', 'no_texts' => 'No texts found in database.' ] ]; $t = $translations[$current_lang]; header('Content-Type: text/html; charset=utf-8'); $message = ''; if ($_SERVER['REQUEST_METHOD'] === 'POST' && isset($_POST['update_texts'])) { try { $pdo->beginTransaction(); $stmt = $pdo->prepare("UPDATE site_texts SET text_value_el = ?, text_value_en = ? WHERE text_key = ?"); if (isset($_POST['texts_el']) && is_array($_POST['texts_el'])) { foreach ($_POST['texts_el'] as $key => $val_el) { $val_en = isset($_POST['texts_en'][$key]) ? $_POST['texts_en'][$key] : ''; $stmt->execute([trim($val_el), trim($val_en), $key]); } } $pdo->commit(); $message = "
{$t['msg_texts_ok']}
"; } catch (Exception $e) { $pdo->rollBack(); $message = "
Σφάλμα: " . $e->getMessage() . "
"; } } if ($_SERVER['REQUEST_METHOD'] === 'POST' && isset($_POST['upload_logo'])) { if (isset($_FILES['logo_file']) && $_FILES['logo_file']['error'] === UPLOAD_ERR_OK) { $upload_dir = __DIR__ . '/../uploads/'; if (!is_dir($upload_dir)) { @mkdir($upload_dir, 0755, true); } $file_extension = strtolower(pathinfo($_FILES['logo_file']['name'], PATHINFO_EXTENSION)); $allowed_extensions = ['jpg', 'jpeg', 'png', 'gif', 'webp', 'svg']; if (in_array($file_extension, $allowed_extensions)) { $filename = 'logo_' . time() . '.' . $file_extension; $target_path = $upload_dir . $filename; if (move_uploaded_file($_FILES['logo_file']['tmp_name'], $target_path)) { $logo_url = 'uploads/' . $filename; try { $stmtCheck = $pdo->prepare("SELECT COUNT(*) FROM settings WHERE `key` = 'site_logo'"); $stmtCheck->execute(); if ($stmtCheck->fetchColumn() > 0) { $stmtUpd = $pdo->prepare("UPDATE settings SET value = ? WHERE `key` = 'site_logo'"); $stmtUpd->execute([$logo_url]); } else { $stmtIns = $pdo->prepare("INSERT INTO settings (`key`, value) VALUES ('site_logo', ?)"); $stmtIns->execute([$logo_url]); } $message = "
{$t['msg_logo_ok']}
"; } catch (Exception $e) { $message = "
Σφάλμα: " . $e->getMessage() . "
"; } } } else { $message = "
{$t['msg_err_type']}
"; } } } $current_logo = ''; try { $logoStmt = $pdo->prepare("SELECT value FROM settings WHERE `key` = 'site_logo'"); $logoStmt->execute(); $current_logo = $logoStmt->fetchColumn(); } catch (Exception $e) {} $texts = []; try { $texts = $pdo->query("SELECT * FROM site_texts ORDER BY description ASC")->fetchAll(PDO::FETCH_ASSOC); } catch (Exception $e) { $message = "
{$t['msg_err_sql']}
"; } ?> <?php echo $t['page_title']; ?>

"; echo ""; echo ""; echo ""; echo ""; } } else { echo ""; } ?>
" . htmlspecialchars($text_row['text_key']) . "" . htmlspecialchars($text_row['description']) . ""; echo "GR"; echo ""; echo ""; echo "EN"; echo ""; echo "
{$t['no_texts']}