protected override void Awake()
        {
            base.Awake();

#if UNITY_EDITOR
            PlayerSettings.bundleVersion = buildVersion;

            // set db
            // The example does not use the auto-generation db and table(DDL).
            Sqlite sql = new Sqlite();
            if (sql.CreateFile("hellgate.db"))
            {
                sql.CreateTable("hellgate.db", new Board().GetType());
                sql.CreateTable("hellgate.db", new Comment().GetType());
            }

//        if (sql.CreateFile ("Hellgate.db")) {
//            sql.ExecuteNonQuery ("CREATE TABLE `board` ( " +
//            "`idx` INTEGER PRIMARY KEY AUTOINCREMENT, " +
//            "`name` TEXT, " +
//            "`description` TEXT " +
//            ");");
//        }
#endif

            // add BGM
            SoundManager.Instance.AddBGM(bgm);
            SoundManager.Instance.PlayBGM();
        }
Example #2
0
        private void CreateTables()
        {
            // PLayer Table
            try
            {
                //sqlcon.DeleteTable<Players>();
                sqlcon.CreateTable <Players>();
            }
            catch (Exception ex)
            {
            }


            // Games Table
            sqlcon.CreateTable <Games>();
        }
Example #3
0
 private void Form1_Load(object sender, EventArgs e)
 {
     Sqlite.Sqlinit();
     timer1.Start();
     metroLabel1.Text = "版本:" + System.Reflection.Assembly.GetExecutingAssembly().GetName().Version.ToString();
     Sqlite.CreateTable("OutTable", new string[] { "ID", "Email", "Name", "Password", "CreatTime" }, new string[] { "integer", "text", "text", "text", "text" });
     Untils.Filldgv("OutTable", dgv_OL);
     Sqlite.CreateTable("EATable", new string[] { "ID", "Email", "Name", "Password", "CreatTime" }, new string[] { "integer", "text", "text", "text", "text" });
     Untils.Filldgv("EATable", dgv_EA);
     Sqlite.CreateTable("ProtonTable", new string[] { "ID", "Email", "Name", "Password", "CreatTime" }, new string[] { "integer", "text", "text", "text", "text" });
     Untils.Filldgv("ProtonTable", dgv_pro);
 }