<?php
	require_once('admin.php');
	//_________________________________________________
	$Display->Title = 'Askme';
	$Display->Subtitle = 'General';
	//___________________________________________________
	require('./admin-display-header.php');
	
	//Database queries
	$Total = $DC->Result("SELECT count(*) FROM ".PR_DATABASE_PREFIX."askme");
	$ToAnswer = $DC->Result("SELECT count(*) FROM ".PR_DATABASE_PREFIX."askme WHERE askme_status = 'toanswer'");
	$Answered = $DC->Result("SELECT count(*) FROM ".PR_DATABASE_PREFIX."askme WHERE askme_status = 'answered'");
	if($Total != false)
	{
		$Total = $Total[0]['count(*)'];
	}
	else
	{
		$Total = '0';
	}
	if($ToAnswer != false)
	{
		$ToAnswer = $ToAnswer[0]['count(*)'];
	}
	else
	{
		$ToAnswer = '0';
	}
	if($Answered != false)
	{
		$Answered = $Answered[0]['count(*)'];
	}
	else
	{
		$Answered = '0';
	}
	//---------------------------------------------------
	
?>
<h2> Askme Settings &raquo;&raquo; </h2>
<ul> <li> You have <strong> <?php _P($ToAnswer); ?> </strong> <?php _Plural('question', $ToAnswer); ?> to answer. <br /> &nbsp; </li> 
	 <li> You have answered <strong> <?php _P($Answered); ?> </strong> <?php _Plural('question', $Answered); ?> so far. </li> 
	 <li> Total <strong> <?php _P($Total); ?> </strong> <?php _Plural('question', $Total); ?> asked so far (excluding deleted questions). </li>
</ul>
<ul> <li> <a href='askme-new.php'> Answer new questions (<strong><font size='+2'><?php _P($ToAnswer); ?></font></strong> new) </a> </li>
	 <li> <a href='askme-answer.php'> Edit answers </a> </li>
</ul>

<?php
require('./admin-display-footer.php');
?>