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.

[Roxie]

Hey thanks, savgeDusk for that. It worked beautifully.

[dstruct2k]

Originally Posted by SavgeDusk

To get it to count correctly, change the 'splay' VARCHAR to INT. -- That corrects both Top 10 & Most Played song. =3

Yep, just figured that out on my own. I shoulda looked at the tables before I posted.

[KAC]

I have not found this in this thread if it was posted I appologize..

Thank you by the way for the hack it is one of the best I have seen !!!

I have it installed and working properly, although I would like to set permissions somehow to only let certain user groups to see it .

I know there is a selection for members and guest and members only but I would like to make thi shonored guests and staff only to see the jukebox and use it . Can someone please let meknow hwat has to be done, or where I can go to find out how to do this .. thank you before hand ..

I know that I can make a forum for the jukebox and then set permissions for that forum but i was wondering if there was another way

[FleaBag]

Finally got around to installing this, working great. Thanks for the fixes to all who provided them in previous posts.

[bandersen]

Originally Posted by SavgeDusk

To get it to count correctly, change the 'splay' VARCHAR to INT. -- That corrects both Top 10 & Most Played song. =3

Where can I find that... and what do I change exactly... Thank you!

[bandersen]

Originally Posted by bandersen

Where can I find that... and what do I change exactly... Thank you!

Found it...working great.

[Nam]

This hack looks awesome, so it works with vb3 gamma?

[Dean C]

Originally Posted by Nam

This hack looks awesome, so it works with vb3 gamma?

No. No vB2 hacks here will work with vB3.

[Nam]

Oh, sorry, I know no vb3 hacks release yet, but I thought this one compatible with vb3 since it's just updated. Oh well, guess I'm gonna wait for another few months then.

[LukeC]

I made sure that the the zip file was updated from pages 2 & 3 on this thread with ppl who had the same error, but to no avail. It works fine without the integration of the store hack, but when I try to get it to run with the store hack, I get this error. Any help would be much appreciated.

Database error in vBulletin 2.3.2:

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

mysql error number: 1054