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(26538)
}
}
I believe that its up to individuals to just avoid things like news or pages on the internet which are more than likely going to publish the league's scores as they happen. Sorry to say but sites like nbl.com.au are an obvious source of NBL scores and once a game is played they are going to have it on the site.
If you don't want to know the game score, don't watch or go where you're likely to find out before seeing the TV replay, simple.
Another good idea (seperating scores/twitter accounts), enjoy following some of the other clubs and for instance the Breakers used twitter quite well last season until it came to game night and it turned into almost a play by play!
I think scores should remain in the title headers on the official site.
For those who want to check in on the results but not inclined to tune in at 10:30pm.
The ... Click for more is a good idea but generally knowing the game is on delay you would think u would avoid social media (facebook, twitter, forums etc).