<th>Website</th>
<th>Night</th>
<th>Schools</th>
</tr>
<?php
$pemail = strlen($username) != 0;
$ret = mysql_query("select code from club order by name");
if ($ret && mysql_num_rows($ret)) {
while ($row = mysql_fetch_assoc($ret)) {
$p = new Club($row["code"]);
$p->fetchdets();
$sch = $p->Schools ? 'Yes' : '-';
print <<<EOT
<tr>
<td>{$p->display_code()}</td>
<td>{$p->display_name()}</td>
<td>{$p->display_contact()}</td>
<td>{$p->display_contphone()}</td>
<td>{$p->display_contemail($pemail)}</td>
<td>{$p->display_website()}</td>
<td>{$p->display_night()}</td>
<td>{$sch}</td>
</tr>
EOT;
}
}
?>
</table>
</div>
</div>
</body>
if ($newcode != $club->Code) {
checkclash($newcode);
$qcode = mysql_real_escape_string($newcode);
mysql_query("update club set code='{$qcode}' where {$club->queryof()}");
$club->Code = $newcode;
}
$club->Name = $newname;
$club->Contactfirst = $contfirst;
$club->Contactlast = $contlast;
$club->Contactemail = $contemail;
$club->Contactphone = $contphone;
$club->Website = $website;
$club->Night = $night;
$club->Schools = $sch;
$club->update();
$Title = "Club {$club->display_name()} updated OK";
break;
}
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
<html>
<?php
$Title = "Update individual club";
include 'php/head.php';
?>
<body>
<script language="javascript" src="webfn.js"></script>
<?php
$showadmmenu = true;
include 'php/nav.php';
print <<<EOT
include 'php/opendatabase.php';
include 'php/club.php';
try {
$club = new Club();
$club->fromget();
$club->fetchdets();
} catch (ClubException $e) {
$mess = $e->getMessage();
include 'php/wrongentry.php';
exit(0);
}
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
<html>
<?php
$Title = "Update Club {$club->display_name()}";
include 'php/head.php';
?>
<body>
<script language="javascript" src="webfn.js"></script>
<script language="javascript">
function formvalid()
{
var form = document.clubform;
if (!nonblank(form.clubcode.value)) {
alert("No club code given");
return false;
}
if (!nonblank(form.clubname.value)) {
alert("No club name given");
return false;
?>
<h1>Update Clubs</h1>
<p>Please select the club to be updated from the following list.</p>
<p>To add a club click on one at random and just change the entries on the form or
select the "new club" menu option</p>
<table class="clubupd">
<tr>
<th>Abbrev</th>
<th>Name</th>
</tr>
<?php
$ret = mysql_query("select code from club order by name");
if ($ret && mysql_num_rows($ret)) {
while ($row = mysql_fetch_assoc($ret)) {
$p = new Club($row["code"]);
$p->fetchdets();
print <<<EOT
<tr>
<td><a href="updindclub.php?{$p->urlof()}" title="Update club details">{$p->display_code()}</a></td>
<td><a href="updindclub.php?{$p->urlof()}" title="Update club details">{$p->display_name()}</a></td>
</tr>
EOT;
}
}
?>
</table>
</div>
</div>
</body>
</html>
if (!$ret) {
$mess = "Cannot delete club";
include 'php/dataerror.php';
exit(0);
}
$nrows = mysql_affected_rows();
if ($nrows == 0) {
$mess = "No clubs deleted";
include 'php/dataerror.php';
exit(0);
}
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
<html>
<?php
$Title = "Deletion of {$club->display_name()} complete";
include 'php/head.php';
print <<<EOT
<body>
EOT;
$showadmmenu = true;
include 'php/nav.php';
print <<<EOT
<h1>Deletion of {$club->display_name()} complete</h1>
<p>
Deletion of club {$club->display_name()} was successful.</p>
EOT;
?>
<p>Click <a href="clubupd.php" title="Resume club update">here</a> to return to the club update menu.</p>
</div>
