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.

[Lionel]

I placed the search in the navbar under a drop down for calendar as a link. It would be nice to be able to use with vbaCMS. The old module does not recognize the events id

[Leeper]

hit a snag. My signature block comes up as code. Any ideas? Link

[ChurchMedia]

A couple of problems I'm having:

The avatar link is broken
The drop-down on the user name has some weird code in it
The signature is not recognizing line breaks
When trying to delete a comment I get:

Invalid SQL: UPDATE event SET totalcom = totalcom - 1,lastevecomdateline= WHERE eventid=94
mysql error: You have an error in your SQL syntax near 'WHERE eventid=94' at line 1

mysql error number: 1064

Here is an example:
http://www.churchmedia.net/community...-4-19&e=94&c=4

[deathemperor]

Here the fix for the error when trying to delete comments:

in calendar.php find:

PHP Code:

$DB_site->query("DELETE FROM " . TABLE_PREFIX . "eventcomments WHERE evecomid=$id");
            
            $lastevecom = $DB_site->query_first("SELECT * FROM " . TABLE_PREFIX . "eventcomments ORDER BY evecomdateline DESC LIMIT 1");
            $DB_site->query("UPDATE " . TABLE_PREFIX . "event SET totalcom = totalcom - 1,lastevecomdateline=$lastevecom[evecomdateline] WHERE eventid=$e"); 


REPLACE IT WITH:

PHP Code:

$DB_site->query("DELETE FROM " . TABLE_PREFIX . "eventcomments WHERE 

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

. "eventcomments ORDER BY evecomdateline DESC LIMIT 1");
            $lastevequery = '';
            if(is_array($lastevecom) && !empty($lastevecom[evecomdateline]))
            {
                

$lastevequery=",lastevecomdateline=$lastevecom[evecomdateline]";
            }
            $DB_site->query("UPDATE " . TABLE_PREFIX . "event SET totalcom = 

totalcom - 1 $lastevequery WHERE eventid=$e"); 


let me know if it works, I am currently away from my PC so I can't do any deep fix. I'll fix the signature problem soon.

Thanks everyone very much for your kind words.

[Lionel]

Am I missing something? Do I need to apply that fix? I am able to delete comments, events no problems, so I am not sure if I should do it or not....

[Lee Wilde]

If it aint broke, don't fix it Lionel ;-)

We have all customised our forums in different ways, so we may experience different problems. So far the only problem I've seen on mine is the signature not displaying correctly, but deathemperor will provide a fix for that soon I'm sure.

[deathemperor]

Originally Posted by Lionel

Am I missing something? Do I need to apply that fix? I am able to delete comments, events no problems, so I am not sure if I should do it or not....

that problem occurs when you have only one comment in an event, So I recommend anyone who installed this hack apply the fix.


SIGNATURE FIX: in calendar.php FIND:

PHP Code:

$eventcomment['evecombody'] = fetch_censored_text($eventcomment['evecombody']); 


ADD BELOW (actually it's possible to add above ^^):

PHP Code:

$eventcomment['signature'] = parse_bbcode($eventcomment['signature'], 0, 1); 


zip updated.

[Lionel]

I did not have the delete problem under the conditions that you said. I updated and I got

Database error in vBulletin 3.0.7:

Invalid SQL: UPDATE event SET totalcom =

totalcom - 1 ,lastevecomdateline=$lastevecom[evecomdateline] WHERE eventid=42
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 '[evecomdateline] WHERE eventid=42' at line 3

mysql error number: 1064

So I reverted and all is fine.

mysql database 4.03

[deathemperor]

I'm sorry, to fix that: find:

PHP Code:

$lastevequery=',lastevecomdateline=$lastevecom[evecomdateline]'; 


replace with:

PHP Code:

$lastevequery=",lastevecomdateline=$lastevecom[evecomdateline]"; 


updated fix post above.

[Lionel]

that works, thanks.