<?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()):
			$picture = (($picture && file_exists($editorsuploadpath.$picture))) ? $editorsdir.$picture : $imageurl.'avatar_2x.png';
			$list .= '<div class="body">';
			$list .= '<table border="0" cellpadding="0" cellspacing="0" class="fluid">';
			$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 .= '<div class="fluid">';
			$list .= '<b>'.$name.'</b>';
			$list .= ($degree) ? '<br clear="all" />'.$degree : '';
			$list .= '</div>';
			$list .= ($post) ? '<br clear="all" /><b style="line-height:24px">'.$post.'</b>' : '';
			$list .= '<br clear="all" />'.$content;
			$list .= ($email && $emailshow === 'Y') ? '<br clear="all" style="line-height:24px" /><b>Email:</b> '.$email : '';
			$list .= ($phone && $phoneshow === 'Y') ? '<br clear="all" style="line-height:24px" /><b>Phone:</b> '.$phone : '';
			$list .= '</td>';
			$list .= '</tr>';
			$list .= '</table>';
			$list .= '</div>';
		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):
	$stmt->bind_result($category);
	echo '<div class="fluid boards">';
	while($stmt->fetch()):
		echo '<div class="head">'.$category.'</div>';
		echo boards($category);
	endwhile;
	$stmt->close();
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');
?>