<?php
	require_once('./admin.php');
	//____________________________________________________________
	$Display->Title = 'Scratches';
	$Display->Subtitle = 'General';
	//____________________________________________________________
	require('./admin-display-header.php');
	
	//Database quries-----------------------------------------------
	$ScratchModerate = $DC->Result("SELECT * FROM ".PR_DATABASE_PREFIX."scratch WHERE scratch_status = 'moderate' ");
	$ScratchCountTotal = $DC->Result("SELECT count(*) FROM ".PR_DATABASE_PREFIX."scratch");
	$ScratchCountOkay = $DC->Result("SELECT count(*) FROM ".PR_DATABASE_PREFIX."scratch WHERE scratch_status = 'okay' ");
	$ScratchCountModerate = $DC->Result("SELECT count(*) FROM ".PR_DATABASE_PREFIX."scratch WHERE scratch_status = 'moderate' ");
	
	if($ScratchCountTotal == false) $ScratchCountTotal = 0; else $ScratchCountTotal = $ScratchCountTotal[0]['count(*)'];
	if($ScratchCountOkay == false) $ScratchCountOkay = 0; else $ScratchCountOkay = $ScratchCountOkay[0]['count(*)'];
	if($ScratchCountModerate == false) $ScratchCountModerate = 0; else $ScratchCountModerate = $ScratchCountModerate[0]['count(*)'];
	//-------------------------------------------
?>
<h2> Profile Settings &raquo;&raquo; </h2>
<ul> <li> You have <strong> <?php _P($ScratchCountModerate); ?> </strong> new <?php _Plural('scatch', $ScratchCountModerate, 'es'); ?> to moderate. </li>
	 <li> You have <strong> <?php _P($ScratchCountOkay); ?> </strong> <?php _Plural('scratch', $ScratchCountOkay, 'es'); ?> on your profile page. </li>
</ul> 
<a href='scratch-new.php'>Moderate new scratches (<?php _P($ScratchCountModerate); ?> new)</a> <br />
<?php
require('./admin-display-footer.php');
?>