Quote

[01:44:57 AM] Overflow

Conn.Execute("UPDATE `Users` SET `Games_played` = '" & Games_played + 1 & "', `Wins` = '" & Wins + 1 & "', `Points` = '" & Points + (ScourgePoints/SentPoints*15)+(Streak*2.5) & "', `Current_game` = 'N/A', `Last_game` = '" & ListedGame & "', `Current_streak` = '1', `Last_gain` = '+" & (ScourgePoints/SentPoints*15)+(Streak*2.5) & "' WHERE `Name` = '" & ScourgePlayers(I) & "'")

With Conn.Execute("SELECT * FROM `Users` WHERE `Name` = '" & ScourgePlayers(I) & "'") Games_played = .Fields(6) Wins = .Fields(4) Losses = .Fields(5) Points = .Fields(3) Streak = .Fields(13) BestStreak = .Fields(14) If Streak >= BestStreak Then Conn.Execute("UPDATE `Users` SET `Games_played` = '" & Games_played + 1 & "', `Wins` = '" & Wins + 1 & "', `Points` = '" & Points + (ScourgePoints/SentPoints*15)+(Streak*2.5) & "', `Current_game` = 'N/A', `Last_game` = '" & ListedGame & "', `Current_streak` = '" & Streak + 1 & "', `Best_Streak` = '" & Streak + 1 & "', `Last_gain` = '+" & (ScourgePoints/SentPoints*15)+(Streak*2.5) & "' WHERE `Name` = '" & ScourgePlayers(I) & "'") ElseIf Streak < BestStreak AND NOT Streak <= 0 Then Conn.Execute("UPDATE `Users` SET `Games_played` = '" & Games_played + 1 & "', `Wins` = '" & Wins + 1 & "', `Points` = '" & Points + (ScourgePoints/SentPoints*15)+(Streak*2.5) & "', `Current_game` = 'N/A', `Last_game` = '" & ListedGame & "', `Current_streak` = '" & Streak + 1 & "', `Last_gain` = '+" & (ScourgePoints/SentPoints*15)+(Streak*2.5) & "' WHERE `Name` = '" & ScourgePlayers(I) & "'") ElseIf Streak <= 0 AND Streak < BestStreak Then Conn.Execute("UPDATE `Users` SET `Games_played` = '" & Games_played + 1 & "', `Wins` = '" & Wins + 1 & "', `Points` = '" & Points + (ScourgePoints/SentPoints*15)+(Streak*2.5) & "', `Current_game` = 'N/A', `Last_game` = '" & ListedGame & "', `Current_streak` = '1', `Last_gain` = '+" & (ScourgePoints/SentPoints*15)+(Streak*2.5) & "' WHERE `Name` = '" & ScourgePlayers(I) & "'") End If End With

Could anyone explain to me why this error is occuring. If you know how to solve it, that'd be even more awesome!