Version: 1.00, by deathemperor
Developer Last Online: Jul 2011
Version: 3.0.7
Rating:
Released: 03-15-2005
Last Update: 09-14-2005
Installs: 26
DB Changes
No support by the author.
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/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'.
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!)
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.
Quote:
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
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.
Calendar Search and Comments for Events Details »»
About Developer
Visit Web Site
DB Changes 
No support by the author.
03-16-2005, 12:00 PM
