The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
Calendar Search and Comments for Events Details »» | |||||||||||||||||||||||||||
Calendar Search and Comments for Events
Developer Last Online: Jul 2011
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:
PHP Code:
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:
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. Show Your Support
|
Comments |
#102
|
|||
|
|||
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: Code:
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 Code:
$eventcomments = $DB_site->query(" SELECT eventcomments.*, event.lastevecomdateline,user.*,userfield.*,usertextfield.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); |
#103
|
|||
|
|||
This is not the part of the code that get that error.
|
#104
|
|||
|
|||
I was taking a stab at it as I am a newbie at PHP.....any ideas?
|
#105
|
|||
|
|||
The original error message will also tell you in what script and which line the error occured.
|
#106
|
|||
|
|||
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.
|
#107
|
||||
|
||||
Quote:
|
#108
|
|||
|
|||
Quote:
|
#109
|
||||
|
||||
nah, that still does nothing to my hack, I never used something like this
PHP Code:
|
#110
|
||||
|
||||
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: Code:
<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: Code:
</table> :banana: |
#111
|
|||
|
|||
Fantastic Mod, many thanks
|
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|