Matix8981 Posted May 2, 2018 Posted May 2, 2018 (edited) My function DBSelect function DBSelect(query) { if(query == undefined) { console.log("Not definied query"); } else { handler.query(query, function(error, result) { if(error) { console.log("Error " + error); throw error; } return result; }); } } And whitelist script "use strict" const mysql = require("./database"); mp.events.add("playerJoin", function(player) { const check = mysql.DBSelect("SELECT * FROM whitelist WHERE socialID='" + player + "';"); if(check == 0) { player.kick("Kick reason"); console.log("sadsad"); } }); Console dont show any errors, in join in server and dont kick me Edited May 2, 2018 by Matix8981
LeozinH1 Posted May 4, 2018 Posted May 4, 2018 (edited) That should work... // Connection file var mysql = require('mysql'); module.exports = { Handle: null, Connect: function(callback) { this.Handle = mysql.createConnection({ host : 'your_host', user : 'your_user', password : 'your_pass', database : 'your_database' }); this.Handle.connect(function(e) { if ( !e ) { callback(); } else console.log ("Error in Database " + e); }); } }; // White list file var db = require("./database"); mp.events.add("playerJoin", (player) => { db.Handle.query("SELECT * FROM whitelist WHERE socialID = ?", [player.socialClub], function(e, result) { if (!result.length){ player.kick("Not in whitelist."); }else{ // In Whitelist :) } }); But instead of using the social club, I recommend creating a login with a unique user ID. Players with pirate gta do not have the socialClub! Sorry for my English, I'm Brazilian. Edited May 4, 2018 by LeozinH1 2
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