Working on a new gaming project involving MySQL for multiplayer functionality. Issue arises when requesting specific queries, where the system retrieves incorrect data or results from previous queries.
dat("SELECT * FROM server1;");
Misdirected queries returning unintended highscore table data instead of the requested server1 content.
dat("SELECT * FROM playernames;");
This auto-saving query function executes previously initialized queries each time it's used.
Attempted to resolve with online resources and Promise method but struggled due to unfamiliarity with handling Promises; resorting to async and await methods.
async function dat(Befehl) {
// Function code here
}
Expected response using the function
let x = await dat("SELECT * FROM server1;");
In theory:
Player1Cards = "Cards"
Player1CardsColour = "Colour";
Player2Cards = "Cards";
Player2CardsColour = "Colour";
Player1Name = "Name"
Player2Name = "Name"
However, actual result provides the highscore table data repeatedly until multiple function calls return correct data after 3-6 attempts.
Also included are additional functions utilizing the query:
// Other functions
Debugging function clearing all servers:
function AlleFreigeben()
{
// Code to clear servers
}
Login functionality integrated within the application:
async function prelogin()
{
// Login code here
}
User registration feature:
async function register()
{
// Registration logic
}
Initiating game start sequence:
async function UnoStartHM()
{
// Game initialization process
}
Unfortunately, certain functions like Abfrage() experience issues in contrast to manual MySQL query execution via console.
async function Abfrage()
{
// Query function struggling with database interaction
}