GummyBear 6 Report post Posted July 2, 2016 (edited) Hello guys, I want to make ranking by chaos points on my web page.. Could anyone give me some advice? Edited July 2, 2016 by GummyBear Quote Share this post Link to post Share on other sites
Billy 164 Report post Posted July 2, 2016 I can see 2 ways of doing this: 1) Load all players inventorys, decrypt and check medal of valor parameters, then sort. But this would be very inefficient. 2) Record all changes to chaos points ingame and write to file, load this file on the webpage. Actually, you could probably use SQL triggers to record it, I'll try that tomorrow 1 Quote Share this post Link to post Share on other sites
Billy 164 Report post Posted July 3, 2016 Done using triggers, add these functions/triggers to your db, then you can just select chaospoint from character and order by descending for rankings. (split function is not mine, found on stackoverflow) I havent fully tested, so let me know if there are any issues. (Updated to fix dupe bug when user doesnt have a medal of valor) CHAOS.sql 2 Quote Share this post Link to post Share on other sites