The XEON Mp3 Player for vBulletin 3.6.X Integrated

[Stavs16]

mine does not contain that code in the header template.

[syrus.xl]

mine does not contain that code in the header template.

I just had a quick look at the Style you are using - it looks like its using customized images for the links in the header. The navbar has been removed in the style.

You would need to change one of these images to launch the player. Does the style come with a spliced PSD (Photoshop Document)? Many free styles don't, that's why I'm asking. Because you would need to edit a button image and then change the code accordingly.

[Stavs16]

no it doesnt come with that.

what do i need to to then?

[syrus.xl]

no it doesnt come with that.

what do i need to to then?

Firstly, you will need to edit one of your buttons in the header, so it reads something like 'mp3 player'. To do this you would need to recreate an exact replica of one of the existing buttons, but replacing the text. It's not an easy job without the original photoshop document.

Then the code for the button would need to be swapped out.

If you can try and create a button first, because if you can get that done, then the rest is quite easy.

[fly]

[SUGGESTION]
Anyway that you can change some of the text to be a vB forum color and not black? This is what I get when I add an mp3:

http://upload.pzind.com/files/2/mp3.JPG

[PROBLEM]
The software isn't working for me. It says that the track was added, but nothing ever shows up on the playlist

[syrus.xl]

[SUGGESTION]
Anyway that you can change some of the text to be a vB forum color and not black? This is what I get when I add an mp3:

http://upload.pzind.com/files/2/mp3.JPG

[PROBLEM]
The software isn't working for me. It says that the track was added, but nothing ever shows up on the playlist

The modification was based on a non-modified vbulletin board, so your CSS is probably set differently. You could get around this by adding your own new text definition in additional CSS of your custom Style, the change the classes in the mp3player_ templates.

The background of the mp3 flash player can also be changed. All it uses is a HEX color value which is in the mp3player_popup template of your style. Here's the default code:
<!-- Xeon popup -->

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


<!-- js flashobject -->

<div align="center" width="100%" id="xeon_vbMp3_player">
Warning!!! To view this vbMp3 Player please enable JavaScript and Flash!
</div>
<script type="text/javascript">
var fo = new FlashObject("xeon_mp3_beta.swf", "xeon_vbMp3_player", "450", "400", "8,0,0,0", "#666666");
fo.addParam("quality", "high");
fo.write("xeon_vbMp3_player");
</script>

<!-- js flashobject -->
As you can see there is a HEX color value variable "#666666" - this is the background color of the player and can be changed to match your styles background.

HTH

[fly]

The modification was based on a non-modified vbulletin board, so your CSS is probably set differently. You could get around this by adding your own new text definition in additional CSS of your custom Style, the change the classes in the mp3player_ templates.

But all that needs to be added to that template is the vB code to use whatever color the forum is using. I don't think it should need any custom CSS, no?

And how do I troubleshoot this problem where MP3s aren't actually getting added to the playlist? I'm not getting any error in the browser, nor in the server logs.

[syrus.xl]

But all that needs to be added to that template is the vB code to use whatever color the forum is using. I don't think it should need any custom CSS, no?

I'll check the default class on normal text this.


And how do I troubleshoot this problem where MP3s aren't actually getting added to the playlist? I'm not getting any error in the browser, nor in the server logs.

There is a bug in the AdminCP which means even if you save your settings as not to approve new tracks added it doesnt save the setting. If you check the playlists you added these tracks to in the AdminCP, you should see they are not approved, once you approve them they will show.

All these errors will be fixed in the update.

[Stavs16]

Firstly, you will need to edit one of your buttons in the header, so it reads something like 'mp3 player'. To do this you would need to recreate an exact replica of one of the existing buttons, but replacing the text. It's not an easy job without the original photoshop document.

Then the code for the button would need to be swapped out.

If you can try and create a button first, because if you can get that done, then the rest is quite easy.


i doubt i'll be able to do this. :confused:

[Stavs16]

where does the sfo files go? i get this error could not find phrase 'mp3player_cp_redirect" ?

and can u upload songs from your own computer or does it have to be the web.

[fly]

I'll check the default class on normal text this.



There is a bug in the AdminCP which means even if you save your settings as not to approve new tracks added it doesnt save the setting. If you check the playlists you added these tracks to in the AdminCP, you should see they are not approved, once you approve them they will show.

All these errors will be fixed in the update.

That was the problem, thanks. Can I suggest that the submitter be added in the approve list?

[syrus.xl]

That was the problem, thanks. Can I suggest that the submitter be added in the approve list?

Thats a good idea..:) Will look into that, with the full release to take this out of its beta release.

[haytham]

I already have flashobject.js in my root folder ( from The vbFLV Video Player) do I ftp it again or skip it

[haytham]

I did all the instructions but can't see anything in my ADmin CP. The only thing I didn't upload is (flashobject.js ) and if I click on the link in navbar it says I am not allowed to have access to that page...help if u can..thanks

new development: the MP3 settings menu showed up in the Admincp but still the same message ( not allowed to access this page) comes up and when trying to save settings I get (couldn't find phrase 'mp3player_cp_redirect')

[syrus.xl]

I already have flashobject.js in my root folder ( from The vbFLV Video Player) do I ftp it again or skip it

The flashobject.js file you will find is common with all my releases, it makes all the flash movies cross-browser compatible.

I did all the instructions but can't see anything in my ADmin CP. The only thing I didn't upload is (flashobject.js ) and if I click on the link in navbar it says I am not allowed to have access to that page...help if u can..thanks

You will need to import the Product XML file and then Refresh the AdminCP to see the 'MP3 Player Management' in the left side menu.

Also check you have allowed your usergroup access - Usergroups - Edit - Check permissions per usergroup. You should be all set then.

HTH
:)

[haytham]

How stupid I feel...If I had read your instructions carefully I wouldn't have made such a fool of myself...I was missing this (Also check you have allowed your usergroup access - Usergroups - Edit - Check permissions per usergroup)
Sorry..All good..I have also installed your vdo mod...You guys rock :)

[syrus.xl]

How stupid I feel...If I had read your instructions carefully I wouldn't have made such a fool of myself...I was missing this (Also check you have allowed your usergroup access - Usergroups - Edit - Check permissions per usergroup)
Sorry..All good..I have also installed your vdo mod...You guys rock :)

Easily overlooked... ;)

[Stavs16]

i get this error could not find phrase 'mp3player_cp_redirect' when i try to update

[haytham]

I think this is normal..the coder said this exists
"Known Issues:
Redirect phrase missing in AdminCP.
Approval Setting not holding setting after clicking Update in AdminCP Settings.
Use of quote or double quotes causes database error in AdminCP."

[syrus.xl]

i get this error could not find phrase 'mp3player_cp_redirect' when i try to update

This is listed under 'Known Issue' in the 1st post - it refers to a missing phrase in the AdminCP, it doesn't affect any functionality of the player settings.

[syrus.xl]

I think this is normal..the coder said this exists
"Known Issues:
Redirect phrase missing in AdminCP.
Approval Setting not holding setting after clicking Update in AdminCP Settings.
Use of quote or double quotes causes database error in AdminCP."

Oops! Beat me... haytham. Thanks! ;)

[haytham]

you are most welcome...I was able to translate most of the important stuff for my forum readers and I changed the play list names easily...really great mod.

[syrus.xl]

you are most welcome...I was able to translate most of the important stuff for my forum readers and I changed the play list names easily...really great mod.

You're welcome! :) Yeah, the playlists names can be changed by editing the various templates on this version.

This will be an option in future versions.:)

[StuntFactoryX]

can i use the same instance of the mp3 player on multable sites. both sites are on the same server but different databases and domains. i was thinking if i used complete paths in the borrowing sites nav bar path to player it might work?

im not concerned w/ the borrowing site to be able to upload anything. just be able to listen to it. i have a dj that is hooking it up on the intergrated site.

[syrus.xl]

can i use the same instance of the mp3 player on multable sites. both sites are on the same server but different databases and domains. i was thinking if i used complete paths in the borrowing sites nav bar path to player it might work?

im not concerned w/ the borrowing site to be able to upload anything. just be able to listen to it. i have a dj that is hooking it up on the intergrated site.

Yes, with full urls it should function with no problems. If it doesn't I can create a proxy for cross-domain access.

[StuntFactoryX]

thanks syrus. it does work w/ a full path to player :D

i searched this thread and you were close to an explanation but can u give me and example on how you would use a button to open this player using a image/button in a header. i have a button and i know where i want it. just need to convert your code from text to image.

[michaelsilvia]

Is this not for sale at the moment? I went to the site and saw this message:


NOTE: Players have now been suspended until some modifications have been made to our purchasing system.

