$(document).ready(function() {
$('#participants').change(function(){
var number = $(this).val();
window.location = "<?php
echo $webLocation;
?>
admin.php?page=post&sub=addjp&number=" + number;
});
});
</script>
<div class="body">
<?php
$check = new QueryCheck();
$check->checkQuery($result, $query);
if (!empty($check->query)) {
$check->message("joint post", "add");
$check->display();
}
?>
<span class="fontTitle">Add Joint Mission Entry</span><br /><br />
This page should be used in the event that a member of the crew has accidentally posted incorrectly. For instance, if a player has replied to one of the emails sent out to the system instead of logging in and posting, you can copy and paste the contents of their email into this form and put the entry into the system. For all other joint posts, please use the <a href="<?php
echo $webLocation;
?>
admin.php?page=post&sub=jp"> Write Joint Post</a> page.<br /><br />
<span class="fontNormal">
<b>Select the number of participants:</b>
}
if (isset($action) && $action == "delete") {
$getLastId = "SELECT cocid FROM sms_coc ORDER BY cocid DESC LIMIT 1";
$getLastIdResult = mysql_query($getLastId);
$lastID = mysql_fetch_assoc($getLastIdResult);
$sql = "DELETE FROM sms_coc WHERE cocid = {$lastID['cocid']} LIMIT 1";
$result = mysql_query($sql);
/* optimize the table */
optimizeSQLTable("sms_coc");
}
?>
<div class="body">
<?php
$check = new QueryCheck();
$check->checkQuery($result, $sql);
if (!empty($check->query)) {
$check->message("chain of command", $action);
$check->display();
}
?>
<span class="fontTitle">Manage the Chain of Command</span><br /><br />
<a href="<?php
echo $webLocation;
?>
admin.php?page=manage&sub=coc&action=create" class="add fontMedium"><strong>Add CoC Position »</strong></a>
<br />
<a href="<?php
echo $webLocation;
$("a[rel*=facebox]").click(function() {
jQuery.facebox(function() {
jQuery.get('admin/ajax/bio_rank_change.php', function(data) {
jQuery.facebox(data);
});
});
return false;
});
});
</script>
<div class="body">
<?php
$check = new QueryCheck();
$check->checkQuery($result, $updateCrew);
if (!empty($check->query)) {
$check->message("biography", "update");
$check->display();
}
?>
<span class="fontTitle">Manage <?php
echo $type;
?>
Biography</span>
<?php
if ($fetchCrew['crewType'] == "pending") {
?>
<b class="yellow">[ Activation Pending ]</b><?php
admin.php?page=manage&sub=accessall" class="add">Set Access Levels for Entire Crew »</a></b><br /><br />
<?php
$getCrew = "SELECT crew.crewid, crew.firstName, crew.lastName, rank.rankName ";
$getCrew .= "FROM sms_crew AS crew, sms_ranks AS rank WHERE crew.rankid = rank.rankid ";
$getCrew .= "AND crew.crewType = 'active' ORDER BY crew.rankid ASC";
$getCrewResult = mysql_query($getCrew);
while ($userFetch = mysql_fetch_assoc($getCrewResult)) {
extract($userFetch, EXTR_OVERWRITE);
echo "<a href='" . $webLocation . "admin.php?page=manage&sub=access&crew=" . $userFetch['crewid'] . "'>" . stripslashes($userFetch['rankName'] . " " . $userFetch['firstName'] . " " . $userFetch['lastName']) . "</a><br />";
}
/* close while loop */
} elseif (isset($crew)) {
/* query check */
$check = new QueryCheck();
$check->checkQuery($result, $updateAccess);
if (!empty($check->query)) {
$check->message("player access levels", "update");
$check->display();
}
$getCrewAccess = "SELECT accessPost, accessManage, accessReports, accessUser, accessOthers ";
$getCrewAccess .= "FROM sms_crew WHERE crewid = '{$crew}' LIMIT 1";
$getCrewAccessResult = mysql_query($getCrewAccess);
$fetchAccess = mysql_fetch_array($getCrewAccessResult);
$crewAccessRaw = $fetchAccess[0] . "," . $fetchAccess[1] . "," . $fetchAccess[2] . "," . $fetchAccess[3] . "," . $fetchAccess[4];
$crewAccess = explode(",", $crewAccessRaw);
?>
<span class="fontTitle">User Access Levels - <?php
printCrewName($crew, "noRank", "noLink");
?>