|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| قسم الشروحات و البرامج المستخدمة في عمل السيرفرات الخاصة [ قسم متخصص فى شروحات و البرامج في عمل السيرفرات الخاصة ] [ يرجى عدم وضع الأسئلة والاستفسارات في هذا القسم ] |
 |
|
| إعلانات google |
|
|
22-02-2015, 08:24 PM
|
#18
|
|
|
• الانـتـسـاب » Feb 2014
|
|
• رقـم العـضـويـة » 116453
|
|
• المشـــاركـات » 904
|
|
• الـدولـة » Egypt
|
|
• الـهـوايـة » FootBall
|
|
• اسـم الـسـيـرفـر » Private Server
|
|
• الـجـنـس » Male
|
|
• نقـاط التقييم » 14
|
|
|
|
.gif)
رد: Release :Scroll Status
تمام يا باشا بس ناقصة Skil effect and skilldata35000enc
|
|
|
|
|
22-02-2015, 09:06 PM
|
#19
|
|
مـديـر عـام
|
|
• الانـتـسـاب » Dec 2007
|
|
• رقـم العـضـويـة » 6993
|
|
• المشـــاركـات » 7,041
|
|
• الـدولـة » Cairo
|
|
• الـهـوايـة » Helping ppl
|
|
• اسـم الـسـيـرفـر » Private Server
|
|
• الـجـنـس » Male
|
|
• نقـاط التقييم » 92
|
|
|
 
