/**
* Return the appropriate Resource controller class based on the class_key request parameter
*
* @static
* @param modX $modx A reference to the modX instance
* @param string $className The controller class name that is attempting to be loaded
* @param array $config An array of configuration options for the action
* @return modManagerController The proper controller class
*/
public static function getInstance(modX &$modx, $className, array $config = array())
{
$resourceClass = 'modDocument';
$isDerivative = false;
if (!empty($_REQUEST['class_key'])) {
$isDerivative = true;
$resourceClass = in_array($_REQUEST['class_key'], array('modDocument', 'modResource')) ? 'modDocument' : $_REQUEST['class_key'];
if ($resourceClass == 'modResource') {
$resourceClass = 'modDocument';
}
} else {
if (!empty($_REQUEST['id']) && $_REQUEST['id'] != 'undefined' && strlen($_REQUEST['id']) === strlen((int) $_REQUEST['id'])) {
/** @var modResource $resource */
$resource = $modx->getObject('modResource', array('id' => $_REQUEST['id']));
if ($resource && !in_array($resource->get('class_key'), array('modDocument', 'modResource'))) {
$isDerivative = true;
$resourceClass = $resource->get('class_key');
} else {
if ($resource && $resource->get('class_key') == 'modResource') {
/* fix improper class key */
$resource->set('class_key', 'modDocument');
$resource->save();
}
}
}
}
if ($isDerivative) {
$resourceClass = str_replace(array('../', '..', '/', '\\'), '', $resourceClass);
if (!class_exists($resourceClass) && !$modx->loadClass($resourceClass)) {
$resourceClass = 'modDocument';
}
$delegateView = $modx->call($resourceClass, 'getControllerPath', array(&$modx));
$action = strtolower(str_replace(array('Resource', 'ManagerController'), '', $className));
$className = str_replace('mod', '', $resourceClass) . ucfirst($action) . 'ManagerController';
$controllerFile = $delegateView . $action . '.class.php';
if (!file_exists($controllerFile)) {
// We more than likely are using a custom manager theme without overridden controller, let's try with the default theme
$theme = $modx->getOption('manager_theme', null, 'default');
$modx->setOption('manager_theme', 'default');
$delegateView = $modx->call($resourceClass, 'getControllerPath', array(&$modx));
$controllerFile = $delegateView . $action . '.class.php';
// Restore custom theme (so we don't process/use default theme assets)
$modx->setOption('manager_theme', $theme);
}
require_once $controllerFile;
}
$controller = new $className($modx, $config);
$controller->resourceClass = $resourceClass;
return $controller;
}
/**
* Return the appropriate Resource controller class based on the class_key request parameter
*
* @static
* @param modX $modx A reference to the modX instance
* @param string $className The controller class name that is attempting to be loaded
* @param array $config An array of configuration options for the action
* @return modManagerController The proper controller class
*/
public static function getInstance(modX &$modx, $className, array $config = array())
{
$resourceClass = 'modDocument';
$isDerivative = false;
if (!empty($_REQUEST['class_key'])) {
$isDerivative = true;
$resourceClass = in_array($_REQUEST['class_key'], array('modDocument', 'modResource')) ? 'modResource' : $_REQUEST['class_key'];
} else {
if (!empty($_REQUEST['id'])) {
/** @var modResource $resource */
$resource = $modx->getObject('modResource', $_REQUEST['id']);
if ($resource && !in_array($resource->get('class_key'), array('modDocument', 'modResource'))) {
$isDerivative = true;
$resourceClass = $resource->get('class_key');
}
}
}
if ($isDerivative) {
$resourceClass = str_replace(array('../', '..', '/', '\\'), '', $resourceClass);
$delegateView = $modx->call($resourceClass, 'getControllerPath', array(&$modx));
$action = strtolower(str_replace(array('Resource', 'ManagerController'), '', $className));
$className = str_replace('mod', '', $resourceClass) . ucfirst($action) . 'ManagerController';
$controllerFile = $delegateView . $action . '.class.php';
require_once $controllerFile;
}
$controller = new $className($modx, $config);
$controller->resourceClass = $resourceClass;
return $controller;
}
/**
* Return the appropriate Resource controller class based on the class_key request parameter
*
* @static
* @param modX $modx A reference to the modX instance
* @param string $className The controller class name that is attempting to be loaded
* @param array $config An array of configuration options for the action
* @return modManagerController The proper controller class
*/
public static function getInstance(modX &$modx, $className, array $config = array())
{
$resourceClass = 'modDocument';
$isDerivative = false;
if (!empty($_REQUEST['class_key'])) {
$isDerivative = true;
$resourceClass = in_array($_REQUEST['class_key'], array('modDocument', 'modResource')) ? 'modDocument' : $_REQUEST['class_key'];
if ($resourceClass == 'modResource') {
$resourceClass = 'modDocument';
}
} else {
if (!empty($_REQUEST['id']) && $_REQUEST['id'] != 'undefined') {
/** @var modResource $resource */
$resource = $modx->getObject('modResource', $_REQUEST['id']);
if ($resource && !in_array($resource->get('class_key'), array('modDocument', 'modResource'))) {
$isDerivative = true;
$resourceClass = $resource->get('class_key');
} else {
if ($resource && $resource->get('class_key') == 'modResource') {
/* fix improper class key */
$resource->set('class_key', 'modDocument');
$resource->save();
}
}
}
}
if ($isDerivative) {
$resourceClass = str_replace(array('../', '..', '/', '\\'), '', $resourceClass);
if (!class_exists($resourceClass) && !$modx->loadClass($resourceClass)) {
$resourceClass = 'modDocument';
}
$delegateView = $modx->call($resourceClass, 'getControllerPath', array(&$modx));
$action = strtolower(str_replace(array('Resource', 'ManagerController'), '', $className));
$className = str_replace('mod', '', $resourceClass) . ucfirst($action) . 'ManagerController';
$controllerFile = $delegateView . $action . '.class.php';
if (!file_exists($controllerFile)) {
$modx->setOption('manager_theme', 'default');
$delegateView = $modx->call($resourceClass, 'getControllerPath', array(&$modx));
$controllerFile = $delegateView . $action . '.class.php';
}
require_once $controllerFile;
}
$controller = new $className($modx, $config);
$controller->resourceClass = $resourceClass;
return $controller;
}
/**
* Loads the principal attributes that define a modUser security profile.
*
* {@inheritdoc}
*/
public function loadAttributes($target, $context = '', $reload = false)
{
$context = !empty($context) ? $context : $this->xpdo->context->get('key');
$id = $this->get('id') ? (string) $this->get('id') : '0';
if ($this->get('id') && !$reload) {
$staleContexts = $this->get('session_stale');
$staleContexts = !empty($staleContexts) ? $staleContexts : array();
$stale = array_search($context, $staleContexts);
if ($stale !== false) {
$reload = true;
$staleContexts = array_diff($staleContexts, array($context));
$this->set('session_stale', $staleContexts);
$this->save();
}
}
if ($this->_attributes === null || $reload) {
$this->_attributes = array();
if (isset($_SESSION["modx.user.{$id}.attributes"])) {
if ($reload) {
unset($_SESSION["modx.user.{$id}.attributes"]);
} else {
$this->_attributes = $_SESSION["modx.user.{$id}.attributes"];
}
}
}
if (!isset($this->_attributes[$context])) {
$this->_attributes[$context] = array();
}
$target = (array) $target;
foreach ($target as $t) {
if (!isset($this->_attributes[$context][$t])) {
$this->_attributes[$context][$t] = $this->xpdo->call($t, 'loadAttributes', array(&$this->xpdo, $context, $this->get('id')));
if (!isset($this->_attributes[$context][$t]) || !is_array($this->_attributes[$context][$t])) {
$this->_attributes[$context][$t] = array();
}
}
}
$_SESSION["modx.user.{$id}.attributes"] = $this->_attributes;
}
} elseif (strpos($object->path, $manager_path) === 0) {
$object->set('path', str_replace($manager_path, '{manager_path}', $object->path));
} elseif (strpos($object->path, $base_path) === 0) {
$object->set('path', str_replace($base_path, '{base_path}', $object->path));
}
if ($package->put($object, $classAttributes)) {
$instances++;
} else {
$modx->log(modX::LOG_LEVEL_WARN, "Could not package {$class} instance with pk: " . print_r($object->getPrimaryKey()));
}
}
$modx->log(modX::LOG_LEVEL_INFO, "Packaged {$instances} of {$class}");
continue 2;
case 'transport.modTransportPackage':
$modx->loadClass($class);
$response = $modx->call('modTransportPackage', 'listPackages', array(&$modx, $workspace->get('id')));
if (isset($response['collection'])) {
foreach ($response['collection'] as $object) {
$packagesDir = MODX_CORE_PATH . 'packages/';
if ($object->getOne('Workspace')) {
$packagesDir = $object->Workspace->get('path') . 'packages/';
}
$pkgSource = $object->get('source');
$folderPos = strrpos($pkgSource, '/');
$sourceDir = $folderPos > 1 ? substr($pkgSource, 0, $folderPos + 1) : '';
$source = realpath($packagesDir . $pkgSource);
$target = 'MODX_CORE_PATH . "packages/' . $sourceDir . '"';
$classAttributes = array_merge($attributes, array('resolve' => array(array('type' => 'file', 'source' => $source, 'target' => "return {$target};"))));
if ($package->put($object, $classAttributes)) {
$instances++;
} else {
/**
* Gets a sortable, limitable collection (and total count) of Resource Groups for the Resource.
*
* @param array $sort An array of sort columns in column => direction format.
* @param int $limit A limit of records to retrieve in the collection.
* @param int $offset A record offset for a limited collection.
* @return array An array containing the collection and total.
*/
public function getGroupsList(array $sort = array('id' => 'ASC'), $limit = 0, $offset = 0)
{
return $this->xpdo->call('modResource', 'listGroups', array(&$this, $sort, $limit, $offset));
}
/**
* Get the number of unanswered questions.
* @return int
*/
public function countUnansweredQuestions()
{
$response = $this->xpdo->call('disThread', 'fetchUnansweredQuestions', array(&$this->xpdo, "{$this->xpdo->escape('disThread')}.{$this->xpdo->escape('post_last_on')}", 'DESC', 10, 0, false, true));
return number_format($response['total']);
}
public function process()
{
//$startTime = microtime(true);
try {
$vaporOptions = array('excludeExtraTablePrefix' => array(), 'excludeExtraTables' => array(), 'excludeFiles' => array(MODX_BASE_PATH . 'vapor', MODX_BASE_PATH . 'phpmyadmin', MODX_BASE_PATH . 'assets', MODX_BASE_PATH . 'core'));
if (is_readable(VAPOR_DIR . 'config.php')) {
$vaporConfigOptions = @(include VAPOR_DIR . 'config.php');
if (is_array($vaporConfigOptions)) {
$vaporOptions = array_merge($vaporOptions, $vaporConfigOptions);
}
}
if (!XPDO_CLI_MODE && !ini_get('safe_mode')) {
set_time_limit(0);
}
$options = array('log_level' => xPDO::LOG_LEVEL_INFO, 'log_target' => array('target' => 'FILE', 'options' => array('filename' => 'vapor-' . strftime('%Y%m%dT%H%M%S', $this->getProperty('startTime')) . '.log')), xPDO::OPT_CACHE_DB => false, xPDO::OPT_SETUP => true);
$modx = new modX('', $options);
$modx->setLogTarget($options['log_target']);
$modx->setLogLevel($options['log_level']);
$modx->setOption(xPDO::OPT_CACHE_DB, false);
$modx->setOption(xPDO::OPT_SETUP, true);
$modx->setDebug(-1);
$modx->startTime = $this->getProperty('startTime');
$modx->getVersionData();
$modxVersion = $modx->version['full_version'];
if (version_compare($modxVersion, '2.2.1-pl', '>=')) {
$modx->initialize('mgr', $options);
} else {
$modx->initialize('mgr');
}
/*$modx->setLogTarget($options['log_target']);
$modx->setLogLevel($options['log_level']);*/
$modx->setOption(xPDO::OPT_CACHE_DB, false);
$modx->setOption(xPDO::OPT_SETUP, true);
$modx->setDebug(-1);
$modxDatabase = $modx->getOption('dbname', $options, $modx->getOption('database', $options));
$modxTablePrefix = $modx->getOption('table_prefix', $options, '');
$core_path = realpath($modx->getOption('core_path', $options, MODX_CORE_PATH)) . '/';
$assets_path = realpath($modx->getOption('assets_path', $options, MODX_ASSETS_PATH)) . '/';
$manager_path = realpath($modx->getOption('manager_path', $options, MODX_MANAGER_PATH)) . '/';
$base_path = realpath($modx->getOption('base_path', $options, MODX_BASE_PATH)) . '/';
$modx->log(modX::LOG_LEVEL_INFO, "core_path=" . $core_path);
$modx->log(modX::LOG_LEVEL_INFO, "assets_path=" . $assets_path);
$modx->log(modX::LOG_LEVEL_INFO, "manager_path=" . $manager_path);
$modx->log(modX::LOG_LEVEL_INFO, "base_path=" . $base_path);
$modx->loadClass('transport.modPackageBuilder', '', false, true);
$builder = new modPackageBuilder($modx);
/** @var modWorkspace $workspace */
$workspace = $modx->getObject('modWorkspace', 1);
if (!$workspace) {
$modx->log(modX::LOG_LEVEL_FATAL, "no workspace!");
}
$package = $builder->createPackage(PKG_NAME, PKG_VERSION, PKG_RELEASE);
/* Defines the classes to extract (also used for truncation) */
$classes = $this->getClassesList();
$attributes = array('vehicle_class' => 'xPDOFileVehicle');
/* get all files from the components directory */
/*$modx->log(modX::LOG_LEVEL_INFO, "Packaging " . MODX_CORE_PATH . 'components');
$package->put(
array(
'source' => MODX_CORE_PATH . 'components',
'target' => 'return MODX_CORE_PATH;'
),
array(
'vehicle_class' => 'xPDOFileVehicle'
)
);*/
/* get all files from the assets directory */
/*$modx->log(modX::LOG_LEVEL_INFO, "Packaging " . MODX_BASE_PATH . 'assets');
$package->put(
array(
'source' => MODX_BASE_PATH . 'assets',
'target' => 'return MODX_BASE_PATH;'
),
array(
'vehicle_class' => 'xPDOFileVehicle'
)
);*/
/* get all files from the manager/components directory */
/*$modx->log(modX::LOG_LEVEL_INFO, "Packaging " . MODX_MANAGER_PATH . 'components');
$package->put(
array(
'source' => MODX_MANAGER_PATH . 'components',
'target' => 'return MODX_MANAGER_PATH;'
),
array(
'vehicle_class' => 'xPDOFileVehicle'
)
);*/
/* find other files/directories in the MODX_BASE_PATH */
$excludes = array('_build', 'setup', 'assets', 'ht.access', 'index.php', 'config.core.php', dirname(MODX_CORE_PATH) . '/' === MODX_BASE_PATH ? basename(MODX_CORE_PATH) : 'core', dirname(MODX_CONNECTORS_PATH) . '/' === MODX_BASE_PATH ? basename(MODX_CONNECTORS_PATH) : 'connectors', dirname(MODX_MANAGER_PATH) . '/' === MODX_BASE_PATH ? basename(MODX_MANAGER_PATH) : 'manager');
if (isset($vaporOptions['excludeFiles']) && is_array($vaporOptions['excludeFiles'])) {
$excludes = array_unique($excludes + $vaporOptions['excludeFiles']);
}
/*if ($dh = opendir(MODX_BASE_PATH)) {
$includes = array();
while (($file = readdir($dh)) !== false) {
/* ignore files/dirs starting with . or matching an exclude */
/*if (strpos($file, '.') === 0 || in_array(strtolower($file), $excludes)) {
continue;
}
$includes[] = array(
'source' => MODX_BASE_PATH . $file,
'target' => 'return MODX_BASE_PATH;'
);
}
closedir($dh);
foreach ($includes as $include) {
$modx->log(modX::LOG_LEVEL_INFO, "Packaging " . $include['source']);
$package->put(
$include,
array(
'vehicle_class' => 'xPDOFileVehicle'
)
);
}
}*/
foreach ($this->getProperty('sources') as $source_id) {
// Try to get mediaSource
$loaded = $this->getSource($source_id);
if ($loaded !== true) {
return $this->failure($loaded);
}
/* Why for??
if (!$this->source->checkPolicy('delete')) {
return $this->failure($this->modx->lexicon('permission_denied'));
}*/
if ($properties = $this->source->getBases('') and $properties['pathIsRelative'] and $path = $properties['path']) {
if ($dh = opendir(MODX_BASE_PATH . $path)) {
$includes = array();
while (($file = readdir($dh)) !== false) {
/* ignore files/dirs starting with . or matching an exclude */
if (strpos($file, '.') === 0 || in_array(strtolower($file), $excludes)) {
continue;
}
$includes[] = array('source' => MODX_BASE_PATH . $path . $file, 'target' => "return MODX_BASE_PATH . '{$path}/';");
}
closedir($dh);
foreach ($includes as $include) {
$modx->log(modX::LOG_LEVEL_INFO, "Packaging " . $include['source']);
$package->put($include, array('vehicle_class' => 'xPDOFileVehicle'));
}
}
}
}
if (!XPDO_CLI_MODE && !ini_get('safe_mode')) {
set_time_limit(0);
}
/* package up the vapor model for use on install */
$modx->log(modX::LOG_LEVEL_INFO, "Packaging vaporVehicle class");
/*$package->put(
array(
'source' => VAPOR_DIR . 'model/vapor',
'target' => "return MODX_CORE_PATH . 'components/vapor/model/';"
),
array(
'vehicle_class' => 'xPDOFileVehicle',
'validate' => array(
array(
'type' => 'php',
'source' => VAPOR_DIR . 'scripts/validate.truncate_tables.php',
'classes' => $classes
),
),
'resolve' => array(
array(
'type' => 'php',
'source' => VAPOR_DIR . 'scripts/resolve.vapor_model.php'
)
)
)
);*/
$attributes = array('preserve_keys' => true, 'update_object' => true);
/* get the extension_packages and resolver */
if ($this->getProperty('includeExtensionPackages')) {
$object = $modx->getObject('modSystemSetting', array('key' => 'extension_packages'));
if ($object) {
$extPackages = $object->get('value');
$extPackages = $modx->fromJSON($extPackages);
foreach ($extPackages as &$extPackage) {
if (!is_array($extPackage)) {
continue;
}
foreach ($extPackage as $pkgName => &$pkg) {
if (!empty($pkg['path']) && strpos($pkg['path'], '[[++') === false) {
if (substr($pkg['path'], 0, 1) !== '/' || strpos($pkg['path'], $base_path) !== 0 && strpos($pkg['path'], $core_path) !== 0) {
$path = realpath($pkg['path']);
if ($path === false) {
$path = $pkg['path'];
} else {
$path = rtrim($path, '/') . '/';
}
} else {
$path = $pkg['path'];
}
if (strpos($path, $core_path) === 0) {
$path = str_replace($core_path, '[[++core_path]]', $path);
} elseif (strpos($path, $assets_path) === 0) {
$path = str_replace($assets_path, '[[++assets_path]]', $path);
} elseif (strpos($path, $manager_path) === 0) {
$path = str_replace($manager_path, '[[++manager_path]]', $path);
} elseif (strpos($path, $base_path) === 0) {
$path = str_replace($base_path, '[[++base_path]]', $path);
}
$pkg['path'] = $path;
}
}
}
$modx->log(modX::LOG_LEVEL_INFO, "Setting extension packages to: " . print_r($extPackages, true));
$object->set('value', $modx->toJSON($extPackages));
$package->put($object, array_merge($attributes, array('resolve' => array(array('type' => 'php', 'source' => VAPOR_DIR . 'scripts/resolve.extension_packages.php')))));
}
}
/* loop through the classes and package the objects */
foreach ($classes as $class) {
if (!XPDO_CLI_MODE && !ini_get('safe_mode')) {
set_time_limit(0);
}
$instances = 0;
$classCriteria = null;
$classAttributes = $attributes;
switch ($class) {
case 'modSession':
/* skip sessions */
continue 2;
case 'modSystemSetting':
$classCriteria = array('key:!=' => 'extension_packages');
break;
case 'modWorkspace':
/** @var modWorkspace $object */
foreach ($modx->getIterator('modWorkspace', $classCriteria) as $object) {
if (strpos($object->path, $core_path) === 0) {
$object->set('path', str_replace($core_path, '{core_path}', $object->path));
} elseif (strpos($object->path, $assets_path) === 0) {
$object->set('path', str_replace($assets_path, '{assets_path}', $object->path));
} elseif (strpos($object->path, $manager_path) === 0) {
$object->set('path', str_replace($manager_path, '{manager_path}', $object->path));
} elseif (strpos($object->path, $base_path) === 0) {
$object->set('path', str_replace($base_path, '{base_path}', $object->path));
}
if ($package->put($object, $classAttributes)) {
$instances++;
} else {
$modx->log(modX::LOG_LEVEL_WARN, "Could not package {$class} instance with pk: " . print_r($object->getPrimaryKey(), true));
}
}
$modx->log(modX::LOG_LEVEL_INFO, "Packaged {$instances} of {$class}");
continue 2;
case 'transport.modTransportPackage':
$modx->loadClass($class);
$response = $modx->call('modTransportPackage', 'listPackages', array(&$modx, $workspace->get('id')));
if (isset($response['collection'])) {
foreach ($response['collection'] as $object) {
$packagesDir = MODX_CORE_PATH . 'packages/';
if ($object->getOne('Workspace')) {
$packagesDir = $object->Workspace->get('path') . 'packages/';
}
$pkgSource = $object->get('source');
$folderPos = strrpos($pkgSource, '/');
$sourceDir = $folderPos > 1 ? substr($pkgSource, 0, $folderPos + 1) : '';
$source = realpath($packagesDir . $pkgSource);
$target = 'MODX_CORE_PATH . "packages/' . $sourceDir . '"';
$classAttributes = array_merge($attributes, array('resolve' => array(array('type' => 'file', 'source' => $source, 'target' => "return {$target};"))));
if ($package->put($object, $classAttributes)) {
$instances++;
} else {
$modx->log(modX::LOG_LEVEL_WARN, "Could not package {$class} instance with pk: " . print_r($object->getPrimaryKey(), true));
}
}
}
$modx->log(modX::LOG_LEVEL_INFO, "Packaged {$instances} of {$class}");
continue 2;
case 'sources.modMediaSource':
foreach ($modx->getIterator('sources.modMediaSource') as $object) {
$classAttributes = $attributes;
/** @var modMediaSource $object */
if ($object->get('is_stream') && $object->initialize()) {
$sourceBases = $object->getBases('');
$source = $object->getBasePath();
if (!$sourceBases['pathIsRelative'] && strpos($source, '://') === false) {
$sourceBasePath = $source;
if (strpos($source, $base_path) === 0) {
$sourceBasePath = str_replace($base_path, '', $sourceBasePath);
$classAttributes['resolve'][] = array('type' => 'php', 'source' => VAPOR_DIR . 'scripts/resolve.media_source.php', 'target' => $sourceBasePath, 'targetRelative' => true);
} else {
/* when coming from Windows sources, remove "{volume}:" */
if (strpos($source, ':\\') !== false || strpos($source, ':/') !== false) {
$sourceBasePath = str_replace('\\', '/', substr($source, strpos($source, ':') + 1));
}
$target = 'dirname(MODX_BASE_PATH) . "/sources/' . ltrim(dirname($sourceBasePath), '/') . '/"';
$classAttributes['resolve'][] = array('type' => 'file', 'source' => $source, 'target' => "return {$target};");
$classAttributes['resolve'][] = array('type' => 'php', 'source' => VAPOR_DIR . 'scripts/resolve.media_source.php', 'target' => $sourceBasePath, 'targetRelative' => false, 'targetPrepend' => "return dirname(MODX_BASE_PATH) . '/sources/';");
}
}
}
if ($package->put($object, $classAttributes)) {
$instances++;
} else {
$modx->log(modX::LOG_LEVEL_WARN, "Could not package {$class} instance with pk: " . print_r($object->getPrimaryKey(), true));
}
}
$modx->log(modX::LOG_LEVEL_INFO, "Packaged {$instances} of {$class}");
continue 2;
default:
break;
}
/** @var xPDOObject $object */
foreach ($modx->getIterator($class, $classCriteria) as $object) {
if ($package->put($object, $classAttributes)) {
$instances++;
} else {
$modx->log(modX::LOG_LEVEL_WARN, "Could not package {$class} instance with pk: " . print_r($object->getPrimaryKey(), true));
}
}
$modx->log(modX::LOG_LEVEL_INFO, "Packaged {$instances} of {$class}");
}
/* collect table names from classes and grab any additional tables/data not listed */
$coreTables = array();
$extraTables = array();
foreach ($classes as $class) {
$coreTables[$class] = $modx->quote($modx->literal($modx->getTableName($class)));
}
if ($coreTables) {
$stmt = $modx->query("SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = '{$modxDatabase}' AND TABLE_NAME NOT IN (" . implode(',', $coreTables) . ")");
$extraTables = $stmt->fetchAll(PDO::FETCH_COLUMN);
}
if (is_array($extraTables) && !empty($extraTables)) {
//$modx->loadClass('vapor.vaporVehicle', VAPOR_DIR . 'model/', true, true);
$modx->loadClass('vapor.vaporVehicle', VAPOR_DIR, true, true);
$excludeExtraTablePrefix = isset($vaporOptions['excludeExtraTablePrefix']) && is_array($vaporOptions['excludeExtraTablePrefix']) ? $vaporOptions['excludeExtraTablePrefix'] : array();
$excludeExtraTables = isset($vaporOptions['excludeExtraTables']) && is_array($vaporOptions['excludeExtraTables']) ? $vaporOptions['excludeExtraTables'] : array();
foreach ($extraTables as $extraTable) {
if (in_array($extraTable, $excludeExtraTables)) {
continue;
}
if (!XPDO_CLI_MODE && !ini_get('safe_mode')) {
set_time_limit(0);
}
$instances = 0;
$object = array();
$attributes = array('vehicle_package' => 'vapor', 'vehicle_class' => 'vaporVehicle');
/* remove modx table_prefix if table starts with it */
$extraTableName = $extraTable;
if (!empty($modxTablePrefix) && strpos($extraTableName, $modxTablePrefix) === 0) {
$extraTableName = substr($extraTableName, strlen($modxTablePrefix));
$addTablePrefix = true;
} elseif (!empty($modxTablePrefix) || in_array($extraTableName, $excludeExtraTablePrefix)) {
$addTablePrefix = false;
} else {
$addTablePrefix = true;
}
$object['tableName'] = $extraTableName;
$modx->log(modX::LOG_LEVEL_INFO, "Extracting non-core table {$extraTableName}");
/* generate the CREATE TABLE statement */
$stmt = $modx->query("SHOW CREATE TABLE {$modx->escape($extraTable)}");
$resultSet = $stmt->fetch(PDO::FETCH_NUM);
$stmt->closeCursor();
if (isset($resultSet[1])) {
if ($addTablePrefix) {
$object['drop'] = "DROP TABLE IF EXISTS {$modx->escape('[[++table_prefix]]' . $extraTableName)}";
$object['table'] = str_replace("CREATE TABLE {$modx->escape($extraTable)}", "CREATE TABLE {$modx->escape('[[++table_prefix]]' . $extraTableName)}", $resultSet[1]);
} else {
$object['drop'] = "DROP TABLE IF EXISTS {$modx->escape($extraTableName)}";
$object['table'] = $resultSet[1];
}
/* collect the rows and generate INSERT statements */
$object['data'] = array();
$stmt = $modx->query("SELECT * FROM {$modx->escape($extraTable)}");
while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
if ($instances === 0) {
$fields = implode(', ', array_map(array($modx, 'escape'), array_keys($row)));
}
$values = array();
while (list($key, $value) = each($row)) {
switch (gettype($value)) {
case 'string':
$values[] = $modx->quote($value);
break;
case 'NULL':
case 'array':
case 'object':
case 'resource':
case 'unknown type':
$values[] = 'NULL';
break;
default:
$values[] = (string) $value;
break;
}
}
$values = implode(', ', $values);
if ($addTablePrefix) {
$object['data'][] = "INSERT INTO {$modx->escape('[[++table_prefix]]' . $extraTableName)} ({$fields}) VALUES ({$values})";
} else {
$object['data'][] = "INSERT INTO {$modx->escape($extraTable)} ({$fields}) VALUES ({$values})";
}
$instances++;
}
}
if (!$package->put($object, $attributes)) {
$modx->log(modX::LOG_LEVEL_WARN, "Could not package rows for table {$extraTable}: " . print_r($object, true));
} else {
$modx->log(modX::LOG_LEVEL_INFO, "Packaged {$instances} rows for table {$extraTable}");
}
}
}
if (!XPDO_CLI_MODE && !ini_get('safe_mode')) {
set_time_limit(0);
}
if (!$package->pack()) {
$message = "Error extracting package, could not pack transport: {$package->signature}";
$modx->log(modX::LOG_LEVEL_ERROR, $message);
//echo "{$message}\n";
} else {
$message = "Completed extracting package: {$package->signature}";
$modx->log(modX::LOG_LEVEL_INFO, $message);
//echo "{$message}\n";
}
$endTime = microtime(true);
$msg = sprintf("Vapor execution completed without exception in %2.4fs", $endTime - $this->getProperty('startTime'));
$modx->log(modX::LOG_LEVEL_INFO, $msg);
return $this->success($msg, array('signature' => $package->signature));
} catch (Exception $e) {
if (empty($endTime)) {
$endTime = microtime(true);
}
if (!empty($modx)) {
$modx->log(modX::LOG_LEVEL_ERROR, $e->getMessage());
$msg = sprintf("Vapor execution completed with exception in %2.4fs", $endTime - $this->getProperty('startTime'));
$modx->log(modX::LOG_LEVEL_INFO, $msg);
return $this->failure($msg);
} else {
//echo $e->getMessage() . "\n";
}
$msg = sprintf("Vapor execution completed with exception in %2.4fs\n", $endTime - $this->getProperty('startTime'));
$modx->log(modX::LOG_LEVEL_INFO, $msg);
return $this->failure($msg);
}
return $modx->success(printf("Vapor execution completed without exception in %2.4fs\n", $endTime - $this->getProperty('startTime')));
}
