Quote:
Originally Posted by Invader Amoto
Is there any simple way I can get some statistics from the data I've got in the database? Specifically to see what the drop rate is on these Festive Crates.
|
Run this query on the database:
Code:
SELECT `item`, COUNT(*)/(SELECT COUNT(*) FROM `log` WHERE `method`=-1 AND `time`>1292047200)*100 as `percentage` FROM `log` WHERE `method`=-1 AND `time`>1292047200 GROUP BY `item` ORDER BY `percentage` DESC
Remove the 2 "AND `time`>1292047200"s if you want the all-time statisitics, rather than since 11th Dec (When Festive Crates started dropping)
Quote:
Originally Posted by sir.moe
Most items under the latest version are stored as type 6's aka unique. These should be type 0 and type 6 should be unique only.
|
I have no idea what this means. >.>