2023-10-23 21:28:39 -06:00
|
|
|
const express = require("express");
|
2023-11-12 16:07:50 -07:00
|
|
|
const bodyParser = require('body-parser');
|
2023-10-23 21:28:39 -06:00
|
|
|
const mysql = require("mysql");
|
|
|
|
const fs = require("fs");
|
|
|
|
const yaml = require("js-yaml");
|
2024-06-30 22:29:52 -06:00
|
|
|
const multer = require("multer");
|
|
|
|
const path = require("path");
|
|
|
|
const os = require("os");
|
2023-10-23 21:28:39 -06:00
|
|
|
|
|
|
|
const app = express();
|
|
|
|
const port = 3000;
|
|
|
|
|
|
|
|
// Read database configuration from config.yaml
|
2023-11-12 16:07:50 -07:00
|
|
|
const config = yaml.load(fs.readFileSync("config.yaml", "utf8"));
|
2023-10-23 21:28:39 -06:00
|
|
|
|
2023-11-12 16:07:50 -07:00
|
|
|
const db = mysql.createConnection(config.database);
|
2023-10-23 21:28:39 -06:00
|
|
|
|
|
|
|
db.connect((err) => {
|
|
|
|
if (err) {
|
|
|
|
console.error("Database connection failed: " + err.stack);
|
|
|
|
return;
|
|
|
|
}
|
|
|
|
console.log("Connected to the database");
|
|
|
|
});
|
|
|
|
|
2023-11-12 16:07:50 -07:00
|
|
|
// Middleware for authentication
|
|
|
|
const authenticate = (req, res, next) => {
|
|
|
|
const providedPassword = req.headers.authorization;
|
|
|
|
|
|
|
|
if (providedPassword === config.app.password) {
|
|
|
|
next();
|
|
|
|
} else {
|
|
|
|
res.status(401).json({ error: 'Unauthorized' });
|
|
|
|
}
|
|
|
|
};
|
|
|
|
|
2024-06-30 22:29:52 -06:00
|
|
|
// Set up multer for file uploads
|
|
|
|
const storage = multer.diskStorage({
|
|
|
|
destination: (req, file, cb) => {
|
|
|
|
const gameId = req.params.id;
|
|
|
|
const homeDir = os.homedir();
|
|
|
|
const dir = path.join(homeDir, 'game-images', gameId);
|
|
|
|
if (!fs.existsSync(dir)){
|
|
|
|
fs.mkdirSync(dir, { recursive: true });
|
|
|
|
}
|
|
|
|
cb(null, dir);
|
|
|
|
},
|
|
|
|
filename: (req, file, cb) => {
|
|
|
|
const gameId = req.params.id;
|
|
|
|
cb(null, gameId); // Save the file with the ID as its name, without extension
|
|
|
|
}
|
|
|
|
});
|
|
|
|
|
|
|
|
const upload = multer({ storage });
|
|
|
|
|
2023-10-23 21:28:39 -06:00
|
|
|
// Serve static files (HTML, CSS, JavaScript)
|
|
|
|
app.use(express.static("public"));
|
|
|
|
|
2024-06-30 22:29:52 -06:00
|
|
|
// JSON data parser
|
2023-11-12 16:07:50 -07:00
|
|
|
app.use(bodyParser.json());
|
|
|
|
|
2023-10-23 21:28:39 -06:00
|
|
|
// Define a route to retrieve game data
|
|
|
|
app.get("/games", (req, res) => {
|
|
|
|
const sql = "SELECT * FROM games";
|
|
|
|
db.query(sql, (err, results) => {
|
|
|
|
if (err) {
|
|
|
|
console.error("Error fetching game data: " + err);
|
|
|
|
res.status(500).send("Internal Server Error");
|
|
|
|
return;
|
|
|
|
}
|
|
|
|
|
|
|
|
res.setHeader("Content-Type", "application/json");
|
|
|
|
res.json(results);
|
|
|
|
});
|
|
|
|
});
|
|
|
|
|
2023-11-12 16:07:50 -07:00
|
|
|
// Endpoint to add a game
|
|
|
|
app.post('/add-game', authenticate, (req, res) => {
|
|
|
|
const { name, publishedLink, year, state, education, level, place, name1, name2 } = req.body;
|
|
|
|
|
|
|
|
// SQL query to insert data into the games table
|
|
|
|
const sql = `
|
|
|
|
INSERT INTO games (name, publishedLink, year, state, education, level, place, name1, name2)
|
|
|
|
VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)
|
|
|
|
`;
|
|
|
|
|
|
|
|
// Array of values to be inserted into the query
|
|
|
|
const values = [name, publishedLink, year, state, education, level, place, name1, name2];
|
|
|
|
|
|
|
|
// Execute the SQL query
|
|
|
|
db.query(sql, values, (error, results) => {
|
|
|
|
if (error) {
|
|
|
|
console.error('Error executing SQL query:', error);
|
|
|
|
res.status(500).json({ error: 'Internal Server Error' });
|
|
|
|
} else {
|
|
|
|
console.log('Data inserted into the games table:', results);
|
2024-06-30 22:29:52 -06:00
|
|
|
res.json({ message: 'Game added successfully!', gameId: results.insertId });
|
2023-11-12 16:07:50 -07:00
|
|
|
}
|
|
|
|
});
|
|
|
|
});
|
|
|
|
|
2024-06-30 22:29:52 -06:00
|
|
|
// Endpoint to upload an image for a game
|
|
|
|
app.post('/upload-image/:id', authenticate, upload.single('gameImage'), (req, res) => {
|
|
|
|
res.json({ message: 'Image uploaded successfully!' });
|
|
|
|
});
|
|
|
|
|
2023-10-23 21:28:39 -06:00
|
|
|
app.listen(port, () => {
|
|
|
|
console.log(`Server is running on port ${port}`);
|
|
|
|
});
|