vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.8 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=235)
-   -   Calendar Enhancements - Calendar Advanced Search (https://vborg.vbsupport.ru/showthread.php?t=223995)

Dylanblitz 10-19-2009 01:57 PM

Quote:

Originally Posted by inciarco (Post 1901935)
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

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 10-19-2009 03:21 PM

Quote:

Originally Posted by Dylanblitz (Post 1902071)
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

Quote:

&& 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 10-19-2009 03:51 PM

Quote:

Originally Posted by inciarco (Post 1902105)
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 10-19-2009 09:02 PM

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 10-19-2009 10:37 PM

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 10-20-2009 03:26 PM

Quote:

Originally Posted by inciarco (Post 1902369)
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 10-20-2009 04:40 PM

Quote:

Originally Posted by Dylanblitz (Post 1902651)
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 10-20-2009 08:55 PM

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 02-27-2010 03:45 PM

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 05-24-2010 02:46 AM

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 ?


All times are GMT. The time now is 05:52 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01150 seconds
  • Memory Usage 1,768KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (4)bbcode_php_printable
  • (6)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (2)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete