public void AddRowClosing()
{
stringBuilder.Append(")");
firstColumn = true;
rowCount++;
if (rowCount >= 1000)
{
database.ExecuteNonQuery(GetSqlQuery());
stringBuilder = null;
rowCount = 0;
}
}
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])
});
}
}
public static void DeleteParty(PMDCP.DatabaseConnector.MySql.MySql database, Party partyData)
{
database.ExecuteNonQuery("DELETE FROM parties WHERE PartyID = \'" + partyData.PartyID + "\'");
}
public static void ClearMissionEnemyData(PMDCP.DatabaseConnector.MySql.MySql database, int difficulty)
{
database.ExecuteNonQuery("DELETE FROM mission_enemy WHERE Rank = \'" + difficulty + "\'");
}