$sql = "SELECT p.* FROM pw_wappushtype p WHERE p.id is not NULL ORDER BY p.sort DESC";
$query = $db->query($sql);
while ($rt = $db->fetch_array($query)) {
empty($typename[$rt['id']]) && adminmsg('分类名称不能为空');
if (isset($typename[$rt['id']])) {
if ($rt['state'] != $states[$rt['id']] || $rt['sort'] != $order[$rt['id']] || $rt['typename'] != $typename[$rt['id']]) {
$insertdb[] = array('id' => $rt['id'], 'sort' => (int) $order[$rt['id']], 'typename' => $typename[$rt['id']], 'state' => $states[$rt['id']]);
}
}
}
!empty($insertdb) && $db->update("REPLACE INTO pw_wappushtype (`id`,`sort`,`typename`,`state`) VALUES" . pwSqlMulti($insertdb));
adminmsg('operate_success');
} else {
InitGP(array('page'), 'GP');
$count = $db->get_value("SELECT COUNT(*) FROM pw_wappushtype p WHERE p.id is not NULL");
list($pages, $limit) = pwLimitPages($count, $page, "{$basename}&");
$pushTypes = array();
$sql = "SELECT p.* FROM pw_wappushtype p WHERE p.id is not NULL ORDER BY p.sort ASC {$limit}";
$query = $db->query($sql);
while ($rt = $db->fetch_array($query)) {
$pushTypes[] = $rt;
}
}
}
function pwLimitPages($count, $page, $pageurl)
{
global $db_perpage, $db_maxpage;
//require_once (R_P.'require/forum.php');
$numofpage = ceil($count / $db_perpage);
$numofpage = $numofpage > $db_maxpage ? $db_maxpage : $numofpage;
$page < 1 ? $page = 1 : ($page > $numofpage ? $page = $numofpage : null);
$isGM = S::inArray($windid, $manager);
!$isGM && $groupid == 3 && ($isGM = 1);
if (!$isGM && $winduid != $space['uid']) {
$userdb = $db->get_one("SELECT index_privacy FROM pw_ouserdata WHERE uid=" . S::sqlEscape($uid));
list($isU, $privacy) = pwUserPrivacy($uid, $userdb);
if (!$privacy['index']) {
Showmsg('mode_o_index_right');
}
}
$group = array();
$count = $db->get_value("SELECT COUNT(DISTINCT c.id) AS count FROM pw_cmembers cm LEFT JOIN pw_colonys c ON cm.colonyid=c.id WHERE cm.uid=" . S::sqlEscape($uid) . " AND cm.ifadmin<>'-1'");
if ($count) {
$db_perpage = 4;
$page = (int) S::getGP('page');
$pageurl = 'apps.php?q=groups&uid=' . $uid . "&";
list($pages, $limit) = pwLimitPages($count, $page, "{$pageurl}");
$query = $db->query("SELECT DISTINCT c.* FROM pw_cmembers cm LEFT JOIN pw_colonys c ON cm.colonyid=c.id WHERE cm.uid=" . S::sqlEscape($uid) . " AND cm.ifadmin <> '-1' ORDER BY cm.colonyid DESC {$limit}");
while ($rt = $db->fetch_array($query)) {
if ($rt['cnimg']) {
list($rt['cnimg']) = geturl("cn_img/{$rt['cnimg']}", 'lf');
} else {
$rt['cnimg'] = $GLOBALS['imgpath'] . '/g/groupnopic.gif';
}
$rt['colonyNums'] = PwColony::calculateCredit($rt);
//$rt['addtime'] = get_date($rt['addtime'], 'Y-m-d');
$rt['createtime'] = get_date($rt['createtime'], 'Y-m-d');
$group[] = $rt;
}
}
require_once PrintEot('m_space_groups');
pwOutPut();
}
require_once PrintEot('thread_galbum');
footer();
} elseif ($a == 'selphoto') {
if (!$ifadmin && (!$colony['ifcyer'] || $colony['ifadmin'] == '-1')) {
Showmsg('colony_cnmenber');
}
S::gp(array('aid', 'selaid', 'page'));
$tmpUrlAdd .= '&aid=' . $aid . '&a=selphoto&selaid=' . $selaid;
$album = $db->get_one("SELECT aname,ownerid,photonum FROM pw_cnalbum WHERE atype='0' AND aid=" . S::sqlEscape($aid));
if (empty($album) || $album['ownerid'] != $winduid) {
Showmsg('data_error');
}
if (empty($_POST['step'])) {
$db_perpage = 10;
list($pages, $limit) = pwLimitPages($album['photonum'], $page, "{$basename}&a=selphoto&aid={$aid}&selaid={$selaid}&");
$options = '';
$query = $db->query("SELECT aid,aname,memopen FROM pw_cnalbum WHERE atype='1' AND ownerid=" . S::sqlEscape($cyid) . ' ORDER BY aid DESC');
while ($rt = $db->fetch_array($query)) {
if ($ifadmin || $rt['memopen'] == 1) {
$memopen = 1;
} else {
$memopen = 0;
}
if ($memopen == 1) {
$options .= "<option value=\"{$rt['aid']}\"" . ($rt['aid'] == $selaid ? ' selected' : '') . ">{$rt['aname']}</option>";
}
}
$cnpho = array();
$query = $db->query("SELECT pid,path,ifthumb FROM pw_cnphoto WHERE aid=" . S::sqlEscape($aid) . " ORDER BY pid {$limit}");
while ($rt = $db->fetch_array($query)) {
$u = $winduid;
}
InitGP(array('posttime'));
if (is_numeric($posttime) && $posttime) {
if ($posttime != '366') {
$where .= " AND postdate>=" . pwEscape($timestamp - $posttime * 84600);
} elseif ($posttime == '366') {
$where .= " AND postdate<=" . pwEscape($timestamp - 365 * 84600);
}
}
}
}
if ($where) {
$count = $db->get_value("SELECT count(*) as count FROM pw_threads WHERE {$where} AND fid != 0");
if ($count) {
list($pages, $limit) = pwLimitPages($count, $page, $thisbase);
$rs = $db->query("SELECT tid,fid,author,authorid,subject,postdate,lastpost,replies,hits,titlefont,anonymous,modelid,special FROM pw_threads {$force} WHERE {$where} AND fid != 0 ORDER BY {$ordertype} DESC {$limit}");
while ($rt = $db->fetch_array($rs)) {
$rt['subject'] = substrs($rt['subject'], 45);
$rt['forum'] = strip_tags($forum[$rt['fid']]['name']);
$rt['postdate'] = get_date($rt['postdate'], 'Y-m-d');
$rt['pcid'] = $rt['special'] > 20 ? $rt['special'] - 20 : 0;
if (!$isGM && $rt['anonymous']) {
$rt['author'] = $rt['authorid'] = '';
}
$article[] = $rt;
}
}
}
if ($space == 1 && defined('F_M')) {
require_once R_P . 'require/credit.php';
$count = $friend['f_num'];
$addurl = 'u=' . $u . '&';
list($pages, $limit) = pwLimitPages($count, $page, "{$thisbase}{$addurl}");
} else {
InitGP('ftid', '', 2);
if (isset($_GET['ftid'])) {
$ftype = (int) GetGP('ftid');
}
$username = $windid;
$query = $db->query("SELECT * FROM pw_friendtype WHERE uid=" . pwEscape($winduid) . " ORDER BY ftid");
$friendtype = array();
while ($rt = $db->fetch_array($query)) {
$friendtype[$rt['ftid']] = $rt;
}
$count = $winddb['f_num'];
list($pages, $limit) = pwLimitPages($count, $page, "{$thisbase}");
}
$friends = getFriends($u, $start, $db_perpage, $ftype, 1);
if ($friends) {
foreach ($friends as $key => $value) {
$value['isfriend'] = isFriend($winduid, $value['uid']);
$friends[$key] = $value;
}
}
}
require_once M_P . 'require/header.php';
if ($space == 1) {
require_once R_P . 'require/credit.php';
list($userdb, $ismyfriend, $friendcheck, $usericon, $usercredit, $totalcredit, $appcount, $p_list) = getAppleftinfo($u);
require_once PrintEot('user_friend');
} else {
!$isGM && $groupid == 3 && ($isGM = 1);
$userdb = $db->get_one("SELECT m.username,o.index_privacy FROM pw_members m LEFT JOIN pw_ouserdata o ON m.uid=o.uid WHERE m.uid=" . pwEscape($u));
list($isU, $privacy) = pwUserPrivacy($u, $userdb);
if ($groupid == 3 || $isU == 2 || $isU != 2 && $privacy['index']) {
$SpaceShow = 1;
}
if (!$SpaceShow) {
Showmsg('mode_o_index_right');
}
if ($u != $winduid) {
$username = $userdb['username'];
} else {
$username = $windid;
}
$count = $db->get_value("SELECT COUNT(*) AS count FROM pw_oboard WHERE touid=" . pwEscape($u));
list($pages, $limit) = pwLimitPages($count, $page, $basename . "q=board&u=" . $u . "&");
$boards = array();
require_once R_P . 'require/bbscode.php';
$wordsfb = L::loadClass('FilterUtil');
$query = $db->query("SELECT o.*,m.icon as face FROM pw_oboard o LEFT JOIN pw_members m ON o.uid=m.uid WHERE o.touid=" . pwEscape($u) . " ORDER BY o.id DESC {$limit}");
while ($rt = $db->fetch_array($query)) {
$rt['postdate'] = get_date($rt['postdate']);
list($rt['face']) = showfacedesign($rt['face'], 1, 'm');
if ($rt['groupid'] == 6 && $db_shield && $groupid != 3) {
$rt['title'] = appShield('ban_feed');
} elseif (!$wordsfb->equal($rt['ifwordsfb'])) {
$rt['title'] = $wordsfb->convert($rt['title'], array('id' => $rt['id'], 'type' => 'comments', 'code' => $rt['ifwordsfb']));
}
if (strpos($rt['title'], '[s:') !== false) {
$rt['title'] = showface($rt['title']);
}
*/
// require_once(M_P.'require/header.php');
// require_once PrintEot('m_groups');
// footer();
list($isheader, $isfooter, $tplname, $isleft) = array(true, true, "m_groups", true);
} elseif ($a == 'friend') {
S::gp(array('page', 'cid'), null, 2);
$friends = getFriends($winduid);
unset($friends[$winduid]);
$friends = is_array($friends) ? array_keys($friends) : array();
$group = array();
$pages = '';
$total = 0;
if (count($friends)) {
$total = $db->get_value("SELECT COUNT(DISTINCT c.id) AS count FROM pw_cmembers cm LEFT JOIN pw_colonys c ON cm.colonyid=c.id WHERE cm.uid IN(" . S::sqlImplode($friends) . ") AND cm.ifadmin <> '-1'");
list($pages, $limit) = pwLimitPages($total, $page, "{$basename}a=friend&");
$friends[] = $winduid;
$query = $db->query("SELECT c.id,c.cname,c.cnimg,c.admin,SUM(cm.uid='{$winduid}') AS ifadd FROM pw_cmembers cm LEFT JOIN pw_colonys c ON cm.colonyid=c.id WHERE cm.uid IN(" . S::sqlImplode($friends) . ") AND cm.ifadmin<>'-1' GROUP BY cm.colonyid HAVING(SUM(cm.uid!='{$winduid}') > 0) ORDER BY cm.colonyid DESC {$limit}");
while ($rt = $db->fetch_array($query)) {
if ($rt['cnimg']) {
list($rt['cnimg']) = geturl("cn_img/{$rt['cnimg']}", 'lf');
} else {
$rt['cnimg'] = $GLOBALS['imgpath'] . '/g/groupnopic.gif';
}
$rt['friends'] = array();
$group[$rt['id']] = $rt;
}
if ($group) {
$query = $db->query("SELECT uid,username,colonyid FROM pw_cmembers WHERE uid IN (" . S::sqlImplode($friends) . ') AND colonyid IN(' . S::sqlImplode(array_keys($group)) . ") AND ifadmin<>'-1'");
while ($rt = $db->fetch_array($query)) {
$num = $group[$rt['colonyid']]['ifadd'] ? 2 : 3;
$query = $db->query("SELECT d.* FROM pw_diarytype d {$sqladd} ORDER BY dtid");
while ($rt = $db->fetch_array($query)) {
$diarytype[$rt['dtid']] = $rt;
}
if ($friends = getFriends($winduid)) {
$sqladd = 'WHERE d.privacy!=2';
$uids = array_keys($friends);
$uids = array_diff($uids, array($winduid));
$uids && ($sqladd .= ' AND d.uid IN(' . pwImplode($uids) . ')');
}
if ($sqladd) {
require_once R_P . 'require/bbscode.php';
$sum = $db->get_value("SELECT COUNT(*) as count FROM pw_diary d {$sqladd}");
if ($sum) {
$wordsfb = L::loadClass('FilterUtil');
list($pages, $limit) = pwLimitPages($sum, $page, $basename . "q=diary&a={$a}&");
$query = $db->query("SELECT d.did,d.dtid,d.uid,d.aid,d.username,d.privacy,d.subject,d.ifconvert,d.ifwordsfb,d.content,d.r_num,d.c_num,d.postdate,m.groupid,m.icon FROM pw_diary d LEFT JOIN pw_members m ON d.uid=m.uid {$sqladd} ORDER BY d.postdate DESC {$limit}");
while ($rt = $db->fetch_array($query)) {
if ($rt['groupid'] == 6 && $db_shield && $groupid != 3) {
$rt['subject'] = '';
$rt['content'] = appShield('ban_diary');
} elseif (!$wordsfb->equal($rt['ifwordsfb'])) {
$rt['content'] = $wordsfb->convert($rt['content'], array('id' => $rt['did'], 'type' => 'diary', 'code' => $rt['ifwordsfb']));
}
$rt['postdate'] = get_date($rt['postdate'], 'Y-m-d H:i');
$rt['content'] = preg_replace("/\\[s:(.+?)\\]/eis", '', $rt['content']);
if ($rt['ifconvert'] == 2) {
$rt['content'] = convert($rt['content'], $db_windpost);
} else {
strpos($rt['content'], '[s:') !== false && ($rt['content'] = showface($rt['content']));
}
updateMemberid($winduid);
addLog($creditlog, $windid, $winduid, 'groups_Uploadphoto');
}
if ($creditlog = unserialize($o_groups_creditlog)) {
addLog($creditlog['Post'], $windid, $winduid, 'groups_Uploadphoto');
}
refreshto("{$basename}a=view&cyid={$cyid}&pid={$pid}", 'operate_success');
}
} elseif ($a == 'selalbum') {
if (!$ifadmin && (!$colony['ifcyer'] || $colony['ifadmin'] == '-1')) {
Showmsg('colony_cnmenber');
}
InitGP(array('page', 'selaid'), null, 2);
$db_perpage = 10;
$total = $db->get_value("SELECT COUNT(*) FROM pw_cnalbum WHERE atype='0' AND ownerid=" . pwEscape($winduid));
list($pages, $limit) = pwLimitPages($total, $page, "{$basename}&a={$a}&");
$album = array();
$query = $db->query("SELECT aid,aname,photonum,lastphoto FROM pw_cnalbum WHERE atype='0' AND ownerid=" . pwEscape($winduid) . " ORDER BY aid DESC {$limit}");
while ($rt = $db->fetch_array($query)) {
$rt['sub_aname'] = substrs($rt['aname'], 18);
$rt['lastphoto'] = getphotourl($rt['lastphoto']);
$album[] = $rt;
}
$url_extra = $selaid ? "&selaid={$selaid}" : '';
list($isheader, $isfooter, $tplname, $isleft) = array(true, true, "m_galbum", true);
} elseif ($a == 'selphoto') {
if (!$ifadmin && (!$colony['ifcyer'] || $colony['ifadmin'] == '-1')) {
Showmsg('colony_cnmenber');
}
InitGP(array('aid', 'selaid'));
$album = $db->get_one("SELECT aname,ownerid,photonum FROM pw_cnalbum WHERE atype='0' AND aid=" . pwEscape($aid));
require_once R_P . 'require/header.php';
list($guidename, $forumtitle) = $pwforum->getTitle();
$msg_guide = $pwforum->headguide($guidename);
$styleid = $colony['styleid'];
$basename = "thread.php?cyid={$cyid}&showtype=write";
if (!$colony['ifwriteopen'] && !$ifadmin && (!$colony['ifcyer'] || $colony['ifadmin'] == '-1')) {
Showmsg('colony_cnmenber');
}
list($faceurl) = showfacedesign($winddb['icon'], 1, 'm');
$writedata = $typeid = array();
if ($count2 = $colony['writenum']) {
$smileParser = L::loadClass('smileparser', 'smile');
/* @var $smileParser PW_SmileParser */
require_once R_P . 'require/showimg.php';
$page = (int) S::getGP('page');
list($pages, $limit) = pwLimitPages($count2, $page, "{$basename}&showtype=write&cyid={$cyid}&");
$query = $db->query("SELECT w.*,m.username,m.icon,m.groupid FROM pw_cwritedata w LEFT JOIN pw_members m ON w.uid=m.uid WHERE w.cyid=" . S::sqlEscape($cyid) . " ORDER BY w.replay_time DESC {$limit}");
while ($rt = $db->fetch_array($query)) {
if ($rt['groupid'] == 6 && $db_shield && $groupid != 3) {
$rt['content'] = appShield('ban_write');
}
$rt['content'] = $smileParser->parse($rt['content']);
list($rt['postdate']) = getLastDate($rt['postdate']);
list($rt['icon']) = showfacedesign($rt['icon'], 1, 'm');
$writedata[$rt['id']] = $rt;
$typeid[] = $rt['id'];
}
}
if ($typeid) {
$sql = "SELECT tt.* FROM (SELECT cm.*,m.icon FROM pw_comment cm LEFT JOIN pw_members m ON cm.uid=m.uid WHERE type='groupwrite' AND typeid in (" . S::sqlImplode($typeid, false) . ") ORDER BY cm.id DESC) tt GROUP BY tt.typeid ";
$query2 = $db->query($sql);
}
if ($keyword) {
$sqlsel .= ' AND c.cname LIKE ' . S::sqlEscape("%" . $keyword . "%");
}
if ($friends) {
$isFriends = $friends;
$friends = getFriends($winduid);
unset($friends[$winduid]);
$uids = $friends ? array_keys($friends) : array(0);
$sqltab .= ' LEFT JOIN pw_cmembers cm ON c.id=cm.colonyid';
$sqlsel .= ' AND cm.uid IN(' . S::sqlImplode($uids) . ')';
}
$total = $db->get_value("SELECT COUNT(DISTINCT c.id) AS sum FROM pw_colonys c {$sqltab} WHERE 1 {$sqlsel}");
if ($total) {
require_once R_P . 'require/bbscode.php';
list($pages, $limit) = pwLimitPages($total, $page, "group.php?q=all" . ($members ? "&members={$members}" : '') . ($isFriends ? "&friends={$isFriends}" : '') . "&keyword=" . rawurlencode($keyword) . "&" . ($styleid ? "styleid=" . $styleid : "") . "&");
$query = $db->query("SELECT DISTINCT c.* FROM pw_colonys c {$sqltab} WHERE 1 {$sqlsel} ORDER BY c.id DESC {$limit}");
while ($rt = $db->fetch_array($query)) {
if ($rt['cnimg']) {
list($rt['cnimg']) = geturl("cn_img/{$rt['cnimg']}", 'lf');
} else {
$rt['cnimg'] = $GLOBALS['imgpath'] . '/g/groupnopic.gif';
}
$rt['cname'] = str_replace($keyword, '<font color="#FF0000">' . $keyword . '</font>', $rt['cname']);
$rt['descrip'] = str_replace($keyword, '<font color="#FF0000">' . $keyword . '</font>', stripWindCode($rt['descrip']));
$rt['colonyNums'] = PwColony::calculateCredit($rt);
$rt['createtime'] = get_date($rt['createtime'], 'Y-m-d');
$group[$rt['id']] = $rt;
}
}
$colonyids = S::sqlImplode(array_keys($group));
}
$sum = $db->get_value("SELECT count(*) as sum FROM pw_share s WHERE {$where}");
if ($a == 'my') {
$favor = $db->get_one("SELECT tids,type FROM pw_favors WHERE uid=" . pwEscape($u));
list(, $favor_num) = getfavor($favor['tids']);
$sum += (int) $favor_num;
}
if ($type && in_array($type, array('web', 'user', 'photo', 'album', 'group', 'video', 'music', 'flash', 'diary', 'topic'))) {
$where .= $where == '' ? 's.type=' . pwEscape($type) : ' AND s.type=' . pwEscape($type);
}
$shares = array();
$count = $db->get_value("SELECT count(*) as count FROM pw_share s WHERE {$where}");
if ($count) {
$page = (int) GetGP('page');
$db_perpage = 10;
list($pages, $limit) = pwLimitPages($count, $page, "{$basename}a={$a}&type={$type}&");
if (!$db_dopen) {
$where .= " AND s.type!='diary'";
}
if (!$db_phopen) {
$where .= " AND s.type!='photo'";
}
if (!$db_groups_open) {
$where .= " AND s.type!='group'";
}
$rs = $db->query("SELECT s.*,m.groupid,m.icon FROM pw_share s LEFT JOIN pw_members m ON s.uid=m.uid WHERE {$where} ORDER BY s.id DESC {$limit}");
while ($rt = $db->fetch_array($rs)) {
list($rt['postdate'], $rt['posttime']) = getLastDate($rt['postdate']);
$temp = unserialize($rt['content']);
if ($temp['video']) {
$rt['host'] = $temp['video']['host'];
if (!$newSpace->viewRight('messageboard')) {
Showmsg('该空间留言板设置隐私，您没有权限查看!');
}
//需要重构
$uid = isset($uid) ? $uid : $winduid;
$basename = 'u.php?a=board&uid=' . $uid . '&';
//$spaceurl = $basename."u=$u&";
require_once R_P . 'require/showimg.php';
if ($uid != $winduid) {
$username = $userdb['username'];
} else {
$username = $windid;
}
$db_perpage = 10;
$count = $db->get_value("SELECT COUNT(*) AS count FROM pw_oboard WHERE touid=" . S::sqlEscape($uid));
list($pages, $limit) = pwLimitPages($count, $page, $basename);
$boards = array();
require_once R_P . 'require/bbscode.php';
$wordsfb = L::loadClass('FilterUtil', 'filter');
$query = $db->query("SELECT o.*,m.icon as face FROM pw_oboard o LEFT JOIN pw_members m ON o.uid=m.uid WHERE o.touid=" . S::sqlEscape($uid) . " ORDER BY o.id DESC {$limit}");
while ($rt = $db->fetch_array($query)) {
$rt['postdate'] = get_date($rt['postdate']);
list($rt['face']) = showfacedesign($rt['face'], 1, 'm');
if ($rt['groupid'] == 6 && $db_shield && $groupid != 3) {
$rt['title'] = appShield('ban_feed');
} elseif (!$wordsfb->equal($rt['ifwordsfb'])) {
$rt['title'] = $wordsfb->convert($rt['title'], array('id' => $rt['id'], 'type' => 'comments', 'code' => $rt['ifwordsfb']));
}
if (strpos($rt['title'], '[s:') !== false) {
$tpc_author = $rt['username'];
$rt['title'] = showface($rt['title']);
} elseif ($group == 2) {
$sqlsel = " AND cm.ifadmin='0'";
} elseif ($group == 3) {
$sqlsel = " AND cm.ifadmin='-1'";
}
$total = $db->get_value("SELECT COUNT(*) AS sum FROM pw_cmembers cm WHERE cm.colonyid=" . S::sqlEscape($cyid) . $sqlsel);
if ($total) {
if (in_array($orderby, array('lastpost', 'lastvisit'))) {
$order = $orderby;
$urladd = $orderby ? "orderby={$orderby}&" : '';
${'order_' . $orderby} = ' class="current"';
} else {
$order = 'ifadmin';
$urladd = '';
}
list($pages, $limit) = pwLimitPages($total, $page, "{$basename}a=member&cyid={$cyid}&group={$group}&{$urladd}");
$memdb = array();
$query = $db->query("SELECT cm.*,m.icon,m.honor,md.thisvisit FROM pw_cmembers cm LEFT JOIN pw_members m ON cm.uid=m.uid LEFT JOIN pw_memberdata md ON m.uid=md.uid WHERE cm.colonyid=" . S::sqlEscape($cyid) . $sqlsel . " ORDER BY cm.{$order} DESC {$limit}");
while ($rt = $db->fetch_array($query)) {
list($rt['icon']) = showfacedesign($rt['icon'], 1, 'm');
$memdb[$rt['username']] = $rt;
}
$colonyOwner = $memdb[$colony['admin']];
unset($memdb[$colony['admin']]);
$colonyOwner && array_unshift($memdb, $colonyOwner);
}
}
$urladd = $group ? '&group=' . $group : '';
list($isheader, $isfooter, $tplname, $isleft) = array(false, true, "m_group", true);
} else {
!$ifadmin && Showmsg('undefined_action');
} elseif ($group == 2) {
$sqlsel = " AND cm.ifadmin='0'";
} elseif ($group == 3) {
$sqlsel = " AND cm.ifadmin='-1'";
}
$total = $db->get_value("SELECT COUNT(*) AS sum FROM pw_cmembers cm WHERE cm.colonyid=" . S::sqlEscape($cyid) . $sqlsel);
if ($total) {
if (in_array($orderby, array('lastpost', 'lastvisit'))) {
$order = $orderby;
$urladd = $orderby ? "orderby={$orderby}&" : '';
${'order_' . $orderby} = ' class="current"';
} else {
$order = 'ifadmin';
$urladd = '';
}
list($pages, $limit) = pwLimitPages($total, $page, "{$basename}&group={$group}&{$urladd}");
$memdb = array();
$query = $db->query("SELECT cm.*,m.icon,m.honor,md.thisvisit FROM pw_cmembers cm LEFT JOIN pw_members m ON cm.uid=m.uid LEFT JOIN pw_memberdata md ON m.uid=md.uid WHERE cm.colonyid=" . S::sqlEscape($cyid) . $sqlsel . " ORDER BY cm.{$order} DESC {$limit}");
while ($rt = $db->fetch_array($query)) {
list($rt['icon']) = showfacedesign($rt['icon'], 1);
$memdb[$rt['username']] = $rt;
}
$colonyOwner = $memdb[$colony['admin']];
unset($memdb[$colony['admin']]);
$colonyOwner && array_unshift($memdb, $colonyOwner);
}
}
$urladd = $group ? '&group=' . $group : '';
require_once PrintEot('thread_member');
footer();
} else {
is_array($actpidDB) && $actpidDB && ($where .= " AND log.actpid IN (" . S::sqlImplode($actpidDB) . ")");
if ($feeslogstatus) {
$where .= " AND status = " . S::sqlEscape($feeslogstatus);
$pageUrl .= 'feeslogstatus=' . $feeslogstatus . '&';
}
if ($activityname) {
$where .= " AND subject LIKE " . S::sqlEscape('%' . $activityname . '%');
$pageUrl .= 'activityname=' . $activityname . '&';
}
if ($otherpartyname) {
$where .= " AND (log.username LIKE " . S::sqlEscape('%' . $otherpartyname . '%') . " OR author LIKE " . S::sqlEscape('%' . $otherpartyname . '%') . " OR log.fromusername LIKE " . S::sqlEscape('%' . $otherpartyname . '%') . ") AND '" . $otherpartyname . "'!='" . $windid . "'";
$pageUrl .= 'otherpartyname=' . $otherpartyname . '&';
}
$count = $db->get_value("SELECT count(*) AS count FROM pw_activitypaylog log {$where}");
if ($count) {
list($pages, $limit) = pwLimitPages($count, $page, $pageUrl);
$query = $db->query("SELECT log.*, m.ifpay AS ifpay, log.fromuid AS fromuid, \n\t\t\t\t\t\t\tlog.fromusername AS fromusername, log.username AS username, log.uid AS uid,m.issubstitute AS issubstitute\n\t\t\t\t\t\t\tFROM pw_activitypaylog log\n\t\t\t\t\t\t\tLEFT JOIN pw_activitymembers m ON log.actuid=m.actuid \n\t\t\t\t\t\t\t{$where} ORDER BY tid DESC, actpid DESC {$limit}");
$feesLog = array();
while ($rt = $db->fetch_array($query)) {
$rt['subject'] = substrs($rt['subject'], 20);
$rt['createtime'] = $postActForO->getTimeFromTimestamp($rt['createtime'], 'minute');
$rt['statusText'] = $postActForO->getFeesLogStatus($rt['status']);
//获得支付说明，收入或支出，对方
$postActForO->getPayLogDescription($rt);
$rt['costtype'] = $postActForO->getFeesLogCostType($rt['costtype']);
$actpid = $rt['actpid'];
$tid = $rt['tid'];
$feesLog[$tid][$actpid] = $rt;
}
}
}
if ($album['groupid'] == 6 && $db_shield && $groupid != 3) {
$album['lastphoto'] = $pwModeImg . '/banuser.gif';
$album['aintro'] = appShield('ban_album_aintro');
}
if ($album['ownerid'] != $winduid && $album['private'] == 1 && !isFriend($album['ownerid'], $winduid) && $groupid != 3) {
Showmsg('mode_o_photos_private_1');
}
if ($album['ownerid'] != $winduid && $album['private'] == 2 && $groupid != 3) {
Showmsg('mode_o_photos_private_2');
}
$viewpwd && ($viewpwd = md5($viewpwd));
if ($album['ownerid'] != $winduid && $album['private'] == 3 && $viewpwd != $album['albumpwd'] && $groupid != 3) {
Showmsg('mode_o_photos_private_3');
}
if ($album['photonum']) {
list($pages, $limit) = pwLimitPages($album['photonum'], $page, "{$basename}a={$a}&aid={$aid}&");
$query = $db->query("SELECT c.pid,c.path,c.ifthumb,c.uptime,m.groupid,c.pintro,c.c_num FROM pw_cnphoto c LEFT JOIN pw_members m ON c.uploader=m.username WHERE c.aid=" . pwEscape($aid) . " ORDER BY c.pid {$limit}");
while ($rt = $db->fetch_array($query)) {
$rt['path'] = getphotourl($rt['path'], $rt['ifthumb']);
if ($rt['groupid'] == 6 && $db_shield && $groupid != 3) {
$rt['path'] = $pwModeImg . '/banuser.gif';
}
$rt['sub_pintro'] = substrs($rt['pintro'], 25);
$rt['uptime'] = get_date($rt['uptime']);
$cnpho[] = $rt;
}
}
$u = $album['ownerid'];
$username = $album['owner'];
} elseif ($a == 'view') {
InitGP(array('pid'));
}
}
list($isheader, $isfooter, $tplname, $isleft) = array(false, true, "m_galbum", true);
} elseif ($a == 'selphoto') {
if (!$ifadmin && (!$colony['ifcyer'] || $colony['ifadmin'] == '-1')) {
Showmsg('colony_cnmenber');
}
S::gp(array('aid', 'selaid', 'page'));
$tmpActionUrl .= '&aid=' . $aid . '&a=selphoto&selaid=' . $selaid;
$album = $db->get_one("SELECT aname,ownerid,photonum FROM pw_cnalbum WHERE atype='0' AND aid=" . S::sqlEscape($aid));
if (empty($album) || $album['ownerid'] != $winduid) {
Showmsg('data_error');
}
if (empty($_POST['step'])) {
$db_perpage = 10;
list($pages, $limit) = pwLimitPages($album['photonum'], $page, "apps.php?q=galbum&a=selphoto&cyid={$cyid}&aid={$aid}&selaid={$selaid}&");
$options = '';
$query = $db->query("SELECT aid,aname,memopen FROM pw_cnalbum WHERE atype='1' AND ownerid=" . S::sqlEscape($cyid) . ' ORDER BY aid DESC');
while ($rt = $db->fetch_array($query)) {
if ($ifadmin || $rt['memopen'] == 1) {
$memopen = 1;
} else {
$memopen = 0;
}
if ($memopen == 1) {
$options .= "<option value=\"{$rt['aid']}\"" . ($rt['aid'] == $selaid ? ' selected' : '') . ">{$rt['aname']}</option>";
}
}
$cnpho = array();
$query = $db->query("SELECT pid,path,ifthumb FROM pw_cnphoto WHERE aid=" . S::sqlEscape($aid) . " ORDER BY pid {$limit}");
while ($rt = $db->fetch_array($query)) {
