CiviCRM Community Forums (archive)

Greetings,

The upcoming events block that I have placed in the side column on a Drupal site is so long that it goes well beyond page content for most pages. I found two ways to truncate this block, which I will share, but I am looking for a long term solution that will survive employee turn-over or civicrm upgrades.

1) Editing .tpl file method:
templates/CRM/Block/Event.tpl
My additions in bold:

<div id="crm-event-block">
{foreach from=$eventBlock item=ev name=uevents}
   {if $smarty.foreach.uevents.item lt 10}
    <p>
    <a href="{$ev.url}">{$ev.title}</a><br />
    {$ev.start_date|truncate:10:""|crmDate}<br />
    {assign var=evSummary value=$ev.summary|truncate:80:""}
    <em>{$evSummary}{if $ev.summary|count_characters:true GT 80}  (<a href="{$ev.url}">{ts}more{/ts}...</a>){/if}</em>
    </p>
   {/if}
{/foreach}
</div>

2) Truncating SQL query method:
CRM/Event/BAO/Event.php
Edit made at line 666  

 ...WHERE civicrm_event.is_active = 1
      AND civicrm_event.is_public = 1
      AND civicrm_event.start_date >= {$condition}";
    
        if(isset( $eventId )) {
            $query .= " AND civicrm_event.id =$eventId ";
      }
        $query .=" ORDER BY   civicrm_event.start_date ASC limit 10";


Both of these methods worked for me, and the second uses less processing, but how can I give the site content creators the ability to edit the number of events listed. There doesn't seem to be any administration menu / controls to do this.

Thanks in advance

Thanks Junglecoder... this solved an issue I had been beating my head against the wall for months. Not sure why the upcomming events does not use the Views Interface (or have some sort of configuration setting on the Civi Admin Side of things)

I actually got the smarty method to work like this.

Line 31
        {foreach from=$eventBlock item=ev name=foo}
         {if $smarty.foreach.foo.iteration < 6}  *** input the limiting number here

Add
             {else break}
             {/if}
after </p> - which would now be at line 39

I didn't want to make a change to the query because I also wanted to be able to have a listing via HTML for all events and changing the query affected this as well.  Thanks for pointing me in the right direction!