[Mr.Serag]

لست أدرى من أين أبدا ؟! وهل تطاوعنى الكلمات ؟؟
فان الكلمات تتصاغر والعبارات تتضاءل ولكننى سأحاول
قدراً أستطاعتى وعسى ان اوفق فقد قال تعالى
(( وقل اعملوا فسيرى الله عملكم ورسولة والمؤمنين))

RefObjCommon

1    43606    ITEM_MALL_CHANGENAME    ???? ???? ??? (???)    xxx    SN_ITEM_MALL_CHANGENAME    SN_ITEM_MALL_CHANGENAME_TT_DESC    1    0    3    3    13    14    180000    3    0    1    1    1    255    0    1    0    0    129    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    Premium\etc\changename.ddj    xxx    xxx    22006

RefObjItem

22026    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    0    SKILL_MALL_REMOVEBLAV    -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    -1    xxx    -1    xxx    0    0    0

RefSkill

1    34038    1011    SKILL_MALL_REMOVEBLAV    ???? ????    SKILL_MALL_REMOVEBLAV    0    1    1    0    0    0    0    0    1000    0    0    0    3599    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    1    0    0    0    0    0    0    0    0    0    0    0    0    3    0    0    255    255    0    0    0    0    0    255    255    255    255    item\etc\giftcoins_1000.ddj    SN_ITEM_MALL_GIFTCOINS_1000    xxx    SN_ITEM_MALL_GIFTCOINS_1000_TT_DESC    xxx    0    0    3    1667396966    1851946342    1685418593    6000    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0

