use only this instead :)
PHP Code:
CREATE PROCEDURE [dbo].[SetPrefix]
/***** Written by PwNeR for PwNeR's World *****/
/***** Date: 07.07.2013 16:26:00 *****/
@prefix int,
@iid int
AS
DECLARE @pid int
DECLARE @EquipInfo int
DECLARE @CheatInfo int
DECLARE @PolishInfo int
DECLARE @BoundInfo int
DECLARE @TotalInfo int
DECLARE @index int
DECLARE @bof_index int
DECLARE @bofindex1 int
DECLARE @imp_index int
DECLARE @impindex1 int
SET @pid = (SELECT PID FROM Item WHERE [IID] = @iid)
SET @EquipInfo = @TotalInfo + (SELECT TOP 1 Info&1 FROM Item WHERE IID = @iid)
SET @CheatInfo = @TotalInfo + (SELECT TOP 1 Info&8 FROM Item WHERE IID = @iid)
SET @PolishInfo = @TotalInfo + (SELECT TOP 1 Info&64 FROM Item WHERE IID = @iid)
SET @BoundInfo = @TotalInfo + (SELECT TOP 1 Info&128 FROM Item WHERE IID = @iid)
SET @TotalInfo = @TotalInfo + @EquipInfo + @CheatInfo + @PolishInfo + @BoundInfo
SET @index = (SELECT [Index] FROM [Item] WHERE [IID] = @iid)
SET @bof_index = (SELECT [BofIndex] FROM [BofTable] WHERE [Index] = @index)
SET @imp_index = (SELECT [ImpIndex] FROM [ImpTable] WHERE [Index] = @index)
----------------------------------------------------------------------------
--- Bead of Fire
IF (@prefix = 94)
begin
if(@bof_index > 1)
SET @bofindex1 = @bof_index
else
SET @bofindex1 = @index
UPDATE Item SET [Index] = @bofindex1 WHERE [IID] = @iid
end
----------------------------------------------------------------------------
--- Pimp
ELSE IF (@prefix = 95)
begin
-- 10 Attack | 10 Magic Attack | 10 Blow | 0 OTP
UPDATE Item SET XAttack = 10, XMagic = 10, UpgrLevel = 10 WHERE [IID] = @iid
end
ELSE IF (@prefix = 96)
begin
-- 11 Attack | 11 Magic Attack | 11 Blow | 1 OTP
UPDATE Item SET XAttack = 11, XMagic = 11, UpgrLevel = 11, XHit = 1 WHERE [IID] = @iid
end
ELSE IF (@prefix = 97)
begin
-- 12 Attack | 12 Magic Attack | 12 Blow | 2 OTP
UPDATE Item SET XAttack = 12, XMagic = 12, UpgrLevel = 12, XHit = 2 WHERE [IID] = @iid
end
ELSE IF (@prefix = 98)
begin
-- 13 Attack | 13 Magic Attack | 13 Blow | 3 OTP
UPDATE Item SET XAttack = 13, XMagic = 13, UpgrLevel = 13, XHit = 3 WHERE [IID] = @iid
end
ELSE IF (@prefix = 99)
begin
-- 14 Attack | 14 Magic Attack | 14 Blow | 4 OTP
UPDATE Item SET XAttack = 14, XMagic = 14, UpgrLevel = 14, XHit = 4 WHERE [IID] = @iid
end
ELSE IF (@prefix = 100)
begin
-- 15 Attack | 15 Magic Attack | 15 Blow | 5 OTP
UPDATE Item SET XAttack = 15, XMagic = 15, UpgrLevel = 15, XHit = 5 WHERE [IID] = @iid
end
ELSE IF (@prefix = 101)
begin
-- 16 Attack | 16 Magic Attack | 16 Blow | 6 OTP
UPDATE Item SET XAttack = 16, XMagic = 16, UpgrLevel = 16, XHit = 6 WHERE [IID] = @iid
end
----------------------------------------------------------------------------
---- Special Items
--- Imperial
ELSE IF (@prefix = 102)
begin
if(@imp_index > 1)
SET @impindex1 = @imp_index
else
SET @impindex1 = @index
UPDATE Item SET [Index] = @impindex1 WHERE [IID] = @iid
end
----------------------------------------------------------------------------
--- Mix Stones
-- G1 Mix
ELSE IF (@prefix = 103)
begin
-- Shadow
UPDATE [Item] SET Info = (Info|524552) WHERE IID = @iid
end
ELSE IF (@prefix = 104)
begin
-- Holy
UPDATE [Item] SET Info = (Info|524808) WHERE IID = @iid
end
ELSE IF (@prefix = 105)
begin
-- Fire
UPDATE [Item] SET Info = (Info|525320) WHERE IID = @iid
end
ELSE IF (@prefix = 106)
begin
-- Ice
UPDATE [Item] SET Info = (Info|526344) WHERE IID = @iid
end
ELSE IF (@prefix = 107)
begin
-- Lightning
UPDATE [Item] SET Info = (Info|528392) WHERE IID = @iid
end
ELSE IF (@prefix = 108)
begin
-- Poison
UPDATE [Item] SET Info = (Info|532488) WHERE IID = @iid
end
ELSE IF (@prefix = 109)
begin
-- Paralyze
UPDATE [Item] SET Info = (Info|540680) WHERE IID = @iid
end
ELSE IF (@prefix = 110)
begin
-- Strength
UPDATE [Item] SET Info = (Info|557064) WHERE IID = @iid
end
ELSE IF (@prefix = 111)
begin
-- Skill
UPDATE [Item] SET Info = (Info|524552) WHERE IID = @iid
end
---------------------------------
-- G3
ELSE IF (@prefix = 112)
begin
-- Mystery
UPDATE [Item] SET Info = (Info|1179720) WHERE IID = @iid
end
ELSE IF (@prefix = 113)
begin
-- Demons Blood
UPDATE [Item] SET Info = (Info|13107920) WHERE IID = @iid
end
----------------------------------
-- G2
ELSE IF (@prefix = 114)
begin
-- Shadow
UPDATE [Item] SET Info = (Info|1048840) WHERE IID = @iid
end
ELSE IF (@prefix = 115)
begin
-- Holy
UPDATE [Item] SET Info = (Info|1049096) WHERE IID = @iid
end
ELSE IF (@prefix = 116)
begin
-- Fire
UPDATE [Item] SET Info = (Info|1049608) WHERE IID = @iid
end
ELSE IF (@prefix = 117)
begin
-- Ice
UPDATE [Item] SET Info = (Info|1050632) WHERE IID = @iid
end
ELSE IF (@prefix = 118)
begin
-- Lightning
UPDATE [Item] SET Info = (Info|1052680) WHERE IID = @iid
end
ELSE IF (@prefix = 119)
begin
-- Poison
UPDATE [Item] SET Info = (Info|1056776) WHERE IID = @iid
end
ELSE IF (@prefix = 120)
begin
-- Paralyze
UPDATE [Item] SET Info = (Info|1064968) WHERE IID = @iid
end
ELSE IF (@prefix = 121)
begin
-- Strength
UPDATE [Item] SET Info = (Info|1081353) WHERE IID = @iid
end
ELSE IF (@prefix = 122)
begin
-- Skill
UPDATE [Item] SET Info = (Info|1114120) WHERE IID = @iid
end
----------------------------------------------------------------------------
-- Mix Remover
ELSE IF (@prefix = 123)
begin
-- Remove all Mix infos from a item
UPDATE Item SET Info = 0 WHERE [IID] = @iid
end
----------------------------------------------------------------------------
-- Other Pimp Talis
ELSE IF (@prefix = 126)
begin
-- 18 Attack | 18 Magic Attack | 18 Blow | 8 OTP
UPDATE Item SET XAttack = 18, XMagic = 18, UpgrLevel = 18, XHit = 8 WHERE [IID] = @iid
end
ELSE IF (@prefix = 127)
begin
-- 10 Def | 1 Eva
UPDATE Item SET XDefense = 10, XDodge = 1 WHERE [IID] = @iid
end
ELSE IF (@prefix = 128)
begin
-- 5 Def | 1 Eva
UPDATE Item SET XDefense = 1, XDodge = 1 WHERE [IID] = @iid
end
ELSE
begin
-- do the normal query
UPDATE Item SET [Prefix] = @prefix WHERE [IID] = @iid
end
he posted 2 times the same procedure thats why ^^
