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(4606)
}
}
I currently do stats for the 36ers, and what Isaac is saying wouldn't be too hard. We already run 2 computers, and also have a wireless netowrk setup with internet access. This is all supplied by our sponsor, Business IT Solutions.
Currently we don't use the game monitor function, but would be extremely easy to set up. We use another stats program that marries in with CyberSports to supply the NBL with their live boxscores, but whether they (NBL) would let us use that feed aswell is another question.
I know I have no dramas seeing the whole stats while i'm sitting on the bench, but as a season ticket holder aswell i've sat in the stands and seen the scoreboard not working, and it's frustrating. I'm sure something better can be worked out