<?php
	require_once('./admin.php');
	//______________________________________________________
	$Display->Title = 'Scratches';
	$Display->Subtitle = 'New scratches';
	$UpdateFile = 'scratch-new-update.php';
	//_______________________________________________________
	require('./admin-display-header.php');
	
	//--------------------- database queries
	$Scratch = $DC->Result("SELECT * FROM ".PR_DATABASE_PREFIX."scratch WHERE scratch_status = 'moderate'");
	//----------------------------------
	print " <h2> New Scratches &raquo;</h2> ";
	if($Scratch == false) print ' <p> No new scratches. <a href="scratch-manage.php">Manage your moderated scratches.</a> ';
	else
	{
		foreach($Scratch as $Key => $KeyValue)
		{
					if(empty($i)) $i = 0;
					if($i%2 == 0) $BackgroundColour = '#F1F1F1';
					else $BackgroundColour = '#E2E2E2';
					$i++;
?>
			<div style='background-color:<?php _P($BackgroundColour); ?>; padding:8px; margin:4px; border:solid 1px grey;'>
 <strong>Name:</strong> <?php _p($KeyValue['scratch_user_name']); ?>
 | <strong>URL:</strong> <a href='<?php _p($KeyValue['scratch_user_url']); ?>'><?php _P($KeyValue['scratch_user_url']); ?></a> 
 | <strong>E-mail:</strong> <a href='mailto:<?php _p($KeyValue['scratch_user_mail']); ?>'><?php _P($KeyValue['scratch_user_mail']); ?></a>
 | <strong>Time:</strong> <?php _p($KeyValue['scratch_time']); ?> 
 <blockquote style="font-family:Georgia, 'Times New Roman', Times, serif; text-indent:10px;"> <?php _p($KeyValue['scratch_value']); ?> </blockquote>
 <a href='scratch-new-update.php?action=publish&id=<?php _P($KeyValue['scratch_id']); ?>'>Publish this scratch</a> ||
 <a href='scratch-new-update.php?action=delete&id=<?php _P($KeyValue['scratch_id']); ?>'>Delete this scratch</a>
			</div>
<?php
		}
	}

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