protected function _content() { global $dbtable_prefix; global $page_last_modified_time; switch ($this->config['mode']) { case 'new': $query = "SELECT a.`fk_user_id`,UNIX_TIMESTAMP(a.`last_changed`) as `last_changed` FROM `{$dbtable_prefix}user_profiles` a WHERE a.`_photo`<>'' AND a.`del`=0 AND a.`status`=" . STAT_APPROVED . " ORDER BY a.`date_added` DESC"; break; case 'vote': $query = "SELECT a.`fk_user_id`,UNIX_TIMESTAMP(b.`last_changed`) as `last_changed` FROM `{$dbtable_prefix}user_stats` a,`{$dbtable_prefix}user_profiles` b WHERE a.`fk_user_id`=b.`fk_user_id` AND a.`stat`='vote_score' AND b.`_photo`<>'' AND b.`status`=" . STAT_APPROVED . " AND b.`del`=0 ORDER BY a.`value` DESC"; break; case 'views': $query = "SELECT a.`fk_user_id`,UNIX_TIMESTAMP(b.`last_changed`) as `last_changed` FROM `{$dbtable_prefix}user_stats` a,`{$dbtable_prefix}user_profiles` b WHERE a.`fk_user_id`=b.`fk_user_id` AND a.`stat`='total_views' AND b.`_photo`<>'' AND b.`status`=" . STAT_APPROVED . " AND b.`del`=0 ORDER BY a.`value` DESC"; break; case 'comm': $query = "SELECT a.`fk_user_id`,UNIX_TIMESTAMP(b.`last_changed`) as `last_changed` FROM `{$dbtable_prefix}user_stats` a,`{$dbtable_prefix}user_profiles` b WHERE a.`fk_user_id`=b.`fk_user_id` AND a.`stat`='total_comments' AND b.`_photo`<>'' AND b.`status`=" . STAT_APPROVED . " AND b.`del`=0 ORDER BY a.`value` DESC"; break; } $query .= " LIMIT 15"; if (!($res = @mysql_query($query))) { trigger_error(mysql_error(), E_USER_ERROR); } $user_ids = array(); while ($rsrow = mysql_fetch_assoc($res)) { $user_ids[] = $rsrow['fk_user_id']; if ($page_last_modified_time < $rsrow['last_changed']) { $page_last_modified_time = $rsrow['last_changed']; } } if (!empty($user_ids)) { require_once _BASEPATH_ . '/includes/classes/user_cache.class.php'; $user_cache = new user_cache(); $loop = $user_cache->get_cache_tpl($user_ids, 'result_user'); unset($user_cache); if (!empty($loop)) { $loop[0]['class'] = 'first'; $loop = array_slice($loop, 0, $this->config['total']); $this->tpl->set_file('widget.content', 'widgets/members/display.html'); $this->tpl->set_loop('loop', $loop); $this->tpl->process('widget.content', 'widget.content', TPL_LOOP | TPL_OPTLOOP); $this->tpl->drop_loop('loop'); unset($loop); } } }
++$j; } } else { // not allowed to view this member info // maybe we should say something here like "upgrade your membership to view this info"... $tpl->set_var('temp', $pcat); $temp = $tpl->process('', 'no_access'); $categs[$j]['content'] = $temp; ++$j; } } $categs[count($categs) - 1]['class'] = 'last'; // get some friends $loop_friends = get_network_members($output['uid'], NET_FRIENDS, 4); if (!empty($loop_friends)) { $loop_friends = $user_cache->get_cache_tpl($loop_friends, 'result_user'); } unset($user_cache); // comments $loop_comments = create_comments_loop('user', $output['uid'], $output); $output['pic_width'] = get_site_option('pic_width', 'core_photo'); $tplvars['title'] = sprintf($GLOBALS['_lang'][152], $output['user']); $tplvars['page_title'] = $output['user']; } else { $topass['message']['type'] = MESSAGE_ERROR; $topass['message']['text'] = $GLOBALS['_lang'][7]; redirect2page('info.php', $topass); } $output['lang_273'] = sanitize_and_format($GLOBALS['_lang'][273], TYPE_STRING, $__field2format[TEXT_DB2DISPLAY]); $output['lang_274'] = sanitize_and_format($GLOBALS['_lang'][274], TYPE_STRING, $__field2format[TEXT_DB2DISPLAY]); $output['lang_256'] = sanitize_and_format($GLOBALS['_lang'][256], TYPE_STRING, $__field2format[TEXT_DB2DISPLAY]);
require _BASEPATH_ . '/skins_site/' . get_my_skin() . '/lang/net.inc.php'; check_login_member('manage_networks'); $tpl = new phemplate(_BASEPATH_ . '/skins_site/' . get_my_skin() . '/', 'remove_nonjs'); require _BASEPATH_ . '/includes/classes/user_cache.class.php'; $user_cache = new user_cache(get_my_skin()); $query = "SELECT `net_id`,`network` FROM `{$dbtable_prefix}networks`"; if (!($res = @mysql_query($query))) { trigger_error(mysql_error(), E_USER_ERROR); } $networks = array(); $i = 0; while ($rsrow = mysql_fetch_assoc($res)) { $rsrow['network'] = sanitize_and_format($rsrow['network'], TYPE_STRING, $__field2format[TEXT_DB2DISPLAY]); $net_members = get_network_members($_SESSION[_LICENSE_KEY_]['user']['user_id'], $rsrow['net_id'], 4); if (!empty($net_members)) { $rsrow['members'] = $user_cache->get_cache_tpl($net_members, 'result_user'); } if (!empty($rsrow['members'])) { $rsrow['see_all'] = true; $networks[] = $rsrow; } } $output = array(); $output['user_id'] = $_SESSION[_LICENSE_KEY_]['user']['user_id']; $tpl->set_file('content', 'my_networks.html'); $tpl->set_var('output', $output); $tpl->set_loop('networks', $networks); $tpl->process('content', 'content', TPL_MULTILOOP | TPL_OPTLOOP | TPL_NOLOOP); $tpl->drop_loop('networks'); unset($networks); $tplvars['title'] = $GLOBALS['_lang'][240];