Index: openacs-4/contrib/obsolete-packages/ticket-tracker-lite/ticket-tracker-lite.info
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/ticket-tracker-lite/ticket-tracker-lite.info,v
diff -u -r1.4 -r1.5
--- openacs-4/contrib/obsolete-packages/ticket-tracker-lite/ticket-tracker-lite.info	26 Feb 2002 15:51:17 -0000	1.4
+++ openacs-4/contrib/obsolete-packages/ticket-tracker-lite/ticket-tracker-lite.info	19 Mar 2002 06:49:29 -0000	1.5
@@ -55,6 +55,7 @@
             <file type="content_page" path="www/admin/index.adp"/>
             <file type="content_page" path="www/admin/index.tcl"/>
             <file type="query_file" path="www/admin/index.xql"/>
+            <file type="content_page" path="www/admin/main.css"/>
             <file type="query_file" db_type="oracle" path="www/admin/member-ae-oracle.xql"/>
             <file type="query_file" db_type="postgresql" path="www/admin/member-ae-postgresql.xql"/>
             <file type="content_page" path="www/admin/member-ae.tcl"/>
@@ -66,6 +67,10 @@
             <file type="query_file" db_type="postgresql" path="www/assignment-ae-postgresql.xql"/>
             <file type="content_page" path="www/assignment-ae.tcl"/>
             <file type="query_file" path="www/assignment-ae.xql"/>
+            <file type="query_file" db_type="oracle" path="www/attach-file-oracle.xql"/>
+            <file type="query_file" db_type="postgresql" path="www/attach-file-postgresql.xql"/>
+            <file type="content_page" path="www/attach-file.tcl"/>
+            <file type="query_file" path="www/attach-file.xql"/>
             <file type="query_file" db_type="oracle" path="www/comment-ae-2-oracle.xql"/>
             <file type="query_file" db_type="postgresql" path="www/comment-ae-2-postgresql.xql"/>
             <file type="content_page" path="www/comment-ae-2.tcl"/>
@@ -76,6 +81,9 @@
             <file type="content_page" path="www/comments.adp"/>
             <file type="content_page" path="www/comments.tcl"/>
             <file type="query_file" path="www/comments.xql"/>
+            <file type="query_file" db_type="oracle" path="www/delete-file-oracle.xql"/>
+            <file type="query_file" db_type="postgresql" path="www/delete-file-postgresql.xql"/>
+            <file type="content_page" path="www/delete-file.tcl"/>
             <file type="documentation" path="www/doc/developer.adp"/>
             <file type="documentation" path="www/doc/developer.tcl"/>
             <file type="documentation" path="www/doc/help.adp"/>
@@ -85,11 +93,21 @@
             <file type="documentation" path="www/doc/ticket-add.gif"/>
             <file type="documentation" path="www/doc/ticket-home.gif"/>
             <file type="documentation" path="www/doc/ticket.gif"/>
+            <file type="content_page" path="www/download/index.vuh"/>
+            <file type="content_page" path="www/images/mime_type/application/pdf.png"/>
+            <file type="content_page" path="www/images/mime_type/application/x-compressed.png"/>
+            <file type="content_page" path="www/images/mime_type/application/x-zip-compressed.png"/>
+            <file type="content_page" path="www/images/mime_type/default.png"/>
+            <file type="content_page" path="www/images/mime_type/image/gif.png"/>
+            <file type="content_page" path="www/images/mime_type/image/jpeg.png"/>
+            <file type="content_page" path="www/images/mime_type/text/html.png"/>
+            <file type="content_page" path="www/images/mime_type/text/plain.png"/>
             <file type="query_file" db_type="oracle" path="www/index-oracle.xql"/>
             <file type="query_file" db_type="postgresql" path="www/index-postgresql.xql"/>
             <file type="content_page" path="www/index.adp"/>
             <file type="content_page" path="www/index.tcl"/>
             <file type="query_file" path="www/index.xql"/>
+            <file type="content_page" path="www/main.css"/>
             <file type="content_page" path="www/master.adp"/>
             <file type="content_page" path="www/master.tcl"/>
             <file type="content_page" path="www/prefs-ae.tcl"/>
@@ -108,6 +126,7 @@
             <file type="content_page" path="www/ticket-edit.adp"/>
             <file type="content_page" path="www/ticket-edit.tcl"/>
             <file type="query_file" path="www/ticket-edit.xql"/>
+            <file type="content_page" path="www/ticket-none.adp"/>
             <file type="query_file" db_type="oracle" path="www/ticket-oracle.xql"/>
             <file type="query_file" db_type="postgresql" path="www/ticket-postgresql.xql"/>
             <file type="query_file" db_type="oracle" path="www/ticket-update-oracle.xql"/>
Index: openacs-4/contrib/obsolete-packages/ticket-tracker-lite/sql/oracle/views-and-plsql.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/ticket-tracker-lite/sql/oracle/views-and-plsql.sql,v
diff -u -r1.1 -r1.2
--- openacs-4/contrib/obsolete-packages/ticket-tracker-lite/sql/oracle/views-and-plsql.sql	20 Apr 2001 20:51:23 -0000	1.1
+++ openacs-4/contrib/obsolete-packages/ticket-tracker-lite/sql/oracle/views-and-plsql.sql	19 Mar 2002 06:49:29 -0000	1.2
@@ -106,3 +106,76 @@
 
 end;
 /
+show errors;
+
+create or replace function ttl__create_file (
+	p_package_id		   in apm_packages.package_id%TYPE, 
+	p_user_id			   in users.user_id%TYPE, 
+	p_name				   in cr_items.name%TYPE, 
+	p_parent_id			   in cr_items.parent_id%TYPE, 
+	p_mime_type			   in cr_mime_types.mime_type%TYPE,
+	p_file_extension	   in cr_mime_types.file_extension%TYPE
+) return cr_revisions.revision_id%TYPE
+as
+	v_item_id			cr_items.item_id%TYPE;
+	v_revision_id		cr_revisions.revision_id%TYPE;
+	v_mime_type			cr_mime_types.mime_type%TYPE;
+begin
+
+	begin
+		-- detect mime type if mime is not yet in cr_mime_type and add it
+		select mime_type into v_mime_type from cr_mime_types
+		  where  mime_type = p_mime_type;
+ 
+		exception
+		  when NO_DATA_FOUND then
+			insert into cr_mime_types 
+			(mime_type, file_extension) 
+			values 
+			(p_mime_type, p_file_extension);
+	end;
+
+	-- if the file already exists then nuke it. this become essentially write
+	select max(item_id) into v_item_id from cr_items where name = p_name;
+
+	if v_item_id is not null then
+	   content_item.delete(v_item_id);
+	end if;
+
+	-- vinodk: this needs to be rewritten to use CR API
+	-- oracle - use lob instead of file
+
+	-- create a new cr_item
+	v_item_id := acs_object.new (
+		null, 
+		'content_item', 
+		sysdate, 
+		p_user_id, 
+		null, 
+		p_package_id
+	);
+
+	insert into cr_items 
+	(item_id, parent_id, name, content_type, storage_type) 
+	values 
+	(v_item_id, p_parent_id, p_name, 'content_revision', 'lob');
+
+	-- create a new cr_revision
+	v_revision_id := acs_object.new (
+		null, 
+		'content_revision', 
+		sysdate, 
+		p_user_id, 
+		null, 
+		null
+	);
+
+	insert into cr_revisions 
+	(revision_id, item_id, mime_type) 
+	values 
+	(v_revision_id, v_item_id, p_mime_type);
+
+	return v_revision_id;
+end;
+/
+show errors;
Index: openacs-4/contrib/obsolete-packages/ticket-tracker-lite/sql/postgresql/views-and-plsql.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/ticket-tracker-lite/sql/postgresql/views-and-plsql.sql,v
diff -u -r1.5 -r1.6
--- openacs-4/contrib/obsolete-packages/ticket-tracker-lite/sql/postgresql/views-and-plsql.sql	13 Aug 2001 21:32:05 -0000	1.5
+++ openacs-4/contrib/obsolete-packages/ticket-tracker-lite/sql/postgresql/views-and-plsql.sql	19 Mar 2002 06:49:29 -0000	1.6
@@ -96,3 +96,47 @@
     return v_privilege;
 end;' language 'plpgsql';
 
+create function ttl__create_file(integer, integer, varchar, integer, varchar, varchar)
+returns integer as '
+declare
+  p_package_id alias for $1;
+  p_user_id alias for $2;
+  p_name alias for $3;
+  p_parent_id alias for $4;
+  p_mime_type alias for $5;
+  p_file_extension alias for $6;
+  v_item_id integer;
+  v_revision_id integer;
+  v_mime_type varchar;
+begin
+
+-- detect mime type if mime is not yet in cr_mime_type and add it
+  select mime_type into v_mime_type from cr_mime_types
+    	where  mime_type = p_mime_type;
+ 
+  if not found then
+    insert into cr_mime_types (mime_type, file_extension) values (p_mime_type, p_file_extension);
+  end if;
+
+-- if the file already exists then nuke it. this become essentially write
+  select item_id into v_item_id from cr_items where name = p_name;
+  if found then 
+    perform content_item__delete(v_item_id);
+  end if;
+
+-- create a new cr_item
+  v_item_id := acs_object__new(null, ''content_item'', now(), p_user_id, null, p_package_id);
+  insert into cr_items (
+    item_id, parent_id, name, content_type, storage_type
+  ) values (
+    v_item_id, p_parent_id, p_name, ''content_revision'', ''file''
+  );
+
+-- create a new cr_revision
+  v_revision_id := acs_object__new(null, ''content_revision'', now(), p_user_id, null, null);
+  insert into cr_revisions (revision_id, item_id, mime_type) 
+  values (v_revision_id, v_item_id, p_mime_type);
+
+  return v_revision_id;
+end;
+' language 'plpgsql';
Index: openacs-4/contrib/obsolete-packages/ticket-tracker-lite/tcl/ticket-tracker-lite-procs.tcl
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/ticket-tracker-lite/tcl/ticket-tracker-lite-procs.tcl,v
diff -u -r1.2 -r1.3
--- openacs-4/contrib/obsolete-packages/ticket-tracker-lite/tcl/ticket-tracker-lite-procs.tcl	28 May 2001 20:43:37 -0000	1.2
+++ openacs-4/contrib/obsolete-packages/ticket-tracker-lite/tcl/ticket-tracker-lite-procs.tcl	19 Mar 2002 06:49:29 -0000	1.3
@@ -208,7 +208,7 @@
         if {[info exists pref_key] && [string equal $var_value $pref_key]} {
             lappend list_of_links "<b>$linktitle</b>"
         } else {
-            lappend list_of_links "<a href=prefs-ae?$var_name=[ns_urlencode $var_value]>$linktitle</a>"
+            lappend list_of_links "<a href=prefs-ae?$var_name=[ns_urlencode $var_value] class=th_link>$linktitle</a>"
         }
     }
 
