* Copyright (C) 2005 James Grant * * This program is free software; you can redistribute it and/or * modify it under the terms of the GNU General Public * License as published by the Free Software Foundation, version 2. * * This program is distributed in the hope that it will be useful, * but WITHOUT ANY WARRANTY; without even the implied warranty of * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU * General Public License for more details. * * You should have received a copy of the GNU General Public License * along with this program; see the file COPYING. If not, write to * the Free Software Foundation, Inc., 59 Temple Place - Suite 330, * Boston, MA 02111-1307, USA. */ ?> 'committee_main.php', 'SFIAB Configuration' => 'config/index.php'), 'important_dates'); $q = $pdo->prepare("SELECT * FROM dates WHERE year='-1'"); $q->execute(); while ($r = $q->fetch(PDO::FETCH_OBJ)) { $defaultdates[$r->name] = $r; } ?> $val) { // put the date and time back together $d = stripslashes($val); $t = stripslashes($_POST['savetimes'][$key]); $v = "$d $t"; $stmt = $pdo->prepare("UPDATE dates SET date=? WHERE year=? AND id=?"); $stmt->execute([$v,$config['FAIRYEAR'],$key]); } } echo happy(i18n('Dates successfully saved')); } echo '
'; echo "\n"; echo ''; echo ''; /* List the dates in the order we would like them to appear */ $dates = array('fairdate' => array(), 'regopen' => array(), 'regclose' => array(), 'postparticipants' => array(), 'postwinners' => array(), 'judgeregopen' => array(), 'judgeregclose' => array(), 'judgescheduleavailable' => array(), 'specawardregopen' => array(), 'specawardregclose' => array()); /* Now copy the SQL data into the above array */ $q = $pdo->prepare("SELECT * FROM dates WHERE year=? ORDER BY date"); $q->execute([$config['FAIRYEAR']]); while ($r = $q->fetch(PDO::FETCH_OBJ)) { $dates[$r->name]['description'] = $r->description; $dates[$r->name]['id'] = $r->id; $dates[$r->name]['date'] = $r->date; $v = $r->date; /* See if $v is something resembling a valid date */ if (!preg_match('/([0-9]{4})-([0-9]{1,2})-([0-9]{1,2})/', $v, $d)) { $error_ids[$r->id] = i18n('Invalid date format'); } else if ($d[3] == 0 || $d[2] == 0 || $d[1] == 0) { $error_ids[$r->id] = i18n('Invalid date'); } } function chkafter($d1, $d2) { global $dates; global $error_ids; $id2 = $dates[$d2]['id']; /* Parse both dates 1, 2, 3, 4, 5, 6 */ preg_match('/([0-9]{4})-([0-9]{1,2})-([0-9]{1,2}) ([0-9]{1,2}):([0-9]{1,2}):([0-9]{1,2})/', $dates[$d1]['date'], $p1); preg_match('/([0-9]{4})-([0-9]{1,2})-([0-9]{1,2}) ([0-9]{1,2}):([0-9]{1,2}):([0-9]{1,2})/', $dates[$d2]['date'], $p2); // int mktime ( [int hour [, int minute [, int second [, int month [, int day [, int year [, int is_dst]]]]]]] ) $u1 = mktime($p1[4], $p1[5], $p1[6], $p1[2], $p1[3], $p1[1]); $u2 = mktime($p2[4], $p2[5], $p2[6], $p2[2], $p2[3], $p2[1]); if ($u1 > $u2) { /* Insert an error for $u2 */ $error_ids[$id2] = i18n('Must come after "%1"', array($dates[$d1]['description'])); } } chkafter('regopen', 'regclose'); chkafter('judgeregopen', 'judgeregclose'); chkafter('specawardregopen', 'specawardregclose'); chkafter('fairdate', 'postwinners'); /* And print the table with all the info in the correct order */ foreach ($dates as $dn => $d) { if (!$d['id']) { $def = $defaultdates[$dn]; // hmm if we dont have a record for this date this year, INSERT the sql from the default $stmt = $pdo->prepare("INSERT INTO dates (date,name,description,year) VALUES ( ?, ?, ?, ? )"); $stmt->execute([$def->date,$dn,$def->description,$config['FAIRYEAR']]); $d['id'] = $pdo->lastInsertId(); $d['description'] = $def->description; $d['date'] = $def->date; } $e = ''; if (get_value_from_array($error_ids, $d['id'])) { $e = '* ' . $error_ids[$d['id']] . ''; } list($_d, $_t) = explode(' ', $d['date']); echo ''; echo ""; } echo '

' . i18n('Dates for fair year %1', array($config['FAIRYEAR']), array('fair year')) . '

' . i18n($d['description']) . '"; echo ""; echo "{$e}
'; echo '\n"; echo '
'; send_footer(); ?>