public IEnumerator AddAccountCoroutine(uLobby.AccountRecord account, uLobby.Request <uLobby.AccountRecord> request) { MySqlParameter[] paramsArray = new MySqlParameter[4]; paramsArray[0] = new MySqlParameter("name", account.name); paramsArray[1] = new MySqlParameter("password", account.passwordHash.passwordHash); paramsArray[2] = new MySqlParameter("salt", account.passwordHash.salt); paramsArray[3] = new MySqlParameter("data", account.data); var operation = ExecuteNonQueryAsync.BeginInvoke(storageManager.connectionString, "INSERT INTO accounts (name,password,salt,data)VALUES(@name,@password,@salt,@data)", paramsArray, null, null); while (!operation.IsCompleted) { yield return(null); } ExecuteNonQueryAsync.EndInvoke(operation); operation = ExecuteDataReaderAsync.BeginInvoke(storageManager.connectionString, "SELECT id FROM accounts where name = @name and password = @password and salt = @salt LIMIT 1;", paramsArray, null, null); while (!operation.IsCompleted) { yield return(null); } var dr = ExecuteDataReaderAsync.EndInvoke(operation); dr.Read(); account.id = new AccountID(dr.GetInt32("id").ToString()); dr.Close(); StorageLayerUtility.RequestUtility.SetResult(request, account); }
public IEnumerator GetFriendListRecordCoroutine(uLobby.AccountID accountID, uLobby.Request <uLobby.FriendListRecord> request) { FriendListRecord friendList = StorageLayerUtility.FriendListRecordUtility.CreateFriendListRecord(); //read friend list var operation = ExecuteDataReaderAsync.BeginInvoke(storageManager.connectionString, "SELECT accounts.id,accounts.name,password,LENGTH(password),salt,LENGTH(salt),data,LENGTH(data) FROM accounts INNER JOIN friends ON accounts.id = friends.friend WHERE owner = @id", new MySqlParameter[] { new MySqlParameter("id", int.Parse(accountID.value)) }, null, null); while (!operation.IsCompleted) { yield return(null); } var dr = ExecuteDataReaderAsync.EndInvoke(operation); while (dr.Read()) { AccountRecord accountRecord = ReadAccountRecordFromDataReader(dr); Account account = StorageLayerUtility.CreateAccount(accountRecord); StorageLayerUtility.FriendListRecordUtility.AddFriend(friendList, StorageLayerUtility.CreateFriendInfo(account)); } dr.Close(); //read the original account owning the list. operation = ExecuteDataReaderAsync.BeginInvoke(storageManager.connectionString, "SELECT id,name,password,LENGTH(password),salt,LENGTH(salt),data,LENGTH(data) FROM accounts WHERE id = @id", new MySqlParameter[] { new MySqlParameter("id", int.Parse(accountID.value)) }, null, null); while (!operation.IsCompleted) { yield return(null); } dr = ExecuteDataReaderAsync.EndInvoke(operation); dr.Read(); Account originalAccount = StorageLayerUtility.CreateAccount(ReadAccountRecordFromDataReader(dr)); dr.Close(); //read invitations operation = ExecuteDataReaderAsync.BeginInvoke(storageManager.connectionString, "SELECT accounts.id,name,password,LENGTH(password),salt,LENGTH(salt),data,LENGTH(data) FROM accounts INNER JOIN invitations ON accounts.id = invitations.sender WHERE invitations.receiver = @id", new MySqlParameter[] { new MySqlParameter("id", int.Parse(accountID.value)) }, null, null); while (!operation.IsCompleted) { yield return(null); } dr = ExecuteDataReaderAsync.EndInvoke(operation); while (dr.Read()) { Account account = StorageLayerUtility.CreateAccount(ReadAccountRecordFromDataReader(dr)); StorageLayerUtility.FriendListRecordUtility.AddFriendInvitation(friendList, StorageLayerUtility.CreateFriendInvitation(account, originalAccount)); } dr.Close(); StorageLayerUtility.RequestUtility.SetResult(request, friendList); yield break; }
public IEnumerator GetAccountRecordCoroutine(uLobby.AccountID accountID, uLobby.Request <uLobby.AccountRecord> request) { var operation = ExecuteDataReaderAsync.BeginInvoke(storageManager.connectionString, "SELECT id,name,password,LENGTH(password),salt,LENGTH(salt),data,LENGTH(data) FROM accounts WHERE id = @id", new MySqlParameter[] { new MySqlParameter("id", int.Parse(accountID.value)) }, null, null); while (!operation.IsCompleted) { yield return(null); } var dr = ExecuteDataReaderAsync.EndInvoke(operation); if (dr.HasRows) { dr.Read(); StorageLayerUtility.RequestUtility.SetResult(request, ReadAccountRecordFromDataReader(dr)); } else { StorageLayerUtility.RequestUtility.SetResult(request, null); } dr.Close(); }
public IEnumerator GetAccountCoroutine(uLobby.AccountID accountID, string accountName, bool exceptionIfInvalid, uLobby.Request <uLobby.Account> request) { MySqlDataReader dr; if (accountID == null) { var operation = ExecuteDataReaderAsync.BeginInvoke(storageManager.connectionString, "SELECT id,name,password,LENGTH(password),salt,LENGTH(salt),data,LENGTH(data) FROM accounts WHERE name = @name;", new MySqlParameter[] { new MySqlParameter("name", accountName) }, null, null); while (!operation.IsCompleted) { yield return(null); } dr = ExecuteDataReaderAsync.EndInvoke(operation); } else { var operation = ExecuteDataReaderAsync.BeginInvoke(storageManager.connectionString, "SELECT id,name,password,LENGTH(password),salt,LENGTH(salt),data,LENGTH(data) FROM accounts WHERE id = @id;", new MySqlParameter[] { new MySqlParameter("id", int.Parse(accountID.value)) }, null, null); while (!operation.IsCompleted) { yield return(null); } dr = ExecuteDataReaderAsync.EndInvoke(operation); } if (dr.HasRows) { dr.Read(); Account account = StorageLayerUtility.CreateAccount(ReadAccountRecordFromDataReader(dr)); StorageLayerUtility.RequestUtility.SetResult(request, account); } else { StorageLayerUtility.RequestUtility.SetResult(request, null); if (exceptionIfInvalid) { StorageLayerUtility.RequestUtility.ThrowException(request, StorageLayerUtility.Exceptions.CreateAccountException("Account with id " + accountID + " and name " + accountName + " does not exist.")); } } dr.Close(); }
public IEnumerator UpdateAccountCoroutine(uLobby.IAccount account, uLobby.AccountUpdate update, uLobby.Request <uLobby.Account> request) { Request <AccountRecord> getAccountRequest; getAccountRequest = StorageLayerUtility.GetAccountRecord(account.id); yield return(getAccountRequest.WaitUntilDone()); if (StorageLayerUtility.RequestUtility.PropagateException(getAccountRequest, request)) { yield break; } AccountRecord record = getAccountRequest.result; if (StorageLayerUtility.AccountUpdateUtility.isPasswordChanged(update)) { record.passwordHash = SaltedPasswordHash.GenerateSaltedPasswordHash(SaltedPasswordHash.GeneratePasswordHash(StorageLayerUtility.AccountUpdateUtility.GetPassword(update) + record.name)); } if (StorageLayerUtility.AccountUpdateUtility.IsDataChanged(update)) { record.data = StorageLayerUtility.AccountUpdateUtility.GetData(update); } MySqlParameter[] paramsArray = new MySqlParameter[4]; paramsArray[0] = new MySqlParameter("password", record.passwordHash.passwordHash); paramsArray[1] = new MySqlParameter("salt", record.passwordHash.salt); paramsArray[2] = new MySqlParameter("data", record.data); paramsArray[3] = new MySqlParameter("id", int.Parse(record.id.value)); var operation = ExecuteNonQueryAsync.BeginInvoke(storageManager.connectionString, "UPDATE accounts SET password=@password,salt=@salt,data=@data WHERE id = @id", paramsArray, null, null); while (!operation.IsCompleted) { yield return(null); } Account updatedAccount = StorageLayerUtility.CreateAccount(record); StorageLayerUtility.RequestUtility.SetResult(request, updatedAccount); }
public IEnumerator GetNewAccountIDCoroutine(uLobby.Request <uLobby.AccountID> request) { //we use the database to generate the ids. StorageLayerUtility.RequestUtility.SetResult(request, new AccountID("111")); //dummy account id object which we don't use. yield break; }