Calendar Search and Comments for Events

[deathemperor]

This hack I made was a paid request by Lee Wilde (https://vborg.vbsupport.ru/member.php?userid=53530), 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.php?p=629980&postcount=38

*UPDATE: 03/17/2005 fixed avatar disable problem and a minor wrong in instructions.txt

TO FIX avatar disable:

FIND:

SELECT eventcomments.*, event.lastevecomdateline,user.*,userfield.*,userte xtfield.signature , customavatar.dateline AS avatardateline FROM " . TABLE_PREFIX . "eventcomments AS eventcomments
REPLACE WITH:

SELECT eventcomments.*, event.lastevecomdateline,user.*,userfield.*,userte xtfield.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/attachment.php?attachmentid=24795

event_with_quickreply_enabled : https://vborg.vbsupport.ru/attachment.php?attachmentid=24793
event_with_reply_added : https://vborg.vbsupport.ru/attachment.php?attachmentid=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.

[nexialys]

hum.. comments on events, does this mean it works like a "new thread for each event", so people doesn't have to create new threads for each event ?! this is great!

EDIT: found a first error;

in the instructions, the first thing is not to ADD BELOW, but to REPLACE WITH in the "in includes/init.php find..."

EDIT AGAIN:

script look solid, but you're not using $vbphrase ... fix this and this will be my next Hack of the Month!!! (ok, we may find some other details to fix before that!)

[Lizard King]

Is there any screenshot or live demo ?

[Polo]

Yeah, some screenshots would be great...

[Challenge]

Yeah, great! Thanks for releasing!

[Lionel]

I wish I could see screenshots. What is the difference between this hack and that one (https://vborg.vbsupport.ru/showthread.php?t=67074)

[Lionel]

Well, I installed. I had avatar disabled on my board, that gave me a mysql error. Could not go any further. Once I enabled avatar, it became fine. I don't want avatar.


Database error in vBulletin 3.0.7:

Invalid SQL:
SELECT eventcomments.*, event.lastevecomdateline,user.*,userfield.*,userte xtfield.signature , customavatar.dateline AS avatardateline FROM eventcomments AS eventcomments
LEFT JOIN event AS event ON(event.eventid=eventcomments.eventid)
LEFT JOIN user AS user ON(user.userid=eventcomments.evecomuserid)
LEFT JOIN userfield AS userfield ON(userfield.userid=eventcomments.evecomuserid)
LEFT JOIN usertextfield as usertextfield ON(usertextfield.userid=eventcomments.evecomuserid )

WHERE eventcomments.eventid=38
ORDER BY eventcomments.evecomid ASC
LIMIT 0, 10

mysql error: Unknown table 'customavatar' in field list

mysql error number: 1109

[Lee Wilde]

Ahem.....deathemperor.....I am a "she" not a "he".... lol

The hack worked perfectly for me on a development board. I'll be installing it on my live site today and I'll post a link here when its ready.

My site is a small business networking site. The ability for my members to add comments to events in the calendar will encourage them to discuss and arrange to meet at upcoming events.

deathemperor accomplished this hack for me with lightening speed and I did not experience any errors at all when installing....and my board had been hacked to death already. Given his knowledge, I'm sure any errors experienced by others will be able to be rectified without much fuss.

Excellent work deathemperor. I will try and contact some of the members who had been searching for the calendar search hack in particular, and alert them to this thread.

[Lionel]

Lee, out of curiosity do you have avatars enabled? Hack works perfect for me, until avatar is disabled...

[Lee Wilde]

I wish I could see screenshots. What is the difference between this hack and that one (https://vborg.vbsupport.ru/showthread.php?t=67074)

Lionel, the hack you linked to (New Thread on Calendar Event) creates a thread in a specified forum, whenever an event is added to the calendar.

deathemperor's hack enables users to reply directly to the event in the calendar....so the calendar event itself can become a thread!

This will bring our calendars to life!!

I'll post a link to a live example later today.

[Lee Wilde]

Lee, out of curiosity do you have avatars enabled? Hack works perfect for me, until avatar is disabled...

Hi Lionel, yes I do have avatars enabled. I'm not a code guru. I'm sure when deathemperor sees your problem he will show you how to remedy.

[Lionel]

Thanks. I hope I am not the only one with that problem. Like you said, it brings life in calendar. It's just that avatar I'd like to keep disable.

[Lee Wilde]

Here are 2 screenshots.

1. event_with_quickreply_enabled.jpg
Users are used to seeing the quick reply box in the forums, so to see under an event seems natural.

2. event_with_reply_added.jpg
Once someone has replied to the event, it begins to look like a forum thread!

I will add a screenshot of the calendar search page shortly.

[deathemperor]

a minute I'll fix the avatar disable problem, didn't think of disabling avatar T_T

to fix avatar disable problem if you installed:

FIND:

SELECT eventcomments.*, event.lastevecomdateline,user.*,userfield.*,userte xtfield.signature , customavatar.dateline AS avatardateline FROM " . TABLE_PREFIX . "eventcomments AS eventcomments
REPLACE WITH:

SELECT eventcomments.*, event.lastevecomdateline,user.*,userfield.*,userte xtfield.signature " . iif($vboptions['avatarenabled'], ", customavatar.dateline AS avatardateline") . " FROM " . TABLE_PREFIX . "eventcomments AS eventcomments


BTW thanks for the kinds word Lee Wilde, much appriciate.

and the reason why I didn't add phase to this was I didn't have enough time, also this hack isn't really big enough

[SamirDarji]

This looks great! Any sceenshots of the search?

[Lee Wilde]

Screenshot of calendar search page.

[Lizard King]

Here are 2 screenshots.

1. event_with_quickreply_enabled.jpg
Users are used to seeing the quick reply box in the forums, so to see under an event seems natural.

2. event_with_reply_added.jpg
Once someone has replied to the event, it begins to look like a forum thread!

I will add a screenshot of the calendar search page shortly.
Lee do you have event attendence installed also ? And is this mod working together with event attendence ?

[Lee Wilde]

I used the event attendance hack on my previous setup and it was brilliant. I don't know whether I really need it now.

I guess the event attendance hack did create the cool list of who is going. Hmmm......perhaps I will install it again. I'll let you know if it causes any problems.

[Lionel]

That fixed my problem. Hack seems to work 100% ok. Indeed you've created a forum within the calendar. Great work!

[Leeper]

I used the event attendance hack on my previous setup and it was brilliant. I don't know whether I really need it now.

I guess the event attendance hack did create the cool list of who is going. Hmmm......perhaps I will install it again. I'll let you know if it causes any problems.

They work great together! Now I just want to figure out the right place to put the search feature. Outstanding hack! I've had it installed for less than an hour and already have compliments! Thank you *clicks install*

[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 (http://www.s2kca.com/forums/calendar.php?do=getinfo&e=17&c=1)

[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/forum/calendar.php?do=getinfo&day=2005-4-19&e=94&c=4

[deathemperor]

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

in calendar.php find:

$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:

$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]

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:

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

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

$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:

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

replace with:
$lastevequery=",lastevecomdateline=$lastevecom[evecomdateline]";

updated fix post above.

[Lionel]

that works, thanks.

[Reeve of shinra]

Thank you for releasing this hack. In retrospect, I cant believe you cant search for calander events making this very much needed.

[Reeve of shinra]

Maybe I missed something but how does a user access the search?

[deathemperor]

you can use: http://YOURSITE.com/FORUM/calendar.php?do=search for the link to event search.

[Reeve of shinra]

When I try that, I get a user not allowed permissions error. I went into the admincp and for admin, the search calender option is set to 'yes'. I probably typo'd something... i'll have to check the code edits when im more awake.

[deathemperor]

it may be because you have not 'save' the usergroup permission in the first time so that it takes effect. I believe the code is ok since ppl is searching finely.

[Reeve of shinra]

Ah that was it. I knew it had to be something simple lol

Thanks!

[MikaK]

Installed this on a 303 with event attendance. All went fine, but when trying to add a comment or quote a existing comment this error pops up (the comments get added into the db all ok):


Database error in vBulletin 3.0.3:
Invalid SQL: SELECT * FROM eventcomments WHERE eventid=12
mysql error: Table 'soundchi_loudlounge.eventcomments' doesn't exist
mysql error number: 1146
Date: Wednesday 23rd of March 2005 12:45:51 AM
Script: http://www.soundchilds.net/loud_lounge/calendar.php
Referer: http://www.soundchilds.net/loud_lounge/calendar.php?do=postnewevecom&e=12
Username: MikaK
IP Address: xxx


my table is using a prefix 'scll' so it should be sclleventcomments.

Certainly hope there is a fix around for the mysql error. This is one hell of a handy hack:banana:

Regs,
-Mika

[deathemperor]

OOPS !

my bad mistake, I missed 2 table_prefix.

TO FIX:

IN calendar.php FIND:

// calculating which page the comment edited or posted is in
$perpage = $vboptions['evecomperpage'];
$countq = $DB_site->query("SELECT * FROM eventcomments WHERE eventid=$e");
$evecomcount = $DB_site->num_rows($countq);
$evepage = ceil($evecomcount/$perpage);
// query the newest comment
$thisevecom = $DB_site->query_first("SELECT evecomid FROM eventcomments WHERE evecomtitle = '" . addslashes($title) . "' ORDER BY evecomdateline DESC LIMIT 1");
$url = "calendar.php?$session[sessionurl]do=getinfo&e=$e&page=$evepage#comment$thisevecom[evecomid]";
eval(print_standard_redirect('redirect_postthanks' ));
}

REPLACE WITH:

// calculating which page the comment edited or posted is in
$perpage = $vboptions['evecomperpage'];
$countq = $DB_site->query("SELECT * FROM " . TABLE_PREFIX . "eventcomments WHERE eventid=$e");
$evecomcount = $DB_site->num_rows($countq);
$evepage = ceil($evecomcount/$perpage);
// query the newest comment
$thisevecom = $DB_site->query_first("SELECT evecomid FROM " . TABLE_PREFIX . "eventcomments WHERE evecomtitle = '" . addslashes($title) . "' ORDER BY evecomdateline DESC LIMIT 1");
$url = "calendar.php?$session[sessionurl]do=getinfo&e=$e&page=$evepage#comment$thisevecom[evecomid]";
eval(print_standard_redirect('redirect_postthanks' ));
}

zip updated.

[MikaK]

OOPS !

my bad mistake, I missed 2 table_prefix.



Worked like a treat:) Tnx.

[deathemperor]

no prob.

I'm glad to hear that.

[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/LPSForum/calendar.php?do=search&keyword=christmas&searchfor=event&searchdate=0&_order=descending&orderby=title&beforeafter=after&pp=10
Referer: http://www.yourlincolnpark.com/LPSForum/calendar.php?do=search
Username: Me
IP Address: myIP

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

[VB-Fanatiker]

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/LPSForum/calendar.php?do=search&keyword=council&searchfor=evecomments&searchdate=0&_order=descending&orderby=title&beforeafter=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]

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]

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.

[deathemperor]

Sorry, I was having a trip.
To fix that do the following:

find in caledar.php:

switch($searchfor)
{
case 'event':
// search for song(s)
$searchfor_query = "event.title LIKE '%$keyword%'";
// $searchfor_subquery = "OR event.event LIKE '%$keyword%'";
$searchin = "event";
break;

case 'eventcomments':
// search for singer(s)
$searchfor_query = "eventcomments.evecomtitle LIKE '%$keyword%'";
$searchfor_subquery = "OR eventcomments.evecombody LIKE '%$keyword%'";
$searchin = "eventcomments";
break;

default:
$searchfor_query = "eventcomments.evecomtitle LIKE '%$keyword%'";
$searchin = "eventcomments";
}

REPLACE IT WITH:

switch($searchfor)
{
case 'event':
// search for song(s)
$searchfor_query = "event.title LIKE '%$keyword%'";
// $searchfor_subquery = "OR event.event LIKE '%$keyword%'";
$searchin = "event AS event";
break;

case 'eventcomments':
// search for singer(s)
$searchfor_query = "eventcomments.evecomtitle LIKE '%$keyword%'";
$searchfor_subquery = "OR eventcomments.evecombody LIKE '%$keyword%'";
$searchin = "eventcomments AS eventcomments";
break;

default:
$searchfor_query = "eventcomments.evecomtitle LIKE '%$keyword%'";
$searchin = "eventcomments AS eventcomments";
}



@VB-Fanatiker, yep those can be made.

[VB-Fanatiker]

@VB-Fanatiker, yep those can be made.

Sorry, I'm not a coder. Do you know, what we must change in this hack to seach in the event details too? :cheeky:
Thats very important for us.

[deathemperor]

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

[VB-Fanatiker]

@deathemperor
That would be very, very friendly! :banana:
Wish a nice birthday!

[YLP1]

Sorry, I was having a trip.
To fix that do the following:

find in caledar.php:

switch($searchfor)
{
case 'event':
// search for song(s)
$searchfor_query = "event.title LIKE '%$keyword%'";
// $searchfor_subquery = "OR event.event LIKE '%$keyword%'";
$searchin = "event";
break;

case 'eventcomments':
// search for singer(s)
$searchfor_query = "eventcomments.evecomtitle LIKE '%$keyword%'";
$searchfor_subquery = "OR eventcomments.evecombody LIKE '%$keyword%'";
$searchin = "eventcomments";
break;

default:
$searchfor_query = "eventcomments.evecomtitle LIKE '%$keyword%'";
$searchin = "eventcomments";
}

REPLACE IT WITH:

switch($searchfor)
{
case 'event':
// search for song(s)
$searchfor_query = "event.title LIKE '%$keyword%'";
// $searchfor_subquery = "OR event.event LIKE '%$keyword%'";
$searchin = "event AS event";
break;

case 'eventcomments':
// search for singer(s)
$searchfor_query = "eventcomments.evecomtitle LIKE '%$keyword%'";
$searchfor_subquery = "OR eventcomments.evecombody LIKE '%$keyword%'";
$searchin = "eventcomments AS eventcomments";
break;

default:
$searchfor_query = "eventcomments.evecomtitle LIKE '%$keyword%'";
$searchin = "eventcomments AS eventcomments";
}



@VB-Fanatiker, yep those can be made.


I tried the above and get this error:
Database error in vBulletin 3.0.7:

Invalid SQL:
SELECT event AS event.*,user.*
FROM vb3_event AS event
LEFT JOIN vb3_user AS user ON (user.userid=event AS event.userid)

WHERE event.title LIKE '%council%'
ORDER BY evecomtitle DESC
LIMIT 10

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 '.*,user.*
FROM vb3_event AS event
LEFT JOIN vb3_user

mysql error number: 1064

Date: Saturday 26th of March 2005 03:31:20 PM
Script: http://www.yourlincolnpark.com/LPSForum/calendar.php?do=search&keyword=council&searchfor=event&searchdate=0&_order=descending&orderby=title&beforeafter=after&pp=10
Referer: http://www.yourlincolnpark.com/LPSForum/calendar.php?do=search
Username: Robin
IP Address: myip

[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.
anyway to add a special "new posts" link for the calendar comments?

[deathemperor]

@YLP1:

FIND:

switch($searchfor)
{
case 'event':
// search for song(s)
$searchfor_query = "event.title LIKE '%$keyword%'";
// $searchfor_subquery = "OR event.event LIKE '%$keyword%'";
$searchin = "event AS event";
break;

case 'eventcomments':
// search for singer(s)
$searchfor_query = "eventcomments.evecomtitle LIKE '%$keyword%'";
$searchfor_subquery = "OR eventcomments.evecombody LIKE '%$keyword%'";
$searchin = "eventcomments AS eventcomments";
break;

default:
$searchfor_query = "eventcomments.evecomtitle LIKE '%$keyword%'";
$searchin = "eventcomments AS eventcomments";
}


REPLACE WITH:

switch($searchfor)
{
case 'event':
// search for song(s)
$searchfor_query = "event.title LIKE '%$keyword%'";
// $searchfor_subquery = "OR event.event LIKE '%$keyword%'";
$searchin = "event";
$as = " AS event";
break;

case 'eventcomments':
// search for singer(s)
$searchfor_query = "eventcomments.evecomtitle LIKE '%$keyword%'";
$searchfor_subquery = "OR eventcomments.evecombody LIKE '%$keyword%'";
$searchin = "eventcomments AS eventcomments";
$as = " AS eventcomments";
break;

default:
$searchfor_query = "eventcomments.evecomtitle LIKE '%$keyword%'";
$searchin = "eventcomments AS eventcomments";
}

FIND:

$eventsearch = $DB_site->query("
SELECT $searchin.*,user.* $evetitle
FROM " . TABLE_PREFIX . "$searchin
LEFT JOIN " . TABLE_PREFIX . "user AS user ON (user.userid=$searchin.$usereve)
$evejoin
WHERE $searchfor_query $searchfor_subquery $searchfor_query1 $searchfor_query2
ORDER BY $order_by $order
LIMIT 10
");

REPLACE WITH

$eventsearch = $DB_site->query("
SELECT $searchin.*,user.* $evetitle
FROM " . TABLE_PREFIX . "$searchin $as
LEFT JOIN " . TABLE_PREFIX . "user AS user ON (user.userid=$searchin.$usereve)
$evejoin
WHERE $searchfor_query $searchfor_subquery $searchfor_query1 $searchfor_query2
ORDER BY $order_by $order
LIMIT 10
");

zip updated.
anyway to add a special "new posts" link for the calendar comments?
what do you mean ?

[YLP1]

@YLP1:

Hi deathemperor, I made the changes you posted and this is error I received:

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

mysql error: Unknown table 'event' in where clause

mysql error number: 1109

Date: Sunday 27th of March 2005 10:20:47 AM
Script: http://www.yourlincolnpark.com/LPSForum/calendar.php?do=search&keyword=council&searchfor=event&searchdate=0&_order=descending&orderby=title&beforeafter=after&pp=10
Referer: http://www.yourlincolnpark.com/LPSForum/calendar.php?do=search


It's not liking the where clause again. This query stuff confuses me to no end LOL

[deathemperor]

it's because I was too tired, having one day under the 38 C degree Sun.

make this change:

FIND:


$eventsearchcount = $DB_site->query("
SELECT *
FROM " . TABLE_PREFIX . "$searchin
WHERE $searchfor_query $searchfor_subquery $searchfor_query2
");


REPLACE WITH:

$eventsearchcount = $DB_site->query("
SELECT *
FROM " . TABLE_PREFIX . "$searchin $as
WHERE $searchfor_query $searchfor_subquery $searchfor_query2
");

[MikaK]

Would it be difficult to hack in events ratings?

Regs,
-Mika

[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]

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]

*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]

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=

[nexialys]

@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]

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?

[deathemperor]

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]

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]

it's because I was too tired, having one day under the 38 C degree Sun.

make this change:

FIND:


$eventsearchcount = $DB_site->query("
SELECT *
FROM " . TABLE_PREFIX . "$searchin
WHERE $searchfor_query $searchfor_subquery $searchfor_query2
");


REPLACE WITH:

$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]

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]

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]

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]

Will this hack search custom calendar field content?

No.
I need this feature also!!! :rolleyes:

[KTBleeding]

No.
I need this feature also!!! :rolleyes:
Bummer. That would save me a BUNCH of hassle.

[deathemperor]

Sorry guys I've been busy with my Java eProjects. I'll make an upgrade for those feature whenever I have time.

thanks for your concern.

[KTBleeding]

Sounds good to me. I've clicked install so I can keep updated.

[Lionel]

Wonder if this can be made to use Geek's Autolink hack?

[deta]

Here are 2 screenshots.

1. event_with_quickreply_enabled.jpg
Users are used to seeing the quick reply box in the forums, so to see under an event seems natural.

2. event_with_reply_added.jpg
Once someone has replied to the event, it begins to look like a forum thread!

I will add a screenshot of the calendar search page shortly.

Hello Lee,

how did you clean-bring there the fields to
Nearest Capital City:
Location:
Website:
Cost:
Parking:
Dress Code
Contact Name and Phone:
..?



Which chop is that?

Thanks

cu Deta

[VB-Fanatiker]

Will this hack search custom calendar field content?

Past another month. Nobody can do this? :alien:

[deathemperor]

I'm still coding my EJB project, 18 is my deadline, from there I'll be making hacks again.

please spare me.

[VB-Fanatiker]

Ok, I think I figured it out..... You have to change the following:

find in calendar.php


$searchfor_query = "event.title LIKE '%$keyword%'";
// $searchfor_subquery = "OR event.event LIKE '%$keyword%'";
$searchin = "event";


and change it to:


$searchfor_query = "event.title LIKE '%$keyword%'";
$searchfor_subquery = "OR event.event LIKE '%$keyword%'";
$searchfor_subquery = "OR event.customfields LIKE '%$keyword%'";
$searchin = "event";


Thats it (for me). Now it is searchable in the event content field and also in the customfields. :)

[deathemperor]

if it does work, then you should change:

$searchfor_subquery = "OR event.customfields LIKE '%$keyword%'";

to

$searchfor_subquery .= "OR event.customfields LIKE '%$keyword%'";

or this line:

$searchfor_subquery = "OR event.event LIKE '%$keyword%'";

will mean nothing

[deta]

Hello Lee,

how did you clean-bring there the fields to
Nearest Capital City:
Location:
Website:
Cost:
Parking:
Dress Code
Contact Name and Phone:
..?



Which chop is that?

Thanks

cu Deta

Can somebody else say to me, how I get?

cu Deta

[YLP1]

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.
Has a fix for this been found?

Thanks in advance.

