FUDforum: Bug Reports » Sorting by join date

Home » FUDforum Development » Bug Reports » Sorting by join date

Show: Today's Messages :: Polls :: Message Navigator

Re: Sorting by join date [message #25889 is a reply to message #25826]

Fri, 24 June 2005 07:57

enicholse

Messages: 30
Registered: May 2005

Karma:

Member

Here are my edits. They are not working. The date is ordered displayed as in my original posting.
The column "Join Date" in the finduser.tmpl GUI has been modified to "Last Visit Date" a click takes you to index.php?t=finduser&usr_login=&S=e8c73e310c865aff5a2567c28b69dccd& amp; amp; amp;vd=1&btn_submit=Find
Here, the Last Visit Date wont sort quite right.

notice the vd=1 in the url, this corresponds to the $ord in *finduser.php.t

finduser.php.t
if (isset($_GET['pc'])) {
$ord = 'posted_msg_count DESC';
} else if (isset($_GET['us'])) {
$ord = 'alias';
} else if (isset($_GET['vd'])) {
$ord = 'last_visit';
} else {
$ord = 'id DESC';
}

********and********

$find_user_data = '';
$c = uq('SELECT /*!40000 SQL_CALC_FOUND_ROWS */ home_page, users_opt, al
ias, name, last_visit, join_date, posted_msg_count, id FROM {SQL_TABLE_PREFIX}us
ers WHERE ' . $qry . ' id>1 ORDER BY ' . $ord . ' ' . $lmt);

**message
finduser_joindate: = Last Visit Date
**
*finduser.tmpl
<th nowrap><div align=
"center"><a href="{TEMPLATE: FINDUSER_PAGE_lnk4}" class="thLnk">{MSG: finduser_j
oindate}</a></div></th>

********and********

{SECTION: FINDUSER_PAGE_lnk4}
{ROOT}?t=finduser&usr_login={VAR-URL: usr_login}&{DEF: _rsid}&vd=1&a
mp;btn_submit=Find
{SECTION: END}

*date_formats.tmpl
{SECTION: finduser_join_date}
{DATE: r->join_date %a, %d %B %Y}
{SECTION: END}

Are you saying "$ord = 'last_visit';" should be "$ord = 'last_visit DESC';" would this really make a difference? Yes, it did. Just a little DESC. Thanks for the help! Of these changes, will they make it through the upgrade.php ?

Aloha, Eric

[Updated on: Fri, 24 June 2005 08:07]

Report message to a moderator

[Message index]

		Sorting by join date By: enicholse on Wed, 22 June 2005 23:12
		Re: Sorting by join date By: Ilia on Wed, 22 June 2005 23:33
		Re: Sorting by join date By: enicholse on Wed, 22 June 2005 23:34
		Re: Sorting by join date By: Ilia on Wed, 22 June 2005 23:41
		Re: Sorting by join date By: enicholse on Wed, 22 June 2005 23:54
		Re: Sorting by join date By: enicholse on Thu, 23 June 2005 00:37
		Re: Sorting by join date By: Ilia on Thu, 23 June 2005 13:21
		Re: Sorting by join date By: enicholse on Fri, 24 June 2005 07:57
		Re: Sorting by join date By: enicholse on Fri, 24 June 2005 08:14
		Re: Sorting by join date By: enicholse on Fri, 24 June 2005 08:18
		Re: Sorting by join date By: Ilia on Fri, 24 June 2005 13:19
		Re: Sorting by join date By: enicholse on Fri, 24 June 2005 20:05
		Re: Sorting by join date By: enicholse on Fri, 24 June 2005 20:10
		Re: Sorting by join date By: Ilia on Fri, 24 June 2005 20:20
		Re: Sorting by join date By: enicholse on Sat, 25 June 2005 01:59
		Re: Sorting by join date By: Ilia on Sat, 25 June 2005 02:06

Previous Topic:	Compatcting Database: Fatal disk space error
Next Topic:	Images don't attach right

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Nov 30 20:13:39 GMT 2024

Total time taken to generate the page: 0.03846 seconds