function execute(&$controller, &$request, &$user)
{
$site = DB_DataObject::factory('site');
$request->setAttribute('sites', $site->getNewSite(5));
$member_num = MemberUtils::total();
$request->setAttribute('member_num', $member_num);
$request->setAttribute('yesterday', time() - 60 * 60 * 24);
return VIEW_SUCCESS;
}
function execute(&$controller, &$request, &$user)
{
$site = DB_DataObject::factory('site');
$sql = 'SELECT m.account, s.title, s.description,
UNIX_TIMESTAMP(m.createdtime) AS createdtime
FROM member m
JOIN source src ON m.id = src.member_id
JOIN site s ON m.id = s.member_id
GROUP BY m.id
HAVING COUNT(s.id) > 0
ORDER BY m.createdtime DESC
LIMIT 16';
$site->query($sql);
$sites = array();
while ($site->fetch()) {
$sites[] = $site;
}
$request->setAttribute('sites', $sites);
$request->setAttribute('title', PLNET_FEED_NEW_PLNET_TITLE);
$request->setAttribute('description', PLNET_FEED_NEW_PLNET_DESCRIPTION);
$member_num = MemberUtils::total();
$request->setAttribute('member_num', $member_num);
return VIEW_SUCCESS;
}