[VB-Fanatiker]

Can somebody else say to me, how I get?

cu Deta

Customfields can be made without a hack in the ACP -> calendar :nervous:

[deta]

Customfields can be made without a hack in the ACP -> calendar :nervous:

Thanks :-)

[Mattius]

It seems i cant add a comment if i click on an event directly in the mini calendar (im using vbacmps), but if i click on the month, and display the entire months worth of events and click on one from there - i can add a comment as intended..

Anyone else having this problem or did i do something silly? :)

Check www.gamerscurse.com...to see what i mean

[LeeWicKeD]

did i installed the hack wrong? because when i click GO ADVANCED it does the same like pressing the REPLY button (in quick reply window)... ??

but: very nice hack!

* LeeWicKeD clicks install :)

[SamirDarji]

It seems i cant add a comment if i click on an event directly in the mini calendar (im using vbacmps), but if i click on the month, and display the entire months worth of events and click on one from there - i can add a comment as intended..

Anyone else having this problem or did i do something silly? :)

Check www.gamerscurse.com...to see what i meanguests can't see the calendar. :(

[LeeWicKeD]

aren't there any suggestions for my problem? not even from the coder? :(

[deathemperor]

I noticed that problem, will have a fix asap.

[LeeWicKeD]

hiho

two more questions ;)

