Query add points

[Kimsangchul]

Msg 2627, Level 14, State 1, Procedure hb_py_gp_apply_userinfo_in, Line 311
Violation of PRIMARY KEY constraint 'PK_TAccountMst'. Cannot insert duplicate key in object 'dbo.TACCOUNTMST'.
The statement has been terminated.

(1 row(s) affected)


This happens because

[MentaL]

[mrNickname]

Created accounts must login to the game atleast one time to make the procedures work. Try login and logout and execute the procedure, see if that works.

[Tsukasa]

Don't create multiple rows for the same user, increase or decrease the amount of cookies in a user's row instead.

[blackstep]

Tsukaya, but I do output like this

http://image.ohozaa.com/i/db4/2untitled.jpg

Help me please

[Tsukasa]

Again, if you execute hb_py_gp_apply_userinfo_in the way it is described here and you haven't tinkered with the database manually it should be working fine.

If the execution fails but the user has a row in TAccountMst already, you can also use this simple update query:

USE [INI3Bill_DB]
GO

DECLARE	@cookiesToAdd int
DECLARE	@totalCookies int

DECLARE @accountName varchar(32)

SET @accountName = N'tsukasa'
SET @cookiesToAdd = 100000

-- Get the old amount (we could do this in one step during update, but oh well)
SELECT TOP 1 @totalCookies = CookieAmt FROM TAccountMst
WHERE UserID = @accountName

-- Increase the value by the amount we want
SET @totalCookies = @totalCookies + @cookiesToAdd

-- And update the amount of cookies for the account
UPDATE TAccountMst
SET CookieAmt = @totalCookies
WHERE UserID = @accountName

GO

[bubbastic]

simple and effective:) as always XD

Btw lol at your new avatar ^