Proseed help

[hodamoseba]

عاوز اضيف البروسيد دة اعمل اية بيجبلى خطا

**IF*(@Operation*=*41*and*@ItemRefID*=*42281*/*id*el*scroll*hena*/)**-----Made*By*#Xan
****BEGIN
********DECLARE*@MLevel*INT*=*(SELECT*MaxLevel*FRO M*SRO_VT_SHARD.._Char*WHERE*CharID=@CharID)
************IF*(@MLevel*between*114*and*115)
****************BEGIN
********************DECLARE*@CharName*varchar(Max) *=*(SELECT*CharName16*FROM*SRO_VT_SHARD.._Char*WHE RE*CharID=@CharID)
********************UPDATE*SRO_VT_SHARD.dbo._Char* Set*CurLevel=116,MaxLevel=116,Strength+=(116-@MLevel),Intellect+=(116-@MLevel),RemainStatPoint+=((116-@MLevel)*3)*WHERE*CharID=@CharID
****************END
****END*
**IF*(@Operation*=*41*and*@ItemRefID*=*42282*/*id*el*scroll*hena*/)**-----Made*By*#Xan
****BEGIN
********DECLARE*@MLevel*INT*=*(SELECT*MaxLevel*FRO M*SRO_VT_SHARD.._Char*WHERE*CharID=@CharID)
************IF*(@MLevel*between*114*and*115)
****************BEGIN
********************DECLARE*@CharName*varchar(Max) *=*(SELECT*CharName16*FROM*SRO_VT_SHARD.._Char*WHE RE*CharID=@CharID)
********************UPDATE*SRO_VT_SHARD.dbo._Char* Set*CurLevel=117,MaxLevel=117,Strength+=(117-@MLevel),Intellect+=(117-@MLevel),RemainStatPoint+=((117-@MLevel)*3)*WHERE*CharID=@CharID
****************END
****END*
**IF*(@Operation*=*41*and*@ItemRefID*=*42283*/*id*el*scroll*hena*/)**-----Made*By*#Xan
****BEGIN
********DECLARE*@MLevel*INT*=*(SELECT*MaxLevel*FRO M*SRO_VT_SHARD.._Char*WHERE*CharID=@CharID)
************IF*(@MLevel*between*114*and*115)
****************BEGIN
********************DECLARE*@CharName*varchar(Max) *=*(SELECT*CharName16*FROM*SRO_VT_SHARD.._Char*WHE RE*CharID=@CharID)
********************UPDATE*SRO_VT_SHARD.dbo._Char* Set*CurLevel=118,MaxLevel=118,Strength+=(118-@MLevel),Intellect+=(118-@MLevel),RemainStatPoint+=((118-@MLevel)*3)*WHERE*CharID=@CharID
****************END
****END*
**IF*(@Operation*=*41*and*@ItemRefID*=*42284*/*id*el*scroll*hena*/)**-----Made*By*#Xan
****BEGIN
********DECLARE*@MLevel*INT*=*(SELECT*MaxLevel*FRO M*SRO_VT_SHARD.._Char*WHERE*CharID=@CharID)
************IF*(@MLevel*between*114*and*115)
****************BEGIN
********************DECLARE*@CharName*varchar(Max) *=*(SELECT*CharName16*FROM*SRO_VT_SHARD.._Char*WHE RE*CharID=@CharID)
********************UPDATE*SRO_VT_SHARD.dbo._Char* Set*CurLevel=119,MaxLevel=119,Strength+=(119-@MLevel),Intellect+=(119-@MLevel),RemainStatPoint+=((119-@MLevel)*3)*WHERE*CharID=@CharID
****************END
****END*
**IF*(@Operation*=*41*and*@ItemRefID*=*42285*/*id*el*scroll*hena*/)**-----Made*By*#Xan
****BEGIN
********DECLARE*@MLevel*INT*=*(SELECT*MaxLevel*FRO M*SRO_VT_SHARD.._Char*WHERE*CharID=@CharID)
************IF*(@MLevel*between*114*and*115)
****************BEGIN
********************DECLARE*@CharName*varchar(Max) *=*(SELECT*CharName16*FROM*SRO_VT_SHARD.._Char*WHE RE*CharID=@CharID)
********************UPDATE*SRO_VT_SHARD.dbo._Char* Set*CurLevel=120,MaxLevel=120,Strength+=(120-@MLevel),Intellect+=(120-@MLevel),RemainStatPoint+=((120-@MLevel)*3)*WHERE*CharID=@CharID
****************END
****END*

[Dev.Ri3o]

ال Procdure نفسو فى اخطاء فى حاجات معملوه Declare كزا مرة وده غلط

[hodamoseba]

طيب عدلهولى :gun_bandana:

[Mr Z!dane]

هتشيل كل ال *
اللي موجودا ف البروسيدور دي عدا السطر ده متجيش جنبه
*/*id*el*scroll*hena*/)**-----Made*By*#Xan

[Hero]

المفروض ال * يعنى مسافه و ف اكواد داخله ف بعضها زي مثلا
SELECTMaxLevelFROMSRO_VT_SHARD
المفروض تكون
SELECT MaxLevel FROM SRO_VT_SHARD

هو سليم بس محتاج انك تظبط الاكواد مش اكتر

ليك موضوعين
##