Search the Community

Guten Tag und zwar habe ich da ein kleines Problem mit mit meinem Login System sobald ich einen Query ausführe habe ich folgendes in der server_exceptions.txt stehen ==================[10/5/19 5:38:43 PM]================== System.IO.FileNotFoundException: Could not load the specified file. File name: 'System.ComponentModel.Primitives' at Assembly System.Runtime.Loader.AssemblyLoadContext.ResolveUsingEvent(AssemblyName assemblyName) ========================================================= ==================[10/5/19 5:38:43 PM]================== System.IO.FileNotFoundException: Could not load the specified file. File name: 'System.ComponentModel.TypeConverter' at Assembly System.Runtime.Loader.AssemblyLoadContext.ResolveUsingEvent(AssemblyName assemblyName) ========================================================= ==================[10/5/19 5:38:43 PM]================== System.IO.FileNotFoundException: Could not load file or assembly 'System.ComponentModel.TypeConverter, Version=4.2.1.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a'. The system cannot find the file specified. File name: 'System.ComponentModel.TypeConverter, Version=4.2.1.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' at RuntimeMethodHandleInternal ModuleHandle.ResolveMethod(RuntimeModule module, int methodToken, IntPtr* typeInstArgs, int typeInstCount, IntPtr* methodInstArgs, int methodInstCount) at RuntimeMethodHandleInternal ModuleHandle.ResolveMethodHandleInternalCore(RuntimeModule module, int methodToken, IntPtr[] typeInstantiationContext, int typeInstCount, IntPtr[] methodInstantiationContext, int methodInstCount) ========================================================= ==================[10/5/19 5:38:43 PM]================== System.IO.FileNotFoundException: Could not load the specified file. File name: 'System.ComponentModel.TypeConverter' at Assembly System.Runtime.Loader.AssemblyLoadContext.ResolveUsingEvent(AssemblyName assemblyName) ========================================================= ==================[10/5/19 5:38:43 PM]================== System.IO.FileNotFoundException: Could not load file or assembly 'System.ComponentModel.TypeConverter, Version=4.2.1.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a'. The system cannot find the file specified. File name: 'System.ComponentModel.TypeConverter, Version=4.2.1.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' at void ModuleHandle.ResolveType(RuntimeModule module, int typeToken, IntPtr* typeInstArgs, int typeInstCount, IntPtr* methodInstArgs, int methodInstCount, ObjectHandleOnStack type) at RuntimeType ModuleHandle.ResolveTypeHandleInternal(RuntimeModule module, int typeToken, RuntimeTypeHandle[] typeInstantiationContext, RuntimeTypeHandle[] methodInstantiationContext) ========================================================= ==================[10/5/19 5:38:43 PM]================== System.TypeLoadException: Could not load type 'System.Management.WbemDefPath' from assembly 'System.Management, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a'. at System.Management.ManagementPath.CreateWbemPath(String path) at System.Management.ManagementPath..ctor(String path) ========================================================= ==================[10/5/19 5:38:43 PM]================== System.IO.FileNotFoundException: Could not load the specified file. File name: 'System.ComponentModel.TypeConverter' at Assembly System.Runtime.Loader.AssemblyLoadContext.ResolveUsingEvent(AssemblyName assemblyName) ========================================================= ==================[10/5/19 5:38:43 PM]================== System.IO.FileNotFoundException: Could not load file or assembly 'System.ComponentModel.TypeConverter, Version=4.2.1.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a'. The system cannot find the file specified. File name: 'System.ComponentModel.TypeConverter, Version=4.2.1.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' at RuntimeMethodHandleInternal ModuleHandle.ResolveMethod(RuntimeModule module, int methodToken, IntPtr* typeInstArgs, int typeInstCount, IntPtr* methodInstArgs, int methodInstCount) at RuntimeMethodHandleInternal ModuleHandle.ResolveMethodHandleInternalCore(RuntimeModule module, int methodToken, IntPtr[] typeInstantiationContext, int typeInstCount, IntPtr[] methodInstantiationContext, int methodInstCount) ========================================================= ==================[10/5/19 5:38:43 PM]================== System.IO.FileNotFoundException: Could not load the specified file. File name: 'System.ComponentModel.TypeConverter' at Assembly System.Runtime.Loader.AssemblyLoadContext.ResolveUsingEvent(AssemblyName assemblyName) ========================================================= ==================[10/5/19 5:38:43 PM]================== System.IO.FileNotFoundException: Could not load file or assembly 'System.ComponentModel.TypeConverter, Version=4.2.1.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a'. The system cannot find the file specified. File name: 'System.ComponentModel.TypeConverter, Version=4.2.1.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' at void ModuleHandle.ResolveType(RuntimeModule module, int typeToken, IntPtr* typeInstArgs, int typeInstCount, IntPtr* methodInstArgs, int methodInstCount, ObjectHandleOnStack type) at RuntimeType ModuleHandle.ResolveTypeHandleInternal(RuntimeModule module, int typeToken, RuntimeTypeHandle[] typeInstantiationContext, RuntimeTypeHandle[] methodInstantiationContext) ========================================================= ==================[10/5/19 5:38:43 PM]================== System.TypeInitializationException: The type initializer for 'System.Management.ManagementPath' threw an exception. ---> System.TypeLoadException: Could not load type 'System.Management.WbemDefPath' from assembly 'System.Management, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a'. at System.Management.ManagementPath.CreateWbemPath(String path) at System.Management.ManagementPath..ctor(String path) at System.Management.ManagementPath..cctor() --- End of inner exception stack trace --- at System.Management.ManagementScope._Clone(ManagementScope scope, IdentifierChangedEventHandler handler) ========================================================= ==================[10/5/19 5:38:43 PM]================== System.ArgumentException: 'windows-1252' is not a supported encoding name. For information on defining a custom encoding, see the documentation for the Encoding.RegisterProvider method. Parameter name: name at int System.Globalization.EncodingTable.GetCodePageFromName(string name) ========================================================= Alle dlls sind im runtime Order auf meinem Linux server.. Ich habe versucht die System.ComponentModel.TypeConverter aus dem dotnet Ordner hoch zu laden aber dann läuft der Server nicht mehr. Über jede hilfe freue ich mich Edit: Oder kann ich es ignorieren da die querys richtig ausgeführt werden?

