Quest Boss item dont appear in equip

[katsumi]

After winning boss Quest
the items dont cm in equip
[eg:- i won shattered gunz doesnt apper in equip or storage ]
maybe some DB missing
any1 knows?

 

[CrashPoint]

Execute tis Query

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go




/****** Object:  Stored Procedure dbo.InsertCharItem    Script Date: 12/3/2008 3:42:11 PM ******/


/* 캐릭터 아이템 추가 - 땜빵 */
ALTER PROC [dbo].[InsertCharItem]
    @CID        int,
    @ItemID        int,
    @per        int
AS
SET NOCOUNT ON 

DECLARE @OrderCIID    int
DECLARE @varBP         int
-- 땜빵
SELECT @varBP = BP FROM Character where CID=@CID
IF @varBP < 0
BEGIN
    UPDATE Character SET BP=0 WHERE CID=@CID
    RETURN (-1)
END


BEGIN TRAN
INSERT INTO CharacterItem (CID, ItemID, RegDate, RentHourPeriod) Values (@CID, @ItemID, GETDATE(), @per)
IF 0 <> @@ERROR BEGIN
    ROLLBACK TRAN
    RETURN (-1)
END
COMMIT TRAN

SET @OrderCIID = @@IDENTITY
SELECT @OrderCIID as ORDERCIID

 

[katsumi]

i got this error

Msg 208, Level 16, State 6, Procedure InsertCharItem, Line 32
Invalid object name 'dbo.InsertCharItem'.

 

[CrashPoint]

i got this error

Msg 208, Level 16, State 6, Procedure InsertCharItem, Line 32
Invalid object name 'dbo.InsertCharItem'.

Maybe u use a different DB.sql, change 'dbo.InsertCharItem' => 'dbo.spInsertCharItem'

 

[katsumi]

thanks

 

[CrashPoint]

np

 

[wesman2232]

Execute tis Query

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go




/****** Object:  Stored Procedure dbo.InsertCharItem    Script Date: 12/3/2008 3:42:11 PM ******/


/* 캐릭터 아이템 추가 - 땜빵 */
ALTER PROC [dbo].[InsertCharItem]
    @CID        int,
    @ItemID        int,
    @per        int
AS
SET NOCOUNT ON 

DECLARE @OrderCIID    int
DECLARE @varBP         int
-- 땜빵
SELECT @varBP = BP FROM Character where CID=@CID
IF @varBP < 0
BEGIN
    UPDATE Character SET BP=0 WHERE CID=@CID
    RETURN (-1)
END


BEGIN TRAN
INSERT INTO CharacterItem (CID, ItemID, RegDate, RentHourPeriod) Values (@CID, @ItemID, GETDATE(), @per)
IF 0 <> @@ERROR BEGIN
    ROLLBACK TRAN
    RETURN (-1)
END
COMMIT TRAN

SET @OrderCIID = @@IDENTITY
SELECT @OrderCIID as ORDERCIID

fixed and added to my fix thread.

 

[kihieu]

Hey CrashPoint, show me how to add new item to shop, especially 2 newest set =))

 

[CrashPoint]

Hey CrashPoint, show me how to add new item to shop, especially 2 newest set =))

xin lỗi tớ chỉ gi

 

[RedMG]

xin lỗi tớ chỉ gi

 

[CrashPoint]

WTF? ) You are funny, CP :> Let's help him :|

i heard tat my GMs BANNED him maybe 3 times cuz hackin so ... not gonna help :|.

@kihieu: if u wan, use da Search Button

 

[katsumi]

well i guess the items get stored in Equip for unlimited days
how to put time limit like iiji
for 7 days