RedirectResponse('links.php');
}
if (isset($_POST['fleetLink']) && isset($_POST['name'])) {
$matches;
if (preg_match('/gang:(?<id>\\d+)/', GetPost('fleetLink'), $matches)) {
$a = Alliance::EnsureAlliance($brow->AllianceId(), $brow->AllianceName());
$f = new Fleet();
$f->Id = $matches['id'];
$f->AllianceId = $a->Id;
$f->Name = GetPost('name');
$f->Added = time();
if ($f->Validate()) {
$f->Save();
// this seems like a good place to delete old fleets
Fleet::DeleteOldFleets();
DataManager::GetInstance()->CloseConnection();
RedirectResponse('links.php');
}
}
}
?>
<html>
<head>
<title>Fleet Links - Add Fleet</title>
</head>
<body>
<h1><a href="index.php">Fleet Links</a></h1>
<h2>Add Fleet</h2>
public function Save()
{
if (!$this->Validate()) {
throw new Exception('Alliance not valid; unable to save.');
}
$conn = DataManager::GetInstance()->GetConnection();
if (!$this->inDatabase) {
$stmt = $conn->prepare('INSERT INTO alliance (id, name) VALUES (?, ?)');
$stmt->bind_param('is', $this->Id, $this->Name);
$stmt->execute();
$rows = $stmt->affected_rows;
$stmt->close();
if ($rows === 1) {
$this->inDatabase = TRUE;
return TRUE;
} else {
return FALSE;
}
} else {
$stmt = $conn->prepare('UPDATE alliance SET name=? WHERE id=?');
$stmt->bind_param('si', $this->Name, $this->Id);
$stmt->execute();
$rows = $stmt->affected_rows;
$stmt->close();
if ($rows === 1) {
return TRUE;
} else {
return FALSE;
}
}
return FALSE;
}
public function Save()
{
if (!$this->Validate()) {
throw new Exception('Fleet not valid; unable to save.');
}
$conn = DataManager::GetInstance()->GetConnection();
if (!$this->inDatabase) {
$stmt = $conn->prepare('INSERT INTO fleet (id, allianceId, name, added) VALUES (?, ?, ?, ?)');
$stmt->bind_param('diss', $this->Id, $this->AllianceId, $this->Name, DataManager::FormatTimestampForSql($this->Added));
$stmt->execute();
$rows = $stmt->affected_rows;
$stmt->close();
if ($rows === 1) {
$this->inDatabase = TRUE;
return TRUE;
} else {
return FALSE;
}
} else {
$stmt = $conn->prepare('UPDATE fleet SET allianceId=?, name=?, added=? WHERE id=?');
$stmt->bind_param('issd', $this->AllianceId, $this->Name, DataManager::FormatTimestampForSql($this->Added), $this->Id);
$stmt->execute();
$rows = $stmt->affected_rows;
$stmt->close();
if ($rows === 1) {
return TRUE;
} else {
return FALSE;
}
}
return FALSE;
}