Question about database save points,kill, and deaths

[jeromerz]

Hello guys,

i need a little help about saving the points, kills, and deaths on Points table without replacing the current values there but the new values will be added to the old values.

my prodecure on saving

 Spoiler

IF NOT EXISTS ( SELECT * FROM POINTS_TBL WHERE idPlayer = @idPlayer and serverindex = @dex )
BEGIN
INSERT POINTS_TBL ( serverindex, szName, idPlayer, nJob, nPoints, nKills, nDeaths )
VALUES @dex, @ame, @idPlayer, @b, @nPoints, @lls, @s )
END
ELSE BEGIN

UPDATE POINTS_TBL SET

serverindex = @dex,
szName = @ame,
idPlayer = @idPlayer,
nJob = @b,
nPoints = @nPoints,
nKills = @lls,
nDeaths = @s

WHERE serverindex = @dex AND idPlayer = @idPlayer
END
RETURN

but instead of adding or updating the values on POINTS_TBL it replaces the value there with the new ones.

Sorry for the bad english. im kinda new about databases..

Thanks in advance

[alfredico]

Originally Posted by jeromerz

i need a little help about saving the points, kills, and deaths on Points table without replacing the current values there but the new values will be added to the old values.

What? Any example?

[jeromerz]

Im working FFA System based on erendora. When the player war starts and a recorded score is added on the database the next time i reopen the event or the next player war occurs. The score recorded is replaced on the score_tbl instead of adding it.

I hope you can help me thnx in advance

[alfredico]

After reading over 10 times trying to figure out what you want to say, I guess you are trying to increase the points each time the event finishes.

nPoints = nPoints + @nPoints,
nKills = nKills + @lls,
nDeaths = nDeaths + @s

[jeromerz]

Originally Posted by alfredico

After reading over 10 times trying to figure out what you want to say, I guess you are trying to increase the points each time the event finishes.

nPoints = nPoints + @nPoints,
nKills = nKills + @lls,
nDeaths = nDeaths + @s

Thanks sir ^^