Events sequence from last to first

How do I change the events sequence on the home page?  The sequence on the EVENTS page is fine.  On the home page, the sequence is going from last event to first. (see photo).  I want it to be first event to last event.

BTW, when clicking on the "FIRST" tab, it still stays on the last event.

Quote · 16 Apr 2010

BTW, I'VE TRIED THE FOLLOWING, AND IT DID NOT WORK FOR ME:

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

Quote · 16 Apr 2010
 
 
Below is the legacy version of the Boonex site, maintained for Dolphin.Pro 7.x support.
The new Dolphin solution is powered by UNA Community Management System.