When you have alot of players, use the stored procedure, or make a quiry like this:
UPDATE PS_UserData.dbo.Users_Master SET Point = Point + A WHERE UserID = B
Or you could make it like this:
UPDATE PS_UserData.dbo.Users_Master SET Point = A WHERE UserID = B
Change A for the amount of points and B for the username.
Technique 1 will ADD points and technique 2 will SET points.
|