[markbolyard]

I have rewritten the install text so that this mod will function 100%.

When installing, please use the following instructions instead of the ones attached to this thread:

================================================== ========

To Install:
STEP 1. Import the product xml file vjukebox-product.xml
STEP 2. Upload all files in the upload folder.
STEP 3. Create a folder named media in your forumroot (or another name, you can edit the name of the folder you want to upload media in, in the ACP settings. CHMOD 777
STEP 4. Go and configure Usergroup permissions via the UserCP for usergroups. You must do this to rebuild the bitfields (Install currently doesn't do this.
STEP 5. Until this mod is repackaged, you will have to create the database tables by running the following sql queries in phpmyadmin:




-- Table structure for table `jukebox_media`
--

CREATE TABLE `jukebox_media` (
`mediaid` smallint(5) unsigned NOT NULL auto_increment,
`medianame` varchar(100) NOT NULL default '',
`mediadesc` varchar(100) NOT NULL default '',
`title` varchar(100) NOT NULL default '',
`url` varchar(100) NOT NULL default '',
`plays` smallint(5) NOT NULL default '0',
`active` int(2) NOT NULL default '0',
`userid` int(11) NOT NULL default '0',
`username` varchar(225) NOT NULL default '',
`totalrating` int(5) NOT NULL default '0',
`announce` int(2) NOT NULL default '0',
`genre` varchar(50) NOT NULL default '',
`description` varchar(250) NOT NULL default '',
`author` varchar(100) NOT NULL default '',
`album` varchar(100) NOT NULL default '',
`date` int(10) NOT NULL default '0',
`whovoted` varchar(25) NOT NULL default '',
`totalvotes` int(15) NOT NULL default '0',
PRIMARY KEY (`mediaid`)
) TYPE=MyISAM AUTO_INCREMENT=3 ;


-- Table structure for table `jukebox_comments`
--

CREATE TABLE `jukebox_comments` (
`mediaid` int(10) unsigned NOT NULL default '0',
`commentid` int(10) unsigned NOT NULL auto_increment,
`username` varchar(25) NOT NULL default '',
`userid` int(10) unsigned NOT NULL default '0',
`comment` varchar(250) NOT NULL default '',
`date` int(10) unsigned NOT NULL default '0',
`title` varchar(50) NOT NULL default '',
`lasteditdate` int(10) default NULL,
`lasteditusername` varchar(25) default NULL,
`lastedituserid` int(10) default NULL,
`ipaddress` varchar(15) default NULL,
PRIMARY KEY (`commentid`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;



STEP 6. In the jukebox.php file, find:

if ( $mid > $count['media'] ) :
eval(standard_error(fetch_error('jukebox_nonewer') ));
endif;

and DELETE IT. (This corrects the fact that you continuously get the NoNewer error phrase when clicking the media name to be viewed.)




Template Modifications:
=============================
FIND:
=============================
<td class="vbmenu_control"><a href="calendar.php$session[sessionurl_q]">$vbphrase[calendar]</a></td>
=============================
BELOW THIS, ADD:
=============================
<td class="vbmenu_control"><a href="jukebox.php$session[sessionurl_q]">Jukebox</a></td>
=============================

To Upgrade:
1. Upload all files in the upload folder to your forumroot.
2. Upload the vjukebox-product.xml file, be sure to have the "Overwrite" option in effect.

Please note:
I am completely knowledgable that this is very buggy code. This is my first coding venture and this is a PRE-ALPHA release, not meant for
production environments, but for testing and bug reporting. I will NOT officially support this until there is a stable version out. Other than my
localhost builds, this is the most unstable version of the code.

Bug Reporting:
Please report all bugs to:
http://www.digitalsupremacy.com/forums/vbugs.php

The code is not yet fully completed and is not even remotely presentable yet. So I would expect alot of bugs, and I know, you have to
register there, but this is the fastest way to debug.

Deleting function + Editting Function:
You can delete media only via the ACP at this point.

As for editting, I do not have a link to do so from the jukebox.php file, but you can do so by going to:
http://www.url.com/forums/jukebox.ph...mid=themediaid

================================================== =====

If you need help installing this mod on your forum, please feel free to PM me.

Until Cole2026 releases the non beta version, this will get you up and running!