Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 General Discussions

Reply
 
Thread Tools Display Modes
  #1  
Old 03-25-2010, 11:51 AM
jarosciak jarosciak is offline
 
Join Date: Apr 2005
Location: Toronto
Posts: 90
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default How do I sort vbulletin posts by post id?

I need to sort vbulletin posts by database postid column, not by a dateline?

I am sure there is no option to do this in vbulletin settings, so I am looking to find where this can be changed in the script.

Don't be afraid to help me. Thanks
Reply With Quote
  #2  
Old 03-25-2010, 01:11 PM
Marco van Herwaarden Marco van Herwaarden is offline
 
Join Date: Jul 2004
Posts: 25,415
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

What is the difference?
Reply With Quote
  #3  
Old 03-25-2010, 01:22 PM
jarosciak jarosciak is offline
 
Join Date: Apr 2005
Location: Toronto
Posts: 90
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I want posts displayed in the thread (any thread), sorted by postid.
Reason for this is, that I have an RSS import situation, where many posts are posted at exactly the same time, while postid is always increasing.
Reply With Quote
  #4  
Old 03-25-2010, 01:35 PM
Lynne's Avatar
Lynne Lynne is offline
 
Join Date: Sep 2004
Location: California/Idaho
Posts: 41,180
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Since you are talking about the order of posts in the showthread page, did you happen to look at the showthread.php page for the $posts query? That's where it should be.
Reply With Quote
  #5  
Old 03-25-2010, 01:48 PM
jarosciak jarosciak is offline
 
Join Date: Apr 2005
Location: Toronto
Posts: 90
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I don't know much about vbulletin and programming used there, but in showthread.php, I've found many referenced to ORDER BY post.dateline $postorder.
Can you point me to a correct one to get my posts sorted by postid?
Reply With Quote
  #6  
Old 03-25-2010, 04:23 PM
Lynne's Avatar
Lynne Lynne is offline
 
Join Date: Sep 2004
Location: California/Idaho
Posts: 41,180
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

It sounds like you want to ORDER BY post.postid instead of post.dateline.
Reply With Quote
  #7  
Old 03-25-2010, 04:33 PM
jarosciak jarosciak is offline
 
Join Date: Apr 2005
Location: Toronto
Posts: 90
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Hi and thanks for your help. At this point I know it should be post.postid, what I asked for is something else:
I've found many referenced to ORDER BY post.dateline $postorder.
Can you point me to a correct one to get my posts sorted by postid?
Reply With Quote
  #8  
Old 03-26-2010, 11:24 AM
Marco van Herwaarden Marco van Herwaarden is offline
 
Join Date: Jul 2004
Posts: 25,415
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I still don't get it. What RSS feed post many post in hte same thread with all the same timestamp? I can not really think of a situation that would behave like that.
Reply With Quote
  #9  
Old 03-26-2010, 11:35 AM
jarosciak jarosciak is offline
 
Join Date: Apr 2005
Location: Toronto
Posts: 90
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Example:

If you try to sync some RSS feed (any) to your forum at lets say 10 AM, you'll find, that every post synced to your forum at that time, will be posted at exactly the time of RSS sync (10 AM).

It's not taking date and time from each element inside RSS feed, which is how it should work in the first place.

Anyways, just an update: I've changed all instances of 'ORDER BY post.dateline' to 'ORDER BY post.postid' in showthread.php and my posts are finally sorting as they should.

Btw. it is important to mention, that I am running RSS to post mod
Reply With Quote
  #10  
Old 03-26-2010, 12:43 PM
Speysider's Avatar
Speysider Speysider is offline
 
Join Date: Apr 2009
Posts: 1,029
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by jarosciak View Post
Btw. it is important to mention, that I am running RSS to post mod
What version of vB do you use? AFAIK, newer versions of the vB3 series include an RSS Feed Manager which does what your hack does.
Reply With Quote
Reply

Thread Tools
Display Modes

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 05:32 AM.


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.05482 seconds
  • Memory Usage 2,236KB
  • 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_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (1)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_postinfo_query
  • fetch_postinfo
  • 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