fendar

On my W7 64b system SQL 2005 is not working I used 2008

thank you for explanation

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

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

Hi i want only ask if there is info regarding sabotage.dll means what this dll do thanks

START / CONTROL PANEL / ADMINISTRATIVE TOOLS / DATA SOURCES (ODBC) here is example of file DNS [ODBC] DRIVER=SQL Server UID=Administrator DATABASE=lin2world WSID=BFLMPSVZ\SQLEXPRESS APP=Microsoft Data Access Components Trusted_Connection=Yes SERVER=BFLMPSVZ\SQLEXPRESS http://www.microsoft.com/express/Database/InstallOptions.aspx install Database with Management Tools or greater or install full MSSQL :)

Hi somewhere on PP was a 2 lines how correct other two cures (Revmatism and Flue) Does somebody know how to solve it?

Hello I got a lot of error is there someone who knows if those records are erorrs or not? or is there any solution for those records 1) 06/30/2010 14:03:12.375, not active user try save. dbid[13254] 2) 06/30/2010 16:47:07.609, [.\UserSocket.cpp][6589] hacking? user[xxxxx] skill_name_id is invalid 3) 06/30/2010 19:27:46.734, fetch_i : Access violation. Read[8cc], ai[dark_choir_player] event[NO_DESIRE], pc[20], sp[0] 4) 06/30/2010 21:00:05.953, [.\Pet.cpp][139] Load Pet(0) from db failed 06/30/2010 21:00:05.953, [.\Socket.cpp][9603] RequestSavePet failed. invalid 5) 06/30/2010 21:00:17.093, [.\PrecompiledHeaderDB.cpp][269] invalid skill_name_id[0] id[0] level[0] 6) 06/30/2010 21:00:20.078, [.\Skill.cpp][796] Unregistered skill(0-0) 7) 06/30/2010 21:27:59.484, [.\NPC.cpp][13298] Rand(0) -_- 8 ) 07/01/2010 00:46:21.687, [.\Residence.cpp][1257] undefined (or unregistered) Residence[Rune] 9) 07/01/2010 00:53:10.296, [.\User.cpp][1836] ORT - User Release failed. Who[xxxxx], refcount[1] 10) 07/01/2010 00:00:18.703, Error sql: exec Sp_CheckPortal_Log_A '2010-06-30',1,'LogD',0,'' (0) 07/01/2010 00:00:18.703, Error 42000:[Microsoft][ODBC SQL Server Driver][sql Server]Could not find stored procedure 'Sp_CheckPortal_Log_A'. 07/01/2010 00:00:18.718, Error sql: exec Sp_BulkInsPortalLog_A 1,'LogD','2010-06-30','C:\_server\Server\L2logD\log\chat\2010-06-30-23-01-comm-chat1.log',2,0,'' (0) 07/01/2010 00:00:18.718, Error 42000:[Microsoft][ODBC SQL Server Driver][sql Server]Could not find stored procedure 'Sp_BulkInsPortalLog_A'. 07/01/2010 00:00:18.718, Error sql: exec Sp_CheckPortal_Log_A '2010-06-30',1,'LogD',0,'' (0) 07/01/2010 00:00:18.718, Error 42000:[Microsoft][ODBC SQL Server Driver][sql Server]Could not find stored procedure 'Sp_CheckPortal_Log_A'. 07/01/2010 00:00:18.718, Error sql: exec Sp_BulkInsPortalLog_A 1,'LogD','2010-06-30 12:00:00','C:\_server\Server\L2logD\log\in\2010-06-30-23-01-comm-in1.log',1,0,'' (0) 07/01/2010 00:00:18.718, Error 42000:[Microsoft][ODBC SQL Server Driver][sql Server]Could not find stored procedure 'Sp_BulkInsPortalLog_A'. Thank you

with this pack I got 06/29/2010 21:04:53.265, [.\NPC.cpp][5429] target null at DistFromMe(). I'm [antharas1] its strange in DB antaras has al stat setted to 0 only timelow is setted on date when antaras died but when i am going to antaras lair ---- antharas is spawned (no antaras) is this OK? what means target null ? (This is an error from AI?) how to correct this?

yes thank you but why npcdata has 1 antaras and 3 antharas? (antharas1,antharas2 and antharas3) what is this?

1) - in npcdata no record found regarding this package - their have: one antaras and 3 antharas (antharas1, antharas2, antharas3) --- this is strange or not?

Hi from L2server 1) [.\ObjectDB.cpp][203] undefined (or unregistered) Name[antharasa] invalid npc name [antharasa] at file [.\NpcSocket.cpp], line[180] 2) RequestCreatMonrace crete interval is too small [3000] does somebody knows how to fix those isues? from NPCserver 3) [d:\work\l2npc\threadsafelibrary.h][2084] Invalid Class[0] sid[0] (I dont have disk D) 4)[.\NpcMaker.cpp][178] Cannot generate random postion in territory [schuttgart01_npcxxxx_65] Thank you

thank you ... in my DB has collumn name SCORE but thank you you kicked me to right way :)

Are you sure becauase I cant find clan_data table my DB is Interlude

Hi does somebody knows where (in DB) are stored clan reputation points? it is on pledge table? which collumn? thank you