· 10 years ago · Jan 18, 2016, 08:33 AM
1using UnityEngine;
2using UnityEngine.UI;
3using System.Collections;
4using System;
5using System.IO;
6using System.Threading;
7using System.Diagnostics;
8using System.Collections.Generic;
9using Debug = UnityEngine.Debug;
10
11public class CreateDbAESv2 : MonoBehaviour
12{
13
14 // private string passSQLiteKit = "PRAGMA hexkey=\"0x0102030405060708090a0b0c0d0e0f10\";";
15 private string passSQLiteKit = "PRAGMA hex";
16
17 //
18 // Other
19 //
20 private SQLiteDB dbsql = null;
21 BCEngine bc = new BCEngine();
22 private string key;// = "1234567891234567";
23
24 //
25 // DataUser
26 //
27 private string DataUser = "DataUser0";
28
29 // Query Create DataUser
30 private string tbl_HeroUser =
31 "CREATE TABLE IF NOT EXISTS tbl_HeroUser (id_hero INTEGER, id_unlockhero INTEGER, id_skill INTEGER, level_hero INTEGER, attack INTEGER, unlock INTEGER);";
32 private string tbl_LevelUser =
33 "CREATE TABLE IF NOT EXISTS tbl_LevelUser (id_level INTEGER, play INTEGER, unlock INTEGER, top_dame INTEGER, top_move INTEGER);";
34
35 // Query Select DataUser
36 private string tbl_HeroUserSelect = "SELECT * FROM tbl_HeroUser;";
37 private string tbl_LevelUserSelect = "SELECT * FROM tbl_LevelUser;";
38
39 // Query Insert DataUser
40 private string tbl_HeroUserInsert =
41 "INSERT INTO tbl_HeroUser (id_hero,id_unlockhero,id_skill,level_hero,attack,unlock) VALUES(?,?,?,?,?,?);";
42 private string tbl_LevelUserInsert =
43 "INSERT INTO tbl_LevelUser (id_level,play,unlock,top_dame,top_move) VALUES(?,?,?,?,?);";
44
45 //
46 // DataGame
47 //
48 private string DataGame = "DataGame0";
49
50 // Query Create DataGame
51 private string tbl_Boss =
52 "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);";
53 //private string tbl_Draw =
54 // "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);";
55 //private string tbl_Energy =
56 // "CREATE TABLE IF NOT EXISTS tbl_Energy (buy INTEGER, note INTEGER, energy INTEGER, energy_buy INTEGER, buy_cube INTEGER, energy_refill VARCHAR);";
57 //private string tbl_Hero =
58 // "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);";
59 //private string tbl_Level =
60 // "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);";
61 private string tbl_Draw =
62 "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);";
63 private string tbl_Energy =
64 "CREATE TABLE IF NOT EXISTS tbl_Energy (num_buy INTEGER, note INTEGER, energy INTEGER, energy_max INTEGER, gold_full INTEGER, gold_max INTEGER);";
65 private string tbl_Hero =
66 "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);";
67 private string tbl_Level =
68 "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);";
69 private string tbl_Skill =
70 "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);";
71 private string tbl_UnlockHero =
72 "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);";
73
74 // Query Select DataGame
75 private string tbl_BossSelect = "SELECT * FROM tbl_Boss;";
76 private string tbl_DrawSelect = "SELECT * FROM tbl_Draw;";
77 private string tbl_EnergySelect = "SELECT * FROM tbl_Energy;";
78 private string tbl_HeroSelect = "SELECT * FROM tbl_Hero;";
79 private string tbl_LevelSelect = "SELECT * FROM tbl_Level;";
80 private string tbl_SkillSelect = "SELECT * FROM tbl_Skill;";
81 private string tbl_UnlockHeroSelect = "SELECT * FROM tbl_UnlockHero;";
82
83 // Query Insert DataGame
84 private string tbl_BossInsert =
85 "INSERT INTO tbl_Boss (id_boss,type,id_level,name_boss,blood,resist,special,move,blood_special,num_special,img) VALUES(?,?,?,?,?,?,?,?,?,?,?);";
86 //private string tbl_DrawInsert =
87 // "INSERT INTO tbl_Draw (id,note,food_percent,food,soul_percent,soul,cube_percent,cube,cube_buy) VALUES(?,?,?,?,?,?,?,?,?);";
88 //private string tbl_EnergyInsert =
89 // "INSERT INTO tbl_Energy (buy,note,energy,energy_buy,buy_cube,energy_refill) VALUES(?,?,?,?,?,?);";
90 //private string tbl_HeroInsert =
91 // "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(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?);";
92 //private string tbl_LevelInsert =
93 // "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(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?);";
94
95 private string tbl_DrawInsert =
96 "INSERT INTO tbl_Draw (id,note,food_percent,food,soul_percent,soul,cube_percent,cube,cube_buy, tile) VALUES(?,?,?,?,?,?,?,?,?,?);";
97 private string tbl_EnergyInsert =
98 "INSERT INTO tbl_Energy (num_buy,note,energy,energy_max,gold_full,gold_max) VALUES(?,?,?,?,?,?);";
99 private string tbl_HeroInsert =
100 "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(?,?,?,?,?,?,?,?,?,?,?,?);";
101 private string tbl_LevelInsert =
102 "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(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?);";
103
104 private string tbl_SkillInsert =
105 "INSERT INTO tbl_Skill (id_skill,type_skill,name_skill,level_skill,num_gem,dame,range,des) VALUES(?,?,?,?,?,?,?,?);";
106 private string tbl_UnlockHeroInsert =
107 "INSERT INTO tbl_UnlockHero (id_unlockhero,id_hero,level_hero,attack,soul,food,crystal,img) VALUES(?,?,?,?,?,?,?,?);";
108
109 // private void Awake()
110 // {
111 // string plaint = "Thieu Mao";
112 // string enc = bc.Encrypt(plaint, key);
113 // string dec = bc.Decrypt(enc, key);
114 //
115 // print("enc = " + enc);
116 // print("dec = " + dec);
117 // }
118
119 void Awake()
120 {
121 EncryptedPlayerPrefs.CreateKey();
122 key = EncryptedPlayerPrefs.GetString("keyAes");
123 }
124
125 // Use this for initialization
126 void Start()
127 {
128
129 print("Path: " + Application.persistentDataPath);
130 // list table
131 //tbl_HeroUser,tbl_LevelUser --> DataUser
132 //tbl_Boss tbl_Draw tbl_Energy tbl_Hero tbl_Level lbl_Skill tbl_UnlockHero --> DataGame
133
134 //updateHeroUser(int idHero, int level, int indexUnlock, int indexSkill, int attack)
135 //updateHeroUser(2,2,2,2,2);
136
137 createDataUser();
138 createDataGame();
139
140 //getHeroUser();
141 //getLevelUser();
142
143 //getBoss();
144 getDraw();
145 //getEnergy();
146 //getHero();
147 //getLevel();
148 //getSkill();
149 //getUnlockHero();
150 }
151
152 private void updateHeroUser(int idHero, int level, int indexUnlock, int indexSkill, int attack)
153 {
154 try
155 {
156 string pass = passSQLiteKit;
157
158 string filename = Application.persistentDataPath + "/" + "DataUser1";
159 SQLiteDB db = new SQLiteDB();
160 // and open again
161 db.Open(filename);
162 //
163 // set ENCRYPTION AGAIN, you could try change to see ENCRYPTION works
164 //
165 SQLiteQuery qr = new SQLiteQuery(db, pass);
166 qr.Step();
167 qr.Release();
168
169 string queryUpdate = "UPDATE tbl_herouser SET level_hero=" + "'" + level + "'" + ", attack=" + "'" + attack + "'" + " ,id_unlockhero=" + "'" + indexUnlock + "'" + ", id_skill=" + "'" + indexSkill + "'" + " WHERE id_hero=" + "'" + idHero + "'";
170 qr = new SQLiteQuery(db, queryUpdate);
171 qr.Step();
172 qr.Release();
173 db.Close();
174
175
176 }
177 catch (Exception e)
178 {
179 print(e.Message);
180 }
181 }
182
183 private void getHeroUser()
184 {
185 string pass = passSQLiteKit;
186
187 string filename = Application.persistentDataPath + "/" + DataUser;
188 SQLiteDB db = new SQLiteDB();
189 // and open again
190 db.Open(filename);
191 //
192 // set ENCRYPTION AGAIN, you could try change to see ENCRYPTION works
193 //
194 SQLiteQuery qr = new SQLiteQuery(db, pass);
195 qr.Step();
196 qr.Release();
197
198 qr = new SQLiteQuery(db, tbl_HeroUserSelect);
199 while (qr.Step())
200 {
201 if (!qr.IsNULL("id_hero")) qr.GetInteger("id_hero");
202 if (!qr.IsNULL("id_unlockhero")) qr.GetInteger("id_unlockhero");
203 if (!qr.IsNULL("id_skill")) qr.GetInteger("id_skill");
204 if (!qr.IsNULL("level_hero")) qr.GetInteger("level_hero");
205 if (!qr.IsNULL("attack")) qr.GetString("attack");
206 if (!qr.IsNULL("unlock")) qr.GetString("unlock");
207 if (!qr.IsNULL("unlock")) print("getHeroUser>> unlock>> " + bc.Decrypt(qr.GetString("unlock"), key));
208 }
209 qr.Release();
210 db.Close();
211 }
212
213 private void getLevelUser()
214 {
215 string pass = passSQLiteKit;
216
217 string filename = Application.persistentDataPath + "/" + DataUser;
218 SQLiteDB db = new SQLiteDB();
219 // and open again
220 db.Open(filename);
221 //
222 // set ENCRYPTION AGAIN, you could try change to see ENCRYPTION works
223 //
224 SQLiteQuery qr = new SQLiteQuery(db, pass);
225 qr.Step();
226 qr.Release();
227
228 qr = new SQLiteQuery(db, tbl_LevelUserSelect);
229 while (qr.Step())
230 {
231 if (!qr.IsNULL("id_level")) qr.GetInteger("id_level");
232 if (!qr.IsNULL("play")) qr.GetString("play");
233 if (!qr.IsNULL("unlock")) qr.GetString("unlock");
234 if (!qr.IsNULL("top_dame")) qr.GetString("top_dame");
235 if (!qr.IsNULL("top_move")) qr.GetString("top_move");
236 if (!qr.IsNULL("top_move")) bc.Decrypt("getLevelUser>> top_move>> " + qr.GetString("top_move"), key);
237 }
238 qr.Release();
239 db.Close();
240 }
241
242 private void getBoss()
243 {
244 string pass = passSQLiteKit;
245
246 string filename = Application.persistentDataPath + "/" + DataGame;
247 SQLiteDB db = new SQLiteDB();
248 // and open again
249 db.Open(filename);
250 //
251 // set ENCRYPTION AGAIN, you could try change to see ENCRYPTION works
252 //
253 SQLiteQuery qr = new SQLiteQuery(db, pass);
254 qr.Step();
255 qr.Release();
256
257 qr = new SQLiteQuery(db, tbl_BossSelect);
258 while (qr.Step())
259 {
260 if (!qr.IsNULL("id_boss")) qr.GetInteger("id_boss");
261 if (!qr.IsNULL("type")) qr.GetString("type");
262 if (!qr.IsNULL("id_level")) qr.GetInteger("id_level");
263 if (!qr.IsNULL("name_boss")) qr.GetString("name_boss");
264 if (!qr.IsNULL("blood")) qr.GetString("blood");
265 if (!qr.IsNULL("resist")) qr.GetString("resist");
266 if (!qr.IsNULL("special")) qr.GetString("special");
267 if (!qr.IsNULL("move")) qr.GetString("move");
268 if (!qr.IsNULL("blood_special")) qr.GetString("blood_special");
269 if (!qr.IsNULL("num_special")) qr.GetString("num_special");
270 if (!qr.IsNULL("img")) qr.GetString("img");
271 if (!qr.IsNULL("img")) print("getBoss>> img>> " + bc.Decrypt(qr.GetString("img"), key));
272 }
273 qr.Release();
274 db.Close();
275 }
276
277 private void getDraw()
278 {
279 print("getDraw");
280 string pass = passSQLiteKit;
281
282 string filename = Application.persistentDataPath + "/" + DataGame;
283 SQLiteDB db = new SQLiteDB();
284 // and open again
285 db.Open(filename);
286 //
287 // set ENCRYPTION AGAIN, you could try change to see ENCRYPTION works
288 //
289 SQLiteQuery qr = new SQLiteQuery(db, pass);
290 qr.Step();
291 qr.Release();
292
293 qr = new SQLiteQuery(db, tbl_DrawSelect);
294 while (qr.Step())
295 {
296 if (!qr.IsNULL("id")) qr.GetInteger("id");
297 if (!qr.IsNULL("note")) qr.GetString("note");
298 if (!qr.IsNULL("food_percent")) qr.GetString("food_percent");
299 if (!qr.IsNULL("food")) qr.GetString("food");
300 if (!qr.IsNULL("soul_percent")) qr.GetString("soul_percent");
301 if (!qr.IsNULL("soul")) qr.GetString("soul");
302 if (!qr.IsNULL("cube_percent")) qr.GetString("cube_percent");
303 if (!qr.IsNULL("cube")) qr.GetString("cube");
304 if (!qr.IsNULL("cube_buy")) qr.GetString("cube_buy");
305 if (!qr.IsNULL("cube_buy")) print("getDraw>> cube_buy>> " + bc.Decrypt(qr.GetString("cube_buy"), key));
306 }
307 qr.Release();
308 db.Close();
309 }
310
311 private void getEnergy()
312 {
313 string pass = passSQLiteKit;
314
315 string filename = Application.persistentDataPath + "/" + DataGame;
316 SQLiteDB db = new SQLiteDB();
317 // and open again
318 db.Open(filename);
319 //
320 // set ENCRYPTION AGAIN, you could try change to see ENCRYPTION works
321 //
322 SQLiteQuery qr = new SQLiteQuery(db, pass);
323 qr.Step();
324 qr.Release();
325
326 qr = new SQLiteQuery(db, tbl_EnergySelect);
327 while (qr.Step())
328 {
329 if (!qr.IsNULL("buy")) qr.GetString("buy");
330 if (!qr.IsNULL("note")) qr.GetString("note");
331 if (!qr.IsNULL("energy")) qr.GetString("energy");
332 if (!qr.IsNULL("energy_buy")) qr.GetString("energy_buy");
333 if (!qr.IsNULL("buy_cube")) qr.GetString("buy_cube");
334 if (!qr.IsNULL("energy_refill")) qr.GetString("energy_refill");
335 if (!qr.IsNULL("energy_refill")) print("getEnergy>> energy_refill>> " + bc.Decrypt(qr.GetString("energy_refill"), key));
336 }
337 qr.Release();
338 db.Close();
339 }
340
341 private void getHero()
342 {
343 string pass = passSQLiteKit;
344
345 string filename = Application.persistentDataPath + "/" + DataGame;
346 SQLiteDB db = new SQLiteDB();
347 // and open again
348 db.Open(filename);
349 //
350 // set ENCRYPTION AGAIN, you could try change to see ENCRYPTION works
351 //
352 SQLiteQuery qr = new SQLiteQuery(db, pass);
353 qr.Step();
354 qr.Release();
355
356 qr = new SQLiteQuery(db, tbl_HeroSelect);
357 while (qr.Step())
358 {
359 if (!qr.IsNULL("id_hero")) qr.GetInteger("id_hero");
360 if (!qr.IsNULL("map_open")) qr.GetString("map_open");
361 if (!qr.IsNULL("map_gift")) qr.GetString("map_gift");
362 if (!qr.IsNULL("type_hero")) qr.GetString("type_hero");
363 if (!qr.IsNULL("id_skill")) qr.GetInteger("id_skill");
364 if (!qr.IsNULL("name_hero")) qr.GetString("name_hero");
365 if (!qr.IsNULL("des")) qr.GetString("des");
366 if (!qr.IsNULL("food")) qr.GetString("food");
367 if (!qr.IsNULL("p_food")) qr.GetString("p_food");
368 if (!qr.IsNULL("soul")) qr.GetString("soul");
369 if (!qr.IsNULL("p_soul")) qr.GetString("p_soul");
370 if (!qr.IsNULL("cube")) qr.GetString("cube");
371 if (!qr.IsNULL("p_cube")) qr.GetString("p_cube");
372 if (!qr.IsNULL("shop_food")) qr.GetString("shop_food");
373 if (!qr.IsNULL("shop_soul")) qr.GetString("shop_soul");
374 if (!qr.IsNULL("shop_cube")) qr.GetString("shop_cube");
375 if (!qr.IsNULL("shop_cube")) print("getHero>> shop_cube>> " + bc.Decrypt(qr.GetString("shop_cube"), key));
376 }
377 qr.Release();
378 db.Close();
379 }
380
381 private void getLevel()
382 {
383 string pass = passSQLiteKit;
384
385 string filename = Application.persistentDataPath + "/" + DataGame;
386 SQLiteDB db = new SQLiteDB();
387 // and open again
388 db.Open(filename);
389 //
390 // set ENCRYPTION AGAIN, you could try change to see ENCRYPTION works
391 //
392 SQLiteQuery qr = new SQLiteQuery(db, pass);
393 qr.Step();
394 qr.Release();
395
396 qr = new SQLiteQuery(db, tbl_LevelSelect);
397 while (qr.Step())
398 {
399 if (!qr.IsNULL("id_level")) qr.GetInteger("id_level");
400 if (!qr.IsNULL("chapter")) qr.GetString("chapter");
401 if (!qr.IsNULL("name_level")) qr.GetString("name_level");
402 if (!qr.IsNULL("energy")) qr.GetString("energy");
403 if (!qr.IsNULL("w_crystal")) qr.GetString("w_crystal");
404 if (!qr.IsNULL("w_food")) qr.GetString("w_food");
405 if (!qr.IsNULL("w_soul")) qr.GetString("w_soul");
406 if (!qr.IsNULL("w_energy")) qr.GetString("w_energy");
407 if (!qr.IsNULL("w_ticket")) qr.GetString("w_ticket");
408 if (!qr.IsNULL("w_hero")) qr.GetString("w_hero");
409 if (!qr.IsNULL("q_move")) qr.GetString("q_move");
410 if (!qr.IsNULL("q_h1")) qr.GetString("q_h1");
411 if (!qr.IsNULL("q_h2")) qr.GetString("q_h2");
412 if (!qr.IsNULL("q_h3")) qr.GetString("q_h3");
413 if (!qr.IsNULL("q_h4")) qr.GetString("q_h4");
414 if (!qr.IsNULL("q_h5")) qr.GetString("q_h5");
415 if (!qr.IsNULL("q_box")) qr.GetString("q_box");
416 if (!qr.IsNULL("q_boss")) qr.GetString("q_boss");
417 if (!qr.IsNULL("q_food")) qr.GetString("q_food");
418 if (!qr.IsNULL("q_soul")) qr.GetString("q_soul");
419 if (!qr.IsNULL("q_ticket")) qr.GetString("q_ticket");
420 if (!qr.IsNULL("q_crystal")) qr.GetString("q_crystal");
421 if (!qr.IsNULL("q_hero")) qr.GetString("q_hero");
422 if (!qr.IsNULL("q_bom")) qr.GetString("q_bom");
423 if (!qr.IsNULL("log_win")) qr.GetString("log_win");
424 if (!qr.IsNULL("log_lose")) qr.GetString("log_lose");
425 if (!qr.IsNULL("log_lose")) print("getLevel>> log_lose>> " + bc.Decrypt(qr.GetString("log_lose"), key));
426 }
427 qr.Release();
428 db.Close();
429 }
430
431 private void getSkill()
432 {
433 string pass = passSQLiteKit;
434
435 string filename = Application.persistentDataPath + "/" + DataGame;
436 SQLiteDB db = new SQLiteDB();
437 // and open again
438 db.Open(filename);
439 //
440 // set ENCRYPTION AGAIN, you could try change to see ENCRYPTION works
441 //
442 SQLiteQuery qr = new SQLiteQuery(db, pass);
443 qr.Step();
444 qr.Release();
445
446 qr = new SQLiteQuery(db, tbl_SkillSelect);
447 while (qr.Step())
448 {
449 if (!qr.IsNULL("id_skill")) qr.GetInteger("id_skill");
450 if (!qr.IsNULL("type_skill")) qr.GetInteger("type_skill");
451 if (!qr.IsNULL("name_skill")) qr.GetString("name_skill");
452 if (!qr.IsNULL("level_skill")) qr.GetInteger("level_skill");
453 if (!qr.IsNULL("num_gem")) qr.GetString("num_gem");
454 if (!qr.IsNULL("dame")) qr.GetString("dame");
455 if (!qr.IsNULL("range")) qr.GetString("range");
456 if (!qr.IsNULL("des")) qr.GetString("des");
457 if (!qr.IsNULL("des")) print("getSkill>> des>> " + bc.Decrypt(qr.GetString("des"), key));
458 }
459 qr.Release();
460 db.Close();
461 }
462
463 private void getUnlockHero()
464 {
465 string pass = passSQLiteKit;
466
467 string filename = Application.persistentDataPath + "/" + DataGame;
468 SQLiteDB db = new SQLiteDB();
469 // and open again
470 db.Open(filename);
471 //
472 // set ENCRYPTION AGAIN, you could try change to see ENCRYPTION works
473 //
474 SQLiteQuery qr = new SQLiteQuery(db, pass);
475 qr.Step();
476 qr.Release();
477
478 qr = new SQLiteQuery(db, tbl_UnlockHeroSelect);
479 while (qr.Step())
480 {
481 if (!qr.IsNULL("id_unlockhero")) qr.GetInteger("id_unlockhero");
482 if (!qr.IsNULL("id_hero")) qr.GetInteger("id_hero");
483 if (!qr.IsNULL("level_hero")) qr.GetInteger("level_hero");
484 if (!qr.IsNULL("attack")) qr.GetString("attack");
485 if (!qr.IsNULL("soul")) qr.GetString("soul");
486 if (!qr.IsNULL("food")) qr.GetString("food");
487 if (!qr.IsNULL("crystal")) qr.GetString("crystal");
488 if (!qr.IsNULL("img")) qr.GetString("img");
489 if (!qr.IsNULL("img")) print("getUnlockHero>> img>> " + bc.Decrypt(qr.GetString("img"), key));
490 }
491 qr.Release();
492 db.Close();
493 }
494
495 private void createDataUser()
496 {
497 // string heykey = Md5Sum(password);
498 // string pass = "PRAGMA hexkey=\"0x" + heykey + "\";";
499 // pass = passSQLiteKit;
500 // if (!isPass) pass = "PRAGMA hex";
501 string pass = passSQLiteKit;
502
503 try
504 {
505 SQLiteDB db2 = null;
506
507 db2 = new SQLiteDB();
508 string filename = Application.persistentDataPath + "/" + DataUser;
509 File.Delete(filename);
510 db2.Open(filename);
511
512 //
513 // set ENCRYPTION
514 //
515 SQLiteQuery qr2 = new SQLiteQuery(db2, pass);
516 qr2.Step();
517 qr2.Release();
518
519 //
520 // create table
521 //
522 qr2 = new SQLiteQuery(db2, tbl_HeroUser);
523 qr2.Step();
524 qr2.Release();
525 qr2 = new SQLiteQuery(db2, tbl_LevelUser);
526 qr2.Step();
527 qr2.Release();
528
529 //
530 // insert table
531 //
532 converttbl_HeroUser(db2);
533 converttbl_LevelUser(db2);
534
535 // close
536 db2.Close();
537 }
538 catch (Exception e)
539 {
540 Debug.Log(e);
541 }
542 }
543
544 private void createDataGame()
545 {
546 // string heykey = Md5Sum(password);
547 // string pass = "PRAGMA hexkey=\"0x" + heykey + "\";";
548 // pass = passSQLiteKit;
549 // if (!isPass) pass = "PRAGMA hex";
550 string pass = passSQLiteKit;
551
552 try
553 {
554 SQLiteDB db3 = null;
555
556 db3 = new SQLiteDB();
557 string filename = Application.persistentDataPath + "/" + DataGame;
558 File.Delete(filename);
559 db3.Open(filename);
560
561 //print("mao " + filename);
562
563 //
564 // set ENCRYPTION
565 //
566 SQLiteQuery qr3 = new SQLiteQuery(db3, pass);
567 qr3.Step();
568 qr3.Release();
569
570 //
571 // create table
572 //
573 qr3 = new SQLiteQuery(db3, tbl_Boss);
574 qr3.Step();
575 qr3.Release();
576 qr3 = new SQLiteQuery(db3, tbl_Draw);
577 qr3.Step();
578 qr3.Release();
579 qr3 = new SQLiteQuery(db3, tbl_Energy);
580 qr3.Step();
581 qr3.Release();
582 qr3 = new SQLiteQuery(db3, tbl_Hero);
583 qr3.Step();
584 qr3.Release();
585 qr3 = new SQLiteQuery(db3, tbl_Level);
586 qr3.Step();
587 qr3.Release();
588 qr3 = new SQLiteQuery(db3, tbl_Skill);
589 qr3.Step();
590 qr3.Release();
591 qr3 = new SQLiteQuery(db3, tbl_UnlockHero);
592 qr3.Step();
593 qr3.Release();
594
595 //tbl_Boss tbl_Draw tbl_Energy tbl_Hero tbl_Level lbl_Skill tbl_UnlockHero
596
597 //
598 // insert table
599 //
600 converttbl_Boss(db3);
601 converttbl_Draw(db3);
602 converttbl_Energy(db3);
603 converttbl_Hero(db3);
604 converttbl_Level(db3);
605 converttbl_Skill(db3);
606 converttbl_UnlockHero(db3);
607
608 // close
609 db3.Close();
610 }
611 catch (Exception e)
612 {
613 print("loi " + e.Message);
614 }
615 }
616
617 private void converttbl_HeroUser(SQLiteDB db2)
618 {
619 LoadDatabase("DataUser");
620 SQLiteQuery qr = new SQLiteQuery(dbsql, tbl_HeroUserSelect);
621 while (qr.Step())
622 {
623 SQLiteQuery qr2 = new SQLiteQuery(db2, tbl_HeroUserInsert);
624 // if (!qr.IsNULL("id_hero")) qr2.Bind(qr.GetInteger("id_hero")); else qr2.BindNull();
625 // if (!qr.IsNULL("id_unlockhero")) qr2.Bind(qr.GetInteger("id_unlockhero")); else qr2.BindNull();
626 // if (!qr.IsNULL("id_skill")) qr2.Bind(qr.GetInteger("id_skill")); else qr2.BindNull();
627 // if (!qr.IsNULL("level_hero")) qr2.Bind(qr.GetInteger("level_hero")); else qr2.BindNull();
628 // if (!qr.IsNULL("attack")) qr2.Bind(qr.GetInteger("attack")); else qr2.BindNull();
629 // if (!qr.IsNULL("unlock")) qr2.Bind(qr.GetInteger("unlock")); else qr2.BindNull();
630 // 3 id ko ma hoa
631 // if (qr.IsNULL("id_hero")) qr2.BindNull(); else qr2.Bind(bc.Encrypt(qr.GetInteger("id_hero").ToString(), key));
632 // if (qr.IsNULL("id_unlockhero")) qr2.BindNull(); else qr2.Bind(bc.Encrypt(qr.GetInteger("id_unlockhero").ToString(), key));
633 // if (qr.IsNULL("id_skill")) qr2.BindNull(); else qr2.Bind(bc.Encrypt(qr.GetInteger("id_skill").ToString(), key));
634 // if (qr.IsNULL("level_hero")) qr2.BindNull(); else qr2.Bind(bc.Encrypt(qr.GetInteger("level_hero").ToString(), key));
635 if (!qr.IsNULL("id_hero")) qr2.Bind(qr.GetInteger("id_hero")); else qr2.BindNull();
636 if (!qr.IsNULL("id_unlockhero")) qr2.Bind(qr.GetInteger("id_unlockhero")); else qr2.BindNull();
637 if (!qr.IsNULL("id_skill")) qr2.Bind(qr.GetInteger("id_skill")); else qr2.BindNull();
638 if (!qr.IsNULL("level_hero")) qr2.Bind(qr.GetInteger("level_hero")); else qr2.BindNull();
639 if (qr.IsNULL("attack")) qr2.BindNull(); else qr2.Bind(bc.Encrypt(qr.GetInteger("attack").ToString(), key));
640 if (qr.IsNULL("unlock")) qr2.BindNull(); else qr2.Bind(bc.Encrypt(qr.GetInteger("unlock").ToString(), key));
641 qr2.Step();
642 qr2.Release();
643 }
644 }
645
646 private void converttbl_LevelUser(SQLiteDB db2)
647 {
648 LoadDatabase("DataUser");
649 SQLiteQuery qr = new SQLiteQuery(dbsql, tbl_LevelUserSelect);
650 while (qr.Step())
651 {
652 SQLiteQuery qr2 = new SQLiteQuery(db2, tbl_LevelUserInsert);
653 // if (!qr.IsNULL("id_level")) qr2.Bind(qr.GetInteger("id_level")); else qr2.BindNull();
654 // if (!qr.IsNULL("play")) qr2.Bind(qr.GetInteger("play")); else qr2.BindNull();
655 // if (!qr.IsNULL("unlock")) qr2.Bind(qr.GetInteger("unlock")); else qr2.BindNull();
656 // if (!qr.IsNULL("top_dame")) qr2.Bind(qr.GetInteger("top_dame")); else qr2.BindNull();
657 // if (!qr.IsNULL("top_move")) qr2.Bind(qr.GetInteger("top_move")); else qr2.BindNull();
658 // ko ma hoa id
659 // if (qr.IsNULL("id_level")) qr2.BindNull(); else qr2.Bind(bc.Encrypt(qr.GetInteger("id_level").ToString(), key));
660 if (!qr.IsNULL("id_level")) qr2.Bind(qr.GetInteger("id_level")); else qr2.BindNull();
661 if (qr.IsNULL("play")) qr2.BindNull(); else qr2.Bind(bc.Encrypt(qr.GetInteger("play").ToString(), key));
662 if (qr.IsNULL("unlock")) qr2.BindNull(); else qr2.Bind(bc.Encrypt(qr.GetInteger("unlock").ToString(), key));
663 if (qr.IsNULL("top_dame")) qr2.BindNull(); else qr2.Bind(bc.Encrypt(qr.GetInteger("top_dame").ToString(), key));
664 if (qr.IsNULL("top_move")) qr2.BindNull(); else qr2.Bind(bc.Encrypt(qr.GetInteger("top_move").ToString(), key));
665 qr2.Step();
666 qr2.Release();
667 }
668 }
669
670 private void converttbl_Boss(SQLiteDB db3)
671 {
672 LoadDatabase("DataGame");
673
674 SQLiteQuery qr = new SQLiteQuery(dbsql, tbl_BossSelect);
675 while (qr.Step())
676 {
677 SQLiteQuery qr3 = new SQLiteQuery(db3, tbl_BossInsert);
678 // if (!qr.IsNULL("id_boss")) qr3.Bind(qr.GetInteger("id_boss")); else qr3.BindNull();
679 // if (!qr.IsNULL("type")) qr3.Bind(qr.GetInteger("type")); else qr3.BindNull();
680 // if (!qr.IsNULL("id_level")) qr3.Bind(qr.GetInteger("id_level")); else qr3.BindNull();
681 // if (!qr.IsNULL("name_boss")) qr3.Bind(qr.GetString("name_boss")); else qr3.BindNull();
682 // if (!qr.IsNULL("blood")) qr3.Bind(qr.GetInteger("blood")); else qr3.BindNull();
683 // if (!qr.IsNULL("resist")) qr3.Bind(qr.GetInteger("resist")); else qr3.BindNull();
684 // if (!qr.IsNULL("special")) qr3.Bind(qr.GetInteger("special")); else qr3.BindNull();
685 // if (!qr.IsNULL("move")) qr3.Bind(qr.GetInteger("move")); else qr3.BindNull();
686 // if (!qr.IsNULL("blood_special")) qr3.Bind(qr.GetInteger("blood_special")); else qr3.BindNull();
687 // if (!qr.IsNULL("num_special")) qr3.Bind(qr.GetInteger("num_special")); else qr3.BindNull();
688 // if (!qr.IsNULL("img")) qr3.Bind(qr.GetString("img")); else qr3.BindNull();
689 // khong ma hoa id
690 // if (qr.IsNULL("id_boss")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("id_boss").ToString(), key));
691 if (!qr.IsNULL("id_boss")) qr3.Bind(qr.GetInteger("id_boss")); else qr3.BindNull();
692 if (qr.IsNULL("type")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("type").ToString(), key));
693 // if (qr.IsNULL("id_level")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("id_level").ToString(), key));
694 if (!qr.IsNULL("id_level")) qr3.Bind(qr.GetInteger("id_level")); else qr3.BindNull();
695 if (qr.IsNULL("name_boss")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetString("name_boss").ToString(), key));
696 if (qr.IsNULL("blood")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("blood").ToString(), key));
697 if (qr.IsNULL("resist")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("resist").ToString(), key));
698 if (qr.IsNULL("special")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("special").ToString(), key));
699 if (qr.IsNULL("move")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("move").ToString(), key));
700 if (qr.IsNULL("blood_special")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("blood_special").ToString(), key));
701 if (qr.IsNULL("num_special")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("num_special").ToString(), key));
702 if (qr.IsNULL("img")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetString("img").ToString(), key));
703 qr3.Step();
704 qr3.Release();
705 }
706 }
707
708 private void converttbl_Draw(SQLiteDB db3)
709 {
710 LoadDatabase("DataGame");
711
712 SQLiteQuery qr = new SQLiteQuery(dbsql, tbl_DrawSelect);
713 while (qr.Step())
714 {
715 SQLiteQuery qr3 = new SQLiteQuery(db3, tbl_DrawInsert);
716 // if (!qr.IsNULL("id")) qr3.Bind(qr.GetInteger("id")); else qr3.BindNull();
717 // if (!qr.IsNULL("note")) qr3.Bind(qr.GetInteger("note")); else qr3.BindNull();
718 // if (!qr.IsNULL("food_percent")) qr3.Bind(qr.GetString("food_percent")); else qr3.BindNull();
719 // if (!qr.IsNULL("food")) qr3.Bind(qr.GetInteger("food")); else qr3.BindNull();
720 // if (!qr.IsNULL("soul_percent")) qr3.Bind(qr.GetString("soul_percent")); else qr3.BindNull();
721 // if (!qr.IsNULL("soul")) qr3.Bind(qr.GetInteger("soul")); else qr3.BindNull();
722 // if (!qr.IsNULL("cube_percent")) qr3.Bind(qr.GetString("cube_percent")); else qr3.BindNull();
723 // if (!qr.IsNULL("cube")) qr3.Bind(qr.GetInteger("cube")); else qr3.BindNull();
724 // if (!qr.IsNULL("cube_buy")) qr3.Bind(qr.GetInteger("cube_buy")); else qr3.BindNull();
725 // khong ma hoa id
726 // if (qr.IsNULL("id")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("id").ToString(), key));
727
728 if (!qr.IsNULL("id")) qr3.Bind(qr.GetInteger("id")); else qr3.BindNull();
729 if (qr.IsNULL("note")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("note").ToString(), key));
730 if (qr.IsNULL("food_percent")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetString("food_percent").ToString(), key));
731 if (qr.IsNULL("food")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("food").ToString(), key));
732 if (qr.IsNULL("soul_percent")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetString("soul_percent").ToString(), key));
733 if (qr.IsNULL("soul")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("soul").ToString(), key));
734 if (qr.IsNULL("cube_percent")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetString("cube_percent").ToString(), key));
735 if (qr.IsNULL("cube")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("cube").ToString(), key));
736 if (qr.IsNULL("cube_buy")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("cube_buy").ToString(), key));
737 if (qr.IsNULL("tile")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("tile").ToString(), key));
738
739 qr3.Step();
740 qr3.Release();
741 }
742 }
743
744 private void converttbl_Energy(SQLiteDB db3)
745 {
746 LoadDatabase("DataGame");
747
748 SQLiteQuery qr = new SQLiteQuery(dbsql, tbl_EnergySelect);
749 while (qr.Step())
750 {
751 SQLiteQuery qr3 = new SQLiteQuery(db3, tbl_EnergyInsert);
752 // if (!qr.IsNULL("buy")) qr3.Bind(qr.GetInteger("buy")); else qr3.BindNull();
753 // if (!qr.IsNULL("note")) qr3.Bind(qr.GetInteger("note")); else qr3.BindNull();
754 // if (!qr.IsNULL("energy")) qr3.Bind(qr.GetInteger("energy")); else qr3.BindNull();
755 // if (!qr.IsNULL("energy_buy")) qr3.Bind(qr.GetInteger("energy_buy")); else qr3.BindNull();
756 // if (!qr.IsNULL("buy_cube")) qr3.Bind(qr.GetInteger("buy_cube")); else qr3.BindNull();
757 // if (!qr.IsNULL("energy_refill")) qr3.Bind(qr.GetString("energy_refill")); else qr3.BindNull();
758
759 // old
760 //if (qr.IsNULL("buy")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("buy").ToString(), key));
761 //if (qr.IsNULL("note")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("note").ToString(), key));
762 //if (qr.IsNULL("energy")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("energy").ToString(), key));
763 //if (qr.IsNULL("energy_buy")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("energy_buy").ToString(), key));
764 //if (qr.IsNULL("buy_cube")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("buy_cube").ToString(), key));
765 //if (qr.IsNULL("energy_refill")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetString("energy_refill").ToString(), key));
766
767 if (qr.IsNULL("num_buy")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("num_buy").ToString(), key));
768 if (qr.IsNULL("note")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("note").ToString(), key));
769 if (qr.IsNULL("energy")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("energy").ToString(), key));
770 if (qr.IsNULL("energy_max")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("energy_max").ToString(), key));
771 if (qr.IsNULL("gold_full")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("gold_full").ToString(), key));
772 if (qr.IsNULL("gold_max")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("gold_max").ToString(), key));
773 qr3.Step();
774 qr3.Release();
775 }
776 }
777
778 private void converttbl_Hero(SQLiteDB db3)
779 {
780 LoadDatabase("DataGame");
781
782 SQLiteQuery qr = new SQLiteQuery(dbsql, tbl_HeroSelect);
783 while (qr.Step())
784 {
785 SQLiteQuery qr3 = new SQLiteQuery(db3, tbl_HeroInsert);
786 // if (!qr.IsNULL("id_hero")) qr3.Bind(qr.GetInteger("id_hero")); else qr3.BindNull();
787 // if (!qr.IsNULL("map_open")) qr3.Bind(qr.GetInteger("map_open")); else qr3.BindNull();
788 // if (!qr.IsNULL("map_gift")) qr3.Bind(qr.GetInteger("map_gift")); else qr3.BindNull();
789 // if (!qr.IsNULL("type_hero")) qr3.Bind(qr.GetInteger("type_hero")); else qr3.BindNull();
790 // if (!qr.IsNULL("id_skill")) qr3.Bind(qr.GetInteger("id_skill")); else qr3.BindNull();
791 // if (!qr.IsNULL("name_hero")) qr3.Bind(qr.GetString("name_hero")); else qr3.BindNull();
792 // if (!qr.IsNULL("des")) qr3.Bind(qr.GetString("des")); else qr3.BindNull();
793 // if (!qr.IsNULL("food")) qr3.Bind(qr.GetInteger("food")); else qr3.BindNull();
794 // if (!qr.IsNULL("p_food")) qr3.Bind(qr.GetString("p_food")); else qr3.BindNull();
795 // if (!qr.IsNULL("soul")) qr3.Bind(qr.GetInteger("soul")); else qr3.BindNull();
796 // if (!qr.IsNULL("p_soul")) qr3.Bind(qr.GetString("p_soul")); else qr3.BindNull();
797 // if (!qr.IsNULL("cube")) qr3.Bind(qr.GetInteger("cube")); else qr3.BindNull();
798 // if (!qr.IsNULL("p_cube")) qr3.Bind(qr.GetString("p_cube")); else qr3.BindNull();
799 // if (!qr.IsNULL("shop_food")) qr3.Bind(qr.GetInteger("shop_food")); else qr3.BindNull();
800 // if (!qr.IsNULL("shop_soul")) qr3.Bind(qr.GetInteger("shop_soul")); else qr3.BindNull();
801 // if (!qr.IsNULL("shop_cube")) qr3.Bind(qr.GetInteger("shop_cube")); else qr3.BindNull();
802 // khong ma hoa id
803 // if (qr.IsNULL("id_hero")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("id_hero").ToString(), key));
804
805 // old
806 //if (!qr.IsNULL("id_hero")) qr3.Bind(qr.GetInteger("id_hero")); else qr3.BindNull();
807 //if (qr.IsNULL("map_open")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("map_open").ToString(), key));
808 //if (qr.IsNULL("map_gift")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("map_gift").ToString(), key));
809 //if (qr.IsNULL("type_hero")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("type_hero").ToString(), key));
810 //// if (qr.IsNULL("id_skill")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("id_skill").ToString(), key));
811 //if (!qr.IsNULL("id_skill")) qr3.Bind(qr.GetInteger("id_skill")); else qr3.BindNull();
812 //if (qr.IsNULL("name_hero")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetString("name_hero").ToString(), key));
813 //if (qr.IsNULL("des")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetString("des").ToString(), key));
814 //if (qr.IsNULL("food")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("food").ToString(), key));
815 //if (qr.IsNULL("p_food")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetString("p_food").ToString(), key));
816 //if (qr.IsNULL("soul")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("soul").ToString(), key));
817 //if (qr.IsNULL("p_soul")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetString("p_soul").ToString(), key));
818 //if (qr.IsNULL("cube")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("cube").ToString(), key));
819 //if (qr.IsNULL("p_cube")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetString("p_cube").ToString(), key));
820 //if (qr.IsNULL("shop_food")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("shop_food").ToString(), key));
821 //if (qr.IsNULL("shop_soul")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("shop_soul").ToString(), key));
822 //if (qr.IsNULL("shop_cube")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("shop_cube").ToString(), key));
823
824 if (!qr.IsNULL("id_hero")) qr3.Bind(qr.GetInteger("id_hero")); else qr3.BindNull();
825 if (qr.IsNULL("chapter")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("chapter").ToString(), key));
826 if (qr.IsNULL("map_open")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("map_open").ToString(), key));
827 if (qr.IsNULL("map_gift")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("map_gift").ToString(), key));
828 if (qr.IsNULL("type_hero")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("type_hero").ToString(), key));
829 // if (qr.IsNULL("id_skill")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("id_skill").ToString(), key));
830 if (!qr.IsNULL("id_skill")) qr3.Bind(qr.GetInteger("id_skill")); else qr3.BindNull();
831 if (qr.IsNULL("name_hero")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetString("name_hero").ToString(), key));
832 if (qr.IsNULL("des")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetString("des").ToString(), key));
833 if (qr.IsNULL("value")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("value").ToString(), key));
834 if (qr.IsNULL("draw_type")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("draw_type").ToString(), key));
835 if (qr.IsNULL("draw_value")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("draw_value").ToString(), key));
836 if (qr.IsNULL("draw_prent")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetString("draw_prent").ToString(), key));
837 qr3.Step();
838 qr3.Release();
839 }
840 }
841
842 private void converttbl_Level(SQLiteDB db3)
843 {
844 LoadDatabase("DataGame");
845
846 SQLiteQuery qr = new SQLiteQuery(dbsql, tbl_LevelSelect);
847 while (qr.Step())
848 {
849 SQLiteQuery qr3 = new SQLiteQuery(db3, tbl_LevelInsert);
850 // if (!qr.IsNULL("id_level")) qr3.Bind(qr.GetInteger("id_level")); else qr3.BindNull();
851 // if (!qr.IsNULL("chapter")) qr3.Bind(qr.GetInteger("chapter")); else qr3.BindNull();
852 // if (!qr.IsNULL("name_level")) qr3.Bind(qr.GetString("name_level")); else qr3.BindNull();
853 // if (!qr.IsNULL("energy")) qr3.Bind(qr.GetInteger("energy")); else qr3.BindNull();
854 // if (!qr.IsNULL("w_crystal")) qr3.Bind(qr.GetInteger("w_crystal")); else qr3.BindNull();
855 // if (!qr.IsNULL("w_food")) qr3.Bind(qr.GetInteger("w_food")); else qr3.BindNull();
856 // if (!qr.IsNULL("w_soul")) qr3.Bind(qr.GetInteger("w_soul")); else qr3.BindNull();
857 // if (!qr.IsNULL("w_energy")) qr3.Bind(qr.GetInteger("w_energy")); else qr3.BindNull();
858 // if (!qr.IsNULL("w_ticket")) qr3.Bind(qr.GetInteger("w_ticket")); else qr3.BindNull();
859 // if (!qr.IsNULL("w_hero")) qr3.Bind(qr.GetInteger("w_hero")); else qr3.BindNull();
860 // if (!qr.IsNULL("q_move")) qr3.Bind(qr.GetInteger("q_move")); else qr3.BindNull();
861 // if (!qr.IsNULL("q_h1")) qr3.Bind(qr.GetInteger("q_h1")); else qr3.BindNull();
862 // if (!qr.IsNULL("q_h2")) qr3.Bind(qr.GetInteger("q_h2")); else qr3.BindNull();
863 // if (!qr.IsNULL("q_h3")) qr3.Bind(qr.GetInteger("q_h3")); else qr3.BindNull();
864 // if (!qr.IsNULL("q_h4")) qr3.Bind(qr.GetInteger("q_h4")); else qr3.BindNull();
865 // if (!qr.IsNULL("q_h5")) qr3.Bind(qr.GetInteger("q_h5")); else qr3.BindNull();
866 // if (!qr.IsNULL("q_box")) qr3.Bind(qr.GetInteger("q_box")); else qr3.BindNull();
867 // if (!qr.IsNULL("q_boss")) qr3.Bind(qr.GetInteger("q_boss")); else qr3.BindNull();
868 // if (!qr.IsNULL("q_food")) qr3.Bind(qr.GetInteger("q_food")); else qr3.BindNull();
869 // if (!qr.IsNULL("q_soul")) qr3.Bind(qr.GetInteger("q_soul")); else qr3.BindNull();
870 // if (!qr.IsNULL("q_ticket")) qr3.Bind(qr.GetInteger("q_ticket")); else qr3.BindNull();
871 // if (!qr.IsNULL("q_crystal")) qr3.Bind(qr.GetInteger("q_crystal")); else qr3.BindNull();
872 // if (!qr.IsNULL("q_hero")) qr3.Bind(qr.GetInteger("q_hero")); else qr3.BindNull();
873 // if (!qr.IsNULL("q_bom")) qr3.Bind(qr.GetInteger("q_bom")); else qr3.BindNull();
874 // if (!qr.IsNULL("log_win")) qr3.Bind(qr.GetString("log_win")); else qr3.BindNull();
875 // if (!qr.IsNULL("log_lose")) qr3.Bind(qr.GetString("log_lose")); else qr3.BindNull();
876 // khong ma hoa id
877 // if (qr.IsNULL("id_level")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("id_level").ToString(), key));
878
879 // old
880 //if (!qr.IsNULL("id_level")) qr3.Bind(qr.GetInteger("id_level")); else qr3.BindNull();
881 //if (qr.IsNULL("chapter")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("chapter").ToString(), key));
882 //if (qr.IsNULL("name_level")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetString("name_level").ToString(), key));
883 //if (qr.IsNULL("energy")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("energy").ToString(), key));
884 //if (qr.IsNULL("w_crystal")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("w_crystal").ToString(), key));
885 //if (qr.IsNULL("w_food")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("w_food").ToString(), key));
886 //if (qr.IsNULL("w_soul")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("w_soul").ToString(), key));
887 //if (qr.IsNULL("w_energy")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("w_energy").ToString(), key));
888 //if (qr.IsNULL("w_ticket")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("w_ticket").ToString(), key));
889 //if (qr.IsNULL("w_hero")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("w_hero").ToString(), key));
890 //if (qr.IsNULL("q_move")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("q_move").ToString(), key));
891 //if (qr.IsNULL("q_h1")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("q_h1").ToString(), key));
892 //if (qr.IsNULL("q_h2")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("q_h2").ToString(), key));
893 //if (qr.IsNULL("q_h3")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("q_h3").ToString(), key));
894 //if (qr.IsNULL("q_h4")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("q_h4").ToString(), key));
895 //if (qr.IsNULL("q_h5")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("q_h5").ToString(), key));
896 //if (qr.IsNULL("q_box")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("q_box").ToString(), key));
897 //if (qr.IsNULL("q_boss")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("q_boss").ToString(), key));
898 //if (qr.IsNULL("q_food")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("q_food").ToString(), key));
899 //if (qr.IsNULL("q_soul")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("q_soul").ToString(), key));
900 //if (qr.IsNULL("q_ticket")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("q_ticket").ToString(), key));
901 //if (qr.IsNULL("q_crystal")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("q_crystal").ToString(), key));
902 //if (qr.IsNULL("q_hero")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("q_hero").ToString(), key));
903 //if (qr.IsNULL("q_bom")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("q_bom").ToString(), key));
904 //if (qr.IsNULL("log_win")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetString("log_win").ToString(), key));
905 //if (qr.IsNULL("log_lose")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetString("log_lose").ToString(), key));
906
907 if (!qr.IsNULL("id_level")) qr3.Bind(qr.GetInteger("id_level")); else qr3.BindNull();
908 if (qr.IsNULL("chapter")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("chapter").ToString(), key));
909 if (qr.IsNULL("name_level")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetString("name_level").ToString(), key));
910 if (qr.IsNULL("name_image")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetString("name_image").ToString(), key));
911 if (qr.IsNULL("energy")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("energy").ToString(), key));
912 if (qr.IsNULL("w_crystal")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("w_crystal").ToString(), key));
913 if (qr.IsNULL("w_food")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("w_food").ToString(), key));
914 if (qr.IsNULL("w_soul")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("w_soul").ToString(), key));
915 if (qr.IsNULL("w_energy")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("w_energy").ToString(), key));
916 if (qr.IsNULL("w_ticket")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("w_ticket").ToString(), key));
917 if (qr.IsNULL("w_hero")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("w_hero").ToString(), key));
918 if (qr.IsNULL("q_move")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("q_move").ToString(), key));
919 if (qr.IsNULL("q_h1")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("q_h1").ToString(), key));
920 if (qr.IsNULL("q_h2")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("q_h2").ToString(), key));
921 if (qr.IsNULL("q_h3")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("q_h3").ToString(), key));
922 if (qr.IsNULL("q_h4")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("q_h4").ToString(), key));
923 if (qr.IsNULL("q_h5")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("q_h5").ToString(), key));
924 if (qr.IsNULL("q_box")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("q_box").ToString(), key));
925 if (qr.IsNULL("q_boss")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("q_boss").ToString(), key));
926 if (qr.IsNULL("q_food")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("q_food").ToString(), key));
927 if (qr.IsNULL("q_soul")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("q_soul").ToString(), key));
928 if (qr.IsNULL("q_ticket")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("q_ticket").ToString(), key));
929 if (qr.IsNULL("q_crystal")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("q_crystal").ToString(), key));
930 if (qr.IsNULL("q_hero")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("q_hero").ToString(), key));
931 if (qr.IsNULL("q_bom")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("q_bom").ToString(), key));
932 if (qr.IsNULL("log_win")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetString("log_win").ToString(), key));
933 if (qr.IsNULL("log_lose")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetString("log_lose").ToString(), key));
934 qr3.Step();
935 qr3.Release();
936 }
937 }
938
939 private void converttbl_Skill(SQLiteDB db3)
940 {
941 LoadDatabase("DataGame");
942
943 SQLiteQuery qr = new SQLiteQuery(dbsql, tbl_SkillSelect);
944 while (qr.Step())
945 {
946 SQLiteQuery qr3 = new SQLiteQuery(db3, tbl_SkillInsert);
947 // if (!qr.IsNULL("id_skill")) qr3.Bind(qr.GetInteger("id_skill")); else qr3.BindNull();
948 // if (!qr.IsNULL("type_skill")) qr3.Bind(qr.GetInteger("type_skill")); else qr3.BindNull();
949 // if (!qr.IsNULL("name_skill")) qr3.Bind(qr.GetString("name_skill")); else qr3.BindNull();
950 // if (!qr.IsNULL("level_skill")) qr3.Bind(qr.GetInteger("level_skill")); else qr3.BindNull();
951 // if (!qr.IsNULL("num_gem")) qr3.Bind(qr.GetInteger("num_gem")); else qr3.BindNull();
952 // if (!qr.IsNULL("dame")) qr3.Bind(qr.GetInteger("dame")); else qr3.BindNull();
953 // if (!qr.IsNULL("range")) qr3.Bind(qr.GetInteger("range")); else qr3.BindNull();
954 // if (!qr.IsNULL("des")) qr3.Bind(qr.GetString("des")); else qr3.BindNull();
955 // khong ma hoa id va level skill va type skill
956 // if (qr.IsNULL("id_skill")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("id_skill").ToString(), key));
957 if (!qr.IsNULL("id_skill")) qr3.Bind(qr.GetInteger("id_skill")); else qr3.BindNull();
958// if (qr.IsNULL("type_skill")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("type_skill").ToString(), key));
959 if (!qr.IsNULL("type_skill")) qr3.Bind(qr.GetInteger("type_skill")); else qr3.BindNull();
960 if (qr.IsNULL("name_skill")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetString("name_skill").ToString(), key));
961// if (qr.IsNULL("level_skill")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("level_skill").ToString(), key));
962 if (!qr.IsNULL("level_skill")) qr3.Bind(qr.GetInteger("level_skill")); else qr3.BindNull();
963 if (qr.IsNULL("num_gem")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("num_gem").ToString(), key));
964 if (qr.IsNULL("dame")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("dame").ToString(), key));
965 if (qr.IsNULL("range")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("range").ToString(), key));
966 if (qr.IsNULL("des")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetString("des").ToString(), key));
967 qr3.Step();
968 qr3.Release();
969 }
970 }
971
972 private void converttbl_UnlockHero(SQLiteDB db3)
973 {
974 //print("Unlockhero vao roi");
975 LoadDatabase("DataGame");
976
977 SQLiteQuery qr = new SQLiteQuery(dbsql, tbl_UnlockHeroSelect);
978 while (qr.Step())
979 {
980 SQLiteQuery qr3 = new SQLiteQuery(db3, tbl_UnlockHeroInsert);
981 // if (!qr.IsNULL("id_unlockhero")) qr3.Bind(qr.GetInteger("id_unlockhero")); else qr3.BindNull();
982 // if (!qr.IsNULL("id_hero")) qr3.Bind(qr.GetInteger("id_hero")); else qr3.BindNull();
983 // if (!qr.IsNULL("level_hero")) qr3.Bind(qr.GetInteger("level_hero")); else qr3.BindNull();
984 // if (!qr.IsNULL("attack")) qr3.Bind(qr.GetInteger("attack")); else qr3.BindNull();
985 // if (!qr.IsNULL("soul")) qr3.Bind(qr.GetInteger("soul")); else qr3.BindNull();
986 // if (!qr.IsNULL("food")) qr3.Bind(qr.GetInteger("food")); else qr3.BindNull();
987 // if (!qr.IsNULL("crystal")) qr3.Bind(qr.GetInteger("crystal")); else qr3.BindNull();
988 // if (!qr.IsNULL("img")) qr3.Bind(qr.GetString("img")); else qr3.BindNull();
989 // khong ma hoa id va level
990 // if (qr.IsNULL("id_unlockhero")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("id_unlockhero").ToString(), key));
991 // if (qr.IsNULL("id_hero")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("id_hero").ToString(), key));
992 // if (qr.IsNULL("level_hero")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("level_hero").ToString(), key));
993 if (!qr.IsNULL("id_unlockhero")) qr3.Bind(qr.GetInteger("id_unlockhero")); else qr3.BindNull();
994 if (!qr.IsNULL("id_hero")) qr3.Bind(qr.GetInteger("id_hero")); else qr3.BindNull();
995 if (!qr.IsNULL("level_hero")) qr3.Bind(qr.GetInteger("level_hero")); else qr3.BindNull();
996 if (qr.IsNULL("attack")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("attack").ToString(), key));
997 if (qr.IsNULL("soul")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("soul").ToString(), key));
998 if (qr.IsNULL("food")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("food").ToString(), key));
999 if (qr.IsNULL("crystal")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetInteger("crystal").ToString(), key));
1000 if (qr.IsNULL("img")) qr3.BindNull(); else qr3.Bind(bc.Encrypt(qr.GetString("img").ToString(), key));
1001 qr3.Step();
1002 qr3.Release();
1003 }
1004 }
1005
1006 private void LoadDatabase(String nameDb)
1007 {
1008 //print("Co vao day");
1009 dbsql = new SQLiteDB();
1010
1011 String filename = Application.persistentDataPath + "/" + nameDb;
1012
1013 // check if database already exists.
1014 if (!File.Exists(filename))
1015 {
1016 UnityEngine.Debug.Log("file does not exist");
1017 // ok , this is first time application start!
1018 // so lets copy prebuild dtabase from StreamingAssets and load store to persistancePath with Test2
1019 byte[] bytes = null;
1020#if UNITY_EDITOR || UNITY_STANDALONE_WIN || UNITY_STANDALONE_OSX
1021 string dbpath = "file://" + Application.streamingAssetsPath + "/" + nameDb;
1022 WWW www = new WWW(dbpath);
1023 StartCoroutine(Download(www));
1024 bytes = www.bytes;
1025#elif UNITY_WEBPLAYER
1026 string dbpath = "StreamingAssets/" + nameDb;
1027 WWW www = new WWW(dbpath);
1028 StartCoroutine(Download(www));
1029 bytes = www.bytes;
1030#elif UNITY_IPHONE
1031 string dbpath = Application.dataPath + "/Raw/" + nameDb;
1032 try{
1033 using ( FileStream fs = new FileStream(dbpath, FileMode.Open, FileAccess.Read, FileShare.Read) ){
1034 bytes = new byte[fs.Length];
1035 fs.Read(bytes,0,(int)fs.Length);
1036 }
1037 } catch (Exception e){
1038
1039 }
1040#elif UNITY_ANDROID
1041
1042 UnityEngine.Debug.Log("UNITY_ANDROID");
1043 string dbpath = Application.streamingAssetsPath + "/" + nameDb;
1044 UnityEngine.Debug.Log(dbpath);
1045 WWW www = new WWW(dbpath);
1046 StartCoroutine(Download(www));
1047 while(!www.isDone){}
1048 bytes = www.bytes;
1049#endif
1050
1051 if (bytes != null)
1052 {
1053 try
1054 {
1055 // copy database to real file into cache folder
1056 using (FileStream fs = new FileStream(filename, FileMode.OpenOrCreate, FileAccess.Write))
1057 {
1058 fs.Write(bytes, 0, bytes.Length);
1059 }
1060
1061 // initialize database
1062 dbsql.Open(filename);
1063 }
1064 catch (Exception e)
1065 {
1066 Debug.Log("ERROR: " + e);
1067 }
1068 }
1069 }
1070 else
1071 {
1072 // it mean we already download prebuild data base and store into persistantPath
1073 // lest update, I will call Test
1074
1075 try
1076 {
1077 // initialize database
1078 dbsql.Open(filename);
1079 }
1080 catch (Exception e)
1081 {
1082 Debug.Log("ERROR: " + e);
1083 }
1084
1085 }
1086 }
1087
1088 IEnumerator Download(WWW www)
1089 {
1090 yield return www;
1091 }
1092}