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

router.get("/", async (req, res) => {
  const userId = 1;

  const avatar = await db.query(
    `
SELECT
avatar_equipment.slot,
items.icon
FROM avatar_equipment
JOIN items ON items.id=avatar_equipment.item_id
WHERE avatar_equipment.user_id=?
`,
    [userId],
  );

  res.json(avatar);
});

module.exports = router;