Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- private void getData(string nameDb, string nameTable, string querySelect)
- {
- try
- {
- string pass = passchuan;
- // tat ma hoa
- if (!isPass) pass = "PRAGMA hex";
- string filename = Application.persistentDataPath + "/" + nameDb;
- SQLiteDB db = new SQLiteDB();
- // and open again
- db.Open(filename);
- //
- // set ENCRYPTION AGAIN, you could try change to see ENCRYPTION works
- //
- SQLiteQuery qr = new SQLiteQuery(db, pass);
- qr.Step();
- qr.Release();
- qr = new SQLiteQuery(db, querySelect);
- while (qr.Step())
- {
- // if (!qr.IsNULL("buy")) qr.GetInteger("buy");
- // if (!qr.IsNULL("note")) qr.GetInteger("note");
- // if (!qr.IsNULL("energy")) qr.GetInteger("energy");
- // if (!qr.IsNULL("energy_buy")) qr.GetInteger("energy_buy");
- // if (!qr.IsNULL("buy_cube")) qr.GetInteger("buy_cube");
- // if (!qr.IsNULL("energy_refill")) qr.GetString("energy_refill");
- // if (!qr.IsNULL("energy_refill")) print("energy_refill= " + qr.GetString("energy_refill"));
- //tbl_HeroUser,tbl_LevelUser
- //tbl_Boss tbl_Draw tbl_Energy tbl_Hero tbl_Level lbl_Skill tbl_UnlockHero
- print("Lay du lieu ok" + nameDb + " >> " + nameTable);
- if (nameTable == "HeroUser")
- {
- // int test = qr.GetInteger("id_unlockhero");
- // print(">> HeroUser >> id_unlockhero= " + test);
- }
- if (nameTable == "LevelUser")
- {
- }
- if (nameTable == "Boss")
- {
- // int test = qr.GetInteger("id_unlockhero");
- // print(">> HeroUser >> id_unlockhero= " + test);
- print("Doc duoc Boss");
- }
- if (nameTable == "Draw")
- {
- // int test = qr.GetInteger("cube_buy");
- // print(">> Draw >> cube_buy= " + test);
- }
- if (nameTable == "Energy")
- {
- // int test = qr.GetInteger("note");
- // print(">> Energy >> note= " + test);
- }
- if (nameTable == "Hero")
- {
- }
- if (nameTable == "Level")
- {
- }
- if (nameTable == "Skill")
- {
- }
- if (nameTable == "UnlockHero")
- {
- }
- }
- qr.Release();
- db.Close();
- }
- catch (Exception e)
- {
- print(e.Message);
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment