HI,
i try Music Online in PHPBB 2.0.22 its work correctly now i want to add Music Online in Icy Phoenix 1.1.10.25 based on phpBB 2.0.22 can any one transect this mod for me to add in Icy Phoenix 1.1.10.25.
Mod for PHPBB 2.0.X : download
Thanx..
Icy Phoenix
Old Support Topics - Music Online Hack (Media Center) ?
mafridi [ Thu 07 Feb, 2008 11:38 ]
Post subject: Music Online Hack (Media Center) ?
Post subject: Music Online Hack (Media Center) ?
Chaotic [ Thu 07 Feb, 2008 11:54 ]
Post subject: Re: Music Online Hack (Media Center) ?
Post subject: Re: Music Online Hack (Media Center) ?
I haven't been able to get this mod to work with IP either. It would be a neat little add-on.
TheSteffen [ Thu 07 Feb, 2008 20:04 ]
Post subject: Re: Music Online Hack (Media Center) ?
Post subject: Re: Music Online Hack (Media Center) ?
Take a look at this site: http://www.icyphoenix.com/viewtopic.php?t=3093
But its not working at the moment...
maybe someone can fix it.
But its not working at the moment...
maybe someone can fix it.
mafridi [ Fri 08 Feb, 2008 05:37 ]
Post subject: Re: Music Online Hack (Media Center) ?
Post subject: Re: Music Online Hack (Media Center) ?
i have the same problem admin cp is blank.... after installing this mod..
Matooba [ Fri 14 Nov, 2008 04:35 ]
Post subject: Re: Music Online Hack (Media Center) ?
Post subject: Re: Music Online Hack (Media Center) ?
I too keep getting errors.
I cant seem to make the sql tables.
I used;
#
# Table structure for table `phpbb_music`
#
CREATE TABLE `phpbb_music` (
`song_id` int(11) unsigned NOT NULL auto_increment,
`song_filename` varchar(255) NOT NULL default '',
`song_imagename` varchar(255) NOT NULL default '',
`song_title` varchar(255) NOT NULL default '',
`song_url` varchar(255) NOT NULL default '',
`song_desc` text,
`song_writer` varchar(255) NOT NULL default '',
`band_website` varchar(255) NOT NULL default '',
`song_user_id` mediumint( NOT NULL default '0',
`song_username` varchar(32) default NULL,
`song_user_ip` varchar( NOT NULL default '0',
`song_time` int(11) unsigned NOT NULL default '0',
`song_cat_id` mediumint( 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 default '0',
`song_dl_enable` TINYINT( 3 ) DEFAULT '1' 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 AUTO_INCREMENT=18 ;
# --------------------------------------------------------
#
# Table structure for table `phpbb_music_cat`
#
CREATE TABLE `phpbb_music_cat` (
`cat_id` mediumint( unsigned NOT NULL auto_increment,
`cat_title` varchar(255) NOT NULL default '',
`cat_desc` text,
`cat_order` mediumint( NOT NULL default '0',
`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) default NULL,
`cat_upload_groups` varchar(255) default NULL,
`cat_rate_groups` varchar(255) default NULL,
`cat_comment_groups` varchar(255) default NULL,
`cat_edit_groups` varchar(255) default NULL,
`cat_delete_groups` varchar(255) default NULL,
`cat_moderator_groups` varchar(255) default NULL,
`cat_approval` tinyint(3) NOT NULL default '0',
`cat_random` tinyint(3) NOT NULL default '1',
PRIMARY KEY (`cat_id`),
KEY `cat_order` (`cat_order`)
) TYPE=MyISAM AUTO_INCREMENT=4 ;
#
# Dumping data for table `phpbb_music_cat`
#
INSERT INTO phpbb_music_cat VALUES (4, 'Test Category 1', 'Go into your Admin Control Panel and add more categories.', 10, -1, 0, 0, 0, 0, 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0,1);
# --------------------------------------------------------
#
# Table structure for table `phpbb_music_comment`
#
CREATE TABLE `phpbb_music_comment` (
`comment_id` int(11) unsigned NOT NULL auto_increment,
`comment_song_id` int(11) unsigned NOT NULL default '0',
`comment_user_id` mediumint( NOT NULL default '0',
`comment_username` varchar(32) default NULL,
`comment_user_ip` varchar( NOT NULL default '',
`comment_time` int(11) unsigned NOT NULL default '0',
`comment_text` text,
`comment_edit_time` int(11) unsigned default NULL,
`comment_edit_count` smallint(5) unsigned NOT NULL default '0',
`comment_edit_user_id` mediumint( default NULL,
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 AUTO_INCREMENT=3 ;
# --------------------------------------------------------
#
# Table structure for table `phpbb_music_config`
#
CREATE TABLE `phpbb_music_config` (
`config_name` varchar(255) NOT NULL default '',
`config_value` varchar(255) NOT NULL default '',
PRIMARY KEY (`config_name`)
) TYPE=MyISAM;
#
# Dumping data for table `phpbb_music_config`
#
INSERT INTO `phpbb_music_config` VALUES ('max_songs', '1024');
INSERT INTO `phpbb_music_config` VALUES ('user_songs_limit', '50');
INSERT INTO `phpbb_music_config` VALUES ('mod_songs_limit', '250');
INSERT INTO `phpbb_music_config` VALUES ('max_file_size', '5145728');
INSERT INTO `phpbb_music_config` VALUES ('rows_per_page', '20');
INSERT INTO `phpbb_music_config` VALUES ('cols_per_page', '1');
INSERT INTO `phpbb_music_config` VALUES ('top', '5');
INSERT INTO `phpbb_music_config` VALUES ('sort_method', 'song_time');
INSERT INTO `phpbb_music_config` VALUES ('sort_order', 'DESC');
INSERT INTO `phpbb_music_config` VALUES ('mp3_allowed', '0');
INSERT INTO `phpbb_music_config` VALUES ('wav_allowed', '0');
INSERT INTO `phpbb_music_config` VALUES ('wma_allowed', '0');
INSERT INTO `phpbb_music_config` VALUES ('desc_length', '512000');
INSERT INTO `phpbb_music_config` VALUES ('hotlink_prevent', '0');
INSERT INTO `phpbb_music_config` VALUES ('hotlink_allowed', 'cfmanager.net.tf');
INSERT INTO `phpbb_music_config` VALUES ('rate', '1');
INSERT INTO `phpbb_music_config` VALUES ('rate_scale', '5');
INSERT INTO `phpbb_music_config` VALUES ('comment', '1');
INSERT INTO `phpbb_music_config` VALUES ('music_version', '.0.6 beta');
INSERT INTO `phpbb_music_config` VALUES ('download', '1');
INSERT INTO `phpbb_music_config` VALUES ('max_image_size', '100000');
INSERT INTO `phpbb_music_config` VALUES ('max_image_width', '500');
INSERT INTO `phpbb_music_config` VALUES ('max_image_height', '500');
INSERT INTO `phpbb_music_config` VALUES ('random_allowed', '0');
# --------------------------------------------------------
#
# Table structure for table `phpbb_music_rate`
#
CREATE TABLE `phpbb_music_rate` (
`rate_song_id` int(11) unsigned NOT NULL default '0',
`rate_user_id` mediumint( NOT NULL default '0',
`rate_user_ip` char( NOT NULL default '',
`rate_point` tinyint(3) unsigned NOT NULL default '0',
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;
################################################## ###################
#
#-----[ SAVE/CLOSE ALL FILES ]------------------------------------------
#
# EoM
Here is the error I recieve:
Any help is appreciated!
I cant seem to make the sql tables.
I used;
#
# Table structure for table `phpbb_music`
#
CREATE TABLE `phpbb_music` (
`song_id` int(11) unsigned NOT NULL auto_increment,
`song_filename` varchar(255) NOT NULL default '',
`song_imagename` varchar(255) NOT NULL default '',
`song_title` varchar(255) NOT NULL default '',
`song_url` varchar(255) NOT NULL default '',
`song_desc` text,
`song_writer` varchar(255) NOT NULL default '',
`band_website` varchar(255) NOT NULL default '',
`song_user_id` mediumint( NOT NULL default '0',
`song_username` varchar(32) default NULL,
`song_user_ip` varchar( NOT NULL default '0',
`song_time` int(11) unsigned NOT NULL default '0',
`song_cat_id` mediumint( 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 default '0',
`song_dl_enable` TINYINT( 3 ) DEFAULT '1' 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 AUTO_INCREMENT=18 ;
# --------------------------------------------------------
#
# Table structure for table `phpbb_music_cat`
#
CREATE TABLE `phpbb_music_cat` (
`cat_id` mediumint( unsigned NOT NULL auto_increment,
`cat_title` varchar(255) NOT NULL default '',
`cat_desc` text,
`cat_order` mediumint( NOT NULL default '0',
`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) default NULL,
`cat_upload_groups` varchar(255) default NULL,
`cat_rate_groups` varchar(255) default NULL,
`cat_comment_groups` varchar(255) default NULL,
`cat_edit_groups` varchar(255) default NULL,
`cat_delete_groups` varchar(255) default NULL,
`cat_moderator_groups` varchar(255) default NULL,
`cat_approval` tinyint(3) NOT NULL default '0',
`cat_random` tinyint(3) NOT NULL default '1',
PRIMARY KEY (`cat_id`),
KEY `cat_order` (`cat_order`)
) TYPE=MyISAM AUTO_INCREMENT=4 ;
#
# Dumping data for table `phpbb_music_cat`
#
INSERT INTO phpbb_music_cat VALUES (4, 'Test Category 1', 'Go into your Admin Control Panel and add more categories.', 10, -1, 0, 0, 0, 0, 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0,1);
# --------------------------------------------------------
#
# Table structure for table `phpbb_music_comment`
#
CREATE TABLE `phpbb_music_comment` (
`comment_id` int(11) unsigned NOT NULL auto_increment,
`comment_song_id` int(11) unsigned NOT NULL default '0',
`comment_user_id` mediumint( NOT NULL default '0',
`comment_username` varchar(32) default NULL,
`comment_user_ip` varchar( NOT NULL default '',
`comment_time` int(11) unsigned NOT NULL default '0',
`comment_text` text,
`comment_edit_time` int(11) unsigned default NULL,
`comment_edit_count` smallint(5) unsigned NOT NULL default '0',
`comment_edit_user_id` mediumint( default NULL,
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 AUTO_INCREMENT=3 ;
# --------------------------------------------------------
#
# Table structure for table `phpbb_music_config`
#
CREATE TABLE `phpbb_music_config` (
`config_name` varchar(255) NOT NULL default '',
`config_value` varchar(255) NOT NULL default '',
PRIMARY KEY (`config_name`)
) TYPE=MyISAM;
#
# Dumping data for table `phpbb_music_config`
#
INSERT INTO `phpbb_music_config` VALUES ('max_songs', '1024');
INSERT INTO `phpbb_music_config` VALUES ('user_songs_limit', '50');
INSERT INTO `phpbb_music_config` VALUES ('mod_songs_limit', '250');
INSERT INTO `phpbb_music_config` VALUES ('max_file_size', '5145728');
INSERT INTO `phpbb_music_config` VALUES ('rows_per_page', '20');
INSERT INTO `phpbb_music_config` VALUES ('cols_per_page', '1');
INSERT INTO `phpbb_music_config` VALUES ('top', '5');
INSERT INTO `phpbb_music_config` VALUES ('sort_method', 'song_time');
INSERT INTO `phpbb_music_config` VALUES ('sort_order', 'DESC');
INSERT INTO `phpbb_music_config` VALUES ('mp3_allowed', '0');
INSERT INTO `phpbb_music_config` VALUES ('wav_allowed', '0');
INSERT INTO `phpbb_music_config` VALUES ('wma_allowed', '0');
INSERT INTO `phpbb_music_config` VALUES ('desc_length', '512000');
INSERT INTO `phpbb_music_config` VALUES ('hotlink_prevent', '0');
INSERT INTO `phpbb_music_config` VALUES ('hotlink_allowed', 'cfmanager.net.tf');
INSERT INTO `phpbb_music_config` VALUES ('rate', '1');
INSERT INTO `phpbb_music_config` VALUES ('rate_scale', '5');
INSERT INTO `phpbb_music_config` VALUES ('comment', '1');
INSERT INTO `phpbb_music_config` VALUES ('music_version', '.0.6 beta');
INSERT INTO `phpbb_music_config` VALUES ('download', '1');
INSERT INTO `phpbb_music_config` VALUES ('max_image_size', '100000');
INSERT INTO `phpbb_music_config` VALUES ('max_image_width', '500');
INSERT INTO `phpbb_music_config` VALUES ('max_image_height', '500');
INSERT INTO `phpbb_music_config` VALUES ('random_allowed', '0');
# --------------------------------------------------------
#
# Table structure for table `phpbb_music_rate`
#
CREATE TABLE `phpbb_music_rate` (
`rate_song_id` int(11) unsigned NOT NULL default '0',
`rate_user_id` mediumint( NOT NULL default '0',
`rate_user_ip` char( NOT NULL default '',
`rate_point` tinyint(3) unsigned NOT NULL default '0',
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;
################################################## ###################
#
#-----[ SAVE/CLOSE ALL FILES ]------------------------------------------
#
# EoM
Here is the error I recieve:
Error
SQL query:
#
# Table structure for table `phpbb_music`
#
CREATE TABLE `phpbb_music` (
`song_id` int( 11 ) unsigned NOT NULL AUTO_INCREMENT ,
`song_filename` varchar( 255 ) NOT NULL default '',
`song_imagename` varchar( 255 ) NOT NULL default '',
`song_title` varchar( 255 ) NOT NULL default '',
`song_url` varchar( 255 ) NOT NULL default '',
`song_desc` text,
`song_writer` varchar( 255 ) NOT NULL default '',
`band_website` varchar( 255 ) NOT NULL default '',
`song_user_id` mediumint( NOT NULL default '0', `song_username` varchar( 32 ) default NULL , `song_user_ip` varchar( NOT NULL default '0', `song_time` int( 11 ) unsigned NOT NULL default '0', `song_cat_id` mediumint( 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 default '0', `song_dl_enable` TINYINT( 3 ) DEFAULT '1' 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 AUTO_INCREMENT =18;
MySQL said: Documentation
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'NOT NULL default '0',
`song_username` varchar(32) default NULL,
`song_user_ip`' at line 10
SQL query:
#
# Table structure for table `phpbb_music`
#
CREATE TABLE `phpbb_music` (
`song_id` int( 11 ) unsigned NOT NULL AUTO_INCREMENT ,
`song_filename` varchar( 255 ) NOT NULL default '',
`song_imagename` varchar( 255 ) NOT NULL default '',
`song_title` varchar( 255 ) NOT NULL default '',
`song_url` varchar( 255 ) NOT NULL default '',
`song_desc` text,
`song_writer` varchar( 255 ) NOT NULL default '',
`band_website` varchar( 255 ) NOT NULL default '',
`song_user_id` mediumint( NOT NULL default '0', `song_username` varchar( 32 ) default NULL , `song_user_ip` varchar( NOT NULL default '0', `song_time` int( 11 ) unsigned NOT NULL default '0', `song_cat_id` mediumint( 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 default '0', `song_dl_enable` TINYINT( 3 ) DEFAULT '1' 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 AUTO_INCREMENT =18;
MySQL said: Documentation
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'NOT NULL default '0',
`song_username` varchar(32) default NULL,
`song_user_ip`' at line 10
Any help is appreciated!