1. Hey all, im getting a error i cant fix when fetching a user ID from a MySQL database. Yes the connection / creation of the database is fine. The error i am getting is as follows. Any help is appreciated ;)

    Code:
            void OnPlayerConnected(Network.Message packet)
            {
                var player = packet.connection.player as BasePlayer;
                var sql2 = Core.Database.Sql.Builder.Append(createQuery);
                sql2 = Core.Database.Sql.Builder.Append(SelectData);
                _mySql.Query(sql2, _mySqlConnection, list =>
                {
                    if (list == null) return;
                    var userid = player.UserIDString;
                    foreach (var entry in list)
                    {
                        string steamid = (string)entry["userid"];
                        if(steamid != player.UserIDString)
                        {
                         Puts("Yeet");
                        }
                    }
                });
            }
    
    Code:
    MySql command callback raised an exception (NullReferenceException: Object reference not set to an instance of an object)
      at Oxide.Plugins.MySQLPlugin+<OnPlayerConnected>c__AnonStorey0.<>m__0 (System.Collections.Generic.List`1 list) [0x00000] in <filename unknown>:0
      at Oxide.Core.MySql.Libraries.MySql+MySqlQuery+<>c__DisplayClass24_0.<Handle>b__0 () [0x00000] in <filename unknown>:0
    
     

    Attached Files:

  2. Anyone?
     
  3. You can take userID without casting connection.player to BasePlayer, just use connection.userid
    I bet null is connection.player, because OnPlayerConnected calls before player is spawned.