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!

[AFemaleProdigy]

I have also installed and am getting an error when I click the link to view the player and also an error when I tryto add a new playlist.

--------------------------------
Database error in vBulletin 3.6.5:
Invalid SQL:
SELECT COUNT(*) AS id
FROM mp3playlist AS mp3playlist WHERE approvemp3=1;
MySQL Error : Unknown column 'approvemp3' in 'where clause'
Error Number : 1054
-------------------------------
Database error in vBulletin 3.6.5:
Invalid SQL:
insert into mp3playlist values(
'','http://jessicabolin.com/media/mp3/Slipknot-Vermilion2.mp3','true','0','Slipknot Vermillion Pt 2',''
);
MySQL Error : Column count doesn't match value count at row 1
Error Number : 1136

----------------------------------------
Update:

I read through the posts and saw someone suggest making some changes to the product xml. I did that and now the errors are gone. However, the mp3 files do not play or show up in the player. I checked my usergroup permissions and they are enabled, the player is enabled, and I verified the url to the mp3. Everything looks in order. Any idea why this would not play or show the mp3s? Thanks.

----------------------------------------
Update 2:

Okay, I am retarded! I just realized that I didn't have the little "approve" checked to "yes" for my mp3s. Duh! Haha!

-----------------------------------------
Conclusion:

This is a good hack so far. I just suggest adding those changes to the product xml as mentioned in previous posts so people don't have to go searching all over for a solution to the errors like I did. Plus, I see that a lot of people haven't gone so far as to look through the posts as I did. Would save a lot of trouble for others.

Thanks for the hack though!

[Conlons]

Hi there Syrus

Installed but then get the following error can you please shed some light

Database error in vBulletin 3.6.4:

Invalid SQL:

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

MySQL Error : Unknown column 'approvemp3' in 'where clause'
Error Number : 1054
Date : Friday, March 9th 2007 @ 11:22:17 AM
Script : http://www.conlons.co.uk/forum/mp3pl...mp3playerpopup
Referrer :
IP Address : 81.178.0.78
Username : *******
Classname : *******

[AFemaleProdigy]

Originally Posted by Conlons

Hi there Syrus

Installed but then get the following error can you please shed some light

Database error in vBulletin 3.6.4:

Invalid SQL:

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

MySQL Error : Unknown column 'approvemp3' in 'where clause'
Error Number : 1054
Date : Friday, March 9th 2007 @ 11:22:17 AM
Script : http://www.conlons.co.uk/forum/mp3pl...mp3playerpopup
Referrer :
IP Address : 81.178.0.78
Username : *******
Classname : *******

Read back through the old posts. I had the same problem, but there is a solution given on one of the past pages. I can't remember the page number though. It's just some simple edits to your product xml file. Took care of the errors for me.

[The Bish]

Originally Posted by AFemaleProdigy

Read back through the old posts. I had the same problem, but there is a solution given on one of the past pages. I can't remember the page number though. It's just some simple edits to your product xml file. Took care of the errors for me.

Installed (Clicked Installed) and with same above error regardless of the XML fix. I am sure once all the kinks are out it will be a very nice mod for my site!

[AFemaleProdigy]

These were the instructions I followed to get rid of my errors (listed in an earlier post of mine) and this worked. Make sure you are adding that new code to all of the tables listed there in red, plus mp3playlist5. It also says "disable" the plugin. I completely uninstalled and then reinstalled the product xml/plugin.

Originally Posted by Sofia

For vb 3.6.4

Find in the product xml :

PHP Code:

`mp3name` varchar(155) NOT NULL default '', 


and add below :

PHP Code:

`approvemp3` int(11) NOT NULL default '0', 


for tables : mp3playlist1, mp3playlist2, mp3playlist3, mp3playlist4 and mp3playersettings

Then you must to disable the product, and reinstall it.

[syrus.xl]

Looks like I'll have to update this error myself, since I haven't seen my co-author address the problem. I was hoping to have this mod fully working, since I've got another nearly ready.

The product xml file error is partially my fault for using a 3rd party exporter, which vb's product system doesn't seem to like. I'll try and get this issue addressed this weekend.

Sorry for the inconvenience.

[lonelime]

hi ...

is this one updated?

[Performance Pol]

Have uploaded all files installed product

try to edit templates and this what I get when trying to save....

Have checked to see if template.php is there and it is

Not sure what to do next...

"Not Acceptable

An appropriate representation of the requested resource /Forum/admincp/template.php could not be found on this server."

Cheers if anyone can help

Col

[syrus.xl]

Originally Posted by lonelime

hi ...

is this one updated?

I've been trying to get this updated for some time now - everytime I go to do the update, something else comes along. I'll try and get it fully updated this week, and send out notifcations when its done.

Sorry for the delay...

[syrus.xl]

Originally Posted by Performance Pol

Have uploaded all files installed product

try to edit templates and this what I get when trying to save....

Have checked to see if template.php is there and it is

Not sure what to do next...


"Not Acceptable

An appropriate representation of the requested resource /Forum/admincp/template.php could not be found on this server."

Cheers if anyone can help


Col

Are you receiving this error from the standard vBulletin style, or a custom style? With some styles the template edit maybe slightly different.