Hi P,
first you must backup any files before you make the changes.
for newest members edit /components/com_community/controllers/frontpage.php line 97, changing the code from
$latestMembers = $model->getLatestMember($limit);
to
$latestMembers = $model->getLatestMember($limit, false);
edit /components/com_community/models/user.php around line 174, change the code from
public function getLatestMember($limit = 15) {
if ($limit == 0)
return array();
$limit = ($limit < 0) ? 0 : $limit;
$config = CFactory::getConfig();
$db = $this->getDBO();
$filterquery = '';
$config = CFactory::getConfig();
if (!$config->get('privacy_show_admins')) {
$userModel = CFactory::getModel('User');
$tmpAdmins = $userModel->getSuperAdmins();
$admins = array();
$filterquery .= ' AND ' . $db->quoteName('id') . ' NOT IN(';
for ($i = 0; $i < count($tmpAdmins); $i++) {
$admin = $tmpAdmins[$i];
$filterquery .= $db->Quote($admin->id);
$filterquery .= $i < count($tmpAdmins) - 1 ? ',' : '';
}
$filterquery .= ')';
}
$query = 'SELECT * FROM ' . $db->quoteName('#__users') . ' '
. ' WHERE ' . $db->quoteName('block') . '=' . $db->Quote(0) . ' '
. $filterquery
. ' ORDER BY ' . $db->quoteName('registerDate') . ' '
. ' DESC LIMIT ' . $limit;
$db->setQuery($query);
$result = $db->loadObjectList();
if ($db->getErrorNum()) {
JError::raiseError(500, $db->stderr());
}
$latestMembers = array();
$uids = array();
foreach ($result as $m) {
$uids[] = $m->id;
}
CFactory::loadUsers($uids);
foreach ($result as $row) {
$latestMembers[] = CFactory::getUser($row->id);
}
return $latestMembers;
}to
public function getLatestMember($limit = 15, $avatar = true) {
if ($limit == 0)
return array();
$limit = ($limit < 0) ? 0 : $limit;
$config = CFactory::getConfig();
$db = $this->getDBO();
$filterquery = '';
$config = CFactory::getConfig();
if (!$config->get('privacy_show_admins')) {
$userModel = CFactory::getModel('User');
$tmpAdmins = $userModel->getSuperAdmins();
$admins = array();
$filterquery .= ' AND ' . $db->quoteName('id') . ' NOT IN(';
for ($i = 0; $i < count($tmpAdmins); $i++) {
$admin = $tmpAdmins[$i];
$filterquery .= $db->Quote($admin->id);
$filterquery .= $i < count($tmpAdmins) - 1 ? ',' : '';
}
$filterquery .= ')';
}
$where = '';
if ($avatar == false) {
$where = ' AND avatar != "" ';
}
$query = 'SELECT ' . $db->quoteName('#__users') . '.* FROM ' . $db->quoteName('#__users') . ' '
. ' LEFT JOIN ' . $db->quoteName('#__community_users') . ' ON (' . $db->quoteName('#__community_users.userid') . '=' . $db->quoteName('#__users.id') . ') '
. ' WHERE ' . $db->quoteName('block') . '=' . $db->Quote(0) . $where . ' '
. $filterquery
. ' ORDER BY ' . $db->quoteName('registerDate') . ' '
. ' DESC LIMIT ' . $limit;
$db->setQuery($query);
$result = $db->loadObjectList();
if ($db->getErrorNum()) {
JError::raiseError(500, $db->stderr());
}
$latestMembers = array();
$uids = array();
foreach ($result as $m) {
$uids[] = $m->id;
}
CFactory::loadUsers($uids);
foreach ($result as $row) {
$latestMembers[] = CFactory::getUser($row->id);
}
return $latestMembers;
}
do you need Featured, Active, and Popular also?
the changes will be long, and it will painfull every upgrade process. you need to re-apply again.
Regards
