المساعد الشخصي الرقمي

مشاهدة النسخة كاملة : Unlock Limit Max Plus +12 To AnY Plus


Mr.Viper
20-04-2016, 09:14 PM
http://e.top4top.net/p_110t3e91.png


http://www.dev-point.com/vb/imagize/smilies/19.gif [[ تعديل ماكس بلص +12 لسهولة الشحن بالـ Query ]] http://www.dev-point.com/vb/imagize/smilies/19.gif

http://www.dev-point.com/vb/imagize/smilies/159.gif [[ اتمني شرحي للموضيع يكون مفهوم وسهل ]] http://www.dev-point.com/vb/imagize/smilies/159.gif

http://www.dev-point.com/vb/images/smilies/blb6.gif [[ ارجو ان ينال الشرح و الموضوع اعجابكم ]] http://www.dev-point.com/vb/images/smilies/blb6.gif

http://www.dev-point.com/vb/images/smilies/31.gif [[ تابعو معي ]] http://www.dev-point.com/vb/images/smilies/31.gif






Go to SRO_VT_SHARD >> Programmability >> StoredProcedures >> _ADD_ITEM_EXTERN

كلك يمين وافتح بيـ Modify
هتنزل تحت شوية
هتبحث عن


declare @dur int
select @dur = Dur_L from _RefObjItem where ID = @link_to_item
set @data = @dur
if (@opt_level < 0)
set @opt_level = 0
else if (@opt_level > 12)
set @opt_level = 12


تغير القيمة 12 لي القيمة الـ انتا عايزها
مثلا هتخلى
Max Plus Be Al Query +25
تعدل على

(else if (@opt_level > 12
set @opt_level = 12
تغير 12 وتكتب زاى ما تحب مثلا 25



بدل ما الايتم كانت بتوصل بالكويرى +12
هتوصل +25

للتوضيح اكتر القى نظرة هنا


http://b.top4top.net/p_1105lkj1.gif




http://a.top4top.net/p_110a0wk2.png

لو فى اى حد وجهتو مشكلة بعد ما طبق الشرح
فى حاجة تانى اسمها




















































Max Plus System










































Go to SRO_VT_SHARDLOG>>Programmability>>Stored Procedures>>_AddLogChar




















































هتلاقي البرسيدور بالشكلده









































































































































































update SRO_VT_SHARD.dbo._Items set OptLevel =20 where optlevel >20
او بالشكل ده
















































































































































































































if @EventID in (4,6,9)
begin
update SRO_VT_SHARD.dbo._Items set OptLevel=12 where OptLevel in (13,14,15,16,17)
end













































































































































امسحوواعمل Execute































































































































































































































































































http://a.top4top.net/p_110a0wk2.png


بالمرة حبة كويرى اكتر ناس هتحتاج الكويرى المبتدئين
قولت اوفر عليهم تعب انك تعمل 12 كويرى من كل نوع ايتم خدها جاهزه =D
الموضوع سهل وبسيط جدا بس بالنسبة لو حد لسه مبتداء هيصعب عليه فهم ازاى يعمل الكويرى
فا بالمرة قولت عشان الموضوع يكمل

طبعا لو حبيت تستخدم اى كويرى هتعدل على كلمة Name
بي اسم الشخصيه الـ عايز تبعتلها الايتم


[1]- D11 Nova
[2]- D13 Sun
[3]- D15 Sun
[4]- Egy A
[5]- Egy B

نبداء بي :

D11 Nova

1- Euro Male Light Armor

USE SRO_VT_SHARD
--Usage:
--exec _ADD_ITEM_EXTERN 'CharName','ItemsCodeName',Count,OptLvl
declare @CharName varchar(64)

set @CharName = 'Name'

exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_TSTAFF_11_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_TSWORD_11_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_DAGGER_11_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_STAFF_11_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_SHIELD_11_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_SWORD_11_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_AXE_11_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_HARP_11_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_CROSSBOW_11_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_DARKSTAFF_11_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_HEAVY_11_HA_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_HEAVY_11_SA_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_HEAVY_11_BA_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_HEAVY_11_LA_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_HEAVY_11_FA_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_HEAVY_11_AA_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_RING_11_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_RING_11_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_EARRING_11_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_NECKLACE_11_A_RARE',1,18



2- Euro Female Light Armor

USE SRO_VT_SHARD
--Usage:
--exec _ADD_ITEM_EXTERN 'CharName','ItemsCodeName',Count,OptLvl
declare @CharName varchar(64)

set @CharName = 'Name'

exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_TSTAFF_11_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_TSWORD_11_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_DAGGER_11_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_STAFF_11_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_SHIELD_11_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_SWORD_11_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_AXE_11_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_HARP_11_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_CROSSBOW_11_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_DARKSTAFF_11_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_LIGHT_11_HA_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_LIGHT_11_SA_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_LIGHT_11_BA_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_LIGHT_11_LA_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_LIGHT_11_FA_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_LIGHT_11_AA_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_RING_11_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_RING_11_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_EARRING_11_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_NECKLACE_11_A_RARE',1,18


3- Euro Male Heavy Armor

USE SRO_VT_SHARD
--Usage:
--exec _ADD_ITEM_EXTERN 'CharName','ItemsCodeName',Count,OptLvl
declare @CharName varchar(64)

set @CharName = 'Name'

exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_TSTAFF_11_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_TSWORD_11_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_DAGGER_11_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_STAFF_11_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_SHIELD_11_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_SWORD_11_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_AXE_11_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_HARP_11_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_CROSSBOW_11_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_DARKSTAFF_11_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_M_HEAVY_11_HA_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_M_HEAVY_11_SA_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_M_HEAVY_11_BA_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_M_HEAVY_11_LA_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_M_HEAVY_11_FA_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_M_HEAVY_11_AA_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_RING_11_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_RING_11_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_EARRING_11_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_NECKLACE_11_A_RARE',1,18


4- Euro Female Heavy Armor

USE SRO_VT_SHARD
--Usage:
--exec _ADD_ITEM_EXTERN 'CharName','ItemsCodeName',Count,OptLvl
declare @CharName varchar(64)

set @CharName = 'Name'

exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_TSTAFF_11_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_TSWORD_11_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_DAGGER_11_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_STAFF_11_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_SHIELD_11_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_SWORD_11_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_AXE_11_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_HARP_11_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_CROSSBOW_11_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_DARKSTAFF_11_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_HEAVY_11_HA_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_HEAVY_11_SA_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_HEAVY_11_BA_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_HEAVY_11_LA_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_HEAVY_11_FA_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_HEAVY_11_AA_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_RING_11_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_RING_11_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_EARRING_11_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_NECKLACE_11_A_RARE',1,18


5- Euro Female Rope

USE SRO_VT_SHARD
--Usage:
--exec _ADD_ITEM_EXTERN 'CharName','ItemsCodeName',Count,OptLvl
declare @CharName varchar(64)

set @CharName = 'Name'

exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_TSTAFF_11_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_TSWORD_11_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_DAGGER_11_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_STAFF_11_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_SHIELD_11_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_SWORD_11_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_AXE_11_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_HARP_11_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_CROSSBOW_11_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_DARKSTAFF_11_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_CLOTHES_11_HA_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_CLOTHES_11_BA_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_CLOTHES_11_LA_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_CLOTHES_11_SA_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_CLOTHES_11_AA_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_CLOTHES_11_FA_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_RING_11_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_RING_11_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_EARRING_11_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_NECKLACE_11_A_RARE',1,18


6- Euro Male Rope

USE SRO_VT_SHARD
--Usage:
--exec _ADD_ITEM_EXTERN 'CharName','ItemsCodeName',Count,OptLvl
declare @CharName varchar(64)

set @CharName = 'Name'

exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_TSTAFF_11_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_TSWORD_11_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_DAGGER_11_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_STAFF_11_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_SHIELD_11_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_SWORD_11_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_AXE_11_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_HARP_11_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_CROSSBOW_11_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_DARKSTAFF_11_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_M_CLOTHES_11_HA_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_M_CLOTHES_11_BA_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_M_CLOTHES_11_LA_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_M_CLOTHES_11_SA_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_M_CLOTHES_11_AA_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_M_CLOTHES_11_FA_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_RING_11_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_RING_11_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_EARRING_11_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_NECKLACE_11_A_RARE',1,18


7- Cgina Male Germant

USE SRO_VT_SHARD
--Usage:
--exec _ADD_ITEM_EXTERN 'CharName','ItemsCodeName',Count,OptLvl
declare @CharName varchar(64)

set @CharName = 'Name'

exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_SPEAR_11_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_BOW_11_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_TBLADE_11_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_SWORD_11_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_BLADE_11_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_SHIELD_11_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_M_CLOTHES_11_HA_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_M_CLOTHES_11_SA_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_M_CLOTHES_11_BA_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_M_CLOTHES_11_LA_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_M_CLOTHES_11_FA_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_M_CLOTHES_11_AA_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_RING_11_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_RING_11_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_EARRING_11_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_NECKLACE_11_A_RARE',1,18


8- Cgina Female Germant

USE SRO_VT_SHARD
--Usage:
--exec _ADD_ITEM_EXTERN 'CharName','ItemsCodeName',Count,OptLvl
declare @CharName varchar(64)

set @CharName = 'Name'

exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_SPEAR_11_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_BOW_11_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_TBLADE_11_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_SWORD_11_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_BLADE_11_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_SHIELD_11_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_W_CLOTHES_11_HA_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_W_CLOTHES_11_SA_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_W_CLOTHES_11_BA_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_W_CLOTHES_11_LA_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_W_CLOTHES_11_FA_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_W_CLOTHES_11_AA_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_RING_11_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_RING_11_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_EARRING_11_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_NECKLACE_11_A_RARE',1,18


9- Cgina Male Protector

USE SRO_VT_SHARD
--Usage:
--exec _ADD_ITEM_EXTERN 'CharName','ItemsCodeName',Count,OptLvl
declare @CharName varchar(64)

set @CharName = 'Name'

exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_SPEAR_11_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_BOW_11_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_TBLADE_11_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_SWORD_11_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_BLADE_11_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_SHIELD_11_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_W_LIGHT_11_HA_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_W_LIGHT_11_SA_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_W_LIGHT_11_BA_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_W_LIGHT_11_LA_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_W_LIGHT_11_FA_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_W_LIGHT_11_AA_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_RING_11_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_RING_11_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_EARRING_11_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_NECKLACE_11_A_RARE',1,18


10- Cgina Female Protector

USE SRO_VT_SHARD
--Usage:
--exec _ADD_ITEM_EXTERN 'CharName','ItemsCodeName',Count,OptLvl
declare @CharName varchar(64)

set @CharName = 'Name'

exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_SPEAR_11_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_BOW_11_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_TBLADE_11_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_SWORD_11_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_BLADE_11_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_SHIELD_11_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_M_LIGHT_11_HA_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_M_LIGHT_11_SA_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_M_LIGHT_11_BA_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_M_LIGHT_11_LA_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_M_LIGHT_11_FA_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_M_LIGHT_11_AA_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_RING_11_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_RING_11_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_EARRING_11_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_NECKLACE_11_A_RARE',1,18


11- Cgina Male Armor

USE SRO_VT_SHARD
--Usage:
--exec _ADD_ITEM_EXTERN 'CharName','ItemsCodeName',Count,OptLvl
declare @CharName varchar(64)

set @CharName = 'Name'

exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_SPEAR_11_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_BOW_11_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_TBLADE_11_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_SWORD_11_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_BLADE_11_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_SHIELD_11_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_M_HEAVY_11_HA_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_M_HEAVY_11_SA_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_M_HEAVY_11_BA_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_M_HEAVY_11_LA_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_M_HEAVY_11_FA_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_M_HEAVY_11_AA_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_RING_11_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_RING_11_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_EARRING_11_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_NECKLACE_11_A_RARE',1,18


12- Cgina Female Armor

USE SRO_VT_SHARD
--Usage:
--exec _ADD_ITEM_EXTERN 'CharName','ItemsCodeName',Count,OptLvl
declare @CharName varchar(64)

set @CharName = 'Name'

exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_SPEAR_11_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_BOW_11_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_TBLADE_11_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_SWORD_11_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_BLADE_11_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_SHIELD_11_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_W_HEAVY_11_HA_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_W_HEAVY_11_SA_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_W_HEAVY_11_BA_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_W_HEAVY_11_LA_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_W_HEAVY_11_FA_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_W_HEAVY_11_AA_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_RING_11_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_RING_11_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_EARRING_11_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_NECKLACE_11_A_RARE',1,18



http://a.top4top.net/p_110a0wk2.png



D13 Sun

1- Euro Male Light Armor

USE SRO_VT_SHARD
--Usage:
--exec _ADD_ITEM_EXTERN 'CharName','ItemsCodeName',Count,OptLvl
declare @CharName varchar(64)

set @CharName = 'Name'

exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_TSTAFF_13_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_TSWORD_13_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_DAGGER_13_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_STAFF_13_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_SHIELD_13_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_SWORD_13_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_AXE_13_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_HARP_13_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_CROSSBOW_13_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_DARKSTAFF_13_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_M_LIGHT_13_HA_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_M_LIGHT_13_SA_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_M_LIGHT_13_BA_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_M_LIGHT_13_LA_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_M_LIGHT_13_FA_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_M_LIGHT_13_AA_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_RING_13_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_RING_13_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_EARRING_13_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_NECKLACE_13_C_RARE',1,18


2- Euro Female Light Armor

USE SRO_VT_SHARD
--Usage:
--exec _ADD_ITEM_EXTERN 'CharName','ItemsCodeName',Count,OptLvl
declare @CharName varchar(64)

set @CharName = 'Name'

exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_TSTAFF_13_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_TSWORD_13_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_DAGGER_13_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_STAFF_13_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_SHIELD_13_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_SWORD_13_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_AXE_13_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_HARP_13_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_CROSSBOW_13_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_DARKSTAFF_13_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_LIGHT_13_HA_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_LIGHT_13_SA_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_LIGHT_13_BA_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_LIGHT_13_LA_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_LIGHT_13_FA_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_LIGHT_13_AA_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_RING_13_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_RING_13_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_EARRING_13_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_NECKLACE_13_C_RARE',1,18


3- Euro Male Heavy Armor

USE SRO_VT_SHARD
--Usage:
--exec _ADD_ITEM_EXTERN 'CharName','ItemsCodeName',Count,OptLvl
declare @CharName varchar(64)

set @CharName = 'Name'

exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_TSTAFF_13_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_TSWORD_13_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_DAGGER_13_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_STAFF_13_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_SHIELD_13_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_SWORD_13_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_AXE_13_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_HARP_13_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_CROSSBOW_13_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_DARKSTAFF_13_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_M_HEAVY_13_HA_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_M_HEAVY_13_SA_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_M_HEAVY_13_BA_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_M_HEAVY_13_LA_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_M_HEAVY_13_FA_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_M_HEAVY_13_AA_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_RING_13_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_RING_13_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_EARRING_13_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_NECKLACE_13_C_RARE',1,18


4- Euro Female Heavy Armor

USE SRO_VT_SHARD
--Usage:
--exec _ADD_ITEM_EXTERN 'CharName','ItemsCodeName',Count,OptLvl
declare @CharName varchar(64)

set @CharName = 'Name'

exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_TSTAFF_13_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_TSWORD_13_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_DAGGER_13_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_STAFF_13_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_SHIELD_13_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_SWORD_13_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_AXE_13_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_HARP_13_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_CROSSBOW_13_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_DARKSTAFF_13_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_HEAVY_13_HA_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_HEAVY_13_SA_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_HEAVY_13_BA_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_HEAVY_13_LA_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_HEAVY_13_FA_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_HEAVY_13_AA_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_RING_13_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_RING_13_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_EARRING_13_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_NECKLACE_13_C_RARE',1,18


5- Euro Female Rope

USE SRO_VT_SHARD
--Usage:
--exec _ADD_ITEM_EXTERN 'CharName','ItemsCodeName',Count,OptLvl
declare @CharName varchar(64)

set @CharName = 'Name'

exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_TSTAFF_13_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_TSWORD_13_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_DAGGER_13_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_STAFF_13_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_SHIELD_13_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_SWORD_13_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_AXE_13_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_HARP_13_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_CROSSBOW_13_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_DARKSTAFF_13_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_CLOTHES_13_HA_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_CLOTHES_13_BA_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_CLOTHES_13_LA_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_CLOTHES_13_SA_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_CLOTHES_13_AA_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_CLOTHES_13_FA_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_RING_13_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_RING_13_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_EARRING_13_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_NECKLACE_13_C_RARE',1,18


6- Euro Male Rope

USE SRO_VT_SHARD
--Usage:
--exec _ADD_ITEM_EXTERN 'CharName','ItemsCodeName',Count,OptLvl
declare @CharName varchar(64)

set @CharName = 'Name'

exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_TSTAFF_13_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_TSWORD_13_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_DAGGER_13_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_STAFF_13_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_SHIELD_13_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_SWORD_13_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_AXE_13_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_HARP_13_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_CROSSBOW_13_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_DARKSTAFF_13_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_M_CLOTHES_13_HA_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_M_CLOTHES_13_BA_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_M_CLOTHES_13_LA_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_M_CLOTHES_13_SA_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_M_CLOTHES_13_AA_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_M_CLOTHES_13_FA_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_RING_13_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_RING_13_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_EARRING_13_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_NECKLACE_13_C_RARE',1,18


7- Cgina Male Germant

USE SRO_VT_SHARD
--Usage:
--exec _ADD_ITEM_EXTERN 'CharName','ItemsCodeName',Count,OptLvl
declare @CharName varchar(64)

set @CharName = 'Name'

exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_SPEAR_13_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_BOW_13_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_TBLADE_13_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_SWORD_13_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_BLADE_13_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_SHIELD_13_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_M_CLOTHES_13_HA_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_M_CLOTHES_13_SA_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_M_CLOTHES_13_BA_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_M_CLOTHES_13_LA_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_M_CLOTHES_13_FA_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_M_CLOTHES_13_AA_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_RING_13_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_RING_13_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_EARRING_13_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_NECKLACE_13_C_RARE',1,18


8- Cgina Female Germant

USE SRO_VT_SHARD
--Usage:
--exec _ADD_ITEM_EXTERN 'CharName','ItemsCodeName',Count,OptLvl
declare @CharName varchar(64)

set @CharName = 'Name'

exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_SPEAR_13_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_BOW_13_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_TBLADE_13_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_SWORD_13_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_BLADE_13_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_SHIELD_13_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_W_CLOTHES_13_HA_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_W_CLOTHES_13_SA_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_W_CLOTHES_13_BA_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_W_CLOTHES_13_LA_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_W_CLOTHES_13_FA_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_W_CLOTHES_13_AA_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_RING_13_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_RING_13_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_EARRING_13_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_NECKLACE_13_C_RARE',1,18


9- Cgina Male Protector

USE SRO_VT_SHARD
--Usage:
--exec _ADD_ITEM_EXTERN 'CharName','ItemsCodeName',Count,OptLvl
declare @CharName varchar(64)

set @CharName = 'Name'

exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_SPEAR_13_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_BOW_13_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_TBLADE_13_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_SWORD_13_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_BLADE_13_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_SHIELD_13_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_M_LIGHT_13_HA_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_M_LIGHT_13_SA_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_M_LIGHT_13_BA_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_M_LIGHT_13_LA_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_M_LIGHT_13_FA_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_M_LIGHT_13_AA_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_RING_13_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_RING_13_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_EARRING_13_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_NECKLACE_13_C_RARE',1,18


10- Cgina Female Protector

USE SRO_VT_SHARD
--Usage:
--exec _ADD_ITEM_EXTERN 'CharName','ItemsCodeName',Count,OptLvl
declare @CharName varchar(64)

set @CharName = 'Name'

exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_SPEAR_13_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_BOW_13_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_TBLADE_13_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_SWORD_13_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_BLADE_13_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_SHIELD_13_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_W_LIGHT_13_HA_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_W_LIGHT_13_SA_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_W_LIGHT_13_BA_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_W_LIGHT_13_LA_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_W_LIGHT_13_FA_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_W_LIGHT_13_AA_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_RING_13_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_RING_13_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_EARRING_13_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_NECKLACE_13_C_RARE',1,18


11- Cgina Male Armor

USE SRO_VT_SHARD
--Usage:
--exec _ADD_ITEM_EXTERN 'CharName','ItemsCodeName',Count,OptLvl
declare @CharName varchar(64)

set @CharName = 'Name'

exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_SPEAR_13_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_BOW_13_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_TBLADE_13_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_SWORD_13_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_BLADE_13_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_SHIELD_13_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_M_HEAVY_13_HA_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_M_HEAVY_13_SA_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_M_HEAVY_13_BA_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_M_HEAVY_13_LA_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_M_HEAVY_13_FA_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_M_HEAVY_13_AA_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_RING_13_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_RING_13_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_EARRING_13_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_NECKLACE_13_C_RARE',1,18


12- Cgina Female Armor

USE SRO_VT_SHARD
--Usage:
--exec _ADD_ITEM_EXTERN 'CharName','ItemsCodeName',Count,OptLvl
declare @CharName varchar(64)

set @CharName = 'Name'

exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_SPEAR_13_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_BOW_13_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_TBLADE_13_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_SWORD_13_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_BLADE_13_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_SHIELD_13_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_W_HEAVY_13_HA_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_W_HEAVY_13_SA_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_W_HEAVY_13_BA_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_W_HEAVY_13_LA_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_W_HEAVY_13_FA_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_W_HEAVY_13_AA_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_RING_13_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_RING_13_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_EARRING_13_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_NECKLACE_13_C_RARE',1,18



http://a.top4top.net/p_110a0wk2.png



D15 Sun

1- Euro Male Light Armor

USE SRO_VT_SHARD
--Usage:
--exec _ADD_ITEM_EXTERN 'CharName','ItemsCodeName',Count,OptLvl
declare @CharName varchar(64)

set @CharName = 'Name'

exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_TSTAFF_15_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_TSWORD_15_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_DAGGER_15_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_STAFF_15_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_SHIELD_15_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_SWORD_15_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_AXE_15_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_HARP_15_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_CROSSBOW_15_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_DARKSTAFF_15_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_M_LIGHT_15_HA_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_M_LIGHT_15_SA_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_M_LIGHT_15_BA_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_M_LIGHT_15_LA_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_M_LIGHT_15_FA_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_M_LIGHT_15_AA_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_RING_15_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_RING_15_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_EARRING_15_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_NECKLACE_15_C_RARE',1,18


2- Euro Female Light Armor

USE SRO_VT_SHARD
--Usage:
--exec _ADD_ITEM_EXTERN 'CharName','ItemsCodeName',Count,OptLvl
declare @CharName varchar(64)

set @CharName = 'Name'

exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_TSTAFF_15_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_TSWORD_15_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_DAGGER_15_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_STAFF_15_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_SHIELD_15_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_SWORD_15_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_AXE_15_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_HARP_15_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_CROSSBOW_15_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_DARKSTAFF_15_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_LIGHT_15_HA_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_LIGHT_15_SA_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_LIGHT_15_BA_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_LIGHT_15_LA_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_LIGHT_15_FA_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_LIGHT_15_AA_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_RING_15_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_RING_15_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_EARRING_15_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_NECKLACE_15_C_RARE',1,18


3- Euro Male Heavy Armor

USE SRO_VT_SHARD
--Usage:
--exec _ADD_ITEM_EXTERN 'CharName','ItemsCodeName',Count,OptLvl
declare @CharName varchar(64)

set @CharName = 'Name'

exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_TSTAFF_15_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_TSWORD_15_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_DAGGER_15_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_STAFF_15_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_SHIELD_15_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_SWORD_15_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_AXE_15_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_HARP_15_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_CROSSBOW_15_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_DARKSTAFF_15_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_M_HEAVY_15_HA_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_M_HEAVY_15_SA_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_M_HEAVY_15_BA_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_M_HEAVY_15_LA_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_M_HEAVY_15_FA_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_M_HEAVY_15_AA_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_RING_15_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_RING_15_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_EARRING_15_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_NECKLACE_15_C_RARE',1,18


4- Euro Female Heavy Armor

USE SRO_VT_SHARD
--Usage:
--exec _ADD_ITEM_EXTERN 'CharName','ItemsCodeName',Count,OptLvl
declare @CharName varchar(64)

set @CharName = 'Name'

exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_TSTAFF_15_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_TSWORD_15_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_DAGGER_15_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_STAFF_15_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_SHIELD_15_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_SWORD_15_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_AXE_15_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_HARP_15_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_CROSSBOW_15_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_DARKSTAFF_15_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_HEAVY_15_HA_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_HEAVY_15_SA_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_HEAVY_15_BA_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_HEAVY_15_LA_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_HEAVY_15_FA_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_HEAVY_15_AA_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_RING_15_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_RING_15_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_EARRING_15_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_NECKLACE_15_C_RARE',1,18


5- Euro Female Rope

USE SRO_VT_SHARD
--Usage:
--exec _ADD_ITEM_EXTERN 'CharName','ItemsCodeName',Count,OptLvl
declare @CharName varchar(64)

set @CharName = 'Name'

exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_TSTAFF_15_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_TSWORD_15_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_DAGGER_15_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_STAFF_15_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_SHIELD_15_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_SWORD_15_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_AXE_15_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_HARP_15_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_CROSSBOW_15_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_DARKSTAFF_15_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_CLOTHES_15_HA_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_CLOTHES_15_BA_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_CLOTHES_15_LA_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_CLOTHES_15_SA_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_CLOTHES_15_AA_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_CLOTHES_15_FA_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_RING_15_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_RING_15_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_EARRING_15_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_NECKLACE_15_C_RARE',1,18


6- Euro Male Rope

USE SRO_VT_SHARD
--Usage:
--exec _ADD_ITEM_EXTERN 'CharName','ItemsCodeName',Count,OptLvl
declare @CharName varchar(64)

set @CharName = 'Name'

exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_TSTAFF_15_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_TSWORD_15_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_DAGGER_15_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_STAFF_15_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_SHIELD_15_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_SWORD_15_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_AXE_15_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_HARP_15_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_CROSSBOW_15_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_DARKSTAFF_15_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_M_CLOTHES_15_HA_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_M_CLOTHES_15_BA_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_M_CLOTHES_15_LA_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_M_CLOTHES_15_SA_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_M_CLOTHES_15_AA_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_M_CLOTHES_15_FA_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_RING_15_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_RING_15_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_EARRING_15_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_NECKLACE_15_C_RARE',1,18


7- Cgina Male Germant

USE SRO_VT_SHARD
--Usage:
--exec _ADD_ITEM_EXTERN 'CharName','ItemsCodeName',Count,OptLvl
declare @CharName varchar(64)

set @CharName = 'Name'

exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_SPEAR_15_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_BOW_15_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_TBLADE_15_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_SWORD_15_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_BLADE_15_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_SHIELD_15_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_M_CLOTHES_15_HA_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_M_CLOTHES_15_SA_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_M_CLOTHES_15_BA_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_M_CLOTHES_15_LA_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_M_CLOTHES_15_FA_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_M_CLOTHES_15_AA_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_RING_15_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_RING_15_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_EARRING_15_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_NECKLACE_15_C_RARE',1,18


8- Cgina Female Germant

USE SRO_VT_SHARD
--Usage:
--exec _ADD_ITEM_EXTERN 'CharName','ItemsCodeName',Count,OptLvl
declare @CharName varchar(64)

set @CharName = 'Name'

exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_SPEAR_15_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_BOW_15_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_TBLADE_15_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_SWORD_15_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_BLADE_15_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_SHIELD_15_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_W_CLOTHES_15_HA_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_W_CLOTHES_15_SA_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_W_CLOTHES_15_BA_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_W_CLOTHES_15_LA_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_W_CLOTHES_15_FA_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_W_CLOTHES_15_AA_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_RING_15_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_RING_15_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_EARRING_15_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_NECKLACE_15_C_RARE',1,18


9- Cgina Male Protector

USE SRO_VT_SHARD
--Usage:
--exec _ADD_ITEM_EXTERN 'CharName','ItemsCodeName',Count,OptLvl
declare @CharName varchar(64)

set @CharName = 'Name'

exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_SPEAR_15_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_BOW_15_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_TBLADE_15_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_SWORD_15_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_BLADE_15_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_SHIELD_15_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_M_LIGHT_15_HA_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_M_LIGHT_15_SA_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_M_LIGHT_15_BA_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_M_LIGHT_15_LA_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_M_LIGHT_15_FA_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_M_LIGHT_15_AA_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_RING_15_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_RING_15_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_EARRING_15_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_NECKLACE_15_C_RARE',1,18


10- Cgina Female Protector

USE SRO_VT_SHARD
--Usage:
--exec _ADD_ITEM_EXTERN 'CharName','ItemsCodeName',Count,OptLvl
declare @CharName varchar(64)

set @CharName = 'Name'

exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_SPEAR_15_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_BOW_15_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_TBLADE_15_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_SWORD_15_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_BLADE_15_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_SHIELD_15_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_W_LIGHT_15_HA_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_W_LIGHT_15_SA_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_W_LIGHT_15_BA_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_W_LIGHT_15_LA_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_W_LIGHT_15_FA_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_W_LIGHT_15_AA_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_RING_15_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_RING_15_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_EARRING_15_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_NECKLACE_15_C_RARE',1,18


11- Cgina Male Armor

USE SRO_VT_SHARD
--Usage:
--exec _ADD_ITEM_EXTERN 'CharName','ItemsCodeName',Count,OptLvl
declare @CharName varchar(64)

set @CharName = 'Name'

exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_SPEAR_15_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_BOW_15_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_TBLADE_15_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_SWORD_15_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_BLADE_15_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_SHIELD_15_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_M_HEAVY_15_HA_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_M_HEAVY_15_SA_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_M_HEAVY_15_BA_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_M_HEAVY_15_LA_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_M_HEAVY_15_FA_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_M_HEAVY_15_AA_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_RING_15_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_RING_15_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_EARRING_15_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_NECKLACE_15_C_RARE',1,18


12- Cgina Female Armor

USE SRO_VT_SHARD
--Usage:
--exec _ADD_ITEM_EXTERN 'CharName','ItemsCodeName',Count,OptLvl
declare @CharName varchar(64)

set @CharName = 'Name'

exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_SPEAR_15_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_BOW_15_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_TBLADE_15_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_SWORD_15_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_BLADE_15_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_SHIELD_15_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_W_HEAVY_15_HA_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_W_HEAVY_15_SA_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_W_HEAVY_15_BA_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_W_HEAVY_15_LA_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_W_HEAVY_15_FA_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_W_HEAVY_15_AA_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_RING_15_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_RING_15_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_EARRING_15_C_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_NECKLACE_15_C_RARE',1,18



http://a.top4top.net/p_110a0wk2.png



Egy A

1- Euro Male Light Armor

USE SRO_VT_SHARD
--Usage:
--exec _ADD_ITEM_EXTERN 'CharName','ItemsCodeName',Count,OptLvl
declare @CharName varchar(64)

set @CharName = 'Name'

exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_TSTAFF_11_SET_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_TSWORD_11_SET_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_DAGGER_11_SET_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_STAFF_11_SET_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_SHIELD_11_SET_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_SWORD_11_SET_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_AXE_11_SET_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_HARP_11_SET_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_CROSSBOW_11_SET_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_DARKSTAFF_11_SET_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_M_LIGHT_11_HA_SET_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_M_LIGHT_11_SA_SET_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_M_LIGHT_11_BA_SET_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_M_LIGHT_11_LA_SET_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_M_LIGHT_11_FA_SET_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_M_LIGHT_11_AA_SET_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_RING_11_SET_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_RING_11_SET_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_EARRING_11_SET_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_NECKLACE_11_SET_A_RARE',1,18


2- Euro Female Light Armor

USE SRO_VT_SHARD
--Usage:
--exec _ADD_ITEM_EXTERN 'CharName','ItemsCodeName',Count,OptLvl
declare @CharName varchar(64)

set @CharName = 'Name'

exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_TSTAFF_11_SET_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_TSWORD_11_SET_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_DAGGER_11_SET_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_STAFF_11_SET_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_SHIELD_11_SET_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_SWORD_11_SET_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_AXE_11_SET_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_HARP_11_SET_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_CROSSBOW_11_SET_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_DARKSTAFF_11_SET_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_LIGHT_11_HA_SET_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_LIGHT_11_SA_SET_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_LIGHT_11_BA_SET_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_LIGHT_11_LA_SET_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_LIGHT_11_FA_SET_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_LIGHT_11_AA_SET_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_RING_11_SET_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_RING_11_SET_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_EARRING_11_SET_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_NECKLACE_11_SET_A_RARE',1,18


3- Euro Male Heavy Armor

USE SRO_VT_SHARD
--Usage:
--exec _ADD_ITEM_EXTERN 'CharName','ItemsCodeName',Count,OptLvl
declare @CharName varchar(64)

set @CharName = 'Name'

exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_TSTAFF_11_SET_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_TSWORD_11_SET_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_DAGGER_11_SET_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_STAFF_11_SET_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_SHIELD_11_SET_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_SWORD_11_SET_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_AXE_11_SET_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_HARP_11_SET_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_CROSSBOW_11_SET_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_DARKSTAFF_11_SET_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_M_HEAVY_11_HA_SET_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_M_HEAVY_11_SA_SET_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_M_HEAVY_11_BA_SET_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_M_HEAVY_11_LA_SET_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_M_HEAVY_11_FA_SET_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_M_HEAVY_11_AA_SET_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_RING_11_SET_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_RING_11_SET_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_EARRING_11_SET_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_NECKLACE_11_SET_A_RARE',1,18


4- Euro Female Heavy Armor

USE SRO_VT_SHARD
--Usage:
--exec _ADD_ITEM_EXTERN 'CharName','ItemsCodeName',Count,OptLvl
declare @CharName varchar(64)

set @CharName = 'Name'

exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_TSTAFF_11_SET_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_TSWORD_11_SET_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_DAGGER_11_SET_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_STAFF_11_SET_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_SHIELD_11_SET_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_SWORD_11_SET_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_AXE_11_SET_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_HARP_11_SET_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_CROSSBOW_11_SET_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_DARKSTAFF_11_SET_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_HEAVY_11_HA_SET_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_HEAVY_11_SA_SET_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_HEAVY_11_BA_SET_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_HEAVY_11_LA_SET_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_HEAVY_11_FA_SET_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_HEAVY_11_AA_SET_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_RING_11_SET_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_RING_11_SET_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_EARRING_11_SET_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_NECKLACE_11_SET_A_RARE',1,18


5- Euro Female Rope

USE SRO_VT_SHARD
--Usage:
--exec _ADD_ITEM_EXTERN 'CharName','ItemsCodeName',Count,OptLvl
declare @CharName varchar(64)

set @CharName = 'Name'

exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_TSTAFF_11_SET_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_TSWORD_11_SET_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_DAGGER_11_SET_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_STAFF_11_SET_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_SHIELD_11_SET_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_SWORD_11_SET_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_AXE_11_SET_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_HARP_11_SET_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_CROSSBOW_11_SET_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_DARKSTAFF_11_SET_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_CLOTHES_11_HA_SET_A_RARE',1,1 8
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_CLOTHES_11_BA_SET_A_RARE',1,1 8
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_CLOTHES_11_LA_SET_A_RARE',1,1 8
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_CLOTHES_11_SA_SET_A_RARE',1,1 8
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_CLOTHES_11_AA_SET_A_RARE',1,1 8
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_CLOTHES_11_FA_SET_A_RARE',1,1 8
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_RING_11_SET_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_RING_11_SET_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_EARRING_11_SET_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_NECKLACE_11_SET_A_RARE',1,18


6- Euro Male Rope

USE SRO_VT_SHARD
--Usage:
--exec _ADD_ITEM_EXTERN 'CharName','ItemsCodeName',Count,OptLvl
declare @CharName varchar(64)

set @CharName = 'Name'

exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_TSTAFF_11_SET_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_TSWORD_11_SET_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_DAGGER_11_SET_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_STAFF_11_SET_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_SHIELD_11_SET_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_SWORD_11_SET_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_AXE_11_SET_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_HARP_11_SET_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_CROSSBOW_11_SET_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_DARKSTAFF_11_SET_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_M_CLOTHES_11_HA_SET_A_RARE',1,1 8
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_M_CLOTHES_11_BA_SET_A_RARE',1,1 8
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_M_CLOTHES_11_LA_SET_A_RARE',1,1 8
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_M_CLOTHES_11_SA_SET_A_RARE',1,1 8
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_M_CLOTHES_11_AA_SET_A_RARE',1,1 8
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_M_CLOTHES_11_FA_SET_A_RARE',1,1 8
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_RING_11_SET_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_RING_11_SET_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_EARRING_11_SET_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_NECKLACE_11_SET_A_RARE',1,18


7- Cgina Male Germant

USE SRO_VT_SHARD
--Usage:
--exec _ADD_ITEM_EXTERN 'CharName','ItemsCodeName',Count,OptLvl
declare @CharName varchar(64)

set @CharName = 'Name'

exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_SPEAR_11_SET_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_BOW_11_SET_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_TBLADE_11_SET_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_SWORD_11_SET_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_BLADE_11_SET_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_SHIELD_11_SET_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_M_CLOTHES_11_HA_SET_A_RARE',1,1 8
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_M_CLOTHES_11_SA_SET_A_RARE',1,1 8
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_M_CLOTHES_11_BA_SET_A_RARE',1,1 8
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_M_CLOTHES_11_LA_SET_A_RARE',1,1 8
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_M_CLOTHES_11_FA_SET_A_RARE',1,1 8
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_M_CLOTHES_11_AA_SET_A_RARE',1,1 8
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_RING_11_SET_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_RING_11_SET_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_EARRING_11_SET_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_NECKLACE_11_SET_A_RARE',1,18


8- Cgina Female Germant

USE SRO_VT_SHARD
--Usage:
--exec _ADD_ITEM_EXTERN 'CharName','ItemsCodeName',Count,OptLvl
declare @CharName varchar(64)

set @CharName = 'Name'

exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_SPEAR_11_SET_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_BOW_11_SET_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_TBLADE_11_SET_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_SWORD_11_SET_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_BLADE_11_SET_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_SHIELD_11_SET_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_W_CLOTHES_11_HA_SET_A_RARE',1,1 8
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_W_CLOTHES_11_SA_SET_A_RARE',1,1 8
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_W_CLOTHES_11_BA_SET_A_RARE',1,1 8
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_W_CLOTHES_11_LA_SET_A_RARE',1,1 8
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_W_CLOTHES_11_FA_SET_A_RARE',1,1 8
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_W_CLOTHES_11_AA_SET_A_RARE',1,1 8
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_RING_11_SET_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_RING_11_SET_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_EARRING_11_SET_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_NECKLACE_11_SET_A_RARE',1,18


9- Cgina Male Protector

USE SRO_VT_SHARD
--Usage:
--exec _ADD_ITEM_EXTERN 'CharName','ItemsCodeName',Count,OptLvl
declare @CharName varchar(64)

set @CharName = 'Name'

exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_SPEAR_11_SET_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_BOW_11_SET_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_TBLADE_11_SET_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_SWORD_11_SET_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_BLADE_11_SET_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_SHIELD_11_SET_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_M_LIGHT_11_HA_SET_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_M_LIGHT_11_SA_SET_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_M_LIGHT_11_BA_SET_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_M_LIGHT_11_LA_SET_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_M_LIGHT_11_FA_SET_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_M_LIGHT_11_AA_SET_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_RING_11_SET_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_RING_11_SET_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_EARRING_11_SET_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_NECKLACE_11_SET_A_RARE',1,18


10- Cgina Female Protector

USE SRO_VT_SHARD
--Usage:
--exec _ADD_ITEM_EXTERN 'CharName','ItemsCodeName',Count,OptLvl
declare @CharName varchar(64)

set @CharName = 'Name'

exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_SPEAR_11_SET_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_BOW_11_SET_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_TBLADE_11_SET_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_SWORD_11_SET_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_BLADE_11_SET_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_SHIELD_11_SET_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_W_LIGHT_11_HA_SET_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_W_LIGHT_11_SA_SET_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_W_LIGHT_11_BA_SET_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_W_LIGHT_11_LA_SET_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_W_LIGHT_11_FA_SET_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_W_LIGHT_11_AA_SET_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_RING_11_SET_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_RING_11_SET_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_EARRING_11_SET_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_NECKLACE_11_SET_A_RARE',1,18


11- Cgina Male Armor

USE SRO_VT_SHARD
--Usage:
--exec _ADD_ITEM_EXTERN 'CharName','ItemsCodeName',Count,OptLvl
declare @CharName varchar(64)

set @CharName = 'Name'

exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_SPEAR_11_SET_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_BOW_11_SET_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_TBLADE_11_SET_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_SWORD_11_SET_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_BLADE_11_SET_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_SHIELD_11_SET_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_M_HEAVY_11_HA_SET_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_M_HEAVY_11_SA_SET_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_M_HEAVY_11_BA_SET_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_M_HEAVY_11_LA_SET_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_M_HEAVY_11_FA_SET_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_M_HEAVY_11_AA_SET_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_RING_11_SET_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_RING_11_SET_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_EARRING_11_SET_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_NECKLACE_11_SET_A_RARE',1,18


12- Cgina Female Armor

USE SRO_VT_SHARD
--Usage:
--exec _ADD_ITEM_EXTERN 'CharName','ItemsCodeName',Count,OptLvl
declare @CharName varchar(64)

set @CharName = 'Name'

exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_SPEAR_11_SET_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_BOW_11_SET_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_TBLADE_11_SET_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_SWORD_11_SET_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_BLADE_11_SET_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_SHIELD_11_SET_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_W_HEAVY_11_HA_SET_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_W_HEAVY_11_SA_SET_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_W_HEAVY_11_BA_SET_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_W_HEAVY_11_LA_SET_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_W_HEAVY_11_FA_SET_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_W_HEAVY_11_AA_SET_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_RING_11_SET_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_RING_11_SET_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_EARRING_11_SET_A_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_NECKLACE_11_SET_A_RARE',1,18



http://a.top4top.net/p_110a0wk2.png



Egy B

1- Euro Male Light Armor

USE SRO_VT_SHARD
--Usage:
--exec _ADD_ITEM_EXTERN 'CharName','ItemsCodeName',Count,OptLvl
declare @CharName varchar(64)

set @CharName = 'Name'

exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_TSTAFF_11_SET_B_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_TSWORD_11_SET_B_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_DAGGER_11_SET_B_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_STAFF_11_SET_B_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_SHIELD_11_SET_B_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_SWORD_11_SET_B_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_AXE_11_SET_B_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_HARP_11_SET_B_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_CROSSBOW_11_SET_B_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_DARKSTAFF_11_SET_B_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_M_LIGHT_11_HA_SET_B_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_M_LIGHT_11_SA_SET_B_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_M_LIGHT_11_BA_SET_B_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_M_LIGHT_11_LA_SET_B_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_M_LIGHT_11_FA_SET_B_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_M_LIGHT_11_AA_SET_B_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_RING_11_SET_B_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_RING_11_SET_B_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_EARRING_11_SET_B_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_NECKLACE_11_SET_B_RARE',1,18


2- Euro Female Light Armor

USE SRO_VT_SHARD
--Usage:
--exec _ADD_ITEM_EXTERN 'CharName','ItemsCodeName',Count,OptLvl
declare @CharName varchar(64)

set @CharName = 'Name'

exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_TSTAFF_11_SET_B_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_TSWORD_11_SET_B_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_DAGGER_11_SET_B_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_STAFF_11_SET_B_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_SHIELD_11_SET_B_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_SWORD_11_SET_B_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_AXE_11_SET_B_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_HARP_11_SET_B_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_CROSSBOW_11_SET_B_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_DARKSTAFF_11_SET_B_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_LIGHT_11_HA_SET_B_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_LIGHT_11_SA_SET_B_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_LIGHT_11_BA_SET_B_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_LIGHT_11_LA_SET_B_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_LIGHT_11_FA_SET_B_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_LIGHT_11_AA_SET_B_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_RING_11_SET_B_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_RING_11_SET_B_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_EARRING_11_SET_B_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_NECKLACE_11_SET_B_RARE',1,18


3- Euro Male Heavy Armor

USE SRO_VT_SHARD
--Usage:
--exec _ADD_ITEM_EXTERN 'CharName','ItemsCodeName',Count,OptLvl
declare @CharName varchar(64)

set @CharName = 'Name'

exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_TSTAFF_11_SET_B_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_TSWORD_11_SET_B_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_DAGGER_11_SET_B_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_STAFF_11_SET_B_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_SHIELD_11_SET_B_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_SWORD_11_SET_B_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_AXE_11_SET_B_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_HARP_11_SET_B_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_CROSSBOW_11_SET_B_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_DARKSTAFF_11_SET_B_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_M_HEAVY_11_HA_SET_B_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_M_HEAVY_11_SA_SET_B_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_M_HEAVY_11_BA_SET_B_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_M_HEAVY_11_LA_SET_B_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_M_HEAVY_11_FA_SET_B_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_M_HEAVY_11_AA_SET_B_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_RING_11_SET_B_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_RING_11_SET_B_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_EARRING_11_SET_B_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_NECKLACE_11_SET_B_RARE',1,18


4- Euro Female Heavy Armor

USE SRO_VT_SHARD
--Usage:
--exec _ADD_ITEM_EXTERN 'CharName','ItemsCodeName',Count,OptLvl
declare @CharName varchar(64)

set @CharName = 'Name'

exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_TSTAFF_11_SET_B_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_TSWORD_11_SET_B_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_DAGGER_11_SET_B_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_STAFF_11_SET_B_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_SHIELD_11_SET_B_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_SWORD_11_SET_B_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_AXE_11_SET_B_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_HARP_11_SET_B_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_CROSSBOW_11_SET_B_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_DARKSTAFF_11_SET_B_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_HEAVY_11_HA_SET_B_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_HEAVY_11_SA_SET_B_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_HEAVY_11_BA_SET_B_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_HEAVY_11_LA_SET_B_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_HEAVY_11_FA_SET_B_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_HEAVY_11_AA_SET_B_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_RING_11_SET_B_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_RING_11_SET_B_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_EARRING_11_SET_B_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_NECKLACE_11_SET_B_RARE',1,18


5- Euro Female Rope

USE SRO_VT_SHARD
--Usage:
--exec _ADD_ITEM_EXTERN 'CharName','ItemsCodeName',Count,OptLvl
declare @CharName varchar(64)

set @CharName = 'Name'

exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_TSTAFF_11_SET_B_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_TSWORD_11_SET_B_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_DAGGER_11_SET_B_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_STAFF_11_SET_B_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_SHIELD_11_SET_B_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_SWORD_11_SET_B_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_AXE_11_SET_B_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_HARP_11_SET_B_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_CROSSBOW_11_SET_B_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_DARKSTAFF_11_SET_B_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_CLOTHES_11_HA_SET_B_RARE',1,1 8
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_CLOTHES_11_BA_SET_B_RARE',1,1 8
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_CLOTHES_11_LA_SET_B_RARE',1,1 8
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_CLOTHES_11_SA_SET_B_RARE',1,1 8
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_CLOTHES_11_AA_SET_B_RARE',1,1 8
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_CLOTHES_11_FA_SET_B_RARE',1,1 8
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_RING_11_SET_B_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_RING_11_SET_B_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_EARRING_11_SET_B_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_NECKLACE_11_SET_B_RARE',1,18


6- Euro Male Rope

USE SRO_VT_SHARD
--Usage:
--exec _ADD_ITEM_EXTERN 'CharName','ItemsCodeName',Count,OptLvl
declare @CharName varchar(64)

set @CharName = 'Name'

exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_TSTAFF_11_SET_B_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_TSWORD_11_SET_B_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_DAGGER_11_SET_B_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_STAFF_11_SET_B_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_SHIELD_11_SET_B_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_SWORD_11_SET_B_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_AXE_11_SET_B_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_HARP_11_SET_B_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_CROSSBOW_11_SET_B_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_DARKSTAFF_11_SET_B_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_M_CLOTHES_11_HA_SET_B_RARE',1,1 8
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_M_CLOTHES_11_BA_SET_B_RARE',1,1 8
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_M_CLOTHES_11_LA_SET_B_RARE',1,1 8
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_M_CLOTHES_11_SA_SET_B_RARE',1,1 8
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_M_CLOTHES_11_AA_SET_B_RARE',1,1 8
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_M_CLOTHES_11_FA_SET_B_RARE',1,1 8
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_RING_11_SET_B_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_RING_11_SET_B_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_EARRING_11_SET_B_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_NECKLACE_11_SET_B_RARE',1,18


7- Cgina Male Germant

USE SRO_VT_SHARD
--Usage:
--exec _ADD_ITEM_EXTERN 'CharName','ItemsCodeName',Count,OptLvl
declare @CharName varchar(64)

set @CharName = 'Name'

exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_SPEAR_11_SET_B_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_BOW_11_SET_B_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_TBLADE_11_SET_B_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_SWORD_11_SET_B_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_BLADE_11_SET_B_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_SHIELD_11_SET_B_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_M_CLOTHES_11_HA_SET_B_RARE',1,1 8
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_M_CLOTHES_11_SA_SET_B_RARE',1,1 8
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_M_CLOTHES_11_BA_SET_B_RARE',1,1 8
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_M_CLOTHES_11_LA_SET_B_RARE',1,1 8
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_M_CLOTHES_11_FA_SET_B_RARE',1,1 8
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_M_CLOTHES_11_AA_SET_B_RARE',1,1 8
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_RING_11_SET_B_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_RING_11_SET_B_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_EARRING_11_SET_B_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_NECKLACE_11_SET_B_RARE',1,18


8- Cgina Female Germant

USE SRO_VT_SHARD
--Usage:
--exec _ADD_ITEM_EXTERN 'CharName','ItemsCodeName',Count,OptLvl
declare @CharName varchar(64)

set @CharName = 'Name'

exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_SPEAR_11_SET_B_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_BOW_11_SET_B_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_TBLADE_11_SET_B_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_SWORD_11_SET_B_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_BLADE_11_SET_B_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_SHIELD_11_SET_B_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_W_CLOTHES_11_HA_SET_B_RARE',1,1 8
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_W_CLOTHES_11_SA_SET_B_RARE',1,1 8
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_W_CLOTHES_11_BA_SET_B_RARE',1,1 8
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_W_CLOTHES_11_LA_SET_B_RARE',1,1 8
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_W_CLOTHES_11_FA_SET_B_RARE',1,1 8
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_W_CLOTHES_11_AA_SET_B_RARE',1,1 8
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_RING_11_SET_B_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_RING_11_SET_B_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_EARRING_11_SET_B_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_NECKLACE_11_SET_B_RARE',1,18


9- Cgina Male Protector

USE SRO_VT_SHARD
--Usage:
--exec _ADD_ITEM_EXTERN 'CharName','ItemsCodeName',Count,OptLvl
declare @CharName varchar(64)

set @CharName = 'Name'

exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_SPEAR_11_SET_B_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_BOW_11_SET_B_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_TBLADE_11_SET_B_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_SWORD_11_SET_B_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_BLADE_11_SET_B_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_SHIELD_11_SET_B_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_M_LIGHT_11_HA_SET_B_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_M_LIGHT_11_SA_SET_B_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_M_LIGHT_11_BA_SET_B_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_M_LIGHT_11_LA_SET_B_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_M_LIGHT_11_FA_SET_B_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_M_LIGHT_11_AA_SET_B_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_RING_11_SET_B_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_RING_11_SET_B_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_EARRING_11_SET_B_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_NECKLACE_11_SET_B_RARE',1,18


10- Cgina Female Protector

USE SRO_VT_SHARD
--Usage:
--exec _ADD_ITEM_EXTERN 'CharName','ItemsCodeName',Count,OptLvl
declare @CharName varchar(64)

set @CharName = 'Name'

exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_SPEAR_11_SET_B_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_BOW_11_SET_B_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_TBLADE_11_SET_B_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_SWORD_11_SET_B_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_BLADE_11_SET_B_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_SHIELD_11_SET_B_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_W_LIGHT_11_HA_SET_B_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_W_LIGHT_11_SA_SET_B_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_W_LIGHT_11_BA_SET_B_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_W_LIGHT_11_LA_SET_B_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_W_LIGHT_11_FA_SET_B_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_W_LIGHT_11_AA_SET_B_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_RING_11_SET_B_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_RING_11_SET_B_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_EARRING_11_SET_B_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_NECKLACE_11_SET_B_RARE',1,18


11- Cgina Male Armor

USE SRO_VT_SHARD
--Usage:
--exec _ADD_ITEM_EXTERN 'CharName','ItemsCodeName',Count,OptLvl
declare @CharName varchar(64)

set @CharName = 'Name'

exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_SPEAR_11_SET_B_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_BOW_11_SET_B_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_TBLADE_11_SET_B_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_SWORD_11_SET_B_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_BLADE_11_SET_B_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_SHIELD_11_SET_B_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_M_HEAVY_11_HA_SET_B_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_M_HEAVY_11_SA_SET_B_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_M_HEAVY_11_BA_SET_B_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_M_HEAVY_11_LA_SET_B_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_M_HEAVY_11_FA_SET_B_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_M_HEAVY_11_AA_SET_B_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_RING_11_SET_B_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_RING_11_SET_B_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_EARRING_11_SET_B_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_NECKLACE_11_SET_B_RARE',1,18


12- Cgina Female Armor

USE SRO_VT_SHARD
--Usage:
--exec _ADD_ITEM_EXTERN 'CharName','ItemsCodeName',Count,OptLvl
declare @CharName varchar(64)

set @CharName = 'Name'

exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_SPEAR_11_SET_B_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_BOW_11_SET_B_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_TBLADE_11_SET_B_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_SWORD_11_SET_B_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_BLADE_11_SET_B_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_SHIELD_11_SET_B_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_W_HEAVY_11_HA_SET_B_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_W_HEAVY_11_SA_SET_B_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_W_HEAVY_11_BA_SET_B_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_W_HEAVY_11_LA_SET_B_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_W_HEAVY_11_FA_SET_B_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_W_HEAVY_11_AA_SET_B_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_RING_11_SET_B_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_RING_11_SET_B_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_EARRING_11_SET_B_RARE',1,18
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_NECKLACE_11_SET_B_RARE',1,18






أتمنى أن أكون افتكم

http://www.dev-point.com/vb/imagize/smilies/r7.gif

Hamza FiGo
20-04-2016, 11:24 PM
عاش يا كبير تسلم الايادي ^^ فية سيستم موجود في داتا كنت استخدمتها مكنش البلاص عايز يطلع عن 12 ولو بالطبل البلدي. كدة انا عرفت لية.. تسلم

اللي نفسي اتعلمه موضوع الفلاش دا. هيجنني :idiot:

Mr.Viper
21-04-2016, 12:36 AM
عاش يا كبير تسلم الايادي ^^ فية سيستم موجود في داتا كنت استخدمتها مكنش البلاص عايز يطلع عن 12 ولو بالطبل البلدي. كدة انا عرفت لية.. تسلم

اللي نفسي اتعلمه موضوع الفلاش دا. هيجنني :idiot:


شكرا ع الموافقة حبيبى

Dev.BigBear
21-04-2016, 12:38 AM
عاش تسلم ايدك :clapping:

Mr.Viper
21-04-2016, 03:48 AM
عاش تسلم ايدك :clapping:

Ty

HLP
21-04-2016, 07:48 AM
تسلم

elbattawy1st
21-04-2016, 10:41 AM
تسلم ايديك ^_^

MR.KaBO
21-04-2016, 12:51 PM
احلا تقييم :mf_doof:يا معلم تسلم والله ده كنت مستنيه من زمان استمر :vibrate:

Dev.Ri3o
22-04-2016, 12:48 PM
برنس الموضوع ده هيفيد ناس كتير خصوصا الناس اللى بتشحن اسلحة +25 فى اللعبة بتاعتها
تسلم ايدك

Blizzard
24-04-2016, 05:39 AM
لو فى اى حد وجهتو مشكلة بعد ما طبق الشرح
فى حاجة تانى اسمها




















































Max Plus System










































Go to SRO_VT_SHARDLOG>>Programmability>>Stored Procedures>>_AddLogChar




















































هتلاقي البرسيدور بالشكلده



































































































































update SRO_VT_SHARD.dbo._Items set OptLevel =20 where optlevel >20
او بالشكل ده













































































if @EventID in (4,6,9) begin update SRO_VT_SHARD.dbo._Items set OptLevel=12 where OptLevel in (13,14,15,16,17) end














































































































امسحوواعمل Execute













































































































































































طيب انا دلوقتى مش عندى فى SRO_VT_SHARD.dbo

Procedures

ده وانا عاوز اعمله علشان االبلير متعرفش تطلع اكتر من 25 مثلا لو جاب 25 من غير ADV يكتبله Plus Limited ياريت تقولى اعملها ازاى

PirateKings
24-04-2016, 06:24 AM
موضوع ممتاز و نتسيق ممتاز

Mr.Viper
25-04-2016, 01:04 PM
شكرا على ردودكم وتعليقاتكم ♥

Mr.Viper
25-04-2016, 01:14 PM
لو فى اى حد وجهتو مشكلة بعد ما طبق الشرح
فى حاجة تانى اسمها

Max Plus System








Go to SRO_VT_SHARDLOG>>Programmability>>Stored Procedures>>_AddLogChar

هتلاقي البرسيدور بالشكل
ده

update SRO_VT_SHARD.dbo._Items set OptLevel =20 where optlevel >20او بالشكل ده







if @EventID in (4,6,9) begin update SRO_VT_SHARD.dbo._Items set OptLevel=12 where OptLevel in (13,14,15,16,17) endامسحوواعمل Execute



طيب انا دلوقتى مش عندى فى SRO_VT_SHARD.dbo

Procedures

ده وانا عاوز اعمله علشان االبلير متعرفش تطلع اكتر من 25 مثلا لو جاب 25 من غير ADV يكتبله Plus Limited ياريت تقولى اعملها ازاى




البرسيدور ده مش بيتعمل فى ال SRO_VT_SHARD
ده بيتعمل فى SRO_VT_SHARDLOG

وده المسار

Go to SRO_VT_SHARDLOG>>Programmability>>Stored Procedures>>_AddLogChar

اختار برسيدور من الاتنين الـ فى الموضوع
بعدين هتفتح
AddLogChar
هتضيف البرسيدور وتعمل
Execute

يعنى مثلا لو عايز الماكس بلص فى الجيم +25
البرسيدور هيكون بالشكل ده
اتفضل

update SRO_VT_SHARD.dbo._Items set OptLevel=25 where optlevel >25

Dev.LumiusCux
26-04-2016, 09:17 PM
بجد تسلم واللهي تسلم ايدك

ahmedzizoa
21-02-2017, 01:27 PM
thx
:unsure:

MORJANA
24-02-2017, 09:54 PM
عـــــاش يا بطل تسلم إيدك والله معلم :birgits_tiredcoffee

™Kabloz
08-03-2017, 01:16 AM
update SRO_VT_SHARD.dbo._Items set OptLevel =20 where optlevel >20

او بالشكل ده




كود PHP:
if @EventID in (4,6,9)
begin
update SRO_VT_SHARD.dbo._Items set OptLevel=12 where OptLevel in (13,14,15,16,17)
end


طـب لو مفيش دوول ؟