Проблема DB.Query is not defined

[jrius]

• Всем привет, я только начал свой путь в RAGE MP.
  Появилась проблема с вызовом функции DB.query в других модулях.
  
  1. Events.js (Где и находится само подключение)

• let spawnPoints = require('./json-packet/spawn_points.json').SpawnPoints;
  
  mp.events.add('playerDeath', (player) => {
      player.spawn(spawnPoints[Math.floor(Math.random() * spawnPoints.length)]);
      player.health = 100;
  });
  
  
  mp.events.add('playerJoin', (player) => {
      
  
      player.call('showLoginDialog');
  });
  
  mp.events.add("playerQuit", (player) => {
      
  });
  
  
  const mysql = require('mysql');
  
  var DB = mysql.createConnection(
  {
      host: 'localhost',
      user: 'root',
      password: '',
      database: 'main_server'
  });
  
  
  mp.events.add('packagesLoaded', () => {
  
     DB.connect(function(err){
         if(err) {
              console.error(`mysql connected failed.`);
              return;
         }
         console.log('mysql connected successfully.');
     });
  });
  
  
  
  mp.events.add('onRegisterAttempt', (player, data) => {
      data = JSON.parse(data);
  
      DB.query('SELECT id FROM `accounts` WHERE `social_id` = ?', [player.rgscId], function (error, results) {  // Проверяем уникальность логина
          if(results.length > 0) return player.call('showAuthError', ['Аккаунт с таким SocialID уже существует']); // Если такой логин уже есть, то возвращаем ошибку
  
          DB.query('INSERT INTO `accounts`(`social_id`, `login`, `password`) VALUES (?,?,?)', [player.rgscId, data.login, data.password], function (error, results) { // Добавляем аккаунт в базу данных
              
          });
  
          DB.query('SELECT `admin_lvl`, `cash` FROM `accounts` WHERE `social_id` = ?', [player.rgscId], function (error, results)
          {
              if(!results.length)
              {
                  player.kick(player);
                  return;
              }
  
              player.admin = results[0].admin_lvl;
              player.cash =  results[0].cash;
  
              player.call('hideLoginDialog');
              player.call('showPlayerHud', [player.cash, player.rgscId, player.id]);
          });
      
      });
  
  });
  
  
  
  mp.events.add('onLoginAttempt', (player, data) => {
      data = JSON.parse(data);
  
      DB.query('SELECT * FROM accounts WHERE login = ? LIMIT 1', [data.login], function (error, results) {
          if(!results.length) return player.call('showAuthError', ['Введите правильный логин или пароль.']);
  
          if (results[0].password === data.password)
          {   
              player.admin = results[0].admin_lvl;
              player.cash =  results[0].cash;
  
              player.call('hideLoginDialog');
              player.call('showPlayerHud', [player.cash, player.rgscId, player.id]);
              return;
          }
          else player.call('showAuthError', ['Неверный Логин или Пароль']);
          
      });
  });

  
  папка с кмд (./command/index.js)
  
  
  

  const MAX_LVL_ADMIN = 5;
  
  mp.events.addCommand('makeadmin', (player, _, id, lvl) => {
      if (player.admin < MAX_LVL_ADMIN) return;
  
      if (id == undefined || lvl == undefined) return player.outputChatBox('/makeadmin [id] [lvl]'); 
      if (lvl < 0 || lvl > MAX_LVL_ADMIN) return player.outputChatBox('/makeadmin [id] [lvl]');
  
      let target = mp.players.at(id);
  
      if (target.id == player.id) return player.outputChatBox('/makeadmin [id] [lvl]'); 
  
      target.admin = lvl;
  
      if (lvl != 0)
      {   
          player.outputChatBox(`Вы успешно выдали админку игроку: ${target.name} (Выдан лвл: ${lvl})`);
          target.outputChatBox(`Вам выдали админ права: ${lvl} lvl (Выдал: ${player.name})`);
      }
      else
      {
          player.outputChatBox(`Вы успешно сняли администратор: ${target.name}`);
          target.outputChatBox(`Вы были сняты с поста администратора! Снял: ${player.name}`);
      }
      
      DB.query('UPDATE `accounts` SET `admin_lvl` = ? WHERE `social_id` = ?', [target.admin, target.rgscId]);
      return 1;
  });

  
  смотрел на данном форуме решение проблемы, но ничего не нашел, пытался создать отдельную функцию
  

  function query(sql)
  {
      DB.query(`${sql}`);
  }

  
  но всё равно ничего не помогало, пакеты с mysql установлены, сервер полностью работает.

 

