expand; if(!isset($order)) $order = "name"; if(!isset($sortname)) $sortname = "ASC"; // Daphne change if(!isset($sortver)) $sortver = "ASC, minor_revision ASC"; if(!isset($sortcheckedout)) $sortcheckedout = "ASC"; // end daphne change if(!isset($sortfilename)) $sortfilename = "DESC"; if(!isset($sortsize)) $sortsize = "DESC"; if(!isset($sortposted)) $sortposted = "DESC"; if(!isset($sortmod)) $sortmod = "DESC"; if(!isset($sort)) $sort = "asc"; // Begin 496814 Column Sorts are not persistant switch ($order) { case "name": $sortorder = 'sortname'; $sort=$sortname; break; case "major_revision": $sortorder = 'sortver'; $sort=$sortver; break; case "filename" : $sortorder = 'sortfilename'; $sort=$sortfilename; break; case "size" : $sortorder = 'sortsize'; $sort=$sortsize; break; case "creatorid" : $sortorder = 'sortposted'; $sort=$sortposted; break; case "smodified" : $sortorder = 'sortmod'; $sort=$sortmod; break; case "checked_out": $sortorder = 'sortcheckedout'; $sort = $sortcheckedout; break; default: $sort="ASC"; break; } // END 496814 Column Sorts are not persistant if(check_auth($parent, "folder_view", $userid) != "1") { printError($lang_nofolderaccess,""); exit; } print("table_expand_width BGCOLOR=$default->main_header_bgcolor CELLSPACING=0 CELLPADDING=0 BORDER=$default->table_border HEIGHT=30>"); ?>
"); } print uid_to_name($userid); print (""); ?> $lang_logout");?>  "); print("  "); print("   "); if($expand==1) { print("owl_root_url/locale/$default->owl_lang/graphics/btn_collapse_view.gif' \t\tBORDER=0>"); } else { print("\t\t\towl_root_url/locale/$default->owl_lang/graphics/btn_expand_view.gif' \t\tBORDER=0>  \n"); } print("
"); print("
"); if ($expand == 1) { print("\t\ttable_expand_width BORDER=$default->table_border>\n"); } else { print("\t\t
table_collapse_width BORDER=$default->table_border>\n"); } print("\t\t\t"); print("\t\t\t
" . gen_navbar($parent) . "
"); if ($expand == 1) { print("\t\t
table_expand_width>\n"); } else { print("\t\t
table_collapse_width>\n"); } // // functions to create/show the links to be sorted on // function show_link($column,$sortname,$sortvalue,$order,$sess,$expand,$parent,$lang_title,$url) { if ($sortvalue == "ASC") { print("\t\t\t\t$lang_title"); if ($order == $column) { print(""); } else { print(""); } } else { print("\t\t\t\t$lang_title"); if ($order == $column) { print(""); } else { print(""); } } } if ($expand == 1) { print("\t\t\ttable_expand_width BORDER=$default->table_border>"); show_link("name","sortname",$sortname,$order,$sess,$expand,$parent,$lang_title,$default->owl_root_url); // Daphne change - column for files checked out if ($default->owl_version_control == 1) { show_link("major_revision","sortver",$sortver,$order,$sess,$expand,$parent,$lang_ver,$default->owl_root_url); } // end Daphne change show_link("filename","sortfilename",$sortfilename,$order,$sess,$expand,$parent,$lang_file,$default->owl_root_url); show_link("size","sortsize",$sortsize,$order,$sess,$expand,$parent,$lang_size,$default->owl_root_url); show_link("creatorid","sortposted", $sortposted,$order,$sess,$expand,$parent,$lang_postedby,$default->owl_root_url); show_link("smodified","sortmod", $sortmod,$order,$sess,$expand,$parent,$lang_modified,$default->owl_root_url); print(""); // Daphne change - column for files checked out if ($default->owl_version_control == 1) { show_link("checked_out","sortcheckedout", $sortcheckedout, $order,$sess,$expand,$parent,$lang_held,$default->owl_root_url); } // end Daphne change } else { print("\t\t\t
$lang_actions
table_collapse_width BORDER=$default->table_border>"); show_link("name","sortname",$sortname,$order,$sess,$expand,$parent,$lang_title,$default->owl_root_url); // Begin Daphne Change if ($default->owl_version_control == 1) { show_link("major_revision","sortver",$sortver,$order,$sess,$expand,$parent,$lang_ver,$default->owl_root_url); } // end Daphne change show_link("filename","sortfilename",$sortfilename,$order,$sess,$expand,$parent,$lang_file,$default->owl_root_url); show_link("size","sortsize",$sortsize,$order,$sess,$expand,$parent,$lang_size,$default->owl_root_url); // Daphne change - column for files checked out if ($default->owl_version_control == 1) { show_link("checked_out","sortcheckedout", $sortcheckedout, $order,$sess,$expand,$parent,$lang_held,$default->owl_root_url); } // end Daphne change } //Looping out Folders $DBFolderCount = 0; $CountLines = 0; $sql = new Owl_DB; if ($order == "creatorid") { $sql->query("SELECT * from $default->owl_folders_table where parent = '$parent' order by $order"); } else { $sql->query("SELECT * from $default->owl_folders_table where parent = '$parent' order by name "); } //********************** //* BEGIN Print Folders //********************** while($sql->next_record()) { if($default->restrict_view == 1) { if(!check_auth($sql->f("id"), "folder_view", $userid)) continue; } $CountLines++; $PrintLines = $CountLines % 2; if ($PrintLines == 0) print("\t\t\t\t"); else print("\t\t\t\t"); print(""); $DBFolderCount++; //count number of filez in db 2 use with array $DBFolders[$DBFolderCount] = $sql->f("name"); //create list if files in if($expand == 1) { print("\t\t\t\t"); // begin Daphne change // extra colunm width for "version" column which folders don't need if ($default->owl_version_control == 1) { print(""); } // end Daphne change print(""); if ($default->owl_version_control == 1) print (""); print(""); } else { //print(""); print("\t\t\t\t"); // begin Daphne change // extra column width for "held" column which folders don't need if ($default->owl_version_control == 1) { if ($PrintLines == 0) print (""); else print (""); } // end Daphne change print(""); } } if ($default->owl_LookAtHD != "false") { $DBFolders[$DBFolderCount+1] = "[END]"; //end DBfolder array $RefreshPage = CompareDBnHD('folder', $default->owl_FileDir . "/" . get_dirpath($parent), $DBFolders, $parent, $default->owl_folders_table); } //********************** // BEGIN Print Files //********************** $sql = new Owl_DB; //$sql->query("SELECT * from $default->owl_files_table where parent = '$parent' order by $order $sort"); if ($default->owl_version_control == 1) { //$sql->query("drop table tmp"); $sql->query("create temporary table tmp (name char(80) not null, parent int(4) not null, val double(4,2) not null)"); // POSTGRES? $sql->query("create temporary table tmp (name varchar(80) not null, parent int4 not null, val float not null);"); //$sql->query("lock tables files read"); $sql->query("insert into tmp select name, parent, max(major_revision+(minor_revision/10)) from files group by name,parent"); $sql->query("select files.* from files,tmp where files.name=tmp.name and major_revision+(minor_revision/10)=tmp.val AND tmp.parent=files.parent AND tmp.parent = '$parent' order by $order $sort"); } else { $sql->query("select * from $default->owl_files_table where parent = '$parent' order by $order $sort" ); } //Looping out files from DB! $DBFileCount = 0; while($sql->next_record()) { if($default->restrict_view == 1) { if(!check_auth($sql->f("id"), "file_download", $userid)) continue; } $CountLines++; $PrintLines = $CountLines % 2; if ($PrintLines == 0) print("\t\t\t\t"); else print("\t\t\t\t"); print(""); else print($sql->f("name").""); // Begin Daphne Change // print version numbers if version control used if ($default->owl_version_control == 1){ if($fileid == $sql->f("id")) print(""); else print(""); } // end Daphne Change if ($sql->f("url") == "1") if($fileid == $sql->f("id")) print(""); else print(""); else if($fileid == $sql->f("id")) print(""); else print(""); $DBFileCount++; //count number of filez in db 2 use with array $DBFiles[$DBFileCount] = $sql->f("filename"); //create list if files in //print("

