[mxbb-commits] mx_music/phpbb2/admin admin_music_auth.php, NONE, 1.1.2.1 admin_music_cat.php, NONE, 1.1.2.1 admin_music_cfg.php, NONE, 1.1.2.1

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

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

Added Files:
      Tag: core28x
	admin_music_auth.php admin_music_cat.php admin_music_cfg.php 
Log Message:
update for new mx_mod 2.8.2

--- NEW FILE: admin_music_auth.php ---
<?php
/**
*
* @package mxBB Portal Module - mx_music
* @version $Id: admin_music_auth.php,v 1.1.2.1 2008/03/08 15:42:58 orynider Exp $
* @copyright (c) 2003 [ory...@rd..., OryNider] mxBB Development Team
* @license http://opensource.org/licenses/gpl-license.php GNU General Public License v2
*
*/

$phpEx = substr(strrchr(__FILE__, '.'), 1);

if ( @file_exists( './../viewtopic.' . $phpEx ) ) // -------------------------------------------- phpBB MOD MODE
{
	define('MXBB_MODULE', false);
	define('IN_PHPBB', true);
	
	$phpbb_root_path = $module_root_path = './../';
	$mx_mod_path = $phpbb_root_path . 'mx_mod/';
	
	require_once($mx_mod_path . "includes/functions_required.$phpEx");
	
	@define('IN_PORTAL', true);
	
	//Check if forum_hack is installed
	if (!isset($mx_root_path))
	{
		$mx_root_path = './../';

		include_once($mx_mod_path . "includes/mx_constants.$phpEx");
		include_once($mx_mod_path . "includes/shared/phpbb2/includes/functions.$phpEx");
	}
	
	require_once($mx_mod_path . "includes/functions_core.$phpEx");
	
	//Check for cash mod
	if (file_exists($phpbb_root_path . 'includes/functions_cash.'.$phpEx))
	{
		define('IN_CASHMOD', true);
	}

	//@ini_set( 'display_errors', '1' );
	error_reporting (E_ERROR | E_WARNING | E_PARSE); // This will NOT report uninitialized variables
	//error_reporting(E_ALL & ~E_NOTICE);

	define( 'PAGE_MUSIC', -506 ); // If this id generates a conflict with other mods, change it ;)

	//
	// Instatiate the mx_cache class
	//
	$mx_cache = new mx_cache();
	
	//
	// instatiate the mx_request_vars class
	//
	$mx_request_vars = new mx_request_vars();
	

	//
	// instatiate the mx_user class
	//
	//$mx_user = new mx_user();

	//
	// Left Pane Paths
	//
	$setmodules_admin_path = '';
	$setmodules_module_path = "./../";
	
	if (file_exists($phpbb_root_path."modcp.$phpEx")) // phpBB2
	{
		define('PORTAL_BACKEND', 'phpbb2');
		$tplEx = 'tpl';
	}
	else if (@file_exists($phpbb_root_path."mcp.$phpEx")) // phpBB3
	{
		define('PORTAL_BACKEND', 'phpbb3');
		$tplEx = 'html';
	}
}
else
{
	define( 'IN_PORTAL', 1 );
	define( 'MXBB_MODULE', true );

	//
	// Main paths
	//
	$mx_root_path = './../../../';
	$module_root_path = './../../../modules/mx_music/';

	$setmodules_admin_path = 'modules/mx_linkdb/admin/';

	define( 'MXBB_27x', file_exists( $mx_root_path . 'mx_login.php' ) );

	$phpEx = substr(strrchr(__FILE__, '.'), 1);
}

if ( !empty( $setmodules ) )
{
	$file = basename( __FILE__ );
	$module['Music_Online']['Permissions'] = $setmodules_admin_path . $file;
	return;
}

$music_root_path = $module_root_path . 'music_box/';

//
// Get general information
//
require($mx_root_path . 'admin/pagestart.' . $phpEx);

if ( !MXBB_MODULE )
{
	require_once($mx_mod_path . "includes/functions_styles.$phpEx");

	$mx_user = new mx_user();	// instatiate the mx_user class
	
	//
	// Define basic constants
	//
	$mx_user->page_id = 506;
	$mx_user->user_ip = $user_ip;
	$mx_user->_init_userprefs();
	$mx_user->set_module_cfg_name('music');
	$mx_user->set_module_lang_path($module_root_path . 'music_box/');
	$mx_user->extend(); // Read language definition
}

require($music_root_path . 'music_common.'.$phpEx);


// **********************************************************************
// Read language definition
// **********************************************************************
if ( !MXBB_MODULE )
{
	if ( !file_exists( $module_root_path . 'music_box/language/lang_' . $board_config['default_lang'] . '/lang_admin_music.' . $phpEx ) )
	{
		include( $module_root_path . 'music_box/language/lang_english/lang_admin_music.' . $phpEx );
	}
	else
	{
		include( $module_root_path . 'music_box/language/lang_' . $board_config['default_lang'] . '/lang_admin_music.' . $phpEx );
	}
}
else
{
	if ( file_exists( $module_root_path . 'language/lang_' . $board_config['default_lang'] . '/lang_admin_music.' . $phpEx ) )
	{
		include( $module_root_path . 'language/lang_' . $board_config['default_lang'] . '/lang_admin_music.' . $phpEx );
	}
	else if ( file_exists( $module_root_path . 'language/lang_english/lang_admin_music.' . $phpEx ) )
	{
		include( $module_root_path . 'language/lang_english/lang_admin_music.' . $phpEx );
	}
}


