*/
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)) {