Index: openacs-4/contrib/obsolete-packages/ticket-tracker-lite/www/attach-file-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/ticket-tracker-lite/www/attach-file-oracle.xql,v
diff -u
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/contrib/obsolete-packages/ticket-tracker-lite/www/attach-file-oracle.xql	19 Mar 2002 06:49:29 -0000	1.1
@@ -0,0 +1,31 @@
+<?xml version="1.0"?>
+
+<queryset>
+   <rdbms><type>oracle</type><version>8.1.6</version></rdbms>
+
+<fullquery name="create_new_file">
+<querytext>
+
+	begin
+		:1 := ttl__create_file(:package_id, :caller_id, :upload_file, :ticket_id, :mime_type, :file_extension);
+	end;
+
+</querytext>
+</fullquery>
+
+
+<fullquery name="file_size_mime_type">
+<querytext>
+
+	update cr_revisions 
+	set content_length = :tmp_size, 
+	    content = empty_blob()
+	where revision_id = :revision_id
+	returning content into :1
+
+</querytext>
+</fullquery>
+
+
+
+</queryset>
Index: openacs-4/contrib/obsolete-packages/ticket-tracker-lite/www/attach-file-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/ticket-tracker-lite/www/attach-file-postgresql.xql,v
diff -u
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/contrib/obsolete-packages/ticket-tracker-lite/www/attach-file-postgresql.xql	19 Mar 2002 06:49:29 -0000	1.1
@@ -0,0 +1,28 @@
+<?xml version="1.0"?>
+
+<queryset>
+   <rdbms><type>postgresql</type><version>7.1</version></rdbms>
+
+<fullquery name="create_new_file">
+<querytext>
+
+	select ttl__create_file(:package_id, :caller_id, :upload_file, :ticket_id, :mime_type, :file_extension)
+
+</querytext>
+</fullquery>
+
+
+
+<fullquery name="file_size_mime_type">
+<querytext>
+
+	update cr_revisions 
+	set content_length = :tmp_size, 
+	    content = :tmp_filename 
+	where revision_id = :revision_id
+
+</querytext>
+</fullquery>
+
+
+</queryset>
Index: openacs-4/contrib/obsolete-packages/ticket-tracker-lite/www/attach-file.tcl
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/ticket-tracker-lite/www/attach-file.tcl,v
diff -u
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/contrib/obsolete-packages/ticket-tracker-lite/www/attach-file.tcl	19 Mar 2002 06:49:29 -0000	1.1
@@ -0,0 +1,35 @@
+ad_page_contract {
+    
+    A page to attach files
+
+} {
+    ticket_id:integer,notnull
+    upload_file:trim,notnull
+    upload_file.tmpfile:tmpfile
+    {return_url "ticket"}
+}
+
+ttl_restrict_to_ttl_users
+
+set caller_id  [ad_conn user_id]
+set caller_ip  [ns_conn peeraddr]
+set package_id [ad_conn package_id]
+
+ns_log notice "vinodk-upload_file=$upload_file"
+
+db_transaction {
+
+    if {![empty_string_p $upload_file]} {
+		set mime_type [ns_guesstype $upload_file]
+		set file_extension [string trimleft [file extension $upload_file] "."]
+		set revision_id [db_exec_plsql create_new_file "select ttl__create_file(:package_id, :caller_id, :upload_file, :ticket_id, :mime_type, :file_extension);"]
+		db_1row get_item_id "select item_id from cr_revisions where revision_id = :revision_id"
+		set tmp_filename [cr_create_content_file $item_id $revision_id ${upload_file.tmpfile}]
+		set tmp_size [cr_file_size $tmp_filename]
+		db_dml file_size_mime_type "update cr_revisions set content_length = :tmp_size, content = :tmp_filename where revision_id = :revision_id" -blob_files [list ${upload_file.tmpfile}]
+    }
+
+}
+
+
+ad_returnredirect "$return_url"
Index: openacs-4/contrib/obsolete-packages/ticket-tracker-lite/www/attach-file.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/ticket-tracker-lite/www/attach-file.xql,v
diff -u
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/contrib/obsolete-packages/ticket-tracker-lite/www/attach-file.xql	19 Mar 2002 06:49:29 -0000	1.1
@@ -0,0 +1,15 @@
+<?xml version="1.0"?>
+
+<queryset>
+
+
+<fullquery name="get_item_id">
+<querytext>
+
+	select item_id from cr_revisions where revision_id = :revision_id
+
+</querytext>
+</fullquery>
+
+
+</queryset>
Index: openacs-4/contrib/obsolete-packages/ticket-tracker-lite/www/comment-ae.adp
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/ticket-tracker-lite/www/comment-ae.adp,v
diff -u -r1.1 -r1.2
--- openacs-4/contrib/obsolete-packages/ticket-tracker-lite/www/comment-ae.adp	20 Apr 2001 20:51:23 -0000	1.1
+++ openacs-4/contrib/obsolete-packages/ticket-tracker-lite/www/comment-ae.adp	19 Mar 2002 06:49:29 -0000	1.2
@@ -5,16 +5,19 @@
 <form method=post action=comment-ae-2>
 @hidden_vars@
 
-<table>
+<table class=standard align=center>
 <tr>
-  <td>
-  <font face=fixed><textarea name=message cols=60 rows=16 wrap=soft>@Q_message@</textarea></font>
-  <br><b>Message is</b> @format_widget@
+  <td class=field>Comment</td>
+  <td class=entry>
+  <textarea name=message cols=60 rows=16 wrap=soft>@Q_message@</textarea>
   </td>
 </tr>
 <tr>
-    <td align=center><input type=Submit Value="@button_name@"></td>
+  <td></td><td>Message is @format_widget@</td>
 </tr>
+<tr>
+    <td colspan=2 align=center><input type=Submit Value="@button_name@"></td>
+</tr>
 </table>
 
 </form>
Index: openacs-4/contrib/obsolete-packages/ticket-tracker-lite/www/comment-ae.tcl
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/ticket-tracker-lite/www/comment-ae.tcl,v
diff -u -r1.2 -r1.3
--- openacs-4/contrib/obsolete-packages/ticket-tracker-lite/www/comment-ae.tcl	28 May 2001 20:43:16 -0000	1.2
+++ openacs-4/contrib/obsolete-packages/ticket-tracker-lite/www/comment-ae.tcl	19 Mar 2002 06:49:29 -0000	1.3
@@ -52,6 +52,6 @@
     set format_widget [ttl_text_format_widget -name message_format]
 }
 
-set navbar_list [ttl_navbar_list [list [list ticket?ticket_id=$ticket_id "Ticket $ticket_id"]]]
+set navbar_list [ad_context_bar [list ticket?ticket_id=$ticket_id "Ticket $ticket_id"] "Add Comment"]
 
 set hidden_vars [export_form_vars ticket_id comment_id]
Index: openacs-4/contrib/obsolete-packages/ticket-tracker-lite/www/delete-file-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/ticket-tracker-lite/www/delete-file-oracle.xql,v
diff -u
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/contrib/obsolete-packages/ticket-tracker-lite/www/delete-file-oracle.xql	19 Mar 2002 06:49:29 -0000	1.1
@@ -0,0 +1,16 @@
+<?xml version="1.0"?>
+
+<queryset>
+   <rdbms><type>oracle</type><version>8.1.6</version></rdbms>
+
+<fullquery name="delete_file">
+<querytext>
+
+	begin
+		content_item.delete(:item_id);
+	end;
+
+</querytext>
+</fullquery>
+
+</queryset>
Index: openacs-4/contrib/obsolete-packages/ticket-tracker-lite/www/delete-file-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/ticket-tracker-lite/www/delete-file-postgresql.xql,v
diff -u
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/contrib/obsolete-packages/ticket-tracker-lite/www/delete-file-postgresql.xql	19 Mar 2002 06:49:29 -0000	1.1
@@ -0,0 +1,14 @@
+<?xml version="1.0"?>
+
+<queryset>
+   <rdbms><type>postgresql</type><version>7.1</version></rdbms>
+
+<fullquery name="delete_file">
+<querytext>
+
+	select content_item__delete(:item_id)
+
+</querytext>
+</fullquery>
+
+</queryset>
Index: openacs-4/contrib/obsolete-packages/ticket-tracker-lite/www/delete-file.tcl
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/ticket-tracker-lite/www/delete-file.tcl,v
diff -u
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/contrib/obsolete-packages/ticket-tracker-lite/www/delete-file.tcl	19 Mar 2002 06:49:29 -0000	1.1
@@ -0,0 +1,12 @@
+ad_page_contract {
+
+delete files in CR
+
+} {
+	item_id:integer,notnull
+	return_url:notnull
+}
+
+db_exec_plsql delete_file "select content_item__delete(:item_id)"
+
+ad_returnredirect $return_url
Index: openacs-4/contrib/obsolete-packages/ticket-tracker-lite/www/index.adp
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/ticket-tracker-lite/www/index.adp,v
diff -u -r1.1 -r1.2
--- openacs-4/contrib/obsolete-packages/ticket-tracker-lite/www/index.adp	20 Apr 2001 20:51:23 -0000	1.1
+++ openacs-4/contrib/obsolete-packages/ticket-tracker-lite/www/index.adp	19 Mar 2002 06:49:29 -0000	1.2
@@ -4,14 +4,15 @@
 <property name=navbar_list>@navbar_list@</property>
 <property name=admin_url>@admin_url@</property>
 
