The Arcive of Official vBulletin Modifications Site.

Calendar Search and Comments for Events · **Released**: 03-15-2005

This hack I made was a paid request by Lee Wilde, the thread can be found here: https://vborg.vbsupport.ru/showthread.php?t=74337 . He and I want to release this to public because Lee Wilde believed that there're alot of members looking for this.

*UPDATE: 03/28/2005

If you installed this hack before 03/28/2005, to fix search bugs please rehack the file calendar.php

*UPDATE: 03/23/2005

Fixed 2 table_prefix mistaken, please read this post: https://vborg.vbsupport.ru/showpost....0&postcount=38

*UPDATE: 03/17/2005 fixed avatar disable problem and a minor wrong in instructions.txt

TO FIX avatar disable:

FIND:

PHP Code:


			
SELECT eventcomments.*, event.lastevecomdateline,user.*,userfield.*,usertextfield.signature , customavatar.dateline AS avatardateline FROM " . TABLE_PREFIX . "eventcomments AS eventcomments

REPLACE WITH:

PHP Code:


			
SELECT eventcomments.*, event.lastevecomdateline,user.*,userfield.*,usertextfield.signature " . iif($vboptions['avatarenabled'], ", customavatar.dateline AS avatardateline") . " FROM " . TABLE_PREFIX . "eventcomments AS eventcomments

What does this hack do ?

Give your users ability to search for Events on Calendar.
Ability to add comments for events.

The permission is usergroup based:

Viewing permission.

Post Comments.

Edit Own comments.

Edit Others comments.

Delete Own comments.

Delete Other comments.

Search Events.

Files edit: 3
New Template: 7
Templates Edit:1
Database: 1 new table, 2 new column for table 'event'.

Installation time: less than 10 minutes.

Screenshots: (thanks to Lee Wilde).

Search Events: https://vborg.vbsupport.ru/attachmen...chmentid=24795

event_with_quickreply_enabled : https://vborg.vbsupport.ru/attachmen...chmentid=24793
event_with_reply_added : https://vborg.vbsupport.ru/attachmen...chmentid=24794

Credits: The installer I use is from V3 Article with permission from John so the credit goes to him.

Last words: I will try to help with all the problems *in cases* may occur.

deathemperor · #52 03-26-2005, 11:25 AM

Sorry, I was having a trip.
To fix that do the following:

find in caledar.php:

PHP Code:


			
        switch($searchfor)

        {

            case 'event':

                // search for song(s)

                $searchfor_query = "event.title LIKE '%$keyword%'";

//                $searchfor_subquery = "OR event.event LIKE '%$keyword%'";

                $searchin = "event";

            break;

    

            case 'eventcomments':

                // search for singer(s)

                $searchfor_query = "eventcomments.evecomtitle LIKE '%$keyword%'";

                $searchfor_subquery = "OR eventcomments.evecombody LIKE '%$keyword%'";

                $searchin = "eventcomments";

            break;

                        

            default:

            $searchfor_query = "eventcomments.evecomtitle LIKE '%$keyword%'";

            $searchin = "eventcomments";            

        }

REPLACE IT WITH:

PHP Code:


			
        switch($searchfor)

        {

            case 'event':

                // search for song(s)

                $searchfor_query = "event.title LIKE '%$keyword%'";

//                $searchfor_subquery = "OR event.event LIKE '%$keyword%'";

                $searchin = "event AS event";

            break;



            case 'eventcomments':

                // search for singer(s)

                $searchfor_query = "eventcomments.evecomtitle LIKE '%$keyword%'";

                $searchfor_subquery = "OR eventcomments.evecombody LIKE '%$keyword%'";

                $searchin = "eventcomments AS eventcomments";

            break;

                        

            default:

            $searchfor_query = "eventcomments.evecomtitle LIKE '%$keyword%'";

            $searchin = "eventcomments AS eventcomments";            

        }

@VB-Fanatiker, yep those can be made.

VB-Fanatiker · #53 03-26-2005, 12:44 PM

Quote:

Originally Posted by deathemperor

@VB-Fanatiker, yep those can be made.

Sorry, I'm not a coder. Do you know, what we must change in this hack to seach in the event details too? :cheeky:
Thats very important for us.

deathemperor · #54 03-26-2005, 12:53 PM

If you like I'll upgrade this to have that options later. just give me sometimes cuz it's soon my birthday ^^

VB-Fanatiker · #55 03-26-2005, 01:23 PM

@deathemperor
That would be very, very friendly! :banana:
Wish a nice birthday!

YLP1 · #56 03-26-2005, 06:32 PM

Quote:

Originally Posted by deathemperor

Sorry, I was having a trip.
To fix that do the following:

find in caledar.php:

PHP Code:


			
        switch($searchfor)

        {

            case 'event':

                // search for song(s)

                $searchfor_query = "event.title LIKE '%$keyword%'";

//                $searchfor_subquery = "OR event.event LIKE '%$keyword%'";

                $searchin = "event";

            break;

    

            case 'eventcomments':

                // search for singer(s)

                $searchfor_query = "eventcomments.evecomtitle LIKE '%$keyword%'";

                $searchfor_subquery = "OR eventcomments.evecombody LIKE '%$keyword%'";

                $searchin = "eventcomments";

            break;

                        

            default:

            $searchfor_query = "eventcomments.evecomtitle LIKE '%$keyword%'";

            $searchin = "eventcomments";            

        }

REPLACE IT WITH:

PHP Code:


			
        switch($searchfor)

        {

            case 'event':

                // search for song(s)

                $searchfor_query = "event.title LIKE '%$keyword%'";

//                $searchfor_subquery = "OR event.event LIKE '%$keyword%'";

                $searchin = "event AS event";

            break;



            case 'eventcomments':

                // search for singer(s)

                $searchfor_query = "eventcomments.evecomtitle LIKE '%$keyword%'";

                $searchfor_subquery = "OR eventcomments.evecombody LIKE '%$keyword%'";

                $searchin = "eventcomments AS eventcomments";

            break;

                        

            default:

            $searchfor_query = "eventcomments.evecomtitle LIKE '%$keyword%'";

            $searchin = "eventcomments AS eventcomments";            

        }

@VB-Fanatiker, yep those can be made.

I tried the above and get this error:
Database error in vBulletin 3.0.7:

Quote:

Invalid SQL:
SELECT event AS event.*,user.*
FROM vb3_event AS event
LEFT JOIN vb3_user AS user ON (user.userid=event AS event.userid)

WHERE event.title LIKE '%council%'
ORDER BY evecomtitle DESC
LIMIT 10

mysql error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '.*,user.*
FROM vb3_event AS event
LEFT JOIN vb3_user

mysql error number: 1064

Date: Saturday 26th of March 2005 03:31:20 PM
Script: http://www.yourlincolnpark.com/LPSFo...er=after&pp=10
Referer: http://www.yourlincolnpark.com/LPSFo....php?do=search
Username: Robin
IP Address: myip

snyx · #57 03-26-2005, 08:04 PM

Quote:

Originally Posted by snyx

This has been a long awaited hack my site has been dyerly needing. I have since controlled my event posting via a fourm, so I have many threads spanning now until mid year. some with pages of posts. what I need is an importer where I could fill in the details and a thread location and it would then port them into this system. is that a large job? it would be fantastic, im willing to exchange graphic work for such an importer.

Thanks ether way, love the calendar mods

also, I have some possible write work for you too deathemperor. a special profiles section, but first I need to impliment this.

anyway to add a special "new posts" link for the calendar comments?

deathemperor · #58 03-27-2005, 08:20 AM

@YLP1:

FIND:

PHP Code:


			
        switch($searchfor)

        {

            case 'event':

                // search for song(s)

                $searchfor_query = "event.title LIKE '%$keyword%'";

//                $searchfor_subquery = "OR event.event LIKE '%$keyword%'";

                $searchin = "event AS event";

            break;



            case 'eventcomments':

                // search for singer(s)

                $searchfor_query = "eventcomments.evecomtitle LIKE '%$keyword%'";

                $searchfor_subquery = "OR eventcomments.evecombody LIKE '%$keyword%'";

                $searchin = "eventcomments AS eventcomments";

            break;

                        

            default:

            $searchfor_query = "eventcomments.evecomtitle LIKE '%$keyword%'";

            $searchin = "eventcomments AS eventcomments";            

        }

REPLACE WITH:

PHP Code:


			
        switch($searchfor)

        {

            case 'event':

                // search for song(s)

                $searchfor_query = "event.title LIKE '%$keyword%'";

//                $searchfor_subquery = "OR event.event LIKE '%$keyword%'";

                $searchin = "event";

                $as = " AS event";

            break;



            case 'eventcomments':

                // search for singer(s)

                $searchfor_query = "eventcomments.evecomtitle LIKE '%$keyword%'";

                $searchfor_subquery = "OR eventcomments.evecombody LIKE '%$keyword%'";

                $searchin = "eventcomments AS eventcomments";

                $as = " AS eventcomments";

            break;

                        

            default:

            $searchfor_query = "eventcomments.evecomtitle LIKE '%$keyword%'";

            $searchin = "eventcomments AS eventcomments";            

        }

