phpBB Smith: disable notification

Author	Message
angelak Member
Sun Mar 12, 2006 6:02 am Post subject: disable notification - hidden group mod
I have applied this hack and it is adding users to the hidden group without sending an email to notify them, but when I add them to the group I get the following error message (even though it's working!) I have applied this several times just in case I am making a mistake but I get the same every time! I am running 2.19 can anyone help? Thanks Angela Could not get group information DEBUG MODE SQL 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 '/ // Disable Notification of Addition to Hidden Group - End Cod SELECT group_name, group_type // // Disable Notification of Addition to Hidden Group - End Code Alteration //------------------------------------------------------------------------------ FROM phpbb_groups WHERE group_id = 88 Line : 561 File : groupcp.php

Thoul Administrator
Sun Mar 12, 2006 3:19 pm Post subject: re: disable notification - hidden group mod
Hi, I guess the instructions in this step can be a bit misleading. When you're installing, the section of code that looks like this: Code: $group_sql = "SELECT group_name FROM " . GROUPS_TABLE . " WHERE group_id = $group_id"; Should be changed to: Code: /------------------------------------------------------------------------------ // Disable Notification of Addition to Hidden Group - Begin Code Alteration // Added: , group_type // Original phpBB Code: // // Get the group name // Email the user and tell them they're in the group // $group_sql = "SELECT group_name FROM " . GROUPS_TABLE . " WHERE group_id = $group_id"; / $group_sql = "SELECT group_name, group_type FROM " . GROUPS_TABLE . " WHERE group_id = $group_id"; // // Disable Notification of Addition to Hidden Group - End Code Alteration //------------------------------------------------------------------------------

angelak Member
Sun Mar 12, 2006 5:04 pm Post subject: re: disable notification - hidden group mod
Thanks, it took me a while to figure out what I needed to do (it's my first mod and I really don't understand it!) But now it works perfectly - thank you for you help - and the mod! Onwards and upwards!!

Sun Mar 12, 2006 6:02 am Post subject: disable notification - hidden group mod

I have applied this hack and it is adding users to the hidden group without sending an email to notify them, but when I add them to the group I get the following error message (even though it's working!) I have applied this several times just in case I am making a mistake but I get the same every time!

I am running 2.19

can anyone help?

Thanks

Angela

Could not get group information

DEBUG MODE

SQL 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 '/ // Disable Notification of Addition to Hidden Group - End Cod

SELECT group_name, group_type // // Disable Notification of Addition to Hidden Group - End Code Alteration //------------------------------------------------------------------------------ FROM phpbb_groups WHERE group_id = 88

Line : 561
File : groupcp.php

Sun Mar 12, 2006 3:19 pm Post subject: re: disable notification - hidden group mod

Hi,

I guess the instructions in this step can be a bit misleading. When you're installing, the section of code that looks like this:

Code:

            $group_sql = "SELECT group_name
               FROM " . GROUPS_TABLE . "
               WHERE group_id = $group_id";

Should be changed to:

Code:

/*------------------------------------------------------------------------------
// Disable Notification of Addition to Hidden Group - Begin Code Alteration
//    Added: , group_type
//    Original phpBB Code:
            //
            // Get the group name
            // Email the user and tell them they're in the group
            //
            $group_sql = "SELECT group_name
               FROM " . GROUPS_TABLE . "
               WHERE group_id = $group_id";
*/
            $group_sql = "SELECT group_name, group_type
               FROM " . GROUPS_TABLE . "
               WHERE group_id = $group_id";
//
// Disable Notification of Addition to Hidden Group - End Code Alteration
//------------------------------------------------------------------------------

Sun Mar 12, 2006 5:04 pm Post subject: re: disable notification - hidden group mod

Thanks, it took me a while to figure out what I needed to do (it's my first mod and I really don't understand it!) But now it works perfectly - thank you for you help - and the mod!

Onwards and upwards!!