Major Additions - The XEON Mp3 Player for vBulletin 3.6.X Integrated

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:

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

Above add:

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

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

After add:

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

[Neal-UK]

What errors are you getting?

[Ryloth]

I'm getting the below error when attempting to goto: /forums/mp3playerindex.php?do=viewmp3playerpopup

PHP Code:

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 


If I goto just mp3playerindex.php its a blank screen.

Help.

[LisaD1]

This is the navbar error

 
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
Date         : Saturday, February 3rd 2007 @ 08:05:05 PM
Script       : http://www.live-love-chat.com/forums...mp3playerpopup
Referrer     : 
IP Address   : 70.78.7.84
Username     : Lisa
Classname    : vb_database

And this is the add error

 
Database error in vBulletin 3.6.4:
Invalid SQL:
insert into mp3playlist values(
 '','http://filecargo.com/dw.php?id=1170548929','true','0','',''
 );
MySQL Error  : Column count doesn't match value count at row 1
Error Number : 1136
Date         : Saturday, February 3rd 2007 @ 08:06:19 PM
Script       : http://www.live-love-chat.com/forums..._add_playlist1
Referrer     : http://www.live-love-chat.com/forums...o=addplaylist1
IP Address   : 70.78.7.84
Username     : Lisa
Classname    : vb_database

[Ryloth]

Oh good, I'm not the only one with that database error.

[LisaD1]

Originally Posted by Ryloth

Oh good, I'm not the only one with that database error.

No I guess not. All we have to hope for is a fast fix!!!

[Neal-UK]

Here you go: https://vborg.vbsupport.ru/showpost....&postcount=422

Think you got to unistall first, and re-install with the edited plugin file ;-)

[LisaD1]

Originally Posted by Neal-UK

Here you go: https://vborg.vbsupport.ru/showpost....&postcount=422

Think you got to unistall first, and re-install with the edited plugin file ;-)

OK I will check it out!!
Thanks!

[syrus.xl]

Originally Posted by Ryloth

I'm getting the below error when attempting to goto: /forums/mp3playerindex.php?do=viewmp3playerpopup

PHP Code:

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 


If I goto just mp3playerindex.php its a blank screen.

Help.

The mp3playerindex.php file is not accessible directly, it relies on 'do' functions - therefore it will display a white page.

The error is relating to a database field missing - this will be fixed shortly, without having to uninstall and reinstall the product.xml file. I'll export a copy of the updated file from the development site and update the package on here.

[Yvgeniy]

Just thought I'd mention a few bugs or things that could use improvement. The PM Admin Text To User type box has a fairly small character limit, which limits the amount of stuff you can write. Pretty annoying if you ask me. The message after you add an mp3 says "The MP3 has been added to are database" or something along those lines. My point is that it's "are" instead of "our." That's all I noticed so far.

[cajunboy2208]

Can someone post a link to their site that has it running? I want to see exactly how it works, and if it is resizeable... it looks huge.