if ($actmid) { $where .= " AND dv.actmid=" . S::sqlEscape($actmid); $pageUrl .= 'actmid=' . $actmid . '&'; } if (!empty($timerange)) { if ('+' == $timerange[0]) { $timerange = (int) $timerange; if ($timerange > 0) { $startTimeBeforeTimestamp = $timestamp + $timerange; $where .= " AND (dv.starttime <= " . S::sqlEscape($startTimeBeforeTimestamp) . "AND dv.starttime >" . S::sqlEscape($timestamp) . "OR (dv.endtime <=" . S::sqlEscape($startTimeBeforeTimestamp) . "And dv.endtime >" . S::sqlEscape($timestamp) . " ))"; $pageUrl .= 'timerange=%2B' . $timerange . '&'; } } } $timeSelectHtml = $postActForO->getTimeSelectHtml($timerange, 1, ''); $actmidSelectHtml = $postActForO->getActmidSelectHtml($actmid, 1, ''); if (empty($a)) { //我的活动 $authoridTidDb = $myTidDb = $allActivityIdsIHaveParticipated = array(); $fids = trim(getSpecialFid() . ",'0'", ','); $query = $db->query("SELECT tid FROM pw_threads WHERE authorid=" . S::sqlEscape($winduid) . " AND special=8 AND fid not IN({$fids})"); while ($rt = $db->fetch_array($query)) { $authoridTidDb[] = $rt['tid']; //我发布的 } $allActivityIdsIHaveParticipated = $postActForO->getAllParticipatedActivityIdsByUid($winduid); //我参与的 $myTidDb = array_merge($authoridTidDb, $allActivityIdsIHaveParticipated); empty($myTidDb) && ($myTidDb = array(-1)); is_array($myTidDb) && $myTidDb && ($where .= " AND dv.tid IN (" . S::sqlImplode($myTidDb) . ")"); } elseif ($a == 'recommended') {