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.

[ohgenki]

can we get a 3.5 for this ?

[deathemperor]

Here you are: https://vborg.vbsupport.ru/showthrea...threadid=91066

[KrisJacobs]

I am having a wierd permissions issue.

When I set EveCom permssions as so:

Edit Own Comments = yes
Delete Own Comments = Yes
Edit Others Comments = no
Edit Others Comments = no

People cannot edit their own comments, and they cannot edit others comments.

When you click the Edit link on your own comments, you get the text editor - but when you click the Submit button, you get "do not have permission" page.

When you click the Edit link on others comments, you immediately get the "do not have permissions" page.

if I set EveCom permissions so:

Edit Own Comments = yes
Delete Own Comments = Yes
Edit Others Comments = yes
Edit Others Comments = yes

You can freely click Edit and successfully make edits to your own comments and others comments. You can use the Delete and delete your own comments and others comments.

What is going wrong here? Thanks in advance for any help.

-Kris

[deathemperor]

I think I made possibly some mistake but I am currently away from my computer, I will fix it very soon later.
thanks for your understanding.

[KrisJacobs]

Thank you!

Here is more information about my set up:

Everyone is a member of the Registered Users group, permissions are default on this group and I do not alter them. I have altered them, saved them, then put them back to pretty much "default".

I have 6 secondary groups that I use to control permissions like "can view forum" "can post in this forum" etc. Every user belongs to Registered Users as their Primary Group, and 1 or 2 secondary groups. Only a very small percentage of users belong to 2 secondary groups.

Each of these secondary groups I have manipulated and saved permissions on in troubleshooting this problem as well.

[KrisJacobs]

Any news on this problem Deathemperor?

Thank you!

[deathemperor]

I figured out the problem, please try this:

find in calendar.php:

PHP Code:

    {//if edit, don't insert new comment 


add this below:

PHP Code:

        $evecom = $DB_site->query_first("SELECT * FROM " . TABLE_PREFIX . "eventcomments WHERE evecomid=$id"); 


Hope this helps.

[KrisJacobs]

It is fixed, thank you very much!!!

[harry1951]

Great hack :-) Just installed it without problems.
Just 1 question. Can this be combined with this, because that is wat I realy want too.
https://vborg.vbsupport.ru/showthread.php?t=63460

[deathemperor]

I didn't try it so I don't know if two hacks are conflict.