public bool LogIn(string user, string pass)
{
MySqlDataReader res = _DBAdmin.ExecuteQuery(
_DBAdmin.CreateQuery(DBQueries.LOG_IN_REQUEST,
user, pass));
if (res.HasRows)
{
res.Close();
return(false);
}
else
{
res.Close();
MySqlDataReader res2 = _DBAdmin.ExecuteQuery(
_DBAdmin.CreateQuery(DBQueries.GET_CONNECTION_STATE,
user));
DataTable dat2 = new DataTable();
dat2.Load(res2);
var state = ((string)dat2.Rows[0]["connectedState"]);
res2.Close();
return(state != "C");
}
}
public void Register()
{
MySqlDataReader res2 = _DBAdmin.ExecuteQuery(_DBAdmin.CreateQuery(DBQueries.CHECK_USERNAME, userField.text));
if (!res2.HasRows) {
res2.Close();
MySqlDataReader res3 = _DBAdmin.ExecuteQuery(_DBAdmin.CreateQuery(DBQueries.REGISTER_REQUEST, userField.text, passField.text));
res3.Close();
print("New User Created.");
}
else {
res2.Close();
print("Username already taken.");
}
}
public void AddFriend(string user1, string user2)
{
MySqlDataReader res = _DBAdmin.ExecuteQuery(
_DBAdmin.CreateQuery(DBQueries.ADD_FRIEND,
user1, user2));
res.Close();
}
