Xtract Posted July 26, 2010 Posted July 26, 2010 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 ... Quote
0 Arsh Posted July 26, 2010 Posted July 26, 2010 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 Quote
0 Arsh Posted July 26, 2010 Posted July 26, 2010 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 Quote
0 fendar Posted July 26, 2010 Posted July 26, 2010 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 Quote
0 Arsh Posted July 26, 2010 Posted July 26, 2010 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. Quote
0 fendar Posted July 26, 2010 Posted July 26, 2010 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 :) Quote
0 sandeagle Posted July 27, 2010 Posted July 27, 2010 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 Quote
0 sandeagle Posted July 27, 2010 Posted July 27, 2010 use C4 full sql pack..and use 74kb Dvamp full update sql pack...all will be ok....???? Quote
0 Arsh Posted July 27, 2010 Posted July 27, 2010 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. Quote
Question
Xtract
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]
Anybody know what wrong and how to resolve this and ...
Please await response ... Thank you so ...
10 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.