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

**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 عندكم كام ؟!

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

	ط·آ§ط¸â€‍ط·آ¨ط¸â€ڑط·آ§ط·طŒ ط¸â€¦ط·آ³ط·آ¬ط¸â€‍ ط·آ¯ط·آ§ط·آ¦ط¸â€¦ط·آ¢

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