[help]new dvamp problem

[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

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.

 

my lin_CreateItem function

ALTER PROCEDURE [dbo].[lin_CreateItem]
(
@char_id	INT,
@item_type 	INT,
@amount 	INT,
@enchant 	INT,
@eroded 	INT,
@bless 		INT,
@ident 		TINYINT,
@wished 	TINYINT,
@warehouse	INT
)
AS
SET NOCOUNT ON

insert into user_item 
(char_id , item_type , amount , enchant , eroded , bless , ident , wished , warehouse) 
values 
(@char_id, @item_type , @amount , @enchant , @eroded , @bless , @ident , @wished , @warehouse)

SELECT @@IDENTITY

 

 

my lin_UpdateUserItem

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

[fendar]

now i have this fixed, but still i dont know the names of new fields

could anybody tell me the names of the new collumns in user_item table?

by adding new collumns

[fendar]

becauase some of you are  asking me for names

here are new names

attack_attr_type, attack_attr_value, def_attr_fire, def_attr_water, def_attr_wind, def_attr_earth, ef_attr_holy, def_attr_unholy

[segfault1]

this is simple sql correction...

 

USE [fredworld]
GO
/****** Object:  StoredProcedure [dbo].[lin_UpdateUserItem]    Script Date: 06/19/2010 14:07:53 ******/
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	INT,
@warehouse	INT,
@item_id		INT,
@attack_attr_type	TINYINT,
@attack_attr_value	INT,
@def_attr_fire	INT,
@def_attr_water	INT,
@def_attr_wind	INT,
@def_attr_earth	INT,
@def_attr_holy	INT,
@def_attr_unholy	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, attack_attr_type=@attack_attr_type, attack_attr_value=@attack_attr_value, def_attr_fire=@def_attr_fire, def_attr_water=@def_attr_water, def_attr_wind=@def_attr_wind, def_attr_earth=@def_attr_earth, def_attr_holy=@def_attr_holy, def_attr_unholy=@def_attr_unholy WHERE item_id=@item_id