2 * 1024 * 1024) return null;
$info = @getimagesize($_FILES[$fileKey]['tmp_name']);
if ($info === false) return null;
$allowed = [
'image/jpeg' => 'jpg',
'image/png' => 'png',
'image/webp' => 'webp',
'image/gif' => 'gif'
];
$mime = $info['mime'] ?? '';
if (!isset($allowed[$mime])) return null;
$uploadDir = IMAGE_PATH . '/' . trim($subDir, '/') . '/';
if (!is_dir($uploadDir)) mkdir($uploadDir, 0755, true);
$filename = uniqid('img_', true) . '.' . $allowed[$mime];
$targetFile = $uploadDir . $filename;
if (!move_uploaded_file($_FILES[$fileKey]['tmp_name'], $targetFile)) return null;
return IMAGE_URL . '/' . trim($subDir, '/') . '/' . $filename;
}
function hasTable(PDO $db, string $table): bool {
try {
$stmt = $db->prepare("SHOW TABLES LIKE ?");
$stmt->execute([$table]);
return (bool)$stmt->fetchColumn();
} catch (Throwable $e) {
return false;
}
}
$hasCostsTable = hasTable($db, 'habit_item_costs');
if (($_SERVER['REQUEST_METHOD'] ?? '') === 'POST') {
$type = $_POST['type'] ?? '';
$id = (int)($_POST['id'] ?? 0);
try {
if ($type === 'habit' && $id > 0) {
$name = trim($_POST['name'] ?? '');
if ($name === '') throw new Exception("Habit name cannot be empty.");
$desc = trim($_POST['description'] ?? '');
$time = $_POST['time_of_day'] ?? 'morning';
$freq = $_POST['frequency'] ?? 'daily';
$xp = (int)($_POST['xp_reward'] ?? 25);
$cal = isset($_POST['show_on_calendar']) ? 1 : 0;
$newImage = safeImageUpload('image', 'habits');
$db->beginTransaction();
if ($newImage) {
$stmt = $db->prepare("UPDATE habits SET name=?, description=?, time_of_day=?, frequency=?, xp_reward=?, show_on_calendar=?, image_path=? WHERE id=?");
$stmt->execute([$name, $desc, $time, $freq, $xp, $cal, $newImage, $id]);
} else {
$stmt = $db->prepare("UPDATE habits SET name=?, description=?, time_of_day=?, frequency=?, xp_reward=?, show_on_calendar=? WHERE id=?");
$stmt->execute([$name, $desc, $time, $freq, $xp, $cal, $id]);
}
// Update costs only if table exists
if ($hasCostsTable) {
$stmt = $db->prepare("DELETE FROM habit_item_costs WHERE habit_id=?");
$stmt->execute([$id]);
$linkItemIds = $_POST['link_item_id'] ?? [];
$linkQtys = $_POST['link_item_qty'] ?? [];
if (is_array($linkItemIds) && count($linkItemIds) > 0) {
$ins = $db->prepare("INSERT INTO habit_item_costs (habit_id, item_id, qty) VALUES (?, ?, ?)");
foreach ($linkItemIds as $itemIdRaw) {
$itemId = (int)$itemIdRaw;
if ($itemId <= 0) continue;
$qty = (int)($linkQtys[$itemIdRaw] ?? 1);
if ($qty <= 0) $qty = 1;
$ins->execute([$id, $itemId, $qty]);
}
}
}
$db->commit();
$message = "Habit updated!";
}
if ($type === 'item' && $id > 0) {
$name = trim($_POST['name'] ?? '');
if ($name === '') throw new Exception("Item name cannot be empty.");
$subtitle = trim($_POST['subtitle'] ?? '');
$desc = trim($_POST['description'] ?? '');
$rarity = $_POST['rarity'] ?? 'common';
$stat = trim($_POST['stat_effect'] ?? '');
$qty = (int)($_POST['quantity'] ?? 0);
$newImage = safeImageUpload('image', 'items');
if ($newImage) {
$stmt = $db->prepare("UPDATE items SET name=?, subtitle=?, description=?, rarity=?, stat_effect=?, quantity=?, image_path=? WHERE id=?");
$stmt->execute([$name, $subtitle, $desc, $rarity, $stat, $qty, $newImage, $id]);
} else {
$stmt = $db->prepare("UPDATE items SET name=?, subtitle=?, description=?, rarity=?, stat_effect=?, quantity=? WHERE id=?");
$stmt->execute([$name, $subtitle, $desc, $rarity, $stat, $qty, $id]);
}
$message = "Item updated!";
}
if ($type === 'bounty' && $id > 0) {
$name = trim($_POST['name'] ?? '');
if ($name === '') throw new Exception("Bounty name cannot be empty.");
$desc = trim($_POST['description'] ?? '');
$xp = (int)($_POST['xp_reward'] ?? 100);
$completed = isset($_POST['completed']) ? 1 : 0;
$newImage = safeImageUpload('image', 'bounties');
if ($newImage) {
$stmt = $db->prepare("UPDATE bounties SET name=?, description=?, xp_reward=?, completed=?, image_path=? WHERE id=?");
$stmt->execute([$name, $desc, $xp, $completed, $newImage, $id]);
} else {
$stmt = $db->prepare("UPDATE bounties SET name=?, description=?, xp_reward=?, completed=? WHERE id=?");
$stmt->execute([$name, $desc, $xp, $completed, $id]);
}
if ($completed) {
$stmt = $db->prepare("UPDATE bounties SET completed_date = COALESCE(completed_date, CURDATE()) WHERE id=?");
$stmt->execute([$id]);
} else {
$stmt = $db->prepare("UPDATE bounties SET completed_date = NULL WHERE id=?");
$stmt->execute([$id]);
}
$message = "Bounty updated!";
}
} catch (Throwable $e) {
if ($db->inTransaction()) $db->rollBack();
$error = $e->getMessage();
}
}
// Load data safely
$habits = [];
$items = [];
$bounties = [];
$costMap = [];
try {
$habits = $db->query("SELECT * FROM habits ORDER BY created_at DESC")->fetchAll();
$items = $db->query("SELECT * FROM items ORDER BY name ASC")->fetchAll();
$bounties = $db->query("SELECT * FROM bounties ORDER BY created_at DESC")->fetchAll();
if ($hasCostsTable) {
$stmt = $db->query("SELECT habit_id, item_id, qty FROM habit_item_costs");
foreach ($stmt->fetchAll() as $row) {
$costMap[(int)$row['habit_id']][(int)$row['item_id']] = (int)$row['qty'];
}
}
} catch (Throwable $e) {
$error = $error ?: "Database error: " . $e->getMessage();
}
?>
Heads up: Table habit_item_costs is missing.
The editor will still work, but item consumption links wonβt show/save until you run the SQL migration.
π οΈ Edit Console
Edit Habits, Items, and Bounties β plus link habits to inventory costs.