Searching for users with a certain number of posts in a period of time?

[lrshelby]

I have a question regarding user searches. I would like to search for users with a certain number of posts within a given period of time.

In my experience, through the Admin CP I can create a list of members using:
Last Post is After
Last Post is Before
and
Posts are greater than (but this is total posts, not number of posts within the designated period of time)

But this doesn't exactly do what I am looking for. I would like to generate a list of users with a certain number of posts within a given period, such as a minimum of 5 posts between January 1, 2007 and February 28, 2007. Is there a way to do this? Am I misunderstanding how to use the search features in the Admin CP and I actually can do this? Or do I need a separate search query of some sort?

Any help would be appreciated.
RS

[lrshelby]

Anyone???

[SCRIPT3R]

You can submit a search to vBulletin with a URL, just like you can with the search form. http://www.yourforums/search.php?do=process&query=searchword , where searchword is the word for which you are searching.

Here is a list of the extra search parameters you can add to the URL. When you add a search parameter to the URL you need to add this to the end of the URL:

&variable_name=value

Search field: Search by Key Word

Variable name: titleonly
Values:

• 0 = Search Entire Posts
• 1 = Search Titles Only

Search field: Search by User Name

Variable name: searchuser
Values: Enter a username

Variable name: starteronly
Values:

• 0 = Find Posts by User
• 1 = Find Threads Started by User

Variable name: exactname
Values:

• 0 = Partial name
• 1 = Exact name

Search field: Find Threads with

Variable name: replyless
Values:

• 0 = At Least
• 1 = At Most

Variable name: replylimit
Values: Any integer values

Search field: Find Posts from

Variable name: searchdate
Values:

• 0 = Any Date
• lastvisit = Your Last Visit
• 1 = Yesterday
• 7 = A Week Ago
• 14 = 2 Weeks Ago
• 30 = A Month Ago
• 90 = 3 Months Ago
• 180 = 6 Months Ago
• 365 = A Year Ago

Variable name: beforeafter
Values:

• after = and Newer
• before = and Older

Search field: Sort Results by

Variable name: sortby
Values:

• rank = Relevancy
• title = Title
• replycount = Number of Replies
• views = Number of Views
• threadstart = Thread Start Date
• lastpost = Last Posting Date
• postusername = User Name
• forum = Forum

Variable name: order
Values:

• descending = in Descending Order
• ascending = in Ascending Order

Search field: Show Results as

Variable name: showposts
Values:

• 0 = Show Results as Threads
• 1 = Show Results as Posts

Search field: Search in Forum(s)

Variable name: forumchoice[]





Values: Do not include this variable in the URL to search all forums. If you want to search specific forums then you need to add an instance for each forumid. For example:

&forumchoice[]=X&forumchoice[]=Y&forumchoice[]=Z

Where X, Y, and Z are the forumids of the forums in which you want to search.

Variable name: childforums
Values:

• 0 = Do not search in child forums
• 1 = Also search in child forums

[lrshelby]

Thank you very much for the information. :up: I will experiment and see what I can come up with. Again, thank you.
RS

Automerged Update 01/30/2007
I guess I don't really understand how to string the URL together. I’m getting nothing but HTTP 404 Not Found errors. I can’t even put together a basic search. Maybe I’m lost in the syntax of it all but also, how does vB check for permissions to do these searches. If you’re just typing the url into the browser how does it know if you are allowed to make that search? I’ve tried numerous different possibilities and got nothing but error messages. Can you give me an example?

Also, can you use the same variable twice? In my case I would be looking to use the beforeafter variable twice. Once to specify the after date and the second time to specify the before date.


Automerged Update 10:14am 01/31/2007
Ok, I'm slowly getting things figured out but I need a bit more help.

The information you gave is great because now I realize that I can put together some "canned" forum searches that my users might like but my original goal was to search for users, not a list of threads or posts. So, instead of...

http://www.yourforums/search.php?do=process

I think I need to use...

http://www.yourforums.com/forums/admincp/user.php?do=find

And I guess the answer to my permissions question is that the permissions issues are handled because the search originates from the admincp.

Now, my question is, what are the variables for user searches? You listed all those variables for forum searches but now I need to know what the variables are for user searches so that I can set them properly and get the user list I am looking for. Do you have a list of the variables that you could post?

[lrshelby]

Now, my question is, what are the variables for user searches? You listed all those variables for forum searches but now I need to know what the variables are for user searches so that I can set them properly and attempt to get the user list I am looking for. Do you or anyone have a list of these variables that you could post? Or can anyone tell me where I could get them?
Thanks.

[SCRIPT3R]

i'm not sure i understand...

Search field: Search by User Name

Variable name: searchuser
Values: Enter a username

Variable name: starteronly
Values:

• 0 = Find Posts by User
• 1 = Find Threads Started by User

Variable name: exactname
Values:

• 0 = Partial name
• 1 = Exact name