/** * 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); }