if( !isset($HTTP_POST_VARS['submit']) )
{
	// Build the category selector
	$sql = "SELECT cat_id, cat_title, cat_order
			FROM ". MUSIC_CAT_TABLE ."
			ORDER BY cat_order ASC";
	if( !$result = $db->sql_query($sql) )
	{
		message_die(GENERAL_ERROR, 'Could not get Category list', '', __LINE__, __FILE__, $sql);
	}

	while( $row = $db->sql_fetchrow($result) )
	{
		$catrows[] = $row;
	}

	for ($i = 0; $i < count($catrows); $i++)
	{
		$template->assign_block_vars('catrow', array(
			'CAT_ID' => $catrows[$i]['cat_id'],
			'CAT_TITLE' => $catrows[$i]['cat_title'])
		);
	}

	$template->set_filenames(array(
		'body' => 'admin/music_cat_select_body.tpl')
	);

	$template->assign_vars(array(
		'L_MUSIC_AUTH_TITLE' => $lang['Music_Auth_Title'],
		'L_MUSIC_AUTH_EXPLAIN' => $lang['Music_Auth_Explain'],
		'L_SELECT_CAT' => $lang['Select_a_Category'],
		'S_MUSIC_ACTION' => append_sid("admin_music_auth.$phpEx"),
		'L_LOOK_UP_CAT' => $lang['Look_up_Category'])
	);

	$template->pparse('body');

	include($mx_root_path . 'admin/page_footer_admin.'.$phpEx);
}
else
{
	if( !isset($HTTP_GET_VARS['cat_id']) )
	{
		$cat_id = intval($HTTP_POST_VARS['cat_id']);

		$template->set_filenames(array(
			'body' => 'admin/music_auth_body.tpl')
		);

		$template->assign_vars(array(
			'L_MUSIC_AUTH_TITLE' => $lang['Music_Auth_Title'],
			'L_MUSIC_AUTH_EXPLAIN' => $lang['Music_Auth_Explain'],
			'L_SUBMIT' => $lang['Submit'],
			'L_RESET' => $lang['Reset'],

			'L_GROUPS' => $lang['Usergroups'],

			'L_VIEW' => $lang['View'],
			'L_UPLOAD' => $lang['Upload'],
			'L_RATE' => $lang['Rate'],
			'L_COMMENT' => $lang['Comment'],
			'L_EDIT' => $lang['Edit'],
			'L_DELETE' => $lang['Delete'],

			'L_IS_MODERATOR' => $lang['Is_Moderator'],
			'S_MUSIC_ACTION' => append_sid("admin_music_auth.$phpEx?cat_id=$cat_id"),
			)
		);

		// Get the list of phpBB usergroups
		$sql = "SELECT group_id, group_name
				FROM " . GROUPS_TABLE . "
				WHERE group_single_user <> " . TRUE ."
				ORDER BY group_name ASC";
		if ( !($result = $db->sql_query($sql)) )
		{
			message_die(GENERAL_ERROR, 'Could not get group list', '', __LINE__, __FILE__, $sql);
		}

		while( $row = $db->sql_fetchrow($result) )
		{
			$groupdata[] = $row;
		}

		// Get info of this cat
		$sql = "SELECT cat_id, cat_title, cat_view_groups, cat_upload_groups, cat_rate_groups, cat_comment_groups, cat_edit_groups, cat_delete_groups, cat_moderator_groups
				FROM ". MUSIC_CAT_TABLE ."
				WHERE cat_id = '$cat_id'";
		if( !$result = $db->sql_query($sql) )
		{
			message_die(GENERAL_ERROR, 'Could not get Category information', '', __LINE__, __FILE__, $sql);
		}

		$thiscat = $db->sql_fetchrow($result);

		$view_groups = @explode(',', $thiscat['cat_view_groups']);
		$upload_groups = @explode(',', $thiscat['cat_upload_groups']);
		$rate_groups = @explode(',', $thiscat['cat_rate_groups']);
		$comment_groups = @explode(',', $thiscat['cat_comment_groups']);
		$edit_groups = @explode(',', $thiscat['cat_edit_groups']);
		$delete_groups = @explode(',', $thiscat['cat_delete_groups']);

		$moderator_groups = @explode(',', $thiscat['cat_moderator_groups']);

		for ($i = 0; $i < count($groupdata); $i++)
		{
			$template->assign_block_vars('grouprow', array(
				'GROUP_ID' => $groupdata[$i]['group_id'],
				'GROUP_NAME' => $groupdata[$i]['group_name'],

				'VIEW_CHECKED' => (in_array($groupdata[$i]['group_id'], $view_groups)) ? 'checked="checked"' : '',

				'UPLOAD_CHECKED' => (in_array($groupdata[$i]['group_id'], $upload_groups)) ? 'checked="checked"' : '',

				'RATE_CHECKED' => (in_array($groupdata[$i]['group_id'], $rate_groups)) ? 'checked="checked"' : '',

				'COMMENT_CHECKED' => (in_array($groupdata[$i]['group_id'], $comment_groups)) ? 'checked="checked"' : '',

				'EDIT_CHECKED' => (in_array($groupdata[$i]['group_id'], $edit_groups)) ? 'checked="checked"' : '',

				'DELETE_CHECKED' => (in_array($groupdata[$i]['group_id'], $delete_groups)) ? 'checked="checked"' : '',

				'MODERATOR_CHECKED' => (in_array($groupdata[$i]['group_id'], $moderator_groups)) ? 'checked="checked"' : '')
			);
		}

		$template->pparse('body');

		include($mx_root_path . 'admin/page_footer_admin.'.$phpEx);
	}
	else
	{
		$cat_id = intval($HTTP_GET_VARS['cat_id']);

		$view_groups = @implode(',', $HTTP_POST_VARS['view']);
		$upload_groups = @implode(',', $HTTP_POST_VARS['upload']);
		$rate_groups = @implode(',', $HTTP_POST_VARS['rate']);
		$comment_groups = @implode(',', $HTTP_POST_VARS['comment']);
		$edit_groups = @implode(',', $HTTP_POST_VARS['edit']);
		$delete_groups = @implode(',', $HTTP_POST_VARS['delete']);

		$moderator_groups = @implode(',', $HTTP_POST_VARS['moderator']);

		$sql = "UPDATE ". MUSIC_CAT_TABLE ."
				SET cat_view_groups = '$view_groups', cat_upload_groups = '$upload_groups', cat_rate_groups = '$rate_groups', cat_comment_groups = '$comment_groups', cat_edit_groups = '$edit_groups', cat_delete_groups = '$delete_groups',	cat_moderator_groups = '$moderator_groups'
				WHERE cat_id = '$cat_id'";
		if ( !$result = $db->sql_query($sql) )
		{
			message_die(GENERAL_ERROR, 'Could not update music config table', '', __LINE__, __FILE__, $sql);
		}

		// okay, return a message... 
		$message = $lang['Music_Auth_successfully'] . '<br /><br />' . sprintf($lang['Click_return_music_auth'], '<a href="' . append_sid("admin_music_auth.$phpEx") . '">', '</a>') . '<br /><br />' . sprintf($lang['Click_return_admin_index'], '<a href="' . append_sid("index.$phpEx?pane=right") . '">', '</a>');

		message_die(GENERAL_MESSAGE, $message);
	}
}

/* Powered by Music Online 2.0 (c) 2003 Cf Manager */

?>
--- NEW FILE: admin_music_cat.php ---
<?php
/**
*
* @package mxBB Portal Module - mx_music
* @version $Id: admin_music_cat.php,v 1.1.2.1 2008/03/08 15:42:59 orynider Exp $
* @copyright (c) 2003 [ory...@rd..., OryNider] mxBB Development Team
* @license http://opensource.org/licenses/gpl-license.php GNU General Public License v2
*
*/

$phpEx = substr(strrchr(__FILE__, '.'), 1);

if ( @file_exists( './../viewtopic.' . $phpEx ) ) // -------------------------------------------- phpBB MOD MODE
{
	define('MXBB_MODULE', false);
	define('IN_PHPBB', true);
	
	$phpbb_root_path = $module_root_path = './../';
	$mx_mod_path = $phpbb_root_path . 'mx_mod/';
	
	require_once($mx_mod_path . "includes/functions_required.$phpEx");
	
	@define('IN_PORTAL', true);
	
	//Check if forum_hack is installed
	if (!isset($mx_root_path))
	{
		$mx_root_path = './../';

		include_once($mx_mod_path . "includes/mx_constants.$phpEx");
		include_once($mx_mod_path . "includes/shared/phpbb2/includes/functions.$phpEx");
	}
	
	require_once($mx_mod_path . "includes/functions_core.$phpEx");
	
	//Check for cash mod
	if (file_exists($phpbb_root_path . 'includes/functions_cash.'.$phpEx))
	{
		define('IN_CASHMOD', true);
	}

	//@ini_set( 'display_errors', '1' );
	error_reporting (E_ERROR | E_WARNING | E_PARSE); // This will NOT report uninitialized variables
	//error_reporting(E_ALL & ~E_NOTICE);

	define( 'PAGE_KB', -502 ); // If this id generates a conflict with other mods, change it ;)

	//
	// Instatiate the mx_cache class
	//
	$mx_cache = new mx_cache();
	
	//
	// instatiate the mx_request_vars class
	//
	$mx_request_vars = new mx_request_vars();
	

	//
	// instatiate the mx_user class
	//
	//$mx_user = new mx_user();

	//
	// Left Pane Paths
	//
	$setmodules_admin_path = '';
	$setmodules_module_path = "./../";
	
	if (file_exists($phpbb_root_path."modcp.$phpEx")) // phpBB2
	{
		define('PORTAL_BACKEND', 'phpbb2');
		$tplEx = 'tpl';
	}
	else if (@file_exists($phpbb_root_path."mcp.$phpEx")) // phpBB3
	{
		define('PORTAL_BACKEND', 'phpbb3');
		$tplEx = 'html';
	}
}
else
{
	define( 'IN_PORTAL', 1 );
	define( 'MXBB_MODULE', true );

	//
	// Main paths
	//
	$mx_root_path = './../../../';
	$module_root_path = './../../../modules/mx_music/';

	$setmodules_admin_path = 'modules/mx_linkdb/admin/';

	define( 'MXBB_27x', file_exists( $mx_root_path . 'mx_login.php' ) );

	$phpEx = substr(strrchr(__FILE__, '.'), 1);
}

if ( !empty( $setmodules ) )
{
	$file = basename( __FILE__ );
	$module['Music_Online']['Categories'] = $setmodules_admin_path . $file;
	return;
}

$music_root_path = $module_root_path . 'music_box/';

//
// Get general information
//
require($mx_root_path . 'admin/pagestart.' . $phpEx);

if ( !MXBB_MODULE )
{
	require_once($mx_mod_path . "includes/functions_styles.$phpEx");

	$mx_user = new mx_user();	// instatiate the mx_user class
	
	//
	// Define basic constants
	//
	$mx_user->page_id = 1;
	$mx_user->user_ip = $user_ip;
	$mx_user->_init_userprefs();
}

require($music_root_path . 'music_common.'.$phpEx);


// **********************************************************************
// Read language definition
// **********************************************************************
if ( !MXBB_MODULE )
{
	if ( !file_exists( $module_root_path . 'music_box/language/lang_' . $board_config['default_lang'] . '/lang_admin_music.' . $phpEx ) )
	{
		include( $module_root_path . 'music_box/language/lang_english/lang_admin_music.' . $phpEx );
	}
	else
	{
		include( $module_root_path . 'music_box/language/lang_' . $board_config['default_lang'] . '/lang_admin_music.' . $phpEx );
	}
}
else
{
	if ( file_exists( $module_root_path . 'language/lang_' . $board_config['default_lang'] . '/lang_admin_music.' . $phpEx ) )
	{
		include( $module_root_path . 'language/lang_' . $board_config['default_lang'] . '/lang_admin_music.' . $phpEx );
	}
	else if ( file_exists( $module_root_path . 'language/lang_english/lang_admin_music.' . $phpEx ) )
	{
		include( $module_root_path . 'language/lang_english/lang_admin_music.' . $phpEx );
	}
}


// --------------------------
// This function will sort the order of all categories
//
function mx_music_reorder_cat()
{
	global $db;

	$sql = "SELECT cat_id, cat_order
			FROM ". MUSIC_CAT_TABLE ."
			WHERE cat_id <> 0
			ORDER BY cat_order ASC";
	if( !$result = $db->sql_query($sql) )
	{
		message_die(GENERAL_ERROR, 'Could not get list of Categories', '', __LINE__, __FILE__, $sql);
	}

	$i = 10;

	while( $row = $db->sql_fetchrow($result) )
	{
		$sql = "UPDATE ". MUSIC_CAT_TABLE ."
				SET cat_order = $i
				WHERE cat_id = ". $row['cat_id'];
		if( !$db->sql_query($sql) )
		{
			message_die(GENERAL_ERROR, 'Could not update order fields', '', __LINE__, __FILE__, $sql);
		}
		$i += 10;
	}
}
// END
// --------------------------


