gravgor2137 Posted June 15, 2019 Share Posted June 15, 2019 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. Link to comment Share on other sites More sharing options...
Mentanding Posted June 15, 2019 Share Posted June 15, 2019 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ą`); }); }); Link to comment Share on other sites More sharing options...
gravgor2137 Posted June 15, 2019 Author Share Posted June 15, 2019 /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) { Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now