[SirSteve]

Originally posted by kyrnel

I modified the hack to display events for the next two weeks by modifying the SQL query to this:

SELECT eventid, subject, eventdate, public
FROM calendar_events
WHERE (eventdate >= '$today' AND eventdate <= DATE_ADD('$today', INTERVAL 14 DAY)) AND ((userid = '$bbuserinfo[userid]') OR (public = 1))
ORDER BY eventdate

I also modified the hack to display "None" if there are no events found. You just have to add an 'else' clause to the If/Then statement.

How is the "Upcoming Weeks" part pulled in? By the same $todaysevents ?

And where is that If/Then statement to change for "None" ?