public static Dictionary <string, CraftingRecipe> ReadCraftingRecipes(CraftingTable table)
{
Dictionary <string, CraftingRecipe> recipes = new Dictionary <string, CraftingRecipe>();
using (DatabaseConnection dbClient = Alias.Server.DatabaseManager.GetConnection())
{
dbClient.AddParameter("id", table.Id);
using (MySqlDataReader Reader = dbClient.DataReader("SELECT * FROM `crafting_recipes` WHERE `table_id` = @id AND `enabled` = '1'"))
{
while (Reader.Read())
{
ItemData item = Alias.Server.ItemManager.GetItemData(Reader.GetInt32("reward"));
if (item != null)
{
CraftingRecipe recipe = new CraftingRecipe
{
Id = Reader.GetInt32("id"),
Reward = item,
Secret = DatabaseBoolean.GetBoolFromString(Reader.GetString("secret"))
};
recipe.Ingredients = ReadRecipeIngredients(recipe.Id, table);
recipes.Add(recipe.Reward.Name, recipe);
}
}
}
}
return(recipes);
}
public static void UpdateBot(RoomEntity bot)
{
using (DatabaseConnection dbClient = Alias.Server.DatabaseManager.GetConnection())
{
dbClient.AddParameter("botId", bot.Id);
dbClient.AddParameter("look", bot.Look);
dbClient.AddParameter("gender", bot.Gender);
dbClient.AddParameter("name", bot.Name);
dbClient.AddParameter("danceId", bot.DanceId);
dbClient.AddParameter("effectId", bot.EffectId);
dbClient.AddParameter("canWalk", DatabaseBoolean.GetStringFromBool(bot.CanWalk));
dbClient.Query("UPDATE `bots` SET `name` = @name, `look` = @look, `gender` = @gender, `dance_id` = @danceId, `effect_id` = @effectId, `can_walk` = @canWalk WHERE `id` = @botId");
}
}
public static void SaveRoom(RoomData data)
{
using (DatabaseConnection dbClient = Alias.Server.DatabaseManager.GetConnection())
{
dbClient.AddParameter("id", data.Id);
dbClient.AddParameter("name", data.Name);
dbClient.AddParameter("ownerId", data.OwnerId);
dbClient.AddParameter("door", (int)data.DoorState + "");
dbClient.AddParameter("maxusers", data.MaxUsers);
dbClient.AddParameter("description", data.Description);
dbClient.AddParameter("trade", (int)data.TradeState + "");
dbClient.AddParameter("ranking", data.Rankings);
dbClient.AddParameter("category", data.Category);
dbClient.AddParameter("image", data.Image);
dbClient.AddParameter("password", data.Password);
dbClient.AddParameter("model", data.ModelName);
dbClient.Query("UPDATE `room_data` SET `name` = @name, `owner` = @ownerId, `door` = @door, `max_users` = @maxusers, " +
"`description` = @description, `trade` = @trade, `ranking` = @ranking, `category` = @category, " +
"`image` = @image, `password` = @password, `model` = @model WHERE `id` = @id");
dbClient.AddParameter("id", data.Id);
dbClient.AddParameter("mute", data.Settings.WhoMutes);
dbClient.AddParameter("kick", data.Settings.WhoKicks);
dbClient.AddParameter("ban", data.Settings.WhoBans);
dbClient.AddParameter("chatmode", data.Settings.ChatMode);
dbClient.AddParameter("chatsize", data.Settings.ChatSize);
dbClient.AddParameter("chatspeed", data.Settings.ChatSpeed);
dbClient.AddParameter("chatflood", data.Settings.ChatFlood);
dbClient.AddParameter("chatdistance", data.Settings.ChatDistance);
dbClient.AddParameter("allowpets", DatabaseBoolean.GetStringFromBool(data.Settings.AllowPets));
dbClient.AddParameter("allowpetseat", DatabaseBoolean.GetStringFromBool(data.Settings.AllowPetsEat));
dbClient.AddParameter("roomblocking", DatabaseBoolean.GetStringFromBool(data.Settings.RoomBlocking));
dbClient.AddParameter("hidewalls", DatabaseBoolean.GetStringFromBool(data.Settings.HideWalls));
dbClient.AddParameter("wallheight", data.Settings.WallHeight);
dbClient.AddParameter("floorsize", data.Settings.FloorSize);
dbClient.Query("UPDATE `room_settings` SET `who_can_mute` = @mute, `who_can_kick` = @kick, `who_can_ban` = @ban, `chat_mode` = @chatmode, " +
"`chat_size` = @chatsize, `chat_speed` = @chatspeed, `chat_flood` = @chatflood, `chat_distance` = @chatdistance, " +
"`allow_pets` = @allowpets, `allow_pets_eat` = @allowpetseat, `room_blocking` = @roomblocking, `hide_walls` = @hidewalls, " +
"`wall_height` = @wallheight, `floor_size` = @floorsize WHERE `id` = @id");
}
}