[Jerry (ChatGPT)]

It seems like the issue is that the DB object is not being recognized in the ./command/index.js file where you are attempting to use DB.query. One way to solve this would be to pass the DB object to the module where you have the command handling logic.

For example, you can modify your ./command/index.js file to accept the DB object as a parameter:

module.exports = (DB) => {
    const MAX_LVL_ADMIN = 5;

    mp.events.addCommand('makeadmin', (player, _, id, lvl) => {
        if (player.admin < MAX_LVL_ADMIN) return;

        if (id == undefined || lvl == undefined) return player.outputChatBox('/makeadmin [id] [lvl]');
        if (lvl < 0 || lvl > MAX_LVL_ADMIN) return player.outputChatBox('/makeadmin [id] [lvl]');

        let target = mp.players.at(id);

        if (target.id == player.id) return player.outputChatBox('/makeadmin [id] [lvl]');

        target.admin = lvl;

        if (lvl != 0)
        {   
            player.outputChatBox(`Вы успешно выдали админку игроку: ${target.name} (Выдан лвл: ${lvl})`);
            target.outputChatBox(`Вам выдали админ права: ${lvl} lvl (Выдал: ${player.name})`);
        }
        else
        {
            player.outputChatBox(`Вы успешно сняли администратор: ${target.name}`);
            target.outputChatBox(`Вы были сняты с поста администратора! Снял: ${player.name}`);
        }

        DB.query('UPDATE `accounts` SET `admin_lvl` = ? WHERE `social_id` = ?', [target.admin, target.rgscId]);
        return 1;
    });
};

Then, in your Events.js file, where you're including the command handling logic, you can pass the DB object to the module:

let spawnPoints = require('./json-packet/spawn_points.json').SpawnPoints;
const commandHandler = require('./command/index')(DB);

// Rest of your Events.js file

This way, the DB object will be accessible in the ./command/index.js file and you should be able to use DB.query within the command logic.

 

[jrius]

Ошибка (дополняю) -

 

[jrius]

It seems like the issue is that the DB object is not being recognized in the ./command/index.js file where you are attempting to use DB.query. One way to solve this would be to pass the DB object to the module where you have the command handling logic.

For example, you can modify your ./command/index.js file to accept the DB object as a parameter:

module.exports = (DB) => {
    const MAX_LVL_ADMIN = 5;

    mp.events.addCommand('makeadmin', (player, _, id, lvl) => {
        if (player.admin < MAX_LVL_ADMIN) return;

        if (id == undefined || lvl == undefined) return player.outputChatBox('/makeadmin [id] [lvl]');
        if (lvl < 0 || lvl > MAX_LVL_ADMIN) return player.outputChatBox('/makeadmin [id] [lvl]');

        let target = mp.players.at(id);

        if (target.id == player.id) return player.outputChatBox('/makeadmin [id] [lvl]');

        target.admin = lvl;

        if (lvl != 0)
        {  
            player.outputChatBox(`Вы успешно выдали админку игроку: ${target.name} (Выдан лвл: ${lvl})`);
            target.outputChatBox(`Вам выдали админ права: ${lvl} lvl (Выдал: ${player.name})`);
        }
        else
        {
            player.outputChatBox(`Вы успешно сняли администратор: ${target.name}`);
            target.outputChatBox(`Вы были сняты с поста администратора! Снял: ${player.name}`);
        }

        DB.query('UPDATE `accounts` SET `admin_lvl` = ? WHERE `social_id` = ?', [target.admin, target.rgscId]);
        return 1;
    });
};

Then, in your Events.js file, where you're including the command handling logic, you can pass the DB object to the module:

let spawnPoints = require('./json-packet/spawn_points.json').SpawnPoints;
const commandHandler = require('./command/index')(DB);

// Rest of your Events.js file

This way, the DB object will be accessible in the ./command/index.js file and you should be able to use DB.query within the command logic.

1. Events.js

let spawnPoints = require('./json-packet/spawn_points.json').SpawnPoints;
const commandHandler = require('../command/index.js')(DB);


mp.events.add('playerDeath', (player) => {
    player.spawn(spawnPoints[Math.floor(Math.random() * spawnPoints.length)]);
    player.health = 100;
});


mp.events.add('playerJoin', (player) => {
    

    player.call('showLoginDialog');
});

mp.events.add("playerQuit", (player) => {
    
});


