Paradise

[Doublingkal]

hello somebody still got paradise files , i just wanted to get it's SP please
I need bof SP and create SP and other , if u can get it please upload it for me
ty

 

[KillerDM]

Im using Paradise repack from 3 years ago, but dont have the clean repack. Just the 1 i modified, or i would have reuploaded for you.

 

[Doublingkal]

i just need the server files and tools , and thank you

 

[KillerDM]

I dont have the clean server files, and since im still real busy working on setting my own server up, i cant give you the modified. Sorry

EDIT:
Lucky you i did a little seach and found them for you.

To view the content, you need to sign in or register

To view the content, you need to sign in or register

have fun with them

 

[Doublingkal]

When i add the Setprefix in SQL 2005

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

I got this error

Msg 156, Level 15, State 1, Procedure SetPrefix, Line 3
Incorrect syntax near the keyword 'USE'.
Msg 154, Level 15, State 1, Procedure SetPrefix, Line 3
a USE database statement is not allowed in a procedure, function or trigger.

 

[Kallyanna]

Meaning you have tohe wrong db server.. try my Set prefix HERE http://forum.ragezone.com/f316/talisman-985399/and try that if is doesnt work thrn try editing it from there

 

[Doublingkal]

Okey i'll try it now



Fixed . i just deleted

CREATE PROCEDURE SetPrefix

from the setprefix , no more ^^



but the tailsmans dont work in the server
10/10 , 11//11 / 12/12 check it
intitem

;Upgrade Merchant items

;10/10 physical
(item	(name 7000)		(Index 9915)	(Image "item017") 			(class general charm)	(code 3 5 12 0)	(country 2)			(use 1)	(plural 1)									(buy 1000000)	(sell 0)					(specialty																												             (Changeprefix weapon  100 172)								)								)

;10/10 Magical
(item	(name 7001)		(Index 9916)	(Image "item017") 			(class general charm)	(code 3 5 12 0)	(country 2)			(use 1)	(plural 1)									(buy 1000000)	(sell 0)					(specialty																												             (Changeprefix weapon  100 173)								)								)



;11/11 physical
(item	(name 7002)		(Index 9917)	(Image "item017") 			(class general charm)	(code 3 5 12 0)	(country 2)			(use 1)	(plural 1)									(buy 2000000)	(sell 0)					(specialty																												             (Changeprefix weapon  75 174)								)								)

;11/11 Magical
(item	(name 7003)		(Index 9918)	(Image "item017") 			(class general charm)	(code 3 5 12 0)	(country 2)			(use 1)	(plural 1)									(buy 2000000)	(sell 0)					(specialty																												             (Changeprefix weapon  75 175)								)								)



;12/12 physical
(item	(name 7004)		(Index 9919)	(Image "item017") 			(class general charm)	(code 3 5 12 0)	(country 2)			(use 1)	(plural 1)									(buy 2500000)	(sell 0)					(specialty																												             (Changeprefix weapon  50 176)								)								)

;12/12 Magical
(item	(name 7005)		(Index 9920)	(Image "item017") 			(class general charm)	(code 3 5 12 0)	(country 2)			(use 1)	(plural 1)									(buy 2500000)	(sell 0)					(specialty																												             (Changeprefix weapon  50 177)								)								)



;13/13 physical
(item	(name 7006)		(Index 9921)	(Image "item017") 			(class general charm)	(code 3 5 12 0)	(country 2)			(use 1)	(plural 1)									(buy 3000000)	(sell 0)					(specialty																												             (Changeprefix weapon  25 178)								)								)

;13/13 Magical
(item	(name 7007)		(Index 9922)	(Image "item017") 			(class general charm)	(code 3 5 12 0)	(country 2)			(use 1)	(plural 1)									(buy 3000000)	(sell 0)					(specialty																												             (Changeprefix weapon  25 179)								)								)

Prefix

