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.

[deathemperor]

Originally Posted by snyx

Well there is a "New Posts" link which outputs the new posts/threads made in the forums. Whats the chance of having a seperate "New Comments" link for posting done in the Calendar?

it cannot be made, because this is just "New reply" not a "new thread" you know, "new thread" here only means making a new event.

[snyx]

Originally Posted by deathemperor

it cannot be made, because this is just "New reply" not a "new thread" you know, "new thread" here only means making a new event.

grumble, that about bold/unbold event titles on calendar depending on new/no replies

[YLP1]

Originally Posted by deathemperor

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 
        "); 


Thank You Bunches.... I am all working now...

[VB-Fanatiker]

Originally Posted by deathemperor

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

Hi deathemperor,

you already in the last 2 weeks thought about it, to make the event details searchable? :nervous:
That would be great, thanks a lot!

VB-Fanatiker

[YLP1]

I have a question...how do I fix this broken avatar link? I'm not sure why it's pulling from where it's pulling shouldn't pull from the member's chosen avatar? How do I fix this?

Any help is greatly appreciated.

[provedel]

Originally Posted by YLP1

I have a question...how do I fix this broken avatar link? I'm not sure why it's pulling from where it's pulling shouldn't pull from the member's chosen avatar? How do I fix this?

Any help is greatly appreciated.

Same here...
On the forum, my avatar point to forums/customavatars/avatar1_0.gif

In Calendar the missing avatar point to forums/customavatars/avatar_0.gif

Note!
My avatars are currently being served from the filesystem, not from Database!!!

Thanks in advance...

[YLP1]

I have another question...when there are more than one event on a given calendar day, how would I a little icon like a bullet or something to indicate each calendar item.

If you look at the calendar graphic I have attached, you will see that on this calendar day I have three events (not including the birthday).

I have also attached a graphic that shows calendar events without use of the mini calendar as well. The bullet icon would make it much easier to identify each event.

These events are seperated by a dotted line, I would like to put an icon or bullet in front of each event entry to identify better each event.

How would I do that?

Thanks in advance.

[YLP1]

Originally Posted by provedel

Same here...
On the forum, my avatar point to forums/customavatars/avatar1_0.gif

In Calendar the missing avatar point to forums/customavatars/avatar_0.gif

Note!
My avatars are currently being served from the filesystem, not from Database!!!

Thanks in advance...

I still can't figure out how to fix this unless a hard link is entered but I am not sure where to put that URL to customavatars.

In looking at the code and the size of the Avatar it looks like the normal size avatars are made smaller??!??

I dunno....any help to fix this is greatly appreicated.

[KTBleeding]

Will this hack search custom calendar field content?

[VB-Fanatiker]

Originally Posted by KTBleeding

Will this hack search custom calendar field content?

No.
I need this feature also!!!