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(187)
}
}
I wont be playing, a bit unfair to be running the comp, making the rules and playing....
Ok...well we have a full comp by the looks....
I'll throw together a site in the next few days with the rules etc (rememeber, I'm no web design genius, it will be basic)
You will pick players based on a draft, and the order will be based on a lottery system.
You will take turns in selecting NBL rostered players, picking a maximum of 10 players, with only 8 to be active at any time.
Teams will play each other as per the draw of the NBL,(you will select a team to be at time of actual sign up), and you will get the stats from the players that you have active.
I will post on this thread the web address when I have it up and running.