lastmodifiedpages

You are here:

Saturday, December 14 in 2024

lastmodifiedpages

shows a list of lhe last [count] pages

Suggested Name:

lastmodifiedpages

Droplet Code:

global $database, $wb;
	$template = (isset($template) ? $template : '');
	if($template == '')
	{ //set default template
		$template  = '<li><span> {LANG}  {DATE}  {TIME}  {USER}</span>  ';
		$template .= '<a href="{LINK}" title="{PAGE_TITLE}">{MENU_TITLE}</a></li>';
	}
	$count = (!isset($count)) ? 5 : intval($count);
	$sql  = 'SELECT `p`.`page_id`,`p`.`link`,`p`.`modified_when`,';
	$sql .= '`p`.`language`,`p`.`visibility`,`p`.`viewing_groups`,';
	$sql .= '`p`.`viewing_users`,`p`.`page_title`, `p`.`menu_title`, ';
	$sql .= '`u`.`display_name` ';
	$sql .= 'FROM `'.TABLE_PREFIX.'pages` `p` LEFT JOIN `'.TABLE_PREFIX.'users` `u` ON `p`.`modified_by`= `u`.`user_id` ';
	$sql .= 'ORDER BY `p`.`modified_when` DESC';
	$output = '';
	if( ($res_pages = $database->query($sql)) )
	{
		$placeholders = array('{LINK}','{PAGE_TITLE}','{MENU_TITLE}','{LANG}','{DATE}','{TIME}','{USER}');
		$showall = ($count == -1);
		while( ($rec_page = $res_pages->fetchRow(MYSQL_ASSOC)) && ($count > 0 || $showall) )
		{
			if( $wb->page_is_visible($rec_page) )
			{
				$replacements = array();
				$replacements['link'] = WB_URL.PAGES_DIRECTORY.$rec_page['link'].PAGE_EXTENSION;
				$replacements['page_title'] = $rec_page['page_title'];
				$replacements['menu_title'] = $rec_page['menu_title'];
				if(defined('PAGE_LANGUAGES') && PAGE_LANGUAGES == true)
				{
					$replacements['lang'] = '['.$rec_page['language'].']';
				}else
				{
					$replacements['lang'] = '';
				}
				$replacements['date'] = date(DATE_FORMAT, $rec_page['modified_when']);
				$replacements['time'] = date(TIME_FORMAT, $rec_page['modified_when']);
				$replacements['user'] = $rec_page['display_name'];
				$output .= str_replace($placeholders, $replacements, $template)."\n";
				$count--;
			}
		}
	}
	if($output == '')
	{
		$output = '[[LastModifiedPages::no pages found]]'."\n";
	}else
	{
		$output = '<ul class="lastpages">'."\n".$output."</ul>\n";
	}
	return $output;