Send cards

[lucasakmeid]

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

 

[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     [USER=270052]car[/USER]D_TYPEID INT
DECLARE     [USER=270052]car[/USER]D_QTY INT

SET @UID = 1 -- your uid
SET    [USER=270052]car[/USER]D_TYPEID = 1 -- card type number
SET    [USER=270052]car[/USER]D_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 +     [USER=270052]car[/USER]D_QTY , USE_YN = 'Y' WHERE UID = @UID
END ELSE BEGIN
INSERT INTO TD_CARD_USRS(UID,CARD_TYPEID,QTY,USE_YN) VALUES (@UID    [USER=270052]car[/USER]D_TYPEID,    [USER=270052]car[/USER]D_QTY,'Y')
END

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

try

You must be registered to see links

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