array(2) {
[0]=>
string(815) "
select r.*,
rc.info,
t.title as threadtitle,
u.username as username,
u.anonymous as useranonymous,
`f`.`value` AS `flairvalue`,
`ft`.`name` AS `flairname`,
`ft`.`colour` AS `flaircolour`,
`ft`.`icon` AS `flairicon`
from reply as r
join thread as t on t.id = r.threadid
join replycontent as rc on rc.replyid = r.id
join user as u on u.id = r.userid
left join `flair` `f` on `f`.`userid` = `u`.`id` and `f`.`categoryid` = `t`.`categoryid`
left join `flairoption` `ft` on `ft`.`id` = `f`.`flairoptionid`
where r.businessid = :businessId
and r.threadid = :threadId
group by r.id
order by r.utcdated desc
limit 0,50
"
[1]=>
array(2) {
["businessId"]=>
int(1)
["threadId"]=>
int(36122)
}
}
The other thing you need to note is that a players points rating (relative to how much it counts towards the team) remains as is for the length of their contract. So if an ordinary player is signed on for say 1 point for a 3 year contract, they will only count as 1 point for each of those 3 years. If they have a breakout year and become a superstar worth 10 points, if their original contract is in place they'll only count as one. Makes it interesting when contract renewal time comes up, but it does reward the club for having some faith in the player.
The loyalty system is a bit farcical as it was brought in and applied straight away. If teams had known it was coming a few years ago they may have changed the way they handled players. This is one part that the Wildcats have benefited from.
The points system is not bad but I think it still needs a bit of tweaking to help spread out the talent as it is designed to do.