الـجـروب الـخـاص بـالـمـنـتـدي Silkroad4arab Facebook | Official Group

**Hamza FiGo** · 05-04-2015, 07:58 PM

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

**Xan** · 20-06-2015, 11:19 PM

دايما بتبهرنا يا EsoOo و مستنيين كمان Tbe Best

**Xan** · 23-06-2015, 05:40 AM

الله ينور يا أسلام فعلا دماغك دي جاااااااامده :D

**Mr.Viper** · 25-06-2015, 07:24 AM

Good job

**ahmednade** · 13-12-2016, 07:36 PM

Thenks ya 7Opy

**افندينا ™Hamboka™** · 19-12-2016, 02:49 PM

تسلم

**Dev.Ahmed_Elnashary** · 06-02-2017, 01:54 AM

تمام !

**hodamoseba** · 26-11-2017, 10:50 PM

Msg 102, Level 15, State 1, Procedure _AddLogItem, Line 408
Incorrect syntax near 'end'.

ممكن حل

دة البروسيد

كود بلغة HTML:

  if(@Operation = 41 and @ItemRefID= '42279') 
 BEGIN  
    Update SRO_VT_SHARD.._Char Set HwanLevel = '5' Where CharID = @CharID 

  if(@Operation = 41 and @ItemRefID= '42280') 
 BEGIN  
    Update SRO_VT_SHARD.._Char Set HwanLevel = '6' Where CharID = @CharID 

  if(@Operation = 41 and @ItemRefID= '422811') 
 BEGIN  
    Update SRO_VT_SHARD.._Char Set HwanLevel = '7' Where CharID = @CharID 

  if(@Operation = 41 and @ItemRefID= '42282') 
 BEGIN  
    Update SRO_VT_SHARD.._Char Set HwanLevel = '8' Where CharID = @CharID 

  if(@Operation = 41 and @ItemRefID= '42283') 
 BEGIN  
    Update SRO_VT_SHARD.._Char Set HwanLevel = '9' Where CharID = @CharID 

  if(@Operation = 41 and @ItemRefID= '42284') 
 BEGIN  
    Update SRO_VT_SHARD.._Char Set HwanLevel = '10' Where CharID = @CharID 

  if(@Operation = 41 and @ItemRefID= '42285') 
 BEGIN  
    Update SRO_VT_SHARD.._Char Set HwanLevel = '11' Where CharID = @CharID 

  if(@Operation = 41 and @ItemRefID= '42286') 
 BEGIN  
    Update SRO_VT_SHARD.._Char Set HwanLevel = '12' Where CharID = @CharID 

  if(@Operation = 41 and @ItemRefID= '42287') 
 BEGIN  
    Update SRO_VT_SHARD.._Char Set HwanLevel = '13' Where CharID = @CharID 

  if(@Operation = 41 and @ItemRefID= '42288') 
 BEGIN  
    Update SRO_VT_SHARD.._Char Set HwanLevel = '14' Where CharID = @CharID 

  if(@Operation = 41 and @ItemRefID= '42289') 
 BEGIN  
    Update SRO_VT_SHARD.._Char Set HwanLevel = '15' Where CharID = @CharID 

  if(@Operation = 41 and @ItemRefID= '42290') 
 BEGIN  
    Update SRO_VT_SHARD.._Char Set HwanLevel = '16' Where CharID = @CharID 

  if(@Operation = 41 and @ItemRefID= '42291') 
 BEGIN  
    Update SRO_VT_SHARD.._Char Set HwanLevel = '17' Where CharID = @CharID 

  if(@Operation = 41 and @ItemRefID= '42292') 
 BEGIN  
    Update SRO_VT_SHARD.._Char Set HwanLevel = '18' Where CharID = @CharID 

  if(@Operation = 41 and @ItemRefID= '42293') 
 BEGIN  
    Update SRO_VT_SHARD.._Char Set HwanLevel = '19' Where CharID = @CharID 

  if(@Operation = 41 and @ItemRefID= '42294') 
 BEGIN  
    Update SRO_VT_SHARD.._Char Set HwanLevel = '20' Where CharID = @CharID 

  if(@Operation = 41 and @ItemRefID= '42295') 
 BEGIN  
    Update SRO_VT_SHARD.._Char Set HwanLevel = '21' Where CharID = @CharID 

  if(@Operation = 41 and @ItemRefID= '42296') 
 BEGIN  
    Update SRO_VT_SHARD.._Char Set HwanLevel = '22' Where CharID = @CharID 

  if(@Operation = 41 and @ItemRefID= '42297') 
 BEGIN  
    Update SRO_VT_SHARD.._Char Set HwanLevel = '23' Where CharID = @CharID 

  if(@Operation = 41 and @ItemRefID= '42298') 
 BEGIN  
    Update SRO_VT_SHARD.._Char Set HwanLevel = '24' Where CharID = @CharID 

  if(@Operation = 41 and @ItemRefID= '42299') 
 BEGIN  
    Update SRO_VT_SHARD.._Char Set HwanLevel = '25' Where CharID = @CharID 

  if(@Operation = 41 and @ItemRefID= '42300') 
 BEGIN  
    Update SRO_VT_SHARD.._Char Set HwanLevel = '26' Where CharID = @CharID 

  if(@Operation = 41 and @ItemRefID= '42301') 
 BEGIN  
    Update SRO_VT_SHARD.._Char Set HwanLevel = '27' Where CharID = @CharID 

  if(@Operation = 41 and @ItemRefID= '42302') 
 BEGIN  
    Update SRO_VT_SHARD.._Char Set HwanLevel = '28' Where CharID = @CharID 

  if(@Operation = 41 and @ItemRefID= '42303') 
 BEGIN  
    Update SRO_VT_SHARD.._Char Set HwanLevel = '29' Where CharID = @CharID 

  if(@Operation = 41 and @ItemRefID= '42304') 
 BEGIN  
    Update SRO_VT_SHARD.._Char Set HwanLevel = '30' Where CharID = @CharID 

  if(@Operation = 41 and @ItemRefID= '42305') 
 BEGIN  
    Update SRO_VT_SHARD.._Char Set HwanLevel = '31' Where CharID = @CharID 

  if(@Operation = 41 and @ItemRefID= '42306') 
 BEGIN  
    Update SRO_VT_SHARD.._Char Set HwanLevel = '32' Where CharID = @CharID 

  if(@Operation = 41 and @ItemRefID= '42307') 
 BEGIN  
    Update SRO_VT_SHARD.._Char Set HwanLevel = '33' Where CharID = @CharID 

  if(@Operation = 41 and @ItemRefID= '42308') 
 BEGIN  
    Update SRO_VT_SHARD.._Char Set HwanLevel = '34' Where CharID = @CharID

