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.

[snyx]

This has been a long awaited hack my site has been dyerly needing. I have since controlled my event posting via a fourm, so I have many threads spanning now until mid year. some with pages of posts. what I need is an importer where I could fill in the details and a thread location and it would then port them into this system. is that a large job? it would be fantastic, im willing to exchange graphic work for such an importer.

Thanks ether way, love the calendar mods
also, I have some possible write work for you too deathemperor. a special profiles section, but first I need to impliment this.

[deathemperor]

an importer like you want is really complex, beside I've never done something like that, it would take alot of time.

Glad to hear you love it.

[VB-Fanatiker]

*vB-Fanatiker klicks install*

Great hack, thanks deathemperor !

Why this hack search only in the event titles and comments but not in the event details?
And is it possible to change this hack to search in new calendercustomfields else?

P.S.: Sorry for my bad schoolenglish, I'm german.

[deathemperor]

the search was supposed to be simple, it can be improved however.

what do you mean by calendercustomfields ?

remember that search function is one of the most simple things so to add this and that isn't hard.

[YLP1]

I am recieving the following error when trying to search:

Database error in vBulletin 3.0.7:

Invalid SQL:
SELECT *
FROM vb3_event
WHERE event.title LIKE '%christmas%'

mysql error: Unknown table 'event' in where clause

mysql error number: 1109

Date: Thursday 24th of March 2005 11:30:55 PM
Script: http://www.yourlincolnpark.com/LPSFo...er=after&pp=10
Referer: http://www.yourlincolnpark.com/LPSFo....php?do=search
Username: Me
IP Address: myIP

How can I fix this? Any help is greatly appreciated.

[VB-Fanatiker]

Originally Posted by deathemperor

the search was supposed to be simple, it can be improved however.

what do you mean by calendercustomfields ?

remember that search function is one of the most simple things so to add this and that isn't hard.

Thank you for your fast reply. :squareeyed:
I mean that the search also must be done in the event details. Do you know, how can we make this?

The "calendercustomfields" can be created in the ACP of the calendar. It's a very cool function for arrange the entrys.

[YLP1]

am recieving the following error when trying to search:


Quote:
Database error in vBulletin 3.0.7:

Invalid SQL:
SELECT *
FROM vb3_event
WHERE event.title LIKE '%christmas%'

mysql error: Unknown table 'event' in where clause

mysql error number: 1109

Date: Thursday 24th of March 2005 11:30:55 PM
Script: http://www.yourlincolnpark.com/LPSF...ter=after&pp=10
Referer: http://www.yourlincolnpark.com/LPSF...r.php?do=search
Username: Me
IP Address: myIP

How can I fix this? Any help is greatly appreciated.

Database error in vBulletin 3.0.7:

Invalid SQL:
SELECT *
FROM vb3_eventcomments
WHERE eventcomments.evecomtitle LIKE '%council%'

mysql error: Unknown table 'eventcomments' in where clause

mysql error number: 1109

Date: Friday 25th of March 2005 01:24:55 PM
Script: http://www.yourlincolnpark.com/LPSFo...er=after&pp=10
Referer: calendar.php?do=search

I have been trying to fix this but I don't know much about PHP...I did figure out that this error is similar to any type of search by Title, comments, etc.

Please advise on how I can fix this. Thanks in advance.

[VB-Fanatiker]

Originally Posted by YLP1

I have been trying to fix this but I don't know much about PHP...I did figure out that this error is similar to any type of search by Title, comments, etc.

Please advise on how I can fix this. Thanks in advance.

There are missing tables in the database. Have you done the changes at the end of this hack?

upload evecom_install.php to you Admincp folder and run it

etc.

[YLP1]

Originally Posted by VB-Fanatiker

There are missing tables in the database. Have you done the changes at the end of this hack?

etc.

Yeppers I ran the install.....I ran it again just to be sure and this is the error I received:

Database error in vBulletin 3.0.7:

Invalid SQL:
CREATE TABLE `vb3_eventcomments` (
`evecomid` int(10) unsigned NOT NULL auto_increment,
`evecomiconid` int(10) unsigned NOT NULL default '0',
`eventid` int(10) unsigned NOT NULL default '0',
`evecomtitle` varchar(250) default NULL,
`evecombody` longtext NOT NULL,
`evecomdateline` int(10) unsigned NOT NULL default '0',
`evecomusername` varchar(250) NOT NULL default '',
`evecomuserid` int(10) unsigned NOT NULL default '0',
`evecomhash` varchar(32) NOT NULL default '',
`valid` tinyint(1) unsigned NOT NULL default '1',
PRIMARY KEY (`evecomid`)
) TYPE=MyISAM

mysql error: Table 'vb3_eventcomments' already exists

mysql error number: 1050

Date: Friday 25th of March 2005 05:53:48 PM
Script: ***admin/evecom_install.php
Referer: ***/evecom_install.php
Username: Robin
IP Address:

Looks like these were already created. What else could be causing the errors?

Thanks in advance.

Edited to add: I confirmed that I have the tables of
vb3_event
- allowsmilies
- calendarid
- customfields
- dateline
- dateline_from
- dateline_to
- event
- eventid
- lastevecomdateline
- recuroption
- recurring
- title
- totalcom
- userid
- utc
- visible


and vb3_eventcomments has these:
- evecombody
- evecomdateline
- evecomhash
- evecomiconid
- evecomid
- evecomtitle
- evecomuserid
- evecomusername
- eventid
- valid

I also uninstalled and reinstalled and went over the instruction three times yet everything works except the search of title, dates, comments, etc.

[YLP1]

I am sorry to be a pest and such a newbie at coding but I have researched the error code and studied up on the coding to see if I could fix it alas...I can't figure out and I am getting errors on all the search functions of this mod and really need guidance on how to fix this.