vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.0 Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=33)
-   -   Calendar Search and Comments for Events (https://vborg.vbsupport.ru/showthread.php?t=78210)

deathemperor 03-15-2005 10:00 PM

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.

nexialys 03-16-2005 12:00 PM

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 03-16-2005 12:37 PM

Is there any screenshot or live demo ?

Polo 03-16-2005 12:49 PM

Yeah, some screenshots would be great...

Challenge 03-16-2005 02:33 PM

Yeah, great! Thanks for releasing!

Lionel 03-16-2005 08:52 PM

I wish I could see screenshots. What is the difference between this hack and that one

Lionel 03-16-2005 10:41 PM

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

mysql error number: 1109

Lee Wilde 03-17-2005 01:12 AM

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 03-17-2005 01:34 AM

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

Lee Wilde 03-17-2005 01:41 AM

Quote:

Originally Posted by Lionel
I wish I could see screenshots. What is the difference between this hack and that one

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.


All times are GMT. The time now is 10:32 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01191 seconds
  • Memory Usage 1,747KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (2)bbcode_php_printable
  • (2)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (2)pagenav_pagelink
  • (1)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete