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!

[Yvgeniy]

Alright, I've got my first error so far. Looks like it's related to apostrophes in the names of songs:

Database error in vBulletin 3.6.4:

Invalid SQL:
update vB_mp3playlist set

id='10',

url_product='http://www.artdecade.us/AintTalkinboutLove.mp3',

url_product_stream='true',

url_product_buffer='2',

mp3name='Van Halen - Ain't Talkin' 'bout Love',

approvemp3='1'

where id='10';

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 't Talkin' 'bout Love',

approvemp3='1'

where id='10'' at line 11
Error Number : 1064
Date : Sunday, February 4th 2007 @ 10:01:32 AM
Script : http://www.sakstudios.net/forums/adm...edit_playlist1
Referrer : http://www.sakstudios.net/forums/adm...laylist1&id=10

Some other things that I'd like to note that could use improvement are:

- Ability to send mp3 notification PM to multiple users rather than just one.
- Ability to allow mods to approve mp3's rather than just admins (I haven't tried it, but I'm guessing only mods are able to approve mp3's so far).
- Perhaps ability to choose to use a different database for handling playing and play list information, in which case it would also be possible to increase the song limit and have no tax on the main forum database.

So far that's all I can think of at the moment.

[trd167]

I finally unstalled this mod, it never worked.

[Distance]

Product checking doesn't work for this?

I think you forgot to enter the product id

[Sofia]

Originally Posted by Yvgeniy

Alright, I've got my first error so far. Looks like it's related to apostrophes in the names of songs:

Database error in vBulletin 3.6.4:

Invalid SQL:
update vB_mp3playlist set

id='10',

url_product='http://www.artdecade.us/AintTalkinboutLove.mp3',

url_product_stream='true',

url_product_buffer='2',

mp3name='Van Halen - Ain't Talkin' 'bout Love',

approvemp3='1'

where id='10';

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 't Talkin' 'bout Love',

approvemp3='1'

where id='10'' at line 11
Error Number : 1064
Date : Sunday, February 4th 2007 @ 10:01:32 AM
Script : http://www.sakstudios.net/forums/adm...edit_playlist1
Referrer : http://www.sakstudios.net/forums/adm...laylist1&id=10

Some other things that I'd like to note that could use improvement are:

- Ability to send mp3 notification PM to multiple users rather than just one.
- Ability to allow mods to approve mp3's rather than just admins (I haven't tried it, but I'm guessing only mods are able to approve mp3's so far).
- Perhaps ability to choose to use a different database for handling playing and play list information, in which case it would also be possible to increase the song limit and have no tax on the main forum database.

So far that's all I can think of at the moment.

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.

[Allan]

But why this hack doen't upgrade with modifications to Sofia ??

[hotmasala4u]

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

cant find this template

$vbphrase[calendar]

not even this i am using blackice

[Yvgeniy]

Originally Posted by hotmasala4u

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

cant find this template

$vbphrase[calendar]

not even this i am using blackice

That's because blackice uses image buttons instead of the regular navbar, so you have to actually look in the header to find that, I believe. Personally, I got rid of buttons and just use the standard system. That way I don't have to make a new button each time I want to add something (example: www.sakstudios.net/forums). Let me know if you want to do the same and I'll give you the code.

Originally Posted by Sosos145

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.

Actually, that was already there to begin with. So that's not the problem.

[syrus.xl]

Originally Posted by 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.

Most of the features you've mentioned have either been fixed or added. However, since this is the free version some of these features are limited or do not exist. A Pro version was designed with many new features, including new players and skins and dynamic wording, if required.

[TeknoSounds]

Hiyas, getting this error when attempting to add a file to playlist 1 thru admincp:

Database error in vBulletin 3.6.4:

Invalid SQL:
insert into vb_mp3playlist values(

	'','http://teknosounds.com/download/mixes/dj3/drizzle.mp3','true','10','DJ^3 - Drizzle - Breaks',''

	);

MySQL Error  : Column count doesn't match value count at row 1
Error Number : 1136

Downloaded the most recent version. Tried some fixes listed but didn't seem to do anything. Anyone have suggestions on fixing this error?

Thanks in advance!

[swiss]

installed and get the following

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 : Tuesday, February 6th 2007 @ 05:54:39 AM
Script : http://<URL REMOVED>//mp3playerindex.php?do=viewmp3playerpopup
Referrer :
IP Address : 70.112.241.193
Username : <REMOVED FOR THIS POST>
Classname : vb_database

any idea's please as followed the install to a T