public UnturnedPlayerInventoryPage(UnturnedPlayerInventory inventory, byte pageIndex, SDG.Unturned.Items page) { Inventory = inventory; Page = page; PageIndex = pageIndex; }
public void PlayerConnect(Rocket.Unturned.Player.UnturnedPlayer pPlayer) { MySqlConnection connection = createConnection(); MySqlCommand command = connection.CreateCommand(); connection.Open(); ////////////////// command.CommandText = "select * from `itemlist` WHERE `steamId`='" + pPlayer.CSteamID.ToString() + "';"; SDG.Unturned.Items ItemListN = new SDG.Unturned.Items(0); MySqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { SDG.Unturned.Item NItem = new SDG.Unturned.Item(ushort.Parse((string)reader["id"], CultureInfo.InvariantCulture), 1, (byte)(int)reader["quality"]); NItem.durability = (byte)(int)reader["durability"]; ItemListN.addItem((byte)(int)reader["x"], (byte)(int)reader["y"], (byte)(int)reader["rot"], NItem); SDG.Unturned.ItemAsset ia = (SDG.Unturned.ItemAsset)SDG.Unturned.Assets.find(SDG.Unturned.EAssetType.ITEM, NItem.id); int metadataSize = reader.GetInt32("data_size"); if (metadataSize > 0) { byte[] metadata = new byte[metadataSize]; reader.GetBytes(reader.GetOrdinal("data"), 0, metadata, 0, metadataSize); NItem.metadata = metadata; } } reader.Close(); command.CommandText = "select * from `vaults`;"; SDG.Unturned.Barricade NewBarricade = new SDG.Unturned.Barricade(366); UnityEngine.Transform NewBTransform = SDG.Unturned.BarricadeManager.dropBarricade(NewBarricade, null, new UnityEngine.Vector3(-20, -20, -20), 0, 0, 0, ulong.Parse(pPlayer.Id), 29832); reader = command.ExecuteReader(); while (reader.Read()) { if ((string)reader["steamId"] == pPlayer.CSteamID.ToString()) { //Create new vaultstorage in home list Uber_VaultS.vaultList.Add(new VaultStorage() { SizeX = (int)reader["sizex"], SizeY = (int)reader["sizey"], Player = pPlayer, SteamID = pPlayer.CSteamID, Locker = NewBTransform, alreadyOpened = false, ItemList = ItemListN }); reader.Close(); connection.Close(); return; } } reader.Close(); ////////////////// ////////////////// ////////////////// ////////////////// ////////////////// ////////////////// //In this case, no vault was found to be saved. Need to make a vault and push to db command.CommandText = "INSERT INTO `vaults` (`steamId`, `sizex`, `sizey`) VALUES ('" + pPlayer.CSteamID.ToString() + "', '3', '2');"; command.ExecuteScalar(); { Uber_VaultS.vaultList.Add(new VaultStorage() { SizeX = 3, SizeY = 2, Player = pPlayer, SteamID = pPlayer.CSteamID, Locker = NewBTransform, alreadyOpened = false }); } ////////////////// connection.Close(); }