/usr/share/gforge/db/20041222-1-delete-task-artifact.php is in gforge-db-postgresql 5.1.1-2.
This file is owned by root:root, with mode 0o755.
The actual contents of the file can be viewed below.
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 | #! /usr/bin/php
<?php
require_once dirname(__FILE__).'/../www/env.inc.php';
require_once $gfcommon.'include/pre.php';
require_once $gfcommon.'pm/ProjectTask.class.php';
db_begin();
$res = db_query_params ('SELECT project_task_id FROM project_task WHERE status_id=$1',
array('3')) ;
if (!$res) {
echo "FAIL\n";
exit();
} else {
$tasks = array();
for ($i=0;$i<db_numrows($res);$i++) {
$data = db_fetch_array($res);
$tasks[] = $data['project_task_id'];
}
foreach ($tasks as $task_id) {
$res = db_query_params ('DELETE FROM project_assigned_to WHERE project_task_id=$1',
array ($task_id));
if (!$res) {
echo 'Error deleting assigned users relationship: '.db_error();
db_rollback();
exit();
}
$res = db_query_params ('DELETE FROM project_dependencies WHERE project_task_id=$1',
array ($task_id)) ;
if (!$res) {
echo 'Error deleting dependencies: '.db_error();
db_rollback();
exit();
}
$res = db_query_params ('DELETE FROM project_history WHERE project_task_id=$1',
array ($task_id)) ;
if (!$res) {
echo 'Error deleting history: '.db_error();
db_rollback();
exit();
}
$res = db_query_params ('DELETE FROM project_messages WHERE project_task_id=$1',
array ($task_id)) ;
if (!$res) {
echo 'Error deleting messages: '.db_error();
db_rollback();
eixt();
}
$res = db_query_params ('DELETE FROM project_task_artifact WHERE project_task_id=$1',
array ($task_id)) ;
if (!$res) {
echo 'Error deleting artifacts: '.db_error();
db_rollback();
exit();
}
$res = db_query_params ('DELETE FROM rep_time_tracking WHERE project_task_id=$1',
array ($task_id)) ;
if (!$res) {
echo 'Error deleting time tracking report: '.db_error();
db_rollback();
exit();
}
$res = db_query_params ('DELETE FROM project_task WHERE project_task_id=$1',
array ($task_id)) ;
if (!$res) {
echo 'Error deleting task: '.db_error();
db_rollback();
exit();
}
}
}
$res = db_query_params ('SELECT artifact_id FROM artifact WHERE status_id=$1',
array('3')) ;
if (!$res) {
echo "FAIL\n";
exit();
} else {
$artifacts = array();
for ($i=0;$i<db_numrows($res);$i++) {
$data = db_fetch_array($res);
$artifacts[] = $data['artifact_id'];
}
foreach ($artifacts as $artifact_id) {
$res = db_query_params ('DELETE FROM artifact_extra_field_data WHERE artifact_id=$1',
array ($artifact_id)) ;
if (!$res) {
echo 'Error deleting extra field data: '.db_error();
db_rollback();
exit();
}
$res = db_query_params ('DELETE FROM artifact_file WHERE artifact_id=$1',
array ($artifact_id)) ;
if (!$res) {
echo 'Error deleting file from db: '.db_error();
db_rollback();
exit();
}
$res = db_query_params ('DELETE FROM artifact_message WHERE artifact_id=$1',
array ($artifact_id)) ;
if (!$res) {
echo 'Error deleting message: '.db_error();
db_rollback();
exit();
}
$res = db_query_params ('DELETE FROM artifact_history WHERE artifact_id=$1',
array ($artifact_id)) ;
if (!$res) {
echo 'Error deleting history: '.db_error();
db_rollback();
exit();
}
$res = db_query_params ('DELETE FROM artifact_monitor WHERE artifact_id=$1',
array ($artifact_id)) ;
if (!$res) {
echo 'Error deleting monitor: '.db_error();
db_rollback();
exit();
}
$res = db_query_params ('DELETE FROM artifact WHERE artifact_id=$1',
array ($artifact_id)) ;
if (!$res) {
echo 'Error deleting artifact: '.db_error();
db_rollback();
exit();
}
}
}
echo "SUCCESS\n";
db_commit();
// Local Variables:
// mode: php
// c-file-style: "bsd"
// End:
?>
|