// 外部スクリプトで書く↓↓
// 仮のランキング上位プレイヤーをインサート
private void DefaultPlayer()
{
int already = 1000;
// 重複のインサートを避ける
string selectQuery = "select * from user where user_id = " + already;
DataTable alreadyTable = sqlDB.ExecuteQuery(selectQuery);
foreach (DataRow dr in alreadyTable.Rows)
{
if ((int)dr["user_id"] == already)
{
Debug.Log("既に存在している。");
return;
}
}
int score_num = 50;
int frame_rnd = 0;
// 初期ランキング上位者を設定してインサート
for (int i = 1; i <= 5; i++)
{
frame_rnd = Random.Range(frame_min, frame_max);
string insertQuery = "insert into user values("
+ already + ", 'techc', 0, "
+ (score_num * i) + ", "
+ frame_rnd + ", 0)";
sqlDB.ExecuteNonQuery(insertQuery);
already++;
}
}
public static void Insert(string table, Dictionary <string, string> data)
{
string keys = String.Join(",", new List <string>(data.Keys));
string values = String.Join(",", new List <string>(data.Values));
string query = $"insert into {table} ({keys}) values ({values})";
db.ExecuteNonQuery(query);
}
// user_data テーブル内 gacha_point 値を 1 加算
public void AddGachaPoint()
{
int addnum = this.gacha_point + 1;
Debug.Log("addgachapoint method = " + addnum);
string query = "update user_data set gacha_point = " + addnum + " where gacha_point = " + gacha_point;
sqlDB.ExecuteNonQuery(query);
//text.text = addnum.ToString();
check = true;
}
/// <summary>
/// 主キーを指定して該当するデータを削除する
/// </summary>
/// <param name="id">主キー</param>
public void DeleteFromPrimaryKey(int id)
{
StringBuilder query = new StringBuilder();
query.Append("DELETE FROM ");
query.Append(TableName);
query.Append(" WHERE ");
query.Append(PrimaryKeyName);
query.Append("=");
query.Append(id.ToString());
query.Append(";");
mDb.ExecuteNonQuery(query.ToString());
}
/// <summary>
/// userDB初期化
/// </summary>
public void SaveGameStart()
{
DB = new DiceGameDB()
{
userID = userId++,
userName = "",
password = 0000,
score = 0,
frame = 0,
point = 0
};
string query = "insert into user values(" + DB.userID + ", " + DB.userName + ", " + DB.password + ", " + DB.score + ", " + DB.frame + ", " + DB.point + ")";
sqlDB.ExecuteNonQuery(query);
}
public void jsonInsert(int id, string json)
{
sqlDB = new SqliteDatabase(DB + "db");
string query = "INSERT INTO VALUES(" + id + "'" + tableName + "');";
sqlDB.ExecuteNonQuery(query);
}
public void jsonUpdate(int id, string json)
{
sqlDB = new SqliteDatabase(DB + "db");
string query = "UPDATE " + tableName + " SET json = '" + json + "' WHERE id = " + id + ";";
sqlDB.ExecuteNonQuery(query);
}
public void InsertItem()
{
if (idField.text != "" && nameField.text != "" && contactField.text != "")
{
string id = "'" + idField.text + "'";
string name = "'" + nameField.text + "'";
string contact = "'" + contactField.text + "'";
//string id= "'2'";
//string name = "'test'";
//string contact = "'99999'";
SqliteDatabase dbName = new SqliteDatabase("testDb.db");
string insertQuery = "INSERT INTO profile(id , name , contact) VALUES(" + id + "," + name + "," + contact + ")";
try
{
dbName.ExecuteNonQuery(insertQuery);
}
catch (System.Exception e)
{
Debug.Log("Already exists");
}
idField.text = "";
nameField.text = "";
contactField.text = "";
QueryItem();
}
}
void ClearDatabase()
{
SqliteDatabase dbName = new SqliteDatabase("testDb.db");
string deleteQuery = "DELETE from profile WHERE 1";
dbName.ExecuteNonQuery(deleteQuery);
}
// DBの時刻を現在時刻に更新
public void Update_time()
{
DateTime putTime = DateTime.Now;
string query = "update time_check_24 set time_24_year = " + putTime.Year + ", time_24_month = " + putTime.Month + ", time_24_day = " + putTime.Day +
", time_24_hour = " + putTime.Hour + ", time_24_minut = " + putTime.Minute + ", time_24_sec = " + putTime.Second + " where time_24_day = " + date[2];
sqlDB.ExecuteNonQuery(query);
}
void Start()
{
//打开测试数据库
Sqlite = new SqliteDatabase("test.db");
//添加数据
Sqlite.ExecuteNonQuery("insert into example (id, name) values(1, 'test name')");
PrintData();
}
public static void setFavo(string no)
{
SqliteDatabase sqlite = new SqliteDatabase("shinkeisei.db");
string sql = @"UPDATE user_info SET station = """ + no + @""";";
sqlite.ExecuteNonQuery(sql);
FavoStation = no;
}
IEnumerator PostData(WWWForm form, string root)
{
string url = serverUrl + root + "/" + "?key=" + key;
using (UnityWebRequest www = UnityWebRequest.Post(url, form))
{
www.SetRequestHeader("Content-Type", "application/x-www-form-urlencoded");
yield return(www.SendWebRequest());
if (www.isNetworkError || www.isHttpError)
{
Debug.Log(www.error);
}
else
{
string userId = "";
string data = www.downloadHandler.text;
string[] strList = data.Split(',');
foreach (string str in strList)
{
string[] strListSub = str.Split(':');
if (strListSub[0] == "{\"userId\"")
{
userId = strListSub[1];
break;
}
}
int userIdInt = int.Parse(userId);
SqliteDatabase sqlDB = new SqliteDatabase("config.db");
string query = "drop table user";
sqlDB.ExecuteNonQuery(query);
query = "create table user(userId ingeger, name string)";
sqlDB.ExecuteNonQuery(query);
string querysecond = "insert into user values(" + userIdInt + ", '" + userName + "')";
sqlDB.ExecuteNonQuery(querysecond);
//Debug.Log(data);
Debug.Log("Form upload complete!");
SceneManager.LoadScene("PhotonRoom");
}
}
}
public bool InsertReview(Reviews reviews)
{
string query = string.Format(@"insert into tblReviews(StationID, FacilityID, RevDate, Rating, Comment)
values ({0}, {1}, '{2}', {3}, '{4}') ;", reviews.Stationid, reviews.Facilitiyid, reviews.Date, reviews.Rating, reviews.Comment);
if (db.ExecuteNonQuery(query))
{
return(true);
}
return(false);
}
public void afresh()
{
string query = "insert chara(player, num) values({Player_num}, {Chara_num})";
sqlDB.ExecuteNonQuery(query);
query = "select id from chara where player = {Player_num} and num = {Chara_num}";
DataTable dataTable = sqlDB.ExecuteQuery(query);
Data_id = (int)dataTable[0]["id"];
Debug.Log(Data_id);
}
/// <summary>
/// Data manipulation SQL issue
/// データ操作SQL発行。
/// </summary>
/// <param name="sql"></param>
public void SqlExecuteNonQuery(string sql)
{
try
{
SqliteDatabase sqliteDataBase = new SqliteDatabase(CONNECT_TABLE);
sqliteDataBase.ExecuteNonQuery(sql);
}
catch (SqliteException ex)
{
Debug.Log(ex.Message + " " + this.ExecutetSql.ToString());
}
}
public void changeLang()
{
Dropdown langdrop = GameObject.Find("LangDrop").GetComponent <Dropdown>();
SqliteDatabase sqlite = new SqliteDatabase("shinkeisei.db");
string sql = "UPDATE user_info SET language = " + langdrop.value;
sqlite.ExecuteNonQuery(sql);
TextManager.Init();
Start();
}
public bool InsertStation(Stations stations)
{
if (stations.Id > getMaxStaID())
{
string query = string.Format(
@"insert into tblStations(Name,Type,LocationID,Wifi,Trolley,Refreshment,ATM,Toilet,Phone,DisabledAccess,Status) values('{0}',{1},{2},{3},{4},{5},{6},{7},{8},{9},{10});", stations.Name, stations.Type, stations.LocationId, stations.Wifi, stations.Trolleys, stations.Refreshment, stations.Atm, stations.Toilet, stations.Phone, stations.DisabledAccess, 1);
return(db.ExecuteNonQuery(query));
}
else
{
return(false);
}
}
/// <summary>
/// Insert SQL issue
/// インサートSQL発行
/// </summary>
/// <param name="component"></param>
public void Insert(object component)
{
try
{
SqliteDatabase sqliteDataBase = new SqliteDatabase(CONNECT_TABLE);
this.CreateInsertSql(component);
sqliteDataBase.ExecuteNonQuery(this.ExecutetSql.ToString());
}
catch (SqliteException ex)
{
Debug.LogError(ex.Message + " " + this.ExecutetSql.ToString());
}
}
// Use this for initialization
void Start()
{
#if UNITY_ANDROID
MyLibs.InitializeSQLCipher();
#endif
database = new SqliteDatabase(dbFilePath, dbDirectoryPath);
database.Open();
if (!string.IsNullOrEmpty(dbPassword))
{
database.Key(dbPassword);
}
Write("Open Database at " + database.pathDB);
database.ExecuteNonQuery("delete from UserData;");
Write("Clear Table UserData");
object[] paramVal = new object[] { 1, "Joko", "Jakarta", 28 };
string query = "insert into UserData values ({0}, {1}, {2}, {3});";
Write("Execute: " + query, paramVal);
database.ExecuteNonQuery(query, paramVal);
QueryTable(1);
paramVal = new object[] { "Joko Update", 1 };
query = "update UserData set name = {0} where Id = {1}";
Write("Execute: " + query, paramVal);
database.ExecuteNonQuery(query, paramVal);
QueryTable(1);
database.Close();
#if UNITY_ANDROID
MyLibs.ToastMessage("SQLCipher Done");
#endif
}
public void AddDataAndGetHiScore(int s, int c, string n, out int hs, out int hc, out bool update)
{
query = "select * from score where name = '" + n + "';";
var dt = sqlDB.ExecuteQuery(query);
//データがないなら
if (dt.Rows.Count == 0)
{
//追加してリターン
query = "insert into score values('" + n + "'," + s + "," + c + ",1);";
sqlDB.ExecuteNonQuery(query);
sqlDB.TransactionCommit();
hs = s; hc = c; update = true; return;
}
//データがあるなら 元データのハイスコアと比べる
int tmpScore = (int)dt.Rows[0]["hiscore"];
int tmpChain = (int)dt.Rows[0]["hichain"];
int playTime = (int)dt.Rows[0]["playtime"];
if (s < tmpScore)
{
//元データのほうが大きいならプレイ回数1増やしてリターン
query = "update score set playtime = " + (playTime + 1).ToString() + " where name = '" + n + "';";
sqlDB.ExecuteNonQuery(query);
sqlDB.TransactionCommit();
hs = tmpScore; hc = tmpChain; update = false; return;
}
//新しいほうが高いなら
query = "update score set hiscore = " + s.ToString()
+ ",hichain = " + c.ToString()
+ ",playtime = " + (playTime + 1).ToString()
+ " where name = '" + n + "';";
sqlDB.ExecuteNonQuery(query);
sqlDB.TransactionCommit();
hs = s; hc = c; update = true; return;
}
public static int execute(string query)
{
try
{
sqlDB.ExecuteNonQuery(query);
Debug.Log("complete : " + query);
return(1);
}
catch (Exception e)
{
Debug.Log(e.Message);
return(0);
}
}
// 初期化の際に使用
void Start()
{
// Insert
SqliteDatabase sqlDB = new SqliteDatabase("namebattler.db");
string query = "insert into characters values('hoge',0,0,0,0,0,0,0,null)";
sqlDB.ExecuteNonQuery(query);
//Select
string selectQuery = "select * from characters";
DataTable dataTable = sqlDB.ExecuteQuery(selectQuery);
string name = "";
foreach (DataRow dr in dataTable.Rows)
{
name = (string)dr["name"];
Debug.Log("name:" + name);
}
}
public Model.ResultEntity AddArticleCategory(Model.ArticleCategory articleCategory)
{
ResultEntity result = new ResultEntity();
result.ExcutRetStatus = false;
if (articleCategory == null)
{
result.StrErrMsg = "调用接口【AddArticleCategory】新增文章分类错误，传入对象参数为null";
logInfo.Info(result.StrErrMsg);
return(result);
}
//执行插入脚本
string strSql = @"INSERT INTO article_category(parent_id,article_category_name)
VALUES(@parent_id,@article_category_name)";
//参数数组
//SQLiteParameter[] paras = null;
try
{
Database database = new SqliteDatabase(DefaultDBConn.DefaultDbConnectionString);
DbCommand command = database.GetSqlStringCommand(strSql);
database.AddInParameter(command, "@parent_id", DbType.Int32, articleCategory.ParentId);
database.AddInParameter(command, "@article_category_name", DbType.String, articleCategory.ArticleCategoryName);
if (database.ExecuteNonQuery(command) > 0)
{
result.ExcutRetStatus = true;
}
}
catch (Exception ex)
{
result.StrErrMsg = string.Format("调用接口【AddArticleCategory】新增文章分类异常，原因：{0}", ex.Message);
logInfo.Error(result.StrErrMsg);
}
return(result);
}
public async void UpdateFromMasterDataIfNeeded()
{
var localDataVersion = new LocalDataVersionRepository().GetLocalDataVersion();
var masterDataVersion = await new MasterDataVersionApi().GetStoryMasterDataVersion();
if (localDataVersion < masterDataVersion)
{
var stories = await _storyApi.GetAll();
foreach (var story in stories)
{
Debug.Log(story.id);
Debug.Log(story.title);
var sql = $"insert into story Values({story.id}, '{story.title}', '{story.sentences}')";
sqlDB.ExecuteNonQuery(sql);
}
}
else
{
StoryListDownloadProgress = 100;
}
}
/// <summary>
/// Problem:
/// 1、写进数据库之后，db browser看不到，但是程序读的到
/// 2、中文写不进数据库
/// </summary>
/// <param name="lines"></param>
/// <param name="tableName"></param>
static private void ChangeTextToSqlite(string[] lines, string tableName)
{
SqliteDatabase sqlite = new SqliteDatabase("Sqlite.db");
PrintSqlite(sqlite, tableName);
foreach (string line in lines)
{
string sqlQuery = string.Format("insert into {0} values({1})", tableName, line);
try
{
sqlite.ExecuteNonQuery(sqlQuery);
}
catch (Exception e)
{
Debug.LogError(sqlQuery + "\n" + e.ToString());
}
finally
{
}
}
//PrintSqlite(sqlite, tableName);
}
public static void Save()
{
Debug.Log("Saving.....");
SqliteDatabase sqlDB = new SqliteDatabase("table.db");
string query = "INSERT INTO user VALUES('Santigo')";
sqlDB.ExecuteNonQuery(query);
newScore = GameController.score;
for (int i = 0; i < 100; i++)
{
if (PreviewLabs.PlayerPrefs.HasKey(i + "Score"))
{
if (PreviewLabs.PlayerPrefs.GetInt(i + "Score") < newScore)
{
//new score is higher than stored score
oldScore = PreviewLabs.PlayerPrefs.GetInt(i + "Score");
PreviewLabs.PlayerPrefs.SetInt(i + "Score", newScore);
PreviewLabs.PlayerPrefs.SetInt(i + "Kills", GameController.killCounter);
newScore = oldScore;
PreviewLabs.PlayerPrefs.Flush();
}
}
else
{
PreviewLabs.PlayerPrefs.SetInt(i + "Score", newScore);
PreviewLabs.PlayerPrefs.SetInt(i + "Kills", GameController.killCounter);
newScore = 0;
PreviewLabs.PlayerPrefs.Flush();
}
}
/*Debug.Log("From save");
* PreviewLabs.PlayerPrefs.SetInt(i + "Score",GameController.score);
* PreviewLabs.PlayerPrefs.SetInt ("kills",GameController.killCounter);
* if(GameController.score > GameController.newHighScore){
*
* }
* PreviewLabs.PlayerPrefs.Flush();*/
}
/// <summary>
/// Multiple issue an insert SQL
/// インサートSQLを複数発行
/// </summary>
/// <param name="componentList"></param>
public void InsertMulti <T>(List <T> componentList)
{
try
{
SqliteDatabase sqliteDataBase = new SqliteDatabase(CONNECT_TABLE);
foreach (object component in componentList)
{
try
{
this.CreateInsertSql(component);
sqliteDataBase.ExecuteNonQuery(this.ExecutetSql.ToString());
}
catch (SqliteException ex)
{
Debug.LogError(ex.Message);
break;
}
}
}
catch (SqliteException ex)
{
Debug.Log(ex.Message + " " + this.ExecutetSql.ToString());
}
}
IEnumerator gameCleared()
{
SqliteDatabase sqlDB = new SqliteDatabase("UserStatus.db");
string selectQuery = "select * from Stage where stage_number = " + stageNumber + " and difficulty = " + difficultyType;
DataTable stageTable = sqlDB.ExecuteQuery(selectQuery);
bool highScoreFlg = false;
if (stageTable.Rows.Count == 0) {
highScoreFlg = true;
} else {
int beforeScore = (int)stageTable.Rows[0]["score"];
if (beforeScore < point) {
highScoreFlg = true;
}
}
//panelの表示
GameObject panelPrefab = (GameObject)Instantiate(panelObject);
panelPrefab.GetComponent<Image>().color = new Color(255f, 255f, 255f, 0);
panelPrefab.transform.SetParent (canvasObject.transform, false);
yield return new WaitForSeconds(0.2f);
//ダイアログの表示
GameObject dialogPrefab = (GameObject)Instantiate(endDialogObject);
float scaleX = dialogPrefab.transform.localScale.x;
float scaleY = dialogPrefab.transform.localScale.y;
float scaleZ = dialogPrefab.transform.localScale.z;
dialogPrefab.transform.localScale = new Vector3((scaleX / 3), (scaleY / 3), (scaleZ / 3));
dialogPrefab.transform.SetParent (canvasObject.transform, false);
iTween.ScaleTo(dialogPrefab, iTween.Hash("x", 1, "y", 1, "z", 1, "time", 0.3f));
yield return new WaitForSeconds(0.2f);
//タイトルの表示
GameObject endTitlePrefab = (GameObject)Instantiate(endTitleObject);
scaleX = endTitlePrefab.transform.localScale.x;
scaleY = endTitlePrefab.transform.localScale.y;
scaleZ = endTitlePrefab.transform.localScale.z;
endTitlePrefab.transform.localScale = new Vector3((scaleX / 3), (scaleY / 3), (scaleZ / 3));
endTitlePrefab.transform.SetParent (canvasObject.transform, false);
iTween.ScaleTo(endTitlePrefab, iTween.Hash("x", scaleX, "y", scaleY, "z", scaleZ, "time", 0.3f));
yield return new WaitForSeconds(0.2f);
//スコアの表示
GameObject scorePrefab = (GameObject)Instantiate(endScoreObject);
scaleX = scorePrefab.transform.localScale.x;
scaleY = scorePrefab.transform.localScale.y;
scaleZ = scorePrefab.transform.localScale.z;
scorePrefab.transform.localScale = new Vector3((scaleX / 3), (scaleY / 3), (scaleZ / 3));
scorePrefab.transform.SetParent (canvasObject.transform, false);
//スコアのテキストを変更
GameObject scoreText = scorePrefab.transform.FindChild("ScoreText").gameObject;
scoreText.GetComponent<Text>().text = point.ToString();
iTween.ScaleTo(scorePrefab, iTween.Hash("x", 1, "y", 1, "z", 1, "time", 0.3f));
yield return new WaitForSeconds(0.2f);
//ハイスコアの表示
if (highScoreFlg) {
GameObject highScorePrefab = (GameObject)Instantiate(endHighScoreObject);
scaleX = highScorePrefab.transform.localScale.x;
scaleY = highScorePrefab.transform.localScale.y;
scaleZ = highScorePrefab.transform.localScale.z;
highScorePrefab.transform.localScale = new Vector3((scaleX / 3), (scaleY / 3), (scaleZ / 3));
highScorePrefab.transform.SetParent (canvasObject.transform, false);
iTween.ScaleTo(highScorePrefab, iTween.Hash("x", scaleX, "y", scaleY, "z", scaleZ, "time", 0.3f));
yield return new WaitForSeconds(0.2f);
}
//コインの表示
GameObject coinPrefab = (GameObject)Instantiate(endCoinObject);
scaleX = coinPrefab.transform.localScale.x;
scaleY = coinPrefab.transform.localScale.y;
scaleZ = coinPrefab.transform.localScale.z;
coinPrefab.transform.localScale = new Vector3((scaleX / 3), (scaleY / 3), (scaleZ / 3));
coinPrefab.transform.SetParent (canvasObject.transform, false);
iTween.ScaleTo(coinPrefab, iTween.Hash("x", 1, "y", 1, "z", 1, "time", 0.3f));
yield return new WaitForSeconds(0.2f);
//コインテキストの表示
Text coinTextPrefab = (Text)Instantiate(endCoinText);
coinTextPrefab.transform.SetParent (canvasObject.transform, false);
//コインの計算
int coin = (point / 1000);
coinTextPrefab.text = coin.ToString();
yield return new WaitForSeconds(0.2f);
//ボタンの表示
GameObject endButtonPrefab = (GameObject)Instantiate(endMenuButton);
scaleX = endButtonPrefab.transform.localScale.x;
scaleY = endButtonPrefab.transform.localScale.y;
scaleZ = endButtonPrefab.transform.localScale.z;
endButtonPrefab.transform.localScale = new Vector3((scaleX / 3), (scaleY / 3), (scaleZ / 3));
endButtonPrefab.transform.SetParent (canvasObject.transform, false);
iTween.ScaleTo(endButtonPrefab, iTween.Hash("x", 1, "y", 1, "z", 1, "time", 0.3f));
yield return new WaitForSeconds(0.2f);
endButtonPrefab = (GameObject)Instantiate(endRetryButton);
scaleX = endButtonPrefab.transform.localScale.x;
scaleY = endButtonPrefab.transform.localScale.y;
scaleZ = endButtonPrefab.transform.localScale.z;
endButtonPrefab.transform.localScale = new Vector3((scaleX / 3), (scaleY / 3), (scaleZ / 3));
endButtonPrefab.transform.SetParent (canvasObject.transform, false);
iTween.ScaleTo(endButtonPrefab, iTween.Hash("x", 1, "y", 1, "z", 1, "time", 0.3f));
yield return new WaitForSeconds(0.2f);
string query;
//インサート
if (stageTable.Rows.Count == 0) {
query = "insert into Stage(stage_number, difficulty, star, remaining_time, remaining_hp, score, created, updated) values(" + stageNumber + "," + difficultyType + ",0,0,0," + point + ",datetime(),datetime())";
sqlDB.ExecuteNonQuery(query);
//アップデート
} else {
int stageID = (int)stageTable.Rows[0]["id"];
if (highScoreFlg) {
query = "update Stage set star=0, remaining_time=0, remaining_hp=0, score=" + point + ",updated=dateTime() where id=" + stageID;
sqlDB.ExecuteNonQuery(query);
}
}
//お金アップデート
query = "update UserStatus set money = (money + " + coin + ") where id = 1";
sqlDB.ExecuteNonQuery(query);
/*
int clearTime = cd;
//GameObjectを生成、生成したオブジェクトを変数に代入
GameObject panelPrefab = (GameObject)Instantiate(panelObject);
panelPrefab.GetComponent<Image>().color = new Color(255f, 255f, 255f, 0);
//Canvasの子要素として登録する
panelPrefab.transform.SetParent (canvasObject.transform, false);
yield return new WaitForSeconds(0.2f);
//ダイアログの表示
GameObject clearDialogPrefab = (GameObject)Instantiate(clearDialogObject);
float scaleX = clearDialogPrefab.transform.localScale.x;
float scaleY = clearDialogPrefab.transform.localScale.y;
float scaleZ = clearDialogPrefab.transform.localScale.z;
clearDialogPrefab.transform.localScale = new Vector3((scaleX / 3), (scaleY / 3), (scaleZ / 3));
//Canvasの子要素として登録する
clearDialogPrefab.transform.SetParent (canvasObject.transform, false);
iTween.ScaleTo(clearDialogPrefab, iTween.Hash("x", 1, "y", 1, "z", 1, "time", 0.3f));
yield return new WaitForSeconds(0.2f);
//Complete
GameObject completePrefab = (GameObject)Instantiate(completeObject);
scaleX = completePrefab.transform.localScale.x;
scaleY = completePrefab.transform.localScale.y;
scaleZ = completePrefab.transform.localScale.z;
completePrefab.transform.localScale = new Vector3((scaleX / 3), (scaleY / 3), (scaleZ / 3));
//Canvasの子要素として登録する
completePrefab.transform.SetParent (canvasObject.transform, false);
if (completePrefab.GetComponent<Text>() == null) {
iTween.ScaleTo(completePrefab, iTween.Hash("x", 1, "y", 1, "z", 1, "time", 0.3f));
} else {
iTween.ScaleTo(completePrefab, iTween.Hash("x", 0.3f, "y", 0.3f, "z", 0.3f, "time", 0.3f));
}
yield return new WaitForSeconds(0.2f);
//star
//星の数を計算する
float decPer = (clearTime * 0.5f) / (limitTime * 1.0f);
float decHpPer = (hp * 0.5f) / 2 * decPer;
float totalPer = decPer + decHpPer;
Debug.Log("DEC PER:" + decPer);
Debug.Log("DEC HP PER:" + decHpPer);
Debug.Log("TOTAL PER:" + totalPer);
//星の数
int starCount = 1;
if (totalPer >= 0.49f) {
starCount = 3;
} else if (totalPer >= 0.35f) {
starCount = 2;
}
int score = (int) Math.Ceiling(totalPer * 10000);
int coin = (int) Math.Ceiling(totalPer * 10);
Debug.Log("COIN:" + coin);
//セーブ
SqliteDatabase sqlDB = new SqliteDatabase("UserStatus.db");
string selectQuery = "select * from Stage where stage_number = " + stageNumber + " and difficulty = " + difficultyType;
DataTable stageTable = sqlDB.ExecuteQuery(selectQuery);
string query;
//インサート
if (stageTable.Rows.Count == 0) {
query = "insert into Stage(stage_number, difficulty, star, remaining_time, remaining_hp, score, created, updated) values(" + stageNumber + "," + difficultyType + "," + starCount + "," + clearTime + "," + hp + "," + score + ",datetime(),datetime())";
sqlDB.ExecuteNonQuery(query);
//アップデート
} else {
int beforeScore = (int)stageTable.Rows[0]["score"];
int stageID = (int)stageTable.Rows[0]["id"];
if (beforeScore < score) {
query = "update Stage set star=" + starCount + ", remaining_time=" + hp +", remaining_hp=" + hp + ", score=" + score + ",updated=dateTime() where id=" + stageID;
sqlDB.ExecuteNonQuery(query);
}
}
//お金アップデート
query = "update UserStatus set money = (money + " + coin + ") where id = 1";
sqlDB.ExecuteNonQuery(query);
//結果ダイアログ
GameObject resultPrefab = (GameObject)Instantiate(resultDialogObject);
scaleX = resultPrefab.transform.localScale.x;
scaleY = resultPrefab.transform.localScale.y;
scaleZ = resultPrefab.transform.localScale.z;
resultPrefab.transform.localScale = new Vector3((scaleX / 3), (scaleY / 3), (scaleZ / 3));
//Canvasの子要素として登録する
resultPrefab.transform.SetParent (canvasObject.transform, false);
GameObject decTimeChild1 = resultPrefab.transform.FindChild("time_number_1").gameObject;
GameObject decTimeChild2 = resultPrefab.transform.FindChild("time_number_2").gameObject;
GameObject decTimeChild3 = resultPrefab.transform.FindChild("time_number_3").gameObject;
String stTime = clearTime.ToString();
String number1 = "0";
String number2 = "0";
String number3 = "0";
if (stTime.Length >= 3) {
number1 = stTime.Substring(0, 1);
number2 = stTime.Substring(1, 1);
number3 = stTime.Substring(2, 1);
} else if (stTime.Length >= 2) {
number2 = stTime.Substring(0, 1);
number3 = stTime.Substring(1, 1);
} else {
number3 = stTime.Substring(0, 1);
}
decTimeChild1.GetComponent<Image>().sprite = Resources.Load <Sprite> ("Prefab/Number/" + "number4_red_" + number1);
decTimeChild2.GetComponent<Image>().sprite = Resources.Load <Sprite> ("Prefab/Number/" + "number4_red_" + number2);
decTimeChild3.GetComponent<Image>().sprite = Resources.Load <Sprite> ("Prefab/Number/" + "number4_red_" + number3);
//hp設定
GameObject decHpChild = resultPrefab.transform.FindChild("hp_number_1").gameObject;
String stHp = hp.ToString();
decHpChild.GetComponent<Image>().sprite = Resources.Load <Sprite> ("Prefab/Number/" + "number4_red_" + stHp);
//coin設定
GameObject coinChild1 = resultPrefab.transform.FindChild("coin_number_1").gameObject;
GameObject coinChild2 = resultPrefab.transform.FindChild("coin_number_2").gameObject;
String stCoin = coin.ToString();
String coin1= "0";
String coin2= "0";
if (stCoin.Length >= 2) {
coin2 = stCoin.Substring(0, 1);
coin1 = stCoin.Substring(1, 1);
} else {
coin1 = stCoin.Substring(0, 1);
}
coinChild1.GetComponent<Image>().sprite = Resources.Load <Sprite> ("Prefab/Number/" + "number4_red_" + coin1);
coinChild2.GetComponent<Image>().sprite = Resources.Load <Sprite> ("Prefab/Number/" + "number4_red_" + coin2);
iTween.ScaleTo(resultPrefab, iTween.Hash("x", 1, "y", 1, "z", 1, "time", 0.3f));
yield return new WaitForSeconds(0.2f);
GameObject starPrefab;
for (int i = 0; i < starObject.Length; i++) {
starPrefab = (GameObject)Instantiate(starObject[i]);
scaleX = starPrefab.transform.localScale.x;
scaleY = starPrefab.transform.localScale.y;
scaleZ = starPrefab.transform.localScale.z;
starPrefab.transform.localScale = new Vector3((scaleX / 3), (scaleY / 3), (scaleZ / 3));
if (i == 1 && totalPer <= 0.35f) {
starPrefab.GetComponent<Image>().sprite = Resources.Load <Sprite> ("Prefab/item_star_lost");
} else if (i == 2 && totalPer <= 0.49f) {
starPrefab.GetComponent<Image>().sprite = Resources.Load <Sprite> ("Prefab/item_star_lost");
}
//Canvasの子要素として登録する
starPrefab.transform.SetParent (canvasObject.transform, false);
// 4秒かけて、y軸を3倍に拡大
iTween.ScaleTo(starPrefab, iTween.Hash("x", 1, "y", 1, "z", 1, "time", 0.3f));
yield return new WaitForSeconds(0.2f);
}
//button
GameObject endButtonPrefab;
for (int i = 0; i < endButtonObject.Length; i++) {
endButtonPrefab = (GameObject)Instantiate(endButtonObject[i]);
scaleX = endButtonPrefab.transform.localScale.x;
scaleY = endButtonPrefab.transform.localScale.y;
scaleZ = endButtonPrefab.transform.localScale.z;
endButtonPrefab.transform.localScale = new Vector3((scaleX / 3), (scaleY / 3), (scaleZ / 3));
//Canvasの子要素として登録する
endButtonPrefab.transform.SetParent (canvasObject.transform, false);
// 4秒かけて、y軸を3倍に拡大
iTween.ScaleTo(endButtonPrefab, iTween.Hash("x", 1, "y", 1, "z", 1, "time", 0.3f));
yield return new WaitForSeconds(0.2f);
}
*/
yield return new WaitForSeconds(0.2f);
}
public bool InsertPhoto(Photos photos)
{
string query = string.Format(@"insert into tblPhotos(StationID, PhotoFile) values ({0},'{1}');", photos.StationId, photos.PhotoFile);
return(db.ExecuteNonQuery(query));
}
void Start()
{
//DB作成
sqlDB = new SqliteDatabase("dicegame.db");
// INSERT
string query = "insert into user values(1, 'hoge', 20, 0, 0, 0)";
sqlDB.ExecuteNonQuery(query);
string selectQuery = "select * from user";
DataTable dataTable = sqlDB.ExecuteQuery(selectQuery);
int a = 0;
string b = "";
int c = 0;
int d = 0;
int e = 0;
int f = 0;
foreach (DataRow dr in dataTable.Rows)
{
a = (int)dr["user_id"];
Debug.Log("user_id:" + a);
b = (string)dr["user_name"];
Debug.Log("name:" + b);
c = (int)dr["password"];
Debug.Log("password:"******"score"];
Debug.Log("score:" + d);
e = (int)dr["frame"];
Debug.Log("frame:" + e);
f = (int)dr["point"];
Debug.Log("point:" + f);
}
// UPDATE
string updateQuery = "update user set user_name = 'huge' where user_id = 1";
sqlDB.ExecuteNonQuery(updateQuery);
// Select
selectQuery = "select * from user";
dataTable = sqlDB.ExecuteQuery(selectQuery);
foreach (DataRow dr in dataTable.Rows)
{
a = (int)dr["user_id"];
Debug.Log("user_id:" + a);
b = (string)dr["user_name"];
Debug.Log("name:" + b);
c = (int)dr["password"];
Debug.Log("password:"******"score"];
Debug.Log("score:" + d);
e = (int)dr["frame"];
Debug.Log("frame:" + e);
f = (int)dr["point"];
Debug.Log("point:" + f);
}
}
IEnumerator gameEnd(bool winFlg=false)
{
//GameObjectを生成、生成したオブジェクトを変数に代入
GameObject panelPrefab = (GameObject)Instantiate(panelObject);
panelPrefab.GetComponent<Image>().color = new Color(255f, 255f, 255f, 0);
//Canvasの子要素として登録する
panelPrefab.transform.SetParent (canvasObject.transform, false);
yield return new WaitForSeconds(0.5f);
int coin = 0;
if (winFlg) {
coin = 10;
} else {
coin = 1;
}
//データベースに登録
//お金アップデート
SqliteDatabase sqlDB = new SqliteDatabase("UserStatus.db");
string query = "update UserStatus set money = (money + " + coin + ") where id = 1";
sqlDB.ExecuteNonQuery(query);
//end object群を全部表示
GameObject endPrefab;
for (int i = 0; i < gameEndObject.Length; i++) {
endPrefab = (GameObject)Instantiate(gameEndObject[i]);
float scaleX = endPrefab.transform.localScale.x;
float scaleY = endPrefab.transform.localScale.y;
float scaleZ = endPrefab.transform.localScale.z;
endPrefab.transform.localScale = new Vector3((scaleX / 3), (scaleY / 3), (scaleZ / 3));
//Canvasの子要素として登録する
endPrefab.transform.SetParent (canvasObject.transform, false);
if (endPrefab.GetComponent<Text>() != null) {
if (winFlg) {
endPrefab.GetComponent<Text>().text = "勝利";
} else {
endPrefab.GetComponent<Text>().text = "敗北";
}
}
string prefabName = endPrefab.name;
prefabName = prefabName.Replace("(Clone)", "");
if (prefabName == "BattleResultDialog") {
//coin設定
GameObject coinChild1 = endPrefab.transform.FindChild("coin_number_1").gameObject;
GameObject coinChild2 = endPrefab.transform.FindChild("coin_number_2").gameObject;
String stCoin = coin.ToString();
String coin1= "0";
String coin2= "0";
if (stCoin.Length >= 2) {
coin2 = stCoin.Substring(0, 1);
coin1 = stCoin.Substring(1, 1);
} else {
coin1 = stCoin.Substring(0, 1);
}
coinChild1.GetComponent<Image>().sprite = Resources.Load <Sprite> ("Prefab/Number/" + "number4_red_" + coin1);
coinChild2.GetComponent<Image>().sprite = Resources.Load <Sprite> ("Prefab/Number/" + "number4_red_" + coin2);
}
iTween.ScaleTo(endPrefab, iTween.Hash("x", scaleX, "y", scaleY, "z", scaleZ, "time", 0.3f));
yield return new WaitForSeconds(0.5f);
}
networkPlayerScript.gameEnd();
}
