[mxbb-commits] mx_music/phpbb2 music_db_install.php, NONE, 1.1.2.2 music_db_uninstall.php, NONE, 1.1.2.2

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

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

Added Files:
      Tag: core28x
	music_db_install.php music_db_uninstall.php 
Log Message:
upgrade version for core28x branch

--- NEW FILE: music_db_install.php ---
<?php
/**
*
* @package phpBB Mod - Media Center
* @version $Id: music_db_install.php,v 1.1.2.2 2008/03/13 10:02:14 orynider Exp $
* @copyright (c) 2002-2006 [Jon Ohlsson, Mohd Basri, wGEric, PHP Arena, pafileDB, CRLin] mxBB Project Team
* @license http://opensource.org/licenses/gpl-license.php GNU General Public License v2
*
*/

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

if ( !defined('PORTAL_BACKEND') && @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/';
	
	include($phpbb_root_path . 'common.' . $phpEx);
	include($mx_mod_path . "includes/functions_required.$phpEx");
	
	//Check if forum_hack is installed
	if (!isset($mx_root_path))
	{
		$mx_root_path = './';
		@define('IN_PORTAL', true);
		include_once($mx_mod_path . "includes/mx_constants.$phpEx");
		include_once($mx_mod_path . "includes/shared/phpbb2/includes/functions.$phpEx");
	}
	else
	{
		@define('IN_PORTAL', true);
		include_once($mx_root_path . "includes/mx_constants.$phpEx");
		include_once($mx_root_path . "includes/shared/phpbb2/includes/functions.$phpEx");
	}
	
	require($mx_mod_path . "includes/functions_core.$phpEx");
	require($mx_mod_path . "includes/functions_styles.$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();
	
	//
	// Get mxBB config settings
	//
	//$portal_config = $mx_cache->obtain_mxbb_config();

	//
	// instatiate the mx_request_vars class
	//
	$mx_request_vars = new mx_request_vars();
	
	//
	// Page selector
	//
	$page_id = $mx_request_vars->request('page', MX_TYPE_INT, 1);

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

	if (file_exists("./modcp.$phpEx")) // phpBB2
	{
		define('PORTAL_BACKEND', 'phpbb2');
		$tplEx = 'tpl';
		
		//
		// Start user session
		// - populate $userdata and $lang
		//
		$mx_user->init($user_ip, $page_id, false);
		init_userprefs($userdata);

		$mx_user->set_module_default_style('prosilver'); // For compatibility with core 2.8.x
		
		if (!$userdata['user_level'] == ADMIN)
		{
			die('Only admins may run this script!!!');
		}
		
	}
	else if (@file_exists("./mcp.$phpEx")) // phpBB3
	{
		define('PORTAL_BACKEND', 'phpbb3');
		$tplEx = 'html';
		
		//
		// Start user session
		// - populate $userdata and $lang
		//
		$mx_user->init($user_ip, $page_id, false);
		$user->setup();
		//
		// End session management
		//

		$mx_user->set_module_default_style('prosilver'); // For compatibility with core 2.8.x

		if ($userdata['user_type'] != USER_FOUNDER)
		{
			die('Only admins may run this script!!!');
		}
	}
	else
	{
		die('Copy this file in phpbb_root_path were is your viewtopic.php file!!!');
	}
}
else // --------------------------------------------------------------------------------- mxBB Module MODE
{
	define( 'MXBB_MODULE', true );

	if ( !function_exists( 'read_block_config' ) )
	{
		define( 'IN_PORTAL', true );
		$mx_root_path 		= './../../';
		$module_root_path 	= './';

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

		// Start session management
		$mx_user->init($user_ip, PAGE_INDEX);
		// End session management

		define( 'MXBB_27x', file_exists( $mx_root_path . 'mx_login.' . $phpEx ) );
	}
	else
	{
		if( !defined('IN_PORTAL') || !is_object($mx_block))
		{
			die("Hacking attempt");
		}

		//
		// Read Block Settings (default mode)
		//
		$title = !empty( $mx_block->block_info['block_title'] ) ? $mx_block->block_info['block_title'] : $lang['KB_title'];
		$desc = $mx_block->block_info['block_desc'];
		$block_size = ( isset( $block_size ) && !empty( $block_size ) ? $block_size : '100%' );

		//Check for cash mod
		if (file_exists($phpbb_root_path . 'includes/functions_cash.'.$phpEx))
		{
			define('IN_CASHMOD', true);
		}

		$is_block = true;
		global $images;
	}
	define( 'MXBB_27x', @file_exists( $mx_root_path . 'mx_login.'.$phpEx ) );
}

//
// Check if mx_common Mod is prezent
//
if (!file_exists($mx_mod_path . "includes/functions_admincp.$phpEx"))
{
	die('mx mod is not uploaded!!!');
}
else
{
	require($mx_mod_path . "includes/functions_admincp.$phpEx");
}

//
// Check if mx_common Mod is prezent
//
if ( !file_exists( $mx_mod_path . 'includes/' . 'functions_admincp.' . $phpEx ) )
{
	die('mx_mod folder is not uploaded!!!');
}
else
{
	include_once( $mx_mod_path . 'includes/' . 'functions_admincp.' . $phpEx );
	include_once( $mx_mod_path . 'includes/functions_required.' . $phpEx );
}

$page_title = 'Installing/Upgrading Media Center';
include($phpbb_root_path . 'includes/page_header.'.$phpEx);

$sql = array();

// If fresh install
if ( !$result = $db->sql_query( "SELECT config_name from " . $table_prefix . "music_config" ) )
{
	$message = "<b>This is a fresh install!</b><br/><br/>";

	$sql[] = "DROP TABLE IF EXISTS " . $table_prefix . "music";

	$sql[] = "DROP TABLE IF EXISTS " . $table_prefix . "music_rate";

	$sql[] = "DROP TABLE IF EXISTS " . $table_prefix . "music_comment";

	$sql[] = "DROP TABLE IF EXISTS " . $table_prefix . "music_cat";

	$sql[] = "DROP TABLE IF EXISTS " . $table_prefix . "music_config";

	$sql[] = "CREATE TABLE ". $table_prefix . "music (
		song_id int(11) UNSIGNED NOT NULL auto_increment,
		song_filename varchar(255) NOT NULL,
		song_filetype varchar(255) NOT NULL,
		song_imagename varchar(255) NOT NULL,
		song_title varchar(255) NOT NULL,
		song_url varchar(255) NOT NULL,
		song_desc text,
		song_singer varchar(255) NOT NULL,
		song_user_id mediumint(8) NOT NULL,
		song_username varchar(32),
		song_user_ip char(8) NOT NULL DEFAULT '0',
		song_time int(11) UNSIGNED NOT NULL,
		song_cat_id mediumint(8) UNSIGNED NOT NULL DEFAULT '1',
		song_view_count int(11) UNSIGNED NOT NULL DEFAULT '0',
		song_lock tinyint(3) NOT NULL DEFAULT '0',
		song_approval tinyint(3) NOT NULL DEFAULT '1',
		song_download_count varchar(255) NOT NULL,
		PRIMARY KEY (song_id),
		KEY song_cat_id (song_cat_id),
		KEY song_user_id (song_user_id),
		KEY song_time (song_time)
		) TYPE=MyISAM";

	$sql[] = "CREATE TABLE ". $table_prefix . "music_rate (
		rate_song_id int(11) UNSIGNED NOT NULL,
		rate_user_id mediumint(8) NOT NULL,
		rate_user_ip char(8) NOT NULL,
		rate_point tinyint(3) UNSIGNED NOT NULL,
		KEY rate_song_id (rate_song_id),
		KEY rate_user_id (rate_user_id),
		KEY rate_user_ip (rate_user_ip),
		KEY rate_point (rate_point)
		) TYPE=MyISAM";

	$sql[] = "CREATE TABLE ". $table_prefix . "music_comment (
		comment_id int(11) UNSIGNED NOT NULL auto_increment,
		comment_song_id int(11) UNSIGNED NOT NULL,
		comment_user_id mediumint(8) NOT NULL,
		comment_username varchar(32),
		comment_user_ip char(8) NOT NULL,
		comment_time int(11) UNSIGNED NOT NULL,
		comment_text TEXT,
		comment_edit_time int(11) UNSIGNED,
		comment_edit_count smallint(5) UNSIGNED NOT NULL DEFAULT '0',
		comment_edit_user_id mediumint(8),
		PRIMARY KEY(comment_id),
		KEY comment_song_id (comment_song_id),
		KEY comment_user_id (comment_user_id),
		KEY comment_user_ip (comment_user_ip),
		KEY comment_time (comment_time)
		) TYPE=MyISAM";

	$sql[] = "CREATE TABLE ". $table_prefix . "music_cat (
		cat_id mediumint(8) UNSIGNED NOT NULL auto_increment,
		cat_parent mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
		cat_type tinyint NOT NULL DEFAULT '0',
		cat_title varchar(255) NOT NULL,
		cat_desc text,
		cat_order mediumint(8) NOT NULL,
		cat_views mediumint(8) NOT NULL,
		cat_view_level tinyint(3) NOT NULL DEFAULT '-1',
		cat_upload_level tinyint(3) NOT NULL DEFAULT '0',
		cat_rate_level tinyint(3) NOT NULL DEFAULT '0',
		cat_comment_level tinyint(3) NOT NULL DEFAULT '0',
		cat_edit_level tinyint(3) NOT NULL DEFAULT '0',
		cat_delete_level tinyint(3) NOT NULL DEFAULT '2',
		cat_view_groups varchar(255),
		cat_upload_groups varchar(255),
		cat_rate_groups varchar(255),
		cat_comment_groups varchar(255),
		cat_edit_groups varchar(255),
		cat_delete_groups varchar(255),
		cat_moderator_groups varchar(255),
		cat_approval tinyint(3) NOT NULL DEFAULT '0',
		PRIMARY KEY (cat_id),
		KEY cat_order (cat_order)
		) TYPE=MyISAM";

	$sql[] = "CREATE TABLE " . $table_prefix . "music_config (
  			 	   	    config_name VARCHAR(255) NOT NULL default '',
						config_value varchar(255) NOT NULL default '',
						PRIMARY KEY  (config_name)
						) TYPE=MyISAM";

	$sql[] = "INSERT INTO " . $table_prefix . "music_config VALUES ('max_songs', '1024')";
	$sql[] = "INSERT INTO " . $table_prefix . "music_config VALUES ('user_songs_limit', '50')";
	$sql[] = "INSERT INTO " . $table_prefix . "music_config VALUES ('mod_songs_limit', '250')";
	$sql[] = "INSERT INTO " . $table_prefix . "music_config VALUES ('max_file_size', '3145728')";
	$sql[] = "INSERT INTO " . $table_prefix . "music_config VALUES ('rows_per_page', '20')";
	$sql[] = "INSERT INTO " . $table_prefix . "music_config VALUES ('cols_per_page', '1')";
	$sql[] = "INSERT INTO " . $table_prefix . "music_config VALUES ('top', '5')";
	$sql[] = "INSERT INTO " . $table_prefix . "music_config VALUES ('sort_method', 'song_time')";
	$sql[] = "INSERT INTO " . $table_prefix . "music_config VALUES ('sort_order', 'DESC')";
	$sql[] = "INSERT INTO " . $table_prefix . "music_config VALUES ('mp3_allowed', '1')";
	$sql[] = "INSERT INTO " . $table_prefix . "music_config VALUES ('wav_allowed', '1')";
	$sql[] = "INSERT INTO " . $table_prefix . "music_config VALUES ('wma_allowed', '1')";
	$sql[] = "INSERT INTO " . $table_prefix . "music_config VALUES ('wmv_allowed', '1')";
	$sql[] = "INSERT INTO " . $table_prefix . "music_config VALUES ('mid_allowed', '1')";
	$sql[] = "INSERT INTO " . $table_prefix . "music_config VALUES ('ram_allowed', '1')";
	$sql[] = "INSERT INTO " . $table_prefix . "music_config VALUES ('au_allowed', '1')";
	$sql[] = "INSERT INTO " . $table_prefix . "music_config VALUES ('mpeg_allowed', '1')";
	$sql[] = "INSERT INTO " . $table_prefix . "music_config VALUES ('avi_allowed', '1')";
	$sql[] = "INSERT INTO " . $table_prefix . "music_config VALUES ('swf_allowed', '1')";
	$sql[] = "INSERT INTO " . $table_prefix . "music_config VALUES ('qt_allowed', '1')";
	$sql[] = "INSERT INTO " . $table_prefix . "music_config VALUES ('rm_allowed', '1')";
	$sql[] = "INSERT INTO " . $table_prefix . "music_config VALUES ('desc_length', '512000')";
	$sql[] = "INSERT INTO " . $table_prefix . "music_config VALUES ('hotlink_prevent', '0')";
	$sql[] = "INSERT INTO " . $table_prefix . "music_config VALUES ('hotlink_allowed', 'cfmanager.gate2vn.net')";
	$sql[] = "INSERT INTO " . $table_prefix . "music_config VALUES ('rate', '1')";
	$sql[] = "INSERT INTO " . $table_prefix . "music_config VALUES ('rate_scale', '10')";
	$sql[] = "INSERT INTO " . $table_prefix . "music_config VALUES ('comment', '1')";
	$sql[] = "INSERT INTO " . $table_prefix . "music_config VALUES ('music_version', '.1.0')";
	$sql[] = "INSERT INTO " . $table_prefix . "music_config VALUES ('max_image_size', '1024000')";
	$sql[] = "INSERT INTO " . $table_prefix . "music_config VALUES ('max_image_width', '800')";
	$sql[] = "INSERT INTO " . $table_prefix . "music_config VALUES ('max_image_height', '600')";
	$sql[] = "INSERT INTO " . $table_prefix . "music_config VALUES ('download', '1')";
	$sql[] = "INSERT INTO " . $table_prefix . "music_config VALUES ('enable_integration', '1')";
	$sql[] = "INSERT INTO " . $table_prefix . "music_config VALUES ('override_default_pages', '0')";
	$sql[] = "INSERT INTO " . $table_prefix . "music_config VALUES ('index', '5')";
	$sql[] = "INSERT INTO " . $table_prefix . "music_config VALUES ('xs_enabled', '1')";
	$sql[] = "INSERT INTO " . $table_prefix . "music_config VALUES ('img_allowed', '1')";
	$sql[] = "INSERT INTO " . $table_prefix . "music_config VALUES ('flv_allowed', '1')";
	$sql[] = "INSERT INTO " . $table_prefix . "music_config VALUES ('show_index_subcats', '1')";
	$sql[] = "INSERT INTO " . $table_prefix . "music_config VALUES ('rows_per_page_pic', '5')";
	$sql[] = "INSERT INTO " . $table_prefix . "music_config VALUES ('cols_per_page_pic', '5')";
	$sql[] = "INSERT INTO " . $table_prefix . "music_config VALUES ('rows_per_page_media', '10')";
	$sql[] = "INSERT INTO " . $table_prefix . "music_config VALUES ('cols_per_page_media', '1')";

	$message .= mx_do_install_upgrade( $sql );
}
else
{

	//
	// Upgrade checks
	//
	$upgrade_206 = 0;
	$upgrade_207 = 0;

	//
	// validate before 2.06
	//
	$result = $db->sql_query( "SELECT config_value from " . $table_prefix . "music_config WHERE config_name = 'enable_integration'" );
	if ( $db->sql_numrows( $result ) == 0 )
	{
		$upgrade_206 = 1;
	}

	//
	// validate before 2.07
	//
	$result = $db->sql_query( "SELECT config_value from " . $table_prefix . "music_config WHERE config_name = 'xs_enabled'" );
	if ( $db->sql_numrows( $result ) == 0 )
	{
		$upgrade_207 = 1;
	}

	$message = "<b>Upgrading!</b><br/><br/>";

	if ( $upgrade_206 == 1 )
	{
		$message .= "<b>Upgrading to v. 2.06 ...</b><br/><br/>";

		$sql[] = "ALTER TABLE " . $table_prefix . "music ADD song_imagename VARCHAR(255) not null AFTER song_filename";
		$sql[] = "ALTER TABLE " . $table_prefix . "music ADD song_download_count VARCHAR(255) not null DEFAULT '0' AFTER song_approval";
		$sql[] = "ALTER TABLE " . $table_prefix . "music_cat ADD cat_views mediumint(8) NOT NULL";
		$sql[] = "INSERT INTO " . $table_prefix . "music_config VALUES ('wmv_allowed', '1')";
		$sql[] = "INSERT INTO " . $table_prefix . "music_config VALUES ('mid_allowed', '1')";
		$sql[] = "INSERT INTO " . $table_prefix . "music_config VALUES ('ram_allowed', '1')";
		$sql[] = "INSERT INTO " . $table_prefix . "music_config VALUES ('au_allowed', '1')";
		$sql[] = "INSERT INTO " . $table_prefix . "music_config VALUES ('mpeg_allowed', '1')";
		$sql[] = "INSERT INTO " . $table_prefix . "music_config VALUES ('avi_allowed', '1')";
		$sql[] = "INSERT INTO " . $table_prefix . "music_config VALUES ('swf_allowed', '1')";
		$sql[] = "INSERT INTO " . $table_prefix . "music_config VALUES ('qt_allowed', '1')";
		$sql[] = "INSERT INTO " . $table_prefix . "music_config VALUES ('rm_allowed', '1')";

		$sql[] = "INSERT INTO " . $table_prefix . "music_config VALUES ('max_image_size', '1024000')";
		$sql[] = "INSERT INTO " . $table_prefix . "music_config VALUES ('max_image_width', '800')";
		$sql[] = "INSERT INTO " . $table_prefix . "music_config VALUES ('max_image_height', '600')";
		$sql[] = "INSERT INTO " . $table_prefix . "music_config VALUES ('download', '1')";
		$sql[] = "INSERT INTO " . $table_prefix . "music_config VALUES ('enable_integration', '1')";
		$sql[] = "INSERT INTO " . $table_prefix . "music_config VALUES ('override_default_pages', '0')";
		$sql[] = "INSERT INTO " . $table_prefix . "music_config VALUES ('index', '5')";
	}

	if ( $upgrade_207 == 1 )
	{
		$message .= "<b>Upgrading to v. 2.0.7...</b><br/><br/>";

		$sql[] = "INSERT INTO " . $table_prefix . "music_config VALUES ('xs_enabled', '1')";
		$sql[] = "INSERT INTO " . $table_prefix . "music_config VALUES ('img_allowed', '1')";
		$sql[] = "INSERT INTO " . $table_prefix . "music_config VALUES ('flv_allowed', '1')";
		$sql[] = "INSERT INTO " . $table_prefix . "music_config VALUES ('show_index_subcats', '1')";
		$sql[] = "INSERT INTO " . $table_prefix . "music_config VALUES ('rows_per_page_pic', '5')";
		$sql[] = "INSERT INTO " . $table_prefix . "music_config VALUES ('cols_per_page_pic', '5')";
		$sql[] = "INSERT INTO " . $table_prefix . "music_config VALUES ('rows_per_page_media', '10')";
		$sql[] = "INSERT INTO " . $table_prefix . "music_config VALUES ('cols_per_page_media', '1')";

		$sql[] = "ALTER TABLE " . $table_prefix . "music_cat ADD cat_parent mediumint(8) UNSIGNED NOT NULL DEFAULT '0' AFTER cat_id";
		$sql[] = "ALTER TABLE " . $table_prefix . "music_cat ADD cat_type tinyint NOT NULL DEFAULT '0' AFTER cat_parent";
		$sql[] = "ALTER TABLE " . $table_prefix . "music ADD song_filetype varchar(255) NOT NULL AFTER song_filename";

		$sql[] = "UPDATE ". $table_prefix ."music_config
				SET config_value = '0.7'
				WHERE config_name = 'music_version'";
	}
	else
	{
		$message .= "<b>Nothing to upgrade...</b><br/><br/>";
	}


	$message .= mx_do_install_upgrade( $sql );

	//
	// Empty module cache
	//
	include_once( $mx_mod_path . 'includes/functions_tools.' . $phpEx );
	$module_cache = new module_cache($root_path);
	$module_cache->tidy();
	$module_cache->save();
}

