|
You last visited: Today at 16:02
Advertisement
About AutoEquipMenT
Discussion on About AutoEquipMenT within the SRO Private Server forum part of the Silkroad Online category.
06/08/2017, 17:46
|
#1
|
elite*gold: 0 
Join Date: May 2017
Posts: 6
Received Thanks: 0
|
About AutoEquipMenT
When I Make Weapon Sun in this tab ItemPoolAutoEquipment
not change anything & I'm working on  .
|
|
|
|
06/09/2017, 00:01
|
#2
|
elite*gold: 0
Join Date: Feb 2014
Posts: 885
Received Thanks: 1,415
|
Please provide us with your table and procedure to be able to find out where is the problem.
|
|
|
|
|
06/09/2017, 10:35
|
#3
|
elite*gold: 0
Join Date: May 2017
Posts: 6
Received Thanks: 0
|
Quote:
Originally Posted by Muhab Ashraf
Please provide us with your table and procedure to be able to find out where is the problem.
|
Trigger
PHP Code:
USE [SRO_VT_SHARD]
GO
/****** Object: Trigger [dbo].[TR_AUTOEQUIP_DEPIEDRA] Script Date: 03/26/2017 00:19:39 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TRIGGER [dbo].[TR_AUTOEQUIP_DEPIEDRA] ON [dbo].[_Char] AFTER UPDATE
AS
BEGIN
declare [MENTION=351728]new[/MENTION]lvl as tinyint = (select CurLevel from inserted)
declare @charID as int = (select CharID from inserted)
if [MENTION=351728]new[/MENTION]lvl between 13 and 99
begin
declare [MENTION=1326241]REF[/MENTION]CharID int
declare @charname varchar(64)
declare @charLevel tinyint
set [MENTION=1326241]REF[/MENTION]CharID = (select RefObjID from SRO_VT_SHARD.dbo._Char where CharID = @charID)
set @charname = (select CharName16 from SRO_VT_SHARD.dbo._Char where CharID = @charID)
set @charLevel = (select CurLevel from SRO_VT_SHARD.dbo._Char where CharID = @charID)
Declare [MENTION=1326241]REF[/MENTION]Mail INT = (Select ItemID From SRO_VT_SHARD.dbo._Inventory Where CharID=(Select CharID From SRO_VT_SHARD.dbo._Char Where CharID = @charID)
AND Slot ='1')
Declare [MENTION=1326241]REF[/MENTION]MailID INT = (Select RefItemID From SRO_VT_SHARD.dbo._Items Where ID64 = [MENTION=1326241]REF[/MENTION]Mail)
Declare [MENTION=1326241]REF[/MENTION]Weapon INT
Declare [MENTION=289336]weapon[/MENTION] INT = (Select ItemID From SRO_VT_SHARD.dbo._Inventory Where CharID=(Select CharID From SRO_VT_SHARD.dbo._Char Where CharID = @charID)
AND Slot ='6')
Declare [MENTION=1326241]REF[/MENTION]WeaponID INT = (Select RefItemID From SRO_VT_SHARD.dbo._Items Where ID64 = [MENTION=289336]weapon[/MENTION])
Declare [MENTION=289336]weapon[/MENTION]Type Tinyint = (Select Typeid4 from SRO_VT_SHARD.dbo._RefObjCommon where ID = [MENTION=1326241]REF[/MENTION]WeaponID)
Declare [MENTION=1830489]refs[/MENTION]hield INT
Declare [MENTION=662184]Shield[/MENTION] INT = (Select ItemID From SRO_VT_SHARD.dbo._Inventory Where CharID=(Select CharID From SRO_VT_SHARD.dbo._Char Where CharID = @charID)
AND Slot ='7')
Declare [MENTION=1830489]refs[/MENTION]hieldID INT = (Select RefItemID From SRO_VT_SHARD.dbo._Items Where ID64 = [MENTION=662184]Shield[/MENTION])
Declare [MENTION=662184]Shield[/MENTION]Type Tinyint = (Select Typeid4 from SRO_VT_SHARD.dbo._RefObjCommon where ID = [MENTION=1830489]refs[/MENTION]hieldID)
declare @mail_codename varchar(250)
declare @chr_gender varchar(250)
declare @item_level varchar(250)
declare @itemcodename varchar(250)
select @mail_codename = CodeName128 from SRO_VT_SHARD.dbo._RefObjCommon where ID = [MENTION=1326241]REF[/MENTION]MailID
declare @degree varchar(25)
Update SRO_VT_SHARD.dbo._Inventory set ItemID = 0 where CharID = @charID and Slot = 0
Update SRO_VT_SHARD.dbo._Inventory set ItemID = 0 where CharID = @charID and Slot = 1
Update SRO_VT_SHARD.dbo._Inventory set ItemID = 0 where CharID = @charID and Slot = 2
Update SRO_VT_SHARD.dbo._Inventory set ItemID = 0 where CharID = @charID and Slot = 3
Update SRO_VT_SHARD.dbo._Inventory set ItemID = 0 where CharID = @charID and Slot = 4
Update SRO_VT_SHARD.dbo._Inventory set ItemID = 0 where CharID = @charID and Slot = 5
Update SRO_VT_SHARD.dbo._Inventory set ItemID = 0 where CharID = @charID and Slot = 9
Update SRO_VT_SHARD.dbo._Inventory set ItemID = 0 where CharID = @charID and Slot = 10
Update SRO_VT_SHARD.dbo._Inventory set ItemID = 0 where CharID = @charID and Slot = 11
Update SRO_VT_SHARD.dbo._Inventory set ItemID = 0 where CharID = @charID and Slot = 12
if (Select ItemID From SRO_VT_SHARD.dbo._Inventory Where CharID=(Select CharID From SRO_VT_SHARD.dbo._Char Where CharID = @charID)
AND Slot ='6') != 0
begin
If ((Select TypeID4 from SRO_VT_SHARD.dbo._RefObjCommon where ID = (Select top 1 RefItemID from SRO_VT_SHARD.dbo._items where id64 = [MENTION=289336]weapon[/MENTION]))
= [MENTION=289336]weapon[/MENTION]Type ) -- Weapon
Begin
Set [MENTION=1326241]REF[/MENTION]Weapon = (Select top 1 ID from SRO_VT_SHARD.dbo._ItemPoolAutoEquipment where
Service = 1 AND
TypeID1=3 AND --- Weapon
TypeID2=1 AND
TypeID3=6 AND
TypeID4 [MENTION=289336]weapon[/MENTION]Type
Group by SRO_VT_SHARD.dbo._ItemPoolAutoEquipment.ID,SRO_VT_SHARD.dbo._ItemPoolAutoEquipment.reqlevel1
having (MAX(ReqLevel1)<= [MENTION=351728]new[/MENTION]lvl)
Order By ReqLevel1 Desc
)
Update SRO_VT_SHARD.dbo._Items set RefItemID= [MENTION=1326241]REF[/MENTION]Weapon where ID64= [MENTION=289336]weapon[/MENTION]
Update SRO_VT_SHARD.dbo._Items set OptLevel= 4,Variance= 34359738367,Data= 200, MagParamNum='2',MagParam1='30064771144',MagParam2= '30064771150' where ID64= [MENTION=289336]weapon[/MENTION]
END
end
if (Select ItemID From SRO_VT_SHARD.dbo._Inventory Where CharID=(Select CharID From SRO_VT_SHARD.dbo._Char Where CharID = @charID)
AND Slot ='7') != 0
begin
If ((Select ID from SRO_VT_SHARD.dbo._RefObjCommon where ID in (Select Refitemid from SRO_VT_SHARD.dbo._Items where ID64 = [MENTION=662184]Shield[/MENTION])) not in (62,3655))
Begin
Set [MENTION=1830489]refs[/MENTION]hield = (Select top 1 ID from SRO_VT_SHARD.dbo._ItemPoolAutoEquipment WITH (Nolock) where
Service = 1 AND
TypeID1=3 AND --- Shield
TypeID2=1 AND
TypeID3=4 AND
TypeID4 [MENTION=662184]Shield[/MENTION]Type
Group by SRO_VT_SHARD.dbo._ItemPoolAutoEquipment.ID,SRO_VT_SHARD.dbo._ItemPoolAutoEquipment.reqlevel1
having (MAX(ReqLevel1)<= [MENTION=351728]new[/MENTION]lvl)
Order By ReqLevel1 Desc
)
Update SRO_VT_SHARD.dbo._Items set RefItemID= [MENTION=1830489]refs[/MENTION]hield where ID64= [MENTION=662184]Shield[/MENTION]
Update SRO_VT_SHARD.dbo._Items set OptLevel= 4,Variance= 34359738367,Data= 200, MagParamNum='2',MagParam1='30064771144',MagParam2= '30064771150' where ID64= [MENTION=662184]Shield[/MENTION]
END
end
IF [MENTION=351728]new[/MENTION]lvl >= 90 and [MENTION=351728]new[/MENTION]lvl <= 99
BEGIN
set @item_level = '10' --DG
set @degree = '_C_RARE'
end
end
IF [MENTION=351728]new[/MENTION]lvl >= 85 and [MENTION=351728]new[/MENTION]lvl <= 89
BEGIN
set @item_level = '09' --DG
set @degree = '_C_RARE'
end
end
IF [MENTION=351728]new[/MENTION]lvl >= 81 and [MENTION=351728]new[/MENTION]lvl <= 84
BEGIN
set @item_level = '09' --DG
set @degree = '_C_RARE'
end
IF [MENTION=351728]new[/MENTION]lvl >= 77 and [MENTION=351728]new[/MENTION]lvl <= 80
BEGIN
set @item_level = '08' --DG
IF @item_level = '09'
begin
set @degree = '_C_RARE'
end
else if @item_level = '08'
begin
set @degree = '_C_RARE'
end
end
IF [MENTION=351728]new[/MENTION]lvl >= 73 and [MENTION=351728]new[/MENTION]lvl <= 76
BEGIN
set @item_level = '08' --DG
IF @item_level = '09'
begin
set @degree = '_C_RARE'
end
else if @item_level = '08'
begin
set @degree = '_C_RARE'
end
end
IF [MENTION=351728]new[/MENTION]lvl >= 69 and [MENTION=351728]new[/MENTION]lvl <= 72
BEGIN
set @item_level = '08' --DG
set @degree = '_C_RARE'
end
IF [MENTION=351728]new[/MENTION]lvl >= 65 and [MENTION=351728]new[/MENTION]lvl <= 68
BEGIN
set @item_level = '07' --DG
IF @item_level = '08'
begin
set @degree = '_C_RARE'
end
else if @item_level = '07'
begin
set @degree = '_C_RARE'
end
end
IF [MENTION=351728]new[/MENTION]lvl >= 61 and [MENTION=351728]new[/MENTION]lvl <= 64
BEGIN
set @item_level = '07' --DG
IF @item_level = '08'
begin
set @degree = '_C_RARE'
end
else if @item_level = '07'
begin
set @degree = '_C_RARE'
end
end
IF [MENTION=351728]new[/MENTION]lvl >= 57 and [MENTION=351728]new[/MENTION]lvl <= 60
BEGIN
set @item_level = '07' --DG
set @degree = '_C_RARE'
end
IF [MENTION=351728]new[/MENTION]lvl >= 53 and [MENTION=351728]new[/MENTION]lvl <= 56
BEGIN
set @item_level = '06' --DG
IF @item_level = '07'
begin
set @degree = '_C_RARE'
end
else if @item_level = '06'
begin
set @degree = '_C_RARE'
end
end
IF [MENTION=351728]new[/MENTION]lvl >= 50 and [MENTION=351728]new[/MENTION]lvl <= 52
BEGIN
set @item_level = '06' --DG
IF @item_level = '07'
begin
set @degree = '_C_RARE'
end
else if @item_level = '06'
begin
set @degree = '_C_RARE'
end
end
IF [MENTION=351728]new[/MENTION]lvl >= 47 and [MENTION=351728]new[/MENTION]lvl <= 49
BEGIN
set @item_level = '06' --DG
set @degree = '_C_RARE'
end
IF [MENTION=351728]new[/MENTION]lvl >= 43 and [MENTION=351728]new[/MENTION]lvl <= 46
BEGIN
set @item_level = '05' --DG
IF @item_level = '06'
begin
set @degree = '_C_RARE'
end
else if @item_level = '05'
begin
set @degree = '_C_RARE'
end
end
IF [MENTION=351728]new[/MENTION]lvl >= 40 and [MENTION=351728]new[/MENTION]lvl <= 42
BEGIN
set @item_level = '05' --DG
IF @item_level = '06'
begin
set @degree = '_C_RARE'
end
else if @item_level = '05'
begin
set @degree = '_C_RARE'
end
end
IF [MENTION=351728]new[/MENTION]lvl >= 37 and [MENTION=351728]new[/MENTION]lvl <= 39
BEGIN
set @item_level = '05' --DG
set @degree = '_C_RARE'
end
IF [MENTION=351728]new[/MENTION]lvl >= 34 and [MENTION=351728]new[/MENTION]lvl <= 36
BEGIN
set @item_level = '04' --DG
IF @item_level = '05'
begin
set @degree = '_C_RARE'
end
else if @item_level = '05'
begin
set @degree = '_C_RARE'
end
end
IF [MENTION=351728]new[/MENTION]lvl >= 31 and [MENTION=351728]new[/MENTION]lvl <= 33
BEGIN
set @item_level = '04' --DG
IF @item_level = '05'
begin
set @degree = '_C_RARE'
end
else if @item_level = '04'
begin
set @degree = '_C_RARE'
end
end
IF [MENTION=351728]new[/MENTION]lvl >= 29 and [MENTION=351728]new[/MENTION]lvl <= 30
BEGIN
set @item_level = '04' --DG
set @degree = '_C_RARE'
end
IF [MENTION=351728]new[/MENTION]lvl >= 26 and [MENTION=351728]new[/MENTION]lvl <= 28
BEGIN
set @item_level = '03' --DG
IF @item_level = '04'
begin
set @degree = '_C_RARE'
end
else if @item_level = '03'
begin
set @degree = '_C_RARE'
end
end
IF [MENTION=351728]new[/MENTION]lvl >= 23 and [MENTION=351728]new[/MENTION]lvl <= 25
BEGIN
set @item_level = '03' --DG
IF @item_level = '04'
begin
set @degree = '_C_RARE'
end
else if @item_level = '03'
begin
set @degree = '_C_RARE'
end
end
IF [MENTION=351728]new[/MENTION]lvl = 21 or [MENTION=351728]new[/MENTION]lvl = 22
BEGIN
set @item_level = '03' --DG
set @degree = '_C_RARE'
end
IF [MENTION=351728]new[/MENTION]lvl >= 18 and [MENTION=351728]new[/MENTION]lvl <= 20
BEGIN
set @item_level = '02' --DG
IF @item_level = '03'
begin
set @degree = '_C_RARE'
end
else if @item_level = '02'
begin
set @degree = '_C_RARE'
end
end
IF [MENTION=351728]new[/MENTION]lvl >= 15 and [MENTION=351728]new[/MENTION]lvl <= 17
BEGIN
set @item_level = '02' --DG
IF @item_level = '03'
begin
set @degree = '_C_RARE'
end
else if @item_level = '02'
begin
set @degree = '_C_RARE'
end
end
IF [MENTION=351728]new[/MENTION]lvl >= 13 and [MENTION=351728]new[/MENTION]lvl <= 14
BEGIN
set @item_level = '02' --DG
set @degree = '_C_RARE'
end
if [MENTION=1326241]REF[/MENTION]CharID between 1907 and 1919 or [MENTION=1326241]REF[/MENTION]CharID between 14875 and 14887
begin
set @chr_gender = 'M' --male
end
if [MENTION=1326241]REF[/MENTION]CharID between 1920 and 1932 or [MENTION=1326241]REF[/MENTION]CharID between 14888 and 14900
begin
set @chr_gender = 'W' --female
end
if [MENTION=1326241]REF[/MENTION]CharID between 1907 and 1919 or [MENTION=1326241]REF[/MENTION]CharID between 1920 and 1932
begin
set @itemcodename = 'ITEM_CH_RING_' + @item_level + @degree + '_C_RARE'
EXEC SRO_VT_SHARD.dbo._FN_ADD_INITIAL_EQUIP_DEPI @charname,11,@itemcodename,200
EXEC SRO_VT_SHARD.dbo._FN_ADD_INITIAL_EQUIP_DEPI @charname,12,@itemcodename,200
set @itemcodename = 'ITEM_CH_EARRING_' + @item_level + @degree + '_C_RARE'
EXEC SRO_VT_SHARD.dbo._FN_ADD_INITIAL_EQUIP_DEPI @charname,9,@itemcodename,200
set @itemcodename = 'ITEM_CH_NECKLACE_' + @item_level + @degree + '_C_RARE'
EXEC SRO_VT_SHARD.dbo._FN_ADD_INITIAL_EQUIP_DEPI @charname,10,@itemcodename,200
end
if [MENTION=1326241]REF[/MENTION]CharID between 14875 and 14887 or [MENTION=1326241]REF[/MENTION]CharID between 14888 and 14900
begin
set @itemcodename = 'ITEM_EU_RING_' + @item_level + @degree + '_C_RARE'
EXEC SRO_VT_SHARD.dbo._FN_ADD_INITIAL_EQUIP_DEPI @charname,11,@itemcodename,200
EXEC SRO_VT_SHARD.dbo._FN_ADD_INITIAL_EQUIP_DEPI @charname,12,@itemcodename,200
set @itemcodename = 'ITEM_EU_EARRING_' + @item_level + @degree + '_C_RARE'
EXEC SRO_VT_SHARD.dbo._FN_ADD_INITIAL_EQUIP_DEPI @charname,9,@itemcodename,200
set @itemcodename = 'ITEM_EU_NECKLACE_' + @item_level + @degree + '_C_RARE'
EXEC SRO_VT_SHARD.dbo._FN_ADD_INITIAL_EQUIP_DEPI @charname,10,@itemcodename,200
end
--//ARMOR\\--
if @mail_codename like 'ITEM_CH_%_LIGHT%'
begin
set @itemcodename = 'ITEM_CH_' + @chr_gender + '_LIGHT_' + @item_level + '_HA' + @degree
EXEC SRO_VT_SHARD.dbo._FN_ADD_INITIAL_EQUIP_DEPI @charname,0,@itemcodename,200
set @itemcodename = 'ITEM_CH_' + @chr_gender + '_LIGHT_' + @item_level + '_SA' + @degree
EXEC SRO_VT_SHARD.dbo._FN_ADD_INITIAL_EQUIP_DEPI @charname,2,@itemcodename,200
set @itemcodename = 'ITEM_CH_' + @chr_gender + '_LIGHT_' + @item_level + '_BA' + @degree
EXEC SRO_VT_SHARD.dbo._FN_ADD_INITIAL_EQUIP_DEPI @charname,1,@itemcodename,200
set @itemcodename = 'ITEM_CH_' + @chr_gender + '_LIGHT_' + @item_level + '_LA' + @degree
EXEC SRO_VT_SHARD.dbo._FN_ADD_INITIAL_EQUIP_DEPI @charname,4,@itemcodename,200
set @itemcodename = 'ITEM_CH_' + @chr_gender + '_LIGHT_' + @item_level + '_AA' + @degree
EXEC SRO_VT_SHARD.dbo._FN_ADD_INITIAL_EQUIP_DEPI @charname,3,@itemcodename,200
set @itemcodename = 'ITEM_CH_' + @chr_gender + '_LIGHT_' + @item_level + '_FA' + @degree
EXEC SRO_VT_SHARD.dbo._FN_ADD_INITIAL_EQUIP_DEPI @charname,5,@itemcodename,200
end
else if @mail_codename like 'ITEM_CH_%_HEAVY%'
begin
set @itemcodename = 'ITEM_CH_' + @chr_gender + '_HEAVY_' + @item_level + '_HA' + @degree
EXEC SRO_VT_SHARD.dbo._FN_ADD_INITIAL_EQUIP_DEPI @charname,0,@itemcodename,200
set @itemcodename = 'ITEM_CH_' + @chr_gender + '_HEAVY_' + @item_level + '_SA' + @degree
EXEC SRO_VT_SHARD.dbo._FN_ADD_INITIAL_EQUIP_DEPI @charname,2,@itemcodename,200
set @itemcodename = 'ITEM_CH_' + @chr_gender + '_HEAVY_' + @item_level + '_BA' + @degree
EXEC SRO_VT_SHARD.dbo._FN_ADD_INITIAL_EQUIP_DEPI @charname,1,@itemcodename,200
set @itemcodename = 'ITEM_CH_' + @chr_gender + '_HEAVY_' + @item_level + '_LA' + @degree
EXEC SRO_VT_SHARD.dbo._FN_ADD_INITIAL_EQUIP_DEPI @charname,4,@itemcodename,200
set @itemcodename = 'ITEM_CH_' + @chr_gender + '_HEAVY_' + @item_level + '_AA' + @degree
EXEC SRO_VT_SHARD.dbo._FN_ADD_INITIAL_EQUIP_DEPI @charname,3,@itemcodename,200
set @itemcodename = 'ITEM_CH_' + @chr_gender + '_HEAVY_' + @item_level + '_FA' + @degree
EXEC SRO_VT_SHARD.dbo._FN_ADD_INITIAL_EQUIP_DEPI @charname,5,@itemcodename,200
end
else if @mail_codename like 'ITEM_CH_%_CLOTHES%'
begin
set @itemcodename = 'ITEM_CH_' + @chr_gender + '_CLOTHES_' + @item_level + '_HA' + @degree
EXEC SRO_VT_SHARD.dbo._FN_ADD_INITIAL_EQUIP_DEPI @charname,0,@itemcodename,200
set @itemcodename = 'ITEM_CH_' + @chr_gender + '_CLOTHES_' + @item_level + '_SA' + @degree
EXEC SRO_VT_SHARD.dbo._FN_ADD_INITIAL_EQUIP_DEPI @charname,2,@itemcodename,200
set @itemcodename = 'ITEM_CH_' + @chr_gender + '_CLOTHES_' + @item_level + '_BA' + @degree
EXEC SRO_VT_SHARD.dbo._FN_ADD_INITIAL_EQUIP_DEPI @charname,1,@itemcodename,200
set @itemcodename = 'ITEM_CH_' + @chr_gender + '_CLOTHES_' + @item_level + '_LA' + @degree
EXEC SRO_VT_SHARD.dbo._FN_ADD_INITIAL_EQUIP_DEPI @charname,4,@itemcodename,200
set @itemcodename = 'ITEM_CH_' + @chr_gender + '_CLOTHES_' + @item_level + '_AA' + @degree
EXEC SRO_VT_SHARD.dbo._FN_ADD_INITIAL_EQUIP_DEPI @charname,3,@itemcodename,200
set @itemcodename = 'ITEM_CH_' + @chr_gender + '_CLOTHES_' + @item_level + '_FA' + @degree
EXEC SRO_VT_SHARD.dbo._FN_ADD_INITIAL_EQUIP_DEPI @charname,5,@itemcodename,200
end
else if @mail_codename like 'ITEM_EU_%_LIGHT%'
begin
set @itemcodename = 'ITEM_EU_' + @chr_gender + '_LIGHT_' + @item_level + '_HA' + @degree
EXEC SRO_VT_SHARD.dbo._FN_ADD_INITIAL_EQUIP_DEPI @charname,0,@itemcodename,200
set @itemcodename = 'ITEM_EU_' + @chr_gender + '_LIGHT_' + @item_level + '_SA' + @degree
EXEC SRO_VT_SHARD.dbo._FN_ADD_INITIAL_EQUIP_DEPI @charname,2,@itemcodename,200
set @itemcodename = 'ITEM_EU_' + @chr_gender + '_LIGHT_' + @item_level + '_BA' + @degree
EXEC SRO_VT_SHARD.dbo._FN_ADD_INITIAL_EQUIP_DEPI @charname,1,@itemcodename,200
set @itemcodename = 'ITEM_EU_' + @chr_gender + '_LIGHT_' + @item_level + '_LA' + @degree
EXEC SRO_VT_SHARD.dbo._FN_ADD_INITIAL_EQUIP_DEPI @charname,4,@itemcodename,200
set @itemcodename = 'ITEM_EU_' + @chr_gender + '_LIGHT_' + @item_level + '_AA' + @degree
EXEC SRO_VT_SHARD.dbo._FN_ADD_INITIAL_EQUIP_DEPI @charname,3,@itemcodename,200
set @itemcodename = 'ITEM_EU_' + @chr_gender + '_LIGHT_' + @item_level + '_FA' + @degree
EXEC SRO_VT_SHARD.dbo._FN_ADD_INITIAL_EQUIP_DEPI @charname,5,@itemcodename,200
end
else if @mail_codename like 'ITEM_EU_%_HEAVY%'
begin
set @itemcodename = 'ITEM_EU_' + @chr_gender + '_HEAVY_' + @item_level + '_HA' + @degree
EXEC SRO_VT_SHARD.dbo._FN_ADD_INITIAL_EQUIP_DEPI @charname,0,@itemcodename,200
set @itemcodename = 'ITEM_EU_' + @chr_gender + '_HEAVY_' + @item_level + '_SA' + @degree
EXEC SRO_VT_SHARD.dbo._FN_ADD_INITIAL_EQUIP_DEPI @charname,2,@itemcodename,200
set @itemcodename = 'ITEM_EU_' + @chr_gender + '_HEAVY_' + @item_level + '_BA' + @degree
EXEC SRO_VT_SHARD.dbo._FN_ADD_INITIAL_EQUIP_DEPI @charname,1,@itemcodename,200
set @itemcodename = 'ITEM_EU_' + @chr_gender + '_HEAVY_' + @item_level + '_LA' + @degree
EXEC SRO_VT_SHARD.dbo._FN_ADD_INITIAL_EQUIP_DEPI @charname,4,@itemcodename,200
set @itemcodename = 'ITEM_EU_' + @chr_gender + '_HEAVY_' + @item_level + '_AA' + @degree
EXEC SRO_VT_SHARD.dbo._FN_ADD_INITIAL_EQUIP_DEPI @charname,3,@itemcodename,200
set @itemcodename = 'ITEM_EU_' + @chr_gender + '_HEAVY_' + @item_level + '_FA' + @degree
EXEC SRO_VT_SHARD.dbo._FN_ADD_INITIAL_EQUIP_DEPI @charname,5,@itemcodename,200
end
else if @mail_codename like 'ITEM_EU_%_CLOTHES%'
begin
set @itemcodename = 'ITEM_EU_' + @chr_gender + '_CLOTHES_' + @item_level + '_HA' + @degree
EXEC SRO_VT_SHARD.dbo._FN_ADD_INITIAL_EQUIP_DEPI @charname,0,@itemcodename,200
set @itemcodename = 'ITEM_EU_' + @chr_gender + '_CLOTHES_' + @item_level + '_SA' + @degree
EXEC SRO_VT_SHARD.dbo._FN_ADD_INITIAL_EQUIP_DEPI @charname,2,@itemcodename,200
set @itemcodename = 'ITEM_EU_' + @chr_gender + '_CLOTHES_' + @item_level + '_BA' + @degree
EXEC SRO_VT_SHARD.dbo._FN_ADD_INITIAL_EQUIP_DEPI @charname,1,@itemcodename,200
set @itemcodename = 'ITEM_EU_' + @chr_gender + '_CLOTHES_' + @item_level + '_LA' + @degree
EXEC SRO_VT_SHARD.dbo._FN_ADD_INITIAL_EQUIP_DEPI @charname,4,@itemcodename,200
set @itemcodename = 'ITEM_EU_' + @chr_gender + '_CLOTHES_' + @item_level + '_AA' + @degree
EXEC SRO_VT_SHARD.dbo._FN_ADD_INITIAL_EQUIP_DEPI @charname,3,@itemcodename,200
set @itemcodename = 'ITEM_EU_' + @chr_gender + '_CLOTHES_' + @item_level + '_FA' + @degree
EXEC SRO_VT_SHARD.dbo._FN_ADD_INITIAL_EQUIP_DEPI @charname,5,@itemcodename,200
end
_ItemPoolAutoEquipment
PHP Code:
1 76 ITEM_CH_SWORD_02_C_RARE 3 1 6 2 0 0 1 13 -1 0 -1 0 -1 0
1 79 ITEM_CH_SWORD_03_C_RARE 3 1 6 2 0 0 1 21 -1 0 -1 0 -1 0
1 82 ITEM_CH_SWORD_04_C_RARE 3 1 6 2 0 0 1 29 -1 0 -1 0 -1 0
1 85 ITEM_CH_SWORD_05_C_RARE 3 1 6 2 0 0 1 38 -1 0 -1 0 -1 0
1 88 ITEM_CH_SWORD_06_C_RARE 3 1 6 2 0 0 1 48 -1 0 -1 0 -1 0
1 91 ITEM_CH_SWORD_07_C_RARE 3 1 6 2 0 0 1 60 -1 0 -1 0 -1 0
1 94 ITEM_CH_SWORD_08_C_RARE 3 1 6 2 0 0 1 72 -1 0 -1 0 -1 0
1 97 ITEM_CH_SWORD_09_C_RARE 3 1 6 2 0 0 1 85 -1 0 -1 0 -1 0
1 112 ITEM_CH_BLADE_02_C_RARE 3 1 6 3 0 0 1 13 -1 0 -1 0 -1 0
1 115 ITEM_CH_BLADE_03_C_RARE 3 1 6 3 0 0 1 21 -1 0 -1 0 -1 0
1 118 ITEM_CH_BLADE_04_C_RARE 3 1 6 3 0 0 1 29 -1 0 -1 0 -1 0
1 121 ITEM_CH_BLADE_05_C_RARE 3 1 6 3 0 0 1 38 -1 0 -1 0 -1 0
1 124 ITEM_CH_BLADE_06_C_RARE 3 1 6 3 0 0 1 48 -1 0 -1 0 -1 0
1 127 ITEM_CH_BLADE_07_C_RARE 3 1 6 3 0 0 1 60 -1 0 -1 0 -1 0
1 130 ITEM_CH_BLADE_08_C_RARE 3 1 6 3 0 0 1 72 -1 0 -1 0 -1 0
1 133 ITEM_CH_BLADE_09_C_RARE 3 1 6 3 0 0 1 85 -1 0 -1 0 -1 0
1 148 ITEM_CH_SPEAR_02_C_RARE 3 1 6 4 0 0 1 13 -1 0 -1 0 -1 0
1 151 ITEM_CH_SPEAR_03_C_RARE 3 1 6 4 0 0 1 21 -1 0 -1 0 -1 0
1 154 ITEM_CH_SPEAR_04_C_RARE 3 1 6 4 0 0 1 29 -1 0 -1 0 -1 0
1 157 ITEM_CH_SPEAR_05_C_RARE 3 1 6 4 0 0 1 38 -1 0 -1 0 -1 0
1 160 ITEM_CH_SPEAR_06_C_RARE 3 1 6 4 0 0 1 48 -1 0 -1 0 -1 0
1 163 ITEM_CH_SPEAR_07_C_RARE 3 1 6 4 0 0 1 60 -1 0 -1 0 -1 0
1 166 ITEM_CH_SPEAR_08_C_RARE 3 1 6 4 0 0 1 72 -1 0 -1 0 -1 0
1 169 ITEM_CH_SPEAR_09_C_RARE 3 1 6 4 0 0 1 85 -1 0 -1 0 -1 0
1 184 ITEM_CH_TBLADE_02_C_RARE 3 1 6 5 0 0 1 13 -1 0 -1 0 -1 0
1 187 ITEM_CH_TBLADE_03_C_RARE 3 1 6 5 0 0 1 21 -1 0 -1 0 -1 0
1 190 ITEM_CH_TBLADE_04_C_RARE 3 1 6 5 0 0 1 29 -1 0 -1 0 -1 0
1 193 ITEM_CH_TBLADE_05_C_RARE 3 1 6 5 0 0 1 38 -1 0 -1 0 -1 0
1 196 ITEM_CH_TBLADE_06_C_RARE 3 1 6 5 0 0 1 48 -1 0 -1 0 -1 0
1 199 ITEM_CH_TBLADE_07_C_RARE 3 1 6 5 0 0 1 60 -1 0 -1 0 -1 0
1 202 ITEM_CH_TBLADE_08_C_RARE 3 1 6 5 0 0 1 72 -1 0 -1 0 -1 0
1 205 ITEM_CH_TBLADE_09_C_RARE 3 1 6 5 0 0 1 85 -1 0 -1 0 -1 0
1 220 ITEM_CH_BOW_02_C_RARE 3 1 6 6 0 0 1 13 -1 0 -1 0 -1 0
1 223 ITEM_CH_BOW_03_C_RARE 3 1 6 6 0 0 1 21 -1 0 -1 0 -1 0
1 226 ITEM_CH_BOW_04_C_RARE 3 1 6 6 0 0 1 29 -1 0 -1 0 -1 0
1 229 ITEM_CH_BOW_05_C_RARE 3 1 6 6 0 0 1 38 -1 0 -1 0 -1 0
1 232 ITEM_CH_BOW_06_C_RARE 3 1 6 6 0 0 1 48 -1 0 -1 0 -1 0
1 235 ITEM_CH_BOW_07_C_RARE 3 1 6 6 0 0 1 60 -1 0 -1 0 -1 0
1 238 ITEM_CH_BOW_08_C_RARE 3 1 6 6 0 0 1 72 -1 0 -1 0 -1 0
1 241 ITEM_CH_BOW_09_C_RARE 3 1 6 6 0 0 1 85 -1 0 -1 0 -1 0
1 256 ITEM_CH_SHIELD_02_C_RARE 3 1 4 1 0 0 1 13 -1 0 -1 0 -1 0
1 259 ITEM_CH_SHIELD_03_C_RARE 3 1 4 1 0 0 1 21 -1 0 -1 0 -1 0
1 262 ITEM_CH_SHIELD_04_C_RARE 3 1 4 1 0 0 1 29 -1 0 -1 0 -1 0
1 265 ITEM_CH_SHIELD_05_C_RARE 3 1 4 1 0 0 1 38 -1 0 -1 0 -1 0
1 268 ITEM_CH_SHIELD_06_C_RARE 3 1 4 1 0 0 1 48 -1 0 -1 0 -1 0
1 271 ITEM_CH_SHIELD_07_C_RARE 3 1 4 1 0 0 1 60 -1 0 -1 0 -1 0
1 274 ITEM_CH_SHIELD_08_C_RARE 3 1 4 1 0 0 1 72 -1 0 -1 0 -1 0
1 277 ITEM_CH_SHIELD_09_C_RARE 3 1 4 1 0 0 1 85 -1 0 -1 0 -1 0
1 10902 ITEM_EU_DAGGER_02_C_RARE 3 1 6 13 1 0 1 13 -1 0 -1 0 -1 0
1 10905 ITEM_EU_DAGGER_03_C_RARE 3 1 6 13 1 0 1 21 -1 0 -1 0 -1 0
1 10908 ITEM_EU_DAGGER_04_C_RARE 3 1 6 13 1 0 1 29 -1 0 -1 0 -1 0
1 10911 ITEM_EU_DAGGER_05_C_RARE 3 1 6 13 1 0 1 38 -1 0 -1 0 -1 0
1 10914 ITEM_EU_DAGGER_06_C_RARE 3 1 6 13 1 0 1 48 -1 0 -1 0 -1 0
1 10917 ITEM_EU_DAGGER_07_C_RARE 3 1 6 13 1 0 1 60 -1 0 -1 0 -1 0
1 10920 ITEM_EU_DAGGER_08_C_RARE 3 1 6 13 1 0 1 72 -1 0 -1 0 -1 0
1 10923 ITEM_EU_DAGGER_09_C_RARE 3 1 6 13 1 0 1 85 -1 0 -1 0 -1 0
1 10938 ITEM_EU_SWORD_02_C_RARE 3 1 6 7 1 0 1 13 -1 0 -1 0 -1 0
1 10941 ITEM_EU_SWORD_03_C_RARE 3 1 6 7 1 0 1 21 -1 0 -1 0 -1 0
1 10944 ITEM_EU_SWORD_04_C_RARE 3 1 6 7 1 0 1 29 -1 0 -1 0 -1 0
1 10947 ITEM_EU_SWORD_05_C_RARE 3 1 6 7 1 0 1 38 -1 0 -1 0 -1 0
1 10950 ITEM_EU_SWORD_06_C_RARE 3 1 6 7 1 0 1 48 -1 0 -1 0 -1 0
1 10953 ITEM_EU_SWORD_07_C_RARE 3 1 6 7 1 0 1 60 -1 0 -1 0 -1 0
1 10956 ITEM_EU_SWORD_08_C_RARE 3 1 6 7 1 0 1 72 -1 0 -1 0 -1 0
1 10959 ITEM_EU_SWORD_09_C_RARE 3 1 6 7 1 0 1 85 -1 0 -1 0 -1 0
1 10974 ITEM_EU_TSWORD_02_C_RARE 3 1 6 8 1 0 1 13 -1 0 -1 0 -1 0
1 10977 ITEM_EU_TSWORD_03_C_RARE 3 1 6 8 1 0 1 21 -1 0 -1 0 -1 0
1 10980 ITEM_EU_TSWORD_04_C_RARE 3 1 6 8 1 0 1 29 -1 0 -1 0 -1 0
1 10983 ITEM_EU_TSWORD_05_C_RARE 3 1 6 8 1 0 1 38 -1 0 -1 0 -1 0
1 10986 ITEM_EU_TSWORD_06_C_RARE 3 1 6 8 1 0 1 48 -1 0 -1 0 -1 0
1 10989 ITEM_EU_TSWORD_07_C_RARE 3 1 6 8 1 0 1 60 -1 0 -1 0 -1 0
1 10992 ITEM_EU_TSWORD_08_C_RARE 3 1 6 8 1 0 1 72 -1 0 -1 0 -1 0
1 10995 ITEM_EU_TSWORD_09_C_RARE 3 1 6 8 1 0 1 85 -1 0 -1 0 -1 0
1 11010 ITEM_EU_AXE_02_C_RARE 3 1 6 9 1 0 1 13 -1 0 -1 0 -1 0
1 11013 ITEM_EU_AXE_03_C_RARE 3 1 6 9 1 0 1 21 -1 0 -1 0 -1 0
1 11016 ITEM_EU_AXE_04_C_RARE 3 1 6 9 1 0 1 29 -1 0 -1 0 -1 0
1 11019 ITEM_EU_AXE_05_C_RARE 3 1 6 9 1 0 1 38 -1 0 -1 0 -1 0
1 11022 ITEM_EU_AXE_06_C_RARE 3 1 6 9 1 0 1 48 -1 0 -1 0 -1 0
1 11025 ITEM_EU_AXE_07_C_RARE 3 1 6 9 1 0 1 60 -1 0 -1 0 -1 0
1 11028 ITEM_EU_AXE_08_C_RARE 3 1 6 9 1 0 1 72 -1 0 -1 0 -1 0
1 11031 ITEM_EU_AXE_09_C_RARE 3 1 6 9 1 0 1 85 -1 0 -1 0 -1 0
1 11046 ITEM_EU_CROSSBOW_02_C_RARE 3 1 6 12 1 0 1 13 -1 0 -1 0 -1 0
1 11049 ITEM_EU_CROSSBOW_03_C_RARE 3 1 6 12 1 0 1 21 -1 0 -1 0 -1 0
1 11052 ITEM_EU_CROSSBOW_04_C_RARE 3 1 6 12 1 0 1 29 -1 0 -1 0 -1 0
1 11055 ITEM_EU_CROSSBOW_05_C_RARE 3 1 6 12 1 0 1 38 -1 0 -1 0 -1 0
1 11058 ITEM_EU_CROSSBOW_06_C_RARE 3 1 6 12 1 0 1 48 -1 0 -1 0 -1 0
1 11061 ITEM_EU_CROSSBOW_07_C_RARE 3 1 6 12 1 0 1 60 -1 0 -1 0 -1 0
1 11064 ITEM_EU_CROSSBOW_08_C_RARE 3 1 6 12 1 0 1 72 -1 0 -1 0 -1 0
1 11067 ITEM_EU_CROSSBOW_09_C_RARE 3 1 6 12 1 0 1 85 -1 0 -1 0 -1 0
1 11082 ITEM_EU_DARKSTAFF_02_C_RARE 3 1 6 10 1 0 1 13 -1 0 -1 0 -1 0
1 11085 ITEM_EU_DARKSTAFF_03_C_RARE 3 1 6 10 1 0 1 21 -1 0 -1 0 -1 0
1 11088 ITEM_EU_DARKSTAFF_04_C_RARE 3 1 6 10 1 0 1 29 -1 0 -1 0 -1 0
1 11091 ITEM_EU_DARKSTAFF_05_C_RARE 3 1 6 10 1 0 1 38 -1 0 -1 0 -1 0
1 11094 ITEM_EU_DARKSTAFF_06_C_RARE 3 1 6 10 1 0 1 48 -1 0 -1 0 -1 0
1 11097 ITEM_EU_DARKSTAFF_07_C_RARE 3 1 6 10 1 0 1 60 -1 0 -1 0 -1 0
1 11100 ITEM_EU_DARKSTAFF_08_C_RARE 3 1 6 10 1 0 1 72 -1 0 -1 0 -1 0
1 11103 ITEM_EU_DARKSTAFF_09_C_RARE 3 1 6 10 1 0 1 85 -1 0 -1 0 -1 0
1 11118 ITEM_EU_TSTAFF_02_C_RARE 3 1 6 11 1 0 1 13 -1 0 -1 0 -1 0
1 11121 ITEM_EU_TSTAFF_03_C_RARE 3 1 6 11 1 0 1 21 -1 0 -1 0 -1 0
1 11124 ITEM_EU_TSTAFF_04_C_RARE 3 1 6 11 1 0 1 29 -1 0 -1 0 -1 0
1 11127 ITEM_EU_TSTAFF_05_C_RARE 3 1 6 11 1 0 1 38 -1 0 -1 0 -1 0
1 11130 ITEM_EU_TSTAFF_06_C_RARE 3 1 6 11 1 0 1 48 -1 0 -1 0 -1 0
1 11133 ITEM_EU_TSTAFF_07_C_RARE 3 1 6 11 1 0 1 60 -1 0 -1 0 -1 0
1 11136 ITEM_EU_TSTAFF_08_C_RARE 3 1 6 11 1 0 1 72 -1 0 -1 0 -1 0
1 11139 ITEM_EU_TSTAFF_09_C_RARE 3 1 6 11 1 0 1 85 -1 0 -1 0 -1 0
1 11154 ITEM_EU_HARP_02_C_RARE 3 1 6 14 1 0 1 13 -1 0 -1 0 -1 0
1 11157 ITEM_EU_HARP_03_C_RARE 3 1 6 14 1 0 1 21 -1 0 -1 0 -1 0
1 11160 ITEM_EU_HARP_04_C_RARE 3 1 6 14 1 0 1 29 -1 0 -1 0 -1 0
1 11163 ITEM_EU_HARP_05_C_RARE 3 1 6 14 1 0 1 38 -1 0 -1 0 -1 0
1 11166 ITEM_EU_HARP_06_C_RARE 3 1 6 14 1 0 1 48 -1 0 -1 0 -1 0
1 11169 ITEM_EU_HARP_07_C_RARE 3 1 6 14 1 0 1 60 -1 0 -1 0 -1 0
1 11172 ITEM_EU_HARP_08_C_RARE 3 1 6 14 1 0 1 72 -1 0 -1 0 -1 0
1 11175 ITEM_EU_HARP_09_C_RARE 3 1 6 14 1 0 1 85 -1 0 -1 0 -1 0
1 11190 ITEM_EU_STAFF_02_C_RARE 3 1 6 15 1 0 1 13 -1 0 -1 0 -1 0
1 11193 ITEM_EU_STAFF_03_C_RARE 3 1 6 15 1 0 1 21 -1 0 -1 0 -1 0
1 11196 ITEM_EU_STAFF_04_C_RARE 3 1 6 15 1 0 1 29 -1 0 -1 0 -1 0
1 11199 ITEM_EU_STAFF_05_C_RARE 3 1 6 15 1 0 1 38 -1 0 -1 0 -1 0
1 11202 ITEM_EU_STAFF_06_C_RARE 3 1 6 15 1 0 1 48 -1 0 -1 0 -1 0
1 11205 ITEM_EU_STAFF_07_C_RARE 3 1 6 15 1 0 1 60 -1 0 -1 0 -1 0
1 11208 ITEM_EU_STAFF_08_C_RARE 3 1 6 15 1 0 1 72 -1 0 -1 0 -1 0
1 11211 ITEM_EU_STAFF_09_C_RARE 3 1 6 15 1 0 1 85 -1 0 -1 0 -1 0
1 11550 ITEM_EU_SHIELD_02_C_RARE 3 1 4 2 1 0 1 13 -1 0 -1 0 -1 0
1 11553 ITEM_EU_SHIELD_03_C_RARE 3 1 4 2 1 0 1 21 -1 0 -1 0 -1 0
1 11556 ITEM_EU_SHIELD_04_C_RARE 3 1 4 2 1 0 1 29 -1 0 -1 0 -1 0
1 11559 ITEM_EU_SHIELD_05_C_RARE 3 1 4 2 1 0 1 38 -1 0 -1 0 -1 0
1 11562 ITEM_EU_SHIELD_06_C_RARE 3 1 4 2 1 0 1 48 -1 0 -1 0 -1 0
1 11565 ITEM_EU_SHIELD_07_C_RARE 3 1 4 2 1 0 1 60 -1 0 -1 0 -1 0
1 11568 ITEM_EU_SHIELD_08_C_RARE 3 1 4 2 1 0 1 72 -1 0 -1 0 -1 0
1 11571 ITEM_EU_SHIELD_09_C_RARE 3 1 4 2 1 0 1 85 -1 0 -1 0 -1 0
|
|
|
|
 |
Similar Threads
|
{Update}RelicSro►Cap 110►mid rates►AutoEquipment D1~D11►Silk Per Hour&&&New Uniques
11/28/2014 - SRO PServer Advertising - 103 Replies
http://i58.tinypic.com/2dloe1w.png
Hello Elitepvpers & Welcome TO Relic Sro
Introducing Relic Sro
When we started to plan for this server, we agreed to keep it exactly the same like ISRO system. And since the server is a LONG TERM server then we decided to add some events and features which will meet the needs of different and several players who have different point of views concerning having fun in a silkroad server.
We have dreamed of a server...
|
{Update}RelicSro►Cap 110►mid rates►AutoEquipment D1~D9►Silk Per Hour&&&More
10/30/2014 - SRO PServer Advertising - 18 Replies
http://i58.tinypic.com/2dloe1w.png
Hello Elitepvpers & Welcome TO Relic Sro
Introducing Relic Sro
When we started to plan for this server, we agreed to keep it exactly the same like ISRO system. And since the server is a LONG TERM server then we decided to add some events and features which will meet the needs of different and several players who have different point of views concerning having fun in a silkroad server.
We have dreamed of a server...
|
LGN-Sparta►Cap 110►Jop►AutoEquipment►Free Silks►Balanced►Classic Gamplay!
11/18/2013 - SRO PServer Advertising - 28 Replies
Website: Legends Gaming Network
Register: Legends Gaming Network
Download: Legends Gaming Network
http://i.epvpimg.com/Dusrc.jpg
1# UPDATE
# Added high mob rate spawn
|
(¯`·.»{Divin-Online}»(Cap130/PvE»3Silk/Hour»AutoEquipment»New System»Open25/9)«.·`)
10/15/2013 - SRO PServer Advertising - 123 Replies
http://i.imagebanana.com/img/kgeuxn1k/divinlogo.jp g
Welcome To Divin Online
We hope that you enjoy in our server Divin-Online
We have many new stuff like (Weapons,Items,Mobs,Pets,Towns and more...)
|
All times are GMT +2. The time now is 16:02.
|
|
