الـجـروب الـخـاص بـالـمـنـتـدي Silkroad4arab 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 عندكم كام ؟!

المواضيع المتشابهه
الموضوع	كاتب الموضوع	المنتدى	الردود	آخر مشاركة
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 زائر)

	البقاء مسجل دائمآ