vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)
-   -   Reversing Order Of Usernotes? (https://vborg.vbsupport.ru/showthread.php?t=65061)

colicab-d 05-13-2004 11:49 AM
Reversing Order Of Usernotes?
 
This may be a dumb and obvious question, but how would I go about reversing the order of usernotes so that the newest one is listed first?

Ive tried looking at the code in usernotes.php and have managed to get it down to this code which is determining the order...

How woul I change this to reflect what Im trying to do?

PHP Code:
    $notes = $DB_site->query("
        SELECT usernote.*, usernote.username as postusername, user.*, userfield.*,
        IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid,
        IF(posterid=0, 0, user.userid) AS userid
        " . iif($vboptions['avatarenabled'],",avatar.avatarpath,NOT ISNULL(customavatar.avatardata) AS hascustomavatar,customavatar.dateline AS avatardateline") . "
        " . iif($vboptions['reputationenable'], ",level") . "
        FROM " . TABLE_PREFIX . "usernote AS usernote
        LEFT JOIN " . TABLE_PREFIX . "user AS user ON(usernote.posterid=user.userid)
        LEFT JOIN " . TABLE_PREFIX . "userfield AS userfield ON(userfield.userid=user.userid)
        LEFT JOIN " . TABLE_PREFIX . "usergroup AS usergroup ON(user.usergroupid=usergroup.usergroupid)
        " . iif($vboptions['avatarenabled'],"LEFT JOIN " . TABLE_PREFIX . "avatar AS avatar ON(avatar.avatarid=user.avatarid) LEFT JOIN " . TABLE_PREFIX . "customavatar AS customavatar ON(customavatar.userid=user.userid)") .
        iif($vboptions['reputationenable'], " LEFT JOIN " . TABLE_PREFIX . "reputationlevel AS reputationlevel ON(user.reputationlevelid=reputationlevel.reputationlevelid)") . "
        WHERE usernote.userid = $userinfo[userid]
        ORDER BY usernote.dateline LIMIT " . ($limitlower - 1) . ", $perpage
    "); 

Boofo 05-13-2004 12:02 PM
Try changing this:

PHP Code:
ORDER BY usernote.dateline 
to:

PHP Code:
ORDER BY usernote.dateline ASC 

colicab-d 05-13-2004 12:10 PM
will do mate thnx for the speedy reply :)

noonespecial 11-16-2005 04:18 AM
ORDER BY usernote.dateline DESC

will show oldest first.

/works in vb 3.5.1 as well
// imo should be defaulted this way.


All times are GMT. The time now is 03:51 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01071 seconds
  • Memory Usage 1,723KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (3)bbcode_php_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (4)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 
Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 
Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete