1/01/2023

26/03/2024_kh

01/12/2021

khaled_flare

02/06/2022_hema

29/05/2022_fareed

fareed_02/02/2024

END_shaher_08/02/2024

29_02_2023

Ah_k_n_06_08_2023

END_tusk_04/01/2024

hossam_02_03_2023

END_vista_04/03/2024

END 14/4/2024

END 20/03/2024_9699

END_26/04/2024

END 3/04/2024

Kamal_Kahraba-END 12/04/2024

-END 17/04/2024

25/01/2022

QueenSro

06_08_2023_Ah_k_n

END_tusk_04/01/2024

9699_20_03_2024

END_Ibrahim_Abde_05/02/2024

END14/4/2024

END_14/04/2024

END_26/04/2024

END 3/04/2024

END golden_17/04/2024

 الـجـروب الـرسـمى لـلـمـنـتـدى FaceBook | Official Group 


شـريـط الاهـداءات


قسم الشروحات و البرامج المستخدمة في عمل السيرفرات الخاصة [ قسم متخصص فى شروحات و البرامج في عمل السيرفرات الخاصة ] [ يرجى عدم وضع الأسئلة والاستفسارات في هذا القسم ]

إضافة رد
قديم 28-12-2015, 01:37 PM   #1

HLP
عضو فعال



الصورة الرمزية HLP


• الانـتـسـاب » Mar 2013
• رقـم العـضـويـة » 110603
• المشـــاركـات » 352
• الـدولـة » Hurghada
• الـهـوايـة » DeveloP AnyThing
• اسـم الـسـيـرفـر » Private Server
• الـجـنـس » Male
• نقـاط التقييم » 14
HLP صـاعـد

HLP غير متواجد حالياً

401  


إرسال رسالة عبر Skype إلى HLP

افتراضي Scroll CH&EU change Weapon & Set



السلام عليكم
Scroll CH&EU change Weapon & Set to any weapon or Set
النهاردة انا عامل موضوع جديد ممكن يفيد ناس كتير المهم
سكرول ده بيبدل اي سلاح صيني او اوربي لسلاح تاني حسب السكرول يعني كل سلاح بسكرول و نفس الكلام مع اللبس و لازم الاعب يكون ماسك السلاح في سكرول السلاح و نفس الكلام مع set
ملاحظة الصيني بيبدل صيني و نفس الكلام مع الاروبي بنفس + و stats
ندخل علي المهم
Database lines

_RefObjCommon

كود PHP:
1    42099    ITEM_CHANGE_WPN_CH_SWORD    ?????    xxx    SN_ITEM_CHANGE_WPN_CH_SWORD    SN_ITEM_CHANGE_WPN_CH_SWORD_TT_DESC    1    0    3    3    3    1    180000    3    0    1    1    1    255    0    1    0    0    1    0    0    0    0    0    0    0    -1    0    -1    0    -1    0    -1    0    -1    0    0    0    0    0    0    0    100    0    0    0    xxx    item\etc\drop_mall_scroll.bsr    item\trade\hunter\sword_14.ddj    xxx    xxx    21515
1    42100    ITEM_CHANGE_WPN_CH_BLADE    
?????    xxx    SN_ITEM_CHANGE_WPN_CH_BLADE    SN_ITEM_CHANGE_WPN_CH_BLADE_TT_DESC    1    0    3    3    3    1    180000    3    0    1    1    1    255    0    1    0    0    1    0    0    0    0    0    0    0    -1    0    -1    0    -1    0    -1    0    -1    0    0    0    0    0    0    0    100    0    0    0    xxx    item\etc\drop_mall_scroll.bsr    item\trade\hunter\blade_14.ddj    xxx    xxx    21516
1    42101    ITEM_CHANGE_WPN_CH_SPEAR    
?????    xxx    SN_ITEM_CHANGE_WPN_CH_SPEAR    SN_ITEM_CHANGE_WPN_CH_SPEAR_TT_DESC    1    0    3    3    3    1    180000    3    0    1    1    1    255    0    1    0    0    1    0    0    0    0    0    0    0    -1    0    -1    0    -1    0    -1    0    -1    0    0    0    0    0    0    0    100    0    0    0    xxx    item\etc\drop_mall_scroll.bsr    item\trade\hunter\spear_14.ddj    xxx    xxx    21517
1    42102    ITEM_CHANGE_WPN_CH_GLAIVE    
?????    xxx    SN_ITEM_CHANGE_WPN_CH_GLAIVE    SN_ITEM_CHANGE_WPN_CH_GLAIVE_TT_DESC    1    0    3    3    3    1    180000    3    0    1    1    1    255    0    1    0    0    1    0    0    0    0    0    0    0    -1    0    -1    0    -1    0    -1    0    -1    0    0    0    0    0    0    0    100    0    0    0    xxx    item\etc\drop_mall_scroll.bsr    item\trade\hunter\tblade_14.ddj    xxx    xxx    21518
1    42103    ITEM_CHANGE_WPN_CH_BOW    
?????    xxx    SN_ITEM_CHANGE_WPN_CH_BOW    SN_ITEM_CHANGE_WPN_CH_BOW_TT_DESC    1    0    3    3    3    1    180000    3    0    1    1    1    255    0    1    0    0    1    0    0    0    0    0    0    0    -1    0    -1    0    -1    0    -1    0    -1    0    0    0    0    0    0    0    100    0    0    0    xxx    item\etc\drop_mall_scroll.bsr    item\trade\hunter\bow_14.ddj    xxx    xxx    21519
1    42104    ITEM_CHANGE_SET_CH_ARMOR    
?????    xxx    SN_ITEM_CHANGE_SET_CH_ARMOR    SN_ITEM_CHANGE_SET_CH_ARMOR_TT_DESC    1    0    3    3    3    1    180000    3    0    1    1    1    255    0    1    0    0    1    0    0    0    0    0    0    0    -1    0    -1    0    -1    0    -1    0    -1    0    0    0    0    0    0    0    100    0    0    0    xxx    item\etc\drop_mall_scroll.bsr    item\trade\hunter\armor_test.ddj    xxx    xxx    21520
1    42105    ITEM_CHANGE_SET_CH_PRO    
?????    xxx    SN_ITEM_CHANGE_SET_CH_PRO    SN_ITEM_CHANGE_SET_CH_PRO_TT_DESC    1    0    3    3    3    1    180000    3    0    1    1    1    255    0    1    0    0    1    0    0    0    0    0    0    0    -1    0    -1    0    -1    0    -1    0    -1    0    0    0    0    0    0    0    100    0    0    0    xxx    item\etc\drop_mall_scroll.bsr    item\trade\hunter\armor_test.ddj    xxx    xxx    21521
1    42106    ITEM_CHANGE_SET_CH_GRAMENT    
?????    xxx    SN_ITEM_CHANGE_SET_CH_GRAMENT    SN_ITEM_CHANGE_SET_CH_GRAMENT_TT_DESC    1    0    3    3    3    1    180000    3    0    1    1    1    255    0    1    0    0    1    0    0    0    0    0    0    0    -1    0    -1    0    -1    0    -1    0    -1    0    0    0    0    0    0    0    100    0    0    0    xxx    item\etc\drop_mall_scroll.bsr    item\trade\hunter\armor_test.ddj    xxx    xxx    21522
1    42107    ITEM_CHANGE_WPN_EU_DAGGER    
?????    xxx    SN_ITEM_CHANGE_WPN_EU_DAGGER    SN_ITEM_CHANGE_WPN_EU_DAGGER_TT_DESC    1    0    3    3    3    1    180000    3    0    1    1    1    255    0    1    0    0    1    0    0    0    0    0    0    0    -1    0    -1    0    -1    0    -1    0    -1    0    0    0    0    0    0    0    100    0    0    0    xxx    item\etc\drop_mall_scroll.bsr    item\trade\hunter\dagger_14.ddj    xxx    xxx    21523
1    42108    ITEM_CHANGE_WPN_EU_XBOW    
?????    xxx    SN_ITEM_CHANGE_WPN_EU_XBOW    SN_ITEM_CHANGE_WPN_EU_XBOW_TT_DESC    1    0    3    3    3    1    180000    3    0    1    1    1    255    0    1    0    0    1    0    0    0    0    0    0    0    -1    0    -1    0    -1    0    -1    0    -1    0    0    0    0    0    0    0    100    0    0    0    xxx    item\etc\drop_mall_scroll.bsr    item\trade\hunter\crossbow_14.ddj    xxx    xxx    21524
1    42109    ITEM_CHANGE_WPN_EU_AXE    
?????    xxx    SN_ITEM_CHANGE_WPN_EU_AXE    SN_ITEM_CHANGE_WPN_EU_AXE_TT_DESC    1    0    3    3    3    1    180000    3    0    1    1    1    255    0    1    0    0    1    0    0    0    0    0    0    0    -1    0    -1    0    -1    0    -1    0    -1    0    0    0    0    0    0    0    100    0    0    0    xxx    item\etc\drop_mall_scroll.bsr    item\trade\hunter\axe_14.ddj    xxx    xxx    21525
1    42110    ITEM_CHANGE_WPN_EU_SWORD    
?????    xxx    SN_ITEM_CHANGE_WPN_EU_SWORD    SN_ITEM_CHANGE_WPN_EU_SWORD_TT_DESC    1    0    3    3    3    1    180000    3    0    1    1    1    255    0    1    0    0    1    0    0    0    0    0    0    0    -1    0    -1    0    -1    0    -1    0    -1    0    0    0    0    0    0    0    100    0    0    0    xxx    item\etc\drop_mall_scroll.bsr    item\trade\hunter\esword_14.ddj    xxx    xxx    21526
1    42111    ITEM_CHANGE_WPN_EU_TSWORD    
?????    xxx    SN_ITEM_CHANGE_WPN_EU_TSWORD    SN_ITEM_CHANGE_WPN_EU_TSWORD_TT_DESC    1    0    3    3    3    1    180000    3    0    1    1    1    255    0    1    0    0    1    0    0    0    0    0    0    0    -1    0    -1    0    -1    0    -1    0    -1    0    0    0    0    0    0    0    100    0    0    0    xxx    item\etc\drop_mall_scroll.bsr    item\trade\hunter\tsword_14.ddj    xxx    xxx    21527
1    42112    ITEM_CHANGE_WPN_EU_TSTAFF    
?????    xxx    SN_ITEM_CHANGE_WPN_EU_TSTAFF    SN_ITEM_CHANGE_WPN_EU_TSTAFF_TT_DESC    1    0    3    3    3    1    180000    3    0    1    1    1    255    0    1    0    0    1    0    0    0    0    0    0    0    -1    0    -1    0    -1    0    -1    0    -1    0    0    0    0    0    0    0    100    0    0    0    xxx    item\etc\drop_mall_scroll.bsr    item\trade\hunter\tstaff_14.ddj    xxx    xxx    21528
1    42113    ITEM_CHANGE_WPN_EU_STAFF    
?????    xxx    SN_ITEM_CHANGE_WPN_EU_STAFF    SN_ITEM_CHANGE_WPN_EU_STAFF_TT_DESC    1    0    3    3    3    1    180000    3    0    1    1    1    255    0    1    0    0    1    0    0    0    0    0    0    0    -1    0    -1    0    -1    0    -1    0    -1    0    0    0    0    0    0    0    100    0    0    0    xxx    item\etc\drop_mall_scroll.bsr    item\trade\hunter\staff_14.ddj    xxx    xxx    21529
1    42114    ITEM_CHANGE_WPN_EU_DSTAFF    
?????    xxx    SN_ITEM_CHANGE_WPN_EU_DSTAFF    SN_ITEM_CHANGE_WPN_EU_DSTAFF_TT_DESC    1    0    3    3    3    1    180000    3    0    1    1    1    255    0    1    0    0    1    0    0    0    0    0    0    0    -1    0    -1    0    -1    0    -1    0    -1    0    0    0    0    0    0    0    100    0    0    0    xxx    item\etc\drop_mall_scroll.bsr    item\trade\hunter\darkstaff_14.ddj    xxx    xxx    21530
1    42115    ITEM_CHANGE_WPN_EU_HARP    
?????    xxx    SN_ITEM_CHANGE_WPN_EU_HARP    SN_ITEM_CHANGE_WPN_EU_HARP_TT_DESC    1    0    3    3    3    1    180000    3    0    1    1    1    255    0    1    0    0    1    0    0    0    0    0    0    0    -1    0    -1    0    -1    0    -1    0    -1    0    0    0    0    0    0    0    100    0    0    0    xxx    item\etc\drop_mall_scroll.bsr    item\trade\hunter\harp_14.ddj    xxx    xxx    21531
1    42116    ITEM_CHANGE_SET_EU_HA    
?????    xxx    SN_ITEM_CHANGE_SET_EU_HA    SN_ITEM_CHANGE_SET_EU_HA_TT_DESC    1    0    3    3    3    1    180000    3    0    1    1    1    255    0    1    0    0    1    0    0    0    0    0    0    0    -1    0    -1    0    -1    0    -1    0    -1    0    0    0    0    0    0    0    100    0    0    0    xxx    item\etc\drop_mall_scroll.bsr    item\trade\hunter\armor_test.ddj    xxx    xxx    21532
1    42117    ITEM_CHANGE_SET_EU_LA    
?????    xxx    SN_ITEM_CHANGE_SET_EU_LA    SN_ITEM_CHANGE_SET_EU_LA_TT_DESC    1    0    3    3    3    1    180000    3    0    1    1    1    255    0    1    0    0    1    0    0    0    0    0    0    0    -1    0    -1    0    -1    0    -1    0    -1    0    0    0    0    0    0    0    100    0    0    0    xxx    item\etc\drop_mall_scroll.bsr    item\trade\hunter\armor_test.ddj    xxx    xxx    21533
1    42118    ITEM_CHANGE_SET_EU_ROBE    
?????    xxx    SN_ITEM_CHANGE_SET_EU_ROBE    SN_ITEM_CHANGE_SET_EU_ROBE_TT_DESC    1    0    3    3    3    1    180000    3    0    1    1    1    255    0    1    0    0    1    0    0    0    0    0    0    0    -1    0    -1    0    -1    0    -1    0    -1    0    0    0    0    0    0    0    100    0    0    0    xxx    item\etc\drop_mall_scroll.bsr    item\trade\hunter\armor_test.ddj    xxx    xxx    21534 
_RefObjItem

كود PHP:
21515    1    2    0    0    1    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    1000    ????    1    ??????    -1    RESURRECT    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    0    0    0
21516    1    2    0    0    1    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    1000    
????    1    ??????    -1    RESURRECT    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    0    0    0
21517    1    2    0    0    1    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    1000    
????    1    ??????    -1    RESURRECT    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    0    0    0
21518    1    2    0    0    1    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    1000    
????    1    ??????    -1    RESURRECT    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    0    0    0
21519    1    2    0    0    1    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    1000    
????    1    ??????    -1    RESURRECT    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    0    0    0
21520    1    2    0    0    1    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    1000    
????    1    ??????    -1    RESURRECT    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    0    0    0
21521    1    2    0    0    1    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    1000    
????    1    ??????    -1    RESURRECT    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    0    0    0
21522    1    2    0    0    1    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    1000    
????    1    ??????    -1    RESURRECT    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    0    0    0
21523    1    2    0    0    1    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    1000    
????    1    ??????    -1    RESURRECT    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    0    0    0
21524    1    2    0    0    1    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    1000    
????    1    ??????    -1    RESURRECT    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    0    0    0
21525    1    2    0    0    1    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    1000    
????    1    ??????    -1    RESURRECT    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    0    0    0
21526    1    2    0    0    1    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    1000    
????    1    ??????    -1    RESURRECT    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    0    0    0
21527    1    2    0    0    1    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    1000    
????    1    ??????    -1    RESURRECT    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    0    0    0
21528    1    2    0    0    1    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    1000    
????    1    ??????    -1    RESURRECT    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    0    0    0
21529    1    2    0    0    1    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    1000    
????    1    ??????    -1    RESURRECT    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    0    0    0
21530    1    2    0    0    1    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    1000    
????    1    ??????    -1    RESURRECT    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    0    0    0
21531    1    2    0    0    1    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    1000    
????    1    ??????    -1    RESURRECT    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    0    0    0
21532    1    2    0    0    1    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    1000    
????    1    ??????    -1    RESURRECT    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    0    0    0
21533    1    2    0    0    1    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    1000    
????    1    ??????    -1    RESURRECT    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    0    0    0
21534    1    2    0    0    1    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    1000    
????    1    ??????    -1    RESURRECT    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    0    0    0 
ده احسن حاجة وصلت ليه في البرسيدور

Create Procedure



كود PHP:
USE [SRO_VT_SHARDLOG]
GO
/****** Object:  StoredProcedure [dbo].[_ChangeSystemH.A]    Script Date: 12/29/2015 09:36:45 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

create PROCEDURE 
[dbo].[_ChangeSystemH.A]
 @
CharID   Int
  
As
--- 
CH Eu H.A Set
       Update SRO_VT_SHARD
.._Items Set RefItemID='39495',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot '0' and ItemID 0) and RefItemID in (39621,39642,39663,39684,39705,39726,39747,39768,39789,39810,39831,39852
       
Update SRO_VT_SHARD.._Items Set RefItemID='39516',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot '2' and ItemID 0) and RefItemID in (39621,39642,39663,39684,39705,39726,39747,39768,39789,39810,39831,39852
       
Update SRO_VT_SHARD.._Items Set RefItemID='39537',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot '1' and ItemID 0) and RefItemID in (39621,39642,39663,39684,39705,39726,39747,39768,39789,39810,39831,39852
       
Update SRO_VT_SHARD.._Items Set RefItemID='39558',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot '4' and ItemID 0) and RefItemID in (39621,39642,39663,39684,39705,39726,39747,39768,39789,39810,39831,39852
       
Update SRO_VT_SHARD.._Items Set RefItemID='39579',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot '3' and ItemID 0) and RefItemID in (39621,39642,39663,39684,39705,39726,39747,39768,39789,39810,39831,39852
       
Update SRO_VT_SHARD.._Items Set RefItemID='39600',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot '5' and ItemID 0) and RefItemID in (39621,39642,39663,39684,39705,39726,39747,39768,39789,39810,39831,39852)      
       
Update SRO_VT_SHARD.._Items Set RefItemID='39873',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot '0' and ItemID 0) and RefItemID in (39999,40020,40041,40062,40083,40104,40125,40146,40167,40188,40209,40230
       
Update SRO_VT_SHARD.._Items Set RefItemID='39894',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot '2' and ItemID 0) and RefItemID in (39999,40020,40041,40062,40083,40104,40125,40146,40167,40188,40209,40230
       
Update SRO_VT_SHARD.._Items Set RefItemID='39915',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot '1' and ItemID 0) and RefItemID in (39999,40020,40041,40062,40083,40104,40125,40146,40167,40188,40209,40230
       
Update SRO_VT_SHARD.._Items Set RefItemID='39936',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot '4' and ItemID 0) and RefItemID in (39999,40020,40041,40062,40083,40104,40125,40146,40167,40188,40209,40230
       
Update SRO_VT_SHARD.._Items Set RefItemID='39957',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot '3' and ItemID 0) and RefItemID in (39999,40020,40041,40062,40083,40104,40125,40146,40167,40188,40209,40230
       
Update SRO_VT_SHARD.._Items Set RefItemID='39978',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot '5' and ItemID 0) and RefItemID in (39999,40020,40041,40062,40083,40104,40125,40146,40167,40188,40209,40230)      
       
Update SRO_VT_SHARD.._Items Set RefItemID='40524',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot '0' and ItemID 0) and RefItemID in (40776,40797,40818,40839,40860,40881,40650,40671,40692,40713,40734,40755
       
Update SRO_VT_SHARD.._Items Set RefItemID='40545',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot '2' and ItemID 0) and RefItemID in (40776,40797,40818,40839,40860,40881,40650,40671,40692,40713,40734,40755
       
Update SRO_VT_SHARD.._Items Set RefItemID='40566',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot '1' and ItemID 0) and RefItemID in (40776,40797,40818,40839,40860,40881,40650,40671,40692,40713,40734,40755
       
Update SRO_VT_SHARD.._Items Set RefItemID='40587',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot '4' and ItemID 0) and RefItemID in (40776,40797,40818,40839,40860,40881,40650,40671,40692,40713,40734,40755
       
Update SRO_VT_SHARD.._Items Set RefItemID='40608',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot '3' and ItemID 0) and RefItemID in (40776,40797,40818,40839,40860,40881,40650,40671,40692,40713,40734,40755
       
Update SRO_VT_SHARD.._Items Set RefItemID='40629',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot '5' and ItemID 0) and RefItemID in (40776,40797,40818,40839,40860,40881,40650,40671,40692,40713,40734,40755)      
       
Update SRO_VT_SHARD.._Items Set RefItemID='40902',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot '0' and ItemID 0) and RefItemID in (41154,41175,41196,41217,41238,41259,41028,41049,41070,41091,41112,41133
       
Update SRO_VT_SHARD.._Items Set RefItemID='40923',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot '2' and ItemID 0) and RefItemID in (41154,41175,41196,41217,41238,41259,41028,41049,41070,41091,41112,41133
       
Update SRO_VT_SHARD.._Items Set RefItemID='40944',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot '1' and ItemID 0) and RefItemID in (41154,41175,41196,41217,41238,41259,41028,41049,41070,41091,41112,41133
       
Update SRO_VT_SHARD.._Items Set RefItemID='40965',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot '4' and ItemID 0) and RefItemID in (41154,41175,41196,41217,41238,41259,41028,41049,41070,41091,41112,41133
       
Update SRO_VT_SHARD.._Items Set RefItemID='40986',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot '3' and ItemID 0) and RefItemID in (41154,41175,41196,41217,41238,41259,41028,41049,41070,41091,41112,41133
       
Update SRO_VT_SHARD.._Items Set RefItemID='41007',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot '5' and ItemID 0) and RefItemID in (41154,41175,41196,41217,41238,41259,41028,41049,41070,41091,41112,41133
Create Procedure


كود PHP:
USE [SRO_VT_SHARDLOG]
GO
/****** Object:  StoredProcedure [dbo].[_ChangeSystemL.A]    Script Date: 12/29/2015 09:37:02 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

create PROCEDURE 
[dbo].[_ChangeSystemL.A]
 @
CharID   Int
  
As
--- 
CH Eu L.A Set
       Update SRO_VT_SHARD
.._Items Set RefItemID='39621',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot '0' and ItemID 0) and RefItemID in (39495,39516,39537,39558,39579,39600,39747,39768,39789,39810,39831,39852)
       
Update SRO_VT_SHARD.._Items Set RefItemID='39642',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot '2' and ItemID 0) and RefItemID in (39495,39516,39537,39558,39579,39600,39747,39768,39789,39810,39831,39852
       
Update SRO_VT_SHARD.._Items Set RefItemID='39663',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot '1' and ItemID 0) and RefItemID in (39495,39516,39537,39558,39579,39600,39747,39768,39789,39810,39831,39852
       
Update SRO_VT_SHARD.._Items Set RefItemID='39684',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot '4' and ItemID 0) and RefItemID in (39495,39516,39537,39558,39579,39600,39747,39768,39789,39810,39831,39852
       
Update SRO_VT_SHARD.._Items Set RefItemID='39705',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot '3' and ItemID 0) and RefItemID in (39495,39516,39537,39558,39579,39600,39747,39768,39789,39810,39831,39852
       
Update SRO_VT_SHARD.._Items Set RefItemID='39726',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot '5' and ItemID 0) and RefItemID in (39495,39516,39537,39558,39579,39600,39747,39768,39789,39810,39831,39852)      
       
Update SRO_VT_SHARD.._Items Set RefItemID='39999',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot '0' and ItemID 0) and RefItemID in (40125,40146,40167,40188,40209,40230,39873,39894,39915,39936,39957,39978
       
Update SRO_VT_SHARD.._Items Set RefItemID='40020',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot '2' and ItemID 0) and RefItemID in (40125,40146,40167,40188,40209,40230,39873,39894,39915,39936,39957,39978)
       
Update SRO_VT_SHARD.._Items Set RefItemID='40041',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot '1' and ItemID 0) and RefItemID in (40125,40146,40167,40188,40209,40230,39873,39894,39915,39936,39957,39978)
       
Update SRO_VT_SHARD.._Items Set RefItemID='40062',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot '4' and ItemID 0) and RefItemID in (40125,40146,40167,40188,40209,40230,39873,39894,39915,39936,39957,39978)
       
Update SRO_VT_SHARD.._Items Set RefItemID='40083',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot '3' and ItemID 0) and RefItemID in (40125,40146,40167,40188,40209,40230,39873,39894,39915,39936,39957,39978)
       
Update SRO_VT_SHARD.._Items Set RefItemID='40104',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot '5' and ItemID 0) and RefItemID in (40125,40146,40167,40188,40209,40230,39873,39894,39915,39936,39957,39978)
       
Update SRO_VT_SHARD.._Items Set RefItemID='40650',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot '0' and ItemID 0) and RefItemID in (40524,40545,40566,40587,40608,40629,40776,40797,40818,40839,40860,40881)
       
Update SRO_VT_SHARD.._Items Set RefItemID='40671',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot '2' and ItemID 0) and RefItemID in (40524,40545,40566,40587,40608,40629,40776,40797,40818,40839,40860,40881
       
Update SRO_VT_SHARD.._Items Set RefItemID='40692',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot '1' and ItemID 0) and RefItemID in (40524,40545,40566,40587,40608,40629,40776,40797,40818,40839,40860,40881
       
Update SRO_VT_SHARD.._Items Set RefItemID='40713',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot '4' and ItemID 0) and RefItemID in (40524,40545,40566,40587,40608,40629,40776,40797,40818,40839,40860,40881
       
Update SRO_VT_SHARD.._Items Set RefItemID='40734',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot '3' and ItemID 0) and RefItemID in (40524,40545,40566,40587,40608,40629,40776,40797,40818,40839,40860,40881
       
Update SRO_VT_SHARD.._Items Set RefItemID='40755',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot '5' and ItemID 0) and RefItemID in (40524,40545,40566,40587,40608,40629,40776,40797,40818,40839,40860,40881)      
       
Update SRO_VT_SHARD.._Items Set RefItemID='41028',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot '0' and ItemID 0) and RefItemID in (40902,40923,40944,40965,40986,41007,41154,41175,41196,41217,41238,41259
       
Update SRO_VT_SHARD.._Items Set RefItemID='41049',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot '2' and ItemID 0) and RefItemID in (40902,40923,40944,40965,40986,41007,41154,41175,41196,41217,41238,41259)
       
Update SRO_VT_SHARD.._Items Set RefItemID='41070',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot '1' and ItemID 0) and RefItemID in (40902,40923,40944,40965,40986,41007,41154,41175,41196,41217,41238,41259)
       
Update SRO_VT_SHARD.._Items Set RefItemID='41091',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot '4' and ItemID 0) and RefItemID in (40902,40923,40944,40965,40986,41007,41154,41175,41196,41217,41238,41259)
       
Update SRO_VT_SHARD.._Items Set RefItemID='41112',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot '3' and ItemID 0) and RefItemID in (40902,40923,40944,40965,40986,41007,41154,41175,41196,41217,41238,41259)
       
Update SRO_VT_SHARD.._Items Set RefItemID='41133',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot '5' and ItemID 0) and RefItemID in (40902,40923,40944,40965,40986,41007,41154,41175,41196,41217,41238,41259

Create Procedure


كود PHP:
USE [SRO_VT_SHARDLOG]
GO
/****** Object:  StoredProcedure [dbo].[_ChangeSystemRobe]    Script Date: 12/29/2015 09:37:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

create PROCEDURE 
[dbo].[_ChangeSystemRobe]
 @
CharID   Int
  
As
 --- 
CH Eu Robe Set
       Update SRO_VT_SHARD
.._Items Set RefItemID='39747',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot '0' and ItemID 0) and RefItemID in (39621,39642,39663,39684,39705,39726,39495,39516,39537,39558,39579,39600)
       
Update SRO_VT_SHARD.._Items Set RefItemID='39768',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot '2' and ItemID 0) and RefItemID in (39621,39642,39663,39684,39705,39726,39495,39516,39537,39558,39579,39600)
       
Update SRO_VT_SHARD.._Items Set RefItemID='39789',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot '1' and ItemID 0) and RefItemID in (39621,39642,39663,39684,39705,39726,39495,39516,39537,39558,39579,39600)
       
Update SRO_VT_SHARD.._Items Set RefItemID='39810',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot '4' and ItemID 0) and RefItemID in (39621,39642,39663,39684,39705,39726,39495,39516,39537,39558,39579,39600)
       
Update SRO_VT_SHARD.._Items Set RefItemID='39831',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot '3' and ItemID 0) and RefItemID in (39621,39642,39663,39684,39705,39726,39495,39516,39537,39558,39579,39600)
       
Update SRO_VT_SHARD.._Items Set RefItemID='39852',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot '5' and ItemID 0) and RefItemID in (39621,39642,39663,39684,39705,39726,39495,39516,39537,39558,39579,39600)
       
Update SRO_VT_SHARD.._Items Set RefItemID='40125',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot '0' and ItemID 0) and RefItemID in (39873,39894,39915,39936,39957,39978,39999,40020,40041,40062,40083,40104)
       
Update SRO_VT_SHARD.._Items Set RefItemID='40146',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot '2' and ItemID 0) and RefItemID in (39873,39894,39915,39936,39957,39978,39999,40020,40041,40062,40083,40104
       
Update SRO_VT_SHARD.._Items Set RefItemID='40167',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot '1' and ItemID 0) and RefItemID in (39873,39894,39915,39936,39957,39978,39999,40020,40041,40062,40083,40104)
       
Update SRO_VT_SHARD.._Items Set RefItemID='40188',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot '4' and ItemID 0) and RefItemID in (39873,39894,39915,39936,39957,39978,39999,40020,40041,40062,40083,40104
       
Update SRO_VT_SHARD.._Items Set RefItemID='40209',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot '3' and ItemID 0) and RefItemID in (39873,39894,39915,39936,39957,39978,39999,40020,40041,40062,40083,40104)
       
Update SRO_VT_SHARD.._Items Set RefItemID='40230',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot '5' and ItemID 0) and RefItemID in (39873,39894,39915,39936,39957,39978,39999,40020,40041,40062,40083,40104)      
       
Update SRO_VT_SHARD.._Items Set RefItemID='40776',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot '0' and ItemID 0) and RefItemID in (40650,40671,40692,40713,40734,40755,40524,40545,40566,40587,40608,40629)
       
Update SRO_VT_SHARD.._Items Set RefItemID='40797',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot '2' and ItemID 0) and RefItemID in (40650,40671,40692,40713,40734,40755,40524,40545,40566,40587,40608,40629)
       
Update SRO_VT_SHARD.._Items Set RefItemID='40818',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot '1' and ItemID 0) and RefItemID in (40650,40671,40692,40713,40734,40755,40524,40545,40566,40587,40608,40629)
       
Update SRO_VT_SHARD.._Items Set RefItemID='40839',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot '4' and ItemID 0) and RefItemID in (40650,40671,40692,40713,40734,40755,40524,40545,40566,40587,40608,40629)
       
Update SRO_VT_SHARD.._Items Set RefItemID='40860',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot '3' and ItemID 0) and RefItemID in (40650,40671,40692,40713,40734,40755,40524,40545,40566,40587,40608,40629)
       
Update SRO_VT_SHARD.._Items Set RefItemID='40881',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot '5' and ItemID 0) and RefItemID in (40650,40671,40692,40713,40734,40755,40524,40545,40566,40587,40608,40629)
       
Update SRO_VT_SHARD.._Items Set RefItemID='41154',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot '0' and ItemID 0) and RefItemID in (41028,41049,41070,41091,41112,41133,40902,40923,40944,40965,40986,41007)
       
Update SRO_VT_SHARD.._Items Set RefItemID='41175',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot '2' and ItemID 0) and RefItemID in (41028,41049,41070,41091,41112,41133,40902,40923,40944,40965,40986,41007
       
Update SRO_VT_SHARD.._Items Set RefItemID='41196',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot '1' and ItemID 0) and RefItemID in (41028,41049,41070,41091,41112,41133,40902,40923,40944,40965,40986,41007)
       
Update SRO_VT_SHARD.._Items Set RefItemID='41217',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot '4' and ItemID 0) and RefItemID in (41028,41049,41070,41091,41112,41133,40902,40923,40944,40965,40986,41007
       
Update SRO_VT_SHARD.._Items Set RefItemID='41238',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot '3' and ItemID 0) and RefItemID in (41028,41049,41070,41091,41112,41133,40902,40923,40944,40965,40986,41007)
       
Update SRO_VT_SHARD.._Items Set RefItemID='41259',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot '5' and ItemID 0) and RefItemID in (41028,41049,41070,41091,41112,41133,40902,40923,40944,40965,40986,41007

_AddLogItem


كود PHP:
--- CH Weapon and Set Change
IF (@Operation 41)and(@ItemRefID 42099) --Ch Weapon change TO Sword
       Begin
       Update SRO_VT_SHARD
.._Items Set RefItemID='39369',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot '6' and ItemID 0) and RefItemID in (39390,39411,39432,39453
 
END
 
IF (@Operation 41)and(@ItemRefID 42100) --Ch Weapon change TO Blade
       Begin
       Update SRO_VT_SHARD
.._Items Set RefItemID='39390',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot '6' and ItemID 0) and RefItemID in (39369,39411,39432,39453
END
 
IF (@Operation 41)and(@ItemRefID 42101) --Ch Weapon change TO Spear
       BEGIN
       Update SRO_VT_SHARD
.._Items Set RefItemID='39411',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot '6' and ItemID 0) and RefItemID in (39369,39390,39432,39453)        
END
 
IF (@Operation 41)and(@ItemRefID 42102) --Ch Weapon change TO Glaive
       BEGIN
       Update SRO_VT_SHARD
.._Items Set RefItemID='39432',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot '6' and ItemID 0) and RefItemID in (39369,39390,39411,39453
END
  
IF (@Operation 41)and(@ItemRefID 42103) --Ch Weapon change TO Bow
       BEGIN
       Update SRO_VT_SHARD
.._Items Set RefItemID='39453',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot '6' and ItemID 0) and RefItemID in (39369,39390,39411,39432
END
IF (@Operation 41)and(@ItemRefID 42104) --Ch Set Garment Or Protector change TO Set Armor
       Begin
                     Execute 
[SRO_VT_SHARDLOG].[dbo].[_ChangeSystemH.A] @CharID
END
IF (@Operation 41)and(@ItemRefID 42105) --Ch Set Garment Or Armor change TO Set Protector
       Begin
              Execute 
[SRO_VT_SHARDLOG].[dbo].[_ChangeSystemL.A] @CharID
END
IF (@Operation 41)and(@ItemRefID 42106) --Ch Set Protector Or Armor change TO Set Garment
       Begin
              Execute 
[SRO_VT_SHARDLOG].[dbo].[_ChangeSystemRobe] @CharID
END
--- EU Weapon and Set Change
 
IF (@Operation 41)and(@ItemRefID 42107) --EU Weapon change TO Dagger
       Begin
       Update SRO_VT_SHARD
.._Items Set RefItemID='40314',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot '6' and ItemID 0) and RefItemID in (40335,40356,40377,40398,40419,40440,40461,40482
END
 
IF (@Operation 41)and(@ItemRefID 42108) --EU Weapon change TO CrossBow
       Begin
       Update SRO_VT_SHARD
.._Items Set RefItemID='40398',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot '6' and ItemID 0) and RefItemID in (40314,40335,40356,40377,40419,40440,40461,40482)  
END
 
IF (@Operation 41)and(@ItemRefID 42109) --EU Weapon change TO Axe
       Begin
       Update SRO_VT_SHARD
.._Items Set RefItemID='40377',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot '6' and ItemID 0) and RefItemID in (40314,40335,40356,40398,40419,40440,40461,40482
END
 
IF (@Operation 41)and(@ItemRefID 42110) --EU Weapon change TO One Hand Sword
       Begin
       Update SRO_VT_SHARD
.._Items Set RefItemID='40335',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot '6' and ItemID 0) and RefItemID in (40314,40356,40377,40398,40419,40440,40461,40482)  
END
 
IF (@Operation 41)and(@ItemRefID 42111) --EU Weapon change TO Two Hand Sword
       Begin
       Update SRO_VT_SHARD
.._Items Set RefItemID='40356',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot '6' and ItemID 0) and RefItemID in (40314,40335,40377,40398,40419,40440,40461,40482)  
END
 
IF (@Operation 41)and(@ItemRefID 42112) --EU Weapon change TO Two Hand Staff
       Begin
       Update SRO_VT_SHARD
.._Items Set RefItemID='40440',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot '6' and ItemID 0) and RefItemID in (40314,40335,40356,40377,40398,40419,40461,40482
END
 
IF (@Operation 41)and(@ItemRefID 42113) --EU Weapon change TO Claric Rod
       Begin
       Update SRO_VT_SHARD
.._Items Set RefItemID='40482',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot '6' and ItemID 0) and RefItemID in (40314,40335,40356,40377,40398,40419,40440,40461
END
 
IF (@Operation 41)and(@ItemRefID 42114) --EU Weapon change TO Warlock Rod
       Begin
       Update SRO_VT_SHARD
.._Items Set RefItemID='40419',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot '6' and ItemID 0) and RefItemID in (40314,40335,40356,40377,40398,40440,40461,40482
END
IF (@Operation 41)and(@ItemRefID 42115) --EU Weapon change TO Harp
       Begin
       Update SRO_VT_SHARD
.._Items Set RefItemID='40461',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot '6' and ItemID 0) and RefItemID in (40314,40335,40356,40377,40398,40419,40440,40482
END
IF (@Operation 41)and(@ItemRefID 42116) --EU Set Robe Or L.A change TO Set H.A
       Begin
                     Execute 
[SRO_VT_SHARDLOG].[dbo].[_ChangeSystemH.A] @CharID
END
IF (@Operation 41)and(@ItemRefID 42117) --EU Set Robe Or H.A change TO Set L.A
       Begin
              Execute 
[SRO_VT_SHARDLOG].[dbo].[_ChangeSystemL.A] @CharID
END
IF (@Operation 41)and(@ItemRefID 42118) --EU Set L.Or H.A change TO Set Robe
       Begin
              Execute 
[SRO_VT_SHARDLOG].[dbo].[_ChangeSystemRobe] @CharID
END 

Media Lines

itemdata_45000

كود PHP:
1    42099    ITEM_CHANGE_WPN_CH_SWORD    ?????    xxx    SN_ITEM_CHANGE_WPN_CH_SWORD    SN_ITEM_CHANGE_WPN_CH_SWORD_TT_DESC    1    0    3    3    3    1    180000    3    0    1    1    1    255    0    1    0    0    1    0    0    0    0    0    0    0    -1    0    -1    0    -1    0    -1    0    -1    0    0    0    0    0    0    0    100    0    0    0    xxx    item\etc\drop_mall_scroll.bsr    item\trade\hunter\sword_14.ddj    xxx    xxx    1    2    0    0    1    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    1000    ????    1    ??????    -1    RESURRECT    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    0    0    
1    42100    ITEM_CHANGE_WPN_CH_BLADE    
?????    xxx    SN_ITEM_CHANGE_WPN_CH_BLADE    SN_ITEM_CHANGE_WPN_CH_BLADE_TT_DESC    1    0    3    3    3    1    180000    3    0    1    1    1    255    0    1    0    0    1    0    0    0    0    0    0    0    -1    0    -1    0    -1    0    -1    0    -1    0    0    0    0    0    0    0    100    0    0    0    xxx    item\etc\drop_mall_scroll.bsr    item\trade\hunter\blade_14.ddj    xxx    xxx    1    2    0    0    1    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    1000    ????    1    ??????    -1    RESURRECT    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    0    0    
1    42101    ITEM_CHANGE_WPN_CH_SPEAR    
?????    xxx    SN_ITEM_CHANGE_WPN_CH_SPEAR    SN_ITEM_CHANGE_WPN_CH_SPEAR_TT_DESC    1    0    3    3    3    1    180000    3    0    1    1    1    255    0    1    0    0    1    0    0    0    0    0    0    0    -1    0    -1    0    -1    0    -1    0    -1    0    0    0    0    0    0    0    100    0    0    0    xxx    item\etc\drop_mall_scroll.bsr    item\trade\hunter\spear_14.ddj    xxx    xxx    1    2    0    0    1    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    1000    ????    1    ??????    -1    RESURRECT    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    0    0    
1    42102    ITEM_CHANGE_WPN_CH_GLAIVE    
?????    xxx    SN_ITEM_CHANGE_WPN_CH_GLAIVE    SN_ITEM_CHANGE_WPN_CH_GLAIVE_TT_DESC    1    0    3    3    3    1    180000    3    0    1    1    1    255    0    1    0    0    1    0    0    0    0    0    0    0    -1    0    -1    0    -1    0    -1    0    -1    0    0    0    0    0    0    0    100    0    0    0    xxx    item\etc\drop_mall_scroll.bsr    item\trade\hunter\tblade_14.ddj    xxx    xxx    1    2    0    0    1    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    1000    ????    1    ??????    -1    RESURRECT    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    0    0    
1    42103    ITEM_CHANGE_WPN_CH_BOW    
?????    xxx    SN_ITEM_CHANGE_WPN_CH_BOW    SN_ITEM_CHANGE_WPN_CH_BOW_TT_DESC    1    0    3    3    3    1    180000    3    0    1    1    1    255    0    1    0    0    1    0    0    0    0    0    0    0    -1    0    -1    0    -1    0    -1    0    -1    0    0    0    0    0    0    0    100    0    0    0    xxx    item\etc\drop_mall_scroll.bsr    item\trade\hunter\bow_14.ddj    xxx    xxx    1    2    0    0    1    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    1000    ????    1    ??????    -1    RESURRECT    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    0    0    
1    42104    ITEM_CHANGE_SET_CH_ARMOR    
?????    xxx    SN_ITEM_CHANGE_SET_CH_ARMOR    SN_ITEM_CHANGE_SET_CH_ARMOR_TT_DESC    1    0    3    3    3    1    180000    3    0    1    1    1    255    0    1    0    0    1    0    0    0    0    0    0    0    -1    0    -1    0    -1    0    -1    0    -1    0    0    0    0    0    0    0    100    0    0    0    xxx    item\etc\drop_mall_scroll.bsr    item\trade\hunter\armor_test.ddj    xxx    xxx    1    2    0    0    1    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    1000    ????    1    ??????    -1    RESURRECT    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    0    0    
1    42105    ITEM_CHANGE_SET_CH_PRO    
?????    xxx    SN_ITEM_CHANGE_SET_CH_PRO    SN_ITEM_CHANGE_SET_CH_PRO_TT_DESC    1    0    3    3    3    1    180000    3    0    1    1    1    255    0    1    0    0    1    0    0    0    0    0    0    0    -1    0    -1    0    -1    0    -1    0    -1    0    0    0    0    0    0    0    100    0    0    0    xxx    item\etc\drop_mall_scroll.bsr    item\trade\hunter\armor_test.ddj    xxx    xxx    1    2    0    0    1    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    1000    ????    1    ??????    -1    RESURRECT    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    0    0    
1    42106    ITEM_CHANGE_SET_CH_GRAMENT    
?????    xxx    SN_ITEM_CHANGE_SET_CH_GRAMENT    SN_ITEM_CHANGE_SET_CH_GRAMENT_TT_DESC    1    0    3    3    3    1    180000    3    0    1    1    1    255    0    1    0    0    1    0    0    0    0    0    0    0    -1    0    -1    0    -1    0    -1    0    -1    0    0    0    0    0    0    0    100    0    0    0    xxx    item\etc\drop_mall_scroll.bsr    item\trade\hunter\armor_test.ddj    xxx    xxx    1    2    0    0    1    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    1000    ????    1    ??????    -1    RESURRECT    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    0    0    
1    42107    ITEM_CHANGE_WPN_EU_DAGGER    
?????    xxx    SN_ITEM_CHANGE_WPN_EU_DAGGER    SN_ITEM_CHANGE_WPN_EU_DAGGER_TT_DESC    1    0    3    3    3    1    180000    3    0    1    1    1    255    0    1    0    0    1    0    0    0    0    0    0    0    -1    0    -1    0    -1    0    -1    0    -1    0    0    0    0    0    0    0    100    0    0    0    xxx    item\etc\drop_mall_scroll.bsr    item\trade\hunter\dagger_14.ddj    xxx    xxx    1    2    0    0    1    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    1000    ????    1    ??????    -1    RESURRECT    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    0    0    
1    42108    ITEM_CHANGE_WPN_EU_XBOW    
?????    xxx    SN_ITEM_CHANGE_WPN_EU_XBOW    SN_ITEM_CHANGE_WPN_EU_XBOW_TT_DESC    1    0    3    3    3    1    180000    3    0    1    1    1    255    0    1    0    0    1    0    0    0    0    0    0    0    -1    0    -1    0    -1    0    -1    0    -1    0    0    0    0    0    0    0    100    0    0    0    xxx    item\etc\drop_mall_scroll.bsr    item\trade\hunter\crossbow_14.ddj    xxx    xxx    1    2    0    0    1    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    1000    ????    1    ??????    -1    RESURRECT    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    0    0    
1    42109    ITEM_CHANGE_WPN_EU_AXE    
?????    xxx    SN_ITEM_CHANGE_WPN_EU_AXE    SN_ITEM_CHANGE_WPN_EU_AXE_TT_DESC    1    0    3    3    3    1    180000    3    0    1    1    1    255    0    1    0    0    1    0    0    0    0    0    0    0    -1    0    -1    0    -1    0    -1    0    -1    0    0    0    0    0    0    0    100    0    0    0    xxx    item\etc\drop_mall_scroll.bsr    item\trade\hunter\axe_14.ddj    xxx    xxx    1    2    0    0    1    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    1000    ????    1    ??????    -1    RESURRECT    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    0    0    
1    42110    ITEM_CHANGE_WPN_EU_SWORD    
?????    xxx    SN_ITEM_CHANGE_WPN_EU_SWORD    SN_ITEM_CHANGE_WPN_EU_SWORD_TT_DESC    1    0    3    3    3    1    180000    3    0    1    1    1    255    0    1    0    0    1    0    0    0    0    0    0    0    -1    0    -1    0    -1    0    -1    0    -1    0    0    0    0    0    0    0    100    0    0    0    xxx    item\etc\drop_mall_scroll.bsr    item\trade\hunter\esword_14.ddj    xxx    xxx    1    2    0    0    1    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    1000    ????    1    ??????    -1    RESURRECT    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    0    0    
1    42111    ITEM_CHANGE_WPN_EU_TSWORD    
?????    xxx    SN_ITEM_CHANGE_WPN_EU_TSWORD    SN_ITEM_CHANGE_WPN_EU_TSWORD_TT_DESC    1    0    3    3    3    1    180000    3    0    1    1    1    255    0    1    0    0    1    0    0    0    0    0    0    0    -1    0    -1    0    -1    0    -1    0    -1    0    0    0    0    0    0    0    100    0    0    0    xxx    item\etc\drop_mall_scroll.bsr    item\trade\hunter\tsword_14.ddj    xxx    xxx    1    2    0    0    1    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    1000    ????    1    ??????    -1    RESURRECT    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    0    0    
1    42112    ITEM_CHANGE_WPN_EU_TSTAFF    
?????    xxx    SN_ITEM_CHANGE_WPN_EU_TSTAFF    SN_ITEM_CHANGE_WPN_EU_TSTAFF_TT_DESC    1    0    3    3    3    1    180000    3    0    1    1    1    255    0    1    0    0    1    0    0    0    0    0    0    0    -1    0    -1    0    -1    0    -1    0    -1    0    0    0    0    0    0    0    100    0    0    0    xxx    item\etc\drop_mall_scroll.bsr    item\trade\hunter\tstaff_14.ddj    xxx    xxx    1    2    0    0    1    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    1000    ????    1    ??????    -1    RESURRECT    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    0    0    
1    42113    ITEM_CHANGE_WPN_EU_STAFF    
?????    xxx    SN_ITEM_CHANGE_WPN_EU_STAFF    SN_ITEM_CHANGE_WPN_EU_STAFF_TT_DESC    1    0    3    3    3    1    180000    3    0    1    1    1    255    0    1    0    0    1    0    0    0    0    0    0    0    -1    0    -1    0    -1    0    -1    0    -1    0    0    0    0    0    0    0    100    0    0    0    xxx    item\etc\drop_mall_scroll.bsr    item\trade\hunter\staff_14.ddj    xxx    xxx    1    2    0    0    1    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    1000    ????    1    ??????    -1    RESURRECT    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    0    0    
1    42114    ITEM_CHANGE_WPN_EU_DSTAFF    
?????    xxx    SN_ITEM_CHANGE_WPN_EU_DSTAFF    SN_ITEM_CHANGE_WPN_EU_DSTAFF_TT_DESC    1    0    3    3    3    1    180000    3    0    1    1    1    255    0    1    0    0    1    0    0    0    0    0    0    0    -1    0    -1    0    -1    0    -1    0    -1    0    0    0    0    0    0    0    100    0    0    0    xxx    item\etc\drop_mall_scroll.bsr    item\trade\hunter\darkstaff_14.ddj    xxx    xxx    1    2    0    0    1    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    1000    ????    1    ??????    -1    RESURRECT    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    0    0    
1    42115    ITEM_CHANGE_WPN_EU_HARP    
?????    xxx    SN_ITEM_CHANGE_WPN_EU_HARP    SN_ITEM_CHANGE_WPN_EU_HARP_TT_DESC    1    0    3    3    3    1    180000    3    0    1    1    1    255    0    1    0    0    1    0    0    0    0    0    0    0    -1    0    -1    0    -1    0    -1    0    -1    0    0    0    0    0    0    0    100    0    0    0    xxx    item\etc\drop_mall_scroll.bsr    item\trade\hunter\harp_14.ddj    xxx    xxx    1    2    0    0    1    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    1000    ????    1    ??????    -1    RESURRECT    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    0    0    
1    42116    ITEM_CHANGE_SET_EU_HA    
?????    xxx    SN_ITEM_CHANGE_SET_EU_HA    SN_ITEM_CHANGE_SET_EU_HA_TT_DESC    1    0    3    3    3    1    180000    3    0    1    1    1    255    0    1    0    0    1    0    0    0    0    0    0    0    -1    0    -1    0    -1    0    -1    0    -1    0    0    0    0    0    0    0    100    0    0    0    xxx    item\etc\drop_mall_scroll.bsr    item\trade\hunter\armor_test.ddj    xxx    xxx    1    2    0    0    1    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    1000    ????    1    ??????    -1    RESURRECT    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    0    0    
1    42117    ITEM_CHANGE_SET_EU_LA    
?????    xxx    SN_ITEM_CHANGE_SET_EU_LA    SN_ITEM_CHANGE_SET_EU_LA_TT_DESC    1    0    3    3    3    1    180000    3    0    1    1    1    255    0    1    0    0    1    0    0    0    0    0    0    0    -1    0    -1    0    -1    0    -1    0    -1    0    0    0    0    0    0    0    100    0    0    0    xxx    item\etc\drop_mall_scroll.bsr    item\trade\hunter\armor_test.ddj    xxx    xxx    1    2    0    0    1    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    1000    ????    1    ??????    -1    RESURRECT    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    0    0    
1    42118    ITEM_CHANGE_SET_EU_ROBE    
?????    xxx    SN_ITEM_CHANGE_SET_EU_ROBE    SN_ITEM_CHANGE_SET_EU_ROBE_TT_DESC    1    0    3    3    3    1    180000    3    0    1    1    1    255    0    1    0    0    1    0    0    0    0    0    0    0    -1    0    -1    0    -1    0    -1    0    -1    0    0    0    0    0    0    0    100    0    0    0    xxx    item\etc\drop_mall_scroll.bsr    item\trade\hunter\armor_test.ddj    xxx    xxx    1    2    0    0    1    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    1000    ????    1    ??????    -1    RESURRECT    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    0    0 
textdata_object

كود PHP:
1    SN_ITEM_CHANGE_WPN_CH_SWORD                                Scroll Change any Wpeapon CH D14 To CH Sword
1    SN_ITEM_CHANGE_WPN_CH_BLADE                                Scroll Change any Wpeapon CH D14 To CH Blade
1    SN_ITEM_CHANGE_WPN_CH_SPEAR                                Scroll Change any Wpeapon CH D14 To CH Spear
1    SN_ITEM_CHANGE_WPN_CH_GLAIVE                                Scroll Change any Wpeapon CH D14 To CH Glaive
1    SN_ITEM_CHANGE_WPN_CH_BOW                                Scroll Change any Wpeapon CH D14 To CH Bow
1    SN_ITEM_CHANGE_SET_CH_ARMOR                                Scroll Change any Set CH D14 To CH Armor Set
1    SN_ITEM_CHANGE_SET_CH_PRO                                Scroll Change any Set CH D14 To CH Protector Set
1    SN_ITEM_CHANGE_SET_CH_GRAMENT                                Scroll Change any Set CH D14 To CH Garment Set
1    SN_ITEM_CHANGE_WPN_EU_DAGGER                                Scroll Change any Wpeapon EU D14 To EU Dagger
1    SN_ITEM_CHANGE_WPN_EU_XBOW                                Scroll Change any Wpeapon EU D14 To EU CrossBow
1    SN_ITEM_CHANGE_WPN_EU_AXE                                Scroll Change any Wpeapon EU D14 To EU Axe
1    SN_ITEM_CHANGE_WPN_EU_SWORD                                Scroll Change any Wpeapon EU D14 To EU One Hand Sword
1    SN_ITEM_CHANGE_WPN_EU_TSWORD                                Scroll Change any Wpeapon EU D14 To EU Two Hand Sword
1    SN_ITEM_CHANGE_WPN_EU_TSTAFF                                Scroll Change any Wpeapon EU D14 To EU Two Hand Staff
1    SN_ITEM_CHANGE_WPN_EU_STAFF                                Scroll Change any Wpeapon EU D14 To EU Claric Rod
1    SN_ITEM_CHANGE_WPN_EU_DSTAFF                                Scroll Change any Wpeapon EU D14 To EU Warlock Rod
1    SN_ITEM_CHANGE_WPN_EU_HARP                                Scroll Change any Wpeapon EU D14 To EU Harp
1    SN_ITEM_CHANGE_SET_EU_HA                                Scroll Change any Set EU D14 To EU H
.A Set
1    SN_ITEM_CHANGE_SET_EU_LA                                Scroll Change any Set EU D14 To EU L
.A Set
1    SN_ITEM_CHANGE_SET_EU_ROBE                                Scroll Change any Set EU D14 To EU Robe Set
1    SN_ITEM_CHANGE_WPN_CH_Sword_TT_DESC                                To 
use this Scroll make Sure your Wpeapon in Your Hand
1    SN_ITEM_CHANGE_WPN_CH_BLADE_TT_DESC                                To 
use this Scroll make Sure your Wpeapon in Your Hand
1    SN_ITEM_CHANGE_WPN_CH_SPEAR_TT_DESC                                To 
use this Scroll make Sure your Wpeapon in Your Hand
1    SN_ITEM_CHANGE_WPN_CH_GLAIVE_TT_DESC                                To 
use this Scroll make Sure your Wpeapon in Your Hand
1    SN_ITEM_CHANGE_WPN_CH_BOW_TT_DESC                                To 
use this Scroll make Sure your Wpeapon in Your Hand
1    SN_ITEM_CHANGE_SET_CH_ARMOR_TT_DESC                                To 
use this Scroll make Sure you Wear your Set
1    SN_ITEM_CHANGE_SET_CH_PRO_TT_DESC                                To 
use this Scroll make Sure you Wear your Set
1    SN_ITEM_CHANGE_SET_CH_GRAMENT_TT_DESC                                To 
use this Scroll make Sure you Wear your Set
1    SN_ITEM_CHANGE_WPN_EU_DAGGER_TT_DESC                                To 
use this Scroll make Sure your Wpeapon in Your Hand
1    SN_ITEM_CHANGE_WPN_EU_XBOW_TT_DESC                                To 
use this Scroll make Sure your Wpeapon in Your Hand
1    SN_ITEM_CHANGE_WPN_EU_AXE_TT_DESC                                To 
use this Scroll make Sure your Wpeapon in Your Hand
1    SN_ITEM_CHANGE_WPN_EU_SWORD_TT_DESC                                To 
use this Scroll make Sure your Wpeapon in Your Hand
1    SN_ITEM_CHANGE_WPN_EU_TSWORD_TT_DESC                                To 
use this Scroll make Sure your Wpeapon in Your Hand
1    SN_ITEM_CHANGE_WPN_EU_TSTAFF_TT_DESC                                To 
use this Scroll make Sure your Wpeapon in Your Hand
1    SN_ITEM_CHANGE_WPN_EU_STAFF_TT_DESC                                To 
use this Scroll make Sure your Wpeapon in Your Hand
1    SN_ITEM_CHANGE_WPN_EU_DSTAFF_TT_DESC                                To 
use this Scroll make Sure your Wpeapon in Your Hand
1    SN_ITEM_CHANGE_WPN_EU_HARP_TT_DESC                                To 
use this Scroll make Sure your Wpeapon in Your Hand
1    SN_ITEM_CHANGE_SET_EU_HA_TT_DESC                                To 
use this Scroll make Sure you Wear your Set
1    SN_ITEM_CHANGE_SET_EU_LA_TT_DESC                                To 
use this Scroll make Sure you Wear your Set
1    SN_ITEM_CHANGE_SET_EU_ROBE_TT_DESC                                To 
use this Scroll make Sure you Wear your Set 
[YOUTUBE]1v4DEccAtVw[/YOUTUBE]


الملفات المرفقة عفوا ,,, لايمكنك مشاهده المرفق لانك غير مسجل لدينا [ للتسجيل اضغط هنا ]
توقيع HLP :
My New Intro
[YOUTUBE]OT4HWFbVuTk[/YOUTUBE]


التعديل الأخير تم بواسطة HLP ; 29-12-2015 الساعة 12:27 PM

رد مع اقتباس
إعلانات google

قديم 28-12-2015, 02:02 PM   #2

Hamza FiGo



الصورة الرمزية Hamza FiGo

مـديـر عـام

• الانـتـسـاب » Dec 2007
• رقـم العـضـويـة » 6993
• المشـــاركـات » 6,157
• الـدولـة » Cairo
• الـهـوايـة » Helping ppl
• اسـم الـسـيـرفـر » Private Server
• الـجـنـس » Male
• نقـاط التقييم » 973
Hamza FiGo صـانـع للابـداعHamza FiGo صـانـع للابـداعHamza FiGo صـانـع للابـداعHamza FiGo صـانـع للابـداعHamza FiGo صـانـع للابـداعHamza FiGo صـانـع للابـداعHamza FiGo صـانـع للابـداعHamza FiGo صـانـع للابـداع

Hamza FiGo غير متواجد حالياً

12310  


إرسال رسالة عبر Yahoo إلى Hamza FiGo إرسال رسالة عبر Skype إلى Hamza FiGo

اوسمتي

افتراضي رد: Scroll CH&EU change Weapon & Set



موضوع رائع كالعادة

تسلم ايدك. ودا اكيد هنزله عندي في السيرفر بعد اذنك

لانه هيفيدني انا كا جي ام

تمت الاضافة لتجميلعه اسكرولات 2015


توقيع Hamza FiGo :
عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ]
عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ]

عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ] || عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ] || عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ]


رد مع اقتباس
قديم 28-12-2015, 02:25 PM   #3

Dangers SrO
عضو سوبر



الصورة الرمزية Dangers SrO


• الانـتـسـاب » Jan 2014
• رقـم العـضـويـة » 116041
• المشـــاركـات » 2,589
• الـدولـة » Gizaaa
• الـهـوايـة » SilkRoad4Arab Only One <3
• اسـم الـسـيـرفـر » Private Server
• الـجـنـس » Male
• نقـاط التقييم » 63
Dangers SrO جـيـد

Dangers SrO غير متواجد حالياً

3196  



افتراضي رد: Scroll CH&EU change Weapon & Set



تسلم موضوع جميل وانشالله هجربو




رد مع اقتباس
قديم 28-12-2015, 02:27 PM   #4

Hamza FiGo



الصورة الرمزية Hamza FiGo

مـديـر عـام

• الانـتـسـاب » Dec 2007
• رقـم العـضـويـة » 6993
• المشـــاركـات » 6,157
• الـدولـة » Cairo
• الـهـوايـة » Helping ppl
• اسـم الـسـيـرفـر » Private Server
• الـجـنـس » Male
• نقـاط التقييم » 973
Hamza FiGo صـانـع للابـداعHamza FiGo صـانـع للابـداعHamza FiGo صـانـع للابـداعHamza FiGo صـانـع للابـداعHamza FiGo صـانـع للابـداعHamza FiGo صـانـع للابـداعHamza FiGo صـانـع للابـداعHamza FiGo صـانـع للابـداع

Hamza FiGo غير متواجد حالياً

12310  


إرسال رسالة عبر Yahoo إلى Hamza FiGo إرسال رسالة عبر Skype إلى Hamza FiGo

اوسمتي

افتراضي رد: Scroll CH&EU change Weapon & Set



عندي فكرة بسيطة

الاسكرول كبيرة ولو اتحطت في اللوج هتعمل لاج. فا من الاحسن تعملها بروسيدر لوحدها علشان نخفف الحمل علي اللوج

وتعرف الناس يغيرو IDs الايتمز فين ويعملو اية علشان هيكون صعب علي الناس شوية


توقيع Hamza FiGo :
عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ]
عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ]

عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ] || عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ] || عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ]


رد مع اقتباس
قديم 28-12-2015, 02:38 PM   #5

HLP
عضو فعال



الصورة الرمزية HLP


• الانـتـسـاب » Mar 2013
• رقـم العـضـويـة » 110603
• المشـــاركـات » 352
• الـدولـة » Hurghada
• الـهـوايـة » DeveloP AnyThing
• اسـم الـسـيـرفـر » Private Server
• الـجـنـس » Male
• نقـاط التقييم » 14
HLP صـاعـد

HLP غير متواجد حالياً

401  


إرسال رسالة عبر Skype إلى HLP

افتراضي رد: Scroll CH&EU change Weapon & Set



اقتباس:
المشاركة الأصلية كتبت بواسطة Hamza FiGo عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ]
موضوع رائع كالعادة

تسلم ايدك. ودا اكيد هنزله عندي في السيرفر بعد اذنك

لانه هيفيدني انا كا جي ام

تمت الاضافة لتجميلعه اسكرولات 2015
شكرا
اقتباس:
المشاركة الأصلية كتبت بواسطة Dangers SrO عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ]
تسلم موضوع جميل وانشالله هجربو
شكرا
اقتباس:
المشاركة الأصلية كتبت بواسطة Hamza FiGo عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ]
عندي فكرة بسيطة

الاسكرول كبيرة ولو اتحطت في اللوج هتعمل لاج. فا من الاحسن تعملها بروسيدر لوحدها علشان نخفف الحمل علي اللوج

وتعرف الناس يغيرو IDs الايتمز فين ويعملو اية علشان هيكون صعب علي الناس شوية
اوكي


توقيع HLP :
My New Intro
[YOUTUBE]OT4HWFbVuTk[/YOUTUBE]



رد مع اقتباس
قديم 28-12-2015, 02:49 PM   #6

Hamza FiGo



الصورة الرمزية Hamza FiGo

مـديـر عـام

• الانـتـسـاب » Dec 2007
• رقـم العـضـويـة » 6993
• المشـــاركـات » 6,157
• الـدولـة » Cairo
• الـهـوايـة » Helping ppl
• اسـم الـسـيـرفـر » Private Server
• الـجـنـس » Male
• نقـاط التقييم » 973
Hamza FiGo صـانـع للابـداعHamza FiGo صـانـع للابـداعHamza FiGo صـانـع للابـداعHamza FiGo صـانـع للابـداعHamza FiGo صـانـع للابـداعHamza FiGo صـانـع للابـداعHamza FiGo صـانـع للابـداعHamza FiGo صـانـع للابـداع

Hamza FiGo غير متواجد حالياً

12310  


إرسال رسالة عبر Yahoo إلى Hamza FiGo إرسال رسالة عبر Skype إلى Hamza FiGo

اوسمتي

افتراضي رد: Scroll CH&EU change Weapon & Set



اعتقد تبقي كدا . عملتها علي السريع كدا علي ما اجرب.

Create Procedure

كود:
USE [SRO_VT_SYSTEMS]
GO
/****** Object:  StoredProcedure [dbo].[_ChangeSex]    Script Date: 12/28/2015 11:41:58 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

CREATE PROCEDURE [dbo].[_ChangeSex]
 @CharID   Int
  As
  Declare @CreaterName Varchar(MAX) = 'HLP' , -- Creater Name
   @Operation Int ,
   @ItemRefID Int 
   
  --- CH Weapon and Set Change
IF (@Operation = 41)and(@ItemRefID = 42099) --Ch Weapon change TO Sword
       Begin
       Update SRO_VT_SHARD.._Items Set RefItemID='39369',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '6' and ItemID > 0) and RefItemID in (39390,39411,39432,39453) 
 END
 IF (@Operation = 41)and(@ItemRefID = 42100) --Ch Weapon change TO Blade
       Begin
       Update SRO_VT_SHARD.._Items Set RefItemID='39390',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '6' and ItemID > 0) and RefItemID in (39369,39411,39432,39453) 
END
 IF (@Operation = 41)and(@ItemRefID = 42101) --Ch Weapon change TO Spear
       BEGIN
       Update SRO_VT_SHARD.._Items Set RefItemID='39411',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '6' and ItemID > 0) and RefItemID in (39369,39390,39432,39453)        
END
 IF (@Operation = 41)and(@ItemRefID = 42102) --Ch Weapon change TO Glaive
       BEGIN
       Update SRO_VT_SHARD.._Items Set RefItemID='39432',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '6' and ItemID > 0) and RefItemID in (39369,39390,39411,39453) 
END
  IF (@Operation = 41)and(@ItemRefID = 42103) --Ch Weapon change TO Bow
       BEGIN
       Update SRO_VT_SHARD.._Items Set RefItemID='39453',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '6' and ItemID > 0) and RefItemID in (39369,39390,39411,39432) 
END
IF (@Operation = 41)and(@ItemRefID = 42104) --Ch Set Garment Or Protector change TO Set Armor
       Begin
       Update SRO_VT_SHARD.._Items Set RefItemID='39495',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '0' and ItemID > 0) and RefItemID in (39621,39642,39663,39684,39705,39726,39747,39768,39789,39810,39831,39852) 
       Update SRO_VT_SHARD.._Items Set RefItemID='39516',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '2' and ItemID > 0) and RefItemID in (39621,39642,39663,39684,39705,39726,39747,39768,39789,39810,39831,39852) 
       Update SRO_VT_SHARD.._Items Set RefItemID='39537',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '1' and ItemID > 0) and RefItemID in (39621,39642,39663,39684,39705,39726,39747,39768,39789,39810,39831,39852) 
       Update SRO_VT_SHARD.._Items Set RefItemID='39558',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '4' and ItemID > 0) and RefItemID in (39621,39642,39663,39684,39705,39726,39747,39768,39789,39810,39831,39852) 
       Update SRO_VT_SHARD.._Items Set RefItemID='39579',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '3' and ItemID > 0) and RefItemID in (39621,39642,39663,39684,39705,39726,39747,39768,39789,39810,39831,39852) 
       Update SRO_VT_SHARD.._Items Set RefItemID='39600',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '5' and ItemID > 0) and RefItemID in (39621,39642,39663,39684,39705,39726,39747,39768,39789,39810,39831,39852)      
       Update SRO_VT_SHARD.._Items Set RefItemID='39873',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '0' and ItemID > 0) and RefItemID in (39999,40020,40041,40062,40083,40104,40125,40146,40167,40188,40209,40230) 
       Update SRO_VT_SHARD.._Items Set RefItemID='39894',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '2' and ItemID > 0) and RefItemID in (39999,40020,40041,40062,40083,40104,40125,40146,40167,40188,40209,40230) 
       Update SRO_VT_SHARD.._Items Set RefItemID='39915',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '1' and ItemID > 0) and RefItemID in (39999,40020,40041,40062,40083,40104,40125,40146,40167,40188,40209,40230) 
       Update SRO_VT_SHARD.._Items Set RefItemID='39936',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '4' and ItemID > 0) and RefItemID in (39999,40020,40041,40062,40083,40104,40125,40146,40167,40188,40209,40230) 
       Update SRO_VT_SHARD.._Items Set RefItemID='39957',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '3' and ItemID > 0) and RefItemID in (39999,40020,40041,40062,40083,40104,40125,40146,40167,40188,40209,40230) 
       Update SRO_VT_SHARD.._Items Set RefItemID='39978',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '5' and ItemID > 0) and RefItemID in (39999,40020,40041,40062,40083,40104,40125,40146,40167,40188,40209,40230)      
END
IF (@Operation = 41)and(@ItemRefID = 42105) --Ch Set Garment Or Armor change TO Set Protector
       Begin
       Update SRO_VT_SHARD.._Items Set RefItemID='39621',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '0' and ItemID > 0) and RefItemID in (39495,39516,39537,39558,39579,39600,39747,39768,39789,39810,39831,39852)
       Update SRO_VT_SHARD.._Items Set RefItemID='39642',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '2' and ItemID > 0) and RefItemID in (39495,39516,39537,39558,39579,39600,39747,39768,39789,39810,39831,39852) 
       Update SRO_VT_SHARD.._Items Set RefItemID='39663',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '1' and ItemID > 0) and RefItemID in (39495,39516,39537,39558,39579,39600,39747,39768,39789,39810,39831,39852) 
       Update SRO_VT_SHARD.._Items Set RefItemID='39684',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '4' and ItemID > 0) and RefItemID in (39495,39516,39537,39558,39579,39600,39747,39768,39789,39810,39831,39852) 
       Update SRO_VT_SHARD.._Items Set RefItemID='39705',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '3' and ItemID > 0) and RefItemID in (39495,39516,39537,39558,39579,39600,39747,39768,39789,39810,39831,39852) 
       Update SRO_VT_SHARD.._Items Set RefItemID='39726',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '5' and ItemID > 0) and RefItemID in (39495,39516,39537,39558,39579,39600,39747,39768,39789,39810,39831,39852)      
       Update SRO_VT_SHARD.._Items Set RefItemID='39999',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '0' and ItemID > 0) and RefItemID in (40125,40146,40167,40188,40209,40230,39873,39894,39915,39936,39957,39978) 
       Update SRO_VT_SHARD.._Items Set RefItemID='40020',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '2' and ItemID > 0) and RefItemID in (40125,40146,40167,40188,40209,40230,39873,39894,39915,39936,39957,39978)
       Update SRO_VT_SHARD.._Items Set RefItemID='40041',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '1' and ItemID > 0) and RefItemID in (40125,40146,40167,40188,40209,40230,39873,39894,39915,39936,39957,39978)
       Update SRO_VT_SHARD.._Items Set RefItemID='40062',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '4' and ItemID > 0) and RefItemID in (40125,40146,40167,40188,40209,40230,39873,39894,39915,39936,39957,39978)
       Update SRO_VT_SHARD.._Items Set RefItemID='40083',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '3' and ItemID > 0) and RefItemID in (40125,40146,40167,40188,40209,40230,39873,39894,39915,39936,39957,39978)
       Update SRO_VT_SHARD.._Items Set RefItemID='40104',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '5' and ItemID > 0) and RefItemID in (40125,40146,40167,40188,40209,40230,39873,39894,39915,39936,39957,39978)
END
IF (@Operation = 41)and(@ItemRefID = 42106) --Ch Set Protector Or Armor change TO Set Garment
       Begin
       Update SRO_VT_SHARD.._Items Set RefItemID='39747',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '0' and ItemID > 0) and RefItemID in (39621,39642,39663,39684,39705,39726,39495,39516,39537,39558,39579,39600)
       Update SRO_VT_SHARD.._Items Set RefItemID='39768',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '2' and ItemID > 0) and RefItemID in (39621,39642,39663,39684,39705,39726,39495,39516,39537,39558,39579,39600)
       Update SRO_VT_SHARD.._Items Set RefItemID='39789',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '1' and ItemID > 0) and RefItemID in (39621,39642,39663,39684,39705,39726,39495,39516,39537,39558,39579,39600)
       Update SRO_VT_SHARD.._Items Set RefItemID='39810',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '3' and ItemID > 0) and RefItemID in (39621,39642,39663,39684,39705,39726,39495,39516,39537,39558,39579,39600)
       Update SRO_VT_SHARD.._Items Set RefItemID='39831',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '4' and ItemID > 0) and RefItemID in (39621,39642,39663,39684,39705,39726,39495,39516,39537,39558,39579,39600)
       Update SRO_VT_SHARD.._Items Set RefItemID='39852',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '5' and ItemID > 0) and RefItemID in (39621,39642,39663,39684,39705,39726,39495,39516,39537,39558,39579,39600)
       Update SRO_VT_SHARD.._Items Set RefItemID='40125',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '0' and ItemID > 0) and RefItemID in (39873,39894,39915,39936,39957,39978,39999,40020,40041,40062,40083,40104)
       Update SRO_VT_SHARD.._Items Set RefItemID='40146',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '2' and ItemID > 0) and RefItemID in (39873,39894,39915,39936,39957,39978,39999,40020,40041,40062,40083,40104) 
       Update SRO_VT_SHARD.._Items Set RefItemID='40167',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '1' and ItemID > 0) and RefItemID in (39873,39894,39915,39936,39957,39978,39999,40020,40041,40062,40083,40104)
       Update SRO_VT_SHARD.._Items Set RefItemID='40188',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '4' and ItemID > 0) and RefItemID in (39873,39894,39915,39936,39957,39978,39999,40020,40041,40062,40083,40104) 
       Update SRO_VT_SHARD.._Items Set RefItemID='40209',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '3' and ItemID > 0) and RefItemID in (39873,39894,39915,39936,39957,39978,39999,40020,40041,40062,40083,40104)
       Update SRO_VT_SHARD.._Items Set RefItemID='40230',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '5' and ItemID > 0) and RefItemID in (39873,39894,39915,39936,39957,39978,39999,40020,40041,40062,40083,40104)      
END
--- EU Weapon and Set Change
 IF (@Operation = 41)and(@ItemRefID = 42107) --EU Weapon change TO Dagger
       Begin
       Update SRO_VT_SHARD.._Items Set RefItemID='40314',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '6' and ItemID > 0) and RefItemID in (40335,40356,40377,40398,40419,40440,40461,40482)
END
 IF (@Operation = 41)and(@ItemRefID = 42108) --EU Weapon change TO CrossBow
       Begin
       Update SRO_VT_SHARD.._Items Set RefItemID='40398',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '6' and ItemID > 0) and RefItemID in (40314,40335,40356,40377,40419,40440,40461,40482) 
END
 IF (@Operation = 41)and(@ItemRefID = 42109) --EU Weapon change TO Axe
       Begin
       Update SRO_VT_SHARD.._Items Set RefItemID='40377',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '6' and ItemID > 0) and RefItemID in (40314,40335,40356,40398,40419,40440,40461,40482)
END
 IF (@Operation = 41)and(@ItemRefID = 42110) --EU Weapon change TO One Hand Sword
       Begin
       Update SRO_VT_SHARD.._Items Set RefItemID='40335',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '6' and ItemID > 0) and RefItemID in (40314,40356,40377,40398,40419,40440,40461,40482) 
END
 IF (@Operation = 41)and(@ItemRefID = 42111) --EU Weapon change TO Two Hand Sword
       Begin
       Update SRO_VT_SHARD.._Items Set RefItemID='40356',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '6' and ItemID > 0) and RefItemID in (40314,40335,40377,40398,40419,40440,40461,40482) 
END
 IF (@Operation = 41)and(@ItemRefID = 42112) --EU Weapon change TO Two Hand Staff
       Begin
       Update SRO_VT_SHARD.._Items Set RefItemID='40440',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '6' and ItemID > 0) and RefItemID in (40314,40335,40356,40377,40398,40419,40461,40482) 
END
 IF (@Operation = 41)and(@ItemRefID = 42113) --EU Weapon change TO Claric Rod
       Begin
       Update SRO_VT_SHARD.._Items Set RefItemID='40482',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '6' and ItemID > 0) and RefItemID in (40314,40335,40356,40377,40398,40419,40440,40461) 
END
 IF (@Operation = 41)and(@ItemRefID = 42114) --EU Weapon change TO Warlock Rod
       Begin
       Update SRO_VT_SHARD.._Items Set RefItemID='40419',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '6' and ItemID > 0) and RefItemID in (40314,40335,40356,40377,40398,40440,40461,40482) 
END
IF (@Operation = 41)and(@ItemRefID = 42115) --EU Weapon change TO Harp
       Begin
       Update SRO_VT_SHARD.._Items Set RefItemID='40461',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '6' and ItemID > 0) and RefItemID in (40314,40335,40356,40377,40398,40419,40440,40482) 
END
IF (@Operation = 41)and(@ItemRefID = 42116) --EU Set Robe Or L.A change TO Set H.A
       Begin
       Update SRO_VT_SHARD.._Items Set RefItemID='40524',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '0' and ItemID > 0) and RefItemID in (40776,40797,40818,40839,40860,40881,40650,40671,40692,40713,40734,40755) 
       Update SRO_VT_SHARD.._Items Set RefItemID='40545',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '2' and ItemID > 0) and RefItemID in (40776,40797,40818,40839,40860,40881,40650,40671,40692,40713,40734,40755) 
       Update SRO_VT_SHARD.._Items Set RefItemID='40566',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '1' and ItemID > 0) and RefItemID in (40776,40797,40818,40839,40860,40881,40650,40671,40692,40713,40734,40755) 
       Update SRO_VT_SHARD.._Items Set RefItemID='40587',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '4' and ItemID > 0) and RefItemID in (40776,40797,40818,40839,40860,40881,40650,40671,40692,40713,40734,40755) 
       Update SRO_VT_SHARD.._Items Set RefItemID='40608',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '3' and ItemID > 0) and RefItemID in (40776,40797,40818,40839,40860,40881,40650,40671,40692,40713,40734,40755) 
       Update SRO_VT_SHARD.._Items Set RefItemID='40629',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '5' and ItemID > 0) and RefItemID in (40776,40797,40818,40839,40860,40881,40650,40671,40692,40713,40734,40755)      
       Update SRO_VT_SHARD.._Items Set RefItemID='40902',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '0' and ItemID > 0) and RefItemID in (41154,41175,41196,41217,41238,41259,41028,41049,41070,41091,41112,41133) 
       Update SRO_VT_SHARD.._Items Set RefItemID='40923',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '2' and ItemID > 0) and RefItemID in (41154,41175,41196,41217,41238,41259,41028,41049,41070,41091,41112,41133) 
       Update SRO_VT_SHARD.._Items Set RefItemID='40944',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '1' and ItemID > 0) and RefItemID in (41154,41175,41196,41217,41238,41259,41028,41049,41070,41091,41112,41133) 
       Update SRO_VT_SHARD.._Items Set RefItemID='40965',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '4' and ItemID > 0) and RefItemID in (41154,41175,41196,41217,41238,41259,41028,41049,41070,41091,41112,41133) 
       Update SRO_VT_SHARD.._Items Set RefItemID='40986',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '3' and ItemID > 0) and RefItemID in (41154,41175,41196,41217,41238,41259,41028,41049,41070,41091,41112,41133) 
       Update SRO_VT_SHARD.._Items Set RefItemID='41007',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '5' and ItemID > 0) and RefItemID in (41154,41175,41196,41217,41238,41259,41028,41049,41070,41091,41112,41133)      
END
IF (@Operation = 41)and(@ItemRefID = 42117) --EU Set Robe Or H.A change TO Set L.A
       Begin
       Update SRO_VT_SHARD.._Items Set RefItemID='40650',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '0' and ItemID > 0) and RefItemID in (40524,40545,40566,40587,40608,40629,40776,40797,40818,40839,40860,40881)
       Update SRO_VT_SHARD.._Items Set RefItemID='40671',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '2' and ItemID > 0) and RefItemID in (40524,40545,40566,40587,40608,40629,40776,40797,40818,40839,40860,40881) 
       Update SRO_VT_SHARD.._Items Set RefItemID='40692',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '1' and ItemID > 0) and RefItemID in (40524,40545,40566,40587,40608,40629,40776,40797,40818,40839,40860,40881) 
       Update SRO_VT_SHARD.._Items Set RefItemID='40713',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '4' and ItemID > 0) and RefItemID in (40524,40545,40566,40587,40608,40629,40776,40797,40818,40839,40860,40881) 
       Update SRO_VT_SHARD.._Items Set RefItemID='40734',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '3' and ItemID > 0) and RefItemID in (40524,40545,40566,40587,40608,40629,40776,40797,40818,40839,40860,40881) 
       Update SRO_VT_SHARD.._Items Set RefItemID='40755',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '5' and ItemID > 0) and RefItemID in (40524,40545,40566,40587,40608,40629,40776,40797,40818,40839,40860,40881)      
       Update SRO_VT_SHARD.._Items Set RefItemID='41028',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '0' and ItemID > 0) and RefItemID in (40902,40923,40944,40965,40986,41007,41154,41175,41196,41217,41238,41259) 
       Update SRO_VT_SHARD.._Items Set RefItemID='41049',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '2' and ItemID > 0) and RefItemID in (40902,40923,40944,40965,40986,41007,41154,41175,41196,41217,41238,41259)
       Update SRO_VT_SHARD.._Items Set RefItemID='41070',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '1' and ItemID > 0) and RefItemID in (40902,40923,40944,40965,40986,41007,41154,41175,41196,41217,41238,41259)
       Update SRO_VT_SHARD.._Items Set RefItemID='41091',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '4' and ItemID > 0) and RefItemID in (40902,40923,40944,40965,40986,41007,41154,41175,41196,41217,41238,41259)
       Update SRO_VT_SHARD.._Items Set RefItemID='41112',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '3' and ItemID > 0) and RefItemID in (40902,40923,40944,40965,40986,41007,41154,41175,41196,41217,41238,41259)
       Update SRO_VT_SHARD.._Items Set RefItemID='41133',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '5' and ItemID > 0) and RefItemID in (40902,40923,40944,40965,40986,41007,41154,41175,41196,41217,41238,41259)
END
IF (@Operation = 41)and(@ItemRefID = 42118) --EU Set L.A Or H.A change TO Set Robe
       Begin
       Update SRO_VT_SHARD.._Items Set RefItemID='40776',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '0' and ItemID > 0) and RefItemID in (40650,40671,40692,40713,40734,40755,40524,40545,40566,40587,40608,40629)
       Update SRO_VT_SHARD.._Items Set RefItemID='40797',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '2' and ItemID > 0) and RefItemID in (40650,40671,40692,40713,40734,40755,40524,40545,40566,40587,40608,40629)
       Update SRO_VT_SHARD.._Items Set RefItemID='40818',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '1' and ItemID > 0) and RefItemID in (40650,40671,40692,40713,40734,40755,40524,40545,40566,40587,40608,40629)
       Update SRO_VT_SHARD.._Items Set RefItemID='40839',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '3' and ItemID > 0) and RefItemID in (40650,40671,40692,40713,40734,40755,40524,40545,40566,40587,40608,40629)
       Update SRO_VT_SHARD.._Items Set RefItemID='40860',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '4' and ItemID > 0) and RefItemID in (40650,40671,40692,40713,40734,40755,40524,40545,40566,40587,40608,40629)
       Update SRO_VT_SHARD.._Items Set RefItemID='40881',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '5' and ItemID > 0) and RefItemID in (40650,40671,40692,40713,40734,40755,40524,40545,40566,40587,40608,40629)
       Update SRO_VT_SHARD.._Items Set RefItemID='41154',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '0' and ItemID > 0) and RefItemID in (41028,41049,41070,41091,41112,41133,40902,40923,40944,40965,40986,41007)
       Update SRO_VT_SHARD.._Items Set RefItemID='41175',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '2' and ItemID > 0) and RefItemID in (41028,41049,41070,41091,41112,41133,40902,40923,40944,40965,40986,41007) 
       Update SRO_VT_SHARD.._Items Set RefItemID='41196',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '1' and ItemID > 0) and RefItemID in (41028,41049,41070,41091,41112,41133,40902,40923,40944,40965,40986,41007)
       Update SRO_VT_SHARD.._Items Set RefItemID='41217',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '4' and ItemID > 0) and RefItemID in (41028,41049,41070,41091,41112,41133,40902,40923,40944,40965,40986,41007) 
       Update SRO_VT_SHARD.._Items Set RefItemID='41238',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '3' and ItemID > 0) and RefItemID in (41028,41049,41070,41091,41112,41133,40902,40923,40944,40965,40986,41007)
       Update SRO_VT_SHARD.._Items Set RefItemID='41259',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '5' and ItemID > 0) and RefItemID in (41028,41049,41070,41091,41112,41133,40902,40923,40944,40965,40986,41007)      
END
AddLogItem

كود:
 IF (@Operation = 41) -- If item used!
   Begin
     IF (@ItemRefID = 70024) -- RefObjCommon ID
      Begin
       Execute [SRO_VT_SYSTEM].[dbo].[_ChangeSex] @CharID
      End
   End  

IF (@Operation = 41) -- If item used!
   Begin
     IF (@ItemRefID = 70024) -- RefObjCommon ID
      Begin
       Execute [SRO_VT_SYSTEM].[dbo].[_ChangeSex] @CharID
      End
   End  
IF (@Operation = 41) -- If item used!
   Begin
     IF (@ItemRefID = 70024) -- RefObjCommon ID
      Begin
       Execute [SRO_VT_SYSTEM].[dbo].[_ChangeSex] @CharID
      End
   End  
IF (@Operation = 41) -- If item used!
   Begin
     IF (@ItemRefID = 70024) -- RefObjCommon ID
      Begin
       Execute [SRO_VT_SYSTEM].[dbo].[_ChangeSex] @CharID
      End
   End  
IF (@Operation = 41) -- If item used!
   Begin
     IF (@ItemRefID = 70024) -- RefObjCommon ID
      Begin
       Execute [SRO_VT_SYSTEM].[dbo].[_ChangeSex] @CharID
      End
   End  

IF (@Operation = 41) -- If item used!
   Begin
     IF (@ItemRefID = 70024) -- RefObjCommon ID
      Begin
       Execute [SRO_VT_SYSTEM].[dbo].[_ChangeSex] @CharID
      End
   End  
IF (@Operation = 41) -- If item used!
   Begin
     IF (@ItemRefID = 70024) -- RefObjCommon ID
      Begin
       Execute [SRO_VT_SYSTEM].[dbo].[_ChangeSex] @CharID
      End
   End  
IF (@Operation = 41) -- If item used!
   Begin
     IF (@ItemRefID = 70024) -- RefObjCommon ID
      Begin
       Execute [SRO_VT_SYSTEM].[dbo].[_ChangeSex] @CharID
      End
   End  
IF (@Operation = 41) -- If item used!
   Begin
     IF (@ItemRefID = 70024) -- RefObjCommon ID
      Begin
       Execute [SRO_VT_SYSTEM].[dbo].[_ChangeSex] @CharID
      End
   End  

IF (@Operation = 41) -- If item used!
   Begin
     IF (@ItemRefID = 70024) -- RefObjCommon ID
      Begin
       Execute [SRO_VT_SYSTEM].[dbo].[_ChangeSex] @CharID
      End
   End  
IF (@Operation = 41) -- If item used!
   Begin
     IF (@ItemRefID = 70024) -- RefObjCommon ID
      Begin
       Execute [SRO_VT_SYSTEM].[dbo].[_ChangeSex] @CharID
      End
   End  
IF (@Operation = 41) -- If item used!
   Begin
     IF (@ItemRefID = 70024) -- RefObjCommon ID
      Begin
       Execute [SRO_VT_SYSTEM].[dbo].[_ChangeSex] @CharID
      End
   End  
IF (@Operation = 41) -- If item used!
   Begin
     IF (@ItemRefID = 70024) -- RefObjCommon ID
      Begin
       Execute [SRO_VT_SYSTEM].[dbo].[_ChangeSex] @CharID
      End
   End  

IF (@Operation = 41) -- If item used!
   Begin
     IF (@ItemRefID = 70024) -- RefObjCommon ID
      Begin
       Execute [SRO_VT_SYSTEM].[dbo].[_ChangeSex] @CharID
      End
   End  
IF (@Operation = 41) -- If item used!
   Begin
     IF (@ItemRefID = 70024) -- RefObjCommon ID
      Begin
       Execute [SRO_VT_SYSTEM].[dbo].[_ChangeSex] @CharID
      End
   End  
IF (@Operation = 41) -- If item used!
   Begin
     IF (@ItemRefID = 70024) -- RefObjCommon ID
      Begin
       Execute [SRO_VT_SYSTEM].[dbo].[_ChangeSex] @CharID
      End
   End  
IF (@Operation = 41) -- If item used!
   Begin
     IF (@ItemRefID = 70024) -- RefObjCommon ID
      Begin
       Execute [SRO_VT_SYSTEM].[dbo].[_ChangeSex] @CharID
      End
   End  

IF (@Operation = 41) -- If item used!
   Begin
     IF (@ItemRefID = 70024) -- RefObjCommon ID
      Begin
       Execute [SRO_VT_SYSTEM].[dbo].[_ChangeSex] @CharID
      End
   End  
IF (@Operation = 41) -- If item used!
   Begin
     IF (@ItemRefID = 70024) -- RefObjCommon ID
      Begin
       Execute [SRO_VT_SYSTEM].[dbo].[_ChangeSex] @CharID
      End
   End  
IF (@Operation = 41) -- If item used!
   Begin
     IF (@ItemRefID = 70024) -- RefObjCommon ID
      Begin
       Execute [SRO_VT_SYSTEM].[dbo].[_ChangeSex] @CharID
      End
   End


توقيع Hamza FiGo :
عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ]
عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ]

عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ] || عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ] || عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ]

التعديل الأخير تم بواسطة Hamza FiGo ; 28-12-2015 الساعة 02:59 PM

رد مع اقتباس
قديم 28-12-2015, 04:05 PM   #7

HLP
عضو فعال



الصورة الرمزية HLP


• الانـتـسـاب » Mar 2013
• رقـم العـضـويـة » 110603
• المشـــاركـات » 352
• الـدولـة » Hurghada
• الـهـوايـة » DeveloP AnyThing
• اسـم الـسـيـرفـر » Private Server
• الـجـنـس » Male
• نقـاط التقييم » 14
HLP صـاعـد

HLP غير متواجد حالياً

401  


إرسال رسالة عبر Skype إلى HLP

افتراضي رد: Scroll CH&EU change Weapon & Set



اقتباس:
المشاركة الأصلية كتبت بواسطة Hamza FiGo عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ]
اعتقد تبقي كدا . عملتها علي السريع كدا علي ما اجرب.

Create Procedure

كود:
USE [SRO_VT_SYSTEMS]
GO
/****** Object:  StoredProcedure [dbo].[_ChangeSex]    Script Date: 12/28/2015 11:41:58 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

CREATE PROCEDURE [dbo].[_ChangeSex]
 @CharID   Int
  As
  Declare @CreaterName Varchar(MAX) = 'HLP' , -- Creater Name
   @Operation Int ,
   @ItemRefID Int 
   
  --- CH Weapon and Set Change
IF (@Operation = 41)and(@ItemRefID = 42099) --Ch Weapon change TO Sword
       Begin
       Update SRO_VT_SHARD.._Items Set RefItemID='39369',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '6' and ItemID > 0) and RefItemID in (39390,39411,39432,39453) 
 END
 IF (@Operation = 41)and(@ItemRefID = 42100) --Ch Weapon change TO Blade
       Begin
       Update SRO_VT_SHARD.._Items Set RefItemID='39390',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '6' and ItemID > 0) and RefItemID in (39369,39411,39432,39453) 
END
 IF (@Operation = 41)and(@ItemRefID = 42101) --Ch Weapon change TO Spear
       BEGIN
       Update SRO_VT_SHARD.._Items Set RefItemID='39411',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '6' and ItemID > 0) and RefItemID in (39369,39390,39432,39453)        
END
 IF (@Operation = 41)and(@ItemRefID = 42102) --Ch Weapon change TO Glaive
       BEGIN
       Update SRO_VT_SHARD.._Items Set RefItemID='39432',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '6' and ItemID > 0) and RefItemID in (39369,39390,39411,39453) 
END
  IF (@Operation = 41)and(@ItemRefID = 42103) --Ch Weapon change TO Bow
       BEGIN
       Update SRO_VT_SHARD.._Items Set RefItemID='39453',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '6' and ItemID > 0) and RefItemID in (39369,39390,39411,39432) 
END
IF (@Operation = 41)and(@ItemRefID = 42104) --Ch Set Garment Or Protector change TO Set Armor
       Begin
       Update SRO_VT_SHARD.._Items Set RefItemID='39495',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '0' and ItemID > 0) and RefItemID in (39621,39642,39663,39684,39705,39726,39747,39768,39789,39810,39831,39852) 
       Update SRO_VT_SHARD.._Items Set RefItemID='39516',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '2' and ItemID > 0) and RefItemID in (39621,39642,39663,39684,39705,39726,39747,39768,39789,39810,39831,39852) 
       Update SRO_VT_SHARD.._Items Set RefItemID='39537',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '1' and ItemID > 0) and RefItemID in (39621,39642,39663,39684,39705,39726,39747,39768,39789,39810,39831,39852) 
       Update SRO_VT_SHARD.._Items Set RefItemID='39558',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '4' and ItemID > 0) and RefItemID in (39621,39642,39663,39684,39705,39726,39747,39768,39789,39810,39831,39852) 
       Update SRO_VT_SHARD.._Items Set RefItemID='39579',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '3' and ItemID > 0) and RefItemID in (39621,39642,39663,39684,39705,39726,39747,39768,39789,39810,39831,39852) 
       Update SRO_VT_SHARD.._Items Set RefItemID='39600',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '5' and ItemID > 0) and RefItemID in (39621,39642,39663,39684,39705,39726,39747,39768,39789,39810,39831,39852)      
       Update SRO_VT_SHARD.._Items Set RefItemID='39873',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '0' and ItemID > 0) and RefItemID in (39999,40020,40041,40062,40083,40104,40125,40146,40167,40188,40209,40230) 
       Update SRO_VT_SHARD.._Items Set RefItemID='39894',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '2' and ItemID > 0) and RefItemID in (39999,40020,40041,40062,40083,40104,40125,40146,40167,40188,40209,40230) 
       Update SRO_VT_SHARD.._Items Set RefItemID='39915',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '1' and ItemID > 0) and RefItemID in (39999,40020,40041,40062,40083,40104,40125,40146,40167,40188,40209,40230) 
       Update SRO_VT_SHARD.._Items Set RefItemID='39936',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '4' and ItemID > 0) and RefItemID in (39999,40020,40041,40062,40083,40104,40125,40146,40167,40188,40209,40230) 
       Update SRO_VT_SHARD.._Items Set RefItemID='39957',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '3' and ItemID > 0) and RefItemID in (39999,40020,40041,40062,40083,40104,40125,40146,40167,40188,40209,40230) 
       Update SRO_VT_SHARD.._Items Set RefItemID='39978',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '5' and ItemID > 0) and RefItemID in (39999,40020,40041,40062,40083,40104,40125,40146,40167,40188,40209,40230)      
END
IF (@Operation = 41)and(@ItemRefID = 42105) --Ch Set Garment Or Armor change TO Set Protector
       Begin
       Update SRO_VT_SHARD.._Items Set RefItemID='39621',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '0' and ItemID > 0) and RefItemID in (39495,39516,39537,39558,39579,39600,39747,39768,39789,39810,39831,39852)
       Update SRO_VT_SHARD.._Items Set RefItemID='39642',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '2' and ItemID > 0) and RefItemID in (39495,39516,39537,39558,39579,39600,39747,39768,39789,39810,39831,39852) 
       Update SRO_VT_SHARD.._Items Set RefItemID='39663',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '1' and ItemID > 0) and RefItemID in (39495,39516,39537,39558,39579,39600,39747,39768,39789,39810,39831,39852) 
       Update SRO_VT_SHARD.._Items Set RefItemID='39684',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '4' and ItemID > 0) and RefItemID in (39495,39516,39537,39558,39579,39600,39747,39768,39789,39810,39831,39852) 
       Update SRO_VT_SHARD.._Items Set RefItemID='39705',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '3' and ItemID > 0) and RefItemID in (39495,39516,39537,39558,39579,39600,39747,39768,39789,39810,39831,39852) 
       Update SRO_VT_SHARD.._Items Set RefItemID='39726',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '5' and ItemID > 0) and RefItemID in (39495,39516,39537,39558,39579,39600,39747,39768,39789,39810,39831,39852)      
       Update SRO_VT_SHARD.._Items Set RefItemID='39999',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '0' and ItemID > 0) and RefItemID in (40125,40146,40167,40188,40209,40230,39873,39894,39915,39936,39957,39978) 
       Update SRO_VT_SHARD.._Items Set RefItemID='40020',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '2' and ItemID > 0) and RefItemID in (40125,40146,40167,40188,40209,40230,39873,39894,39915,39936,39957,39978)
       Update SRO_VT_SHARD.._Items Set RefItemID='40041',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '1' and ItemID > 0) and RefItemID in (40125,40146,40167,40188,40209,40230,39873,39894,39915,39936,39957,39978)
       Update SRO_VT_SHARD.._Items Set RefItemID='40062',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '4' and ItemID > 0) and RefItemID in (40125,40146,40167,40188,40209,40230,39873,39894,39915,39936,39957,39978)
       Update SRO_VT_SHARD.._Items Set RefItemID='40083',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '3' and ItemID > 0) and RefItemID in (40125,40146,40167,40188,40209,40230,39873,39894,39915,39936,39957,39978)
       Update SRO_VT_SHARD.._Items Set RefItemID='40104',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '5' and ItemID > 0) and RefItemID in (40125,40146,40167,40188,40209,40230,39873,39894,39915,39936,39957,39978)
END
IF (@Operation = 41)and(@ItemRefID = 42106) --Ch Set Protector Or Armor change TO Set Garment
       Begin
       Update SRO_VT_SHARD.._Items Set RefItemID='39747',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '0' and ItemID > 0) and RefItemID in (39621,39642,39663,39684,39705,39726,39495,39516,39537,39558,39579,39600)
       Update SRO_VT_SHARD.._Items Set RefItemID='39768',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '2' and ItemID > 0) and RefItemID in (39621,39642,39663,39684,39705,39726,39495,39516,39537,39558,39579,39600)
       Update SRO_VT_SHARD.._Items Set RefItemID='39789',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '1' and ItemID > 0) and RefItemID in (39621,39642,39663,39684,39705,39726,39495,39516,39537,39558,39579,39600)
       Update SRO_VT_SHARD.._Items Set RefItemID='39810',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '3' and ItemID > 0) and RefItemID in (39621,39642,39663,39684,39705,39726,39495,39516,39537,39558,39579,39600)
       Update SRO_VT_SHARD.._Items Set RefItemID='39831',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '4' and ItemID > 0) and RefItemID in (39621,39642,39663,39684,39705,39726,39495,39516,39537,39558,39579,39600)
       Update SRO_VT_SHARD.._Items Set RefItemID='39852',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '5' and ItemID > 0) and RefItemID in (39621,39642,39663,39684,39705,39726,39495,39516,39537,39558,39579,39600)
       Update SRO_VT_SHARD.._Items Set RefItemID='40125',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '0' and ItemID > 0) and RefItemID in (39873,39894,39915,39936,39957,39978,39999,40020,40041,40062,40083,40104)
       Update SRO_VT_SHARD.._Items Set RefItemID='40146',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '2' and ItemID > 0) and RefItemID in (39873,39894,39915,39936,39957,39978,39999,40020,40041,40062,40083,40104) 
       Update SRO_VT_SHARD.._Items Set RefItemID='40167',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '1' and ItemID > 0) and RefItemID in (39873,39894,39915,39936,39957,39978,39999,40020,40041,40062,40083,40104)
       Update SRO_VT_SHARD.._Items Set RefItemID='40188',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '4' and ItemID > 0) and RefItemID in (39873,39894,39915,39936,39957,39978,39999,40020,40041,40062,40083,40104) 
       Update SRO_VT_SHARD.._Items Set RefItemID='40209',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '3' and ItemID > 0) and RefItemID in (39873,39894,39915,39936,39957,39978,39999,40020,40041,40062,40083,40104)
       Update SRO_VT_SHARD.._Items Set RefItemID='40230',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '5' and ItemID > 0) and RefItemID in (39873,39894,39915,39936,39957,39978,39999,40020,40041,40062,40083,40104)      
END
--- EU Weapon and Set Change
 IF (@Operation = 41)and(@ItemRefID = 42107) --EU Weapon change TO Dagger
       Begin
       Update SRO_VT_SHARD.._Items Set RefItemID='40314',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '6' and ItemID > 0) and RefItemID in (40335,40356,40377,40398,40419,40440,40461,40482)
END
 IF (@Operation = 41)and(@ItemRefID = 42108) --EU Weapon change TO CrossBow
       Begin
       Update SRO_VT_SHARD.._Items Set RefItemID='40398',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '6' and ItemID > 0) and RefItemID in (40314,40335,40356,40377,40419,40440,40461,40482) 
END
 IF (@Operation = 41)and(@ItemRefID = 42109) --EU Weapon change TO Axe
       Begin
       Update SRO_VT_SHARD.._Items Set RefItemID='40377',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '6' and ItemID > 0) and RefItemID in (40314,40335,40356,40398,40419,40440,40461,40482)
END
 IF (@Operation = 41)and(@ItemRefID = 42110) --EU Weapon change TO One Hand Sword
       Begin
       Update SRO_VT_SHARD.._Items Set RefItemID='40335',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '6' and ItemID > 0) and RefItemID in (40314,40356,40377,40398,40419,40440,40461,40482) 
END
 IF (@Operation = 41)and(@ItemRefID = 42111) --EU Weapon change TO Two Hand Sword
       Begin
       Update SRO_VT_SHARD.._Items Set RefItemID='40356',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '6' and ItemID > 0) and RefItemID in (40314,40335,40377,40398,40419,40440,40461,40482) 
END
 IF (@Operation = 41)and(@ItemRefID = 42112) --EU Weapon change TO Two Hand Staff
       Begin
       Update SRO_VT_SHARD.._Items Set RefItemID='40440',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '6' and ItemID > 0) and RefItemID in (40314,40335,40356,40377,40398,40419,40461,40482) 
END
 IF (@Operation = 41)and(@ItemRefID = 42113) --EU Weapon change TO Claric Rod
       Begin
       Update SRO_VT_SHARD.._Items Set RefItemID='40482',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '6' and ItemID > 0) and RefItemID in (40314,40335,40356,40377,40398,40419,40440,40461) 
END
 IF (@Operation = 41)and(@ItemRefID = 42114) --EU Weapon change TO Warlock Rod
       Begin
       Update SRO_VT_SHARD.._Items Set RefItemID='40419',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '6' and ItemID > 0) and RefItemID in (40314,40335,40356,40377,40398,40440,40461,40482) 
END
IF (@Operation = 41)and(@ItemRefID = 42115) --EU Weapon change TO Harp
       Begin
       Update SRO_VT_SHARD.._Items Set RefItemID='40461',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '6' and ItemID > 0) and RefItemID in (40314,40335,40356,40377,40398,40419,40440,40482) 
END
IF (@Operation = 41)and(@ItemRefID = 42116) --EU Set Robe Or L.A change TO Set H.A
       Begin
       Update SRO_VT_SHARD.._Items Set RefItemID='40524',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '0' and ItemID > 0) and RefItemID in (40776,40797,40818,40839,40860,40881,40650,40671,40692,40713,40734,40755) 
       Update SRO_VT_SHARD.._Items Set RefItemID='40545',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '2' and ItemID > 0) and RefItemID in (40776,40797,40818,40839,40860,40881,40650,40671,40692,40713,40734,40755) 
       Update SRO_VT_SHARD.._Items Set RefItemID='40566',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '1' and ItemID > 0) and RefItemID in (40776,40797,40818,40839,40860,40881,40650,40671,40692,40713,40734,40755) 
       Update SRO_VT_SHARD.._Items Set RefItemID='40587',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '4' and ItemID > 0) and RefItemID in (40776,40797,40818,40839,40860,40881,40650,40671,40692,40713,40734,40755) 
       Update SRO_VT_SHARD.._Items Set RefItemID='40608',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '3' and ItemID > 0) and RefItemID in (40776,40797,40818,40839,40860,40881,40650,40671,40692,40713,40734,40755) 
       Update SRO_VT_SHARD.._Items Set RefItemID='40629',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '5' and ItemID > 0) and RefItemID in (40776,40797,40818,40839,40860,40881,40650,40671,40692,40713,40734,40755)      
       Update SRO_VT_SHARD.._Items Set RefItemID='40902',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '0' and ItemID > 0) and RefItemID in (41154,41175,41196,41217,41238,41259,41028,41049,41070,41091,41112,41133) 
       Update SRO_VT_SHARD.._Items Set RefItemID='40923',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '2' and ItemID > 0) and RefItemID in (41154,41175,41196,41217,41238,41259,41028,41049,41070,41091,41112,41133) 
       Update SRO_VT_SHARD.._Items Set RefItemID='40944',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '1' and ItemID > 0) and RefItemID in (41154,41175,41196,41217,41238,41259,41028,41049,41070,41091,41112,41133) 
       Update SRO_VT_SHARD.._Items Set RefItemID='40965',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '4' and ItemID > 0) and RefItemID in (41154,41175,41196,41217,41238,41259,41028,41049,41070,41091,41112,41133) 
       Update SRO_VT_SHARD.._Items Set RefItemID='40986',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '3' and ItemID > 0) and RefItemID in (41154,41175,41196,41217,41238,41259,41028,41049,41070,41091,41112,41133) 
       Update SRO_VT_SHARD.._Items Set RefItemID='41007',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '5' and ItemID > 0) and RefItemID in (41154,41175,41196,41217,41238,41259,41028,41049,41070,41091,41112,41133)      
END
IF (@Operation = 41)and(@ItemRefID = 42117) --EU Set Robe Or H.A change TO Set L.A
       Begin
       Update SRO_VT_SHARD.._Items Set RefItemID='40650',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '0' and ItemID > 0) and RefItemID in (40524,40545,40566,40587,40608,40629,40776,40797,40818,40839,40860,40881)
       Update SRO_VT_SHARD.._Items Set RefItemID='40671',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '2' and ItemID > 0) and RefItemID in (40524,40545,40566,40587,40608,40629,40776,40797,40818,40839,40860,40881) 
       Update SRO_VT_SHARD.._Items Set RefItemID='40692',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '1' and ItemID > 0) and RefItemID in (40524,40545,40566,40587,40608,40629,40776,40797,40818,40839,40860,40881) 
       Update SRO_VT_SHARD.._Items Set RefItemID='40713',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '4' and ItemID > 0) and RefItemID in (40524,40545,40566,40587,40608,40629,40776,40797,40818,40839,40860,40881) 
       Update SRO_VT_SHARD.._Items Set RefItemID='40734',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '3' and ItemID > 0) and RefItemID in (40524,40545,40566,40587,40608,40629,40776,40797,40818,40839,40860,40881) 
       Update SRO_VT_SHARD.._Items Set RefItemID='40755',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '5' and ItemID > 0) and RefItemID in (40524,40545,40566,40587,40608,40629,40776,40797,40818,40839,40860,40881)      
       Update SRO_VT_SHARD.._Items Set RefItemID='41028',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '0' and ItemID > 0) and RefItemID in (40902,40923,40944,40965,40986,41007,41154,41175,41196,41217,41238,41259) 
       Update SRO_VT_SHARD.._Items Set RefItemID='41049',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '2' and ItemID > 0) and RefItemID in (40902,40923,40944,40965,40986,41007,41154,41175,41196,41217,41238,41259)
       Update SRO_VT_SHARD.._Items Set RefItemID='41070',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '1' and ItemID > 0) and RefItemID in (40902,40923,40944,40965,40986,41007,41154,41175,41196,41217,41238,41259)
       Update SRO_VT_SHARD.._Items Set RefItemID='41091',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '4' and ItemID > 0) and RefItemID in (40902,40923,40944,40965,40986,41007,41154,41175,41196,41217,41238,41259)
       Update SRO_VT_SHARD.._Items Set RefItemID='41112',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '3' and ItemID > 0) and RefItemID in (40902,40923,40944,40965,40986,41007,41154,41175,41196,41217,41238,41259)
       Update SRO_VT_SHARD.._Items Set RefItemID='41133',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '5' and ItemID > 0) and RefItemID in (40902,40923,40944,40965,40986,41007,41154,41175,41196,41217,41238,41259)
END
IF (@Operation = 41)and(@ItemRefID = 42118) --EU Set L.A Or H.A change TO Set Robe
       Begin
       Update SRO_VT_SHARD.._Items Set RefItemID='40776',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '0' and ItemID > 0) and RefItemID in (40650,40671,40692,40713,40734,40755,40524,40545,40566,40587,40608,40629)
       Update SRO_VT_SHARD.._Items Set RefItemID='40797',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '2' and ItemID > 0) and RefItemID in (40650,40671,40692,40713,40734,40755,40524,40545,40566,40587,40608,40629)
       Update SRO_VT_SHARD.._Items Set RefItemID='40818',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '1' and ItemID > 0) and RefItemID in (40650,40671,40692,40713,40734,40755,40524,40545,40566,40587,40608,40629)
       Update SRO_VT_SHARD.._Items Set RefItemID='40839',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '3' and ItemID > 0) and RefItemID in (40650,40671,40692,40713,40734,40755,40524,40545,40566,40587,40608,40629)
       Update SRO_VT_SHARD.._Items Set RefItemID='40860',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '4' and ItemID > 0) and RefItemID in (40650,40671,40692,40713,40734,40755,40524,40545,40566,40587,40608,40629)
       Update SRO_VT_SHARD.._Items Set RefItemID='40881',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '5' and ItemID > 0) and RefItemID in (40650,40671,40692,40713,40734,40755,40524,40545,40566,40587,40608,40629)
       Update SRO_VT_SHARD.._Items Set RefItemID='41154',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '0' and ItemID > 0) and RefItemID in (41028,41049,41070,41091,41112,41133,40902,40923,40944,40965,40986,41007)
       Update SRO_VT_SHARD.._Items Set RefItemID='41175',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '2' and ItemID > 0) and RefItemID in (41028,41049,41070,41091,41112,41133,40902,40923,40944,40965,40986,41007) 
       Update SRO_VT_SHARD.._Items Set RefItemID='41196',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '1' and ItemID > 0) and RefItemID in (41028,41049,41070,41091,41112,41133,40902,40923,40944,40965,40986,41007)
       Update SRO_VT_SHARD.._Items Set RefItemID='41217',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '4' and ItemID > 0) and RefItemID in (41028,41049,41070,41091,41112,41133,40902,40923,40944,40965,40986,41007) 
       Update SRO_VT_SHARD.._Items Set RefItemID='41238',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '3' and ItemID > 0) and RefItemID in (41028,41049,41070,41091,41112,41133,40902,40923,40944,40965,40986,41007)
       Update SRO_VT_SHARD.._Items Set RefItemID='41259',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '5' and ItemID > 0) and RefItemID in (41028,41049,41070,41091,41112,41133,40902,40923,40944,40965,40986,41007)      
END
AddLogItem

كود:
 IF (@Operation = 41) -- If item used!
   Begin
     IF (@ItemRefID = 70024) -- RefObjCommon ID
      Begin
       Execute [SRO_VT_SYSTEM].[dbo].[_ChangeSex] @CharID
      End
   End  

IF (@Operation = 41) -- If item used!
   Begin
     IF (@ItemRefID = 70024) -- RefObjCommon ID
      Begin
       Execute [SRO_VT_SYSTEM].[dbo].[_ChangeSex] @CharID
      End
   End  
IF (@Operation = 41) -- If item used!
   Begin
     IF (@ItemRefID = 70024) -- RefObjCommon ID
      Begin
       Execute [SRO_VT_SYSTEM].[dbo].[_ChangeSex] @CharID
      End
   End  
IF (@Operation = 41) -- If item used!
   Begin
     IF (@ItemRefID = 70024) -- RefObjCommon ID
      Begin
       Execute [SRO_VT_SYSTEM].[dbo].[_ChangeSex] @CharID
      End
   End  
IF (@Operation = 41) -- If item used!
   Begin
     IF (@ItemRefID = 70024) -- RefObjCommon ID
      Begin
       Execute [SRO_VT_SYSTEM].[dbo].[_ChangeSex] @CharID
      End
   End  

IF (@Operation = 41) -- If item used!
   Begin
     IF (@ItemRefID = 70024) -- RefObjCommon ID
      Begin
       Execute [SRO_VT_SYSTEM].[dbo].[_ChangeSex] @CharID
      End
   End  
IF (@Operation = 41) -- If item used!
   Begin
     IF (@ItemRefID = 70024) -- RefObjCommon ID
      Begin
       Execute [SRO_VT_SYSTEM].[dbo].[_ChangeSex] @CharID
      End
   End  
IF (@Operation = 41) -- If item used!
   Begin
     IF (@ItemRefID = 70024) -- RefObjCommon ID
      Begin
       Execute [SRO_VT_SYSTEM].[dbo].[_ChangeSex] @CharID
      End
   End  
IF (@Operation = 41) -- If item used!
   Begin
     IF (@ItemRefID = 70024) -- RefObjCommon ID
      Begin
       Execute [SRO_VT_SYSTEM].[dbo].[_ChangeSex] @CharID
      End
   End  

IF (@Operation = 41) -- If item used!
   Begin
     IF (@ItemRefID = 70024) -- RefObjCommon ID
      Begin
       Execute [SRO_VT_SYSTEM].[dbo].[_ChangeSex] @CharID
      End
   End  
IF (@Operation = 41) -- If item used!
   Begin
     IF (@ItemRefID = 70024) -- RefObjCommon ID
      Begin
       Execute [SRO_VT_SYSTEM].[dbo].[_ChangeSex] @CharID
      End
   End  
IF (@Operation = 41) -- If item used!
   Begin
     IF (@ItemRefID = 70024) -- RefObjCommon ID
      Begin
       Execute [SRO_VT_SYSTEM].[dbo].[_ChangeSex] @CharID
      End
   End  
IF (@Operation = 41) -- If item used!
   Begin
     IF (@ItemRefID = 70024) -- RefObjCommon ID
      Begin
       Execute [SRO_VT_SYSTEM].[dbo].[_ChangeSex] @CharID
      End
   End  

IF (@Operation = 41) -- If item used!
   Begin
     IF (@ItemRefID = 70024) -- RefObjCommon ID
      Begin
       Execute [SRO_VT_SYSTEM].[dbo].[_ChangeSex] @CharID
      End
   End  
IF (@Operation = 41) -- If item used!
   Begin
     IF (@ItemRefID = 70024) -- RefObjCommon ID
      Begin
       Execute [SRO_VT_SYSTEM].[dbo].[_ChangeSex] @CharID
      End
   End  
IF (@Operation = 41) -- If item used!
   Begin
     IF (@ItemRefID = 70024) -- RefObjCommon ID
      Begin
       Execute [SRO_VT_SYSTEM].[dbo].[_ChangeSex] @CharID
      End
   End  
IF (@Operation = 41) -- If item used!
   Begin
     IF (@ItemRefID = 70024) -- RefObjCommon ID
      Begin
       Execute [SRO_VT_SYSTEM].[dbo].[_ChangeSex] @CharID
      End
   End  

IF (@Operation = 41) -- If item used!
   Begin
     IF (@ItemRefID = 70024) -- RefObjCommon ID
      Begin
       Execute [SRO_VT_SYSTEM].[dbo].[_ChangeSex] @CharID
      End
   End  
IF (@Operation = 41) -- If item used!
   Begin
     IF (@ItemRefID = 70024) -- RefObjCommon ID
      Begin
       Execute [SRO_VT_SYSTEM].[dbo].[_ChangeSex] @CharID
      End
   End  
IF (@Operation = 41) -- If item used!
   Begin
     IF (@ItemRefID = 70024) -- RefObjCommon ID
      Begin
       Execute [SRO_VT_SYSTEM].[dbo].[_ChangeSex] @CharID
      End
   End
تمام كويس بس برسيدور ده مش شغال و انا عملت برسيدور تاني اهو


Create Procedure



كود PHP:
USE [SRO_VT_SHARDLOG]
GO
/****** Object:  StoredProcedure [dbo].[_ChangeSystemH.A]    Script Date: 12/29/2015 09:36:45 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

create PROCEDURE 
[dbo].[_ChangeSystemH.A]
 @
CharID   Int
  
As
--- 
CH Eu H.A Set
       Update SRO_VT_SHARD
.._Items Set RefItemID='39495',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot '0' and ItemID 0) and RefItemID in (39621,39642,39663,39684,39705,39726,39747,39768,39789,39810,39831,39852
       
Update SRO_VT_SHARD.._Items Set RefItemID='39516',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot '2' and ItemID 0) and RefItemID in (39621,39642,39663,39684,39705,39726,39747,39768,39789,39810,39831,39852
       
Update SRO_VT_SHARD.._Items Set RefItemID='39537',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot '1' and ItemID 0) and RefItemID in (39621,39642,39663,39684,39705,39726,39747,39768,39789,39810,39831,39852
       
Update SRO_VT_SHARD.._Items Set RefItemID='39558',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot '4' and ItemID 0) and RefItemID in (39621,39642,39663,39684,39705,39726,39747,39768,39789,39810,39831,39852
       
Update SRO_VT_SHARD.._Items Set RefItemID='39579',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot '3' and ItemID 0) and RefItemID in (39621,39642,39663,39684,39705,39726,39747,39768,39789,39810,39831,39852
       
Update SRO_VT_SHARD.._Items Set RefItemID='39600',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot '5' and ItemID 0) and RefItemID in (39621,39642,39663,39684,39705,39726,39747,39768,39789,39810,39831,39852)      
       
Update SRO_VT_SHARD.._Items Set RefItemID='39873',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot '0' and ItemID 0) and RefItemID in (39999,40020,40041,40062,40083,40104,40125,40146,40167,40188,40209,40230
       
Update SRO_VT_SHARD.._Items Set RefItemID='39894',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot '2' and ItemID 0) and RefItemID in (39999,40020,40041,40062,40083,40104,40125,40146,40167,40188,40209,40230
       
Update SRO_VT_SHARD.._Items Set RefItemID='39915',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot '1' and ItemID 0) and RefItemID in (39999,40020,40041,40062,40083,40104,40125,40146,40167,40188,40209,40230
       
Update SRO_VT_SHARD.._Items Set RefItemID='39936',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot '4' and ItemID 0) and RefItemID in (39999,40020,40041,40062,40083,40104,40125,40146,40167,40188,40209,40230
       
Update SRO_VT_SHARD.._Items Set RefItemID='39957',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot '3' and ItemID 0) and RefItemID in (39999,40020,40041,40062,40083,40104,40125,40146,40167,40188,40209,40230
       
Update SRO_VT_SHARD.._Items Set RefItemID='39978',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot '5' and ItemID 0) and RefItemID in (39999,40020,40041,40062,40083,40104,40125,40146,40167,40188,40209,40230)      
       
Update SRO_VT_SHARD.._Items Set RefItemID='40524',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot '0' and ItemID 0) and RefItemID in (40776,40797,40818,40839,40860,40881,40650,40671,40692,40713,40734,40755
       
Update SRO_VT_SHARD.._Items Set RefItemID='40545',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot '2' and ItemID 0) and RefItemID in (40776,40797,40818,40839,40860,40881,40650,40671,40692,40713,40734,40755
       
Update SRO_VT_SHARD.._Items Set RefItemID='40566',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot '1' and ItemID 0) and RefItemID in (40776,40797,40818,40839,40860,40881,40650,40671,40692,40713,40734,40755
       
Update SRO_VT_SHARD.._Items Set RefItemID='40587',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot '4' and ItemID 0) and RefItemID in (40776,40797,40818,40839,40860,40881,40650,40671,40692,40713,40734,40755
       
Update SRO_VT_SHARD.._Items Set RefItemID='40608',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot '3' and ItemID 0) and RefItemID in (40776,40797,40818,40839,40860,40881,40650,40671,40692,40713,40734,40755
       
Update SRO_VT_SHARD.._Items Set RefItemID='40629',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot '5' and ItemID 0) and RefItemID in (40776,40797,40818,40839,40860,40881,40650,40671,40692,40713,40734,40755)      
       
Update SRO_VT_SHARD.._Items Set RefItemID='40902',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot '0' and ItemID 0) and RefItemID in (41154,41175,41196,41217,41238,41259,41028,41049,41070,41091,41112,41133
       
Update SRO_VT_SHARD.._Items Set RefItemID='40923',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot '2' and ItemID 0) and RefItemID in (41154,41175,41196,41217,41238,41259,41028,41049,41070,41091,41112,41133
       
Update SRO_VT_SHARD.._Items Set RefItemID='40944',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot '1' and ItemID 0) and RefItemID in (41154,41175,41196,41217,41238,41259,41028,41049,41070,41091,41112,41133
       
Update SRO_VT_SHARD.._Items Set RefItemID='40965',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot '4' and ItemID 0) and RefItemID in (41154,41175,41196,41217,41238,41259,41028,41049,41070,41091,41112,41133
       
Update SRO_VT_SHARD.._Items Set RefItemID='40986',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot '3' and ItemID 0) and RefItemID in (41154,41175,41196,41217,41238,41259,41028,41049,41070,41091,41112,41133
       
Update SRO_VT_SHARD.._Items Set RefItemID='41007',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot '5' and ItemID 0) and RefItemID in (41154,41175,41196,41217,41238,41259,41028,41049,41070,41091,41112,41133
Create Procedure


كود PHP:
USE [SRO_VT_SHARDLOG]
GO
/****** Object:  StoredProcedure [dbo].[_ChangeSystemL.A]    Script Date: 12/29/2015 09:37:02 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

create PROCEDURE 
[dbo].[_ChangeSystemL.A]
 @
CharID   Int
  
As
--- 
CH Eu L.A Set
       Update SRO_VT_SHARD
.._Items Set RefItemID='39621',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot '0' and ItemID 0) and RefItemID in (39495,39516,39537,39558,39579,39600,39747,39768,39789,39810,39831,39852)
       
Update SRO_VT_SHARD.._Items Set RefItemID='39642',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot '2' and ItemID 0) and RefItemID in (39495,39516,39537,39558,39579,39600,39747,39768,39789,39810,39831,39852
       
Update SRO_VT_SHARD.._Items Set RefItemID='39663',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot '1' and ItemID 0) and RefItemID in (39495,39516,39537,39558,39579,39600,39747,39768,39789,39810,39831,39852
       
Update SRO_VT_SHARD.._Items Set RefItemID='39684',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot '4' and ItemID 0) and RefItemID in (39495,39516,39537,39558,39579,39600,39747,39768,39789,39810,39831,39852
       
Update SRO_VT_SHARD.._Items Set RefItemID='39705',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot '3' and ItemID 0) and RefItemID in (39495,39516,39537,39558,39579,39600,39747,39768,39789,39810,39831,39852
       
Update SRO_VT_SHARD.._Items Set RefItemID='39726',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot '5' and ItemID 0) and RefItemID in (39495,39516,39537,39558,39579,39600,39747,39768,39789,39810,39831,39852)      
       
Update SRO_VT_SHARD.._Items Set RefItemID='39999',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot '0' and ItemID 0) and RefItemID in (40125,40146,40167,40188,40209,40230,39873,39894,39915,39936,39957,39978
       
Update SRO_VT_SHARD.._Items Set RefItemID='40020',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot '2' and ItemID 0) and RefItemID in (40125,40146,40167,40188,40209,40230,39873,39894,39915,39936,39957,39978)
       
Update SRO_VT_SHARD.._Items Set RefItemID='40041',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot '1' and ItemID 0) and RefItemID in (40125,40146,40167,40188,40209,40230,39873,39894,39915,39936,39957,39978)
       
Update SRO_VT_SHARD.._Items Set RefItemID='40062',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot '4' and ItemID 0) and RefItemID in (40125,40146,40167,40188,40209,40230,39873,39894,39915,39936,39957,39978)
       
Update SRO_VT_SHARD.._Items Set RefItemID='40083',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot '3' and ItemID 0) and RefItemID in (40125,40146,40167,40188,40209,40230,39873,39894,39915,39936,39957,39978)
       
Update SRO_VT_SHARD.._Items Set RefItemID='40104',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot '5' and ItemID 0) and RefItemID in (40125,40146,40167,40188,40209,40230,39873,39894,39915,39936,39957,39978)
       
Update SRO_VT_SHARD.._Items Set RefItemID='40650',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot '0' and ItemID 0) and RefItemID in (40524,40545,40566,40587,40608,40629,40776,40797,40818,40839,40860,40881)
       
Update SRO_VT_SHARD.._Items Set RefItemID='40671',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot '2' and ItemID 0) and RefItemID in (40524,40545,40566,40587,40608,40629,40776,40797,40818,40839,40860,40881
       
Update SRO_VT_SHARD.._Items Set RefItemID='40692',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot '1' and ItemID 0) and RefItemID in (40524,40545,40566,40587,40608,40629,40776,40797,40818,40839,40860,40881
       
Update SRO_VT_SHARD.._Items Set RefItemID='40713',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot '4' and ItemID 0) and RefItemID in (40524,40545,40566,40587,40608,40629,40776,40797,40818,40839,40860,40881
       
Update SRO_VT_SHARD.._Items Set RefItemID='40734',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot '3' and ItemID 0) and RefItemID in (40524,40545,40566,40587,40608,40629,40776,40797,40818,40839,40860,40881
       
Update SRO_VT_SHARD.._Items Set RefItemID='40755',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot '5' and ItemID 0) and RefItemID in (40524,40545,40566,40587,40608,40629,40776,40797,40818,40839,40860,40881)      
       
Update SRO_VT_SHARD.._Items Set RefItemID='41028',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot '0' and ItemID 0) and RefItemID in (40902,40923,40944,40965,40986,41007,41154,41175,41196,41217,41238,41259
       
Update SRO_VT_SHARD.._Items Set RefItemID='41049',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot '2' and ItemID 0) and RefItemID in (40902,40923,40944,40965,40986,41007,41154,41175,41196,41217,41238,41259)
       
Update SRO_VT_SHARD.._Items Set RefItemID='41070',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot '1' and ItemID 0) and RefItemID in (40902,40923,40944,40965,40986,41007,41154,41175,41196,41217,41238,41259)
       
Update SRO_VT_SHARD.._Items Set RefItemID='41091',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot '4' and ItemID 0) and RefItemID in (40902,40923,40944,40965,40986,41007,41154,41175,41196,41217,41238,41259)
       
Update SRO_VT_SHARD.._Items Set RefItemID='41112',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot '3' and ItemID 0) and RefItemID in (40902,40923,40944,40965,40986,41007,41154,41175,41196,41217,41238,41259)
       
Update SRO_VT_SHARD.._Items Set RefItemID='41133',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot '5' and ItemID 0) and RefItemID in (40902,40923,40944,40965,40986,41007,41154,41175,41196,41217,41238,41259

Create Procedure


كود PHP:
USE [SRO_VT_SHARDLOG]
GO
/****** Object:  StoredProcedure [dbo].[_ChangeSystemRobe]    Script Date: 12/29/2015 09:37:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

create PROCEDURE 
[dbo].[_ChangeSystemRobe]
 @
CharID   Int
  
As
 --- 
CH Eu Robe Set
       Update SRO_VT_SHARD
.._Items Set RefItemID='39747',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot '0' and ItemID 0) and RefItemID in (39621,39642,39663,39684,39705,39726,39495,39516,39537,39558,39579,39600)
       
Update SRO_VT_SHARD.._Items Set RefItemID='39768',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot '2' and ItemID 0) and RefItemID in (39621,39642,39663,39684,39705,39726,39495,39516,39537,39558,39579,39600)
       
Update SRO_VT_SHARD.._Items Set RefItemID='39789',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot '1' and ItemID 0) and RefItemID in (39621,39642,39663,39684,39705,39726,39495,39516,39537,39558,39579,39600)
       
Update SRO_VT_SHARD.._Items Set RefItemID='39810',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot '4' and ItemID 0) and RefItemID in (39621,39642,39663,39684,39705,39726,39495,39516,39537,39558,39579,39600)
       
Update SRO_VT_SHARD.._Items Set RefItemID='39831',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot '3' and ItemID 0) and RefItemID in (39621,39642,39663,39684,39705,39726,39495,39516,39537,39558,39579,39600)
       
Update SRO_VT_SHARD.._Items Set RefItemID='39852',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot '5' and ItemID 0) and RefItemID in (39621,39642,39663,39684,39705,39726,39495,39516,39537,39558,39579,39600)
       
Update SRO_VT_SHARD.._Items Set RefItemID='40125',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot '0' and ItemID 0) and RefItemID in (39873,39894,39915,39936,39957,39978,39999,40020,40041,40062,40083,40104)
       
Update SRO_VT_SHARD.._Items Set RefItemID='40146',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot '2' and ItemID 0) and RefItemID in (39873,39894,39915,39936,39957,39978,39999,40020,40041,40062,40083,40104
       
Update SRO_VT_SHARD.._Items Set RefItemID='40167',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot '1' and ItemID 0) and RefItemID in (39873,39894,39915,39936,39957,39978,39999,40020,40041,40062,40083,40104)
       
Update SRO_VT_SHARD.._Items Set RefItemID='40188',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot '4' and ItemID 0) and RefItemID in (39873,39894,39915,39936,39957,39978,39999,40020,40041,40062,40083,40104
       
Update SRO_VT_SHARD.._Items Set RefItemID='40209',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot '3' and ItemID 0) and RefItemID in (39873,39894,39915,39936,39957,39978,39999,40020,40041,40062,40083,40104)
       
Update SRO_VT_SHARD.._Items Set RefItemID='40230',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot '5' and ItemID 0) and RefItemID in (39873,39894,39915,39936,39957,39978,39999,40020,40041,40062,40083,40104)      
       
Update SRO_VT_SHARD.._Items Set RefItemID='40776',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot '0' and ItemID 0) and RefItemID in (40650,40671,40692,40713,40734,40755,40524,40545,40566,40587,40608,40629)
       
Update SRO_VT_SHARD.._Items Set RefItemID='40797',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot '2' and ItemID 0) and RefItemID in (40650,40671,40692,40713,40734,40755,40524,40545,40566,40587,40608,40629)
       
Update SRO_VT_SHARD.._Items Set RefItemID='40818',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot '1' and ItemID 0) and RefItemID in (40650,40671,40692,40713,40734,40755,40524,40545,40566,40587,40608,40629)
       
Update SRO_VT_SHARD.._Items Set RefItemID='40839',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot '4' and ItemID 0) and RefItemID in (40650,40671,40692,40713,40734,40755,40524,40545,40566,40587,40608,40629)
       
Update SRO_VT_SHARD.._Items Set RefItemID='40860',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot '3' and ItemID 0) and RefItemID in (40650,40671,40692,40713,40734,40755,40524,40545,40566,40587,40608,40629)
       
Update SRO_VT_SHARD.._Items Set RefItemID='40881',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot '5' and ItemID 0) and RefItemID in (40650,40671,40692,40713,40734,40755,40524,40545,40566,40587,40608,40629)
       
Update SRO_VT_SHARD.._Items Set RefItemID='41154',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot '0' and ItemID 0) and RefItemID in (41028,41049,41070,41091,41112,41133,40902,40923,40944,40965,40986,41007)
       
Update SRO_VT_SHARD.._Items Set RefItemID='41175',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot '2' and ItemID 0) and RefItemID in (41028,41049,41070,41091,41112,41133,40902,40923,40944,40965,40986,41007
       
Update SRO_VT_SHARD.._Items Set RefItemID='41196',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot '1' and ItemID 0) and RefItemID in (41028,41049,41070,41091,41112,41133,40902,40923,40944,40965,40986,41007)
       
Update SRO_VT_SHARD.._Items Set RefItemID='41217',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot '4' and ItemID 0) and RefItemID in (41028,41049,41070,41091,41112,41133,40902,40923,40944,40965,40986,41007
       
Update SRO_VT_SHARD.._Items Set RefItemID='41238',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot '3' and ItemID 0) and RefItemID in (41028,41049,41070,41091,41112,41133,40902,40923,40944,40965,40986,41007)
       
Update SRO_VT_SHARD.._Items Set RefItemID='41259',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot '5' and ItemID 0) and RefItemID in (41028,41049,41070,41091,41112,41133,40902,40923,40944,40965,40986,41007

_AddLogItem


كود PHP:
--- CH Weapon and Set Change
IF (@Operation 41)and(@ItemRefID 42099) --Ch Weapon change TO Sword
       Begin
       Update SRO_VT_SHARD
.._Items Set RefItemID='39369',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot '6' and ItemID 0) and RefItemID in (39390,39411,39432,39453
 
END
 
IF (@Operation 41)and(@ItemRefID 42100) --Ch Weapon change TO Blade
       Begin
       Update SRO_VT_SHARD
.._Items Set RefItemID='39390',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot '6' and ItemID 0) and RefItemID in (39369,39411,39432,39453
END
 
IF (@Operation 41)and(@ItemRefID 42101) --Ch Weapon change TO Spear
       BEGIN
       Update SRO_VT_SHARD
.._Items Set RefItemID='39411',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot '6' and ItemID 0) and RefItemID in (39369,39390,39432,39453)        
END
 
IF (@Operation 41)and(@ItemRefID 42102) --Ch Weapon change TO Glaive
       BEGIN
       Update SRO_VT_SHARD
.._Items Set RefItemID='39432',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot '6' and ItemID 0) and RefItemID in (39369,39390,39411,39453
END
  
IF (@Operation 41)and(@ItemRefID 42103) --Ch Weapon change TO Bow
       BEGIN
       Update SRO_VT_SHARD
.._Items Set RefItemID='39453',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot '6' and ItemID 0) and RefItemID in (39369,39390,39411,39432
END
IF (@Operation 41)and(@ItemRefID 42104) --Ch Set Garment Or Protector change TO Set Armor
       Begin
                     Execute 
[SRO_VT_SHARDLOG].[dbo].[_ChangeSystemH.A] @CharID
END
IF (@Operation 41)and(@ItemRefID 42105) --Ch Set Garment Or Armor change TO Set Protector
       Begin
              Execute 
[SRO_VT_SHARDLOG].[dbo].[_ChangeSystemL.A] @CharID
END
IF (@Operation 41)and(@ItemRefID 42106) --Ch Set Protector Or Armor change TO Set Garment
       Begin
              Execute 
[SRO_VT_SHARDLOG].[dbo].[_ChangeSystemRobe] @CharID
END
--- EU Weapon and Set Change
 
IF (@Operation 41)and(@ItemRefID 42107) --EU Weapon change TO Dagger
       Begin
       Update SRO_VT_SHARD
.._Items Set RefItemID='40314',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot '6' and ItemID 0) and RefItemID in (40335,40356,40377,40398,40419,40440,40461,40482
END
 
IF (@Operation 41)and(@ItemRefID 42108) --EU Weapon change TO CrossBow
       Begin
       Update SRO_VT_SHARD
.._Items Set RefItemID='40398',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot '6' and ItemID 0) and RefItemID in (40314,40335,40356,40377,40419,40440,40461,40482)  
END
 
IF (@Operation 41)and(@ItemRefID 42109) --EU Weapon change TO Axe
       Begin
       Update SRO_VT_SHARD
.._Items Set RefItemID='40377',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot '6' and ItemID 0) and RefItemID in (40314,40335,40356,40398,40419,40440,40461,40482
END
 
IF (@Operation 41)and(@ItemRefID 42110) --EU Weapon change TO One Hand Sword
       Begin
       Update SRO_VT_SHARD
.._Items Set RefItemID='40335',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot '6' and ItemID 0) and RefItemID in (40314,40356,40377,40398,40419,40440,40461,40482)  
END
 
IF (@Operation 41)and(@ItemRefID 42111) --EU Weapon change TO Two Hand Sword
       Begin
       Update SRO_VT_SHARD
.._Items Set RefItemID='40356',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot '6' and ItemID 0) and RefItemID in (40314,40335,40377,40398,40419,40440,40461,40482)  
END
 
IF (@Operation 41)and(@ItemRefID 42112) --EU Weapon change TO Two Hand Staff
       Begin
       Update SRO_VT_SHARD
.._Items Set RefItemID='40440',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot '6' and ItemID 0) and RefItemID in (40314,40335,40356,40377,40398,40419,40461,40482
END
 
IF (@Operation 41)and(@ItemRefID 42113) --EU Weapon change TO Claric Rod
       Begin
       Update SRO_VT_SHARD
.._Items Set RefItemID='40482',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot '6' and ItemID 0) and RefItemID in (40314,40335,40356,40377,40398,40419,40440,40461
END
 
IF (@Operation 41)and(@ItemRefID 42114) --EU Weapon change TO Warlock Rod
       Begin
       Update SRO_VT_SHARD
.._Items Set RefItemID='40419',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot '6' and ItemID 0) and RefItemID in (40314,40335,40356,40377,40398,40440,40461,40482
END
IF (@Operation 41)and(@ItemRefID 42115) --EU Weapon change TO Harp
       Begin
       Update SRO_VT_SHARD
.._Items Set RefItemID='40461',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot '6' and ItemID 0) and RefItemID in (40314,40335,40356,40377,40398,40419,40440,40482
END
IF (@Operation 41)and(@ItemRefID 42116) --EU Set Robe Or L.A change TO Set H.A
       Begin
                     Execute 
[SRO_VT_SHARDLOG].[dbo].[_ChangeSystemH.A] @CharID
END
IF (@Operation 41)and(@ItemRefID 42117) --EU Set Robe Or H.A change TO Set L.A
       Begin
              Execute 
[SRO_VT_SHARDLOG].[dbo].[_ChangeSystemL.A] @CharID
END
IF (@Operation 41)and(@ItemRefID 42118) --EU Set L.Or H.A change TO Set Robe
       Begin
              Execute 
[SRO_VT_SHARDLOG].[dbo].[_ChangeSystemRobe] @CharID
END 

وانا شغال علي system جديد لو اشتغل كويس يكون حاجة جديدة علي vsro
شكرا


توقيع HLP :
My New Intro
[YOUTUBE]OT4HWFbVuTk[/YOUTUBE]


التعديل الأخير تم بواسطة HLP ; 29-12-2015 الساعة 01:04 PM

رد مع اقتباس
قديم 28-12-2015, 05:16 PM   #8

™ EgY_KhaN ™
عضو متألق



الصورة الرمزية ™ EgY_KhaN ™


• الانـتـسـاب » Aug 2012
• رقـم العـضـويـة » 103935
• المشـــاركـات » 1,663
• الـدولـة » Mansoura
• الـهـوايـة » Love the Destruction
• اسـم الـسـيـرفـر » Private Server
• الـجـنـس » Male
• نقـاط التقييم » 54
™ EgY_KhaN ™ جـيـد

™ EgY_KhaN ™ غير متواجد حالياً

10648  


إرسال رسالة عبر Yahoo إلى ™ EgY_KhaN ™ إرسال رسالة عبر Skype إلى ™ EgY_KhaN ™

اوسمتي

افتراضي رد: Scroll CH&EU change Weapon & Set



شغل عالي استمر


توقيع ™ EgY_KhaN ™ :

EgY_KhaN is There !



رد مع اقتباس
قديم 28-12-2015, 07:25 PM   #9

Dev.Ri3o
عضو ذهبى



الصورة الرمزية Dev.Ri3o


• الانـتـسـاب » Apr 2015
• رقـم العـضـويـة » 121546
• المشـــاركـات » 4,033
• الـدولـة » https://t.me/pump_upp
• الـهـوايـة » MIS
• اسـم الـسـيـرفـر » No Server
• الـجـنـس » Male
• نقـاط التقييم » 45
Dev.Ri3o صـاعـد

Dev.Ri3o غير متواجد حالياً

9264  


إرسال رسالة عبر ICQ إلى Dev.Ri3o إرسال رسالة عبر AIM إلى Dev.Ri3o إرسال رسالة عبر Yahoo إلى Dev.Ri3o إرسال رسالة عبر Skype إلى Dev.Ri3o

افتراضي رد: Scroll CH&EU change Weapon & Set



تسلم ايدك


توقيع Dev.Ri3o :
عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ]


رد مع اقتباس
قديم 28-12-2015, 08:29 PM   #10

Xan
عضو فعال



الصورة الرمزية Xan


• الانـتـسـاب » Jun 2015
• رقـم العـضـويـة » 122406
• المشـــاركـات » 463
• الـدولـة » الأسكندريه
• الـهـوايـة » Developer
• اسـم الـسـيـرفـر » No Server
• الـجـنـس » Male
• نقـاط التقييم » 10
Xan صـاعـد

Xan غير متواجد حالياً

648  


إرسال رسالة عبر Yahoo إلى Xan إرسال رسالة عبر Skype إلى Xan

افتراضي رد: Scroll CH&EU change Weapon & Set



الله ينور .... جامد و فكره جديده


توقيع Xan :
Xan Is The Best

Developer $ SQL $ Protection



رد مع اقتباس
قديم 28-12-2015, 10:20 PM   #11

JanGanSRO
عضو فعال



الصورة الرمزية JanGanSRO


• الانـتـسـاب » Jul 2012
• رقـم العـضـويـة » 102590
• المشـــاركـات » 300
• الـدولـة » الاسكندريه
• الـهـوايـة » JuliusjefJD
• اسـم الـسـيـرفـر » Private Server
• الـجـنـس » Male
• نقـاط التقييم » 29
JanGanSRO صـاعـد

JanGanSRO غير متواجد حالياً

279  


إرسال رسالة عبر AIM إلى JanGanSRO إرسال رسالة عبر Yahoo إلى JanGanSRO إرسال رسالة عبر Skype إلى JanGanSRO

افتراضي رد: Scroll CH&EU change Weapon & Set



بصراحه موضوع جميل فكرت اعملو اكتر من مرة و كنت بكسل

تسلم الايادى


توقيع JanGanSRO :
عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ]


رد مع اقتباس
قديم 29-12-2015, 12:34 AM   #12

Gsxr
عضو نشيك





• الانـتـسـاب » Dec 2015
• رقـم العـضـويـة » 128676
• المشـــاركـات » 81
• الـدولـة »
• الـهـوايـة »
• اسـم الـسـيـرفـر » No Server
• الـجـنـس » Male
• نقـاط التقييم » 10
Gsxr صـاعـد

Gsxr غير متواجد حالياً

158  



افتراضي رد: Scroll CH&EU change Weapon & Set



فكرة كويسة انا هحطها في الجيم عندي شكرا




رد مع اقتباس
قديم 29-12-2015, 03:15 AM   #13

Mr.Rover
عضو فعال



الصورة الرمزية Mr.Rover


• الانـتـسـاب » Oct 2015
• رقـم العـضـويـة » 127461
• المشـــاركـات » 298
• الـدولـة » Tanta
• الـهـوايـة » Sql,DB,Media
• اسـم الـسـيـرفـر » Private Server
• الـجـنـس » Male
• نقـاط التقييم » 19
Mr.Rover صـاعـد

Mr.Rover غير متواجد حالياً

528  


إرسال رسالة عبر Yahoo إلى Mr.Rover

افتراضي رد: Scroll CH&EU change Weapon & Set



Keep up




رد مع اقتباس
قديم 29-12-2015, 10:54 AM   #14

merazz012
عضو لامع



الصورة الرمزية merazz012


• الانـتـسـاب » Jun 2008
• رقـم العـضـويـة » 23523
• المشـــاركـات » 1,199
• الـدولـة »
• الـهـوايـة » Dev>DataBase>PK2
• اسـم الـسـيـرفـر » Pavo
• الـجـنـس » Male
• نقـاط التقييم » 121
merazz012 جـيـدmerazz012 جـيـد

merazz012 غير متواجد حالياً

670  



افتراضي رد: Scroll CH&EU change Weapon & Set



تمام ! :]


توقيع merazz012 :
عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ]


رد مع اقتباس
قديم 29-12-2015, 12:49 PM   #15

HLP
عضو فعال



الصورة الرمزية HLP


• الانـتـسـاب » Mar 2013
• رقـم العـضـويـة » 110603
• المشـــاركـات » 352
• الـدولـة » Hurghada
• الـهـوايـة » DeveloP AnyThing
• اسـم الـسـيـرفـر » Private Server
• الـجـنـس » Male
• نقـاط التقييم » 14
HLP صـاعـد

HLP غير متواجد حالياً

401  


إرسال رسالة عبر Skype إلى HLP

افتراضي رد: Scroll CH&EU change Weapon & Set



اقتباس:
المشاركة الأصلية كتبت بواسطة elmagico123 عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ]
شغل عالي استمر
اقتباس:
المشاركة الأصلية كتبت بواسطة ameral عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ]
تسلم ايدك
اقتباس:
المشاركة الأصلية كتبت بواسطة Xan عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ]
الله ينور .... جامد و فكره جديده
اقتباس:
المشاركة الأصلية كتبت بواسطة JanGanSRO عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ]
بصراحه موضوع جميل فكرت اعملو اكتر من مرة و كنت بكسل

تسلم الايادى
اقتباس:
المشاركة الأصلية كتبت بواسطة Gsxr عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ]
فكرة كويسة انا هحطها في الجيم عندي شكرا
اقتباس:
المشاركة الأصلية كتبت بواسطة Mr.Rover عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ]
Keep up
اقتباس:
المشاركة الأصلية كتبت بواسطة merazz012 عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ]
تمام ! :]

شكرا يا رجاله


توقيع HLP :
My New Intro
[YOUTUBE]OT4HWFbVuTk[/YOUTUBE]



رد مع اقتباس
إضافة رد


يتصفح الموضوع حالياً : 1 (0 عضو و 1 زائر)
 
أدوات الموضوع
انواع عرض الموضوع

ضوابط المشاركة
لا تستطيع إضافة مواضيع جديدة
لا تستطيع الرد على المواضيع
لا تستطيع إرفاق ملفات
لا تستطيع تعديل مشاركاتك

BB code متاحة
كود [IMG] متاحة
كود HTML معطلة

الانتقال السريع


الساعة الآن 12:44 PM.

أقسام المنتدى

الـمـنـتـدى الـعـام @ مـنـاقـشـات عـامـة حـول سيلك رود أون لايـن @ قـسـم الـتـرحـيـب و الـتـعـارف @ صـور سـيـلك رود @ فـيـديـو سـيـلك رود @ أخـبـار سـيـلك رود أون لايـن @ مـنـتـدى لـعـبـة SilkroadOnline @ الـقـسـم الـتـعـلـيـمـى @ قـسـم الاسـئـلـه و الاسـتـفـسـارات حـول الـلـعـبـة @ قـسـم الـبـرامـج الـمـسـاعـدة @ الـمـنـتـدى الادارى @ قـسـم خـاص بـالـمـشـرفـيـن @ قـسـم الـشـكـاوى والاسـتـفـسـارات @ قـسـم الاقـتـراحـات @ قسم البيع والشراء (Gold) @ منتدى البيع( Gold) @ منتدى الشراء (Gold) @ مـنـتـدى الـبـرامـج والـحـمـايــة @ طريق الحرير بالسيرفر الكورى ( Korean SilkRoad ) @ قـسـم الـ AgBot @ منتدى بيع الأكونتات ( Accounts ) @ منتدى بيع اللبس والأسلحة ( Item ) @ منتدى شراء اللبس والأسلحة ( Item ) @ مـنـتـدى الـسـيـرفـرات والـجـايـلـدات الـعـربـيـة @ Flora @ Minerva @ Feronia @ Bellona @ منتدى سـيـرفـرات وجـايـلـدات [ Silkroad Online ] @ قسم المواضيع المكررة و المخالفة @ قسم الاستفسارات ومشاكل وحلول البوت @ مـنـتـدى الـبـوتـات والـبـرامـج اللازمـة لـتـشـغـيـل الـلـعـبـة @ قـسـم الـ PhBot @ -== قسم ال T-BOT ==- @ Ceres @ بـعـيـدآ عـن سـيـلـك رود @ سـجـل تـطـويـرات الـمـنـتـدى @ قـسـم الـسـيـرفـرات الـخـاصـة @ القـسـم الإسـلامـى الـعـام @ قـسـم الـحـمـايـة @ آرشـيـف الـمـواضـيـع الـمـمـيـزة @ قـسـم الـ StealthLite Bot @ قسم الاستفسارات ومشاكل وحلول ال Agbot @ قسم الاستفسارات ومشاكل وحلول ال StealthLite @ قسم الاستفسارات ومشاكل وحلول ال PHBOT @ قسم الاستفسارات ومشاكل وحلول ال T-BOT @ قـسـم الـ SroKing Bot @ قـسـم الـبـيـع والـشـراء [ Silkroad Online ] @ Flora @ Ceres @ Bellona @ Minerva @ Feronia @ قـسـم شـهـر رمـضـان الـمـبـارك 2020 @ اخـبـار الـتـقـنـيـة و الـتـكـنـولـوجـيـا @ قســم البــرامج العامــة @ قسم الاسئلة و الاستفسارات الخاصه بالبرامج والحماية @ ECSRO @ ECSRO(Fembria) @ ECSRO(VIP) @ SJSRO (OLD) @ SJSRO (new) @ sunworld @ قـسـم الـ IBot @ قـسـم الـريـاضـة الـعـامـة @ Vsro @ Rusro @ قـسـم الـبـيـع والـشـراء [ Private-SRO ] @ ZSZC & Aurora @ قـسـم الـ Sbot @ قـسـم الـ Mbot @ V.I.P Zone @ دردشة الاعضاء VIP @ قسم الدعم الفنى والاقتراحات VIP @ قـسـم تـعـديـل [ PK2 Edit ] @ Mysro @ الــمكتبة القرانية @ قسم الصوتيات والمرئيات الإسلامية @ قسم المكتبة الإسلامية @ قسم الاستفسارات ومشاكل وحلول ال IBOT @ قسم الاستفسارات ومشاكل وحلول ال Sbot @ قسم الاستفسارات ومشاكل وحلول ال Mbot @ قسم الاستفسارات ومشاكل وحلول ال Sroking @ Elite & Eroad @ DreamWorld @ قـسـم سـيـرفـرات وجـايـلـدات [ Silkroad-R ] @ Maycena @ قسم الاسئلة و الاستفسارات لعمل السيرفرات الخاصة @ قـسـم الـبـيـع والـشـراء [ Silkroad-R ] @ مـنـتـدى الـسـيـرفـرات الـخـاصـة - Private SRO @ Perfection @ Ex.Silkroad R @ SroKings @ قـسـم الـتـصـامـيـم والـجـرافـيـكـس @ Other Online Games @ قـسـم S4 League @ قسم CrossFire @ قسم Conquer Online @ قـسـم بـيـع وشـراء LOL @ تـحـمـيـل ألـعـاب Pc Games @ طلبات و استفسارات و مشاكل الالعاب @ Barons Online @ (AriesOnline (Pvp @ QueenSRO Network @ مشاكل & استفسارات S4 League @ مشاكل & استفسارات CrossFire @ World's Gate @ Sun-World @ قسم Aion @ قسم Continent Of The Ninth @ قسم World Of Warcraft @ PanicSro @ الـقـسـم الاخـبـارى @ قـسـم خـاص بـمـواضـيـع الاعـتـزال والاجازات @ IceSro-R @ Kings_Silkroad @ Justice Road @ ArabianRoadOnline Network @ Devias Online @ قـسـم طـلـبـات الـفـحـص @ CrossFire Fantasy Game @ قسم هاكات CrossFire @ مشاكل & استفسارات Aion @ مشاكل & استفسارات Conquer Online @ قسم الاسئله و استفسارات للعبة League Of Legends @ legenD road @ WantedSro Online @ قسم شروحات الشخصيات والبيلدات @ قسم الشروحات و البرامج المستخدمة في عمل السيرفرات الخاصة @ Mixsro @ قـسـم الـمـسـابـقـات والألـعـاب @ قـسـم الأسـئـلـة والاسـتـفـسـارات الـمـتـعـلـقـة بـ SRO-R @ LegenD Road @ Knights War Online @ Evolution Network @ FlagSRO Network @ Perfection (PvP) Network @ قـسـم هـاكـات S4league @ منتدى المنوعات @ حــرب العصــابــات @ قــســم الادارة الــعــلــيــا @ كــأس العالــم لـلاذى @ Destructions Network @ FanTasYWorld @ مـتـجـر خـدمـات وممـيـزات الـرصـيـد الـبـنـكـي @ Smart-Sro Online @ InFusion Online @ قـسـم الأنـمـى الـعـام @ Divine Online @ قـسـم Dota @ تـقـاريـر وأخـبـار ألـعـاب الـ PC @ GameXen Network @ inferno online @ منتدى عمل السيرفرات الخاصة @ قسم الحماية والاوتوايفنت للسيرفرات الخاصه @ الأسئلة و الاستفسارات الخاصة بالـ PK2 edit @ Velestia @ Punisher Sro Online @ Atlantis Online @ ALEXNADER SRO @ Hell World Online @ ImmortalRoad @ قـسـم الـ Centerbot @ قسم الاستفسارات ومشاكل وحلول ال Centerbot @ Time.Sro-Online @ Revenge (PVE) Online @ مـنـتـدى Silkroad4arab || Games Online @ ركن الالعاب الاون لاين و المتصفح Online Games @ قسم دروس التصميم (مونتاج - فوتوشوب) @ قسم ادوات التصميم و ملحقاتها @ قسم المانجا @ قسم تقارير الانمي @ دورة الفوتوشوب للمبتدئين @ الشروحات العامة @ قسم طلبات التعريفات @ مـسـودة الأعـضـاء @ Creddy Online @ Alliance-sro @ Quick Road (PvP ) @ قسم الاسئله والاستفسارات لعمل الفيديو @ منتدى لعبة League Of Legends @ أخبار ومناقشات League Of Legends @ قسم بيع وشراء لعبة CrossFire @ القسم التعليمي للعبة League Of Legends @ منتدى سيرفرات [ LOL ] @ North America @ EU West @ EU Nordic & East @ صـور و فـيـديـو League Of Legends @ قسم طلبات واستفسارات البيلدات والشخصيات @ قسم تقارير المخالفات والإنذارات @ قـسـم كـشـف الـدمـج و الـتـلـغـيـم @ قسم Wolf team @ قسم Dota 2 @ قسم Dragon nest @ قسم DC Universe Online @ قسم انظمة تشغيل Windows @ Quenth Online @ Wolf team Arabic @ RealDreamSro ( PvP ) @ EmpireSRO @ Amazing Sro @ Speed-sro @ . Destructions Network @ SilkRoad E 80 China @ قـسم المــواضـيع الـشعـريه والادبـيـه @ قـسـم اخـبـار الانـمـى @ Greats-sro Online @ قـسـم الـكـومـيـكـس @ منتدى الفحص @ Srowing @ Dakupra-Online @ حرب العصابات @ قسم خاص بالاسئله والاستفسارات الخاصة بالجرافيكس @ منتدى لغات البرمجة و التطوير @ قسم شروحات لغات البرمجة و التطوير @ مناقشات لغات البرمجة و التطوير @ قسم الاسئلة و الاستفسارات الخاصه بلغات البرمجة @ استراحة البوتاتــ @ PantuSRO @ القسم التجارى الرسمي ( Vps Hosting , Diacated server,Silkroad edit ) @ Tyr Online @ RocSro @ Legend Of Silkroad @ Pioneer Gaming-Network @ Valentus - CAP 80 @ MirrorSro @ Eridanus Online Cap90 @ Fear-Sro @ Silkroad-Z Online PVE @ طـلبات الاعضـاء @ Massive-Network @ Kryptonite-Sro @ DeathRoad @ Mysro Servers @ Devils Team @ DooMSRO Network @ EROAD SRO @ Story-SRO @ Ventrue-Online @ Settlers-SRO @ Electus Online @ MarsRoad Online @ Arrow Online @ Selene @ Hermes @ OldSro Online (cap 80 ) @ Sunroad @ Eloys Online @ Sentiero-Road Online @ Steam-Sro @ Arcane Reborn Online @ Eryxonline @ Vengeance Online @ Mirage Online @ SyndiCateOnline @ Desert Sro @ NeSro Network @ قسـم الـ Android @ قســم تــطويـر المــواقع والمــنتديـــات @ قـسـمـ الـلـهــو الـخــفــي @ MegaWar Sro @ Mirror Sro @ AdvancedSRO @ OblivionSilkroad @ Arrivals_Sro @ Amphibius Online @ Royal online @ Forbidden-Sro @ vanish-sro @ Majesty Online @ Chaos Network @ قـسـم الـ srAssist Bot @ قسم الاستفسارات ومشاكل وحلول ال srAssist Bot @ Damocles Sro @ Demo Sro @ KingsRoad @ Arius 9D ch & eu @ brother sro @ DreamWorld-Online @ Poseidon-Sro @ Ph-Sro @ Jupiet-Online @ Fury Sro @ JungleSro @ Xemia Games @ invctus-sro @ Revolution Gaming Network @ DemonSro @ Aeolus @ Golden Sro @ Chaos Network @ Chaos II Online @ Fallen Soul @ Xian @ Xian @ Revira online @ قسم اللياقة البدنية @ كاس العالم للاذي 2018 @ Unix Sro @ Immortal SRO @ قـسـم الاغـانـى الـعامة [English - Arabic - Videos] @ قـسـم الـرابــ (Rap) @ أرشـيـف الـمـواضـيـع الـمـمـيـزة @ Perfection SRO @ Rev-Sro @ Egypt Sro @ قـسـم خـاص بالـ Data Base @ قـسـم PUBG Mobile @ قـسـم Fortnite @ PureSRO @ Battle-Online @ قـسـم تـحـمـيـل الأفـلام الـعـربـيـة @ قـسـم الـسـيـرفـرات الـخـاصـة الـمـجـانـى @ URBANO-SRO @ Royalty-Road Online @ Zero-Online @ Anoha 140 PVE @ Anoha 140 PVE @ Exorue 80 CH @ Pantu-SRO @ Victor SRO @ Flare Online @ Terasus Online @ Aeolian Online @ Maygen Online @ Norges Online @ Ragnis Online @ قـسـم الـ [ ST-FILTER ] @ Requer Online @ الـقـسـم الـتـجـاري لـ ISRO [خاص فقط لبيع منتجات اللعبة الاصلية] @ Dynastic online @ مـنـتـدى الـسـيـرفـيـرات الـتـركـي والـروسـي @ قـسـم سـيـرفـرات وجـايـلـدات الـسـيـرفـر الـتـركـى [TR-SRO] @ Troy @ Smyrna @ Side @ Olympos @ Teos @ Perge @ قـسـم الـبـيـع والـشـراء الـسـيـرفـر الـتـركـي [ TR-SRO ] @ قـسـم سـيـرفـرات وجـايـلـدات الـسـيـرفـر الـروسـي [ RU-SRO ] @ قـسـم الـبـيـع والـشـراء الـسـيـرفـر الـروسـى [ RU-SRO ] @ Miele Online @ Old Silkroad - ZSZC @ Paranormal @ Aquarius Online @ T-SRO online @ Glory @ Serv Game @ Roxy Online @ Enfexia Online @ Aege Online CAP 110 @ Florian Online @ SroPace Online @ Elessea Online @ Dream World @ Asona Online @ Victus-R Online @ Rexall Online @ Pirate Online @ Xian Online @