echo "<br /><br />";
echo "<table  width=\"90%\" align=\"center\" cellpadding=\"4\" cellspacing=\"1\" border=\"0\" class=\"forumline\">";
echo "<tr><th class=\"thHead\" align=\"center\">Mod Installation/Upgrading/Uninstalling Information - mod specific db tables</th></tr>";
echo "<tr><td class=\"row1\"  align=\"left\"><span class=\"gen\">" . $message . "</span></td></tr>";
echo "</table><br />";


include($phpbb_root_path . 'includes/page_tail.'.$phpEx);

?>
--- NEW FILE: music_db_uninstall.php ---
<?php
/**
*
* @package phpBB2 Mod - pafileDB
* @version $Id: music_db_uninstall.php,v 1.1.2.2 2008/03/13 10:02:16 orynider Exp $
* @copyright (c) 2002-2006 [Jon Ohlsson, Mohd Basri, wGEric, PHP Arena, pafileDB, CRLin] mxBB Project Team
* @license http://opensource.org/licenses/gpl-license.php GNU General Public License v2
*
*/

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

if ( !defined('PORTAL_BACKEND') && @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/';
	
	include($phpbb_root_path . 'common.' . $phpEx);
	include($mx_mod_path . "includes/functions_required.$phpEx");
	
	//Check if forum_hack is installed
	if (!isset($mx_root_path))
	{
		$mx_root_path = './';
		@define('IN_PORTAL', true);
		include_once($mx_mod_path . "includes/mx_constants.$phpEx");
		include_once($mx_mod_path . "includes/shared/phpbb2/includes/functions.$phpEx");
	}
	else
	{
		@define('IN_PORTAL', true);
		include_once($mx_root_path . "includes/mx_constants.$phpEx");
		include_once($mx_root_path . "includes/shared/phpbb2/includes/functions.$phpEx");
	}
	
	require($mx_mod_path . "includes/functions_core.$phpEx");
	require($mx_mod_path . "includes/functions_styles.$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();
	
	//
	// Get mxBB config settings
	//
	//$portal_config = $mx_cache->obtain_mxbb_config();

	//
	// instatiate the mx_request_vars class
	//
	$mx_request_vars = new mx_request_vars();
	
	//
	// Page selector
	//
	$page_id = $mx_request_vars->request('page', MX_TYPE_INT, 1);

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

	if (file_exists("./modcp.$phpEx")) // phpBB2
	{
		define('PORTAL_BACKEND', 'phpbb2');
		$tplEx = 'tpl';
		
		//
		// Start user session
		// - populate $userdata and $lang
		//
		$mx_user->init($user_ip, $page_id, false);
		init_userprefs($userdata);

		$mx_user->set_module_default_style('prosilver'); // For compatibility with core 2.8.x
		
		if (!$userdata['user_level'] == ADMIN)
		{
			die('Only admins may run this script!!!');
		}
		
	}
	else if (@file_exists("./mcp.$phpEx")) // phpBB3
	{
		define('PORTAL_BACKEND', 'phpbb3');
		$tplEx = 'html';
		
		//
		// Start user session
		// - populate $userdata and $lang
		//
		$mx_user->init($user_ip, $page_id, false);
		$user->setup();
		//
		// End session management
		//

		$mx_user->set_module_default_style('prosilver'); // For compatibility with core 2.8.x

		if ($userdata['user_type'] != USER_FOUNDER)
		{
			die('Only admins may run this script!!!');
		}
	}
	else
	{
		die('Copy this file in phpbb_root_path were is your viewtopic.php file!!!');
	}
}
else // --------------------------------------------------------------------------------- mxBB Module MODE
{
	define( 'MXBB_MODULE', true );

	if ( !function_exists( 'read_block_config' ) )
	{
		define( 'IN_PORTAL', true );
		$mx_root_path 		= './../../';
		$module_root_path 	= './';

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

		// Start session management
		$mx_user->init($user_ip, PAGE_INDEX);
		// End session management

		define( 'MXBB_27x', file_exists( $mx_root_path . 'mx_login.' . $phpEx ) );
	}
	else
	{
		if( !defined('IN_PORTAL') || !is_object($mx_block))
		{
			die("Hacking attempt");
		}

		//
		// Read Block Settings (default mode)
		//
		$title = !empty( $mx_block->block_info['block_title'] ) ? $mx_block->block_info['block_title'] : $lang['KB_title'];
		$desc = $mx_block->block_info['block_desc'];
		$block_size = ( isset( $block_size ) && !empty( $block_size ) ? $block_size : '100%' );

		//Check for cash mod
		if (file_exists($phpbb_root_path . 'includes/functions_cash.'.$phpEx))
		{
			define('IN_CASHMOD', true);
		}

		$is_block = true;
		global $images;
	}
	define( 'MXBB_27x', @file_exists( $mx_root_path . 'mx_login.'.$phpEx ) );
}

//
// Check if mx_common Mod is prezent
//
if (!file_exists($mx_mod_path . "includes/functions_admincp.$phpEx"))
{
	die('mx mod is not uploaded!!!');
}
else
{
	require($mx_mod_path . "includes/functions_admincp.$phpEx");
}

$page_title = 'Uninstalling Media Center';
include($phpbb_root_path . 'includes/page_header.'.$phpEx);

$sql = array(
	"DROP TABLE " . $table_prefix . "music",
	"DROP TABLE " . $table_prefix . "music_rate",
	"DROP TABLE " . $table_prefix . "music_comment",
	"DROP TABLE " . $table_prefix . "music_config"
	);

echo "<br /><br />";
echo "<table  width=\"90%\" align=\"center\" cellpadding=\"4\" cellspacing=\"1\" border=\"0\" class=\"forumline\">";
echo "<tr><th class=\"thHead\" align=\"center\">Mod Installation/Upgrading/Uninstalling Information - mod specific db tables</th></tr>";
echo "<tr><td class=\"row1\"  align=\"left\"><span class=\"gen\">" . mx_do_install_upgrade( $sql ) . "</span></td></tr>";
echo "</table><br />";


include($phpbb_root_path . 'includes/page_tail.'.$phpEx);

?>