const mysql = require('mysql');

var DB = mysql.createConnection(
{
    host: 'localhost',
    user: 'root',
    password: '',
    database: 'main_server'
});


mp.events.add('packagesLoaded', () => {

   DB.connect(function(err){
       if(err) {
            console.error(`mysql connected failed.`);
            return;
       }
       console.log('mysql connected successfully.');
   });
});



mp.events.add('onRegisterAttempt', (player, data) => {
    data = JSON.parse(data);

    DB.query('SELECT id FROM `accounts` WHERE `social_id` = ?', [player.rgscId], function (error, results) {  // Проверяем уникальность логина
        if(results.length > 0) return player.call('showAuthError', ['Аккаунт с таким SocialID уже существует']); // Если такой логин уже есть, то возвращаем ошибку

        DB.query('INSERT INTO `accounts`(`social_id`, `login`, `password`) VALUES (?,?,?)', [player.rgscId, data.login, data.password], function (error, results) { // Добавляем аккаунт в базу данных
            
        });

        DB.query('SELECT `admin_lvl`, `cash` FROM `accounts` WHERE `social_id` = ?', [player.rgscId], function (error, results)
        {
            if(!results.length)
            {
                player.kick(player);
                return;
            }

            player.admin = results[0].admin_lvl;
            player.cash =  results[0].cash;

            player.call('hideLoginDialog');
            player.call('showPlayerHud', [player.cash, player.rgscId, player.id]);
        });
    
    });

});



mp.events.add('onLoginAttempt', (player, data) => {
    data = JSON.parse(data);

    DB.query('SELECT * FROM accounts WHERE login = ? LIMIT 1', [data.login], function (error, results) {
        if(!results.length) return player.call('showAuthError', ['Введите правильный логин или пароль.']);

        if (results[0].password === data.password)
        {   
            player.admin = results[0].admin_lvl;
            player.cash =  results[0].cash;

            player.call('hideLoginDialog');
            player.call('showPlayerHud', [player.cash, player.rgscId, player.id]);
            return;
        }
        else player.call('showAuthError', ['Неверный Логин или Пароль']);
        
    });
});

2. command/index.js

mp.events.addCommand('veh', (player, _, id, veh, color1, color2) =>
{   
    if (player.admin < 2) return;

    if (id == undefined || veh == undefined) return player.outputChatBox('/veh [id] [model] [color1] [color2]');
    let target = mp.players.at(id);
    
    if (target == null) return player.notify('~ r~ID игрока не найден!');
    let pos = target.position;
    
    var adminVeh = mp.vehicles.new(mp.joaat(veh), new mp.Vector3(pos.x + 2, pos.y, pos.z));

    
    adminVeh.setNeonColor(255, 0, 0);
    adminVeh.neonEnable = true;

    adminVeh.setColor(parseInt(color1), parseInt(color2));
    target.putIntoVehicle(adminVeh, 0);
});

module.exports = (DB) => {
    const MAX_LVL_ADMIN = 5;

    mp.events.addCommand('makeadmin', (player, _, id, lvl) => {
        if (player.admin < MAX_LVL_ADMIN) return;

        if (id == undefined || lvl == undefined) return player.outputChatBox('/makeadmin [id] [lvl]');
        if (lvl < 0 || lvl > MAX_LVL_ADMIN) return player.outputChatBox('/makeadmin [id] [lvl]');

        let target = mp.players.at(id);

        if (target.id == player.id) return player.outputChatBox('/makeadmin [id] [lvl]');

        target.admin = lvl;

        if (lvl != 0)
        {   
            player.outputChatBox(`Вы успешно выдали админку игроку: ${target.name} (Выдан лвл: ${lvl})`);
            target.outputChatBox(`Вам выдали админ права: ${lvl} lvl (Выдал: ${player.name})`);
        }
        else
        {
            player.outputChatBox(`Вы успешно сняли администратор: ${target.name}`);
            target.outputChatBox(`Вы были сняты с поста администратора! Снял: ${player.name}`);
        }

        DB.query('UPDATE `accounts` SET `admin_lvl` = ? WHERE `social_id` = ?', [target.admin, target.rgscId]);
        return 1;
    });
};

 

[jrius]

Пофиксил.

Исправленный код, кому нужен.

1. Events.js

let spawnPoints = require('./json-packet/spawn_points.json').SpawnPoints;



