The Arcive of Official vBulletin Modifications Site.

vJukebox - Song and Video Management System · **Released**: 12-08-2005

vJukebox v 0.9.0 Alpha

What does this do?
This is a Jukebox system, you can add and listen to/play videos/songs, users can rate the media, comment it, and much more!
Updates:

0.9.0 - Total Rewrite, several new features, template overhall.
0.8.1 - Fixed several bugs that I overlooked at first distribution.

Known Bugs:

File Writing Error - Fix by Replicators, See this post.

To Install:
1. Import the product xml file in this folder.
2. Upload all files in the upload folder.
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
3. Enjoy.

Please note:
I will not officially support this until we get into the beta phases.

If you want to add a link to this in the navbar:
In the template: navbar
=============================
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>
=============================

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

Please Donate if you want the product to grow. I'll donate 15% of all donations I get for this project to Unicef as well.

markbolyard · #**102** 12-20-2005, 06:53 PM

Works Great. Install did not put tables into the database, so I opened the xml file up in a editor and manually added the table. Works like a charm now!

Clicks install.

MissKalunji · #**103** 12-20-2005, 08:13 PM

Quote:

Originally Posted by namesville.com

Works Great. Install did not put tables into the database, so I opened the xml file up in a editor and manually added the table. Works like a charm now!

Clicks install.

how did you? everytime i try to add the first table it keeps giving me errors

can you give me the right syntax for the tables plz?

RichieBoy67 · #**104** 12-20-2005, 08:53 PM

Can someone take these querri out of the xml and create manual instructions?? I don't have time right now but this will work fine...

markbolyard · #**105** 12-20-2005, 10:08 PM

Quote:

Originally Posted by MissKalunji

how did you? everytime i try to add the first table it keeps giving me errors

can you give me the right syntax for the tables plz?

Ok, here is the sql to create the tables... I have discovered a couple problems, which I will work out and share my fixes here. In the meantime:

Code:

-- Table structure for table `jukebox_media`
-- 

CREATE TABLE `jukebox_media` (
  `mediaid` smallint(5) unsigned NOT NULL auto_increment,
  `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 '',
  `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 ;

Code:

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

Just copy and paste these these into your sql queries box in phpmyadmin.

The one problem I am facing is a error when administering media through the admincp, and the script is trying to locate a field in the table jukebox_media called album. I imagine if I remove this from the sql file, it will take care of it. I will keep you updated as I figure things out...

Additional Note: Phrases do not get added during product import / install.

MissKalunji · #**106** 12-20-2005, 10:36 PM

Quote:

Originally Posted by namesville.com

Ok, here is the sql to create the tables... I have discovered a couple problems, which I will work out and share my fixes here. In the meantime:

Code:

-- Table structure for table `jukebox_media`
-- 

CREATE TABLE `jukebox_media` (
  `mediaid` smallint(5) unsigned NOT NULL auto_increment,
  `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 '',
  `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 ;

Code:

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

Just copy and paste these these into your sql queries box in phpmyadmin.

The one problem I am facing is a error when administering media through the admincp, and the script is trying to locate a field in the table jukebox_media called album. I imagine if I remove this from the sql file, it will take care of it. I will keep you updated as I figure things out...

Additional Note: Phrases do not get added during product import / install.

Thanks! well my phrases were added let u know if i found anything before you

markbolyard · #**107** 12-20-2005, 11:30 PM

Ok, need to add a additional field under jukebox_media. Go to phpmyadmin, browse to jukebox_media, view structure, and add field:

album varchar 100 (leave the rest untouched) and save... this will fix the error when you try to edit a media file through the admincp.

RichieBoy67 · #**108** 12-20-2005, 11:44 PM

Great... Thanks.... I never looked at the xml file. I thought there were more than that...lol

Thanks much!!!

So the problem is that these are not being installed with older versions of mysql but as loing as you do them manualy your fine. Worked for me anyways...

markbolyard · #**109** 12-20-2005, 11:51 PM

Well, I am down to one last issue. Maybe one of you got through it and can help me now

I uploaded a video. If I click the link under "Highest Rated Media" the video opens in windows media player which is fine. Now the problem is when I click the link under "Most Accessed Media" or "List of Media", i get this message: There are no more entries to view.

It worked the very first time I tried this right after the install and additions to the database (when I clicked the media, I was taken to a template that displayed it, not right to my windows media player) Now, no go...

Thanks for any suggestions.

MissKalunji · #**110** 12-20-2005, 11:56 PM

Quote:

Originally Posted by namesville.com

Ok, need to add a additional field under jukebox_media. Go to phpmyadmin, browse to jukebox_media, view structure, and add field:

author varchar 100 (leave the rest untouched) and save... this will fix the error when you try to edit a media file through the admincp.

Quote:

Invalid SQL:

UPDATE jukebox_media SET
title = 'test',
author = 'test',
album = '',
url = 'http://dancehallareaz.com/forum/media/Lion king - Theme song.mp3',
genre = ''
WHERE mediaid = '6';

MySQL Error : Unknown column 'album' in 'field list'
Error Number : 1054
Date : Tuesday, December 20th 2005 @ 08:52:12 PM
Script : http://www.dancehallareaz.com/forum/...keboxadmin.php
Referrer : http://www.dancehallareaz.com/forum/...ditmedia&mid=6

thats whats happening still...and author still there

and i also get that error

uploaded_file(): Unable to move '/tmp/phpOeywfz' to '/xxxx/xxxx/xxxxx/forum/media/you are my sunshine.mp3' in /jukebox.php on line

silurius · #**111** 12-21-2005, 12:06 AM

I have a feeling that if imp can be accomodated, this extension could become quite powerful. Check out http://www.playimp.com.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.05403 seconds Memory Usage 2,329KB Queries Executed 26 (?)
More Information
Template Usage: (1)SHOWTHREAD (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)ad_showthread_beforeqr (4)bbcode_code (5)bbcode_quote (1)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)modsystem_post (1)navbar (6)navbar_link (120)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (1)pagenav_pagelinkrel (11)post_thanks_box (11)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (11)post_thanks_postbit_info (10)postbit (11)postbit_onlinestatus (11)postbit_wrapper (1)spacer_close (1)spacer_open (1)tagbit_wrapper Phrase Groups Available: global inlinemod postbit posting reputationlevel showthread	Included Files: ./showthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/functions_bigthree.php ./includes/class_postbit.php ./includes/class_bbcode.php ./includes/functions_reputation.php ./includes/functions_post_thanks.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete showthread_start showthread_getinfo forumjump showthread_post_start showthread_query_postids showthread_query bbcode_fetch_tags bbcode_create showthread_postbit_create postbit_factory postbit_display_start post_thanks_function_post_thanks_off_start post_thanks_function_post_thanks_off_end post_thanks_function_fetch_thanks_start post_thanks_function_fetch_thanks_end post_thanks_function_thanked_already_start post_thanks_function_thanked_already_end fetch_musername postbit_imicons bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete postbit_display_complete post_thanks_function_can_thank_this_post_start pagenav_page pagenav_complete tag_fetchbit_complete forumrules navbits navbits_complete showthread_complete
Messages:

The Arcive of Official vBulletin Modifications Site.

It is not a VB3 engine, just a parsed copy!