1. is it possible, to show the new comments for events in NEW POSTS for every user that has the permissions for the calendar?

2. do you need someone to translate your hack into german? i would do this, if could tell me where to find the phrases etc..because there's no XML-file ;)

regards
lee

[deathemperor]

1. I don't know if that's possible.

2. I'll tell you when this hack is fully phrased, even when it is there will be no xml files cuz the phrases will be installed in the database along with vb phrases.

thanks for offering

[YLP1]

Hi everyone,

I get this DB error intermittingly and it has been driving me nuts. I have searched high and low for an answer on correcting this but it still rears it's ugly head Can someone help me fix this issue? Any help is greatly appreciated:

Database error in vBulletin 3.0.7:
Invalid SQL:
SELECT user.avatarid, user.avatarrevision, avatarpath, NOT ISNULL(avatardata) AS hascustom, customavatar.dateline
FROM vb3_user AS user
LEFT JOIN vb3_avatar AS avatar ON avatar.avatarid = user.avatarid
LEFT JOIN vb3_customavatar AS customavatar ON customavatar.userid = user.userid
WHERE user.userid =
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 '' at line 5
mysql error number: 1064


And this is what that section of the Calendar.php looks like:

$eventcomments = $DB_site->query("

SELECT eventcomments.*, event.lastevecomdateline,user.*,userfield.*,userte xtfield.signature " . iif($vboptions['avatarenabled'], ", customavatar.dateline AS avatardateline") . " FROM " . TABLE_PREFIX . "eventcomments AS eventcomments

LEFT JOIN " . TABLE_PREFIX . "event AS event ON(event.eventid=eventcomments.eventid)

LEFT JOIN " . TABLE_PREFIX . "user AS user ON(user.userid=eventcomments.evecomuserid)

LEFT JOIN " . TABLE_PREFIX . "userfield AS userfield ON(userfield.userid=eventcomments.evecomuserid)

LEFT JOIN " . TABLE_PREFIX . "usertextfield as usertextfield ON(usertextfield.userid=eventcomments.evecomuserid )

" . iif($vboptions['avatarenabled'], "LEFT JOIN " . TABLE_PREFIX . "customavatar AS customavatar ON(customavatar.userid = eventcomments.evecomuserid)") . "

WHERE eventcomments.eventid=$eventid

ORDER BY eventcomments.evecomid ASC

LIMIT $startingfrom, $perpage

");



$evecomrow = $DB_site->num_rows($eventcomments);

[Marco van Herwaarden]

This is not the part of the code that get that error.

[YLP1]

I was taking a stab at it as I am a newbie at PHP.....any ideas?

[Marco van Herwaarden]

The original error message will also tell you in what script and which line the error occured.

[YLP1]

That's part of the problem...this same error occurs on several pages like the index.php, showthread.php and private messenging pages.... I can't isolate it.

[deathemperor]

That's part of the problem...this same error occurs on several pages like the index.php, showthread.php and private messenging pages.... I can't isolate it.
which means this error is not from this hack, so I'm sorry I cannot provide you any fix for this

[SamirDarji]

Hi everyone,

I get this DB error intermittingly and it has been driving me nuts. I have searched high and low for an answer on correcting this but it still rears it's ugly head Can someone help me fix this issue? Any help is greatly appreciated:

Database error in vBulletin 3.0.7:
Invalid SQL:
SELECT user.avatarid, user.avatarrevision, avatarpath, NOT ISNULL(avatardata) AS hascustom, customavatar.dateline
FROM vb3_user AS user
LEFT JOIN vb3_avatar AS avatar ON avatar.avatarid = user.avatarid
LEFT JOIN vb3_customavatar AS customavatar ON customavatar.userid = user.userid
WHERE user.userid =
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 '' at line 5
mysql error number: 1064


And this is what that section of the Calendar.php looks like:

$eventcomments = $DB_site->query("

SELECT eventcomments.*, event.lastevecomdateline,user.*,userfield.*,userte xtfield.signature " . iif($vboptions['avatarenabled'], ", customavatar.dateline AS avatardateline") . " FROM " . TABLE_PREFIX . "eventcomments AS eventcomments

LEFT JOIN " . TABLE_PREFIX . "event AS event ON(event.eventid=eventcomments.eventid)

LEFT JOIN " . TABLE_PREFIX . "user AS user ON(user.userid=eventcomments.evecomuserid)

LEFT JOIN " . TABLE_PREFIX . "userfield AS userfield ON(userfield.userid=eventcomments.evecomuserid)

LEFT JOIN " . TABLE_PREFIX . "usertextfield as usertextfield ON(usertextfield.userid=eventcomments.evecomuserid )

" . iif($vboptions['avatarenabled'], "LEFT JOIN " . TABLE_PREFIX . "customavatar AS customavatar ON(customavatar.userid = eventcomments.evecomuserid)") . "

WHERE eventcomments.eventid=$eventid

ORDER BY eventcomments.evecomid ASC

LIMIT $startingfrom, $perpage

");



$evecomrow = $DB_site->num_rows($eventcomments);

Well, the error has to do with avatars. Try disabling avatars to see if the error goes away. That's a start in the right direction.

[deathemperor]

nah, that still does nothing to my hack, I never used something like this NOT ISNULL(avatardata) in it, sorry I can't help you out.

[Antivirus]

Just installed this- it's closest hack i could find that allows us to do what we want to do with tracking events and their feedback from members. I'm going to be playing around with it onn our test boards for next few days and so far everything looks great. [virus clicks install]

I had the following problem, not sure if anyoe else noticed this in one of the templates the install file uploaded...

In the calendar_searchevents template, there was a <table> tag that wasn't closed, it caused an odd column on the right hand side and messed up the footer (only for the Search Events page) so after figuring it out, i just added the closing </table> tag and it's beautiful. I attached screenies for people in case they have the same problem as shown, this would be your fix...

In calendar_searchevents template...

Find:
<div style="margin-top:6px">
<input type="submit" class="button" name="dosearch" value="Search Now" accesskey="s" />
<input type="reset" class="button" value="Reset Fields" accesskey="r" onclick="window.location=\'calendar.php?do=search\';" />
</div>
</td>
</tr>
</table>
</form>


And add below:
</table>

before and after screenies attached. Thanks again death!
:banana:

[bjs144]

Fantastic Mod, many thanks

[ohgenki]

can we get a 3.5 for this ?

[deathemperor]

Here you are: https://vborg.vbsupport.ru/showthread.php?s=&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:

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

add this below:

$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.

[xfaethorx]

hi is there a a legacy post bit version of the calendar_evecombit?

I use a legacy post bits everywhere else and the layout of this is the newer postbit format..has anyone altered this already?

[XrayHead]

Anyone know if you can have new events added to the new post's search?

For this to work for me people will have to know that events are being posted in the calendar section. If I could get this to work, my site would have a whole new feature not seen on any of the other boards that are in the same topics as mine!!

Xray

[XrayHead]

Ok I am geting this error!!


Database error in vBulletin 3.0.3:

Invalid SQL: INSERT INTO phrase (phraseid, languageid, varname, text, phrasetypeid) VALUES (NULL, '0', 'comment_deleted', 'Comment deleted.', 2000)
mysql error: Duplicate entry 'comment_deleted-0-2000' for key 2

mysql error number: 1062

Date: Sunday 18th of December 2005 09:49:51 PM
Script: http://mysite.com/vboard/admincp/evecom_install.php
Referer: http://mysite.com/vboard/admincp/evecom_install.php
Username: Lee B
IP Address: xx.xx.xx.xx

Can anyone please help me out as I am 90% there getting this to work on my LIVE board!!

Lee B

PS, Bummer as it workes way cool on my test board...

[DavidBlaze]

Has the VBulletin 3.7 version of this contrib been posted?

[Antivirus]

Has the VBulletin 3.7 version of this contrib been posted?

unfortunately, no - this has not been ported to 3.7.x

[leylandfor]

will this work with 3.7.2?