Welcome!

Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!

Join Today!

[Help PHP] Ranking

Newbie Spellweaver
Joined
Mar 16, 2019
Messages
9
Reaction score
0
That is my script for calculating ItemPoints on Slots 0-12
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
CyberKod3 - [Help PHP] Ranking - RaGEZONE Forums


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:
Back
Top