Events listing

On the homepage and the events page I would like to have the events shown as per firstcoming event on top, followed by the other events (last event on the bottom).

How to do this ?

Open that file and edit the SQL query to ORDER BY `Date` DESC

Use as per your database. Hope this will help.

Same problem here, Want event sorted on date.

Which query should I change and how exactly do I do this?

By default it is programmed to list the events in the order of starting date.(decending)

I want to sort them ascending. How would I do that?

I wanted to avoid the past events to be shown in the home page and events page, also wanted the nearest event to be shown first than the farthest event as shown in (homepage : www.mallusworld.com ; eventpage : http://mallusworld.com/events/)

This is how i could do it: please note i am using Version Dolphin 6.1.3

1.  Open /inc/classes/BxDolEvents.php file

2.  Goto Line 463 and find the line

$sStatusActiveSQL = "`SDatingEvents`.`Status` = 'Active';

Change it to

$sStatusActiveSQL = "`SDatingEvents`.`Status` = 'Active' AND `SDatingEvents`.`EventStart` > NOW()";

immediately on the next line you could see

$sOrderBySQL = "ORDER BY `SDatingEvents`.`EventStart` DESC";

Change it to

$sOrderBySQL = "ORDER BY `SDatingEvents`.`EventStart` ASC";

3.  Goto line 846 and find the line

AND `SDatingEvents`.`Status` = 'Active'

Change it to

AND `SDatingEvents`.`Status` = 'Active'  AND `SDatingEvents`.`EventStart` > NOW() ORDER BY `EventStart` ASC