public static void Add(TaxCollector item)
{
try
{
MySqlCommand Command = new MySqlCommand()
{
Connection = DatabaseManager.Provider.getConnection(),
CommandText = "REPLACE INTO `taxcollector` VALUES(@guid,@map,@cell,@or,@guild,@n1,@n2,@item,@kamas,@xp);",
};
Command.Prepare();
Command.Parameters.AddWithValue("@guid", item.ActorId);
Command.Parameters.AddWithValue("@map", item.Mapid);
Command.Parameters.AddWithValue("@cell", item.CellId);
Command.Parameters.AddWithValue("@or", item.Orientation);
Command.Parameters.AddWithValue("@n1", item.N1);
Command.Parameters.AddWithValue("@guild", item.GuildID);
Command.Parameters.AddWithValue("@n2", item.N2);
Command.Parameters.AddWithValue("@item", item.getItemsId());
Command.Parameters.AddWithValue("@kamas", item.Kamas);
Command.Parameters.AddWithValue("@xp", item.XP);
Command.ExecuteNonQuery();
Cache.Add(item.ActorId, item);
}
catch (Exception e)
{
Logger.Error("Can't execute query : " + e.ToString());
}
}
public static void Update(TaxCollector item)
{
try
{
MySqlCommand Command = new MySqlCommand()
{
Connection = DatabaseManager.Provider.getConnection(),
CommandText = "UPDATE `taxcollector` set objets = @objets, kamas = @kamas, xp = @xp WHERE guid= @guid;",
};
Command.Prepare();
Command.Parameters.AddWithValue("@objets", item.getItemsId());
Command.Parameters.AddWithValue("@kamas", item.Kamas);
Command.Parameters.AddWithValue("@xp", item.XP);
Command.Parameters.AddWithValue("@guid", item.ActorId);
Command.ExecuteNonQuery();
}
catch (Exception e)
{
Logger.Error(e);
}
}
