Index: admin/upgrades/0_18_inc.php
===================================================================
RCS file: /cvsroot/mantisbt/mantisbt/admin/upgrades/0_18_inc.php,v
retrieving revision 1.18
diff -u -r1.18 0_18_inc.php
--- admin/upgrades/0_18_inc.php	3 Aug 2004 23:45:15 -0000	1.18
+++ admin/upgrades/0_18_inc.php	4 Aug 2004 15:47:07 -0000
@@ -548,5 +548,30 @@
 			'Rename Column',
 			"ALTER TABLE mantis_custom_field_table DROP require_close" );
 
+	$upgrades[] = new FunctionUpgrade(
+				'delete-admin-over',
+				'delete any project level access overrides for admin users',
+				'upgrade_0_18_del_admin_override' );
+
+	function upgrade_0_18_del_admin_override() {
+		global $t_user_table, $t_project_user_list_table;
+
+		$query = "select p.user_id
+				FROM $t_project_user_list_table as p, $t_user_table as u
+				WHERE ( ( p.user_id = u.id ) AND ( u.access_level >= 90 ) )";
+		$result = db_query( $query );
+		$t_count = db_num_rows( $result );
+		for ( $i = 0 ; $i < $t_count ; $i++ ) {
+			$t_row = db_fetch_array( $result );
+			$t_user = $t_row['user_id'];
+			$query = "DELETE FROM $t_project_user_list_table
+				WHERE user_id=$t_user";
+			db_query( $query );
+		}
+
+		return true;
+	}
+
+
 	return $upgrades;
 ?>
\ No newline at end of file