Пример #1
0
 function update041()
 {
     $this->mLog->addReport(_AD_LEGACY_MESSAGE_UPDATE_STARTED);
     //Add Table
     $sqlfileInfo = $this->_mTargetXoopsModule->getInfo('sqlfile');
     $dirname = $this->_mTargetXoopsModule->getVar('dirname');
     $sqlfile = $sqlfileInfo[XOOPS_DB_TYPE];
     $sqlfilepath = XOOPS_MODULE_PATH . '/' . $dirname . '/' . $sqlfile;
     require_once XOOPS_MODULE_PATH . '/legacy/admin/class/Legacy_SQLScanner.class.php';
     $scanner = new Legacy_SQLScanner();
     $scanner->setDB_PREFIX(XOOPS_DB_PREFIX);
     $scanner->setDirname($this->_mTargetXoopsModule->get('dirname'));
     if (!$scanner->loadFile($sqlfilepath)) {
         $this->mLog->addError(XCube_Utils::formatMessage(_AD_LEGACY_ERROR_SQL_FILE_NOT_FOUND, $sqlfile));
         return false;
     }
     $scanner->parse();
     $sqls = $scanner->getSQL();
     $root = XCube_Root::getSingleton();
     $db = $root->mController->getDB();
     foreach ($sqls as $sql) {
         if (strpos($sql, '_message_users') !== false) {
             if (!$db->query($sql)) {
                 $this->mLog->addError($db->error());
                 return false;
             }
         }
     }
     $this->mLog->addReport(_AD_LEGACY_MESSAGE_DATABASE_SETUP_FINISHED);
     //add table
     $this->updatemain();
     return true;
 }
Пример #2
0
 /**
  * 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;
 }
Пример #4
0
 /**
  * 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;
 }