شرح عمل اى ITEM FB

[[Dev] Arshivel]

شرح عمل اى ITEM FB

Item Stats 61%

Weapon - Dagger - 2h-1h-Warrior -etc Like Phy

UPDATE dbo._Items set OptLevel='10',Variance='3241771616',MagParamNum='5 ',MagParam1='858993459290',MagParam2= '257698037862',MagParam3='30064771150',MagParam4= '30064771144',MagParam5= '429496729714'WHERE ID64='662889'

Weapon - Staff - Claric - Etc Like Mag

UPDATE dbo._Items set OptLevel='10',Variance='638176256',MagParamNum='5' ,MagParam1='858993459290',MagParam2= '257698037862',MagParam3='30064771150',MagParam4= '30064771144',MagParam5= '429496729714'WHERE ID64='662889'

Item Set
Hands - Shoulder - Foot

UPDATE dbo._Items set OptLevel='10',Variance='658099808',Data='3000',Mag ParamNum='4',MagParam1='30064771144',MagParam2= '858993459290',MagParam3='30064771150',MagParam4= '257698037898'WHERE ID64='666187'

Head - Legs - Chest

UPDATE dbo._Items set OptLevel='10',Variance='658099808',MagParamNum='6' ,MagParam1='30064771144',MagParam2= '5583457484950',MagParam3='858993459290',MagParam4 = '5583457484962',MagParam5= '30064771150',MagParam6= '257698037898'WHERE ID64='666187'

Set Accsossry

UPDATE dbo._Items set OptLevel='10',Variance='627',MagParamNum='7',MagPa ram1='30064771144',MagParam2= '30064771150',MagParam3='85899346088',MagParam4= '85899346100',MagParam5= '85899346112',MagParam6= '85899346106',MagParam7= '85899346094'WHERE ID64='666187'

Item Status 80%

Weapon - Dagger - 2h-1h-Warrior -etc Like Phy

UPDATE dbo._Items set OptLevel='10',Variance='26870580000',MagParamNum=' 5',MagParam1='858993459290',MagParam2= '257698037862',MagParam3='30064771150',MagParam4= '30064771144',MagParam5= '429496729714'WHERE ID64='662889'

Weapon - Staff - Claric - Etc Like Mag

UPDATE dbo._Items set OptLevel='10',Variance='27683251200',MagParamNum=' 5',MagParam1='858993459290',MagParam2= '257698037862',MagParam3='30064771150',MagParam4= '30064771144',MagParam5= '429496729714'WHERE ID64='662889'

ITEM Set
Hands - Shoulder - Foot

UPDATE dbo._Items set OptLevel='10',Variance='865920800',Data='3000',Mag ParamNum='4',MagParam1='30064771144',MagParam2= '858993459290',MagParam3='30064771150',MagParam4= '257698037898'WHERE ID64='666187'

Head - Legs - Chest

UPDATE dbo._Items set OptLevel='10',Variance='865920800',MagParamNum='6' ,MagParam1='30064771144',MagParam2= '5583457484950',MagParam3='858993459290',MagParam4 = '5583457484962',MagParam5= '30064771150',MagParam6= '257698037898'WHERE ID64='666187'

Set Accessory

UPDATE dbo._Items set OptLevel='10',Variance='825',MagParamNum='7',MagPa ram1='30064771144',MagParam2= '30064771150',MagParam3='85899346088',MagParam4= '85899346100',MagParam5= '85899346112',MagParam6= '85899346106',MagParam7= '85899346094'WHERE ID64='666187'

ملحوظه ال حاجه دى فى ITEM Dg 11
لو انتا عاوز item dg 12 or 13
ممكن تغير ال ارقام

وى ده شرح كده عشان تجيب ال item



SR_UserEdit

كليك يمين على ال item ثم Edit item
--------------------------------------------
لو انتا عاوز ايتم dg 12 or 13
بتعكلو FB من ال SMC
ثتم بتروح على ال SQl - SRO_VT_SHARD
[dbo].[_Items]



فى ال صوره MagParam1 - etc
كل ال عليك فى ال Query انك هتغير ال رقم
Enjoy