mp.events.add('playerDeath', (player) => {
    player.spawn(spawnPoints[Math.floor(Math.random() * spawnPoints.length)]);
    player.health = 100;
});


mp.events.add('playerJoin', (player) => {
    

    player.call('showLoginDialog');
});

mp.events.add("playerQuit", (player) => {
    
});


const mysql = require('mysql');

var DB = mysql.createConnection(
{
    host: 'localhost',
    user: 'root',
    password: '',
    database: 'main_server'
});


mp.events.add('packagesLoaded', () => {

   DB.connect(function(err){
       if(err) {
            console.error(`mysql connected failed.`);
            return;
       }
       console.log('mysql connected successfully.');
   });
});

require('../command/index.js')(DB);

mp.events.add('onRegisterAttempt', (player, data) => {
    data = JSON.parse(data);

    DB.query('SELECT id FROM `accounts` WHERE `social_id` = ?', [player.rgscId], function (error, results) {  // Проверяем уникальность логина
        if(results.length > 0) return player.call('showAuthError', ['Аккаунт с таким SocialID уже существует']); // Если такой логин уже есть, то возвращаем ошибку

        DB.query('INSERT INTO `accounts`(`social_id`, `login`, `password`) VALUES (?,?,?)', [player.rgscId, data.login, data.password], function (error, results) { // Добавляем аккаунт в базу данных
            
        });

        DB.query('SELECT `admin_lvl`, `cash` FROM `accounts` WHERE `social_id` = ?', [player.rgscId], function (error, results)
        {
            if(!results.length)
            {
                player.kick(player);
                return;
            }

            player.admin = results[0].admin_lvl;
            player.cash =  results[0].cash;

            player.call('hideLoginDialog');
            player.call('showPlayerHud', [player.cash, player.rgscId, player.id]);
        });
    
    });

});



mp.events.add('onLoginAttempt', (player, data) => {
    data = JSON.parse(data);

    DB.query('SELECT * FROM accounts WHERE login = ? LIMIT 1', [data.login], function (error, results) {
        if(!results.length) return player.call('showAuthError', ['Введите правильный логин или пароль.']);

        if (results[0].password === data.password)
        {   
            player.admin = results[0].admin_lvl;
            player.cash =  results[0].cash;

            player.call('hideLoginDialog');
            player.call('showPlayerHud', [player.cash, player.rgscId, player.id]);
            return;
        }
        else player.call('showAuthError', ['Неверный Логин или Пароль']);
        
    });
});

2. commans/index.js

mp.events.addCommand('veh', (player, _, id, veh, color1, color2) =>
{   
    if (player.admin < 2) return;

    if (id == undefined || veh == undefined) return player.outputChatBox('/veh [id] [model] [color1] [color2]');
    let target = mp.players.at(id);
    
    if (target == null) return player.notify('~ r~ID игрока не найден!');
    let pos = target.position;
    
    var adminVeh = mp.vehicles.new(mp.joaat(veh), new mp.Vector3(pos.x + 2, pos.y, pos.z));

    
    adminVeh.setNeonColor(255, 0, 0);
    adminVeh.neonEnable = true;

    adminVeh.setColor(parseInt(color1), parseInt(color2));
    target.putIntoVehicle(adminVeh, 0);
});

module.exports = (DB) => {
    const MAX_LVL_ADMIN = 5;

    mp.events.addCommand('makeadmin', (player, _, id, lvl) => {
        if (player.admin < MAX_LVL_ADMIN) return;

        if (id == undefined || lvl == undefined) return player.outputChatBox('/makeadmin [id] [lvl]');
        if (lvl < 0 || lvl > MAX_LVL_ADMIN) return player.outputChatBox('/makeadmin [id] [lvl]');

        let target = mp.players.at(id);

        if (target.id == player.id) return player.outputChatBox('/makeadmin [id] [lvl]');

        target.admin = lvl;

        if (lvl != 0)
        {   
            player.outputChatBox(`Вы успешно выдали админку игроку: ${target.name} (Выдан лвл: ${lvl})`);
            target.outputChatBox(`Вам выдали админ права: ${lvl} lvl (Выдал: ${player.name})`);
        }
        else
        {
            player.outputChatBox(`Вы успешно сняли администратор: ${target.name}`);
            target.outputChatBox(`Вы были сняты с поста администратора! Снял: ${player.name}`);
        }

        DB.query('UPDATE `accounts` SET `admin_lvl` = ? WHERE `social_id` = ?', [target.admin, target.rgscId]);
        return 1;
    });
};