PHP Code:
Top 10 Best Sharers (with minimum 100 MB downloaded)
Account Rank Account User Uploaded Downloaded ratio
1 Optimus Prime 21.83 TB 32.91 GB 679.18
2 Giorgatzelos 9.09 TB 4.43 GB 2,102.27
after table top 10 sharers i get this message:
Code:
BIGINT UNSIGNED value is out of range in '(`hostz_11543320_1`.`torrent_users`.`downloaded` - `hostz_11543320_1`.`torrent_users`.`uploaded`)'
Bump: maybe the error is because there are 2 sharers and the sql seeks for 10?...
i looked at the code and this is the only i can think of....