$focus->del_create_def_folder($focus->query);
$dbQuery = "select * from vtiger_attachmentsfolder";
$result = $adb->pquery($dbQuery, array());
$foldercount = $adb->num_rows($result);
$folders = array();
$emptyfolders = array();
if ($foldercount > 0) {
for ($i = 0; $i < $foldercount; $i++) {
$query = '';
$displayFolder = '';
$query = $focus->query;
$list_query = '';
$list_query = $focus->query;
$folder_id = $adb->query_result($result, $i, "folderid");
$query .= " and vtiger_notes.folderid = {$folder_id}";
$sorder = $focus->getSortOrderForFolder($folder_id);
if (!is_array($_SESSION['NOTES_FOLDER_SORT_ORDER'])) {
$_SESSION['NOTES_FOLDER_SORT_ORDER'] = array();
}
$_SESSION['NOTES_FOLDER_SORT_ORDER'][$folder_id] = $sorder;
$order_by = $focus->getOrderByForFolder($folder_id);
if (!is_array($_SESSION['NOTES_FOLDER_ORDER_BY'])) {
$_SESSION['NOTES_FOLDER_ORDER_BY'] = array();
}
$_SESSION['NOTES_FOLDER_ORDER_BY'][$folder_id] = $order_by;
if ($folder_id != $request_folderid) {
$start[$folder_id] = 1;
}
if (isset($order_by) && $order_by != '') {
$tablename = getTableNameForField('Documents', $order_by);
$tablename = $tablename != '' ? $tablename . "." : '';