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();