[Problem] Alchemy DC Bug

[MissinGDeaTh]

when ever i use alchemy to plus any item i get DC, i don't know the reason.
any one can help me with it ?
the elixir is the same won't be changed, same at the OptLvl on the item wont be changed
so if i'm trying to plus sword +5 with 1 elixir i will get DC and the sword will still be +5 and the 1 elixir in my inventory will be there :/

[IMG=expandable: 1][/IMG]

[​Exo]

Can I see your _AddLogItem proc?

[MissinGDeaTh]

Originally Posted by Exo

Can I see your _AddLogItem proc?

here it's

USE [SRO_VT_SHARD_aBdoOoO]
GO
/****** Object: StoredProcedure [dbo].[_AddLogItem] Script Date: 4/22/2015 4:35:25 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER OFF
GO


ALTER procedure [dbo].[_AddLogItem]
@CharID int,
@ItemRefID int,
@ItemSerial bigint,
@dwData int,
@TargetStorage tinyint,
@Operation tinyint,
@Slot_From tinyint,
@Slot_To tinyint,
@EventPos varchar(64),
@strDesc varchar(128)
as
declare @len_pos int
declare @len_desc int
set @len_pos = len(@EventPos)
set @len_desc = len(@strDesc)
if (@len_pos > 0 and @len_desc > 0)
begin
insert _LogEventItem (EventTime, CharID, ItemRefID, dwData, TargetStorage, Operation, Slot_From, Slot_To, EventPos, strDesc, Serial64)
values(GetDate(), @CharID, @ItemRefID, @dwData, @TargetStorage, @Operation, @Slot_From, @Slot_To, @EventPos, @strDesc, @ItemSerial)
end
else if (@len_pos > 0 and @len_desc = 0)
begin
insert _LogEventItem (EventTime, CharID, ItemRefID, dwData, TargetStorage, Operation, Slot_From, Slot_To, EventPos, Serial64)
values(GetDate(), @CharID, @ItemRefID, @dwData, @TargetStorage, @Operation, @Slot_From, @Slot_To, @EventPos, @ItemSerial)
end
else if (@len_pos = 0 and @len_desc > 0)
begin
insert _LogEventItem (EventTime, CharID, ItemRefID, dwData, TargetStorage, Operation, Slot_From, Slot_To, strDesc, Serial64)
values(GetDate(), @CharID, @ItemRefID, @dwData, @TargetStorage, @Operation, @Slot_From, @Slot_To, @strDesc, @ItemSerial)
end
else if (@len_pos = 0 and @len_desc = 0)
begin
insert _LogEventItem (EventTime, CharID, ItemRefID, dwData, TargetStorage, Operation, Slot_From, Slot_To, Serial64)
values(GetDate(), @CharID, @ItemRefID, @dwData, @TargetStorage, @Operation, @Slot_From, @Slot_To, @ItemSerial)
end
-- 유료 아이템 구입이면!
-- #define LOG_ITEMEVENT_BUY_CASHITEM (BYTE)35
if (@Operation = 35)
begin
insert _LogCashItem (RefItemID, CharID, Cnt, EventTime, Serial64)
values(@ItemRefID, @CharID, @dwData, GetDate(), @ItemSerial)
end

[​Exo]

hmm, did you modify any alchemy material or something?

[MissinGDeaTh]

Originally Posted by Exo

hmm, did you modify any alchemy material or something?

no, did nothing :/

[Syloxx]

Originally Posted by Exo

Can I see your _AddLogItem proc?

o.O _AddLogItem will NEVER be result for a DC

if there is a return / problem with the procedure there is a notice in gameserver thats it no dc or smt else since the Log get executed after all changes happend so it would be useless to disconnect the player just because the log is fcked up.

anyway an optlevel change is a directly update query in the _Items table so it cant be SQL related (just if you modified some items)

its probably a client problem check the dmps maybe you can find a ddj, txt or smt like that wich is missing.

[​Exo]

Originally Posted by Syloxx

o.O _AddLogItem will NEVER be result for a DC

if there is a return / problem with the procedure there is a notice in gameserver thats it no dc or smt else since the Log get executed after all changes happend so it would be useless to disconnect the player just because the log is fcked up.

anyway an optlevel change is a directly update query in the _Items table so it cant be SQL related (just if you modified some items)

its probably a client problem check the dmps maybe you can find a ddj, txt or smt like that wich is missing.

Since he didn't provide any information, this possibility was also available, either it's just a normal dc, or a crash caused by the gs. I felt like starting with this, in case he applied something like max plus or whatever but, seems this wasn't the case.

[Snow*]

Originally Posted by Syloxx

o.O _AddLogItem will NEVER be result for a DC

if there is a return / problem with the procedure there is a notice in gameserver thats it no dc or smt else since the Log get executed after all changes happend so it would be useless to disconnect the player just because the log is fcked up.

anyway an optlevel change is a directly update query in the _Items table so it cant be SQL related (just if you modified some items)

its probably a client problem check the dmps maybe you can find a ddj, txt or smt like that wich is missing.

Client will crash if it has missing stuff (wont give DC). So, maybe he used a query to limit the plus? idk any errors @ GS?

[MissinGDeaTh]

i can't get error @ GS but i get DC not a crash !!

[Syloxx]

Originally Posted by MissinGDeaTh

i can't get error @ GS but i get DC not a crash !!

dc + no errors in gameserver cant be

the only problem wich comes in my mind is that your procedure STRG_DEL_ITEM or smt like that is fcked up and gives you a crash (will probably executed to remove the elixir + lucky powder)

so idk whats wrong but one question if you relog whats happend with the items?

Elixir + Lucky Stay (yes / no)
Item OptLevel changes (yes / no)

you really should give more informations.

[MissinGDeaTh]

Originally Posted by Syloxx

dc + no errors in gameserver cant be

the only problem wich comes in my mind is that your procedure STRG_DEL_ITEM or smt like that is fcked up and gives you a crash (will probably executed to remove the elixir + lucky powder)

so idk whats wrong but one question if you relog whats happend with the items?

Elixir + Lucky Stay (yes / no)
Item OptLevel changes (yes / no)

you really should give more informations.

the elixir and lucky stays the OptLevel wont be changed, i get this error

[lepitismak]

i have the same problem!
But, dont get dc when make alchemy with gm account!
any help?

[cristianxi]

Same Problem to make any plus item
any solution please thnx

 Spoiler