if( !isset($HTTP_POST_VARS['mode']) )
{
	if( !isset($HTTP_GET_VARS['action']) )
	{
		$template->set_filenames(array(
			'body' => 'admin/music_cat_body.tpl')
		);

		$template->assign_vars(array(
			'L_MUSIC_CAT_TITLE' => $lang['Music_Categories_Title'],
			'L_MUSIC_CAT_EXPLAIN' => $lang['Music_Categories_Explain'],
			'S_MUSIC_ACTION' => append_sid("admin_music_cat.$phpEx"),
			'L_MOVE_UP' => $lang['Move_up'],
			'L_MOVE_DOWN' => $lang['Move_down'],
			'L_EDIT' => $lang['Edit'],
			'L_DELETE' => $lang['Delete'],
			'S_MODE' => 'new',
			'L_CREATE_MUSIC' => $lang['Create_music'],
			'L_CREATE_CATEGORY' => $lang['Create_category'])
		);

		$sql = "SELECT *
				FROM ". MUSIC_CAT_TABLE ."
				WHERE cat_parent = 0
				ORDER BY cat_order ASC";
		if(!$result = $db->sql_query($sql))
		{
			message_die(GENERAL_ERROR, 'Could not query music Categories information', '', __LINE__, __FILE__, $sql);
		}
		while ($row = $db->sql_fetchrow($result))
		{
			$catrow[] = $row;
		}

		for( $i = 0; $i < count($catrow); $i++ )
		{
			if ($catrow[$i]['cat_type'] != 0) 
			{ 
				$colspan = 1; 
				$add_sc = "<td class=\"" . (($i % 2) ? 'row1' : 'row2') . "\" align=\"center\">" . 
				"<form action=\"" . append_sid("admin_music_cat.$phpEx") . "\" method=\"post\"><input type=\"hidden\" value=\"new\" name=\"mode\" /><input type=\"hidden\" value=\"" . $catrow[$i]['cat_id'] . "\" name=\"cat_parent\"><input name=\"submit\" type=\"submit\" value=\"" . $lang['Create_sub_music'] . "\" class=\"liteoption\">" . 
				"</form></td>"; 
			} 
			else 
			{ 
				$colspan = 2; 
				$add_sc = ""; 
			}

			$template->assign_block_vars('catrow', array(
				'COLOR' => ($i % 2) ? 'row1' : 'row2',
				'TITLE' => $catrow[$i]['cat_title'],
				'DESC' => $catrow[$i]['cat_desc'],
				'COLSPAN' => $colspan, 
				'ADD_SC' => $add_sc,
				'S_MOVE_UP' => append_sid("admin_music_cat.$phpEx?action=move&amp;move=-15&amp;cat_id=" . $catrow[$i]['cat_id']),
				'S_MOVE_DOWN' => append_sid("admin_music_cat.$phpEx?action=move&amp;move=15&amp;cat_id=" . $catrow[$i]['cat_id']),
				'S_EDIT_ACTION' => append_sid("admin_music_cat.$phpEx?action=edit&amp;cat_id=" . $catrow[$i]['cat_id']),
				'S_DELETE_ACTION' => append_sid("admin_music_cat.$phpEx?action=delete&amp;cat_id=" . $catrow[$i]['cat_id'])
				)
			);

			if ($catrow[$i]['cat_type'] != 0) 
			{ 
				// this is a parent category 
				$sc_sql = "SELECT * 
									FROM ". MUSIC_CAT_TABLE ." 
									WHERE cat_parent = " . $catrow[$i]['cat_id'] . " 
									GROUP BY cat_id 
									ORDER BY cat_order ASC"; 
  
				if ( !($sc_result = $db->sql_query($sc_sql)) ) 
				{ 
					mx_message_die(GENERAL_ERROR, 'Could not query sub categories', '', __LINE__, __FILE__, $sc_sql); 
				}
 
				while ($subcatrow = $db->sql_fetchrow($sc_result)) 
				{ 
					$template->assign_block_vars('catrow', array( 
						'COLSPAN' => 2, 
						'ADD_SC' => '', 
						'COLOR' => ($i % 2) ? 'row1' : 'row2', 
						'TITLE' => "&nbsp;&nbsp;&nbsp;&nbsp;" . $subcatrow['cat_title'], 
						'DESC' => "&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;" . preg_replace("#\n#", "<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;", $subcatrow['cat_desc']), 
						'S_MOVE_UP' => append_sid("admin_music_cat.$phpEx?action=move&amp;move=-15&amp;cat_parent=" . $catrow[$i]['cat_id'] . "&amp;cat_id=" . $subcatrow['cat_id']), 
						'S_MOVE_UP' => append_sid("admin_music_cat.$phpEx?action=move&amp;move=15&amp;cat_parent=" . $catrow[$i]['cat_id'] . "&amp;cat_id=" . $subcatrow['cat_id']), 
						'S_EDIT_ACTION' => append_sid("admin_music_cat.$phpEx?action=edit&amp;cat_id=" . $subcatrow['cat_id']), 
						'S_DELETE_ACTION' => append_sid("admin_music_cat.$phpEx?action=delete&amp;cat_id=" . $subcatrow['cat_id']) 
						)); 
				} 
			} 
		}

		$template->pparse('body');

		include($mx_root_path . 'admin/page_footer_admin.'.$phpEx);
	}
	else
	{
		if( $HTTP_GET_VARS['action'] == 'edit' )
		{
			$cat_id = intval($HTTP_GET_VARS['cat_id']);

			$sql = "SELECT *
					FROM ". MUSIC_CAT_TABLE ."
					WHERE cat_id = '$cat_id'";
			if(!$result = $db->sql_query($sql))
			{
				message_die(GENERAL_ERROR, 'Could not query music Categories information', '', __LINE__, __FILE__, $sql);
			}
			if( $db->sql_numrows($result) == 0 )
			{
				message_die(GENERAL_ERROR, 'The requested category is not existed');
			}
			$catrow = $db->sql_fetchrow($result);

			$template->set_filenames(array(
				'body' => 'admin/music_cat_new_body.tpl')
			);

			$template->assign_vars(array(
				'L_MUSIC_CAT_TITLE' => $lang['Music_Categories_Title'],
				'L_MUSIC_CAT_EXPLAIN' => $lang['Music_Categories_Explain'],
				'S_MUSIC_ACTION' => append_sid("admin_music_cat.$phpEx?cat_id=$cat_id"),
				'L_CAT_TITLE' => $lang['Category_Title'],
				'L_CAT_DESC' => $lang['Category_Desc'],
				'L_CAT_PERMISSIONS' => $lang['Category_Permissions'],
				'L_VIEW_LEVEL' => $lang['View_level'],
				'L_UPLOAD_LEVEL' => $lang['Upload_level'],
				'L_RATE_LEVEL' => $lang['Rate_level'],
				'L_COMMENT_LEVEL' => $lang['Comment_level'],
				'L_EDIT_LEVEL' => $lang['Edit_level'],
				'L_DELETE_LEVEL' => $lang['Delete_level'],
				'L_SONGS_APPROVAL' => $lang['Songs_Approval'],
				'L_GUEST' => $lang['Forum_ALL'], 
				'L_REG' => $lang['Forum_REG'], 
				'L_PRIVATE' => $lang['Forum_PRIVATE'], 
				'L_MOD' => $lang['Forum_MOD'], 
				'L_ADMIN' => $lang['Forum_ADMIN'],

				'L_DISABLED' => $lang['Disabled'],

				'S_CAT_TITLE' => $catrow['cat_title'],
				'S_CAT_DESC' => $catrow['cat_desc'],

				'VIEW_GUEST' => ($catrow['cat_view_level'] == MUSIC_GUEST) ? 'selected="selected"' : '',
				'VIEW_REG' => ($catrow['cat_view_level'] == MUSIC_USER) ? 'selected="selected"' : '',
				'VIEW_PRIVATE' => ($catrow['cat_view_level'] == MUSIC_PRIVATE) ? 'selected="selected"' : '',
				'VIEW_MOD' => ($catrow['cat_view_level'] == MUSIC_MOD) ? 'selected="selected"' : '',
				'VIEW_ADMIN' => ($catrow['cat_view_level'] == MUSIC_ADMIN) ? 'selected="selected"' : '',

				'UPLOAD_GUEST' => ($catrow['cat_upload_level'] == MUSIC_GUEST) ? 'selected="selected"' : '',
				'UPLOAD_REG' => ($catrow['cat_upload_level'] == MUSIC_USER) ? 'selected="selected"' : '',
				'UPLOAD_PRIVATE' => ($catrow['cat_upload_level'] == MUSIC_PRIVATE) ? 'selected="selected"' : '',
				'UPLOAD_MOD' => ($catrow['cat_upload_level'] == MUSIC_MOD) ? 'selected="selected"' : '',
				'UPLOAD_ADMIN' => ($catrow['cat_upload_level'] == MUSIC_ADMIN) ? 'selected="selected"' : '',

				'RATE_GUEST' => ($catrow['cat_rate_level'] == MUSIC_GUEST) ? 'selected="selected"' : '',
				'RATE_REG' => ($catrow['cat_rate_level'] == MUSIC_USER) ? 'selected="selected"' : '',
				'RATE_PRIVATE' => ($catrow['cat_rate_level'] == MUSIC_PRIVATE) ? 'selected="selected"' : '',
				'RATE_MOD' => ($catrow['cat_rate_level'] == MUSIC_MOD) ? 'selected="selected"' : '',
				'RATE_ADMIN' => ($catrow['cat_rate_level'] == MUSIC_ADMIN) ? 'selected="selected"' : '',

				'COMMENT_GUEST' => ($catrow['cat_comment_level'] == MUSIC_GUEST) ? 'selected="selected"' : '',
				'COMMENT_REG' => ($catrow['cat_comment_level'] == MUSIC_USER) ? 'selected="selected"' : '',
				'COMMENT_PRIVATE' => ($catrow['cat_comment_level'] == MUSIC_PRIVATE) ? 'selected="selected"' : '',
				'COMMENT_MOD' => ($catrow['cat_comment_level'] == MUSIC_MOD) ? 'selected="selected"' : '',
				'COMMENT_ADMIN' => ($catrow['cat_comment_level'] == MUSIC_ADMIN) ? 'selected="selected"' : '',

				'EDIT_REG' => ($catrow['cat_edit_level'] == MUSIC_USER) ? 'selected="selected"' : '',
				'EDIT_PRIVATE' => ($catrow['cat_edit_level'] == MUSIC_PRIVATE) ? 'selected="selected"' : '',
				'EDIT_MOD' => ($catrow['cat_edit_level'] == MUSIC_MOD) ? 'selected="selected"' : '',
				'EDIT_ADMIN' => ($catrow['cat_edit_level'] == MUSIC_ADMIN) ? 'selected="selected"' : '',

				'DELETE_REG' => ($catrow['cat_delete_level'] == MUSIC_USER) ? 'selected="selected"' : '',
				'DELETE_PRIVATE' => ($catrow['cat_delete_level'] == MUSIC_PRIVATE) ? 'selected="selected"' : '',
				'DELETE_MOD' => ($catrow['cat_delete_level'] == MUSIC_MOD) ? 'selected="selected"' : '',
				'DELETE_ADMIN' => ($catrow['cat_delete_level'] == MUSIC_ADMIN) ? 'selected="selected"' : '',

				'APPROVAL_DISABLED' => ($catrow['cat_approval'] == MUSIC_USER) ? 'selected="selected"' : '',
				'APPROVAL_MOD' => ($catrow['cat_approval'] == MUSIC_MOD) ? 'selected="selected"' : '',
				'APPROVAL_ADMIN' => ($catrow['cat_approval'] == MUSIC_ADMIN) ? 'selected="selected"' : '',

				'S_MODE' => 'edit',

				'S_GUEST' => MUSIC_GUEST,
				'S_USER' => MUSIC_USER,
				'S_PRIVATE' => MUSIC_PRIVATE,
				'S_MOD' => MUSIC_MOD,
				'S_ADMIN' => MUSIC_ADMIN,

				'L_PANEL_TITLE' => $lang['Edit_Category'])
			);

			$template->pparse('body');

			include($mx_root_path . 'admin/page_footer_admin.'.$phpEx);
		}
		else if( $HTTP_GET_VARS['action'] == 'delete' )
		{
			$cat_id = intval($HTTP_GET_VARS['cat_id']);

			$sql = "SELECT cat_id, cat_title, cat_order
					FROM ". MUSIC_CAT_TABLE ."
					ORDER BY cat_order ASC";
			if(!$result = $db->sql_query($sql))
			{
				message_die(GENERAL_ERROR, 'Could not query music Categories information', '', __LINE__, __FILE__, $sql);
			}

			$cat_found = FALSE;
			while( $row = $db->sql_fetchrow($result) )
			{
				if( $row['cat_id'] == $cat_id )
				{
					$thiscat = $row;
					$cat_found = TRUE;
				}
				else
				{
					$catrow[] = $row;
				}
			}
			if( $cat_found == FALSE )
			{
				message_die(GENERAL_ERROR, 'The requested category is not existed');
			}

			$select_to = '<select name="target"><option value="0">'. $lang['Delete_all_songs'] .'</option>';
			for ($i = 0; $i < count($catrow); $i++)
			{
				$select_to .= '<option value="'. $catrow[$i]['cat_id'] .'">'. $catrow[$i]['cat_title'] .'</option>';
			}
			$select_to .= '</select>';

			$template->set_filenames(array(
				'body' => 'admin/music_cat_delete_body.tpl')
			);

			$template->assign_vars(array(
				'S_MUSIC_ACTION' => append_sid("admin_music_cat.$phpEx?cat_id=$cat_id"),
				'L_CAT_DELETE' => $lang['Delete_Category'],
				'L_CAT_DELETE_EXPLAIN' => $lang['Delete_Category_Explain'],
				'L_CAT_TITLE' => $lang['Category_Title'],
				'S_CAT_TITLE' => $thiscat['cat_title'],
				'L_MOVE_CONTENTS' => $lang['Move_contents'],
				'L_MOVE_DELETE' => $lang['Move_and_Delete'],
				'S_SELECT_TO' => $select_to)
			);

			$template->pparse('body');

			include($mx_root_path . 'admin/page_footer_admin.'.$phpEx);
		}
		else if( $HTTP_GET_VARS['action'] == 'move' )
		{
			$cat_id = intval($HTTP_GET_VARS['cat_id']);
			$move = intval($HTTP_GET_VARS['move']);

			$sql = "UPDATE ". MUSIC_CAT_TABLE ."
					SET cat_order = cat_order + $move
					WHERE cat_id = $cat_id";
			if( !$result = $db->sql_query($sql) )
			{
				message_die(GENERAL_ERROR, 'Could not change category order', '', __LINE__, __FILE__, $sql);
			}

			mx_music_reorder_cat();

			// Return a message...
			$message = $lang['Category_changed_order'] . "<br /><br />" . sprintf($lang['Click_return_music_category'], "<a href=\"" . append_sid("admin_music_cat.$phpEx") . "\">", "</a>") . "<br /><br />" . sprintf($lang['Click_return_admin_index'], "<a href=\"" . append_sid("index.$phpEx?pane=right") . "\">", "</a>");

			message_die(GENERAL_MESSAGE, $message);
		}
	}
}
else 
{ 
	if(( $HTTP_POST_VARS['mode'] == 'new' ) || ($HTTP_POST_VARS['mode'] == 'newcat')) 
	{
		if( !isset($HTTP_POST_VARS['cat_title']) )
		{
			$template->set_filenames(array(
				'body' => 'admin/music_cat_new_body.tpl')
			);

			if ( !isset($HTTP_POST_VARS['cat_parent']) ) 
			{ 
                                $cat_parent = ""; 
			} 
			else 
			{ 
                                $cat_parent = "<input type=\"hidden\" value=\"" . $HTTP_POST_VARS['cat_parent'] . "\" name=\"cat_parent\">"; 
			} 
  
			if ($HTTP_POST_VARS['mode'] == 'newcat') 
			{ 
                                $cat_type = "<input type=\"hidden\" value=\"1\" name=\"cat_type\">"; 
			}

			$template->assign_vars(array(
				'L_MUSIC_CAT_TITLE' => $lang['Music_Categories_Title'],
				'L_MUSIC_CAT_EXPLAIN' => $lang['Music_Categories_Explain'],
				'S_MUSIC_ACTION' => append_sid("admin_music_cat.$phpEx"),
				'L_CAT_TITLE' => $lang['Category_Title'],
				'L_CAT_DESC' => $lang['Category_Desc'],
				'L_CAT_PERMISSIONS' => $lang['Category_Permissions'],
				'L_VIEW_LEVEL' => $lang['View_level'],
				'L_UPLOAD_LEVEL' => $lang['Upload_level'],
				'L_RATE_LEVEL' => $lang['Rate_level'],
				'L_COMMENT_LEVEL' => $lang['Comment_level'],
				'L_EDIT_LEVEL' => $lang['Edit_level'],
				'L_DELETE_LEVEL' => $lang['Delete_level'],
				'L_SONGS_APPROVAL' => $lang['Songs_Approval'],
				'L_GUEST' => $lang['Forum_ALL'], 
				'L_REG' => $lang['Forum_REG'], 
				'L_PRIVATE' => $lang['Forum_PRIVATE'], 
				'L_MOD' => $lang['Forum_MOD'], 
				'L_ADMIN' => $lang['Forum_ADMIN'],

				'L_DISABLED' => $lang['Disabled'],

				'VIEW_GUEST' => 'selected="selected"',
				'UPLOAD_REG' => 'selected="selected"',
				'RATE_REG' => 'selected="selected"',
				'COMMENT_REG' => 'selected="selected"',
				'EDIT_REG' => 'selected="selected"',
				'DELETE_MOD' => 'selected="selected"',
				'APPROVAL_DISABLED' => 'selected="selected"',

				'S_MODE' => 'new',

				'S_GUEST' => MUSIC_GUEST,
				'S_USER' => MUSIC_USER,
				'S_PRIVATE' => MUSIC_PRIVATE,
				'S_MOD' => MUSIC_MOD,
				'S_ADMIN' => MUSIC_ADMIN,

				'CAT_PARENT' => $cat_parent, 
				'CAT_TYPE' => $cat_type, 

				'L_PANEL_TITLE' => $lang['Create_category'])
			);

			$template->pparse('body');

			include($mx_root_path . 'admin/page_footer_admin.'.$phpEx);
		}
		else
		{
			// Get posting variables

			if ( !isset($HTTP_POST_VARS['cat_parent']) ) 
			{ 
                                $cat_parent = 0; 
			} 
			else 
			{ 
                                $cat_parent = intval($HTTP_POST_VARS['cat_parent']); 
			} 
			if ( !isset($HTTP_POST_VARS['cat_type']) ) 
			{ 
                                $cat_type = 0; 
			} 
			else 
			{ 
                                $cat_type = 1; 
			}
 
			$cat_title = str_replace("\'", "''", htmlspecialchars(trim($HTTP_POST_VARS['cat_title'])));
			$cat_desc = str_replace("\'", "''", trim($HTTP_POST_VARS['cat_desc']));
			$view_level = intval($HTTP_POST_VARS['cat_view_level']);
			$upload_level = intval($HTTP_POST_VARS['cat_upload_level']);
			$rate_level = intval($HTTP_POST_VARS['cat_rate_level']);
			$comment_level = intval($HTTP_POST_VARS['cat_comment_level']);
			$edit_level = intval($HTTP_POST_VARS['cat_edit_level']);
			$delete_level = intval($HTTP_POST_VARS['cat_delete_level']);
			$cat_approval = intval($HTTP_POST_VARS['cat_approval']);

			// Get the last ordered category
			$sql = "SELECT cat_order FROM ". MUSIC_CAT_TABLE ."
					ORDER BY cat_order DESC
					LIMIT 1";
			if(!$result = $db->sql_query($sql))
			{
				message_die(GENERAL_ERROR, 'Could not query music Categories information', '', __LINE__, __FILE__, $sql);
			}
			$row = $db->sql_fetchrow($result);
			$last_order = $row['cat_order'];
			$cat_order = $last_order + 10;

			// Here we insert a new row into the db
			$sql = "INSERT INTO ". MUSIC_CAT_TABLE ." (cat_title, cat_desc, cat_order, cat_view_level, cat_upload_level, cat_rate_level, cat_comment_level, cat_edit_level, cat_delete_level, cat_approval, cat_parent, cat_type)
					VALUES ('$cat_title', '$cat_desc', '$cat_order', '$view_level', '$upload_level', '$rate_level', '$comment_level', '$edit_level', '$delete_level', '$cat_approval', $cat_parent, $cat_type)";
			if(!$result = $db->sql_query($sql))
			{
				message_die(GENERAL_ERROR, 'Could not create new music Category', '', __LINE__, __FILE__, $sql);
			}

			// Return a message...
			$message = $lang['New_category_created'] . "<br /><br />" . sprintf($lang['Click_return_music_category'], "<a href=\"" . append_sid("admin_music_cat.$phpEx") . "\">", "</a>") . "<br /><br />" . sprintf($lang['Click_return_admin_index'], "<a href=\"" . append_sid("index.$phpEx?pane=right") . "\">", "</a>");

			message_die(GENERAL_MESSAGE, $message);
		}
	}
	else if( $HTTP_POST_VARS['mode'] == 'edit' )
	{
		// Get posting variables
		$cat_id = intval($HTTP_GET_VARS['cat_id']);
		$cat_title = str_replace("\'", "''", htmlspecialchars(trim($HTTP_POST_VARS['cat_title'])));
		$cat_desc = str_replace("\'", "''", trim($HTTP_POST_VARS['cat_desc']));
		$view_level = intval($HTTP_POST_VARS['cat_view_level']);
		$upload_level = intval($HTTP_POST_VARS['cat_upload_level']);
		$rate_level = intval($HTTP_POST_VARS['cat_rate_level']);
		$comment_level = intval($HTTP_POST_VARS['cat_comment_level']);
		$edit_level = intval($HTTP_POST_VARS['cat_edit_level']);
		$delete_level = intval($HTTP_POST_VARS['cat_delete_level']);
		$cat_approval = intval($HTTP_POST_VARS['cat_approval']);

		// Now we update this row
		$sql = "UPDATE ". MUSIC_CAT_TABLE ."
				SET cat_title = '$cat_title', cat_desc = '$cat_desc', cat_view_level = '$view_level', cat_upload_level = '$upload_level', cat_rate_level = '$rate_level', cat_comment_level = '$comment_level', cat_edit_level = '$edit_level', cat_delete_level = '$delete_level', cat_approval = '$cat_approval'
				WHERE cat_id = '$cat_id'";
		if(!$result = $db->sql_query($sql))
		{
			message_die(GENERAL_ERROR, 'Could not update this music Category', '', __LINE__, __FILE__, $sql);
		}

		// Return a message...
		$message = $lang['Category_updated'] . "<br /><br />" . sprintf($lang['Click_return_music_category'], "<a href=\"" . append_sid("admin_music_cat.$phpEx") . "\">", "</a>") . "<br /><br />" . sprintf($lang['Click_return_admin_index'], "<a href=\"" . append_sid("index.$phpEx?pane=right") . "\">", "</a>");

		message_die(GENERAL_MESSAGE, $message);
	}
	else if( $HTTP_POST_VARS['mode'] == 'delete' )
	{
		$cat_id = intval($HTTP_GET_VARS['cat_id']);
		$target = intval($HTTP_POST_VARS['target']);

		if( $target == 0 ) // Delete All
		{
			// Get file information of all songs in this category
			$sql = "SELECT song_id, song_filename, song_cat_id
					FROM ". MUSIC_TABLE ."
					WHERE song_cat_id = '$cat_id'";
			if(!$result = $db->sql_query($sql))
			{
				message_die(GENERAL_ERROR, 'Could not query music information', '', __LINE__, __FILE__, $sql);
			}
			$songrow = array();
			while( $row = $db ->sql_fetchrow($result) )
			{
				$songrow[] = $row;
				$song_id_row[] = $row['song_id'];
			}

			if( count($songrow) != 0 ) // if this category is not empty
			{
				// Delete all physical song 
				for ($i = 0; $i < count($songrow); $i++)
				{
					@unlink('../' . MUSIC_UPLOAD_PATH . $songrow[$i]['song_filename']);
				}

				$song_id_sql = '(' . implode(',', $song_id_row) . ')';

				// Delete all related ratings
				$sql = "DELETE FROM ". MUSIC_RATE_TABLE ."
						WHERE rate_song_id IN ". $song_id_sql;
				if(!$result = $db->sql_query($sql))
				{
					message_die(GENERAL_ERROR, 'Could not delete Ratings information', '', __LINE__, __FILE__, $sql);
				}

				// Delete all related comments
				$sql = "DELETE FROM ". MUSIC_COMMENT_TABLE ."
						WHERE comment_song_id IN ". $song_id_sql;
				if(!$result = $db->sql_query($sql))
				{
					message_die(GENERAL_ERROR, 'Could not delete Comments information', '', __LINE__, __FILE__, $sql);
				}

				// Delete song entries in db
				$sql = "DELETE FROM ". MUSIC_TABLE ."
						WHERE song_cat_id = '$cat_id'";
				if(!$result = $db->sql_query($sql))
				{
					message_die(GENERAL_ERROR, 'Could not delete song entries in the DB', '', __LINE__, __FILE__, $sql);
				}
			}

			// This category is now emptied, we can remove it!
			$sql = "DELETE FROM ". MUSIC_CAT_TABLE ."
					WHERE cat_id = '$cat_id'";
			if(!$result = $db->sql_query($sql))
			{
				message_die(GENERAL_ERROR, 'Could not delete this Category', '', __LINE__, __FILE__, $sql);
			}

			// Re-order the rest of categories
			mx_music_reorder_cat();

			// Return a message...
			$message = $lang['Category_deleted'] . "<br /><br />" . sprintf($lang['Click_return_music_category'], "<a href=\"" . append_sid("admin_music_cat.$phpEx") . "\">", "</a>") . "<br /><br />" . sprintf($lang['Click_return_admin_index'], "<a href=\"" . append_sid("index.$phpEx?pane=right") . "\">", "</a>");

			message_die(GENERAL_MESSAGE, $message);
		}
		else // Move content...
		{
			$sql = "UPDATE ". MUSIC_TABLE ."
					SET song_cat_id = '$target'
					WHERE song_cat_id = '$cat_id'";
			if(!$result = $db->sql_query($sql))
			{
				message_die(GENERAL_ERROR, 'Could not update this Category content', '', __LINE__, __FILE__, $sql);
			}

			// This category is now emptied, we can remove it!
			$sql = "DELETE FROM ". MUSIC_CAT_TABLE ."
					WHERE cat_id = '$cat_id'";
			if(!$result = $db->sql_query($sql))
			{
				message_die(GENERAL_ERROR, 'Could not delete this Category', '', __LINE__, __FILE__, $sql);
			}

			// Re-order the rest of categories
			mx_music_reorder_cat();

			// Return a message...
			$message = $lang['Category_deleted'] . "<br /><br />" . sprintf($lang['Click_return_music_category'], "<a href=\"" . append_sid("admin_music_cat.$phpEx") . "\">", "</a>") . "<br /><br />" . sprintf($lang['Click_return_admin_index'], "<a href=\"" . append_sid("index.$phpEx?pane=right") . "\">", "</a>");

			message_die(GENERAL_MESSAGE, $message);
		}
	}
}

