/**
* DBquery
*
* @param string $query
* @param XoopsModule &$module
* @param Legacy_ModuleInstallLog &$log
*
* @return bool
**/
public static function DBquery($query, &$module, &$log)
{
require_once XOOPS_MODULE_PATH . '/legacy/admin/class/Legacy_SQLScanner.class.php';
// TODO will be use other class?
$scanner = new Legacy_SQLScanner();
$scanner->setDB_PREFIX(XOOPS_DB_PREFIX);
$scanner->setDirname($module->get('dirname'));
$scanner->setBuffer($query);
$scanner->parse();
$sqls = $scanner->getSQL();
$root =& XCube_Root::getSingleton();
$successFlag = true;
foreach ($sqls as $sql) {
if ($root->mController->mDB->query($sql)) {
$log->addReport(XCube_Utils::formatString(_MI_LEIMG_INSTALL_MSG_SQL_SUCCESS, $sql));
} else {
$log->addReport(XCube_Utils::formatString(_MI_LEIMG_INSTALL_MSG_SQL_ERROR, $sql));
$successFlag = false;
}
}
return $successFlag;
}
/**
* DB query.
*
* @param string $query
* @param XoopsModule &$module
* @param Legacy_ModuleInstallLog &$log
*
* @return bool
*/
public static function DBquery($query, &$module, &$log)
{
$dirname = $module->get('dirname');
$constpref = '_MI_' . strtoupper($dirname);
require_once XOOPS_MODULE_PATH . '/legacy/admin/class/Legacy_SQLScanner.class.php';
$scanner = new Legacy_SQLScanner();
$scanner->setDB_PREFIX(XOOPS_DB_PREFIX);
$scanner->setDirname($dirname);
$scanner->setBuffer($query);
$scanner->parse();
$sqls = $scanner->getSQL();
$root =& XCube_Root::getSingleton();
$successFlag = true;
foreach ($sqls as $sql) {
if ($root->mController->mDB->query($sql)) {
$log->addReport(XCube_Utils::formatString(constant($constpref . '_INSTALL_MSG_SQL_SUCCESS'), $sql));
} else {
$log->addReport(XCube_Utils::formatString(constant($constpref . '_INSTALL_MSG_SQL_ERROR'), $sql));
$successFlag = false;
}
}
return $successFlag;
}
/**
* Executes SQL query as cube style.
*/
function DBquery($query, &$module, $log)
{
require_once XOOPS_MODULE_PATH . "/legacy/admin/class/Legacy_SQLScanner.class.php";
$successFlag = true;
$scanner = new Legacy_SQLScanner();
$scanner->setDB_PREFIX(XOOPS_DB_PREFIX);
$scanner->setDirname($module->get('dirname'));
$scanner->setBuffer($query);
$scanner->parse();
$sqlArr = $scanner->getSQL();
$root =& XCube_Root::getSingleton();
foreach ($sqlArr as $sql) {
if ($root->mController->mDB->query($sql)) {
$log->addReport("Success: {$sql}");
$successFlag &= true;
} else {
$log->addError("Failure: {$sql}");
$successFlag = false;
}
}
return $successFlag;
}