[syrus.xl]

Is this not for sale at the moment? I went to the site and saw this message:

Sorry, that message is referring to a version that can be used globally, on any website. But all the players available on here and my site are free to use for vBulletin users.

There are forthcoming commercial versions of all players, but with many enhancements than what are currently on here.

I am gradually, tidying up my site so new modifcations can be added.

[michaelsilvia]

Thanks for the fast response! I will try this and the video player tomorrow. I'd love to be added to the list of folks you e-mail when a premium version is available. Looks great!

Mike

[michaelsilvia]

Is there a way to host the MP3s on another server? The site I want it on is on a shared plan, but I have a dedicated server with plenty of bandwidth. Same question with the video player.

Mike

[syrus.xl]

Is there a way to host the MP3s on another server? The site I want it on is on a shared plan, but I have a dedicated server with plenty of bandwidth. Same question with the video player.

Mike

The mp3 player is set to use internal or external linking, therefore it can use mp3's on another server. The video player however, wasn't designed to use external server linking only local access. This will probably be changed in a future release.

Thanks for the fast response! I will try this and the video player tomorrow. I'd love to be added to the list of folks you e-mail when a premium version is available. Looks great!

Mike

Added...:)

[syrus.xl]

thanks syrus. it does work w/ a full path to player :D

i searched this thread and you were close to an explanation but can u give me and example on how you would use a button to open this player using a image/button in a header. i have a button and i know where i want it. just need to convert your code from text to image.

Sure... Here you go! :)

<!—Mp3 Player Launch -->
<if condition="$show['member']">
<a href="javascript:NewWindow=window.open('mp3playerindex.p hp?do=viewmp3playerpopup','newWin','width=500,heig ht=500,left=0,top=0, toolbar=No,location=No,scrollbars=1,status=No,resi zable=No,fullscreen=No');
NewWindow.focus(); void(0);"><img src="path_to_your_image_here" border="0"></a>
</if>
<!—End Mp3 Player Launch -->

[GNDI]

when I'm trying to install this I get the following error or vB 3.6.4

XML Error: not well-formed (invalid token) at Line 1

[syrus.xl]

when I'm trying to install this I get the following error or vB 3.6.4

XML Error: not well-formed (invalid token) at Line 1

I'll check this later... I'll upgrade a test board to 3.6.4 and try an install.

Strange because its a standard XML import/export file.:confused:

[syrus.xl]

Remember you can still vote for this mod for 'Mod of the Month', if you haven't done so already.

CLICK HERE to Vote Now! (https://vborg.vbsupport.ru/showthread.php?t=130551)

An update is due very soon, including updated players! ;)

[SnapOff Racing]

pardon my ignorance but i installed everything properly and it works fine in vb 3.6.4, but when i did the cmps install, i can't get it to do anything but what it says below:

The template code uses the supplied flashobject.js to call the xeon flash player, this fixes the issue with view the player in Internet Explorer 6.0 and above. There is some text in the code “Warning!!! To view this vbMp3 Player please enable JavaScript and Flash! “, this will only display if a person views your site with javascript and flash disabled. You can change this line of text to what you would like to display to visitors. The flashobject.js file will detect if the person has javascript and flash enabled, and will either display the text or the mp3 player automatically

anyone have any tips?

[syrus.xl]

pardon my ignorance but i installed everything properly and it works fine in vb 3.6.4, but when i did the cmps install, i can't get it to do anything but what it says below:

The template code uses the supplied flashobject.js to call the xeon flash player, this fixes the issue with view the player in Internet Explorer 6.0 and above. There is some text in the code ?Warning!!! To view this vbMp3 Player please enable JavaScript and Flash! ?, this will only display if a person views your site with javascript and flash disabled. You can change this line of text to what you would like to display to visitors. The flashobject.js file will detect if the person has javascript and flash enabled, and will either display the text or the mp3 player automatically

anyone have any tips?

I'm assuming you have the vBa CMPS installed outside your forum 'ROOT', therefore the paths will be incorrect.

There are 2 file calls in the CMPS coding, namely flashobject.js and the xeon_mp3_beta.swf - if you prepend both these files with the full url, then that should fix this problem.

HTH

[KiwiInsanity]

Installed and playing songs fine.... only thing is it doesnt show any more than 10 songs in each playlist for me - and there are 30 or more?
Anyone help me there with that?
Also - not sure if its a bug, but if you drag the play position seek bar to more than 1/2 way, it moves straight on to the next song in the playlist...
A very nice mod - the members love it :)

[syrus.xl]

Installed and playing songs fine.... only thing is it doesnt show any more than 10 songs in each playlist for me - and there are 30 or more?
Anyone help me there with that?

That's something I've not come across before... But I'll run a few tests.


Also - not sure if its a bug, but if you drag the play position seek bar to more than 1/2 way, it moves straight on to the next song in the playlist...
A very nice mod - the members love it :)

Make sure all your mp3's do not have varying bitrates - this causes problems within flash files, from tracks not playing at correct speeds to seek bar acting abnormally.

[Freak0204]

This is so awesome! Installed!!

[KiwiInsanity]

That's something I've not come across before... But I'll run a few tests.

hehe - that would be right - if something can happen to me and no else, it surely will! LOL ....seems to be my own "murphy's law"

The different bit rates thing is difficult to avoid, our forum is a "private" one therefore I dont have 'Approve New Mp3 Added' on.... how would I check the bitrate info of the songs linked to ??
thanks again - great support too cheers

PS latest vBulletin? Version 3.6.4 running .....

[syrus.xl]

hehe - that would be right - if something can happen to me and no else, it surely will! LOL ....seems to be my own "murphy's law"

The different bit rates thing is difficult to avoid, our forum is a "private" one therefore I dont have 'Approve New Mp3 Added' on.... how would I check the bitrate info of the songs linked to ??
thanks again - great support too cheers

PS latest vBulletin? Version 3.6.4 running .....

hehe... and I thought I was the only one with my own 'Murphys Law';)

I'll look up a few free utilities that do this, some allow you to change the bitrate. However, mp3 bitrates cannot be changed server-side - unless there's a script out there I haven't seen yet. lol

I'll check back on this tomorrow, 2am here in the UK and I need some sleep.

Support should be a priority on any modifcation! Well, mine anyway!;)

[Claygp]

Is it possible put a limit on who uploads what?

Example: I only want each user to be able to upload 1 MP3. When they upload a 2nd one .. it overwrites the 1st. So .. each user can have their favorite MP3 of the moment uploaded to the player. (and .. hopefully .. it will display the username beside the song or something)

If its not possible right now .. will it be possible in the near future?

[SnapOff Racing]

I'm assuming you have the vBa CMPS installed outside your forum 'ROOT', therefore the paths will be incorrect.

There are 2 file calls in the CMPS coding, namely flashobject.js and the xeon_mp3_beta.swf - if you prepend both these files with the full url, then that should fix this problem.

HTH

ok, that fixed my issue, but also rose another one...now it's not loading any of my playlists...can u take a look for me?

www.snapoffracing.com

thanks! :cool:

[Distance]

There is a bug on the non shuffle player, when i click on the playlist then click again, all the tracks show up twice.. and if you keep clicking it keeps coming up more

[KiwiInsanity]

Just to let you know mate - fixed the probs of not displaying more than 10 - it appears some of the songs added which have "character accents" in the names also does strange things :)
I did see the single/double quotes thing are a known bug, so I know you'll be looking at issues of filtering input anyway, hope this helps a little along the way.
heres some of the ones that were causing probs.
(as if blank spaces werent bad enough!)

/07%20-%20Estoy%20Aqu%ed.mp3', 'true', 0, 'Shakira,Estoy Aqu?.', 1);
/06%20-%20Inevitable.mp3', 'true', 0, 'Shakira, Inevitable', 1);
/05%20-%20Ciega,%20Sordomuda.mp3', 'true', 0, 'Shakira, Ciega,Sordomuda', 1);
/04%20-%20Moscas%20en%20la%20Casa.mp3', 'true', 0, 'Shakira,MoscasenlaCasa.', 1);
/03%20-%20D%f3nde%20Est%e1n%20Los%20Ladrones.mp3', 'true', 0, 'Shakira,D?ndeEst?nLosLadrones', 1);
/02%20-%20Si%20te%20Vas.mp3', 'true', 0, 'Shakira,Si-te-Vas', 1);

fixing this also seemed to stop the glitch of jumping to next track if the seek bar was dragged along past halfway..

Anyway - just thought I'd post this in case it helps with your debugging
cheers syrus
Kiwi

[syrus.xl]

This was mentioned in a previous post - I need to update the main post. Flash doesn't parse the urls correctly if they contain 'white space' so it gets converted, which causes many problems.