/* Powered by Music Online 2.0 (c) 2003 Cf Manager */

?>
--- NEW FILE: admin_music_cfg.php ---
<?php
/**
*
* @package mxBB Portal Module - mx_music
* @version $Id: admin_music_cfg.php,v 1.1.2.1 2008/03/08 15:42:59 orynider Exp $
* @copyright (c) 2003 [ory...@rd..., OryNider] mxBB Development Team
* @license http://opensource.org/licenses/gpl-license.php GNU General Public License v2
*
*/

$phpEx = substr(strrchr(__FILE__, '.'), 1);

if ( @file_exists( './../viewtopic.' . $phpEx ) ) // -------------------------------------------- phpBB MOD MODE
{
	define('MXBB_MODULE', false);
	define('IN_PHPBB', true);
	
	$phpbb_root_path = $module_root_path = './../';
	$mx_mod_path = $phpbb_root_path . 'mx_mod/';
	
	require_once($mx_mod_path . "includes/functions_required.$phpEx");
	
	@define('IN_PORTAL', true);
	
	//Check if forum_hack is installed
	if (!isset($mx_root_path))
	{
		$mx_root_path = './../';

		include_once($mx_mod_path . "includes/mx_constants.$phpEx");
		include_once($mx_mod_path . "includes/shared/phpbb2/includes/functions.$phpEx");
	}
	
	require_once($mx_mod_path . "includes/functions_core.$phpEx");
	
	//Check for cash mod
	if (file_exists($phpbb_root_path . 'includes/functions_cash.'.$phpEx))
	{
		define('IN_CASHMOD', true);
	}

	//@ini_set( 'display_errors', '1' );
	error_reporting (E_ERROR | E_WARNING | E_PARSE); // This will NOT report uninitialized variables
	//error_reporting(E_ALL & ~E_NOTICE);

	define( 'PAGE_KB', -502 ); // If this id generates a conflict with other mods, change it ;)

	//
	// Instatiate the mx_cache class
	//
	$mx_cache = new mx_cache();
	
	//
	// instatiate the mx_request_vars class
	//
	$mx_request_vars = new mx_request_vars();
	

	//
	// instatiate the mx_user class
	//
	//$mx_user = new mx_user();

	//
	// Left Pane Paths
	//
	$setmodules_admin_path = '';
	$setmodules_module_path = "./../";
	
	if (file_exists($phpbb_root_path."modcp.$phpEx")) // phpBB2
	{
		define('PORTAL_BACKEND', 'phpbb2');
		$tplEx = 'tpl';
	}
	else if (@file_exists($phpbb_root_path."mcp.$phpEx")) // phpBB3
	{
		define('PORTAL_BACKEND', 'phpbb3');
		$tplEx = 'html';
	}
}
else
{
	define( 'IN_PORTAL', 1 );
	define( 'MXBB_MODULE', true );

	//
	// Main paths
	//
	$mx_root_path = './../../../';
	$module_root_path = './../../../modules/mx_music/';

	$setmodules_admin_path = 'modules/mx_linkdb/admin/';

	define( 'MXBB_27x', file_exists( $mx_root_path . 'mx_login.php' ) );

	$phpEx = substr(strrchr(__FILE__, '.'), 1);
}

if ( !empty( $setmodules ) )
{
	$file = basename( __FILE__ );
	$module['Music_Online']['Configuration'] = $setmodules_admin_path . $file;
	return;
}

$music_root_path = $module_root_path . 'music_box/';

//
// Get general information
//
require($mx_root_path . 'admin/pagestart.' . $phpEx);

if ( !MXBB_MODULE )
{
	require_once($mx_mod_path . "includes/functions_styles.$phpEx");

	$mx_user = new mx_user();	// instatiate the mx_user class
	
	//
	// Define basic constants
	//
	$mx_user->page_id = 1;
	$mx_user->user_ip = $user_ip;
	$mx_user->_init_userprefs();
}

require($music_root_path . 'music_common.'.$phpEx);


// **********************************************************************
// Read language definition
// **********************************************************************
if ( !MXBB_MODULE )
{
	if ( !file_exists( $module_root_path . 'music_box/language/lang_' . $board_config['default_lang'] . '/lang_admin_music.' . $phpEx ) )
	{
		include( $module_root_path . 'music_box/language/lang_english/lang_admin_music.' . $phpEx );
	}
	else
	{
		include( $module_root_path . 'music_box/language/lang_' . $board_config['default_lang'] . '/lang_admin_music.' . $phpEx );
	}
}
else
{
	if ( file_exists( $module_root_path . 'language/lang_' . $board_config['default_lang'] . '/lang_admin_music.' . $phpEx ) )
	{
		include( $module_root_path . 'language/lang_' . $board_config['default_lang'] . '/lang_admin_music.' . $phpEx );
	}
	else if ( file_exists( $module_root_path . 'language/lang_english/lang_admin_music.' . $phpEx ) )
	{
		include( $module_root_path . 'language/lang_english/lang_admin_music.' . $phpEx );
	}
}


