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
|
<?php
/*
* Due to bug in code, patch and support req close date wasn't
* set properly before 2000-11-16. This script is to fix it (kinda).
*
*/
require ('squal_pre.php');
if (!strstr($REMOTE_ADDR,$sys_internal_network)) {
exit_permission_denied();
}
echo "Patching patches<br />";
# If some patch is not opened, set its close date one month after open
$res=db_query("
UPDATE patch
SET close_date=open_date+60*60*24*30
WHERE close_date=0 AND patch_status_id NOT IN (0,1)
");
if (!$res) print "error<br />";
echo "Affected rows: ",db_affected_rows($res),"<br /><br />";
echo "Patching sup reqs<br />";
$res=db_query("
UPDATE support
SET close_date=open_date+60*60*24*30
WHERE close_date=0 AND support_status_id NOT IN (0,1)
");
if (!$res) print "error<br />";
echo "Affected rows: ",db_affected_rows($res),"<br /><br />";
?>
|
