I’ve sent Cobus an email yet again (quoted below) asking for details. Hopefully it will be the end of the matter after these details are sent to me.
referback (including Shane and Wayne) so I’m making a
very reasonable request to make everything clear to
me. I would like these details of every player that’s
ever joined through me: Date they joined, date the
first played, date last played, any chargebacks and
when and also reason for account closure if
applicable. I hope that part isn’t too difficult. I
realise there would be a lot of players but hopefully
the main part can be a simple database query (I don’t
care what format it is in as long as the info is
there).
They should have an identifying ID (i.e. account
number with some digits removed). Then by month: which
of those players played and, attached to each player,
their deposit, wagers, return and cashouts that month.
Again, the database query should be pretty simple for
each month, eg. in SQL to get the list of player
details (for each player) from Feb 2007 the query
would be something like: “select player,
sum(deposits), sum(wagers), sum(return), sum(cashouts)
where affiliate=’aff82426′ and date BETWEEN
‘2007-02-01’ and ‘2007-03-01’ GROUP BY player”. Then
each row returned will contain the player and the
details I want. The past 24 months would be fine but
I’d like more if possible. Again, I don’t care what
format it is in as long as the data is there. I don’t
need the specific dates played either like I’d get
with Trident, I just need the monthly figures.