Results 1 to 9 of 9

Thread: installing music online mod
      
   

  1. #1
    Join Date
    Jan 2006
    Location
    Dark side of the moon
    Posts
    1,144

    Thumbs up installing music online mod

    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( 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

  2. #2
    Join Date
    Jul 2005
    Location
    Concord, NC
    Posts
    2,335

    Default Re: installing music online mod

    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.

  3. #3
    Join Date
    Jan 2006
    Location
    Dark side of the moon
    Posts
    1,144

    Default Re: installing music online mod

    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.

  4. #4
    Join Date
    Apr 2006
    Location
    manchester england
    Posts
    1,665

    Default Re: installing music online mod

    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?
    The get vasili to join our forum campaign has begun



    www.thatgoodsite.com and our forum of fun also starring my hero vasili
    Weve got movies,arcade,radio,T.V,chat,music,funny vids,jokes and lots and lots of fun for free

  5. #5
    Join Date
    Jul 2005
    Location
    Concord, NC
    Posts
    2,335

    Default Re: installing music online mod

    Quote Originally Posted by Aliens Anonymous
    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

  6. #6
    Join Date
    Jan 2006
    Location
    Dark side of the moon
    Posts
    1,144

    Default Re: installing music online mod

    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.

  7. #7
    Join Date
    Jan 2006
    Location
    Dark side of the moon
    Posts
    1,144

    Default Re: installing music online mod

    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

  8. #8
    Join Date
    Jul 2005
    Location
    Concord, NC
    Posts
    2,335

    Default Re: installing music online mod

    Quote Originally Posted by Aliens Anonymous
    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.

  9. #9
    Join Date
    Apr 2006
    Location
    manchester england
    Posts
    1,665

    Default Re: installing music online mod

    cheers mate wow i love your site its realy good and fun too
    The get vasili to join our forum campaign has begun



    www.thatgoodsite.com and our forum of fun also starring my hero vasili
    Weve got movies,arcade,radio,T.V,chat,music,funny vids,jokes and lots and lots of fun for free

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

     

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •