/**
* Maintenance script to collect video data (local and premium videos) and insert into video_info table
* Note: video data come from embedded premium videos, local videos, and related videos (related videos list and global list)
* Default setting: create video_info table, remove deleted videos (local) and add videos
* @author Liz Lee, Saipetch Kongkatong
*/
function addVideo(&$videoList, $titleName)
{
    global $dryrun, $added, $invalid, $duplicate, $dupInDb;
    $videoInfoHelper = new VideoInfoHelper();
    $videoData = $videoInfoHelper->getVideoDataFromTitle($titleName);
    if (!empty($videoData)) {
        printText($videoData['videoTitle']);
        $titleHash = md5($videoData['videoTitle']);
        if (!in_array($titleHash, $videoList)) {
            $status = true;
            if (!$dryrun) {
                $videoInfo = new VideoInfo($videoData);
                $status = $videoInfo->addVideo();
            }
            if ($status) {
                $added++;
                printText("..... ADDED.\n");
            } else {
                $dupInDb++;
                printText("..... ALREADY ADDED TO DB.\n");
            }
            $videoList[] = $titleHash;
        } else {
            $duplicate++;
            printText("..... ALREADY ADDED.\n");
        }
    } else {
        $invalid++;
        printText("{$titleName}..... INVALID.\n");
    }
}

function printAny($text)
{
    if (is_array($text)) {
        printArray($text);
    } else {
        printText($text);
    }
}

/**
 * add data to video
 * @param array $row
 * @param array $fields
 * @param array $video
 * @return array $video
 */
function addDataToVideo($row, $fields, $video = array())
{
    foreach ($fields as $key => $value) {
        $data = empty($row[$value]) ? '' : $row[$value];
        $video[] = $data;
        printText("\t{$key}: {$data}\n");
    }
    return $video;
}

**/
/* define the page class */
$pageClass = "simm";
/* pull in the menu */
if (isset($sessionCrewid)) {
    include_once 'skins/' . $sessionDisplaySkin . '/menu.php';
} else {
    include_once 'skins/' . $skin . '/menu.php';
}
?>

<div class="body">
	<span class="fontTitle">Simm Rules</span>
	<?php 
/*
	if the person is logged in and has level 5 access, display an icon
	that will take them to edit the entry
*/
if (isset($sessionCrewid) && in_array("m_messages", $sessionAccess)) {
    echo "&nbsp;&nbsp;&nbsp;&nbsp;";
    echo "<a href='" . $webLocation . "admin.php?page=manage&sub=messages' class='image'>";
    echo "<img src='" . $webLocation . "images/edit.png' alt='Edit' border='0' />";
    echo "</a>";
}
?>
	<br /><br />
	
	<?php 
printText($rules);
?>
</div>

            ?>
	
	<span class="fontMedium"><b><?php 
            printText($newsTitle);
            ?>
</b></span><br />
	<span class="fontSmall">
		Posted by <?php 
            printText($author);
            ?>
 on <?php 
            echo dateFormat("long", $newsPosted);
            ?>
<br />
		Category: <?php 
            printText($catName);
            ?>
	</span><br />
	<div style="padding: 1em 0 3em 1em;">
		<?php 
            printText($newsContent);
            ?>
	</div>
	
	<?php 
        }
    }
}
?>
	
</div>

				</span><br />
				<span class="fontSmall">
					Posted by <?php 
                printCrewName($newsItems['newsAuthor'], "rank", "link");
                ?>
 on <?php 
                echo dateFormat("long", $newsPosted);
                ?>
<br />
					Category: <?php 
                printText($catName);
                ?>
				</span><br />
				<div style="padding: .5em 0em 2em 1em;">
					<?php 
                printText($text);
                echo " ... <nobr>[ <a href='" . $webLocation . "index.php?page=news&id=" . $newsid . "'>Read More &raquo;</a> ]</nobr>";
                ?>
				</div>
			
			<?php 
            }
            /* close the while loop */
        }
        /* close the count check */
        ?>
		</div>
		<?php 
    }
    ?>
		

?>
		</div> <!-- close TWO -->
		
		<div id="three" class="ui-tabs-container ui-tabs-hide">
			<?php 
if (count($missions['completed']) < 1) {
    ?>
				<strong class='orange fontMedium'>No completed missions</strong>
			<?php 
} else {
    ?>
				<?php 
    foreach ($missions['completed'] as $key => $value) {
        echo "<a href='" . $webLocation . "index.php?page=mission&id=" . $value['id'] . "'><strong class='fontMedium'>";
        printText($value['title']);
        echo "</strong></a>";
        if ($usePosting == "y") {
            echo "&nbsp;&nbsp; [ Posts: " . $value['count'] . " ]";
        }
        echo "<div style='padding: 1em 0 2em 1em;'>";
        printText($value['desc']);
        echo "</div>";
    }
    ?>
			<?php 
}
?>
		</div> <!-- close THREE -->
	</div> <!-- close CONTENT -->
	
</div> <!-- Close .body -->

				<?php 
    } else {
        ?>
					<table>
						<?php 
        foreach ($mission_array['completed'] as $row) {
            ?>
							
						<form method="post" action="<?php 
            echo $webLocation;
            ?>
admin.php?page=manage&sub=summaries&t=3">
						<tr>
							<td class="tableCellLabel">
								<?php 
            printText($row['title']);
            ?>
								<input type="hidden" name="missionid" value="<?php 
            echo $row['id'];
            ?>
" />
							</td>
							<td>&nbsp;</td>
							<td>
								<textarea name="missionSummary" rows="15" class="wideTextArea"><?php 
            echo stripslashes($row['summary']);
            ?>
</textarea>
							</td>
						</tr>
						<tr>

    }
    if ($missionCount == 0) {
        echo "<b>Please create a mission before posting!</b>";
    } else {
        $missions = "SELECT missionid, missionTitle, missionStatus FROM sms_missions WHERE ";
        $missions .= "missionStatus != 'upcoming'";
        $missionsResult = mysql_query($missions);
        echo "<select name='postMission'>";
        while ($missionArray = mysql_fetch_array($missionsResult)) {
            extract($missionArray, EXTR_OVERWRITE);
            echo "<option value='" . $missionid . "'";
            if ($missionStatus == "current") {
                echo " selected ";
            }
            echo ">";
            printText($missionTitle);
            echo "</option>";
        }
        echo "</select>";
    }
    ?>
				</td>
			</tr>
			<tr>
				<td colspan="3" height="10"></td>
			</tr>
			<tr>
				<td class="narrowLabel tableCellLabel">Title</td>
				<td>&nbsp;</td>
				<td><input type="text" class="name" name="postTitle" style="font-weight:bold;" length="100" /></td>
			</tr>

						<img src="images/combadge-npc.png" border="0" alt="[ View Bio ]" />
					</a>
				</td>
			</tr>
	
		<?php 
            }
            /* close the NPC for loop */
        }
        /* close the if( $n_num_row ) logic */
        if ($p_open > "0" && $d_type == "playing") {
            ?>
	
			<tr class="open" style="display:none">
				<td width="35%" valign="middle" style="padding-left: 1em;"><?php 
            printText($p_position);
            ?>
</td>
				<td width="15%" valign="middle" align="right">
					<img src="<?php 
            echo $webLocation;
            ?>
images/ranks/<?php 
            echo $rankSet;
            ?>
/blank.png" />
				</td>
				<td width="40%" valign="middle">
					<span class="fontSmall">
						<a href="<?php 
            echo $webLocation;

?>

<div class="body">
	<span class="fontTitle">
		Mission Notes - <i><?php 
echo printMissionTitle($notes[0]);
?>
</i>
		
		<?php 
if (in_array("m_missionnotes", $sessionAccess)) {
    ?>
		&nbsp;
		<a href="<?php 
    echo $webLocation;
    ?>
admin.php?page=manage&sub=missionnotes">
			<img src="<?php 
    echo $webLocation;
    ?>
images/edit.png" border="0" alt="[ Edit ]" />
		</a>
		<?php 
}
?>
		
	</span><br /><br />
	<?php 
printText($notes[1]);
?>
</div>

        $missions = FALSE;
        while ($titleArray = mysql_fetch_array($missionTitleResult)) {
            extract($titleArray, EXTR_OVERWRITE);
            $missions[] = array('id' => $missionid, 'title' => $missionTitle);
        }
        if (count($missions) == 0) {
            echo "<b>You must <a href='" . $webLocation . "admin.php?page=manage&sub=missions'>create a mission</a> before posting!</b>";
        } elseif (count($missions) > 1) {
            echo "<select name='postMission'>";
            foreach ($missions as $k => $v) {
                echo "<option value='" . $v['id'] . "'>" . $v['title'] . "</option>";
            }
            echo "</select>";
        } else {
            echo "<a href='" . $webLocation . "index.php?page=mission&id=" . $missions[0]['id'] . "'>";
            printText($missions[0]['title']);
            echo "</a>";
            echo "<input type='hidden' name='postMission' value='" . $missions[0]['id'] . "' />";
        }
        ?>
				</td>
			</tr>
			<tr>
				<td class="narrowLabel tableCellLabel">Title</td>
				<td>&nbsp;</td>
				<td><input type="text" class="name" name="postTitle" style="font-weight:bold;" length="100" /></td>
			</tr>
			<tr>
				<td class="narrowLabel tableCellLabel">Location</td>
				<td>&nbsp;</td>
				<td><input type="text" class="name" name="postLocation" style="font-weight:bold;" length="100" /></td>

	<h3><?php 
    printText($pendingArray['dockingShipName'] . " " . $pendingArray['dockingShipRegistry']);
    ?>
</h3>
	<h4><?php 
    printText($pendingArray['dockingShipCO']);
    ?>
</h4>
	
	<div class="overflow">
		<strong>Duration:</strong> <?php 
    printText($pendingArray['dockingDuration']);
    ?>
</strong><br /><br />
		<?php 
    printText($pendingArray['dockingDesc']);
    ?>
	</div>
		
	<form method="post" action="">
		<div>
			<input type="hidden" name="action_id" value="<?php 
    echo $pendingArray['dockid'];
    ?>
" />
			<input type="hidden" name="action_type" value="delete" />
			<input type="hidden" name="action_tab" value="<?php 
    echo $tab_action;
    ?>
" />
	

</td>
		</tr>
		<?php 
}
if ($hasFighters == "y") {
    ?>
		<tr>
			<td class="tableCellLabel">Fighters</td>
			<td>&nbsp;</td>
			<td><?php 
    printText($fighters);
    ?>
</td>
		</tr>
		<?php 
}
if ($hasTransports == "y") {
    ?>
		<tr>
			<td class="tableCellLabel">Transports</td>
			<td>&nbsp;</td>
			<td><?php 
    printText($transports);
    ?>
</td>
		</tr>
		<?php 
}
?>
	</table>
</div> <!-- close the div id content tag -->

    echo "    ";
    echo "<a href='" . $webLocation . "admin.php?page=manage&sub=messages' class='image'>";
    echo "<img src='" . $webLocation . "images/edit.png' alt='Edit' border='0' />";
    echo "</a>";
}
?>
	<br /><br />
	
	<?php 
printText($simmMessage);
?>
	<br /><br />
	
	<p>
		<b><?php 
printText($co);
?>
<br />
		Commanding Officer, <?php 
printText($shipPrefix . " " . $shipName);
?>
<br />
		<?php 
if ($tfMember == "y") {
    echo $tfName . ", ";
}
echo $fleet;
?>
</b>
	</p>
</div>

" + "\n";
                receipt += "<?php 
                }
                ?>
";
                receipt += "<?php 
                echo printLine(lang("total_tax_amount") . ":" . $this->sma->formatMoney($inv->product_tax));
                ?>
" + "\n";
                <?php 
            }
        }
        ?>
                receipt += "\x1B\x61\x31";
                receipt += "\n" + "<?php 
        echo $biller->invoice_footer ? printText(str_replace(array('\\n', '\\r'), ' ', $this->sma->decode_html($biller->invoice_footer))) : '';
        ?>
" + "\n";
                receipt += "\x1B\x61\x30";
                <?php 
        if (isset($pos_settings->cash_drawer_cose)) {
            ?>
                print(receipt, '', '<?php 
            echo $pos_settings->cash_drawer_cose;
            ?>
');
                <?php 
        } else {
            ?>
                print(receipt, '', '');
                <?php 

            case 5:
                echo "red";
                break;
        }
        echo "'>";
        ?>
					<i><?php 
        echo dateFormat("long", $strikeDate);
        ?>
</i> - 
					<?php 
        printCrewName($crewid, "rank", "noLink");
        ?>
 [ Strike #<?php 
        echo $allStrikes['number'];
        ?>
 ]</b> - 
					<?php 
        printText($reason);
        ?>
				</li><br />
				<?php 
    }
    ?>
			</ul>
	</div>

<?php 
} else {
    errorMessage("strike listing");
}

    $sessionAccess = explode(",", $_SESSION['sessionAccess']);
}
if (in_array("x_approve_users", $sessionAccess)) {
    include_once '../../framework/functionsGlobal.php';
    include_once '../../framework/functionsUtility.php';
    if (isset($_GET['id']) && is_numeric($_GET['id'])) {
        $id = $_GET['id'];
    }
    /* get the data */
    $getPendingCrew = "SELECT crewid, firstName, lastName, positionid, rankid ";
    $getPendingCrew .= "FROM sms_crew WHERE crewid = {$id} LIMIT 1";
    $getPendingCrewResult = mysql_query($getPendingCrew);
    $pendingArray = mysql_fetch_assoc($getPendingCrewResult);
    ?>
	<h2>Reject Crew Application &ndash; <?php 
    printText($pendingArray['firstName'] . " " . $pendingArray['lastName']);
    ?>
</h2>
	<p>Please specify message you want to be sent to the player regarding their rejection.</p>
	<p>Rejection messages can now use wild cards for dynamic elements. For instance, using the <strong class="yellow">#position#</strong> wild card will insert the position they applied for into the email before it is sent. Available wild cards are: <strong>#ship#</strong>, <strong>#position#</strong>, and <strong>#player#</strong> (character&rsquo;s name).</p>
	
	<form method="post" action="">
		<table>
			<tr>
				<td class="tableCellLabel">Email Message</td>
				<td>&nbsp;</td>
				<td>
					<textarea name="rejectMessage" class="narrowTable" rows="10"><?php 
    echo stripslashes($rejectMessage);
    ?>
</textarea>

                    echo "<option value='" . $rankid . "' style='color:#" . $deptColor . ";'>" . $rankName . "</option>";
                }
            }
            ?>
					</select>
				</td>
			</tr>
			<?php 
        } else {
            ?>
			<tr>
				<td class="tableCellLabel">Rank</td>
				<td>&nbsp;</td>
				<td>
					<b><?php 
            printText($fetchRank['rankName']);
            ?>
</b>
					<span class="fontSmall">
						<br /><a href="#" rel="facebox" myAction="why">Why can&rsquo;t I change this rank?</a>
					</span>
					<input type="hidden" name="rank" value="<?php 
            echo $fetchCrew['rankid'];
            ?>
" />
				</td>
			</tr>
			<?php 
        }
        ?>
			

                    if (!empty($value[1])) {
                        ?>
					<br />
					<span class="fontSmall">Awarded: <?php 
                        echo dateFormat('medium2', $value[1]);
                        ?>
</span>
					<?php 
                    }
                    ?>
					</span>
				</td>
				<td width="55%" valign="middle">
					<?php 
                    if (!empty($value[2])) {
                        printText($value[2]);
                    } else {
                        echo "<span class='orange'>No reason given</strong>";
                    }
                    ?>
				</td>
				<td width="15%" align="center">
					<a href="#" rel="facebox" myAward="<?php 
                    echo $key;
                    ?>
" myID="<?php 
                    echo $crew;
                    ?>
" class="delete"><strong>Remove Award</strong></a>
				</td>
			</tr>