Send cards

[lucasakmeid]

Hello , I was wondering if you have any SQL table , I can be sending cards to the players.

[MentaL]

[top1]

give me more details

[lucasakmeid]

Say I wanted to give a player with a card , but I 'm not in the game. And please send by SQL .

[top1]

DECLARE @UID INT
DECLARE @carD_TYPEID INT
DECLARE @carD_QTY INT

SET @UID = 1 -- your uid
SET @carD_TYPEID = 1 -- card type number
SET @carD_QTY = 1 -- card quantity to add

IF EXISTS(SELECT 1 FROM TD_CARD_USRS WHERE UID = @UID AND CARD_TYPEID = @carD_TYPEID) BEGIN
UPDATE TD_CARD_USRS SET QTY = QTY + @carD_QTY , USE_YN = 'Y' WHERE UID = @UID
END ELSE BEGIN
INSERT INTO TD_CARD_USRS(UID,CARD_TYPEID,QTY,USE_YN) VALUES (@UID @carD_TYPEID @carD_QTY,'Y')
END

[lucasakmeid]

I could not use the query . More could manually , thank you!

Error: Msg 102, Level 15, State 1, Line 12
Incorrect syntax near '@carD_TYPEID'

[top1]

DECLARE @UID INT
DECLARE     @carD_TYPEID INT
DECLARE     @carD_QTY INT

SET @UID = 1 -- your uid
SET    @carD_TYPEID = 1 -- card type number
SET    @carD_QTY = 1 -- card quantity to add

IF EXISTS(SELECT 1 FROM TD_CARD_USRS WHERE UID = @UID AND CARD_TYPEID = #D_TYPEID) BEGIN
UPDATE TD_CARD_USRS SET QTY = QTY +     @carD_QTY , USE_YN = 'Y' WHERE UID = @UID
END ELSE BEGIN
INSERT INTO TD_CARD_USRS(UID,CARD_TYPEID,QTY,USE_YN) VALUES (@UID    @carD_TYPEID,    @carD_QTY,'Y')
END

Forums is freak its change my code try to uppercase @carD_TYPEID AND @carD_QTY

try this link

[lucasakmeid]

Thank you so much!

[Vaulient]

It seems the problem has been solved , I will be closing the thread for now ,if the problem still persists and OP desires the thread to be opened again , please drop me a PM