<?php
/**
* [PHPFOX_HEADER]
*/
defined('PHPFOX') or exit('NO DICE!');
/**
*
*
* @copyright [PHPFOX_COPYRIGHT]
* @author Raymond Benc
* @package Module_Admincp
* @version $Id: process.class.php 5143 2013-01-15 14:16:21Z Miguel_Espinoza $
*/
class Admincp_Service_Module_Process extends Phpfox_Service
{
/**
* @var string
*/
private $_siteName;
/**
* Admincp_Service_Module_Process constructor.
*/
public function __construct()
{
$this->_sTable = Phpfox::getT('module');
$sCacheModules = PHPFOX_DIR_FILE . 'log' . PHPFOX_DS . 'installer_modules.php';
if (file_exists($sCacheModules)) {
require($sCacheModules);
if (isset($aSiteConfig) && isset($aSiteConfig['site_name'])) {
$this->_siteName = $aSiteConfig['site_name'];
}
}
}
/**
* @todo Look into adding back the is_dir() check
*
* @param array $aVals
*
* @return string
*/
public function add($aVals)
{
$sName = strtolower($aVals['module_id']);
$sName = trim(preg_replace( '/ +/', '-',preg_replace('/[^0-9a-zA-Z_]+/', '', $sName)));
$iProductId = $aVals['product_id'];
if (empty($sName))
{
return Phpfox_Error::set(_p('module_id_can_only_contain_the_following_characters'));
}
if (!isset($aVals['text'])) {
$aVals['text'] = [];
}
if (!isset($aVals['menu'])) {
$aVals['menu'] = [];
}
$aInsert = [
'product_id' => $iProductId,
'module_id' => $sName,
'is_core' => (isset($aVals['is_core']) ? $aVals['is_core'] : 0),
'is_active' => 1,
'is_menu' => $aVals['is_menu']
];
$iMenus = 0;
if (isset($aVals['is_menu']) && $aVals['is_menu']) {
$sNewMenu = [];
foreach ($aVals['menu'] as $aMenu) {
if (empty($aMenu['phrase'])) {
continue;
}
$iMenus++;
$sPhrase = Language_Service_Phrase_Process::instance()->add([
'var_name' => 'admin_menu_' . $aMenu['phrase'],
'text' => [
'en' => $aMenu['phrase']
]
]);
$sNewMenu[$sPhrase] = [
'url' => Phpfox_Url::instance()->makeReverseUrl($aMenu['link'])
];
}
}
Language_Service_Phrase_Process::instance()->add([
'var_name' => 'module_' . $sName,
'text' => $aVals['text']
]);
$aInsert['phrase_var_name'] = 'module_' . $sName;
if ($iMenus && isset($sNewMenu)) {
$aInsert['menu'] = serialize($sNewMenu);
}
$this->database()->insert($this->_sTable, $aInsert);
Log_Service_Staff::instance()->add('module', 'add', [
'name' => $sName
]);
$path = PHPFOX_DIR_MODULE . $sName . PHPFOX_DS;
if (is_writable(PHPFOX_DIR_MODULE)) {
if (!is_dir($path)) {
mkdir($path);
}
$dirs = [
'include/component/ajax/',
'include/component/block/',
'include/component/controller/',
'include/service/',
'install/',
'static/css/',
'static/image/',
'static/jscript/',
'template/default/block/',
'template/default/controller/'
];
foreach ($dirs as $dir) {
if (!is_dir($path . $dir)) {
mkdir($path . $dir, 0777, true);
}
}
}
$clones = ['include/service/_example.class.php', 'include/component/controller/example.class.php', 'template/default/controller/example.html.php'];
foreach ($clones as $clone) {
$copy = PHPFOX_DIR_MODULE . 'core' . PHPFOX_DS . $clone;
$new = $path . $clone;
if (!file_exists($new)) {
$content = file_get_contents($copy);
$content = str_replace('MODULE', ucwords($sName), $content);
$name = str_replace('_example.', strtolower($sName) . '.', $new);
$name = str_replace('example.', 'index.', $name);
file_put_contents($name, $content);
}
}
$this->cache()->remove();
return $sName;
}
/**
* @param int $iId
* @param array $aVals
*
* @return bool
*/
public function update($iId, $aVals)
{
$sName = strtolower($aVals['module_id']);
$sName = trim(preg_replace( '/ +/', '-',preg_replace('/[^0-9a-zA-Z_]+/', '', $sName)));
$iProductId = $aVals['product_id'];
if (empty($sName)) {
return Phpfox_Error::set(_p('module_id_can_only_contain_the_following_characters'));
}
if (strlen(implode("", array_values($aVals['text']))) == 0) {
return Phpfox_Error::set(_p('provide_information_regarding_module'));
}
$iMenus = 0;
if (isset($aVals['is_menu']) && $aVals['is_menu'] && isset($aVals['menu']) && count($aVals['menu']))
{
$sNewMenu = array();
foreach ($aVals['menu'] as $aMenu)
{
if (empty($aMenu['phrase']))
{
continue;
}
$iMenus++;
if (isset($aMenu['phrase_var']) && Language_Service_Phrase_Phrase::instance()->isPhrase($aMenu['phrase_var']))
{
$aMenu['text'] = array(Phpfox_Locale::instance()->getLangId() => $aMenu['phrase']);
$sPhrase = $sName . '.' . $aMenu['phrase_var'];
Language_Service_Phrase_Process::instance()->updateVarName(Phpfox_Locale::instance()->getLangId(), $sPhrase, $aMenu['phrase']);
}
else
{
$sPhrase = Language_Service_Phrase_Process::instance()->add(array(
'var_name' => 'admin_menu_' . strtolower($aMenu['phrase']),
'text' => array(
'en' => $aMenu['phrase']
)
)
);
}
$sNewMenu[$sPhrase] = array(
'url' => Phpfox_Url::instance()->makeReverseUrl($aMenu['link'])
);
}
}
if (Language_Service_Phrase_Phrase::instance()->isPhrase('module_' . $sName))
{
foreach ($aVals['text'] as $sLang => $sValue)
{
Language_Service_Phrase_Process::instance()->updateVarName($sLang, $sName . '.' . 'module_' . $sName, $sValue, (isset($aVals['text_default']) ? true : false));
}
}
else
{
Language_Service_Phrase_Process::instance()->add(array(
'var_name' => 'module_' . $sName,
'text' => $aVals['text']
)
);
}
$aVals['phrase_var_name'] = 'module_' . $sName;
if ($iMenus && isset($sNewMenu))
{
$aVals['menu'] = serialize($sNewMenu);
}
else
{
unset($aVals['menu']);
}
$this->database()->process(array(
'product_id',
'module_id',
'is_core' => 'int',
'is_menu' => 'int',
'menu' => 'null',
'phrase_var_name' => 'null'
), $aVals)->update($this->_sTable, "module_id = '" . $this->database()->escape($iId) . "'");
Log_Service_Staff::instance()->add('module', 'update', array(
'module_id' => $iId
)
);
$this->cache()->remove();
return true;
}
/**
* @param array $aVals
*
* @return bool
*/
public function updateActive($aVals)
{
foreach ($aVals as $iId => $aVal)
{
if (isset($aVal['is_active']) && ($bReturn = Phpfox_Module::instance()->initMethod($iId, 'requirementCheck')) === false)
{
return false;
}
$this->database()->update($this->_sTable, array('is_active' => (isset($aVal['is_active']) ? 1 : 0)), "module_id = '" . $this->database()->escape($iId) . "'");
}
Log_Service_Staff::instance()->add('module_activity', 'update');
$this->cache()->remove();
return true;
}
/**
* @param int $iId
* @param int $iType
*
* @return null
*/
public function updateActivity($iId, $iType)
{
$iId = str_replace('__module_', '', $iId);
Phpfox::isUser(true);
Phpfox::getUserParam('admincp.has_admin_access', true);
if ($sPlugin = Phpfox_Plugin::get('admincp.service_module_process_updateactivity')) {
eval($sPlugin);
if (isset($mReturnFromPlugin)) {
$this->cache()->remove();
return $mReturnFromPlugin;
}
}
$aActive = [
'is_active' => (int)($iType == '1' ? 1 : 0)
];
$iCnt = $this->database()->select('COUNT(*)')
->from($this->_sTable)
->where('module_id = \'' . $this->database()->escape($iId) . '\'')
->executeField();
if ($iCnt) {
$this->database()->update($this->_sTable, $aActive, 'module_id = \'' . $this->database()->escape($iId) . '\'');
}
$iCnt = $this->database()->select('COUNT(*)')
->from(':apps')
->where('apps_id = \'' . $this->database()->escape($iId) . '\'')
->executeField();
if ($iCnt) {
$this->database()->update(':apps', $aActive, 'apps_id=\'' . $this->database()->escape($iId) . '\'');
//Disable module alias
if ($oAppObject = \Core\Lib::appInit($iId)) {
if (!empty($oAppObject->alias)) {
$this->database()->update($this->_sTable, $aActive, 'module_id = \'' . $this->database()->escape($oAppObject->alias) . '\'');
}
}
}
$this->cache()->remove();
return null;
}
/**
* @param int $iId
*
* @return bool
*/
public function delete($iId)
{
if ($sPlugin = Phpfox_Plugin::get('admincp.service_module_process_delete')){eval($sPlugin);if (isset($mReturnFromPlugin)){return $mReturnFromPlugin;}}
$aRow = $this->database()->select('*')
->from($this->_sTable)
->where("module_id = '" . $iId . "'")
->execute('getSlaveRow');
if (!isset($aRow['module_id'])) {
return false;
}
// Process mass action and connect with other modules to delete
Admincp_Service_Module_Process::instance()->mass('admincp_module_delete', $aRow['module_id']);
$oLanguagePhraseProcess = Language_Service_Phrase_Process::instance();
if ($aRow['menu'])
{
$aMenus = unserialize($aRow['menu']);
foreach ($aMenus as $sName => $aMenu)
{
$oLanguagePhraseProcess->delete($sName, true);
}
}
$this->database()->delete($this->_sTable, "module_id = '" . $aRow['module_id'] . "'");
$oLanguagePhraseProcess->delete($aRow['module_id'] . '.' . $aRow['phrase_var_name'], true);
Log_Service_Staff::instance()->add('module', 'delete', array(
'module_id' => $iId
)
);
$sFile = PHPFOX_DIR_MODULE . $aRow['module_id'] . PHPFOX_DIR_MODULE_XML . PHPFOX_DS . 'phpfox' . PHPFOX_XML_SUFFIX;
if (file_exists($sFile))
{
$aModule = Phpfox::getLib('xml.parser')->parse($sFile);
if (isset($aModule['tables']))
{
$aTables = array();
$aCache = unserialize(trim($aModule['tables']));
foreach ($aCache as $sKey => $aData)
{
$sKey = preg_replace('#phpfox_#i', Phpfox::getParam(array('db', 'prefix')), $sKey);
$aTables[] = $sKey;
}
if (count($aTables))
{
Phpfox_Database::instance()->dropTables($aTables);
}
}
}
$this->cache()->remove();
return true;
}
/**
* @param int $iId
* @param string $sPhrase
*
* @return bool
*/
public function deleteMenu($iId, $sPhrase)
{
$aRow = $this->database()->select('menu')
->from($this->_sTable)
->where("module_id = '" . $iId . "'")
->execute('getSlaveRow');
if (!isset($aRow['menu'])) {
return false;
}
$aMenus = unserialize($aRow['menu']);
$aNew = array();
foreach ($aMenus as $sName => $aMenu) {
if ($sName == $iId . '.' . $sPhrase) {
continue;
}
$aNew[$sName] = $aMenu;
}
$this->database()->update($this->_sTable, array('menu' => (count($aNew) ? serialize($aNew) : null)), "module_id = '" . $iId . "'");
Language_Service_Phrase_Process::instance()->delete($iId . '.' . $sPhrase, true);
Log_Service_Staff::instance()->add('module_menu', 'delete', [
'module_id' => $iId
]);
$this->cache()->remove();
return true;
}
/**
* @param array $aVals
* @param bool $bMissingOnly
*
* @return bool
*/
public function import($aVals, $bMissingOnly = false)
{
if ($bMissingOnly)
{
$aModules = array();
$aRows = $this->database()->select('name')
->from($this->_sTable)
->execute('getRows', array(
'free_result' => true
));
foreach ($aRows as $aRow) {
$aModules[$aRow['name']] = $aRow['name'];
}
$aSql = array();
foreach ($aVals['module'] as $aValue)
{
if (in_array($aValue['name'], $aModules))
{
continue;
}
$aSql[] = [
'phpfox',
$aValue['name'],
$aValue['is_core'],
$aValue['is_active'],
$aValue['is_menu'],
(empty($aValue['value']) ? null : $aValue['value']),
$aValue['phrase_var_name']
];
}
if ($aSql) {
$this->database()->multiInsert($this->_sTable, [
'product_id',
'name',
'is_core',
'is_active',
'is_menu',
'menu',
'phrase_var_name'
], $aSql);
}
} else {
$aSql = array();
foreach ($aVals['module'] as $aValue)
{
$aSql[] = array(
'phpfox',
$aValue['name'],
$aValue['is_core'],
$aValue['is_active'],
$aValue['is_menu'],
(empty($aValue['value']) ? null : $aValue['value']),
$aValue['phrase_var_name']
);
}
$this->database()->multiInsert($this->_sTable, array(
'product_id',
'name',
'is_core',
'is_active',
'is_menu',
'menu',
'phrase_var_name'
), $aSql);
}
Log_Service_Staff::instance()->add('module', 'import');
return true;
}
/**
* @param string $sProduct
* @param array $aFiles
* @param null $mOverwrite
*
* @return bool
*/
public function processInstall($sProduct, $aFiles, $mOverwrite = null)
{
$iInstalled = 0;
foreach ($aFiles as $iKey => $aFile)
{
if ($aFile['installed'] == 'false')
{
$aParams = Phpfox::getLib('xml.parser')->parse(file_get_contents(PHPFOX_DIR_MODULE . $iKey . PHPFOX_DS . 'phpfox.xml'));
$this->install($aParams['data']['module_id'], ($aFile['table'] == 'true' ? array('table' => true, 'insert' => true) : array('insert' => true)), $sProduct, $aParams);
$aFiles[$iKey]['installed'] = 'true';
$iInstalled++;
break;
}
}
if (!$iInstalled)
{
Phpfox::getLib('cache')->unlock();
Phpfox::getLib('cache')->remove();
}
return ($iInstalled ? $aFiles : true);
}
/**
* @todo Memory usage. Way too much memory being used here.
*
* @param string $sModule
* @param array $aParams
*
* @return bool
*/
public function install($sModule = null, $aParams = array(), $sProduct = 'phpfox', &$aModule = null)
{
$bUpgradeCheck = (defined('PHPFOX_PRODUCT_UPGRADE_CHECK') ? true : false);
if ($aModule === null)
{
$sFile = PHPFOX_DIR_MODULE . $sModule . PHPFOX_DIR_MODULE_XML . PHPFOX_DS . 'phpfox' . PHPFOX_XML_SUFFIX;
if (!file_exists($sFile))
{
return false;
}
$aModule = Phpfox::getLib('xml.parser')->parse($sFile);
if (!isset($aModule['data']['module_id']))
{
return false;
}
if ($aModule['data']['module_id'] != $sModule)
{
return false;
}
}
if (isset($aParams['table']))
{
if (isset($aModule['tables']))
{
$oPhpfoxDatabaseExport = Phpfox::getLib('database.support');
$aTables = unserialize(trim($aModule['tables']));
$sQueries = Phpfox::getLib('database.export')->process(Phpfox::getParam(array('db', 'driver')), $aTables);
$aDriver = $oPhpfoxDatabaseExport->getDriver(Phpfox::getParam(array('db', 'driver')));
$sQueries = preg_replace('#phpfox_#i', Phpfox::getParam(array('db', 'prefix')), $sQueries);
if ($aDriver['comments'] == 'remove_comments') {
$oPhpfoxDatabaseExport->removeComments($sQueries);
} else {
$oPhpfoxDatabaseExport->removeRemarks($sQueries);
}
$aSql = $oPhpfoxDatabaseExport->splitSqlFile($sQueries, $aDriver['delim']);
foreach ($aSql as $sSql) {
$sSql = preg_replace('/CREATE TABLE/', 'CREATE TABLE IF NOT EXISTS', $sSql);
$this->database()->query($sSql);
}
}
$bSkipInstallTable = false;
if ($bUpgradeCheck)
{
if ($this->database()->select('COUNT(*)')->from($this->_sTable)->where('module_id = \'' . $aModule['data']['module_id'] . '\'')->execute('getSlaveField'))
{
$bSkipInstallTable = true;
}
}
if ($sProduct == 'phpfox') {
$aProductInfo = [
'version' => Phpfox::VERSION,
'vendor' => 'phpFox',
'url' => 'https://store.phpfox.com/',
'description' => 'phpFox default app',
'apps_icon' => '',
];
} else {
$aProductInfo = db()->select('*')
->from(':product')
->where('product_id="' . $sProduct . '"')
->executeRow();
if ($aProductInfo)
{
$aProductInfo['apps_icon'] = $aProductInfo['icon'];
if (empty($aModule['data']['phrase_var_name'])) {
$aModule['data']['phrase_var_name'] = $aProductInfo['title'];
}
if ($aProductInfo['url'] === null)
{
$aProductInfo['url'] = '';
}
}
}
if ($bSkipInstallTable === false)
{
$this->database()->insert($this->_sTable, array(
'module_id' => $aModule['data']['module_id'],
'product_id' => $sProduct,
'is_core' => $aModule['data']['is_core'],
'is_active' => 1,
'is_menu' => $aModule['data']['is_menu'],
'version' => $aProductInfo['version'],
'author' => (empty($aProductInfo['vendor'])) ? 'n/a' : $aProductInfo['vendor'],
'vendor' => $aProductInfo['url'],
'description' => $aProductInfo['description'],
'apps_icon' => $aProductInfo['apps_icon'],
'menu' => $aModule['data']['menu'],
'phrase_var_name' => $aModule['data']['phrase_var_name']
)
);
}
else{
// update
$this->database()->update($this->_sTable,array(
'module_id' => $aModule['data']['module_id'],
'product_id' => $sProduct,
'is_core' => $aModule['data']['is_core'],
'is_active' => 1,
'is_menu' => $aModule['data']['is_menu'],
'menu' => $aModule['data']['menu'],
'version' => $aProductInfo['version'],
'author' => (empty($aProductInfo['vendor'])) ? 'n/a' : $aProductInfo['vendor'],
'vendor' => $aProductInfo['url'],
'description' => $aProductInfo['description'],
'apps_icon' => $aProductInfo['apps_icon'],
'phrase_var_name' => $aModule['data']['phrase_var_name']
),
'module_id = "' . $aModule['data']['module_id'] . '" AND product_id = "' . $sProduct .'"');
}
}
if (isset($aParams['post_install']))
{
$sFile = PHPFOX_DIR_MODULE . $sModule . PHPFOX_DIR_MODULE_XML . PHPFOX_DS . 'phpfox' . PHPFOX_XML_SUFFIX;
$aModule = Phpfox::getLib('xml.parser')->parse($sFile);
if (isset($aModule['install']))
{
eval($aModule['install']);
}
}
if (isset($aParams['insert']))
{
if (isset($aModule['settings']))
{
if ($bUpgradeCheck && isset($sModule))
{
$aCacheCheck = array();
$aCacheRows = $this->database()->select('setting_id, var_name')
->from(Phpfox::getT('setting'))
->where('module_id = \'' . $this->database()->escape($sModule) . '\'')
->execute('getSlaveRows');
foreach ($aCacheRows as $aCacheRow)
{
$aCacheCheck[$aCacheRow['var_name']] = $aCacheRow;
}
}
$aRows = (isset($aModule['settings']['setting'][1]) ? $aModule['settings']['setting'] : (isset($aModule['settings']['setting']) ? array($aModule['settings']['setting']) : []));
foreach ($aRows as $aRow)
{
if ($bUpgradeCheck && isset($aCacheCheck[$aRow['var_name']]))
{
$this->database()->update(Phpfox::getT('setting'), array(
'group_id' => (empty($aRow['group']) ? null : $aRow['group']),
'type_id' => $aRow['type'],
'phrase_var_name' => $aRow['phrase_var_name'],
'value_default' => $aRow['value'],
'ordering' => $aRow['ordering']
), 'setting_id = ' . (int) $aCacheCheck[$aRow['var_name']]['setting_id']
);
continue;
}
$this->database()->insert(Phpfox::getT('setting'), array(
'group_id' => (empty($aRow['group']) ? null : $aRow['group']),
'module_id' => ($sModule === null ? $aRow['module_id'] : $sModule),
'product_id' => $sProduct,
'is_hidden' => $aRow['is_hidden'],
'version_id' => $aRow['version_id'],
'type_id' => $aRow['type'],
'var_name' => $aRow['var_name'],
'phrase_var_name' => $aRow['phrase_var_name'],
'value_actual' => $this->_siteNameParse($aRow['value']),
'value_default' => $this->_siteNameParse($aRow['value']),
'ordering' => $aRow['ordering']
)
);
}
}
if (isset($aModule['setting_groups']))
{
if ($bUpgradeCheck)
{
$aCacheCheck = array();
$aCacheRows = $this->database()->select('var_name')
->from(Phpfox::getT('setting_group'))
->where('module_id = \'' . $this->database()->escape(($sModule === null ? $aRow['module_id'] : $sModule)) . '\'')
->execute('getSlaveRows');
foreach ($aCacheRows as $aCacheRow)
{
$aCacheCheck[$aCacheRow['var_name']] = true;
}
}
$aRows = (isset($aModule['setting_groups']['name'][1]) ? $aModule['setting_groups']['name'] : array($aModule['setting_groups']['name']));
foreach ($aRows as $aRow)
{
if ($bUpgradeCheck && isset($aCacheCheck[$aRow['var_name']]))
{
continue;
}
$this->database()->insert(Phpfox::getT('setting_group'), array(
'group_id' => $aRow['value'],
'module_id' => ($sModule === null ? $aRow['module_id'] : $sModule),
'product_id' => $sProduct,
'version_id' => $aRow['version_id'],
'var_name' => $aRow['var_name']
)
);
}
}
if (isset($aModule['phrases']))
{
if ($bUpgradeCheck)
{
$aCacheCheck = array();
$aCacheRows = $this->database()->select('phrase_id, var_name, text_default')
->from(Phpfox::getT('language_phrase'))
->where('module_id = \'' . $this->database()->escape(($sModule === null ? $aRow['module_id'] : $sModule)) . '\'')
->execute('getSlaveRows');
foreach ($aCacheRows as $aCacheRow)
{
$aCacheCheck[$aCacheRow['var_name']] = $aCacheRow;
}
}
$aRows = (isset($aModule['phrases']['phrase'][1]) ? $aModule['phrases']['phrase'] : (isset($aModule['phrases']['phrase']) ? array($aModule['phrases']['phrase']) : []));
$sPhrasePath = PHPFOX_DIR . 'module' . PHPFOX_DS . ($sModule === null ? $aRow['module_id'] : $sModule) . PHPFOX_DS . PHPFOX_DS . 'phrase.json';
if (file_exists($sPhrasePath)) {
$aPhrases = json_decode(file_get_contents($sPhrasePath), true);
\Core\Lib::phrase()->addPhrase($aPhrases);
} else {
$aModulePhrases = [];
foreach ($aRows as $aRow) {
if ($bUpgradeCheck && isset($aCacheCheck[$aRow['var_name']])) {
if ($aCacheCheck[$aRow['var_name']]['text_default'] != $aRow['value']) {
$this->database()->update(Phpfox::getT('language_phrase'), array(
'text_default' => $aRow['value']
), 'phrase_id = ' . (int)$aCacheCheck[$aRow['var_name']]['phrase_id']
);
}
continue;
}
$aModulePhrases[$aRow['var_name']] = $this->_siteNameParse($aRow['value']);
$this->database()->insert(Phpfox::getT('language_phrase'), array(
'language_id' => 'en',
'module_id' => $this->database()->escape(($sModule === null ? $aRow['module_id'] : $sModule)),
'var_name' => $aRow['var_name'],
'text' => $this->_siteNameParse($aRow['value']),
'text_default' => $this->_siteNameParse($aRow['value']),
'added' => $aRow['added']
)
);
}
file_put_contents($sPhrasePath, json_encode($aModulePhrases, JSON_PRETTY_PRINT));
}
}
if (isset($aModule['menus']))
{
if ($bUpgradeCheck)
{
$aCacheCheck = array();
$aCacheRows = $this->database()->select('menu_id, var_name')
->from(Phpfox::getT('menu'))
->where('module_id = \'' . $this->database()->escape(($sModule === null ? $aRow['module_id'] : $sModule)) . '\'')
->execute('getSlaveRows');
foreach ($aCacheRows as $aCacheRow)
{
$aCacheCheck[$aCacheRow['var_name']] = $aCacheRow;
}
}
$aRows = (isset($aModule['menus']['menu'][1]) ? $aModule['menus']['menu'] : array($aModule['menus']['menu']));
/* In this array we store the previous parent_ids to convert to the newly inserted parent_ids*/
$aParents = array();
for ($iCycle = 0; $iCycle <= 1; $iCycle++)
{
foreach ($aRows as $aRow)
{
/* Menu has a parent but we havent added the parent yet */
/* Make sure no wrong connections are added*/
if (empty($aRow['m_connection']))
{
$aRow['m_connection'] = null;
}
/* Just safety */
if (!isset($aRow['parent_id']))
{
$aRow['parent_id'] = 0;
}
if (!isset($aRow['parent_var_name']))
{
$aRow['parent_var_name'] = '';
}
if ($iCycle == 0 && !empty($aRow['parent_var_name']))
{
continue;
}
if ($iCycle == 1 && empty($aRow['parent_var_name']))
{
continue;
}
if ($iCycle == 1 && !empty($aRow['parent_var_name']))
{
$aDbMenu = $this->database()->select('*')
->from(Phpfox::getT('menu'))
->where(['var_name' => Phpfox::getLib('parse.input')->clean($aRow['parent_var_name'])])
->execute('getSlaveRow');
if (isset($aDbMenu['menu_id']))
{
$aRow['parent_id'] = $aDbMenu['menu_id'];
}
}
if ($bUpgradeCheck && isset($aCacheCheck[$aRow['var_name']]))
{
$this->database()->update(Phpfox::getT('menu'), array(
'parent_id' => (int) $aRow['parent_id'],
'm_connection' => $aRow['m_connection'],
'var_name' => $aRow['var_name'],
'url_value' => (empty($aRow['url_value']) ? null : $aRow['url_value'])
), 'menu_id = ' . (int) $aCacheCheck[$aRow['var_name']]['menu_id']
);
continue;
}
$aMenuUpdate = array(
'parent_id' => (int) $aRow['parent_id'],
'module_id' => ($sModule === null ? $aRow['module_id'] : $sModule),
'product_id' => $sProduct,
'm_connection' => $aRow['m_connection'],
'var_name' => $aRow['var_name'],
'ordering' => $aRow['ordering'],
'url_value' => (empty($aRow['url_value']) ? null : $aRow['url_value']),
'version_id' => $aRow['version_id'],
'disallow_access' => (empty($aRow['disallow_access']) ? null : $aRow['disallow_access']),
'is_active' => 1
);
if ($this->database()->isField(Phpfox::getT('menu'), 'mobile_icon'))
{
$aMenuUpdate['mobile_icon'] = (empty($aRow['mobile_icon']) ? null : $aRow['mobile_icon']);
}
$iNewParentId = $this->database()->insert(Phpfox::getT('menu'), $aMenuUpdate);
}
} /* end for cycle*/
}
if (isset($aModule['user_group_settings']))
{
if ($bUpgradeCheck)
{
$aCacheCheck = array();
$aCacheRows = $this->database()->select('setting_id, name')
->from(Phpfox::getT('user_group_setting'))
->where('module_id = \'' . $this->database()->escape(($sModule === null ? $aRow['module_id'] : $sModule)) . '\'')
->execute('getSlaveRows');
foreach ($aCacheRows as $aCacheRow)
{
$aCacheCheck[$aCacheRow['name']] = $aCacheRow;
}
}
$aRows = (isset($aModule['user_group_settings']['setting'][1]) ? $aModule['user_group_settings']['setting'] : (isset($aModule['user_group_settings']['setting']) ? array($aModule['user_group_settings']['setting']) : []));
foreach ($aRows as $aRow)
{
if ($bUpgradeCheck && isset($aCacheCheck[$aRow['value']]))
{
$this->database()->update(Phpfox::getT('user_group_setting'), array(
'is_hidden' => (isset($aRow['is_hidden']) ? (int) $aRow['is_hidden'] : 0),
'is_admin_setting' => $aRow['is_admin_setting'],
'name' => $aRow['value'],
'type_id' => $aRow['type'],
'default_admin' => $aRow['admin'],
'default_user' => $aRow['user'],
'default_guest' => $aRow['guest'],
'default_staff' => $aRow['staff'],
'ordering' => $aRow['ordering']
), 'setting_id = ' . (int) $aCacheCheck[$aRow['value']]['setting_id']
);
continue;
}
$this->database()->insert(Phpfox::getT('user_group_setting'), array(
'is_admin_setting' => $aRow['is_admin_setting'],
'module_id' => ($sModule === null ? $aRow['module_id'] : $sModule),
'product_id' => $sProduct,
'name' => $aRow['value'],
'type_id' => $aRow['type'],
'default_admin' => $aRow['admin'],
'default_user' => $aRow['user'],
'default_guest' => $aRow['guest'],
'default_staff' => $aRow['staff'],
'ordering' => $aRow['ordering']
)
);
}
}
if (isset($aModule['hooks']))
{
if ($bUpgradeCheck)
{
$aCacheCheck = array();
$aCacheRows = $this->database()->select('hook_id, call_name')
->from(Phpfox::getT('plugin_hook'))
->where('module_id = \'' . $this->database()->escape(($sModule === null ? $aRow['module_id'] : $sModule)) . '\'')
->execute('getSlaveRows');
foreach ($aCacheRows as $aCacheRow)
{
$aCacheCheck[$aCacheRow['call_name']] = $aCacheRow;
}
}
$aRows = (isset($aModule['hooks']['hook'][1]) ? $aModule['hooks']['hook'] : array($aModule['hooks']['hook']));
foreach ($aRows as $aRow)
{
if ($bUpgradeCheck && isset($aCacheCheck[$aRow['call_name']]))
{
continue;
}
$this->database()->insert(Phpfox::getT('plugin_hook'), array(
'module_id' => ($sModule === null ? $aRow['module_id'] : $sModule),
'product_id' => $sProduct,
'hook_type' => $aRow['hook_type'],
'call_name' => $aRow['call_name'],
'added' => (int) $aRow['added'],
'version_id' => (empty($aRow['version_id']) ? null : $aRow['version_id']),
'is_active' => 1
)
);
}
}
if (isset($aModule['plugins']))
{
if ($bUpgradeCheck)
{
$aCacheCheck = array();
$aCacheRows = $this->database()->select('plugin_id, call_name')
->from(Phpfox::getT('plugin'))
->where('module_id = \'' . $this->database()->escape(($sModule === null ? $aRow['module_id'] : $sModule)) . '\'')
->execute('getSlaveRows');
foreach ($aCacheRows as $aCacheRow)
{
$aCacheCheck[$aCacheRow['call_name']] = $aCacheRow;
}
}
$aRows = (isset($aModule['plugins']['plugin'][1]) ? $aModule['plugins']['plugin'] : array($aModule['plugins']['plugin']));
foreach ($aRows as $aRow)
{
if ($bUpgradeCheck && isset($aCacheCheck[$aRow['call_name']]))
{
$this->database()->update(Phpfox::getT('plugin'), array(
'title' => $aRow['title'],
'php_code' => str_replace('\\','\\\\',$aRow['value'])
), 'plugin_id = ' . (int) $aCacheCheck[$aRow['call_name']]['plugin_id']
);
continue;
}
$this->database()->insert(Phpfox::getT('plugin'), array(
'module_id' => ($sModule === null ? (empty($aRow['module_id']) ? null : $aRow['module_id']) : $sModule),
'product_id' => $sProduct,
'call_name' => $aRow['call_name'],
'title' => $aRow['title'],
'php_code' => str_replace('\\','\\\\',$aRow['value']),
'is_active' => 1
)
);
}
}
if (isset($aModule['components']))
{
if ($bUpgradeCheck)
{
$aCacheCheck = array();
$aCacheRows = $this->database()->select('component_id, component, m_connection')
->from(Phpfox::getT('component'))
->where('module_id = \'' . $this->database()->escape(($sModule === null ? $aRow['module_id'] : $sModule)) . '\'')
->execute('getSlaveRows');
foreach ($aCacheRows as $aCacheRow)
{
$aCacheCheck[$aCacheRow['component'] . $aCacheRow['m_connection']] = $aCacheRow;
}
}
$aRows = (isset($aModule['components']['component'][1]) ? $aModule['components']['component'] : array($aModule['components']['component']));
foreach ($aRows as $aRow)
{
if ($bUpgradeCheck && isset($aCacheCheck[$aRow['component'] . $aRow['m_connection']]))
{
$this->database()->update(Phpfox::getT('component'), array(
'component' => $aRow['component'],
'm_connection' => $aRow['m_connection'],
'is_controller' => (int) $aRow['is_controller'],
'is_block' => (int) $aRow['is_block']
), 'component_id = ' . (int) $aCacheCheck[$aRow['component'] . $aRow['m_connection']]['component_id']
);
continue;
}
$this->database()->insert(Phpfox::getT('component'), array(
'module_id' => ($sModule === null ? $aRow['module_id'] : $sModule),
'product_id' => $sProduct,
'component' => $aRow['component'],
'm_connection' => $aRow['m_connection'],
'is_controller' => (int) $aRow['is_controller'],
'is_block' => (int) $aRow['is_block'],
'is_active' => (int) $aRow['is_active']
)
);
}
}
if (isset($aModule['blocks']))
{
if ($bUpgradeCheck)
{
$aCacheCheck = array();
$aCacheRows = $this->database()->select('block_id, component, m_connection')
->from(Phpfox::getT('block'))
->where('module_id = \'' . $this->database()->escape(($sModule === null ? $aRow['module_id'] : $sModule)) . '\'')
->execute('getSlaveRows');
foreach ($aCacheRows as $aCacheRow)
{
$aCacheCheck[$aCacheRow['component'] . $aCacheRow['m_connection']] = $aCacheRow;
}
}
$aRows = (isset($aModule['blocks']['block'][1]) ? $aModule['blocks']['block'] : array($aModule['blocks']['block']));
foreach ($aRows as $aRow)
{
if ($bUpgradeCheck && isset($aCacheCheck[$aRow['component'] . $aRow['m_connection']]))
{
$aBlockSql = array(
'location' => $aRow['location'],
'can_move' => (int) $aRow['can_move']
);
if (!empty($aRow['title']))
{
$aBlockSql['title'] = (!empty($aRow['title']) ? $this->preParse()->clean($aRow['title']) : null);
}
if (isset($aRow['type_id']))
{
$aBlockSql['type_id'] = (isset($aRow['type_id']) ? (int) $aRow['type_id'] : 0);
}
$this->database()->update(Phpfox::getT('block'), $aBlockSql, 'block_id = ' . (int) $aCacheCheck[$aRow['component'] . $aRow['m_connection']]['block_id']);
if (isset($aRow['type_id']) && (int) $aRow['type_id'] > 0)
{
$this->database()->update(Phpfox::getT('block_source'), array(
'source_code' => $aRow['source_code'],
'source_parsed' => $aRow['source_parsed']
), 'block_id = ' . (int) $aCacheCheck[$aRow['component'] . $aRow['m_connection']]['block_id']
);
}
continue;
}
$aBlockSql = array(
'module_id' => ($sModule === null ? $aRow['module_id'] : $sModule),
'product_id' => $sProduct,
'component' => (empty($aRow['component']) ? null : $aRow['component']),
'm_connection' => $aRow['m_connection'],
'location' => (int) $aRow['location'],
'is_active' => (int) $aRow['is_active'],
'ordering' => (int) $aRow['ordering'],
'can_move' => (int) $aRow['can_move'],
'disallow_access' => (empty($aRow['disallow_access']) ? null : $aRow['disallow_access']),
'version_id' => (empty($aRow['version_id']) ? null : $aRow['version_id'])
);
if (!empty($aRow['title']))
{
$aBlockSql['title'] = (!empty($aRow['title']) ? $this->preParse()->clean($aRow['title']) : null);
}
if (isset($aRow['type_id']))
{
$aBlockSql['type_id'] = (isset($aRow['type_id']) ? (int) $aRow['type_id'] : 0);
}
$iBlockId = $this->database()->insert(Phpfox::getT('block'), $aBlockSql);
if (isset($aRow['type_id']) && (int) $aRow['type_id'] > 0)
{
$this->database()->insert(Phpfox::getT('block_source'), array(
'block_id' => $iBlockId,
'source_code' => $aRow['source_code'],
'source_parsed' => $aRow['source_parsed']
)
);
}
}
}
if (isset($aModule['crons']))
{
if ($bUpgradeCheck)
{
$aCacheCheck = array();
$aCacheRows = $this->database()->select('php_code')
->from(Phpfox::getT('cron'))
->where('module_id = \'' . $this->database()->escape(($sModule === null ? $aRow['module_id'] : $sModule)) . '\'')
->execute('getSlaveRows');
foreach ($aCacheRows as $aCacheRow)
{
$aCacheCheck[md5($aCacheRow['php_code'])] = true;
}
}
$aRows = (isset($aModule['crons']['cron'][1]) ? $aModule['crons']['cron'] : array($aModule['crons']['cron']));
foreach ($aRows as $aRow)
{
if ($bUpgradeCheck && isset($aCacheCheck[md5($aRow['value'])]))
{
continue;
}
$this->database()->insert(Phpfox::getT('cron'), array(
'module_id' => ($sModule === null ? $aRow['module_id'] : $sModule),
'product_id' => $sProduct,
'php_code' => Phpfox::getLib('parse.format')->phpCode($aRow['value']),
'type_id' => $aRow['type_id'],
'every' => $aRow['every'],
'is_active' => '1'
)
);
}
}
if (isset($aModule['pages']))
{
if ($bUpgradeCheck)
{
$aCacheCheck = array();
$aCacheRows = $this->database()->select('page_id, title_url')
->from(Phpfox::getT('page'))
->where('module_id = \'' . $this->database()->escape(($sModule === null ? $aRow['module_id'] : $sModule)) . '\'')
->execute('getSlaveRows');
foreach ($aCacheRows as $aCacheRow)
{
$aCacheCheck[$aCacheRow['title_url']] = $aCacheRow;
}
}
$aRows = (isset($aModule['pages']['page'][1]) ? $aModule['pages']['page'] : array($aModule['pages']['page']));
foreach ($aRows as $aRow)
{
if ($bUpgradeCheck && isset($aCacheCheck[$aRow['title_url']]))
{
if (isset($aRow['no_update']) && ($aRow['no_update'] == 1)) continue;
$this->database()->update(Phpfox::getT('page'), array(
'is_phrase' => $aRow['is_phrase'],
'has_bookmark' => $aRow['has_bookmark'],
'parse_php' => $aRow['parse_php'],
'add_view' => $aRow['add_view'],
'full_size' => $aRow['full_size'],
'title' => $aRow['title'],
'title_url' => $aRow['title_url']
), 'page_id = ' . (int) $aCacheCheck[$aRow['title_url']]['page_id']
);
$this->database()->update(Phpfox::getT('page_text'), array(
'keyword' => (empty($aRow['keyword']) ? null : $aRow['keyword']),
'description' => (empty($aRow['description']) ? null : $aRow['description']),
'text' => $aRow['text'],
'text_parsed' => $aRow['text_parsed']
), 'page_id = ' . (int) $aCacheCheck[$aRow['title_url']]['page_id']
);
continue;
}
$iPageId = $this->database()->insert(Phpfox::getT('page'), array(
'module_id' => ($sModule === null ? $aRow['module_id'] : $sModule),
'is_phrase' => $aRow['is_phrase'],
'product_id' => $sProduct,
'is_active' => 1,
'has_bookmark' => $aRow['has_bookmark'],
'parse_php' => $aRow['parse_php'],
'add_view' => $aRow['add_view'],
'full_size' => $aRow['full_size'],
'title' => $aRow['title'],
'title_url' => $aRow['title_url'],
'added' => $aRow['added']
)
);
$this->database()->insert(Phpfox::getT('page_text'), array(
'page_id' => $iPageId,
'keyword' => (empty($aRow['keyword']) ? null : $aRow['keyword']),
'description' => $this->_siteNameParse(empty($aRow['description']) ? null : $aRow['description']),
'text' => $this->_siteNameParse($aRow['text']),
'text_parsed' => $this->_siteNameParse($aRow['text_parsed'])
)
);
}
}
if (isset($aModule['custom_group']))
{
if ($bUpgradeCheck)
{
$aCacheCheck = array();
$aCacheRows = $this->database()->select('phrase_var_name')
->from(Phpfox::getT('custom_group'))
->where('module_id = \'' . $this->database()->escape(($sModule === null ? $aRow['module_id'] : $sModule)) . '\'')
->execute('getSlaveRows');
foreach ($aCacheRows as $aCacheRow)
{
$aCacheCheck[$aCacheRow['phrase_var_name']] = true;
}
}
$aRows = (isset($aModule['custom_group']['group'][1]) ? $aModule['custom_group']['group'] : array($aModule['custom_group']['group']));
$aCustomGroupCache = array();
foreach ($aRows as $aRow)
{
if ($bUpgradeCheck && isset($aCacheCheck[$aRow['phrase_var_name']]))
{
continue;
}
$aCustomGroupCache[$aRow['phrase_var_name']] = $this->database()->insert(Phpfox::getT('custom_group'), array(
'module_id' => ($sModule === null ? $aRow['module_id'] : $sModule),
'product_id' => $sProduct,
'type_id' => $aRow['type_id'],
'phrase_var_name' => $aRow['phrase_var_name'],
'is_active' => $aRow['is_active'],
'ordering' => $aRow['ordering']
)
);
}
}
if (isset($aModule['custom_field']))
{
if ($bUpgradeCheck)
{
$aCacheCheck = array();
$aCacheRows = $this->database()->select('phrase_var_name')
->from(Phpfox::getT('custom_field'))
->where('module_id = \'' . $this->database()->escape(($sModule === null ? $aRow['module_id'] : $sModule)) . '\'')
->execute('getSlaveRows');
foreach ($aCacheRows as $aCacheRow)
{
$aCacheCheck[$aCacheRow['phrase_var_name']] = true;
}
}
$aRows = (isset($aModule['custom_field']['field'][1]) ? $aModule['custom_field']['field'] : array($aModule['custom_field']['field']));
foreach ($aRows as $aRow)
{
if ($bUpgradeCheck && isset($aCacheCheck[$aRow['phrase_var_name']]))
{
continue;
}
$iFieldId = $this->database()->insert(Phpfox::getT('custom_field'), array(
'module_id' => ($sModule === null ? $aRow['module_id'] : $sModule),
'product_id' => $sProduct,
'group_id' => (isset($aCustomGroupCache[$aRow['group_name']]) ? (int) $aCustomGroupCache[$aRow['group_name']] : 0),
'field_name' => $aRow['field_name'],
'type_id' => $aRow['type_id'],
'phrase_var_name' => $aRow['phrase_var_name'],
'type_name' => $aRow['type_name'],
'var_type' => $aRow['var_type'],
'is_active' => 1,
'is_required' => $aRow['is_required'],
'ordering' => $aRow['ordering']
)
);
if (!empty($aRow['value']))
{
$aOptions = unserialize($aRow['value']);
foreach ($aOptions as $aOption)
{
$this->database()->insert(Phpfox::getT('custom_option'), array('field_id' => $iFieldId, 'phrase_var_name' => $aOption['phrase_var_name']));
}
}
if (!$this->database()->isField(Phpfox::getT('user_custom'), Custom_Service_Custom::instance()->getAlias() . $aRow['field_name']))
{
$this->database()->addField(array(
'table' => Phpfox::getT('user_custom'),
'field' => Custom_Service_Custom::instance()->getAlias() . $aRow['field_name'],
'type' => $aRow['type_name']
)
);
}
if (!$this->database()->isField(Phpfox::getT('user_custom_value'), Custom_Service_Custom::instance()->getAlias() . $aRow['field_name']))
{
$this->database()->addField(array(
'table' => Phpfox::getT('user_custom_value'),
'field' => Custom_Service_Custom::instance()->getAlias() . $aRow['field_name'],
'type' => $aRow['type_name']
)
);
}
}
}
if (isset($aModule['reports']))
{
if ($bUpgradeCheck)
{
$aCacheCheck = array();
$aCacheRows = $this->database()->select('message')
->from(Phpfox::getT('report'))
->where('module_id = \'' . $this->database()->escape(($sModule === null ? $aRow['module_id'] : $sModule)) . '\'')
->execute('getSlaveRows');
foreach ($aCacheRows as $aCacheRow)
{
$aCacheCheck[$aCacheRow['message']] = true;
}
}
$aRows = (isset($aModule['reports']['report'][1]) ? $aModule['reports']['report'] : array($aModule['reports']['report']));
$aInserted = array();
foreach ($aRows as $aRow)
{
if ( ($bUpgradeCheck && isset($aCacheCheck[$aRow['value']])) || (isset($aInserted[md5(serialize($aRow))])))
{
continue;
}
$aInserted[md5(serialize($aRow))] = true;
$this->database()->insert(Phpfox::getT('report'), array(
'module_id' => ($sModule === null ? $aRow['module_id'] : $sModule),
'product_id' => $sProduct,
'message' => $aRow['value']
)
);
}
}
if (isset($aModule['stats']))
{
if ($bUpgradeCheck)
{
$aCacheCheck = array();
$aCacheRows = $this->database()->select('stat_id, phrase_var')
->from(Phpfox::getT('site_stat'))
->where('module_id = \'' . $this->database()->escape(($sModule === null ? $aRow['module_id'] : $sModule)) . '\'')
->execute('getSlaveRows');
foreach ($aCacheRows as $aCacheRow)
{
$aCacheCheck[$aCacheRow['phrase_var']] = $aCacheRow;
}
}
$aRows = (isset($aModule['stats']['stat'][1]) ? $aModule['stats']['stat'] : array($aModule['stats']['stat']));
foreach ($aRows as $aRow)
{
if ($bUpgradeCheck && isset($aCacheCheck[$aRow['phrase_var']]))
{
$this->database()->update(Phpfox::getT('site_stat'), array(
'phrase_var' => $aRow['phrase_var'],
'php_code' => $aRow['value'],
'stat_link' => $aRow['stat_link'],
'stat_image' => $aRow['stat_image']
), 'stat_id = ' . (int) $aCacheCheck[$aRow['phrase_var']]['stat_id']
);
continue;
}
$this->database()->insert(Phpfox::getT('site_stat'), array(
'module_id' => ($sModule === null ? $aRow['module_id'] : $sModule),
'product_id' => $sProduct,
'phrase_var' => $aRow['phrase_var'],
'php_code' => $aRow['value'],
'stat_link' => $aRow['stat_link'],
'stat_image' => $aRow['stat_image'],
'is_active' => $aRow['is_active'],
'ordering' => '0'
)
);
}
}
if ($sModule !== null)
{
$aModuleCallback = Phpfox::massCallback('installModule', $sProduct, $sModule, $aModule);
}
if (defined('PHPFOX_UPGRADE_MODULE_XML'))
{
// phpfox_update_settings
if (isset($aModule['phpfox_update_settings']))
{
$aRows = (isset($aModule['phpfox_update_settings']['setting'][1]) ? $aModule['phpfox_update_settings']['setting'] : array($aModule['phpfox_update_settings']['setting']));
foreach ($aRows as $aRow)
{
$this->database()->update(Phpfox::getT('setting'), array(
'group_id' => (empty($aRow['group']) ? null : $aRow['group']),
'is_hidden' => $aRow['is_hidden'],
'type_id' => $aRow['type'],
'value_actual' => $aRow['value'],
'value_default' => $aRow['value'],
'ordering' => $aRow['ordering']
), 'module_id = \'' . ($sModule === null ? $aRow['module_id'] : $sModule) . '\' AND var_name = \'' . $aRow['var_name'] . '\''
);
}
}
// phpfox_update_blocks
if (isset($aModule['phpfox_update_blocks']))
{
$aRows = (isset($aModule['phpfox_update_blocks']['block'][1]) ? $aModule['phpfox_update_blocks']['block'] : array($aModule['phpfox_update_blocks']['block']));
foreach ($aRows as $aRow)
{
$this->database()->update(Phpfox::getT('block'), array(
'is_active' => $aRow['is_active'],
'can_move' => $aRow['can_move'],
'title' => $aRow['title'],
'ordering' => $aRow['ordering']
), 'm_connection = \'' . $aRow['m_connection'] . '\' AND module_id = \'' . ($sModule === null ? $aRow['module_id'] : $sModule) . '\' AND component = \'' . $aRow['component'] . '\''
);
}
}
// phpfox_update_rss
if (isset($aModule['phpfox_update_rss']))
{
$aRows = (isset($aModule['phpfox_update_rss']['feed'][1]) ? $aModule['phpfox_update_rss']['feed'] : array($aModule['phpfox_update_rss']['feed']));
foreach ($aRows as $aRow)
{
$this->database()->update(Phpfox::getT('rss'), array(
'php_view_code' => $aRow['php_view_code']
), 'module_id = \'' . ($sModule === null ? $aRow['module_id'] : $sModule) . '\' AND title_var = \'' . $aRow['title_var'] . '\''
);
}
}
if (isset($aModule['phpfox_update_phrases']))
{
$aRows = (isset($aModule['phpfox_update_phrases']['phrase'][1]) ? $aModule['phpfox_update_phrases']['phrase'] : array($aModule['phpfox_update_phrases']['phrase']));
foreach ($aRows as $aRow)
{
$this->database()->update(Phpfox::getT('language_phrase'), array(
'text' => $aRow['value'],
'text_default' => $aRow['value']
), 'language_id = \'en\' AND module_id = \'' . ($sModule === null ? $aRow['module_id'] : $sModule) . '\' AND var_name = \'' . $aRow['var_name'] . '\''
);
}
}
if (isset($aModule['phpfox_update_menus']))
{
$aRows = (isset($aModule['phpfox_update_menus']['menu'][1]) ? $aModule['phpfox_update_menus']['menu'] : array($aModule['phpfox_update_menus']['menu']));
foreach ($aRows as $aRow)
{
$this->database()->update(Phpfox::getT('menu'), array(
'm_connection' => $aRow['m_connection'],
'ordering' => $aRow['ordering'],
'url_value' => (empty($aRow['url_value']) ? null : $aRow['url_value']),
'disallow_access' => (empty($aRow['disallow_access']) ? null : $aRow['disallow_access'])
), 'module_id = \'' . ($sModule === null ? $aRow['module_id'] : $sModule) . '\' AND var_name = \'' . $aRow['var_name'] . '\''
);
}
}
}
}
return true;
}
/**
*
*/
public function mass()
{
$aArgs = func_get_args();
$sAction = $aArgs[0];
$aParams = array();
for ($i = 1; $i <= (func_num_args() - 1); $i++)
{
$aParams[] = $aArgs[$i];
}
foreach (Phpfox_Module::instance()->getModules() as $sModule)
{
$sCallBack = PHPFOX_DIR_MODULE . $sModule . PHPFOX_DS . PHPFOX_DIR_MODULE_SERVICE . PHPFOX_DS . 'callback.class.php';
if (file_exists($sCallBack))
{
require_once($sCallBack);
$sClass = $sModule . '_Service_Callback';
$sMethod = 'mass' . str_replace('_', '', $sAction);
$oObject[$sClass] = new $sClass();
if (is_object($oObject[$sClass]) && method_exists($oObject[$sClass], $sMethod))
{
$sEval = 'call_user_func(array($oObject[$sClass], $sMethod)';
if (count($aParams))
{
foreach ($aParams as $mParam)
{
$sEval .= ', ' . var_export($mParam, true) . '';
}
}
$sEval .= ');';
eval($sEval);
}
}
}
}
/**
* Change Site name to name of user
* @param string $sValue
*
* @return string
*/
private function _siteNameParse($sValue){
if (!isset($this->_siteName)){
return $sValue;
}
$sNewName = $this->_siteName;
if (strtolower($sNewName) == 'site name'){
return $sValue;
}
//Replace all lower
$sValue = str_replace('site name', strtolower($sNewName), $sValue);
$sValue = str_replace('sitename', strtolower($sNewName), $sValue);
//Replace all upper
$sValue = str_replace('SITE NAME', strtoupper($sNewName), $sValue);
$sValue = str_replace('SITENAME', strtoupper($sNewName), $sValue);
//Replace upper first
$sValue = str_replace("Site name", ucfirst(strtolower($sNewName)), $sValue);
$sValue = str_replace('Sitename', ucfirst(strtolower($sNewName)), $sValue);
//Replace upper first letter
$sValue = str_replace('Site Name', ucwords(strtolower($sNewName)), $sValue);
$sValue = str_replace('SiteName', ucwords(strtolower($sNewName)), $sValue);
//other case
$sValue = str_replace(strtolower('SiteName'), strtolower($sNewName), $sValue);
return $sValue;
}
/**
* If a call is made to an unknown method attempt to connect
* it to a specific plug-in with the same name thus allowing
* plug-in developers the ability to extend classes.
*
* @param string $sMethod is the name of the method
* @param array $aArguments is the array of arguments of being passed
*
* @return null
*/
public function __call($sMethod, $aArguments)
{
/**
* Check if such a plug-in exists and if it does call it.
*/
if ($sPlugin = Phpfox_Plugin::get('admincp.service_module_process___call'))
{
eval($sPlugin);
return null;
}
/**
* No method or plug-in found we must throw a error.
*/
Phpfox_Error::trigger('Call to undefined method ' . __CLASS__ . '::' . $sMethod . '()', E_USER_ERROR);
}
}