/**
* Updates this entry solution.
*
* @param string $message
* @param string $state
* @param array $options
* @param MessageAttachmentListEditor $attachmentList
*/
public function update($message, $state, $options = array(), $attachmentList = null)
{
// get number of attachments
$attachmentsAmount = $attachmentList !== null ? count($attachmentList->getAttachments($this->solutionID)) : 0;
$sql = "UPDATE\twcf" . WCF_N . "_contest_solution\n\t\t\tSET\tmessage = '" . escapeString($message) . "',\n\t\t\t\tstate = '" . escapeString($state) . "',\n\t\t\t\tattachments = " . $attachmentsAmount . ",\n\t\t\t\tenableSmilies = " . (isset($options['enableSmilies']) ? $options['enableSmilies'] : 1) . ",\n\t\t\t\tenableHtml = " . (isset($options['enableHtml']) ? $options['enableHtml'] : 0) . ",\n\t\t\t\tenableBBCodes = " . (isset($options['enableBBCodes']) ? $options['enableBBCodes'] : 1) . "\n\t\t\tWHERE\tsolutionID = " . intval($this->solutionID);
WCF::getDB()->sendQuery($sql);
// update attachments
if ($attachmentList != null) {
$attachmentList->findEmbeddedAttachments($message);
}
}
/**
* Updates this price.
*
* @param string $subject
* @param string $message
* @param string $secretMessage
* @param string $state
* @param MessageAttachmentListEditor $attachmentList
*/
public function update($subject, $message, $secretMessage, $state, $attachmentList = null)
{
// get number of attachments
$attachments = $attachmentList !== null ? $attachmentList->getAttachments($this->priceID) : array();
$attachmentsAmount = count($attachments);
$tmp = array_keys($attachments);
$attachmentID = count($tmp) ? $attachments[$tmp[0]]->attachmentID : 0;
$sql = "UPDATE\twcf" . WCF_N . "_contest_price\n\t\t\tSET\tsubject = '" . escapeString($subject) . "',\n\t\t\t\tmessage = '" . escapeString($message) . "',\n\t\t\t\tsecretMessage = '" . escapeString($secretMessage) . "',\n\t\t\t\tstate = '" . escapeString($state) . "',\n\t\t\t\tattachments = " . $attachmentsAmount . ",\n\t\t\t\tattachmentID = " . intval($attachmentID) . "\n\t\t\tWHERE\tpriceID = " . intval($this->priceID);
WCF::getDB()->sendQuery($sql);
// update attachments
if ($attachmentList != null) {
$attachmentList->findEmbeddedAttachments($message);
}
}
/**
* Updates this entry.
*
* @param integer $userID
* @param integer $groupID
* @param string $subject
* @param string $message
* @param string $fromTime
* @param string $untilTime
* @param string $state
* @param array $options
* @param integer $classIDArray
* @param MessageAttachmentListEditor $attachmentList
*/
public function update($userID, $groupID, $subject, $message, $fromTime, $untilTime, $state, $options = array(), $classIDArray = array(), $attachmentList = null)
{
// get number of attachments
$attachmentsAmount = $attachmentList !== null ? count($attachmentList->getAttachments($this->contestID)) : 0;
// update data
$sql = "UPDATE\twcf" . WCF_N . "_contest\n\t\t\tSET\tuserID = " . intval($userID) . ",\n\t\t\t\tgroupID = " . intval($groupID) . ",\n\t\t\t\tsubject = '" . escapeString($subject) . "',\n\t\t\t\tmessage = '" . escapeString($message) . "',\n\t\t\t\tfromTime = " . intval($fromTime) . ",\n\t\t\t\tuntilTime = " . intval($untilTime) . ",\n\t\t\t\tattachments = " . $attachmentsAmount . ",\n\t\t\t\tenableSmilies = " . (isset($options['enableSmilies']) ? $options['enableSmilies'] : 1) . ",\n\t\t\t\tenableHtml = " . (isset($options['enableHtml']) ? $options['enableHtml'] : 0) . ",\n\t\t\t\tenableBBCodes = " . (isset($options['enableBBCodes']) ? $options['enableBBCodes'] : 1) . ",\n\t\t\t\tenableSolution = " . (isset($options['enableSolution']) ? $options['enableSolution'] : 0) . ",\n\t\t\t\tenableOpenSolution = " . (isset($options['enableOpenSolution']) ? $options['enableOpenSolution'] : 0) . ",\n\t\t\t\tenableParticipantCheck = " . (isset($options['enableParticipantCheck']) ? $options['enableParticipantCheck'] : 0) . ",\n\t\t\t\tenablePricechoice = " . (isset($options['enablePricechoice']) ? $options['enablePricechoice'] : 0) . ",\n\t\t\t\tpriceExpireSeconds = " . (isset($options['priceExpireSeconds']) ? $options['priceExpireSeconds'] : 0) . ",\n\t\t\t\tenableSponsorCheck = " . (isset($options['enableSponsorCheck']) ? $options['enableSponsorCheck'] : 0) . "\n\t\t\tWHERE\tcontestID = " . intval($this->contestID);
WCF::getDB()->sendQuery($sql);
// update attachments
if ($attachmentList != null) {
$attachmentList->findEmbeddedAttachments($message);
}
// update state
$this->updateState($state);
// update classes
$this->setClasses($classIDArray);
}
