الموقع العربي الاول للعبة Silkroad Online

الموقع العربي الاول للعبة Silkroad Online (https://silkroad4arab.com/vb/index.php)
-   قسم الاسئلة و الاستفسارات لعمل السيرفرات الخاصة (https://silkroad4arab.com/vb/forumdisplay.php?f=226)
-   -   Proseed help (https://silkroad4arab.com/vb/showthread.php?t=621198)

hodamoseba 26-11-2017 12:13 AM

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

كود PHP:

**IF*(@Operation*=*41*and*@ItemRefID*=*42281*/*id*el*scroll*hena*/)**-----Made*By*#Xan
****BEGIN
********DECLARE*@MLevel*INT*=*(SELECT*MaxLevel*FROM*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*WHERE*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*FROM*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*WHERE*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*FROM*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*WHERE*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*FROM*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*WHERE*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*FROM*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*WHERE*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 26-11-2017 12:30 AM

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

hodamoseba 26-11-2017 01:34 AM

رد: Proseed help
 
طيب عدلهولى :gun_bandana:

Mr Z!dane 26-11-2017 06:21 AM

رد: Proseed help
 
هتشيل كل ال *
اللي موجودا ف البروسيدور دي عدا السطر ده متجيش جنبه
كود PHP:

*/*id*el*scroll*hena*/)**-----Made*By*#Xan 


Hero 26-11-2017 09:30 AM

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

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

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


الساعة الآن 04:24 PM.

Powered by vBulletin® Version 3.8.9
Copyright ©2000 - 2024, vBulletin Solutions, Inc.