how to Sort events in ascending order

inc/classes/BxDolEvents.php

function PageSDatingShowEvents

edit:

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

change DESC to ASC   and even EventStart to ID

the bold is how they are ordered.

Below is one you can try where it displays a week or so ahead/upcoming

there are a also a couple queries  you can use to prune them so if they are over they get deleted from DB

//mrp mod order by event start day nov 08
$sOrderBySQL = " AND (TO_DAYS( NOW( ) ) - TO_DAYS( `EventStart` )) < 1 ORDER BY `EventStart`";
//mrp mod order by event start day nov 08 end

TO MATCH FRONT (events block):

in function GenAnyBlockContent

//mrp modification get events by date
$sOrderS = '';
switch ($sOrder) {
case 'last':
case 'latest':
$sOrderS = "AND (TO_DAYS( NOW( ) ) - TO_DAYS( `EventStart` )) <1 ORDER BY `EventStart`";
break;
case 'rand':
$sOrderS = "AND (TO_DAYS( NOW( ) ) - TO_DAYS( `EventStart` )) <1 ORDER BY `EventStart`";
break;
case 'first':
$sOrderS = "AND (TO_DAYS( NOW( ) ) - TO_DAYS( `EventStart` )) <1 ORDER BY `EventStart`";
break;
//mrp modification get events by date end

Thank you greatly for your response.
I just change the DESC in ASC, and everything is in order ..


Thank you again ..

I added even after they try and 'get change events by date', THANK YOU VERY MUCH ...

You are welcome

MrP,

Can you outline the code for removing the event from DB after event date?

Many thanks, again!!

Stuart

One last question ..
I realize that the output is cleared when it is past .. is this normal should always delete it by hand?

else ..
Is it impossible to make registration impossible once the time of departure arrived, or even one hour prior exit?