コード例 #1
0
ファイル: Settings.php プロジェクト: rsids/bright_api
 /**
  * Creates or updates an array of custom setting<br/>
  * Required permissions:<br/>
  * <ul>
  * <li>IS_AUTH</li>
  * <li>MANAGE_SETTINGS</li>
  * </ul>
  * @param array $values An array of objects containing a name and a value string
  * @return array An array of custom settings
  * @throws \Exception
  */
 public function setSettings($values)
 {
     if (!$this->IS_AUTH) {
         throw $this->throwException(AuthenticationException::NO_USER_AUTH);
     }
     if (!$this->MANAGE_SETTINGS) {
         throw $this->throwException(3002);
     }
     foreach ($values as $val) {
         $oval = (object) $val;
         $this->setSetting($oval->name, $oval->value);
         unset($oval);
     }
     $cache = new Cache();
     $cache->flushCache();
     return $this->getSettings();
 }
コード例 #2
0
ファイル: UserGroup.php プロジェクト: rsids/bright_api
 /**
  * Removes a user from the given group
  * @since 1.5
  * @param int $userId the Id of the user
  * @param int $groupId the Id of the group
  * @return bool
  * @throws \Exception
  */
 public function removeUserFromGroup($userId, $groupId)
 {
     // No permissions required,
     // First we have to find a way to gracefully by-pass
     // the authentication system, to allow apps to manage
     // users.
     // 		if(!$this -> IS_AUTH)
     // 			throw $this -> throwException(Exceptions::NO_USER_AUTH);
     // 		if(!$this -> MANAGE_USER)
     // 			throw $this -> throwException(Exceptions::MISSING_PERMISSION_USER);
     if (!is_numeric($userId)) {
         throw $this->throwException(ParameterException::INTEGER_EXCEPTION);
     }
     if (!is_numeric($groupId)) {
         throw $this->throwException(ParameterException::INTEGER_EXCEPTION);
     }
     $c = new Cache();
     $c->deleteCacheByPrefix('user');
     $sql = "DELETE FROM `userusergroups` WHERE `groupId`={$groupId} AND `userId`={$userId}";
     $res = $this->_conn->deleteRow($sql) == 1;
     $uc = new User();
     $au = $uc->getAuthUser();
     // Update session if necessary
     if ($au->userId == $userId) {
         $user = $uc->getUser($userId);
         $_SESSION['user'] = serialize($user);
     }
     return $res;
 }
コード例 #3
0
ファイル: Calendar.php プロジェクト: rsids/bright_api
 /**
  * Creates or updates a calendar event
  * @param OCalendarEvent $event event The event to create or update
  * @param boolean $executeHook
  * @param boolean $updateContent When false, oContent is left untouched
  * @throws \Exception
  * @return bool
  */
 public function setEvent(OCalendarEvent $event, $executeHook = true, $updateContent = true)
 {
     $ch = null;
     if (!isset($event->dates) || count($event->dates) == 0) {
         throw $this->throwException(EventException::NOT_ENOUGH_DATES);
     }
     $c = new Cache();
     $c->deleteCacheByLabel("calendaritem_{$event->calendarId}");
     $c->deleteCacheByPrefix("eventsByIdRange_");
     $c->deleteCacheByPrefix('calendar_getEventsByRange');
     // Execute hook if present
     if (class_exists('CalendarHook') && $executeHook) {
         $ch = new \CalendarHook();
         if (method_exists($ch, 'preSetEvent')) {
             $event = $ch->preSetEvent($event);
         }
     }
     // Set modification values
     $aid = isset($_SESSION['administratorId']) ? $_SESSION['administratorId'] : 0;
     $event->createdby = $aid;
     $event->modifiedby = $aid;
     $event->label = $this->generateLabel($event->label, $event->calendarId);
     BrightUtils::forceInt($event, array('calendarId', 'itemType', 'createdby', 'locationId', 'modifiedby'));
     BrightUtils::escape($event, array('recur', 'label'));
     $event->enabled = $event->enabled === 1 || $event->enabled === true || $event->enabled === 'true' ? 1 : 0;
     $until = (double) $event->until;
     $event->until = date(BrightUtils::$SQLDateTime, $until);
     $sql = "INSERT INTO calendarnew (`calendarId`, `locationId`, `itemType`, `label`, `recur`, `until`, `enabled`, `deleted`, `creationdate`, `modificationdate`, `createdby`, `modifiedby`) VALUES (\n\t\t\t\t{$event->calendarId},\n\t\t\t\t{$event->locationId},\n\t\t\t\t{$event->itemType},\n\t\t\t\t'{$event->label}',\n\t\t\t\t'{$event->recur}',\n\t\t\t\t'{$event->until}',\n\t\t\t\t{$event->enabled},\n\t\t\t\tNULL, NOW(), NOW(),\n\t\t\t\t{$event->createdby},\n\t\t\t\t{$event->modifiedby})\n\t\t\t\tON DUPLICATE KEY UPDATE\n\t\t\t\titemType = VALUES(`itemType`),\n\t\t\t\tlocationId = VALUES(`locationId`),\n\t\t\t\tlabel = VALUES(`label`),\n\t\t\t\trecur = VALUES(`recur`),\n\t\t\t\tenabled = VALUES(`enabled`),\n\t\t\t\tuntil = VALUES(`until`),\n\t\t\t\tmodificationdate = NOW(),\n\t\t\t\tmodifiedby = VALUES(`modifiedby`),\n\t\t\t\t`calendarId`=LAST_INSERT_ID(`calendarId`)";
     $event->calendarId = $this->_conn->insertRow($sql);
     $sql = 'UPDATE `calendardates` SET `deleted`=1 WHERE `calendarId`=' . $event->calendarId;
     $this->_conn->updateRow($sql);
     $sql = 'INSERT INTO `calendardates` (`calendarId`,`starttime`, `endtime`,`allday`,`deleted`,`noend`) VALUES ';
     $sqla = array();
     // Store also for calendarevents
     $evdates = array();
     foreach ($event->dates as &$date) {
         $date = (object) $date;
         if ($date->endtime < $date->starttime) {
             // Quick fix, just add 1 day to the endtime
             // We could (or should) throw an exception here, since it's not a valid range...
             $date->endtime = strtotime('+1 day', $date->endtime);
         }
         $starttime = date(BrightUtils::$SQLDateTime, $date->starttime);
         $endtime = date(BrightUtils::$SQLDateTime, $date->endtime);
         $date->allday = $date->allday == true ? 1 : 0;
         $date->noend = $date->noend == true ? 1 : 0;
         $sqla[] = "({$event->calendarId}, '{$starttime}','{$endtime}', {$date->allday},0, {$date->noend})";
         $evdates[] = "({$event->calendarId}, '{$starttime}','{$endtime}', {$date->allday}, 0, {$date->noend})";
     }
     $sql .= implode(",\r\n", $sqla);
     $sql .= ' ON DUPLICATE KEY UPDATE `allday`=VALUES(`allday`),  `noend`=VALUES(`noend`), `deleted`=0';
     $this->_conn->insertRow($sql);
     $sql = "DELETE FROM calendardates WHERE deleted=1";
     $this->_conn->insertRow($sql);
     // Delete stored dates
     // 		$sql = 'DELETE FROM calendarevents WHERE eventId=' . (int) $event -> calendarId;
     // 		$this -> _conn -> deleteRow($sql);
     $sql = 'UPDATE calendareventsnew SET `deleted`=1 WHERE `calendarId`=' . (int) $event->calendarId;
     $this->_conn->updateRow($sql);
     $sql = 'INSERT INTO `calendareventsnew` (`calendarId`, `starttime`, `endtime`, `allday`, `deleted`,`noend`) VALUES ';
     $sqla = array();
     $earr = array();
     if ($event->recur && $event->recur != '') {
         $recur = $event->recur;
         // Recurring event, process it and add if needed
         $recarr = explode(';', $recur);
         $freq = '';
         $interval = 0;
         // If recur has trailing ;, pop last item
         if ($recarr[count($recarr) - 1] == '') {
             array_pop($recarr);
         }
         foreach ($recarr as $recitem) {
             $recitemarr = explode('=', $recitem);
             $key = $recitemarr[0];
             $val = $recitemarr[1];
             $dayarr = null;
             $monthrepeat = 'dom';
             switch ($key) {
                 case 'FREQ':
                     // Frequency, valid values are: DAILY, WEEKLY, MONTHLY, YEARLY
                     $freq = $val;
                     break;
                 case 'INTERVAL':
                     $interval = (int) $val;
                     break;
                 case 'BYDAY':
                     // Difference between monthly and weekly
                     switch ($freq) {
                         case 'WEEKLY':
                             $days = explode(',', $val);
                             $dayarr = array();
                             // Find out which days are checked
                             foreach ($days as $day) {
                                 switch ($day) {
                                     case 'SU':
                                         $dayarr[0] = 1;
                                         break;
                                     case 'MO':
                                         $dayarr[1] = 1;
                                         break;
                                     case 'TU':
                                         $dayarr[2] = 1;
                                         break;
                                     case 'WE':
                                         $dayarr[3] = 1;
                                         break;
                                     case 'TH':
                                         $dayarr[4] = 1;
                                         break;
                                     case 'FR':
                                         $dayarr[5] = 1;
                                         break;
                                     case 'SA':
                                         $dayarr[6] = 1;
                                         break;
                                 }
                             }
                             break;
                         case 'MONTHLY':
                             $monthrepeat = 'dow';
                             break;
                     }
                     break;
                 case 'BYMONTHDAY':
                     // Difference between monthly and yearly
                     /**
                      * @todo implement Is more implementation really needed, or is this switch just useless an could it be
                      * replaced with an if statement.
                      */
                     switch ($freq) {
                         case 'MONTHLY':
                             $monthrepeat = 'dom';
                             break;
                     }
                     break;
             }
         }
         // Add dates, if event recurs, calculate all dates
         $sqla[] = $evdates[0];
         $evstart = $event->dates[0]->starttime;
         $evend = $event->dates[0]->endtime;
         $startenddiff = $evend - $evstart;
         switch ($freq) {
             case 'DAILY':
                 // Easy!
                 while ($evstart < $until) {
                     $evstart += 86400 * $interval;
                     $evend += 86400 * $interval;
                     $ev = new \stdClass();
                     $ev->starttime = $evstart;
                     $ev->endtime = $evend;
                     $ev->calendarId = $event->calendarId;
                     $earr[] = $ev;
                 }
                 break;
             case 'WEEKLY':
                 // Get timestamp of the first day of the week
                 $fdow = date('w', $evstart);
                 $edow = date('w', $evend);
                 $startweek = mktime(date('H', $evstart), date('i', $evstart), date('s', $evstart), date('n', $evstart), date('j', $evstart) - $fdow, date('Y', $evstart));
                 $ddow = $edow - $fdow;
                 if ($ddow < 0) {
                     $ddow += 7;
                 }
                 $first = true;
                 while ($startweek < $until) {
                     // On the first week, skip the sunday, because,
                     // if the sunday is checked, it is already added before
                     $dow = $first ? $fdow + 1 : 0;
                     $first = false;
                     while ($dow < 7) {
                         if (array_key_exists($dow, $dayarr)) {
                             $ev = new \stdClass();
                             $ev->starttime = mktime(date('H', $evstart), date('i', $evstart), date('s', $evstart), date('n', $startweek), date('j', $startweek) + $dow, date('Y', $startweek));
                             // 								$edow = $dow + $ddow;
                             // 								if($edow < 0)
                             // 									$edow +=7;
                             $ev->endtime = mktime(date('H', $evend), date('i', $evend), date('s', $evend), date('n', $startweek), date('j', $startweek) + $dow + $ddow, date('Y', $startweek));
                             $ev->calendarId = $event->calendarId;
                             if ($ev->starttime < $until) {
                                 $earr[] = $ev;
                             }
                         }
                         $dow++;
                     }
                     $startweek += $interval * 604800;
                 }
                 // Now add 1 * $interval weeks and start with the first available day of dayarr
                 break;
             case 'MONTHLY':
                 if ($monthrepeat == 'dom') {
                     // Day Of Month
                     while ($evstart < $until) {
                         $evstart = mktime(date('H', $evstart), date('i', $evstart), date('s', $evstart), date('n', $evstart) + $interval, date('j', $evstart), date('Y', $evstart));
                         $evend = mktime(date('H', $evend), date('i', $evend), date('s', $evend), date('n', $evend) + $interval, date('j', $evend), date('Y', $evend));
                         $ev = new \stdClass();
                         $ev->starttime = $evstart;
                         $ev->endtime = $evend;
                         $ev->calendarId = $event->calendarId;
                         $earr[] = $ev;
                     }
                 } else {
                     // Day of Week
                     // Get the day of the week (sun - sat)
                     $dow = date('w', $evstart);
                     // Calculate how often that day has occured in the month (eg. the 2nd monday)
                     $nd = ceil(date('j', $evstart) / 7);
                     $mon = date('n', $evstart);
                     while ($evstart < $until) {
                         // Add the interval of months
                         $a = $evstart = strtotime("+{$interval} month", $evstart);
                         // Check the 'new' day of the week
                         $newdow = date('w', $evstart);
                         $delta = $dow - $newdow;
                         if ($delta < 0) {
                             $delta += 7;
                         }
                         // And correct it to the old dow
                         $evstart += $delta * 86400;
                         // We've accidently moved to the next month, correct date
                         // by removing 1 week;
                         if (date('m', $evstart) > date('m', $a)) {
                             $evstart -= 7 * 86400;
                         }
                         // Check how often that day has occured
                         $newnd = ceil(date('j', $evstart) / 7);
                         // And correct it to the original occurence
                         while ($newnd < $nd) {
                             $evstart += 604800;
                             $newnd++;
                         }
                         while ($newnd > $nd) {
                             $evstart -= 604800;
                             $newnd--;
                         }
                         $evend = $evstart + $startenddiff;
                         $ev = new \stdClass();
                         $ev->starttime = $evstart;
                         $ev->endtime = $evend;
                         $ev->calendarId = $event->calendarId;
                         $earr[] = $ev;
                     }
                 }
                 break;
             case 'YEARLY':
                 while ($evstart < $until) {
                     $evstart = mktime(date('H', $evstart), date('i', $evstart), date('s', $evstart), date('n', $evstart), date('j', $evstart), date('Y', $evstart) + $interval);
                     $evend = mktime(date('H', $evend), date('i', $evend), date('s', $evend), date('n', $evend), date('j', $evend), date('Y', $evend) + $interval);
                     $ev = new \stdClass();
                     $ev->starttime = $evstart;
                     $ev->endtime = $evend;
                     $ev->calendarId = $event->calendarId;
                     $earr[] = $ev;
                 }
                 break;
         }
         $ad = $event->dates[0]->allday;
         $ne = $event->dates[0]->noend;
         foreach ($earr as $ev) {
             if ($ev->endtime < $ev->starttime) {
                 // Quick fix, just add 1 day to the endtime
                 $ev->endtime = strtotime('+1 day', $ev->endtime);
             }
             $sqla[] = "({$event->calendarId},\n\t\t\t\t\t\t\t'" . date(BrightUtils::$SQLDateTime, $ev->starttime) . "',\n\t\t\t\t\t\t\t'" . date(BrightUtils::$SQLDateTime, $ev->endtime) . "',\n\t\t\t\t\t\t\t{$ad},\n\t\t\t\t\t\t\t0,\n\t\t\t\t\t\t\t{$ne})";
         }
     } else {
         $sqla = $evdates;
     }
     // Add dates to db
     $sql .= join(',', $sqla);
     $sql .= ' ON DUPLICATE KEY UPDATE starttime=VALUES(starttime), endtime=VALUES(endtime), `deleted`=0, allday=VALUES(`allday`), noend=VALUES(`noend`)';
     $this->_conn->insertRow($sql);
     $sql = 'DELETE FROM calendareventsnew WHERE `deleted`=1 AND `calendarId`=' . (int) $event->calendarId;
     $this->_conn->deleteRow($sql);
     if ($updateContent) {
         $this->setContent($event, 'calendarcontent');
         $search = BrightUtils::createSearchString($event);
         if ((int) $event->locationId > 0) {
             $search .= $this->conn->getField("SELECT search FROM gm_markers WHERE pageId={$event->locationId}");
         }
         $search = Connection::getInstance()->escape_string($search);
         $sql = "INSERT INTO calendarindex (calendarId, search) VALUES ({$event->calendarId}, '{$search}') ON DUPLICATE KEY UPDATE search='{$search}' ";
         $this->_conn->insertRow($sql);
     }
     if (isset($ch) && method_exists($ch, 'postSetEvent')) {
         $ch->postSetEvent($event);
     }
     return true;
 }