**TheBold** · 27-11-2017, 08:47 PM

اقتباس:

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

Msg 102, Level 15, State 1, Procedure _AddLogItem, Line 408
Incorrect syntax near 'end'.

ممكن حل

دة البروسيد

كود بلغة HTML:

if(@Operation = 41 and @ItemRefID= '42279') BEGIN Update SRO_VT_SHARD.._Char Set HwanLevel = '5' Where CharID = @CharID if(@Operation = 41 and @ItemRefID= '42280') BEGIN Update SRO_VT_SHARD.._Char Set HwanLevel = '6' Where CharID = @CharID if(@Operation = 41 and @ItemRefID= '422811') BEGIN Update SRO_VT_SHARD.._Char Set HwanLevel = '7' Where CharID = @CharID if(@Operation = 41 and @ItemRefID= '42282') BEGIN Update SRO_VT_SHARD.._Char Set HwanLevel = '8' Where CharID = @CharID if(@Operation = 41 and @ItemRefID= '42283') BEGIN Update SRO_VT_SHARD.._Char Set HwanLevel = '9' Where CharID = @CharID if(@Operation = 41 and @ItemRefID= '42284') BEGIN Update SRO_VT_SHARD.._Char Set HwanLevel = '10' Where CharID = @CharID if(@Operation = 41 and @ItemRefID= '42285') BEGIN Update SRO_VT_SHARD.._Char Set HwanLevel = '11' Where CharID = @CharID if(@Operation = 41 and @ItemRefID= '42286') BEGIN Update SRO_VT_SHARD.._Char Set HwanLevel = '12' Where CharID = @CharID if(@Operation = 41 and @ItemRefID= '42287') BEGIN Update SRO_VT_SHARD.._Char Set HwanLevel = '13' Where CharID = @CharID if(@Operation = 41 and @ItemRefID= '42288') BEGIN Update SRO_VT_SHARD.._Char Set HwanLevel = '14' Where CharID = @CharID if(@Operation = 41 and @ItemRefID= '42289') BEGIN Update SRO_VT_SHARD.._Char Set HwanLevel = '15' Where CharID = @CharID if(@Operation = 41 and @ItemRefID= '42290') BEGIN Update SRO_VT_SHARD.._Char Set HwanLevel = '16' Where CharID = @CharID if(@Operation = 41 and @ItemRefID= '42291') BEGIN Update SRO_VT_SHARD.._Char Set HwanLevel = '17' Where CharID = @CharID if(@Operation = 41 and @ItemRefID= '42292') BEGIN Update SRO_VT_SHARD.._Char Set HwanLevel = '18' Where CharID = @CharID if(@Operation = 41 and @ItemRefID= '42293') BEGIN Update SRO_VT_SHARD.._Char Set HwanLevel = '19' Where CharID = @CharID if(@Operation = 41 and @ItemRefID= '42294') BEGIN Update SRO_VT_SHARD.._Char Set HwanLevel = '20' Where CharID = @CharID if(@Operation = 41 and @ItemRefID= '42295') BEGIN Update SRO_VT_SHARD.._Char Set HwanLevel = '21' Where CharID = @CharID if(@Operation = 41 and @ItemRefID= '42296') BEGIN Update SRO_VT_SHARD.._Char Set HwanLevel = '22' Where CharID = @CharID if(@Operation = 41 and @ItemRefID= '42297') BEGIN Update SRO_VT_SHARD.._Char Set HwanLevel = '23' Where CharID = @CharID if(@Operation = 41 and @ItemRefID= '42298') BEGIN Update SRO_VT_SHARD.._Char Set HwanLevel = '24' Where CharID = @CharID if(@Operation = 41 and @ItemRefID= '42299') BEGIN Update SRO_VT_SHARD.._Char Set HwanLevel = '25' Where CharID = @CharID if(@Operation = 41 and @ItemRefID= '42300') BEGIN Update SRO_VT_SHARD.._Char Set HwanLevel = '26' Where CharID = @CharID if(@Operation = 41 and @ItemRefID= '42301') BEGIN Update SRO_VT_SHARD.._Char Set HwanLevel = '27' Where CharID = @CharID if(@Operation = 41 and @ItemRefID= '42302') BEGIN Update SRO_VT_SHARD.._Char Set HwanLevel = '28' Where CharID = @CharID if(@Operation = 41 and @ItemRefID= '42303') BEGIN Update SRO_VT_SHARD.._Char Set HwanLevel = '29' Where CharID = @CharID if(@Operation = 41 and @ItemRefID= '42304') BEGIN Update SRO_VT_SHARD.._Char Set HwanLevel = '30' Where CharID = @CharID if(@Operation = 41 and @ItemRefID= '42305') BEGIN Update SRO_VT_SHARD.._Char Set HwanLevel = '31' Where CharID = @CharID if(@Operation = 41 and @ItemRefID= '42306') BEGIN Update SRO_VT_SHARD.._Char Set HwanLevel = '32' Where CharID = @CharID if(@Operation = 41 and @ItemRefID= '42307') BEGIN Update SRO_VT_SHARD.._Char Set HwanLevel = '33' Where CharID = @CharID if(@Operation = 41 and @ItemRefID= '42308') BEGIN Update SRO_VT_SHARD.._Char Set HwanLevel = '34' Where CharID = @CharID