HERE WE ARE ID - $tmp

"); //exit(); if($expand ==1) { if($fileid == $sql->f("id")) print("\t\t\t\t"); else print("\t\t\t\t"); print("\t\t\t\t"); } else { print("\t"); } } // end Daphne Change } if ($default->owl_version_control == 1) { //$sql->query("unlock tables"); $sql->query("drop table tmp"); } $DBFiles[$DBFileCount+1] = "[END]"; //end DBfile array print("
" . $sql->f("name") . "     "); if(check_auth($sql->f("id"), "folder_delete", $userid) == 1) print("\t$lang_del_folder_alt "); if(check_auth($sql->f("id"), "folder_modify", $userid) == 1) { print("$lang_mod_folder_alt"); print("$lang_move_folder_alt"); print(" $lang_get_file_alt "); } print(" 
"); $iconfiles = array("html","htm","gif","jpg","bmp","zip","tar","doc","mdb","xls","ppt","pdf","gz","mp3","tgz"); $choped = split("\.", $sql->f("filename")); $pos = count($choped); // BEGIN BUG FIX: #433548 Problem with uppercase fileextensions $ext = strtolower($choped[$pos-1]); // END BUG FIX: #433548 Problem with uppercase fileextensions if ($sql->f("url") == "1") print(" "); else { if (preg_grep("/$ext/",$iconfiles)) print(" "); else print(" "); } if($fileid == $sql->f("id")) print("".$sql->f("name")."".$sql->f("major_revision").".".$sql->f("minor_revision")."".$sql->f("major_revision").".".$sql->f("minor_revision")."".$sql->f("name")." ".gen_filesize($sql->f("size"))."".$sql->f("name")." ".gen_filesize($sql->f("size"))."".$sql->f("filename")."".gen_filesize($sql->f("size"))."".$sql->f("filename")."".gen_filesize($sql->f("size"))."".fid_to_creator($sql->f("id"))."".$sql->f("modified")."".fid_to_creator($sql->f("id"))."".$sql->f("modified").""); printFileIcons($sql->f("id"),$sql->f("filename"),$sql->f("checked_out"),$sql->f("url"),$default->owl_version_control,$ext); } // begin Daphne change // printing who has a document checked out if ($default->owl_version_control == 1) { if (($holder = uid_to_name($sql->f("checked_out"))) == "Owl") { print("\t-
$holder
"); // *********************************** // If the refresh from hard drive // feature is enabled // *********************************** if ($default->owl_LookAtHD != "false") { if($RefreshPage == true) { CompareDBnHD('file', $default->owl_FileDir . "/" . get_dirpath($parent), $DBFiles, $parent, $default->owl_files_table); }else{ $RefreshPage = CompareDBnHD('file', $default->owl_FileDir . "/" . get_dirpath($parent), $DBFiles, $parent, $default->owl_files_table); } if($RefreshPage == true) { ?>