[javascript] DATABASE.JS
Viewer
*** This page was generated with the meta tag "noindex, nofollow". This happened because you selected this option before saving or the system detected it as spam. This means that this page will never get into the search engines and the search bot will not crawl it. There is nothing to worry about, you can still share it with anyone.
- const sqlite3 = require('sqlite3').verbose();
- const db = new sqlite3.Database('./fishing_game.db');
- db.serialize(() => {
- db.run(`CREATE TABLE IF NOT EXISTS users (
- username TEXT PRIMARY KEY,
- points INTEGER,
- rod INTEGER,
- last_fishing_attempt INTEGER
- )`);
- });
- function getUserData(username) {
- return new Promise((resolve, reject) => {
- db.get(`SELECT * FROM users WHERE username = ?`, [username], (err, row) => {
- if (err) {
- reject(err);
- } else {
- resolve(row);
- }
- });
- });
- }
- function setUserData(username, points, rod, lastFishingAttempt) {
- return new Promise((resolve, reject) => {
- db.run(`INSERT OR REPLACE INTO users (username, points, rod, last_fishing_attempt) VALUES (?, ?, ?, ?)`, [username, points, rod, lastFishingAttempt], (err) => {
- if (err) {
- reject(err);
- } else {
- resolve();
- }
- });
- });
- }
- function updatePointsAndRod(username, points, rod) {
- return new Promise((resolve, reject) => {
- db.run(`UPDATE users SET points = ?, rod = ? WHERE username = ?`, [points, rod, username], (err) => {
- if (err) {
- reject(err);
- } else {
- resolve();
- }
- });
- });
- }
- function updateLastFishingAttempt(username, lastFishingAttempt) {
- return new Promise((resolve, reject) => {
- db.run(`UPDATE users SET last_fishing_attempt = ? WHERE username = ?`, [lastFishingAttempt, username], (err) => {
- if (err) {
- reject(err);
- } else {
- resolve();
- }
- });
- });
- }
- module.exports = {
- getUserData,
- setUserData,
- updatePointsAndRod,
- updateLastFishingAttempt,
- };
Editor
You can edit this paste and save as new: