|
Page 1 of 1
|
 mafridi 
Joined: January 2008
Posts: 21
|
 Music Online Hack (Media Center) ?
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..
|
#1 Thu 07 Feb, 2008 11:38 |
|
Sponsors
|
Icy Phoenix is an open source project, you can show your appreciation and support future development by donating to the project.
|
| |
Chaotic
Joined: January 2008
Posts: 1369
Location:  Georgia
|
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.
____________ | Icy Phoenix ColorizeIt! |
Bipolar Disorder - Not good for you and definitely not good for everyone else.
|
#2 Thu 07 Feb, 2008 11:54 |
|
mafridi
Joined: January 2008
Posts: 21
|
Re: Music Online Hack (Media Center) ?
i have the same problem admin cp is blank.... after installing this mod..
|
#4 Fri 08 Feb, 2008 05:37 |
|
Matooba
Joined: November 2008
Posts: 1
|
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:
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
Any help is appreciated!
|
#5 Fri 14 Nov, 2008 04:35 |
|
|
|
Page 1 of 1
|
 Was this topic useful?
 Was this topic useful?
| Link this topic |
|---|
| URL |
|
| BBCode |
|
| HTML |
|
You cannot post new topics
You cannot reply to topics
You cannot edit your posts
You cannot delete your posts
You cannot vote in polls
You cannot attach files
You can download files
You cannot post calendar events
|
|
|
|
Magdeburg