jeep Posted June 7, 2006 Share Posted June 7, 2006 Hi,I wonder if anyone could help me with this:I am setting up an intranet site with mambo open source.I also use an calendar component (ExtCalendar) wich has a module that shows the 'latest events' (LatestEventsModule).But,.. i would like to make some changes to how the program works.By default you can set how many upcoming events you want to show on the frontpage. What I would like is that is shows only stuff for today.I think it should be in this part:$calendarquery = "SELECT e.*,cat,cat_name from #__extcal_events AS e LEFT JOIN #__extcal_categories AS c ON e.cat=c.cat_idWHERE ( ( ( UNIX_TIMESTAMP(e.end_date) >= UNIX_TIMESTAMP('".$EXTCAL_CONFIG['now']."') ) OR ( UNIX_TIMESTAMP(e.start_date) >= UNIX_TIMESTAMP('".$EXTCAL_CONFIG['now']."') ) )OR ( e.end_date = '0000-00-00 00:00:01' ) )AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY e.start_date,e.title ASCLIMIT " . $EXTCAL_CONFIG['number_of_events_to_list_upcoming'];\0\0but i can't figure it out, anyone that could give me a tip? thnx! Quote Link to comment https://forums.phpfreaks.com/topic/11397-help-needed-with-a-mambo-module/ Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.