log.php
5.75 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
<?php
/*
* log.php
*
* Copyright (c) 1999-2002 The Owl Project Team
* Licensed under the GNU GPL. For full terms see the file COPYING.
*
* $Id$
*/
require("./config/owl.php");
require("./lib/owl.lib.php");
require("./config/html.php");
require("./lib/security.lib.php");
include("./lib/header.inc");
// store file name and extension separately
$filesearch = explode('.',$filename);
// Begin 496814 Column Sorts are not persistant
// + ADDED &order=$order&$sortorder=$sortname to
// all browse.php? header and HREF LINES
switch ($order) {
case "name":
$sortorder = 'sortname';
break;
case "major_revision":
$sortorder = 'sortver';
break;
case "filename" :
$sortorder = 'sortfilename';
break;
case "size" :
$sortorder = 'sortsize';
break;
case "creatorid" :
$sortorder = 'sortposted';
break;
case "smodified" :
$sortorder = 'sortmod';
break;
case "checked_out":
$sortorder = 'sortcheckedout';
break;
default:
break;
}
// END 496814 Column Sorts are not persistant
print("<TABLE WIDTH=$default->table_expand_width BGCOLOR=$default->main_header_bgcolor CELLSPACING=0 CELLPADDING=0 BORDER=$default->table_border HEIGHT=30>");
?>
<TR><TD ALIGN=LEFT>
<?php print("$lang_user: ");
if(prefaccess($userid)) {
print("<A HREF='prefs.php?owluser=$userid&sess=$sess&expand=$expand&order=$order&sortname=$sortname'>");
}
print uid_to_name($userid);
print ("</A>");
?>
<FONT SIZE=-1>
<?php print("<A HREF='index.php?login=logout&sess=$sess'>$lang_logout</A>");?>
</FONT></TD><TD ALIGN=RIGHT>
<?php print("<A HREF='browse.php?sess=$sess&parent=$parent&expand=$expand&order=$order&$sortorder=$sortname'><IMG SRC='$default->owl_root_url/locale/$language/graphics/btn_browse.gif' BORDER=0>");?>
</A></TD></TR></TABLE>
<?php
print("<CENTER>");
print("<TABLE WIDTH=$default->table_expand_width BORDER=$default->table_border>");
print("<TR><TD align=left>$lang_viewlog ".gen_navbar($parent)."/".flid_to_name($id)."</TD></TR>");
print("</TABLE><HR WIDTH=$default->table_expand_width><BR>$filename");
print ("<TABLE width=$default->table_expand_width border=$default->table_border cellpadding=3 cellspacing=0>
<TR><TD BGCOLOR='$default->table_header_bg' width=5%>$lang_ver</td>
<TD BGCOLOR='$default->table_header_bg' width=10%>$lang_user</TD>
<TD BGCOLOR='$default->table_header_bg' width=60%>$lang_log_file</TD>
<TD BGCOLOR='$default->table_header_bg' width=25%>$lang_modified</TD></TR>");
$sql = new Owl_DB;
// SPECIFIC SQL LOG QUERY - NOT USED (problematic)
// This SQL log query is designed for repository assuming there is only 1
// digit in major revision, and noone decides to have a "_x-" in their
// filename.
//
// Has to be changed if the naming structure changes.
// Also a problem that it didn't catch the "current"
// file because of the "_x-" matching (grr)
//
//$sql->query("select * from $default->owl_files_table where filename LIKE '$filesearch[0]\__-%$filesearch[1]' order by major_revision desc, minor_revision desc");
// GENERIC SQL LOG QUERY - currently used.
// prone to errors when people name a set of docs
// Blah.doc
// Blah_errors.doc
// Blah_standards.doc
// etc. and search for a log on Blah.doc (it brings up all 3 docs)
//$sql->query("select * from $default->owl_files_table where filename LIKE '$filesearch[0]%$filesearch[1]' order by major_revision desc, minor_revision desc");
//$SQL = "select * from $default->owl_files_table where filename LIKE '$filesearch[0]%$filesearch[1]' order by major_revision desc, minor_revision desc";
//printError("PARENT: $parent",$SQL);
if ($default->owl_use_fs)
{
$sql->query("Select id from $default->owl_folders_table where name='backup' and parent='$parent'");
while($sql->next_record()) {
$backup_parent = $sql->f("id");
}
$sql->query("select * from $default->owl_files_table where filename LIKE '$filesearch[0]%$filesearch[1]' AND (parent = $backup_parent OR parent = $parent) order by major_revision desc, minor_revision desc");
}
else
{
// name based query -- assuming that the given name for the file doesn't change...
// at some point, we should really look into creating a "revision_id" field so that all revisions can be linked.
// in the meanwhile, the code for changing the Title of the file has been altered to go back and
$name = flid_to_name($id);
$sql->query("select * from $default->owl_files_table where name='$name' AND parent='$parent' order by major_revision desc, minor_revision desc");
}
//global $sess;
while($sql->next_record()) {
$choped = split("\.", $sql->f("filename"));
$pos = count($choped);
$ext = strtolower($choped[$pos-1]);
print("<TR><TD valign=top>".$sql->f("major_revision").".".$sql->f("minor_revision")."</TD>
<TD valign=top>".uid_to_name($sql->f("creatorid"))."</TD>
<TD valign=top align=left><font size=2 style='font-weight:bold'>");
printFileIcons($sql->f("id"),$sql->f("filename"),$sql->f("checked_out"),$sql->f("url"),$default->owl_version_control,$ext);
print("  [ ".$sql->f("filename")." ]</font><br>
<pre>".$sql->f("description")."</></TD>
<TD valign=top>".$sql->f("modified")."</TD></TR>");
}
// print("<TR><TD valign=top>".$sql->f("major_revision").".".$sql->f("minor_revision")."</TD>
//<TD valign=top>".uid_to_name($sql->f("creatorid"))."</TD>
//<TD valign=top><font style='font-weight:bold'>[ ".$sql->f("filename")." ]</font><br>
//<pre>".$sql->f("description")."</></TD>
//<TD valign=top>".$sql->f("modified")."</TD></TR>");
//}
print("</TABLE>");
include("./lib/footer.inc");
?>