Jump to content
  • 0

[Helper] pliz Cached error


Xtract

Question

help new dll error cached.exe 176kb

 

HTML Code:

 

23/07/2010 23:40:38.546, Error sql: EXEC lin_CreateItem 1,57,0,0,0,0,0,0,0,254,0,0,0,0,0,0,0 (0)

23/07/2010 23:40:38.562, Error 42000: [Microsoft] [ODBC SQL Server Driver]

 Procedure or function lin_CreateItem Has too many arguments specified.

 

Anybody know what wrong and how to resolve this and ...

 

Please await response ... Thank you so ...

Link to comment
Share on other sites

10 answers to this question

Recommended Posts

  • 0

You miss the last dVamp SQL updates... this is the procedure update for createitem that you miss..

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,
@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

insert into user_item 
(char_id , item_type , amount , enchant , eroded , bless , ident , wished , warehouse,attack_attr_type, attack_attr_value, def_attr_fire, def_attr_water, def_attr_wind, def_attr_earth, def_attr_holy, def_attr_unholy) 
values 
(@char_id, @item_type , @amount , @enchant , @eroded , @bless , @ident , @wished , @warehouse,@attack_attr_type, @attack_attr_value, @def_attr_fire, @def_attr_water, @def_attr_wind, @def_attr_earth, @def_attr_holy, @def_attr_unholy)

SELECT @@IDENTITY
GO

 

Anyway, next time, use the search, some days ago someone asked the same thing

Link to comment
Share on other sites

  • 0

very very thx man...^^

 

user_item ??

what about user_item?

 

Edit: you mean the missing fields?

 

here you go,

ALTER TABLE user_item ADD
[attack_attr_type] [tinyint] NOT NULL DEFAULT 254,
[attack_attr_value] [int] NOT NULL DEFAULT 0,
[def_attr_fire] [int] NOT NULL DEFAULT 0,
[def_attr_water] [int] NOT NULL DEFAULT 0,
[def_attr_wind] [int] NOT NULL DEFAULT 0,
[def_attr_earth] [int] NOT NULL DEFAULT 0,
[def_attr_holy] [int] NOT NULL DEFAULT 0,
[def_attr_unholy] [int] NOT NULL DEFAULT 0
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

GO

And you miss many others, ill post them later if i have time

Link to comment
Share on other sites

  • 0

you are not familiar with SQL

 

USE [lin2world]
GO
/****** Object:  StoredProcedure [dbo].[lin_UpdateUserItem]    Script Date: 07/12/2010 07:32:31 ******/
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,
@attack_attr_type   INT,
@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

Link to comment
Share on other sites

  • 0

you are not familiar with SQL

 

USE [lin2world]
GO
/****** Object:  StoredProcedure [dbo].[lin_UpdateUserItem]    Script Date: 07/12/2010 07:32:31 ******/
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,
@attack_attr_type   INT,
@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

I dont get your point.

Link to comment
Share on other sites

  • 0

heh :D

sorry wrong file

 

ALTER TABLE user_item ADD
attack_attr_type    INT NULL DEFAULT 0,
attack_attr_value    INT NULL DEFAULT 0,
def_attr_fire    INT NULL DEFAULT 0,
def_attr_water    INT NULL DEFAULT 0,
def_attr_wind    INT NULL DEFAULT 0,
def_attr_earth    INT NULL DEFAULT 0,
def_attr_holy    INT NULL DEFAULT 0,
def_attr_unholy    INT NULL DEFAULT 0
GO

 

btw you will need also lin_UpdateUserItem :)

Link to comment
Share on other sites

  • 0

 


ALTER TABLE user_item ADD
[attack_attr_type] [tinyint] NOT NULL DEFAULT 254,
[attack_attr_value] [int] NOT NULL DEFAULT 0,
[def_attr_fire] [int] NOT NULL DEFAULT 0,
[def_attr_water] [int] NOT NULL DEFAULT 0,
[def_attr_wind] [int] NOT NULL DEFAULT 0,
[def_attr_earth] [int] NOT NULL DEFAULT 0,
[def_attr_holy] [int] NOT NULL DEFAULT 0,
[def_attr_unholy] [int] NOT NULL DEFAULT 0
GO

ALTER TABLE user_data ADD
wedding int NULL,
division int NOT NULL DEFAULT 0,
pledge_group int NOT NULL DEFAULT 0,
AcademyLev int NOT NULL DEFAULT 0,
KarmaOrig int NOT NULL DEFAULT 0,
PKdiff int NOT NULL DEFAULT 0,
ST_face int NOT NULL DEFAULT 0,
CursedTimeEquip int NOT NULL DEFAULT 0,
TitleColor int NULL,
WeddingTelTime int NOT NULL DEFAULT 0,
SponsorId int NOT NULL DEFAULT 0,
ST_left_bracelet int NOT NULL DEFAULT 0,
ST_right_bracelet int NOT NULL DEFAULT 0,
ST_hairall int NOT NULL DEFAULT 0,
ST_agathon int NOT NULL DEFAULT 0,
souls int NOT NULL DEFAULT 0,
transformation_id int NOT NULL DEFAULT 0,
talisman1 int NOT NULL DEFAULT 0,
talisman2 int NOT NULL DEFAULT 0,
talisman3 int NOT NULL DEFAULT 0,
talisman4 int NOT NULL DEFAULT 0,
talisman5 int NOT NULL DEFAULT 0,
talisman6 int NOT NULL DEFAULT 0,
reputation_point int NULL DEFAULT 0;
GO

Link to comment
Share on other sites

  • 0

use C4 full sql pack..and use 74kb Dvamp full update sql pack...all will be ok....????

First he have already solved with the sql,and your user_data its nor for the interlude pack,

second, you still love to spam everywhere, duble post, and non sense posts.

Link to comment
Share on other sites

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.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.



×
×
  • Create New...