Hi to all! I found an article here in the explained forum as add adena in char. I tried to make with another one procedure that I found. more it is generating an error…. could speak to me where is the error? I go to post scripts to facilitate.
You can post now and register later.
If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.
what matters most here are the files... nobody cares what you think or believe if I am one or the other... people choose the best files to create their server and that's it... if for some reason they are not choosing you, you should create something by yourself and offer it.
greetings
Is there a rule that prevents you from doing it? or do you dictate the rules here? haha, I think you still don't know who's in charge here no matter what mod they put in here haha
Question
horo
Hi to all! I found an article here in the explained forum as add adena in char. I tried to make with another one procedure that I found. more it is generating an error…. could speak to me where is the error? I go to post scripts to facilitate.
precedure: lin_BetaAddItem
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO
/****** Object: Stored Procedure dbo.lin_BetaAddItem Script Date: 2003-09-20 ?? 11:51:56 ******/
ALTER PROCEDURE [dbo].[lin_BetaAddItem]
(
@char_id int,
@Item_type int,
@amount int
)
AS
SET NOCOUNT ON
DECLARE @tempRowCount INT
DECLARE @bIsStackable TINYINT
SELECT @bIsStackable = IsStackable FROM ITEMNAME WHERE id = @Item_type
If @bIsStackable Is NULL
Begin
RAISERROR ('Not exist Item Type', 16, 1)
End
Else
Begin
If @bIsStackable = 1
Begin
Update user_item set amount = amount + @amount where item_type = @Item_type and char_id = @char_id
Set @tempRowCount = @@ROWCOUNT
If @tempRowCount = 0
INSERT INTO user_item (char_id, item_type, amount, enchant, eroded, bless, ident, wished, warehouse) VALUES (@char_id, @Item_type, @amount, 0,0,0,0,0,0)
End
Else If @amount = 1
Begin
INSERT INTO user_item (char_id, item_type, amount, enchant, eroded, bless, ident, wished, warehouse) VALUES (@char_id, @Item_type, @amount, 0,0,0,0,0,0)
Set @tempRowCount = @@ROWCOUNT
End
Else
Begin
RAISERROR ('Amount is invalid', 16, 1)
End
End
If @tempRowCount Is NOT NULL
Select @tempRowCount
==================
script PHP
thanks a lot to all
0 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.