I don't know how to use MySQL query. so please help me

Hey, so I wanted to create a MySQL Query where something in one table gets updated and something gets created in another table. That works so far, but I want to send a Error Message to the player, if `name1` already exists. public static int CreatePlayerSkin(Client player, AccountModel account, SkinModel skin) { NAPI.Util.ConsoleOutput("Debug 1"); int playerId = 0; using (MySqlConnection connection = new MySqlConnection(connectionString)) { NAPI.Util.ConsoleOutput("Debug 2"); try { NAPI.Util.ConsoleOutput("Debug 3"); connection.Open(); MySqlCommand command = connection.CreateCommand(); command.CommandText = "UPDATE accounts SET sex = @sex, name = @name WHERE socialName = @socialName LIMIT 1"; command.Parameters.AddWithValue("@sex", account.sex); command.Parameters.AddWithValue("@name", account.realName); command.Parameters.AddWithValue("@socialName", account.socialName); command.ExecuteNonQuery(); player.SetData(EntityData.PLAYER_SEX, account.sex); NAPI.Util.ConsoleOutput("Debug 4"); playerId = (int)command.LastInsertedId; command.CommandText = "INSERT INTO `skins` (`name1`, `socialName`, `firstHeadShape`, `secondHeadShape`, `firstSkinTone`, `secondSkinTone`, `headMix`, `skinMix`, "; command.CommandText += "`hairModel`, `firstHairColor`, `secondHairColor`, `beardModel`, `beardColor`, `chestModel`, `chestColor`, `blemishesModel`, "; command.CommandText += "`ageingModel`, `complexionModel`, `sundamageModel`, `frecklesModel`, `noseWidth`, `noseHeight`, `noseLength`, `noseBridge`, `noseTip`, `noseShift`, "; command.CommandText += "`browHeight`, `browWidth`, `cheekboneHeight`, `cheekboneWidth`, `cheeksWidth`, `eyes`, `lips`, `jawWidth`, `jawHeight`, `chinLength`, "; command.CommandText += "`chinPosition`, `chinWidth`, `chinShape`, `neckWidth`, `eyesColor`, `eyebrowsModel`, `eyebrowsColor`, `makeupModel`, `blushModel`, `blushColor`, "; command.CommandText += "`lipstickModel`, `lipstickColor`) VALUES (@name1, @socName, @firstHeadShape, @secondHeadShape, @firstSkinTone, @secondSkinTone, @headMix, @skinMix, "; command.CommandText += "@hairModel, @firstHairColor, @secondHairColor, @beardModel, @beardColor, @chestModel, @chestColor, @blemishesModel, @ageingModel, "; command.CommandText += "@complexionModel, @sundamageModel, @frecklesModel, @noseWidth, @noseHeight, @noseLength, @noseBridge, @noseTip, @noseShift, @browHeight, "; command.CommandText += "@browWidth, @cheekboneHeight, @cheekboneWidth, @cheeksWidth, @eyes, @lips, @jawWidth, @jawHeight, @chinLength, @chinPosition, @chinWidth, "; command.CommandText += "@chinShape, @neckWidth, @eyesColor, @eyebrowsModel, @eyebrowsColor, @makeupModel, @blushModel, @blushColor, @lipstickModel, @lipstickColor)"; command.Parameters.AddWithValue("@name1", account.realName); command.Parameters.AddWithValue("@socName", player.SocialClubName); command.Parameters.AddWithValue("@firstHeadShape", skin.firstHeadShape); command.Parameters.AddWithValue("@secondHeadShape", skin.secondHeadShape); command.Parameters.AddWithValue("@firstSkinTone", skin.firstSkinTone); command.Parameters.AddWithValue("@secondSkinTone", skin.secondSkinTone); command.Parameters.AddWithValue("@headMix", skin.headMix); command.Parameters.AddWithValue("@skinMix", skin.skinMix); command.Parameters.AddWithValue("@hairModel", skin.hairModel); command.Parameters.AddWithValue("@firstHairColor", skin.firstHairColor); command.Parameters.AddWithValue("@secondHairColor", skin.secondHairColor); command.Parameters.AddWithValue("@beardModel", skin.beardModel); command.Parameters.AddWithValue("@beardColor", skin.beardColor); command.Parameters.AddWithValue("@chestModel", skin.chestModel); command.Parameters.AddWithValue("@chestColor", skin.chestColor); command.Parameters.AddWithValue("@blemishesModel", skin.blemishesModel); command.Parameters.AddWithValue("@ageingModel", skin.ageingModel); command.Parameters.AddWithValue("@complexionModel", skin.complexionModel); command.Parameters.AddWithValue("@sundamageModel", skin.sundamageModel); command.Parameters.AddWithValue("@frecklesModel", skin.frecklesModel); command.Parameters.AddWithValue("@noseWidth", skin.noseWidth); command.Parameters.AddWithValue("@noseHeight", skin.noseHeight); command.Parameters.AddWithValue("@noseLength", skin.noseLength); command.Parameters.AddWithValue("@noseBridge", skin.noseBridge); command.Parameters.AddWithValue("@noseTip", skin.noseTip); command.Parameters.AddWithValue("@noseShift", skin.noseShift); command.Parameters.AddWithValue("@browHeight", skin.browHeight); command.Parameters.AddWithValue("@browWidth", skin.browWidth); command.Parameters.AddWithValue("@cheekboneHeight", skin.cheekboneHeight); command.Parameters.AddWithValue("@cheekboneWidth", skin.cheekboneWidth); command.Parameters.AddWithValue("@cheeksWidth", skin.cheeksWidth); command.Parameters.AddWithValue("@eyes", skin.eyes); command.Parameters.AddWithValue("@lips", skin.lips); command.Parameters.AddWithValue("@jawWidth", skin.jawWidth); command.Parameters.AddWithValue("@jawHeight", skin.jawHeight); command.Parameters.AddWithValue("@chinLength", skin.chinLength); command.Parameters.AddWithValue("@chinPosition", skin.chinPosition); command.Parameters.AddWithValue("@chinWidth", skin.chinWidth); command.Parameters.AddWithValue("@chinShape", skin.chinShape); command.Parameters.AddWithValue("@neckWidth", skin.neckWidth); command.Parameters.AddWithValue("@eyesColor", skin.eyesColor); command.Parameters.AddWithValue("@eyebrowsModel", skin.eyebrowsModel); command.Parameters.AddWithValue("@eyebrowsColor", skin.eyebrowsColor); command.Parameters.AddWithValue("@makeupModel", skin.makeupModel); command.Parameters.AddWithValue("@blushModel", skin.blushModel); command.Parameters.AddWithValue("@blushColor", skin.blushColor); command.Parameters.AddWithValue("@lipstickModel", skin.lipstickModel); command.Parameters.AddWithValue("@lipstickColor", skin.lipstickColor); command.ExecuteNonQuery(); NAPI.Util.ConsoleOutput("Character created"); player.TriggerEvent("cancelCharacterCreation2"); player.SetData(EntityData.PLAYER_TUTORIAL, 2); Globals.OnPlayerSpawn(player); } catch (Exception ex) { NAPI.Util.ConsoleOutput("[EXCEPTION CreateCharacter] " + ex.Message); NAPI.Util.ConsoleOutput("[EXCEPTION CreateCharacter] " + ex.StackTrace); player.TriggerEvent("characterNameDuplicated"); } } return playerId; } So, If `name1` already exists in the table `skins` I want that "catch (Exception ex)" gets called, where it triggers the Event "characterNameDuplicated", but Idk how I should do that. Maybe somebody here has some idea. Btw. that's the WiredPlayers-RP Gamemode from the resource on this forum here. Thanks

