Support

October 9, 2012 at 7:15 pm

Hello,

On line 30 of espresso_table.php, right above the $order_by variable, add this:

$days  .= " WHERE ADDDATE('".date ( 'Y-m-d' )."', INTERVAL ".$max_days." DAY) >= e.start_date AND e.start_date >= '".date( 'Y-m-d' )."' ";

Under that is the sql query, which has an if/else statement determining whether we’re looking at a category-specific list or a general list. To get what you want, it should look like this.

if ($type == 'category'){
    $sql = "SELECT e.* FROM " . EVENTS_CATEGORY_TABLE . " c ";
    $sql .= " JOIN " . EVENTS_CATEGORY_REL_TABLE . " r ON r.cat_id = c.id ";
    $sql .= " JOIN " . EVENTS_DETAIL_TABLE . " e ON e.id = r.event_id ";
    $sql .= " JOIN " . EVENTS_START_END_TABLE . " ese ON ese.event_id = e.id ";
    if ( $max_days != "" ) {
        $sql .= $days;
        $sql .= " AND c.category_identifier != '" . $category_identifier . "' ";
    } else {
        $sql .= " WHERE c.category_identifier != '" . $category_identifier . "' ";
    }
    $sql .= " AND e.is_active = 'Y' ";
}else{
    $sql = "SELECT e.*, ese.start_time, ese.end_time FROM " . EVENTS_DETAIL_TABLE . " e ";
    $sql .= "LEFT JOIN " . EVENTS_START_END_TABLE . " ese ON ese.event_id = e.id ";
    if ( $max_days != "" ) {
        $sql .= $days;
        $sql .= " AND e.is_active = 'Y' ";
    } else {
        $sql .= " WHERE e.is_active = 'Y' ";
    }
}

We have tested this previously and it should work. Let us know if you have anymore questions.