phpBB.de

Code: Alles auswählen

// Beginn Foto Box in PORTAL
//
// BEGIN Random or Recent Photo
//

$Display = 'Recent';            // Replace 'XXXX' with 'Recent' or 'Random'.
$CategoryID = 1;	           // Replace 0 with a category ID.  Otherwise, keep it as it is.
                                       // Example: http://www.seekideas.com/forum/album_cat.php?cat_id=3
                                       //                Category ID is 3

if ($Display == 'Random') {
	if ($CategoryID != 0) {
		$sql = "SELECT * FROM phpbb_album WHERE pic_cat_id = $CategoryID ORDER BY RAND() LIMIT 1";
	}
	else {
		$sql = "SELECT * FROM phpbb_album ORDER BY RAND() LIMIT 1";
	}
}
else if ($Display == 'Recent') {
	if ($CategoryID != 0) {
		$sql = "SELECT pic_id, pic_title, pic_username, pic_time FROM phpbb_album WHERE pic_cat_id = $CategoryID ORDER BY pic_time DESC LIMIT 0,1";
	}
	else {
		$sql = "SELECT pic_id, pic_title, pic_username, pic_time FROM phpbb_album ORDER BY pic_time DESC LIMIT 0,1";
	}
}

if (!$result = $db->sql_query($sql))
	{
	message_die(GENERAL_ERROR, 'Could not query album information', '', __LINE__, __FILE__, $sql);
	}
	
$picrow = $db->sql_fetchrow($result);
//
// END Random or Recent Photo
//

Code: Alles auswählen

# The name of your photo display 
# Example: $lang['Newest_pic'] = 'Newest Photo'; 
#       $lang['Newest_pic'] = 'HOTTEST PICTURE'; 
#       $lang['Newest_pic'] = 'Random Pic'; 

$lang['Newest_pic'] = 'Recent Photo';

Code: Alles auswählen

# The name of your photo display Example:
$lang['Newest_pic'] = 'Newest Photo'; 
$lang['Newest_pic'] = 'HOTTEST PICTURE'; 
$lang['Newest_pic'] = 'Random Pic'; 
$lang['Newest_pic'] = 'Recent Photo';

Code: Alles auswählen

// Photo Album 
'L_NEWEST_PIC' => $lang['Newest_pic'], 
'PIC_IMAGE' => append_sid('album_thumbnail.'. $phpEx . '?pic_id=' . $picrow['pic_id']), 
'PIC_TITLE' => $picrow['pic_title'], 
'PIC_POSTER' => $picrow['pic_username'], 
'U_PIC_LINK' => append_sid('album_comment.' . $phpEx . '?pic_id=' . $picrow['pic_id']), 
'PIC_TIME' => create_date($board_config['default_dateformat'], $picrow['pic_time'], $board_config['board_timezone']),

Code: Alles auswählen

'U_MARK_READ' => append_sid("index.$phpEx?mark=forums"))
    'L_NEWEST_PIC' => $lang['Newest_pic'], 
    'PIC_IMAGE' => append_sid('album_thumbnail.'. $phpEx . '?pic_id=' . $picrow['pic_id']), 
    'PIC_TITLE' => $picrow['pic_title'], 
    'PIC_POSTER' => $picrow['pic_username'], 
    'U_PIC_LINK' => append_sid('album_comment.' . $phpEx . '?pic_id=' . $picrow['pic_id']), 
    'PIC_TIME' => create_date($board_config['default_dateformat'], $picrow['pic_time'], $board_config['board_timezone']), 
	);