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]

you mean you want to rate for events ?

this isn't too hard too make tho, it will be included in the next version when I have time.

[MikaK]

Originally Posted by deathemperor

you mean you want to rate for events ?

this isn't too hard too make tho, it will be included in the next version when I have time.

Sounds good. Would definately suite my needs.

I still get a my sql error when searching for eventcomments:

  
Database error in vBulletin 3.0.3:
Invalid SQL: 
	SELECT * 
	FROM sclleventcomments  
	WHERE eventcomments.evecomtitle LIKE '%house%'   
  
mysql error: Unknown table 'eventcomments' in where clause
mysql error number: 1109
Date: Monday 28th of March 2005 03:35:31 AM

I had my bb set with the prefix "scll" so probably a missing prefix case.

Regs,
-Mika

[deathemperor]

pm sent

[deathemperor]

*UPDATE: 03/28/2005

If you installed this hack before 03/28/2005, to fix search bugs please rehack the file calendar.php

this happens only on board using table prefix

[MikaK]

Originally Posted by deathemperor

*UPDATE: 03/28/2005

If you installed this hack before 03/28/2005, to fix search bugs please rehack the find calendar.php

this happens only on board using table prefix

Can you specify some more details ie. do you mean a specific section of the installation text file or re-running the install script?

Regs,
-Mika

[deathemperor]

re edit all the steps you made for calendar.php,

I suggest you upload the new calendar.php and make the edit as in the instruction file.

[MikaK]

Originally Posted by deathemperor

re edit all the steps you made for calendar.php,

I suggest you upload the new calendar.php and make the edit as in the instruction file.

Ok. tnx. On my way.

=M=

@deathemperor...

i see in the installer that there is a Step 3 for language insertions, but there is only one phrase added... why this ?!... will you do the entire hack updated to add the phrases in the system?... because this step is actually useless... (my 2cents).. i would prefer having this done in $vbphrases, so we can translate the hack!!!

thanks anyway.. i love it - even if i will install it once in $vbphrase only!

[deathemperor]

the installer is simply one script I use to make all the installers for my hacks, basicly it always have those steps. it's not about I have that step in, it's about making all the phrase, the only phrase I added was because I got to add it in, it's the front end error message.. I'll consider it in the next version.

[snyx]

Originally Posted by deathemperor

what do you mean ?

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?