コード例 #4
0
ファイル: Maps.php プロジェクト: rsids/bright_api
 private function _getMarker($id, $full, $enabledOnly, $byPage = false)
 {
     $id = (int) $id;
     $cname = 'marker_' . $id;
     $cname .= $full ? 1 : 0;
     $cname .= $enabledOnly ? 1 : 0;
     $cname .= $byPage ? 1 : 0;
     $cache = new Cache();
     $result = $cache->getCache($cname);
     if ($result) {
         return $result;
     }
     $esql = $enabledOnly ? ' AND `enabled`=1' : '';
     if ($byPage) {
         $sql = "SELECT * FROM `gm_markers` WHERE `deleted`=0 {$esql} AND pageId={$id}";
     } else {
         $sql = "SELECT * FROM `gm_markers` WHERE `deleted`=0 {$esql} AND markerId={$id}";
     }
     $marker = $this->_conn->getRow($sql, 'OMarker');
     if (!$marker) {
         return null;
     }
     if (!$full) {
         $cache->setCache($marker, $cname, strtotime('+1 year'));
         return $marker;
     }
     $page = new Page();
     $contents = $page->getPageById($marker->pageId, false, false);
     if ($contents) {
         foreach ($contents as $key => $value) {
             $marker->{$key} = $value;
         }
         $marker->_explicitType = 'OMarker';
     }
     $cache->setCache($marker, $cname, strtotime('+1 year'));
     return $marker;
 }
コード例 #5
0
ファイル: Page.php プロジェクト: rsids/bright_api
 /**
  * Updates a page
  * @param OPage page The page to update
  * @return OPage The updated page
  */
 private function _updatePage($page)
 {
     $ap = $page->alwayspublished ? 1 : 0;
     $sn = $page->showinnavigation ? 1 : 0;
     $cachebleChanged = $this->_cachebleChanged($page);
     $page->label = Connection::getInstance()->escape_string($this->generateLabel($page->label, $page->pageId));
     $page->modifiedby = isset($_SESSION['administratorId']) ? $_SESSION['administratorId'] : 0;
     BrightUtils::forceInt($page, array('publicationdate', 'expirationdate', 'itemType', 'pageId'));
     $sql = "UPDATE page \n\t\t\t\tSET label='{$page->label}',\n\t\t\t\titemType='{$page->itemType}', \n\t\t\t\tpublicationdate=FROM_UNIXTIME({$page->publicationdate}),\n\t\t\t\texpirationdate=FROM_UNIXTIME({$page->expirationdate}), \n\t\t\t\talwayspublished={$ap},\n\t\t\t\tshowinnavigation={$sn},\n\t\t\t\tmodificationdate=NOW(),\n\t\t\t\tmodifiedby={$page->modifiedby}\n\t\t\t\tWHERE pageId={$page->pageId}";
     $this->conn->updateRow($sql);
     $this->setContent($page);
     if ($cachebleChanged) {
         // Flush cache
         $cache = new Cache();
         $cache->flushCache();
         $tree = new Tree();
         $tree->generateSitemap();
     }
     return $this->getPageById($page->pageId, true);
 }
