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

**Mr.Serag** · 01-06-2013, 12:45 AM

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

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

منقول

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

**ELjOkeR** · 01-06-2013, 01:17 AM

Approved #

**S4A_Knight** · 01-06-2013, 05:42 AM

شكرا يا باشا

**Mr.Serag** · 01-06-2013, 08:07 AM

العفو

**StayAlive-Online** · 01-06-2013, 06:02 PM

معلش لحظة يا باشا

اسم الموضوع scroll for change char name

و البروسيديور ملهوش علاقه بتغيير اسم الكاركتر
ملخص شرح البروسيديور
انو بيشيل البلو اللى بيكون على الافاتارات لما تكون لابس افاتار فيه بلوو

انت جربت الموضوع ده عندك و لا اخدتو كوبى من ريججزون و حطيتو هنا على طول من غير ما تجربو

لان البروسيديور اللى مكتوب فى ريجزون و اللى انت واخدو كوبى و حاطو هنا على طول مكتوب غلط

و الراجل اللى كاتب الموضوع مش محدد حيتحط فين بالظبط فى البروسديور بتاع addtimedjop

لو عندك الشرح الكامل ياريت تكتبو يا اما انتظروا موضوع كامل لحاجات دى لانى فعلا جربتهم و عدلت عليهم و كلهم شغالين عندى فى السيرفر و الحمد لله

**MyRȝturn** · 01-06-2013, 06:42 PM

كود PHP:

if(@JobID= '34038') --Remover Blue Avatar

ايه ده
نقل وخلاص

**StayAlive-Online** · 03-06-2013, 09:30 AM

بعد ازن المشرفين و مدير المنتدى

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

دة لينك موضوع انا شرحت فيه ازاى تقدر تضيف الاسكرولات دى و فكرة شغلها على المنتدى عندى

انا نزلت اللينك هنا بعد ما عملت الموضوع على طول فى المنتدى عندى لانى تعبت و عاوز انام و اول ما اصحى ان شاء الله حعمل موضوع جديد فى المنتدى هنا اشرحها تانى لانى عارف ان ممنوع كتابه اى لينك خارجى فى المنتدى

**AnaElKbeerHena** · 26-04-2014, 11:35 AM

فين الميديا ؟

**Xeitran** · 01-05-2014, 10:27 PM

شكراً يا باشا

**Hero** · 05-05-2014, 03:08 PM

حضرتك الموضوع ناقص
بس انا ان شاء الله هعمل موضوع كامل
صورة من الجيم بتاعى

**iLead** · 19-05-2014, 11:26 PM

ايه ده ؟

كود PHP:


			
  if(@JobID= '34038') --Remover Blue Avatar

Copy & Paste Like Kid's

**Dev.Ri3o** · 15-07-2015, 07:33 PM

يعنى انت جايب الموضوع ناقص و مفهوش تعديل ال Media و كمان مفيش اى شرح للبروسيدور

**MR.KaBO** · 17-01-2016, 01:34 AM

تسلم والله علي الموضوع

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

	حفظ بياناتي ؟

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