I'm absolutely certain that the following is misleading:
Total Bets: 282
Total Staked: 19287
Total Won: 9499
This makes it look like the bookie has made nearly 10k off users.
I'm looking at the SQL queries and I'm certain that total bets and total staked are correct. However, the total won does not show RETURNED STAKES.
If there's 1 event with 1 bet, odds 1/1 and I win on a $100 bet, the stats should show:
Total Bets: 1
Total Staked: 100
Total Won: 200
However, they DON'T. They would actually show:
Total Bets: 1
Total Staked: 100
Total Won: 100
This makes it look like the bookie has broken even, when the bookie is really down $100.
I'm working on new SQL query to fix this.
|