vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   Modification Requests/Questions (Unpaid) (https://vborg.vbsupport.ru/forumdisplay.php?f=112)
-   -   Calendar Event Search (https://vborg.vbsupport.ru/showthread.php?t=147843)

noonespecial 05-22-2007 06:18 AM
Calendar Event Search
 
To be able to search the calendar would be a huge ... huge ... HUGE benefit.

Benj 05-23-2007 07:23 PM
backed - highly needed

youryogi.com 05-23-2007 09:10 PM
Ditto this request. It is a request that has been made year after year.

What would be nice would be a calendar that is searchable and also has a block on the top showing all of the upcoming events, a way to add attachments to an event, a way to comment on it, and event attendance all tied together.

There is really no calendar hacks out there that do all of these together and work within the calendar itself.

noonespecial 05-25-2007 09:33 AM
Quote:
Originally Posted by youryogi.com (Post 1253476)
Ditto this request. It is a request that has been made year after year.


What would be nice would be a calendar that is searchable and also has a block on the top showing all of the upcoming events, a way to add attachments to an event, a way to comment on it, and event attendance all tied together.

There is really no calendar hacks out there that do all of these together and work within the calendar itself.
That would be cool ... at the moment - a search is what I'm looking for most.

noonespecial 06-04-2007 06:47 AM
Guess this won't be happening.

nexialys 06-04-2007 12:32 PM
there is a similar hack for 3.5, but is not supported, so i suppose someone can handle the upgrade.. :)

noonespecial 06-19-2007 06:14 PM
Where?

dizzy100 06-19-2007 06:31 PM
I'd love to see this also.

noonespecial 06-24-2007 06:14 AM
Could you point me into this?

Benj 06-25-2007 10:48 PM
<a href="https://vborg.vbsupport.ru/showthread.php?t=91066&highlight=calendar+comments +search" target="_blank">https://vborg.vbsupport.ru/showt...omments+search</a>

elricstorm 06-26-2007 01:33 PM
What would you want the search to perform? i.e. what type of search requests

noonespecial 06-26-2007 05:00 PM
Quote:
Originally Posted by elricstorm (Post 1276939)
What would you want the search to perform? i.e. what type of search requests
Title and body of the event would be perfect IMO.

noonespecial 08-14-2007 06:56 AM
Finally got around to putting this together myself. Unsure how "optimized" it is ... but here's the core of it.

PHP Code:
if ($_REQUEST['do'] == 'searchresults')
{

    $vbulletin->input->clean_array_gpc('r', array(
        'sk' => TYPE_STR,
        'st' => TYPE_INT,
    ));

    // ATTN Compatibility Code
    $sk =& $vbulletin->GPC['sk'];
    $st =& $vbulletin->GPC['st'];
    // ATTN Compatibility Code

    if ($st==4)
    {
        $total= $db->query_first("
            SELECT COUNT(*) AS entries FROM " . TABLE_PREFIX . "event
            WHERE title LIKE '%".$db->escape_string($sk)."%' AND visible=1
        ");
        $getentries= $db->query("
            SELECT title,calendarid,visible,eventid,dateline_from FROM " . TABLE_PREFIX . "event
            WHERE visible=1 AND title LIKE '%".$db->escape_string($sk)."%'
            ORDER BY dateline_from DESC
            LIMIT 50
        ");
    }
       if ($total['entries']<1)
    {
        $resultbits="<div align=\"center\"><b>$vbphrase[no_results_found]</b></div>";
    }
    else
    {
        while($entry= $db->fetch_array($getentries))
        {
            $entry[date]= vbdate($vbulletin->options['dateformat'], $entry['dateline_from'],false,true,false,true);
            if (strlen($entry['title'])>300)
            {
                $entry['title']= "".substr($entry['title'], 0, 300)."...";
            }
            eval('$resultbits .= "' . fetch_template('eventsearchresults') . '";');
        }
        $db->free_result($entry);
    } 
It works - you just have to be skilled enough to put it together in your own script though. For legal reasons I can't really give any more help ... but I figured this would be a start for anyone looking to add an "event search" on their forum. So ... take ... use ... adapt ... hope it can help someone.

Note: if you don't want case sensitive searching - change event.title from utf_8 to "latin".


All times are GMT. The time now is 03:27 PM.

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.01020 seconds
  • Memory Usage 1,757KB
  • 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
  • (1)bbcode_php_printable
  • (2)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (13)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
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete