PDA

View Full Version : installing music online mod



Aliens Anonymous
06-16-2006, 12:32 AM
Hi Dudes
Need a bit of help here.
have been trying to install a mod into a forum have managed most of it useing easymod but it would not do the database bit, said i had to do this manually. this is were i have got abit stuck does anyone now how to put this dame thing in as it's driven me nut for the last 4 hours. i've put the details below.
the forum is on http://www.aliensanonymous.org/testforum
Thank for your help and time and brain.

#-----[ SQL ]--------------------------------------------------------
# This Music Online will add 5 tables into your database.
#
# Copy the below code into phpMyAdmin (phpmyadmin.net)
# Please pay attention to the table prefix if you have specified
# something other than phpbb_ for your board's prefix.
################################################## ###################
#
# 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(8) NOT NULL default '0',
`song_username` varchar(32) default NULL,
`song_user_ip` varchar(8) NOT NULL default '0',
`song_time` int(11) unsigned NOT NULL default '0',
`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 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(8) unsigned NOT NULL auto_increment,
`cat_title` varchar(255) NOT NULL default '',
`cat_desc` text,
`cat_order` mediumint(8) 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(8) NOT NULL default '0',
`comment_username` varchar(32) default NULL,
`comment_user_ip` varchar(8) 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(8) 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(8) NOT NULL default '0',
`rate_user_ip` char(8) 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

racefan20
06-16-2006, 04:48 AM
A fat guy in a red suit with a long white beard asked me to tell you that you've received an early Christmas present. LOL

He also said to let him know, through me, if you have any problems. The instructions you were given weren't very good.

Aliens Anonymous
06-16-2006, 07:43 AM
Hay racefan tell him from me, through you, that once again he has proved that his knowledge is second to none. Thank you very much .
just one small thing, How did you do that ? as you may have seen, that forum is just a testforum so that i can do changes add mods etc. ( did not want to risk missing up the main forum again ) if you could let me know how that would be most kind. as now i know it works i will give a go on the main forum.
Tell santa there's extra cookies and milk for him.
Thanks once again race your a star.
HAVE TO GO AND DO SOME OF THAT WORK STUFF NOW SO WIIL SEE YOU LATER.

allstarfaces
06-16-2006, 07:46 AM
god your good you are race
hey aliens where did you get the **** thingy from and will it be the same headache to install on b.v normal page?

racefan20
06-16-2006, 07:53 AM
Hay racefan tell him from me, through you, that once again he has proved that his knowledge is second to none. Thank you very much .
just one small thing, How did you do that ? as you may have seen, that forum is just a testforum so that i can do changes add mods etc. ( did not want to risk missing up the main forum again ) if you could let me know how that would be most kind. as now i know it works i will give a go on the main forum.
Tell santa there's extra cookies and milk for him.
Thanks once again race your a star.
HAVE TO GO AND DO SOME OF THAT WORK STUFF NOW SO WIIL SEE YOU LATER.

The instuctions you were given are poorly written, that's why easymod couldn't write the database. I can explain more about how to do it (very easy, by the way) later, but for now, the easiest thing for you to do is to go to phpmyadmin and export each of the new tables to your pc, then once you have all the other edits done on your main site, go to the database that powers the main site and use the Import feature to bring those tables on board seamlessly. If this gives you too much trouble (it shouldn't) we'll plan a phone call sometime this weekend.

Thank the fat guy, I had nothing to do with it. LOL

Aliens Anonymous
06-16-2006, 07:56 AM
Hi Allstarfaces
don't think that would be possible the scipt is for phpBB and comes in several folders and files.
but there are some good web site player around. there's one on the interduce our site i think the blokes called ttate8 he has a good one on his site.

Aliens Anonymous
06-16-2006, 08:06 AM
Racefan have try to understand your last post but it's to early and my eyes can't focus yet, were is phpmyadmin. god i realy can't Concentrate, were's my coffee.
Tell you what race i will get back to you on this later , must go to work now.
thank once again

racefan20
06-16-2006, 08:08 AM
Racefan have try to understand your last post but it's to early and my eyes can't focus yet, were is phpmyadmin. god i realy can't Concentrate, were's my coffee.
Tell you what race i will get back to you on this later , must go to work now.
thank once again

Cpanel > mysqldatabases...scroll to the bottom. Talk to you later.

allstarfaces
06-16-2006, 08:09 AM
cheers mate wow i love your site its realy good and fun too