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

**Hero** · 04-04-2015, 07:39 PM

تسلم ايدك "]

**Dev. iLegend** · 05-04-2015, 01:31 AM

يا باشا حضرتك التوقيع بتاعك ممنوع انك تعمل فيه إعلانات لنفسك وللينك موقع بيع وملفات بدون سكان من المنتدي من فضلك إقرا القوانين وأرجو تعديل التوقيع بأسرع وقت قبل عمل ريبورت لإدارة المنتدي

**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

**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

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

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

	حفظ بياناتي ؟

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