//use SelectJumpTypes object. Since 1.6.3 public static List<object> SelectJumpTypesNew(bool dbconOpened, string allJumpsName, string filter, bool onlyName) { //allJumpsName: add and "allJumpsName" value //filter: // "" all jumps, // "TC" only with previous fall, // "nonTC" only not with previous fall // used in gui/stats.cs //onlyName: return only type name string whereString = ""; if(filter == "TC") { whereString = " WHERE startIn == 0 "; } else if(filter == "nonTC") { whereString = " WHERE startIn == 1 "; } openIfNeeded(dbconOpened); dbcmd.CommandText = "SELECT * " + " FROM " + Constants.JumpTypeTable + " " + whereString + " ORDER BY uniqueID"; LogB.SQL(dbcmd.CommandText.ToString()); dbcmd.ExecuteNonQuery(); SqliteDataReader reader; reader = dbcmd.ExecuteReader(); List<object> types = new List<object>(); SelectJumpTypes type; if(allJumpsName != "") { type = new SelectJumpTypes(allJumpsName); types.Add(type); } while(reader.Read()) { if(onlyName) { type = new SelectJumpTypes(reader[1].ToString()); } else { type = new SelectJumpTypes( Convert.ToInt32(reader[0]), //uniqueID reader[1].ToString(), //nameEnglish Util.IntToBool(Convert.ToInt32(reader[2].ToString())), //startIn Util.IntToBool(Convert.ToInt32(reader[3].ToString())), //hasWeight reader[4].ToString()); //description } types.Add(type); } reader.Close(); closeIfNeeded(dbconOpened); return types; }
//use SelectJumpTypes object. Since 1.6.3 public static List <object> SelectJumpTypesNew(bool dbconOpened, string allJumpsName, string filter, bool onlyName) { //allJumpsName: add and "allJumpsName" value //filter: // "" all jumps, // "TC" only with previous fall, // "nonTC" only not with previous fall // used in gui/stats.cs //onlyName: return only type name string whereString = ""; if (filter == "TC") { whereString = " WHERE startIn == 0 "; } else if (filter == "nonTC") { whereString = " WHERE startIn == 1 "; } openIfNeeded(dbconOpened); dbcmd.CommandText = "SELECT * " + " FROM " + Constants.JumpTypeTable + " " + whereString + " ORDER BY uniqueID"; LogB.SQL(dbcmd.CommandText.ToString()); dbcmd.ExecuteNonQuery(); SqliteDataReader reader; reader = dbcmd.ExecuteReader(); List <object> types = new List <object>(); SelectJumpTypes type; if (allJumpsName != "") { type = new SelectJumpTypes(allJumpsName); types.Add(type); } while (reader.Read()) { if (onlyName) { type = new SelectJumpTypes(reader[1].ToString()); } else { type = new SelectJumpTypes( Convert.ToInt32(reader[0]), //uniqueID reader[1].ToString(), //nameEnglish Util.IntToBool(Convert.ToInt32(reader[2].ToString())), //startIn Util.IntToBool(Convert.ToInt32(reader[3].ToString())), //hasWeight reader[4].ToString()); //description } types.Add(type); } reader.Close(); closeIfNeeded(dbconOpened); return(types); }