Problem: View All Threads by this user

[itisjust4fun]

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

[Simon Lloyd]

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

[kh99]

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'].

[itisjust4fun]

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

[itisjust4fun]

well thanks anyways I figured out how to make that hook but thanks for pointing me in the right direction