-<table width=100%>
+<table class="full">
 <tr>
-    <td align=right>[ <b><a href=ticket-add>Add a ticket</a></b> | <b><a href=doc/help>Help</a></b> ]</td>
+    <td align=right> <a href=ticket-add>Add a Ticket</a> </td>
 </tr>
 </table>
 
-<table width=100% cellpadding=3 cellspacing=1 border=0>
-    <tr bgcolor=#e0e0e0>
+<table class="full">
+    <tr>
+	<th>@id_slider@</th>
         <th>@name_slider@</th>
         <th>@status_slider@</th>
         <th>@activity_slider@</th>
@@ -22,11 +23,12 @@
 
   <multiple name=tickets>
   <if @tickets.rownum@ odd>
-    <tr width=100% bgcolor=#efefef>
+    <tr class="oddrow">
   </if>
   <else>
-    <tr width=100%>
+    <tr class="evenrow">
   </else>
+	<td align=center>@tickets.ticket_id@</a>
         <td align=left><a href=ticket?ticket_id=@tickets.ticket_id@>@tickets.ticket_name@</a></td>
         <td align=center>@tickets.status@</td>
         <td align=center>@tickets.last_comment@</td>
@@ -42,24 +44,44 @@
     </tr>
   </if>
     
-    <tr bgcolor=#efefef>
-        <td colspan=6 align=center><a href=ticket-add>Add a ticket</a></td>
-    </tr>
 </table>
+<p>
 
+<table class=full cellspacing=0>
+<tr>
+<td class=contextbar valign=top>
 <form action=prefs-ae>
-
-<table cellpadding=0 cellspacing=0 border=0 width=100%>
-    <tr bgcolor=#ededed>
-        <th>Ticket assignments</th>
-        <th>Ticket status</th>
-        <th>Area</th>
+<table cellspacing=0>
+    <tr>
+	<td colspan=3 class=contextbar> &nbsp; Filter Tickets by:</td>
     </tr>
     <tr>
-        <td align=center>@ticket_owner_slider@</td>
-        <td align=center>@ticket_state_slider@</td>
-        <td align=center>@area_optionlist@ <input type=submit value="Go"></td>
+        <td width=5% class=contextbar>&nbsp</td><td nowrap class=contextbar>Ticket assignments</td><td class=contextbar>@ticket_owner_slider@</td>
     </tr>
+    <tr>
+        <td class=contextbar>&nbsp</td><td class=contextbar>Ticket status</td><td class=contextbar>@ticket_state_slider@</td>
+    </tr>
+    <tr>
+        <td class=contextbar>&nbsp</td><td class=contextbar>Area</td><td class=contextbar>@area_optionlist@</td>
+    </tr>
+    <tr>
+     	<td class=contextbar>&nbsp</td><td colspan=2 class=contextbar><input type=submit value="Filter" class=contextbar></td>
+    </tr>
 </table>
+</form>
+</td>
 
+<td class=contextbar valign=top>
+<form action="ticket">
+<table>
+<tr>
+    <td class=contextbar nowrap> &nbsp Search for a Ticket - Ticket ID #: <input type=text name=ticket_id> <input type=submit value="Search"></td>
+</tr>
+</table>
 </form>
+</td>
+
+<td class=contextbar valign=top width="100%">&nbsp</td>
+</tr>
+</table>
+
Index: openacs-4/contrib/obsolete-packages/ticket-tracker-lite/www/index.tcl
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/ticket-tracker-lite/www/index.tcl,v
diff -u -r1.3 -r1.4
--- openacs-4/contrib/obsolete-packages/ticket-tracker-lite/www/index.tcl	26 Feb 2002 15:51:17 -0000	1.3
+++ openacs-4/contrib/obsolete-packages/ticket-tracker-lite/www/index.tcl	19 Mar 2002 06:49:29 -0000	1.4
@@ -11,7 +11,8 @@
 
 set master_template [ttl_master_template]
 
