예제 #1
0
파일: my.php 프로젝트: jechiy/PHPWind
 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') {