Nothing is ever easy! ;) Thanks anyway, Kiwi! :)

[seabiscuit]

Wow this looks really nice and id love to try and use this.


ok... it seems i am the only one having trouble. I think i installed and uploaded correctly. I uploaded the MP3 and set the URL as
http://www.xxxxx.com/mp3/song1.mp3, and it plays correctly if i browse that page using firefox.

I think the player is getting a feed because it does say Song 2- Blur on the player, but it doesnt play anything. It says Total in PlayList 1:(1) and the clock doenst move from 00:00.

The .mp3 works fine on my windows media player as well.

Heres the setting im playing it at.
MP3 ID---URL---------------------------------Streat-Buffer -----
1 http://www.xxxxxxxx.com/mp3/song1.mp3 True ----0----- Song 2 - Blur 1


Would anybody have a slightest clue what i have overlooked?

[seabiscuit]

ok. It didnt work last night. I woke up this morning without changing a thing, and its working now. :)

But now, the problem is that the track is playing maybe 50% faster than it should. Would i just have to reupload the song?

[syrus.xl]

ok. It didnt work last night. I woke up this morning without changing a thing, and its working now. :)

But now, the problem is that the track is playing maybe 50% faster than it should. Would i just have to reupload the song?

This is a sign that the mp3 bitrate is of an incorrect value, and flash cannot read it correctly, therefore it will play it wrong - majority of the times this will be the speed.

For mp3's to work correctly, I would suggest a 128k bitrate for all tracks. Lower than this will become noticeable on playback. With a 128k bitrate, most mp3's tend to be around 3-5Mb in size.

HTH

[bluesteel]

Ths is a great Mod. Installed it yesterday, spent a few hours today converting and uploading 60+ songs.
It was working great, my members were loving it, then wallop. The MP3 directory on my websapce dsappeared!

I can't think of any other explanation other than my ISP deleted it (ICDSoft).
Anybody else had this problem? Is t common?

[syrus.xl]

Ths is a great Mod. Installed it yesterday, spent a few hours today converting and uploading 60+ songs.
It was working great, my members were loving it, then wallop. The MP3 directory on my websapce dsappeared!

I can't think of any other explanation other than my ISP deleted it (ICDSoft).
Anybody else had this problem? Is t common?

I just looked at your Web Hosts Terms of Use policy, they do not allow mp3 files on their servers. Strange, for any hosting company - because that means you can't even use your own material in mp3 format either.

Personally, I don't store mp3's on my server - they are hosted in another country. Laws and use of mp3's vary from country to country.

[tvayuda]

Hello I have a problem on having loaded flash I give the mistake " not to could load the movie " to see if they can help me

[MrPHD]

I can´t put music on mp3 player...what do that? link, how?

This Resolved,thanks

[syrus.xl]

I can?t put music on mp3 player...what do that? link, how?

Hi,

Have you uploaded any mp3's to link to yet? Once you have done this then you can put the link in to the mp3 player.

HTH

[syrus.xl]

Hello I have a problem on having loaded flash I give the mistake " not to could load the movie " to see if they can help me

Is the flash player file located in the root of your forums? That error will appear if the code cannot find the flash file (swf).

HTH

[MrPHD]

Hi,

Have you uploaded any mp3's to link to yet? Once you have done this then you can put the link in to the mp3 player.

HTH


What link? I upload 7.5GB of music mp3 to my server but what link i have put it when add a mp3?Thanks


e.g. h**p://dhp.servebbs.com/forum/music/Benni Benassi-Sprea Love.mp3

[bluesteel]

I just looked at your Web Hosts Terms of Use policy, they do not allow mp3 files on their servers. Strange, for any hosting company - because that means you can't even use your own material in mp3 format either.

Personally, I don't store mp3's on my server - they are hosted in another country. Laws and use of mp3's vary from country to country.

Thanks for the swift reply syrus.

Thats a shame! The server I am on with them is in Hong Kong too! I used to have the old Jukebox on another of my websites for over a year with no problem (same host) but I've just remembered that I converted all of the files to .wma format.

You couldn't possibly PM me with any links to mp3's could you? I spent some time earlier looking but drew a blank.

Thanks
Alan

[MrPHD]

Thanks all but i resolve the problem. Thank Syrus.xl

[dramster]

I must be missing something!

Can't wait to try this mod out but I cannot seem to find where you give the users access to it. I have followed the install instructions but the line that says "Now, navigate to AdminCP -> Usergroups -> Usergroup Manager – adjust usergroups permissions as required. Default is all usergroups have no access." doesn't seem to take me anywhere where I can turn the access rights on.

Anyone got any ideas?

[MrPHD]

If you have all well done you must be see this imageon User Groups Manager.

[MrPHD]

Tell the version you have of Vbulletin please.

[Guest210212002]

I ended up uninstalling this. I run a music site, and it's fantastic in part for sites like mine since the idea is for members to upload their own content/songs.

The problem is that there isn't any limit set for the number of files or space constraits, so brand new members could concievably sign up to my site and upload a slew of pirate MP3s, or just keep uploading until my webspace is consumed.

If you can add to the usergroup permissions a file count and space check, I'd love to reinstall it - I realize that I can set the max upload size in php.ini, but that doesn't really get around the rest of the issues. :(

[bluesteel]

Does anybody know of any free/cheap ISP that it is ok to host mp3 files? I am desperate to be able to use this mp3player lol

[dramster]

Oh dear - that was my first post and it turns out to have been a bit of a school boy error!

Sorry guys, I got my live and test environments mixed up! Thanks for the quick response though!

Now that everything appears set up in the administrator panel I am having trouble opening the GUI. When I click on the link on the navigation I get a blank screen.

Any ideas?

As for the version - it is a fresh install (3.6.4)

Thanks again Dramster

EDIT: Apologies once again! Sorted now. Not my best start to a new bard I've joined :-)

[beishe8]

The problem is that there isn't any limit set for the number of files or space constraits, so brand new members could concievably sign up to my site and upload a slew of pirate MP3s, or just keep uploading until my webspace is consumed.

Solution:
Approve New Mp3 Added
Select Yes if you want the admin to approve all new MP3s that are added by users.

[MrPHD]

Oh dear - that was my first post and it turns out to have been a bit of a school boy error!

Sorry guys, I got my live and test environments mixed up! Thanks for the quick response though!

Now that everything appears set up in the administrator panel I am having trouble opening the GUI. When I click on the link on the navigation I get a blank screen.

Any ideas?

As for the version - it is a fresh install (3.6.4)


Thanks again Dramster


EDIT: Apologies once again! Sorted now. Not my best start to a new bard I've joined :-)

chmod 777 xeon_mp3_beta file. Regards

[Romanthic]

Thank you guy
You 're excellent coder ;)

[tobybird]

Installed. Working great but I am getting an error message at the end of my play list. Any ideas what would be causing this?

eta: I should state that the message pops up after the last song has finished playing.

[micheal332001]

Hi all

I have sent syrus the updated files that fixes the redirect in the admincp,
and also i have added the option of adding multiple mp3 files in the add mp3 page.
You will be able to add 3 mp3 files at a time in there now.
If anyone has problems with the script i will help as much as i can.

[syrus.xl]

Installed. Working great but I am getting an error message at the end of my play list. Any ideas what would be causing this?

eta: I should state that the message pops up after the last song has finished playing.

Hi tobybird,

That error derives from the player being only populated with just one track on a single playlist. The idea of the playlist design is to have more than one track on any playlist, at any one time.

This doesn't mean you have to put loads of tracks into every playlist, but if you put one track in playlist 3 then add one to playlist 5, then this error will occur. Just add a few tracks to one playlist at a time, if you can.

[syrus.xl]

As posted by Mike, the new updated files are ready. However, I just need to make a few changes to the main player flash file.

It should be released later today; then this modification will no longer be in a beta form. It will be a full release, notifications will be sent out once the package iss updated, to those that have clicked Install on this modification.

:cool:

[Distance]

There is a bug on the non shuffle player, when i click on the playlist then click again, all the tracks show up twice.. and if you keep clicking it keeps coming up more


*coughs*

[tobybird]

Thanks Syrus XL, got that sorted this morning.

One other picky little thing. I had yet another "I'm an idiot" moment. When uploading songs, even if the path is not correct, the song does appear to upload and is viewable in the player as if all is well. The only issue, of course, is the play length data is missing. Possibly when uploading, an error message stating that x song is not found at x path would be helpful. lol Especially for those of us who tend to over look the little things staring you right in the face. :rolleyes: Again, very minor issue. Thanks again!

eta: Sorry one more... You get a MySQL error when trying to add a song with an apostrophe anywhere in the title. For example I'm Dreaming of a White Christmas would give an error whereas Im Dreaming of a White Christmas would not.

[Guest210212002]

Solution:

Admin approval doesn't change the fact that this person can keep uploading to my server. That's the problem. All approval does is add them to the list.

[syrus.xl]

*coughs*

I will look at this when recompiling the flash player this evening.

[syrus.xl]

Admin approval doesn't change the fact that this person can keep uploading to my server. That's the problem. All approval does is add them to the list.

You could create a new usergroup and only give them permission to upload. This would stop users from other usergroups from uploading, but still be able to listen or not depending on the permission settings.

[syrus.xl]

Thanks Syrus XL, got that sorted this morning.

One other picky little thing. I had yet another "I'm an idiot" moment. When uploading songs, even if the path is not correct, the song does appear to upload and is viewable in the player as if all is well. The only issue, of course, is the play length data is missing. Possibly when uploading, an error message stating that x song is not found at x path would be helpful. lol Especially for those of us who tend to over look the little things staring you right in the face. :rolleyes: Again, very minor issue. Thanks again!

eta: Sorry one more... You get a MySQL error when trying to add a song with an apostrophe anywhere in the title. For example I'm Dreaming of a White Christmas would give an error whereas Im Dreaming of a White Christmas would not.

Your first aforementioned issue maybe dealt with in another update, but not in the updated package that will be released later today.

The MySQL apostrophe error is fixed in the latest files, which I will be updating shortly.

[Distance]

I just noticed when adding songs.. some of the song names are..

Don't

whenever the track names have ' in the name it comes up with SQL error

[syrus.xl]

I just noticed when adding songs.. some of the song names are..

Don't

whenever the track names have ' in the name it comes up with SQL error

This is listed under Known Issues - a fix for all known issues discussed during the beta stage, will be uploaded later this evening.

[micheal332001]

I just noticed when adding songs.. some of the song names are..

Don't

whenever the track names have ' in the name it comes up with SQL error

Hi there

When syrus uploads the new files the fix is in there for this problem.
Also the redirect in the admincp has been fixed.
Also added multiple uploads of mp3 when adding a new mp3 you can upload 3 mp3's at a time now or when the new files are updated

[joeychgo]

I just want to clarify something - Does this have a way to actually upload an mp3 or when you say upload are you referring to placing the url location of the MP3?

Also - when is the final version coming?

[syrus.xl]

I just want to clarify something - Does this have a way to actually upload an mp3 or when you say upload are you referring to placing the url location of the MP3?

Also - when is the final version coming?

It doesn't support mp3 uploading, only mp3 urls can be entered. The reason for this is due to various server configurations, which in many cases would fail on uploading mp3's via PHP.

[beishe8]

Admin approval doesn't change the fact that this person can keep uploading to my server. That's the problem. All approval does is add them to the list.

OK. Add them to the list.
Can that person fill your webspace? No. Cannot upload the files.

Cheers

[syrus.xl]

Also - when is the final version coming?

Should be today... Everyone that has clicked Installed will be notified.

It would have been yesterday, but I got held up with a tyre puncture for 4hrs!!! :surprised:

[Stavs16]

hi can someone help me please, i am uploading a button from my tren_z forum style from extremepixels.com. I don't know how to edit a button but i do have photoshop and have attempted. here is the home button from my forums, if you can change that home text to vbMp3 Player that would be amazing. thanks

http://aycu22.webshots.com/image/8261/2006240158004186550_rs.jpg

[syrus.xl]

hi can someone help me please, i am uploading a button from my tren_z forum style from extremepixels.com. I don't know how to edit a button but i do have photoshop and have attempted. here is the home button from my forums, if you can change that home text to vbMp3 Player that would be amazing. thanks

http://aycu22.webshots.com/image/8261/2006240158004186550_rs.jpg

It would be hard to re-create a new button from just a jpg. This is why you have the PSD, you should be able to edit the button in Photoshop by isolating the layers (done by turning them off), and then you can normally drag the button and associated text into a new PSD.

One thing to note with PSD's, is you should have the correct font installed, or the text will change to some other font.

[Distance]

Sooo its now the 9th.. Is there going to be an update?

[rootnik]

I haven't installed this yet, waiting on the new version. I just wanted to comment on the support the author of this mod has provided. You are doing a great job, even helping people with things that have nothing to do with this hack when you could just as easily sent them looking elsewhere for answers. You easily get my nomination for HOTM.

[dramster]

Great mod - thanks, installed.

I want to change the names of the playlists to something more meaningful (ie different genres).

How do I do this?

Thanks,
Drammy

[Distance]

You cant in this version

[syrus.xl]

I haven't installed this yet, waiting on the new version. I just wanted to comment on the support the author of this mod has provided. You are doing a great job, even helping people with things that have nothing to do with this hack when you could just as easily sent them looking elsewhere for answers. You easily get my nomination for HOTM.

I'm just doing a few last checks... code has been updated and so has the player.;) Then I'll upload the new version.:)

[FRANKTHETANK 2]

ok syrus. i i tried it agin today and put xml as product still cant get it tow ork. wtf this is teh only hacki have ever did that i cant do. please help. i want this player on my new site. heres the code

Warning: main(./global.php) [function.main]: failed to open stream: No such file or directory in /home/thronefi/public_html/armyselite/mp3playerindex.php on line 33

Fatal error: main() [function.require]: Failed opening required './global.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/thronefi/public_html/armyselite/mp3playerindex.php on line 33

[syrus.xl]

ok syrus. i i tried it agin today and put xml as product still cant get it tow ork. wtf this is teh only hacki have ever did that i cant do. please help. i want this player on my new site. heres the code


Warning: main(./global.php) [function.main]: failed to open stream: No such file or directory in /home/thronefi/public_html/armyselite/mp3playerindex.php on line 33

Fatal error: main() [function.require]: Failed opening required './global.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/thronefi/public_html/armyselite/mp3playerindex.php on line 33

Please wait... I'm updating this product now. Should be all done within 30 mins!:)

[FRANKTHETANK 2]

ok thanks. hope its easier.lol

[syrus.xl]

ok thanks. hope its easier.lol

All Updated now... all files need overwriting and you should be fit to go!:D

Once you have uploaded the files and imported the product xml file through your AdminCP - make sure you Refresh and the Save Settings in the Mp3 Player Management first.

[FRANKTHETANK 2]

so should i redownload the player, then reinstall?

[syrus.xl]

so should i redownload the player, then reinstall?

I've updated the whole package. The other player is an optional extra.:D

[Distance]

Has the no shuffle player been updated

[syrus.xl]

Has the no shuffle player been updated

Not yet, I need to recompile the player for no shuffle. I'll try and get that done now.;)

[Distance]

THanks.. i just went to replace the file.. and it was the same file, i was like WTF :p

[Distance]

When should this be finished?

[syrus.xl]

When should this be finished?

Just redone the code, and recompiled the player with no shuffle. Just about to update it now.;)

[Distance]

Ah i see it doesnt take long :)

I love you for this hack :D

[FRANKTHETANK 2]

i got to work. was the managnent setting. thanks syruis

[syrus.xl]

Ah i see it doesnt take long :)

I love you for this hack :D

All updated now! Feel free to take the updated player!:cool:

[syrus.xl]

i got to work. was the managnent setting. thanks syruis

You're welcome! Just updated this hack on a few other vbulletin sites.:)

[Distance]

I had the first download :)

But the problem hasnt been fixed

There is a bug on the non shuffle player, when i click on the playlist then click again, all the tracks show up twice.. and if you keep clicking it keeps coming up more

[syrus.xl]

I had the first download :)

But the problem hasnt been fixed

Personally, I don't use the players I design. Mine are imported via another flash file and locked to my domain.

I'll upload the player and re-check this non-shuffle version on the development board.

[trd167]

I installed everything when I when click on vBmp3player on the navbar or "mp3 player settings" under the admin setting, i get this error.

Database error in vBulletin 3.6.4:

Invalid SQL:
SELECT * FROM mp3player_settings;

MySQL Error : Table 'whiteplusyellow.mp3player_settings' doesn't exist
Error Number : 1146
Date : Sunday, December 10th 2006 @ 04:04:30 PM
Script : http://www.whiteplusyellow.com/forum/admincp/mp3player_admin.php
Referrer :
IP Address : xx.xxx.x.xxx
Username : WhiteplusYellow
Classname : vB_Database

[FRANKTHETANK 2]

hey syrus. oen more thing. how do i get rid of teh add mp3 stuff and where do i add playlists and what do i add as name of them?

[syrus.xl]

hey syrus. oen more thing. how do i get rid of teh add mp3 stuff and where do i add playlists and what do i add as name of them?

To remove the Add Mp3 link in the popup you would need to edit your default style and edit the mp3player template. The code you would need to remove would be this:

<div align="center" style="padding: 5px 5px 5px 5px;">
<a href="mp3playerindex.php?do=addmp3" target="_blank">Add Your MP3's</a>
</div>

The player is designed with only 5 playlists, these can't be changed in this version. I may add this feature in an future update.

[syrus.xl]

I installed everything when I when click on vBmp3player on the navbar or "mp3 player settings" under the admin setting, i get this error.

Database error in vBulletin 3.6.4:

Invalid SQL:
SELECT * FROM mp3player_settings;

MySQL Error : Table 'whiteplusyellow.mp3player_settings' doesn't exist
Error Number : 1146
Date : Sunday, December 10th 2006 @ 04:04:30 PM
Script : http://www.whiteplusyellow.com/forum/admincp/mp3player_admin.php
Referrer :
IP Address : xx.xxx.x.xxx
Username : WhiteplusYellow
Classname : vB_Database

Did you click on Save Settings after importing the product xml file? It's referring to an error that the mp3player settings table is missing. Which the product xml file creates during import.

[trd167]

Did you click on Save Settings after importing the product xml file? It's referring to an error that the mp3player settings table is missing. Which the product xml file creates during import.


is there a way i could have the mp3player settings table manually? it seems like the product xml file does not create it for me during import.

[TTG]

Receiving the same database error (https://vborg.vbsupport.ru/showpost.php?p=1135996&postcount=360) !?

[Biggles]

Thanks a million syrus.xl. This hack of yours is a real doozy. I've kept up with the upgrades and was looking forward to this one. As I said before: my members love it and use it a lot. Very nice job you've made of it.

Biggles

[FRANKTHETANK 2]

so i just make 5 playlists like the vbplayer and name them plylist1,2 and so on?

[bluesteel]

Upgrade installed and appears to be working fine on 3.6.4 in Macclesfield. Thanks syrus.xl :)

[syrus.xl]

is there a way i could have the mp3player settings table manually? it seems like the product xml file does not create it for me during import.

I added a note to the main post with a temporary fix. And I'll fix this later correctly.

[syrus.xl]

so i just make 5 playlists like the vbplayer and name them plylist1,2 and so on?

This version doesn't use that principle anymore, that was used on the XML version, released back in September 2006. Playlists are created in the Mp3 Player Management in your AdminCP.

You could rename the playlists by editing the templates for this modification, but the database will still require them to listed numerically.

[FRANKTHETANK 2]

ok well let me look at it again. can i still get the olderversion if i want. i liked it better that way was esier fo rme since i know how.

[syrus.xl]

ok well let me look at it again. can i still get the olderversion if i want. i liked it better that way was esier fo rme since i know how.

Yeah, its available here!:)

https://vborg.vbsupport.ru/showthread.php?t=125817

[beishe8]

Norton is deleting a file from the now updated ZIP file.
Why?

[Biggles]

Norton is deleting a file from the now updated ZIP file.
Why?I had the same snag, beishe8. It's a Nortons problem (as usual). The way around it is to disable virus protection after downloading the zip (perhaps come off the net while you do that).

Once you've extracted the files, your troubles are not quite over. You will need to go back on the net to upload the files thru ftp. So, disable Antivirus briefly while you do that, otherwise Nortons will delete that same file as you try to upload. Once you are finished with the file transfer to the server, you are all clear to re-activate Nortons AV.

I've had a discussion with Syrus XL on this. It is definitely NOT a virus, just a Norton's problem seeing just one file as one when it is not.

I think the real answer is to dump Nortons and get a proper AV system. There are better available - and some don't keep recharging you for what you've already paid for - grrr!

Best of luck. Incidentally, once I did the above it's all working just fine on my site. And it's a great mod well worth the trouble of setting it up.

Regards

Biggles

[beishe8]

I've had a discussion with Syrus XL on this. It is definitely NOT a virus, just a Norton's problem seeing just one file as one when it is not.

Thanks Biggles for the quick help. I'll do as you recommended.

Just a question to Syrus XL : Isn't it possible to rename that offending file?

Regards,

beishe8

Edit:
And a second question:Why did not pop up this problem earlier when the original player was unzipped?

[dramster]

Receiving the same database error (https://vborg.vbsupport.ru/showpost.php?p=1135996&postcount=360) !?
Me too...

Any ideas how we can fix this?

I installed in the same way I installed first time round and it fails with the db error.

I have installed tice now and failed both times. I have installed by uninstalling the beta version - is this correct?


Cheers,
Drammy

[syrus.xl]

Me too...

Any ideas how we can fix this?

I installed in the same way I installed first time round and it fails with the db error.

I have installed tice now and failed both times. I have installed by uninstalling the beta version - is this correct?


Cheers,
Drammy

The package is now updated. The product XML file has been updated and should fix the database problem.:)

[dramster]

Wicked, thanks Syrus.xl!

[dramster]

Scratch that - I'm still getting the error, although this time against another field:


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 : Monday, December 11th 2006 @ 08:39:38 AM
Script : http://libby.asmallorange.com/~drammy/virus/mp3playerindex.php?do=viewmp3playerpopup
Referrer : http://libby.asmallorange.com/~drammy/virus/
IP Address : xx.xxx.xxx.xx
Username : Drammy
Classname : vb_database

[micheal332001]

Scratch that - I'm still getting the error, although this time against another field:


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 : Monday, December 11th 2006 @ 08:39:38 AM
Script : http://libby.asmallorange.com/~drammy/virus/mp3playerindex.php?do=viewmp3playerpopup (http://libby.asmallorange.com/%7Edrammy/virus/mp3playerindex.php?do=viewmp3playerpopup)
Referrer : http://libby.asmallorange.com/~drammy/virus/ (http://libby.asmallorange.com/%7Edrammy/virus/)
IP Address : xx.xxx.xxx.xx
Username : Drammy
Classname : vb_database


Ill sort this out now and send syrus the new xml

[tobybird]

odd... double posted sry

[tobybird]

Norton is deleting a file from the now updated ZIP file.
Why?

I had the same snag, beishe8. It's a Nortons problem (as usual). The way around it is to disable virus protection after downloading the zip (perhaps come off the net while you do that).

Once you've extracted the files, your troubles are not quite over. You will need to go back on the net to upload the files thru ftp. So, disable Antivirus briefly while you do that, otherwise Nortons will delete that same file as you try to upload. Once you are finished with the file transfer to the server, you are all clear to re-activate Nortons AV.

I've had a discussion with Syrus XL on this. It is definitely NOT a virus, just a Norton's problem seeing just one file as one when it is not.

I think the real answer is to dump Nortons and get a proper AV system. There are better available - and some don't keep recharging you for what you've already paid for - grrr!

Best of luck. Incidentally, once I did the above it's all working just fine on my site. And it's a great mod well worth the trouble of setting it up.

Regards

Biggles

Thanks Biggles for the quick help. I'll do as you recommended.

Just a question to Syrus XL : Isn't it possible to rename that offending file?

Regards,

beishe8

Edit:
And a second question:Why did not pop up this problem earlier when the original player was unzipped?

If you guys don't mind, I was wondering what the answer to his edit is as well. Thanks!

[trd167]

everything is working fine. thank you!

[trd167]

never mind...i am getting this message when i try to open the player on my navbar.

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 : Monday, December 11th 2006 @ 03:07:10 PM
Script : http://www.whiteplusyellow.com/forum/mp3playerindex.php?do=viewmp3playerpopup
Referrer :
IP Address : xx.xxx.x.xxx.
Username : WhiteplusYellow
Classname : vB_Database

[TTG]

The package is now updated. The product XML file has been updated and should fix the database problem.:)


Not yet it doesn't :confused:

Database error in vBulletin 3.6.4:

Invalid SQL:
SELECT * FROM mp3player_settings;

MySQL Error : Table 'XXXXXX_XXX.mp3player_settings' doesn't exist ..
etc etc etc

[PostMaster]

never mind...i am getting this message when i try to open the player on my navbar.

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 : Monday, December 11th 2006 @ 03:07:10 PM
Script : http://www.whiteplusyellow.com/forum/mp3playerindex.php?do=viewmp3playerpopup
Referrer :
IP Address : xx.xxx.x.xxx.
Username : WhiteplusYellow
Classname : vB_Database

I'm getting this as well, also with me I don't even see the player on the navbar until I click on a forum to read it(any forum), then I'll see it on the navbar and it takes me to this link. My zonealarm pop up unzipping this and said it clean a file, I didn't right it down but I closed down my zonealarm and unzipped it again and upload to the forum root directory like told.

I have three styles and I can see it on the default style on 3.6.2 forum default and takes me to this error I'm quoting.

The other two sytles I don't see it until I read the forum and then see it on the navbar. I have arcade install find, this is not working for me.

also what do I put in the URL if this is the reason?
https://vborg.vbsupport.ru/external/2006/12/15.jpg

[syrus.xl]

I'm getting this as well, also with me I don't even see the player on the navbar until I click on a forum to read it(any forum), then I'll see it on the navbar and it takes me to this link. My zonealarm pop up unzipping this and said it clean a file, I didn't right it down but I closed down my zonealarm and unzipped it again and upload to the forum root directory like told.

I have three styles and I can see it on the default style on 3.6.2 forum default and takes me to this error I'm quoting.

The other two sytles I don't see it until I read the forum and then see it on the navbar. I have arcade install find, this is not working for me.

also what do I put in the URL if this is the reason?
https://vborg.vbsupport.ru/external/2006/12/15.jpg

I'll be updating the product XML later today, to rectify these problems. The images you have posted regarding Product version, etc are for 'live' version tracking. I didn't use these for a number of reasons, this mod is not specifically released just on vbulletin.org (which supports version tracking), but also a number of smaller sites. It is used to track if you have the latest version available from your ACP. So, both fields were left blank because it was released as a global modification.

[shete]

Everything works perfectly except for when the people try to add MP3s ...

it says " Fatal error: Unable to proceed with save while $errors array is not empty in class vb_datamanager_pm in /includes/class_dm.php on line 763 "

What can I do to fix this ???

[PostMaster]

I'll be updating the product XML later today, to rectify these problems. The images you have posted regarding Product version, etc are for 'live' version tracking. I didn't use these for a number of reasons, this mod is not specifically released just on vbulletin.org (which supports version tracking), but also a number of smaller sites. It is used to track if you have the latest version available from your ACP. So, both fields were left blank because it was released as a global modification.


Ok I see, ok updated it and unzipped it again and this is what pop up with ZoneAlarm saying it clean a virus is it ok to continue without this file to make this work? I'm assuming Zonealarm just thinks this is a virus and is protecting me from any harm. What should I do allow this file with Zonealarm closed and then upload it to the server? It will only remove it again when it does it's daily search :confused: So I will have to do this when the virus with Zonealarm is turned off.


https://vborg.vbsupport.ru/external/2006/12/8.gif

[Stavs16]

if i also wanted to embed this into my forum home what would be the code?

[TTG]

un-installed and re-installed and now new database 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'

[JRite]

i dont know, but i can't seem to get this to show up
i downloaded it, and installed it into the manage products thing...
then i hit the refresh part, and nothing happened... can't find an Mp3 Player Management menu anywhere...
i'm using vb 3.6.4
can anyone help me out?

[Parture]

That's why I am still using the xml version. Better safe than sorry. I prophesied this would happen, as it has happened so many times before like vbjournal, vbquiz and others. There is nothing worse than a database error for a plugin, where you can't unistall it and the you can't access your forum because of a database error. Before people create a product, they need to make sure it works on these very basic levels first.

[JRite]

i dont know, but i can't seem to get this to show up
i downloaded it, and installed it into the manage products thing...
then i hit the refresh part, and nothing happened... can't find an Mp3 Player Management menu anywhere...
i'm using vb 3.6.4
can anyone help me out?

i'm still stumped...

[micheal332001]

i dont know, but i can't seem to get this to show up
i downloaded it, and installed it into the manage products thing...
then i hit the refresh part, and nothing happened... can't find an Mp3 Player Management menu anywhere...
i'm using vb 3.6.4
can anyone help me out?

Take alook in your ftp to make sure you have uploaded all files to where they should be, as it looks like you have not uploaded them to the right folders.

[JRite]

what is my ftp?

[JRite]

oh... and...

AdminCP -> Styles & Templates -> Navigation / Breadcrumb Templates -> navbar
^ my 3.6.4 doesn't even have those options... wtf?

[tobybird]

oh... and...


^ my 3.6.4 doesn't even have those options... wtf?

lol

Admin CP

Styles & Templates

Style Manager

Edit Templates

Navigation / Breadcrumb Templates

navbar


Ya might want to pull out the manual. ;) http://www.vbulletin.com/docs/html/

[seabiscuit]

looks really nice but i am getting this error. I think i had it working before when i was testing it, and i tried to install it for good


Database error in vBulletin 3.6.4:

Invalid SQL:
insert into mp3playlist values(

'','http://www.xxx.com/mp3/victory.mp3','true','5','victory',''

);

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

Script : http://www.xxx.com/forum/admincp/mp3player_admin.php?do=do_add_playlist1
Referrer : http://www.xxx.com/forum/admincp/mp3player_admin.php?do=addplaylist1


What's wrong? Help would be greatly appreciated.

[micheal332001]

looks really nice but i am getting this error. I think i had it working before when i was testing it, and i tried to install it for good


Database error in vBulletin 3.6.4:

Invalid SQL:
insert into mp3playlist values(

'','http://www.xxx.com/mp3/victory.mp3','true','5','victory',''

);

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

Script : http://www.xxx.com/forum/admincp/mp3player_admin.php?do=do_add_playlist1
Referrer : http://www.xxx.com/forum/admincp/mp3player_admin.php?do=addplaylist1
What's wrong? Help would be greatly appreciated.

I will have alook at this for you and get back to you here.

[beishe8]

what is my ftp?

File Transfer Protocol

A program used to upload/download files to/from your webspace.

"FileZilla" is one of them.

Cheers, beishe8

[stinger2]

Database error in vBulletin 3.6.4:

Invalid SQL:

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

MySQL Error : Unknown column 'approvemp3' in 'where clause'
Error Number : 1054
Date : Thursday, December 14th 2006 @ 10:53:49 PM
Script : http://localhost/forums/mp3playerindex.php?do=viewmp3playerpopup
Referrer :
IP Address : 127.0.0.1
Username : stinger2
Classname : vb_database



getting the same error as the guys before.....any fix yet?

nice hack though.....thx

[Kidswap]

I'm getting the same error. Subscribing to see the solution.

[seabiscuit]

I will have alook at this for you and get back to you here.

thank you so much Michael. I will be waiting.

[seabiscuit]

i happened to have the previous version, so i tried that again, and it worked like a charm.

[R-n-R]

For what it is worth I am getting this error as well.

Database error in vBulletin 3.6.4:

Invalid SQL:

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

MySQL Error : Unknown column 'approvemp3' in 'where clause'
Error Number : 1054
Date : Thursday, December 14th 2006 @ 10:53:49 PM
Script : http://localhost/forums/mp3playerindex.php?do=viewmp3playerpopup
Referrer :
IP Address : 127.0.0.1
Username : stinger2
Classname : vb_database



getting the same error as the guys before.....any fix yet?

nice hack though.....thx

[96TSi]

I have the same error also. Installed as instructed. all the files are there

[trd167]

is the XML file being worked on?

[DAdiguzeL]

I have the same problem :(

[Cireus]

Absolutely awesome product! Running it on my 3.6.4 board w/o any trouble installing! Thanks!

[teyron]

why does norton pick this up as a virus?

[syrus.xl]

why does norton pick this up as a virus?

Norton AV is well known for 'false-positives'. I have had this package scanned by numerous other antivirus programs, and it always comes back virus free. It doesn't take much to trigger Norton (as little as a few characters).

Product XML:
The product XML is being worked on - I'm just running a few more tests before releasing it. An error sneaked in if the installation was new, upgrades seemed to work fine.

Sorry about the delay, but I am quite busy this time of year.

[basilrath]

any ideas ive uploaded the folder contents to the forum root ie .........

admincp contents into admincp

includes contents into the includes folder

the other 3 php to root

and the swf to root too and get this any ideas

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'

[Diana Notacat]

Looking forward to seeing the fix for that new install program. My members will reall like this addition!

[soletrader]

So I guess this hack is not working for all? Looking forward to it :)

[basilrath]

The earlier version is good anyway ive actually got it in the navbar etc aswell as in the postbit ...................5 playlists etc

screenshot..........

http://www.recommenditall.com/thebig/forums/lgtbfs.gif (http://www.recommenditall.com/thebig/forums/tbfs_dump.bmp)

[Allan]

Thanks for this hack :)

Edit: Don't work with vB3.6.4 :(


Database error in vBulletin 3.6.4:

Invalid SQL:

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

MySQL Error : Champ 'approvemp3' inconnu dans where clause
Error Number : 1054
Date : Monday, December 25th 2006 @ 09:08:45 AM
Script : http://www.vbulletin-ressources.com/forum/mp3playerindex.php?do=viewmp3playerpopup
Referrer : http://www.vbulletin-ressources.com/forum/index.php
IP Address : 195.36.194.90
Username : Allan
Classname : vb_database

[richTV]

been using it on my forum [3.6.4] for a few days now with 30 tracks of those ol' standards Xmas music.

many thanks for designing this gem!

i was wondering, however, if there r any laws i should be worried about whilst my users play these songs at my forum? ie, copyright issues?

TIA :)

[basilrath]

as long as your not a commercial site etc

not selling

[richTV]

our site is 100% fed on donations by the members to which ALL of those euros ? goes to the server fees and any extra money for the month is stored until the following month's server bill.

tnx for the clarification. :)

[winpro19]

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

[Allan]

In xml file, find:

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

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

thanks it worked!

[blogtorank]

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:

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]

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

[TTG]

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

[StuntFactoryX]

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]

Database error in vBulletin 3.6.4:

i did the fix but im getin

XML Error: mismatched tag at Line 378

[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????

[TTG]

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

[loonytune15]

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 runs in a seperate window :)

[imk]

Database error in vBulletin 3.6.4:

i did the fix but im getin

XML Error: mismatched tag at Line 378

???????????

[Greek76]

For some reason none of my songs play on the player. I did no changes and all the urls are correct? Any ideas? All the buttons work except for the play button you cant press it.

[MythoLogy]

I had the same error that many has had lately:

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

And thanks to Allan's fix - I uninstalled the mod, dropped the table and made the changes - installed and now I too can now enjoy this mod. Nice Job Allan for the fix and syrus for the mod.

[mojahudba]

i getting this error :

Database error in vBulletin 3.6.4:

Invalid SQL:

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

MySQL Error : Unknown column 'approvemp3' in 'where clause'
Error Number : 1054
Date : Wednesday, January 3rd 2007 @ 10:53:08 AM
Script : http://www.mojahudba.com/forums/mp3playerindex.php?do=viewmp3playerpopup
Referrer :
IP Address : xxxxxxxxx
Username : Jeinko
Classname : vb_database

and allan change didnt help :S

[stinger2]

thx alan....your fix has corrected it..

[revmitchell]

When i tried to download the player my norton antivirus denied the file. Said it had a virus in it.

[SportsZone]

Any chance more file formats than MP3 can be used to work with this player?

*clicks install*

[Dluzion]

im getting this:

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 : Friday, January 5th 2007 @ 11:25:11 AM
Script : http://blazextreme.com/forum/mp3playerindex.php?do=viewmp3playerpopup
Referrer : http://blazextreme.com/forum/
Username : Dluzion
Classname : vb_database

[Allan]

im getting this:
Check this ^^

https://vborg.vbsupport.ru/showpost.php?p=1145732&postcount=422

[Dluzion]

Hey allan, thanks for the hack
i tried it and it gave me an error on line 379 when i tried to upload it

[syrus.xl]

Any chance more file formats than MP3 can be used to work with this player?

*clicks install*

I will be releasing a similar modification that uses the same technology that YouTube and Google utilize. Also compatible with with a few other sites like blip.tv etc. However, this will probably be a commercial modification.

[revmitchell]

I installed it and it os on the tool bar. when you click it you get a pop up with this message:

The page cannot be found
The page you are looking for might have been removed, had its name changed, or is temporarily unavailable.

What did I do wrong?

[syrus.xl]

I installed it and it os on the tool bar. when you click it you get a pop up with this message:

The page cannot be found
The page you are looking for might have been removed, had its name changed, or is temporarily unavailable.


What did I do wrong?

There shouldn't be a page not found error on the popup, it uses a custom vbulletin template to display the player. I'm currently updating the product XML file for a few database errors, but none are related to the popup.

This was not an issue, do you have javascript enabled?

[revmitchell]

Apparently I dont. when I tried to install it in a mod box this is the error that appeared.

Warning!!! To view this vbMp3 Player please enable JavaScript and Flash!

But I am new to this how do you do that?

[syrus.xl]

apparently I dont. when I tried to install it in a mod box this is the error that appeared.

Warning!!! To view this vbMp3 Player please enable JavaScript and Flash!

But I am so knew to this that I know just enough to mes it up I do not know how to do that.

That message is built-in to the coding of the popup window to display the player, its a message so troubleshooting can be done easier. It will only show if any of the following conditions are not met:


The player swf file is not in the root of your forum.
The flashobject.js file is missing from you forum root directory.
You don't have the latest version of Flash installed in your browser.