-set navbar_list [ttl_navbar_list -nohome]
+#set navbar_list [ttl_navbar_list -nohome]
+set navbar_list [ad_context_bar]
 
 db_0or1row get_prefs {
     select 
@@ -68,6 +69,9 @@
 set sort [ttl_util_default sort priority]
 
 switch $sort {
+    ticket_id {
+	set order_clause "order by ticket_id"
+    }
     deadline {
         set order_clause "[db_map order_deadline]"
     } 
@@ -136,15 +140,18 @@
 #
 # For dimensional sliders
 #
-
+set id_slider       [ttl_pref_choices sort ticket_id "Ticket Id"]
 set name_slider     [ttl_pref_choices sort name Subject]
 set status_slider   [ttl_pref_choices sort status Status]
 set activity_slider [ttl_pref_choices sort activity "Last Activity"]
 set area_slider     [ttl_pref_choices sort area "Area"]
 set priority_slider [ttl_pref_choices sort priority Priority]
 set deadline_slider [ttl_pref_choices sort deadline Deadline]
 
-set ticket_owner_slider [ttl_pref_choices mine_p f All t Mine]
-set ticket_state_slider [ttl_pref_choices status all all queued queued active active]
+set option_list [list "f {All [string repeat &nbsp 25]}" {t Me}]
+set ticket_owner_slider [ad_db_select_widget -default $mine_p -option_list $option_list mine_list "" mine_p]
+set option_list [list "all {All [string repeat &nbsp 25]}" {queued Queued} {active Active}]
+set ticket_state_slider [ad_db_select_widget -default $status -option_list $option_list status_list "" status]
 
+
 set area_optionlist [ttl_area_optionlist -all_option $area_id]
Index: openacs-4/contrib/obsolete-packages/ticket-tracker-lite/www/main.css
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/ticket-tracker-lite/www/main.css,v
diff -u
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/contrib/obsolete-packages/ticket-tracker-lite/www/main.css	19 Mar 2002 06:49:29 -0000	1.1
@@ -0,0 +1,44 @@
+body		{ font-size: 12px; font-family: Arial, Helvetica, sans-serif}
+
+input           { font-family: verdana, arial, helvetica; font-size: 12px; }
+select		{ font-family: verdana, arial, helvetica; font-size: 12px; }
+textarea	{ font-family: verdana, arial, helvetica; font-size: 12px; }
+
+h1		{ font-family: verdana, arial, helvetica; font-size: 
+15px; font-weight: 700; font-style: italic; color: #FF0000; }
+h2		{ font-family: verdana, arial, helvetica; font-size: 
+13px; font-weight: 700; font-style: italic; color: #000000; }
+h3		{ font-family: verdana, arial, helvetica; font-size: 
+12px; font-weight: 700; font-style: italic; color: #999999; }
+
+p		{ font-family: verdana, arial, helvetica; font-size: 
+12px; color: #000000; }
+
+td		{ font-size: 12px; }
+td.entry	{ background-color: #EFEFEF }
+td.field	{ background-color: #C8CED7; font-weight: bold }
+th		{ font-size: 12px; color: #FFFFFF; background-color: #42679D }
+
+tr.evenrow	{ background : #ECECEC; }
+tr.oddrow	{ background : #FFFFFF; }
+
+table.full	{ width: 100%; }
+table.standard	{ width: 665; }
+
+ul		{ font-family: verdana, arial, helvetica; font-size: 
+12px; color: #000000; }
+
+sup		{ font-family: verdana, arial, helvetica; font-size: 
+8px; color: #000000; }
+
+a		{ color: #154584; text-decoration: none; }
+a:hover         { color: #0099FF; background-color: #FFFFFF; 
+text-decoration: underline; }
+.th_link	{ color: #FFFFFF; text-decoration: underline; 
+background-color: #42679D; }
+.action_link	{ font-size: 14px; color: #42679D; text-decoration: 
+none; font-weight: bold }
+.main_nav	{ font-size: 12px; color: #FFFFFF; text-decoration: none; }
+
+.contextbar	{ font-family: verdana, arial, helvetica; font-size: 
+12px; color: #000000; background: #CCCCCC; font-weight: bold }
Index: openacs-4/contrib/obsolete-packages/ticket-tracker-lite/www/master.adp
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/ticket-tracker-lite/www/master.adp,v
diff -u -r1.1 -r1.2
--- openacs-4/contrib/obsolete-packages/ticket-tracker-lite/www/master.adp	20 Apr 2001 20:51:23 -0000	1.1
+++ openacs-4/contrib/obsolete-packages/ticket-tracker-lite/www/master.adp	19 Mar 2002 06:49:29 -0000	1.2
@@ -1,61 +1,16 @@
-<html>
-<head>
-    <title>@title@</title>
-    <style>
-<!--
-pre, code { 
-    font-family: monospace 
-}
+<master>
+<property name="title">@title@</property>
+<property name="header_stuff">@header_stuff@</property>
 
-body {
-    font-family: Verdana, Arial;
-}
-
-p, li, td, th, ul, ol {
-    font-family: Verdana, Arial;
-    font-size : 10pt;
-}
-
-h1, h2, h3, h4 {
-    font-family: Verdana, Arial;
-}
-
-.Navbar {
-    font-family: Verdana, Arial;
-    font-size : 9pt;
-    font-weight: bold;
-}
-
-.PageTitle {
-    font-family: Verdana, Arial;
-    font-size : 16pt;
-}
-
-.tiny {
-    font-family: Verdana, Arial;
-    font-size : 8pt;
-}
-
-.signature {
-    font-family: Verdana, Arial;
-    font-size : 10pt;
-}
-
--->
-</style>
-</head>
-
-<body bgcolor=white>
-
-<table width=100% cellpadding=0 cellspacing=2 border=0>
+<table class="full" cellspacing=0>
   <tr>
-    <td class=navbar><list name=navbar_list>@navbar_list:item@ &gt; </list></td>
-    <td align=right>
+    <td class="contextbar">@navbar_list@</td>
+    <td class="contextbar" align=right>
     <if @admin_url@ not nil><a class=tiny href=@admin_url@>Admin view</a></if>
     </td>
   </tr>
   <tr>
-    <td class=pagetitle>@title@</td>
+    <td></td>
     <td align=right>
         <if @right_header_html@ not nil>@right_header_html@</if>
     </td>
@@ -64,5 +19,4 @@
 
 <slave>
 
-<hr size=1>
-<span class=signature><em><a href=mailto:@system_owner@>@system_owner@</a></span>
+
Index: openacs-4/contrib/obsolete-packages/ticket-tracker-lite/www/master.tcl
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/ticket-tracker-lite/www/master.tcl,v
diff -u -r1.1 -r1.2
--- openacs-4/contrib/obsolete-packages/ticket-tracker-lite/www/master.tcl	20 Apr 2001 20:51:23 -0000	1.1
+++ openacs-4/contrib/obsolete-packages/ticket-tracker-lite/www/master.tcl	19 Mar 2002 06:49:29 -0000	1.2
@@ -1 +1,2 @@
-set system_owner [ad_system_owner]
+set header_stuff "<link rel=\"stylesheet\" type=\"text/css\" href=\"main.css\">"
+
Index: openacs-4/contrib/obsolete-packages/ticket-tracker-lite/www/ticket-add.adp
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/ticket-tracker-lite/www/ticket-add.adp,v
diff -u -r1.1 -r1.2
--- openacs-4/contrib/obsolete-packages/ticket-tracker-lite/www/ticket-add.adp	20 Apr 2001 20:51:23 -0000	1.1
+++ openacs-4/contrib/obsolete-packages/ticket-tracker-lite/www/ticket-add.adp	19 Mar 2002 06:49:29 -0000	1.2
@@ -5,38 +5,38 @@
 <form method=post action=ticket-add-2>
 <input type=hidden name=ticket_id value=@ticket_id@>
 
-<table cellpadding=8 cellspacing=2 border=0>
-<tr bgcolor=#efefef>
-  <td colspan=2><b>Name</b>&nbsp;
-    <font face=fixed><input name=name size=50 maxlength=80></font>
-  </td>
+<table class=standard align=center>
+<tr>
+  <td class="field">Name</td>
+  <td class="entry"><input name=name size=50 maxlength=80></td>
 </tr>
 
-<tr bgcolor=#efefef>
-  <td colspan=2>
-  <b>Description</b><br>
-  <font face=fixed><textarea name=message cols=60 rows=16 wrap=soft></textarea></font>
-  <br><b>Message is</b> @format_widget@
+<tr>
+  <td class="field">Description</td>
+  <td class="entry"><textarea name=message cols=60 rows=16 wrap=soft></textarea>
   </td>
 </tr>
+<tr>
+  <td></td><td>Message is @format_widget@</td>
+</tr>
 
-<tr bgcolor=#efefef>
-    <td><b>Ticket type:</b></td>
-    <td>@type_optionlist@</td>
+<tr>
+    <td class="field">Ticket type:</td>
+    <td class="entry">@type_optionlist@</td>
 </td>
-<tr bgcolor=#efefef>
-    <td><b>Area of site:</b></td>
-    <td>@area_optionlist@</td>
+<tr>
+    <td class="field">Area of site:</td>
+    <td class="entry">@area_optionlist@</td>
 </tr>
-<tr bgcolor=#efefef>
-    <td><b>Priority:</b></td>
-    <td>@priority_optionlist@</td>
+<tr>
+    <td class="field">Priority:</td>
+    <td class="entry">@priority_optionlist@</td>
 </tr>
-<tr bgcolor=#efefef>
-    <td><b>Deadline:</b></td>
-    <td>@deadline_widget@</td>
+<tr>
+    <td class="field">Deadline:</td>
+    <td class="entry">@deadline_widget@</td>
 </tr>
-<tr bgcolor=#efefef>
+<tr>
     <td colspan=2 align=center><input type=Submit Value=" Add ticket "></td>
 </tr>
 </table>
Index: openacs-4/contrib/obsolete-packages/ticket-tracker-lite/www/ticket-add.tcl
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/ticket-tracker-lite/www/ticket-add.tcl,v
diff -u -r1.2 -r1.3
--- openacs-4/contrib/obsolete-packages/ticket-tracker-lite/www/ticket-add.tcl	28 May 2001 20:43:16 -0000	1.2
+++ openacs-4/contrib/obsolete-packages/ticket-tracker-lite/www/ticket-add.tcl	19 Mar 2002 06:49:29 -0000	1.3
@@ -31,7 +31,8 @@
 }
 
 set title "Add a ticket"
-set navbar_list [ttl_navbar_list]
+#set navbar_list [ttl_navbar_list]
+set navbar_list [ad_context_bar [list "Add"]]
 
 set type_optionlist     [ttl_type_optionlist]
 set area_optionlist     [ttl_area_optionlist]
Index: openacs-4/contrib/obsolete-packages/ticket-tracker-lite/www/ticket-edit.adp
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/ticket-tracker-lite/www/ticket-edit.adp,v
diff -u -r1.1 -r1.2
--- openacs-4/contrib/obsolete-packages/ticket-tracker-lite/www/ticket-edit.adp	20 Apr 2001 20:51:23 -0000	1.1
+++ openacs-4/contrib/obsolete-packages/ticket-tracker-lite/www/ticket-edit.adp	19 Mar 2002 06:49:29 -0000	1.2
@@ -5,21 +5,20 @@
 <form method=post action=ticket-edit-2>
 <input type=hidden name=ticket_id value=@ticket_id@>
 
-<table cellpadding=8 cellspacing=2 border=0>
-<tr bgcolor=#efefef>
-  <td colspan=2><b>Name</b>&nbsp;
-    <font face=fixed><input name=name size=50 maxlength=45 value="@Q_name@"></font>
-  </td>
+<table class=standard align=center>
+<tr>
+  <td class="field">Name</td>
+  <td class="entry"><input name=name size=50 maxlength=45 value="@Q_name@"></td>
 </tr>
 
-<tr bgcolor=#efefef>
-  <td colspan=2>
-  <b>Description</b><br>
-  <font face=fixed><textarea name=message cols=60 rows=16 wrap=soft>@Q_message@</textarea></font>
-  <br><b>Message is</b> @format_widget@
-  </td>
+<tr>
+  <td class="field">Description</td>
+  <td class="entry"><textarea name=message cols=60 rows=16 wrap=soft>@Q_message@</textarea></font></td>
 </tr>
-<tr bgcolor=#efefef>
+<tr>
+  <td></td><td>Message is @format_widget@</td>
+</tr>
+<tr>
     <td colspan=2 align=center><input type=Submit Value=" Update "></td>
 </tr>
 </table>
Index: openacs-4/contrib/obsolete-packages/ticket-tracker-lite/www/ticket-edit.tcl
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/ticket-tracker-lite/www/ticket-edit.tcl,v
diff -u -r1.2 -r1.3
--- openacs-4/contrib/obsolete-packages/ticket-tracker-lite/www/ticket-edit.tcl	28 May 2001 20:43:16 -0000	1.2
+++ openacs-4/contrib/obsolete-packages/ticket-tracker-lite/www/ticket-edit.tcl	19 Mar 2002 06:49:29 -0000	1.3
@@ -21,7 +21,7 @@
 }
 
 set title "Update ticket $ticket_id"
-set navbar_list [ttl_navbar_list [list [list "ticket?ticket_id=$ticket_id" "$name"]]]
+set navbar_list [ad_context_bar [list "ticket?ticket_id=$ticket_id" "$name"] Edit]
 
 set Q_name    [ns_quotehtml $name]
 set Q_message [ns_quotehtml $message]
Index: openacs-4/contrib/obsolete-packages/ticket-tracker-lite/www/ticket-none.adp
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/ticket-tracker-lite/www/ticket-none.adp,v
diff -u
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/contrib/obsolete-packages/ticket-tracker-lite/www/ticket-none.adp	19 Mar 2002 06:49:29 -0000	1.1
@@ -0,0 +1,6 @@
+<master src=[ttl_master_template]>
+<% set context_bar [ad_context_bar] %>
+<property name=title>Issue Does Not Exists</property>
+<property name=navbar_list>@context_bar@</property>
+
+<center> Sorry That ticket does not exists.  Click <a href="index">here</a> to return </center>
Index: openacs-4/contrib/obsolete-packages/ticket-tracker-lite/www/ticket.adp
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/ticket-tracker-lite/www/ticket.adp,v
diff -u -r1.1 -r1.2
--- openacs-4/contrib/obsolete-packages/ticket-tracker-lite/www/ticket.adp	20 Apr 2001 20:51:23 -0000	1.1
+++ openacs-4/contrib/obsolete-packages/ticket-tracker-lite/www/ticket.adp	19 Mar 2002 06:49:29 -0000	1.2
@@ -2,8 +2,11 @@
 <property name=title>@title@</property>
 <property name=navbar_list>@navbar_list@</property>
 
-<table cellpadding=8 cellspacing=2 border=0 width="100%">
-<tr bgcolor=#efefef>
+<form method=post action=ticket-update>
+<input type=hidden name=ticket_id value=@ticket_id@>
+
+<table class="standard" align="center">
+<tr>
   <td colspan=2>
 
     <p><b>@name@</b>
@@ -13,51 +16,90 @@
     <if @edit_url@ not nil>(<a href=@edit_url@>edit</a>)</if>
     
     <p>Added @posting_date@ by @posting_name@</p>
+    </td>
+</tr>
 
-    <center>
 
-    <table cellpadding=4 cellspacing=0 border=0>
-        <form method=post action=ticket-update>
-        <input type=hidden name=ticket_id value=@ticket_id@>
-
-        <tr>
-            <td><b>Ticket type:</b></td>
-            <td>@type_optionlist@</td>
-        </td>
-        <tr>
-            <td><b>Area of site:</b></td>
-            <td>@area_optionlist@</td>
-        </tr>
-        <tr>
-            <td><b>Priority:</b></td>
-            <td>@priority_optionlist@</td>
-        </tr>
-        <tr>
-            <td><b>Deadline:</b></td>
-            <td>@deadline_widget@</td>
-        </tr>
-        <tr>
-            <td><b>Status:</b></td>
-            <td>@status_optionlist@</td>
-        </tr>
-        <tr>
-            <td><br></td>
+<tr>
+	<td class="field">Ticket type:</td>
+        <td class="entry">@type_optionlist@</td>
+</td>
+<tr>
+        <td class="field">Area of site:</td>
+        <td class="entry">@area_optionlist@</td>
+</tr>
+<tr>
+	<td class="field">Priority:</td>
+        <td class="entry">@priority_optionlist@</td>
+</tr>
+<tr>
+	<td class="field">Deadline:</td>
+        <td class="entry">@deadline_widget@</td>
+</tr>
+<tr>
+        <td class="field">Status:</td>
+        <td class="entry">@status_optionlist@</td>
+</tr>
+<tr>
+        <td></td>
             <td><input type=Submit Value=" Update "></td>
-        </tr>
-        </table>
-      </center>
+</tr>
 
-    </form>
+</table>
+</form>
 
+<form action="attach-file" enctype=multipart/form-data method=post>
+<input type=hidden name=ticket_id value=@ticket_id@>
+<input type=hidden name=return_url value=@return_url@>
+	<table class=standard align=center>
+	<tr><th>Attach Files</th><tr>
+	<tr><td><input type=file name=upload_file size=20> <input type=submit value="Attach File"></td></tr>
+	<multiple name="files">
+	<tr><td>
+		<if @files.mime_type@ eq "text/html" 
+		or @files.mime_type@ eq "text/plain" 
+		or @files.mime_type@ eq "image/gif"
+		or @files.mime_type@ eq "image/jpeg"
+		>
+			<a href="download/@files.name@?revision_id=@files.revision_id@" target="_blank">
+		</if>
+		<else>
+			<a href="download/@files.name@?revision_id=@files.revision_id@">
+		</else>
+
+		<if @files.mime_type@ eq "text/html" 
+		or @files.mime_type@ eq "text/plain" 
+		or @files.mime_type@ eq "image/gif"
+		or @files.mime_type@ eq "image/jpeg"
+		or @files.mime_type@ eq "application/octet-stream"
+		or @files.mime_type@ eq "application/x-zip-compressed"
+		or @files.mime_type@ eq "application/x-compressed"
+		or @files.mime_type@ eq "application/pdf"
+		>
+			<img src="images/mime_type/@files.mime_type@.png" border=0>
+		</if>
+		<else>
+			<img src="images/mime_type/default.png" border=0>
+		</else>
+
+		@files.name@</a> &nbsp (<a href="delete-file?item_id=@files.item_id@&return_url=@return_url@">delete</a>)
   </td>
-</tr>
+	</tr>
+	</multiple>
+	<if @files:rowcount@ eq "0">
+		<tr><td><em>No files attached to this ticket</em></td></tr>
+	</if>
+	</table>
+</form>
+<p>
 
-<tr bgcolor=#e0e0e0>
+<table class=standard align=center>
+<tr>
   <th width="50%">Assigned users</th>
   <th width="50%">Not assigned</th>
 </tr>
 
-<tr bgcolor=#efefef valign=top>
+<tr valign=top>
   <td>
     <if @assigned_users@ not nil>
       <ul>
@@ -76,12 +118,17 @@
   </td>
 </tr>
 <tr>
-  <td colspan=2>
+</table>
 
+
+<table class="standard" align="center">
+<tr>
+  <td>
+
 <include src=comments ticket_id=@ticket_id@>
 
 <center>
-<p><a href=comment-ae?ticket_id=@ticket_id@>Add a comment</a>
+<p><a href=comment-ae?ticket_id=@ticket_id@>Add a Comment</a>
 </center>
 
   </td>
Index: openacs-4/contrib/obsolete-packages/ticket-tracker-lite/www/ticket.tcl
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/ticket-tracker-lite/www/ticket.tcl,v
diff -u -r1.3 -r1.4
--- openacs-4/contrib/obsolete-packages/ticket-tracker-lite/www/ticket.tcl	8 Feb 2002 07:27:34 -0000	1.3
+++ openacs-4/contrib/obsolete-packages/ticket-tracker-lite/www/ticket.tcl	19 Mar 2002 06:49:29 -0000	1.4
@@ -15,7 +15,7 @@
 # 1) Get the ticket info
 #
 
-db_1row get_one_ticket {
+if ![db_0or1row get_one_ticket {
     select 
         t.area_id,
         a.name as area_name,
@@ -33,11 +33,14 @@
     where a.context_id = :package_id 
     and t.ticket_id = :ticket_id
     and t.area_id = a.area_id
-}
+}] then { ad_returnredirect "ticket-none" }
 
+
 set title "Ticket $ticket_id"
-set navbar_list [ttl_navbar_list [list [list "prefs-ae?area_id=$area_id" "$area_name"]]]
+set navbar_list [ad_context_bar [list "prefs-ae?area_id=$area_id" "$area_name"] $title]
 
+#set navbar_list [ad_context_bar [list [list "prefs-ae?area_id=$area_id" "$area_name"] $title]]
+
 set message [ttl_format_text_for_display -format $message_format -wrap 60 $message]
 
 #
@@ -87,5 +90,8 @@
 set area_optionlist     [ttl_area_optionlist $area_id]
 set priority_optionlist [ttl_priority_optionlist $priority]
 set status_optionlist   [ttl_status_optionlist $status]
-ns_log Notice "vinodk: dead: $deadline"
 set deadline_widget     [ad_dateentrywidget deadline $deadline]
+
+db_multirow files get_files "select i.name, r.mime_type, r.revision_id, i.item_id from cr_items i, cr_revisions r where i.parent_id = :ticket_id and i.item_id = r.item_id"
+
+set return_url "ticket?ticket_id=$ticket_id"
Index: openacs-4/contrib/obsolete-packages/ticket-tracker-lite/www/admin/main.css
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/ticket-tracker-lite/www/admin/main.css,v
diff -u
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/contrib/obsolete-packages/ticket-tracker-lite/www/admin/main.css	19 Mar 2002 06:49:29 -0000	1.1
@@ -0,0 +1,44 @@
+body		{ font-size: 12px; font-family: Arial, Helvetica, sans-serif}
+
+input           { font-family: verdana, arial, helvetica; font-size: 12px; }
+select		{ font-family: verdana, arial, helvetica; font-size: 12px; }
+textarea	{ font-family: verdana, arial, helvetica; font-size: 12px; }
+
+h1		{ font-family: verdana, arial, helvetica; font-size: 
+15px; font-weight: 700; font-style: italic; color: #FF0000; }
+h2		{ font-family: verdana, arial, helvetica; font-size: 
+13px; font-weight: 700; font-style: italic; color: #000000; }
+h3		{ font-family: verdana, arial, helvetica; font-size: 
+12px; font-weight: 700; font-style: italic; color: #999999; }
+
+p		{ font-family: verdana, arial, helvetica; font-size: 
+12px; color: #000000; }
+
+td		{ font-size: 12px; }
+td.entry	{ background-color: #EFEFEF }
+td.field	{ background-color: #C8CED7; font-weight: bold }
+th		{ font-size: 12px; color: #FFFFFF; background-color: #42679D }
+
+tr.evenrow	{ background : #ECECEC; }
+tr.oddrow	{ background : #FFFFFF; }
+
+table.full	{ width: 100%; }
+table.standard	{ width: 665; }
+
+ul		{ font-family: verdana, arial, helvetica; font-size: 
+12px; color: #000000; }
+
+sup		{ font-family: verdana, arial, helvetica; font-size: 
+8px; color: #000000; }
+
+a		{ color: #154584; text-decoration: none; }
+a:hover         { color: #0099FF; background-color: #FFFFFF; 
+text-decoration: underline; }
+.th_link	{ color: #FFFFFF; text-decoration: underline; 
+background-color: #42679D; }
+.action_link	{ font-size: 14px; color: #42679D; text-decoration: 
+none; font-weight: bold }
+.main_nav	{ font-size: 12px; color: #FFFFFF; text-decoration: none; }
+
+.contextbar	{ font-family: verdana, arial, helvetica; font-size: 
+12px; color: #000000; background: #CCCCCC; font-weight: bold }
Index: openacs-4/contrib/obsolete-packages/ticket-tracker-lite/www/download/index.vuh
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/ticket-tracker-lite/www/download/index.vuh,v
diff -u
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/contrib/obsolete-packages/ticket-tracker-lite/www/download/index.vuh	19 Mar 2002 06:49:29 -0000	1.1
@@ -0,0 +1,12 @@
+
+ad_page_contract {
+
+} {
+    revision_id:integer
+}
+
+#set user_id [ad_conn user_id]
+
+#ad_require_permission $revision_id "read"
+
+cr_write_content -revision_id $revision_id
Index: openacs-4/contrib/obsolete-packages/ticket-tracker-lite/www/images/mime_type/default.png
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/ticket-tracker-lite/www/images/mime_type/default.png,v
diff -u
Binary files differ
Index: openacs-4/contrib/obsolete-packages/ticket-tracker-lite/www/images/mime_type/application/pdf.png
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/ticket-tracker-lite/www/images/mime_type/application/pdf.png,v
diff -u
Binary files differ
Index: openacs-4/contrib/obsolete-packages/ticket-tracker-lite/www/images/mime_type/application/x-compressed.png
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/ticket-tracker-lite/www/images/mime_type/application/x-compressed.png,v
diff -u
Binary files differ
Index: openacs-4/contrib/obsolete-packages/ticket-tracker-lite/www/images/mime_type/application/x-zip-compressed.png
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/ticket-tracker-lite/www/images/mime_type/application/x-zip-compressed.png,v
diff -u
Binary files differ
Index: openacs-4/contrib/obsolete-packages/ticket-tracker-lite/www/images/mime_type/image/gif.png
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/ticket-tracker-lite/www/images/mime_type/image/gif.png,v
diff -u
Binary files differ
Index: openacs-4/contrib/obsolete-packages/ticket-tracker-lite/www/images/mime_type/image/jpeg.png
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/ticket-tracker-lite/www/images/mime_type/image/jpeg.png,v
diff -u
Binary files differ
Index: openacs-4/contrib/obsolete-packages/ticket-tracker-lite/www/images/mime_type/text/html.png
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/ticket-tracker-lite/www/images/mime_type/text/html.png,v
diff -u
Binary files differ
Index: openacs-4/contrib/obsolete-packages/ticket-tracker-lite/www/images/mime_type/text/plain.png
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/ticket-tracker-lite/www/images/mime_type/text/plain.png,v
diff -u
Binary files differ