LuckyEnchant error

[hi5]

Hi guys, i have a problem at my server. when user enchanting item and enchant is failed. The e13-e14 weapon look like e15-e16. It seems like a module is repalacing by hyper module, any 1 had error like that?
Best regards, hi5

[MentaL]

[Valdemarus]

See here the corresponding module (ti_EnchantInfo). and look at the options modules (ti_Item)

[inetpub]

LuckyEnchant hmm its one way to fix it:
go to:
atum2_db_1>Programmability>Stored Procedures>dbo.atum_GetEnchantBYItemUID

and change it to:

USE [atum2_db_1]
GO
/****** Object:  StoredProcedure [dbo].[atum_GetEnchantBYItemUID]    Script Date: 24-12-2012 21:34:20 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER PROCEDURE [dbo].[atum_GetEnchantBYItemUID]
	@i_ItemUID		BIGINT
AS

	SELECT TargetItemNum, EnchantItemNum
	FROM td_enchant WITH(NOLOCK)
	WHERE @i_ItemUID = TargetItemUniqueNumber

[bergi9]

LuckyEnchant hmm its one way to fix it:
go to:
atum2_db_1>Programmability>Stored Procedures>dbo.atum_GetEnchantBYItemUID

and change it to:

USE [atum2_db_1]
GO
/****** Object:  StoredProcedure [dbo].[atum_GetEnchantBYItemUID]    Script Date: 24-12-2012 21:34:20 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER PROCEDURE [dbo].[atum_GetEnchantBYItemUID]
	@i_ItemUID		BIGINT
AS

	SELECT TargetItemNum, EnchantItemNum
	FROM td_enchant WITH(NOLOCK)
	WHERE @i_ItemUID = TargetItemUniqueNumber

this dont fix the LuckyEnchant, i have the same since 1 year and still have LuckyEnchant

[hi5]

LuckyEnchant hmm its one way to fix it:
go to:
atum2_db_1>Programmability>Stored Procedures>dbo.atum_GetEnchantBYItemUID

and change it to:

USE [atum2_db_1]
GO
/****** Object:  StoredProcedure [dbo].[atum_GetEnchantBYItemUID]    Script Date: 24-12-2012 21:34:20 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER PROCEDURE [dbo].[atum_GetEnchantBYItemUID]
	@i_ItemUID		BIGINT
AS

	SELECT TargetItemNum, EnchantItemNum
	FROM td_enchant WITH(NOLOCK)
	WHERE @i_ItemUID = TargetItemUniqueNumber

Yea, its realy dont fix the bug. I tryed to replace all procedures, but nothing.
Any 1 know what to do?

[NomCake]

You can fix it in the database for sure :)

I have done this :D

HINT: You will need to create a new Table.

[bergi9]

you need to alter the table and change the prodecure. its simple.

[inetpub]

yea byt how to do it? hmm can somebody explain this?