CMS Made Simple Forums

Code: Select all

/*
Parameters to use:
   guestbook_id : define which guestbook has to be used, defaults to 1
   number : number of entries to show, defaults to 3

This UDT outputs the smarty array variable {$random_gb_entries}
It contains the keys:
            [entry_id]
            [guestbook]
            [sender]
            [e_mail]
            [homepage]
            [country]
            [location]
            [message]
            [date]
            [approved]
            [ip_address]
*/




$guestbook_id = isset($params['guestbook_id']) && ctype_digit($params['guestbook_id']) ? $params['guestbook_id'] : 1;
$number = isset($params['number']) && ctype_digit($params['number']) ? $params['number'] : 3;

$gCms = cmsms();
$db =& $gCms->db;

$query = "SELECT * FROM " . cms_db_prefix() . "module_guestbook 
	WHERE approved='1' AND guestbook='" . $guestbook_id . "' ORDER BY RAND() DESC LIMIT " . $number;
$result = $db->Execute($query);
$entries = array();

if ( $result )
{
	while ( $row=$result->FetchRow() )
	{
		$entries[] = $row;
	}
}

$smarty->assign_by_ref('random_gb_entries',$entries);

Code: Select all

{RandomGBentries}

<ul>
{foreach from=$random_gb_entries item=gb_entry}
  <li>{$gb_entry.entry_id}
    <ul>
    <li>{$gb_entry.guestbook}</li>
    <li>{$gb_entry.sender}</li>
    <li>{$gb_entry.e_mail}</li>
    <li>{$gb_entry.homepage}</li>
    <li>{$gb_entry.country}</li>
    <li>{$gb_entry.location}</li>
    <li>{$gb_entry.message}</li>
    <li>{$gb_entry.date}</li>
    <li>{$gb_entry.approved}</li>
    <li>{$gb_entry.ip_address}</li>
    </ul>
  </li> 
{/foreach}
</ul>