public static void AddMissionEnemyData(PMDCP.DatabaseConnector.MySql.MySql database, int difficulty, int index, MissionEnemyData data) { database.AddRow("mission_enemy", new IDataColumn[] { database.CreateColumn(false, "Rank", difficulty.ToString()), database.CreateColumn(false, "EnemyIndex", index.ToString()), database.CreateColumn(false, "NpcNum", data.NpcNum.ToString()) }); }
public static void AddMissionClientData(PMDCP.DatabaseConnector.MySql.MySql database, int difficulty, int index, MissionClientData data) { database.AddRow("mission_client", new IDataColumn[] { database.CreateColumn(false, "Rank", difficulty.ToString()), database.CreateColumn(false, "ClientIndex", index.ToString()), database.CreateColumn(false, "DexNum", data.DexNum.ToString()), database.CreateColumn(false, "FormNum", data.FormNum.ToString()) }); }
public static void AddMissionRewardData(PMDCP.DatabaseConnector.MySql.MySql database, int difficulty, int index, MissionRewardData data) { database.AddRow("mission_reward", new IDataColumn[] { database.CreateColumn(false, "Rank", difficulty.ToString()), database.CreateColumn(false, "RewardIndex", index.ToString()), database.CreateColumn(false, "ItemNum", data.ItemNum.ToString()), database.CreateColumn(false, "ItemAmount", data.ItemAmount.ToString()), database.CreateColumn(false, "ItemTag", data.ItemTag) }); }
public static void SaveParty(PMDCP.DatabaseConnector.MySql.MySql database, Party partyData) { database.ExecuteNonQuery("DELETE FROM parties WHERE PartyID = \'" + partyData.PartyID + "\'"); //database.DeleteRow("friends", "CharID = \'" + playerData.CharID + "\'"); for (int i = 0; i < partyData.Members.Count; i++) { database.UpdateOrInsert("parties", new IDataColumn[] { database.CreateColumn(false, "PartyID", partyData.PartyID), database.CreateColumn(false, "PartySlot", i.ToString()), database.CreateColumn(false, "CharID", partyData.Members[i]) }); } }
/// <summary> /// Adds a new friend. Return codes are as follows: /// <list type="table"> /// <item> /// 0 - Success /// </item> /// <item> /// 1 - Friend is already on list /// </item> /// </list> /// </summary> /// <param name="name"></param> public int AddFriend(PMDCP.DatabaseConnector.MySql.MySql database, string name) { int error = 0; if (friends.Contains(name) == false) { QuickAdd(name); if (UpdateOnDemand && database != null) { database.UpdateOrInsert("friends", new IDataColumn[] { database.CreateColumn(false, "CharID", ownerCharID), database.CreateColumn(false, "FriendListSlot", (friends.Count - 1).ToString()), database.CreateColumn(false, "FriendName", name) }); } } else { error = 1; } return(error); }