Invision Community 4: SEO, prepare for v5 and dormant account notifications Matt November 11, 2024Nov 11
Posted April 14, 201014 yr File Name: (SOS30) Birthdays in Sidebar v1.0.0File Submitter: Adriano FariaFile Submitted: 14 Apr 2010File Category: Hooks and Plugins This hook will show today's birthdays in sidebar. You can set: Number of users to show If you want to show group color in user links If you want to show banned members in the list Sort by:User ID User Name Joined Date Posts Reputation Points ASC DESC [*]Sort order: Click here to download this file
April 15, 201014 yr Thanks, one problem though. Clicking "View all birthdays in Calendar" doesnt seem to work.
April 15, 201014 yr Author Weird. I don't have this problem in my live board: http://forum.sosinvision.com.br/ What happens with you ? You just click and nothing happens ?
December 5, 201014 yr Great mod! But when I activated it, I receive a SQL Driver error. In the cache error log this is what is showing... ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Date: Sun, 05 Dec 2010 00:06:49 +0000 Error: 1064 - 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 ') and ( m.bday_day=4 AND m.bday_month=12 ) ORDER BY m.posts desc LIMIT 0,5' at line 1 IP Address: 76.26.27.33 - /forums/ ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- mySQL query error: SELECT m.member_id, m.members_seo_name, m.members_display_name, m.member_group_id, m.bday_day, m.bday_month, m.bday_year,pp.pp_main_photo, pp.pp_main_width, pp.pp_main_height FROM ftmembers m LEFT JOIN ftprofile_portal pp ON ( pp.pp_member_id=m.member_id ) WHERE (m.member_banned = 0 and m.member_group_id != ) and ( m.bday_day=4 AND m.bday_month=12 ) ORDER BY m.posts desc LIMIT 0,5 .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------. | File | Function | Line No. | |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------| | admin/sources/classes/output/publicOutput.php | [sidebar_birthday].getOutput | 3198 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | admin/sources/classes/output/publicOutput.php | [output].templateHooks | 2453 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | admin/applications/forums/modules_public/forums/boards.php | [output].sendOutput | 150 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | admin/sources/base/ipsController.php | [public_forums_forums_boards].doExecute | 285 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' Is this a known issue? Thanks
December 6, 201014 yr Author This shouldn't be a problem:$banned = "(m.member_banned = 0 and m.member_group_id != {$this->settings['banned_group']}) and "; it should grab the ID from the banned group. Do you have a BANNED group, right ?
December 15, 201014 yr Yes I have a banned group...but nobody is in it. Instead I have an alternate member group I use for this purpose. Could this be why?
December 15, 201014 yr Author Certainly, since I'm looking for banned_group in conf_global.php! Edit you conf_global.php and use the right group ID in banned_group and you're done.
December 16, 201014 yr That makes sense. but a few more questions... 1. What exactly am I editing in conf_global.php? I looked in this file located in my /forums/ path but couldnt find anything in there related to a banned group. 2. I have the default "Banned" group with id #3 - 0 members in this group...because I also have the "Restricted" group which is the one I use for banned members. This is id #25. Which do I use for this purpose? 3. Where exactly is that banned_group code I need to change? Cant find it in conf_global or the template bit. Thanks!
Archived
This topic is now archived and is closed to further replies.