public static PartyData LoadParty(MySql database, string partyID) { PartyData partyData = new PartyData(); partyData.PartyID = partyID; string query = "SELECT parties.CharID " + "FROM parties " + "WHERE parties.PartyID = \'" + partyData.PartyID + "\';"; List <DataColumnCollection> rows = database.RetrieveRows(query); if (rows != null) { for (int i = 0; i < rows.Count; i++) { partyData.Members.Add(rows[i]["CharID"].ValueString); } } return(partyData); }
public static void DeleteParty(PMDCP.DatabaseConnector.MySql.MySql database, PartyData partyData) { database.ExecuteNonQuery("DELETE FROM parties WHERE PartyID = \'" + partyData.PartyID + "\'"); }