Calendar Search and Comments for Events

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.

[KTBleeding]

Originally Posted by VB-Fanatiker

No.
I need this feature also!!!

Bummer. That would save me a BUNCH of hassle.

[deathemperor]

Sorry guys I've been busy with my Java eProjects. I'll make an upgrade for those feature whenever I have time.

thanks for your concern.

[KTBleeding]

Sounds good to me. I've clicked install so I can keep updated.

[Lionel]

Wonder if this can be made to use Geek's Autolink hack?

[deta]

Originally Posted by Lee Wilde

Here are 2 screenshots.

1. event_with_quickreply_enabled.jpg
Users are used to seeing the quick reply box in the forums, so to see under an event seems natural.

2. event_with_reply_added.jpg
Once someone has replied to the event, it begins to look like a forum thread!

I will add a screenshot of the calendar search page shortly.

Hello Lee,

how did you clean-bring there the fields to
Nearest Capital City:
Location:
Website:
Cost:
Parking:
Dress Code
Contact Name and Phone:
..?



Which chop is that?

Thanks

cu Deta

[VB-Fanatiker]

Originally Posted by KTBleeding

Will this hack search custom calendar field content?

Past another month. Nobody can do this? :alien:

[deathemperor]

I'm still coding my EJB project, 18 is my deadline, from there I'll be making hacks again.

please spare me.

[VB-Fanatiker]

Ok, I think I figured it out..... You have to change the following:

find in calendar.php

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

and change it to:

				$searchfor_query = "event.title LIKE '%$keyword%'";
				$searchfor_subquery = "OR event.event LIKE '%$keyword%'";
				$searchfor_subquery = "OR event.customfields LIKE '%$keyword%'";
				$searchin = "event";

Thats it (for me). Now it is searchable in the event content field and also in the customfields.

[deathemperor]

if it does work, then you should change:

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

to

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

or this line:

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

will mean nothing

[deta]

Originally Posted by deta

Hello Lee,

how did you clean-bring there the fields to
Nearest Capital City:
Location:
Website:
Cost:
Parking:
Dress Code
Contact Name and Phone:
..?



Which chop is that?

Thanks

cu Deta

Can somebody else say to me, how I get?

cu Deta