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(129)
}
}
Well, CyberSports (the NBL / ABL stats software) runs a player ranking system that I would utilise, and there is a program that I used previously that actually ran the game based on player stats and the teams playing.
A little labour intensive to set up, but once you get it going, it runs really well.
I was wondering what interest there would be in a fantasy NBL league.
I ran one of the early leagues on one of OzHoops predecessor sites, and would be willing to set one up again (or a couple of conferences if need be).....let me know through a post here for now if your interested (and if we get enough interest, I might be able to convince Isaac to dedicate some site space for us).
I think it was probably more likely to do with the severing of ties when the Sixers moved to AEC. When the club first announced they were moving games to the AEC they said they would still continue to train at TSA but that then went out the window and they moved to PA Rec Centre instead.