コード例 #6
0
ファイル: Tree.php プロジェクト: rsids/bright_api
 /**
  * Moves an existing page in the tree<br/>
  * Required permissions:<br/>
  * <ul>
  * <li>IS_AUTH</li>
  * </ul>
  * @param int $treeId The id of the page to move
  * @param int $oldParentId The id of the current parent
  * @param int $newParentId The id of the new parent
  * @param int $oldIndex The old index
  * @param int $newIndex The new index
  * @return array The children of the new parent
  * @throws \Exception
  */
 public function movePage($treeId, $oldParentId, $newParentId, $oldIndex, $newIndex)
 {
     if (!$this->IS_AUTH) {
         throw $this->throwException(AuthenticationException::NO_USER_AUTH);
     }
     if (!is_numeric($treeId) || !is_numeric($oldParentId) || !is_numeric($newParentId) || !is_numeric($oldIndex) || !is_numeric($newIndex)) {
         throw $this->throwException(ParameterException::INTEGER_EXCEPTION);
     }
     // Check if the number of children doesn't exceed the maximum
     if ((int) $oldParentId != (int) $newParentId) {
         $sql = 'SELECT `maxchildren`, (SELECT COUNT(nct.`treeId`) ' . 'FROM `tree` nct ' . 'WHERE nct.parentId=' . $newParentId . ') ' . 'AS numchildren  ' . 'FROM `itemtypes` ' . 'WHERE `itemId`=(SELECT `itemType` ' . 'FROM `page` p ' . 'WHERE p.`pageId`=(SELECT t.`pageId` ' . 'FROM `tree` t ' . 'WHERE `treeId`=' . $newParentId . '))';
         $ncResult = $this->_conn->getRow($sql);
         if ((double) $ncResult->numchildren >= (double) $ncResult->maxchildren && (double) $ncResult->maxchildren > -1) {
             throw $this->throwException(6001, array($ncResult->maxchildren));
         }
     }
     $retObj = new \stdClass();
     $cache = new Cache();
     // Check if the page exists in the new parent,
     //only if the newparent is actually another parent
     if ((int) $oldParentId != (int) $newParentId) {
         $sql = 'SELECT pageId FROM tree WHERE treeId = ' . $treeId;
         $page = $this->_conn->getRow($sql);
         if ($this->_checkForPageExistance($page->pageId, $newParentId)) {
             $retObj->oldParent = $this->getChildren($oldParentId);
             $retObj->newParent = $this->getChildren($newParentId);
             $cache->flushCache();
             return $retObj;
         }
     }
     $this->_cleanIndexes($oldParentId);
     $this->_cleanIndexes($newParentId);
     $this->_updateIndexes($oldIndex, -1, $oldParentId);
     $this->_updateIndexes($newIndex, 1, $newParentId);
     $sql = 'UPDATE tree ' . 'SET `parentId`=' . $newParentId . ', ' . '`index`=' . $newIndex . ' ' . 'WHERE `treeId`=' . $treeId;
     $this->_conn->updateRow($sql);
     $cache->flushCache();
     $this->generateSitemap();
     $retObj->oldParent = $this->getChildren($oldParentId);
     $retObj->newParent = $this->getChildren($newParentId);
     return $retObj;
 }