//
// Pull all config data
//
$sql = "SELECT * FROM " . MUSIC_CONFIG_TABLE;
if(!$result = $db->sql_query($sql))
{
	message_die(CRITICAL_ERROR, "Could not query music config information", "", __LINE__, __FILE__, $sql);
}
else
{
	while( $row = $db->sql_fetchrow($result) )
	{
		$config_name = $row['config_name'];
		$config_value = $row['config_value'];
		$default_config[$config_name] = $config_value;

		$new[$config_name] = ( isset($HTTP_POST_VARS[$config_name]) ) ? $HTTP_POST_VARS[$config_name] : $default_config[$config_name];

		if( isset($HTTP_POST_VARS['submit']) )
		{
			$sql = "UPDATE " . MUSIC_CONFIG_TABLE . " SET
				config_value = '" . str_replace("\'", "''", $new[$config_name]) . "'
				WHERE config_name = '$config_name'";
			if( !$db->sql_query($sql) )
			{
				message_die(GENERAL_ERROR, "Failed to update music configuration for $config_name", "", __LINE__, __FILE__, $sql);
			}
		}
	}

	if( isset($HTTP_POST_VARS['submit']) )
	{
		$message = $lang['Music_config_updated'] . "<br /><br />" . sprintf($lang['Click_return_music_config'], "<a href=\"" . append_sid("admin_music_cfg.$phpEx") . "\">", "</a>") . "<br /><br />" . sprintf($lang['Click_return_admin_index'], "<a href=\"" . append_sid($mx_root_path . "admin/index.$phpEx?pane=right") . "\">", "</a>");

		message_die(GENERAL_MESSAGE, $message);
	}
}

$template->set_filenames(array(
	"body" => "admin/music_config_body.tpl")
);

