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-22-2012, 06:48 AM
itisjust4fun itisjust4fun is offline
 
Join Date: Apr 2011
Posts: 3
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default Problem: View All Threads by this user

Hi there I wanted to ask a question, I'm having problem with viewing all the threads a user has posted, when I click on the said link in the user profile it takes me to the threads page but it shows only 20 pages and its the same for all the posters for example I've a user with 7000 post but this process also opens only 20 pages and post per page are 25.

So does anyone know how I can change it to show all the threads from 1 to 7000. Is it possible ???

P.S: I'm running vb 3.8.7 patch level 2

Thanks
Reply With Quote
  #2  
Old 05-22-2012, 07:30 AM
Simon Lloyd's Avatar
Simon Lloyd Simon Lloyd is offline
 
Join Date: Aug 2008
Location: Manchester
Posts: 3,481
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Maybe the post table is corrupt or needs optimising, for the user who you know has 7000 posts, go to admincp>maintainance>execute query and run this (but change it to suit, i.e vb_post your post table may not have a prefix so it would just be post)
SELECT *
FROM vb_post
WHERE username LIKE 'The 7000 post username'

If it returns all 7000 (and it will take a while) then the table is good and it's something else

--------------- Added [DATE]1337676524[/DATE] at [TIME]1337676524[/TIME] ---------------

actually that may be too intensive so use this same way
SELECT username, count(*) AS postCount
FROM vb_post
GROUP BY username
HAVING
postCount BETWEEN 6000 AND 10000

Just change vb_post if your tables don't have a prefix, this will give you a table of usernames with post count
Reply With Quote
  #3  
Old 05-22-2012, 01:21 PM
kh99 kh99 is offline
 
Join Date: Aug 2009
Location: Maine
Posts: 13,185
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

In the settings in the adminCP, under "Message Searching Options", there's "Maximum Search Results to Return". You won't get more than that many posts no matter how many the user has. You could increase it, but searching take a lot of server resources, so if you allowed unlimited search results it might cause problems.

ETA: if you wanted to allow more just for yourself or a specific usergroup, you could probably create a plugin using hook search_before_process and reset $vbulletin->options['maxresults'].
Reply With Quote
  #4  
Old 05-24-2012, 07:10 AM
itisjust4fun itisjust4fun is offline
 
Join Date: Apr 2011
Posts: 3
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

thanks you two you have been very helpful I just wanted to know if I was missing something. I'll try both of your ideas first one is good for testing; I know sql so queries are no problems but the second one looks more efficient but can you tell me how to make a hook or some tutorial maybe because I haven't done that before
Reply With Quote
  #5  
Old 05-25-2012, 09:28 AM
itisjust4fun itisjust4fun is offline
 
Join Date: Apr 2011
Posts: 3
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

well thanks anyways I figured out how to make that hook but thanks for pointing me in the right direction
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 10:06 AM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.04505 seconds
  • Memory Usage 2,192KB
  • 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)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (5)post_thanks_box
  • (5)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (5)post_thanks_postbit_info
  • (5)postbit
  • (5)postbit_onlinestatus
  • (5)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
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete