Mark, I actually bought that module, but I am going to return it because I didn’t realize you need to modify EE core files to use it and I’m not a fan of doing that. 😊
Sue, I could use that, but it’s not as intuitive for the site editors and I would have to deal with how/when the entries would appear which can get sticky too.
In the end, the query module works great. Here is my revised code if anyone else is trying to accomplish this!
Let me know if you see anything that needs work! 😊
{exp:query limit="5" sql="SELECT exp_channel_data.entry_id, exp_channel_data.field_id_1 AS event_date_time, exp_channel_data.field_id_4 AS event_pastors, exp_channel_data.field_id_5 AS event_telephone, exp_channel_data.field_id_6 AS event_address, exp_channel_data.field_id_22 as event_website, exp_channel_titles.title FROM exp_channel_data INNER JOIN exp_channel_titles ON (exp_channel_data.entry_id = exp_channel_titles.entry_id) WHERE exp_channel_data.field_id_1 > {current_time format='%U'} AND exp_channel_data.site_id = 1 AND exp_channel_data.channel_id = 1 ORDER BY exp_channel_data.field_id_1 ASC"}
<div class="round popped">
<h2>{title}</h2>
<p> <br />
{!-- Event Date/Time --}<br />
{if event_date_time}<br />
<div class="event_month">{event_date_time format="%F %j, %Y"}</div><br />
<strong>Date:</strong> {event_date_time format="%l, %F %j, %Y"}</p>
<p> <strong>Time:</strong> {event_date_time format="%g:%i %A"}</p>
<p> {/if}<br />
<br />
{!-- Event Pastors --}<br />
{if event_pastors}<br />
<strong>Pastor(s):</strong> {event_pastors}</p>
<p> {/if}<br />
<br />
{!-- Event Telephone --}<br />
{if event_telephone}<br />
<strong>Telephone:</strong> {event_telephone}</p>
<p> {/if}<br />
<br />
{!-- Event Address --}<br />
{if event_address}<br />
<strong>Address:</strong> {event_address}</p>
<p> {/if}<br />
<br />
{!-- Event Website --}<br />
{if event_website}<br />
<strong>Website:</strong> <a href="http://{event_website}">{event_website}</a><br />
{/if}<br />
<br />
</div> {!-- end of round popped --}<br />
<br />
{!-- No Events Found --}<br />
{if no_results}<br />
<div class="round popped"><br />
</p><h2>Oops!</h2>
<p> No upcoming events were found. Please check back soon!<br />
</div><br />
{/if}<br />
<br />
{!-- Pagination --}<br />
{paginate}<br />
{if previous_page}<br />
<a href="http://{auto_path}">Previous</a> <br />
{/if}<br />
{if next_page}<br />
<a href="http://{auto_path}">More</a><br />
{/if}<br />
{/paginate}<br />
<br />
{/exp:query}