startdate >= \''.$date.'\' or enddate >= \''.$date.'\' or `lastrepeat` >= \''.$date.'\'
(startdate >= \''.$date.'\' or enddate >= \''.$date.'\' or `lastrepeat` >= \''.$date.'\')
$eventsSQL = 'SELECT *, E.id as eid, E.category as catID, E.repeat, C.name as category, (SELECT DATEDIFF(E.enddate, E.startdate)) as DurationDays, (SELECT TIMEDIFF(E.endtime, E.starttime)) as DurationTime
FROM '.$modx->getFullTableName($this->tables['events']).' as E
LEFT JOIN '.$modx->getFullTableName($this->tables['categories']).' as C ON E.category = C.id
WHERE (startdate >= \''.$date.'\' or enddate >= \''.$date.'\' or `lastrepeat` >= \''.$date.'\') and E.active=1
and C.active=1 '.($CatId ? ' and C.id IN ('.$CatId.') ' : '').'
ORDER BY startdate LIMIT '.$n;
☆ A M B ☆
That is pretty cool Susan!
Speaking of setting start dates and end dates... http://www.filamentgroup.com/examples/slider_v2/index3.php
☆ A M B ☆
☆ A M B ☆
Quote from: sottwell at Jul 17, 2010, 07:50 AMThat is pretty cool Susan!
Speaking of setting start dates and end dates... http://www.filamentgroup.com/examples/slider_v2/index3.php
I am also wondering how and end user can add events.
Do they have to be a manager and run the module?
Can I set up a link or way for the client to just add/edit events?
Thanks
BG66
☆ A M B ☆
charless,
WOW, what a great module! This is just what I was looking for. It’s great to have Events and a Calendar all in one!
Here are a few things I found: Using version 0.0.6-rc3
1) Typos in Configuration settings page
Cateogory List Options -> Category List Options
Enanble Cateogry Filters -> Enable Category Filters
2) Is there a way to not shown the categories in the List view? I have five categories and it takes up a lot of space in my sidebar
3) When entering a Start date, can the End date change to the start date automatically?
What happens is that the End date stays set to the current date. If the user does not change the end date I have seen the event span over a few days.
Thanks!
BG66
&mxcDefaultCatIdLock=`true`
&mxcDefaultCatIdLock=`true`
☆ A M B ☆
Can this work with Revolution 2.0?? Please??
I think many people would really like Revo 2.0 compatibility much sooner than any new features, excluding bug fixes.
Thank you, Tom