API для RedAge V3

const serverIp = "IP:PORT"
    function getOnline() {
        return fetch('https://cdn.rage.mp/master/')
            .then((response) => response.json())
            .then((responseJson) => {
                setCurrentOnline(responseJson[serverIp].players)
            })
            .catch((error) => {
                console.error(error);
            });
    }

{
  "name": "redage-login-info-api",
  "version": "0.0.1",
  "main": "index.js",
  "scripts": {
    "test": "echo \"Error: no test specified\" && exit 1"
  },
  "keywords": [],
  "author": "ragemp.pro",
  "license": "ISC",
  "description": "",
  "dependencies": {
    "express": "^4.18.2",
    "mysql2": "^3.6.5"
  }
}

const express = require("express");
const db = require("./db");
const app = express();
const port = 3000;

app.use(express.json());

app.use(
    express.urlencoded({
        extended: true,
    })
);

app.get("/", (req, res) => {
    res.json({ message: "api is fine..." });
});

// GET /occupied?username=...
app.get("/occupied", async (req, res) => {
    try {
        const username = req.query.username;
        const results = await db.query("SELECT * FROM accounts WHERE login = ?", [username]);
        res.status(200).json({accounts: results.length});
    } catch (e) {
        res.status(500).json({error: e});
    }
})

app.listen(port, () => {
    console.log(`API listening at http://localhost:${port}`);
});

const mysql = require('mysql2/promise');

const dbConfig = {
    host: "host",
    user: "user",
    password: "pass",
    database: "database",
    connectTimeout: 60000
}

let connection;

async function query(sql, params) {
    if (!connection || connection.state === 'disconnected') {
        connection = await mysql.createConnection(dbConfig);
    }
    const [results, ] = await connection.execute(sql, params);
    return results;
}

module.exports = {
    query
}