This file doesn't work either.
The only difference I can see between 2 files is that you have added "a." to the condition `published` = 1
I'm testing it in a joomla 1.5 with event-booking config hidepastevents=0
For the rest of the forum we are talking about SOLD OUT EVENTS:
The script is one the best I've found (for joomla), very good job. All the scripts can always be improved, but there is something basic for us in order to offer this script to our clients = Joomdonation sell more scripts. In the calendar view the variable "total_registrants" or SUM(number_registrants) has to be present. This is done from /components/com_event-booking/models/calendar.php
In calendar.php there is a query between lines 90-125 which has to get this information.
Independently of the ifs and elses, lets say we have joomla 1.5 and hidepastevents=0, the basic query according the last calendar.php is:
$query = " SELECT a.*, IFNULL(SUM(b.number_registrants), 0) FROM #__eb_events AS a "
." LEFT JOIN #__eb_registrants AS b "
. ' ON (a.id = b.event_id AND (b.published = 1 OR (b.payment_method="os_offline" AND b.published != 2))) '
." WHERE (a.`published` = 1) AND (`event_date` BETWEEN '$startdate' AND '$enddate') AND a.access <= $aid "
." ORDER BY event_date ASC, ordering ASC"
;
We are using LEFT JOIN to get the information from two tables.
Once we have total_registrants, it will be very easy to show it like text, colors, icons, etc to show the clients which event is full and this way they don't have to enter one by one in all the events to see which one they can reserve!!!
Somebody can help please??!!
