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(24525)
}
}
Update: I have created a new league with 20 positions available.
Access the League via Join the League after you click on the link scroll down to HoopsSA
League Name: HoopsSA
Password: isaac
If you could post on here once you have joined just so I can make sure it's all working correctly. BTW if we can get enough people I will make 2 Divisions in the League.
Draft type is going to be an email draft system with each person allowed 12 hours to make a pick.
An e-mail draft is a version of an live online draft but it allows a much longer time limit to make a pick. This is good for people with busy schedules or differing time zones. When a player is chosen online, an e-mail is sent to all owners alerting them that a pick has been made and that another team is on the clock.