[Dev] Arshivel
06-09-2013, 05:23 AM
http://imageshack.us/a/img849/6192/besmelah.png
شرح عمل اى 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
http://img31.imageshack.us/img31/5066/owui.jpg
SR_UserEdit
كليك يمين على ال item ثم Edit item
--------------------------------------------
لو انتا عاوز ايتم dg 12 or 13
بتعكلو FB من ال SMC
ثتم بتروح على ال SQl - SRO_VT_SHARD
[dbo].[_Items]
http://img138.imageshack.us/img138/5208/tp3r.jpg
فى ال صوره MagParam1 - etc
كل ال عليك فى ال Query انك هتغير ال رقم
Enjoy
شرح عمل اى 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
http://img31.imageshack.us/img31/5066/owui.jpg
SR_UserEdit
كليك يمين على ال item ثم Edit item
--------------------------------------------
لو انتا عاوز ايتم dg 12 or 13
بتعكلو FB من ال SMC
ثتم بتروح على ال SQl - SRO_VT_SHARD
[dbo].[_Items]
http://img138.imageshack.us/img138/5208/tp3r.jpg
فى ال صوره MagParam1 - etc
كل ال عليك فى ال Query انك هتغير ال رقم
Enjoy