/**
* Creates a new ViewableContest object.
*
* @param integer $participantID
* @param array<mixed> $row
*/
public function __construct($participantID, $row = null)
{
if ($participantID !== null) {
$sql = "SELECT\t\tavatar_table.*, \n\t\t\t\t\t\tcontest_participant.*,\n\t\t\t\t\t\tuser_table.username, \n\t\t\t\t\t\tgroup_table.groupName\n\t\t\t\tFROM \t\twcf" . WCF_N . "_contest_participant contest_participant\n\t\t\t\tLEFT JOIN\twcf" . WCF_N . "_user user_table\n\t\t\t\tON\t\t(user_table.userID = contest_participant.userID)\n\t\t\t\tLEFT JOIN\twcf" . WCF_N . "_avatar avatar_table\n\t\t\t\tON\t\t(avatar_table.avatarID = user_table.avatarID)\n\t\t\t\tLEFT JOIN\twcf" . WCF_N . "_group group_table\n\t\t\t\tON\t\t(group_table.groupID = contest_participant.groupID)\n\t\t\t\tWHERE \t\tcontest_participant.participantID = " . intval($participantID) . "\n\t\t\t\tAND\t\t(" . ContestParticipant::getStateConditions() . ")";
$row = WCF::getDB()->getFirstRow($sql);
}
DatabaseObject::__construct($row);
}
