Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 General Discussions
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools Display Modes
  #1  
Old 05-24-2003, 08:31 AM
Cyn Cyn is offline
 
Join Date: Apr 2002
Posts: 157
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default Order of posts alphabetically

In forumdisplay.php I have the following code placed to alphabetize the thread titles in one forum.

switch ($sortfield) {
case 'title':
case 'lastpost':
case 'replycount':
case 'views':
case 'postusername':
case 'voteavg':
break;

default:

if($foruminfo[forumid]==163) $sortfield='title';
else $sortfield='lastpost';
}

This is placing the threads in reversed alphabetical order Z - A. How can I change it to place them A-Z? Thanks!
Reply With Quote
  #2  
Old 05-24-2003, 10:41 AM
Xenon's Avatar
Xenon Xenon is offline
 
Join Date: Oct 2001
Location: Bavaria
Posts: 12,878
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

add $sqlsortoder='ASC'; to your if cond
Reply With Quote
  #3  
Old 05-24-2003, 10:53 AM
Cyn Cyn is offline
 
Join Date: Apr 2002
Posts: 157
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Like this?

default:
if($foruminfo[forumid]==163) $sortfield='title'; $sqlsortorder='ASC';
else $sortfield='lastpost';

Edited to add: It worked!! :classic: Thanks!!
Reply With Quote
  #4  
Old 05-24-2003, 11:20 AM
Cyn Cyn is offline
 
Join Date: Apr 2002
Posts: 157
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I spoke too soon.

I placed the same code as another "if" to include another forum, like this:

default:
if($foruminfo[forumid]==163) $sortfield='title' AND $sqlsortorder='ASC';
if($foruminfo[forumid]==164) $sortfield='title' AND $sqlsortorder='ASC';
else $sortfield='lastpost';
}


Problem is it only works for page 1. Page 2 puts them in reverse order.
Reply With Quote
  #5  
Old 05-24-2003, 12:06 PM
Chris M's Avatar
Chris M Chris M is offline
 
Join Date: Dec 2001
Location: Northampton, England
Posts: 6,186
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

If you click here, you will see that it reverses the order when you go back to page one by clicking on the page1 link...

It has something to do with the "pagenumber"

Satan
Reply With Quote
  #6  
Old 05-24-2003, 01:11 PM
Cyn Cyn is offline
 
Join Date: Apr 2002
Posts: 157
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Oh wonderful! :dead:

:classic:
Reply With Quote
  #7  
Old 05-24-2003, 01:29 PM
Cyn Cyn is offline
 
Join Date: Apr 2002
Posts: 157
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I tried this:

default:
if($foruminfo[forumid]==163) $sortfield='title' AND $sqlsortorder='ASC';
if($foruminfo[forumid]==163 AND pagenumber=2) $sortfield='title' AND $sqlsortorder='ASC';
if($foruminfo[forumid]==164) $sortfield='title' AND $sqlsortorder='ASC';

else $sortfield='lastpost';
}

And got this:

Parse error: parse error, unexpected '=' in /usr/www/users/mother1/discussions/forumdisplay.php on line 376
Reply With Quote
  #8  
Old 05-24-2003, 02:40 PM
Cyn Cyn is offline
 
Join Date: Apr 2002
Posts: 157
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

And tried this:

default:
if($foruminfo[forumid]==163) $sortfield='title' AND $sqlsortorder='ASC';
if($foruminfo[forumid]==163 AND $foruminfo[pagenumber]==2) $sortfield='title' AND $sqlsortorder='ASC';


Didn't get a parse error but no desired result either.
Reply With Quote
  #9  
Old 05-24-2003, 05:14 PM
Xenon's Avatar
Xenon Xenon is offline
 
Join Date: Oct 2001
Location: Bavaria
Posts: 12,878
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

your synatx is incorrect, you have to do it like this:

PHP Code:
if($foruminfo[forumid]==163)

  
$sortfield='title';
  
$sqlsortorder='ASC';

Reply With Quote
  #10  
Old 05-24-2003, 09:15 PM
Davey Davey is offline
 
Join Date: Nov 2002
Location: England
Posts: 383
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Isn't this feature already available?
You click on "Thread" at the top of the forum (Click here to arrange all of General Hacking Discussion's threads alphabetically).
It then arranges the threads alphabetically.

Dave.
Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 01:08 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.04302 seconds
  • Memory Usage 2,249KB
  • Queries Executed 13 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)ad_showthread_firstpost
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (1)bbcode_php
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (2)pagenav_pagelink
  • (10)post_thanks_box
  • (10)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (10)post_thanks_postbit_info
  • (10)postbit
  • (10)postbit_onlinestatus
  • (10)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.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/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.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
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • pagenav_page
  • pagenav_complete
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete