protected function _assignValues(&$iaView, array &$entryData)
{
if (isset($entryData['data'])) {
$entryData['data'] = unserialize($entryData['data']);
empty($entryData['data']['fields']) || ($entryData['data']['fields'] = array_reverse($entryData['data']['fields']));
} else {
$entryData['data'] = array();
}
// populating titles & descriptions
if (empty($_POST['title'])) {
$this->_iaDb->setTable(iaLanguage::getTable());
$stmt = "`key` = 'plan_title_" . $this->getEntryId() . "'";
$entryData['title'] = $this->_iaDb->keyvalue(array('code', 'value'), $stmt);
$stmt = "`key` = 'plan_description_" . $this->getEntryId() . "'";
$entryData['description'] = $this->_iaDb->keyvalue(array('code', 'value'), $stmt);
$this->_iaDb->resetTable();
} else {
list($entryData['title'], $entryData['description']) = array($_POST['title'], $_POST['description']);
}
//
$units = $this->_iaDb->getEnumValues($this->getTable(), 'unit');
$units = $units ? array_values($units['values']) : array();
$usergroups = $this->_iaCore->factory('users')->getUsergroups();
unset($usergroups[iaUsers::MEMBERSHIP_ADMINISTRATOR], $usergroups[iaUsers::MEMBERSHIP_GUEST]);
$iaView->assign('usergroups', $usergroups);
$iaView->assign('fields', $this->_fields);
$iaView->assign('items', $this->_items);
$iaView->assign('expiration_statuses', $this->_getItemsStatuses());
$iaView->assign('units', $units);
}
private function _getPages()
{
$sql = 'SELECT DISTINCTROW p.*, IF(t.`value` is null, p.`name`, t.`value`) `title` ' . 'FROM `:prefixpages` p ' . 'LEFT JOIN `:prefix:table_language` t ' . "ON (`key` = CONCAT('page_title_', p.`name`) AND t.`code` = ':language') " . "WHERE p.`status` = ':status' AND p.`service` = 0 " . 'ORDER BY t.`value`';
$sql = iaDb::printf($sql, array('prefix' => $this->_iaDb->prefix, 'table_language' => iaLanguage::getTable(), 'language' => $this->_iaCore->iaView->language, 'status' => iaCore::STATUS_ACTIVE));
return $this->_iaDb->getAll($sql);
}
public function delete($id, $log = true)
{
$iaDb =& $this->iaDb;
$row = $iaDb->row(iaDb::ALL_COLUMNS_SELECTION, iaDb::convertIds($id));
$title = self::LANG_PATTERN_TITLE . $id;
$title = iaLanguage::exists($title) ? iaLanguage::get($title) : $row['title'];
$this->iaCore->startHook('beforeBlockDelete', array('block' => &$row));
$result = parent::delete($id);
if ($result) {
$iaDb->delete('`object_type` = :object && `object` = :id', self::getPagesTable(), array('id' => $id, 'object' => 'blocks'));
$iaDb->delete('`key` = :title OR `key` = :content', iaLanguage::getTable(), array('title' => self::LANG_PATTERN_TITLE . $id, 'content' => self::LANG_PATTERN_CONTENT . $id));
if ($log) {
$this->iaCore->factory('log')->write(iaLog::ACTION_DELETE, array('item' => 'block', 'name' => $title, 'id' => $id));
}
}
$this->iaCore->startHook('afterBlockDelete', array('block' => &$row));
return $result;
}
protected function _searchByPages()
{
$iaCore =& $this->iaCore;
$iaDb =& $this->iaDb;
$iaPage = $iaCore->factory('page', iaCore::FRONT);
$stmt = '`value` LIKE :query AND `category` = :category AND `code` = :language ORDER BY `key`';
$iaDb->bind($stmt, array('query' => '%' . iaSanitize::sql($this->_query) . '%', 'category' => iaLanguage::CATEGORY_PAGE, 'language' => $iaCore->iaView->language));
$result = array();
if ($rows = $iaDb->all(array('key', 'value'), $stmt, null, null, iaLanguage::getTable())) {
foreach ($rows as $row) {
$pageName = str_replace(array('page_title_', 'page_content_'), '', $row['key']);
$key = false === stripos($row['key'], 'page_content_') ? 'title' : 'content';
$value = iaSanitize::tags($row['value']);
isset($result[$pageName]) || ($result[$pageName] = array());
if ('content' == $key) {
$value = $this->_extractSnippet($value);
if (empty($result[$pageName]['title'])) {
$result[$pageName]['title'] = iaLanguage::get('page_title_' . $pageName);
}
}
$result[$pageName]['url'] = $iaPage->getUrlByName($pageName, false);
$result[$pageName][$key] = $value;
}
}
// blocks content will be printed out as a pages content
if ($blocks = $this->_searchByBlocks()) {
foreach ($blocks as $pageName => $blocksData) {
if (isset($result[$pageName])) {
$result[$pageName]['extraItems'] = $blocksData;
} else {
$result[$pageName] = array('url' => $iaPage->getUrlByName($pageName), 'title' => iaLanguage::get('page_title_' . $pageName), 'content' => '', 'extraItems' => $blocksData);
}
}
}
$count = count($result);
$html = $this->_render('search-list-pages' . iaView::TEMPLATE_FILENAME_EXT, array('pages' => $result));
return array($count, $html);
}
public function install()
{
$iaDb =& $this->iaDb;
$this->iaCore->startHook('phpExtrasInstallBefore', array('extra' => $this->itemData['name']));
$extrasList = array();
$array = $iaDb->all(array('id', 'name', 'version'), "`status` = 'active'", null, null, self::getTable());
foreach ($array as $item) {
$extrasList[$item['name']] = $item;
}
// TODO: check for relations and deactivate all needed extras
if ($this->itemData['requirements']) {
$messages = array();
foreach ($this->itemData['requirements'] as $requirement) {
if ($requirement['min'] || $requirement['max']) {
$min = $max = false;
if (isset($extrasList[$requirement['name']])) {
$info = $extrasList[$requirement['name']];
$min = $requirement['min'] ? version_compare($requirement['min'], $info['version'], '<=') : true;
$max = $requirement['max'] ? version_compare($requirement['max'], $info['version'], '>=') : true;
}
if (!$max || !$min) {
$ver = '';
if ($requirement['min']) {
$ver .= $requirement['min'];
}
if ($requirement['max']) {
if ($requirement['min']) {
$ver .= '-';
}
$ver .= $requirement['max'];
}
$values = array(':extra' => $requirement['type'], ':name' => $requirement['name'], ':version' => $ver);
$messages[] = iaLanguage::getf('required_extras_error', $values);
$this->error = true;
} else {
// TODO: add relations in database to deactivate when parent is uninstalled
}
}
}
if ($this->error) {
$this->setMessage(implode('<br />', $messages));
return false;
}
}
$this->uninstall($this->itemData['name']);
if (false !== stristr('update', $this->itemData['name'])) {
$this->isUpdate = true;
}
if ($this->itemData['groups']) {
$iaDb->setTable('admin_pages_groups');
$maxOrder = $iaDb->getMaxOrder();
foreach ($this->itemData['groups'] as $block) {
$iaDb->insert($block, array('order' => ++$maxOrder));
}
$iaDb->resetTable();
}
if ($this->itemData['pages']['admin']) {
$iaDb->setTable('admin_pages');
$order = (int) $iaDb->one('MAX(`order`)', "`menus` IN ('menu')");
$order = max($order, 1);
foreach ($this->itemData['pages']['admin'] as $page) {
if (is_null($page['order'])) {
$order += 5;
$page['order'] = $order;
}
if ($page['group']) {
$this->_menuGroups[] = $page['group'];
}
$page['group'] = $this->_lookupGroupId($page['group']);
$iaDb->insert($page);
}
$iaDb->resetTable();
}
if ($this->itemData['actions']) {
$iaDb->setTable('admin_actions');
foreach ($this->itemData['actions'] as $action) {
$action['name'] = strtolower(str_replace(' ', '_', $action['name']));
if ($action['name'] && !$iaDb->exists('`name` = :name', array('name' => $action['name']))) {
$action['order'] = empty($action['order']) || !is_numeric($action['order']) ? $iaDb->getMaxOrder() + 1 : $action['order'];
$iaDb->insert($action);
}
}
$iaDb->resetTable();
}
if ($this->itemData['phrases']) {
$this->_processPhrases($this->itemData['phrases']);
}
if ($this->itemData['config_groups']) {
$iaDb->setTable(iaCore::getConfigGroupsTable());
$maxOrder = $iaDb->getMaxOrder();
foreach ($this->itemData['config_groups'] as $config) {
$iaDb->insert($config, array('order' => ++$maxOrder));
}
$iaDb->resetTable();
}
if ($this->itemData['objects']) {
$iaDb->setTable('acl_objects');
foreach ($this->itemData['objects'] as $obj) {
if ($obj['title']) {
$key = ($obj['object'] == $obj['pre_object'] ? '' : $obj['pre_object'] . '-') . $obj['object'] . '--' . $obj['action'];
iaLanguage::addPhrase($key, $obj['title'], null, $this->itemData['name'], iaLanguage::CATEGORY_COMMON, false);
unset($obj['title']);
}
$iaDb->insert($obj);
}
$iaDb->resetTable();
}
if ($this->itemData['permissions']) {
$iaDb->setTable('acl_privileges');
foreach ($this->itemData['permissions'] as $permission) {
$iaDb->insert($permission);
}
$iaDb->resetTable();
}
if ($this->itemData['config']) {
$iaDb->setTable('config');
$maxOrder = $iaDb->getMaxOrder();
foreach ($this->itemData['config'] as $config) {
$iaDb->insert($config, array('order' => ++$maxOrder));
}
$iaDb->resetTable();
}
if ($this->itemData['pages']['custom'] && $this->itemData['type'] == self::TYPE_PACKAGE) {
$iaDb->setTable('items_pages');
foreach ($this->itemData['pages']['custom'] as $page) {
$iaDb->insert(array('page_name' => $page['name'], 'item' => $page['item']));
}
$iaDb->resetTable();
}
$iaBlock = $this->iaCore->factory('block', iaCore::ADMIN);
$extraPages = array();
if ($this->itemData['pages']['front']) {
$pageGroups = $iaDb->keyvalue(array('name', 'id'), null, 'admin_pages_groups');
$iaDb->setTable('pages');
$maxOrder = $iaDb->getMaxOrder();
$existPages = $iaDb->keyvalue(array('name', 'id'));
foreach ($this->itemData['pages']['front'] as $page) {
if (!isset($existPages[$page['name']])) {
if (self::TYPE_PACKAGE == $this->itemData['type'] && $page['fields_item']) {
$iaDb->insert(array('page_name' => $page['name'], 'item' => $page['fields_item']), null, 'items_pages');
}
$title = isset($page['title']) && $page['title'] ? $page['title'] : false;
$blocks = isset($page['blocks']) && $page['blocks'] ? $page['blocks'] : false;
$menus = isset($page['menus']) && $page['menus'] ? explode(',', $page['menus']) : array();
$contents = isset($page['contents']) && $page['contents'] ? $page['contents'] : false;
unset($page['title'], $page['blocks'], $page['menus'], $page['contents']);
$page['group'] = $pageGroups[$page['group']];
$pageId = $iaDb->insert($page, array('order' => ++$maxOrder, 'last_updated' => iaDb::FUNCTION_NOW));
empty($title) || $this->_addPhrase('page_title_' . $page['name'], $title, iaLanguage::CATEGORY_PAGE);
// TODO: should be handled by iaBlock
if ($blocks) {
$blocks = $iaDb->keyvalue(array('name', 'id'), "`name` IN ('" . implode("','", $blocks) . "')", iaBlock::getTable(), 0, 1);
foreach ($blocks as $blockId) {
$iaDb->insert(array('object_type' => 'blocks', 'object' => $blockId, 'page_name' => $page['name']), null, 'objects_pages');
}
}
if (!is_int($page['group'])) {
$page['group'] = $this->_lookupGroupId($page['group']);
}
if ($menus) {
$iaDb->setTable(iaBlock::getTable());
$added = array();
$items = array();
$menusData = $iaDb->keyvalue(array('id', 'name'), "`type` = 'menu'");
$db = false;
foreach ($menusData as $id => $name) {
if (in_array($name, $menus)) {
$added[] = $name;
$items[] = array('parent_id' => 0, 'menu_id' => $id, 'el_id' => $pageId . '_' . iaUtil::generateToken(4), 'level' => 0, 'page_name' => $page['name']);
$db = true;
$this->iaCore->iaCache->remove('menu_' . $id . '.inc');
}
}
if ($db) {
$iaDb->insert($items, null, iaBlock::getMenusTable());
}
foreach ($menus as $val) {
if (!in_array($val, $added)) {
$menuItem = array('type' => iaBlock::TYPE_MENU, 'status' => iaCore::STATUS_ACTIVE, 'position' => 'left', 'collapsible' => true, 'title' => $this->itemData['info']['title'], 'extras' => $this->itemData['name'], 'name' => $this->itemData['name'], 'sticky' => true, 'removable' => false);
$menuItem['id'] = $iaBlock->insert($menuItem);
$contents = array('parent_id' => 0, 'menu_id' => $menuItem['id'], 'el_id' => $pageId . '_' . iaUtil::generateToken(5), 'level' => 0, 'page_name' => $page['name']);
$iaDb->insert($contents, null, iaBlock::getMenusTable());
}
}
$iaDb->resetTable();
}
empty($contents) || $this->_addPhrase('page_content_' . $page['name'], $contents, iaLanguage::CATEGORY_PAGE);
$extraPages[] = $page['name'];
}
}
$iaDb->resetTable();
}
if ($this->itemData['blocks']) {
$iaBlock = $this->iaCore->factory('block', iaCore::ADMIN);
foreach ($this->itemData['blocks'] as $block) {
$iaBlock->insert($block);
}
}
if ($this->itemData['hooks']) {
$iaDb->setTable('hooks');
$maxOrder = $iaDb->getMaxOrder();
foreach ($this->itemData['hooks'] as $hook) {
$array = explode(',', $hook['name']);
foreach ($array as $hookName) {
if (trim($hookName)) {
$hook['name'] = $hookName;
if (isset($hook['code']) && $hook['code']) {
$hook['code'] = str_replace('{extras}', $this->itemData['name'], $hook['code']);
}
$rawValues = array();
if (!isset($hook['order'])) {
$rawValues['order'] = ++$maxOrder;
}
$iaDb->insert($hook, $rawValues);
}
}
}
$iaDb->resetTable();
}
if ($this->itemData['usergroups']) {
$this->iaCore->factory('acl');
$iaDb->setTable(iaUsers::getUsergroupsTable());
foreach ($this->itemData['usergroups'] as $item) {
if (!$iaDb->exists('`name` = :name', array('name' => $item['name']))) {
$configs = $item['configs'];
$permissions = $item['permissions'];
$groupId = $iaDb->insert(array('extras' => $item['extras'], 'name' => $item['name'], 'system' => true, 'assignable' => $item['assignable'], 'visible' => $item['visible']));
// update language records
$this->_addPhrase('usergroup_' . $item['name'], $item['title']);
$iaDb->setTable(iaCore::getCustomConfigTable());
$iaDb->delete('`type` = :type AND `type_id` = :id', null, array('type' => iaAcl::GROUP, 'id' => $groupId));
foreach ($configs as $config) {
$data = array('name' => $config['name'], 'value' => $config['value'], 'type' => iaAcl::GROUP, 'type_id' => $groupId, 'extras' => $this->itemData['name']);
$iaDb->insert($data);
}
$iaDb->resetTable();
$iaDb->setTable('acl_privileges');
$iaDb->delete('`type` = :type AND `type_id` = :id', null, array('type' => iaAcl::GROUP, 'id' => $groupId));
foreach ($permissions as $permission) {
$data = array('object' => $permission['object'], 'object_id' => $permission['object_id'], 'action' => $permission['action'], 'access' => $permission['access'], 'type' => iaAcl::GROUP, 'type_id' => $groupId, 'extras' => $permission['extras']);
$iaDb->insert($data);
}
$iaDb->resetTable();
}
}
$iaDb->resetTable();
}
$extraEntry = array_merge($this->itemData['info'], array('name' => $this->itemData['name'], 'type' => $this->itemData['type']));
unset($extraEntry['date']);
if ($this->itemData['sql']['uninstall']) {
$extraEntry['uninstall_sql'] = serialize($this->itemData['sql']['uninstall']);
}
if ($this->itemData['code']['uninstall']) {
$extraEntry['uninstall_code'] = $this->itemData['code']['uninstall'];
}
if ($this->itemData['sql']['install']) {
$this->_processQueries($this->itemData['sql']['install']);
}
if (self::TYPE_PACKAGE == $this->itemData['type']) {
$extraEntry['url'] = $this->_url;
}
if ($this->itemData['items']) {
$extraEntry['items'] = serialize($this->itemData['items']);
$iaDb->setTable('items');
foreach ($this->itemData['items'] as $item) {
$iaDb->insert(array_merge($item, array('package' => $this->itemData['name'])));
}
$iaDb->resetTable();
}
$this->iaCore->factory('field');
$fieldGroups = $iaDb->keyvalue('CONCAT(`item`, `name`) `key`, `id`', null, iaField::getTableGroups());
if ($this->itemData['item_field_groups']) {
$maxOrder = $iaDb->getMaxOrder(iaField::getTableGroups());
foreach ($this->itemData['item_field_groups'] as $item) {
$item['order'] || ($item['order'] = ++$maxOrder);
if ($item['title'] && !$iaDb->exists("`key` = 'fieldgroup_{$item['name']}' AND `code`='" . $this->iaView->language . "'", null, iaLanguage::getTable())) {
$this->_addPhrase('fieldgroup_' . $item['name'], $item['title']);
}
unset($item['title']);
$description = 'fieldgroup_description_' . $item['item'] . '_' . $item['name'];
if (!$iaDb->exists('`key` = :key AND `code` = :language', array('key' => $description, 'language' => $this->iaView->language), iaLanguage::getTable())) {
// insert fieldgroup description
iaLanguage::addPhrase($description, $item['description'], null, $this->itemData['name'], iaLanguage::CATEGORY_COMMON, false);
}
unset($item['description']);
$fieldGroups[$item['item'] . $item['name']] = $iaDb->insert($item, null, iaField::getTableGroups());
}
}
if ($this->itemData['item_fields']) {
$iaDb->setTable(iaField::getTable());
$maxOrder = $iaDb->getMaxOrder(iaField::getTable());
foreach ($this->itemData['item_fields'] as $item) {
if (!$iaDb->exists('`item` = :item AND `name` = :name', array('item' => $item['item'], 'name' => $item['name']))) {
$item['order'] || ($item['order'] = ++$maxOrder);
$item['fieldgroup_id'] = isset($fieldGroups[$item['item'] . $item['group']]) ? $fieldGroups[$item['item'] . $item['group']] : 0;
$this->_addPhrase('field_' . $item['name'], $item['title']);
unset($item['group'], $item['title']);
if (is_array($item['numberRangeForSearch'])) {
foreach ($item['numberRangeForSearch'] as $num) {
$this->_addPhrase('field_' . $item['name'] . '_range_' . $num, $num, iaLanguage::CATEGORY_FRONTEND);
}
}
unset($item['numberRangeForSearch']);
if ('dependent' == $item['relation']) {
$iaDb->setTable(iaField::getTableRelations());
foreach (explode(';', $item['parent']) as $parent) {
$list = explode(':', $parent);
if (2 == count($list)) {
list($fieldName, $fieldValues) = $list;
foreach (explode(',', $fieldValues) as $fieldValue) {
$entryData = array('field' => $fieldName, 'element' => $fieldValue, 'child' => $item['name'], 'item' => $item['item'], 'extras' => $this->itemData['name']);
$iaDb->insert($entryData);
}
}
}
$iaDb->resetTable();
}
unset($item['parent']);
if (is_array($item['values'])) {
foreach ($item['values'] as $key => $value) {
$key = sprintf('field_%s_%s', $item['name'], $key);
$this->_addPhrase($key, $value);
}
if ($item['default']) {
// TODO: multiple default values for checkboxes should be implemented
if (!in_array($item['default'], array_keys($item['values']))) {
$item['default'] = array_search($item['default'], $item['values']);
}
}
$item['values'] = implode(',', array_keys($item['values']));
}
$fieldPages = $item['item_pages'] ? $item['item_pages'] : array();
$tableName = $item['table_name'];
$className = $item['class_name'];
unset($item['item_pages'], $item['table_name'], $item['class_name']);
$fieldId = $iaDb->insert($item);
$item['table_name'] = $tableName;
$item['class_name'] = $className;
if ($fieldPages) {
foreach ($fieldPages as $pageName) {
if (trim($pageName) != '') {
$iaDb->insert(array('page_name' => $pageName, 'field_id' => $fieldId, 'extras' => $this->itemData['name']), null, iaField::getTablePages());
}
}
}
$iaDb->setTable($tableName);
$tableFields = $iaDb->describe();
$isExist = false;
foreach ($tableFields as $f) {
if ($f['Field'] == $item['name']) {
$isExist = true;
break;
}
}
if (!$isExist) {
$this->_addAlter($item);
}
$iaDb->resetTable();
} else {
$stmt = '`item` = :item AND `name` = :name';
$iaDb->bind($stmt, $item);
$iaDb->update(null, $stmt, array('extras' => "CONCAT(`extras`, ',', '" . $this->itemData['name'] . "')"));
}
}
$iaDb->resetTable();
}
$rollbackData = array();
if ($this->itemData['changeset']) {
$tablesMapping = array('block' => 'blocks', 'field' => 'fields', 'menu' => 'blocks');
foreach ($this->itemData['changeset'] as $entry) {
if (!isset($tablesMapping[$entry['type']])) {
continue;
}
switch ($entry['type']) {
case 'field':
list($fieldName, $itemName) = explode('-', $entry['name']);
if (empty($fieldName) || empty($itemName)) {
continue;
}
$stmt = iaDb::printf("`name` = ':name' AND `item` = ':item'", array('name' => $fieldName, 'item' => $itemName));
break;
default:
$stmt = iaDb::printf("`name` = ':name'", $entry);
}
$tableName = $tablesMapping[$entry['type']];
$name = $entry['name'];
unset($entry['type'], $entry['name']);
$entryData = $iaDb->row('`' . implode('`,`', array_keys($entry)) . '`', $stmt, $tableName);
if ($iaDb->update($entry, $stmt, null, $tableName)) {
$rollbackData[$tableName][$name] = $entryData;
}
}
}
$extraEntry['rollback_data'] = empty($rollbackData) ? '' : serialize($rollbackData);
if (self::TYPE_PLUGIN == $this->itemData['type']) {
$extraEntry['removable'] = !in_array($this->itemData['name'], $this->_builtinPlugins);
}
if (!$this->isUpdate) {
$this->iaCore->startHook('phpExtrasInstallBeforeSql', array('extra' => $this->itemData['name'], 'data' => &$this->itemData['info']));
$iaDb->insert($extraEntry, array('date' => iaDb::FUNCTION_NOW), self::getTable());
}
$this->_processCategory($extraEntry);
if ($this->itemData['code']['install']) {
$this->_runPhpCode($this->itemData['code']['install']);
}
if ($this->itemData['cron_jobs']) {
$this->iaCore->factory('cron');
foreach ($this->itemData['cron_jobs'] as $job) {
$job['extras'] = $this->itemData['name'];
$iaDb->insert($job, null, iaCron::getTable());
}
}
$this->iaCore->startHook('phpExtrasInstallAfter', array('extra' => $this->itemData['name']));
$this->iaCore->factory('cache')->clearAll();
return true;
}
private function _savePhrases(array &$data, $name, $item)
{
$this->_iaDb->setTable(iaLanguage::getTable());
$phraseKeyTitle = 'fieldgroup_' . $name;
$phraseKeyDescription = "fieldgroup_description_{$item}_{$name}";
foreach ($this->_iaCore->languages as $code => $language) {
$stmt = '`key` = :phrase AND `code` = :language';
$this->_iaDb->bind($stmt, array('phrase' => $phraseKeyTitle, 'language' => $code));
$this->_iaDb->exists($stmt) ? $this->_iaDb->update(array('value' => iaSanitize::html($data['titles'][$code])), $stmt) : iaLanguage::addPhrase($phraseKeyTitle, iaSanitize::html($data['titles'][$code]), $code);
$stmt = '`key` = :phrase && `code` = :language';
$this->_iaDb->bind($stmt, array('phrase' => $phraseKeyDescription, 'language' => $code));
$this->_iaDb->exists($stmt) ? $this->_iaDb->update(array('value' => iaSanitize::html($data['description'][$code])), $stmt) : iaLanguage::addPhrase($phraseKeyDescription, iaSanitize::html($data['description'][$code]), $code);
}
$this->_iaDb->resetTable();
}
// check read permissions
$page['passw'] = trim($page['passw']);
if (isset($_POST['password']) && $page['passw'] && $passw != $page['passw']) {
$iaView->setMessages(iaLanguage::get('password_incorrect'), iaView::ERROR_NOT_FOUND);
}
if ($page['passw'] && $passw != $page['passw'] && !$previewMode) {
if (!$preview) {
$page = array('meta_description' => $page['meta_description'], 'meta_keywords' => $page['meta_keywords']);
$iaView->assign('protect', true);
}
}
if ($preview) {
$iaView->assign('page_protect', iaLanguage::get('page_preview'));
}
$iaView->assign('page', $page);
$iaDb->setTable(iaLanguage::getTable());
$jt_where = "`category` = 'page' AND `key` = 'page_{DATA_REPLACE}_{$name}' AND `code` = '";
if (!$previewMode) {
$page_title_check = iaLanguage::get('page_title_' . $name, $name);
$pageTitle = $page_title_check ? $page_title_check : $iaDb->one('`value`', str_replace('{DATA_REPLACE}', 'title', $jt_where) . $iaCore->get('lang') . "'");
$iaView->title($pageTitle);
}
if ($page && !$previewMode) {
$page_content_check = $iaDb->one('`value`', str_replace('{DATA_REPLACE}', 'content', $jt_where) . $iaView->language . "'");
$content = $page_content_check ? $page_content_check : $iaDb->one('`value`', str_replace('{DATA_REPLACE}', 'content', $jt_where) . $iaCore->get('lang') . "'");
}
$iaDb->resetTable();
if ($page['custom_tpl'] && $page['template_filename']) {
$content = $iaView->iaSmarty->fetch($page['template_filename']);
}
$iaView->assign('content', $content);
public function uninstall($extraName)
{
if (empty($extraName)) {
$this->error = true;
$this->setMessage('Extra name is empty.');
return false;
}
$this->iaCore->startHook('phpExtrasUninstallBefore', array('extra' => $extraName));
if ($this->iaCore->get('default_package') == $extraName) {
$this->iaCore->set('default_package', '', true);
}
$this->checkValidity();
$extraName = iaSanitize::sql($extraName);
$iaDb =& $this->iaDb;
$code = $iaDb->row_bind(array('uninstall_code', 'uninstall_sql', 'rollback_data'), '`name` = :name', array('name' => $extraName), self::getTable());
$pagesList = $iaDb->onefield('`name`', "`extras` = '{$extraName}'", null, null, 'pages');
$iaDb->delete("`page_name` IN ('" . implode("','", $pagesList) . "')", 'menus');
if (in_array($this->iaCore->get('home_page'), $pagesList)) {
$this->iaCore->set('home_page', 'index', true);
}
if ($itemsList = $iaDb->onefield('item', "`package` = '{$extraName}'", null, null, 'items')) {
$stmt = "`item` IN ('" . implode("','", $itemsList) . "')";
$iaDb->cascadeDelete(array('items_pages', 'favorites', 'views_log'), $stmt);
}
if ($pagesList) {
$iaDb->cascadeDelete(array('objects_pages'), "`page_name` IN ('" . implode("','", $pagesList) . "')");
$iaDb->setTable(iaLanguage::getTable());
$iaDb->delete("`key` IN ('page_title_" . implode("','page_title_", $pagesList) . "')");
$iaDb->delete("`key` IN ('page_content_" . implode("','page_content_", $pagesList) . "')");
$iaDb->delete("`key` IN ('page_metakeyword_" . implode("','page_metakeyword_", $pagesList) . "')");
$iaDb->delete("`key` IN ('page_metadescr_" . implode("','page_metadescr_", $pagesList) . "')");
$iaDb->resetTable();
}
$tableList = array('admin_actions', 'admin_pages_groups', 'admin_pages', 'acl_privileges', iaLanguage::getTable(), iaCore::getConfigGroupsTable(), iaCore::getConfigTable(), iaCore::getCustomConfigTable(), 'pages', 'hooks', 'acl_objects', 'fields_groups', 'fields_pages', 'fields_relations', 'fields_tree_nodes', 'cron');
$iaDb->cascadeDelete($tableList, "`extras` = '{$extraName}'");
$this->iaCore->factory('field');
$iaDb->setTable(iaField::getTable());
$stmt = '`extras` LIKE :extras';
$this->iaDb->bind($stmt, array('extras' => '%' . $extraName . '%'));
if ($itemsList) {
$stmt .= " OR `item` IN ('" . implode("','", $itemsList) . "')";
}
if ($fields = $iaDb->all(array('id', 'extras'), $stmt)) {
foreach ($fields as $field) {
$pluginsList = explode(',', $field['extras']);
if (count($pluginsList) > 1) {
unset($pluginsList[array_search($extraName, $pluginsList)]);
$iaDb->update(array('extras' => implode(',', $pluginsList), 'id' => $field['id']));
} else {
$iaDb->delete(iaDb::convertIds($field['id']));
}
}
}
$iaDb->resetTable();
$iaBlock = $this->iaCore->factory('block', iaCore::ADMIN);
if ($blockIds = $iaDb->onefield(iaDb::ID_COLUMN_SELECTION, "`extras` = '{$extraName}'", null, null, iaBlock::getTable())) {
foreach ($blockIds as $blockId) {
$iaBlock->delete($blockId, false);
}
}
if ($code['uninstall_sql']) {
$code['uninstall_sql'] = unserialize($code['uninstall_sql']);
if ($code['uninstall_sql'] && is_array($code['uninstall_sql'])) {
foreach ($code['uninstall_sql'] as $sql) {
$iaDb->query(str_replace('{prefix}', $iaDb->prefix, $sql['query']));
}
}
}
$entry = $iaDb->row_bind(iaDb::ALL_COLUMNS_SELECTION, '`name` = :name', array('name' => $extraName), self::getTable());
$iaDb->delete('`name` = :plugin', self::getTable(), array('plugin' => $extraName));
$iaDb->delete('`package` = :plugin', 'items', array('plugin' => $extraName));
empty($entry) || $this->_processCategory($entry, self::ACTION_UNINSTALL);
if ($code['uninstall_code']) {
$this->_runPhpCode($code['uninstall_code']);
}
if ($code['rollback_data']) {
$rollbackData = unserialize($code['rollback_data']);
if (is_array($rollbackData)) {
$existPositions = $this->iaView->positions;
foreach ($rollbackData as $sectionName => $actions) {
foreach ($actions as $name => $itemData) {
if (isset($itemData['position'])) {
if (!in_array($itemData['position'], $existPositions)) {
$itemData['position'] = '';
$itemData['status'] = iaCore::STATUS_INACTIVE;
}
}
$stmt = iaDb::printf("`name` = ':name'", array('name' => $name));
$this->iaDb->update($itemData, $stmt, null, $sectionName);
}
}
}
}
// clear usergroups
if ($usergroups = $iaDb->all(iaDb::ALL_COLUMNS_SELECTION, iaDb::convertIds($extraName, 'extras'), 0, null, iaUsers::getUsergroupsTable())) {
$iaUsers = $this->iaCore->factory('users');
foreach ($usergroups as $usergroup) {
$iaUsers->deleteUsergroup($usergroup['id']);
}
}
$this->iaCore->startHook('phpExtrasUninstallAfter', array('extra' => $extraName));
$this->iaCore->iaCache->clearAll();
return true;
}
private function _update(array $fieldData, $id)
{
$iaDb =& $this->_iaDb;
$field = $iaDb->row(iaDb::ALL_COLUMNS_SELECTION, iaDb::convertIds($id));
if (empty($field) || $field['type'] != $fieldData['type']) {
return false;
}
// set correct relations
if (iaField::RELATION_REGULAR == $fieldData['relation']) {
$this->_resetRelations($field['name'], $field['item']);
} else {
if ($fieldData['parents']) {
$this->_setParents($field['name'], $fieldData['parents']);
}
if ($fieldData['children']) {
$this->_setChildren($field['name'], $field['item'], $fieldData['values'], $fieldData['children']);
}
$this->_setRelations();
}
unset($fieldData['parents'], $fieldData['children']);
$iaDb->setTable(iaLanguage::getTable());
$iaDb->delete("`key` LIKE 'field\\_" . $field['name'] . "\\_%'");
foreach ($this->_iaCore->languages as $code => $language) {
iaLanguage::addPhrase('field_' . $field['name'], $fieldData['title'][$code], $code, $field['extras']);
if (isset($fieldData['annotation'][$code]) && $fieldData['annotation'][$code]) {
iaLanguage::addPhrase('field_' . $field['name'] . '_annotation', $fieldData['annotation'][$code], $code, $field['extras']);
}
}
unset($fieldData['title'], $fieldData['annotation']);
$keys = array();
if (isset($fieldData['values']) && is_array($fieldData['values'])) {
$newKeys = array();
foreach ($fieldData['values'] as $key => $value) {
$key = $keys[$key] = isset($fieldData['keys'][$key]) ? $fieldData['keys'][$key] : $key;
iaLanguage::addPhrase('field_' . $field['name'] . '_' . $key, $value, null, $field['extras']);
$newKeys[] = $key;
}
$fieldData['values'] = implode(',', $newKeys);
} elseif (iaField::TREE != $fieldData['type']) {
unset($fieldData['values']);
} elseif (iaField::TREE == $fieldData['type']) {
$iaDb->setTable('fields_tree_nodes');
$iaDb->delete('`field` = :name && `item` = :item', null, array('name' => $field['name'], 'item' => $field['item']));
if ($fieldData['tree_nodes']) {
foreach ($fieldData['tree_nodes'] as $node) {
// insert default language
iaLanguage::addPhrase('field_' . $field['item'] . '_' . $field['name'] . '_' . $node['node_id'], $node['text'], $this->_iaCore->iaView->language, $field['extras']);
unset($node['text']);
$node['field'] = $field['name'];
$node['item'] = $field['item'];
$node['extras'] = $field['extras'];
$iaDb->insert($node);
}
}
$iaDb->resetTable();
unset($fieldData['tree_nodes']);
}
unset($fieldData['keys']);
if (isset($fieldData['lang_values']) && is_array($fieldData['lang_values'])) {
foreach ($fieldData['lang_values'] as $languageCode => $phrases) {
foreach ($phrases as $phraseKey => $phraseValue) {
iaLanguage::addPhrase('field_' . $field['name'] . '_' . $phraseKey, $phraseValue, $languageCode, $field['extras']);
}
}
}
if (isset($fieldData['lang_values'])) {
unset($fieldData['lang_values']);
}
if ($fieldData['searchable'] && $fieldData['type'] == iaField::NUMBER && isset($fieldData['_numberRangeForSearch']) && is_array($fieldData['_numberRangeForSearch']) && !empty($fieldData['_numberRangeForSearch'])) {
$iaDb->delete("`key` LIKE 'field\\_" . $field['name'] . "\\_range\\_%'");
foreach ($fieldData['_numberRangeForSearch'] as $value) {
iaLanguage::addPhrase('field_' . $field['name'] . '_range_' . $value, $value, null, $field['extras']);
}
unset($fieldData['_numberRangeForSearch']);
} else {
$iaDb->delete("`key` LIKE 'field\\_" . $field['name'] . "\\_range\\_%'");
}
$iaDb->resetTable();
$tableName = $this->_iaCore->factory('item')->getItemTable($fieldData['item']);
// avoid making fulltext second time
if (!$field['searchable'] && $fieldData['searchable'] && in_array($fieldData['type'], array(iaField::TEXT, iaField::TEXTAREA))) {
$indexes = $iaDb->getAll("SHOW INDEX FROM `{$iaDb->prefix}{$tableName}`");
$keyExists = false;
foreach ($indexes as $i) {
if ($i['Key_name'] == $field['name'] && $i['Index_type'] == 'FULLTEXT') {
$keyExists = true;
break;
}
}
if (!$keyExists) {
$iaDb->query("ALTER TABLE `{$iaDb->prefix}{$tableName}` ADD FULLTEXT (`{$field['name']}`)");
}
}
if ($field['searchable'] && !$fieldData['searchable'] && in_array($fieldData['type'], array(iaField::TEXT, iaField::TEXTAREA))) {
$indexes = $iaDb->getAll("SHOW INDEX FROM `{$iaDb->prefix}{$tableName}`");
$keyExists = false;
foreach ($indexes as $i) {
if ($i['Key_name'] == $field['name'] && $i['Index_type'] == 'FULLTEXT') {
$keyExists = true;
break;
}
}
if ($keyExists) {
$iaDb->query("ALTER TABLE `{$iaDb->prefix}{$tableName}` DROP INDEX `{$field['name']}`");
}
}
$pagesList = $fieldData['pages'];
unset($fieldData['pages'], $fieldData['groups'], $fieldData['item']);
$result = parent::_entryUpdate($fieldData, $id);
if ($pagesList) {
$this->_setPagesList($id, $pagesList, $field['extras']);
}
if ($result) {
if (in_array($fieldData['type'], array(iaField::TEXT, iaField::COMBO, iaField::RADIO, iaField::CHECKBOX))) {
$sql = "ALTER TABLE `{$this->_iaDb->prefix}{$tableName}` ";
$sql .= "CHANGE `{$field['name']}` `{$field['name']}` ";
switch ($fieldData['type']) {
case iaField::TEXT:
$sql .= "VARCHAR ({$fieldData['length']}) ";
$sql .= $fieldData['default'] ? "DEFAULT '{$fieldData['default']}' " : '';
break;
default:
if (isset($fieldData['values'])) {
$values = explode(',', $fieldData['values']);
$sql .= $fieldData['type'] == iaField::CHECKBOX ? 'SET' : 'ENUM';
$sql .= "('" . implode("','", $values) . "')";
if (!empty($fieldData['default'])) {
$sql .= " DEFAULT '{$fieldData['default']}' ";
}
}
break;
}
$sql .= 'NOT NULL';
$iaDb->query($sql);
}
}
return $result;
}
private function _getPagesList($languageCode)
{
$iaPage = $this->_iaCore->factory('page', iaCore::ADMIN);
$sql = 'SELECT DISTINCTROW p.*, IF(l.`value` IS NULL, p.`name`, l.`value`) `title` ' . 'FROM `:prefix:table_pages` p ' . 'LEFT JOIN `:prefix:table_phrases` l ' . "ON (`key` = CONCAT('page_title_', p.`name`) AND l.`code` = ':lang' AND l.`category` = ':category') " . "WHERE p.`status` = ':status' AND p.`service` = 0 " . 'GROUP BY p.`name` ' . 'ORDER BY l.`value`';
$sql = iaDb::printf($sql, array('prefix' => $this->_iaDb->prefix, 'table_pages' => $iaPage::getTable(), 'table_phrases' => iaLanguage::getTable(), 'status' => iaCore::STATUS_ACTIVE, 'lang' => $languageCode, 'category' => iaLanguage::CATEGORY_PAGE));
return $this->_iaDb->getAll($sql);
}
public function getNonServicePages(array $exclude)
{
$sql = "SELECT DISTINCTROW p.*, IF(t.`value` IS NULL, p.`name`, t.`value`) `title`\n\t\t\tFROM `" . self::getTable(true) . "` p\n\t\t\t\tLEFT JOIN `" . $this->iaDb->prefix . iaLanguage::getTable() . "` t\n\t\t\t\t\tON `key` = CONCAT('page_title_', p.`name`) AND t.`code` = '" . $this->iaView->language . "'\n\t\t\tWHERE p.`status` = 'active'\n\t\t\t\tAND p.`service` = 0 " . ($exclude ? "AND !FIND_IN_SET(p.`name`, '" . implode(',', $exclude) . "') " : ' ') . 'ORDER BY t.`value`';
return $this->iaDb->getAll($sql);
}
protected function _assignValues(&$iaView, array &$entryData)
{
if (isset($_POST['titles']) && isset($_POST['contents'])) {
$entryData['titles'] = $_POST['titles'];
$entryData['contents'] = $_POST['contents'];
} elseif (iaCore::ACTION_EDIT == $iaView->get('action')) {
$this->_iaDb->setTable(iaLanguage::getTable());
$entryData['titles'] = $this->_iaDb->keyvalue(array('code', 'value'), "`key` = 'page_title_{$entryData['name']}' AND `category` = 'page'");
$entryData['contents'] = $this->_iaDb->keyvalue(array('code', 'value'), "`key` = 'page_content_{$entryData['name']}' AND `category` = 'page'");
$this->_iaDb->resetTable();
}
$menus = array(array('title' => iaLanguage::get('core_menus', 'Core menus'), 'list' => array()), array('title' => iaLanguage::get('custom_menus', 'Custom menus'), 'list' => array()));
$iaAcl = $this->_iaCore->factory('acl');
if ($iaAcl->checkAccess('admin_page:add', 0, 0, 'menus')) {
$this->_iaCore->factory('block', iaCore::ADMIN);
$menusList = $this->_iaDb->all(array('id', 'title', 'removable'), "`type` = 'menu'", null, null, iaBlock::getTable());
foreach ($menusList as $menuEntry) {
$menus[$menuEntry['removable']]['list'][] = $menuEntry;
}
ksort($menus[0]['list']);
ksort($menus[1]['list']);
$selectedMenus = empty($_POST['menus']) ? $this->_iaDb->onefield('menu_id', iaDb::convertIds($entryData['name'], 'page_name'), null, null, iaBlock::getMenusTable()) : $_POST['menus'];
$iaView->assign('selectedMenus', $selectedMenus);
}
$parentAlias = '';
if ($entryData['parent']) {
$parentAlias = $this->getHelper()->getByName($entryData['parent'], false);
$parentAlias = empty($parentAlias['alias']) ? $parentAlias['name'] . IA_URL_DELIMITER : $parentAlias['alias'];
}
$entryData['extension'] = false === strpos($entryData['alias'], '.') ? '' : end(explode('.', $entryData['alias']));
$entryData['alias'] = substr($entryData['alias'], strlen($parentAlias), -1 - strlen($entryData['extension']));
if ($entryData['name'] == $entryData['alias']) {
$entryData['alias'] = '';
}
$parentPage = $this->getHelper()->getByName($entryData['parent'], false);
$groups = $this->getHelper()->getGroups(array($this->_iaCore->get('home_page'), $entryData['name']));
$isHomepage = $this->_iaCore->get('home_page', iaView::DEFAULT_HOMEPAGE) == $entryData['name'];
$iaView->assign('isHomePage', $isHomepage);
$iaView->assign('extensions', $this->getHelper()->extendedExtensions);
$iaView->assign('menus', $menus);
$iaView->assign('pages', $this->getHelper()->getNonServicePages(array('index')));
$iaView->assign('pagesGroup', $groups);
$iaView->assign('parentPageId', $parentPage['id']);
}
protected function _assignValues(&$iaView, array &$entryData)
{
$groupList = $this->_iaDb->onefield('`group`', '1 = 1 GROUP BY `group`', null, null, 'pages');
$this->_iaDb->setTable('admin_pages_groups');
$array = $this->_iaDb->all(array('id', 'name', 'title'));
$pagesGroups = array();
foreach ($array as $row) {
in_array($row['id'], $groupList) && ($pagesGroups[$row['id']] = $row);
}
$this->_iaDb->resetTable();
$menuPages = array();
$entryData['content'] = is_null($this->_multilingualContent) ? $entryData['contents'] : $this->_multilingualContent;
if (!isset($entryData['titles']) && iaCore::ACTION_EDIT == $iaView->get('action')) {
$this->_iaDb->setTable(iaLanguage::getTable());
$entryData['titles'] = $this->_iaDb->keyvalue(array('code', 'value'), "`key` = '" . iaBlock::LANG_PATTERN_TITLE . $this->getEntryId() . "'");
$entryData['contents'] = $this->_iaDb->keyvalue(array('code', 'value'), "`key` = '" . iaBlock::LANG_PATTERN_CONTENT . $this->getEntryId() . "'");
$entryData['languages'] = empty($entryData['contents']) ? array() : array_keys($entryData['contents']);
if ($entryData['multilingual'] && empty($entryData['contents']) && iaBlock::TYPE_PHP != $entryData['type']) {
foreach ($this->_iaCore->languages as $code => $language) {
$entryData['titles'][$code] = $entryData['title'];
$entryData['contents'][$code] = $entryData['content'];
}
}
$this->_iaDb->resetTable();
$menuPages = $this->_iaDb->onefield('`name`', "FIND_IN_SET('{$entryData['name']}', `menus`)", null, null, 'pages');
}
isset($entryData['header']) || ($entryData['header'] = true);
isset($entryData['collapsible']) || ($entryData['collapsible'] = true);
isset($entryData['multilingual']) || ($entryData['multilingual'] = true);
isset($entryData['sticky']) || ($entryData['sticky'] = true);
isset($entryData['external']) || ($entryData['external'] = false);
empty($entryData['subpages']) || ($entryData['subpages'] = unserialize($entryData['subpages']));
isset($entryData['pages']) || ($entryData['pages'] = $this->_iaDb->onefield('page_name', "`object_type` = 'blocks' && " . iaDb::convertIds($this->getEntryId(), 'object'), 0, null, iaBlock::getPagesTable()));
$iaView->assign('menuPages', $menuPages);
$iaView->assign('pagesGroup', $pagesGroups);
$iaView->assign('pages', $this->_getPagesList($iaView->language));
$iaView->assign('positions', $this->getHelper()->getPositions());
$iaView->assign('types', $this->getHelper()->getTypes());
}
public function getByName($pageName, $lookupThroughBackend = true)
{
$result = $this->iaDb->row_bind(iaDb::ALL_COLUMNS_SELECTION, '`name` = :name', array('name' => $pageName), $lookupThroughBackend ? self::getAdminTable() : self::getTable());
if (!$lookupThroughBackend && $result) {
$result['title'] = $this->iaDb->one_bind(array('value'), '`key` = :key AND `category` = :category AND `code` = :lang', array('key' => 'page_title_' . $pageName, 'category' => iaLanguage::CATEGORY_PAGE, 'lang' => $this->iaView->language), iaLanguage::getTable());
}
return $result;
}
protected function _createJsFile($file, $type = 'config')
{
$this->iaCore->factory('util');
// required in order the class iaUtil to be loaded
$iaDb =& $this->iaCore->iaDb;
switch ($type) {
case 'lang':
case 'admin_lang':
// get phrases
$stmt = "`code` = :lang AND `category` NOT IN ('tooltip', 'page', :category)";
$iaDb->bind($stmt, array('lang' => $this->iaCore->iaView->language, 'category' => $type == 'admin_lang' ? 'frontend' : iaCore::ADMIN));
$phrases = $iaDb->keyvalue(array('key', 'value'), $stmt, iaLanguage::getTable());
// get list of languages
$languagesList = $iaDb->assoc(array('code', 'title', 'direction', 'flagicon', 'iso' => 'code'), 'admin_lang' == $type ? null : "`status` = 'active'", 'languages');
$fileContent = 'intelli.' . ('admin_lang' == $type ? 'admin.' : '') . 'lang = ' . iaUtil::jsonEncode($phrases) . ';' . 'intelli.languages = ' . iaUtil::jsonEncode($languagesList) . ';';
break;
case 'config':
$stmt = "`private` = 0 && `type` != 'divider' && `config_group` != 'email_templates'";
$config = $iaDb->keyvalue(array('name', 'value'), $stmt, iaCore::getConfigTable());
if (file_exists(IA_INCLUDES . 'custom.inc.php')) {
include IA_INCLUDES . 'custom.inc.php';
}
$config['ia_url'] = IA_CLEAR_URL;
$config['packages'] = $this->iaCore->setPackagesData();
$config['items'] = array();
$config['extras'] = array(array('core', iaLanguage::get('core', 'Core')));
$array = $iaDb->all(array('name', 'title'), "`status` = 'active' ORDER BY `type`", null, null, 'extras');
foreach ($array as $item) {
$config['extras'][] = array($item['name'], $item['title']);
}
$array = $iaDb->onefield('`item`', "`item` != 'transactions'", null, null, 'items');
foreach ($array as $item) {
$config['items'][] = array($item, iaLanguage::get($item, $item));
}
$fileContent = 'intelli.config = ' . iaUtil::jsonEncode($config) . ';';
}
if (isset($fileContent)) {
if ($fh = fopen($file, 'w')) {
fwrite($fh, $fileContent);
fclose($fh);
}
}
}
public function install($type = self::SETUP_REPLACE)
{
$iaDb =& $this->iaDb;
// TODO: check for relations and deactivate all needed extras
if ($this->_requires) {
$messages = array();
foreach ($this->_requires as $require) {
if ($require['min'] || $require['max']) {
$min = $max = false;
if (isset($extrasList[$require['name']])) {
$info = $extrasList[$require['name']];
$min = $require['min'] ? version_compare($require['min'], $info['version'], '<=') : true;
$max = $require['max'] ? version_compare($require['max'], $info['version'], '>=') : true;
}
if (!$max || !$min) {
$ver = '';
if ($require['min']) {
$ver .= $require['min'];
}
if ($require['max']) {
if ($require['min']) {
$ver .= '-';
}
$ver .= $require['max'];
}
$replace = array(':extra' => $require['type'], ':name' => $require['name'], ':version' => $ver);
$messages[] = iaLanguage::getf('required_template_error', $replace);
$this->error = true;
} else {
// TODO: add relations in database to deactivate when parent is uninstalled
}
}
}
if ($this->error) {
$this->_message = implode('<br>', $messages);
return false;
}
}
if (self::SETUP_REPLACE == $type) {
$template = $iaDb->one('value', "`name` = 'tmpl'", iaCore::getConfigTable());
$tablesList = array('hooks', 'blocks', iaLanguage::getTable(), 'pages', iaCore::getConfigTable(), iaCore::getConfigGroupsTable(), iaCore::getCustomConfigTable());
$iaDb->cascadeDelete($tablesList, "`extras` = '{$template}'");
$iaDb->cascadeDelete($tablesList, "`extras` = '{$this->name}'");
}
$iaDb->update(array('value' => $this->name), "`name` = 'tmpl'", null, iaCore::getConfigTable());
if ($this->_phrases) {
$this->_processPhrases();
}
if ($this->_config) {
$iaDb->setTable(iaCore::getConfigTable());
$maxOrder = $iaDb->one_bind('MAX(`order`) + 1', '`extras` = :extras', array('extras' => $this->name));
$maxOrder = $maxOrder ? (int) $maxOrder : 1;
foreach ($this->_config as $entry) {
$id = $this->iaDb->one(iaDb::ID_COLUMN_SELECTION, iaDb::convertIds($entry['name'], 'name'));
$entry['order'] = isset($entry['order']) ? $entry['order'] : ++$maxOrder;
if (!$id || empty($entry['name'])) {
$this->iaDb->insert($entry);
} elseif ($id) {
if (isset($entry['value'])) {
unset($entry['value']);
}
$this->iaDb->update($entry, iaDb::convertIds($id));
}
}
$iaDb->resetTable();
}
if ($this->_configGroups) {
$iaDb->setTable(iaCore::getConfigGroupsTable());
$maxOrder = $iaDb->getMaxOrder() + 1;
foreach ($this->_configGroups as $title => $entry) {
$iaDb->insert($entry, array('order' => $maxOrder));
$this->_addPhrase('config_group_' . $entry['name'], $title, iaLanguage::CATEGORY_ADMIN);
$maxOrder++;
}
$iaDb->resetTable();
}
if ($this->_hooks) {
$iaDb->setTable('hooks');
$maxOrder = $iaDb->one('MAX(`order`) + 1');
$maxOrder = $maxOrder ? $maxOrder : 1;
foreach ($this->_hooks as $hook) {
$array = explode(',', $hook['name']);
foreach ($array as $hookName) {
if (trim($hookName)) {
$hook['name'] = $hookName;
if (isset($hook['code']) && $hook['code']) {
$hook['code'] = str_replace('{extras}', $this->name, $hook['code']);
}
$iaDb->insert($hook, array('order' => $maxOrder));
$maxOrder++;
}
}
}
$iaDb->resetTable();
}
$positionsList = array();
if ($this->_positions) {
$positionPages = array();
$iaDb->setTable('positions');
$iaDb->truncate();
foreach ($this->_positions as $position) {
$positionsList[] = $position['name'];
$iaDb->insert(array('name' => $position['name'], 'menu' => (int) $position['menu'], 'movable' => (int) $position['movable']));
if (null != $position['default_access']) {
$positionPages[] = array('object_type' => 'positions', 'page_name' => '', 'object' => $position['name'], 'access' => (int) $position['default_access']);
}
if ($position['pages']) {
$pages = explode(',', $position['pages']);
foreach ($pages as $page) {
$positionPages[] = array('object_type' => 'positions', 'page_name' => $page, 'object' => $position['name'], 'access' => (int) $position['access']);
}
}
}
$iaDb->resetTable();
if ($positionPages) {
$iaDb->delete("`object_type` = 'positions'", 'objects_pages');
foreach ($positionPages as $positionPage) {
$iaDb->insert($positionPage, null, 'objects_pages');
}
}
}
$iaBlock = $this->iaCore->factory('block', iaCore::ADMIN);
if ($this->blocks) {
$iaDb->setTable($iaBlock::getTable());
$maxOrder = $iaDb->one('MAX(`order`)');
$maxOrder = $maxOrder ? $maxOrder : 1;
foreach ($this->blocks as $block) {
if (!$block['order']) {
$maxOrder++;
$block['order'] = $maxOrder;
} else {
$block['order'] = (int) $block['order'];
}
if (!empty($block['filename'])) {
$block['external'] = 1;
}
$blockPages = $block['pages'];
unset($block['pages'], $block['added']);
if (!in_array($block['position'], $positionsList)) {
$block['position'] = $positionsList[0];
}
if (isset($block['contents']) && $block['contents']) {
$block['contents'] = str_replace('{extras}', $this->name, $block['contents']);
}
$id = $iaDb->insert($block);
if ($blockPages) {
$iaBlock->setVisibility($id, $block['sticky'], explode(',', $blockPages));
}
}
$iaDb->resetTable();
}
$rollbackData = array();
if ($this->_changeset) {
$tablesMapping = array('block' => 'blocks', 'field' => 'fields', 'menu' => 'blocks', 'page' => 'pages');
foreach ($this->_changeset as $changeset) {
if (!isset($tablesMapping[$changeset['type']])) {
continue;
}
$entity = $changeset['type'];
$name = $changeset['name'];
unset($changeset['type'], $changeset['name']);
switch ($entity) {
case 'field':
list($fieldName, $itemName) = explode('-', $name);
if (empty($fieldName) || empty($itemName)) {
continue;
}
$stmt = iaDb::printf("`name` = ':name' AND `item` = ':item'", array('name' => $fieldName, 'item' => $itemName));
break;
case 'block':
case 'menu':
$pagesList = isset($changeset['pages']) ? explode(',', $changeset['pages']) : array();
unset($changeset['pages']);
// intentionally missing break stmt
// intentionally missing break stmt
default:
$stmt = iaDb::printf("`name` = ':name'", array('name' => $name));
}
$tableName = $tablesMapping[$entity];
$entryData = $iaDb->row('`id`, `' . implode('`,`', array_keys($changeset)) . '`', $stmt, $tableName);
if ($iaDb->update($changeset, $stmt, null, $tableName)) {
if (isset($changeset['sticky']) && ('block' == $entity || 'menu' == $entity)) {
$iaBlock->setVisibility($entryData['id'], $changeset['sticky'], $pagesList);
}
unset($entryData['id']);
$rollbackData[$tableName][$name] = $entryData;
}
}
}
$rollbackData = empty($rollbackData) ? '' : serialize($rollbackData);
$this->iaCore->set(self::CONFIG_LAYOUT_DATA, serialize($this->_layout), true);
$this->iaCore->set(self::CONFIG_ROLLBACK_DATA, $rollbackData, true);
if (self::SETUP_INITIAL != $type) {
setcookie('template_color_scheme', '', time() - 3600, '/');
}
return true;
}
public function __construct()
{
parent::__construct();
$this->setTable(iaLanguage::getTable());
$this->setHelper($this->_iaCore->iaCache);
}
function searchByPages($query, &$results)
{
$iaCore = iaCore::instance();
$iaDb =& $iaCore->iaDb;
$iaSmarty =& $iaCore->iaView->iaSmarty;
$iaPage = $iaCore->factory('page', iaCore::FRONT);
$stmt = '`value` LIKE :query AND `category` = :category AND `code` = :language ORDER BY `key`';
$iaDb->bind($stmt, array('query' => '%' . iaSanitize::sql($query) . '%', 'category' => iaLanguage::CATEGORY_PAGE, 'language' => $iaCore->iaView->language));
$pages = array();
if ($rows = $iaDb->all(array('key', 'value'), $stmt, null, null, iaLanguage::getTable())) {
foreach ($rows as $row) {
$pageName = str_replace(array('page_title_', 'page_content_'), '', $row['key']);
$key = false === stripos($row['key'], 'page_content_') ? 'title' : 'content';
$value = iaSanitize::tags($row['value']);
isset($pages[$pageName]) || ($pages[$pageName] = array());
if ('content' == $key) {
$value = extractSnippet($value, $query);
if (empty($pages[$pageName]['title'])) {
$pages[$pageName]['title'] = iaLanguage::get('page_title_' . $pageName);
}
}
$pages[$pageName]['url'] = $iaPage->getUrlByName($pageName, false);
$pages[$pageName][$key] = $value;
}
}
// blocks content will be printed out as a pages content
if ($blocks = searchThroughBlocks($query)) {
foreach ($blocks as $pageName => $blocksData) {
if (isset($pages[$pageName])) {
$pages[$pageName]['extraItems'] = $blocksData;
} else {
$pages[$pageName] = array('url' => $iaPage->getUrlByName($pageName), 'title' => iaLanguage::get('page_title_' . $pageName), 'content' => '', 'extraItems' => $blocksData);
}
}
}
if ($pages) {
$iaSmarty->assign('pages', $pages);
$results['num'] += count($pages);
$results['html']['pages'] = $iaSmarty->fetch('search-list-pages.tpl');
}
}