If you do not have flash installed or up-to-date then you will need to visit Adobe to get the latest version for your browser, to display a flash object embedded in a page. You can get it from here (http://www.adobe.com/shockwave/download/download.cgi?P1_Prod_Version=ShockwaveFlash&promoid=BIOW).

HTH.

[revmitchell]

The player swf file is not in the root of your forum.
The flashobject.js file is missing from you forum root directory.


Is there a difference between being in the root of your forum and missing from your root directory?

[syrus.xl]

Is there a difference between being in the root of your forum and missing from your root directory?

It depends on how you have your actual website setup.

A website root would be:
www.yourdomain.com

However, if you created your forums in a sub-directory like this:
www.youdomainl.com/forum

Then you would place the player swf and flashobject.js files in the forum folder. The installer assumes you have placed these files inside the forum directory in order to function with the playlist PHP file and the main popup code.

[revmitchell]

I understand that. I have it placed in www.website.com/vb

But do i need to place it in any sub folders of vb? or just in the main part of the vb folder?

And is there a yahoo tool bar associated with the download of this mod?

[revmitchell]

I deleted the other down load so as not to take up space on my hard drive and in downloading the file again my norton antivirus blocks the php. file. any thoughts. Lists it as high risk.

[revmitchell]

I got working thanks.

[syrus.xl]

I understand that. I have it placed in www.website.com/vb

But do i need to place it in any sub folders of vb? or just in the main part of the vb folder?

And is there a yahoo tool bar associated with the download of this mod?

No, this mod does not install the Yahoo Toolbar - that is part of the Flash Player Installer on Adobe's website. It should be 'unticked' before you preceed to install the latest Flash Player in to your browser.

[revmitchell]

I got it visable. I loaded mp3's to it but fail to hear any music. The play button is flashing but it appears there is a progress bar? at the top and it isnt moving forward. What else might I be doing wrong?

sorry to be such a pest.

[syrus.xl]

I got it visable. I loaded mp3's to it but fail to hear any music. The play button is flashing but it appears there is a progress bar? at the top and it isnt moving forward. What else might I be doing wrong?

sorry to be such a pest.

Reasons for songs not loading could be any of the following:

If the mp3 track name contains any abnormal characters, e.g =+.(/ etc. or if the tracks have spaces like this example:

I believe in miracles.mp3 <-- this title would not be read incorrectly by the player. You would need to change it to this.

i_believe_in_miracles.mp3 <-- note no spaces in the title. Underscores and the minus signs are acceptable.

Flash can be funny when reading external file names. I tend to keep all my files without any capital letters in file names, this avoids problems.

[revmitchell]

what should the buffer be set on?

[syrus.xl]

what should the buffer be set on?

The player has a default buffer value of 5 so the buffer value you set in vbulletin just overrides this setting.

The buffer is measured in seconds... so it can buffer upto 10 seconds of data before playing, in most cases it will work with a value of 0 - 2 max - depends on server and network speeds.

You need to enable Streaming for the buffer value to work.

[revmitchell]

I want to thank you for your timely replies and your patience. God Bless.

[syrus.xl]

I want to thank you for your timely replies and your patience. God Bless.

No problem!:) It's what support is for! Eventhough I've been very busy lately with other projects.

[revmitchell]

Could my problem be my hosting account? I host the mp3's at wikiupload and they give me a big long code rather than just a url.

example:

http://www.wikiupload.com/get_rss.php?user_id=12505&pop_files_number=1&my_files_number=1&ch_box_files_by_tag_1=on&tag_1=praise+to+god+%21&tag1_files_number=1&choose_tag1=myFiles&tag_2=&tag2_files_numb

[syrus.xl]

Could my problem be my hosting account? I host the mp3's at wikiupload and they give me a big long code rather than just a url.

example:

http://www.wikiupload.com/get_rss.php?user_id=12505&pop_files_number=1&my_files_number=1&ch_box_files_by_tag_1=on&tag_1=praise+to+god+%21&tag1_files_number=1&choose_tag1=myFiles&tag_2=&tag2_files_numb

That is a rss output url - and far too long for the player to process. Any url should be processed with the .mp3 extension at the end, nothing else as this would then be read by flash as a flashvar which the player will not recognize.

[revmitchell]

Hence my problem. Gotchya!

[admin0]

what is the difference between this and the other one with vbMp3 and xeon ?
are both the same products? then why 2 plugins ?

[syrus.xl]

what is the difference between this and the other one with vbMp3 and xeon ?
are both the same products? then why 2 plugins ?

There's a big difference between the two versions. The first one is XML driven and only uses one IF conditional to hide the launch link. Hence, it uses no SQL queries.

This version is fully integrated into vBulletin - and managed via the ACP -> Mp3 Player Management. It is not XML driven, and all track data is held in the database. For other features read the first post.

[Dluzion]

syrus im still getting this can you please help???

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 : Friday, January 5th 2007 @ 11:25:11 AM
Script : http://blazextreme.com/forum/mp3play...mp3playerpopup
Referrer : http://blazextreme.com/forum/
Username : Dluzion
Classname : vb_database

[trd167]

so is the plugin all working now or still a no go?

[SuperDank]

nice....

im almost there.. can someone please tell me how to get it to play??? i have three songs... seems to be reading them.. 50cent is 5mb.. the other ar 50mb (mp3s)..

thanks!!!!!
http://420kill.com/forums

Click on 420TUNES

[JVCode]

Just installed, but getting this error when trying to open the player;

Unknown column 'approvemp3' in 'where clause'

[Allan]

Read all posts to thread please ^^

https://vborg.vbsupport.ru/showpost.php?p=1145732&postcount=422

[JVCode]

Read all posts to thread please ^^

https://vborg.vbsupport.ru/showpost.php?p=1145732&postcount=422

Ah excellent, works like a charm now, thankyou! :D

[TheBlackPoet]

installing when i get home>>> damn come on 8a!!!

[SuperDank]

W00T!!!

works...

thanks guys!! you guys rock!

[Dluzion]

Nevermind figured it out

[Vampyre]

Many thanks, syrus.xl, for releasing this as a free version for vB licensees. :D

In xml file, find:

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

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


Thanks for the update, Allan.:up:
It's installed like a charm. :p

[Zowners]

i installed it, saved the setting but when i try to add a file i get this:



Database error in vBulletin 3.6.0:

Invalid SQL:
insert into mp3playlist values(

'','http://www.paramorefans.com/mp3sVbulletin/All We Know(9.24.06).mp3','true','1','test',''

);

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

[Vampyre]

In the MP3 URL, try replacing blank spaces with %20, and see if it makes any difference.

[Zowners]

thanks for replying
but i got the same message again, i even tried unninstallinf the plug in and installed it back

Database error in vBulletin 3.6.0:

Invalid SQL:
insert into mp3playlist values(

'','http://www.paramorefans.com/mp3sVbulletin/All%20We%20Know(9.24.06).mp3','true','0','test',''

);

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

[afmarko99]

I am getting the same problem.

Searching everywhere for a fix.

[GSPFAN]

Read all posts to thread please ^^

https://vborg.vbsupport.ru/showpost.php?p=1145732&postcount=422


I have tried this several times but i still get the error


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

[dholt]

why has the download not been updated with this fix.
https://vborg.vbsupport.ru/showpost.php?p=1145732&postcount=422

Just a Question

[Xbizcafe]

When I unzip my antivirus tell me problem with :

mp3player_admin.php

it's tell me this virus : http://www.symantec.com/security_response/writeup.jsp?docid=2002-101518-4323-99

[dholt]

there is no virus turn your virus off and then open it and upload it to your server.

[ktp101]

this looks like a good hack, wondering what kind of effect this will have on bandwidth, can anyone with this installed give me an indication of what difference its made to their forum.

[JuGgOlOw22]

Cn SOmeone Help me with this am getting this as a error wen i click on the link on he Navbar :

Invalid SQL:

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

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

Hit me on AIm at coronaqueenz127 please

[dknelson]

I really like the idea of this but I too am concerned about bandwidth. Any responses would be appreciated.

Another question. Is there any way that we are going to get in trouble with copyrights on the songs? I run a free site and can't afford to be fined. :)

[Murex]

I installed per directions and receive this error when trying to add any mp3's:


Invalid SQL:
insert into vb3_mp3playlist values(

'','http://www.site.net/mp3.mp3','true','5','Name',''

);

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

[JuGgOlOw22]

iight i been having this problem i could add mp3 everything works but...... it wont play the song it just sits there the mp3 link im sing is f\rom the ipod mp3 player i had so im just takin the links and adding them but the still dont work

www.nextelsprintforums.com/files/100.mp3

thats the link iuse ANY 1 help me

[goodguy]

I was getting a permissions error then when I edited the user groups got 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 : Sunday, January 28th 2007 @ 10:20:04 AM
Script : http://hairdivision.co.uk/forums/mp3playerindex.php?do=viewmp3playerpopup
Referrer :

Just when I thought I had learned to install things correctly first time. :confused:

[Allan]

Read all pages (my posts)

[goodguy]

Read all pages (my posts)

Thanks, It works!!!!!!!!!!!!!! (I knew I should have read right the way through the thread)

Just a thought Alan, do you know anything about building furniture? I should have read that manual too.
;-)

[scart3r]

Another happy customer :) Thanks heaps

[Murex]

That also took care of my issue as well, thanks Allan.

They really should change that for the download.

[Neal-UK]

Is there a way for people to upload their songs rather than link to another site?

[cykelmyggen]

This is what I'm getting when I try to launch XEON-player - does anyone have a clue...? I followed install-instructions as written in text-doc!

Database error in vBulletin 3.6.4:

Invalid SQL:

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

MySQL Error : Unknown column 'approvemp3' in 'where clause'
Error Number : 1054
Date : Sunday, January 28th 2007 @ 10:18:58 PM"

[donaldgkimball]

Hi there:

Please forgive me if this one has been covered before. Quite honestly as I sorted through and used the search features I could not find some obvious answers to my question about windows media player capability.

Here is simply what I want to do:

In a post that I create I simply say: To hear and view this species of bird click here:

at that point windows media player is activated and my file plays for the mbr wanting to view it.

Can anyone tell me if there is a hack I can buy to do this? and how is this set up?

Thanks so much and this should be a common question so forgive me if it has been dealt with at length elsewhere. I couldnt find the informatioin if it has been.

Cheers!

Don

[^SuiCyde^]

i'm sure you could just create an embed bb code, not sure on the specifics though, and have it so you just type in the file name you want embedded.....

[micheal332001]

Cn SOmeone Help me with this am getting this as a error wen i click on the link on he Navbar :

Invalid SQL:

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

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


Hit me on AIm at coronaqueenz127 please

I installed per directions and receive this error when trying to add any mp3's:


Invalid SQL:
insert into vb3_mp3playlist values(

'','http://www.site.net/mp3.mp3','true','5','Name',''

);

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


I was getting a permissions error then when I edited the user groups got the following?



Just when I thought I had learned to install things correctly first time. :confused:

This is what I'm getting when I try to launch XEON-player - does anyone have a clue...? I followed install-instructions as written in text-doc!

Database error in vBulletin 3.6.4:

Invalid SQL:

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

MySQL Error : Unknown column 'approvemp3' in 'where clause'
Error Number : 1054
Date : Sunday, January 28th 2007 @ 10:18:58 PM"

Hi all

I see there is still this error poping up i will try today and fix this so it will install all the tables with out errors.

Just give me a few hours and i should have a fix for you.

[dknelson]

I really like the idea of this but I too am concerned about bandwidth. Any responses would be appreciated.

Another question. Is there any way that we are going to get in trouble with copyrights on the songs? I run a free site and can't afford to be fined. :)

Not trying to be pushy but any opinions/answers on this?

[MarcG]

Hey all,

Got everything hooked into the admin CP but I'm now getting a database error. I tried the revised XML code as well but no luck, I still get the below db error message.

Database error in vBulletin 3.6.4:
Invalid SQL:

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

MySQL Error : Unknown column 'approvemp3' in 'where clause'
Error Number : 1054
Date : Monday, January 29th 2007 @ 07:59:54 PM

[MarcG]

The below script problem looks to be fixed when more than 1 mp3 is loaded into the playlist.



ok...re-installed again and reimported the xml file, all looked to be working great until I loaded up 1 mp3 file, the mp3 played and then next popped up. Any ideas what might be causing this?

Tested using Firefox/2.0.0.1 and IE 6.0

https://vborg.vbsupport.ru/external/2007/01/1.jpg

[scart3r]

Hi :) I have installed it, fixed up the database error thing and it didn't work. Basically I can load mp3's but when I go to play them, the play button just flashes. I uninstalled it and did the whole process again, and the same thing is happening. I have had a look through the 34 pages of info here, but couldn't find my mistake. Please help :)

My forum is at http://www.nettrafficchat.com

Cheers,
Cindy