if (!$del_db->connect($db_server, $db_user, $db_pw, $db_name)) { $error = $messageStack->add(SETUP_CO_MGR_CANNOT_CONNECT, 'error'); } if (!$error) { $tables = array(); $table_list = $del_db->Execute("show tables"); while (!$table_list->EOF) { $tables[] = array_shift($table_list->fields); $table_list->MoveNext(); } if (is_array($tables)) { foreach ($tables as $table) { $del_db->Execute("drop table " . $table); } } $backup->delete_dir(DIR_FS_MY_FILES . $db_name); unset($_SESSION['companies'][$_POST['del_company']]); gen_add_audit_log(SETUP_CO_MGR_LOG . TEXT_DELETE, $db_name); $messageStack->add(SETUP_CO_MGR_DELETE_SUCCESS, 'success'); } } $default_tab_id = 'manager'; break; case 'ordr_nums': validate_security($security_level, 3); // read in the requested status values $sequence_array = array(); foreach ($status_fields as $status_field) { if (db_prepare_input($_POST[$status_field]) != $status_values->fields[$status_field]) { $sequence_array[$status_field] = db_prepare_input($_POST[$status_field]); $status_values->fields[$status_field] = $sequence_array[$status_field];
} if (!$error) { gen_add_audit_log(GEN_DB_DATA_BACKUP, TABLE_AUDIT_LOG); $backup->download($backup->dest_dir, $backup->dest_file); // will not return if successful } $default_tab_id = 'tools'; break; case 'clean': $carrier = db_prepare_input($_POST['carrier']); $fy_month = db_prepare_input($_POST['fy_month']); $fy_year = db_prepare_input($_POST['fy_year']); $conv_type = db_prepare_input($_POST['conv_type']); $backup = new backup(); $backup->source_dir = DIR_FS_MY_FILES . $_SESSION['company'] . '/shipping/labels/' . $carrier . '/' . $fy_year . '/' . $fy_month . '/'; if ($backup->delete_dir($backup->source_dir, $recursive = true)) { $error = true; } if (!$error) { gen_add_audit_log(GEN_FILE_DATA_CLEAN); } $default_tab_id = 'tools'; break; default: } /***************** prepare to display templates *************************/ // build some general pull down arrays $sel_yes_no = array(array('id' => '0', 'text' => TEXT_NO), array('id' => '1', 'text' => TEXT_YES)); $sel_checked = array(array('id' => '0', 'text' => TEXT_UNCHECKED), array('id' => '1', 'text' => TEXT_CHECKED)); $sel_show = array(array('id' => '0', 'text' => TEXT_HIDE), array('id' => '1', 'text' => TEXT_SHOW)); $sel_fy_month = array(array('id' => '01', 'text' => TEXT_JAN), array('id' => '02', 'text' => TEXT_FEB), array('id' => '03', 'text' => TEXT_MAR), array('id' => '04', 'text' => TEXT_APR), array('id' => '05', 'text' => TEXT_MAY), array('id' => '06', 'text' => TEXT_JUN), array('id' => '07', 'text' => TEXT_JUL), array('id' => '08', 'text' => TEXT_AUG), array('id' => '09', 'text' => TEXT_SEP), array('id' => '10', 'text' => TEXT_OCT), array('id' => '11', 'text' => TEXT_NOV), array('id' => '12', 'text' => TEXT_DEC));
case 'export': $dir = DIR_FS_MY_FILES . 'translator/'; $pieces = explode(':', $_POST['rowSeq']); $mod = $pieces[0]; $lang = $pieces[1]; $ver = $pieces[2]; $backup->source_dir = $dir . 'export/'; $backup->dest_dir = $dir; $backup->dest_file = $mod . '_' . $lang . '_R' . str_replace('.', '', $ver) . '.zip'; if (!($result = $translator->export_language($mod, $lang, $ver))) { $error = true; } if ($backup->make_zip('dir')) { $error = true; } if ($backup->delete_dir($backup->source_dir)) { $error = true; } if (!$error) { gen_add_audit_log(TEXT_EDIT_TRANSLATION . ' (' . TEXT_EXPORT . ')', $mod . ' ' . lang . ' R' . $ver); $backup->download($backup->dest_dir, $backup->dest_file); // will not return if successful } break; case 'export_all_go': $dir = DIR_FS_MY_FILES . 'translator/'; $lang = db_prepare_input($_POST['lang']); $backup->source_dir = $dir . 'export/'; $backup->dest_dir = $dir; $backup->dest_file = 'language_' . $lang . '_Rxx.zip'; $sel_modules = build_mod_list();