- 论坛徽章:
- 0
|
$query = "SELECT
c.*,
t.topic_title,
pt.post_text,
pt.bbcode_uid,
t.topic_views,
t.topic_replies,
f.forum_name,
f.auth_read,
(cal_interval_units = 'DAY' && cal_interval = 1 && '$current_isodate' = INTERVAL (cal_interval * (cal_repeat - 1)) DAY + cal_date) as block_end
FROM
" . MYCALENDAR_TABLE . " as c,
" . TOPICS_TABLE . " as t,
" . FORUMS_TABLE . " as f,
" . POSTS_TEXT_TABLE . " as pt
WHERE
c.forum_id = f.forum_id
AND
c.topic_id = t.topic_id
AND
f.events_forum > 0
AND
pt.post_id = t.topic_first_post_id
AND
'$current_isodate' >= cal_date
里面的: (cal_interval_units = 'DAY' && cal_interval = 1 && '$current_isodate' = INTERVAL (cal_interval * (cal_repeat - 1)) DAY + cal_date) as block_end是什么意思。 |
|