[Help PHP] Ranking

[CyberKod3]

That is my script for calculating ItemPoints on Slots 0-12

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?

[MentaL]