Announcement

Collapse
No announcement yet.

installing music online mod

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • 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
    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.
    My NASCAR Forum

    Comment


    • #3
      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.

      Comment


      • #4
        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

        Comment


        • #5
          Re: installing music online mod

          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
          My NASCAR Forum

          Comment


          • #6
            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.

            Comment


            • #7
              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

              Comment


              • #8
                Re: installing music online mod

                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.
                My NASCAR Forum

                Comment


                • #9
                  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

                  Comment

                  Working...
                  X