/// <summary> /// Copies the column values into the given DbParameterValues using the database column name /// with a prefixed @ as the key. The keys must already exist in the DbParameterValues; /// this method will not create them if they are missing. /// </summary> /// <param name="source">The object to copy the values from.</param> /// <param name="paramValues">The DbParameterValues to copy the values into.</param> public static void CopyValues(this IGuildTable source, DbParameterValues paramValues) { paramValues["created"] = source.Created; paramValues["id"] = (UInt16)source.ID; paramValues["name"] = source.Name; paramValues["tag"] = source.Tag; }
/// <summary> /// Copies the column values into the given DbParameterValues using the database column name /// with a prefixed @ as the key. The keys must already exist in the DbParameterValues; /// this method will not create them if they are missing. /// </summary> /// <param name="source">The object to copy the values from.</param> /// <param name="paramValues">The DbParameterValues to copy the values into.</param> public static void CopyValues(this ICharacterTemplateTable source, DbParameterValues paramValues) { paramValues["ai_id"] = (ushort?)source.AIID; paramValues["alliance_id"] = (Byte)source.AllianceID; paramValues["body_id"] = (UInt16)source.BodyID; paramValues["chat_dialog"] = (ushort?)source.ChatDialog; paramValues["exp"] = source.Exp; paramValues["give_cash"] = source.GiveCash; paramValues["give_exp"] = source.GiveExp; paramValues["id"] = (UInt16)source.ID; paramValues["level"] = source.Level; paramValues["move_speed"] = source.MoveSpeed; paramValues["name"] = source.Name; paramValues["respawn"] = source.Respawn; paramValues["shop_id"] = (ushort?)source.ShopID; paramValues["statpoints"] = source.StatPoints; paramValues["stat_agi"] = (Int16)source.GetStat(StatType.Agi); paramValues["stat_defence"] = (Int16)source.GetStat(StatType.Defence); paramValues["stat_int"] = (Int16)source.GetStat(StatType.Int); paramValues["stat_maxhit"] = (Int16)source.GetStat(StatType.MaxHit); paramValues["stat_maxhp"] = (Int16)source.GetStat(StatType.MaxHP); paramValues["stat_maxmp"] = (Int16)source.GetStat(StatType.MaxMP); paramValues["stat_minhit"] = (Int16)source.GetStat(StatType.MinHit); paramValues["stat_str"] = (Int16)source.GetStat(StatType.Str); }
/// <summary> /// Copies the column values into the given DbParameterValues using the database column name /// with a prefixed @ as the key. The keys must already exist in the DbParameterValues; /// this method will not create them if they are missing. /// </summary> /// <param name="source">The object to copy the values from.</param> /// <param name="paramValues">The DbParameterValues to copy the values into.</param> public static void CopyValues(this ICharacterQuestStatusTable source, DbParameterValues paramValues) { paramValues["character_id"] = (Int32)source.CharacterID; paramValues["completed_on"] = source.CompletedOn; paramValues["quest_id"] = (UInt16)source.QuestID; paramValues["started_on"] = source.StartedOn; }
/// <summary> /// Copies the column values into the given DbParameterValues using the database column name /// with a prefixed @ as the key. The keys must already exist in the DbParameterValues; /// this method will not create them if they are missing. /// </summary> /// <param name="source">The object to copy the values from.</param> /// <param name="paramValues">The DbParameterValues to copy the values into.</param> public static void CopyValues(this IItemTable source, DbParameterValues paramValues) { paramValues["action_display_id"] = (ushort?)source.ActionDisplayID; paramValues["amount"] = source.Amount; paramValues["description"] = source.Description; paramValues["equipped_body"] = source.EquippedBody; paramValues["graphic"] = (UInt16)source.Graphic; paramValues["height"] = source.Height; paramValues["hp"] = (Int16)source.HP; paramValues["id"] = (Int32)source.ID; paramValues["item_template_id"] = (ushort?)source.ItemTemplateID; paramValues["mp"] = (Int16)source.MP; paramValues["name"] = source.Name; paramValues["range"] = source.Range; paramValues["stat_agi"] = (Int16)source.GetStat(StatType.Agi); paramValues["stat_defence"] = (Int16)source.GetStat(StatType.Defence); paramValues["stat_int"] = (Int16)source.GetStat(StatType.Int); paramValues["stat_maxhit"] = (Int16)source.GetStat(StatType.MaxHit); paramValues["stat_maxhp"] = (Int16)source.GetStat(StatType.MaxHP); paramValues["stat_maxmp"] = (Int16)source.GetStat(StatType.MaxMP); paramValues["stat_minhit"] = (Int16)source.GetStat(StatType.MinHit); paramValues["stat_req_agi"] = (Int16)source.GetReqStat(StatType.Agi); paramValues["stat_req_int"] = (Int16)source.GetReqStat(StatType.Int); paramValues["stat_req_str"] = (Int16)source.GetReqStat(StatType.Str); paramValues["stat_str"] = (Int16)source.GetStat(StatType.Str); paramValues["type"] = (Byte)source.Type; paramValues["value"] = source.Value; paramValues["weapon_type"] = (Byte)source.WeaponType; paramValues["width"] = source.Width; }
/// <summary> /// Copies the column values into the given DbParameterValues using the database column name /// with a prefixed @ as the key. The keys must already exist in the DbParameterValues; /// this method will not create them if they are missing. /// </summary> /// <param name="source">The object to copy the values from.</param> /// <param name="paramValues">The DbParameterValues to copy the values into.</param> public static void CopyValues(this ICharacterTemplateEquippedTable source, DbParameterValues paramValues) { paramValues["chance"] = (UInt16)source.Chance; paramValues["character_template_id"] = (UInt16)source.CharacterTemplateID; paramValues["id"] = source.ID; paramValues["item_template_id"] = (UInt16)source.ItemTemplateID; }
/// <summary> /// When overridden in the derived class, sets the database parameters values <paramref name="p"/> /// based on the values specified in the given <paramref name="item"/> parameter. /// </summary> /// <param name="p">Collection of database parameters to set the values for.</param> /// <param name="item">The value or object/struct containing the values used to execute the query.</param> protected override void SetParameters(DbParameterValues p, QueryArgs item) { p["accountID"] = (int)item.AccountID; p["secs"] = item.Secs; p["reason"] = item.Reason; p["issuedBy"] = item.IssuedBy; }
/// <summary> /// Copies the column values into the given DbParameterValues using the database column name /// with a prefixed @ as the key. The keys must already exist in the DbParameterValues; /// this method will not create them if they are missing. /// </summary> /// <param name="source">The object to copy the values from.</param> /// <param name="paramValues">The DbParameterValues to copy the values into.</param> public static void CopyValues(this IViewUserCharacterTable source, DbParameterValues paramValues) { paramValues["ai_id"] = (ushort?)source.AIID; paramValues["body_id"] = (UInt16)source.BodyID; paramValues["cash"] = source.Cash; paramValues["character_template_id"] = (ushort?)source.CharacterTemplateID; paramValues["chat_dialog"] = (ushort?)source.ChatDialog; paramValues["exp"] = source.Exp; paramValues["hp"] = (Int16)source.HP; paramValues["id"] = source.ID; paramValues["level"] = source.Level; paramValues["load_map_id"] = (UInt16)source.LoadMapID; paramValues["load_x"] = source.LoadX; paramValues["load_y"] = source.LoadY; paramValues["move_speed"] = source.MoveSpeed; paramValues["mp"] = (Int16)source.MP; paramValues["name"] = source.Name; paramValues["respawn_map_id"] = (ushort?)source.RespawnMapID; paramValues["respawn_x"] = source.RespawnX; paramValues["respawn_y"] = source.RespawnY; paramValues["shop_id"] = (ushort?)source.ShopID; paramValues["statpoints"] = source.StatPoints; paramValues["stat_agi"] = source.StatAgi; paramValues["stat_defence"] = source.StatDefence; paramValues["stat_int"] = source.StatInt; paramValues["stat_maxhit"] = source.StatMaxhit; paramValues["stat_maxhp"] = source.StatMaxhp; paramValues["stat_maxmp"] = source.StatMaxmp; paramValues["stat_minhit"] = source.StatMinhit; paramValues["stat_str"] = source.StatStr; }
/// <summary> /// When overridden in the derived class, sets the database parameters values <paramref name="p"/> /// based on the values specified in the given <paramref name="item"/> parameter. /// </summary> /// <param name="p">Collection of database parameters to set the values for.</param> /// <param name="item">The value or object/struct containing the values used to execute the query.</param> protected override void SetParameters(DbParameterValues p, QueryArgs item) { p["name"] = item.Name; p["password"] = item.Password; p["email"] = item.Email; p["creator_ip"] = item.IP; }
/// <summary> /// Copies the column values into the given DbParameterValues using the database column name /// with a prefixed @ as the key. The key must already exist in the DbParameterValues /// for the value to be copied over. If any of the keys in the DbParameterValues do not /// match one of the column names, or if there is no field for a key, then it will be /// ignored. Because of this, it is important to be careful when using this method /// since columns or keys can be skipped without any indication. /// </summary> /// <param name="source">The object to copy the values from.</param> /// <param name="paramValues">The DbParameterValues to copy the values into.</param> public static void TryCopyValues(this ICharacterStatusEffectTable source, DbParameterValues paramValues) { for (var i = 0; i < paramValues.Count; i++) { switch (paramValues.GetParameterName(i)) { case "character_id": paramValues[i] = (Int32)source.CharacterID; break; case "id": paramValues[i] = (Int32)source.ID; break; case "power": paramValues[i] = source.Power; break; case "status_effect_id": paramValues[i] = (Byte)source.StatusEffect; break; case "time_left_secs": paramValues[i] = source.TimeLeftSecs; break; } } }
/// <summary> /// Copies the column values into the given DbParameterValues using the database column name /// with a prefixed @ as the key. The keys must already exist in the DbParameterValues; /// this method will not create them if they are missing. /// </summary> /// <param name="source">The object to copy the values from.</param> /// <param name="paramValues">The DbParameterValues to copy the values into.</param> public static void CopyValues(this ICharacterQuestStatusKillsTable source, DbParameterValues paramValues) { paramValues["character_id"] = (Int32)source.CharacterID; paramValues["character_template_id"] = (UInt16)source.CharacterTemplateID; paramValues["count"] = source.Count; paramValues["quest_id"] = (UInt16)source.QuestID; }
/// <summary> /// Copies the column values into the given DbParameterValues using the database column name /// with a prefixed @ as the key. The keys must already exist in the DbParameterValues; /// this method will not create them if they are missing. /// </summary> /// <param name="source">The object to copy the values from.</param> /// <param name="paramValues">The DbParameterValues to copy the values into.</param> public static void CopyValues(this ICharacterTable source, DbParameterValues paramValues) { paramValues["ai_id"] = (ushort?)source.AIID; paramValues["body_id"] = (UInt16)source.BodyID; paramValues["cash"] = source.Cash; paramValues["character_template_id"] = (ushort?)source.CharacterTemplateID; paramValues["chat_dialog"] = (ushort?)source.ChatDialog; paramValues["exp"] = source.Exp; paramValues["hp"] = (Int16)source.HP; paramValues["id"] = (Int32)source.ID; paramValues["level"] = source.Level; paramValues["load_map_id"] = (UInt16)source.LoadMapID; paramValues["load_x"] = source.LoadX; paramValues["load_y"] = source.LoadY; paramValues["move_speed"] = source.MoveSpeed; paramValues["mp"] = (Int16)source.MP; paramValues["name"] = source.Name; paramValues["respawn_map_id"] = (ushort?)source.RespawnMapID; paramValues["respawn_x"] = source.RespawnX; paramValues["respawn_y"] = source.RespawnY; paramValues["shop_id"] = (ushort?)source.ShopID; paramValues["statpoints"] = source.StatPoints; paramValues["stat_agi"] = (Int16)source.GetStat(StatType.Agi); paramValues["stat_defence"] = (Int16)source.GetStat(StatType.Defence); paramValues["stat_int"] = (Int16)source.GetStat(StatType.Int); paramValues["stat_maxhit"] = (Int16)source.GetStat(StatType.MaxHit); paramValues["stat_maxhp"] = (Int16)source.GetStat(StatType.MaxHP); paramValues["stat_maxmp"] = (Int16)source.GetStat(StatType.MaxMP); paramValues["stat_minhit"] = (Int16)source.GetStat(StatType.MinHit); paramValues["stat_str"] = (Int16)source.GetStat(StatType.Str); }
/// <summary> /// Copies the column values into the given DbParameterValues using the database column name /// with a prefixed @ as the key. The keys must already exist in the DbParameterValues; /// this method will not create them if they are missing. /// </summary> /// <param name="source">The object to copy the values from.</param> /// <param name="paramValues">The DbParameterValues to copy the values into.</param> public static void CopyValues(this IAccountIpsTable source, DbParameterValues paramValues) { paramValues["account_id"] = (Int32)source.AccountID; paramValues["id"] = source.ID; paramValues["ip"] = source.Ip; paramValues["time"] = source.Time; }
/// <summary> /// Copies the column values into the given DbParameterValues using the database column name /// with a prefixed @ as the key. The keys must already exist in the DbParameterValues; /// this method will not create them if they are missing. /// </summary> /// <param name="source">The object to copy the values from.</param> /// <param name="paramValues">The DbParameterValues to copy the values into.</param> public static void CopyValues(this IWorldStatsGuildUserChangeTable source, DbParameterValues paramValues) { paramValues["guild_id"] = (ushort?)source.GuildID; paramValues["id"] = source.ID; paramValues["user_id"] = (Int32)source.UserID; paramValues["when"] = source.When; }
/// <summary> /// Copies the column values into the given DbParameterValues using the database column name /// with a prefixed @ as the key. The keys must already exist in the DbParameterValues; /// this method will not create them if they are missing. /// </summary> /// <param name="source">The object to copy the values from.</param> /// <param name="paramValues">The DbParameterValues to copy the values into.</param> public static void CopyValues(this IItemTemplateTable source, DbParameterValues paramValues) { paramValues["action_display_id"] = (ushort?)source.ActionDisplayID; paramValues["description"] = source.Description; paramValues["equipped_body"] = source.EquippedBody; paramValues["graphic"] = (UInt16)source.Graphic; paramValues["height"] = source.Height; paramValues["hp"] = (Int16)source.HP; paramValues["id"] = (UInt16)source.ID; paramValues["mp"] = (Int16)source.MP; paramValues["name"] = source.Name; paramValues["range"] = source.Range; paramValues["stat_agi"] = (Int16)source.GetStat(StatType.Agi); paramValues["stat_defence"] = (Int16)source.GetStat(StatType.Defence); paramValues["stat_int"] = (Int16)source.GetStat(StatType.Int); paramValues["stat_maxhit"] = (Int16)source.GetStat(StatType.MaxHit); paramValues["stat_maxhp"] = (Int16)source.GetStat(StatType.MaxHP); paramValues["stat_maxmp"] = (Int16)source.GetStat(StatType.MaxMP); paramValues["stat_minhit"] = (Int16)source.GetStat(StatType.MinHit); paramValues["stat_req_agi"] = (Int16)source.GetReqStat(StatType.Agi); paramValues["stat_req_int"] = (Int16)source.GetReqStat(StatType.Int); paramValues["stat_req_str"] = (Int16)source.GetReqStat(StatType.Str); paramValues["stat_str"] = (Int16)source.GetStat(StatType.Str); paramValues["type"] = (Byte)source.Type; paramValues["value"] = source.Value; paramValues["weapon_type"] = (Byte)source.WeaponType; paramValues["width"] = source.Width; }
/// <summary> /// Copies the column values into the given DbParameterValues using the database column name /// with a prefixed @ as the key. The keys must already exist in the DbParameterValues; /// this method will not create them if they are missing. /// </summary> /// <param name="source">The object to copy the values from.</param> /// <param name="paramValues">The DbParameterValues to copy the values into.</param> public static void CopyValues(this IGuildMemberTable source, DbParameterValues paramValues) { paramValues["character_id"] = (Int32)source.CharacterID; paramValues["guild_id"] = (UInt16)source.GuildID; paramValues["joined"] = source.Joined; paramValues["rank"] = (Byte)source.Rank; }
/// <summary> /// Copies the column values into the given DbParameterValues using the database column name /// with a prefixed @ as the key. The keys must already exist in the DbParameterValues; /// this method will not create them if they are missing. /// </summary> /// <param name="source">The object to copy the values from.</param> /// <param name="paramValues">The DbParameterValues to copy the values into.</param> public static void CopyValues(this IWorldStatsCountUserKillNpcTable source, DbParameterValues paramValues) { paramValues["count"] = source.Count; paramValues["last_update"] = source.LastUpdate; paramValues["npc_template_id"] = (UInt16)source.NPCTemplateID; paramValues["user_id"] = (Int32)source.UserID; }
/// <summary> /// Copies the column values into the given DbParameterValues using the database column name /// with a prefixed @ as the key. The keys must already exist in the DbParameterValues; /// this method will not create them if they are missing. /// </summary> /// <param name="source">The object to copy the values from.</param> /// <param name="paramValues">The DbParameterValues to copy the values into.</param> public static void CopyValues(this IQuestTable source, DbParameterValues paramValues) { paramValues["id"] = (UInt16)source.ID; paramValues["repeatable"] = source.Repeatable; paramValues["reward_cash"] = source.RewardCash; paramValues["reward_exp"] = source.RewardExp; }
/// <summary> /// Copies the column values into the given DbParameterValues using the database column name /// with a prefixed @ as the key. The keys must already exist in the DbParameterValues; /// this method will not create them if they are missing. /// </summary> /// <param name="source">The object to copy the values from.</param> /// <param name="paramValues">The DbParameterValues to copy the values into.</param> public static void CopyValues(this IWorldStatsCountNpcKillUserTable source, DbParameterValues paramValues) { paramValues["count"] = source.Count; paramValues["last_update"] = source.LastUpdate; paramValues["npc_template_id"] = (UInt16)source.NPCTemplateID; paramValues["user_id"] = (Int32)source.UserID; }
/// <summary> /// When overridden in the derived class, sets the database parameters values <paramref name="p"/> /// based on the values specified in the given <paramref name="item"/> parameter. /// </summary> /// <param name="p">Collection of database parameters to set the values for.</param> /// <param name="item">The value or object/struct containing the values used to execute the query.</param> protected override void SetParameters(DbParameterValues p, IWorldStatsUserConsumeItemTable item) { item.CopyValues(p); // Set the `when` field to null to ensure that the time is assigned by MySQL p["when"] = null; }
/// <summary> /// Copies the column values into the given DbParameterValues using the database column name /// with a prefixed @ as the key. The keys must already exist in the DbParameterValues; /// this method will not create them if they are missing. /// </summary> /// <param name="source">The object to copy the values from.</param> /// <param name="paramValues">The DbParameterValues to copy the values into.</param> public static void CopyValues(this ICharacterStatusEffectTable source, DbParameterValues paramValues) { paramValues["character_id"] = (Int32)source.CharacterID; paramValues["id"] = (Int32)source.ID; paramValues["power"] = source.Power; paramValues["status_effect_id"] = (Byte)source.StatusEffect; paramValues["time_left_secs"] = source.TimeLeftSecs; }
/// <summary> /// When overridden in the derived class, sets the database parameters based on the specified characterID. /// </summary> /// <param name="p">Collection of database parameters to set the values for.</param> /// <param name="item">Item used to execute the query.</param> protected override void SetParameters(DbParameterValues p, QueryArgs item) { p["character_id"] = (int)item.CharacterID; p["slot"] = (int)item.Slot; Debug.Assert(Convert.ToInt32(p["slot"]) == (int)item.Slot); Debug.Assert(Convert.ToInt32(p["character_id"]) == (int)item.CharacterID); }
/// <summary> /// Copies the column values into the given DbParameterValues using the database column name /// with a prefixed @ as the key. The keys must already exist in the DbParameterValues; /// this method will not create them if they are missing. /// </summary> /// <param name="source">The object to copy the values from.</param> /// <param name="paramValues">The DbParameterValues to copy the values into.</param> public static void CopyValues(this ICharacterTemplateInventoryTable source, DbParameterValues paramValues) { paramValues["chance"] = (UInt16)source.Chance; paramValues["character_template_id"] = (UInt16)source.CharacterTemplateID; paramValues["id"] = source.ID; paramValues["item_template_id"] = (UInt16)source.ItemTemplateID; paramValues["max"] = source.Max; paramValues["min"] = source.Min; }
/// <summary> /// Copies the column values into the given DbParameterValues using the database column name /// with a prefixed @ as the key. The keys must already exist in the DbParameterValues; /// this method will not create them if they are missing. /// </summary> /// <param name="source">The object to copy the values from.</param> /// <param name="paramValues">The DbParameterValues to copy the values into.</param> public static void CopyValues(this IWorldStatsUserConsumeItemTable source, DbParameterValues paramValues) { paramValues["id"] = source.ID; paramValues["item_template_id"] = (UInt16)source.ItemTemplateID; paramValues["map_id"] = (ushort?)source.MapID; paramValues["user_id"] = (Int32)source.UserID; paramValues["when"] = source.When; paramValues["x"] = source.X; paramValues["y"] = source.Y; }
/// <summary> /// Copies the column values into the given DbParameterValues using the database column name /// with a prefixed @ as the key. The keys must already exist in the DbParameterValues; /// this method will not create them if they are missing. /// </summary> /// <param name="source">The object to copy the values from.</param> /// <param name="paramValues">The DbParameterValues to copy the values into.</param> public static void CopyValues(this IAccountBanTable source, DbParameterValues paramValues) { paramValues["account_id"] = (Int32)source.AccountID; paramValues["end_time"] = source.EndTime; paramValues["expired"] = source.Expired; paramValues["id"] = source.ID; paramValues["issued_by"] = source.IssuedBy; paramValues["reason"] = source.Reason; paramValues["start_time"] = source.StartTime; }
/// <summary> /// Copies the column values into the given DbParameterValues using the database column name /// with a prefixed @ as the key. The keys must already exist in the DbParameterValues; /// this method will not create them if they are missing. /// </summary> /// <param name="source">The object to copy the values from.</param> /// <param name="paramValues">The DbParameterValues to copy the values into.</param> public static void CopyValues(this IWorldStatsUserLevelTable source, DbParameterValues paramValues) { paramValues["character_id"] = (Int32)source.CharacterID; paramValues["id"] = source.ID; paramValues["level"] = source.Level; paramValues["map_id"] = (ushort?)source.MapID; paramValues["when"] = source.When; paramValues["x"] = source.X; paramValues["y"] = source.Y; }
/// <summary> /// Copies the column values into the given DbParameterValues using the database column name /// with a prefixed @ as the key. The keys must already exist in the DbParameterValues; /// this method will not create them if they are missing. /// </summary> /// <param name="source">The object to copy the values from.</param> /// <param name="paramValues">The DbParameterValues to copy the values into.</param> public static void CopyValues(this IWorldStatsQuestCancelTable source, DbParameterValues paramValues) { paramValues["id"] = source.ID; paramValues["map_id"] = (ushort?)source.MapID; paramValues["quest_id"] = (UInt16)source.QuestID; paramValues["user_id"] = (Int32)source.UserID; paramValues["when"] = source.When; paramValues["x"] = source.X; paramValues["y"] = source.Y; }
/// <summary> /// When overridden in the derived class, sets the database parameters values <paramref name="p"/> /// based on the values specified in the given <paramref name="item"/> parameter. /// </summary> /// <param name="p">Collection of database parameters to set the values for.</param> /// <param name="item">The value or object/struct containing the values used to execute the query.</param> protected override void SetParameters(DbParameterValues p, QueryArgs item) { p["guild_id"] = (int)item.GuildID; p["character_id"] = (int)item.CharacterID; p["target_character_id"] = (int?)item.TargetID; p["event_id"] = item.EventID; p["arg0"] = item.Arg0; p["arg1"] = item.Arg1; p["arg2"] = item.Arg2; }
/// <summary> /// Copies the column values into the given DbParameterValues using the database column name /// with a prefixed @ as the key. The keys must already exist in the DbParameterValues; /// this method will not create them if they are missing. /// </summary> /// <param name="source">The object to copy the values from.</param> /// <param name="paramValues">The DbParameterValues to copy the values into.</param> public static void CopyValues(this IMapSpawnTable source, DbParameterValues paramValues) { paramValues["amount"] = source.Amount; paramValues["character_template_id"] = (UInt16)source.CharacterTemplateID; paramValues["height"] = source.Height; paramValues["id"] = (Int32)source.ID; paramValues["map_id"] = (UInt16)source.MapID; paramValues["width"] = source.Width; paramValues["x"] = source.X; paramValues["y"] = source.Y; }
/// <summary> /// Copies the column values into the given DbParameterValues using the database column name /// with a prefixed @ as the key. The keys must already exist in the DbParameterValues; /// this method will not create them if they are missing. /// </summary> /// <param name="source">The object to copy the values from.</param> /// <param name="paramValues">The DbParameterValues to copy the values into.</param> public static void CopyValues(this IGuildEventTable source, DbParameterValues paramValues) { paramValues["arg0"] = source.Arg0; paramValues["arg1"] = source.Arg1; paramValues["arg2"] = source.Arg2; paramValues["character_id"] = (Int32)source.CharacterID; paramValues["created"] = source.Created; paramValues["event_id"] = source.EventID; paramValues["guild_id"] = (UInt16)source.GuildID; paramValues["id"] = source.ID; paramValues["target_character_id"] = (int?)source.TargetCharacterID; }
/// <summary> /// Copies the column values into the given DbParameterValues using the database column name /// with a prefixed @ as the key. The keys must already exist in the DbParameterValues; /// this method will not create them if they are missing. /// </summary> /// <param name="source">The object to copy the values from.</param> /// <param name="paramValues">The DbParameterValues to copy the values into.</param> public static void CopyValues(this IAccountTable source, DbParameterValues paramValues) { paramValues["creator_ip"] = source.CreatorIp; paramValues["current_ip"] = source.CurrentIp; paramValues["email"] = source.Email; paramValues["id"] = (Int32)source.ID; paramValues["name"] = source.Name; paramValues["password"] = source.Password; paramValues["permissions"] = (Byte)source.Permissions; paramValues["time_created"] = source.TimeCreated; paramValues["time_last_login"] = source.TimeLastLogin; }
/// <summary> /// Copies the column values into the given DbParameterValues using the database column name /// with a prefixed @ as the key. The keys must already exist in the DbParameterValues; /// this method will not create them if they are missing. /// </summary> /// <param name="source">The object to copy the values from.</param> /// <param name="paramValues">The DbParameterValues to copy the values into.</param> public static void CopyValues(this IWorldStatsNetworkTable source, DbParameterValues paramValues) { paramValues["connections"] = source.Connections; paramValues["id"] = source.ID; paramValues["recv_bytes"] = source.RecvBytes; paramValues["recv_messages"] = source.RecvMessages; paramValues["recv_packets"] = source.RecvPackets; paramValues["sent_bytes"] = source.SentBytes; paramValues["sent_messages"] = source.SentMessages; paramValues["sent_packets"] = source.SentPackets; paramValues["when"] = source.When; }
/// <summary> /// Copies the column values into the given DbParameterValues using the database column name /// with a prefixed @ as the key. The key must already exist in the DbParameterValues /// for the value to be copied over. If any of the keys in the DbParameterValues do not /// match one of the column names, or if there is no field for a key, then it will be /// ignored. Because of this, it is important to be careful when using this method /// since columns or keys can be skipped without any indication. /// </summary> /// <param name="source">The object to copy the values from.</param> /// <param name="paramValues">The DbParameterValues to copy the values into.</param> public static void TryCopyValues(this IServerTimeTable source, DbParameterValues paramValues) { for (var i = 0; i < paramValues.Count; i++) { switch (paramValues.GetParameterName(i)) { case "server_time": paramValues[i] = source.ServerTime; break; } } }
/// <summary> /// Copies the column values into the given DbParameterValues using the database column name /// with a prefixed @ as the key. The key must already exist in the DbParameterValues /// for the value to be copied over. If any of the keys in the DbParameterValues do not /// match one of the column names, or if there is no field for a key, then it will be /// ignored. Because of this, it is important to be careful when using this method /// since columns or keys can be skipped without any indication. /// </summary> /// <param name="source">The object to copy the values from.</param> /// <param name="paramValues">The DbParameterValues to copy the values into.</param> public static void TryCopyValues(this IWorldStatsUserShoppingTable source, DbParameterValues paramValues) { for (var i = 0; i < paramValues.Count; i++) { switch (paramValues.GetParameterName(i)) { case "amount": paramValues[i] = source.Amount; break; case "character_id": paramValues[i] = (Int32)source.CharacterID; break; case "cost": paramValues[i] = source.Cost; break; case "id": paramValues[i] = source.ID; break; case "item_template_id": paramValues[i] = (ushort?)source.ItemTemplateID; break; case "map_id": paramValues[i] = (ushort?)source.MapID; break; case "sale_type": paramValues[i] = source.SaleType; break; case "shop_id": paramValues[i] = (UInt16)source.ShopID; break; case "when": paramValues[i] = source.When; break; case "x": paramValues[i] = source.X; break; case "y": paramValues[i] = source.Y; break; } } }
/// <summary> /// Copies the column values into the given DbParameterValues using the database column name /// with a prefixed @ as the key. The keys must already exist in the DbParameterValues; /// this method will not create them if they are missing. /// </summary> /// <param name="source">The object to copy the values from.</param> /// <param name="paramValues">The DbParameterValues to copy the values into.</param> public static void CopyValues(this IWorldStatsUserKillNpcTable source, DbParameterValues paramValues) { paramValues["id"] = source.ID; paramValues["map_id"] = (ushort?)source.MapID; paramValues["npc_template_id"] = (ushort?)source.NPCTemplateID; paramValues["npc_x"] = source.NpcX; paramValues["npc_y"] = source.NpcY; paramValues["user_id"] = (Int32)source.UserID; paramValues["user_level"] = source.UserLevel; paramValues["user_x"] = source.UserX; paramValues["user_y"] = source.UserY; paramValues["when"] = source.When; }
/// <summary> /// Copies the column values into the given DbParameterValues using the database column name /// with a prefixed @ as the key. The keys must already exist in the DbParameterValues; /// this method will not create them if they are missing. /// </summary> /// <param name="source">The object to copy the values from.</param> /// <param name="paramValues">The DbParameterValues to copy the values into.</param> public static void CopyValues(this IWorldStatsUserShoppingTable source, DbParameterValues paramValues) { paramValues["amount"] = source.Amount; paramValues["character_id"] = (Int32)source.CharacterID; paramValues["cost"] = source.Cost; paramValues["id"] = source.ID; paramValues["item_template_id"] = (ushort?)source.ItemTemplateID; paramValues["map_id"] = (ushort?)source.MapID; paramValues["sale_type"] = source.SaleType; paramValues["shop_id"] = (UInt16)source.ShopID; paramValues["when"] = source.When; paramValues["x"] = source.X; paramValues["y"] = source.Y; }
/// <summary> /// Copies the column values into the given DbParameterValues using the database column name /// with a prefixed @ as the key. The key must already exist in the DbParameterValues /// for the value to be copied over. If any of the keys in the DbParameterValues do not /// match one of the column names, or if there is no field for a key, then it will be /// ignored. Because of this, it is important to be careful when using this method /// since columns or keys can be skipped without any indication. /// </summary> /// <param name="source">The object to copy the values from.</param> /// <param name="paramValues">The DbParameterValues to copy the values into.</param> public static void TryCopyValues(this ICharacterTemplateSkillTable source, DbParameterValues paramValues) { for (var i = 0; i < paramValues.Count; i++) { switch (paramValues.GetParameterName(i)) { case "character_template_id": paramValues[i] = (UInt16)source.CharacterTemplateID; break; case "skill_id": paramValues[i] = (Byte)source.SkillID; break; } } }
/// <summary> /// Copies the column values into the given DbParameterValues using the database column name /// with a prefixed @ as the key. The keys must already exist in the DbParameterValues; /// this method will not create them if they are missing. /// </summary> /// <param name="source">The object to copy the values from.</param> /// <param name="paramValues">The DbParameterValues to copy the values into.</param> public static void CopyValues(this ICharacterTemplateSkillTable source, DbParameterValues paramValues) { paramValues["character_template_id"] = (UInt16)source.CharacterTemplateID; paramValues["skill_id"] = (Byte)source.SkillID; }
/// <summary> /// Copies the column values into the given DbParameterValues using the database column name /// with a prefixed @ as the key. The key must already exist in the DbParameterValues /// for the value to be copied over. If any of the keys in the DbParameterValues do not /// match one of the column names, or if there is no field for a key, then it will be /// ignored. Because of this, it is important to be careful when using this method /// since columns or keys can be skipped without any indication. /// </summary> /// <param name="source">The object to copy the values from.</param> /// <param name="paramValues">The DbParameterValues to copy the values into.</param> public static void TryCopyValues(this IEventCountersQuestTable source, DbParameterValues paramValues) { for (var i = 0; i < paramValues.Count; i++) { switch (paramValues.GetParameterName(i)) { case "counter": paramValues[i] = source.Counter; break; case "quest_event_counter_id": paramValues[i] = source.QuestEventCounterId; break; case "quest_id": paramValues[i] = (UInt16)source.QuestID; break; } } }
/// <summary> /// Copies the column values into the given DbParameterValues using the database column name /// with a prefixed @ as the key. The keys must already exist in the DbParameterValues; /// this method will not create them if they are missing. /// </summary> /// <param name="source">The object to copy the values from.</param> /// <param name="paramValues">The DbParameterValues to copy the values into.</param> public static void CopyValues(this IEventCountersQuestTable source, DbParameterValues paramValues) { paramValues["counter"] = source.Counter; paramValues["quest_event_counter_id"] = source.QuestEventCounterId; paramValues["quest_id"] = (UInt16)source.QuestID; }
/// <summary> /// Copies the column values into the given DbParameterValues using the database column name /// with a prefixed @ as the key. The key must already exist in the DbParameterValues /// for the value to be copied over. If any of the keys in the DbParameterValues do not /// match one of the column names, or if there is no field for a key, then it will be /// ignored. Because of this, it is important to be careful when using this method /// since columns or keys can be skipped without any indication. /// </summary> /// <param name="source">The object to copy the values from.</param> /// <param name="paramValues">The DbParameterValues to copy the values into.</param> public static void TryCopyValues(this ICharacterEquippedTable source, DbParameterValues paramValues) { for (var i = 0; i < paramValues.Count; i++) { switch (paramValues.GetParameterName(i)) { case "character_id": paramValues[i] = (Int32)source.CharacterID; break; case "item_id": paramValues[i] = (Int32)source.ItemID; break; case "slot": paramValues[i] = (Byte)source.Slot; break; } } }