public List <RegisterLevel> ListRegisterLevel(int pIdGame, int pIdPlayer, int pIdRegisterMap) { List <RegisterLevel> list_register = new List <RegisterLevel>(); string conn = "URI=file:" + Application.streamingAssetsPath + "/AdvScrabble.db"; //Path to database. IDbConnection dbconn; dbconn = (IDbConnection) new SqliteConnection(conn); dbconn.Open(); //Open connection to the database. IDbCommand dbcmd = dbconn.CreateCommand(); string sqlQuery = String.Format("SELECT * FROM level_register where id_game = \"{0}\" and id_player = \"{1}\" and id_map_register = \"{2}\"", pIdGame, pIdPlayer, pIdRegisterMap); dbcmd.CommandText = sqlQuery; IDataReader reader = dbcmd.ExecuteReader(); while (reader.Read()) { RegisterLevel r = new RegisterLevel(); r.Id_register_level = reader.GetInt32(3); r.Level = this.GetLevel(pIdGame, reader.GetInt32(4), reader.GetInt32(5)); r.Score = reader.GetInt32(6); r.Count_stars = reader.GetInt32(7); list_register.Add(r); } reader.Close(); reader = null; dbcmd.Dispose(); dbcmd = null; dbconn.Close(); dbconn = null; return(list_register); }
public void InsertRegLevel(int pIdGame, int pIdPlayer, int pIdRegMap, int pIdMap, RegisterLevel r) { string conn = "URI=file:" + Application.streamingAssetsPath + "/AdvScrabble.db"; //Path to database. using (IDbConnection dbconn = new SqliteConnection(conn)) { dbconn.Open(); using (IDbCommand dbcmd = dbconn.CreateCommand()) { string sqlQuery = String.Format("INSERT INTO level_register (id_game, id_player, id_map_register, id_level_register, id_map, id_level, score, count_star) VALUES (\"{0}\",\"{1}\",\"{2}\",\"{3}\",\"{4}\",\"{5}\",\"{6}\",\"{7}\")", pIdGame, pIdPlayer, pIdRegMap, r.Id_register_level, pIdMap, r.Level.Id_level, r.Score, r.Count_stars); dbcmd.CommandText = sqlQuery; dbcmd.ExecuteScalar(); dbconn.Close(); } } }
// Use this for initialization void Start() { GameObject cursorBar = GameObject.Find("CursorBar"); BoxCollider2D cursorBox = cursorBar.GetComponent <BoxCollider2D> (); cursorBox.enabled = true; GameObject load = GameObject.Find("LoadMap"); GameObject music = GameObject.Find("ButtonMusic"); GameObject sound = GameObject.Find("ButtonSound"); a = load.GetComponent <AudioSource> (); Image musicImage = music.GetComponent <Image> (); Image soundImage = sound.GetComponent <Image> (); if (UIManagerMenu.musicActive == true) { musicImage.sprite = Resources.Load <Sprite> ("Buttons/ButtonMusic") as Sprite; a.Play(); } else { musicImage.sprite = Resources.Load <Sprite> ("Buttons/ButtonMusicProh") as Sprite; if (a.isPlaying == true) { a.Stop(); } } if (UICommon.soundActive == true) { soundImage.sprite = Resources.Load <Sprite> ("Buttons/ButtonSound") as Sprite; } else { soundImage.sprite = Resources.Load <Sprite> ("Buttons/ButtonSoundProh") as Sprite; } buttonOneLife = GameObject.Find("ButtonOneLife"); textOneLife = GameObject.Find("TextOneLife"); imageOneLife = GameObject.Find("ImageOneLife"); backLevelsMap = GameObject.Find("BackLevelsMap"); mapRegPanel = GameObject.Find("MapRegPanel"); achievementGrid = GameObject.Find("AchievementsGrid"); panel = GameObject.Find("Panel"); backGroundBar = GameObject.Find("BackGroundBar"); if (UIManagerMenu.g.P.Name == "") { if (UIManagerMenu.typeConnection == "facebook") { UIManagerMenu.g.P = new Player(); UIManagerMenu.g.P.Name = FBScript.userName; ChargeData(); UIManagerMenu.g.P.ListAchievements[0].Count++; } else { new UICommon().SetActiveControls(false); GameObject imageReg = GameObject.Find("ImageRegister"); Animator imageReg_anim = imageReg.GetComponent <Animator> (); imageReg_anim.Play("ShowRegister"); } } else { ChargeData(); } if (UIManager.goNext == true) { if (UIManagerMenu.g.P.ListRegMap.Count == 0) { RegisterMap rm = new RegisterMap(); rm.Map = new Map(); rm.Map.Id_map = UIManagerMenu.IdMap + 1; rm.Score_map += PieceDrag.total_score_gral; new Persistence().InsertRegMap(UIManagerMenu.g.Id_game, UIManagerMenu.g.P.Id_player, rm); } else { UIManagerMenu.g.P.ListRegMap[UIManagerMenu.IdMap].Score_map += PieceDrag.total_score_gral; new Persistence().UpdateRegMap(UIManagerMenu.g.Id_game, UIManagerMenu.g.P.Id_player, UIManagerMenu.g.P.ListRegMap[UIManagerMenu.IdMap]); } UIManagerMenu.g.P.ListRegMap = new Persistence().ListRegisterMap(UIManagerMenu.g.Id_game, UIManagerMenu.g.P.Id_player); RegisterLevel regLevel = new RegisterLevel(); regLevel.Level = new Level(); regLevel.Level.Id_level = levelGo; regLevel.Score = PieceDrag.total_score_gral; regLevel.Count_stars = UIManager.countStars; new Persistence().InsertRegLevel(UIManagerMenu.g.Id_game, UIManagerMenu.g.P.Id_player, UIManagerMenu.g.P.ListRegMap [UIManagerMenu.IdMap].Id_register_map, UIManagerMenu.IdMap + 1, regLevel); UIManagerMenu.g = new Persistence().GetGame(); this.GoToNextLevel(); UIManager.goNext = false; } }