I seem that my DB table user_item has few collumn --- > bad stored procedures
My user_item table
item_id int
char_id int
item_type int
amount int
enchant int
eroded int
bless int
ident int
wished tinyint
warehouse int
errors
07/11/2010 20:01:39.812, Error sql: EXEC lin_CreateItem 13489,6881,0,0,0,0,0,0,0,254,0,0,0,0,0,0,0 (0)
07/11/2010 20:01:39.875, Error 42000:[Microsoft][ODBC SQL Server Driver][sql Server]Procedure or function lin_CreateItem has too many arguments specified.
07/11/2010 20:05:17.203, Error sql: EXEC lin_UpdateUserItem 912,8615,97,0,0,0,0,0,0,15487441,232,4903,34620,49140,52648,37716,49156,2132 (0)
07/11/2010 20:05:17.203, Error 42000:[Microsoft][ODBC SQL Server Driver][sql Server]Procedure or function lin_UpdateUserItem has too many arguments specified.
USE [lin2world]
GO
/****** Object: StoredProcedure [dbo].[lin_UpdateUserItem] Script Date: 07/11/2010 21:12:30 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[lin_UpdateUserItem]
(
@char_id INT,
@item_type INT,
@amount INT,
@enchant INT,
@eroded INT,
@bless INT,
@ident INT,
@wished tinyint,
@warehouse INT,
@item_id INT
)
AS
SET NOCOUNT ON
UPDATE user_item set char_id=@char_id, item_type=@item_type, amount=@amount, enchant=@enchant, eroded=@eroded, bless=@bless, ident=@ident, wished=@wished, warehouse=@warehouse WHERE item_id=@item_id
Could you please help me with this table and with this procedures
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.
Hello!
Im looking for help, don know its even possible, I made some alterations in chat window sizes for NPC-s.
My problem is the QuestHTMLWnd is working, but cant find a way to resize the rewards icons back grounds.
Some one have any idea for change it?
DISCORD :
utchiha_market
telegram :
https://t.me/utchiha_market
SELLIX STORE :
https://utchihamkt.mysellix.io/
Join our server for more products :
https://discord.gg/hoodservices
https://campsite.bio/utchihaamkt
DISCORD :
utchiha_market
telegram :
https://t.me/utchiha_market
SELLIX STORE :
https://utchihamkt.mysellix.io/
Join our server for more products :
https://discord.gg/hoodservices
https://campsite.bio/utchihaamkt
Question
fendar
Hi
I have a problem when user tried buy item
I got those errors
I seem that my DB table user_item has few collumn --- > bad stored procedures
My user_item table
errors
my lin_CreateItem function
my lin_UpdateUserItem
Could you please help me with this table and with this procedures
Link to comment
Share on other sites
3 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.