|
رد: Release :Scroll Status
اقتباس:
المشاركة الأصلية كتبت بواسطة ruxana
عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ]
تمام يا باشا بس ناقصة Skil effect and skilldata35000enc
|
ملهاش ياباشا . دا شغال علي AddLogItem ملوش علاقة بيها خالص
|
|
|
|
|
23-02-2015, 02:07 PM
|
#20
|
|
|
• الانـتـسـاب » Apr 2014
|
|
• رقـم العـضـويـة » 117207
|
|
• المشـــاركـات » 471
|
|
• الـدولـة »
|
|
• الـهـوايـة »
|
|
• اسـم الـسـيـرفـر » No Server
|
|
• الـجـنـس » Male
|
|
• نقـاط التقييم » 11
|
|
|
|
رد: Release :Scroll Status
اقتباس:
المشاركة الأصلية كتبت بواسطة Hamza FiGo
عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ]
بعض التعديلات علي البروسيدر . فية بعض الحاجات مش شغالة عندك يا First
والتعديل انا ضايف فية الــ Full Blue علشان يبقي كامل . تحياتي ^^
كود:
--> Weapon Stat Scrolls :
-- Weapon 61%
IF (@Operation = 41) and (@ItemRefID = 50235)
Begin
Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '21059194464',MagParamNum = '5' , MagParam1 = '34359738807' , MagParam2 = '34359738808' , MagParam3 = '429496730043' , MagParam4 = '858993459641' , MagParam5 = '257698038202' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '6' and ItemID > 0)
End
-- Weapon 80%
IF (@Operation = 41) and (@ItemRefID = 50236)
Begin
Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '27709466400',MagParamNum = '5' , MagParam1 = '34359738807' , MagParam2 = '34359738808' , MagParam3 = '429496730043' , MagParam4 = '858993459641' , MagParam5 = '257698038202' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '6' and ItemID > 0)
End
-- Weapon 100%
IF (@Operation = 41) and (@ItemRefID = 50237)
Begin
Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '34359738367',MagParamNum = '5' , MagParam1 = '34359738807' , MagParam2 = '34359738808' , MagParam3 = '429496730043' , MagParam4 = '858993459641' , MagParam5 = '257698038202' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '6' and ItemID > 0)
End
--> Shield Stat Scrolls :
-- SH 61%
IF (@Operation = 41) and (@ItemRefID = 50238)
Begin
Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '658099827',MagParamNum='4 ',MagParam1='858993459291',MagParam2= '429496729727',MagParam3='34359738447',MagParam4= '34359738441',MagParam5= '257698038202' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '7' and ItemID > 0)
End
-- SH 80%
IF (@Operation = 41) and (@ItemRefID = 50239)
Begin
Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '865920825',MagParamNum='4 ',MagParam1='858993459291',MagParam2= '429496729727',MagParam3='34359738447',MagParam4= '34359738441',MagParam5= '257698038202' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '7' and ItemID > 0)
End
-- SH 100%
IF (@Operation = 41) and (@ItemRefID = 50240)
Begin
Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '1073741823',MagParamNum='4 ',MagParam1='858993459291',MagParam2= '429496729727',MagParam3='34359738447',MagParam4= '34359738441',MagParam5= '257698038202' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '7' and ItemID > 0)
End
--> Armor Stat Scrolls :
-- AR 61%
IF (@Operation = 41) and (@ItemRefID = 50241)
Begin
Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '658099827',MagParamNum='6',MagParam1='34359738808',MagParam2= '858993459641',MagParam3='34359738807',MagParam4 = '7301444403647',MagParam5= '7301444403646',MagParam6= '257698038205' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '0' and ItemID > 0)
Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '658099827',MagParamNum='6',MagParam1='34359738808',MagParam2= '858993459641',MagParam3='34359738807',MagParam4 = '7301444403647',MagParam5= '7301444403646',MagParam6= '257698038205' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '1' and ItemID > 0)
Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '658099827',MagParamNum='4',MagParam1='34359738808',MagParam2= '34359738807',MagParam3='858993459641',MagParam4= '257698038205' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '2' and ItemID > 0)
Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '658099827',MagParamNum='4',MagParam1='34359738808',MagParam2= '34359738807',MagParam3='858993459641',MagParam4= '257698038205' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '3' and ItemID > 0)
Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '658099827',MagParamNum='6',MagParam1='34359738808',MagParam2= '858993459641',MagParam3='34359738807',MagParam4 = '7301444403647',MagParam5= '7301444403646',MagParam6= '257698038205' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '4' and ItemID > 0)
Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '658099827',MagParamNum='4',MagParam1='34359738808',MagParam2= '34359738807',MagParam3='858993459641',MagParam4= '257698038205' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '5' and ItemID > 0)
End
-- AR 80%
IF (@Operation = 41) and (@ItemRefID = 50242)
Begin
Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '865920825',MagParamNum='6',MagParam1='34359738808',MagParam2= '858993459641',MagParam3='34359738807',MagParam4 = '7301444403647',MagParam5= '7301444403646',MagParam6= '257698038205' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '0' and ItemID > 0)
Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '865920825',MagParamNum='6',MagParam1='34359738808',MagParam2= '858993459641',MagParam3='34359738807',MagParam4 = '7301444403647',MagParam5= '7301444403646',MagParam6= '257698038205' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '1' and ItemID > 0)
Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '865920825',MagParamNum='4',MagParam1='34359738808',MagParam2= '34359738807',MagParam3='858993459641',MagParam4= '257698038205' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '2' and ItemID > 0)
Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '865920825',MagParamNum='4',MagParam1='34359738808',MagParam2= '34359738807',MagParam3='858993459641',MagParam4= '257698038205' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '3' and ItemID > 0)
Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '865920825',MagParamNum='6',MagParam1='34359738808',MagParam2= '858993459641',MagParam3='34359738807',MagParam4 = '7301444403647',MagParam5= '7301444403646',MagParam6= '257698038205' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '4' and ItemID > 0)
Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '865920825',MagParamNum='4',MagParam1='34359738808',MagParam2= '34359738807',MagParam3='858993459641',MagParam4= '257698038205' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '5' and ItemID > 0)
End
-- AR 100%
IF (@Operation = 41) and (@ItemRefID = 50243)
Begin
Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '1073741823',MagParamNum='6',MagParam1='34359738808',MagParam2= '858993459641',MagParam3='34359738807',MagParam4 = '7301444403647',MagParam5= '7301444403646',MagParam6= '257698038205' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '0' and ItemID > 0)
Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '1073741823',MagParamNum='6',MagParam1='34359738808',MagParam2= '858993459641',MagParam3='34359738807',MagParam4 = '7301444403647',MagParam5= '7301444403646',MagParam6= '257698038205' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '1' and ItemID > 0)
Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '1073741823',MagParamNum='4',MagParam1='34359738808',MagParam2= '34359738807',MagParam3='858993459641',MagParam4= '257698038205' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '2' and ItemID > 0)
Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '1073741823',MagParamNum='4',MagParam1='34359738808',MagParam2= '34359738807',MagParam3='858993459641',MagParam4= '257698038205' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '3' and ItemID > 0)
Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '1073741823',MagParamNum='6',MagParam1='34359738808',MagParam2= '858993459641',MagParam3='34359738807',MagParam4 = '7301444403647',MagParam5= '7301444403646',MagParam6= '257698038205' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '4' and ItemID > 0)
Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '1073741823',MagParamNum='4',MagParam1='34359738808',MagParam2= '34359738807',MagParam3='858993459641',MagParam4= '257698038205' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '5' and ItemID > 0)
End
--> Accessory Stat Scrolls :
-- Acc 61%
IF (@Operation = 41) and (@ItemRefID = 50244)
Begin
Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '627',MagParamNum='7',MagParam1='85899346369',MagParam2= '85899346370',MagParam3='85899346368',MagParam4= '85899346371',MagParam5= '85899346372',MagParam6= '34359738808',MagParam7= '34359738807' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '9' and ItemID > 0)
Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '627',MagParamNum='7',MagParam1='85899346369',MagParam2= '85899346370',MagParam3='85899346368',MagParam4= '85899346371',MagParam5= '85899346372',MagParam6= '34359738808',MagParam7= '34359738807' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '10' and ItemID > 0)
Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '627',MagParamNum='7',MagParam1='85899346369',MagParam2= '85899346370',MagParam3='85899346368',MagParam4= '85899346371',MagParam5= '85899346372',MagParam6= '34359738808',MagParam7= '34359738807' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '11' and ItemID > 0)
Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '627',MagParamNum='7',MagParam1='85899346369',MagParam2= '85899346370',MagParam3='85899346368',MagParam4= '85899346371',MagParam5= '85899346372',MagParam6= '34359738808',MagParam7= '34359738807' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '12' and ItemID > 0)
End
-- Acc 80%
IF (@Operation = 41) and (@ItemRefID = 50245)
Begin
Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '825',MagParamNum='7',MagParam1='85899346369',MagParam2= '85899346370',MagParam3='85899346368',MagParam4= '85899346371',MagParam5= '85899346372',MagParam6= '34359738808',MagParam7= '34359738807' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '9' and ItemID > 0)
Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '825',MagParamNum='7',MagParam1='85899346369',MagParam2= '85899346370',MagParam3='85899346368',MagParam4= '85899346371',MagParam5= '85899346372',MagParam6= '34359738808',MagParam7= '34359738807' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '10' and ItemID > 0)
Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '825',MagParamNum='7',MagParam1='85899346369',MagParam2= '85899346370',MagParam3='85899346368',MagParam4= '85899346371',MagParam5= '85899346372',MagParam6= '34359738808',MagParam7= '34359738807' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '11' and ItemID > 0)
Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '825',MagParamNum='7',MagParam1='85899346369',MagParam2= '85899346370',MagParam3='85899346368',MagParam4= '85899346371',MagParam5= '85899346372',MagParam6= '34359738808',MagParam7= '34359738807' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '12' and ItemID > 0)
End
-- Acc 100%
IF (@Operation = 41) and (@ItemRefID = 50246)
Begin
Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '1023',MagParamNum='7',MagParam1='85899346369',MagParam2= '85899346370',MagParam3='85899346368',MagParam4= '85899346371',MagParam5= '85899346372',MagParam6= '34359738808',MagParam7= '34359738807' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '9' and ItemID > 0)
Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '1023',MagParamNum='7',MagParam1='85899346369',MagParam2= '85899346370',MagParam3='85899346368',MagParam4= '85899346371',MagParam5= '85899346372',MagParam6= '34359738808',MagParam7= '34359738807' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '10' and ItemID > 0)
Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '1023',MagParamNum='7',MagParam1='85899346369',MagParam2= '85899346370',MagParam3='85899346368',MagParam4= '85899346371',MagParam5= '85899346372',MagParam6= '34359738808',MagParam7= '34359738807' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '11' and ItemID > 0)
Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '1023',MagParamNum='7',MagParam1='85899346369',MagParam2= '85899346370',MagParam3='85899346368',MagParam4= '85899346371',MagParam5= '85899346372',MagParam6= '34359738808',MagParam7= '34359738807' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '12' and ItemID > 0)
End
|
تسلم
|
|
|
|
|
27-02-2015, 03:38 AM
|
#22
|
|
|
• الانـتـسـاب » May 2013
|
|
• رقـم العـضـويـة » 111830
|
|
• المشـــاركـات » 885
|
|
• الـدولـة » Giza
|
|
• الـهـوايـة » Photoshop & 3d
|
|
• اسـم الـسـيـرفـر » Private Server
|
|
• الـجـنـس » Male
|
|
• نقـاط التقييم » 11
|
|
|
|
رد: Release :Scroll Status
كود:
iF (@Operation = 41) -- Scroll is used
BEGIN
IF (@ItemRefID = 50235) -- Your Test scroll 61% Protectro & Accessory
BEGIN
SELECT @CharName = CharName16 from [Dan_com].[dbo].[_Char] WHERE CharID = @CharID
Declare @HelmItemID64 int = 0----- HelmItem,MailItem,PantsItem
Declare @MailItemID64 int = 1----- HelmItem,MailItem,PantsItem
Declare @ShoulderItemID64 int = 2----- ShoulderItem,GauntletItem,BootsItem
Declare @GauntletItemID64 int = 3----- ShoulderItem,GauntletItem,BootsItem
Declare @PantsItemID64 int = 4----- HelmItem,MailItem,PantsItem
Declare @BootsItemID64 int = 5----- ShoulderItem,GauntletItem,BootsItem
Declare @WeaponItemID64 int = 6----- Weapon
Declare @ShieldItemID64 int = 7----- SHield
Declare @NecklaceItemID64 int = 9---- Accessory
Declare @EarringItemID64 int = 10---- Accessory
Declare @RingLItemID64 int = 11---- Accessory
Declare @RingRItemID64 int = 12---- Accessory
UPDATE Dan_com.dbo._Items SET Variance = 658099827, MagParamNum = 6, MagParam1 = 876173328830, MagParam2 = 7301444403651, MagParam3 = 283467841986, MagParam4 = 51539607997, MagParam5 = 7301444403652, MagParam6 = 51539607996, MagParam7 = NULL, MagParam8 = NULL, MagParam9 = NULL, MagParam10 = NULL, MagParam11 = NULL, MagParam12 = NULL WHERE ID64 IN (select ItemID from Dan_com.dbo._Inventory WHERE Slot = 0 AND CharID = (select CharID from Dan_com.dbo._Char where CharName16 = @CharName))
UPDATE Dan_com.dbo._Items SET Variance = 658099827, MagParamNum = 6, MagParam1 = 876173328830, MagParam2 = 7301444403651, MagParam3 = 283467841986, MagParam4 = 51539607997, MagParam5 = 7301444403652, MagParam6 = 51539607996, MagParam7 = NULL, MagParam8 = NULL, MagParam9 = NULL, MagParam10 = NULL, MagParam11 = NULL, MagParam12 = NULL WHERE ID64 IN (select ItemID from Dan_com.dbo._Inventory WHERE Slot = 1 AND CharID = (select CharID from Dan_com.dbo._Char where CharName16 = @CharName))
UPDATE Dan_com.dbo._Items SET Variance = 658099827, MagParamNum = 6, MagParam1 = 876173328830, MagParam2 = 7301444403651, MagParam3 = 283467841986, MagParam4 = 51539607997, MagParam5 = 7301444403652, MagParam6 = 51539607996, MagParam7 = NULL, MagParam8 = NULL, MagParam9 = NULL, MagParam10 = NULL, MagParam11 = NULL, MagParam12 = NULL WHERE ID64 IN (select ItemID from Dan_com.dbo._Inventory WHERE Slot = 4 AND CharID = (select CharID from Dan_com.dbo._Char where CharName16 = @CharName))
UPDATE Dan_com.dbo._Items SET Variance = 658099827, MagParamNum = 4, MagParam1 = 876173328830, MagParam2 = 283467841986, MagParam3 = 51539607997, MagParam4 = 51539607996, MagParam5 = NULL, MagParam6 = NULL, MagParam7 = NULL, MagParam8 = NULL, MagParam9 = NULL, MagParam10 = NULL, MagParam11 = NULL, MagParam12 = NULL WHERE ID64 IN (select ItemID from Dan_com.dbo._Inventory WHERE Slot = 2 AND CharID = (select CharID from Dan_com.dbo._Char where CharName16 = @CharName))
UPDATE Dan_com.dbo._Items SET Variance = 658099827, MagParamNum = 4, MagParam1 = 876173328830, MagParam2 = 283467841986, MagParam3 = 51539607997, MagParam4 = 51539607996, MagParam5 = NULL, MagParam6 = NULL, MagParam7 = NULL, MagParam8 = NULL, MagParam9 = NULL, MagParam10 = NULL, MagParam11 = NULL, MagParam12 = NULL WHERE ID64 IN (select ItemID from Dan_com.dbo._Inventory WHERE Slot = 3 AND CharID = (select CharID from Dan_com.dbo._Char where CharName16 = @CharName))
UPDATE Dan_com.dbo._Items SET Variance = 658099827, MagParamNum = 4, MagParam1 = 876173328830, MagParam2 = 283467841986, MagParam3 = 51539607997, MagParam4 = 51539607996, MagParam5 = NULL, MagParam6 = NULL, MagParam7 = NULL, MagParam8 = NULL, MagParam9 = NULL, MagParam10 = NULL, MagParam11 = NULL, MagParam12 = NULL WHERE ID64 IN (select ItemID from Dan_com.dbo._Inventory WHERE Slot = 5 AND CharID = (select CharID from Dan_com.dbo._Char where CharName16 = @CharName))
UPDATE Dan_com.dbo._Items SET Variance = 627, MagParamNum = 7, MagParam1 = 51539607997, MagParam2 = 51539607996, MagParam3 = 85899346373, MagParam4 = 85899346374, MagParam5 = 85899346375, MagParam6 = 85899346376, MagParam7 = 85899346377, MagParam8 = NULL, MagParam9 = NULL, MagParam10 = NULL, MagParam11 = NULL, MagParam12 = NULL WHERE ID64 IN (select ItemID from Dan_com.dbo._Inventory WHERE Slot = 10 AND CharID = (select CharID from Dan_com.dbo._Char where CharName16 = @CharName))
UPDATE Dan_com.dbo._Items SET Variance = 627, MagParamNum = 7, MagParam1 = 51539607997, MagParam2 = 51539607996, MagParam3 = 85899346373, MagParam4 = 85899346374, MagParam5 = 85899346375, MagParam6 = 85899346376, MagParam7 = 85899346377, MagParam8 = NULL, MagParam9 = NULL, MagParam10 = NULL, MagParam11 = NULL, MagParam12 = NULL WHERE ID64 IN (select ItemID from Dan_com.dbo._Inventory WHERE Slot = 11 AND CharID = (select CharID from Dan_com.dbo._Char where CharName16 = @CharName))
UPDATE Dan_com.dbo._Items SET Variance = 627, MagParamNum = 7, MagParam1 = 51539607997, MagParam2 = 51539607996, MagParam3 = 85899346373, MagParam4 = 85899346374, MagParam5 = 85899346375, MagParam6 = 85899346376, MagParam7 = 85899346377, MagParam8 = NULL, MagParam9 = NULL, MagParam10 = NULL, MagParam11 = NULL, MagParam12 = NULL WHERE ID64 IN (select ItemID from Dan_com.dbo._Inventory WHERE Slot = 12 AND CharID = (select CharID from Dan_com.dbo._Char where CharName16 = @CharName))
UPDATE Dan_com.dbo._Items SET Variance = 627, MagParamNum = 7, MagParam1 = 51539607997, MagParam2 = 51539607996, MagParam3 = 85899346373, MagParam4 = 85899346374, MagParam5 = 85899346375, MagParam6 = 85899346376, MagParam7 = 85899346377, MagParam8 = NULL, MagParam9 = NULL, MagParam10 = NULL, MagParam11 = NULL, MagParam12 = NULL WHERE ID64 IN (select ItemID from Dan_com.dbo._Inventory WHERE Slot = 9 AND CharID = (select CharID from Dan_com.dbo._Char where CharName16 = @CharName))
END
END
IF (@ItemRefID = 50236) -- Your Test scroll 80% Protectro & Accessory
BEGIN
SELECT @CharName = CharName16 from [Dan_com].[dbo].[_Char] WHERE CharID = @CharID
UPDATE Dan_com.dbo._Items SET Variance = 865920825, MagParamNum = 6, MagParam1 = 876173328830, MagParam2 = 7301444403651, MagParam3 = 283467841986, MagParam4 = 51539607997, MagParam5 = 7301444403652, MagParam6 = 51539607996, MagParam7 = NULL, MagParam8 = NULL, MagParam9 = NULL, MagParam10 = NULL, MagParam11 = NULL, MagParam12 = NULL WHERE ID64 IN (select ItemID from Dan_com.dbo._Inventory WHERE Slot = 0 AND CharID = (select CharID from Dan_com.dbo._Char where CharName16 = @CharName))
UPDATE Dan_com.dbo._Items SET Variance = 865920825, MagParamNum = 6, MagParam1 = 876173328830, MagParam2 = 7301444403651, MagParam3 = 283467841986, MagParam4 = 51539607997, MagParam5 = 7301444403652, MagParam6 = 51539607996, MagParam7 = NULL, MagParam8 = NULL, MagParam9 = NULL, MagParam10 = NULL, MagParam11 = NULL, MagParam12 = NULL WHERE ID64 IN (select ItemID from Dan_com.dbo._Inventory WHERE Slot = 1 AND CharID = (select CharID from Dan_com.dbo._Char where CharName16 = @CharName))
UPDATE Dan_com.dbo._Items SET Variance = 865920825, MagParamNum = 6, MagParam1 = 876173328830, MagParam2 = 7301444403651, MagParam3 = 283467841986, MagParam4 = 51539607997, MagParam5 = 7301444403652, MagParam6 = 51539607996, MagParam7 = NULL, MagParam8 = NULL, MagParam9 = NULL, MagParam10 = NULL, MagParam11 = NULL, MagParam12 = NULL WHERE ID64 IN (select ItemID from Dan_com.dbo._Inventory WHERE Slot = 4 AND CharID = (select CharID from Dan_com.dbo._Char where CharName16 = @CharName))
UPDATE Dan_com.dbo._Items SET Variance = 865920825, MagParamNum = 4, MagParam1 = 876173328830, MagParam2 = 283467841986, MagParam3 = 51539607997, MagParam4 = 51539607996, MagParam5 = NULL, MagParam6 = NULL, MagParam7 = NULL, MagParam8 = NULL, MagParam9 = NULL, MagParam10 = NULL, MagParam11 = NULL, MagParam12 = NULL WHERE ID64 IN (select ItemID from Dan_com.dbo._Inventory WHERE Slot = 2 AND CharID = (select CharID from Dan_com.dbo._Char where CharName16 = @CharName))
UPDATE Dan_com.dbo._Items SET Variance = 865920825, MagParamNum = 4, MagParam1 = 876173328830, MagParam2 = 283467841986, MagParam3 = 51539607997, MagParam4 = 51539607996, MagParam5 = NULL, MagParam6 = NULL, MagParam7 = NULL, MagParam8 = NULL, MagParam9 = NULL, MagParam10 = NULL, MagParam11 = NULL, MagParam12 = NULL WHERE ID64 IN (select ItemID from Dan_com.dbo._Inventory WHERE Slot = 3 AND CharID = (select CharID from Dan_com.dbo._Char where CharName16 = @CharName))
UPDATE Dan_com.dbo._Items SET Variance = 865920825, MagParamNum = 4, MagParam1 = 876173328830, MagParam2 = 283467841986, MagParam3 = 51539607997, MagParam4 = 51539607996, MagParam5 = NULL, MagParam6 = NULL, MagParam7 = NULL, MagParam8 = NULL, MagParam9 = NULL, MagParam10 = NULL, MagParam11 = NULL, MagParam12 = NULL WHERE ID64 IN (select ItemID from Dan_com.dbo._Inventory WHERE Slot = 5 AND CharID = (select CharID from Dan_com.dbo._Char where CharName16 = @CharName))
UPDATE Dan_com.dbo._Items SET Variance = 825, MagParamNum = 7, MagParam1 = 51539607997, MagParam2 = 51539607996, MagParam3 = 85899346373, MagParam4 = 85899346374, MagParam5 = 85899346375, MagParam6 = 85899346376, MagParam7 = 85899346377, MagParam8 = NULL, MagParam9 = NULL, MagParam10 = NULL, MagParam11 = NULL, MagParam12 = NULL WHERE ID64 IN (select ItemID from Dan_com.dbo._Inventory WHERE Slot = 10 AND CharID = (select CharID from Dan_com.dbo._Char where CharName16 = @CharName))
UPDATE Dan_com.dbo._Items SET Variance = 825, MagParamNum = 7, MagParam1 = 51539607997, MagParam2 = 51539607996, MagParam3 = 85899346373, MagParam4 = 85899346374, MagParam5 = 85899346375, MagParam6 = 85899346376, MagParam7 = 85899346377, MagParam8 = NULL, MagParam9 = NULL, MagParam10 = NULL, MagParam11 = NULL, MagParam12 = NULL WHERE ID64 IN (select ItemID from Dan_com.dbo._Inventory WHERE Slot = 11 AND CharID = (select CharID from Dan_com.dbo._Char where CharName16 = @CharName))
UPDATE Dan_com.dbo._Items SET Variance = 825, MagParamNum = 7, MagParam1 = 51539607997, MagParam2 = 51539607996, MagParam3 = 85899346373, MagParam4 = 85899346374, MagParam5 = 85899346375, MagParam6 = 85899346376, MagParam7 = 85899346377, MagParam8 = NULL, MagParam9 = NULL, MagParam10 = NULL, MagParam11 = NULL, MagParam12 = NULL WHERE ID64 IN (select ItemID from Dan_com.dbo._Inventory WHERE Slot = 12 AND CharID = (select CharID from Dan_com.dbo._Char where CharName16 = @CharName))
UPDATE Dan_com.dbo._Items SET Variance = 825, MagParamNum = 7, MagParam1 = 51539607997, MagParam2 = 51539607996, MagParam3 = 85899346373, MagParam4 = 85899346374, MagParam5 = 85899346375, MagParam6 = 85899346376, MagParam7 = 85899346377, MagParam8 = NULL, MagParam9 = NULL, MagParam10 = NULL, MagParam11 = NULL, MagParam12 = NULL WHERE ID64 IN (select ItemID from Dan_com.dbo._Inventory WHERE Slot = 9 AND CharID = (select CharID from Dan_com.dbo._Char where CharName16 = @CharName))
END
IF (@ItemRefID = 50237) -- Your Test scroll 100% Protectro & Accessory
BEGIN
SELECT @CharName = CharName16 from [Dan_com].[dbo].[_Char] WHERE CharID = @CharID
UPDATE Dan_com.dbo._Items SET Variance = 1073741823, MagParamNum = 6, MagParam1 = 876173328830, MagParam2 = 7301444403651, MagParam3 = 283467841986, MagParam4 = 51539607997, MagParam5 = 7301444403652, MagParam6 = 51539607996, MagParam7 = NULL, MagParam8 = NULL, MagParam9 = NULL, MagParam10 = NULL, MagParam11 = NULL, MagParam12 = NULL WHERE ID64 IN (select ItemID from Dan_com.dbo._Inventory WHERE Slot = 0 AND CharID = (select CharID from Dan_com.dbo._Char where CharName16 = @CharName))
UPDATE Dan_com.dbo._Items SET Variance = 1073741823, MagParamNum = 6, MagParam1 = 876173328830, MagParam2 = 7301444403651, MagParam3 = 283467841986, MagParam4 = 51539607997, MagParam5 = 7301444403652, MagParam6 = 51539607996, MagParam7 = NULL, MagParam8 = NULL, MagParam9 = NULL, MagParam10 = NULL, MagParam11 = NULL, MagParam12 = NULL WHERE ID64 IN (select ItemID from Dan_com.dbo._Inventory WHERE Slot = 1 AND CharID = (select CharID from Dan_com.dbo._Char where CharName16 = @CharName))
UPDATE Dan_com.dbo._Items SET Variance = 1073741823, MagParamNum = 6, MagParam1 = 876173328830, MagParam2 = 7301444403651, MagParam3 = 283467841986, MagParam4 = 51539607997, MagParam5 = 7301444403652, MagParam6 = 51539607996, MagParam7 = NULL, MagParam8 = NULL, MagParam9 = NULL, MagParam10 = NULL, MagParam11 = NULL, MagParam12 = NULL WHERE ID64 IN (select ItemID from Dan_com.dbo._Inventory WHERE Slot = 4 AND CharID = (select CharID from Dan_com.dbo._Char where CharName16 = @CharName))
UPDATE Dan_com.dbo._Items SET Variance = 1073741823, MagParamNum = 4, MagParam1 = 876173328830, MagParam2 = 283467841986, MagParam3 = 51539607997, MagParam4 = 51539607996, MagParam5 = NULL, MagParam6 = NULL, MagParam7 = NULL, MagParam8 = NULL, MagParam9 = NULL, MagParam10 = NULL, MagParam11 = NULL, MagParam12 = NULL WHERE ID64 IN (select ItemID from Dan_com.dbo._Inventory WHERE Slot = 2 AND CharID = (select CharID from Dan_com.dbo._Char where CharName16 = @CharName))
UPDATE Dan_com.dbo._Items SET Variance = 1073741823, MagParamNum = 4, MagParam1 = 876173328830, MagParam2 = 283467841986, MagParam3 = 51539607997, MagParam4 = 51539607996, MagParam5 = NULL, MagParam6 = NULL, MagParam7 = NULL, MagParam8 = NULL, MagParam9 = NULL, MagParam10 = NULL, MagParam11 = NULL, MagParam12 = NULL WHERE ID64 IN (select ItemID from Dan_com.dbo._Inventory WHERE Slot = 3 AND CharID = (select CharID from Dan_com.dbo._Char where CharName16 = @CharName))
UPDATE Dan_com.dbo._Items SET Variance = 1073741823, MagParamNum = 4, MagParam1 = 876173328830, MagParam2 = 283467841986, MagParam3 = 51539607997, MagParam4 = 51539607996, MagParam5 = NULL, MagParam6 = NULL, MagParam7 = NULL, MagParam8 = NULL, MagParam9 = NULL, MagParam10 = NULL, MagParam11 = NULL, MagParam12 = NULL WHERE ID64 IN (select ItemID from Dan_com.dbo._Inventory WHERE Slot = 5 AND CharID = (select CharID from Dan_com.dbo._Char where CharName16 = @CharName))
UPDATE Dan_com.dbo._Items SET Variance = 1023, MagParamNum = 7, MagParam1 = 51539607997, MagParam2 = 51539607996, MagParam3 = 85899346373, MagParam4 = 85899346374, MagParam5 = 85899346375, MagParam6 = 85899346376, MagParam7 = 85899346377, MagParam8 = NULL, MagParam9 = NULL, MagParam10 = NULL, MagParam11 = NULL, MagParam12 = NULL WHERE ID64 IN (select ItemID from Dan_com.dbo._Inventory WHERE Slot = 10 AND CharID = (select CharID from Dan_com.dbo._Char where CharName16 = @CharName))
UPDATE Dan_com.dbo._Items SET Variance = 1023, MagParamNum = 7, MagParam1 = 51539607997, MagParam2 = 51539607996, MagParam3 = 85899346373, MagParam4 = 85899346374, MagParam5 = 85899346375, MagParam6 = 85899346376, MagParam7 = 85899346377, MagParam8 = NULL, MagParam9 = NULL, MagParam10 = NULL, MagParam11 = NULL, MagParam12 = NULL WHERE ID64 IN (select ItemID from Dan_com.dbo._Inventory WHERE Slot = 11 AND CharID = (select CharID from Dan_com.dbo._Char where CharName16 = @CharName))
UPDATE Dan_com.dbo._Items SET Variance = 1023, MagParamNum = 7, MagParam1 = 51539607997, MagParam2 = 51539607996, MagParam3 = 85899346373, MagParam4 = 85899346374, MagParam5 = 85899346375, MagParam6 = 85899346376, MagParam7 = 85899346377, MagParam8 = NULL, MagParam9 = NULL, MagParam10 = NULL, MagParam11 = NULL, MagParam12 = NULL WHERE ID64 IN (select ItemID from Dan_com.dbo._Inventory WHERE Slot = 12 AND CharID = (select CharID from Dan_com.dbo._Char where CharName16 = @CharName))
UPDATE Dan_com.dbo._Items SET Variance = 1023, MagParamNum = 7, MagParam1 = 51539607997, MagParam2 = 51539607996, MagParam3 = 85899346373, MagParam4 = 85899346374, MagParam5 = 85899346375, MagParam6 = 85899346376, MagParam7 = 85899346377, MagParam8 = NULL, MagParam9 = NULL, MagParam10 = NULL, MagParam11 = NULL, MagParam12 = NULL WHERE ID64 IN (select ItemID from Dan_com.dbo._Inventory WHERE Slot = 9 AND CharID = (select CharID from Dan_com.dbo._Char where CharName16 = @CharName))
END
ده البروسيدور 61%-80%-100%
بدل ما تعمل كل البروسيدور ده كله
ولو عايز تعمل سلاح وشيلد برحتك
ملحوظه ياريت تعديل علي البرام عشان هيكون مختلف بين لعبه ولعبه
من حيث HP-MP-STR-INT-Durability ETC ETC ETC
|
|
|
|
|
25-04-2015, 12:59 AM
|
#23
|
|
|
• الانـتـسـاب » Jan 2015
|
|
• رقـم العـضـويـة » 120530
|
|
• المشـــاركـات » 693
|
|
• الـدولـة » مصر,الدقهليه
|
|
• الـهـوايـة » SOLVE Problems
|
|
• اسـم الـسـيـرفـر » No Server
|
|
• الـجـنـس » Male
|
|
• نقـاط التقييم » 10
|
|
|
|
رد: Release :Scroll Status
انا عندى مشكله فى الاسكرول دى بتعمل عندى بلو انا مش عوزها تعمل بلو خالص 
او تعمل بلو صح
|
|
|
|
|
19-05-2015, 12:19 AM
|
#25
|
|
|
• الانـتـسـاب » May 2015
|
|
• رقـم العـضـويـة » 122163
|
|
• المشـــاركـات » 95
|
|
• الـدولـة »
|
|
• الـهـوايـة »
|
|
• اسـم الـسـيـرفـر » No Server
|
|
• الـجـنـس » Male
|
|
• نقـاط التقييم » 10
|
|
|
|
رد: Release :Scroll Status
|
|
|
|
|
29-05-2015, 02:58 PM
|
#28
|
|
|
• الانـتـسـاب » May 2015
|
|
• رقـم العـضـويـة » 121913
|
|
• المشـــاركـات » 17
|
|
• الـدولـة » Samanoud
|
|
• الـهـوايـة »
|
|
• اسـم الـسـيـرفـر » Private Server
|
|
• الـجـنـس » Male
|
|
• نقـاط التقييم » 10
|
|
|
|
.gif)
رد: Release :Scroll Status
|
|
|
|
|
04-06-2015, 04:47 PM
|
#29
|
|
|
• الانـتـسـاب » Mar 2013
|
|
• رقـم العـضـويـة » 110693
|
|
• المشـــاركـات » 2,013
|
|
• الـدولـة » المنوفية
|
|
• الـهـوايـة » الجرافيك
|
|
• اسـم الـسـيـرفـر » Private Server
|
|
• الـجـنـس » Male
|
|
• نقـاط التقييم » 29
|
|
|
|
رد: Release :Scroll Status
دا البروسيدر بعد تعديل البلو الصحيح
كود PHP:
--> Weapon Stat Scrolls :
-- Weapon 61%
IF (@Operation = 41) and (@ItemRefID = 67247)
Begin
Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '21059194464',MagParamNum= '5' ,MagParam1='30064771144',MagParam2= '30064771150',MagParam3='858993459290',MagParam4 = '257698037862',MagParam5= '429496729714'Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '6' and ItemID > 0)
End
-- Weapon 80%
IF (@Operation = 41) and (@ItemRefID = 67248)
Begin
Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '27709466400',MagParamNum= '5' ,MagParam1='30064771144',MagParam2= '30064771150',MagParam3='858993459290',MagParam4 = '257698037862',MagParam5= '429496729714'Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '6' and ItemID > 0)
End
-- Weapon 100%
IF (@Operation = 41) and (@ItemRefID = 67249)
Begin
Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '34359738367',MagParamNum= '5' ,MagParam1='30064771144',MagParam2= '30064771150',MagParam3='858993459290',MagParam4 = '257698037862' ,MagParam5= '429496729714'Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '6' and ItemID > 0)
End
--> Shield Stat Scrolls :
-- SH 61%
IF (@Operation = 41) and (@ItemRefID = 67250)
Begin
Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '21059194464',MagParamNum= '4 ',MagParam1='30064771144',MagParam2= '30064771150',MagParam3='858993459290',MagParam4 = '429496729726'Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '7' and ItemID > 0)
End
-- SH 80%
IF (@Operation = 41) and (@ItemRefID = 67251)
Begin
Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '27709466425',MagParamNum= '4 ',MagParam1='30064771144',MagParam2= '30064771150',MagParam3='858993459290',MagParam4 = '429496729726' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '7' and ItemID > 0)
End
-- SH 100%
IF (@Operation = 41) and (@ItemRefID = 67252)
Begin
Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '34359738336',MagParamNum= '4 ',MagParam1='30064771144',MagParam2= '30064771150',MagParam3='858993459290',MagParam4 = '429496729726' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '7' and ItemID > 0)
End
--> Armor Stat Scrolls :
-- AR 61%
IF (@Operation = 41) and (@ItemRefID = 67253)
Begin
Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '658099827',MagParamNum='6',MagParam1='30064771144',MagParam2= '858993459290',MagParam3='30064771150',MagParam4 = '257698037898',MagParam5= '5583457484962',MagParam6= '5583457484950' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '0' and ItemID > 0)
Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '658099827',MagParamNum='6',MagParam1='30064771144',MagParam2= '858993459290',MagParam3='30064771150',MagParam4 = '257698037898',MagParam5= '5583457484962',MagParam6= '5583457484950' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '1' and ItemID > 0)
Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '658099827',MagParamNum='4',MagParam1='30064771144',MagParam2= '858993459290',MagParam3='30064771150',MagParam4= '257698037898' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '2' and ItemID > 0)
Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '658099827',MagParamNum='4',MagParam1='30064771144',MagParam2= '858993459290',MagParam3='30064771150',MagParam4= '257698037898' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '3' and ItemID > 0)
Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '658099827',MagParamNum='6',MagParam1='30064771144',MagParam2= '858993459290',MagParam3='30064771150',MagParam4 = '257698037898',MagParam5= '5583457484962',MagParam6= '5583457484950' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '4' and ItemID > 0)
Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '658099827',MagParamNum='4',MagParam1='30064771144',MagParam2= '858993459290',MagParam3='30064771150',MagParam4= '257698037898' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '5' and ItemID > 0)
End
-- AR 80%
IF (@Operation = 41) and (@ItemRefID = 67254)
Begin
Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '865920825',MagParamNum='6',MagParam1='30064771144',MagParam2= '858993459290',MagParam3='30064771150',MagParam4 = '257698037898',MagParam5= '5583457484962',MagParam6= '5583457484950' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '0' and ItemID > 0)
Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '865920825',MagParamNum='6',MagParam1='30064771144',MagParam2= '858993459290',MagParam3='30064771150',MagParam4 = '257698037898',MagParam5= '5583457484962',MagParam6= '5583457484950' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '1' and ItemID > 0)
Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '865920825',MagParamNum='4',MagParam1='30064771144',MagParam2= '858993459290',MagParam3='30064771150',MagParam4= '257698037898' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '2' and ItemID > 0)
Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '865920825',MagParamNum='4',MagParam1='30064771144',MagParam2= '858993459290',MagParam3='30064771150',MagParam4= '257698037898' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '3' and ItemID > 0)
Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '865920825',MagParamNum='6',MagParam1='30064771144',MagParam2= '858993459290',MagParam3='30064771150',MagParam4 = '257698037898',MagParam5= '5583457484962',MagParam6= '5583457484950' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '4' and ItemID > 0)
Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '865920825',MagParamNum='4',MagParam1='30064771144',MagParam2= '858993459290',MagParam3='30064771150',MagParam4= '257698037898' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '5' and ItemID > 0)
End
-- AR 100%
IF (@Operation = 41) and (@ItemRefID = 67255)
Begin
Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '1073741823',MagParamNum='6',MagParam1='30064771144',MagParam2= '858993459290',MagParam3='30064771150',MagParam4 = '257698037898',MagParam5= '5583457484962',MagParam6= '5583457484950' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '0' and ItemID > 0)
Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '1073741823',MagParamNum='6',MagParam1='30064771144',MagParam2= '858993459290',MagParam3='30064771150',MagParam4 = '257698037898',MagParam5= '5583457484962',MagParam6= '5583457484950' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '1' and ItemID > 0)
Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '1073741823',MagParamNum='4',MagParam1='30064771144',MagParam2= '858993459290',MagParam3='30064771150',MagParam4= '257698037898' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '2' and ItemID > 0)
Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '1073741823',MagParamNum='4',MagParam1='30064771144',MagParam2= '858993459290',MagParam3='30064771150',MagParam4= '257698037898' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '3' and ItemID > 0)
Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '1073741823',MagParamNum='6',MagParam1='30064771144',MagParam2= '858993459290',MagParam3='30064771150',MagParam4 = '257698037898',MagParam5= '5583457484962',MagParam6= '5583457484950' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '4' and ItemID > 0)
Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '1073741823',MagParamNum='4',MagParam1='30064771144',MagParam2= '858993459290',MagParam3='30064771150',MagParam4= '257698037898' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '5' and ItemID > 0)
End
--> Accessory Stat Scrolls :
-- Acc 61%
IF (@Operation = 41) and (@ItemRefID = 67256)
Begin
Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '627',MagParamNum='7',MagParam1='30064771144',MagParam2= '30064771150',MagParam3='85899346100',MagParam4= '85899346094',MagParam5= '85899346112',MagParam6= '85899346106',MagParam7= '85899346088' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '9' and ItemID > 0)
Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '627',MagParamNum='7',MagParam1='30064771144',MagParam2= '30064771150',MagParam3='85899346100',MagParam4= '85899346094',MagParam5= '85899346112',MagParam6= '85899346106',MagParam7= '85899346088' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '10' and ItemID > 0)
Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '627',MagParamNum='7',MagParam1='30064771144',MagParam2= '30064771150',MagParam3='85899346100',MagParam4= '85899346094',MagParam5= '85899346112',MagParam6= '85899346106',MagParam7= '85899346088' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '11' and ItemID > 0)
Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '627',MagParamNum='7',MagParam1='30064771144',MagParam2= '30064771150',MagParam3='85899346100',MagParam4= '85899346094',MagParam5= '85899346112',MagParam6= '85899346106',MagParam7= '85899346088' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '12' and ItemID > 0)
End
-- Acc 80%
IF (@Operation = 41) and (@ItemRefID = 67257)
Begin
Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '825',MagParamNum='7',MagParam1='30064771144',MagParam2= '30064771150',MagParam3='85899346100',MagParam4= '85899346094',MagParam5= '85899346112',MagParam6= '85899346106',MagParam7= '85899346088' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '9' and ItemID > 0)
Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '825',MagParamNum='7',MagParam1='30064771144',MagParam2= '30064771150',MagParam3='85899346100',MagParam4= '85899346094',MagParam5= '85899346112',MagParam6= '85899346106',MagParam7= '85899346088' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '10' and ItemID > 0)
Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '825',MagParamNum='7',MagParam1='30064771144',MagParam2= '30064771150',MagParam3='85899346100',MagParam4= '85899346094',MagParam5= '85899346112',MagParam6= '85899346106',MagParam7= '85899346088' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '11' and ItemID > 0)
Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '825',MagParamNum='7',MagParam1='30064771144',MagParam2= '30064771150',MagParam3='85899346100',MagParam4= '85899346094',MagParam5= '85899346112',MagParam6= '85899346106',MagParam7= '85899346088' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '12' and ItemID > 0)
End
-- Acc 100%
IF (@Operation = 41) and (@ItemRefID = 67258)
Begin
Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '1023',MagParamNum='7',MagParam1='30064771144',MagParam2= '30064771150',MagParam3='85899346100',MagParam4= '85899346094',MagParam5= '85899346112',MagParam6= '85899346106',MagParam7= '85899346088' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '9' and ItemID > 0)
Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '1023',MagParamNum='7',MagParam1='30064771144',MagParam2= '30064771150',MagParam3='85899346100',MagParam4= '85899346094',MagParam5= '85899346112',MagParam6= '85899346106',MagParam7= '85899346088' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '10' and ItemID > 0)
Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '1023',MagParamNum='7',MagParam1='30064771144',MagParam2= '30064771150',MagParam3='85899346100',MagParam4= '85899346094',MagParam5= '85899346112',MagParam6= '85899346106',MagParam7= '85899346088' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '11' and ItemID > 0)
Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '1023',MagParamNum='7',MagParam1='30064771144',MagParam2= '30064771150',MagParam3='85899346100',MagParam4= '85899346094',MagParam5= '85899346112',MagParam6= '85899346106',MagParam7= '85899346088' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '12' and ItemID > 0)
End
تــــــقبل مرورى
|
|
|
|
|
06-06-2015, 09:55 PM
|
#30
|
|
|
• الانـتـسـاب » May 2015
|
|
• رقـم العـضـويـة » 121913
|
|
• المشـــاركـات » 17
|
|
• الـدولـة » Samanoud
|
|
• الـهـوايـة »
|
|
• اسـم الـسـيـرفـر » Private Server
|
|
• الـجـنـس » Male
|
|
• نقـاط التقييم » 10
|
|
|
|
رد: Release :Scroll Status
تمام عااش 
|
|
|
|
|
يتصفح الموضوع حالياً : 1 (0 عضو و 1 زائر)
|
|
|
ضوابط المشاركة
|
لا تستطيع إضافة مواضيع جديدة
لا تستطيع الرد على المواضيع
لا تستطيع إرفاق ملفات
لا تستطيع تعديل مشاركاتك
كود HTML معطلة
|
|
|
المواضيع المتشابهه
|
| الموضوع |
كاتب الموضوع |
المنتدى |
الردود |
آخر مشاركة |
|
Status Scroll
|
khaledPSx |
قسم المواضيع المكررة و المخالفة |
4 |
18-07-2016 05:48 PM |
|
Status Scroll Little Help !
|
khaledPSx |
قسم المواضيع المكررة و المخالفة |
5 |
14-07-2016 05:27 PM |
|
طلب في Scroll Status
|
Mohamed ElKersh |
قسم الاسئلة و الاستفسارات لعمل السيرفرات الخاصة |
14 |
02-04-2016 12:11 AM |
|
Scroll Status
|
Blizzard |
قسم المواضيع المكررة و المخالفة |
1 |
29-03-2016 02:32 AM |
|
Scroll Status
|
MarOz |
قسم المواضيع المكررة و المخالفة |
15 |
28-10-2014 05:06 PM |
الساعة الآن 02:07 PM.
| 
العرض العادي
