Jump to content

Archived

This topic is now archived and is closed to further replies.

jeep

Help needed with a mambo module

Recommended Posts

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_id
WHERE ( ( ( 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 ASC
LIMIT " . $EXTCAL_CONFIG['number_of_events_to_list_upcoming'];\0\0


but i can't figure it out, anyone that could give me a tip?


thnx!

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.