<?php
require_once("header.php");
echo $page_content;
function boards($category){
	global $mysqli, $imageurl, $boardstatus, $editorsdir, $editorsuploadpath;
	$list = "";
	$stmt = $mysqli->prepare("SELECT name, degree, post, content, email, emailshow, phone, phoneshow, picture FROM editors WHERE (category = ? AND status = ?) ORDER BY sortnumber ASC") or die("An error occurred. Please try after some time.");
	$stmt->bind_param('ss', $category, $boardstatus);
	$stmt->execute();
	$stmt->store_result();
	if($stmt->num_rows() > 0):
		$stmt->bind_result($name, $degree, $post, $content, $email, $emailshow, $phone, $phoneshow, $picture);
		while($stmt->fetch()):
			$list .= '<tr>';
			$list .= '<td align="center" valign="top" class="f">';
			$picture = (($picture && file_exists($editorsuploadpath . $picture))) ? $editorsdir . $picture : $imageurl . 'avatar_2x.png';
			$list .= '<img src="' . $picture . '" alt="' . $name . '" />';
			$list .= '</td>';
			$list .= '<td align="left" valign="top" class="l">';
			$list .= '<b>' . $name . '</b>';
			$list .= ($degree) ? ' ' . $degree : NULL;
			$list .= '<br clear="all" />';
			$list .= ($post) ? $post . '<br clear="all" />' : NULL;
			$list .= ($content) ? html_entity_decode($content) . '<br clear="all" />' : NULL;
			$list .= ($email && $emailshow === 'Y') ? '<b>Email:</b> ' . $email . '<br clear="all" />' : NULL;
			$list .= ($phone && $phoneshow === 'Y') ? '<b>Phone:</b> ' . $phone : NULL;
			$list .= '</td>';
			$list .= '</tr>';
		endwhile;
		$stmt->close();
	endif;
	return $list;
}
$boardstatus = "enabled";
$stmt = $mysqli->prepare("SELECT category FROM editors WHERE status = ? GROUP BY category ORDER BY catsortnumber ASC") or die("An error occurred. Please try after some time.");
$stmt->bind_param('s', $boardstatus);
$stmt->execute();
$stmt->store_result();
if($stmt->num_rows() > 0):
	echo '<table border="0" cellpadding="0" cellspacing="0" class="fluid boards">';
	$stmt->bind_result($category);
	while($stmt->fetch()):
		echo '<tr>';
		echo '<th align="left" valign="middle" colspan="2">' . $category . '</th>';
		echo '</tr>';
		echo boards($category);
	endwhile;
	$stmt->close();
	echo '</table>';
else:
	echo '<div align="center"><img src="' . $imageurl . 'coming-soon.png" alt="Comming Soon" /></div>';
endif;
echo <<<EOJ
<div class="fluid regboard">
	<p>Apply for Editorial Board Member <a href="{$baseurl}join">Click Here</a></p>
</div>
EOJ;
require_once("footer.php");
?>