End date in calendar

Lean
Topic Author
Offline
New Member

More

13 years 6 months ago - 13 years 6 months ago #11834 by Lean

End date in calendar was created by Lean

Hi there,

A couple of days ago I bought the Event Booking compontent and it's doing about everything that I wanted it to do, so great work! But however there's one thing that should be fixed before I can use it in my clients website. The calendar doesn't take into account the end day of an event. Therefore; when I plan a multi day event, it won't be clear to my visitors that it is more than one day. (In my case; events won't be longer than 2 days, but still it's not very usable)

Can I get this fixed via the adminstrator or should this be taken care off in the source?

A short term solution for me would be that the end date is shown in the upcoming events module. Can you describe the mySQL and php code that I have to change?

Thanks ik advance!

Lean

Last edit: 13 years 6 months ago by Lean.

Please Log in or Create an account to join the conversation.

Tuan Pham Ngoc
Away
Administrator

More

13 years 6 months ago #11850 by Tuan Pham Ngoc

Replied by Tuan Pham Ngoc on topic Re: End date in calendar

Hi Lean

Right now, Event Booking doesn't support Multiple Days events, so we will use the solution as you suggested : Displays Event End Date in the up-coming events module . The steps are :

1. Open the file modules/mod_eb_events/mod_eb_events.php

2. Find the sql command below :

Code:

$sql = 'SELECT a.id, a.title, a.location_id, a.event_date, c.name AS location_name FROM #__eb_events AS a '		 
		 . ' LEFT JOIN #__eb_locations AS c '
		 . ' ON a.location_id = c.id '
		 . ' WHERE '.implode(' AND ', $where)
		 . ' ORDER BY a.event_date '
		 . ' LIMIT '.$numberEvents		
	;	

3. Modify the sql command above to include event end date :

Code:

$sql = 'SELECT a.id, a.title, a.location_id, a.event_date, a.event_end_date, c.name AS location_name FROM #__eb_events AS a '		 
		 . ' LEFT JOIN #__eb_locations AS c '
		 . ' ON a.location_id = c.id '
		 . ' WHERE '.implode(' AND ', $where)
		 . ' ORDER BY a.event_date '
		 . ' LIMIT '.$numberEvents		
	;	

4. Modify file modules/mod_eb_events/tmpl/default.php to display event end date. For example , find the code below :

Code:

<span class="event_date"><?php echo JHTML::_('date', $row->event_date, $config->event_date_format, $format); ?></span>

Change it to :

Code:

<span class="event_date"><?php echo JHTML::_('date', $row->event_date, $config->event_date_format, $format); ?> - 
<?php echo JHTML::_('date', $row->event_end_date, $config->event_date_format, $format); ?>
</span>

Hope this help !

Tuan

Please Log in or Create an account to join the conversation.

Lean
Topic Author
Offline
New Member

More

13 years 6 months ago #11994 by Lean

Replied by Lean on topic Re: End date in calendar

Hi Tuan,

Thanks for your support, works great! Final question; i'm configuring currently the component and module in my testing environment. Is there a possibility to backup the settings and events so that I can easily set up the Event Booking in my live website? I would say that it should be possible by:
1. installing the event booking component and module on my live website
2. making a backup of all the modified php/css files and overwrite them on my live website
3. My problem is: what should I do with the database tables? How should I im- en export this?

Thanks a lot!

Please Log in or Create an account to join the conversation.

Moderators: Tuan Pham Ngoc

Powered by Kunena Forum

End date in calendar

Support

Documentation

Information

Connect Us