[mxbb-commits] mx_music music.php,1.23,1.24

[FlorinCB <ory...@us...>]

Update of /cvsroot/mxbb/mx_music
In directory sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv17215

Modified Files:
	music.php 
Log Message:
fix for phpBB3 backend

Index: music.php
===================================================================
RCS file: /cvsroot/mxbb/mx_music/music.php,v
retrieving revision 1.23
retrieving revision 1.24
diff -C2 -d -r1.23 -r1.24
*** music.php	10 Sep 2008 06:05:21 -0000	1.23
--- music.php	10 Sep 2008 06:54:21 -0000	1.24
***************
*** 405,412 ****
  	if( $catrows[$i]['cat_moderator_groups'] != '')
  	{
  		// We have usergroup_ID, now we need usergroup name
  		$sql = "SELECT group_id, group_name
  				FROM " . GROUPS_TABLE . "
! 				WHERE group_single_user <> 1
  					AND group_type <> ". GROUP_HIDDEN ."
  					AND group_id IN (". $catrows[$i]['cat_moderator_groups'] .")
--- 405,423 ----
  	if( $catrows[$i]['cat_moderator_groups'] != '')
  	{
+ 		switch (PORTAL_BACKEND)
+ 		{
+ 			case 'internal':
+ 			case 'phpbb2':
+ 				$sql_where = 'group_single_user <> " . true . "';
+ 			break;
+ 
+ 			case 'phpbb3':
+ 				$sql_where = 'group_id <> " . true . "';
+ 			break;
+ 		}	
  		// We have usergroup_ID, now we need usergroup name
  		$sql = "SELECT group_id, group_name
  				FROM " . GROUPS_TABLE . "
! 				WHERE " . $sql_where . "
  					AND group_type <> ". GROUP_HIDDEN ."
  					AND group_id IN (". $catrows[$i]['cat_moderator_groups'] .")
***************
*** 796,803 ****
  		if ($thiscat['cat_moderator_groups'] != '')
  		{
  			// Get the namelist of moderator usergroups
! 			$sql = "SELECT group_id, group_name, group_type, group_single_user
  					FROM " . GROUPS_TABLE . "
! 					WHERE group_single_user <> 1
  						AND group_type <> ". GROUP_HIDDEN ."
  						AND group_id IN (". $thiscat['cat_moderator_groups'] .")
--- 807,825 ----
  		if ($thiscat['cat_moderator_groups'] != '')
  		{
+ 			switch (PORTAL_BACKEND)
+ 			{
+ 				case 'internal':
+ 				case 'phpbb2':
+ 					$sql_where = 'group_single_user <> " . true . "';
+ 				break;
+ 
+ 				case 'phpbb3':
+ 					$sql_where = 'group_id <> " . true . "';
+ 				break;
+ 			}		
  			// Get the namelist of moderator usergroups
! 			$sql = "SELECT *
  					FROM " . GROUPS_TABLE . "
! 					WHERE " . $sql_where . "
  						AND group_type <> ". GROUP_HIDDEN ."
  						AND group_id IN (". $thiscat['cat_moderator_groups'] .")