(prefix	(index 172)	(level 0)	(sell 50)	(str 0)	(Hth 0)									(hit 0)		(Int 0) (Dex 0)						)
(prefix	(index 173)	(level 0)	(sell 50)	(str 0)	(Hth 0)									(hit 0)		(Int 0) (Dex 0)						)
(prefix	(index 174)	(level 0)	(sell 50)	(str 0)	(Hth 0)									(hit 0)		(Int 0) (Dex 0)						)
(prefix	(index 175)	(level 0)	(sell 50)	(str 0)	(Hth 0)									(hit 0)		(Int 0) (Dex 0)						)
(prefix	(index 176)	(level 0)	(sell 50)	(str 0)	(Hth 0)									(hit 0)		(Int 0) (Dex 0)						)
(prefix	(index 177)	(level 0)	(sell 50)	(str 0)	(Hth 0)									(hit 0)		(Int 0) (Dex 0)						)
(prefix	(index 178)	(level 0)	(sell 50)	(str 0)	(Hth 0)									(hit 0)		(Int 0) (Dex 0)						)
(prefix	(index 179)	(level 0)	(sell 50)	(str 0)	(Hth 0)									(hit 0)		(Int 0) (Dex 0)						)

SP ( 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]

 [USER=523062]Prefix[/USER] int,
@iid int

AS


declare @pid int
declare [USER=1333459381]Index[/USER] int
declare @bof_index int
declare @bofindex1 int
declare [USER=1333374026]equip[/USER]Info int
declare [USER=155687]cheat[/USER]Info int
declare [USER=1333366307]pol[/USER]ishInfo int
declare [USER=1333427606]Bound[/USER]Info int
declare [USER=2000041465]Total[/USER]Info int
SET @pid = (SELECT PID FROM Item WHERE [IID] = @iid)
SET [USER=1333459381]Index[/USER] = (SELECT [Index] FROM [Item] WHERE [IID] = @iid)
SET @bof_index = (SELECT [BofIndex] FROM [BofTable] WHERE [Index] = [USER=1333459381]Index[/USER])
SET [USER=1333374026]equip[/USER]Info = (SELECT TOP 1 Info&1 FROM Item WHERE IID = @iid)
SET [USER=155687]cheat[/USER]Info = (SELECT TOP 1 Info&8 FROM Item WHERE IID = @iid)
SET [USER=1333366307]pol[/USER]ishInfo = (SELECT TOP 1 Info&64 FROM Item WHERE IID = @iid)
SET [USER=1333427606]Bound[/USER]Info = (SELECT TOP 1 Info&128 FROM Item WHERE IID = @iid)
SET [USER=2000041465]Total[/USER]Info = [USER=1333374026]equip[/USER]Info + [USER=155687]cheat[/USER]Info + [USER=1333366307]pol[/USER]ishInfo + [USER=1333427606]Bound[/USER]Info

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

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

ELSE IF  [USER=523062]Prefix[/USER] = 152)
begin
--Stone of Demon Blood G3
UPDATE [Item] SET Info = [USER=2000041465]Total[/USER]Info + 1310720 WHERE IID = @iid
end

ELSE IF  [USER=523062]Prefix[/USER] = 153)
begin
--Stone of Shadow G1
UPDATE [Item] SET Info = [USER=2000041465]Total[/USER]Info + 524544 WHERE IID = @iid
end

ELSE IF  [USER=523062]Prefix[/USER] = 154)
begin
--Stone of Shadow G2
UPDATE [Item] SET Info = [USER=2000041465]Total[/USER]Info + 1048832 WHERE IID = @iid
end

ELSE IF  [USER=523062]Prefix[/USER] = 155)
begin
--Stone of Holy G1
UPDATE [Item] SET Info = [USER=2000041465]Total[/USER]Info + 524800 WHERE IID = @iid
end

ELSE IF  [USER=523062]Prefix[/USER] = 156)
begin
--Stone of Holy G2
UPDATE [Item] SET Info = [USER=2000041465]Total[/USER]Info + 1049088 WHERE IID = @iid
end

ELSE IF  [USER=523062]Prefix[/USER] = 157)
begin
--Stone of Flame G1
UPDATE [Item] SET Info = [USER=2000041465]Total[/USER]Info + 525312 WHERE IID = @iid
end

ELSE IF  [USER=523062]Prefix[/USER] = 158)
begin
--Stone of Flame G2
UPDATE [Item] SET Info = [USER=2000041465]Total[/USER]Info + 1049600 WHERE IID = @iid
end

ELSE IF  [USER=523062]Prefix[/USER] = 159)
begin
--Stone of Ice G1
UPDATE [Item] SET Info = [USER=2000041465]Total[/USER]Info + 526336 WHERE IID = @iid
end

ELSE IF  [USER=523062]Prefix[/USER] = 160)
begin
--Stone of Ice G2
UPDATE [Item] SET Info = [USER=2000041465]Total[/USER]Info + 1050624 WHERE IID = @iid
end

ELSE IF  [USER=523062]Prefix[/USER] = 161)
begin
--Stone of Lightning G1
UPDATE [Item] SET Info = [USER=2000041465]Total[/USER]Info + 528384 WHERE IID = @iid
end

ELSE IF  [USER=523062]Prefix[/USER] = 162)
begin
--Stone of Lightning G2
UPDATE [Item] SET Info = [USER=2000041465]Total[/USER]Info + 1052672 WHERE IID = @iid
end

ELSE IF  [USER=523062]Prefix[/USER] = 163)
begin
--Stone of Poison G1
UPDATE [Item] SET Info = [USER=2000041465]Total[/USER]Info + 532480 WHERE IID = @iid
end

ELSE IF  [USER=523062]Prefix[/USER] = 164)
begin
--Stone of Poison G2
UPDATE [Item] SET Info = [USER=2000041465]Total[/USER]Info + 1056768 WHERE IID = @iid
end

ELSE IF  [USER=523062]Prefix[/USER] = 165)
begin
--Stone of Para G1
UPDATE [Item] SET Info = [USER=2000041465]Total[/USER]Info + 540672 WHERE IID = @iid
end

ELSE IF  [USER=523062]Prefix[/USER] = 166)
begin
--Stone of Para G2
UPDATE [Item] SET Info = [USER=2000041465]Total[/USER]Info + 1064960 WHERE IID = @iid
end

ELSE IF  [USER=523062]Prefix[/USER] = 167)
begin
--Stone of Str G1
UPDATE [Item] SET Info = [USER=2000041465]Total[/USER]Info + 557056 WHERE IID = @iid
end

ELSE IF  [USER=523062]Prefix[/USER] = 168)
begin
--Stone of Str G2
UPDATE [Item] SET Info = [USER=2000041465]Total[/USER]Info + 1081344 WHERE IID = @iid
end

ELSE IF  [USER=523062]Prefix[/USER] = 169)
begin
--Stone of Skill G1
UPDATE [Item] SET Info = [USER=2000041465]Total[/USER]Info + 589824 WHERE IID = @iid
end

ELSE IF  [USER=523062]Prefix[/USER] = 170)
begin
--Stone of Skill G2
UPDATE [Item] SET Info = [USER=2000041465]Total[/USER]Info + 1114112 WHERE IID = @iid
end

ELSE IF  [USER=523062]Prefix[/USER] = 171)
begin
--Stone of Mistery G3
UPDATE [Item] SET Info = [USER=2000041465]Total[/USER]Info + 1179648 WHERE IID = @iid
end

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

ELSE IF  [USER=523062]Prefix[/USER] = 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  [USER=523062]Prefix[/USER] = 188)
begin
--5/1 Pride Armor GM
UPDATE [Item] SET XDefense = 5, XDodge = 1, Prefix = 85 WHERE IID = @iid
end

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

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

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

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

ELSE IF  [USER=523062]Prefix[/USER] = 193)
begin
--Test Item
UPDATE [Item] SET XDodge = 2 WHERE IID = @iid
end

ELSE IF  [USER=523062]Prefix[/USER] = 220)
begin
if(@bof_index > 1)
SET @bofindex1 = @bof_index
else
SET @bofindex1 = [USER=1333459381]Index[/USER]

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

ELSE IF  [USER=523062]Prefix[/USER] = 221)
begin
if(@bof_index > 1)
SET @bofindex1 = @bof_index
else
SET @bofindex1 = [USER=1333459381]Index[/USER]

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

ELSE IF  [USER=523062]Prefix[/USER] = 222)
begin
if(@bof_index > 1)
SET @bofindex1 = @bof_index
else
SET @bofindex1 = [USER=1333459381]Index[/USER]

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

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

Fixed it for u Men 1

 

[MaN11]

use code pls..
i cant see anythink here

 

[Doublingkal]

notice : i hexed db servt , but same .. -_-

 

[MaN11]

u added prefix to config.pk ->prefix.dat and server side-> prefix.txt ?
all looks to be fine here.. but maybe somethink is wrong with that repack that u use, try use other one and tell me if it work or no
if on other repack it will be the same that somethink is wrong with DBSvrT.exe

 

[Doublingkal]

Well , im using clean repack , so it shoud work
here is my dbservt hexed <

To view the content, you need to sign in or register