4 * Due to bug in code, patch and support req close date wasn't
5 * set properly before 2000-11-16. This script is to fix it (kinda).
9 require_once $gfcommon.'include/pre.php';
11 if (!strstr($REMOTE_ADDR,$sys_internal_network)) {
12 exit_permission_denied();
15 echo "Patching patches<br />";
17 # If some patch is not opened, set its close date one month after open
18 $res=db_query_params ('
20 SET close_date=open_date+60*60*24*30
21 WHERE close_date=0 AND patch_status_id NOT IN (0,1)
25 if (!$res) print "error<br />";
27 echo "Affected rows: ",db_affected_rows($res),"<br /><br />";
32 echo "Patching sup reqs<br />";
34 $res=db_query_params ('
36 SET close_date=open_date+60*60*24*30
37 WHERE close_date=0 AND support_status_id NOT IN (0,1)
41 if (!$res) print "error<br />";
43 echo "Affected rows: ",db_affected_rows($res),"<br /><br />";