That is my script for calculating ItemPoints on Slots 0-12
One account i dont have items on me. is Naked and that is result
Normal is ItemPoints : 0 and the other problems is put one item +5 normal on me and the ItemPoints : 125 ( 130 -5 =125 normal 130 +5=135)
Anyone can helping me to fix that?
PHP:
SELECT TOP 25 _Char.CharName16 , _Char.CurLevel , SUM(_Items.OptLevel) AS ItemPointsFROM _Char INNER JOIN _Inventory ON _Char.CharID = _Inventory.CharID INNER JOIN _Items ON _Inventory.ItemID = _Items.ID64 where _char.charname16 not like 'GM' AND _char.Charname16 not like '%xprodigy%' AND _char.charname16 not like '%-%' AND _inventory.Slot between 0 and 12GROUP BY _Char.CharName16,_Char.CurLevelOrder by _Char.CurLevel desc ,SUM(_items.Optlevel) desc");
One account i dont have items on me. is Naked and that is result
Normal is ItemPoints : 0 and the other problems is put one item +5 normal on me and the ItemPoints : 125 ( 130 -5 =125 normal 130 +5=135)
Anyone can helping me to fix that?
Last edited: