The Arcive of Official vBulletin Modifications Site.

The XEON Mp3 Player for vBulletin 3.6.X Integrated · **Version:** 3.6.11

The XEON Mp3 Player for vBulletin 3.6.X

Design: Syrus XL Media 2003-2007
Coding Update: vBmotion.com

Demo: www.digitalport.co.uk (Click Entertainment>XEON Mp3 Player)

Important: Supported only on Digital Port UK

Update Rev: 4.0.1 - Navbar code updated to work with vBadvanced CMPS outside the forum directory.
Updated Rev: 4.0.0 - All known bugs fixed in AdminCP, these include the Approve Mp3 issue and the Edit Mp3 problem.
Added: 21/04/07 - XEON Player in vB Custom Page Instructions.zip
Demo: http://www.digitalport.co.uk/digital...&template=Xeon

Version: 3.6.0 coding (Major UPDATE) *see below
Version: 3.5.1 coding (Product XML file updated)
Version: 3.0 XEON Player (Shuffle disabled) *Player Only Package* added.

Fully compatible and tested on vBulletin 3.6.0, 3.7 and up.

No example tracks are included in this version.

*IMPORTANT: About version 3.6!!*
If you have installed this modification prior to the latest version 3.6, it is recommended that you update to the latest version 3.6 immediately. Older versions contain a Security Hole in the admin section. All database errors have been fixed, special thanks to Code Monkey.

[high]External Data Pull[/high]
This modification is designed to pull data from internal and external servers. Check that you enter full urls to pull external data or the modification will fail to read.

[high]Features:[/high]

Can hold upto 500 mp3 tracks (5 playlists with 100 tracks in each)
Automatically cuts off access to playlists if 100 tracks are reached
All track data held in database
Volume & Pan(balance) Controls
Add mp3's through AdminCP or via Popup
PM system notifcation of new tracks submitted
Edit/Delete/Approve/Deny tracks via AdminCP
Usergroup Permissions for adding tracks and viewing of player
Multi-functional display on mp3 player
WOL Enabled - see who's using the mp3 player
Stream and Buffer parameters per track
Track pre-loading on display

This version is not compatible with the XML driven vbMp3 Player I released awhile ago (you may uninstall or leave in, as this version uses renamed files). The player, and all code have been changed, and now fully utilizes the vBulletin AdminCP for settings, mp3 playlist management, usergroup permissions.

[high]Known Issues:[/high]
None

UPDATING:
Overwrite all files with the new package XEON Mp3 Player v4.0.0
Import the Product XML file using the vBulletin Product Manager. Go to Mp3 Player Management and update settings and Save.

Template edit:
(required on new install or upgrade, unless you have installed other products from us.).
In the headinclude template -
Find:

Code:

<script type="text/javascript" src="clientscript/vbulletin_global.js?v=$vboptions[simpleversion]"></script>

Above add:

Code:

<script type="text/javascript" src="clientscript/flashobject.js"></script>

If this line of code already exists then DO NOT ADD IT!

End of Update

MAIN INSTALLATION

Installation:
Upload the contents of the ?Upload folder? to your forum root. Import the ?product-mp3player.xml? file via ?Plugins & Products? ? Manage Products ? Import Product in your AdminCP. Press F5 or refresh your browser window to view the Mp3 Player Management menu. Once you install this version make sure you Update the MP3 Management settings and click SAVE, failure to do so will result in an error if you enable the custom PM notification system.

Template Edits:
These edits are based on the default vBulletin style, you may need to change if you have a custom style.

AdminCP -> Styles & Templates -> Navigation / Breadcrumb Templates -> navbar

Find:

Code:

<td class="vbmenu_control"><a href="calendar.php$session[sessionurl_q]">$vbphrase[calendar]</a></td>

After add:

Code:

<!-- Mp3 Player Launch -->
<if condition="$show['member']">
<td class="vbmenu_control"><a href="javascript:NewWindow=window.open('$vboptions[bburl]/mp3playerindex.php?do=viewmp3playerpopup','newWin','width=500,height=500,left=0,top=0, toolbar=No,location=No,scrollbars=1,status=No,resizable=No,fullscreen=No');
NewWindow.focus(); void(0);">vbMp3 Player</a></td>
</if>
<!-- End Mp3 Player Launch -->

Now, navigate to AdminCP -> Usergroups -> Usergroup Manager ? adjust usergroups permissions as required. Default is all usergroups have no access.

You now have the vbMp3 XEON player installed!

[high]Update notifications can only be sent out if you have clicked 'INSTALL'.[/high]

More players will available shortly.

Enjoy!

winpro19 · #**422** 12-27-2006, 10:26 AM

same error for me mate
SELECT COUNT(*) AS id
FROM mp3playlist AS mp3playlist WHERE approvemp3=1;

Allan · #**423** 12-27-2006, 10:32 AM

In xml file, find:

Code:

<codes>
        <code version="beta 1">
            <installcode><![CDATA[$db->reporterror = 0;
echo "Adding Tables<br /><br />";
$vbulletin->db->query_write("CREATE TABLE ". TABLE_PREFIX ."mp3playlist (
`id` int(11) NOT NULL auto_increment,
  `url_product` varchar(255) NOT NULL default '',
  `url_product_stream` varchar(100) NOT NULL default '',
  `url_product_buffer` int(1) NOT NULL default '0',
  `mp3name` varchar(155) NOT NULL default '',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM");
echo "<font size=\"1\">Added Table - mp3playlist1</font><br />";

$vbulletin->db->query_write("CREATE TABLE ". TABLE_PREFIX ."mp3playlist1 (
`id` int(11) NOT NULL auto_increment,
  `url_product` varchar(255) NOT NULL default '',
  `url_product_stream` varchar(100) NOT NULL default '',
  `url_product_buffer` int(1) NOT NULL default '0',
  `mp3name` varchar(155) NOT NULL default '',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM");
echo "<font size=\"1\">Added Table - mp3playlist2</font><br />";

$vbulletin->db->query_write("CREATE TABLE ". TABLE_PREFIX ."mp3playlist2 (
`id` int(11) NOT NULL auto_increment,
  `url_product` varchar(255) NOT NULL default '',
  `url_product_stream` varchar(100) NOT NULL default '',
  `url_product_buffer` int(1) NOT NULL default '0',
  `mp3name` varchar(155) NOT NULL default '',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM");
echo "<font size=\"1\">Added Table - mp3playlist3</font><br />";

$vbulletin->db->query_write("CREATE TABLE ". TABLE_PREFIX ."mp3playlist3 (
`id` int(11) NOT NULL auto_increment,
  `url_product` varchar(255) NOT NULL default '',
  `url_product_stream` varchar(100) NOT NULL default '',
  `url_product_buffer` int(1) NOT NULL default '0',
  `mp3name` varchar(155) NOT NULL default '',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM");
echo "<font size=\"1\">Added Table - mp3playlist4</font><br />";

$vbulletin->db->query_write("CREATE TABLE ". TABLE_PREFIX ."mp3playlist4 (
`id` int(11) NOT NULL auto_increment,
  `url_product` varchar(255) NOT NULL default '',
  `url_product_stream` varchar(100) NOT NULL default '',
  `url_product_buffer` int(1) NOT NULL default '0',
  `mp3name` varchar(155) NOT NULL default '',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM");
echo "<font size=\"1\">Added Table - mp3playlist5</font><br />";

$vbulletin->db->query_write("CREATE TABLE IF NOT EXISTS " . TABLE_PREFIX . "mp3player_settings (
    active int(11) NOT NULL default '0',
  pmadminid int(11) NOT NULL default '0',
  pmactive int(11) NOT NULL default '0',
  pmadminname varchar(150) NOT NULL default '',
  pmadmintitle varchar(150) NOT NULL default '',
  pmadmintext varchar(255) NOT NULL default '',
  approvemp3 int(11) NOT NULL default '0')");
echo "<font size=\"1\">Added Table - mp3player_settings</font><br />";

$vbulletin->db->query_write("INSERT INTO " . TABLE_PREFIX . "mp3player_settings VALUES (1, 1, 1, 'ADMIN NAME', 'New MP3 Added', 'This is a test to see if the pm system works', 0)");
echo "<font size=\"1\">Settings Added</font><br />";

$vbulletin->db->query_write("ALTER TABLE " . TABLE_PREFIX . "usergroup ADD COLUMN mp3playergrouppermissions INT(10) UNSIGNED NOT NULL DEFAULT '0'");
echo "<font size=\"1\">Added usergroup - Permissions</font><br />";

// Rebuild Bitfields
require_once(DIR . '/includes/class_bitfield_builder.php');
vB_Bitfield_Builder::save($db);
build_forum_permissions();
echo "<font size=\"1\">vB Bitfield Builder Done</font><br />";]]></installcode>
            <uninstallcode><![CDATA[$db->query("DELETE FROM " . TABLE_PREFIX . "template WHERE title LIKE 'mp3player_%'");
$db->query("DELETE FROM " . TABLE_PREFIX . "template WHERE title='mp3player'");
$db->query("DELETE FROM " . TABLE_PREFIX . "phrase WHERE varname LIKE 'mp3player_%'");

$db->query("
        DROP TABLE IF EXISTS " . TABLE_PREFIX . "mp3playlist
    ");
    
$db->query("
        DROP TABLE IF EXISTS " . TABLE_PREFIX . "mp3playlist1
    ");
    
$db->query("
        DROP TABLE IF EXISTS " . TABLE_PREFIX . "mp3playlist2
    ");
    
$db->query("
        DROP TABLE IF EXISTS " . TABLE_PREFIX . "mp3playlist3
    ");
    
$db->query("
        DROP TABLE IF EXISTS " . TABLE_PREFIX . "mp3playlist4
    ");]]></uninstallcode>
        </code>
    </codes>

Replace with:

Code:

<codes>
        <code version="beta 1">
            <installcode><![CDATA[$db->reporterror = 0;
echo "Adding Tables<br /><br />";
$vbulletin->db->query_write("CREATE TABLE ". TABLE_PREFIX ."mp3playlist (
`id` int(11) NOT NULL auto_increment,
  `url_product` varchar(255) NOT NULL default '',
  `url_product_stream` varchar(100) NOT NULL default '',
  `url_product_buffer` int(1) NOT NULL default '0',
  `mp3name` varchar(155) NOT NULL default '',
`approvemp3` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM");
echo "<font size=\"1\">Added Table - mp3playlist1</font><br />";

$vbulletin->db->query_write("CREATE TABLE ". TABLE_PREFIX ."mp3playlist1 (
`id` int(11) NOT NULL auto_increment,
  `url_product` varchar(255) NOT NULL default '',
  `url_product_stream` varchar(100) NOT NULL default '',
  `url_product_buffer` int(1) NOT NULL default '0',
  `mp3name` varchar(155) NOT NULL default '',
`approvemp3` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM");
echo "<font size=\"1\">Added Table - mp3playlist2</font><br />";

$vbulletin->db->query_write("CREATE TABLE ". TABLE_PREFIX ."mp3playlist2 (
`id` int(11) NOT NULL auto_increment,
  `url_product` varchar(255) NOT NULL default '',
  `url_product_stream` varchar(100) NOT NULL default '',
  `url_product_buffer` int(1) NOT NULL default '0',
  `mp3name` varchar(155) NOT NULL default '',
`approvemp3` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM");
echo "<font size=\"1\">Added Table - mp3playlist3</font><br />";

$vbulletin->db->query_write("CREATE TABLE ". TABLE_PREFIX ."mp3playlist3 (
`id` int(11) NOT NULL auto_increment,
  `url_product` varchar(255) NOT NULL default '',
  `url_product_stream` varchar(100) NOT NULL default '',
  `url_product_buffer` int(1) NOT NULL default '0',
  `mp3name` varchar(155) NOT NULL default '',
`approvemp3` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM");
echo "<font size=\"1\">Added Table - mp3playlist4</font><br />";

$vbulletin->db->query_write("CREATE TABLE ". TABLE_PREFIX ."mp3playlist4 (
`id` int(11) NOT NULL auto_increment,
  `url_product` varchar(255) NOT NULL default '',
  `url_product_stream` varchar(100) NOT NULL default '',
  `url_product_buffer` int(1) NOT NULL default '0',
  `mp3name` varchar(155) NOT NULL default '',
`approvemp3` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM");
echo "<font size=\"1\">Added Table - mp3playlist5</font><br />";

$vbulletin->db->query_write("CREATE TABLE IF NOT EXISTS " . TABLE_PREFIX . "mp3player_settings (
    active int(11) NOT NULL default '0',
  pmadminid int(11) NOT NULL default '0',
  pmactive int(11) NOT NULL default '0',
  pmadminname varchar(150) NOT NULL default '',
  pmadmintitle varchar(150) NOT NULL default '',
  pmadmintext varchar(255) NOT NULL default '',
  approvemp3 int(11) NOT NULL default '0')");
echo "<font size=\"1\">Added Table - mp3player_settings</font><br />";

$vbulletin->db->query_write("INSERT INTO " . TABLE_PREFIX . "mp3player_settings VALUES (1, 1, 1, 'ADMIN NAME', 'New MP3 Added', 'This is a test to see if the pm system works', 0)");
echo "<font size=\"1\">Settings Added</font><br />";

$vbulletin->db->query_write("ALTER TABLE " . TABLE_PREFIX . "usergroup ADD COLUMN mp3playergrouppermissions INT(10) UNSIGNED NOT NULL DEFAULT '0'");
echo "<font size=\"1\">Added usergroup - Permissions</font><br />";

// Rebuild Bitfields
require_once(DIR . '/includes/class_bitfield_builder.php');
vB_Bitfield_Builder::save($db);
build_forum_permissions();
echo "<font size=\"1\">vB Bitfield Builder Done</font><br />";]]></installcode>
            <uninstallcode><![CDATA[$db->query("DELETE FROM " . TABLE_PREFIX . "template WHERE title LIKE 'mp3player_%'");
$db->query("DELETE FROM " . TABLE_PREFIX . "template WHERE title='mp3player'");
$db->query("DELETE FROM " . TABLE_PREFIX . "phrase WHERE varname LIKE 'mp3player_%'");

$db->query("
        DROP TABLE IF EXISTS " . TABLE_PREFIX . "mp3playlist
    ");
    
$db->query("
        DROP TABLE IF EXISTS " . TABLE_PREFIX . "mp3playlist1
    ");
    
$db->query("
        DROP TABLE IF EXISTS " . TABLE_PREFIX . "mp3playlist2
    ");
    
$db->query("
        DROP TABLE IF EXISTS " . TABLE_PREFIX . "mp3playlist3
    ");
    
$db->query("
        DROP TABLE IF EXISTS " . TABLE_PREFIX . "mp3playlist4
    ");]]></uninstallcode>
        </code>
    </codes>

PS: Thanks Sofia ^^

winpro19 · #**424** 12-28-2006, 02:45 AM

thanks it worked!

blogtorank · #**425** 12-28-2006, 03:18 AM

Edit, will try the above as I didn't want to read 29 pages to see of this ERR.

Will update this post if that fixes it.

++++++++++++++++++++++++++++++++++++++++++++++++++ ++++++++++++++

Edit: After doing what Allan above suggested:

Quote:

Database error in vBulletin 3.6.4:

Invalid SQL:

SELECT COUNT(*) AS id
FROM mp3playlist AS mp3playlist WHERE approvemp3=1;

MySQL Error : Unknown column 'approvemp3' in 'where clause'
Error Number : 1054

Here's my MySQL version:

5.0.27

++++++++++++++++++++++++++++++++++++++++++++++++++ ++++++++

When in doubt, drop the damned product and reinstall fresh

, Allan you are a genius man, Thanks!!!!

loonytune15 · #**426** 12-28-2006, 01:32 PM

Great hack, installed though i had to do the fix a couple of posts above..

TTG · #**427** 12-28-2006, 11:04 PM

Thanks for the fix Alan .. un-installed -- made the xml edit and re-installed and now working well ..

StuntFactoryX · #**428** 12-29-2006, 10:18 PM

im trying to map this out and wanted to get some input... i was thinking of importing my songs from the download folder from the downloads2 hack... that way users can listen and download if they like and users can upload there and i can import... how do u think that will work and if other file extensions in there like zip or jpgs?

imk · #**429** 12-29-2006, 10:33 PM

Database error in vBulletin 3.6.4:

i did the fix but im getin

XML Error: mismatched tag at Line 378

Khawar · #**430** 12-31-2006, 04:52 AM

Does it work as a pop up or no?
all i want to ask is that while listening to the songs, r my users gone be able to browse the forums aswell or no????

TTG · #**431** 12-31-2006, 08:39 AM

Quote:

Originally Posted by Khawar

Does it work as a pop up or no?
all i want to ask is that while listening to the songs, r my users gone be able to browse the forums aswell or no????

It does in Firefox and IE

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.06866 seconds Memory Usage 2,356KB Queries Executed 27 (?)
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 (6)bbcode_code (2)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 (3)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_postinfo_query fetch_postinfo 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!