Code:
USE [Pangya_S4_TH]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
/**************************************************
* TSU_AddCardToUser *
* Last Update: 2010-12-19 *
* *
* Adds a card from the published cardsets to a *
* user's inventory. *
**************************************************/
CREATE PROC [dbo].[TSU_AddCardToUser] (
@user_id varchar(32),
@card_id int
)
AS
BEGIN
DECLARE @user_idx int
DECLARE @card_type int
SELECT @user_idx = [UID] FROM [Pangya_Member_Info]
WHERE [userid] = @user_id
IF @@ROWCOUNT = 1
BEGIN
SELECT TOP 1 @card_type = [card_type] FROM [TA_CARDPACK_ITEM]
WHERE CARD_TYPEID = @card_id
IF @@ROWCOUNT = 1
BEGIN
INSERT INTO TD_CARD_USRS ( [UID], [CARD_TYPEID], [CARD_TYPE], [QTY], [USE_YN] )
VALUES ( @user_idx, @card_id, @card_type, 1, N'Y')
RETURN @@ERROR
END
ELSE
BEGIN
PRINT N'Card does not exist!'
RETURN 1
END
END
ELSE
BEGIN
PRINT N'User does not exist!'
RETURN 1
END
END
GO
Msg 2714, Level 16, State 3, Procedure TSU_AddCardToUser, Line 44
There is already an object named 'TSU_AddCardToUser' in the database.
i want ADD ALL CARD TO USER
exp. id jamesbond007
help plz.
---------------------------------------------
today i make room for sell item other player but can't sell item
This error
how do you Fix this problem
sorry i suck english
Thank you very much, sir.
Last edited: