Location: PHPKode > projects > Prsaar Social Networking Platform > PrsaarColour-0.7.alpha.6.3/pr-admin/index.php
<?php
	//------------------------------ Initialise dashboard
	require_once('./admin.php');
	$Display->Title = 'Dashboard';
	
	//---------------------Database quries
	$Scratch = $DC->Result("SELECT count(*) FROM ".PR_DATABASE_PREFIX."scratch WHERE scratch_status = 'moderate'");
	if($Scratch == false) $Scratch = 0;
	else $Scratch = $Scratch[0]['count(*)'];
	$Question = $DC->Result("SELECT count(*) FROM ".PR_DATABASE_PREFIX."askme WHERE askme_status = 'toanswer'");
	if($Question == false) $Question = 0;
	else $Question = $Question[0]['count(*)'];
	//-------------------------------------
?>
<?php require('./admin-display-header.php'); ?>
	<h2> Dashboard &raquo;&raquo; </h2>
	<ul>
		<ol> <a href='./scratch.php?page=new'>You have (<?php echo $Scratch; ?>) new <?php _Plural('scratch', $Scratch, 'es'); ?>. </ol>
		<ol> <a href='./askme.php?page=new'>You have (<?php echo $Question; ?>) new <?php _Plural('question', $Question); ?> to answer. </ol>
	</ul>
<?php require('./admin-display-footer.php'); ?>
Return current item: Prsaar Social Networking Platform