Search by Date + Range

[Intex]

Is there a hack out there that allows you to specify a date range to search for threads / posts?

[Intex]

Anybody ?

[Intex]

I don't have much knowledge of PHP or SQL, but can anybody shed any light on this? From each forum its possible to view the last posts by xxx days, so all I'm after is something that just searches all forums.

I'd really appreciate any help with this and I'm sure others would fine it useful.

[jksgvb]

I'm very interested in this feature also. Member why-not posted this excellent hack for vB 3.0 here:

https://vborg.vbsupport.ru/showthread.php?t=74830

I tried to apply it to vB 3.6, but there are too many code changes in search.php for a non-web developer to implement. Anybody have this hack running on vB 3.6?

Thanks.

[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

[jksgvb]

Thanks for the url search terms, geartripper. My requirement is that I print all posts over a 1 week period in selected forums, and the searchword always trips me up. That url command requires a searchword doesn't it? (My advanced search function is hacked so that it will allow searches without a searchword or user name.)

Maybe getdaily&days would work, but I don't know all the options of that command. Will getdaily&days display posts, not threads?

[jahshaka]

i have a similar problem here - on a certain date there were over 200 new threads in my forum - compared to the average of 20-30 and i want to pull all those threads and see what they were... is there a way to do this with the search options? i dont see any way to put in a date range...

i tried building a query

http://www.vfxtalk.com/forum/search....by=threadstart

but it wont let me do a search without a query - which i need to d osince i dont know whats in those threads, ie the following wont work...

http://www.vfxtalk.com/forum/search....by=threadstart

any help would be really cool!

[HydraulicJack]

I gotta say I'm *astounded* that this basic search capability of getting ALL posts within a given date range is not built in to vBulletin. WTF???

This has been around in other Forum software since 1995 (e.g. then-O'Reilly WebBoard).

Requiring some keyword to be part of any date-range search automatically reduces the results so you don't get all.

Will SOMEBODY please post a hack for this in vBulletin???

Thanks from this shocked newbie.
HJ

PS: If the hack is a url call, please include an example URL for us non-techies.

Thanks!

[TMS_Hon]

i too need a hack to hav the search by date option ...
has anybdy been able to do it for the 3.5.x versions.
plz reply if nybdy has found out the solution to it..

[TMS_Hon]

hey guys.....i have derived the solution for searching threads/posts by date range..
it requires some changes...the code is under test and will be uploaded in a few days.

:up: