شـريـط الاهـداءات | |
قسم الاسئلة و الاستفسارات لعمل السيرفرات الخاصة [ قسم خاص لأسئلة واستفسارات عمل السيرفرات الخاصة ] [ يرجى الالتزام بقوانين قسم الأسئلة والاستفسارات ] |
|
أدوات الموضوع | انواع عرض الموضوع |
15-01-2021, 02:57 PM | #1 | ||||||||||||
|
معلش يا شباب كنت بضيف الscrolls بتاعت ال stats 60% وال 80 و ال 100 لما بستخدم الquery ديه --> 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='3435973880 8',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='3435973880 8',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='3435973880 8',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='3435973880 8',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='3435973880 8',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='3435973880 8',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',MagP aram2= '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',MagP aram2= '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',MagP aram2= '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',MagP aram2= '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',MagP aram2= '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',MagP aram2= '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',MagP aram2= '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',MagP aram2= '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',Mag Param2= '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',Mag Param2= '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',Mag Param2= '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',Mag Param2= '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 بيجبلي كده Msg 137, Level 15, State 2, Line 3 Must declare the scalar variable "@Operation". Msg 137, Level 15, State 2, Line 5 Must declare the scalar variable "@CharID". Msg 137, Level 15, State 2, Line 8 Must declare the scalar variable "@Operation". Msg 137, Level 15, State 2, Line 10 Must declare the scalar variable "@CharID". Msg 137, Level 15, State 2, Line 13 Must declare the scalar variable "@Operation". Msg 137, Level 15, State 2, Line 15 Must declare the scalar variable "@CharID". Msg 137, Level 15, State 2, Line 20 Must declare the scalar variable "@Operation". Msg 137, Level 15, State 2, Line 22 Must declare the scalar variable "@CharID". Msg 137, Level 15, State 2, Line 25 Must declare the scalar variable "@Operation". Msg 137, Level 15, State 2, Line 27 Must declare the scalar variable "@CharID". Msg 137, Level 15, State 2, Line 30 Must declare the scalar variable "@Operation". Msg 137, Level 15, State 2, Line 32 Must declare the scalar variable "@CharID". Msg 137, Level 15, State 2, Line 37 Must declare the scalar variable "@Operation". Msg 137, Level 15, State 2, Line 39 Must declare the scalar variable "@CharID". Msg 137, Level 15, State 2, Line 40 Must declare the scalar variable "@CharID". Msg 137, Level 15, State 2, Line 41 Must declare the scalar variable "@CharID". Msg 137, Level 15, State 2, Line 42 Must declare the scalar variable "@CharID". Msg 137, Level 15, State 2, Line 43 Must declare the scalar variable "@CharID". Msg 137, Level 15, State 2, Line 44 Must declare the scalar variable "@CharID". Msg 137, Level 15, State 2, Line 47 Must declare the scalar variable "@Operation". Msg 137, Level 15, State 2, Line 49 Must declare the scalar variable "@CharID". Msg 137, Level 15, State 2, Line 50 Must declare the scalar variable "@CharID". Msg 137, Level 15, State 2, Line 51 Must declare the scalar variable "@CharID". Msg 137, Level 15, State 2, Line 52 Must declare the scalar variable "@CharID". Msg 137, Level 15, State 2, Line 53 Must declare the scalar variable "@CharID". Msg 137, Level 15, State 2, Line 54 Must declare the scalar variable "@CharID". Msg 137, Level 15, State 2, Line 57 Must declare the scalar variable "@Operation". Msg 137, Level 15, State 2, Line 59 Must declare the scalar variable "@CharID". Msg 137, Level 15, State 2, Line 60 Must declare the scalar variable "@CharID". Msg 137, Level 15, State 2, Line 61 Must declare the scalar variable "@CharID". Msg 137, Level 15, State 2, Line 62 Must declare the scalar variable "@CharID". Msg 137, Level 15, State 2, Line 63 Must declare the scalar variable "@CharID". Msg 137, Level 15, State 2, Line 64 Must declare the scalar variable "@CharID". Msg 137, Level 15, State 2, Line 69 Must declare the scalar variable "@Operation". Msg 137, Level 15, State 2, Line 71 Must declare the scalar variable "@CharID". Msg 137, Level 15, State 2, Line 72 Must declare the scalar variable "@CharID". Msg 137, Level 15, State 2, Line 73 Must declare the scalar variable "@CharID". Msg 137, Level 15, State 2, Line 74 Must declare the scalar variable "@CharID". Msg 137, Level 15, State 2, Line 77 Must declare the scalar variable "@Operation". Msg 137, Level 15, State 2, Line 79 Must declare the scalar variable "@CharID". Msg 137, Level 15, State 2, Line 80 Must declare the scalar variable "@CharID". Msg 137, Level 15, State 2, Line 81 Must declare the scalar variable "@CharID". Msg 137, Level 15, State 2, Line 82 Must declare the scalar variable "@CharID". Msg 137, Level 15, State 2, Line 85 Must declare the scalar variable "@Operation". Msg 137, Level 15, State 2, Line 87 Must declare the scalar variable "@CharID". Msg 137, Level 15, State 2, Line 88 Must declare the scalar variable "@CharID". Msg 137, Level 15, State 2, Line 89 Must declare the scalar variable "@CharID". Msg 137, Level 15, State 2, Line 90 Must declare the scalar variable "@CharID". و مفيش stats بتعلي لما بستخدمها |
||||||||||||
|
15-01-2021, 05:49 PM | #2 | |||||||||||||
|
اقتباس:
|
|||||||||||||
|
15-01-2021, 10:47 PM | #3 | |||||||||||||
|
اقتباس:
|
|||||||||||||
|
15-01-2021, 11:15 PM | #4 | |||||||||||||
|
اقتباس:
|
|||||||||||||
|
16-01-2021, 05:04 PM | #5 | |||||||||||||
|
اقتباس:
|
|||||||||||||
|
16-01-2021, 07:15 PM | #6 | |||||||||||||
|
اقتباس:
ازاي بقي الله يباركلك |
|||||||||||||
|
16-01-2021, 09:36 PM | #7 | |||||||||||||
|
اقتباس:
|
|||||||||||||
|
16-01-2021, 10:52 PM | #8 | |||||||||||||
|
اقتباس:
|
|||||||||||||
|
17-01-2021, 10:22 PM | #9 | ||||||||||||
|
تم حل المشكلة
|
||||||||||||
|
يتصفح الموضوع حالياً : 1 (0 عضو و 1 زائر) | |
|
|