3 require_once dirname(__FILE__).'/../www/env.inc.php';
4 require_once $gfcommon.'include/pre.php';
5 require_once $gfcommon.'pm/ProjectTask.class.php';
9 $res = db_query_params ('SELECT project_task_id FROM project_task WHERE status_id=$1',
19 for ($i=0;$i<db_numrows($res);$i++) {
20 $data = db_fetch_array($res);
21 $tasks[] = $data['project_task_id'];
24 foreach ($tasks as $task_id) {
25 $res = db_query_params ('DELETE FROM project_assigned_to WHERE project_task_id=$1',
28 echo 'Error deleting assigned users relationship: '.db_error();
32 $res = db_query_params ('DELETE FROM project_dependencies WHERE project_task_id=$1',
35 echo 'Error deleting dependencies: '.db_error();
39 $res = db_query_params ('DELETE FROM project_history WHERE project_task_id=$1',
42 echo 'Error deleting history: '.db_error();
46 $res = db_query_params ('DELETE FROM project_messages WHERE project_task_id=$1',
49 echo 'Error deleting messages: '.db_error();
53 $res = db_query_params ('DELETE FROM project_task_artifact WHERE project_task_id=$1',
56 echo 'Error deleting artifacts: '.db_error();
60 $res = db_query_params ('DELETE FROM rep_time_tracking WHERE project_task_id=$1',
63 echo 'Error deleting time tracking report: '.db_error();
67 $res = db_query_params ('DELETE FROM project_task WHERE project_task_id=$1',
70 echo 'Error deleting task: '.db_error();
77 $res = db_query_params ('SELECT artifact_id FROM artifact WHERE status_id=$1',
87 for ($i=0;$i<db_numrows($res);$i++) {
88 $data = db_fetch_array($res);
89 $artifacts[] = $data['artifact_id'];
92 foreach ($artifacts as $artifact_id) {
93 $res = db_query_params ('DELETE FROM artifact_extra_field_data WHERE artifact_id=$1',
94 array ($artifact_id)) ;
96 echo 'Error deleting extra field data: '.db_error();
100 $res = db_query_params ('DELETE FROM artifact_file WHERE artifact_id=$1',
101 array ($artifact_id)) ;
103 echo 'Error deleting file from db: '.db_error();
107 $res = db_query_params ('DELETE FROM artifact_message WHERE artifact_id=$1',
108 array ($artifact_id)) ;
110 echo 'Error deleting message: '.db_error();
114 $res = db_query_params ('DELETE FROM artifact_history WHERE artifact_id=$1',
115 array ($artifact_id)) ;
117 echo 'Error deleting history: '.db_error();
121 $res = db_query_params ('DELETE FROM artifact_monitor WHERE artifact_id=$1',
122 array ($artifact_id)) ;
124 echo 'Error deleting monitor: '.db_error();
128 $res = db_query_params ('DELETE FROM artifact WHERE artifact_id=$1',
129 array ($artifact_id)) ;
131 echo 'Error deleting artifact: '.db_error();
142 // c-file-style: "bsd"