مشاهدة النسخة كاملة : مساعده
comannda
27-06-2017, 12:11 AM
كنت عاوز اعرف ازاي اضيف +255
™Ozoo-Eboda™
27-06-2017, 12:26 AM
--Auther*Pur3viL*
DECLARE*@Charid*int
DECLARE*@ItemID*int
Declare*@Charname*VarChar(50)
Declare*@PLUS*int
DECLARE*@Head*int
Declare*@CHEST*int
DECLARE*@LEGS*int
DECLARE*@SHOULDER*int
DECLARE*@HAND*int
DECLARE*@FOOT*int
DECLARE*@RING1*int
DECLARE*@RING2*int
DECLARE*@NECK*int
DECLARE*@ERRING*int
DECLARE*@WEP*int
DECLARE*@SHIELD*int
SET*@Charname*=*'Pur3viL'
SET*@PLUS*=*'7'
SET*@Charid*=*(select*CharID*from*_Char*where*Char Name16=@Charname)
SET*@Head*=*(Select*ItemID*from*SRO_VT_SHARD.dbo._ Inventory*where*Slot=0*and*CharID=@Charid)
SET*@CHEST*=*(Select*ItemID*from*SRO_VT_SHARD.dbo. _Inventory*where*Slot=1*and*CharID=@Charid)
SET*@LEGS*=*(Select*ItemID*from*SRO_VT_SHARD.dbo._ Inventory*where*Slot=4*and*CharID=@Charid)
SET*@SHOULDER*=*(Select*ItemID*from*SRO_VT_SHARD.d bo._Inventory*where*Slot=2*and*CharID=@Charid)
SET*@HAND*=*(Select*ItemID*from*SRO_VT_SHARD.dbo._ Inventory*where*Slot=3*and*CharID=@Charid)
SET*@FOOT*=*(Select*ItemID*from*SRO_VT_SHARD.dbo._ Inventory*where*Slot=5*and*CharID=@Charid)
SET*@RING1*=*(Select*ItemID*from*SRO_VT_SHARD.dbo. _Inventory*where*Slot=11*and*CharID=@Charid)
SET*@RING2*=*(Select*ItemID*from*SRO_VT_SHARD.dbo. _Inventory*where*Slot=12*and*CharID=@Charid)
SET*@NECK*=*(Select*ItemID*from*SRO_VT_SHARD.dbo._ Inventory*where*Slot=10*and*CharID=@Charid)
SET*@ERRING*=*(Select*ItemID*from*SRO_VT_SHARD.dbo ._Inventory*where*Slot=9*and*CharID=@Charid)
SET*@WEP*=(Select*ItemID*from*SRO_VT_SHARD.dbo._In ventory*where*Slot=6*and*CharID=@Charid)
SET*@SHIELD*=(Select*ItemID*from*SRO_VT_SHARD.dbo. _Inventory*where*Slot=7*and*CharID=@Charid)
update*_Items*
set*MagParamNum=6,
optlevel=@PLUS,
MagParam1*=5583457484950,
MagParam2*=5583457484962,
MagParam3*=30064771144,
MagParam4=858993459290,
MagParam5=30064771150,
MagParam6=257698037898,
Variance=865920825
where*ID64*=@Head
---------------
update*_Items*
set*MagParamNum=6,
optlevel=@PLUS,
MagParam1*=5583457484950,
MagParam2*=5583457484962,
MagParam3*=30064771144,
MagParam4=858993459290,
MagParam5=30064771150,
MagParam6=257698037898,
Variance=865920825
where*ID64*=@CHEST
----------------------
update*_Items*
set*MagParamNum=4,
optlevel=@PLUS,
MagParam1*=30064771150,
MagParam2*=30064771144,
MagParam3*=858993459290,
MagParam4=257698037898,
Variance=865920825
where*ID64*=@SHOULDER
----------------------
update*_Items*
set*MagParamNum=4,
optlevel=@PLUS,
MagParam1*=30064771150,
MagParam2*=30064771144,
MagParam3*=858993459290,
MagParam4=257698037898,
Variance=865920825
where*ID64*=@HAND
update*_Items*
set*MagParamNum=6,
optlevel=@PLUS,
MagParam1*=5583457484950,
MagParam2*=5583457484962,
MagParam3*=30064771144,
MagParam4=858993459290,
MagParam5=30064771150,
MagParam6=257698037898,
Variance=865920825
where*ID64*=@LEGS
-----------------------
update*_Items*
set*MagParamNum=4,
optlevel=@PLUS,
MagParam1*=30064771150,
MagParam2*=30064771144,
MagParam3*=858993459290,
MagParam4=257698037898,
Variance=865920825
where*ID64*=@FOOT
update*_Items*
set*MagParamNum=6,
optlevel=@PLUS,
MagParam1*=30064771144,
MagParam2*=30064771150,
MagParam3*=85899346100,
MagParam4*=85899346094,
MagParam5*=85899346112,
MagParam6*=85899346106,
Variance=858
where*ID64*=@RING1
update*_Items*
set*MagParamNum=6,
optlevel=@PLUS,
MagParam1*=30064771144,
MagParam2*=30064771150,
MagParam3*=85899346100,
MagParam4*=85899346094,
MagParam5*=85899346112,
MagParam6*=85899346106,
Variance=858
where*ID64*=@RING2
update*_Items*
set*MagParamNum=6,
optlevel=@PLUS,
MagParam1*=30064771144,
MagParam2*=30064771150,
MagParam3*=85899346100,
MagParam4*=85899346094,
MagParam5*=85899346112,
MagParam6*=85899346106,
Variance=858
where*ID64*=@NECK
update*_Items*
set*MagParamNum=6,
optlevel=@PLUS,
MagParam1*=30064771144,
MagParam2*=30064771150,
MagParam3*=85899346100,
MagParam4*=85899346094,
MagParam5*=85899346112,
MagParam6*=85899346106,
Variance=858
where*ID64*=@ERRING
update*_Items*
set*MagParamNum=4,
optlevel=@PLUS,
MagParam1*=30064771150,
MagParam2*=30064771144,
MagParam3*=858993459290,
MagParam4*=257698037862,
Variance=28817845082
where*ID64*=@WEP
update*_Items*
set*MagParamNum=3,
optlevel=@PLUS,
MagParam1*=30064771150,
MagParam2*=30064771144,
MagParam3*=858993459290,
Variance=900557658
where*ID64*=@SHIELD
select***from*_Inventory*where*CharID=@Charid*and* Slot*between*0*and*12اتفضل ..
دي كويري بتظبط stats و ++
هتكتب اسم الشخصية اللي معاها الايتم بس لازم يكون الكراكتر ماسك السلاح مثلا
..
™Ozoo-Eboda™
27-06-2017, 12:26 AM
--Auther*Pur3viL*
DECLARE*@Charid*int
DECLARE*@ItemID*int
Declare*@Charname*VarChar(50)
Declare*@PLUS*int
DECLARE*@Head*int
Declare*@CHEST*int
DECLARE*@LEGS*int
DECLARE*@SHOULDER*int
DECLARE*@HAND*int
DECLARE*@FOOT*int
DECLARE*@RING1*int
DECLARE*@RING2*int
DECLARE*@NECK*int
DECLARE*@ERRING*int
DECLARE*@WEP*int
DECLARE*@SHIELD*int
SET*@Charname*=*'Pur3viL'
SET*@PLUS*=*'7'
SET*@Charid*=*(select*CharID*from*_Char*where*Char Name16=@Charname)
SET*@Head*=*(Select*ItemID*from*SRO_VT_SHARD.dbo._ Inventory*where*Slot=0*and*CharID=@Charid)
SET*@CHEST*=*(Select*ItemID*from*SRO_VT_SHARD.dbo. _Inventory*where*Slot=1*and*CharID=@Charid)
SET*@LEGS*=*(Select*ItemID*from*SRO_VT_SHARD.dbo._ Inventory*where*Slot=4*and*CharID=@Charid)
SET*@SHOULDER*=*(Select*ItemID*from*SRO_VT_SHARD.d bo._Inventory*where*Slot=2*and*CharID=@Charid)
SET*@HAND*=*(Select*ItemID*from*SRO_VT_SHARD.dbo._ Inventory*where*Slot=3*and*CharID=@Charid)
SET*@FOOT*=*(Select*ItemID*from*SRO_VT_SHARD.dbo._ Inventory*where*Slot=5*and*CharID=@Charid)
SET*@RING1*=*(Select*ItemID*from*SRO_VT_SHARD.dbo. _Inventory*where*Slot=11*and*CharID=@Charid)
SET*@RING2*=*(Select*ItemID*from*SRO_VT_SHARD.dbo. _Inventory*where*Slot=12*and*CharID=@Charid)
SET*@NECK*=*(Select*ItemID*from*SRO_VT_SHARD.dbo._ Inventory*where*Slot=10*and*CharID=@Charid)
SET*@ERRING*=*(Select*ItemID*from*SRO_VT_SHARD.dbo ._Inventory*where*Slot=9*and*CharID=@Charid)
SET*@WEP*=(Select*ItemID*from*SRO_VT_SHARD.dbo._In ventory*where*Slot=6*and*CharID=@Charid)
SET*@SHIELD*=(Select*ItemID*from*SRO_VT_SHARD.dbo. _Inventory*where*Slot=7*and*CharID=@Charid)
update*_Items*
set*MagParamNum=6,
optlevel=@PLUS,
MagParam1*=5583457484950,
MagParam2*=5583457484962,
MagParam3*=30064771144,
MagParam4=858993459290,
MagParam5=30064771150,
MagParam6=257698037898,
Variance=865920825
where*ID64*=@Head
---------------
update*_Items*
set*MagParamNum=6,
optlevel=@PLUS,
MagParam1*=5583457484950,
MagParam2*=5583457484962,
MagParam3*=30064771144,
MagParam4=858993459290,
MagParam5=30064771150,
MagParam6=257698037898,
Variance=865920825
where*ID64*=@CHEST
----------------------
update*_Items*
set*MagParamNum=4,
optlevel=@PLUS,
MagParam1*=30064771150,
MagParam2*=30064771144,
MagParam3*=858993459290,
MagParam4=257698037898,
Variance=865920825
where*ID64*=@SHOULDER
----------------------
update*_Items*
set*MagParamNum=4,
optlevel=@PLUS,
MagParam1*=30064771150,
MagParam2*=30064771144,
MagParam3*=858993459290,
MagParam4=257698037898,
Variance=865920825
where*ID64*=@HAND
update*_Items*
set*MagParamNum=6,
optlevel=@PLUS,
MagParam1*=5583457484950,
MagParam2*=5583457484962,
MagParam3*=30064771144,
MagParam4=858993459290,
MagParam5=30064771150,
MagParam6=257698037898,
Variance=865920825
where*ID64*=@LEGS
-----------------------
update*_Items*
set*MagParamNum=4,
optlevel=@PLUS,
MagParam1*=30064771150,
MagParam2*=30064771144,
MagParam3*=858993459290,
MagParam4=257698037898,
Variance=865920825
where*ID64*=@FOOT
update*_Items*
set*MagParamNum=6,
optlevel=@PLUS,
MagParam1*=30064771144,
MagParam2*=30064771150,
MagParam3*=85899346100,
MagParam4*=85899346094,
MagParam5*=85899346112,
MagParam6*=85899346106,
Variance=858
where*ID64*=@RING1
update*_Items*
set*MagParamNum=6,
optlevel=@PLUS,
MagParam1*=30064771144,
MagParam2*=30064771150,
MagParam3*=85899346100,
MagParam4*=85899346094,
MagParam5*=85899346112,
MagParam6*=85899346106,
Variance=858
where*ID64*=@RING2
update*_Items*
set*MagParamNum=6,
optlevel=@PLUS,
MagParam1*=30064771144,
MagParam2*=30064771150,
MagParam3*=85899346100,
MagParam4*=85899346094,
MagParam5*=85899346112,
MagParam6*=85899346106,
Variance=858
where*ID64*=@NECK
update*_Items*
set*MagParamNum=6,
optlevel=@PLUS,
MagParam1*=30064771144,
MagParam2*=30064771150,
MagParam3*=85899346100,
MagParam4*=85899346094,
MagParam5*=85899346112,
MagParam6*=85899346106,
Variance=858
where*ID64*=@ERRING
update*_Items*
set*MagParamNum=4,
optlevel=@PLUS,
MagParam1*=30064771150,
MagParam2*=30064771144,
MagParam3*=858993459290,
MagParam4*=257698037862,
Variance=28817845082
where*ID64*=@WEP
update*_Items*
set*MagParamNum=3,
optlevel=@PLUS,
MagParam1*=30064771150,
MagParam2*=30064771144,
MagParam3*=858993459290,
Variance=900557658
where*ID64*=@SHIELD
select***from*_Inventory*where*CharID=@Charid*and* Slot*between*0*and*12اتفضل ..
دي كويري بتظبط stats و ++
هتكتب اسم الشخصية اللي معاها الايتم بس لازم يكون الكراكتر ماسك السلاح مثلا
..
Legendr
27-06-2017, 01:19 AM
بس انا بيتهيالي انه اخره 250 مش 255
MORJANA
27-06-2017, 10:56 AM
أخرها +250
و ده لو عايز تعمل ADV +250 للـ GM بس
RefObjCommon
1 41918 ITEM_UPPER_WE ?? ????(??) xxx SN_ITEM_ETC_ARCHEMY_UPPER_REINFORCE_13_S SN_ITEM_ETC_ARCHEMY_UPPER_REINFORCE_WE_S_RARE_TT_D ESC 1 0 3 3 10 4 180000 3 2 1 1 1 255 3 1 0 0 0 0 200000 0 0 0 2000 40000 -1 0 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 xxx item\etc\drop_reinforce_recipe.bsr item\etc\archemy_upper_reinforce_weapon2.ddj xxx xxx 43662
RefObjItem :
43662 1 2 0 0 13 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 100663296 ?????? -1 xxx -1 xxx -1 xxx 0 ?????? 0 ?????? 2 ?????? 250 ???? +2 -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx 0 0 0
Itemdata_45000 :
1 41918 ITEM_UPPER_WE ?? ????(??) xxx SN_ITEM_ETC_ARCHEMY_UPPER_REINFORCE_13_GM SN_ITEM_ETC_ARCHEMY_UPPER_REINFORCE_WE_GM_RARE_TT_ DESC 0 0 3 3 10 4 180000 3 2 1 1 1 255 3 1 0 0 0 0 200000 0 0 0 2000 40000 -1 0 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 xxx item\etc\drop_reinforce_recipe.bsr item\etc\archemy_upper_reinforce_weapon2.ddj xxx xxx 1 2 0 0 13 0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 0 0 0 0 0 0 0 0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 100663296 ?????? -1 xxx -1 xxx -1 xxx 0 ?????? 0 ?????? 2 ?????? 250 ???? +2 -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx 0 0
طبعا أنت هتعمل منه 3 كمان للـ Set .. Shield & Accss مع مراعاة تغيير الـID's و الـ link بتاعهم بالتوفيق
ملحوظة : كود الـADV منقول :snitch:
comannda
27-06-2017, 06:22 PM
بعد ازن حضرتك كنت عاوز اعرف ازاي اعمل كوبر انا اسه جديد
™Ozoo-Eboda™
27-06-2017, 06:38 PM
بعد ازن حضرتك كنت عاوز اعرف ازاي اعمل كوبر انا اسه جديد
حضرتك هتاخد الكويري دي copy
بعدان SQL
بعدان database
هتلاقي اعلي البرنامج كلمة. New Query
اضغط عليها و اعمل past الكويري و عدل عليه ..
مكان الاسم هتكتي اسم الشخصية اللي معاها الايتم ..و مكان الرقم دا ال ++ اللي انت عاوزة
..
بعد التعديل هتضغط كليك يمين داخل مربع الكويري و تضغط Excute او F5
..
بالتوفيق
comannda
27-06-2017, 09:30 PM
مشكور
™Ozoo-Eboda™
28-06-2017, 07:22 PM
^^
يغلق
vBulletin® v3.8.11, Copyright ©2000-2026, vBulletin Solutions, Inc