ZenzCode Posted July 8, 2019 Share Posted July 8, 2019 So I started a script today, and I wanted to add the MySQL. So the problem is, that i get this Unhandled Exception: System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.IO.FileNotFoundException: Could not load file or assembly 'System.Data.Common, Version=4.2.1.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a'. The system cannot find the file specified. at bool RPGerman.RPGerman.Database.PlayerDatabase.isPlayerWhitelisted(Client player) at void RPGerman.RPGerman.Main.PlayerConnected(Client player) in /opt/server/ragemp-srv_new_037/C:\Users\Eric\Desktop\RPGerman\bridge\resources\RPGerman\RPGerman\RPGerman\RPGerman\Main.cs:line 26 --- End of inner exception stack trace --- at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor) at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments) at GTANetworkInternals.EventHandler.Parse(Event _event, Object[] arguments) at Bootstrapper.EventInternalClass.OnPlayerReady(UInt16 playerId) Aborted Error every time I join, because we check for the whitelist. Here is the code PlayerDatabase: using System; using System.Data.Common; using MySql.Data.MySqlClient; using GTANetworkAPI; namespace RPGerman.RPGerman.Database { class PlayerDatabase { public static string myConnectionString = "SERVER=censored;" + "DATABASE=censored;" + "UID=censored" + "PASSWORD=" + Main.databasePW + ";"; public static MySqlConnection connection; public static MySqlCommand command; public static MySqlDataReader reader; //SERVER VALUES private static int startgeld = 25000; public static bool isPlayerWhitelisted(Client player) { connection = new MySqlConnection(myConnectionString); connection.Open(); command = connection.CreateCommand(); command.CommandText = "SELECT * FROM whitelist WHERE socialclub = @socialclub"; command.Parameters.AddWithValue("@socialclub", player.SocialClubName); reader = command.ExecuteReader(); while(reader.Read()) { string SocialClubName = reader.GetString("socialclub"); if(SocialClubName == player.SocialClubName) { connection.Close(); return true; } } connection.Close(); return false; } } } JoinEvent: [ServerEvent(Event.PlayerConnected)] public void PlayerConnected(Client player) { if(PlayerDatabase.isPlayerWhitelisted(player)) { //do smthg }else{ player.Kick("~r~Du bist nicht auf der Whitelist."); } } Any ideas? Link to comment Share on other sites More sharing options...
Division Posted July 12, 2019 Share Posted July 12, 2019 nothing to do with ur function System.IO.FileNotFoundException: Could not load file or assembly 'System.Data.Common, Version=4.2.1.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a'. The system cannot find the file specified. add this file to runtime folder 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