[mxbb-commits] mx_music/admin admin_music_auth.php, NONE, 1.1 admin_music_cat.php, NONE, 1.1 admin_music_cfg.php, NONE, 1.1 admin_music_ext.php, NONE, 1.1

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

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

Added Files:
	admin_music_auth.php admin_music_cat.php admin_music_cfg.php 
	admin_music_ext.php 
Log Message:


--- NEW FILE: admin_music_ext.php ---
<?php
/**
*
* @package mxBB Portal Module - mx_music
* @version $Id: admin_music_ext.php,v 1.1 2007/06/06 20:32:21 orynider Exp $
* @copyright (c) 2002-2006 [Markus, Jon Ohlsson] mxBB Project Team
* @license http://opensource.org/licenses/gpl-license.php GNU General Public License v2
*
*/

define( 'IN_PORTAL', 1 );

if ( !empty( $setmodules ) )
{
	$file = basename( __FILE__ );
	$module['Music_Online']['Configuration ext'] = 'modules/mx_music/admin/' . $file;
	return;
}

//
// Let's set the root dir for phpBB
//
$module_root_path = '../';
$mx_root_path = '../../../';
$music_root_path = $module_root_path . 'music_box/';
$phpEx = substr(strrchr(__FILE__, '.'), 1); 

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

//
// Get general music information
//
include($music_root_path . 'music_common.'.$phpEx);
// include_once( $module_root_path . 'music_box/music_constants.'.$phpEx );

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

//
// Mode setting
//
$mode = $mx_request_vars->request('mode', MX_TYPE_NO_TAGS, '');

//
// Main db settings
// Pull all config data
//
$sql = "SELECT *
	 FROM " . MUSIC_CONFIG_TABLE;
if ( !$result = $db->sql_query( $sql ) )
{
	mx_message_die( CRITICAL_ERROR, "Could not query phpbb plugin base configuration 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 ) )
			{
				mx_message_die( GENERAL_ERROR, "Failed to update general configuration for $config_name", "", __LINE__, __FILE__, $sql );
			}
		}
	}
	$db->sql_freeresult($result);

	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_ext.$phpEx" ) . "\">", "</a>" ) . "<br /><br />" . sprintf( $lang['Click_return_admin_index'], "<a href=\"" . append_sid( $mx_root_path . "admin/index.$phpEx?pane=right" ) . "\">", "</a>" );
		mx_message_die( GENERAL_MESSAGE, $message );
	}
}

//
// Populate parameter variables
//
$music_index = $new['index'];

// $other = $new['other'];


$override_default_pages = $new['override_default_pages'];
$integration_enabled = $new['enable_integration'];

//
// Get page_list selects
//
$pagelist_index = get_list_formatted('page_list', $new['index'], 'index');

// $pagelist_other = get_list_formatted('page_list', $new['other'], 'other');

//
// Start page proper
//
$template->set_filenames( array( "body" => "admin/music_admin_body_ext.tpl" ));

$template->assign_vars( array(
		'S_MUSIC_ACTION' => append_sid( "admin_music_ext.$phpEx" ),

		'L_MUSIC_TITLE' => $lang['mx_music_admin'],
		'L_MUSIC_EXPLAIN' => $lang['mx_music_admin_explain'],

		'L_DEFAULT_PAGES_TITLE' => $lang['default_pages_title'],
		'L_DEFAULT_PAGES_TITLE_EXPLAIN' => $lang['default_pages_title_explain'],

		'L_DEFAULT_PAGES_MORE_TITLE' => $lang['default_pages_more_title'],
		'L_DEFAULT_PAGES_MORE_TITLE_EXPLAIN' => $lang['default_pages_more_title_explain'],

		//
		// Enable/Disable phpBB integration
		//
		'L_MUSIC_INTEGRATION_ENABLED' => $lang['integration_enabled'],
		'L_MUSIC_INTEGRATION_ENABLED_EXPLAIN' => $lang['integration_enabled_explain'],

		'L_MUSIC_INTEGRATION_ENABLED_YES' => $lang['integration_enabled_yes'],
		'L_MUSIC_INTEGRATION_ENABLED_NO' => $lang['integration_enabled_no'],

		'MUSIC_INTEGRATION_ENABLED_YES' => ( $integration_enabled == '1' ) ? ' checked="checked"' : '',
		'MUSIC_INTEGRATION_ENABLED_NO' => ( $integration_enabled == '0' ) ? ' checked="checked"' : '',

		//
		// Default static settings or block settings
		//
		'L_OVERRIDE_DEFAULT_PAGES' => $lang['override'],
		'L_OVERRIDE_DEFAULT_PAGES_EXPLAIN' => $lang['override_explain'],

		'L_OVERRIDE_DEFAULT_PAGES_YES' => $lang['override_yes'],
		'L_OVERRIDE_DEFAULT_PAGES_NO' => $lang['override_no'],

		'OVERRIDE_DEFAULT_PAGES_CHECKBOX_YES' => ( $override_default_pages == '1' ) ? ' checked="checked"' : '',
		'OVERRIDE_DEFAULT_PAGES_CHECKBOX_NO' => ( $override_default_pages == '0' ) ? ' checked="checked"' : '',


		'L_MUSIC_INDEX' => $lang['index'],
		'MUSIC_INDEX' => $pagelist_index,

		// 'L_SUBMIT' => $lang['submit'],
		// 'L_RESET' => $lang['reset'],

		'L_SUBMIT' => $lang['Submit'],
		'L_RESET' => $lang['Reset']

	));

$template->pparse( "body" );
include_once( $mx_root_path . 'admin/page_footer_admin.' . $phpEx );

?>

