Stone ;)

[Bound]

hello all , i gotta problem since i left kal , and back to it again
i added the stones which already released
and when i write it's index in game like /get 1906 i get the item after some seconds exactly i get auto close for no reason and when i try to login again it wait 2 seconds and the game close , idk from where the problem
already used it in clean repack same ! u can take a look

[MentaL]

[Andblood]

try to make new iniitem index. just copy an old talisman and change it name , index and prefix.

[Bound]

try to make new iniitem index. just copy an old talisman and change it name , index and prefix.

already did so !
i tried all the methods with Makova too !

as we are team ! x

well , i fixied it , but when i add the tailsman or the stone on my weapon i go relog the weapon still clean and don't have any effect although i added set prefix stored producer !

[thankx]

restore ur database again (kal_db) (kal_auth) and try with this stored

CREATE PROCEDURE SetPrefix

USE [kal_db]
GO
/****** Object: StoredProcedure [dbo].[SetPrefix] Script Date: 01/13/2010 20:39:39 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[SetPrefix]

@prefix int,
@iid int

AS


declare @pid int
declare @index int
declare @bof_index int
declare @bofindex1 int
declare @EquipInfo int
declare @CheatInfo int
declare @PolishInfo int
declare @BoundInfo int
declare @TotalInfo int
SET @pid = (SELECT PID FROM Item WHERE [IID] = @iid)
SET @index = (SELECT [Index] FROM [Item] WHERE [IID] = @iid)
SET @bof_index = (SELECT [BofIndex] FROM [BofTable] WHERE [Index] = @index)
SET @EquipInfo = (SELECT TOP 1 Info&1 FROM Item WHERE IID = @iid)
SET @CheatInfo = (SELECT TOP 1 Info&8 FROM Item WHERE IID = @iid)
SET @PolishInfo = (SELECT TOP 1 Info&64 FROM Item WHERE IID = @iid)
SET @BoundInfo = (SELECT TOP 1 Info&128 FROM Item WHERE IID = @iid)
SET @TotalInfo = @EquipInfo + @CheatInfo + @PolishInfo + @BoundInfo

IF (@prefix = 150)
begin
--do a special thing, like make bound
UPDATE [Item] SET Info = (Info|128) WHERE IID = @iid
end

ELSE IF (@prefix = 151)
begin
--do a special thing, like make unbound
UPDATE [Item] SET Info = Info - (Info&128) WHERE IID = @iid
end

ELSE IF (@prefix = 152)
begin
--Stone of Demon Blood G3
UPDATE [Item] SET Info = @TotalInfo + 1310720 WHERE IID = @iid
end

ELSE IF (@prefix = 153)
begin
--Stone of Shadow G1
UPDATE [Item] SET Info = @TotalInfo + 524544 WHERE IID = @iid
end

ELSE IF (@prefix = 154)
begin
--Stone of Shadow G2
UPDATE [Item] SET Info = @TotalInfo + 1048832 WHERE IID = @iid
end

ELSE IF (@prefix = 155)
begin
--Stone of Holy G1
UPDATE [Item] SET Info = @TotalInfo + 524800 WHERE IID = @iid
end

ELSE IF (@prefix = 156)
begin
--Stone of Holy G2
UPDATE [Item] SET Info = @TotalInfo + 1049088 WHERE IID = @iid
end

ELSE IF (@prefix = 157)
begin
--Stone of Flame G1
UPDATE [Item] SET Info = @TotalInfo + 525312 WHERE IID = @iid
end

ELSE IF (@prefix = 158)
begin
--Stone of Flame G2
UPDATE [Item] SET Info = @TotalInfo + 1049600 WHERE IID = @iid
end

ELSE IF (@prefix = 159)
begin
--Stone of Ice G1
UPDATE [Item] SET Info = @TotalInfo + 526336 WHERE IID = @iid
end

ELSE IF (@prefix = 160)
begin
--Stone of Ice G2
UPDATE [Item] SET Info = @TotalInfo + 1050624 WHERE IID = @iid
end

ELSE IF (@prefix = 161)
begin
--Stone of Lightning G1
UPDATE [Item] SET Info = @TotalInfo + 528384 WHERE IID = @iid
end

ELSE IF (@prefix = 162)
begin
--Stone of Lightning G2
UPDATE [Item] SET Info = @TotalInfo + 1052672 WHERE IID = @iid
end

ELSE IF (@prefix = 163)
begin
--Stone of Poison G1
UPDATE [Item] SET Info = @TotalInfo + 532480 WHERE IID = @iid
end

ELSE IF (@prefix = 164)
begin
--Stone of Poison G2
UPDATE [Item] SET Info = @TotalInfo + 1056768 WHERE IID = @iid
end

ELSE IF (@prefix = 165)
begin
--Stone of Para G1
UPDATE [Item] SET Info = @TotalInfo + 540672 WHERE IID = @iid
end

ELSE IF (@prefix = 166)
begin
--Stone of Para G2
UPDATE [Item] SET Info = @TotalInfo + 1064960 WHERE IID = @iid
end

ELSE IF (@prefix = 167)
begin
--Stone of Str G1
UPDATE [Item] SET Info = @TotalInfo + 557056 WHERE IID = @iid
end

ELSE IF (@prefix = 168)
begin
--Stone of Str G2
UPDATE [Item] SET Info = @TotalInfo + 1081344 WHERE IID = @iid
end

ELSE IF (@prefix = 169)
begin
--Stone of Skill G1
UPDATE [Item] SET Info = @TotalInfo + 589824 WHERE IID = @iid
end

ELSE IF (@prefix = 170)
begin
--Stone of Skill G2
UPDATE [Item] SET Info = @TotalInfo + 1114112 WHERE IID = @iid
end

ELSE IF (@prefix = 171)
begin
--Stone of Mistery G3
UPDATE [Item] SET Info = @TotalInfo + 1179648 WHERE IID = @iid
end

ELSE IF (@prefix = 172)
begin
--10/10 Physical
UPDATE [Item] SET UpgrLevel = 10, XAttack = 10 WHERE IID = @iid
end

ELSE IF (@prefix = 173)
begin
--10/10 Magical
UPDATE [Item] SET UpgrLevel = 10, XMagic = 10 WHERE IID = @iid
end

ELSE IF (@prefix = 174)
begin
--11/11 Physical
UPDATE [Item] SET UpgrLevel = 11, XAttack = 11 WHERE IID = @iid
end

ELSE IF (@prefix = 175)
begin
--11/11 Magical
UPDATE [Item] SET UpgrLevel = 11, XMagic = 11 WHERE IID = @iid
end

ELSE IF (@prefix = 176)
begin
--12/12 Physical
UPDATE [Item] SET UpgrLevel = 12, XAttack = 12 WHERE IID = @iid
end

ELSE IF (@prefix = 177)
begin
--12/12 Magical
UPDATE [Item] SET UpgrLevel = 12, XMagic = 12 WHERE IID = @iid
end

ELSE IF (@prefix = 178)
begin
--13/13 Physical
UPDATE [Item] SET UpgrLevel = 13, XAttack = 13 WHERE IID = @iid
end

ELSE IF (@prefix = 179)
begin
--13/13 Magical
UPDATE [Item] SET UpgrLevel = 13, XMagic = 13 WHERE IID = @iid
end

ELSE IF (@prefix = 180)
begin
--14/14 Physical
UPDATE [Item] SET UpgrLevel = 14, XAttack = 14 WHERE IID = @iid
end

ELSE IF (@prefix = 181)
begin
--14/14 Magical
UPDATE [Item] SET UpgrLevel = 14, XMagic = 14 WHERE IID = @iid
end

ELSE IF (@prefix = 182)
begin
--15/15 Physical
UPDATE [Item] SET UpgrLevel = 15, XAttack = 15 WHERE IID = @iid
end

ELSE IF (@prefix = 183)
begin
--15/15 Magical
UPDATE [Item] SET UpgrLevel = 15, XMagic = 15 WHERE IID = @iid
end

ELSE IF (@prefix = 184)
begin
--16/16 Physical
UPDATE [Item] SET UpgrLevel = 16, XAttack = 16 WHERE IID = @iid
end

ELSE IF (@prefix = 185)
begin
--16/16 Magical
UPDATE [Item] SET UpgrLevel = 16, XMagic = 16 WHERE IID = @iid
end

ELSE IF (@prefix = 186)
begin
--Eb success chance 100% - UpgradeRate -> 100
UPDATE [Item] SET UpgrRate = 100 WHERE IID = @iid
end

ELSE IF (@prefix = 187)
begin
--16/16/6 Queens Physical & Magical GM
UPDATE [Item] SET UpgrLevel = 16, XHit = 6, XAttack = 16, XMagic = 16, Prefix = 250 WHERE IID = @iid
end

ELSE IF (@prefix = 188)
begin
--5/1 Pride Armor GM
UPDATE [Item] SET XDefense = 5, XDodge = 1, Prefix = 85 WHERE IID = @iid
end

ELSE IF (@prefix = 189)
begin
--18/18/8 Physical
UPDATE [Item] SET UpgrLevel = 18, XHit = 8, XAttack = 18 WHERE IID = @iid
end

ELSE IF (@prefix = 190)
begin
--18/18/8 Magical
UPDATE [Item] SET UpgrLevel = 18, XHit = 8, XMagic = 18 WHERE IID = @iid
end

ELSE IF (@prefix = 191)
begin
--20/20/10 Physical
UPDATE [Item] SET UpgrLevel = 20, XHit = 10, XAttack = 20 WHERE IID = @iid
end

ELSE IF (@prefix = 192)
begin
--20/20/10 Magical
UPDATE [Item] SET UpgrLevel = 20, XHit = 10, XMagic = 20 WHERE IID = @iid
end

ELSE IF (@prefix = 193)
begin
--Test Item
UPDATE [Item] SET XDodge = 2 WHERE IID = @iid
end

ELSE IF (@prefix = 220)
begin
if(@bof_index > 1)
SET @bofindex1 = @bof_index
else
SET @bofindex1 = @index

UPDATE Item SET [Index] = @bofindex1 WHERE [IID] = @iid
end

ELSE IF (@prefix = 221)
begin
if(@bof_index > 1)
SET @bofindex1 = @bof_index
else
SET @bofindex1 = @index

UPDATE Item SET [Index] = @bofindex1 WHERE [IID] = @iid
end

ELSE IF (@prefix = 222)
begin
if(@bof_index > 1)
SET @bofindex1 = @bof_index
else
SET @bofindex1 = @index

UPDATE Item SET [Index] = @bofindex1 WHERE [IID] = @iid
end

ELSE
begin
--Do the normal query
UPDATE Item SET [Prefix] = @prefix WHERE [IID] = @iid
end

[Bound]

FIXIED THANK's FOR R3volutioN and all other :)