Calendar Advanced Search

[Dylanblitz]

I haven't seen a calendar search hack so I thought I'd make one.

This hack will add search functionality for your calendars.
It will add an option for a quick search in the Search dropdown navbar as well as an option to do advanced searching. You can search based on the text in the title/body of the event, the event author, start/end date of the event and the calendars you have permissions to view.

[Turbe]

That was fast :eek:

I'll check this out.... Thank you for creating this and accepting the request (https://vborg.vbsupport.ru/showthread.php?t=223820)..

Requested Features:
Support for Custom Calendar Fields
Admin Control Panel - feature to specific which Calendar(s) is available in Calendar Search (only the one(s) selected are listed/available in the Search Window).
Admin Control Panel - Usergroup permissions for Calendar Search (separate from Forum Search Permissions) - I actually need Unregistered/Guests to be able to Search the Calendar without any additional verification (i.e. re-CAPTCHA) which is the way you have it now :up: if I change the Unregistered Usergroup Forum Search options to 'YES' - just have a separate Permissions Toggle for the Calendar Search.


:up:

[GoTTi]

wait a second....i never noticed there wasnt search option for the calendar. wow....this just got my MOTM vote! how the hell did vb miss this one the entire time? shows the calendar is just a dead mod for them...thanks for this addon.

[Turbe]

this just got my MOTM vote!

Yes Agreed, I can't believe with all the great talent around here that there hadn't been an attempt for many years/VB Versions... I'm very grateful to Dylanblitz...

GoTTi, do you realize you can have Custom Calendar Fields too? Many don't. :D



how the hell did vb miss this one the entire time? shows the calendar is just a dead mod for them...

http://www.vbulletin.com/forum/showthread.php?p=730678



.

[Turbe]

Installed on 3.7.5, so far so good (except noted below).. more testing needed

I use both IE and Firefox, for some reason (and the first time I've seen this on my site), I get a Microsoft Suspicious Website Warning/Phishing Warning in IE for the script:

http://www.mysitel.com/forum/calendarsearch.php?do=search

Anyone else get this?

Dylan, what is the JavaScript actually for?

EDIT: May be a new Sponsor Ad

[Dylanblitz]

Installed on 3.7.5, so far so good (except noted below).. more testing needed

I use both IE and Firefox, for some reason (and the first time I've seen this on my site), I get a Microsoft Suspicious Website Warning/Phishing Warning in IE for the script:

http://www.mysitel.com/forum/calendarsearch.php?do=search

Anyone else get this?

Dylan, what is the JavaScript actually for?

EDIT: May be a new Sponsor Ad

The js is for the mini calendar. I've used it before, don't think it's causing the problem.

[Turbe]

Yes, a new Sponsor ad in the cycle that I didn't realize.. I looking into that now :(

[SorentoUltimate]

Very Good, Thanks
INSTALLED

[ragtek]

You could just use the vbulletin own calendarpopup!

[Dylanblitz]

You could just use the vbulletin own calendarpopup!

I've actually never seen a popup calendar in vBulletin. Where would I access that at?

I'd rather use internal functions for what I can instead of outside js.

[ragtek]

You can see it in the project tools and in the acp.

clientscript/vbulletin_date_picker.js

maybe you could use the google translator to translate my article from vbgo(sorry, but i have no time atm, to release it on vb.org
http://www.vbulletin-germany.org/showthread.php?t=1390

[Turbe]

I'd rather use internal functions for what I can instead of outside js.

I use the one in Projects but I do like how yours is presented better :)

[Dylanblitz]

Hmm, a bit different, I don't think it's worth the outside script and files though. I'll switch it to use the internal code when I add the custom fields functionality and ACP calendar selection.

[Turbe]

too bad you wouldn't make it a ACP option to use the internal Mini Calendar function or the external one)... :)

If someone chooses the internal method, they don't have to copy the .js file into the forum's folder - it's optional but I would use the external one I think - I like the one you use now...

[Turbe]

Added ACP Permissions feature request to Post #1 :D

[klaush]

The calendar was and is even an important feature in vb, but not known by the develeopment team i think.

Thanks for this even important modification. This should be standard!

[SamirDarji]

OMG!!!! THANK YOU! THANK YOU! THANK YOU! THANK YOU! THANK YOU! THANK YOU!

I've been wanting this ever since I started using vb back in 2003!

But it may come a little late as the event forums I'm using actually takes the calendar info and puts it into the first post so the regular search picks it up. :( I'm still making a mental note of this plugin as I may want to use both side-by-side. Do you think there might be any problems with this?

[Dylanblitz]

I don't see any conflict but I think you'll have a bit of redundancy.

[SamirDarji]

I don't see any conflict but I think you'll have a bit of redundancy.Thank you. I'll try it on my test system.

[inciarco]

I noticed that the Search Results Only Show the Future Events, no matter if I Choose a Past Date on the Advanced Search. :confused:

Is it Possible to Include the Possibility to Include in the Search the Previous Events Too? :confused:

I Hope You Can Include that Feature on the Mod or Perhaps Indicate us what should we Change and where to Obtain those Complete Results.

Of Course I Voted for this Mod on this Mont's MOTM, I Like a lot this Feature on the Board. :up:

My Best Regards.

:)

[Dylanblitz]

I noticed that the Search Results Only Show the Future Events, no matter if I Choose a Past Date on the Advanced Search. :confused:

Is it Possible to Include the Possibility to Include in the Search the Previous Events Too? :confused:

I Hope You Can Include that Feature on the Mod or Perhaps Indicate us what should we Change and where to Obtain those Complete Results.

Of Course I Voted for this Mod on this Mont's MOTM, I Like a lot this Feature on the Board. :up:

My Best Regards.

:)

If you want to show previous dates you can modify this line 240

$event_query = $db->query_read("SELECT ce.*, cu.username, cc.title AS CalendarName FROM " . TABLE_PREFIX . "event ce LEFT JOIN " . TABLE_PREFIX . "user cu ON ce.userid = cu.userid LEFT JOIN " . TABLE_PREFIX . "calendar cc ON ce.calendarid = cc.calendarid WHERE ce.visible = '1' && dateline_from > '$thisdate'" . $search_vars . " ORDER BY " . $chksort . " " . $chkorder . " LIMIT " . ($limitlower - 1) . ", " . $perpage);

Change it to

$event_query = $db->query_read("SELECT ce.*, cu.username, cc.title AS CalendarName FROM " . TABLE_PREFIX . "event ce LEFT JOIN " . TABLE_PREFIX . "user cu ON ce.userid = cu.userid LEFT JOIN " . TABLE_PREFIX . "calendar cc ON ce.calendarid = cc.calendarid WHERE ce.visible = '1'" . $search_vars . " ORDER BY " . $chksort . " " . $chkorder . " LIMIT " . ($limitlower - 1) . ", " . $perpage);

[inciarco]

If you want to show previous dates you can modify this line 240

$event_query = $db->query_read("SELECT ce.*, cu.username, cc.title AS CalendarName FROM " . TABLE_PREFIX . "event ce LEFT JOIN " . TABLE_PREFIX . "user cu ON ce.userid = cu.userid LEFT JOIN " . TABLE_PREFIX . "calendar cc ON ce.calendarid = cc.calendarid WHERE ce.visible = '1' && dateline_from > '$thisdate'" . $search_vars . " ORDER BY " . $chksort . " " . $chkorder . " LIMIT " . ($limitlower - 1) . ", " . $perpage);

Change it to

$event_query = $db->query_read("SELECT ce.*, cu.username, cc.title AS CalendarName FROM " . TABLE_PREFIX . "event ce LEFT JOIN " . TABLE_PREFIX . "user cu ON ce.userid = cu.userid LEFT JOIN " . TABLE_PREFIX . "calendar cc ON ce.calendarid = cc.calendarid WHERE ce.visible = '1'" . $search_vars . " ORDER BY " . $chksort . " " . $chkorder . " LIMIT " . ($limitlower - 1) . ", " . $perpage);

