function &getList($params)
{
$modulemode = $params->get('modulemode', 'latest');
$default_avatar = JURI::root(true) . '/' . $params->get('default_avatar', 'modules/mod_rokbridge_members/assets/default-avatar.png');
if (!($forum_db =& $this->rokbridge->getDb())) {
return array();
}
$latest_members = array();
$limit = trim($params->get('limit', 20));
if ($modulemode == 'latest') {
$sql = "SELECT user_id, user_type, username, user_avatar, user_avatar_type, user_avatar_width, user_avatar_height, user_regdate, FROM_UNIXTIME(user_regdate,'%a %b %D %x %h:%i %p') AS reg_date\n \t\t FROM #__users\n \t\t WHERE user_type != 2\n \t\t\tORDER BY user_regdate DESC \n \t\t\tLIMIT 0, " . $limit;
} elseif ($modulemode == 'top') {
$sql = "SELECT user_id, user_type, username, user_avatar, user_avatar_type, user_avatar_width, user_avatar_height, user_lastvisit, user_posts, FROM_UNIXTIME(user_lastvisit,'%a %b %D %x %h:%i %p') AS last_visit\n \t\t FROM #__users\n \t\t WHERE user_type != 2\n \t\t\tORDER BY user_posts DESC \n \t\t\tLIMIT 0, " . $limit;
} else {
$time = time() - intval($params->get('onlinetime', 5)) * 60;
$sql = "SELECT u.user_id, u.user_type, u.username, u.user_avatar, u.user_avatar_type, u.user_avatar_width, u.user_avatar_height, u.user_lastvisit, u.user_posts, s.session_time, u.user_allow_viewonline as show_online, FROM_UNIXTIME(user_lastvisit,'%a %b %D %x %h:%i %p') AS last_visit \n\t\t FROM #__users u, #__sessions s \n\t\t WHERE u.user_id = s.session_user_id AND s.session_time >= " . ($time - (int) ($time % 30)) . " \n\t\t AND u.user_type != 2 AND s.session_user_id <> 1 \n\t\t ORDER BY u.user_lastvisit \n\t\t DESC";
}
$forum_db->setQuery($sql);
$results = $forum_db->loadObjectList();
// remove duplicate entries
$rows = array();
foreach ($results as $result) {
if (!array_key_exists($result->user_id, $rows)) {
$rows[$result->user_id] = $result;
}
}
/* Start Building Time */
$formatdate = trim($params->get('formatdate'));
foreach ($rows as $row) {
if ($modulemode == 'latest') {
$date =& JFactory::getDate($row->reg_date);
$reg_date = $date->toFormat($formatdate);
$row->reg_date = $reg_date;
$row->extra_info = ' : ' . $reg_date;
} elseif ($modulemode == 'top') {
$row->extra_info = ' : Posts: ' . $row->user_posts;
} else {
$row->extra_info = '';
$time_online = floor((time() - intval($row->user_lastvisit)) / 60) + 1;
$row->extra_info = ' : Online ' . $time_online . ' mins';
}
require_once JPATH_ADMINISTRATOR . DS . 'components' . DS . 'com_rokbridge' . DS . 'helper.php';
$rokbridge = new RokBridgeHelper();
$row->avatar_img = $rokbridge->getAvatar($row, $params->get('avatar_size', 32), $row->extra_info, $default_avatar);
$latest_members[] = $row;
}
return $latest_members;
}
function getAvatar($user, $extension, $default_avatar)
{
$avatar = 0;
if ($user->get('id') == 0) {
$avatar = !empty($default_avatar) ? $default_avatar : 0;
} elseif ($extension == 1) {
require_once JPATH_ADMINISTRATOR . '/components/com_rokbridge/helper.php';
$rokbridge = new RokBridgeHelper();
$phpbb_db = $rokbridge->phpbb_db;
$query = "SELECT user_id, user_type, username, user_unread_privmsg, user_new_privmsg, user_avatar, user_avatar_type, user_avatar_width, user_avatar_height, user_lastvisit, FROM_UNIXTIME(user_lastvisit,'%a %b %D %x %h:%i %p') AS LastVisit FROM #__users WHERE " . $rokbridge->getWhereClause($user->username);
$phpbb_db->setQuery($query);
$fuser = $phpbb_db->loadObject();
$avatar = $rokbridge->getAvatar($fuser, 35, "", $default_avatar);
$avatar = substr($avatar, strpos($avatar, '"') + 1);
$avatar = substr($avatar, 0, strpos($avatar, '"'));
} elseif ($extension == 2) {
$jspath = JPATH_BASE . DS . 'components/com_community';
include_once $jspath . DS . 'libraries/core.php';
$user =& CFactory::getUser($user->get('id'));
$avatar = $user->getThumbAvatar();
} elseif ($extension == 3) {
$jspath = JPATH_ADMINISTRATOR . '/components/com_comprofiler';
include_once $jspath . DS . 'plugin.foundation.php';
cbimport('cb.database');
$user =& CBuser::getInstance($user->get('id'));
$avatar = $user->avatarFilePath(1);
if (empty($avatar)) {
$avatar = $default_avatar;
}
} elseif ($extension == 4) {
$ini = JFile::read(JPATH_ADMINISTRATOR . '/components/com_juser/config.ini');
$juserparams = new JParameter($ini);
$avatar_save_path = $juserparams->get('general::avatars_dir');
if (file_exists(JPATH_ROOT . DS . $avatar_save_path . DS . $user->get('username') . '.jpg')) {
$avatar = JURI::root() . str_replace('\\', '/', $avatar_save_path) . '/' . $user->get('username') . '.jpg';
} else {
$avatar = JURI::root() . '/components/com_juser/images/default_avatar.png';
}
} elseif ($extension == 5) {
require_once JPATH_BASE . DS . 'components/com_kunena/class.kunena.php';
$kunena_user = KunenaFactory::getUser($user->get('id'));
$username = $kunena_user->getName();
$avatar = $kunena_user->getAvatarURL();
}
return $avatar;
}
/**
* Used by converters importing bridged forums
*
* @TODO store this value in the db in the future instead of HTML5 localStorage
*
* @return string|boolean
*/
public function getPath()
{
//Get the path from the request if it exists
if (KRequest::has('post.path')) {
return KRequest::get('post.path', 'admin::com.ninja.filter.path');
}
//Get the path from RokBridge, if RokBridge is present
$helper = JPATH_ADMINISTRATOR . '/components/com_rokbridge/helper.php';
if (JFile::exists($helper)) {
JLoader::register('RokBridgeHelper', $helper);
if (!method_exists('RokBridgeHelper', 'getParams')) {
return false;
}
return RokBridgeHelper::getParams()->get('phpbb3_path');
}
return false;
}
<?php
/**
* @version $Id: mod_rokbridge_login.php 2047 2007-10-02 00:42:56Z rhuk $
* @package RokBridge - phpBB3 edition
* @copyright Copyright (C) 2009 RocketTheme. All rights reserved.
* @license http://www.gnu.org/copyleft/gpl.html GNU/GPL, see LICENSE.php
* @author RocketTheme, LLC
*/
// no direct access
defined('_JEXEC') or die('Restricted access');
//initiate rokbridge helper
require_once JPATH_ADMINISTRATOR . DS . 'components' . DS . 'com_rokbridge' . DS . 'helper.php';
$rokbridge = new RokBridgeHelper();
// Include the syndicate functions only once
require_once dirname(__FILE__) . DS . 'helper.php';
// database parameters
$params->def('greeting', 1);
// end
if ($params->get('show_default_avatar', 1) == 1) {
$default_avatar = JURI::root(true) . '/' . $params->get('default_avatar', 'modules/mod_rokbridge_login/assets/default-avatar.png');
} else {
$default_avatar = '';
}
// helper
$helper = new ModRokBridgeLoginHelper($rokbridge);
$type = $helper->getType();
$return = $helper->getReturnURL($params, $type);
$fuser = $helper->getUser();
$pms = $helper->getPMs();
$lastvisit = $helper->getLastVisit();
