Details
-
Type: Patch
-
Status: Done/Fixed
-
Priority: Minor
-
Resolution: Won't Fix
-
Affects Version/s: 2.2.8
-
Fix Version/s: None
-
Component/s: None
-
Labels:None
Description
I am using the "Upcoming Events" module for Joomla that was produced by the Google Summer of Code project. I found and fixed the following issue when I configure it to show all public events: It shows public events that occured in the past. I changed to queries to check that start_date is equal to or after today's date. I changed the file File: /modules/mod_civievent/helper.php , lines 69 -> 80
$query = 'SELECT title,id,start_date,end_date' .
' FROM civicrm_event'.' where is_online_registration = "1" AND start_date >= CURDATE()'.$privacy.$sort ;
echo "1.1";
}
else
{
$privacy = str_replace("AND", "WHERE", $privacy);
$query = 'SELECT title,id' .
' FROM civicrm_event'
// where is_online_registration = "0"'
.$privacy. ' AND start_date >= CURDATE() ' .$sort ;
How can my fix get put into a new version of the component? Also, why aren't the new GSOC Joomla extensions listed on the CiviCRM download page?
Also, the choices for event type are restricted to "Conference, Exhibition, Fundraiser, Meeting, Performance, or Workshop." I can see these are hardcoded in the file: /modules/mod_civievent/mod_civievent.xml:
<param name="tid" type="list" default="10" label="Display" description="Select Contribution Type">
<option value="1">Conference</option>
<option value="1">Exhibition</option>
<option value="3">Fundraiser</option>
<option value="4">Meeting</option>
<option value="5">Performance</option>
<option value="6">Workshop</option>
</param>
How can this be fixed to list all valid event types?
Thanks,
Sarah