With optional store hack intergration
 

Here we go, time for some music....I have seen a few threads here requesting a jukebox hack.
So here it is...

Once you have installed this hack please keep in mind legal issues we loading your jukebox with songs.
You can add MP3 however it is NOT advisable without permission from the copyright governing bodies in your country.
The jukebox operates in its own seperate browser window

Here are the instalation instructions for the Jukebox hack. It wont take you very long.
As like my other hacks this hack is also designed to operate on its own or with Lesane's store hack
If you have the store hack installed you can make users buy "Jukebox Plays" from the store before they can listen to songs.

The admin area is highly configurable and the jukebox has 4 different modes
1) Off
2) On - Jukebox Plays Needed (Lesane's Store Required)
3) On - Freeplay For Members & Guests
4) On - Freeplay For Members Only

There is also defult audio settings, this defult is used at the beginning of jukebox session (when a user opens the jukebox)
1) You can nominate a defult song. I have recorded an MP3 voice introduction that you can use.
2) You can set it to play the most requested song.
3) No audio

There is also a top 10 song list as well.

DEMO: www.atmyparty.com

SCREENSHOT: Next posts

REQUIREMENTS:

2 X php file alteration
1 X database query
9 X new templates
3 X template modifications

INSTALATION TIME: aprox. 15 - 20 min

Tested on 2.2.8 but should work on all versions.

update...big fixes to page no 5

~ This hack is Copyright ~
Please note that I reserve the right to code and release this hack for VB3, I have not and will not grant permission for anyone else to code this hack for VB3.

admin config

admin modify

freeplay jukebox

store hack intergration

jukebox plays required

store hack intergration

warning buy more jukebox plays

finally

store hack intergration

store bit

Wow, this looks nice. Can you make it so members can link external streaming swf into it instead of midi?

i will look into it

OH MY GOSH! This is exactly what i've been looking for! :)

Do you have to upload the mp3's to your server?

- miSt

Yep, upload the music files to your server and link them from the "add" in the jukebox admin

glad you like it.......2 out of 3 :)

Problems I'm having:

In jukeboxquery.php I had to change:
<form action="Jukeboxquery.php" method="post">

to:
<form action="jukeboxquery.php" method="post">
my server was is case sensitive.

Also I can not see the options. The page is blank. ??

I will love this when it gets working. thanks

I get this error when trying to view jukebox.php:

Database error in vBulletin 2.2.7:

Invalid SQL: SELECT * FROM jukeboxadmin WHERE event='1'
mysql error: Table 'schiphopforums.jukeboxadmin' doesn't exist

mysql error number: 1146

wont this eat a lot of Bandwidth if they on your server ?

auz1111 - you need to run the necessary queries which will create that missing table ;)

- miSt

what are the other queries? I ran jukeboxquery.php and it worked fine. I don't see a query to add jukeboxadmin table

ok i have two jukeboxquery.php files in the zip I downloaded. I ran both, but now this query won't run:

"INSERT INTO banneradmin VALUES (NULL,'2', 'http://www.xxxx.xxx/midi/midi/xxxx.xxx', 'Description', '1', '0')");
echo "<p>Default Admin values added in jukeboxadmin table";

Where did the banneradmin table come from?
Is there something else I'm missing now?

replace the banneradmin with jukeboxadmin and also in jukebox.php remove the call to saw in the db queries and then it runs fine.

He never added saw in the jukebox table, but left the call to the db in the query which results in the error you were getting in jukebox.php i believe

awesome SB2002!! But just one more problem... my options still show a blank page when I click the options button in the ACP. Everything else works fine: can play songs, can add and edit, etc.

any idea?

yeah, i got that too. change the link you add in admin/index.php from action=options to juke.php?action=config

ie from this:

makenavoption("Options","juke.php?action=options", "|");

to this:

makenavoption("Options","juke.php?action=config"," |");

that will bring up the options screen then.

damn...i didnt realise those few coding errors, that will teach me to work on more than one hack at a time.......lol

I will download the jukebox php files from my server and rebuild the zip file.....

sorry again for the stuffups

re instaling tables, you need to install from the jukebox_hack folder first, then the other one if you have the store hack

Hey, considering the way the hack actually works, i'd say that only having these minor little errors are nothing much at all. I ain't no hack writer at all, but I have had a lot of experience recoding stuff and rewriting bits to suit my board, so i knew pretty much what to look for and where to look.

I must say tho, very nice hack and nice to finally see something like this made, i've had members asking for something like this for a while, lol.

That did it SB2002! You da man! Don't sweat it Trafix. This is a great hack and I appreciate it! ...hmmmm Now only if there was a way to search them when the list gets long. :)

--edit-- (forgotten to run the store sql) ;)

great hack!!!!! is there a possibility that users can upload songs ?
also it would be great when the song would continue when u browse the forums.

hmm I think this should be tested before u post it here, I get a DB error:

Upload is not a good idea schorsch, linking to external mp3, midi or streaming swf is better. Your error is caused by not installing the store sql part of the hack :)

Schorsch,

You will be getting this error if you have not set the config right, jbplays is apart of the store hack intergration...if you havnt got the store or installed the jukebox_store_intergration then make sure the admin config is
"NO"- have you got store hack

and select other jukebox mode to jukebox plays required.....

However if you do have the store installed then you need to run the quirie php located in the intergration folder, let me know if you have any further errors or probs.

PS zip v1.1 is now uploaded, hopefully this will correct all bugs reported before this post



The jukebox is designed to open in a new browser window so the user is free to serf around the site in the original window, however they need to return to the jukebox to start the next sone

The installation seemed to go fine, but none of the music is playing when you select a song. (I've waited for it to finish loading, and the locations are correct.)
Any idea of what could cause this problem?
This is just the sort of hack I was looking for, so I'd really love to get it working...

U can't link to music files on another server?

BTW very nice hack!!

Yep, as long as you enter the full url in the field when you add a song, it can be anywhere.

hmmmmm can you either post or pm the ulr to your jukebox please.....and either select a defult song or put it in freeplay mode so i can have a look...tnx

Very nice TY

*clicks Install

I just can't get over this hack buddy - i've wanted it for so long. In fact i might just install it tonight :)

- miSt

To let this work with streaming swf (made out of mp3 wich is extremely cool) you can change this in the 'jukebox_play_song' template:

Replace
<bgsound src="$playsong" loop="1">

with:
<embed src="$playsong" width="0" height="0">

Invalid SQL: SELECT storename,pointname,ban FROM storeadmin
mysql error: Unknown column 'ban' in 'field list'

mysql error number: 1054

Everything runs ok - ran the queries as well

and still get that ???

I do have the store hack installed and i ran the query for that even checked everything again but its a no go

I get that when i click on the link on main forum home page to go to it.

Sweet ty NuclioN

can someone give some info on what program to use to convert mp3s to swf

I tried this one but when playing in IE it shows a Scroll bar with stop/Play etc or is this correct ??

http://www.actionscript.org/software...ump.cgi?ID=115

not that i can stream em to my prob is sorted out in Post 37
but any info on this would help for when i do.

You can convert mp3 to swf with flash (5 or mx). Now, it's not easy to explain how to do this, but i shall try to make a tutorial for it.
You can import a mp3 in flash and then click window/library. After that click with the right mousebutton on your mp3 and choose properties and set this as output:

- compression = mp3
- unmark (do not select) convert stereo to mono
- bitrate = 128 kps
- quality =fast

Now, after you've done this you must doubleclick on the first keyframe on the timeline and a sound editwindow apears. Choose the sound from the display and set this:

- effect = none
- sync = stream

Ok, after this you must stretch the output over the whole timeline untill there is no grafical output visible, so make frames (somethimes 2 to 3000 or more) untill all the output is visible. Remove the empty frames after the last visible output. Your streaming swf file is now ready to export. Export the swf as it is, so don't make changes in the output.

Upload this swf file to your server and listen to it in your forum (html enabled or you must have the swf vb code tags installed) with this code:

<embed width="0" height="0" src="http://www.yourserver.com/yourfile.swf">

Or when you have the swf vb code installed:
{SWF=http://www.yourserver.com/yourfile.swf} width="0" height="0"{/SWF}

Remember the { tags must be replaced with [ to let that work.

Screendump flashsettings: