/**
* Creates a new price.
*
* @param integer $contestID
* @param integer $sponsorID
* @param string $subject
* @param string $message
* @param string $secretMessage
* @param MessageAttachmentListEditor $attachmentList
* @param integer $position if zero, position will automatically be determined
* @return ContestPriceEditor
*/
public static function create($contestID, $sponsorID, $subject, $message, $secretMessage, $attachmentList = null, $position = 0)
{
if ($position === 0) {
// check maximum position
$position = self::getMaxPosition($contestID) + 1;
}
// get number of attachments
$attachments = $attachmentList !== null ? $attachmentList->getAttachments() : array();
$attachmentsAmount = count($attachments);
$tmp = array_keys($attachments);
$attachmentID = count($tmp) ? $attachments[$tmp[0]]->attachmentID : 0;
$sql = "INSERT INTO\twcf" . WCF_N . "_contest_price\n\t\t\t\t\t(contestID, sponsorID, subject, message, secretMessage, time, position, attachments, attachmentID)\n\t\t\tVALUES\t\t(" . intval($contestID) . ", " . intval($sponsorID) . ", '" . escapeString($subject) . "', \n\t\t\t\t\t'" . escapeString($message) . "', '" . escapeString($secretMessage) . "', \n\t\t\t\t\t" . TIME_NOW . ", " . intval($position) . ", " . $attachmentsAmount . ", " . intval($attachmentID) . ")";
WCF::getDB()->sendQuery($sql);
// get new id
$priceID = WCF::getDB()->getInsertID("wcf" . WCF_N . "_contest_price", 'priceID');
// update entry
$sql = "UPDATE\twcf" . WCF_N . "_contest\n\t\t\tSET\tprices = prices + 1\n\t\t\tWHERE\tcontestID = " . intval($contestID);
WCF::getDB()->sendQuery($sql);
// sent event
require_once WCF_DIR . 'lib/data/contest/event/ContestEventEditor.class.php';
require_once WCF_DIR . 'lib/data/contest/sponsor/ViewableContestSponsor.class.php';
$sponsor = new ViewableContestSponsor($sponsorID);
ContestEventEditor::create($contestID, $sponsor->userID, $sponsor->groupID, __CLASS__, array('priceID' => $priceID, 'owner' => $sponsor->getOwner()->getName()));
// update attachments
if ($attachmentList !== null) {
$attachmentList->updateContainerID($priceID);
$attachmentList->findEmbeddedAttachments($message);
}
return new ContestPriceEditor($priceID);
}
/**
* Creates a new contest entry.
*
* @param integer $userID
* @param integer $groupID
* @param string $subject
* @param string $message
* @param array $options
* @param integer $classIDArray
* @param integer $participants
* @param integer $jurys
* @param integer $prices
* @param integer $sponsors
* @param MessageAttachmentListEditor $attachmentList
* @return ContestEditor
*/
public static function create($userID, $groupID, $subject, $message, $options = array(), $state = 'private', $classIDArray = array(), $participants = array(), $jurys = array(), $prices = array(), $sponsors = array(), $attachmentList = null)
{
// get number of attachments
$attachmentsAmount = $attachmentList !== null ? count($attachmentList->getAttachments()) : 0;
// save entry
$sql = "INSERT INTO\twcf" . WCF_N . "_contest\n\t\t\t\t\t(userID, groupID, subject, message, time, attachments, enableSmilies, enableHtml,\n\t\t\t\t\tenableBBCodes, enableSolution, enableOpenSolution, enableParticipantCheck,\n\t\t\t\t\tenablePricechoice, priceExpireSeconds, enableSponsorCheck)\n\t\t\tVALUES\t\t(" . intval($userID) . ", " . intval($groupID) . ", '" . escapeString($subject) . "', '" . escapeString($message) . "', \n\t\t\t\t\t" . TIME_NOW . ", " . $attachmentsAmount . ",\n\t\t\t\t\t" . (isset($options['enableSmilies']) ? $options['enableSmilies'] : 1) . ",\n\t\t\t\t\t" . (isset($options['enableHtml']) ? $options['enableHtml'] : 0) . ",\n\t\t\t\t\t" . (isset($options['enableBBCodes']) ? $options['enableBBCodes'] : 0) . ",\n\t\t\t\t\t" . (isset($options['enableSolution']) ? $options['enableSolution'] : 0) . ",\n\t\t\t\t\t" . (isset($options['enableOpenSolution']) ? $options['enableOpenSolution'] : 0) . ",\n\t\t\t\t\t" . (isset($options['enableParticipantCheck']) ? $options['enableParticipantCheck'] : 0) . ",\n\t\t\t\t\t" . (isset($options['enablePricechoice']) ? $options['enablePricechoice'] : 0) . ",\n\t\t\t\t\t" . (isset($options['priceExpireSeconds']) ? $options['priceExpireSeconds'] : 0) . ",\n\t\t\t\t\t" . (isset($options['enableSponsorCheck']) ? $options['enableSponsorCheck'] : 0) . ")";
WCF::getDB()->sendQuery($sql);
// get id
$contestID = WCF::getDB()->getInsertID("wcf" . WCF_N . "_contest", 'contestID');
// sent event
require_once WCF_DIR . 'lib/data/contest/event/ContestEventEditor.class.php';
require_once WCF_DIR . 'lib/data/contest/owner/ContestOwner.class.php';
ContestEventEditor::create($contestID, $userID, $groupID, __CLASS__, array('contestID' => $contestID, 'state' => $state, 'owner' => ContestOwner::get($userID, $groupID)->getName()));
// get new object
$entry = new self($contestID);
// update classes
if (count($classIDArray) > 0) {
$entry->setClasses($classIDArray);
}
// update participants
$entry->setParticipants($participants);
// update jurys
$entry->setJurys($jurys);
// update prices
$sponsorID = 0;
if (count($sponsors) > 0 || count($prices) > 0) {
if (count($prices)) {
$sponsorID = $entry->setSponsors($sponsors, $userID, $groupID);
} else {
$entry->setSponsors($sponsors);
$sponsorID = 0;
}
}
// update prices
$entry->setPrices($prices, $sponsorID);
// update attachments
if ($attachmentList !== null) {
$attachmentList->updateContainerID($contestID);
$attachmentList->findEmbeddedAttachments($message);
}
// return object
return $entry;
}
/**
* Creates a new entry solution.
*
* @param integer $contestID
* @param integer $participantID
* @param string $message
* @param string $state
* @param array $options
* @param MessageAttachmentListEditor $attachmentList
* @return ContestSolutionEditor
*/
public static function create($contestID, $participantID, $message, $state = 'private', $options = array(), $attachmentList = null)
{
// get number of attachments
$attachmentsAmount = $attachmentList !== null ? count($attachmentList->getAttachments()) : 0;
$sql = "INSERT INTO\twcf" . WCF_N . "_contest_solution\n\t\t\t\t\t(contestID, participantID, message, time, \n\t\t\t\t\tstate, attachments, enableSmilies, enableHtml, enableBBCodes)\n\t\t\tVALUES\t\t(" . intval($contestID) . ", " . intval($participantID) . ", '" . escapeString($message) . "', " . TIME_NOW . ", \n\t\t\t\t\t'" . escapeString($state) . "', " . $attachmentsAmount . ",\n\t\t\t\t\t" . (isset($options['enableSmilies']) ? $options['enableSmilies'] : 1) . ",\n\t\t\t\t\t" . (isset($options['enableHtml']) ? $options['enableHtml'] : 0) . ",\n\t\t\t\t\t" . (isset($options['enableBBCodes']) ? $options['enableBBCodes'] : 0) . ")";
WCF::getDB()->sendQuery($sql);
// get id
$solutionID = WCF::getDB()->getInsertID("wcf" . WCF_N . "_contest_solution", 'solutionID');
// update entry
$sql = "UPDATE\twcf" . WCF_N . "_contest\n\t\t\tSET\tsolutions = solutions + 1\n\t\t\tWHERE\tcontestID = " . intval($contestID);
WCF::getDB()->sendQuery($sql);
// sent event
require_once WCF_DIR . 'lib/data/contest/event/ContestEventEditor.class.php';
require_once WCF_DIR . 'lib/data/contest/owner/ContestOwner.class.php';
require_once WCF_DIR . 'lib/data/contest/participant/ViewableContestParticipant.class.php';
$participant = new ViewableContestParticipant($participantID);
ContestEventEditor::create($contestID, $participant->userID, $participant->groupID, __CLASS__, array('solutionID' => $solutionID, 'owner' => $participant->getOwner()->getName()));
// update attachments
if ($attachmentList !== null) {
$attachmentList->updateContainerID($solutionID);
$attachmentList->findEmbeddedAttachments($message);
}
return new ContestSolutionEditor($solutionID);
}
