Search the Community

Business] 9 loaded. (node:21292) UnhandledPromiseRejectionWarning: TypeError: Cannot read property 'x' of null at global.UpdateBizz3D (D:\ragemp\server-files\packages\server\src\systems\business\index.js:101:24) at Business.forEach (D:\ragemp\server-files\packages\server\src\systems\business\index.js:74:7) at Array.forEach (<anonymous>) at query.then (D:\ragemp\server-files\packages\server\src\systems\business\index.js:73:14) at process._tickCallback (internal/process/next_tick.js:68:7) (node:21292) UnhandledPromiseRejectionWarning: Unhandled promise rejection. This error originated either by throwing inside of an async function without a catch block, or by rejecting a promise which was not handled with .catch(). (rejection id: 1) (node:21292) [DEP0018] DeprecationWarning: Unhandled promise rejections are deprecated. In the future, promise rejections that are not handled will terminate the Node.js process with a non-zero exit code. [Data] 5 loaded. [Houses] 5 loaded.

Делаю работу грузчика. Сделал колшейп, если становишься на него - устраиваешься на работу, но не могу понять, как сделать так, чтобы поинты были видны только у человека, который устроился. Знаю, что надо делать через client, но чёт не догоняю. Вот что у меня получается пока-что: mp.events.add("playerEnterColshape", playerEnterColshapeHandler); function playerEnterColshapeHandler(player, shape) { if(shape == builduse) { if(player.work_id) { gm.mysql.handle.query('UPDATE `accounts` SET work_id = ? WHERE username = ?', [0, player.name]); player.work_id = false; player.call("work_id", false); } else { gm.mysql.handle.query('UPDATE `accounts` SET work_id = ? WHERE username = ?', [1, player.name]); player.work_id = true; player.call("work_id", true); } } let random = Math.floor(Math.random() * 2); gm.mysql.handle.query('UPDATE `accounts` SET amount_builder = ? WHERE username = ?', [random, player.name]); if(shape == work1use) { if(player.point_builder == 0) { gm.mysql.handle.query('UPDATE `accounts` SET amount_builder = ? WHERE username = ?', [1, player.name]); player.point_builder = true; player.call("point_builder", true); } } if(shape == work2use) { if(player.point_builder == 1) { gm.mysql.handle.query('UPDATE `accounts` SET amount_builder = ? WHERE username = ?', [0, player.name]); player.point_builder = false; player.call("point_builder", false); } } } Возможно ли сделать, как я, через рандом две точки? Где создавать колшейпы, в клиенте, или сервере? Если кто знает, хелп, буду благодарен.

How to make it so that if 1 falls out, then one point will appear, if 0, then another And where do you need to create points in the client or server? mp.events.add("playerEnterColshape", playerEnterColshapeHandler); function playerEnterColshapeHandler(player, shape) { if(shape == builduse) { if(player.work_id) { gm.mysql.handle.query('UPDATE `accounts` SET work_id = ? WHERE username = ?', [0, player.name]); player.work_id = false; player.call("work_id", false); } else { gm.mysql.handle.query('UPDATE `accounts` SET work_id = ? WHERE username = ?', [1, player.name]); player.work_id = true; player.call("work_id", true); } } let random = Math.floor(Math.random() * 2); gm.mysql.handle.query('UPDATE `accounts` SET amount_builder = ? WHERE username = ?', [random, player.name]); if(shape == work1use) { if(player.point_builder == 0) { gm.mysql.handle.query('UPDATE `accounts` SET amount_builder = ? WHERE username = ?', [1, player.name]); player.point_builder = true; player.call("point_builder", true); } } if(shape == work2use) { if(player.point_builder == 1) { gm.mysql.handle.query('UPDATE `accounts` SET amount_builder = ? WHERE username = ?', [0, player.name]); player.point_builder = false; player.call("point_builder", false); } } }

