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;
}
}
