public static SlotItem[] GetItemsForCharacter(CharacterManager.ItemType type, int? characterId = null)
{
using (var bl = Storage.GetBuilder(CharacterManager.SQLSafeName))
{
bl.SelectFrom(TableName, new string[] { "*" },
new WhereFilter(ColumnNames.TypeId, (int)type),
new WhereFilter(ColumnNames.CharacterId, characterId)
);
return Storage.ExecuteArray<SlotItem>(bl);
}
}
public static int GetItem(CharacterManager.ItemType type, int slot, int? characterId = null)
{
using (var bl = Storage.GetBuilder(CharacterManager.SQLSafeName))
{
bl.SelectFrom(TableName, new string[] { ColumnNames.Id },
new WhereFilter(ColumnNames.TypeId, (int)type),
new WhereFilter(ColumnNames.Slot, slot),
new WhereFilter(ColumnNames.CharacterId, characterId)
);
return (int)Storage.ExecuteScalar<Int32>(bl);
}
}
public static int NewItem(CharacterManager.ItemType type, int netId, int stack, int prefix, int slot, int? userId = null)
{
using (var bl = Storage.GetBuilder(CharacterManager.SQLSafeName))
{
bl.InsertInto(TableName,
new DataParameter(ColumnNames.TypeId, (int)type),
new DataParameter(ColumnNames.NetId, netId),
new DataParameter(ColumnNames.Stack, stack),
new DataParameter(ColumnNames.Prefix, prefix),
new DataParameter(ColumnNames.Slot, slot),
new DataParameter(ColumnNames.UserId, userId)
);
return (int)Storage.ExecuteInsert(bl); //Get the new ID
}
}
public static bool UpdateItem(CharacterManager.ItemType type, int netId, int prefix, int stack, bool favorite, int slot, int? characterId = null)
{
using (var bl = Storage.GetBuilder(CharacterManager.SQLSafeName))
{
bl.Update(TableName, new DataParameter[]
{
new DataParameter(ColumnNames.NetId, netId),
new DataParameter(ColumnNames.Prefix, prefix),
new DataParameter(ColumnNames.Stack, stack),
new DataParameter(ColumnNames.Favorite, favorite)
},
new WhereFilter(ColumnNames.TypeId, (int)type),
new WhereFilter(ColumnNames.Slot, slot),
new WhereFilter(ColumnNames.CharacterId, characterId)
);
return Storage.ExecuteNonQuery(bl) > 0;
}
}