Procedure
_TimedJob

       if(@JobID= '34038') --Remover Blue Avatar 
        begin 
            SELECT @ItemID=ItemID from _Inventory where CharID = @CharID AND Slot = '13' 
            SELECT @RefItemID=RefItemID from _Items where ID64 = @ItemID 
            If (@RefItemID >='43620' AND @RefItemID <='43625') 
                         begin 
                        Update _Items Set MagParamNum = 0, MagParam1 = NULL, MagParam2 = NULL, MagParam3 = NULL, MagParam4 = NULL, MagParam5 = NULL, MagParam6 = NULL, MagParam7 = NULL, MagParam8 = NULL, MagParam9 = NULL, MagParam10 = NULL, MagParam11 = NULL, MagParam12 = NULL where ID64 = @ItemID 
                      end 
                        Else 
                        If (@RefItemID >='22912' AND @RefItemID <='22923') 
                          begin 
                         Update _Items Set MagParamNum = 0, MagParam1 = NULL, MagParam2 = NULL, MagParam3 = NULL, MagParam4 = NULL, MagParam5 = NULL, MagParam6 = NULL, MagParam7 = NULL, MagParam8 = NULL, MagParam9 = NULL, MagParam10 = NULL, MagParam11 = NULL, MagParam12 = NULL where ID64 = @ItemID 
                       end 
                        Else 
                          If (@RefItemID >='23272' AND @RefItemID <='23275') 
                          begin 
                         Update _Items Set MagParamNum = 0, MagParam1 = NULL, MagParam2 = NULL, MagParam3 = NULL, MagParam4 = NULL, MagParam5 = NULL, MagParam6 = NULL, MagParam7 = NULL, MagParam8 = NULL, MagParam9 = NULL, MagParam10 = NULL, MagParam11 = NULL, MagParam12 = NULL where ID64 = @ItemID 
                       end 
                        Else 
                          If (@RefItemID >='23320' AND @RefItemID <='23321') 
                          begin 
                         Update _Items Set MagParamNum = 0, MagParam1 = NULL, MagParam2 = NULL, MagParam3 = NULL, MagParam4 = NULL, MagParam5 = NULL, MagParam6 = NULL, MagParam7 = NULL, MagParam8 = NULL, MagParam9 = NULL, MagParam10 = NULL, MagParam11 = NULL, MagParam12 = NULL where ID64 = @ItemID 
                       end 
                        Else 
                          If (@RefItemID >='24262' AND @RefItemID <='24273') 
                          begin 
                         Update _Items Set MagParamNum = 0, MagParam1 = NULL, MagParam2 = NULL, MagParam3 = NULL, MagParam4 = NULL, MagParam5 = NULL, MagParam6 = NULL, MagParam7 = NULL, MagParam8 = NULL, MagParam9 = NULL, MagParam10 = NULL, MagParam11 = NULL, MagParam12 = NULL where ID64 = @ItemID 
                       end 
                        Else 
                          If (@RefItemID >='24298' AND @RefItemID <='24317') 
                          begin 
                         Update _Items Set MagParamNum = 0, MagParam1 = NULL, MagParam2 = NULL, MagParam3 = NULL, MagParam4 = NULL, MagParam5 = NULL, MagParam6 = NULL, MagParam7 = NULL, MagParam8 = NULL, MagParam9 = NULL, MagParam10 = NULL, MagParam11 = NULL, MagParam12 = NULL where ID64 = @ItemID 
                       end 
                        Else 
                          If (@RefItemID >='24351' AND @RefItemID <='24380') 
                          begin 
                         Update _Items Set MagParamNum = 0, MagParam1 = NULL, MagParam2 = NULL, MagParam3 = NULL, MagParam4 = NULL, MagParam5 = NULL, MagParam6 = NULL, MagParam7 = NULL, MagParam8 = NULL, MagParam9 = NULL, MagParam10 = NULL, MagParam11 = NULL, MagParam12 = NULL where ID64 = @ItemID 
                       end 
                        Else 
                          If (@RefItemID >='24405' AND @RefItemID <='24412') 
                          begin 
                         Update _Items Set MagParamNum = 0, MagParam1 = NULL, MagParam2 = NULL, MagParam3 = NULL, MagParam4 = NULL, MagParam5 = NULL, MagParam6 = NULL, MagParam7 = NULL, MagParam8 = NULL, MagParam9 = NULL, MagParam10 = NULL, MagParam11 = NULL, MagParam12 = NULL where ID64 = @ItemID 
                       end 
                        Else 
                          If (@RefItemID >='24644' AND @RefItemID <='24661') 
                          begin 
                         Update _Items Set MagParamNum = 0, MagParam1 = NULL, MagParam2 = NULL, MagParam3 = NULL, MagParam4 = NULL, MagParam5 = NULL, MagParam6 = NULL, MagParam7 = NULL, MagParam8 = NULL, MagParam9 = NULL, MagParam10 = NULL, MagParam11 = NULL, MagParam12 = NULL where ID64 = @ItemID 
                       end 
                        Else 
                        If (@RefItemID >='25799' AND @RefItemID <='25822') 
                          begin 
                         Update _Items Set MagParamNum = 0, MagParam1 = NULL, MagParam2 = NULL, MagParam3 = NULL, MagParam4 = NULL, MagParam5 = NULL, MagParam6 = NULL, MagParam7 = NULL, MagParam8 = NULL, MagParam9 = NULL, MagParam10 = NULL, MagParam11 = NULL, MagParam12 = NULL where ID64 = @ItemID 
                       end 
                        Else 
                          If (@RefItemID >='29403' AND @RefItemID <='29412') 
                          begin 
                         Update _Items Set MagParamNum = 0, MagParam1 = NULL, MagParam2 = NULL, MagParam3 = NULL, MagParam4 = NULL, MagParam5 = NULL, MagParam6 = NULL, MagParam7 = NULL, MagParam8 = NULL, MagParam9 = NULL, MagParam10 = NULL, MagParam11 = NULL, MagParam12 = NULL where ID64 = @ItemID 
                       end 
                        Else 
                          If (@RefItemID >='33814' AND @RefItemID <='33837') 
                          begin 
                         Update _Items Set MagParamNum = 0, MagParam1 = NULL, MagParam2 = NULL, MagParam3 = NULL, MagParam4 = NULL, MagParam5 = NULL, MagParam6 = NULL, MagParam7 = NULL, MagParam8 = NULL, MagParam9 = NULL, MagParam10 = NULL, MagParam11 = NULL, MagParam12 = NULL where ID64 = @ItemID 
                       end 
                        Else 
                          If (@RefItemID >='35578' AND @RefItemID <='35581') 
                          begin 
                         Update _Items Set MagParamNum = 0, MagParam1 = NULL, MagParam2 = NULL, MagParam3 = NULL, MagParam4 = NULL, MagParam5 = NULL, MagParam6 = NULL, MagParam7 = NULL, MagParam8 = NULL, MagParam9 = NULL, MagParam10 = NULL, MagParam11 = NULL, MagParam12 = NULL where ID64 = @ItemID 
                       end 
                        Else 
                          If (@RefItemID >='35586' AND @RefItemID <='35591') 
                          begin 
                         Update _Items Set MagParamNum = 0, MagParam1 = NULL, MagParam2 = NULL, MagParam3 = NULL, MagParam4 = NULL, MagParam5 = NULL, MagParam6 = NULL, MagParam7 = NULL, MagParam8 = NULL, MagParam9 = NULL, MagParam10 = NULL, MagParam11 = NULL, MagParam12 = NULL where ID64 = @ItemID 
                       end 
                        Else 
                          If (@RefItemID >='36750' AND @RefItemID <='36753') 
                          begin 
                         Update _Items Set MagParamNum = 0, MagParam1 = NULL, MagParam2 = NULL, MagParam3 = NULL, MagParam4 = NULL, MagParam5 = NULL, MagParam6 = NULL, MagParam7 = NULL, MagParam8 = NULL, MagParam9 = NULL, MagParam10 = NULL, MagParam11 = NULL, MagParam12 = NULL where ID64 = @ItemID 
                       end 
                        Else 
                          If (@RefItemID >='36806' AND @RefItemID <='36811') 
                          begin 
                         Update _Items Set MagParamNum = 0, MagParam1 = NULL, MagParam2 = NULL, MagParam3 = NULL, MagParam4 = NULL, MagParam5 = NULL, MagParam6 = NULL, MagParam7 = NULL, MagParam8 = NULL, MagParam9 = NULL, MagParam10 = NULL, MagParam11 = NULL, MagParam12 = NULL where ID64 = @ItemID 
                       end 
                        Else 
                          If (@RefItemID >='36915' AND @RefItemID <='36932') 
                          begin 
                         Update _Items Set MagParamNum = 0, MagParam1 = NULL, MagParam2 = NULL, MagParam3 = NULL, MagParam4 = NULL, MagParam5 = NULL, MagParam6 = NULL, MagParam7 = NULL, MagParam8 = NULL, MagParam9 = NULL, MagParam10 = NULL, MagParam11 = NULL, MagParam12 = NULL where ID64 = @ItemID 
                       end 
                        Else 
                          If (@RefItemID >='38802' AND @RefItemID <='38815') 
                          begin 
                         Update _Items Set MagParamNum = 0, MagParam1 = NULL, MagParam2 = NULL, MagParam3 = NULL, MagParam4 = NULL, MagParam5 = NULL, MagParam6 = NULL, MagParam7 = NULL, MagParam8 = NULL, MagParam9 = NULL, MagParam10 = NULL, MagParam11 = NULL, MagParam12 = NULL where ID64 = @ItemID 
                       end 
                        Else 
                          If (@RefItemID >='38838' AND @RefItemID <='38841') 
                          begin 
                         Update _Items Set MagParamNum = 0, MagParam1 = NULL, MagParam2 = NULL, MagParam3 = NULL, MagParam4 = NULL, MagParam5 = NULL, MagParam6 = NULL, MagParam7 = NULL, MagParam8 = NULL, MagParam9 = NULL, MagParam10 = NULL, MagParam11 = NULL, MagParam12 = NULL where ID64 = @ItemID 
                       end 
                        Else 
                          If (@RefItemID >='38966' AND @RefItemID <='38969') 
                          begin 
                         Update _Items Set MagParamNum = 0, MagParam1 = NULL, MagParam2 = NULL, MagParam3 = NULL, MagParam4 = NULL, MagParam5 = NULL, MagParam6 = NULL, MagParam7 = NULL, MagParam8 = NULL, MagParam9 = NULL, MagParam10 = NULL, MagParam11 = NULL, MagParam12 = NULL where ID64 = @ItemID 
                       end 
                        Else 
                          If (@RefItemID >='39286' AND @RefItemID <='39303') 
                          begin 
                         Update _Items Set MagParamNum = 0, MagParam1 = NULL, MagParam2 = NULL, MagParam3 = NULL, MagParam4 = NULL, MagParam5 = NULL, MagParam6 = NULL, MagParam7 = NULL, MagParam8 = NULL, MagParam9 = NULL, MagParam10 = NULL, MagParam11 = NULL, MagParam12 = NULL where ID64 = @ItemID 
                       end 
                        Else 
                          If (@RefItemID >='41473' AND @RefItemID <='41520') 
                          begin 
                         Update _Items Set MagParamNum = 0, MagParam1 = NULL, MagParam2 = NULL, MagParam3 = NULL, MagParam4 = NULL, MagParam5 = NULL, MagParam6 = NULL, MagParam7 = NULL, MagParam8 = NULL, MagParam9 = NULL, MagParam10 = NULL, MagParam11 = NULL, MagParam12 = NULL where ID64 = @ItemID 
                       end 
                        Else 
                          If (@RefItemID >='41798' AND @RefItemID <='41803') 
                          begin 
                         Update _Items Set MagParamNum = 0, MagParam1 = NULL, MagParam2 = NULL, MagParam3 = NULL, MagParam4 = NULL, MagParam5 = NULL, MagParam6 = NULL, MagParam7 = NULL, MagParam8 = NULL, MagParam9 = NULL, MagParam10 = NULL, MagParam11 = NULL, MagParam12 = NULL where ID64 = @ItemID 
                       end 
                        Else 
                          If (@RefItemID >='41833' AND @RefItemID <='41844') 
                          begin 
                         Update _Items Set MagParamNum = 0, MagParam1 = NULL, MagParam2 = NULL, MagParam3 = NULL, MagParam4 = NULL, MagParam5 = NULL, MagParam6 = NULL, MagParam7 = NULL, MagParam8 = NULL, MagParam9 = NULL, MagParam10 = NULL, MagParam11 = NULL, MagParam12 = NULL where ID64 = @ItemID 
                       end 
                        Else 
                          If (@RefItemID >='41946' AND @RefItemID <='41955') 
                          begin 
                         Update _Items Set MagParamNum = 0, MagParam1 = NULL, MagParam2 = NULL, MagParam3 = NULL, MagParam4 = NULL, MagParam5 = NULL, MagParam6 = NULL, MagParam7 = NULL, MagParam8 = NULL, MagParam9 = NULL, MagParam10 = NULL, MagParam11 = NULL, MagParam12 = NULL where ID64 = @ItemID 
                          end 
                        Else 
                          If (@RefItemID >='42713' AND @RefItemID <='42722') 
                          begin 
                         Update _Items Set MagParamNum = 0, MagParam1 = NULL, MagParam2 = NULL, MagParam3 = NULL, MagParam4 = NULL, MagParam5 = NULL, MagParam6 = NULL, MagParam7 = NULL, MagParam8 = NULL, MagParam9 = NULL, MagParam10 = NULL, MagParam11 = NULL, MagParam12 = NULL where ID64 = @ItemID 
                       end 
                        Else 
                          If (@RefItemID >='43009' AND @RefItemID <='43014') 
                          begin 
                         Update _Items Set MagParamNum = 0, MagParam1 = NULL, MagParam2 = NULL, MagParam3 = NULL, MagParam4 = NULL, MagParam5 = NULL, MagParam6 = NULL, MagParam7 = NULL, MagParam8 = NULL, MagParam9 = NULL, MagParam10 = NULL, MagParam11 = NULL, MagParam12 = NULL where ID64 = @ItemID 
                       end 
                        Else 
                          If (@RefItemID >='43584' AND @RefItemID <='43589') 
                          begin 
                         Update _Items Set MagParamNum = 0, MagParam1 = NULL, MagParam2 = NULL, MagParam3 = NULL, MagParam4 = NULL, MagParam5 = NULL, MagParam6 = NULL, MagParam7 = NULL, MagParam8 = NULL, MagParam9 = NULL, MagParam10 = NULL, MagParam11 = NULL, MagParam12 = NULL where ID64 = @ItemID 
                       end 
            return -3 
        end

منقول

في النهاية لا أملك إلا أن أقول أنني قد عرضت رأيي وأدليت بفكرتي في هذا الموضوع
لعلي أكون قد وفقت في كتابته والتعبير عنه وأخيراً ما أنا إلا بشر قد أخطئ
وقد أصيب فإن كنت قد أخطأت فأرجو مسامحتي وإن كنت فد أصبت فهذا كل ما أرجوه من الله عزوجل.