using UnityEngine;
using UnityEngine.UI;
using System.Collections;
using Mono.Data.Sqlite;
using System.Data;
using System.IO;
using System;
public class visible : MonoBehaviour {
// Update is called once per frame
public SqliteConnection con_db;
public SqliteCommand cmd_db;
public SqliteDataReader rdr;
public string path;
public void connection()
{
try
{
if (Application.platform != RuntimePlatform.Android)
{
path = Application.dataPath + "/airdatabase.db";
}
else
{
path = Application.persistentDataPath + "/airdatabase.db";
if (!File.Exists(path))
{
WWW load = new WWW("jar:file://" + Application.dataPath + "!/assets/" + "StreamingAssets/airdatabase.db");
while (!load.isDone) { }
File.WriteAllBytes(path, load.bytes);
}
}
// para sa pagopen ng detabase
con_db = new SqliteConnection(“URI=file:” + path);
con_db.Open();
}
catch (Exception ex)
{
text.text = ex.ToString();
}
}
private void Disconnect()
{
con_db.Close();
con_db.Dispose();
}
private void accounts()
{
try
{
connection();
cmd_db = new SqliteCommand("SELECT Player FROM Account", con_db);
rdr = cmd_db.ExecuteReader();
while (rdr.Read())
{
text.text = rdr[0].ToString();
}
}
catch (Exception ex)
{
text.text = ex.ToString();
}