コード例 #7
0
ファイル: Element.php プロジェクト: rsids/bright_api
 /**
  * Saves a element
  * @param OPage $element The element to save
  * @param bool $returnall
  * @return \stdClass An object containing element, the just saved element and elements, an array of all elements
  * @throws \Exception
  */
 public function setElement($element, $returnall = true)
 {
     if (!$this->IS_AUTH) {
         throw $this->throwException(AuthenticationException::NO_USER_AUTH);
     }
     if (method_exists($this->_hook, 'preSetElement')) {
         $element = $this->_hook->preSetElement($element);
     }
     $element = $this->_page->setPage($element, false, false);
     if (method_exists($this->_hook, 'postSetElement')) {
         $this->_hook->postSetElement($element);
     }
     $c = new Cache();
     $c->deleteCacheByPrefix("element_filter_");
     $search = BrightUtils::createSearchString($element);
     $search = Connection::getInstance()->escape_string($search);
     $sql = "INSERT INTO pageindex (pageId, search) VALUES ({$element->pageId}, '{$search}') ON DUPLICATE KEY UPDATE search='{$search}' ";
     Connection::getInstance()->insertRow($sql);
     if (!$returnall) {
         return $element;
     }
     return $this->_page->getPages(4, null, true);
 }
コード例 #8
0
ファイル: User.php プロジェクト: rsids/bright_api
 /**
  * Deletes a user by it's e-mail and it's activationcode
  * @param string $email The e-mail address of the user
  * @param string $activationCode The activation code of the user
  * @since 2.2 - 28 dec 2010
  * @return boolean True when successful
  */
 public function deactivate($email, $activationCode)
 {
     $c = new Cache();
     $c->deleteCacheByPrefix('user');
     $sql = 'UPDATE user ' . 'SET deleted=NOW() ' . "WHERE activationcode='" . Connection::getInstance()->escape_string($activationCode) . "' " . "AND email='" . Connection::getInstance()->escape_string($email) . "'";
     return $this->conn->updateRow($sql);
 }
コード例 #9
0
ファイル: Content.php プロジェクト: rsids/bright_api
 /**
  * Inserts content into the database
  * @param OPage $page
  * @param string $table
  * @return int
  * @throws ParameterException
  */
 protected function setContent($page, $table = 'content')
 {
     $pid = 'pageId';
     switch ($table) {
         case 'content':
             $pid = 'pageId';
             break;
         case 'userfields':
             $pid = 'userId';
             break;
         case 'calendarcontent':
             $pid = 'calendarId';
             break;
     }
     $id = (int) $page->{$pid};
     $table = Connection::getInstance()->escape_string($table);
     $b = new Backup();
     $b->setBackup($page, $table);
     if (!isset($page->content) || $page->content == null) {
         throw new ParameterException(ParameterException::OBJECT_EXCEPTION);
     }
     $sql = "UPDATE `{$table}` SET `deleted`=1 WHERE `{$pid}`={$id}";
     $this->conn->updateRow($sql);
     $it = new Template();
     $def = $it->getTemplateDefinition($page->itemType, true);
     $def->title = new \stdClass();
     $def->title->contenttype = 'string';
     $def->title->searchable = 1;
     $sql = "INSERT INTO `{$table}` (`{$pid}`, `lang`, `field`, `value`,`index`,`searchable`) VALUES ";
     $sqla = array();
     foreach ($page->content as $field => $langs) {
         $searchable = 0;
         if ($field == 'title') {
             $searchable = 1;
             if ($table == 'content' && $this->_titleChanged($langs, $page->{$pid})) {
                 $cache = new Cache();
                 $cache->flushCache();
             }
         } else {
             $searchable = isset($def->{$field}) && $def->{$field}->searchable ? 1 : 0;
         }
         foreach ($langs as $lang => $val) {
             // 20130725 Fix for unknown fields
             $contenttype = isset($def->{$field}) && isset($def->{$field}->contenttype) ? $def->{$field}->contenttype : 'string';
             switch ($contenttype) {
                 case 'array':
                     $index = 0;
                     if (!is_array($val)) {
                         $val = array($val);
                     }
                     foreach ($val as $listval) {
                         $lang = BrightUtils::escapeSingle($lang);
                         $field = BrightUtils::escapeSingle($field);
                         if (!is_string($listval)) {
                             //throw $this -> throwException(Exceptions::INCORRECT_PARAM_STRING, '$listval: ' . print_r($listval, true));
                             $listval = json_encode($listval);
                         }
                         $listval = BrightUtils::escapeHtml($listval);
                         $sqlid = $page->{$pid};
                         $sqla[] = "({$sqlid},\n\t\t\t\t\t\t\t\t\t\t'{$lang}',\n\t\t\t\t\t\t\t\t\t\t'{$field}',\n\t\t\t\t\t\t\t\t\t\t'{$listval}', {$index}, {$searchable}) ";
                         $index++;
                     }
                     break;
                 default:
                     $lang = BrightUtils::escapeSingle($lang);
                     $field = BrightUtils::escapeSingle($field);
                     if ($val !== null && $val !== false && !is_scalar($val)) {
                         $val = json_encode($val);
                         if ($val == '{}') {
                             $val = '';
                         }
                         //throw $this -> throwException(Exceptions::INCORRECT_PARAM_STRING, 'val: ' . print_r($val, true));
                     }
                     $val = BrightUtils::escapeHtml($val);
                     if ($val != '') {
                         $sqlid = $page->{$pid};
                         $sqla[] = "({$sqlid},\n\t\t\t\t\t\t\t\t\t\t'{$lang}',\n\t\t\t\t\t\t\t\t\t\t'{$field}',\n\t\t\t\t\t\t\t\t\t\t'{$val}', 0, {$searchable}) ";
                     }
             }
         }
     }
     if (count($sqla) > 0) {
         $sql .= implode(", \r\n", $sqla);
         $sql .= " ON DUPLICATE KEY UPDATE `value`=VALUES(`value`), `deleted`=0";
         $result = $this->conn->insertRow($sql);
     } else {
         // Delete old content? uncomment line
         // $result = 1;
     }
     if ($result !== false && $result > 0) {
         // All is well, clean up old data
         $sql = "DELETE FROM `{$table}` WHERE `deleted`= 1 AND  `{$pid}`={$id}";
         $this->conn->deleteRow($sql);
     }
     return $result;
 }