Index: openacs-4/contrib/obsolete-packages/ticket-tracker/www/admin/install/index-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/ticket-tracker/www/admin/install/Attic/index-oracle.xql,v
diff -u
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/contrib/obsolete-packages/ticket-tracker/www/admin/install/index-oracle.xql	6 Sep 2001 16:29:39 -0000	1.1
@@ -0,0 +1,19 @@
+<?xml version="1.0"?>
+<queryset>
+   <rdbms><type>oracle</type><version>8.1.6</version></rdbms>
+
+<fullquery name="check_sender">      
+      <querytext>
+      
+	select email as good_email from parties 
+	where party_id = (select apv.attr_value 
+                        from apm_parameter_values apv, 
+                             apm_parameters ap 
+	                    where ap.package_key = :package_key
+                          and ap.parameter_name = 'NotificationSender' 
+	                      and ap.parameter_id = apv.parameter_id)
+
+      </querytext>
+</fullquery>
+ 
+</queryset>
Index: openacs-4/contrib/obsolete-packages/ticket-tracker/www/admin/install/index-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/ticket-tracker/www/admin/install/Attic/index-postgresql.xql,v
diff -u
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/contrib/obsolete-packages/ticket-tracker/www/admin/install/index-postgresql.xql	6 Sep 2001 16:29:39 -0000	1.1
@@ -0,0 +1,19 @@
+<?xml version="1.0"?>
+<queryset>
+   <rdbms><type>postgresql</type><version>7.1</version></rdbms>
+
+<fullquery name="check_sender">      
+      <querytext>
+      
+	select email as good_email from parties 
+	where party_id = (select apv.attr_value 
+                        from apm_parameter_values apv, 
+                             apm_parameters ap 
+	                    where ap.package_key = :package_key
+                          and ap.parameter_name = 'NotificationSender' 
+	                      and ap.parameter_id = apv.parameter_id)::integer
+
+      </querytext>
+</fullquery>
+ 
+</queryset>
Index: openacs-4/contrib/obsolete-packages/ticket-tracker/www/admin/install/index.adp
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/ticket-tracker/www/admin/install/index.adp,v
diff -u -r1.1 -r1.2
--- openacs-4/contrib/obsolete-packages/ticket-tracker/www/admin/install/index.adp	20 Apr 2001 20:51:25 -0000	1.1
+++ openacs-4/contrib/obsolete-packages/ticket-tracker/www/admin/install/index.adp	6 Sep 2001 16:29:39 -0000	1.2
@@ -17,6 +17,33 @@
     <if @dubious_url@ not nil>
       <li>The <code>SystemUrl</code> parameter under acs-kernel/system-information still has its default value, which is <code>@dubious_url@</code>
     </if>
+	<if @good_email@ nil>
+	  <li>The <code>NotificationSender</code> parameter under ticket-tracker does not have an email associated with it. This parameter is a <code>party_id</code> and must have a valid email address because this email address will sign all alerts that the ticket-tracker sends out. 
+		<blockquote>
+		<table border=1 cellpadding=5>
+		<tr>
+		<th>Search for a user
+		<th>Add a new user
+		</tr>
+		<td>
+		<form action=/acs-admin/users/search method=post>
+		<input type=hidden name=target value="@package_url@admin/install/set-sender">
+			<p>By email address: <input name=email>
+			<center>-- OR --</center>
+			<p>By last name: <input name=last_name>
+			<center><input type=submit value="Search for User"></center>
+		</form>
+		</td>
+		<td>
+		<form action=/acs-admin/users/user-add method=post>
+		<center><input type=submit value="Add A User"></center>
+		<br>You'll need to come back to the ticket-tracker after you're done.
+		</form>
+		</td>
+		</tr>
+		</table>
+		</blockquote>
+	</if>
   </ul>
   Please go to <a href="/admin/site-map">Site Map</a> to correct the error(s).
 </if>
Index: openacs-4/contrib/obsolete-packages/ticket-tracker/www/admin/install/index.tcl
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/ticket-tracker/www/admin/install/index.tcl,v
diff -u -r1.1 -r1.2
--- openacs-4/contrib/obsolete-packages/ticket-tracker/www/admin/install/index.tcl	20 Apr 2001 20:51:25 -0000	1.1
+++ openacs-4/contrib/obsolete-packages/ticket-tracker/www/admin/install/index.tcl	6 Sep 2001 16:29:39 -0000	1.2
@@ -12,8 +12,12 @@
     gc_mounted_p:onevalue
     workflow_mounted_p:onevalue
     has_error_p:onevalue
+	package_url:onevalue
 }
 
+set package_url [ad_conn package_url]
+set package_key [ad_conn package_key]
+
 set context_bar {}
 
 # check to see if general comments has been mounted
@@ -47,7 +51,20 @@
     set dubious_url ""
 }
 
-if { !$gc_mounted_p || !$workflow_mounted_p || ![empty_string_p $dubious_url] } {
+# check to see if NotificationSender has an email address
+if { ![db_0or1row check_sender "
+	select email as good_email from parties 
+	where party_id = (select apv.attr_value 
+                        from apm_parameter_values apv, 
+                             apm_parameters ap 
+	                    where ap.package_key = :package_key
+                          and ap.parameter_name = 'NotificationSender' 
+	                      and ap.parameter_id = apv.parameter_id)
+" ] } {
+	set good_email ""
+}
+
+if { !$gc_mounted_p || !$workflow_mounted_p || ![empty_string_p $dubious_url] || [empty_string_p $good_email] } {
     set has_error_p 1
 } else {
     set has_error_p 0
Index: openacs-4/contrib/obsolete-packages/ticket-tracker/www/admin/install/index.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/ticket-tracker/www/admin/install/index.xql,v
diff -u -r1.1 -r1.2
--- openacs-4/contrib/obsolete-packages/ticket-tracker/www/admin/install/index.xql	4 Jun 2001 16:53:27 -0000	1.1
+++ openacs-4/contrib/obsolete-packages/ticket-tracker/www/admin/install/index.xql	6 Sep 2001 16:29:39 -0000	1.2
@@ -41,5 +41,4 @@
       </querytext>
 </fullquery>
 
- 
 </queryset>
Index: openacs-4/contrib/obsolete-packages/ticket-tracker/www/admin/install/set-sender.tcl
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/ticket-tracker/www/admin/install/set-sender.tcl,v
diff -u
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/contrib/obsolete-packages/ticket-tracker/www/admin/install/set-sender.tcl	6 Sep 2001 16:29:39 -0000	1.1
@@ -0,0 +1,15 @@
+# /packages/ticket-tracker/www/admin/install/set-sender.tcl
+ad_page_contract {
+     Set the NotificationSender parameter based on the result from a user-search
+
+     @author vkurup@massmed.org [vkurup@massmed.org]
+     @creation-date Wed Sep  5 00:45:28 2001
+     @cvs-id
+} {
+	{user_id_from_search:integer 0}
+}
+
+# set the NotificationSender to this user_id
+ad_parameter -set $user_id_from_search NotificationSender
+
+ad_returnredirect "[ad_conn package_url]"