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); } }