query("SELECT id, name FROM champions ORDER BY name ASC");
$champions = $champStmt->fetchAll();
// Handle form submission
if ($_SERVER['REQUEST_METHOD'] === 'POST') {
$title = $_POST['title'];
$subtitle = $_POST['subtitle'];
$rarity = $_POST['rarity'] ?? 'none';
$category = $_POST['category'] ?? 'misc';
$champion_id = !empty($_POST['champion_id']) ? intval($_POST['champion_id']) : null;
$quantity = !empty($_POST['quantity']) ? intval($_POST['quantity']) : null;
$quantity_max = !empty($_POST['quantity_max']) ? intval($_POST['quantity_max']) : null;
// Stats JSON
$stats_json = "{}";
if (!empty($_POST['stat_key']) && !empty($_POST['stat_value'])) {
$stats = [];
foreach ($_POST['stat_key'] as $i => $key) {
$key = trim($key);
$value = trim($_POST['stat_value'][$i]);
if ($key !== "" && $value !== "") {
$stats[$key] = $value;
}
}
$stats_json = json_encode($stats);
}
// Handle image upload
$image_path = null;
if (!empty($_FILES['image']['name'])) {
$uploadDir = ITEM_IMAGES_PATH;
if (!is_dir($uploadDir)) {
mkdir($uploadDir, 0777, true);
}
$filename = time() . "_" . basename($_FILES['image']['name']);
$targetPath = $uploadDir . $filename;
if (move_uploaded_file($_FILES['image']['tmp_name'], $targetPath)) {
$image_path = "assets/images/items/" . $filename;
}
}
// Insert item
$stmt = $pdo->prepare("
INSERT INTO items
(title, subtitle, image_path, rarity, category, champion_id, quantity, quantity_max, stats_json)
VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)
");
$stmt->execute([
$title,
$subtitle,
$image_path,
$rarity,
$category,
$champion_id,
$quantity,
$quantity_max,
$stats_json
]);
$message = "Item successfully added!";
}
?>
Add Item