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();
}
