const express = require("express");
const router = express.Router();
const db = require("../database/database");
const auth = require("../middleware/auth");

router.get("/", auth, async (req, res) => {
  const userId = req.session.user.id;

  try {
    const [rows] = await db.query(
      `
SELECT
ae.slot,
ae.item_id,
ae.item_level_id,
items.icon,
item_levels.level AS item_level
FROM avatar_equipment ae
LEFT JOIN items ON items.id = ae.item_id
LEFT JOIN item_levels ON item_levels.id = ae.item_level_id
WHERE ae.user_id=?
`,
      [userId],
    );

    res.json(rows);
  } catch (err) {
    console.error("Equipment Fehler:", err);
    res.status(500).json({ error: "DB Fehler" });
  }
});

module.exports = router;