change listing order to > expiration date

[canariasdata +]

This question may be related to a resolved thread: renewed listing showing first....

Hello again,

comming back to a "resolved" question I asked a few years ago...

Again I have the problem that renewed listings not show first but stay in their position (ordered by creation date)

Now my question in regard to the last answer:
Where do I change the order of the listings so that they show ordered by expiration date instead of creation date.

Thanks,
Gregor

[Lhotch +]

Originally Posted by canariasdata

Now my question in regard to the last answer:
Where do I change the order of the listings so that they show ordered by expiration date instead of creation date.

Thanks,
Gregor

I believe I answered that right above Erics reply.......

/includes/classes/kernal/Listings.php

[canariasdata +]

Hello Larry,

thanks again!
Obviously, I wasn't reading the old post deaply enough to see the relation between your path and my question, thank you!

Could you plese confirm that the code in question is the following starting line 248 in Listings.php (V.4.0.3):

	//Sort by
		$sortfield = mysql_real_escape_string(@$_REQUEST['sortfield']);
		$sortorder = mysql_real_escape_string(@$_REQUEST['sortorder']);
		if ($sortfield == '')
		{
			if( !empty($_COOKIE['sortlistings']['sortfield'])) {
				$sortfield=$_COOKIE['sortlistings']['sortfield'];
			} elseif( !empty($options['sortfield']) ) {
				$sortfield=$options['sortfield'];
			} else {
				$sortfield = 'dateadded';
			}
		}
		else
		{
			setcookie("sortlistings[sortfield]", $sortfield, time() + 604800, '/');
		}
		if ($sortorder == '')
		{
			if( !empty($_COOKIE['sortlistings']['sortorder'])) {
				$sortorder=$_COOKIE['sortlistings']['sortorder'];
			} else if( !empty($options['sortorder']) ) {
				$sortorder=$options['sortorder'];
			} else {
				$sortorder = 'desc';
			}
		}
		else

which needs to be changed to:

}
 else {
				$sortfield = 'expiration';
			}

thanks again,
Gregor