Писал и < npm update mysql > и < npm -g update mysql > и < npm update -g mysql > console.log("step 0"); var mysql = require('mysql'); var mysqlc = mysql.createConnection({ host:'localhost',// host of server user:'root',// MySQL user password:'',// MySQL password database:'rage_bados'// MySQL database }); mysqlc.connect(function(e) { if(e) { console.log("Error connecting to the database with error "+e); } else { console.log('Database connected!') } }); mysqlc.end(); mysqlc.query("SELECT * FROM `users` WHERE `nickname`=", [], function(e, r) { if(e) { console.log('Error on connection ... '); throw e; } else { console.log('Password is '+r[0].passcode); } }); Error: Error: Cannot find module 'mysql' at Function.Module._resolveFilename (internal/modules/cjs/loader.js:581:15) at Function.Module._load (internal/modules/cjs/loader.js:507:25) at Module.require (internal/modules/cjs/loader.js:637:17) at require (internal/modules/cjs/helpers.js:20:18) at Object.<anonymous> (D:\RAGEMP\server-files\packages\freeroam\index.js:15:13) at Module._compile (internal/modules/cjs/loader.js:689:30) at Object.Module._extensions..js (internal/modules/cjs/loader.js:700:10) at Module.load (internal/modules/cjs/loader.js:599:32) at tryModuleLoad (internal/modules/cjs/loader.js:538:12) at Function.Module._load (internal/modules/cjs/loader.js:530:3)

/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) {

Und warum die Placeholder benutzen wenn man einfach das machen kann: misc.query(`INSERT INTO weapon_shops SET ShopX=${pos.x}, ShopY=${pos.y}, ShopZ=${pos.z}`, ...

Try wrapping your whole code into a try catch like this: try { var mysql = require('mysql'); let mysqlc = mysql.createConnection({ host: '...', user: '...', password: '...', database: '...' }); mysqlc.connect(function(e) { console.log('Connecting ... '); if(e) { console.log("Error connecting to the database with error "+e); } else { console.log('Database connected!') } }); mp.events.add("CheckedLogin", (UserName, Password) => { console.log('Call ... '); mysqlc.query("SELECT * FROM `Player` WHERE `UserName`=", [UserName], function(e, r) { console.log('Load ... '); if(e) { console.log('Error on connection ... '); throw e; } else { console.log('Password is '); } }); mysqlc.end(); }); } catch(e) { console.log(e); }

used: < npm update mysql > | < npm -g update mysql > and < npm update -g mysql > console.log("step 0"); var mysql = require('mysql'); var mysqlc = mysql.createConnection({ host:'localhost',// host of server user:'root',// MySQL user password:'',// MySQL password database:'rage_bados'// MySQL database }); mysqlc.connect(function(e) { if(e) { console.log("Error connecting to the database with error "+e); } else { console.log('Database connected!') } }); mysqlc.end(); mysqlc.query("SELECT * FROM `users` WHERE `nickname`=", [], function(e, r) { if(e) { console.log('Error on connection ... '); throw e; } else { console.log('Password is '+r[0].passcode); } }); ERROR: step 0 Error: Error: Cannot find module 'mysql' at Function.Module._resolveFilename (internal/modules/cjs/loader.js:581:15) at Function.Module._load (internal/modules/cjs/loader.js:507:25) at Module.require (internal/modules/cjs/loader.js:637:17) at require (internal/modules/cjs/helpers.js:20:18) at Object.<anonymous> (D:\RAGEMP\server-files\packages\freeroam\index.js:15:13) at Module._compile (internal/modules/cjs/loader.js:689:30) at Object.Module._extensions..js (internal/modules/cjs/loader.js:700:10) at Module.load (internal/modules/cjs/loader.js:599:32) at tryModuleLoad (internal/modules/cjs/loader.js:538:12) at Function.Module._load (internal/modules/cjs/loader.js:530:3)

https://github.com/mysqljs/mysql#escaping-query-values Les dir das mal durch. Dort siehst du das dort steht "Strings are safely escaped", und damit ist auch gemeint, dass die Apostrophe eingesetzt werden. Bitte verbreite hier kein Halbwissen, du redest hier nämlich einfach nur Schwachsinn, ohne dich zu informieren.

Hello, i have such code: mp.events.add('playerJoin', (player) =>{ player.outputChatBox('!{red}►!{white}[!{#17d666}SERVER!{white}]: Hello. First you need auth. Use /login for this.'); player.cop = 0; player.exit = 0; player.robb = 0; player.ingame = 0; player.au = 0; }); mp.events.addCommand('mp', (player)=>{ if (player.au == 0){ player.outputChatBox('!{red}►!{white}[!{#17d666}SERVER!{white}]: Need to auth. Use /login.'); } if (player.au == 1){ startMP(); } function startMP() { if (startmp == 0){ player.ingame = 1; player.cop = 1; countplayers +=1; var timertostart = setTimeout(teleporttomp, 5000); startmp = 1; player.outputChatBox('!{red}►!{white}[!{#17d666}SERVER!{white}]: Your role is cop'); mysqlc.query("SELECT null FROM game WHERE name = ?", player.name, function(e, result) { if (!e) { if ( !result.length ) { mysqlc.query("INSERT INTO game (name, sost) VALUES (?,?)", [player.name, 1], function(e) { if ( e ) console.log ( e ); }); } else { mysqlc.query("UPDATE game SET sost=? WHERE name=?", [1, player.name], function(e) { if ( e ) console.log ( e ); }); } } else console.log (e); }); } if (startmp == 1 && countplayers == 1 && player.ingame == 0){ player.ingame = 1; player.robber = 1; player.outputChatBox('!{red}►!{white}[!{#17d666}SERVER!{white}]: Your role is robber'); countplayers +=1; mysqlc.query("SELECT null FROM game WHERE name = ?", player.name, function(e, result) { if (!e) { if ( !result.length ) { mysqlc.query("INSERT INTO game (name, sost) VALUES (?,?)", [player.name, 2], function(e) { if ( e ) console.log ( e ); }); } else { mysqlc.query("UPDATE game SET sost=? WHERE name=?", [2, player.name], function(e) { if ( e ) console.log ( e ); }); } } else console.log (e); }); } if (startmp == 1 && countplayers != 1 && player.ingame == 0){ countplayers +=1; player.ingame = 1; player.cop = 1; player.outputChatBox('!{red}►!{white}[!{#17d666}SERVER!{white}]: Твоя роль: Коп.'); mysqlc.query("SELECT null FROM game WHERE name = ?", player.name, function(e, result) { if (!e) { if ( !result.length ) { mysqlc.query("INSERT INTO game (name, sost) VALUES (?,?)", [player.name, 1], function(e) { if ( e ) console.log ( e ); }); } else { mysqlc.query("UPDATE game SET sost=? WHERE name=?", [1, player.name], function(e) { if ( e ) console.log ( e ); }); } } else console.log (e); }); } if (nachalo == 1 && player.ingame == 0 && startmp == 1){ player.outputChatBox('!{red}►!{white}[!{#17d666}SERVER!{white}]: Game already begin.'); } function teleporttomp() { if (countplayers >=2){ setTimeout(endmp, 10000); reason = 1; nachalo = 1; if (spawncar == 0){ copcar2 = mp.vehicles.new(-1627000575, new mp.Vector3(408.7535400390625, -985.9756469726562, 28.87946128845215)); copcar3 = mp.vehicles.new(-1627000575, new mp.Vector3(408.854248046875, -991.5232543945312, 28.880756378173828)); copcar4 = mp.vehicles.new(-1627000575, new mp.Vector3(408.9591979980469, -997.333251953125, 28.88153648376465)); copcar5 = mp.vehicles.new(-1627000575, new mp.Vector3(409.0743103027344, -1003.7307739257812, 28.881433486938477)); copcar6 = mp.vehicles.new(-1627000575, new mp.Vector3(404.4643249511719, -1016.8744506835938, 28.93781852722168)); copcar7 = mp.vehicles.new(-1627000575, new mp.Vector3(405.6515808105469, -971.7103271484375, 28.973918914794922)); robcar = mp.vehicles.new(1878062887, new mp.Vector3(148.70083618164062, -1028.100341796875, 28.839427947998047)); robcar.dimension = 2; copcar2.dimension = 2; copcar3.dimension = 2; copcar4.dimension = 2; copcar5.dimension = 2; copcar6.dimension = 2; copcar7.dimension = 2; spawncar = 1; } mysqlc.query("SELECT sost FROM game WHERE name = ?", [player.name], function(e, result) { if ( result.length ) { player.role= result[0]["sost"]; console.log(player.role); if (player.role == 1) // cop { player.spawn(new mp.Vector3(457.8045959472656, -990.8690795898438, 30.689599990844727)); player.model = -1699520669; player.dimension = 2; player.giveWeapon(453432689, 1000); } if (player.role == 2) // robber { player.spawn(new mp.Vector3(150.1586151123047, -1040.0599365234375, 29.37407684326172)); player.dimension = 2; player.model = -1067576423; } } else console.log('request failure'); }); For some reason, if some player started this event, him gived role of Robber. If some try to join in this event, him gives role cops, but when called function "teleporttomp" - player, that was "Robber" (who started event) got his role, but all, who was "Cop" - not considered. This happenes because it working only for one player and after just ceases to work. Why so happenes? How to fix this? I need teleport whole players, which now is in this event, on their position with their roles. Please, help me P.S Sorry for my english

If so were the case I think he should have a file not found exception rather than not supported. I'm really new to this scripting and don't know the difference between SqlConnection and MySqlConnection, but my query would look something like this. try { string query = "SELECT [name] FROM [sys].[tables] ORDER BY [name]"; using(MySqlConnection db = new MySqlConnection(_connStr)) using(MySqlCommand cmd = new MySqlCommand(query, db)) { db.Open(); using(MySqlDataReader data = command.ExecuteReader()) { if(data.Read()) { } } } } catch(Exception ex) { Console.WriteLine(ex.ToString()); }

Guten Tag zusammen, ich habe derzeit das Problem, das mit seit dem TS3 Update immer folgende Fehlermeldung ausgegeben wird wenn ich meinen Server mit folgenden Settings in der meta.xml starten möchte. <meta> <info name="teamspeak_wrapper" type="script" /> <script src="RAGEMP_TsVoice.dll" /> <setting name="teamspeak_query_address" value="" default="127.0.0.1" /> <setting name="teamspeak_query_port" value="" default="10011" /> <setting name="teamspeak_port" value="" default="9987" /> <setting name="teamspeak_login" value="" default="serveradmin" /> <setting name="teamspeak_password" value="" default="serverpassword" /> <setting name="teamspeak_channel" value="" default="sprachkanal" /> </meta> Hier tritt folgender Fehler auf. Started! Waiting for connections.. [P] Plugin bridge.dll loaded! System.ArgumentNullException: Value cannot be null. Parameter name: hostName at TeamSpeak3QueryApi.Net.QueryClient..ctor(String hostName, Int32 port) in C:\Users\Administrator\Desktop\RAGEMP_GTA5_TSVoice-master\RAGEMP_TsVoice\TsQuery\QueryClient.cs:line 60 at TeamSpeak3QueryApi.Net.Specialized.TeamSpeakClient..ctor(String hostName, Int32 port) in C:\Users\Administrator\Desktop\RAGEMP_GTA5_TSVoice-master\RAGEMP_TsVoice\TsQuery\Specialized\TeamSpeakClient.cs:line 34 at RAGEMP_TsVoice.Teamspeak.<InitTSQuery>d__32.MoveNext() in C:\Users\Administrator\Desktop\RAGEMP_GTA5_TSVoice-master\RAGEMP_TsVoice\Teamspeak.cs:line 117 --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at RAGEMP_TsVoice.Teamspeak.<<OnResourceStart>b__28_0>d.MoveNext() in C:\Users\Administrator\Desktop\RAGEMP_GTA5_TSVoice-master\RAGEMP_TsVoice\Teamspeak.cs:line 66 Die connect Methode sieht wie folgt aus : private async Task InitTSQuery() { tsQuery = new TeamSpeakClient(TeamspeakQueryAddress, TeamspeakQueryPort); // Create rich client instance try { await tsQuery.Connect(); // connect to the server await tsQuery.Login(TeamspeakLogin, TeamspeakPassword); // login to do some stuff that requires permission await tsQuery.UseServer(1); // Use the server with id '1' var me = await tsQuery.WhoAmI(); // Get information about yourself! var channel = (await tsQuery.FindChannel(TeamspeakChannel)).FirstOrDefault(); Utils.Delay(100, false, async () => await UpdateTeamspeak(channel) ); } catch(QueryException ex) { Console.WriteLine(ex.ToString()); } } Hatte alles funktioniert nun nicht mehr! Passe ich nun die Methode etwas an, ohne die Daten aus der XML Datei zu lesen und gebe im Code direkt den Host und den Port an, bekomme ich diesen Fehler hier. [P] Plugin bridge.dll loaded! TeamSpeak3QueryApi.Net.QueryException: An error occurred during the query. at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at TeamSpeak3QueryApi.Net.QueryClient.<Send>d__28.MoveNext() in C:\Users\Administrator\Desktop\RAGEMP_GTA5_TSVoice-master\RAGEMP_TsVoice\TsQuery\QueryClient.cs:line 149 --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at RAGEMP_TsVoice.Teamspeak.<InitTSQuery>d__36.MoveNext() in C:\Users\Administrator\Desktop\RAGEMP_GTA5_TSVoice-master\RAGEMP_TsVoice\Teamspeak.cs:line 125 Teamspeak Wrapper Initialised! Started HTTP server at 22006 port. Ich habe wirklich keine Ahnung was ich falsch mache.

There's a couple red flags with this whole projects - No credits have been given, you're using multiple resources which have come from RageMP (which is 100% fine, they're free and open) but you haven't taken the time to even credit those who made these. - According to comments, you've also ripped off sources that may not have been open source for the public, and so far you've avoided responded to anyone about this. - Looking briefly over the code, there's a lot of really bad code, you can easily see it has been copy/pasted as some functions have been developed really inefficiently (e.g you're calling multiple queries one after the other, imagine a lot of people using that function at the same time) and also if a query errors, your letting the code continue to run instead of ending the function when it errors. - This is all put together in 7 days. While it's good for new developers to come and release resources no matter if they're new or experienced, I feel like this has been very rushed, slapped together and pushed out. I really hope code hasn't been stolen from other private projects.

Hello,there is sth wrong with the started [Business] 9 loaded. (node:21292) UnhandledPromiseRejectionWarning: TypeError: Cannot read property 'x' of null at global.UpdateBizz3D (D:\ragemp\server-files\packages\server\src\systems\business\index.js:101:24) at Business.forEach (D:\ragemp\server-files\packages\server\src\systems\business\index.js:74:7) at Array.forEach (<anonymous>) at query.then (D:\ragemp\server-files\packages\server\src\systems\business\index.js:73:14) at process._tickCallback (internal/process/next_tick.js:68:7) (node:21292) UnhandledPromiseRejectionWarning: Unhandled promise rejection. This error originated either by throwing inside of an async function without a catch block, or by rejecting a promise which was not handled with .catch(). (rejection id: 1) (node:21292) [DEP0018] DeprecationWarning: Unhandled promise rejections are deprecated. In the future, promise rejections that are not handled will terminate the Node.js process with a non-zero exit code. [Data] 5 loaded. [Houses] 5 loaded. What should I do?I googled it but I couldn't find anything helpful....

"addhouse": (player, args) => { if(player.customData.admin < 6) return player.call("alert", "error" , "У Вас недостаточно полномочий"); if (isNaN(parseInt(rare = args[1])) || isNaN(parseInt(coast = args[2])) || isNaN(interior = parseInt(args[3])) || isNaN(parseInt(garage = args[4])) || isNaN(max_cars = parseInt(args[5]))) return player.call("alert", "error" , "Используйте: /addhouse [rare] [coast] [interior] [garage] [max_cars]"); if(parseInt(rare) >= 0 && parseInt(coast) >= 0 && parseInt(interior) >= 0 && parseInt(garage) >= 0 && max_cars >= 1) { let get_id = 0; let get_count = 0; mysql.connection.query('SELECT COUNT(*) AS count FROM houses', [], function (error, results, fields) { get_count = results[0].count; let array_max_cars = new Array(parseInt(max_cars)); let array_gen = {x: 'NONE', y: 'NONE', z: 'NONE'}; for(let i = 0; i < max_cars; i++) { array_max_cars = array_gen; } let max_cars_pos = JSON.stringify(array_max_cars); var query = mysql.connection.query('INSERT INTO houses SET pos_x = ?, pos_y = ?, pos_z = ?, pos_heading = ?, rare = ?, coast = ?, interior = ?, garage = ?, garage_enter_pos_x = ?, garage_enter_pos_y = ?, garage_enter_pos_z = ?, garage_enter_pos_r = ?, max_cars_count = ?, max_cars_pos = ?', [player.position.x, player.position.y, player.position.z, player.heading, rare, coast, interior, garage, 0, 0, 0, 0, max_cars, max_cars_pos], function (error, results, fields) { console.log(error); }); configure.housesblips[get_count] = mp.blips.new(40, new mp.Vector3(parseFloat(player.position.x), parseFloat(player.position.y), parseFloat(player.position.z)), { name: "Дом", scale: 1, color: 2, drawDistance: 100, shortRange: 100, rotation: 0, dimension: 0, }); configure.housesmarkers[get_count] = mp.markers.new(0, new mp.Vector3(parseFloat(player.position.x), parseFloat(player.position.y), parseFloat(player.position.z)), 1, { direction: new mp.Vector3(0,0,0), rotation: new mp.Vector3(0,0,0), visible: true, dimension: 0 }); configure.housesmarkers[get_count].setColor(255, 247, 0, 255); configure.housescolshapes[get_count] = mp.colshapes.newRectangle(player.position.x, player.position.y, 1, 1); configure.housesnumber[get_count] = get_count; configure.housestate[get_count] = 0; configure.housesrare[get_count] = parseInt(rare); configure.housesowner[get_count] = "NONE"; configure.housescoast[get_count] = parseInt(coast); configure.housesinterior[get_count] = parseInt(interior); configure.housesgarage[get_count] = parseInt(garage); player.call("alert", "success", "Дом установлен!"); if(parseInt(garage) >= 1) { player.call("alert", "information", "Для установки точки выезда/въезда в гараж используйте: /setgarage"); } //logger.write("[" + namepos + "]: " + "X: " + get_pos.x + "; Y: " + get_pos.y + "; Z: " + get_pos.z + ";"); }); } else { player.call("alert", "error", "Для установки дома, необходимо выбрать следующее параметры:"); player.call("alert", "error", "Классы домов: 0 [H], 1 [M], 2 [R], 3 [A]"); player.call("alert", "information", "[/addhouse]: [rare] [coast] [interior] [garage] [max_cars]"); } },

$mysearch="Your Search Name"; $query = mysql_query("SELECT * FROM table"); $c=0; // set array $array = array(); // look through query while($row = mysql_fetch_assoc($query)){ // add each row returned into an array $array[] = $row; $c++; } for($i=0;$i=$c;$i++) { if($array[i]['username']==$mysearch) { // name found } } https://www.welookups.com/

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.

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ą`); }); });

Everything from this folder. And yes, I have a mysql module index.js require('./main.js'); require('./main_s.js'); main.js mp.events.addCommand("v", (player) => { player.outputChatBox('Dostępne komendy związane z samochodami prywatnymi'); player.outputChatBox('/vspawn [id]'); player.outputChatBox('/vlista'); player.outputChatBox('/vudostepnij [id_gracza] [id_pojazdu]'); player.outputChatBox('/vprzypisz [id pojazdu] [id grupy]'); player.outputChatBox('/vulepszenia [id_pojazdu]'); }); mp.events.addCommand("vlista", (player) => { mp.events.call('sprawdzPojazd', player); console.log(`dziala`); }); mp.events.add('wypiszPojazdy', (player) => { let pojazdy = player.getVariable(`pojazd_gracz`); let id = player.getVariable(`id_pojazdow`); player.outputChatBox(`Twoje pojazdy:`); player.outputChatBox(`${id} ${pojazdy}`); }); main_s.js var mysql = require('mysql'); var conn = mysql.createConnection({ host:'re',// host of server user:'re',// MySQL user password:'re',// MySQL password database:'re'// MySQL database }); conn.connect(function(err) { if (err) console.log (err); else console.log("Successful connected to DataBase!"); }); mp.events.add('sprawdzPojazd', (player) => { console.log(`wykonany event`) conn.query("SELECT * from `rp_vehicles` WHERE `login`=", [player], function(e, r) { if(e) { console.log('Error on connection ... '); throw e; } else { console.log(`wykonany event2`); player.setVariable('pojazd_gracz', r[0].model); player.setVariable('id_pojazdow', r[0].id); mp.events.call('wypiszPojazdy', player); } }); });

Hello, I would like to ask if you plan to do and release multiplayer for the latest social club version? Thank you in advance for your reply Because the new version does not work

My guess would be that you're not properly closing shit. mp.events.add("getInformationAboutDuty", (player) => { rp.mysql.handle.query('SELECT `adminduty` from `rp_administration` WHERE `login` = ?', [player], function (err, res) { if(res == 0) { player.outputchatBox(`Text shit here`); } else { mp.events.call('setDutyOnPlayer', player); player.outputChatBox(`Chat shit here`); } }); });

Error: C:\RAGEMP\server-files\packages\administration-system\mysql.js:60 }}; ^ mp.events.add("getInformationAboutDuty", (player) => { rp.mysql.handle.query('SELECT `adminduty` from rp_administration WHERE login=?', [player], function(err,res){ if(res == 0){ player.outputChatBox(`Nie możesz wejść na duty - brak uprawnień`); } else { mp.events.call('setDutyOnPlayer', player); player.outputChatBox(`Zalogowałeś się na duty!`); }}; )};

Hello guys! I have a problem with assemblies, and I don't really know why. So the problem is that when I start the server, I get no errors, but I get bunch of them in server-exception.txt file. Errors like this: ==================[2019. 02. 03. 1:07:33]================== System.IO.FileNotFoundException: Could not load the specified file. File name: 'Microsoft.EntityFrameworkCore.resources' at Assembly System.Runtime.Loader.AssemblyLoadContext.ResolveUsingEvent(AssemblyName assemblyName) ========================================================= ==================[2019. 02. 03. 1:07:37]================== System.ArgumentException: Field 'Microsoft.EntityFrameworkCore.Query.EntityQueryModelVisitor+TransparentIdentifier`2[RiteMOD.VehicleModel,System.Collections.Generic.IEnumerable`1[RiteMOD.Szin]].Inner' is not defined for type 'Microsoft.EntityFrameworkCore.Query.EntityQueryModelVisitor+TransparentIdentifier`2[RiteMOD.VehicleModel,RiteMOD.Szin]' at MemberExpression System.Linq.Expressions.Expression.Field(Expression expression, FieldInfo field) ========================================================= I don't know what the problem is. I have all of the required dlls in my runtime folder, and their version is 2.2 (I'm using .NET Core 2.2). I tried to use .NET Core 2.0 with v2.0 dlls, but that didn't work either. I'm using the latest Bootstrapper.dll (v0.3.7). Full log (96 lines): https://pastebin.com/vWrdbnrp manaszon

Doch klar steht es bei Barber... mp.events.addCommand({ 'createbarbershop' : async (player, enteredprice) => { if (player.adminLvl < 1) return; const id = business.getCountOfBusinesses() + 1; const coord = misc.getPlayerCoordJSON(player); const price = Number(enteredprice.replace(/\D+/g,"")); const query1 = misc.query(`INSERT INTO business (id, title, coord, price) VALUES ('${id}', 'Barber Shop', '${coord}', '${price}');`); const query2 = misc.query(`INSERT INTO barbershop (id) VALUES ('${id}');`); await Promise.all([query1, query2]); player.outputChatBox("!{#4caf50} Barber shop successfully created!"); }, 'setbscamdata' : async (player, id) => { if (player.adminLvl < 1) return; const shop = business.getBusiness(+id); shop.updateCamData(player); }, });