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);
}