Hello! I made this resource, and when i enter any information in game the console says this: C:\Users\varad\Desktop\PleasantRoleplay\packages\PleasantRoleplay\user-system\Login.js:11: TypeError: Cannot read property 'query' of null db.Handle.query("SELECT * FROM accounts WHERE username = ?", username, function(e, result) { Login.js: var db = require('../mysql/Connection'); mp.events.add('playerJoin', player => { player.call('loginShowPanel'); let alpha = player.alpha; player.alpha = 0; }); mp.events.add('loginSendInformation', (player, username, password) => { db.Handle.query("SELECT * FROM accounts WHERE username = ?", username, function(e, result) { if ( result.length ) { player.call('loginClosePanel'); let alpha = player.alpha; player.alpha = 255; } else player.outputChatBox("<b style='color: red'>This Username doesn't exist!</b>"); }); }); Connection.js: var mysql = require('mysql'); module.exports = { Handle: null, Connect: function(callback) { this.Handle = mysql.createConnection({ host : 'localhost', user : 'root', password : '', database : 'pleasantroleplay' }); this.Handle.connect(function(e) { if ( !e ) { callback(); } else console.log ("DATABASE ERROR" + e); }); } }; Index.js: require('./mysql/Connection'); require('./user-system/Login.js'); I have added Mysql module through npm.

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