<?php
require_once('header.php');
echo $page_content;
$leavingstatus = 'Y';
function boards($category){
	global $mysqli, $baseurl, $imageurl, $boardstatus, $editorsdir, $editorsuploadpath, $leavingstatus;
	$list = '';
	$stmt = $mysqli->prepare("SELECT name, degree, post, content, email, emailshow, phone, phoneshow, picture FROM editors WHERE (category = ? AND status = ? AND leavingstatus = ?) ORDER BY sortnumber ASC") or die('An error occurred. Please try after some time.');
	$stmt->bind_param('sss', $category, $boardstatus, $leavingstatus);
	$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()):
			$picture = (($picture && file_exists($editorsuploadpath.$picture))) ? $editorsdir.$picture : $imageurl.'avatar_2x.png';
			$list .= '<tr>';
			$list .= '<td align="center" valign="top" class="f"><img src="'.$picture.'" alt="'.$name.'" /></td>';
			$list .= '<td align="left" valign="top" class="l">';
			$list .= '<b>'.$name.'</b>';
			$list .= ($degree) ? '&nbsp;('.$degree.')' : '';
			$list .= '<br clear="all" />';
			$list .= ($post) ? $post.'<br clear="all" />' : '';
			$list .= $content.'<br clear="all" />';
			$list .= ($email && $emailshow === 'Y') ? '<b>Email:</b> '.$email.'<br clear="all" />' : '';
			$list .= ($phone && $phoneshow === 'Y') ? '<b>Phone:</b> '.$phone : '';
			$list .= '</td>';
			$list .= '</tr>';
		endwhile;
		$stmt->close();
	endif;
	return $list;
}
$boardstatus = 'enabled';
$stmt = $mysqli->prepare("SELECT category FROM editors WHERE (status = ? AND leavingstatus = ?) GROUP BY category ORDER BY catsortnumber ASC") or die('An error occurred. Please try after some time.');
$stmt->bind_param('ss', $boardstatus, $leavingstatus);
$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><th align="left" valign="middle" colspan="2">'.$category.'</th></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}ApplyforBoardMember">Click Here</a></p>
</div>
EOJ;
require_once("footer.php");
?>