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.

[Lee Wilde]

Originally Posted by Lionel

Lee, out of curiosity do you have avatars enabled? Hack works perfect for me, until avatar is disabled...

Hi Lionel, yes I do have avatars enabled. I'm not a code guru. I'm sure when deathemperor sees your problem he will show you how to remedy.

[Lionel]

Thanks. I hope I am not the only one with that problem. Like you said, it brings life in calendar. It's just that avatar I'd like to keep disable.

[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.

[deathemperor]

a minute I'll fix the avatar disable problem, didn't think of disabling avatar T_T

to fix avatar disable problem if you installed:

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 


BTW thanks for the kinds word Lee Wilde, much appriciate.

and the reason why I didn't add phase to this was I didn't have enough time, also this hack isn't really big enough

[SamirDarji]

This looks great! Any sceenshots of the search?

[Lee Wilde]

Screenshot of calendar search page.

[Lizard King]

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.

Lee do you have event attendence installed also ? And is this mod working together with event attendence ?

[Lee Wilde]

I used the event attendance hack on my previous setup and it was brilliant. I don't know whether I really need it now.

I guess the event attendance hack did create the cool list of who is going. Hmmm......perhaps I will install it again. I'll let you know if it causes any problems.

[Lionel]

That fixed my problem. Hack seems to work 100% ok. Indeed you've created a forum within the calendar. Great work!

[Leeper]

Originally Posted by Lee Wilde

I used the event attendance hack on my previous setup and it was brilliant. I don't know whether I really need it now.

I guess the event attendance hack did create the cool list of who is going. Hmmm......perhaps I will install it again. I'll let you know if it causes any problems.

They work great together! Now I just want to figure out the right place to put the search feature. Outstanding hack! I've had it installed for less than an hour and already have compliments! Thank you *clicks install*