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(7656)
}
}
The points system should be scrapped altogether. Its too complicated and makes recruiting difficult because there are too many options to consider. Its enough to just have a salary cap to adhere to and a maximum number of imports per team. The rest is up the club to try and negotiate the best they can within the salary cap restraints. Loyalty to a club by a player staying a long time is a decision to be made by that player and should make no difference to their player rating. Simplicity is the best way as it eliminates suspicion that individual clubs are adhering to the rules. It also makes it more difficult to hide non complying activity by clubs.