getVillage($id); /* --------------------------------------------------------------------------- * Update a1-a8 / b1-b8 * --------------------------------------------------------------------------- */ $fields = []; for ($i = 1; $i <= 8; $i++) { $a = (int)($_POST['a' . $i] ?? 0); $b = (int)($_POST['b' . $i] ?? 0); $fields[] = "a$i = $a"; $fields[] = "b$i = $b"; } $q = "UPDATE " . TB_PREFIX . "abdata SET " . implode(", ", $fields) . " WHERE vref = $id"; $database->query($q); /* --------------------------------------------------------------------------- * Log admin - adaptat pentru structura ta: * CREATE TABLE `s1_admin_log` (`id` int, `user` text, `log` text, `time` int) * --------------------------------------------------------------------------- */ $adminId = (string)(int)$_SESSION['id']; $time = time(); // FIX: luăm numele satului $village = $database->getVillage($id); // dacă nu-l ai deja sus, lasă linia asta $villageName = $village['name'] ?? 'Village'; $villageNameSafe = htmlspecialchars($villageName, ENT_QUOTES, 'UTF-8'); $logText = "Changed troop upgrade levels in village $villageNameSafe"; // escapăm corect pentru coloana TEXT $adminIdEsc = $database->escape($adminId); $logEsc = $database->escape($logText); $database->query( "INSERT INTO " . TB_PREFIX . "admin_log (`id`, `user`, `log`, `time`) " . "VALUES (0, '$adminIdEsc', '$logEsc', $time)" ); header("Location: ../../../Admin/admin.php?p=village&did=" . $id . "&ab"); exit; ?>