$template->assign_vars(array(
	'L_MUSIC_CONFIG' => $lang['Music_config'],
	'L_MUSIC_CONFIG_EXPLAIN' => $lang['Music_config_explain'],
	'S_MUSIC_CONFIG_ACTION' => append_sid('admin_music_cfg.'.$phpEx),

	'MAX_SONGS' => $new['max_songs'],
	'MAX_FILE_SIZE' => $new['max_file_size'],
	'ROWS_PER_PAGE' => $new['rows_per_page'],
	'COLS_PER_PAGE' => $new['cols_per_page'],
	'TOP' => $new['top'],

	// eXtreme Styles
	'XS_ENABLED' => ($new['xs_enabled'] == 1) ? 'checked="checked"' : '',
	'XS_DISABLED' => ($new['xs_enabled'] == 0) ? 'checked="checked"' : '',

	'ROWS_PER_PAGE_PIC' => $new['rows_per_page_pic'],
	'COLS_PER_PAGE_PIC' => $new['cols_per_page_pic'],

	'ROWS_PER_PAGE_MEDIA' => $new['rows_per_page_media'],
	'COLS_PER_PAGE_MEDIA' => $new['cols_per_page_media'],

	// Index
	'INDEX_SHOW_SUBCATS_ENABLED' => ($new['show_index_subcats'] == 1) ? 'checked="checked"' : '',
	'INDEX_SHOW_SUBCATS_DISABLED' => ($new['show_index_subcats'] == 0) ? 'checked="checked"' : '',

	//
	// Song image
	//
	'MAX_IMAGE_SIZE' => $new['max_image_size'],
	'MAX_IMAGE_WIDTH' => $new['max_image_width'],
	'MAX_IMAGE_HEIGHT' => $new['max_image_height'],

	'USER_SONGS_LIMIT' => $new['user_songs_limit'],
	'MOD_SONGS_LIMIT' => $new['mod_songs_limit'],

	'MP3_ENABLED' => ($new['mp3_allowed'] == 1) ? 'checked="checked"' : '',
	'MP3_DISABLED' => ($new['mp3_allowed'] == 0) ? 'checked="checked"' : '',

	'WAV_ENABLED' => ($new['wav_allowed'] == 1) ? 'checked="checked"' : '',
	'WAV_DISABLED' => ($new['wav_allowed'] == 0) ? 'checked="checked"' : '',

	'WMA_ENABLED' => ($new['wma_allowed'] == 1) ? 'checked="checked"' : '',
	'WMA_DISABLED' => ($new['wma_allowed'] == 0) ? 'checked="checked"' : '',

	// Media Center
	'WMV_ENABLED' => ($new['wmv_allowed'] == 1) ? 'checked="checked"' : '',
	'WMV_DISABLED' => ($new['wmv_allowed'] == 0) ? 'checked="checked"' : '',

	'MIDI_ENABLED' => ($new['mid_allowed'] == 1) ? 'checked="checked"' : '',
	'MIDI_DISABLED' => ($new['mid_allowed'] == 0) ? 'checked="checked"' : '',

	'RAM_ENABLED' => ($new['ram_allowed'] == 1) ? 'checked="checked"' : '',
	'RAM_DISABLED' => ($new['ram_allowed'] == 0) ? 'checked="checked"' : '',

	'AU_ENABLED' => ($new['au_allowed'] == 1) ? 'checked="checked"' : '',
	'AU_DISABLED' => ($new['au_allowed'] == 0) ? 'checked="checked"' : '',

	'MPEG_ENABLED' => ($new['mpeg_allowed'] == 1) ? 'checked="checked"' : '',
	'MPEG_DISABLED' => ($new['mpeg_allowed'] == 0) ? 'checked="checked"' : '',

	'AVI_ENABLED' => ($new['avi_allowed'] == 1) ? 'checked="checked"' : '',
	'AVI_DISABLED' => ($new['avi_allowed'] == 0) ? 'checked="checked"' : '',

	'SWF_ENABLED' => ($new['swf_allowed'] == 1) ? 'checked="checked"' : '',
	'SWF_DISABLED' => ($new['swf_allowed'] == 0) ? 'checked="checked"' : '',

	'QT_ENABLED' => ($new['qt_allowed'] == 1) ? 'checked="checked"' : '',
	'QT_DISABLED' => ($new['qt_allowed'] == 0) ? 'checked="checked"' : '',

	'FLV_ENABLED' => ($new['flv_allowed'] == 1) ? 'checked="checked"' : '',
	'FLV_DISABLED' => ($new['flv_allowed'] == 0) ? 'checked="checked"' : '',

	'RM_ENABLED' => ($new['rm_allowed'] == 1) ? 'checked="checked"' : '',
	'RM_DISABLED' => ($new['rm_allowed'] == 0) ? 'checked="checked"' : '',

	'IMG_ENABLED' => ($new['img_allowed'] == 1) ? 'checked="checked"' : '',
	'IMG_DISABLED' => ($new['img_allowed'] == 0) ? 'checked="checked"' : '',

	// Media Center
	'SONG_DESC_MAX_LENGTH' => $new['desc_length'],

	'HOTLINK_PREVENT_ENABLED' => ($new['hotlink_prevent'] == 1) ? 'checked="checked"' : '',
	'HOTLINK_PREVENT_DISABLED' => ($new['hotlink_prevent'] == 0) ? 'checked="checked"' : '',

	'HOTLINK_ALLOWED' => $new['hotlink_allowed'],

	'RATE_ENABLED' => ($new['rate'] == 1) ? 'checked="checked"' : '',
	'RATE_DISABLED' => ($new['rate'] == 0) ? 'checked="checked"' : '',

	'RATE_SCALE' => $new['rate_scale'],

	'COMMENT_ENABLED' => ($new['comment'] == 1) ? 'checked="checked"' : '',
	'COMMENT_DISABLED' => ($new['comment'] == 0) ? 'checked="checked"' : '',

	'DOWNLOAD_ENABLED' => ($new['download'] == 1) ? 'checked="checked"' : '',
	'DOWNLOAD_DISABLED' => ($new['download'] == 0) ? 'checked="checked"' : '',

	'SORT_TIME' => ($new['sort_method'] == 'song_time') ? 'selected="selected"' : '',
	'SORT_SONG_TITLE' => ($new['sort_method'] == 'song_title') ? 'selected="selected"' : '',
	'SORT_USERNAME' => ($new['sort_method'] == 'song_user_id') ? 'selected="selected"' : '',
	'SORT_VIEW' => ($new['sort_method'] == 'song_view_count') ? 'selected="selected"' : '',
	'SORT_RATING' => ($new['sort_method'] == 'rating') ? 'selected="selected"' : '',
	'SORT_COMMENTS' => ($new['sort_method'] == 'comments') ? 'selected="selected"' : '',
	'SORT_NEW_COMMENT' => ($new['sort_method'] == 'new_comment') ? 'selected="selected"' : '',

	'SORT_ASC' => ($new['sort_order'] == 'ASC') ? 'selected="selected"' : '',
	'SORT_DESC' => ($new['sort_order'] == 'DESC') ? 'selected="selected"' : '',

	'S_GUEST' => MUSIC_GUEST,
	'S_USER' => MUSIC_USER,
	'S_PRIVATE' => MUSIC_PRIVATE,
	'S_MOD' => MUSIC_MOD,
	'S_ADMIN' => MUSIC_ADMIN,

	'L_MAX_SONGS' => $lang['Max_songs'],
	'L_MAX_FILE_SIZE' => $lang['Max_file_size'],
	'L_USER_SONGS_LIMIT' => $lang['User_songs_limit'],
	'L_MOD_SONGS_LIMIT' => $lang['Moderator_songs_limit'],
	'L_ROWS_PER_PAGE' => $lang['Rows_per_page'],
	'L_COLS_PER_PAGE' => $lang['Cols_per_page'],
	'L_ROWS_PER_PAGE_PIC' => $lang['Rows_per_page_music_pic_cat'],
	'L_COLS_PER_PAGE_PIC' => $lang['Cols_per_page_music_pic_cat'],
	'L_ROWS_PER_PAGE_MEDIA' => $lang['Rows_per_page_music_media_cat'],
	'L_COLS_PER_PAGE_MEDIA' => $lang['Cols_per_page_music_media_cat'],
	'L_TOP' => $lang['Top'],

	//Index
	'L_INDEX_SETTINGS' => $lang['Music_Index_Settings'],
	'L_INDEX_SHOW_SUBCATS' => $lang['Show_Index_Subcats'],

	//
	// Lang Song image
	//
	'L_MAX_IMAGE_SIZE' => $lang['Max_image_size'],
	'L_MAX_IMAGE_WIDTH' => $lang['Max_image_width'],
	'L_MAX_IMAGE_HEIGHT' => $lang['Max_image_height'],

	// Media Center Allowed FileTypes
	'L_MP3_ALLOWED' => $lang['MP3_allowed'],
	'L_WAV_ALLOWED' => $lang['WAV_allowed'],
	'L_WMA_ALLOWED' => $lang['WMA_allowed'],
	'L_WMV_ALLOWED' => $lang['WMV_allowed'],
	'L_MIDI_ALLOWED' => $lang['MIDI_allowed'],
	'L_RAM_ALLOWED' => $lang['RAM_allowed'],
	'L_AU_ALLOWED' => $lang['AU_allowed'],
	'L_MPEG_ALLOWED' => $lang['MPEG_allowed'],
	'L_AVI_ALLOWED' => $lang['AVI_allowed'],
	'L_SWF_ALLOWED' => $lang['SWF_allowed'],
	'L_QT_ALLOWED' => $lang['QT_allowed'],
	'L_FLV_ALLOWED' => $lang['FLV_allowed'],
	'L_RM_ALLOWED' => $lang['RM_allowed'],
	'L_IMG_ALLOWED' => $lang['IMG_allowed'],
	// Media Center Allowed FileTypes

	'L_SONG_DESC_MAX_LENGTH' => $lang['Song_Desc_Max_Length'],
	'L_HOTLINK_PREVENT' => $lang['Hotlink_prevent'],
	'L_HOTLINK_ALLOWED' => $lang['Hotlink_allowed'],
	'L_RATE_SYSTEM' => $lang['Rate_system'],
	'L_RATE_SCALE' => $lang['Rate_Scale'],
	'L_COMMENT_SYSTEM' => $lang['Comment_system'],
	'L_DOWNLOAD_SYSTEM' => $lang['Download_system'],
	'L_EXTRA_SETTINGS' => $lang['Extra_Settings'],
	'L_DEFAULT_SORT_METHOD' => $lang['Default_Sort_Method'],
	'L_TIME' => $lang['Time'],
	'L_SONG_TITLE' => $lang['Song_Title'],
	'L_USERNAME' => $lang['Sort_Username'],
	'L_VIEW' => $lang['View'],
	'L_RATING' => $lang['Rating'],
	'L_COMMENTS' => $lang['Comments'],
	'L_DOWNLOAD' => $lang['Download'],
	'L_NEW_COMMENT' => $lang['New_Comment'],
	'L_DEFAULT_SORT_ORDER' => $lang['Default_Sort_Order'],
	'L_ASC' => $lang['Sort_Ascending'],
	'L_DESC' => $lang['Sort_Descending'],
	'L_GUEST' => $lang['Forum_ALL'], 
	'L_REG' => $lang['Forum_REG'], 
	'L_PRIVATE' => $lang['Forum_PRIVATE'], 
	'L_MOD' => $lang['Forum_MOD'], 
	'L_ADMIN' => $lang['Forum_ADMIN'],

	'L_DISABLED' => $lang['Disabled'],
	'L_ENABLED' => $lang['Enabled'],
	'L_YES' => $lang['Yes'],
	'L_NO' => $lang['No'],
	'L_SUBMIT' => $lang['Submit'],
	'L_RESET' => $lang['Reset'])
);

$template->pparse("body");

include($mx_root_path . 'admin/page_footer_admin.'.$phpEx);

/* Powered by Music Online 2.0 (c) 2003 Cf Manager */

?>