$subject2 = $emailSubject . " Docking Request";
$to2 = printCOEmail();
$from2 = $dockingShipCO . " < " . $dockingShipCOEmail . " >";
$message2 = "Greetings " . printCO() . ",\n\t\t\t\n\t{$dockingShipCO} of the {$dockingShipName} has sent a request to dock with the {$shipName}. To answer the Commanding Officer and approve or deny his request, please log in to your Control Panel.\n\t\t\n" . $webLocation . "login.php?action=login";
mail($to2, $subject2, $message2, "From: " . $from2 . "\nX-Mailer: PHP/" . phpversion());
}
}
}
?>
<div class="body">
<?php
$check = new QueryCheck();
$check->checkQuery($result, $query);
if (!empty($check->query)) {
$check->message("docking request", "submit");
$check->display();
}
?>
<span class="fontTitle">Docking Request Form</span><br /><br />
<form method="post" action="<?php
echo $webLocation;
?>
index.php?page=dockingrequest">
<table>
<tr>
<td colspan="3" class="fontLarge"><b>Ship Information</b></td>
</tr>
<tr>
jQuery.facebox(function() {
jQuery.get('admin/ajax/award_remove.php?c=' + crew + '&a=' + award, function(data) {
jQuery.facebox(data);
});
});
return false;
});
});
</script>
<div class="body">
<?php
$check = new QueryCheck();
$check->checkQuery($result, $query);
if (!empty($check->query)) {
$check->message("crew award", "remove");
$check->display();
}
?>
<span class="fontTitle">Remove Award From <?php
printCrewName($crew, "rank", "noLink");
?>
</span><br /><br />
<b class="fontLarge">
<a href="<?php
echo $webLocation;
?>
admin.php?page=manage&sub=removeaward">« Back to Crew List</a>
</b>
<br /><br />
jQuery.facebox(function() {
jQuery.get('admin/ajax/award_give.php?c=' + crew + '&a=' + award, function(data) {
jQuery.facebox(data);
});
});
return false;
});
});
</script>
<div class="body">
<?php
$check = new QueryCheck();
$check->checkQuery($result, $query);
if (!empty($check->query)) {
$check->message("player award", "add");
$check->display();
}
?>
<span class="fontTitle">Give Award To <?php
printCrewName($crew, "rank", "noLink");
?>
</span><br /><br />
<b class="fontMedium">
<a href="<?php
echo $webLocation;
?>
admin.php?page=manage&sub=addaward">« Back to Crew List</a>
</b><br /><br />
$message .= "Location: " . stripslashes($postLocation) . "\r\n";
$message .= "Timeline: " . stripslashes($postTimeline) . "\r\n";
$message .= "Tag: " . stripslashes($postTag) . "\r\n\r\n";
$message .= stripslashes($postContent);
/* send the email */
mail($to, $subject, $message, "From: " . $from . "\nX-Mailer: PHP/" . phpversion());
}
}
?>
<div class="body">
<?php
$check = new QueryCheck();
$check->checkQuery($result, $query);
if (!empty($check->query)) {
$check->message("mission entry", "add");
$check->display();
}
?>
<span class="fontTitle">Add 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 mission posts, please use the <a href="<?php
echo $webLocation;
?>
admin.php?page=post&sub=mission"> Write Mission Post</a> page.<br /><br />
<form method="post" action="<?php
echo $webLocation;
?>
admin.php?page=post&sub=addpost">
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
}
?>
$catid = NULL;
}
$query = "DELETE FROM sms_news_categories WHERE catid = {$catid} LIMIT 1";
$result = mysql_query($query);
/* optimize the table */
optimizeSQLTable("sms_news_categories");
$action = "delete";
}
?>
<div class="body">
<?php
$check = new QueryCheck();
$check->checkQuery($result, $query);
if (!empty($check->query)) {
$check->message("news category", $action);
$check->display();
}
?>
<span class="fontTitle">Create Site News Category</span><br /><br />
<table cellpadding="2" cellspacing="2">
<form method="post" action="admin.php?page=manage&sub=newscategories">
<tr>
<td valign="middle">
<b>Category Name</b><br />
<input type="text" class="name" name="catName" maxlength="50" />
</td>
<td valign="middle">
<b>Required Access Level</b><br />
jQuery.get('admin/ajax/department_' + action + '.php', function(data) {
jQuery.facebox(data);
});
});
return false;
});
});
</script>
<div class="body">
<?php
$check = new QueryCheck();
$check->checkQuery($result, $query);
if (!empty($check->query)) {
$check->message($object, $action);
$check->display();
}
?>
<span class="fontTitle">Department Management</span><br /><br />
Use the fields below to manage your departments. You can add a new department using the appropriate link below, or, you can manage which departments have access to departmental databases from the appropriate link. <strong class="yellow">Important</strong> – if you want to create a new rank, you will need to create a new department before you attempt to create the rank. (You can also use an existing department as well.)<br /><br />
<a href="#" rel="facebox" class="fontMedium add" myAction="add"><strong>Add New Department »</strong></a><br />
<a href="#" rel="facebox" class="fontMedium add" myAction="database"><strong>Update Departmental Database Access »</strong></a><br /><br />
<table>
<?php
/* get the departments from the database */
$getDepartments = "SELECT * FROM sms_departments ORDER BY deptOrder ASC";
$getDepartmentsResult = mysql_query($getDepartments);
jQuery.facebox(function() {
jQuery.get('admin/ajax/activate_' + type + "_" + action + '.php?id=' + id, function(data) {
jQuery.facebox(data);
});
});
return false;
});
});
</script>
<div class="body">
<?php
$check = new QueryCheck();
$check->checkQuery($result, $query);
if (!empty($check->query)) {
$check->message($action_category, $action_type);
$check->display();
}
?>
<span class="fontTitle">Manage Pending Items</span><br /><br />
<div id="container-1">
<ul>
<li><a href="#one"><span>Users (<?php
echo $countPendingUsers;
?>
)</span></a></li>
<li><a href="#two"><span>Mission Posts (<?php
echo $countPendingPosts;
?>
)</span></a></li>
$shipHistory = stripslashes($shipHistory);
$cpMessage = stripslashes($cpMessage);
$joinDisclaimer = stripslashes($joinDisclaimer);
$samplePostQuestion = stripslashes($samplePostQuestion);
$rules = stripslashes($rules);
$acceptMessage = stripslashes($acceptMessage);
$rejectMessage = stripslashes($rejectMessage);
$siteCredits = stripslashes($siteCredits);
?>
<div class="body">
<?php
$check = new QueryCheck();
$check->checkQuery($result, $query);
if (!empty($check->query)) {
$check->message("site messages", "update");
$check->display();
}
?>
<span class="fontTitle">Site Messages</span>
<form method="post" action="<?php
echo $webLocation;
?>
admin.php?page=manage&sub=messages">
<table>
<tr>
<td class="tableCellLabel">Welcome Message</td>
<td> </td>
<td>
$result = "true";
/* send the email */
mail($to, $subject, $message, "From: " . $from . "\nX-Mailer: PHP/" . phpversion());
}
}
}
/* end action/send if statement */
?>
<div class="body">
<?php
$check = new QueryCheck();
$check->checkQuery($result, $query);
if (!empty($check->query)) {
$check->message("message", $action);
$check->display();
}
?>
<span class="fontTitle">Contact Us</span><br /><br />
<table>
<tr>
<td class="tableCellLabel">Commanding Officer</td>
<td> </td>
<td><?php
echo printCO();
?>
</td>
</tr>
jQuery.facebox(function() {
jQuery.get('admin/ajax/npc_' + action + '.php?id=' + id, function(data) {
jQuery.facebox(data);
});
});
return false;
});
});
</script>
<div class="body">
<?php
$check = new QueryCheck();
$check->checkQuery($result, $query);
if (!empty($check->query)) {
$check->message("non-playing character", $action_type);
$check->display();
}
?>
<span class="fontTitle">Manage Non-Playing Characters</span>
<p>From this page, you can select any of the NPCs that exist in your own department. You can edit their bios, promote (or demote) them to another position or rank (below your own). If you want to move an NPC from your own department to another department, please contact the CO or XO. In addition, you can also add your own NPCs for your department.
<?php
if (in_array("m_npcs2", $sessionAccess)) {
?>
If you would like to make an NPC a playing character, simply activate them. You will then be able to edit their account.
<?php
}
?>
<br /><br />
});
});
return false;
});
$('.zebra tr:nth-child(even)').addClass('alt');
});
</script>
<div class="body">
<?php
$check = new QueryCheck();
$check->checkQuery($result, $query);
if (!empty($check->query)) {
$check->message("database entry", $action_type);
$check->display();
}
?>
<span class="fontTitle">Database Entry Management</span><br /><br />
The database feature in SMS 2 allows for the creation of an easy-to-manage list of important links, both on-site and off-site, as well as the option to create a database entry for those things that don’t require a complete new page created.
<?php
if (in_array("m_database2", $sessionAccess)) {
?>
<strong class="yellow">Note:</strong> admins can give and take access to the database feature through the Department management page.
<?php
}
?>
jQuery.facebox(function() {
jQuery.get('admin/ajax/position_' + action + '.php', function(data) {
jQuery.facebox(data);
});
});
return false;
});
});
</script>
<div class="body">
<?php
$check = new QueryCheck();
$check->checkQuery($result, $query);
if (!empty($check->query)) {
$check->message("position", $action);
$check->display();
}
?>
<span class="fontTitle">Position Management</span><br /><br />
Use the fields below to manage the positions used by SMS. You can create new positions and tie them to a department by using the link below to add a new position.
<?php
if ($dept == 1) {
?>
<strong class="yellow">Please Note:</strong> Several functions that control emails in SMS use position ids 1 and 2 for the Commanding Officer and Executive Officer respectively. Because of this, you cannot delete the first two positions. If you change either of these positions to have different id numbers, some of the email functions will not work properly.
<?php
}
?>
<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");
?>
</span>
mail($to, $subject, $message, "From: " . $from . "\nX-Mailer: PHP/" . phpversion());
}
?>
<div class="body">
<?php
/* set the type */
if (isset($delete) || isset($add)) {
$type = "joint post author";
} else {
$type = "joint mission post";
}
$check = new QueryCheck();
$check->checkQuery($result, $query);
if (!empty($check->query)) {
$check->message($type, $action);
$check->display();
}
?>
<?php
if ($useMissionNotes == "y") {
?>
<script type="text/javascript">
$(document).ready(function() {
$('a#toggle').click(function() {
$('#notes').slideToggle('slow');
return false;
});
jQuery.facebox(function() {
jQuery.get('admin/ajax/moderate_edit.php?id=' + id, function(data) {
jQuery.facebox(data);
});
});
return false;
});
});
</script>
<div class="body">
<?php
$check = new QueryCheck();
$check->checkQuery($result, $query);
if (!empty($check->query)) {
$check->message("user moderation flags", "update");
$check->display();
}
?>
<span class="fontTitle">Crew Post Moderation</span><br /><br />
From this page you can view and change the moderation levels for various players. A green icon means that the type of post (the column) is being moderated for that particular player, while nothing in the column means the type of post is not being moderated.<br /><br />
Moderated posts will require approval before being sent out to the crew. If a player is moderated and they attempted to post a joint post, the joint post will require approval before it is sent out to the crew, even if the other members are not moderated. Unmoderated posts will be sent out without any need for activation. These values can also be changed from each user’s account page.<br /><br />
<table class="zebra" cellpadding="3" cellspacing="0">
<tr class="fontMedium">
<th>Crew Member</td>
<th>Mission Posts</td>
<th>Personal Logs</td>
<th>News Items</td>
</tr>
}
}
/* loop through the database items and put them into a 2d array */
while ($fetch3 = mysql_fetch_assoc($result3)) {
extract($fetch3, EXTR_OVERWRITE);
$array3[] = array($fetch3['dbid'], $fetch3['dbTitle']);
}
?>
<div class="body">
<?php
$check = new QueryCheck();
$check->checkQuery($result, $query);
if (!empty($check->query)) {
$check->message($type, "update");
$check->display();
}
?>
<span class="fontTitle">Site Options</span><br /><br />
SMS gives users more control of what they see when they’re logged in now. From this page,
you can set the skin you use when you’re logged in, the rank set you see as well as control
panel options and personalized menu items.<br />
<?php
$getUserInfo = "SELECT cpShowPosts, cpShowLogs, cpShowNews, cpShowPostsNum, ";
$getUserInfo .= "cpShowLogsNum, cpShowNewsNum, menu1, menu2, menu3, menu4, menu5, ";
$getUserInfo .= "menu6, menu7, menu8, menu9, menu10 FROM sms_crew WHERE crewid = '{$sessionCrewid}' LIMIT 1";
$getUserInfoResult = mysql_query($getUserInfo);
jQuery.facebox(function() {
jQuery.get('admin/ajax/tour_' + action + '.php?id=' + id, function(data) {
jQuery.facebox(data);
});
});
return false;
});
});
</script>
<div class="body">
<?php
$check = new QueryCheck();
$check->checkQuery($result, $query);
if (!empty($check->query)) {
$check->message("tour item", $action);
$check->display();
}
?>
<span class="fontTitle">Tour Management</span><br /><br />
The tour feature is designed to allow COs to give their players and visitors a visual picture of some of the major locations on the ship or starbase. To that end, you can specify not only a name and location, but a description as well as show up to three images of the location if you’d like. If you want to include more images than three, you’ll need to reference them in the description. In addition, images for your tour must be stored on your server and be put in the <em class="orange">images/tour</em> directory. Simply specify the name of the image and its extension and SMS will take care of the rest!<br /><br />
<a href="#" rel="facebox" myAction="add" myId="0" class="add fontMedium"><strong>Add New Tour Item »</strong></a>
<br /><br />
<table class="zebra" cellpadding="3" cellspacing="0">
<?php
/* pull the ranks from the database */
$getTour = "SELECT * FROM sms_tour ORDER BY tourOrder ASC";
$getTourResult = mysql_query($getTour);
/* loop through the results and fill the form */
admin.php?page=manage&sub=accesslevels&sec=pl">» Standard Player Access Levels</a>
</b>
<?php
} elseif (isset($sec)) {
/* get the group access levels for the specified section */
$getCrewAccess = "SELECT * FROM sms_accesslevels WHERE id = {$id} LIMIT 1";
$getCrewAccessResult = mysql_query($getCrewAccess);
$fetchAccess = mysql_fetch_array($getCrewAccessResult);
$access_raw = $fetchAccess[1] . "," . $fetchAccess[2] . "," . $fetchAccess[3] . "," . $fetchAccess[4] . "," . $fetchAccess[5];
$crewAccess = explode(',', $access_raw);
/* query check */
$check = new QueryCheck();
$check->checkQuery($result, $query);
if (!empty($check->query)) {
$check->message("default access level", "update");
$check->display();
}
?>
<span class="fontTitle">Default User Access Levels -
<?php
/* setup the title based on the section */
switch ($sec) {
case 'co':
echo "Commanding Officers";
break;
case 'xo':
echo "Executive Officers";
break;
case 'dh':
});
$('a#toggle').click(function() {
$('#notes').slideToggle('slow');
return false;
});
});
</script>
<div class="body">
<?php
$check = new QueryCheck();
$check->checkQuery($result, $query);
if (!empty($check->query)) {
$check->message("menu item", $action);
$check->display();
}
?>
<span class="fontTitle">Menu Management</span><br /><br />
Use this page to edit the menus used throughout SMS. From these pages, you will be able to change anything about a menu item or delete the item entirely. <b class="red">Use extreme caution when editing menu items. Incorrect modification can cause you to not be able to access the menu items any more! Deletions cannot be undone.</b> Changes made to any menu item will affect that item across all skins in the system.<br /><br />
<b class="fontMedium"><a href="#" class="add" myAction="add" rel="facebox">Add Menu Item »</a></b><br />
<?php
if ($simmType == "starbase" || $usePosting == "n" || $useMissionNotes == "n") {
?>
<br />
<div class="update">
<div class="notify-normal">
jQuery.get('admin/ajax/mission_add.php', function(data) {
jQuery.facebox(data);
});
});
return false;
});
});
</script>
<div class="body">
<?php
$check = new QueryCheck();
$check->checkQuery($result, $query);
if (!empty($check->query)) {
$check->message("mission", $action);
$check->display();
}
?>
<span class="fontTitle">Mission Management</span><br /><br />
From here you can manage the missions your sim is participating in. You can as many missions simultaneously that you want simply by setting each mission to Current Mission. From the posting pages, players will be able to choose which mission their post is put into. Whether you use the posting system or not, mission management lets you provide pertinent mission information to your players. To create a mission, click the link below, or to update/delete a mission, use the forms below.<br /><br />
<a href="#" rel="facebox" class="fontMedium add"><strong>Add New Mission »</strong></a>
<br /><br />
<div id="container-1">
<ul>
<li><a href="#one"><span>Current Mission(s)</span></a></li>
<li><a href="#two"><span>Upcoming Missions (<?php
echo count($mission_array['upcoming']);
$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;
?>
admin.php?page=manage&sub=coc&action=delete" class="delete fontMedium"><strong>Remove Last CoC Position »</strong></a>
$posts_array['pending'][] = array('id' => $fetch_p[0], 'title' => $fetch_p[1], 'author' => $fetch_p[2]);
}
?>
<script type="text/javascript">
$(document).ready(function() {
$('#container-1 > ul').tabs();
$('.zebra tr:nth-child(even)').addClass('alt');
});
</script>
<div class="body">
<?php
$check = new QueryCheck();
$check->checkQuery($result, $query);
if (!empty($check->query)) {
$check->message("news item", $action);
$check->display();
}
?>
<span class="fontTitle">Manage News Items</span><br /><br />
<div id="container-1">
<ul>
<li><a href="#one"><span>Activated</span></a></li>
<li><a href="#two"><span>Saved (<?php
echo count($posts_array['saved']);
?>
)</span></a></li>
<li><a href="#three"><span>Pending (<?php
echo count($posts_array['pending']);
?>
$mission_array = array('current' => array(), 'completed' => array(), 'upcoming' => array());
$missions = "SELECT * FROM sms_missions ORDER BY missionOrder DESC";
$missionsResult = mysql_query($missions);
while ($notes = mysql_fetch_array($missionsResult)) {
extract($notes, EXTR_OVERWRITE);
$mission_array[$missionStatus][] = array('id' => $missionid, 'title' => $missionTitle, 'order' => $missionOrder, 'summary' => $missionSummary);
}
?>
<div class="body">
<?php
$check = new QueryCheck();
$check->checkQuery($result, $query);
if (!empty($check->query)) {
$check->message("mission summary", "update");
$check->display();
}
?>
<script type="text/javascript">
$(document).ready(function(){
$('#container-1 > ul').tabs(<?php
echo $tab;
?>
);
});
</script>
<span class="fontTitle">Manage Mission Summaries</span><br /><br />
Mission summaries allow you to summarize your past and current missions so that new users can get a feel for what your crew has done in-character. It’s also a great way for players that enter during a mission or current players who have fallen behind to get caught up quickly.<br /><br />
jQuery.facebox(function() {
jQuery.get('admin/ajax/rank_' + action + '.php', function(data) {
jQuery.facebox(data);
});
});
return false;
});
});
</script>
<div class="body">
<?php
$check = new QueryCheck();
$check->checkQuery($result, $query);
if (!empty($check->query)) {
$check->message("rank", $action);
$check->display();
}
?>
<span class="fontTitle">Rank Management</span><br /><br />
Use the fields below to manage the ranks used by SMS. <strong class="yellow">Please note</strong> that all the rank sets use the same data from the database, the only thing that changes are the images. You cannot edit a certain rank set to be different from another. If you want to create a new rank item, use the link below.<br /><br />
<a href="#" rel="facebox" myAction="add" class="add fontMedium"><strong>Create New Rank »</strong></a><br /><br />
<p><span class="fontSmall">Click on the rank image to view that rank set</span><br /><br />
<?php
foreach ($allowedRanksArray as $key => $value) {
?>
<a href="<?php
echo $webLocation;
?>
$action = "save";
} elseif (isset($_POST['action_delete_x'])) {
$query = "DELETE FROM sms_personallogs WHERE logid = {$id} LIMIT 1";
$result = mysql_query($query);
/* optimize the table */
optimizeSQLTable("sms_personallogs");
$action = "delete";
}
?>
<div class="body">
<?php
$check = new QueryCheck();
$check->checkQuery($result, $query);
if (!empty($check->query)) {
$check->message("personal log", $action);
$check->display();
}
?>
<span class="fontTitle">Post Personal Log</span><br /><br />
<?php
if (!isset($id)) {
?>
<form method="post" action="<?php
echo $webLocation;
?>
admin.php?page=post&sub=log">
<table>
<tr>
jQuery.facebox(function() {
jQuery.get('admin/ajax/docking_' + action + '.php?id=' + id, function(data) {
jQuery.facebox(data);
});
});
return false;
});
});
</script>
<div class="body">
<?php
$check = new QueryCheck();
$check->checkQuery($result, $query);
if (!empty($check->query)) {
$check->message("ship", $action);
$check->display();
}
?>
<span class="fontTitle">Docked Ship Management</span><br /><br />
From here you can edit any ships that are currently docked or have previously docked with your starbase. You cannot edit or activate pending docking requests from this page, you must use the <a href="<?php
echo $webLocation;
?>
admin.php?page=manage&sub=activate">activation page</a> to do so.<br /><br />
<div id="container-1">
<ul>
<li><a href="#one"><span>Docked Ships (<?php
echo count($ships['activated']);
?>
$action = "save";
} elseif (isset($_POST['action_delete_x'])) {
$query = "DELETE FROM sms_posts WHERE postid = {$id} LIMIT 1";
$result = mysql_query($query);
/* optimize the table */
optimizeSQLTable("sms_posts");
$action = "delete";
}
?>
<div class="body">
<?php
$check = new QueryCheck();
$check->checkQuery($result, $query);
if (!empty($check->query)) {
$check->message("mission entry", $action);
$check->display();
}
if ($useMissionNotes == "y" && !isset($_POST['action_delete_x'])) {
?>
<script type="text/javascript">
$(document).ready(function() {
$('a#toggle').click(function() {
$('#notes').slideToggle('slow');
return false;
});
});
</script>
<div class="update notify-normal">
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>
<select id="participants">
/* define the email variables */
$to = printCOEmail() . ", " . printXOEmail();
$subject = $emailSubject . " Status Change Request";
$message = $_POST['crewMember'] . " has requested that their status be changed to {$newStatus}.\n\nDuration: " . stripslashes($_POST['duration']) . "\nReason: " . stripslashes($_POST['reason']);
/* send the nomination email */
mail($to, $subject, $message, "From: " . $from . "\nX-Mailer: PHP/" . phpversion());
}
?>
<div class="body">
<?php
$check = new QueryCheck();
$check->checkQuery($result, $query);
if (!empty($check->query)) {
$check->message("status", "update");
$check->display();
}
?>
<span class="fontTitle">Request Status Change</span><br /><br />
Use this page to inform the CO and XO of your intention to go on LOA or ELOA. Once you
submit the form, your status will be changed.<br /><br />
<?php
$getInfo = "SELECT loa FROM sms_crew WHERE crewid = '{$sessionCrewid}' LIMIT 1";
$getInfoResult = mysql_query($getInfo);
$info = mysql_fetch_assoc($getInfoResult);
?>