FIND:

PHP Code:


			
        $eventsearch = $DB_site->query("

                SELECT $searchin.*,user.* $evetitle

                FROM " . TABLE_PREFIX . "$searchin

                LEFT JOIN " . TABLE_PREFIX . "user AS user ON (user.userid=$searchin.$usereve)

                $evejoin

                WHERE $searchfor_query $searchfor_subquery $searchfor_query1 $searchfor_query2

                ORDER BY $order_by $order

                LIMIT 10

        ");

REPLACE WITH

PHP Code:


			
        $eventsearch = $DB_site->query("

                SELECT $searchin.*,user.* $evetitle

                FROM " . TABLE_PREFIX . "$searchin $as

                LEFT JOIN " . TABLE_PREFIX . "user AS user ON (user.userid=$searchin.$usereve)

                $evejoin

                WHERE $searchfor_query $searchfor_subquery $searchfor_query1 $searchfor_query2

                ORDER BY $order_by $order

                LIMIT 10

        ");

zip updated.

Quote:

Originally Posted by snyx

anyway to add a special "new posts" link for the calendar comments?

what do you mean ?

YLP1 · #59 03-27-2005, 01:21 PM

Quote:

Originally Posted by deathemperor

@YLP1:

Hi deathemperor, I made the changes you posted and this is error I received:

Quote:

Invalid SQL:
SELECT *
FROM vb3_event
WHERE event.title LIKE '%council%'

mysql error: Unknown table 'event' in where clause

mysql error number: 1109

Date: Sunday 27th of March 2005 10:20:47 AM
Script: http://www.yourlincolnpark.com/LPSFo...er=after&pp=10
Referer: http://www.yourlincolnpark.com/LPSFo....php?do=search

It's not liking the where clause again. This query stuff confuses me to no end LOL

deathemperor · #60 03-27-2005, 10:06 PM

it's because I was too tired, having one day under the 38 C degree Sun.

make this change:

FIND:

PHP Code:


			
        $eventsearchcount = $DB_site->query("

                SELECT * 

                FROM " . TABLE_PREFIX . "$searchin 

                WHERE $searchfor_query $searchfor_subquery $searchfor_query2 

        ");

REPLACE WITH:

PHP Code:


			
        $eventsearchcount = $DB_site->query("

                SELECT * 

                FROM " . TABLE_PREFIX . "$searchin $as

                WHERE $searchfor_query $searchfor_subquery $searchfor_query2 

        ");

MikaK · #61 03-28-2005, 07:24 AM

Would it be difficult to hack in events ratings?

Regs,
-Mika

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.07322 seconds Memory Usage 2,400KB Queries Executed 25 (?)
More Information
Template Usage: (1)SHOWTHREAD (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)ad_showthread_beforeqr (12)bbcode_php (7)bbcode_quote (1)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)modsystem_post (1)navbar (6)navbar_link (120)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (11)post_thanks_box (11)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (11)post_thanks_postbit_info (10)postbit (11)postbit_onlinestatus (11)postbit_wrapper (1)spacer_close (1)spacer_open (1)tagbit_wrapper Phrase Groups Available: global inlinemod postbit posting reputationlevel showthread	Included Files: ./showthread.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/functions_bigthree.php ./includes/class_postbit.php ./includes/class_bbcode.php ./includes/functions_reputation.php ./includes/functions_post_thanks.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 showthread_start showthread_getinfo forumjump showthread_post_start showthread_query_postids showthread_query bbcode_fetch_tags bbcode_create showthread_postbit_create postbit_factory postbit_display_start post_thanks_function_post_thanks_off_start post_thanks_function_post_thanks_off_end post_thanks_function_fetch_thanks_start post_thanks_function_fetch_thanks_end post_thanks_function_thanked_already_start post_thanks_function_thanked_already_end fetch_musername postbit_imicons bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete postbit_display_complete post_thanks_function_can_thank_this_post_start pagenav_page pagenav_complete tag_fetchbit_complete forumrules navbits navbits_complete showthread_complete
Messages:

The Arcive of Official vBulletin Modifications Site.

It is not a VB3 engine, just a parsed copy!