private void OnLogin(User user)
{
R_UserGame userGame = null;
try
{
Debug.Log("OnLogin() - MainMenu.userInfo check");
userGame = R_UserGameService.Instance.GetUserGameByUserIdAndGameCode(user.user_id, Constant.GAME_CODE);
}
catch (DatabaseConnectionException e)
{
Debug.Log("###### Exception #########");
Debug.Log(e.ToString());
Debug.Log(Properties.GetDatabaseConnectionErrorMessage());
return;
}
MainMenu.userInfo.nick_name = userGame.nick_name;
androidSet.ShowToast(Properties.GetLoginSucceedMessage() + " (" + MainMenu.userInfo.nick_name + ")", false);
Debug.Log("환영합니다 " + MainMenu.userInfo.nick_name + "님. " + (user.visit_count + 1) + "번째 방문입니다.");
int ret = UserService.Instance.UpdateUserByUserId(user.user_id, "visit_count", user.visit_count + 1);
Debug.Log("ret is " + ret);
loginFinish = true;
}
public int InsertR_UserGame(R_UserGame userGame)
{
int ret = 0;
string query = String.Format("insert into r_user_game (user_id, game_code, nick_name, create_date) values ('{0}', '{1}', '{2}', '{3}')"
, userGame.user_id
, userGame.game_code
, userGame.nick_name
, userGame.create_date.ToString("yyyyMMddhhmmss"));
ret = MySqlConnector.Instance.DoNonQuery(query);
Debug.Log("InsertR_UserGame() ret is " + ret);
return(ret);
}
private void OnLogin(User user)
{
R_UserGame userGame = null;
try
{
Debug.Log("MainMenu.cs : OnLogin() - MainMenu.userInfo check");
userGame = R_UserGameService.Instance.GetUserGameByUserIdAndGameCode(user.user_id, Constant.GAME_CODE);
}
catch (DatabaseConnectionException e)
{
Debug.Log("###### Exception #########");
Debug.Log(e.ToString());
Debug.Log(Properties.GetDatabaseConnectionErrorMessage());
Login(false);
return;
}
MainMenu.userInfo.nick_name = userGame.nick_name;
toggle_login.isOn = true;
androidSet.ShowToast(Properties.GetLoginSucceedMessage() + " (" + userInfo.nick_name + ")", false);
}
private List <R_UserGame> GetUserGameList(string query)
{
List <R_UserGame> userGameList = new List <R_UserGame>();
MySqlConnector.Instance.DoSelectQuery(query, (MySqlDataReader reader) =>
{
// 데이터 없음
if (reader == null)
{
Debug.Log("No data");
return;
}
/////////// for debuging ///////////
Debug.Log("Parsing data");
//List<string> columns = GetDataReaderColumnNames(reader);
//foreach (string col in columns)
//{
// Debug.Log(col);
//}
//Debug.Log("reader: " + columns.ToString());
/////////// for debuging ///////////
///
string user_id = reader["user_id"].ToString();
string game_code = reader["game_code"].ToString();
string nick_name = reader["nick_name"].ToString();
string create_date = reader["create_date"].ToString();
R_UserGame userGame = new R_UserGame
{
user_id = user_id,
game_code = game_code,
nick_name = nick_name,
create_date = Convert.ToDateTime(create_date)
};
userGameList.Add(userGame);
});
return(userGameList);
}
public void HandleOK()
{
string nickName = inputField.text;
Debug.Log("닉네임 : " + nickName);
if (nickName.Length <= 1)
{
storyMessage.text = "이름이 없나? 다시 물어보겠어";
indicateText.text = "2글자 이상 입력 해 주세요";
return;
}
User user = null;
R_UserGame userGame = null;
try
{
userGame = R_UserGameService.Instance.GetUserGameByNickNameAndGameCode(nickName, Constant.GAME_CODE);
if (userGame != null)
{
// 이미 있는 닉네임...
Debug.Log("이미 있는 닉네임" + userGame.user_id);
storyMessage.text = "다 아는 이름이구먼!";
indicateText.text = "이미 존재하는 닉네임 입니다 다시 입력하세요";
return;
}
MainMenu.userInfo.nick_name = nickName;
Debug.Log("사용 가능 한 닉네임(" + MainMenu.userInfo.nick_name + ") 입니다.");
// 새로운 user 등록
user = new User
{
auth = MainMenu.userInfo.auth,
country = MainMenu.userInfo.user_country,
visit_count = 1,
user_id = MainMenu.userInfo.user_id,
email = MainMenu.userInfo.user_email,
user_image = MainMenu.userInfo.user_image,
user_name = MainMenu.userInfo.user_name
};
int r = UserService.Instance.InsertUser(user);
if (r != 1)
{
throw new InvalidOperationException("Failed to insert user record");
}
// UserGame 등록
R_UserGame newUserGame = new R_UserGame
{
user_id = user.user_id,
game_code = Constant.GAME_CODE,
nick_name = MainMenu.userInfo.nick_name,
create_date = DateTimeManager.Instance.getKoreaTimeFromUTCNow()
};
r = R_UserGameService.Instance.InsertR_UserGame(newUserGame);
if (r != 1)
{
throw new InvalidOperationException("Failed to insert userGame record");
}
inputPanelUI.SetActive(false);
imagePanelUI.SetActive(true);
storyMessage.text = "인류의 미래는 \"" + nickName + "\" 자네의 손가락에 달렸네.. 행운을 비네!! (튜토리얼은 없다네)";
SingletonClass.Instance.bLogin = true;
PlayerPrefs.SetInt("bLogin", SingletonClass.Instance.bLogin ? 1 : 0);
PlayerPrefs.Save();
}
catch (Exception e)
{
Debug.Log(e.Message);
storyMessage.text = "치지직.. 통신 불량.. 유저 등록 실패..";
UserService.Instance.deleteUser(user);
}
finally
{
Invoke("GoMainMenuScene", 3);
}
}
