// ~/cirvol-api/index.js
require('dotenv').config();
const express = require('express');
const mysql = require('mysql2');
const cors = require('cors');
const path = require('path');

const app = express();
app.use(cors());
app.use(express.json());

// Serve the 'public' folder for your index.html
app.use(express.static(path.join(__dirname, 'public')));

// Database Connection
const db = mysql.createConnection({
    host: 'localhost',
    user: process.env.DB_USER,
    password: process.env.DB_PASSWORD,
    database: process.env.DB_NAME
});

db.connect(err => {
    if (err) return console.error('❌ Database error:', err.message);
    console.log('✅ Connected to MySQL');
});

// Basic API Route
app.get('/api/status', (req, res) => {
    res.json({ status: "Online", node: "vpsnode2", timestamp: new Date() });
});

const PORT = 3000;
app.listen(PORT, () => console.log(`🚀 API live on port ${PORT}`));