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(26513)
}
}
Picked my copy up last night, and just played the my player mode all night (probably why i'm so tired at work today lol) and this mode has been improved immensely,
I have also noticed it is a bit easier to drive thru the lane than previous editions...
But overall looks better and so far playes better too.
Up late last night playing it. Awesome. Bit hard to get used to at first, things like calling pick and roll etc but loving it.
Those classic teams are so cool to use, but thought Run TMC sucked, tough team to use if the opposition has a decent centre and pf.