*/ global $sugar_config; global $locale; global $current_user; global $app_list_strings; $filename = "SweetDBExport-" . date("m-d-Y(h:i:s)"); if ($sugar_config['disable_export'] || !empty($sugar_config['admin_export_only']) && !(is_admin($current_user) || ACLController::moduleSupportsACL($the_module) && ACLAction::getUserAccessLevel($current_user->id, $the_module, 'access') == ACL_ALLOW_ENABLED && (ACLAction::getUserAccessLevel($current_user->id, $the_module, 'admin') == ACL_ALLOW_ADMIN || ACLAction::getUserAccessLevel($current_user->id, $the_module, 'admin') == ACL_ALLOW_ADMIN_DEV))) { die($GLOBALS['app_strings']['ERR_EXPORT_DISABLED']); } ini_set('zlib.output_compression', 'Off'); ob_end_clean(); ob_start(); $header = FALSE; $headerArray = array(); $content = ""; $sql = trim(SweetDB::getRequestVar('sql', '')); $result = $GLOBALS['db']->query($sql, TRUE); while ($hash = $GLOBALS['db']->fetchByAssoc($result)) { if (!$header) { $header = TRUE; foreach ($hash as $colName => $colValue) { $headerArray[] = $colName; } $content = '"' . implode('", "', $headerArray) . '"'; $content .= "\r\n"; } $lineArray = array(); $lineData = ""; foreach ($hash as $colName => $colValue) { array_push($lineArray, preg_replace("/\"/", "\"\"", $colValue)); }
require_once 'custom/modules/Administration/SweetDBAdmin/classes/class.indexes.php'; require_once 'custom/modules/Administration/SweetDBAdmin/classes/class.query.php'; require_once 'custom/modules/Administration/SweetDBAdmin/classes/class.search.php'; require_once 'custom/modules/Administration/SweetDBAdmin/classes/class.readLog.php'; require_once 'custom/modules/Administration/SweetDBAdmin/classes/class.crud.php'; require_once 'custom/modules/Administration/SweetDBAdmin/classes/class.table.php'; global $current_user; global $mod_strings; global $app_list_strings; global $app_strings; global $theme; $title = getClassicModuleTitle("Administration", array("<a href='../../../modules/Administration/index.php?module=Administration&action=SweetDBAdmin'>{$mod_strings['LBL_MODULE_NAME']}</a>", translate('LBL_SWEETDBADMIN')), FALSE); //set up classes $SweetDB_query = new SweetDB_query(); $SweetDB = new SweetDB(); $command = $SweetDB->getRequestVar('command', "query"); $numOfRecords = $SweetDB->getRequestVar('numrecords', 50); $startRecord = $SweetDB->getRequestVar('startrecord', 0); $scriptName = $SweetDB->getRequestVar('action', ""); $SweetDB->sugar_smarty->assign("mod", $mod_strings); $SweetDB->sugar_smarty->assign("app", $app_strings); $SweetDB->sugar_smarty->assign("NUM_RECORDS", $numOfRecords); $SweetDB->sugar_smarty->assign("START_RECORD", $startRecord); $SweetDB->sugar_smarty->assign("SCRIPTNAME", $scriptName); $SweetDB->sugar_smarty->assign("TABLE", $SweetDB->getTable()); $SweetDB->sugar_smarty->assign("TITLE", $title); $SweetDB->sugar_smarty->assign("MODULE", getCurrentModule($SweetDB->getTable())); if (file_exists('cache/SweetDB_sqlHistory.php')) { include_once 'cache/SweetDB_sqlHistory.php'; } if (isset($sqlHistory) && !empty($sqlHistory)) {