Query : Make Item D14 FB 100%

[StayAlive-Online]

http://www6.0zz0.com/2013/05/27/01/688213374.gif

كما عودناكم دائما بالمواضيع المميزة

استعلام جاهز لعمل الايتم FB 100%
ملحوظة : دجرى 14 فقط

الاستعلامات دى حتخلى الايتم +14 و FB فى نفس الوقت
Helm

update _Items
set MagParamNum=6,
optlevel=14,
MagParam1 =34359738807,
MagParam2 =34359738808,
MagParam3 =7301444403646,
MagParam4=7301444403647,
MagParam5=858993459641,
MagParam6=257698038205
where ID64 like 'ITEM ID'
---------------
Mail

update _Items
set MagParamNum=6,
optlevel=14,
MagParam1 =34359738807,
MagParam2 =34359738808,
MagParam3 =7301444403646,
MagParam4=7301444403647,
MagParam5=858993459641,
MagParam6=257698038205
where ID64 like 'ITEM ID'

----------------------

shoulder

update _Items
set MagParamNum=4,
optlevel=14,
MagParam1 =34359738807,
MagParam2 =34359738808,
MagParam3 =858993459641,
MagParam4=257698038205
where ID64 like 'ITEM ID'

----------------------
gantelet

update _Items
set MagParamNum=4,
optlevel=14,
MagParam1 =34359738807,
MagParam2 =34359738808,
MagParam3 =858993459641,
MagParam4=257698038205
where ID64 like 'ITEM ID'
----------------------

pants

update _Items
set MagParamNum=6,
optlevel=14,
MagParam1 =34359738807,
MagParam2 =34359738808,
MagParam3 =7301444403646,
MagParam4=7301444403647,
MagParam5=858993459641,
MagParam6=257698038205
where ID64 like 'ITEM ID'

-----------------------

boots


update _Items
set MagParamNum=4,
optlevel=14,
MagParam1 =34359738807,
MagParam2 =34359738808,
MagParam3 =858993459641,
MagParam4=257698038205
where ID64 like 'ITEM ID'

--------------------------
السلاح و الشيلد



update _Items
set MagParamNum=8,
optlevel=14,
MagParam1 =8589935060,
MagParam2 =4294967758,
MagParam3 =4294967762,
MagParam4=429496730043,
MagParam5=858993459641,
MagParam6=34359738808,MagParam7 =34359738807,
MagParam8=257698038202
where ID64 like 'ITEM ID'

------------------------

shield

update _Items
set MagParamNum=4,
optlevel=14,
MagParam1 =34359738807,
MagParam2 =34359738808,
MagParam3 =858993459641,
MagParam4=429496730044
where ID64 like 'ITEM ID'
الاكسيسورى
earring

update _Items
set MagParamNum=6,
optlevel=14,
MagParam1 =85899346347,
MagParam2 =85899346349,
MagParam3 =85899346346,
MagParam4=85899346348,
MagParam5=34359738785,
MagParam6=34359738786
where ID64 like 'ITEM ID'

--------------------------
ring STR & INT

update _Items
set MagParamNum=2,
optlevel=14,
MagParam1 =34359738807,
MagParam2 =34359738808
where ID64 like 'ITEM ID'

-------------------------
necklace


update _Items
set MagParamNum=2,
optlevel=14,
MagParam1 =34359738807,
MagParam2 =34359738808
where ID64 like 'ITEM ID'
نشوفكم على خير فى الموضوع القادم

[Yui]

good jop but you need to get item ID from SMC

[StayAlive-Online]

good jop but you need to get item ID from SMC
sure need item id from smc

edit item >> modify >> item id

[MyRȝturn]

good jop
ThX

[Yui]

sure need item id from smc

edit item >> modify >> item id

also can get the item ID by this Query


USE [SRO_VT_SHARD]
/**** Query By Yui *****/
SELECT
[dbo].[_Inventory].[CharID],
[dbo].[_Char].[CharName16],
[dbo].[_Inventory].[Slot],
[dbo].[_Inventory].[ItemID],
[dbo].[_Items].[RefItemID],
[dbo].[_Items].[OptLevel],
[dbo].[_RefObjCommon].[CodeName128]
FROM [dbo].[_Inventory]
JOIN [dbo].[_Char] ON [dbo].[_Inventory].[CharID] = [dbo].[_Char].[CharID]
JOIN [dbo].[_Items] ON [dbo].[_Inventory].[ItemID] = [dbo].[_Items].[ID64]
JOIN [dbo].[_RefObjCommon] ON [dbo].[_Items].[RefItemID] = [dbo].[_RefObjCommon].[ID]
WHERE [dbo].[_Char].[CharName16] like'char name'
ORDER BY[dbo].[_Char].[CharName16]ASC,[dbo].[_Inventory].[Slot]ASC;

[elfr3on2010]

تسلم ايدك

[●♥ Marwan1337 ♥●]

تسلــمـ أيــدكـ ,,

[افندينا ™Hamboka™]

تسلم

[Mr Z!dane]

تــــســـلم يـــا بـــاشا ,,,

[iLead]

تسلم ايدك .. استمر

[Gm Boola]

يا جماعا انا ليسه جديد عايز شرح للكلام ده بليييز:wavetowel2:

[☜ ĂиTaKą ☞]

Good Jop

[The_Run]

تسلم ايدك بجد

[Xeitran]

مشكور جداً

[Tigger]

تسلم :rm_bear:

[GM CrazyViper]

Thx You And Good Jop

[BeitoMoza]

Awaz Query Stats . we F.B Ba3d Eznkoo:wavetowel2:

[MahMoudMeDo]

mfesh 61 ?

[mido1044]

تسلم يا معلم. الف شكر