اسم الداتا عندك اية و اخر الـ HwanLevel عندكم كام ؟!

**F77** · 27-11-2017, 12:28 AM

ضيف كلمة END تحت كل بروسيدر
زي كده

كود بلغة HTML:

 if(@Operation = 41 and @ItemRefID= '42300') 
 BEGIN  
    Update SRO_VT_SHARD.._Char Set HwanLevel = '26' Where CharID = @CharID 
END

**TheBold** · 27-11-2017, 01:23 AM

جاري التجربة

**hodamoseba** · 27-11-2017, 11:04 AM

نفس المشكلة

**F77** · 27-11-2017, 05:01 PM

ما هي شغالة عندي نفس المشكلة فين بقا
ضفها فى AddLogItem بعد as

كود بلغة HTML:

if(@Operation = 41 and @ItemRefID= '122414') BEGIN Update SRO_VT_SHARD.._Char Set HwanLevel = '10' Where CharID = @CharID END

**F77** · 27-11-2017, 09:19 PM

يا معلم افهم بس
ده اسم الداتا بتاعتك SRO_VT_SHARD
ده رقم التيتل نيم عندك HwanLevel = '20'
ده رقم السكرول ItemRefID= '42290

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

كود بلغة HTML:

 
  if(@Operation = 41 and @ItemRefID= '122414') 
          BEGIN  
Update SRO_VT_SHARD.._Char Set HwanLevel = '10' Where CharID = @CharID 
END

**Scrox** · 27-11-2017, 11:08 PM

جميل

المواضيع المتشابهه
الموضوع	كاتب الموضوع	المنتدى	الردود	آخر مشاركة
Title Name Scroll (Help)	Howdare	قـسـم الاسـئـلـه و الاسـتـفـسـارات حـول الـلـعـبـة	2	12-04-2018 02:55 AM
Title Name Scroll (Help)	HB#	قسم الاسئلة و الاستفسارات لعمل السيرفرات الخاصة	8	22-07-2017 06:30 AM
Scroll Change Name With New System Dev By EsoOo	Genius Eslam Esoo	قسم الشروحات و البرامج المستخدمة في عمل السيرفرات الخاصة	8	05-04-2015 08:19 PM

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

	تسجيل الدخول دائمآ