The 13 parameter function
Posted: Sat Jul 29, 2006 6:40 am
Just wanted to share that with you all.
What do you think?
What do you think?
Code: Select all
/**
* Create a new site with a video (yes there are 13 parameters)
*
* @param string $title
* @param int $clientId
* @param int|null $subclientId
* @param bool $useQuestionnaire
* @param string|null $feedbackRequest
* @param string|null $stream
* @param string|null $download
* @param string|null $questionnaireStart
* @param string|null $questionnaireEnd
* @param string|null $hqVideoUrl
* @param string|null $lqVideoUrl
* @param int $widthDim
* @param int $heightDim
*
* @return int the insert_id of the newly created site
*/
public function _createSiteWithVideo($title, $clientId, $subclientId, $useQuestionnaire, $feedbackRequest,
$stream, $download, $questionnaireStart, $questionnaireEnd,
$hqVideoUrl, $lqVideoUrl, $widthDim, $heightDim)
{
$this->begin();
if ($feedbackRequest === null and $stream === null and $download === null
and $questionnaireStart === null and $questionnaireEnd === null) {
$msgSetId = 1; // all null is already reserved under 1
} else {
$q =
"INSERT INTO MsgSet (feedbackRequest, stream, download,
questionnaireStart, questionnaireEnd)
VALUES ('$feedbackRequest', '$stream', '$download',
'$quesionnaireStart', '$questionnaireEnd')";
$this->exec($q, __FUNCTION__, true);
$msgSetId = $this->_db->insert_id;
}
$useQuestionnaire = (int)$useQuestionnaire;
$q =
"INSERT INTO Site (title, _clientId, _subClientId, _msgSetId,
useQuestionnaire, useVideo, hqVideoUrl,
lqVideoUrl, widthDim, heightDim)
VALUES ('$title', $clientId, $subclientId, $msgSetId,
$useQuestionnaire, 1, $widthDim, $heightDim)";
$this->exec($q, __FUNCTION__, true);
$siteId = $this->_db->insert_id;
$this->commit();
return $siteId;
}