Item Stat problem

04/06/2019 20:01 bende16#1

str 3 int 3
%100 Please fix and share with me please
please all features %100 share with me fixed .
HP (%100)
MP (%100)
Parry rate (%100)
Durability %200 ( %100)

HTML Code:

UPDATE _Char SET CurLevel = 1, MaxLevel = 1, Strength = 20, Intellect= 20, RemainStatPoint= 0, ExpOffset = 0, RemainGold = 1000000, RemainSkillPoint = 0, InventorySize = 109 WHERE _Char.CharID = [MENTION=993253]newchar[/MENTION]ID
UPDATE _Items SET OptLevel=10,Variance=1073741823,MagParamNum=6,MagParam1=858993459290,MagParam2=257698037898,MagParam3=5583457484950,MagParam4=30064771150 ,MagParam5=5583457484962,MagParam6=30064771144 WHERE ID64 IN (SELECT ItemID FROM _Inventory WHERE Slot BETWEEN 0 AND 5  AND CharID [MENTION=993253]newchar[/MENTION]ID)
UPDATE _Items SET OptLevel=10,Variance=34359738367,MagParamNum=5,MagParam1=858993459290,MagParam2=257698037862,MagParam3=429496729714,MagParam4=30064771150 ,MagParam5=30064771144 WHERE ID64 IN (SELECT ItemID FROM _Inventory WHERE Slot LIKE '6' AND CharID [MENTION=993253]newchar[/MENTION]ID)
UPDATE _Items SET OptLevel=10,Variance=1073741823,MagParamNum=4,MagParam1=858993459290,MagParam2=30064771150,MagParam3=429496729726,MagParam4=30064771144 WHERE ID64 IN (SELECT ItemID FROM _Inventory WHERE Slot LIKE '7' AND CharID [MENTION=993253]newchar[/MENTION]ID)
UPDATE _Items SET OptLevel=10,Variance=1023,MagParamNum=7,MagParam1=30064771150,MagParam2=85899346100,MagParam3=85899346094,MagParam4=85899346088 ,MagParam5=85899346106,MagParam6=85899346112,MagParam7=30064771144 WHERE ID64 IN (SELECT ItemID FROM _Inventory WHERE Slot BETWEEN 9 AND 12 AND CharID [MENTION=993253]newchar[/MENTION]ID)

[Only registered and activated users can see links. Click Here To Register...]

04/06/2019 20:28 Worshiper#2

its already 100% but its show 300% because is D1 :kappapride:

04/06/2019 21:27 VeRo!#3

Make an item full blue manually, get it's row from _Items table, Replace the magparamx with your procedure ones.

04/06/2019 23:34 bende16#4

Fixed thanks

Code:

UPDATE _Char SET CurLevel = 1, MaxLevel = 1, Strength = 20, Intellect= 20, RemainStatPoint= 0, ExpOffset = 0, RemainGold = 10000000, RemainSkillPoint = 0, InventorySize = 109 WHERE _Char.CharID = [MENTION=993253]newchar[/MENTION]ID
UPDATE _Items SET OptLevel='3', MagParamNum='7', MagParam1='12884901893', MagParam2='12884901899', MagParam3='21474836497', MagParam4='21474836509', MagParam5='21474836515', MagParam6='21474836521', MagParam7='21474836503'  WHERE ID64 IN (SELECT ItemID FROM _Inventory WHERE Slot in (9,10,11,12) AND ItemID !=0 AND CharID [MENTION=993253]newchar[/MENTION]ID)
UPDATE _Items set OptLevel='3', MagParamNum='5', MagParam1='12884901899', MagParam2='12884901893', MagParam3='257698037840', MagParam4='85899346012', MagParam5='150323855464'  WHERE ID64 IN (SELECT ItemID FROM _Inventory WHERE Slot = 6 AND ItemID !=0 AND CharID [MENTION=993253]newchar[/MENTION]ID)
UPDATE _Items set OptLevel='3', MagParamNum='4', MagParam1='12884901899', MagParam2='12884901893', MagParam3='150323855476', MagParam4='257698037840'  WHERE ID64 IN (SELECT ItemID FROM _Inventory WHERE Slot = 7 AND ItemID !=0 AND CharID [MENTION=993253]newchar[/MENTION]ID)
UPDATE _Items set OptLevel='3', MagParamNum='6', MagParam1='12884901893', MagParam2='12884901899', MagParam3='128849019020', MagParam4='128849019032', MagParam5='85899346048',MagParam6='257698037840'  WHERE ID64 IN (SELECT ItemID FROM _Inventory WHERE Slot in (0,1,4) AND ItemID !=0 AND CharID [MENTION=993253]newchar[/MENTION]ID)
UPDATE _Items set OptLevel='3', MagParamNum='4', MagParam1='12884901899', MagParam2='12884901893', MagParam3='85899346048', MagParam4='257698037840'  WHERE ID64 IN (SELECT ItemID FROM _Inventory WHERE Slot in (2,3,5) AND ItemID !=0 AND CharID [MENTION=993253]newchar[/MENTION]ID)