PHP I2CE::runSQLScript Examples

Example #1

File: I2CE_Module_UserAccess.php Project: apelon-ohie/ihris-site

 protected function updateAccessTable()
 {
     $db = MDB2::singleton();
     $options = self::getInitOptions(I2CE::getUserAccessInit('DEFAULT'));
     $rows = $db->queryAll("SHOW FULL COLUMNS FROM " . $options['accessTable'] . " WHERE Field='role'");
     if (substr($rows[0]->type, 0, 3) != 'int') {
         I2CE::raiseError("NOT doing access table");
         return true;
     }
     I2CE::raiseError("Altering access table to 3.x format");
     return I2CE::runSQLScript('update-access-table.sql');
 }