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(35965)
}
}
Who said I am reinventing the wheel? The NBL are slack, so I am putting it into a format that I like, for my own records :|
As for getting a website, I am actually working on that. I am getting the stats first, then I will get it up online. Can't say when that will happen, got a long way to go.
We do have our first baby coming soon, so that is going to take up most of my time.
I'm putting all the historical stats into a spreadsheet and making it look a hell of a lot better to look at. Will include all time leaders in all statistical areas.
You will find that the NBL have decided that Larry Davidson who played at the beginning of the NBL is the same guy who is currently playing for the Hawks. That ticks me off because they aren't the same guy. Real shame because there are possibly more cases of this (haven't come across any yet).