public void apply() { try { ConnectBdd(); bool b = false; GameObject pseudo = GameObject.FindGameObjectWithTag("player"); MySqlCommand command_info = new MySqlCommand("SELECT * FROM users WHERE pseudo = '" + @pseudo.name + "'", con); MySqlDataReader my_Reader = command_info.ExecuteReader(); while (my_Reader.Read()) { if (DataBaseManag.crypt256(lastpass.text) == my_Reader.GetString(2) && new_pass.text == confirm_pass.text) { b = true; } if (lastpass.text == "" || new_pass.text == "" || confirm_pass.text == "") { b = false; error.text = "Error : " + "Select all input"; } else { error.text = "Error : " + "Maybe wrong late pass or pass different"; } } my_Reader.Close(); if (b) { string command = "UPDATE users SET password= '******' WHERE pseudo='" + pseudo.name + "';"; MySqlCommand cmd = new MySqlCommand(command, con); try { cmd.ExecuteReader(); Debug.Log("Update success"); } catch (IOException ex) { Debug.Log(ex); } cmd.Dispose(); panel.gameObject.SetActive(false); pseudo.gameObject.SetActive(true); pass.gameObject.SetActive(true); email.gameObject.SetActive(true); grad.gameObject.SetActive(true); menu_button.gameObject.SetActive(true); update_button.gameObject.SetActive(true); } con.Close(); } catch (IOException ex) { Debug.Log(ex); } }
public void ConnectBdd() { string constr = "Server=" + host + ";DATABASE=" + database + ";User ID=" + username + ";Password="******";Pooling=true;Charset=utf8;"; try { con = new MySqlConnection(constr); con.Open(); } catch (IOException ex) { Debug.Log(ex.ToString()); } }