Subrion - open source content management system
Copyright (C) 2016 Intelliants, LLC
This file is part of Subrion.
Subrion is free software: you can redistribute it and/or modify
it under the terms of the GNU General Public License as published by
the Free Software Foundation, either version 3 of the License, or
(at your option) any later version.
Subrion is distributed in the hope that it will be useful,
but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
GNU General Public License for more details.
You should have received a copy of the GNU General Public License
along with Subrion. If not, see .
protected function _preSaveEntry(array &$entry, array $data, $action) { $this->_iaCore->startHook('adminAddMemberValidation'); $iaAcl = $this->_iaCore->factory('acl'); $iaField = $this->_iaCore->factory('field'); $fields = iaField::getAcoFieldsList(iaCore::ADMIN, $this->_itemName); // below is the hacky way to force the script to upload files to the appropriate user's folder // FIXME $activeUser = iaUsers::getIdentity(true); $_SESSION[iaUsers::SESSION_KEY] = array('id' => $this->getEntryId(), 'username' => $data['username']); list($entry, $error, $this->_messages, ) = $iaField->parsePost($fields, $entry); $_SESSION[iaUsers::SESSION_KEY] = $activeUser; // if ($iaAcl->isAccessible($this->getName(), 'usergroup')) { if (isset($data['usergroup_id'])) { $entry['usergroup_id'] = array_key_exists($data['usergroup_id'], $this->_userGroups) ? $data['usergroup_id'] : iaUsers::MEMBERSHIP_REGULAR; } } elseif (iaCore::ACTION_ADD == $action) { $entry['usergroup_id'] = iaUsers::MEMBERSHIP_REGULAR; } if ($error) { return false; } $stmt = '`email` = :email'; if (iaCore::ACTION_EDIT == $action) { if (isset($entry['status']) && $entry['status'] == $this->_iaDb->one('status', iaDb::convertIds((int) $this->getEntryId()))) { unset($entry['status']); } $stmt .= ' AND `id` != ' . (int) $this->getEntryId(); } if ($this->_iaDb->exists($stmt, $entry)) { $this->addMessage('error_duplicate_email'); } if ($this->_iaDb->exists('`username` = :username AND `id` != :id', array('username' => $entry['username'], 'id' => $this->getEntryId()))) { $this->addMessage('username_already_taken'); } if ($iaAcl->checkAccess($this->getName(), 'password') || iaCore::ACTION_ADD == $action) { $this->_password = trim($data['_password']); if ($this->_password || !empty($data['_password2'])) { $entry['password'] = $this->getHelper()->encodePassword($this->_password); iaUtil::loadUTF8Functions('ascii', 'validation', 'bad', 'utf8_to_ascii'); if (empty($entry['password'])) { $this->addMessage('error_password_empty'); } elseif (!utf8_is_ascii($entry['password'])) { $this->addMessage(iaLanguage::get('password') . ': ' . iaLanguage::get('ascii_required')); } elseif ($entry['password'] != $this->getHelper()->encodePassword($data['_password2'])) { $this->addMessage('error_password_match'); } } } if (empty($data['_password']) && iaCore::ACTION_ADD == $action) { $this->addMessage('error_password_empty'); } return !$this->getMessages(); }
function searchableFields($iaDb, $aItems, $types = null) { $result = array(); $stmt = "`adminonly` = 0 AND `searchable` = 1 AND `item` IN('" . implode("', '", $aItems) . "') "; if (is_array($types)) { $stmt .= sprintf(" AND `type` IN ('%s') ", implode("', '", $types)); } $fields = $iaDb->all(array('name', 'item', 'values', 'type', 'show_as'), $stmt, null, null, iaField::getTable()); foreach ($fields as $f) { if ('combo' == $f['type'] || 'radio' == $f['type'] || 'checkbox' == $f['type']) { $f['type'] = $f['show_as']; $values = array(); foreach (explode(',', $f['values']) as $key) { $values[$key] = iaLanguage::get("field_{$f['name']}_{$key}"); } $f['values'] = $values; } $result[$f['item']][$f['name']] = $f; } return $result; }
// check password if (!$itemData['disable_fields']) { if (!$itemData['password']) { $error = true; $messages[] = iaLanguage::get('error_password_empty'); } else { if ($_POST['password'] != $_POST['password2']) { $error = true; $messages[] = iaLanguage::get('error_password_match'); } } } else { $itemData['password'] = ''; } } else { iaField::keepValues($itemData, $fields); $iaView->setMessages($messages); } if (!$error) { $memberId = $iaUsers->register($itemData); if ($memberId) { $iaCore->factory('log')->write(iaLog::ACTION_CREATE, array('item' => 'member', 'name' => $itemData['fullname'], 'id' => $memberId, 'type' => iaCore::FRONT)); } // process sponsored plan if ($memberId && isset($_POST['plan_id']) && is_numeric($_POST['plan_id'])) { $plan = $iaPlan->getById($_POST['plan_id']); $usergroup = $plan['usergroup'] ? $plan['usergroup'] : iaUsers::MEMBERSHIP_REGULAR; $iaDb->update(array('id' => $memberId, 'usergroup_id' => $usergroup), 0, 0, iaUsers::getTable()); if ($plan['cost'] > 0) { $itemData['id'] = $memberId; $itemData['member_id'] = $memberId;
private function _getFieldsList() { $this->_iaCore->factory('field'); $fields = array(); $rows = $this->_iaDb->all(array('name', 'item', 'for_plan', 'required'), ' 1=1 ORDER BY `for_plan` DESC', null, null, iaField::getTable()); foreach ($rows as $row) { $type = $row['for_plan']; if ($row['required'] == 1) { $type = 2; // required } if (!isset($fields[$row['item']])) { $fields[$row['item']] = array(2 => array(), 1 => array(), 0 => array()); } $fields[$row['item']][$type][] = $row['name']; } return $fields; }
// these fields are system and used in system template $item = array('status' => 'active', 'account_username' => $_SESSION['user']['username'], 'featured' => true); if ('edit' == $pageAction) { $item = $iaAlbum->getById((int) $_GET['id']); if (empty($item)) { iaView::errorPage(iaView::ERROR_NOT_FOUND); } } $fields = iaField::getAllFields(true, '', 'albums'); if (isset($_POST['save'])) { $error = false; $errorFields = array(); $messages = array(); iaCore::util(); if ($fields) { list($data, $error, $messages, $errorFields) = iaField::parsePost($fields, $item, true); } // validate account if (isset($_POST['account']) && !empty($_POST['account'])) { $member_id = $iaDb->one('id', "`username` = '{$_POST['account']}' ", iaUsers::getTable()); if (!$member_id) { $error = true; $messages[] = iaLanguage::get('album_incorrect_account'); } else { $data['member_id'] = $member_id; } } else { $data['member_id'] = iaUsers::getIdentity()->id; } if (!defined('IA_NOUTF')) { iaUtf8::loadUTF8Core();
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 _processParams($params, $processRequestUri = false) { $data = array(); $stmt = '`item` = :item AND `searchable` = 1'; $this->iaDb->bind($stmt, array('item' => $this->_itemName)); $this->_fieldTypes = $this->iaDb->keyvalue(array('name', 'type'), $stmt, iaField::getTable()); if ($params && is_array($params)) { foreach ($params as $fieldName => $value) { empty($this->getOption('columnAlias')->{$fieldName}) || ($fieldName = $this->getOption('columnAlias')->{$fieldName}); if (empty($value) || !isset($this->_fieldTypes[$fieldName]) && ($this->getOption('customColumns') && !in_array($fieldName, $this->_options['customColumns']))) { continue; } $data[$fieldName] = $value; } } // support for custom parameters field:value within request URL if ($processRequestUri) { $captions = array(); foreach ($this->iaCore->requestPath as $chunk) { if (false === strstr($chunk, ':')) { continue; } $value = explode(':', $chunk); $key = array_shift($value); empty($this->getOption('columnAlias')->{$key}) || ($key = $this->getOption('columnAlias')->{$key}); if ($value && isset($this->_fieldTypes[$key])) { switch ($this->_fieldTypes[$key]) { case iaField::NUMBER: if (count($value) > 1) { $data[$key] = array('f' => (int) $value[0], 't' => (int) $value[1]); $captions[] = sprintf('%d-%d', $value[0], $value[1]); } else { $data[$key] = array('f' => (int) $value[0], 't' => (int) $value[0]); $captions[] = $value[0]; } break; case iaField::COMBO: foreach ($value as $v) { $title = iaLanguage::get(sprintf('field_%s_%s', $key, $v), false); empty($title) || ($captions[] = $title); } $data[$key] = $value; break; default: $data[$key] = $value; $captions[] = $value; } } } $this->_caption = implode(' ', $captions); } $this->_params = $data; }
$messages[] = iaLanguage::get('password_empty'); } if ($newPassword != $_POST['confirm']) { $error = true; $messages[] = iaLanguage::get('error_password_match'); } if (!$error) { $iaUsers->changePassword(iaUsers::getIdentity(true), $newPassword, false); $error = false; $messages[] = iaLanguage::get('password_changed'); } $iaView->setMessages($messages, $error ? iaView::ERROR : iaView::SUCCESS); } elseif ($_POST && (isset($_POST['change_info']) || isset($_POST['plan_id']))) { if (isset($_POST['change_info'])) { $item = array(); $fields = iaField::getAcoFieldsList(null, $itemName, null, true, iaUsers::getIdentity(true)); list($item, $error, $messages, $error_fields) = $iaField->parsePost($fields, iaUsers::getIdentity(true)); if (!$error) { if (isset($_POST['usergroup_id']) && $assignableGroups && in_array((int) $_POST['usergroup_id'], array_keys($assignableGroups))) { $item['usergroup_id'] = $_POST['usergroup_id']; } $iaDb->update($item, iaDb::convertIds(iaUsers::getIdentity()->id)); if (0 == $iaDb->getErrorNumber()) { $iaCore->startHook('phpUserProfileUpdate', array('userInfo' => iaUsers::getIdentity(true), 'data' => $item)); iaUsers::reloadIdentity(); $iaView->setMessages(iaLanguage::get('saved'), iaView::SUCCESS); } else { $iaView->setMessages(iaLanguage::get('db_error')); } } else { $iaView->setMessages($messages);
private function _getParents($name) { $result = array(); if ($parents = $this->_iaDb->all(iaDb::ALL_COLUMNS_SELECTION, "`child` = '{$name}'", 0, null, iaField::getTableRelations())) { foreach ($parents as $parent) { $result[$parent['item']][$parent['field']][$parent['element']] = true; } } return $result; }
protected function _processFields(array $fields) { if (!$fields) { return; } $this->iaCore->factory('field'); $fieldGroups = $this->iaDb->keyvalue('CONCAT(`item`, `name`) `key`, `id`', null, iaField::getTableGroups()); $this->iaDb->setTable(iaField::getTable()); $maxOrder = $this->iaDb->getMaxOrder(); foreach ($fields as $entry) { $stmt = '`item` = :item AND `name` = :name'; $this->iaDb->bind($stmt, array('item' => $entry['item'], 'name' => $entry['name'])); if ($row = $this->iaDb->row(array('id', 'extras'), $stmt)) { if (false === stripos($row['extras'], $this->itemData['name'])) { $value = ($row['extras'] ? ',' : '') . $this->itemData['name']; $value = sprintf("CONCAT(`extras`, '%s')", $value); $this->iaDb->update(null, iaDb::convertIds($row['id']), array('extras' => $value)); } continue; } $entry['order'] || ($entry['order'] = ++$maxOrder); $entry['fieldgroup_id'] = isset($fieldGroups[$entry['item'] . $entry['group']]) ? $fieldGroups[$entry['item'] . $entry['group']] : 0; $this->_addPhrase('field_' . $entry['name'], $entry['title']); unset($entry['group'], $entry['title']); if (is_array($entry['numberRangeForSearch'])) { foreach ($entry['numberRangeForSearch'] as $num) { $this->_addPhrase('field_' . $entry['name'] . '_range_' . $num, $num, iaLanguage::CATEGORY_FRONTEND); } } unset($entry['numberRangeForSearch']); if (iaField::RELATION_DEPENDENT == $entry['relation']) { $this->iaDb->setTable(iaField::getTableRelations()); foreach (explode(';', $entry['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' => $entry['name'], 'item' => $entry['item'], 'extras' => $this->itemData['name']); $this->iaDb->insert($entryData); } } } $this->iaDb->resetTable(); } unset($entry['parent']); if (is_array($entry['values'])) { foreach ($entry['values'] as $key => $value) { $key = sprintf('field_%s_%s', $entry['name'], $key); $this->_addPhrase($key, $value); } if ($entry['default']) { // TODO: multiple default values for checkboxes should be implemented if (!in_array($entry['default'], array_keys($entry['values']))) { $entry['default'] = array_search($entry['default'], $entry['values']); } } $entry['values'] = implode(',', array_keys($entry['values'])); } $fieldPages = $entry['item_pages'] ? $entry['item_pages'] : array(); $tableName = $entry['table_name']; $className = $entry['class_name']; unset($entry['item_pages'], $entry['table_name'], $entry['class_name']); $fieldId = $this->iaDb->insert($entry); $entry['table_name'] = $tableName; $entry['class_name'] = $className; foreach ($fieldPages as $pageName) { if (trim($pageName)) { $row = array('page_name' => $pageName, 'field_id' => $fieldId, 'extras' => $this->itemData['name']); $this->iaDb->insert($row, null, iaField::getTablePages()); } } $columnExists = false; foreach ($this->iaDb->describe($tableName) as $f) { if ($f['Field'] == $entry['name']) { $columnExists = true; break; } } $columnExists || $this->_alterTable($entry); } $this->iaDb->resetTable(); }
$iaView->assign('album', $album); // get artist information $iaArtist = $iaCore->factoryPackage('artist', IA_CURRENT_PACKAGE); $artist = $iaArtist->getArtist($album['id_artist']); $iaView->assign('artist', $artist); // get artist albums $albums = $iaAlbum->getAlbumsByArtist($album['id_artist'], "AND `id` <> '{$album['id']}'"); $iaView->assign('albums', $albums); // get artist lyrics $iaLyric = $iaCore->factoryPackage('lyric', IA_CURRENT_PACKAGE); $lyrics = $iaLyric->getLyricsByAlbum($album['id']); if ($lyrics) { $lyrics = $iaItem->updateItemsFavorites($lyrics, $iaLyric->getItemName()); // filter fields iaCore::fields(); $fields = iaField::filterFields($lyrics, $iaLyric->getItemName()); $iaView->assign('fields', $fields); } $iaView->assign('lyrics', $lyrics); // count views $iaAlbum->incrementViewsCounter($album['id']); // breadcrumb formation iaBreadcrumb::add(_t('artists'), 'artists/'); iaBreadcrumb::add($artist['title'], $iaCore->iaSmarty->ia_url(array('type' => 'url', 'item' => $iaArtist->getItemName(), 'data' => $artist))); // set meta keywords and description $iaView->set('description', $album['meta_description']); $iaView->set('keywords', $album['meta_keywords']); $iaView->title($album['title']); $iaView->display('albumview'); break; case 'lyric_view':
$per_page = $iaCore->get('lyrics_per_page', 10); $page = isset($_GET['page']) && 1 < $_GET['page'] ? (int) $_GET['page'] : 1; $start = ($page - 1) * $per_page; $where = false; // gets current page and defines start position $num_index = 20; $page = !empty($_GET['page']) ? (int) $_GET['page'] : 1; $start = (max($page, 1) - 1) * $num_index; $search_alphas = array('0-9', 'A', 'B', 'C', 'D', 'E', 'F', 'G', 'H', 'I', 'J', 'K', 'L', 'M', 'N', 'O', 'P', 'Q', 'R', 'S', 'T', 'U', 'V', 'W', 'X', 'Y', 'Z'); $alpha = isset($iaCore->requestPath[0]) && in_array($iaCore->requestPath[0], $search_alphas) ? $iaCore->requestPath[0] : false; $cause = $alpha ? '0-9' == $alpha ? "(`{$account_by}` REGEXP '^[0-9]') AND " : "(`{$account_by}` LIKE '{$alpha}%') AND " : ''; // get genres $genres = $iaGenre->getGenres($where, $start, $per_page); // get total number of genres $genres_total = $iaGenre->iaDb->foundRows(); if ($genres) { $iaItem = $iaCore->factory('item'); $genres = $iaItem->updateItemsFavorites($genres, 'genres'); // filter fields $fields = iaField::filterFields($genres, 'genres'); $iaView->assign('fields', $fields); } $iaView->assign('genres', $genres); $iaView->assign('aTotal', $genres_total); $iaView->assign('aItemsPerPage', $per_page); $iaView->assign('aTemplate', IA_URL . 'lyrics/?page={page}'); break; default: break; } }
protected function _preSaveEntry(array &$entry, array $data, $action) { $entry = array('name' => iaUtil::checkPostParam('name'), 'item' => iaUtil::checkPostParam('item'), 'collapsible' => iaUtil::checkPostParam('collapsible'), 'collapsed' => iaUtil::checkPostParam('collapsed'), 'tabview' => iaUtil::checkPostParam('tabview'), 'tabcontainer' => iaUtil::checkPostParam('tabcontainer')); iaUtil::loadUTF8Functions('ascii', 'bad', 'validation'); if (iaCore::ACTION_ADD == $action) { if (!utf8_is_ascii($entry['name'])) { $this->addMessage('ascii_required'); } else { $entry['name'] = strtolower($entry['name']); } if (!$this->getMessages() && !preg_match('/^[a-z0-9\\-_]{2,50}$/', $entry['name'])) { $this->addMessage('name_is_incorrect'); } if (empty($data['item'])) { $this->addMessage('at_least_one_item_should_be_checked'); } $entry['order'] = $this->_iaDb->getMaxOrder(iaField::getTableGroups()) + 1; } foreach ($this->_iaCore->languages as $code => $language) { if ($data['titles'][$code]) { if (!utf8_is_valid($data['titles'][$code])) { $data['titles'][$code] = utf8_bad_replace($data['titles'][$code]); } } else { $this->addMessage($language['title'] . ': ' . iaLanguage::get('title_incorrect'), false); } if ($data['description'][$code]) { if (!utf8_is_valid($data['description'][$code])) { $data['description'][$code] = utf8_bad_replace($data['description'][$code]); } } } return !$this->getMessages(); }
$per_page = $iaCore->get('artists_per_page', 20); $page = isset($_GET['page']) && 1 < $_GET['page'] ? (int) $_GET['page'] : 1; $start = ($page - 1) * $per_page; $search_alphas = iaUtil::getLetters(); $alpha = isset($iaCore->requestPath[0]) && in_array($iaCore->requestPath[0], $search_alphas) ? $iaCore->requestPath[0] : false; $cause = $alpha ? '0-9' == $alpha ? "(`title` REGEXP '^[0-9]') AND " : "(`title` LIKE '{$alpha}%') AND " : ''; $iaView->assign('search_alphas', $search_alphas); $iaView->assign('alpha', $alpha); $iaArtist->where = $cause . "`status`='active' ORDER BY `title` ASC "; $artists = $iaArtist->getArtists(false, $start, $per_page); $total_artists = $iaArtist->count; if ($artists) { $iaItem = $iaCore->factory('item'); $artists = $iaItem->updateItemsFavorites($artists, $iaArtist->getItemName()); // filter fields $fields = iaField::filterFields($artists, 'artists'); $iaView->assign('fields', $fields); } $iaView->assign('artists', $artists); $iaView->assign('aTotal', $total_artists); $iaView->assign('aItemsPerPage', $per_page); if ($alpha) { iaBreadcrumb::add(_t('artists'), IA_PACKAGE_URL . 'artists/'); iaBreadcrumb::replaceEnd($alpha, ''); $iaView->assign('aTemplate', IA_URL . 'artists/' . $alpha . '/?page={page}'); } else { $iaView->assign('aTemplate', IA_URL . 'artists/?page={page}'); } break; default: break;
$data['id'] = $iaLyric->add($data); } else { if (isset($_POST['delete_lyric'])) { $action = 'deleted'; $data['id'] = 0; $iaLyric->delete('`id` = ' . $lyric['id']); } else { $action = 'updated'; $data['id'] = $lyric['id']; $iaLyric->update($data); } } if (!$error) { $messages[] = _t('lyric_' . $action . $dmsg); iaUtil::redirect(_t('thanks'), $messages, $iaLyric->url('view', $data)); } } if (isset($_POST['ajax'])) { header('Content-type: text/xml'); echo '<?xml version="1.0" encoding="' . $iaCore->get('charset') . '" ?>' . '<root><error>' . $error . '</error><msg><![CDATA[<li>' . implode('</li><li>', $messages) . ']]></msg></root>'; exit; } } $itemInfo = false; $sections = iaField::getAcoGroupsFields(false, 'lyrics', '', $itemInfo); $iaView->assign('sections', $sections); $iaView->assign('fields', $fields); $iaView->assign('error_fields', $errorFields); $iaView->assign('item', $lyric); $iaView->display('manage'); }