Jump to content
MaxCheaters Official Group on Discord
-> Place your ad text here <-
We're Rebuilding – Join Our Staff Team
  • 0

[Helper] pliz Cached error

Xtract

Asked by Xtract,

 Share

Question

Xtract Newbie

Xtract

Posted
Posted

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 ...

10 answers to this question

Recommended Posts

  • 0
Arsh Newbie

Arsh

Posted
Posted

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

  • 0
Arsh Newbie

Arsh

Posted
Posted

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

  • 0
fendar Newbie

fendar

Posted
Posted

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

  • 0
Arsh Newbie

Arsh

Posted
Posted

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.

  • 0
fendar Newbie

fendar

Posted
Posted

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 :)

  • 0
sandeagle Community Regular

sandeagle

Posted
Posted

 


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

  • 0
Arsh Newbie

Arsh

Posted
Posted

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.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share
Go to question listing


  • Posts

    • 4TOP
      L2J4Team - Oath of Blood C5

      By 4TOP · Posted

      Added FloodProtector utility to prevent packet flooding for actions like item use and dice rolling. Integrated flood protection checks in relevant client packet handlers and registered/removal hooks in player lifecycle. Updated movement logic in L2PcInstance for improved position synchronization and geodata handling. Minor fixes and refactoring in attack logic, private store handling, and admin NPC editing. Refactored AI classes to enhance movement, attack, and skill usage logic for characters and mobs. Improved distance checks, attack range calculations, and skill casting conditions. Removed unused intention command logic from L2CharacterAI. Updated configuration to enable CellPathFinding. Minor code cleanups and bug fixes for more reliable AI behavior. Enhanced GeoPathFinding with detailed debug and error messages for region loading, including success/failure counts and file checks. Refactored L2AttackableAI and L2CharacterAI to improve attack range tolerance, immediate attack behavior, and added safety checks for missing targets. Updated configuration to disable CellPathFinding by default and added a new ShowRedName option for aggressive mobs. Minor config and log updates included. Applied TCP socket optimizations (e.g., TCP_NODELAY, buffer sizes, keepalive) in ClientThread, Connection, and SelectorThread to reduce latency and improve throughput. Enhanced L2AttackableAI with better random walk, aggro, and attack logic, including silent move checks, quest monster handling, and improved faction/raid/minion behavior. Added silent move support to L2PlayableInstance and quest monster flag to L2NpcTemplate/L2NpcInstance. These changes aim to improve server responsiveness, AI realism, and overall stability.
    • Cygnus
      [L2J] L2 Cygnus

      By Cygnus · Posted

      Thanks 🙂
    • Meissgenry
      EFT Cheats • Aimbot, ESP, HWID Spoofer • Fully Undetected

      By Meissgenry · Posted

      I’ve been using this Escape from Tarkov Hack for about a week now with no issues at all. ESP works great without any lag, and the aimbot is smooth and doesn't feel obvious. Had a quick setup with the loader, and support answered my questions right away. The HWID spoofer also did its job without messing with my system. So far, the cheat's staying undetected on my side.
    • wongerlt
      Need OOG bot that works with L2J Interlude

      By wongerlt · Posted

      it have ig and oog
    • Advertising
      Hello everyone, this is ADENA L2REBORN / LU4 / MASTERWORK

      By Advertising · Posted

      Hello everyone, this is ADENA L2REBORN / LU4 / MASTERWORK We also have items, epics, etc. discord - adver745645 Our prices are reasonable, so have a nice shopping and a nice day.

  • Topics

×
×
  • Create New...

AdBlock Extension Detected!

Our website is made possible by displaying online advertisements to our members.

Please disable AdBlock browser extension first, to be able to use our community.

I've Disabled AdBlock