showmessage('do_success', "space.php?do=friend&view=blacklist&start={$_GET['start']}", 0);
}
} elseif ($op == 'rand') {
$randuids = array();
if ($space['friendnum'] < 5) {
//附近在线的朋友
$onlinelist = array();
$query = $_SGLOBAL['db']->query("SELECT uid FROM " . tname('session') . " LIMIT 0,100");
while ($value = $_SGLOBAL['db']->fetch_array($query)) {
if ($value['uid'] != $space['uid']) {
$onlinelist[] = $value['uid'];
}
}
$randuids = sarray_rand(array_merge($onlinelist, $space['friends']), 1);
} else {
$randuids = sarray_rand($space['friends'], 1);
}
showmessage('do_success', "space.php?uid=" . array_pop($randuids), 0);
} elseif ($op == 'getcfriend') {
$fuids = empty($_GET['fuid']) ? array() : explode(',', $_GET['fuid']);
$newfuids = array();
foreach ($fuids as $value) {
$value = intval($value);
if ($value) {
$newfuids[$value] = $value;
}
}
//共同的好友
$list = array();
if ($newfuids) {
$query = $_SGLOBAL['db']->query("SELECT uid,username,name,namestatus FROM " . tname('space') . " WHERE uid IN (" . simplode($newfuids) . ") LIMIT 0,15");
}
//在线用户
$onlinelist = array();
$query = $_SGLOBAL['db']->query("SELECT s.*, sf.note FROM ".tname('session')." s
LEFT JOIN ".tname('spacefield')." sf ON sf.uid=s.uid
ORDER BY s.lastactivity DESC LIMIT 0,12");
while ($value = $_SGLOBAL['db']->fetch_array($query)) {
if(!$value['magichidden']) {
$value['note'] = shtmlspecialchars(strip_tags($value['note']));
realname_set($value['uid'], $value['username']);
$onlinelist[$value['uid']] = $value;
}
}
if(empty($star) && $onlinelist) {
$star = sarray_rand($onlinelist, 1);
foreach ($star as $key => $value) {
$query = $_SGLOBAL['db']->query("SELECT * FROM ".tname('space')." WHERE uid='$value[uid]'");
if ($subvalue = $_SGLOBAL['db']->fetch_array($query)) {
$star[$key] = array_merge($subvalue, $star[$key]);
}
}
}
//在线人数
$olcount = getcount('session', array());
//应用
$myappcount = 0;
$myapplist = array();
showmessage('do_success', "home.php?mod=space&uid={$_G['uid']}&do=friend&view=blacklist&quickforward=1&start={$_GET['start']}");
}
} elseif ($op == 'rand') {
$userlist = $randuids = array();
space_merge($space, 'count');
if ($space['friends'] < 5) {
$query = DB::query("SELECT uid FROM " . DB::table('common_session') . " LIMIT 0,100");
} else {
$query = DB::query("SELECT fuid as uid FROM " . DB::table('home_friend') . " WHERE uid='{$_G['uid']}'");
}
while ($value = DB::fetch($query)) {
if ($value['uid'] != $space['uid']) {
$userlist[] = $value['uid'];
}
}
$randuids = sarray_rand($userlist, 1);
showmessage('do_success', "home.php?mod=space&quickforward=1&uid=" . array_pop($randuids));
} elseif ($op == 'getcfriend') {
$fuid = empty($_GET['fuid']) ? 0 : intval($_GET['fuid']);
$list = array();
if ($fuid) {
$friend = $friendlist = array();
$query = DB::query("SELECT * FROM " . DB::table('home_friend') . " WHERE uid='{$space['uid']}' OR uid='{$fuid}'");
while ($value = DB::fetch($query)) {
$friendlist[$value['uid']][] = $value['fuid'];
$friend[$value['fuid']] = $value;
}
if ($friendlist[$_G['uid']] && $friendlist[$fuid]) {
$cfriend = array_intersect($friendlist[$_G['uid']], $friendlist[$fuid]);
$i = 0;
foreach ($cfriend as $key => $uid) {
// group groups ҳ
$list = $starlist = $modlist = $memberlist = $checklist = array();
if ($mtag['allowview']) {
$query = $_SGLOBAL['db']->query("SELECT main.* FROM " . tname('thread') . " main \r\n\t\t\t\tWHERE main.tagid='{$tagid}' \r\n\t\t\t\tORDER BY main.displayorder DESC, main.lastpost DESC \r\n\t\t\t\tLIMIT 0,50");
while ($value = $_SGLOBAL['db']->fetch_array($query)) {
realname_set($value['uid'], $value['username']);
realname_set($value['lastauthorid'], $value['lastauthor']);
$list[] = $value;
}
//ǻԱ
$query = $_SGLOBAL['db']->query("SELECT * FROM " . tname('tagspace') . " WHERE tagid='{$tagid}' AND grade='1'");
while ($value = $_SGLOBAL['db']->fetch_array($query)) {
realname_set($value['uid'], $value['username']);
$starlist[] = $value;
}
$starlist = sarray_rand($starlist, 12);
//ѡ
//Ա
$query = $_SGLOBAL['db']->query("SELECT * FROM " . tname('tagspace') . " WHERE tagid='{$tagid}' AND grade='0' LIMIT 0,12");
while ($value = $_SGLOBAL['db']->fetch_array($query)) {
realname_set($value['uid'], $value['username']);
$memberlist[] = $value;
}
}
// group
$query = $_SGLOBAL['db']->query("SELECT * FROM " . tname('tagspace') . " WHERE tagid='{$tagid}' AND grade>'7' ORDER BY grade DESC LIMIT 0,12");
while ($value = $_SGLOBAL['db']->fetch_array($query)) {
realname_set($value['uid'], $value['username']);
$modlist[] = $value;
}
// group
