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 + "\'"); }