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.

[trafix]

Today at 05:34 AM DPoole said this in Post #37
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.

Interesting....however change

PHP Code:

$yesstore = $DB_site->query_first("SELECT storename,pointname,ban FROM storeadmin"); 


to

PHP Code:

$yesstore = $DB_site->query_first("SELECT * FROM storeadmin"); 


should fix your prob

[trafix]

Today at 03:39 AM Mist said this in Post #35
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

Im glad you like it..is it good enough for a MOTM nomination

[DPoole]

$yesstore = $DB_site->query_first("SELECT * FROM storeadmin")
You have an error in your SQL syntax near '$yesstore = $DB_site->query_first("SELECT * FROM storeadmin")' at line 1

[trafix]

sorry just got out of bed when i posted that

PHP Code:

$yesstore = $DB_site->query_first("SELECT storename,pointname FROM storeadmin"); 


[Kurayami]

Problem fixed with post 37... I was using .swf files with the improper code. *Knocks self on head.* Thanks for the great hack, by the way!

[DPoole]

$yesstore = $DB_site->query_first("SELECT storename,pointname FROM storeadmin")
You have an error in your SQL syntax near '$yesstore = $DB_site->query_first("SELECT storename,pointname FROM storeadmin")' at line 1

Aint sure why getting this error though as i installed it correctly
get no errors what so ever until i click to go to jukebox then get the sql error box

[DPoole]

Today at 02:40 AM Kurayami said this in Post #45
Problem fixed with post 37... I was using .swf files with the improper code. *Knocks self on head.* Thanks for the great hack, by the way!

Post 37 ?? how u mean dont follow your answer to it

[DPoole]

I have now just installed this to a test board - no store installed and only did the first part of the hack and left out the store integration - Also turned store off in Admin CP as well

Note the following error :

Database error in vBulletin 2.3.0:

Invalid SQL: SELECT storename,pointname,ban FROM storeadmin
mysql error: Table 'testboard.storeadmin' doesn't exist

mysql error number: 1146

so whys it askin for store when it aint installed and the option is set to No in admin CP

[Kurayami]

Ah, sorry about that! My brain took down the incorrect post number--the fix was posted in post 36, which was right above yours. I must remind myself not to post while half-asleep.

[trafix]

Today at 02:57 PM DPoole said this in Post #48
I have now just installed this to a test board - no store installed and only did the first part of the hack and left out the store integration - Also turned store off in Admin CP as well

Note the following error :

Database error in vBulletin 2.3.0:

Invalid SQL: SELECT storename,pointname,ban FROM storeadmin
mysql error: Table 'testboard.storeadmin' doesn't exist

mysql error number: 1146

so whys it askin for store when it aint installed and the option is set to No in admin CP

ooooops....try this ....find

PHP Code:

$yesstore = $DB_site->query_first("SELECT storename,pointname,ban FROM storeadmin");
$jukeboxadmin=$DB_site->query_first("SELECT * FROM jukeboxadmin WHERE event='1'");
$caniplay=$jukeboxadmin[playtype];
$isstore=$jukeboxadmin[storehack]; 


replace with

PHP Code:

$jukeboxadmin=$DB_site->query_first("SELECT * FROM jukeboxadmin WHERE event='1'");
$caniplay=$jukeboxadmin[playtype];

if($jukeboxadmin[storehack]=="1") {
$yesstore = $DB_site->query_first("SELECT storename,pointname,ban FROM storeadmin");
$isstore=$jukeboxadmin[storehack];
} 


sorry