Thank You Very Much, Dylanblitz. :up:

I removed the

&& dateline_from > '$thisdate'

and is Working Great.:up:

This is a Great Mod, Very Important for Boards that Use the Calendar Tool. :up:

My Best Regards, and Thank You Very Much For Sharing This Great Mod. :up:

:)

[Dylanblitz]

Thank You Very Much, Dylanblitz. :up:

I removed the



and is Working Great.:up:

This is a Great Mod, Very Important for Boards that Use the Calendar Tool. :up:

My Best Regards, and Thank You Very Much For Sharing This Great Mod. :up:

:)

Good to hear. This mod will go away with vb4. From what I hear the calendar is finally being included in the search so doing it from the outside won't be needed anymore :)

[SamirDarji]

vb4 is vaporware at the moment, and I think there will be support for the 3.8.x series for a while after vb4 is out. This mod will live on for a few years.

[inciarco]

Small Bug. :confused:

I made the Changes to include on the results all the List of Events (not only from the current date).

When I try to search for events with certain words like "colombia", "mexico", the mod only displays the first page of results, leaving many events out, (the results are larger than that); in other cases like when I search in my calendar for "espa?a", the results are presented in 2 pages, but leaving the other pages and results out; the results list and pages are being truncated for some reason.

This is happening with the Navbar Search and also with the Advanced Search, even by selecting Start and End Dates.

Looks like the pagination feature needs some code checking. :confused:

Do you know why? :confused:

Is there something additional that I should change to correct this? :confused:

My Best Regards.

:)

[Dylanblitz]

Small Bug. :confused:

I made the Changes to include on the results all the List of Events (not only from the current date).

When I try to search for events with certain words like "colombia", "mexico", the mod only displays the first page of results, leaving many events out, (the results are larger than that); in other cases like when I search in my calendar for "espa?a", the results are presented in 2 pages, but leaving the other pages and results out; the results list and pages are being truncated for some reason.

This is happening with the Navbar Search and also with the Advanced Search, even by selecting Start and End Dates.

Looks like the pagination feature needs some code checking. :confused:

Do you know why? :confused:

Is there something additional that I should change to correct this? :confused:

My Best Regards.

:)

Can you send me a link to your forum so I can check it out? I thought I had the nav path built right, I don't have enough calendar records to test it out right.

[inciarco]

Can you send me a link to your forum so I can check it out? I thought I had the nav path built right, I don't have enough calendar records to test it out right.

I've Sent You a PM with the Info, Dylanblitz. :up:

Is it possible to Include the Following Feature on the Mod:

1. To be able to Control the Time Betwen Searchs with the same one Specified for the Thread and Post Searchs, to Avoid Abuse of this Tool.

To do it, what Code Should I Include and in what File/Plugin for Make it Happen? :confused:

My Best Regards.

:)

[inciarco]

I guess you can use the same Date and Time Control that vBulletin Uses for the Searchs, because this is a Search it self, so if you Update and Control this Limits with the same System as the Board the User won't be able to Abuse of this Queries and also won't be able to Search Again on the Calendar or the Threads/Posts until the Waiting Time Expires. ;)

(This way you don't need to Create your own Time Control, and use the related one on the Forum Board). ;)

(I saw that the Mod uses the same Permission for Searching, so if an Usergroup don't Have Permissions to Search on the Forums won't have Permissions to Search on the Calendar, that is very Logic because both are Searchs on the Board.)

My Best Regards.

:)

[inciarco]

Hello Dylanblitz.

I Hope You Can Share With Us Soon an Update of this Great Mod.

Remember that One Small Detail is missing (not working properly), and is that when the Results have more than 1 Page the other Pages don't Show. :confused:

I've tested it on vB384 PL2 and the Error is still there. :confused:

My Best Regards and Hopes for an Update. ;)

:)

[MonkYZ]

Great mod ! I've installed it but unfortunatelly it gives me a bad link. To be more exact, the link to calendarsearch.php?do=dosearch is missing the /forum/ path. How can i fix this ?