query("
SELECT id, title, quantity, quantity_max
FROM items
ORDER BY title ASC
");
$items = $itemStmt->fetchAll();
// Handle form submission
if ($_SERVER['REQUEST_METHOD'] === 'POST') {
$title = $_POST['title'];
$description = $_POST['description'];
$frequency = $_POST['frequency'];
$specific_date = !empty($_POST['specific_date']) ? $_POST['specific_date'] : null;
$show_on_calendar = isset($_POST['show_on_calendar']) ? 1 : 0;
$is_bounty = isset($_POST['is_bounty']) ? 1 : 0;
$xp_reward = !empty($_POST['xp_reward']) ? intval($_POST['xp_reward']) : 10;
// Inventory tab assignment
$tab = $_POST['tab'] ?? 'misc';
// Optional linked item
$linked_item_id = !empty($_POST['linked_item_id']) ? intval($_POST['linked_item_id']) : null;
$consume_amount = !empty($_POST['consume_amount']) ? intval($_POST['consume_amount']) : null;
// Handle image upload
$image_path = null;
if (!empty($_FILES['image']['name'])) {
$uploadDir = HABIT_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/habits/" . $filename;
}
}
// Insert habit
$stmt = $pdo->prepare("
INSERT INTO habits
(title, description, image_path, frequency, specific_date, show_on_calendar, is_bounty, xp_reward, tab, linked_item_id, consume_amount)
VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
");
$stmt->execute([
$title,
$description,
$image_path,
$frequency,
$specific_date,
$show_on_calendar,
$is_bounty,
$xp_reward,
$tab,
$linked_item_id,
$consume_amount
]);
$message = "Habit/Bounty successfully created!";
}
?>
Create Habit