on my database server (Sun Fire 280, Solaris 9, MySQL 4.0.18, Apache 1.3.29, PHP 4.3.4 both as Apache module and CGI binary), i have to run some data maintenance jobs (i. e. archiving, optimizing, user announcement via email) at different times; for the jobs, i wrote PHP scripts like the following
Code: Select all
<?php
require_once('db_connect.inc');
require_once('date_time.inc');
$query = "SELECT DBsas.sas_announcements.* FROM DBsas.sas_announcements WHERE DBsas.sas_announcements.KA = 'k'";
$erg = MYSQL_QUERY($query);
$numrows = MYSQL_NUM_ROWS($erg);
if ($numrows > '0') {
$i = 0;
while ($i < $numrows){
$aid = mysql_result($erg,$i,"id");
$wochentag = mysql_result($erg,$i,"wochentag");
$tag = mysql_result($erg,$i,"tag");
$monat = mysql_result($erg,$i,"monat");
$jahr = mysql_result($erg,$i,"jahr");
$zeit = mysql_result($erg,$i,"zeit");
$zeit_supplement = mysql_result($erg,$i,"zeit_supplement");
$ort = mysql_result($erg,$i,"ort");
$ort_extern = mysql_result($erg,$i,"ort_extern");
$sem_title = mysql_result($erg,$i,"title");
$thema =mysql_result($erg,$i,"thema");
$sonst = mysql_result($erg,$i,"sonst");
$display = mysql_result($erg,$i,"display");
$institute = mysql_result($erg,$i,"institute");
$release_date = mysql_result($erg,$i,"release_date");
$email = mysql_result($erg,$i,"email");
$dep_ids = mysql_result($erg,$i,"dep_ids");
$departments = mysql_result($erg,$i,"departments");
$grp_ids = mysql_result($erg,$i,"grp_ids");
$groups = mysql_result($erg,$i,"groups");
$ppl_ids = mysql_result($erg,$i,"ppl_ids");
$people = mysql_result($erg,$i,"people");
if ($jahr < $this_year) {
$aid = mysql_result($erg,$i,"id");
$u1query = "UPDATE DBsas.sas_announcements SET DBsas.sas_announcements.KA = 'a' WHERE DBsas.sas_announcements.id = '$aid'";
$u1erg = mysql_query($u1query) or die(mysql_error());
$u2query = "UPDATE DBsas.sas_people SET DBsas.sas_people.tmp = 'a' WHERE DBsas.sas_people.sasid = '$aid'";
$u2erg = mysql_query($u2query) or die(mysql_error());}
else if (($jahr <= $this_year) && ($monat < $this_month)) {
$aid = mysql_result($erg,$i,"id");
$u1query = "UPDATE DBsas.sas_announcements SET DBsas.sas_announcements.KA = 'a' WHERE DBsas.sas_announcements.id = '$aid'";
$u1erg = mysql_query($u1query) or die(mysql_error());
$u2query = "UPDATE DBsas.sas_people SET DBsas.sas_people.tmp = 'a' WHERE DBsas.sas_people.sasid = '$aid'";
$u2erg = mysql_query($u2query) or die(mysql_error());}
else if (($jahr <= $this_year) && ($monat < $this_month) && ($tag <= $this_day)) {
$aid = mysql_result($erg,$i,"id");
$u1query = "UPDATE DBsas.sas_announcements SET DBsas.sas_announcements.KA = 'a' WHERE DBsas.sas_announcements.id = '$aid'";
$u1erg = mysql_query($u1query) or die(mysql_error());
$u2query = "UPDATE DBsas.sas_people SET DBsas.sas_people.tmp = 'a' WHERE DBsas.sas_people.sasid = '$aid'";
$u2erg = mysql_query($u2query) or die(mysql_error());}
else {}
$i++;}}
else {}
?>Code: Select all
15 0 * * * /usr/local/bin/php /usr/local/Web/include/crontables/root/archive.php3 > /dev/nullCode: Select all
# /usr/local/bin/php -v
PHP 4.3.4 (cgi) (built: Apr 2 2004 21:15:36)
Copyright (c) 1997-2003 The PHP Group
Zend Engine v1.3.0, Copyright (c) 1998-2003 Zend Technologies
with Zend Extension Manager v1.0.1, Copyright (c) 2003, by Zend Technologies
with Zend Optimizer v2.5.1, Copyright (c) 1998-2004, by Zend TechnologiesHave i done something wrong?
Thanks in advance for help / advice, yours
- bluenote