Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- using UnityEngine;
- using UnityEngine.UI;
- using System.Collections;
- using System;
- using System.IO;
- using System.Threading;
- using System.Diagnostics;
- using System.Collections.Generic;
- using Debug = UnityEngine.Debug;
- public class CreateDbAESv2 : MonoBehaviour
- {
- // private string passSQLiteKit = "PRAGMA hexkey=\"0x0102030405060708090a0b0c0d0e0f10\";";
- private string passSQLiteKit = "PRAGMA hex";
- //
- // Other
- //
- private SQLiteDB dbsql = null;
- BCEngine bc = new BCEngine();
- private string key;// = "1234567891234567";
- //
- // DataUser
- //
- private string DataUser = "DataUser0";
- // Query Create DataUser
- private string tbl_HeroUser =
- "CREATE TABLE IF NOT EXISTS tbl_HeroUser (id_hero INTEGER, id_unlockhero INTEGER, id_skill INTEGER, level_hero INTEGER, attack INTEGER, unlock INTEGER);";
- private string tbl_LevelUser =
- "CREATE TABLE IF NOT EXISTS tbl_LevelUser (id_level INTEGER, play INTEGER, unlock INTEGER, top_dame INTEGER, top_move INTEGER);";
- // Query Select DataUser
- private string tbl_HeroUserSelect = "SELECT * FROM tbl_HeroUser;";
- private string tbl_LevelUserSelect = "SELECT * FROM tbl_LevelUser;";
- // Query Insert DataUser
- private string tbl_HeroUserInsert =
- "INSERT INTO tbl_HeroUser (id_hero,id_unlockhero,id_skill,level_hero,attack,unlock) VALUES(?,?,?,?,?,?);";
- private string tbl_LevelUserInsert =
- "INSERT INTO tbl_LevelUser (id_level,play,unlock,top_dame,top_move) VALUES(?,?,?,?,?);";
- //
- // DataGame
- //
- private string DataGame = "DataGame0";
- // Query Create DataGame
- private string tbl_Boss =
- "CREATE TABLE IF NOT EXISTS tbl_Boss (id_boss INTEGER, type INTEGER, id_level INTEGER, name_boss VARCHAR, blood INTEGER, resist INTEGER, special INTEGER, move INTEGER, blood_special INTEGER, num_special INTEGER, img VARCHAR);";
- //private string tbl_Draw =
- // "CREATE TABLE IF NOT EXISTS tbl_Draw (id INTEGER, note INTEGER, food_percent VARCHAR, food INTEGER, soul_percent VARCHAR, soul INTEGER, cube_percent VARCHAR, cube INTEGER, cube_buy INTEGER);";
- //private string tbl_Energy =
- // "CREATE TABLE IF NOT EXISTS tbl_Energy (buy INTEGER, note INTEGER, energy INTEGER, energy_buy INTEGER, buy_cube INTEGER, energy_refill VARCHAR);";
- //private string tbl_Hero =
- // "CREATE TABLE IF NOT EXISTS tbl_Hero (id_hero INTEGER, map_open INTEGER, map_gift INTEGER, type_hero INTEGER, id_skill INTEGER, name_hero VARCHAR, des VARCHAR, food INTEGER, p_food VARCHAR, soul INTEGER, p_soul VARCHAR, cube INTEGER, p_cube VARCHAR, shop_food INTEGER, shop_soul INTEGER, shop_cube INTEGER);";
- //private string tbl_Level =
- // "CREATE TABLE IF NOT EXISTS tbl_Level (id_level INTEGER, chapter INTEGER, name_level VARCHAR, energy INTEGER DEFAULT (0), w_crystal INTEGER DEFAULT (0), w_food INTEGER DEFAULT (0), w_soul INTEGER, w_energy INTEGER, w_ticket INTEGER, w_hero INTEGER, q_move INTEGER, q_h1 INTEGER, q_h2 INTEGER, q_h3 INTEGER, q_h4 INTEGER, q_h5 INTEGER, q_box INTEGER, q_boss INTEGER, q_food INTEGER, q_soul INTEGER, q_ticket INTEGER, q_crystal INTEGER, q_hero INTEGER, q_bom INTEGER, log_win VARCHAR, log_lose VARCHAR);";
- private string tbl_Draw =
- "CREATE TABLE IF NOT EXISTS tbl_Draw (id INTEGER, note INTEGER, food_percent VARCHAR, food INTEGER, soul_percent VARCHAR, soul INTEGER, cube_percent VARCHAR, cube INTEGER, cube_buy INTEGER, tile INTEGER);";
- private string tbl_Energy =
- "CREATE TABLE IF NOT EXISTS tbl_Energy (num_buy INTEGER, note INTEGER, energy INTEGER, energy_max INTEGER, gold_full INTEGER, gold_max INTEGER);";
- private string tbl_Hero =
- "CREATE TABLE IF NOT EXISTS tbl_Hero (id_hero INTEGER, chapter INTEGER, map_open INTEGER, map_gift INTEGER, type_hero INTEGER, id_skill INTEGER, name_hero VARCHAR, des VARCHAR, value INTEGER, draw_type INTEGER, draw_value INTEGER, draw_prent VARCHAR);";
- private string tbl_Level =
- "CREATE TABLE tbl_Level (id_level INTEGER, chapter INTEGER, name_level VARCHAR, name_image VARCHAR, energy INTEGER DEFAULT (0), w_crystal INTEGER DEFAULT (0), w_food INTEGER DEFAULT (0), w_soul INTEGER, w_energy INTEGER, w_ticket INTEGER, w_hero INTEGER, q_move INTEGER, q_h1 INTEGER, q_h2 INTEGER, q_h3 INTEGER, q_h4 INTEGER, q_h5 INTEGER, q_box INTEGER, q_boss INTEGER, q_food INTEGER, q_soul INTEGER, q_ticket INTEGER, q_crystal INTEGER, q_hero INTEGER, q_bom INTEGER, log_win VARCHAR, log_lose VARCHAR);";
- private string tbl_Skill =
- "CREATE TABLE IF NOT EXISTS tbl_Skill (id_skill INTEGER, type_skill INTEGER, name_skill VARCHAR, level_skill INTEGER, num_gem INTEGER, dame INTEGER, range INTEGER, des VARCHAR);";
- private string tbl_UnlockHero =
- "CREATE TABLE IF NOT EXISTS tbl_UnlockHero (id_unlockhero INTEGER, id_hero INTEGER, level_hero INTEGER, attack INTEGER, soul INTEGER, food INTEGER, crystal INTEGER, img VARCHAR);";
- // Query Select DataGame
- private string tbl_BossSelect = "SELECT * FROM tbl_Boss;";
- private string tbl_DrawSelect = "SELECT * FROM tbl_Draw;";
- private string tbl_EnergySelect = "SELECT * FROM tbl_Energy;";
- private string tbl_HeroSelect = "SELECT * FROM tbl_Hero;";
- private string tbl_LevelSelect = "SELECT * FROM tbl_Level;";
- private string tbl_SkillSelect = "SELECT * FROM tbl_Skill;";
- private string tbl_UnlockHeroSelect = "SELECT * FROM tbl_UnlockHero;";
- // Query Insert DataGame
- private string tbl_BossInsert =
- "INSERT INTO tbl_Boss (id_boss,type,id_level,name_boss,blood,resist,special,move,blood_special,num_special,img) VALUES(?,?,?,?,?,?,?,?,?,?,?);";
- //private string tbl_DrawInsert =
- // "INSERT INTO tbl_Draw (id,note,food_percent,food,soul_percent,soul,cube_percent,cube,cube_buy) VALUES(?,?,?,?,?,?,?,?,?);";
- //private string tbl_EnergyInsert =
- // "INSERT INTO tbl_Energy (buy,note,energy,energy_buy,buy_cube,energy_refill) VALUES(?,?,?,?,?,?);";
- //private string tbl_HeroInsert =
- // "INSERT INTO tbl_Hero (id_hero,map_open,map_gift,type_hero,id_skill,name_hero,des,food,p_food,soul,p_soul,cube,p_cube,shop_food,shop_soul,shop_cube) VALUES(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?);";
- //private string tbl_LevelInsert =
- // "INSERT INTO tbl_Level (id_level,chapter,name_level,energy,w_crystal,w_food,w_soul,w_energy,w_ticket,w_hero,q_move,q_h1,q_h2,q_h3,q_h4,q_h5,q_box,q_boss,q_food,q_soul,q_ticket,q_crystal,q_hero,q_bom,log_win,log_lose) VALUES(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?);";
- private string tbl_DrawInsert =
- "INSERT INTO tbl_Draw (id,note,food_percent,food,soul_percent,soul,cube_percent,cube,cube_buy, tile) VALUES(?,?,?,?,?,?,?,?,?,?);";
- private string tbl_EnergyInsert =
- "INSERT INTO tbl_Energy (num_buy,note,energy,energy_max,gold_full,gold_max) VALUES(?,?,?,?,?,?);";
- private string tbl_HeroInsert =
- "INSERT INTO tbl_Hero (id_hero,chapter,map_open,map_gift,type_hero,id_skill,name_hero,des,value,draw_type,draw_value,draw_prent) VALUES(?,?,?,?,?,?,?,?,?,?,?,?);";
- private string tbl_LevelInsert =
- "INSERT INTO tbl_Level (id_level,chapter,name_level,name_image,energy,w_crystal,w_food,w_soul,w_energy,w_ticket,w_hero,q_move,q_h1,q_h2,q_h3,q_h4,q_h5,q_box,q_boss,q_food,q_soul,q_ticket,q_crystal,q_hero,q_bom,log_win,log_lose) VALUES(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?);";
- private string tbl_SkillInsert =
- "INSERT INTO tbl_Skill (id_skill,type_skill,name_skill,level_skill,num_gem,dame,range,des) VALUES(?,?,?,?,?,?,?,?);";
- private string tbl_UnlockHeroInsert =
- "INSERT INTO tbl_UnlockHero (id_unlockhero,id_hero,level_hero,attack,soul,food,crystal,img) VALUES(?,?,?,?,?,?,?,?);";
- // private void Awake()
- // {
- // string plaint = "Thieu Mao";
- // string enc = bc.Encrypt(plaint, key);
- // string dec = bc.Decrypt(enc, key);
- //
- // print("enc = " + enc);
- // print("dec = " + dec);
- // }
- void Awake()
- {
- EncryptedPlayerPrefs.CreateKey();
- key = EncryptedPlayerPrefs.GetString("keyAes");
- }
- // Use this for initialization
- void Start()
- {
- print("Path: " + Application.persistentDataPath);
- // list table
- //tbl_HeroUser,tbl_LevelUser --> DataUser
- //tbl_Boss tbl_Draw tbl_Energy tbl_Hero tbl_Level lbl_Skill tbl_UnlockHero --> DataGame
- //updateHeroUser(int idHero, int level, int indexUnlock, int indexSkill, int attack)
- //updateHeroUser(2,2,2,2,2);
- createDataUser();
- createDataGame();
- //getHeroUser();
- //getLevelUser();
- //getBoss();
- getDraw();
- //getEnergy();
- //getHero();
- //getLevel();
- //getSkill();
- //getUnlockHero();
- }
- private void updateHeroUser(int idHero, int level, int indexUnlock, int indexSkill, int attack)
- {
- try
- {
- string pass = passSQLiteKit;
- string filename = Application.persistentDataPath + "/" + "DataUser1";
- 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();
- string queryUpdate = "UPDATE tbl_herouser SET level_hero=" + "'" + level + "'" + ", attack=" + "'" + attack + "'" + " ,id_unlockhero=" + "'" + indexUnlock + "'" + ", id_skill=" + "'" + indexSkill + "'" + " WHERE id_hero=" + "'" + idHero + "'";
- qr = new SQLiteQuery(db, queryUpdate);
- qr.Step();
- qr.Release();
- db.Close();
- }
- catch (Exception e)
- {
- print(e.Message);
- }
- }
- private void getHeroUser()
- {
- string pass = passSQLiteKit;
- string filename = Application.persistentDataPath + "/" + DataUser;
- 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, tbl_HeroUserSelect);
- while (qr.Step())
- {
- if (!qr.IsNULL("id_hero")) qr.GetInteger("id_hero");
- if (!qr.IsNULL("id_unlockhero")) qr.GetInteger("id_unlockhero");
- if (!qr.IsNULL("id_skill")) qr.GetInteger("id_skill");
- if (!qr.IsNULL("level_hero")) qr.GetInteger("level_hero");
- if (!qr.IsNULL("attack")) qr.GetString("attack");
- if (!qr.IsNULL("unlock")) qr.GetString("unlock");
- if (!qr.IsNULL("unlock")) print("getHeroUser>> unlock>> " + bc.Decrypt(qr.GetString("unlock"), key));
- }
- qr.Release();
- db.Close();
- }
- private void getLevelUser()
- {
- string pass = passSQLiteKit;
- string filename = Application.persistentDataPath + "/" + DataUser;
- 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, tbl_LevelUserSelect);
- while (qr.Step())
- {
- if (!qr.IsNULL("id_level")) qr.GetInteger("id_level");
- if (!qr.IsNULL("play")) qr.GetString("play");
- if (!qr.IsNULL("unlock")) qr.GetString("unlock");
- if (!qr.IsNULL("top_dame")) qr.GetString("top_dame");
- if (!qr.IsNULL("top_move")) qr.GetString("top_move");
- if (!qr.IsNULL("top_move")) bc.Decrypt("getLevelUser>> top_move>> " + qr.GetString("top_move"), key);
- }
- qr.Release();
- db.Close();
- }
- private void getBoss()
- {
- string pass = passSQLiteKit;
- string filename = Application.persistentDataPath + "/" + DataGame;
- 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, tbl_BossSelect);
- while (qr.Step())
- {
- if (!qr.IsNULL("id_boss")) qr.GetInteger("id_boss");
- if (!qr.IsNULL("type")) qr.GetString("type");
- if (!qr.IsNULL("id_level")) qr.GetInteger("id_level");
- if (!qr.IsNULL("name_boss")) qr.GetString("name_boss");
- if (!qr.IsNULL("blood")) qr.GetString("blood");
- if (!qr.IsNULL("resist")) qr.GetString("resist");
- if (!qr.IsNULL("special")) qr.GetString("special");
- if (!qr.IsNULL("move")) qr.GetString("move");
- if (!qr.IsNULL("blood_special")) qr.GetString("blood_special");
- if (!qr.IsNULL("num_special")) qr.GetString("num_special");
- if (!qr.IsNULL("img")) qr.GetString("img");
- if (!qr.IsNULL("img")) print("getBoss>> img>> " + bc.Decrypt(qr.GetString("img"), key));
- }
- qr.Release();
- db.Close();
- }
- private void getDraw()
- {
- print("getDraw");
- string pass = passSQLiteKit;
- string filename = Application.persistentDataPath + "/" + DataGame;
- 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, tbl_DrawSelect);
- while (qr.Step())
- {
- if (!qr.IsNULL("id")) qr.GetInteger("id");
- if (!qr.IsNULL("note")) qr.GetString("note");
- if (!qr.IsNULL("food_percent")) qr.GetString("food_percent");
- if (!qr.IsNULL("food")) qr.GetString("food");
- if (!qr.IsNULL("soul_percent")) qr.GetString("soul_percent");
- if (!qr.IsNULL("soul")) qr.GetString("soul");
- if (!qr.IsNULL("cube_percent")) qr.GetString("cube_percent");
- if (!qr.IsNULL("cube")) qr.GetString("cube");
- if (!qr.IsNULL("cube_buy")) qr.GetString("cube_buy");
- if (!qr.IsNULL("cube_buy")) print("getDraw>> cube_buy>> " + bc.Decrypt(qr.GetString("cube_buy"), key));
- }
- qr.Release();
- db.Close();
- }
- private void getEnergy()
- {
- string pass = passSQLiteKit;
- string filename = Application.persistentDataPath + "/" + DataGame;
- 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, tbl_EnergySelect);
- while (qr.Step())
- {
- if (!qr.IsNULL("buy")) qr.GetString("buy");
- if (!qr.IsNULL("note")) qr.GetString("note");
- if (!qr.IsNULL("energy")) qr.GetString("energy");
- if (!qr.IsNULL("energy_buy")) qr.GetString("energy_buy");
- if (!qr.IsNULL("buy_cube")) qr.GetString("buy_cube");
- if (!qr.IsNULL("energy_refill")) qr.GetString("energy_refill");
- if (!qr.IsNULL("energy_refill")) print("getEnergy>> energy_refill>> " + bc.Decrypt(qr.GetString("energy_refill"), key));
- }
- qr.Release();
- db.Close();
- }
- private void getHero()
- {
- string pass = passSQLiteKit;
- string filename = Application.persistentDataPath + "/" + DataGame;
- 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, tbl_HeroSelect);
- while (qr.Step())
- {
- if (!qr.IsNULL("id_hero")) qr.GetInteger("id_hero");
- if (!qr.IsNULL("map_open")) qr.GetString("map_open");
- if (!qr.IsNULL("map_gift")) qr.GetString("map_gift");
- if (!qr.IsNULL("type_hero")) qr.GetString("type_hero");
- if (!qr.IsNULL("id_skill")) qr.GetInteger("id_skill");
- if (!qr.IsNULL("name_hero")) qr.GetString("name_hero");
- if (!qr.IsNULL("des")) qr.GetString("des");
- if (!qr.IsNULL("food")) qr.GetString("food");
- if (!qr.IsNULL("p_food")) qr.GetString("p_food");
- if (!qr.IsNULL("soul")) qr.GetString("soul");
- if (!qr.IsNULL("p_soul")) qr.GetString("p_soul");
- if (!qr.IsNULL("cube")) qr.GetString("cube");
- if (!qr.IsNULL("p_cube")) qr.GetString("p_cube");
- if (!qr.IsNULL("shop_food")) qr.GetString("shop_food");
- if (!qr.IsNULL("shop_soul")) qr.GetString("shop_soul");
- if (!qr.IsNULL("shop_cube")) qr.GetString("shop_cube");
- if (!qr.IsNULL("shop_cube")) print("getHero>> shop_cube>> " + bc.Decrypt(qr.GetString("shop_cube"), key));
- }
- qr.Release();
- db.Close();
- }
- private void getLevel()
- {
- string pass = passSQLiteKit;
- string filename = Application.persistentDataPath + "/" + DataGame;
- 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, tbl_LevelSelect);
- while (qr.Step())
- {
- if (!qr.IsNULL("id_level")) qr.GetInteger("id_level");
- if (!qr.IsNULL("chapter")) qr.GetString("chapter");
- if (!qr.IsNULL("name_level")) qr.GetString("name_level");
- if (!qr.IsNULL("energy")) qr.GetString("energy");
- if (!qr.IsNULL("w_crystal")) qr.GetString("w_crystal");
- if (!qr.IsNULL("w_food")) qr.GetString("w_food");
- if (!qr.IsNULL("w_soul")) qr.GetString("w_soul");
- if (!qr.IsNULL("w_energy")) qr.GetString("w_energy");
- if (!qr.IsNULL("w_ticket")) qr.GetString("w_ticket");
- if (!qr.IsNULL("w_hero")) qr.GetString("w_hero");
- if (!qr.IsNULL("q_move")) qr.GetString("q_move");
- if (!qr.IsNULL("q_h1")) qr.GetString("q_h1");
- if (!qr.IsNULL("q_h2")) qr.GetString("q_h2");
- if (!qr.IsNULL("q_h3")) qr.GetString("q_h3");
- if (!qr.IsNULL("q_h4")) qr.GetString("q_h4");
- if (!qr.IsNULL("q_h5")) qr.GetString("q_h5");
- if (!qr.IsNULL("q_box")) qr.GetString("q_box");
- if (!qr.IsNULL("q_boss")) qr.GetString("q_boss");
- if (!qr.IsNULL("q_food")) qr.GetString("q_food");
- if (!qr.IsNULL("q_soul")) qr.GetString("q_soul");
- if (!qr.IsNULL("q_ticket")) qr.GetString("q_ticket");
- if (!qr.IsNULL("q_crystal")) qr.GetString("q_crystal");
- if (!qr.IsNULL("q_hero")) qr.GetString("q_hero");
- if (!qr.IsNULL("q_bom")) qr.GetString("q_bom");
- if (!qr.IsNULL("log_win")) qr.GetString("log_win");
- if (!qr.IsNULL("log_lose")) qr.GetString("log_lose");
- if (!qr.IsNULL("log_lose")) print("getLevel>> log_lose>> " + bc.Decrypt(qr.GetString("log_lose"), key));
- }
- qr.Release();
- db.Close();
- }
- private void getSkill()
- {
- string pass = passSQLiteKit;
- string filename = Application.persistentDataPath + "/" + DataGame;
- 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, tbl_SkillSelect);
- while (qr.Step())
- {
- if (!qr.IsNULL("id_skill")) qr.GetInteger("id_skill");
- if (!qr.IsNULL("type_skill")) qr.GetInteger("type_skill");
- if (!qr.IsNULL("name_skill")) qr.GetString("name_skill");
- if (!qr.IsNULL("level_skill")) qr.GetInteger("level_skill");
- if (!qr.IsNULL("num_gem")) qr.GetString("num_gem");
- if (!qr.IsNULL("dame")) qr.GetString("dame");
- if (!qr.IsNULL("range")) qr.GetString("range");
- if (!qr.IsNULL("des")) qr.GetString("des");
- if (!qr.IsNULL("des")) print("getSkill>> des>> " + bc.Decrypt(qr.GetString("des"), key));
- }
- qr.Release();
- db.Close();
- }
- private void getUnlockHero()
- {
- string pass = passSQLiteKit;
- string filename = Application.persistentDataPath + "/" + DataGame;
- 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, tbl_UnlockHeroSelect);
- while (qr.Step())
- {
- if (!qr.IsNULL("id_unlockhero")) qr.GetInteger("id_unlockhero");
- if (!qr.IsNULL("id_hero")) qr.GetInteger("id_hero");
- if (!qr.IsNULL("level_hero")) qr.GetInteger("level_hero");
- if (!qr.IsNULL("attack")) qr.GetString("attack");
- if (!qr.IsNULL("soul")) qr.GetString("soul");
- if (!qr.IsNULL("food")) qr.GetString("food");
- if (!qr.IsNULL("crystal")) qr.GetString("crystal");
- if (!qr.IsNULL("img")) qr.GetString("img");
- if (!qr.IsNULL("img")) print("getUnlockHero>> img>> " + bc.Decrypt(qr.GetString("img"), key));
- }
- qr.Release();
- db.Close();
- }
- private void createDataUser()
- {
- // string heykey = Md5Sum(password);
- // string pass = "PRAGMA hexkey=\"0x" + heykey + "\";";
- // pass = passSQLiteKit;
- // if (!isPass) pass = "PRAGMA hex";
- string pass = passSQLiteKit;
- try
- {
- SQLiteDB db2 = null;
- db2 = new SQLiteDB();
- string filename = Application.persistentDataPath + "/" + DataUser;
- File.Delete(filename);
- db2.Open(filename);
- //
- // set ENCRYPTION
- //
- SQLiteQuery qr2 = new SQLiteQuery(db2, pass);
- qr2.Step();
- qr2.Release();
- //
- // create table
- //
- qr2 = new SQLiteQuery(db2, tbl_HeroUser);
- qr2.Step();
- qr2.Release();
- qr2 = new SQLiteQuery(db2, tbl_LevelUser);
- qr2.Step();
- qr2.Release();
- //
- // insert table
- //
- converttbl_HeroUser(db2);
- converttbl_LevelUser(db2);
- // close
- db2.Close();
- }
- catch (Exception e)
- {
- Debug.Log(e);
- }
- }
- private void createDataGame()
- {
- // string heykey = Md5Sum(password);
- // string pass = "PRAGMA hexkey=\"0x" + heykey + "\";";
- // pass = passSQLiteKit;
- // if (!isPass) pass = "PRAGMA hex";
- string pass = passSQLiteKit;
- try
- {
- SQLiteDB db3 = null;
- db3 = new SQLiteDB();
- string filename = Application.persistentDataPath + "/" + DataGame;
- File.Delete(filename);
- db3.Open(filename);
- //print("mao " + filename);
- //
- // set ENCRYPTION
- //
- SQLiteQuery qr3 = new SQLiteQuery(db3, pass);
- qr3.Step();
- qr3.Release();
- //
- // create table
- //
- qr3 = new SQLiteQuery(db3, tbl_Boss);
- qr3.Step();
- qr3.Release();
- qr3 = new SQLiteQuery(db3, tbl_Draw);
- qr3.Step();
- qr3.Release();
- qr3 = new SQLiteQuery(db3, tbl_Energy);
- qr3.Step();
- qr3.Release();
- qr3 = new SQLiteQuery(db3, tbl_Hero);
- qr3.Step();
- qr3.Release();
- qr3 = new SQLiteQuery(db3, tbl_Level);
- qr3.Step();
- qr3.Release();
- qr3 = new SQLiteQuery(db3, tbl_Skill);
- qr3.Step();
- qr3.Release();
- qr3 = new SQLiteQuery(db3, tbl_UnlockHero);
- qr3.Step();
- qr3.Release();
- //tbl_Boss tbl_Draw tbl_Energy tbl_Hero tbl_Level lbl_Skill tbl_UnlockHero
- //
- // insert table
- //
- converttbl_Boss(db3);
- converttbl_Draw(db3);
- converttbl_Energy(db3);
- converttbl_Hero(db3);
- converttbl_Level(db3);
- converttbl_Skill(db3);
- converttbl_UnlockHero(db3);
- // close
- db3.Close();
- }
- catch (Exception e)
- {
- print("loi " + e.Message);
- }
- }
- private void converttbl_HeroUser(SQLiteDB db2)
- {
- LoadDatabase("DataUser");
- SQLiteQuery qr = new SQLiteQuery(dbsql, tbl_HeroUserSelect);
- while (qr.Step())
- {
- SQLiteQuery qr2 = new SQLiteQuery(db2, tbl_HeroUserInsert);
- // if (!qr.IsNULL("id_hero")) qr2.Bind(qr.GetInteger("id_hero")); else qr2.BindNull();
- // if (!qr.IsNULL("id_unlockhero")) qr2.Bind(qr.GetInteger("id_unlockhero")); else qr2.BindNull();
- // if (!qr.IsNULL("id_skill")) qr2.Bind(qr.GetInteger("id_skill")); else qr2.BindNull();
- // if (!qr.IsNULL("level_hero")) qr2.Bind(qr.GetInteger("level_hero")); else qr2.BindNull();
- // if (!qr.IsNULL("attack")) qr2.Bind(qr.GetInteger("attack")); else qr2.BindNull();
- // if (!qr.IsNULL("unlock")) qr2.Bind(qr.GetInteger("unlock")); else qr2.BindNull();
- // 3 id ko ma hoa
- // if (qr.IsNULL("id_hero")) qr2.BindNull(); else qr2.Bind(bc.Encrypt(qr.GetInteger("id_hero").ToString(), key));
- // if (qr.IsNULL("id_unlockhero")) qr2.BindNull(); else qr2.Bind(bc.Encrypt(qr.GetInteger("id_unlockhero").ToString(), key));
- // if (qr.IsNULL("id_skill")) qr2.BindNull(); else qr2.Bind(bc.Encrypt(qr.GetInteger("id_skill").ToString(), key));
- // if (qr.IsNULL("level_hero")) qr2.BindNull(); else qr2.Bind(bc.Encrypt(qr.GetInteger("level_hero").ToString(), key));
- if (!qr.IsNULL("id_hero")) qr2.Bind(qr.GetInteger("id_hero")); else qr2.BindNull();
- if (!qr.IsNULL("id_unlockhero")) qr2.Bind(qr.GetInteger("id_unlockhero")); else qr2.BindNull();
- if (!qr.IsNULL("id_skill")) qr2.Bind(qr.GetInteger("id_skill")); else qr2.BindNull();
- if (!qr.IsNULL("level_hero")) qr2.Bind(qr.GetInteger("level_hero")); else qr2.BindNull();
- if (qr.IsNULL("attack")) qr2.BindNull(); else qr2.Bind(bc.Encrypt(qr.GetInteger("attack").ToString(), key));
- if (qr.IsNULL("unlock")) qr2.BindNull(); else qr2.Bind(bc.Encrypt(qr.GetInteger("unlock").ToString(), key));
- qr2.Step();
- qr2.Release();
- }
- }
- private void converttbl_LevelUser(SQLiteDB db2)
- {
- LoadDatabase("DataUser");
- SQLiteQuery qr = new SQLiteQuery(dbsql, tbl_LevelUserSelect);
- while (qr.Step())
- {
- SQLiteQuery qr2 = new SQLiteQuery(db2, tbl_LevelUserInsert);
- // if (!qr.IsNULL("id_level")) qr2.Bind(qr.GetInteger("id_level")); else qr2.BindNull();
- // if (!qr.IsNULL("play")) qr2.Bind(qr.GetInteger("play")); else qr2.BindNull();
- // if (!qr.IsNULL("unlock")) qr2.Bind(qr.GetInteger("unlock")); else qr2.BindNull();
- // if (!qr.IsNULL("top_dame")) qr2.Bind(qr.GetInteger("top_dame")); else qr2.BindNull();
- // if (!qr.IsNULL("top_move")) qr2.Bind(qr.GetInteger("top_move")); else qr2.BindNull();
- // ko ma hoa id
- // if (qr.IsNULL("id_level")) qr2.BindNull(); else qr2.Bind(bc.Encrypt(qr.GetInteger("id_level").ToString(), key));
- if (!qr.IsNULL("id_level")) qr2.Bind(qr.GetInteger("id_level")); else qr2.BindNull();
- if (qr.IsNULL("play")) qr2.BindNull(); else qr2.Bind(bc.Encrypt(qr.GetInteger("play").ToString(), key));
- if (qr.IsNULL("unlock")) qr2.BindNull(); else qr2.Bind(bc.Encrypt(qr.GetInteger("unlock").ToString(), key));
- if (qr.IsNULL("top_dame")) qr2.BindNull(); else qr2.Bind(bc.Encrypt(qr.GetInteger("top_dame").ToString(), key));
- if (qr.IsNULL("top_move")) qr2.BindNull(); else qr2.Bind(bc.Encrypt(qr.GetInteger("top_move").ToString(), key));
- qr2.Step();
- qr2.Release();
- }
- }
- private void converttbl_Boss(SQLiteDB db3)
- {
- LoadDatabase("DataGame");
- SQLiteQuery qr = new SQLiteQuery(dbsql, tbl_BossSelect);
- while (qr.Step())
- {
- SQLiteQuery qr3 = new SQLiteQuery(db3, tbl_BossInsert);
- // if (!qr.IsNULL("id_boss")) qr3.Bind(qr.GetInteger("id_boss")); else qr3.BindNull();
- // if (!qr.IsNULL("type")) qr3.Bind(qr.GetInteger("type")); else qr3.BindNull();
- // if (!qr.IsNULL("id_level")) qr3.Bind(qr.GetInteger("id_level")); else qr3.BindNull();
- // if (!qr.IsNULL("name_boss")) qr3.Bind(qr.GetString("name_boss")); else qr3.BindNull();
- // if (!qr.IsNULL("blood")) qr3.Bind(qr.GetInteger("blood")); else qr3.BindNull();
- // if (!qr.IsNULL("resist")) qr3.Bind(qr.GetInteger("resist")); else qr3.BindNull();
- // if (!qr.IsNULL("special")) qr3.Bind(qr.GetInteger("special")); else qr3.BindNull();
- // if (!qr.IsNULL("move")) qr3.Bind(qr.GetInteger("move")); else qr3.BindNull();
- // if (!qr.IsNULL("blood_special")) qr3.Bind(qr.GetInteger("blood_special")); else qr3.BindNull();
- // if (!qr.IsNULL("num_special")) qr3.Bind(qr.GetInteger("num_special")); else qr3.BindNull();
- // if (!qr.IsNULL("img")) qr3.Bind(qr.GetString("img")); else qr3.BindNull();
- // khong ma hoa id
- // if (qr.IsNULL("id_boss")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("id_boss").ToString(), key));
- if (!qr.IsNULL("id_boss")) qr3.Bind(qr.GetInteger("id_boss")); else qr3.BindNull();
- if (qr.IsNULL("type")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("type").ToString(), key));
- // if (qr.IsNULL("id_level")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("id_level").ToString(), key));
- if (!qr.IsNULL("id_level")) qr3.Bind(qr.GetInteger("id_level")); else qr3.BindNull();
- if (qr.IsNULL("name_boss")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetString("name_boss").ToString(), key));
- if (qr.IsNULL("blood")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("blood").ToString(), key));
- if (qr.IsNULL("resist")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("resist").ToString(), key));
- if (qr.IsNULL("special")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("special").ToString(), key));
- if (qr.IsNULL("move")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("move").ToString(), key));
- if (qr.IsNULL("blood_special")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("blood_special").ToString(), key));
- if (qr.IsNULL("num_special")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("num_special").ToString(), key));
- if (qr.IsNULL("img")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetString("img").ToString(), key));
- qr3.Step();
- qr3.Release();
- }
- }
- private void converttbl_Draw(SQLiteDB db3)
- {
- LoadDatabase("DataGame");
- SQLiteQuery qr = new SQLiteQuery(dbsql, tbl_DrawSelect);
- while (qr.Step())
- {
- SQLiteQuery qr3 = new SQLiteQuery(db3, tbl_DrawInsert);
- // if (!qr.IsNULL("id")) qr3.Bind(qr.GetInteger("id")); else qr3.BindNull();
- // if (!qr.IsNULL("note")) qr3.Bind(qr.GetInteger("note")); else qr3.BindNull();
- // if (!qr.IsNULL("food_percent")) qr3.Bind(qr.GetString("food_percent")); else qr3.BindNull();
- // if (!qr.IsNULL("food")) qr3.Bind(qr.GetInteger("food")); else qr3.BindNull();
- // if (!qr.IsNULL("soul_percent")) qr3.Bind(qr.GetString("soul_percent")); else qr3.BindNull();
- // if (!qr.IsNULL("soul")) qr3.Bind(qr.GetInteger("soul")); else qr3.BindNull();
- // if (!qr.IsNULL("cube_percent")) qr3.Bind(qr.GetString("cube_percent")); else qr3.BindNull();
- // if (!qr.IsNULL("cube")) qr3.Bind(qr.GetInteger("cube")); else qr3.BindNull();
- // if (!qr.IsNULL("cube_buy")) qr3.Bind(qr.GetInteger("cube_buy")); else qr3.BindNull();
- // khong ma hoa id
- // if (qr.IsNULL("id")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("id").ToString(), key));
- if (!qr.IsNULL("id")) qr3.Bind(qr.GetInteger("id")); else qr3.BindNull();
- if (qr.IsNULL("note")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("note").ToString(), key));
- if (qr.IsNULL("food_percent")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetString("food_percent").ToString(), key));
- if (qr.IsNULL("food")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("food").ToString(), key));
- if (qr.IsNULL("soul_percent")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetString("soul_percent").ToString(), key));
- if (qr.IsNULL("soul")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("soul").ToString(), key));
- if (qr.IsNULL("cube_percent")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetString("cube_percent").ToString(), key));
- if (qr.IsNULL("cube")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("cube").ToString(), key));
- if (qr.IsNULL("cube_buy")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("cube_buy").ToString(), key));
- if (qr.IsNULL("tile")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("tile").ToString(), key));
- qr3.Step();
- qr3.Release();
- }
- }
- private void converttbl_Energy(SQLiteDB db3)
- {
- LoadDatabase("DataGame");
- SQLiteQuery qr = new SQLiteQuery(dbsql, tbl_EnergySelect);
- while (qr.Step())
- {
- SQLiteQuery qr3 = new SQLiteQuery(db3, tbl_EnergyInsert);
- // if (!qr.IsNULL("buy")) qr3.Bind(qr.GetInteger("buy")); else qr3.BindNull();
- // if (!qr.IsNULL("note")) qr3.Bind(qr.GetInteger("note")); else qr3.BindNull();
- // if (!qr.IsNULL("energy")) qr3.Bind(qr.GetInteger("energy")); else qr3.BindNull();
- // if (!qr.IsNULL("energy_buy")) qr3.Bind(qr.GetInteger("energy_buy")); else qr3.BindNull();
- // if (!qr.IsNULL("buy_cube")) qr3.Bind(qr.GetInteger("buy_cube")); else qr3.BindNull();
- // if (!qr.IsNULL("energy_refill")) qr3.Bind(qr.GetString("energy_refill")); else qr3.BindNull();
- // old
- //if (qr.IsNULL("buy")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("buy").ToString(), key));
- //if (qr.IsNULL("note")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("note").ToString(), key));
- //if (qr.IsNULL("energy")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("energy").ToString(), key));
- //if (qr.IsNULL("energy_buy")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("energy_buy").ToString(), key));
- //if (qr.IsNULL("buy_cube")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("buy_cube").ToString(), key));
- //if (qr.IsNULL("energy_refill")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetString("energy_refill").ToString(), key));
- if (qr.IsNULL("num_buy")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("num_buy").ToString(), key));
- if (qr.IsNULL("note")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("note").ToString(), key));
- if (qr.IsNULL("energy")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("energy").ToString(), key));
- if (qr.IsNULL("energy_max")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("energy_max").ToString(), key));
- if (qr.IsNULL("gold_full")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("gold_full").ToString(), key));
- if (qr.IsNULL("gold_max")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("gold_max").ToString(), key));
- qr3.Step();
- qr3.Release();
- }
- }
- private void converttbl_Hero(SQLiteDB db3)
- {
- LoadDatabase("DataGame");
- SQLiteQuery qr = new SQLiteQuery(dbsql, tbl_HeroSelect);
- while (qr.Step())
- {
- SQLiteQuery qr3 = new SQLiteQuery(db3, tbl_HeroInsert);
- // if (!qr.IsNULL("id_hero")) qr3.Bind(qr.GetInteger("id_hero")); else qr3.BindNull();
- // if (!qr.IsNULL("map_open")) qr3.Bind(qr.GetInteger("map_open")); else qr3.BindNull();
- // if (!qr.IsNULL("map_gift")) qr3.Bind(qr.GetInteger("map_gift")); else qr3.BindNull();
- // if (!qr.IsNULL("type_hero")) qr3.Bind(qr.GetInteger("type_hero")); else qr3.BindNull();
- // if (!qr.IsNULL("id_skill")) qr3.Bind(qr.GetInteger("id_skill")); else qr3.BindNull();
- // if (!qr.IsNULL("name_hero")) qr3.Bind(qr.GetString("name_hero")); else qr3.BindNull();
- // if (!qr.IsNULL("des")) qr3.Bind(qr.GetString("des")); else qr3.BindNull();
- // if (!qr.IsNULL("food")) qr3.Bind(qr.GetInteger("food")); else qr3.BindNull();
- // if (!qr.IsNULL("p_food")) qr3.Bind(qr.GetString("p_food")); else qr3.BindNull();
- // if (!qr.IsNULL("soul")) qr3.Bind(qr.GetInteger("soul")); else qr3.BindNull();
- // if (!qr.IsNULL("p_soul")) qr3.Bind(qr.GetString("p_soul")); else qr3.BindNull();
- // if (!qr.IsNULL("cube")) qr3.Bind(qr.GetInteger("cube")); else qr3.BindNull();
- // if (!qr.IsNULL("p_cube")) qr3.Bind(qr.GetString("p_cube")); else qr3.BindNull();
- // if (!qr.IsNULL("shop_food")) qr3.Bind(qr.GetInteger("shop_food")); else qr3.BindNull();
- // if (!qr.IsNULL("shop_soul")) qr3.Bind(qr.GetInteger("shop_soul")); else qr3.BindNull();
- // if (!qr.IsNULL("shop_cube")) qr3.Bind(qr.GetInteger("shop_cube")); else qr3.BindNull();
- // khong ma hoa id
- // if (qr.IsNULL("id_hero")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("id_hero").ToString(), key));
- // old
- //if (!qr.IsNULL("id_hero")) qr3.Bind(qr.GetInteger("id_hero")); else qr3.BindNull();
- //if (qr.IsNULL("map_open")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("map_open").ToString(), key));
- //if (qr.IsNULL("map_gift")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("map_gift").ToString(), key));
- //if (qr.IsNULL("type_hero")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("type_hero").ToString(), key));
- //// if (qr.IsNULL("id_skill")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("id_skill").ToString(), key));
- //if (!qr.IsNULL("id_skill")) qr3.Bind(qr.GetInteger("id_skill")); else qr3.BindNull();
- //if (qr.IsNULL("name_hero")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetString("name_hero").ToString(), key));
- //if (qr.IsNULL("des")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetString("des").ToString(), key));
- //if (qr.IsNULL("food")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("food").ToString(), key));
- //if (qr.IsNULL("p_food")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetString("p_food").ToString(), key));
- //if (qr.IsNULL("soul")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("soul").ToString(), key));
- //if (qr.IsNULL("p_soul")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetString("p_soul").ToString(), key));
- //if (qr.IsNULL("cube")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("cube").ToString(), key));
- //if (qr.IsNULL("p_cube")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetString("p_cube").ToString(), key));
- //if (qr.IsNULL("shop_food")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("shop_food").ToString(), key));
- //if (qr.IsNULL("shop_soul")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("shop_soul").ToString(), key));
- //if (qr.IsNULL("shop_cube")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("shop_cube").ToString(), key));
- if (!qr.IsNULL("id_hero")) qr3.Bind(qr.GetInteger("id_hero")); else qr3.BindNull();
- if (qr.IsNULL("chapter")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("chapter").ToString(), key));
- if (qr.IsNULL("map_open")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("map_open").ToString(), key));
- if (qr.IsNULL("map_gift")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("map_gift").ToString(), key));
- if (qr.IsNULL("type_hero")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("type_hero").ToString(), key));
- // if (qr.IsNULL("id_skill")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("id_skill").ToString(), key));
- if (!qr.IsNULL("id_skill")) qr3.Bind(qr.GetInteger("id_skill")); else qr3.BindNull();
- if (qr.IsNULL("name_hero")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetString("name_hero").ToString(), key));
- if (qr.IsNULL("des")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetString("des").ToString(), key));
- if (qr.IsNULL("value")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("value").ToString(), key));
- if (qr.IsNULL("draw_type")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("draw_type").ToString(), key));
- if (qr.IsNULL("draw_value")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("draw_value").ToString(), key));
- if (qr.IsNULL("draw_prent")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetString("draw_prent").ToString(), key));
- qr3.Step();
- qr3.Release();
- }
- }
- private void converttbl_Level(SQLiteDB db3)
- {
- LoadDatabase("DataGame");
- SQLiteQuery qr = new SQLiteQuery(dbsql, tbl_LevelSelect);
- while (qr.Step())
- {
- SQLiteQuery qr3 = new SQLiteQuery(db3, tbl_LevelInsert);
- // if (!qr.IsNULL("id_level")) qr3.Bind(qr.GetInteger("id_level")); else qr3.BindNull();
- // if (!qr.IsNULL("chapter")) qr3.Bind(qr.GetInteger("chapter")); else qr3.BindNull();
- // if (!qr.IsNULL("name_level")) qr3.Bind(qr.GetString("name_level")); else qr3.BindNull();
- // if (!qr.IsNULL("energy")) qr3.Bind(qr.GetInteger("energy")); else qr3.BindNull();
- // if (!qr.IsNULL("w_crystal")) qr3.Bind(qr.GetInteger("w_crystal")); else qr3.BindNull();
- // if (!qr.IsNULL("w_food")) qr3.Bind(qr.GetInteger("w_food")); else qr3.BindNull();
- // if (!qr.IsNULL("w_soul")) qr3.Bind(qr.GetInteger("w_soul")); else qr3.BindNull();
- // if (!qr.IsNULL("w_energy")) qr3.Bind(qr.GetInteger("w_energy")); else qr3.BindNull();
- // if (!qr.IsNULL("w_ticket")) qr3.Bind(qr.GetInteger("w_ticket")); else qr3.BindNull();
- // if (!qr.IsNULL("w_hero")) qr3.Bind(qr.GetInteger("w_hero")); else qr3.BindNull();
- // if (!qr.IsNULL("q_move")) qr3.Bind(qr.GetInteger("q_move")); else qr3.BindNull();
- // if (!qr.IsNULL("q_h1")) qr3.Bind(qr.GetInteger("q_h1")); else qr3.BindNull();
- // if (!qr.IsNULL("q_h2")) qr3.Bind(qr.GetInteger("q_h2")); else qr3.BindNull();
- // if (!qr.IsNULL("q_h3")) qr3.Bind(qr.GetInteger("q_h3")); else qr3.BindNull();
- // if (!qr.IsNULL("q_h4")) qr3.Bind(qr.GetInteger("q_h4")); else qr3.BindNull();
- // if (!qr.IsNULL("q_h5")) qr3.Bind(qr.GetInteger("q_h5")); else qr3.BindNull();
- // if (!qr.IsNULL("q_box")) qr3.Bind(qr.GetInteger("q_box")); else qr3.BindNull();
- // if (!qr.IsNULL("q_boss")) qr3.Bind(qr.GetInteger("q_boss")); else qr3.BindNull();
- // if (!qr.IsNULL("q_food")) qr3.Bind(qr.GetInteger("q_food")); else qr3.BindNull();
- // if (!qr.IsNULL("q_soul")) qr3.Bind(qr.GetInteger("q_soul")); else qr3.BindNull();
- // if (!qr.IsNULL("q_ticket")) qr3.Bind(qr.GetInteger("q_ticket")); else qr3.BindNull();
- // if (!qr.IsNULL("q_crystal")) qr3.Bind(qr.GetInteger("q_crystal")); else qr3.BindNull();
- // if (!qr.IsNULL("q_hero")) qr3.Bind(qr.GetInteger("q_hero")); else qr3.BindNull();
- // if (!qr.IsNULL("q_bom")) qr3.Bind(qr.GetInteger("q_bom")); else qr3.BindNull();
- // if (!qr.IsNULL("log_win")) qr3.Bind(qr.GetString("log_win")); else qr3.BindNull();
- // if (!qr.IsNULL("log_lose")) qr3.Bind(qr.GetString("log_lose")); else qr3.BindNull();
- // khong ma hoa id
- // if (qr.IsNULL("id_level")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("id_level").ToString(), key));
- // old
- //if (!qr.IsNULL("id_level")) qr3.Bind(qr.GetInteger("id_level")); else qr3.BindNull();
- //if (qr.IsNULL("chapter")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("chapter").ToString(), key));
- //if (qr.IsNULL("name_level")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetString("name_level").ToString(), key));
- //if (qr.IsNULL("energy")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("energy").ToString(), key));
- //if (qr.IsNULL("w_crystal")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("w_crystal").ToString(), key));
- //if (qr.IsNULL("w_food")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("w_food").ToString(), key));
- //if (qr.IsNULL("w_soul")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("w_soul").ToString(), key));
- //if (qr.IsNULL("w_energy")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("w_energy").ToString(), key));
- //if (qr.IsNULL("w_ticket")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("w_ticket").ToString(), key));
- //if (qr.IsNULL("w_hero")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("w_hero").ToString(), key));
- //if (qr.IsNULL("q_move")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("q_move").ToString(), key));
- //if (qr.IsNULL("q_h1")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("q_h1").ToString(), key));
- //if (qr.IsNULL("q_h2")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("q_h2").ToString(), key));
- //if (qr.IsNULL("q_h3")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("q_h3").ToString(), key));
- //if (qr.IsNULL("q_h4")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("q_h4").ToString(), key));
- //if (qr.IsNULL("q_h5")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("q_h5").ToString(), key));
- //if (qr.IsNULL("q_box")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("q_box").ToString(), key));
- //if (qr.IsNULL("q_boss")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("q_boss").ToString(), key));
- //if (qr.IsNULL("q_food")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("q_food").ToString(), key));
- //if (qr.IsNULL("q_soul")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("q_soul").ToString(), key));
- //if (qr.IsNULL("q_ticket")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("q_ticket").ToString(), key));
- //if (qr.IsNULL("q_crystal")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("q_crystal").ToString(), key));
- //if (qr.IsNULL("q_hero")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("q_hero").ToString(), key));
- //if (qr.IsNULL("q_bom")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("q_bom").ToString(), key));
- //if (qr.IsNULL("log_win")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetString("log_win").ToString(), key));
- //if (qr.IsNULL("log_lose")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetString("log_lose").ToString(), key));
- if (!qr.IsNULL("id_level")) qr3.Bind(qr.GetInteger("id_level")); else qr3.BindNull();
- if (qr.IsNULL("chapter")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("chapter").ToString(), key));
- if (qr.IsNULL("name_level")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetString("name_level").ToString(), key));
- if (qr.IsNULL("name_image")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetString("name_image").ToString(), key));
- if (qr.IsNULL("energy")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("energy").ToString(), key));
- if (qr.IsNULL("w_crystal")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("w_crystal").ToString(), key));
- if (qr.IsNULL("w_food")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("w_food").ToString(), key));
- if (qr.IsNULL("w_soul")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("w_soul").ToString(), key));
- if (qr.IsNULL("w_energy")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("w_energy").ToString(), key));
- if (qr.IsNULL("w_ticket")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("w_ticket").ToString(), key));
- if (qr.IsNULL("w_hero")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("w_hero").ToString(), key));
- if (qr.IsNULL("q_move")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("q_move").ToString(), key));
- if (qr.IsNULL("q_h1")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("q_h1").ToString(), key));
- if (qr.IsNULL("q_h2")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("q_h2").ToString(), key));
- if (qr.IsNULL("q_h3")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("q_h3").ToString(), key));
- if (qr.IsNULL("q_h4")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("q_h4").ToString(), key));
- if (qr.IsNULL("q_h5")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("q_h5").ToString(), key));
- if (qr.IsNULL("q_box")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("q_box").ToString(), key));
- if (qr.IsNULL("q_boss")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("q_boss").ToString(), key));
- if (qr.IsNULL("q_food")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("q_food").ToString(), key));
- if (qr.IsNULL("q_soul")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("q_soul").ToString(), key));
- if (qr.IsNULL("q_ticket")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("q_ticket").ToString(), key));
- if (qr.IsNULL("q_crystal")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("q_crystal").ToString(), key));
- if (qr.IsNULL("q_hero")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("q_hero").ToString(), key));
- if (qr.IsNULL("q_bom")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("q_bom").ToString(), key));
- if (qr.IsNULL("log_win")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetString("log_win").ToString(), key));
- if (qr.IsNULL("log_lose")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetString("log_lose").ToString(), key));
- qr3.Step();
- qr3.Release();
- }
- }
- private void converttbl_Skill(SQLiteDB db3)
- {
- LoadDatabase("DataGame");
- SQLiteQuery qr = new SQLiteQuery(dbsql, tbl_SkillSelect);
- while (qr.Step())
- {
- SQLiteQuery qr3 = new SQLiteQuery(db3, tbl_SkillInsert);
- // if (!qr.IsNULL("id_skill")) qr3.Bind(qr.GetInteger("id_skill")); else qr3.BindNull();
- // if (!qr.IsNULL("type_skill")) qr3.Bind(qr.GetInteger("type_skill")); else qr3.BindNull();
- // if (!qr.IsNULL("name_skill")) qr3.Bind(qr.GetString("name_skill")); else qr3.BindNull();
- // if (!qr.IsNULL("level_skill")) qr3.Bind(qr.GetInteger("level_skill")); else qr3.BindNull();
- // if (!qr.IsNULL("num_gem")) qr3.Bind(qr.GetInteger("num_gem")); else qr3.BindNull();
- // if (!qr.IsNULL("dame")) qr3.Bind(qr.GetInteger("dame")); else qr3.BindNull();
- // if (!qr.IsNULL("range")) qr3.Bind(qr.GetInteger("range")); else qr3.BindNull();
- // if (!qr.IsNULL("des")) qr3.Bind(qr.GetString("des")); else qr3.BindNull();
- // khong ma hoa id va level skill va type skill
- // if (qr.IsNULL("id_skill")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("id_skill").ToString(), key));
- if (!qr.IsNULL("id_skill")) qr3.Bind(qr.GetInteger("id_skill")); else qr3.BindNull();
- // if (qr.IsNULL("type_skill")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("type_skill").ToString(), key));
- if (!qr.IsNULL("type_skill")) qr3.Bind(qr.GetInteger("type_skill")); else qr3.BindNull();
- if (qr.IsNULL("name_skill")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetString("name_skill").ToString(), key));
- // if (qr.IsNULL("level_skill")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("level_skill").ToString(), key));
- if (!qr.IsNULL("level_skill")) qr3.Bind(qr.GetInteger("level_skill")); else qr3.BindNull();
- if (qr.IsNULL("num_gem")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("num_gem").ToString(), key));
- if (qr.IsNULL("dame")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("dame").ToString(), key));
- if (qr.IsNULL("range")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("range").ToString(), key));
- if (qr.IsNULL("des")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetString("des").ToString(), key));
- qr3.Step();
- qr3.Release();
- }
- }
- private void converttbl_UnlockHero(SQLiteDB db3)
- {
- //print("Unlockhero vao roi");
- LoadDatabase("DataGame");
- SQLiteQuery qr = new SQLiteQuery(dbsql, tbl_UnlockHeroSelect);
- while (qr.Step())
- {
- SQLiteQuery qr3 = new SQLiteQuery(db3, tbl_UnlockHeroInsert);
- // if (!qr.IsNULL("id_unlockhero")) qr3.Bind(qr.GetInteger("id_unlockhero")); else qr3.BindNull();
- // if (!qr.IsNULL("id_hero")) qr3.Bind(qr.GetInteger("id_hero")); else qr3.BindNull();
- // if (!qr.IsNULL("level_hero")) qr3.Bind(qr.GetInteger("level_hero")); else qr3.BindNull();
- // if (!qr.IsNULL("attack")) qr3.Bind(qr.GetInteger("attack")); else qr3.BindNull();
- // if (!qr.IsNULL("soul")) qr3.Bind(qr.GetInteger("soul")); else qr3.BindNull();
- // if (!qr.IsNULL("food")) qr3.Bind(qr.GetInteger("food")); else qr3.BindNull();
- // if (!qr.IsNULL("crystal")) qr3.Bind(qr.GetInteger("crystal")); else qr3.BindNull();
- // if (!qr.IsNULL("img")) qr3.Bind(qr.GetString("img")); else qr3.BindNull();
- // khong ma hoa id va level
- // if (qr.IsNULL("id_unlockhero")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("id_unlockhero").ToString(), key));
- // if (qr.IsNULL("id_hero")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("id_hero").ToString(), key));
- // if (qr.IsNULL("level_hero")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("level_hero").ToString(), key));
- if (!qr.IsNULL("id_unlockhero")) qr3.Bind(qr.GetInteger("id_unlockhero")); else qr3.BindNull();
- if (!qr.IsNULL("id_hero")) qr3.Bind(qr.GetInteger("id_hero")); else qr3.BindNull();
- if (!qr.IsNULL("level_hero")) qr3.Bind(qr.GetInteger("level_hero")); else qr3.BindNull();
- if (qr.IsNULL("attack")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("attack").ToString(), key));
- if (qr.IsNULL("soul")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("soul").ToString(), key));
- if (qr.IsNULL("food")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("food").ToString(), key));
- if (qr.IsNULL("crystal")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("crystal").ToString(), key));
- if (qr.IsNULL("img")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetString("img").ToString(), key));
- qr3.Step();
- qr3.Release();
- }
- }
- private void LoadDatabase(String nameDb)
- {
- //print("Co vao day");
- dbsql = new SQLiteDB();
- String filename = Application.persistentDataPath + "/" + nameDb;
- // check if database already exists.
- if (!File.Exists(filename))
- {
- UnityEngine.Debug.Log("file does not exist");
- // ok , this is first time application start!
- // so lets copy prebuild dtabase from StreamingAssets and load store to persistancePath with Test2
- byte[] bytes = null;
- #if UNITY_EDITOR || UNITY_STANDALONE_WIN || UNITY_STANDALONE_OSX
- string dbpath = "file://" + Application.streamingAssetsPath + "/" + nameDb;
- WWW www = new WWW(dbpath);
- StartCoroutine(Download(www));
- bytes = www.bytes;
- #elif UNITY_WEBPLAYER
- string dbpath = "StreamingAssets/" + nameDb;
- WWW www = new WWW(dbpath);
- StartCoroutine(Download(www));
- bytes = www.bytes;
- #elif UNITY_IPHONE
- string dbpath = Application.dataPath + "/Raw/" + nameDb;
- try{
- using ( FileStream fs = new FileStream(dbpath, FileMode.Open, FileAccess.Read, FileShare.Read) ){
- bytes = new byte[fs.Length];
- fs.Read(bytes,0,(int)fs.Length);
- }
- } catch (Exception e){
- }
- #elif UNITY_ANDROID
- UnityEngine.Debug.Log("UNITY_ANDROID");
- string dbpath = Application.streamingAssetsPath + "/" + nameDb;
- UnityEngine.Debug.Log(dbpath);
- WWW www = new WWW(dbpath);
- StartCoroutine(Download(www));
- while(!www.isDone){}
- bytes = www.bytes;
- #endif
- if (bytes != null)
- {
- try
- {
- // copy database to real file into cache folder
- using (FileStream fs = new FileStream(filename, FileMode.OpenOrCreate, FileAccess.Write))
- {
- fs.Write(bytes, 0, bytes.Length);
- }
- // initialize database
- dbsql.Open(filename);
- }
- catch (Exception e)
- {
- Debug.Log("ERROR: " + e);
- }
- }
- }
- else
- {
- // it mean we already download prebuild data base and store into persistantPath
- // lest update, I will call Test
- try
- {
- // initialize database
- dbsql.Open(filename);
- }
- catch (Exception e)
- {
- Debug.Log("ERROR: " + e);
- }
- }
- }
- IEnumerator Download(WWW www)
- {
- yield return www;
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement