setVariable dosen't work

[gravgor2137]

mp.events.add("getInformationAboutDuty", (player) => {
        gm.mysql.handle.query('SELECT `login`,`ranga`, `adminduty` FROM `rp_administration` WHERE `login` = ?', [player], function(err, res){
            let login = res[0]["login"];
            let ranga = res[0]["ranga"];
            let aduty = res[0]["adminduty"];
            console.log(`Login gracza: ${login}, Ranga gracza: ${ranga}, Level duty: ${aduty}`);
            player.setVariable('duty', aduty);
            player.outputChatBox(`Zostałeś zalogowany na służbę administracyjną`);
            player.setVariable('ranga', ranga);
        });
    });

 

 

 

Hi! In this code something does not work for me setVariable - does anyone know why? No error in the console.
   

[Mentanding]

read this.

try this:

mp.events.add("getInformationAboutDuty", (player) => {
	gm.mysql.handle.query('SELECT * FROM rp_administration WHERE login = ?', [player], function(err, res) {
		player.setVariable('login', result[0].login);
		player.setVariable('ranga', result[0].ranga);
		player.setVariable('adminduty', result[0].adminduty);
		console.log(`Login gracza: ${player.getVariable('login')}, Ranga gracza: ${player.getVariable('ranga')}, Level duty: ${player.getVariable('adminduty')}`);
		player.outputChatBox(`Zostałeś zalogowany na służbę administracyjną`);
	});
});

 

[gravgor2137]

/clients/s44127/packages/administration-system/mysql.js:75: TypeError: Cannot read property 'query' of null
gm.mysql.handle.query('SELECT * FROM rp_administration WHERE login = ?', [player], function(err, res) {