public static Dictionary <string, string> GetRaceInfo(int id) { // id, name, creator, type, number of checkpoints Dictionary <string, string> results = new Dictionary <string, string>(); Dictionary <string, string> row; MySQLConnector mySQLConnector = MySQLConnector.Instance(); mySQLConnector = MySQLConnector.Instance(); Dictionary <string, object> param = new Dictionary <string, object> { { "@id", id } }; // On récupère l'id, le nom et le nom du créateur mySQLConnector.OpenReader("SELECT race_id, race_name, race_creator FROM races WHERE race_id = @id", param); row = mySQLConnector.GetNextRow(); foreach (KeyValuePair <string, string> kvp in row) { results.Add(MySQLConnector.Field.GetFieldName(kvp.Key), kvp.Value); } mySQLConnector.CloseReader(); // On récupère tous les checkpoints de la course mySQLConnector.OpenReader("SELECT checkpoint_id, checkpoint_number, checkpoint_pos_x, checkpoint_pos_y, checkpoint_pos_z " + "FROM race_checkpoints WHERE race_id = @id", param); int nbrOfCheckpoints = 0; row = mySQLConnector.GetNextRow(); Vector3 firstCheckpointPos = new Vector3(); while (row.Count > 0) { nbrOfCheckpoints++; if (row["checkpoint_number"] == "0") { firstCheckpointPos = new Vector3( (float)Convert.ToDouble(row["checkpoint_pos_x"]), (float)Convert.ToDouble(row["checkpoint_pos_y"]), (float)Convert.ToDouble(row["checkpoint_pos_z"]) ); } row = mySQLConnector.GetNextRow(); } results.Add("Nombre de checkpoints", nbrOfCheckpoints.ToString()); mySQLConnector.CloseReader(); // On récupère la zone du premier checkpoint string zoneStr = ""; Zone zone = new Zone(); zoneStr = zone.GetZoneName(firstCheckpointPos); results.Add("Zone", zoneStr); return(results); }
public static Dictionary <string, string> FindRace(string str) { MySQLConnector mySQLConnector = MySQLConnector.Instance(); mySQLConnector = MySQLConnector.Instance(); Dictionary <string, object> param = new Dictionary <string, object> { { "@name", str } }; mySQLConnector.OpenReader("SELECT race_id, race_name FROM races WHERE race_name LIKE @name", param); Dictionary <string, string> results = mySQLConnector.GetNextRow(); mySQLConnector.CloseReader(); return(results); }