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