<?php
<a href="http://www.ubbcentral.com">UBBCentral Webseite</a>

<br>

<a href="http://www.ubbcentral.com/order.php?product=UBB.threads">Preise / Bestellen</a>

<br>

<a href="http://www.infopop.com/members/members.php">UBB-Central Members Area</a>
?> 

$body = <<<EOF
<a href="http://www.ubbcentral.com">UBBCentral Webseite</a>
<br>
<a href="http://www.ubbcentral.com/order.php?product=UBB.threads">Preise / Bestellen</a>
<br>
<a href="http://www.infopop.com/members/members.php">UBB-Central Members Area</a>
EOF;
 

require_once("/home/.../photopost.inc.php");
$pp_db_prefix = "pp_";

function pp_get_ext( $filename ) {
	return substr($filename, strrpos($filename,"."));
}

function pp_is_image( $filename ) {
	$retval = 0;

	$mediatypes = array( ".jpg", ".gif", ".png", ".bmp" );
	$ext = pp_get_ext( $filename );

	if ( in_array(strtolower($ext), $mediatypes) )
		$retval = 1;

	return( $retval );
}

//
// Featured Photos Code
// Follow down to End Feature Photos Code
//

// which type of images do you want to show
$q_switch = "random";

switch ($q_switch) {
	case "most_view":
		$query = "SELECT p.id,p.user,p.userid,p.cat,p.title,p.bigimage,p.views 
			FROM {$pp_db_prefix}photos p 
			LEFT JOIN {$pp_db_prefix}categories c ON c.id=p.cat 
			WHERE c.password = '' 
			ORDER BY c.views DESC";
		break;
	case "lastest":
		$query = "SELECT p.id,p.user,p.userid,p.cat,p.title,p.bigimage,p.views 
			FROM {$pp_db_prefix}photos p 
			LEFT JOIN {$pp_db_prefix}categories c ON c.id=p.cat 
			WHERE c.password = '' 
			ORDER BY date DESC";
		break;
	case "random":
		$query = "SELECT p.id,p.user,p.userid,p.cat,p.title,p.bigimage,p.views 
			FROM {$pp_db_prefix}photos p 
			LEFT JOIN {$pp_db_prefix}categories c ON c.id=p.cat 
			WHERE c.password = '' 
			ORDER BY RAND()";
		break;
}
$result = mysql_query($query);

$counted = 0; $featured = "";

while ( list($pid, $puser, $puserid, $pcat, $ptitle, $photo, $pviews) = mysql_fetch_array($result)) {	
	if ( pp_is_image($photo) ) {
		$photolen = strlen($photo);
		$theext = pp_get_ext($photo);
		$photo_name = str_replace( $theext, "", $photo );
	
		$temp_user = $line['userid'];
		$thumbtag = "{$full_path}{$pcat}/thumbs/{$photo}";
		$mthumb = "<img border=\"0\" src=\"{$data_dir}{$pcat}/thumbs/{$photo}\" alt=\"$thumbtag\" />";
	
// One box for each feature
$featured .= <<<PPPRINT

	<tr align="center"><td align="center" class="alt-1">
		<a href="{$url_path}showphoto.php?photo={$pid}">$mthumb</a>
		<br />by {$puser}
	</td></tr>
	
PPPRINT;

		$counted++;
	}
	
	if ( $counted == 5 ) break;
}
mysql_free_result($result);


echo <<<PPPRINT
$tbopen
<tr>
<td class="tdheader" colspan="5" align="center">
Featured Photos
</td>
</tr>
$featured
$tbclose<br />
PPPRINT;

mysql_select_db ("name of uub7 database")or die("Could not select database");
 

echo <<<PPPRINT
$tbopen
<tr>
<td class="tdheader" colspan="5" align="center">
Featured Photos
</td>
</tr>
$featured
$tbclose<br />
PPPRINT;
 

$body = <<<PPPRINT
$tbopen
<tr>
<td class="tdheader" colspan="5" align="center">
Featured Photos
</td>
</tr>
$featured
$tbclose<br />
PPPRINT;