public void SetWardrobeSlot(SqlDatabaseClient MySqlClient, int SlotId, string Figure, CharacterGender Gender)
{
lock (mWardrobe)
{
WardrobeItem Item = new WardrobeItem(Figure, Gender);
MySqlClient.SetParameter("userid", mId);
MySqlClient.SetParameter("slotid", SlotId);
MySqlClient.SetParameter("figure", Figure);
MySqlClient.SetParameter("gender", Gender == CharacterGender.Male ? "M" : "F");
if (!mWardrobe.ContainsKey(SlotId))
{
mWardrobe.Add(SlotId, Item);
MySqlClient.ExecuteNonQuery("INSERT INTO wardrobe (user_id,slot_id,figure,gender) VALUES (@userid,@slotid,@figure,@gender)");
return;
}
mWardrobe[SlotId] = Item;
MySqlClient.ExecuteNonQuery("UPDATE wardrobe SET figure = @figure, gender = @gender WHERE user_id = @userid AND slot_id = @slotid LIMIT 1");
}
}
public void SetWardrobeSlot(SqlDatabaseClient MySqlClient, int SlotId, string Figure, CharacterGender Gender)
{
lock (mWardrobe)
{
WardrobeItem Item = new WardrobeItem(Figure, Gender);
MySqlClient.SetParameter("userid", mId);
MySqlClient.SetParameter("slotid", SlotId);
MySqlClient.SetParameter("figure", Figure);
MySqlClient.SetParameter("gender", Gender == CharacterGender.Male ? "M" : "F");
if (!mWardrobe.ContainsKey(SlotId))
{
mWardrobe.Add(SlotId, Item);
MySqlClient.ExecuteNonQuery("INSERT INTO wardrobe (user_id,slot_id,figure,gender) VALUES (@userid,@slotid,@figure,@gender)");
return;
}
mWardrobe[SlotId] = Item;
MySqlClient.ExecuteNonQuery("UPDATE wardrobe SET figure = @figure, gender = @gender WHERE user_id = @userid AND slot_id = @slotid LIMIT 1");
}
}
