/**
* Custom install method
*
* @param null|string $fromDirectory Directory of plugin to install
* @param boolean $InstallIntoDatabaseOnly Install plugin database only
* @return boolean
*/
function install($fromDirectory = null, $InstallIntoDatabaseOnly = false)
{
global $_CB_framework, $_CB_database, $ueConfig, $_PLUGINS;
if (!$this->preInstallCheck($fromDirectory, $this->elementType)) {
return false;
}
$cbInstallXML = $this->i_xmldocument;
// Get name
$e = $cbInstallXML->getElementByPath('name');
$this->elementName($e->data());
$cleanedElementName = strtolower(str_replace(array(" ", "."), array("", "_"), $this->elementName()));
// Get plugin filename
$files_element = $cbInstallXML->getElementByPath('files');
$files_names = array();
foreach ($files_element->children() as $file) {
$files_names[] = $file->data();
if ($file->attributes("plugin")) {
$this->elementSpecial($file->attributes("plugin"));
}
}
$fileNopathNoext = null;
$matches = array();
if (preg_match("/^.*[\\/\\\\](.*)\\..*\$/", $this->installFilename(), $matches)) {
$fileNopathNoext = $matches[1];
}
if (!($fileNopathNoext && $this->elementSpecial() == $fileNopathNoext)) {
$this->setError(1, 'Installation filename `' . $fileNopathNoext . '` (with .xml) does not match main php file plugin attribute `' . $this->elementSpecial() . '` in the plugin xml file<br />');
return false;
}
$cleanedMainFileName = strtolower(str_replace(array(" ", "."), array("", "_"), $this->elementSpecial()));
// check version
$v = $cbInstallXML->getElementByPath('version');
$version = $v->data();
$THISCBVERSION = '2.0.14';
if ($version == $ueConfig['version'] || $version == $THISCBVERSION || version_compare($version, $ueConfig['version'], '<=') && version_compare($version, '1.0', '>=')) {
} else {
$this->setError(1, 'Plugin version (' . $version . ') different from Community Builder version (' . $ueConfig['version'] . ')');
return false;
}
// Check Dependencies
$dependencies = $cbInstallXML->getElementByPath('dependencies');
if ($dependencies !== false) {
foreach ($dependencies->children() as $dependency) {
$dependencyElement = $dependency->attributes('name');
$dependencyLabel = $dependency->attributes('label');
$dependencyVersions = $dependency->attributes('version');
if ($dependencyElement) {
$dependencyPlugin = new PluginTable();
$dependencyPlugin->load(array('element' => $dependencyElement));
if (!$dependencyPlugin->id) {
$this->setError(1, CBTxt::T('PLUGIN_DEPENDENCY_MISSING', 'Plugin dependency [dependency] is not installed.', array('[dependency]' => $dependencyLabel ? $dependencyLabel : $dependencyElement)));
return false;
}
if ($dependencyVersions) {
$dependencyVersions = explode(' ', $dependencyVersions);
$dependencyRelease = $_PLUGINS->getPluginVersion($dependencyPlugin->id, true);
$dependencyMatched = true;
foreach ($dependencyVersions as $dependencyVersion) {
if (preg_match('/^(>=|<=|!=|<>|>|<|=|)(.+)/', $dependencyVersion, $versionMatches)) {
$dependencyOperator = $versionMatches[1] ? $versionMatches[1] : '=';
if (!version_compare($dependencyRelease, $versionMatches[2], $dependencyOperator)) {
$dependencyMatched = false;
break;
}
}
}
if (!$dependencyMatched) {
$this->setError(1, CBTxt::T('PLUGIN_DEPENDENCY_MISSING_VERSION', 'Plugin dependency [dependency] [version] different from [dependency] [release].', array('[dependency]' => $dependencyLabel ? $dependencyLabel : $dependencyElement, '[version]' => implode(' ', $dependencyVersions), '[release]' => $dependencyRelease)));
return false;
}
}
}
}
}
$backendMenu = "";
$adminmenusnode = $cbInstallXML->getElementByPath('adminmenus');
if ($adminmenusnode !== false) {
$menusArr = array();
//cycle through each menu
foreach ($adminmenusnode->children() as $menu) {
if ($menu->getName() == "menu") {
$action = $menu->attributes('action');
$text = CBTxt::T($menu->data());
$menusArr[] = $text . ":" . $action;
}
}
$backendMenu = implode(",", $menusArr);
}
$folder = strtolower($cbInstallXML->attributes('group'));
if (cbStartOfStringMatch($folder, '/')) {
$this->elementDir($_CB_framework->getCfg('absolute_path') . $folder . '/');
$subFolder = $folder;
} else {
$subFolder = ($folder == 'user' ? 'plug_' : '') . $cleanedElementName;
$this->elementDir($_CB_framework->getCfg('absolute_path') . '/components/com_comprofiler/plugin/' . $folder . '/' . $subFolder . '/');
}
$upgradeMethod = $this->installMethod($cbInstallXML->attributes('method'));
if (file_exists($this->elementDir()) && !$upgradeMethod) {
$this->setError(1, 'Another plugin is already using directory: "' . $this->elementDir() . '"');
return false;
}
$parentFolder = preg_replace('/\\/[^\\/]*\\/?$/', '/', $this->elementDir());
if (!file_exists($parentFolder)) {
$this->setError(1, sprintf('The directory in which the plugin should install does not exist: probably the parent extension is not installed. Install parent extension first. Plugin parent directory missing: "%s" and plugin directory specified by installer for installation "%s"', $parentFolder, $this->elementDir()));
return false;
}
if (!$InstallIntoDatabaseOnly) {
if (!file_exists($this->elementDir()) && !$this->createDirectoriesForPath($this->elementDir())) {
$this->setError(1, 'Failed to create directory' . ' "' . $this->elementDir() . '"');
return false;
}
// Copy files from package:
if ($this->parseFiles('files', 'plugin', 'No file is marked as plugin file') === false) {
$this->cleanupInstall(null, $this->elementDir());
// try removing directory and content just created successfully
return false;
}
// Copy XML file from package (needed for creating fields of new types and so on):
if ($this->copySetupFile() === false) {
$this->cleanupInstall(null, $this->elementDir());
// try removing directory and content just created successfully
return false;
}
}
// Check to see if plugin already exists in db
$_CB_database->setQuery("SELECT id FROM #__comprofiler_plugin WHERE element = '" . $this->elementSpecial() . "' AND folder = '" . $subFolder . "'");
if (!$_CB_database->query()) {
$this->setError(1, 'SQL error' . ': ' . $_CB_database->getErrorMsg());
if (!$InstallIntoDatabaseOnly) {
$this->cleanupInstall(null, $this->elementDir());
// try removing directory and content just created successfully
}
return false;
}
$pluginId = $_CB_database->loadResult();
$pluginRowWasNotExisting = !$pluginId;
$row = new PluginTable();
if ($pluginId) {
$row->load((int) $pluginId);
}
if (!$row->id) {
$row->name = $this->elementName();
$row->ordering = 99;
$row->iscore = 0;
$row->viewaccesslevel = 1;
$row->client_id = 0;
$row->published = $folder == 'language' ? 1 : 0;
}
$row->type = $folder;
$row->folder = $subFolder;
$row->backend_menu = $backendMenu;
$row->element = $this->elementSpecial();
if (!$row->store()) {
$this->setError(1, 'SQL error' . ': ' . $row->getError());
if (!$InstallIntoDatabaseOnly) {
$this->cleanupInstall(null, $this->elementDir());
// try removing directory and content just created successfully
}
return false;
}
$pluginId = (int) $row->id;
$savePreviousPluginId = $_PLUGINS->_setLoading($row, true);
$sqlUpgrader = new DatabaseUpgrade(null, false);
$success = null;
// Are there any Database statements ??
$db = $cbInstallXML->getElementByPath('database');
if ($db !== false && count($db->children()) > 0) {
//$sqlUpgrader->setDryRun( true );
$success = $sqlUpgrader->checkXmlDatabaseDescription($db, $cleanedElementName, true, null, null);
/*
var_dump( $success );
echo "<br>\nERRORS: " . $sqlUpgrader->getErrors( "<br /><br />\n\n", "<br />\n" );
echo "<br>\nLOGS: " . $sqlUpgrader->getLogs( "<br /><br />\n\n", "<br />\n" );
exit;
*/
if (!$success) {
$this->setError(1, "Plugin database XML SQL Error " . $sqlUpgrader->getErrors());
if ($pluginRowWasNotExisting) {
$this->deleteTabAndFieldsOfPlugin($row->id);
// delete tabs and private fields of plugin
$row->delete();
}
if (!$InstallIntoDatabaseOnly) {
$this->cleanupInstall(null, $this->elementDir());
// try removing directory and content just created successfully
}
$_PLUGINS->_setLoading($row, $savePreviousPluginId);
return false;
}
}
$e = $cbInstallXML->getElementByPath('description');
$desc = $this->elementName();
if ($e !== false) {
$desc .= '<div>' . $e->data() . '</div>';
$this->setError(0, $desc);
}
//If type equals user then check for tabs and fields
if ($folder == 'user') {
$tabsnode = $cbInstallXML->getElementByPath('tabs');
if ($tabsnode !== false) {
//cycle through each tab
foreach ($tabsnode->children() as $tab) {
if ($tab->getName() == 'tab') {
//install each tab
$tabid = $this->installTab($pluginId, $tab);
if ($tabid) {
//get all fields in the tab
$fieldsnode = $tab->getElementByPath('fields');
if ($fieldsnode !== false) {
//cycle through each field
foreach ($fieldsnode->children() as $field) {
if ($field->getName() == "field") {
//install each field
//echo "installing field...";
$fieldid = $this->installField($pluginId, $tabid, $field);
//get all fieldvalues for the field
//cycle through each fieldValue
foreach ($field->children() as $fieldValue) {
if ($fieldValue->getName() == "fieldvalue") {
$this->installFieldValue($fieldid, $fieldValue);
}
}
}
}
}
} else {
if ($pluginRowWasNotExisting) {
if ($db) {
$sqlUpgrader->checkXmlDatabaseDescription($db, $cleanedElementName, 'drop', null, null);
}
$this->deleteTabAndFieldsOfPlugin($row->id);
// delete tabs and private fields of plugin
$row->delete();
}
if (!$InstallIntoDatabaseOnly) {
$this->cleanupInstall(null, $this->elementDir());
// try removing directory and content just created successfully
}
$_PLUGINS->_setLoading($row, $savePreviousPluginId);
return false;
}
}
}
}
// (re)install field types of plugin:
$fieldtypes = $cbInstallXML->getElementByPath('fieldtypes');
if ($fieldtypes !== false) {
foreach ($fieldtypes->children() as $typ) {
if ($typ->getName() == 'field') {
$this->installFieldType($pluginId, $typ->attributes('type'));
}
}
}
}
// Check if there are any files that need to be deleted:
$deleteElements = $cbInstallXML->getElementByPath('delete');
if ($deleteElements !== false) {
$adminFS = cbAdminFileSystem::getInstance();
foreach ($deleteElements->children() as $file) {
$filename = $file->data();
if ($adminFS->file_exists($this->i_elementdir . $filename) && !in_array($filename, $files_names)) {
if ($file->getName() == 'foldername') {
$adminFS->deldir(_cbPathName($this->i_elementdir . $filename . '/'));
} elseif ($file->getName() == 'filename') {
$adminFS->unlink(_cbPathName($this->i_elementdir . $filename, false));
}
}
}
}
// Are there any SQL queries??
$query_element = $cbInstallXML->getElementByPath('install/queries');
if ($query_element !== false) {
foreach ($query_element->children() as $query) {
$_CB_database->setQuery(trim($query->data()));
if (!$_CB_database->query()) {
$this->setError(1, "SQL Error " . $_CB_database->getErrorMsg());
if ($pluginRowWasNotExisting) {
if ($db) {
$sqlUpgrader->checkXmlDatabaseDescription($db, $cleanedElementName, 'drop', null, null);
}
$this->deleteTabAndFieldsOfPlugin($row->id);
// delete tabs and private fields of plugin
$row->delete();
}
if (!$InstallIntoDatabaseOnly) {
$this->cleanupInstall(null, $this->elementDir());
// try removing directory and content just created successfully
}
$_PLUGINS->_setLoading($row, $savePreviousPluginId);
return false;
}
}
}
// Are there any CBLib libraries ?
$libraries_element = $cbInstallXML->getElementByPath('libraries');
if ($libraries_element !== false) {
foreach ($libraries_element->children() as $library) {
if ($library->getName() != 'library') {
continue;
}
// Copy files from library package:
$savePackage = $this->i_xmldocument;
$subFolder = $library->attributes('name');
$saveElement = $this->elementDir();
$this->elementDir($_CB_framework->getCfg('absolute_path') . '/components/com_comprofiler/plugin/libraries/' . ($subFolder ? $subFolder . '/' : null));
$this->i_xmldocument = $library;
if (!file_exists($this->elementDir()) && !$this->createDirectoriesForPath($this->elementDir())) {
$this->setError(1, 'Failed to create directory' . ' "' . $this->elementDir() . '"');
$this->i_xmldocument = $savePackage;
$this->elementDir($saveElement);
$this->cleanupInstall(null, $this->elementDir());
// try removing directory and content just created successfully
return false;
}
if ($this->parseFiles('files') === false) {
$this->i_xmldocument = $savePackage;
$this->elementDir($saveElement);
$this->cleanupInstall(null, $this->elementDir());
// try removing directory and content just created successfully
return false;
}
$this->i_xmldocument = $savePackage;
$this->elementDir($saveElement);
}
}
// Is there an installfile
$installfile_elemet = $cbInstallXML->getElementByPath('installfile');
if ($installfile_elemet !== false) {
// check if parse files has already copied the install.component.php file (error in 3rd party xml's!)
if (!$InstallIntoDatabaseOnly && !file_exists($this->elementDir() . $installfile_elemet->data())) {
if (!$this->copyFiles($this->installDir(), $this->elementDir(), array(), array($installfile_elemet->data()), $this->installMethod())) {
$this->setError(1, 'Could not copy PHP install file.');
if ($pluginRowWasNotExisting) {
if ($db) {
$sqlUpgrader->checkXmlDatabaseDescription($db, $cleanedElementName, 'drop', null, null);
}
$this->deleteTabAndFieldsOfPlugin($row->id);
// delete tabs and private fields of plugin
$row->delete();
}
$this->cleanupInstall(null, $this->elementDir());
// try removing directory and content just created successfully
$_PLUGINS->_setLoading($row, $savePreviousPluginId);
return false;
}
}
$this->hasInstallFile(true);
$this->installFile($installfile_elemet->data());
}
// Is there an uninstallfile
$uninstallfile_elemet = $cbInstallXML->getElementByPath('uninstallfile');
if ($uninstallfile_elemet !== false) {
if (!$InstallIntoDatabaseOnly && !file_exists($this->elementDir() . $uninstallfile_elemet->data())) {
if (!$this->copyFiles($this->installDir(), $this->elementDir(), array(), array($uninstallfile_elemet->data(), $this->installMethod()))) {
$this->setError(1, 'Could not copy PHP uninstall file');
if ($pluginRowWasNotExisting) {
if ($db) {
$sqlUpgrader->checkXmlDatabaseDescription($db, $cleanedElementName, 'drop', null, null);
}
$this->deleteTabAndFieldsOfPlugin($row->id);
// delete tabs and private fields of plugin
$row->delete();
}
$this->cleanupInstall(null, $this->elementDir());
// try removing directory and content just created successfully
$_PLUGINS->_setLoading($row, $savePreviousPluginId);
return false;
}
}
}
self::cleanOpcodeCaches();
if ($this->hasInstallFile()) {
if (is_file($this->elementDir() . $this->installFile())) {
/** @noinspection PhpIncludeInspection */
require_once $this->elementDir() . $this->installFile();
$ret = call_user_func_array('plug_' . $cleanedMainFileName . '_install', array());
if ($ret != '') {
$this->setError(0, $desc . $ret);
}
}
}
if ($db !== false && count($db->children()) > 0) {
CBDatabaseChecker::renderDatabaseResults($sqlUpgrader, true, false, $success, array(), array(), $this->elementName(), 1, false);
}
$_PLUGINS->_setLoading($row, $savePreviousPluginId);
return true;
}
/**
* Saves the CB plugin view after an edit view form submit
*
* @param array $options
* @param array $actionPath
* @param array $keyValues
* @param array $parametersValues
* @param SimpleXMLElement $viewModel
* @param TableInterface $data
* @param RegistryEditController $params
* @param string $mode
* @param string $dataModelType
* @param PluginTable $plugin
* @param SimpleXMLElement $dataModel
* @param RegistryInterface $pluginParams
* @param string $cbprevstate
* @param int $ui
* @return null|string NULL: ok, STRING: error
*/
protected function savePluginView($options, $actionPath, $keyValues, $parametersValues, $viewModel, $data, $params, &$mode, $dataModelType, $plugin, $dataModel, $pluginParams, $cbprevstate, $ui)
{
global $_CB_framework;
new cbTabs(false, 2, -1, false);
// prevents output of CB tabs js code until we are done with drawing (or redirecting)
$resultingMsg = null;
cbSpoofCheck('plugin');
$postArray = $this->input->getNamespaceRegistry('post')->asArray();
// List of variables to exclude from the $postArray:
$exclude = array('option', 'cid', 'cbprevstate', cbSpoofField());
foreach ($actionPath as $k => $v) {
$exclude[] = $k;
}
// Remove the exclude variables from the $postArray before being used in the below cases:
foreach ($exclude as $v) {
if (isset($postArray[$v])) {
unset($postArray[$v]);
}
}
// Fix multi-selects and multi-checkboxes arrays to |*|-delimited strings:
$postArray = $this->recursiveMultiSelectFix($postArray);
foreach ($postArray as $key => $value) {
if (property_exists($data, $key)) {
$postArray[$key] = is_array($value) ? json_encode($value) : $value;
}
}
$errorMsg = null;
switch ($dataModelType) {
case 'sql:row':
if ($ui == 2) {
if (true !== ($error = RegistryEditView::validateAndBindPost($params, $postArray))) {
$errorMsg = $error;
break;
}
if (!$data->bind($postArray)) {
$errorMsg = $data->getError();
break;
}
} else {
RegistryEditView::setFieldsListArrayValues(true);
$fields = $params->draw(null, null, null, null, null, null, false, 'param', 'fieldsListArray');
// New CB2.0 way for bind():
foreach ($fields as $key => $value) {
if (property_exists($data, $key)) {
$data->{$key} = is_array($value) ? json_encode($value) : $value;
}
}
}
if (!$data->check()) {
$errorMsg = $data->getError();
break;
}
$dataModelKey = $data->getKeyName();
$dataModelValueOld = $data->{$dataModelKey};
if ($mode == 'savecopy') {
if (!$data->canCopy($data)) {
$errorMsg = $data->getError();
break;
}
if (!$data->copy($data)) {
$errorMsg = $data->getError();
break;
}
} else {
if (!$data->store()) {
$errorMsg = $data->getError();
break;
}
}
$dataModelValue = $data->{$dataModelKey};
// Id changed; be sure to update the url encase of redirect:
if (count($keyValues) == 1) {
$urlKeys = array_keys($keyValues);
$urlDataKey = $urlKeys[0];
if ($mode == 'savenew') {
unset($actionPath[$urlDataKey]);
} elseif ($dataModelValue != $dataModelValueOld) {
$actionPath[$urlDataKey] = $dataModelValue;
}
}
if ($data->hasFeature('checkout')) {
/** @var \CBLib\Database\Table\CheckedOrderedTable $data */
$data->checkin();
}
$this->savePluginViewOrder($data, $viewModel);
$resultingMsg = $data->cbResultOfStore();
break;
case 'sql:field':
// <data name="params" type="sql:field" table="#__cbsubs_config" class="cbpaidConfig" key="id" value="1" valuetype="sql:int" />
$dataModelName = $dataModel->attributes('name');
$dataModelKey = $dataModel->attributes('key');
$dataModelValue = $dataModel->attributes('value');
if ($ui == 2) {
if (true !== ($error = RegistryEditView::validateAndBindPost($params, $postArray))) {
$errorMsg = $error;
break;
}
}
$rawParams = array();
$rawParams[$dataModelName] = json_encode($postArray);
$xmlsql = new XmlQuery($this->db, null, $pluginParams);
$xmlsql->process_data($dataModel);
if ($dataModelValue) {
$result = $xmlsql->queryUpdate($rawParams);
} else {
$result = $xmlsql->queryInsert($rawParams, $dataModelKey);
}
if (!$result) {
$errorMsg = $xmlsql->getErrorMsg();
}
break;
case 'parameters':
if ($ui == 2) {
if (true !== ($error = RegistryEditView::validateAndBindPost($params, $postArray))) {
$errorMsg = $error;
break;
}
}
$rawParams = array();
$rawParams['params'] = json_encode($postArray);
// $plugin = new PluginTable( $this->_db );
// $plugin->load( $pluginId );
if (!$plugin->bind($rawParams)) {
$errorMsg = $plugin->getError();
break;
}
if (!$plugin->check()) {
$errorMsg = $plugin->getError();
break;
}
if (!$plugin->store()) {
$errorMsg = $plugin->getError();
break;
}
$plugin->checkin();
$plugin->updateOrder("type='" . $plugin->getDbo()->getEscaped($plugin->type) . "' AND ordering > -10000 AND ordering < 10000 ");
$resultingMsg = $plugin->cbResultOfStore();
break;
case 'class':
if ($ui == 2) {
if (true !== ($error = RegistryEditView::validateAndBindPost($params, $postArray))) {
$errorMsg = $error;
break;
}
}
if (!$data->bind($postArray)) {
$errorMsg = $data->getError();
break;
}
if (!$data->check()) {
$errorMsg = $data->getError();
break;
}
if (!$data->store()) {
$errorMsg = $data->getError();
break;
}
if ($data->hasFeature('checkout')) {
/** @var \CBLib\Database\Table\CheckedOrderedTable $data */
$data->checkin();
}
$this->savePluginViewOrder($data, $viewModel);
$resultingMsg = $data->cbResultOfStore();
break;
case 'sql:multiplerows':
default:
echo 'Save error: showview data type: ' . $dataModelType . ' not implemented !';
exit;
break;
}
if ($ui == 2) {
$url = 'index.php?option=' . $options['option'] . '&view=' . $options['view'];
if ($options['view'] == 'editPlugin') {
$url .= '&cid=' . $options['pluginid'];
}
$url = $_CB_framework->backendUrl($url);
} else {
$url = 'index.php';
if (count($options) > 0) {
$fixOptions = array();
foreach ($options as $k => $v) {
$fixOptions[$k] = $k . '=' . urlencode($v);
}
$url .= '?' . implode('&', $fixOptions);
}
}
if (isset($data->title)) {
$dataItem = CBTxt::T($data->title);
} elseif (isset($data->name)) {
$dataItem = CBTxt::T($data->name);
} else {
$dataItem = null;
}
if ($errorMsg) {
if (in_array($mode, array('save', 'savenew', 'savecopy'))) {
$mode = 'apply';
}
$msg = CBTxt::T('FAILED_TO_SAVE_LABEL_ITEM_BECAUSE_ERROR', 'Failed to save [label] [item] because: [error]', array('[label]' => $viewModel->attributes('label'), '[item]' => $dataItem, '[error]' => $errorMsg));
$msgType = 'error';
} else {
$msg = CBTxt::T('SUCCESSFULLY_SAVED_LABEL_ITEM', 'Successfully saved [label] [item]', array('[label]' => $viewModel->attributes('label'), '[item]' => $dataItem));
$msgType = 'message';
}
switch ($mode) {
case 'apply':
case 'savenew':
case 'savecopy':
unset($actionPath['view']);
foreach ($actionPath as $k => $v) {
if ($v !== '') {
$url .= '&' . $k . '=' . $v;
}
}
foreach ($parametersValues as $k => $v) {
$url .= '&' . $k . '=' . $v;
}
if ($cbprevstate) {
$url .= '&cbprevstate=' . $cbprevstate;
}
break;
case 'save':
if ($cbprevstate) {
$prevUrl = base64_decode($cbprevstate);
// $parametersValues[] = "'" . base64_encode( implode( '&', $cbprevstate ) ) . "'";
if (!preg_match('$[:/]$', $prevUrl)) {
$prevUrl = str_replace('&pluginid=', '&cid=', $prevUrl);
if ($ui == 2) {
$url = $_CB_framework->backendUrl('index.php?' . $prevUrl);
} else {
$url = 'index.php?' . $prevUrl;
}
}
}
break;
}
if ($resultingMsg) {
if ($ui != 2) {
return $resultingMsg;
// in frontend, for now, don't redirect here: think this is right !
} else {
// If not an apply then change it to an apply so we can redisplay the view with the resulting message above it:
if (in_array($mode, array('save', 'savenew', 'savecopy'))) {
$mode = 'apply';
}
echo $resultingMsg;
}
} else {
if ($ui != 2) {
return null;
// in frontend, for now, don't redirect here: think this is right !
// $url = cbUnHtmlspecialchars( cbSef( $url ) );
}
if ($mode == 'apply' && $errorMsg) {
$_CB_framework->enqueueMessage($msg, $msgType);
} else {
cbRedirect($ui == 2 ? $url : cbSef(htmlspecialchars($url), false), $msg, $msgType);
}
}
return null;
}
function cbInstaller_install_plugins(&$return)
{
global $_CB_framework, $_CB_adminpath, $ueConfig;
cbimport('cb.adminfilesystem');
cbimport('cb.installer');
$cbDatabase = \CBLib\Application\Application::Database();
// List of core plugins that are no longer core, but we just want to disable core status and not remove as they don't conflict:
$deprecated = array('bootstrap', 'winclassic', 'webfx', 'osx', 'luna', 'dark', 'yanc', 'cb.mamblogtab', 'cb.simpleboardtab', 'cb.authortab');
foreach ($deprecated as $pluginElement) {
$plugin = new PluginTable();
if ($plugin->load(array('element' => $pluginElement))) {
$query = "UPDATE " . $cbDatabase->NameQuote('#__comprofiler_plugin') . "\n SET " . $cbDatabase->NameQuote('iscore') . " = 0" . "\n WHERE " . $cbDatabase->NameQuote('id') . " = " . (int) $plugin->id;
$cbDatabase->setQuery($query);
if (!$cbDatabase->query()) {
$return .= '<div style="font-size:14px;color:red;margin-bottom:10px;">' . CBTxt::P('Plugin [element] failed to deprecate. Please run Tools > Check Community Builder Database to reattempt.', array('[element]' => $pluginElement)) . '</div>';
}
$query = "UPDATE " . $cbDatabase->NameQuote('#__comprofiler_tabs') . "\n SET " . $cbDatabase->NameQuote('sys') . " = 0" . "\n WHERE " . $cbDatabase->NameQuote('pluginid') . " = " . (int) $plugin->id;
$cbDatabase->setQuery($query);
if (!$cbDatabase->query()) {
$return .= '<div style="font-size:14px;color:red;margin-bottom:10px;">' . CBTxt::P('Plugin [element] tabs failed to deprecate. Please run Tools > Check Community Builder Database to reattempt.', array('[element]' => $pluginElement)) . '</div>';
}
$query = "UPDATE " . $cbDatabase->NameQuote('#__comprofiler_fields') . "\n SET " . $cbDatabase->NameQuote('sys') . " = 0" . "\n WHERE " . $cbDatabase->NameQuote('pluginid') . " = " . (int) $plugin->id;
$cbDatabase->setQuery($query);
if (!$cbDatabase->query()) {
$return .= '<div style="font-size:14px;color:red;margin-bottom:10px;">' . CBTxt::P('Plugin [element] fields failed to deprecate. Please run Tools > Check Community Builder Database to reattempt.', array('[element]' => $pluginElement)) . '</div>';
}
}
}
// List of plugins that conflict with the core that need to be removed (normally due to being merged into core):
$conflicted = array('bootstrap', 'winclassic', 'webfx', 'osx', 'luna', 'dark', 'yanc', 'cb.mamblogtab', 'cb.authortab', 'cbvideofield', 'cb.filefield');
foreach ($conflicted as $pluginElement) {
$plugin = new PluginTable();
if ($plugin->load(array('element' => $pluginElement))) {
if (!cbInstaller_uninstall_plugin($plugin, $return)) {
return false;
}
}
}
// Ensure Default template, CB Core, and language plugins are published as they are not allowed to be unpublished:
$query = "UPDATE " . $cbDatabase->NameQuote('#__comprofiler_plugin') . "\n SET " . $cbDatabase->NameQuote('published') . " = 1" . "\n WHERE ( " . $cbDatabase->NameQuote('id') . " IN " . $cbDatabase->safeArrayOfIntegers(array(1, 7)) . ' OR ' . $cbDatabase->NameQuote('type') . ' = ' . $cbDatabase->quote('language') . ' )';
$cbDatabase->setQuery($query);
$cbDatabase->query();
$pluginsFile = $_CB_adminpath . 'pluginsfiles.tgz';
// We need to ensure the core plugins archive actually exists before doing anything with it:
if (!file_exists($pluginsFile)) {
$return .= '<div style="font-size:14px;color:red;margin-bottom:10px;">' . CBTxt::P('Core plugins archive [path] missing.', array('[path]' => $pluginsFile)) . '</div>';
return false;
}
// We need zlib to unzip packages so lets check that it exists:
if (!extension_loaded('zlib')) {
$return .= '<div style="font-size:14px;color:red;margin-bottom:10px;">' . CBTxt::T('Core plugins can not be installed as zlib is not installed.') . '</div>';
return false;
}
$installer = new cbInstallerPlugin();
// Uncompress the core plugins so we can install them:
if (!$installer->upload($pluginsFile, true, false)) {
$return .= '<div style="font-size:14px;color:red;margin-bottom:10px;">' . CBTxt::P('Core plugins can not be installed as uncompressing [path] failed.', array('[path]' => $pluginsFile)) . '</div>';
return false;
}
$adminFS = cbAdminFileSystem::getInstance();
$baseDir = $_CB_framework->getCfg('absolute_path') . '/components/com_comprofiler';
// Create the base plugin directory:
if (!$adminFS->is_dir($baseDir . '/plugin')) {
if (!$adminFS->mkdir($baseDir . '/plugin')) {
$return .= '<div style="font-size:14px;color:red;margin-bottom:10px;">' . CBTxt::P('Failed to create directory [path].', array('[path]' => $baseDir . '/plugin')) . '</div>';
return false;
}
if (!$adminFS->copy($baseDir . '/index.html', $baseDir . '/plugin/index.html')) {
$return .= '<div style="font-size:14px;color:red;margin-bottom:10px;">' . CBTxt::P('Failed to create index [path].', array('[path]' => $baseDir . '/plugin/index.html')) . '</div>';
return false;
}
}
// Create the language template directory:
if (!$adminFS->is_dir($baseDir . '/plugin/language')) {
if (!$adminFS->mkdir($baseDir . '/plugin/language')) {
$return .= '<div style="font-size:14px;color:red;margin-bottom:10px;">' . CBTxt::P('Failed to create directory [path].', array('[path]' => $baseDir . '/plugin/language')) . '</div>';
return false;
}
if (!$adminFS->copy($baseDir . '/index.html', $baseDir . '/plugin/language/index.html')) {
$return .= '<div style="font-size:14px;color:red;margin-bottom:10px;">' . CBTxt::P('Failed to create index [path].', array('[path]' => $baseDir . '/plugin/language/index.html')) . '</div>';
return false;
}
}
// Create the template plugin directory:
if (!$adminFS->is_dir($baseDir . '/plugin/templates')) {
if (!$adminFS->mkdir($baseDir . '/plugin/templates')) {
$return .= '<div style="font-size:14px;color:red;margin-bottom:10px;">' . CBTxt::P('Failed to create directory [path].', array('[path]' => $baseDir . '/plugin/templates')) . '</div>';
return false;
}
if (!$adminFS->copy($baseDir . '/index.html', $baseDir . '/plugin/templates/index.html')) {
$return .= '<div style="font-size:14px;color:red;margin-bottom:10px;">' . CBTxt::P('Failed to create index [path].', array('[path]' => $baseDir . '/plugin/templates/index.html')) . '</div>';
return false;
}
}
// Create the user plugin directory:
if (!$adminFS->is_dir($baseDir . '/plugin/user')) {
if (!$adminFS->mkdir($baseDir . '/plugin/user')) {
$return .= '<div style="font-size:14px;color:red;margin-bottom:10px;">' . CBTxt::P('Failed to create directory [path].', array('[path]' => $baseDir . '/plugin/user')) . '</div>';
return false;
}
if (!$adminFS->copy($baseDir . '/index.html', $baseDir . '/plugin/user/index.html')) {
$return .= '<div style="font-size:14px;color:red;margin-bottom:10px;">' . CBTxt::P('Failed to create index [path].', array('[path]' => $baseDir . '/plugin/user/index.html')) . '</div>';
return false;
}
}
// Install core plugins 1 by 1 silently:
$installFrom = $installer->installDir();
$filesList = cbReadDirectory($installFrom, '.', true);
foreach ($filesList as $file) {
if (preg_match('/^.+\\.xml$/i', $file)) {
$plgPath = $installFrom . (substr($installFrom, -1, 1) == '/' ? '' : '/') . $file;
$plgXml = new SimpleXMLElement(trim(file_get_contents($plgPath)));
if ($plgXml->getName() == 'cbinstall') {
$plgDir = dirname($plgPath) . '/';
ob_start();
$plgInstaller = new cbInstallerPlugin();
$installed = $plgInstaller->install($plgDir);
ob_end_clean();
if (!$installed) {
$return .= '<div style="font-size:14px;color:red;margin-bottom:10px;">' . CBTxt::P('Installing core plugin [plugin] failed with error [error].', array('[plugin]' => $plgInstaller->i_elementname ? $plgInstaller->i_elementname : $file, '[error]' => $plgInstaller->getError())) . '</div>';
return false;
}
}
}
}
// Delete the expanded core plugins archive:
$result = $adminFS->deldir(_cbPathName($installFrom . '/'));
if ($result === false) {
$return .= '<div style="font-size:14px;color:red;margin-bottom:10px;">' . CBTxt::T('Deleting expanded core plugins archive failed.') . '</div>';
}
// Delete the core plugins archive:
$result = $adminFS->unlink(_cbPathName($pluginsFile, false));
if ($result === false) {
$return .= '<div style="font-size:14px;color:red;margin-bottom:10px;">' . CBTxt::P('Deleting core plugins archive [path] failed.', array('[path]' => $pluginsFile)) . '</div>';
}
// Sets the as ready so config can actually load this time:
\CB\Application\CBConfig::setCbConfigReadyToLoad(true);
// Load the config now that the tables exist encase they didn't during install:
\CB\Application\CBConfig::loadLegacyCBueConfig();
// Migrate old file based configuration to database based configuration:
$newConfig = null;
if ($adminFS->file_exists($_CB_adminpath . 'ue_config.php')) {
/** @noinspection PhpIncludeInspection */
include_once $_CB_adminpath . 'ue_config.php';
// Reset the template back to default if upgrading from a 1.x install:
$ueConfig['templatedir'] = 'default';
$newConfig = json_encode($ueConfig);
}
// Convert CB 1.x nesttabs into new nested tab display mode if needed:
if (isset($ueConfig['nesttabs'])) {
// Update all the tabs that would have normally auto-nested and make them nested displays
$query = 'UPDATE ' . $cbDatabase->NameQuote('#__comprofiler_tabs') . "\n SET " . $cbDatabase->NameQuote('displaytype') . " = " . $cbDatabase->Quote('nested') . "\n WHERE " . $cbDatabase->NameQuote('displaytype') . " = " . $cbDatabase->Quote('tab') . "\n AND " . $cbDatabase->NameQuote('fields') . " = 1" . "\n AND ( ( " . $cbDatabase->NameQuote('pluginclass') . " IS NULL )" . ' OR ( ' . $cbDatabase->NameQuote('sys') . ' = 2 ) )';
$cbDatabase->setQuery($query);
$cbDatabase->query();
unset($ueConfig['nesttabs']);
$newConfig = json_encode($ueConfig);
}
// Migrate global avatar params to field params:
if (isset($ueConfig['allowAvatar']) || isset($ueConfig['defaultAvatar']) || isset($ueConfig['defaultPendingAvatar']) || isset($ueConfig['allowAvatarGallery'])) {
$field = new FieldTable();
if ($field->load(array('name' => 'avatar'))) {
$fieldParams = new Registry($field->params);
if (isset($ueConfig['allowAvatar'])) {
$fieldParams->set('image_allow_uploads', (int) $ueConfig['allowAvatar']);
unset($ueConfig['allowAvatar']);
}
if (isset($ueConfig['defaultAvatar'])) {
$fieldParams->set('defaultAvatar', $ueConfig['defaultAvatar']);
unset($ueConfig['defaultAvatar']);
}
if (isset($ueConfig['defaultPendingAvatar'])) {
$fieldParams->set('defaultPendingAvatar', $ueConfig['defaultPendingAvatar']);
unset($ueConfig['defaultPendingAvatar']);
}
if (isset($ueConfig['allowAvatarGallery'])) {
$fieldParams->set('image_allow_gallery', (int) $ueConfig['allowAvatarGallery']);
unset($ueConfig['allowAvatarGallery']);
}
$field->set('params', $fieldParams->asJson());
if (!$field->store()) {
$return .= '<div style="font-size:14px;color:red;margin-bottom:10px;">' . CBTxt::P('Field [name] failed to migrate. Error: [error]', array('[name]' => $field->name, '[error]' => $field->getError())) . '</div>';
}
}
$newConfig = json_encode($ueConfig);
}
// Migrate global email ajax checker to field specific param:
if (isset($ueConfig['reg_email_checker'])) {
$field = new FieldTable();
if ($field->load(array('name' => 'email'))) {
$fieldParams = new Registry($field->params);
$fieldParams->set('field_check_email', (string) $ueConfig['reg_email_checker']);
$field->set('params', $fieldParams->asJson());
if (!$field->store()) {
$return .= '<div style="font-size:14px;color:red;margin-bottom:10px;">' . CBTxt::P('Field [name] failed to migrate. Error: [error]', array('[name]' => $field->name, '[error]' => $field->getError())) . '</div>';
}
}
unset($ueConfig['reg_email_checker']);
$newConfig = json_encode($ueConfig);
}
// Migrate global image params to field params:
if (isset($ueConfig['allowAvatarUpload'])) {
$query = 'SELECT *' . "\n FROM " . $cbDatabase->NameQuote('#__comprofiler_fields') . "\n WHERE " . $cbDatabase->NameQuote('name') . " != " . $cbDatabase->Quote('avatar') . "\n AND " . $cbDatabase->NameQuote('type') . " = " . $cbDatabase->Quote('image');
$cbDatabase->setQuery($query);
$fields = $cbDatabase->loadObjectList(null, '\\CB\\Database\\Table\\FieldTable', array($cbDatabase));
/** @var $fields FieldTable[] */
foreach ($fields as $field) {
$fieldParams = new Registry($field->params);
$fieldParams->set('image_allow_uploads', (int) $ueConfig['allowAvatarUpload']);
$field->set('params', $fieldParams->asJson());
if (!$field->store()) {
$return .= '<div style="font-size:14px;color:red;margin-bottom:10px;">' . CBTxt::P('Field [name] failed to migrate. Error: [error]', array('[name]' => $field->name, '[error]' => $field->getError())) . '</div>';
}
}
unset($ueConfig['allowAvatarUpload']);
$newConfig = json_encode($ueConfig);
}
// Convert CB 1.x allow_profileviewbyGID into new profile_viewaccesslevel if needed:
if (isset($ueConfig['allow_profileviewbyGID']) && !isset($ueConfig['profile_viewaccesslevel'])) {
$ueConfig['profile_viewaccesslevel'] = \CBLib\Application\Application::CmsPermissions()->convertOldGroupToViewAccessLevel($ueConfig['allow_profileviewbyGID'], 'CB Profiles access');
unset($ueConfig['allow_profileviewbyGID']);
$newConfig = json_encode($ueConfig);
}
// Convert CB 1.x allow_profileviewbyGID into new profile_viewaccesslevel if needed:
if (isset($ueConfig['imageApproverGid']) && !isset($ueConfig['moderator_viewaccesslevel'])) {
$ueConfig['moderator_viewaccesslevel'] = \CBLib\Application\Application::CmsPermissions()->convertOldGroupToViewAccessLevel($ueConfig['imageApproverGid'], 'CB Moderators access');
unset($ueConfig['imageApproverGid']);
$newConfig = json_encode($ueConfig);
}
// If old configuration for terms and conditions exists we need to pass it to the terms and conditions field:
if (isset($ueConfig['reg_enable_toc']) && isset($ueConfig['reg_toc_url'])) {
if ($ueConfig['reg_enable_toc'] == 1 && $ueConfig['reg_toc_url'] != '') {
$field = new FieldTable();
if ($field->load(array('name' => 'acceptedterms'))) {
$fieldParams = new Registry($field->params);
if ($fieldParams->get('terms_url') == '') {
$fieldParams->set('terms_url', $ueConfig['reg_toc_url']);
$field->set('required', 1);
$field->set('registration', 1);
$field->set('edit', 1);
$field->set('params', $fieldParams->asJson());
if (!$field->store()) {
$return .= '<div style="font-size:14px;color:red;margin-bottom:10px;">' . CBTxt::P('Field [name] failed to migrate. Error: [error]', array('[name]' => $field->name, '[error]' => $field->getError())) . '</div>';
}
}
}
}
unset($ueConfig['reg_enable_toc']);
unset($ueConfig['reg_toc_url']);
$newConfig = json_encode($ueConfig);
}
// If old configuration for userlists exists we need to pass it to the userlist it self:
if (isset($ueConfig['num_per_page']) && isset($ueConfig['allow_profilelink'])) {
if ($ueConfig['num_per_page'] != '' || $ueConfig['allow_profilelink'] != 1) {
$query = 'SELECT *' . "\n FROM " . $cbDatabase->NameQuote('#__comprofiler_lists');
$cbDatabase->setQuery($query);
$lists = $cbDatabase->loadObjectList(null, '\\CB\\Database\\Table\\ListTable', array($cbDatabase));
/** @var $lists ListTable[] */
foreach ($lists as $list) {
$listParams = new Registry($list->params);
$changed = false;
if ($ueConfig['num_per_page'] != '' && $listParams->get('list_limit') == '') {
$listParams->set('list_limit', $ueConfig['num_per_page']);
$changed = true;
}
if ($ueConfig['allow_profilelink'] != 1 && $listParams->get('allow_profilelink') == '') {
$listParams->set('allow_profilelink', $ueConfig['allow_profilelink']);
$changed = true;
}
if ($changed) {
$list->set('params', $listParams->asJson());
if (!$list->store()) {
$return .= '<div style="font-size:14px;color:red;margin-bottom:10px;">' . CBTxt::P('Userlist [title] failed to migrate. Error: [error]', array('[name]' => $list->title, '[error]' => $list->getError())) . '</div>';
}
}
}
}
unset($ueConfig['num_per_page']);
unset($ueConfig['allow_profilelink']);
$newConfig = json_encode($ueConfig);
}
// Establish default for any missing config params:
$configXml = new SimpleXMLElement(trim(file_get_contents($_CB_adminpath . 'xmlcb/views/view.com_comprofiler.editconfig.xml')));
if ($configXml) {
$configXmlParams = $configXml->xpath('//param');
if ($configXmlParams) {
$configXmlSet = false;
foreach ($configXmlParams as $configXmlParam) {
$k = (string) $configXmlParam->attributes('name');
if (!isset($ueConfig[$k])) {
$v = (string) $configXmlParam->attributes('default');
if ($k) {
$ueConfig[$k] = $v;
$configXmlSet = true;
}
}
}
if ($configXmlSet) {
$newConfig = json_encode($ueConfig);
}
}
}
// Update cb.core with the new cb config:
if ($newConfig) {
$query = "UPDATE " . $cbDatabase->NameQuote('#__comprofiler_plugin') . "\n SET " . $cbDatabase->NameQuote('params') . " = " . $cbDatabase->Quote($newConfig) . "\n WHERE " . $cbDatabase->NameQuote('id') . " = 1";
$cbDatabase->setQuery($query);
if (!$cbDatabase->query()) {
$_CB_framework->enqueueMessage(CBTxt::P('Failed to update configuration params in database. Error: [error]', array('[error]' => $cbDatabase->getErrorMsg())), 'error');
return false;
}
}
// Remove the old config file if it exists as we migrated above already:
if ($adminFS->file_exists($_CB_adminpath . 'ue_config.php')) {
$adminFS->unlink($_CB_adminpath . 'ue_config.php');
}
// Migrate old userlist columns to new usage:
$tableFields = $cbDatabase->getTableFields('#__comprofiler_lists');
if (isset($tableFields['#__comprofiler_lists'])) {
$userListFields = array_keys($tableFields['#__comprofiler_lists']);
$userListOldFields = array('useraccessgroupid', 'sortfields', 'filterfields', 'col1title', 'col1enabled', 'col1fields', 'col1captions', 'col2title', 'col2enabled', 'col2fields', 'col2captions', 'col3title', 'col3enabled', 'col3fields', 'col3captions', 'col4title', 'col4enabled', 'col4fields', 'col4captions');
// At least 1 legacy column still exists so lets begin migration of userlists:
if (array_intersect($userListOldFields, $userListFields)) {
$query = 'SELECT *' . "\n FROM " . $cbDatabase->NameQuote('#__comprofiler_lists');
$cbDatabase->setQuery($query);
$lists = $cbDatabase->loadObjectList(null, '\\CB\\Database\\Table\\ListTable', array($cbDatabase));
/** @var $lists ListTable[] */
foreach ($lists as $list) {
$listParams = new Registry($list->params);
$listSorting = array();
$listSortFields = $list->get('sortfields') ? explode(', ', str_replace('`', '', $list->get('sortfields'))) : array();
$paramsChanged = false;
foreach ($listSortFields as $listSortField) {
$sortParts = explode(' ', $listSortField);
$sortField = isset($sortParts[0]) ? trim($sortParts[0]) : null;
if ($sortField) {
$sortDirection = isset($sortParts[1]) ? trim($sortParts[1]) : 'ASC';
$listSorting[] = array('column' => $sortField, 'direction' => $sortDirection);
}
}
if ($listSorting) {
$paramsChanged = true;
$listParams->set('sort_mode', '0');
$listParams->set('basic_sort', $listSorting);
}
$listFilterFields = $list->get('filterfields');
if ($listFilterFields) {
$filterType = substr($listFilterFields, 0, 1);
$listFilterFields = rawurldecode(substr($listFilterFields, 2, -1));
if ($filterType == 'a') {
$paramsChanged = true;
$listParams->set('filter_mode', '1');
$listParams->set('filter_advanced', $listFilterFields);
} else {
$listFilters = array();
$basicFilters = explode(' AND ', $listFilterFields);
foreach ($basicFilters as $basicFilter) {
if (preg_match('/`(.+)`\\s*(.+)\\s*\'(.*)\'|`(.+)`\\s*(.+)/i', $basicFilter, $matches)) {
$filterField = isset($filterParts[1]) ? $filterParts[1] : (isset($filterParts[4]) ? $filterParts[4] : null);
$filterOperator = isset($filterParts[2]) ? $filterParts[2] : (isset($filterParts[5]) ? $filterParts[5] : null);
$filterVal = isset($filterParts[3]) ? $filterParts[3] : '';
switch ($filterOperator) {
case '!=':
$filterOperator = '<>||ISNULL';
break;
case 'IS NULL':
case "= ''":
$filterOperator = '=';
$filterVal = '';
break;
case 'IS NOT NULL':
case "!= ''":
$filterOperator = '!=';
$filterVal = '';
break;
}
if ($filterField && $filterOperator) {
$listFilters[] = array('column' => $filterField, 'operator' => $filterOperator, 'value' => $filterVal);
}
}
}
if ($listFilters) {
$paramsChanged = true;
$listParams->set('filter_mode', '0');
$listParams->set('filter_basic', $listFilters);
}
}
}
$listColumns = array();
for ($i = 1, $n = 4; $i <= $n; $i++) {
if ($list->get('col' . $i . 'enabled')) {
$columnTitle = $list->get('col' . $i . 'title', '');
$columnCaptions = (int) $list->get('col' . $i . 'captions', 0);
$columnFields = $list->get('col' . $i . 'fields') ? explode('|*|', $list->get('col' . $i . 'fields')) : array();
$listFields = array();
foreach ($columnFields as $columnField) {
$listFields[] = array('field' => (string) $columnField, 'display' => $columnCaptions ? '1' : '4');
}
if ($listFields) {
$listColumns[] = array('title' => $columnTitle, 'size' => '3', 'cssclass' => '', 'fields' => $listFields);
}
}
}
if ($listColumns) {
$paramsChanged = true;
$listParams->set('columns', $listColumns);
}
if ($paramsChanged || $list->get('usergroupids')) {
$list->set('usergroupids', implode('|*|', explode(', ', $list->get('usergroupids'))));
$list->set('params', $listParams->asJson());
if (!$list->store()) {
$return .= '<div style="font-size:14px;color:red;margin-bottom:10px;">' . CBTxt::P('Userlist [title] failed to migrate. Error: [error]', array('[name]' => $list->title, '[error]' => $list->getError())) . '</div>';
}
}
}
$userListDrop = array();
foreach ($userListOldFields as $userListOldField) {
if (in_array($userListOldField, $userListFields)) {
$userListDrop[] = $cbDatabase->NameQuote($userListOldField);
}
}
if ($userListDrop) {
$query = 'ALTER TABLE ' . $cbDatabase->NameQuote('#__comprofiler_lists') . "\n DROP " . implode(', DROP ', $userListDrop);
$cbDatabase->setQuery($query);
$cbDatabase->query();
}
}
}
// Migrates password strength parameters:
$plugin = new PluginTable();
if ($plugin->load(array('element' => 'cbpasswordstrength'))) {
$query = "SELECT *" . "\n FROM " . $cbDatabase->NameQuote('#__comprofiler_fields') . "\n WHERE " . $cbDatabase->NameQuote('type') . " = " . $cbDatabase->Quote('password');
$cbDatabase->setQuery($query);
$fields = $cbDatabase->loadObjectList(null, '\\CB\\Database\\Table\\FieldTable', array($cbDatabase));
/** @var $fields FieldTable[] */
foreach ($fields as $field) {
$fieldParams = new Registry($field->params);
$fieldParams->set('passTestSrength', (string) $fieldParams->get('pswstr_display', 1));
$field->set('params', $fieldParams->asJson());
if (!$field->store()) {
$return .= '<div style="font-size:14px;color:red;margin-bottom:10px;">' . CBTxt::P('Field [name] failed to migrate. Error: [error]', array('[name]' => $field->name, '[error]' => $field->getError())) . '</div>';
}
}
if (!cbInstaller_uninstall_plugin($plugin, $return)) {
return false;
}
}
// Migrates ajax points field parameters:
$plugin = new PluginTable();
if ($plugin->load(array('element' => 'cbajaxpointsfield'))) {
$query = "SELECT *" . "\n FROM " . $cbDatabase->NameQuote('#__comprofiler_fields') . "\n WHERE " . $cbDatabase->NameQuote('type') . " = " . $cbDatabase->Quote('ajaxpoints');
$cbDatabase->setQuery($query);
$fields = $cbDatabase->loadObjectList(null, '\\CB\\Database\\Table\\FieldTable', array($cbDatabase));
/** @var $fields FieldTable[] */
foreach ($fields as $field) {
$fieldParams = new Registry($field->params);
switch ((int) $fieldParams->get('ajax_layout', 1)) {
case 1:
$fieldParams->set('points_layout', '[minus] [value] [plus]');
break;
case 2:
$fieldParams->set('points_layout', '[plus] [value] [minus]');
break;
case 3:
$fieldParams->set('points_layout', '[value] [minus][plus]');
break;
case 4:
$fieldParams->set('points_layout', '[value] [plus][minus]');
break;
case 5:
$fieldParams->set('points_layout', '[minus][plus] [value]');
break;
case 6:
$fieldParams->set('points_layout', '[plus][minus] [value]');
break;
}
$fieldParams->set('points_inc_plus', (string) $fieldParams->get('ajax_increment_up', 1));
$fieldParams->set('points_inc_minus', (string) $fieldParams->get('ajax_increment_down', 1));
$fieldParams->set('points_access', '8');
$fieldParams->set('points_access_custom', (string) $fieldParams->get('ajax_access', 0));
$field->set('type', 'points');
$field->set('pluginid', 1);
$field->set('params', $fieldParams->asJson());
if (!$field->store()) {
$return .= '<div style="font-size:14px;color:red;margin-bottom:10px;">' . CBTxt::P('Field [name] failed to migrate. Error: [error]', array('[name]' => $field->name, '[error]' => $field->getError())) . '</div>';
}
}
if (!cbInstaller_uninstall_plugin($plugin, $return)) {
return false;
}
}
// Migrates rating field parameters:
$plugin = new PluginTable();
if ($plugin->load(array('element' => 'ratingfield'))) {
$query = "SELECT *" . "\n FROM " . $cbDatabase->NameQuote('#__comprofiler_fields') . "\n WHERE " . $cbDatabase->NameQuote('type') . " IN " . $cbDatabase->safeArrayOfStrings(array('myrating', 'yourrating'));
$cbDatabase->setQuery($query);
$fields = $cbDatabase->loadObjectList(null, '\\CB\\Database\\Table\\FieldTable', array($cbDatabase));
/** @var $fields FieldTable[] */
foreach ($fields as $field) {
$fieldParams = new Registry($field->params);
if ($field->type == 'myrating') {
$fieldParams->set('rating_access', '2');
} else {
if ($fieldParams->get('AllowAnnonymous', 1)) {
$fieldParams->set('rating_access', '3');
} else {
$fieldParams->set('rating_access', '4');
$fieldParams->set('rating_access_exclude', '1');
}
}
$fieldParams->set('rating_number', (string) $fieldParams->get('NumStars', 5));
switch ((int) $fieldParams->get('RatingFraction', 1)) {
case 1:
$fieldParams->set('rating_step', '1');
break;
case 2:
$fieldParams->set('rating_step', '0.5');
break;
case 3:
$fieldParams->set('rating_step', '0.33');
break;
case 4:
$fieldParams->set('rating_step', '0.25');
break;
}
$field->set('type', 'rating');
$field->set('pluginid', 1);
$field->set('params', $fieldParams->asJson());
if (!$field->store()) {
$return .= '<div style="font-size:14px;color:red;margin-bottom:10px;">' . CBTxt::P('Field [name] failed to migrate. Error: [error]', array('[name]' => $field->name, '[error]' => $field->getError())) . '</div>';
}
}
if (!cbInstaller_uninstall_plugin($plugin, $return)) {
return false;
}
}
// Migrates verify email field parameters:
$plugin = new PluginTable();
if ($plugin->load(array('element' => 'cbverifyemail'))) {
$query = "SELECT *" . "\n FROM " . $cbDatabase->NameQuote('#__comprofiler_fields') . "\n WHERE " . $cbDatabase->NameQuote('type') . " IN " . $cbDatabase->safeArrayOfStrings(array('emailaddress', 'primaryemailaddress'));
$cbDatabase->setQuery($query);
$fields = $cbDatabase->loadObjectList(null, '\\CB\\Database\\Table\\FieldTable', array($cbDatabase));
/** @var $fields FieldTable[] */
foreach ($fields as $field) {
$fieldParams = new Registry($field->params);
$fieldParams->set('fieldVerifyInput', $fieldParams->get('verifyemail_display_reg', 1) || $fieldParams->get('verifyemail_display_edit', 0) ? '1' : '0');
$fieldParams->set('verifyEmailTitle', $fieldParams->get('verifyemail_title', '_UE_VERIFY_SOMETHING'));
$field->set('params', $fieldParams->asJson());
if (!$field->store()) {
$return .= '<div style="font-size:14px;color:red;margin-bottom:10px;">' . CBTxt::P('Field [name] failed to migrate. Error: [error]', array('[name]' => $field->name, '[error]' => $field->getError())) . '</div>';
}
}
if (!cbInstaller_uninstall_plugin($plugin, $return)) {
return false;
}
}
// Migrates forum integration parameters:
$plugin = new PluginTable();
if ($plugin->load(array('element' => 'cb.simpleboardtab'))) {
$pluginParams = new Registry($plugin->params);
$cbForums = new PluginTable();
if ($cbForums->load(array('element' => 'cbforums'))) {
$cbForumsParams = new Registry($cbForums->params);
if ((int) $pluginParams->get('forumType', 0) == 4) {
$cbForumsParams->set('forum_model', '6');
} else {
$cbForumsParams->set('forum_model', '1');
}
switch ((int) $pluginParams->get('sidebarMode', 0)) {
case 1:
$cbForumsParams->set('k20_personaltext', $pluginParams->get('sidebarBeginner1'));
$cbForumsParams->set('k20_gender', $pluginParams->get('sidebarBeginner4'));
$cbForumsParams->set('k20_birthdate', $pluginParams->get('sidebarBeginner2'));
$cbForumsParams->set('k20_location', $pluginParams->get('sidebarBeginner3'));
$cbForumsParams->set('k20_icq', $pluginParams->get('sidebarBeginner5'));
$cbForumsParams->set('k20_aim', $pluginParams->get('sidebarBeginner6'));
$cbForumsParams->set('k20_yim', $pluginParams->get('sidebarBeginner7'));
$cbForumsParams->set('k20_msn', $pluginParams->get('sidebarBeginner8'));
$cbForumsParams->set('k20_skype', $pluginParams->get('sidebarBeginner9'));
$cbForumsParams->set('k20_twitter', $pluginParams->get('sidebarBeginner12'));
$cbForumsParams->set('k20_facebook', $pluginParams->get('sidebarBeginner13'));
$cbForumsParams->set('k20_gtalk', $pluginParams->get('sidebarBeginner10'));
$cbForumsParams->set('k20_myspace', $pluginParams->get('sidebarBeginner14'));
$cbForumsParams->set('k20_linkedin', $pluginParams->get('sidebarBeginner15'));
$cbForumsParams->set('k20_delicious', $pluginParams->get('sidebarBeginner16'));
$cbForumsParams->set('k20_digg', $pluginParams->get('sidebarBeginner18'));
$cbForumsParams->set('k20_blogspot', $pluginParams->get('sidebarBeginner19'));
$cbForumsParams->set('k20_flickr', $pluginParams->get('sidebarBeginner20'));
$cbForumsParams->set('k20_bebo', $pluginParams->get('sidebarBeginner21'));
$cbForumsParams->set('k20_website', $pluginParams->get('sidebarBeginner11'));
break;
case 2:
$cbForumsParams->set('k20_sidebar_reg', $pluginParams->get('sidebarAdvancedExists'));
$cbForumsParams->set('k20_sidebar_anon', $pluginParams->get('sidebarAdvancedPublic'));
$cbForumsParams->set('k20_sidebar_del', $pluginParams->get('sidebarAdvancedDeleted'));
break;
}
$cbForums->set('params', $cbForumsParams->asJson());
if (!$cbForums->store()) {
$return .= '<div style="font-size:14px;color:red;margin-bottom:10px;">' . CBTxt::P('Plugin [element] failed to migrate. Error: [error]', array('[element]' => $plugin->element, '[error]' => $cbForums->getError())) . '</div>';
}
}
// Migrate the forum fields to ensure their display mode is set:
$query = "SELECT *" . "\n FROM " . $cbDatabase->NameQuote('#__comprofiler_fields') . "\n WHERE " . $cbDatabase->NameQuote('name') . " IN " . $cbDatabase->safeArrayOfStrings(array('forumrank', 'forumposts', 'forumkarma'));
$cbDatabase->setQuery($query);
$fields = $cbDatabase->loadObjectList(null, '\\CB\\Database\\Table\\FieldTable', array($cbDatabase));
/** @var $fields FieldTable[] */
foreach ($fields as $field) {
$fieldParams = new Registry($field->params);
switch ($field->name) {
case 'forumposts':
$fieldParams->set('forumStatus', 'posts');
break;
case 'forumkarma':
$fieldParams->set('forumStatus', 'karma');
break;
case 'forumrank':
$fieldParams->set('forumStatus', 'rank');
break;
}
$field->set('params', $fieldParams->asJson());
if (!$field->store()) {
$return .= '<div style="font-size:14px;color:red;margin-bottom:10px;">' . CBTxt::P('Field [name] failed to migrate. Error: [error]', array('[name]' => $field->name, '[error]' => $field->getError())) . '</div>';
}
}
if (!cbInstaller_uninstall_plugin($plugin, $return)) {
return false;
}
}
// Removes legacy about cb menu items from CB Menu tab params
$tab = new TabTable();
if ($tab->load(17)) {
$tabParams = new Registry($tab->params);
if ($tabParams->get('firstSubMenuName') == '_UE_MENU_ABOUT_CB') {
$tabParams->set('firstSubMenuName', '');
$tabParams->set('firstSubMenuHref', '');
if ($tabParams->get('firstMenuName') == '_UE_MENU_CB' && !$tabParams->get('secondSubMenuName')) {
$tabParams->set('firstMenuName', '');
}
$tab->set('params', $tabParams->asJson());
if (!$tab->store()) {
$return .= '<div style="font-size:14px;color:red;margin-bottom:10px;">' . CBTxt::P('Tab [title] failed to migrate. Error: [error]', array('[title]' => $tab->title, '[error]' => $tab->getError())) . '</div>';
}
}
}
// We need to fix the name fields publish state:
switch ($ueConfig['name_style']) {
case 2:
$nameArray = array('name' => 0, 'firstname' => 1, 'middlename' => 0, 'lastname' => 1);
break;
case 3:
$nameArray = array('name' => 0, 'firstname' => 1, 'middlename' => 1, 'lastname' => 1);
break;
case 1:
default:
$nameArray = array('name' => 1, 'firstname' => 0, 'middlename' => 0, 'lastname' => 0);
break;
}
foreach ($nameArray as $name => $published) {
$query = 'UPDATE ' . $cbDatabase->NameQuote('#__comprofiler_fields') . "\n SET " . $cbDatabase->NameQuote('published') . " = " . (int) $published . "\n WHERE " . $cbDatabase->NameQuote('name') . " = " . $cbDatabase->Quote($name);
$cbDatabase->setQuery($query);
$cbDatabase->query();
}
return true;
}
