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.
chatgpt answer
1) thats not a lie, "head progressive diseases."
2) thats not about your "had the worst customers" "was rude and disrespectful."
3) you just took what i said in the previous post and mirror it, the truth is on your answers
4) i dont like your skamming skills even here in this topic
stop edditing your answers you called me roten and other names on your first reply now you edit your answers to look good boy 🙂 you are the disrispectful and rude in this community
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.