--- NEW FILE: admin_music_cat.php ---
<?php
/**
*
* @package mxBB Portal Module - mx_music
* @version $Id: admin_music_cat.php,v 1.1 2007/06/06 20:32:17 orynider Exp $
* @copyright (c) 2003 [ory...@rd..., OryNider] mxBB Development Team
* @license http://opensource.org/licenses/gpl-license.php GNU General Public License v2
*
*/

define('IN_PORTAL', 1);

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

//
// Let's set the root dir for phpBB
//
$module_root_path = '../';
$mx_root_path = '../../../';
$music_root_path = $module_root_path . 'music_box/';
$phpEx = substr(strrchr(__FILE__, '.'), 1); 

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

//
// Get general music information
//
include($music_root_path . 'music_common.'.$phpEx);

// **********************************************************************
// Read language definition
// **********************************************************************
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 ( file_exists( $module_root_path . 'language/lang_' . $board_config['default_lang'] . '/lang_main_music.' . $phpEx ) )
{
	include( $module_root_path . 'language/lang_' . $board_config['default_lang'] . '/lang_main_music.' . $phpEx );
}
else if ( file_exists( $module_root_path . 'language/lang_english/lang_main_music.' . $phpEx ) )
{
	include( $module_root_path . 'language/lang_english/lang_main_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_CATEGORY' => $lang['Create_category'])
		);

		$sql = "SELECT *
				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);
		}
		while ($row = $db->sql_fetchrow($result))
		{
			$catrow[] = $row;
		}

		for( $i = 0; $i < count($catrow); $i++ )
		{
			$template->assign_block_vars('catrow', array(
				'COLOR' => ($i % 2) ? 'row1' : 'row2',
				'TITLE' => $catrow[$i]['cat_title'],
				'DESC' => $catrow[$i]['cat_desc'],
				'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'])
				)
			);
		}

		$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' )
	{
		if( !isset($HTTP_POST_VARS['cat_title']) )
		{
			$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"),
				'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,

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

			$template->pparse('body');

			include($mx_root_path . 'admin/page_footer_admin.'.$phpEx);
		}
		else
		{
			// Get posting variables
			$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)
					VALUES ('$cat_title', '$cat_desc', '$cat_order', '$view_level', '$upload_level', '$rate_level', '$comment_level', '$edit_level', '$delete_level', '$cat_approval')";
			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_auth.php ---
<?php
/**
*
* @package mxBB Portal Module - mx_music
* @version $Id: admin_music_auth.php,v 1.1 2007/06/06 20:32:13 orynider Exp $
* @copyright (c) 2003 [ory...@rd..., OryNider] mxBB Development Team
* @license http://opensource.org/licenses/gpl-license.php GNU General Public License v2
*
*/

define('IN_PORTAL', 1);

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

//
// Let's set the root dir for phpBB
//
$module_root_path = '../';
$mx_root_path = '../../../';
$music_root_path = $module_root_path . 'music_box/';
$phpEx = substr(strrchr(__FILE__, '.'), 1); 

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

//
// Get general music information
//
include($music_root_path . 'music_common.'.$phpEx);

// **********************************************************************
// Read language definition
// **********************************************************************
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 ( file_exists( $module_root_path . 'language/lang_' . $board_config['default_lang'] . '/lang_main_music.' . $phpEx ) )
{
	include( $module_root_path . 'language/lang_' . $board_config['default_lang'] . '/lang_main_music.' . $phpEx );
}
else if ( file_exists( $module_root_path . 'language/lang_english/lang_main_music.' . $phpEx ) )
{
	include( $module_root_path . 'language/lang_english/lang_main_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_cfg.php ---
<?php
/**
*
* @package mxBB Portal Module - mx_music
* @version $Id: admin_music_cfg.php,v 1.1 2007/06/06 20:32:18 orynider Exp $
* @copyright (c) 2003 [ory...@rd..., OryNider] mxBB Development Team
* @license http://opensource.org/licenses/gpl-license.php GNU General Public License v2
*
*/

define('IN_PORTAL', 1);

if ( !empty( $setmodules ) )
{
	$file = basename( __FILE__ );
	$module['Music_Online']['Configuration std'] = 'modules/mx_music/admin/' . $file;
	return;
}

//
// Let's set the root dir for phpBB
//
$module_root_path = '../';
$mx_root_path = '../../../';
$music_root_path = $module_root_path . 'music_box/';
$phpEx = substr(strrchr(__FILE__, '.'), 1); 

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

//
// Get general music information
//
include($music_root_path . 'music_common.'.$phpEx);

// **********************************************************************
// Read language definition
// **********************************************************************
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 ( file_exists( $module_root_path . 'language/lang_' . $board_config['default_lang'] . '/lang_main_music.' . $phpEx ) )
{
	include( $module_root_path . 'language/lang_' . $board_config['default_lang'] . '/lang_main_music.' . $phpEx );
}
else if ( file_exists( $module_root_path . 'language/lang_english/lang_main_music.' . $phpEx ) )
{
	include( $module_root_path . 'language/lang_english/lang_main_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("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'],

	//
	// 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"' : '',

	'RM_ENABLED' => ($new['rm_allowed'] == 1) ? 'checked="checked"' : '',
	'RM_DISABLED' => ($new['rm_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_TOP' => $lang['Top'],
	//
	// 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'],

	'L_MP3_ALLOWED' => $lang['MP3_allowed'],
	'L_WAV_ALLOWED' => $lang['WAV_allowed'],
	'L_WMA_ALLOWED' => $lang['WMA_allowed'],
	// Media Center
	'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_RM_ALLOWED' => $lang['RM_allowed'],
	// Media Center
	'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 */

?>