Calendar Enhancements - Calendar Advanced Search

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.

[Dylanblitz]

Originally Posted by inciarco

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

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

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

PHP Code:

$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

PHP Code:

$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]

Originally Posted by Dylanblitz

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

PHP Code:

$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

PHP Code:

$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]

Originally Posted by inciarco

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.

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.

Do you know why?

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

My Best Regards.

[Dylanblitz]

Originally Posted by inciarco

Small Bug.

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.

Do you know why?

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

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]

Originally Posted by Dylanblitz

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?

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.

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

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 ?