How to change EVENTS listings

On our EVENTS section, when we add an events it lists in decending order (end of the year at top).  It should be assending order (beginning of year at top).   Anyone know how to change these settings?

if you get an answer..im listening..Been wondering about that myself

Events ASCending code changes

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

Stuart038, I owe you a beer!  Thank You so much.  Worked perfect!

Now that I got my Events page in the proper order, does anyone know how to change to ascending order of events on the "Member" pages.  The member pages still are in the wrong order.