With optional store hack intergration

[trafix]

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 (http://www.atmyparty.com/network/)

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]

admin config

[trafix]

admin modify

[trafix]

freeplay jukebox

[trafix]

store hack intergration

jukebox plays required

[trafix]

store hack intergration

warning buy more jukebox plays

[trafix]

finally

store hack intergration

store bit

[NuclioN]

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

[trafix]

i will look into it

[Dean C]

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

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

- miSt

[trafix]

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

[auz1111]

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

[auz1111]

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

[DPoole]

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

[Dean C]

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

- miSt

[auz1111]

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

[auz1111]

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?

[SB2002]

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

[auz1111]

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?

[SB2002]

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.

[trafix]

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

[SB2002]

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.

[auz1111]

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

[NuclioN]

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

[Schorsch]

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.

[Schorsch]

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

Database error in vBulletin xxx:

Invalid SQL: SELECT userid,username,jbplays FROM user WHERE userid='2'
mysql error: Unknown column 'jbplays' in 'field list'

mysql error number: 1054

Date: Friday 28th of March 2003 02:58:04 AM
Script: http://www.xxxxxxxxxxxxx.com/vB/jukebox.php
Referer:

[NuclioN]

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

[trafix]

Today at 12:04 PM Schorsch said this in Post #26 (https://vborg.vbsupport.ru/showthread.php?postid=374313#post374313)
hmm I think this should be tested before u post it here, I get a DB error:




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.

[trafix]

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


Today at 11:32 AM Schorsch said this in Post #25 (https://vborg.vbsupport.ru/showthread.php?postid=374298#post374298)
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.


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

[Kurayami]

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

[Lethal]

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

[Lethal]

BTW very nice hack!!

[trafix]

Today at 03:43 PM Lethal said this in Post #31 (https://vborg.vbsupport.ru/showthread.php?postid=374386#post374386)
U can't link to music files on another server?


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

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.)

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

[Lethal]

Very nice TY

*clicks Install

[Dean C]

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

[NuclioN]

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

[DPoole]

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.

[Lethal]

Today at 01:51 PM NuclioN said this in Post #36 (https://vborg.vbsupport.ru/showthread.php?postid=374596#post374596)
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">


Sweet ty NuclioN

[DPoole]

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/main/jump.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.

[NuclioN]

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:

[trafix]

Today at 05:34 AM DPoole said this in Post #37 (https://vborg.vbsupport.ru/showthread.php?postid=374609#post374609)
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

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

to

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

should fix your prob

[trafix]

Today at 03:39 AM Mist said this in Post #35 (https://vborg.vbsupport.ru/showthread.php?postid=374568#post374568)
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 :cool:

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

$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 (https://vborg.vbsupport.ru/showthread.php?postid=374779#post374779)
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. :D

[trafix]

Today at 02:57 PM DPoole said this in Post #48 (https://vborg.vbsupport.ru/showthread.php?postid=374830#post374830)
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

$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

$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

[DPoole]

Done that in jukebox.php i don`t get the same error now LOL

i get this

Invalid SQL: SELECT userid,username,jbplays FROM user WHERE userid='1'
mysql error: Unknown column 'jbplays' in 'field list'

mysql error number: 1054

[trafix]

Today at 05:17 PM DPoole said this in Post #51 (https://vborg.vbsupport.ru/showthread.php?postid=374868#post374868)
Done that in jukebox.php i don`t get the same error now LOL

i get this

Invalid SQL: SELECT userid,username,jbplays FROM user WHERE userid='1'
mysql error: Unknown column 'jbplays' in 'field list'

mysql error number: 1054


ok i do have the store installed so obviously i mist some stuff in the stand alone version....i will update the zip file once these bugs are fixed......thenks for your co operation & persistance DPpoole....try this find around line 123

$userstuff = $DB_site->query_first("SELECT userid,username,jbplays FROM user WHERE userid='$bbuserinfo[userid]'");


replace with

if($jukeboxadmin[storehack]=="1") {
$userstuff = $DB_site->query_first("SELECT userid,username,jbplays FROM user WHERE userid='$bbuserinfo[userid]'");
}

[NuclioN]

Hm..the top 10 does not work properly, it is placing the last added song as the one that is most requested (after listen to it once) altough this is not the case.

[DPoole]

works cheers

now to suzz out to get it to play a song :)

cheers m8 once again

Clicking on top 10 in Jukebox gives a java error and dont open the windown as well.Not sure if u knew about this

Edit got it playing songs well now :)

cheers once again will try with store later on

Is flash the only way to make mp3`s stream as i have a couple of Trance mp3s and they about 70megs people wont want to listen to them if it downloads its instead of streamin it.

[trafix]

Today at 02:57 AM DPoole said this in Post #54 (https://vborg.vbsupport.ru/showthread.php?postid=375020#post375020)
works cheers

now to suzz out to get it to play a song :)

cheers m8 once again

Clicking on top 10 in Jukebox gives a java error and dont open the windown as well.Not sure if u knew about this

Edit got it playing songs well now :)

cheers once again will try with store later on

Is flash the only way to make mp3`s stream as i have a couple of Trance mp3s and they about 70megs people wont want to listen to them if it downloads its instead of streamin it.


in your jukebox template find:
$header

after this add
<script LANGUAGE="Javascript">
<!--
function showwin(name,size)
{
attrbts = size + ",resizable=yes,toolbar=no,location=no,directories= no,status=no,menubar=no,scrollbars=yes"
window.open(name, "juke", attrbts);
}
//-->
</script>

[DPoole]

works for top 10 Now

it dont open a new window though it just shows top10 in the same window as the julebox was in - also has a sort of delay before opening

[DPoole]

Yesterday at 08:50 PM DPoole said this in Post #39 (https://vborg.vbsupport.ru/showthread.php?postid=374651#post374651)
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/main/jump.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.


The above link is good for doing mp3`s in swf mode for ease of use.I have just done a 70meg mp3 and took less than a min to convert i then upped it to server and now its streamin it fine.

Note if u run the swf file it creates in IE on its own

example http://testboard/song.swf you get a loader playing which u dont want but if u stream it though the store the loader dont show.

So works a treat and the program is easy to use.

[trafix]

in the jukebox.php the following appears 4 times.....make sure that this is correct

$maxplay="<font size=\"2\">The most played song is: <a href=\"jukebox.php?s=$session[sessionhash]&action=main&mysong=$mostplayed[songsid]\"><b><i>$mostplayed[sname]</b></i></a> with <b>$mostplayed[splay]</b> requests.</font><br>Click <a href=\"javascript:showwin('jukebox.php?action=top10', 'width=400,height=300')\"><b><u>here</u></b></a> to view the top 10 most played songs.<br><smallfont>Please Note: Clicking on Top 10 may stop the song from playing.</smallfont><br>";

[DPoole]

Lo trafix appreciate your help on this and the other hack u made.

Will you be an updated Zip for standalone and for store with the following added ?

Love the hack by the way - is easier to actually stream from your comp than uploading all these mp3s to server

Cheers has a lot of potential esp for people who make their own Music traxs up as they can now let people stream em from the board.

Well done.

[trafix]

I persume that all is working now!

Yep I will update the zip soon :)

glad you like it.

[DPoole]

yep - one question - not sure if me or not but im finding that my swf files are only playing a certain percentage of the orginal track then just stop.

Not sure if its just me with using that link above but converted 3 to swf and all have not reached the end of the song before stopping.

Just tried an mp3 song and that played all way to end.So its obviously something to do with way im converting em to SWF i think so aint part of hack really but just thought id let others know see if they got same probs.

[trafix]

great news!

RE swf files..........I have no idea...:(

i will update zip to v1.2 soon

[DPoole]

trafix

if its possible - you know on the main forum home page when u click the julebox link can you make it so it opens in a java window etc and just has the jukebox without the main logo at top of page with all the buttons.

[trafix]

yeah its possible,

it will need some template editing,

but it is 4:39 am and i have spent the day adding about 10+ hacks...so its bed time 4 me.

lit me know if you want me to build the templates 4 u or if you want to have a bash at it :)

Night!

[DPoole]

Today at 05:40 PM DPoole said this in Post #59 (https://vborg.vbsupport.ru/showthread.php?postid=375050#post375050)
Lo trafix appreciate your help on this and the other hack u made.

Will you be an updated Zip for standalone and for store with the following added ?

Love the hack by the way - is easier to actually stream from your comp than uploading all these mp3s to server

Cheers has a lot of potential esp for people who make their own Music traxs up as they can now let people stream em from the board.

Well done.


FIXED MY PROBS WITH MP3 to SWF

go here download the swf to mp3 http://www.soundnails.com/

it then converts to swf but gives u 2 files delete the loader one as aint needed and just keep the mp3 swf file and upload to server and works fine.Just done 5 songs this way and all played to end.

[NuclioN]

wow Dpoole! :D It would be great if the output can be implemented or embeded in the jukebox.

[Marzas]

i get this error when trying to get into the jukebox.php file

Database error in vBulletin 2.2.9:

Invalid SQL: SELECT * FROM jukebox WHERE songsid=
mysql error: You have an error in your SQL syntax near '' at line 1

mysql error number: 1064

Date: Saturday 29th of March 2003 09:28:00 PM
Script: http://www.flowingevolution.com/forum/forum/jukebox.php
Referer:


why the hell is it doing forum/forum?
its supposed to be just /forum

please help me fix this!

cheerz

Marzas

[trafix]

Yep you will get this error of you have no songs loaded in the jukebox...you can do this from your admin panel

[Marzas]

cool, talk about quick support, i put it for 1 sec, refreshed and your here, thanks m8

[Marzas]

also, my store.php is stuffed up, its all in text and and fully stuffed. what do i do? redo the coding again carefully?

[trafix]

what other addons have you put into the store?

if none....grab the zip file from the store thread and start your store.php from scratch

[Marzas]

Today at 05:53 AM trafix said this in Post #68 (https://vborg.vbsupport.ru/showthread.php?postid=375346#post375346)
Yep you will get this error of you have no songs loaded in the jukebox...you can do this from your admin panel

now i get a blank screen!

whats with that, and my store is all jumbeled up with text of the file!

[Marzas]

yello, somebody wake up!
all i am getting is a blank screen and i here some redirecting clicks in the background, about 4. Its a 100% white screen, and i did everything right, what the hell is going on!

[trafix]

you are getting a blank screen on your store or jukebox?????????

[Marzas]

jukebox!, store is perfect.

[Marzas]

any idea?

[trafix]

sorry yes i did post it in the wrong forum...lol

ok thanks for the link..

Umm,

first check your templates....looks like the templates have not been added

second, re upload a new copy of the jukebox.php

[ricoche]

Excellent work trafix!

This installed perfectly and I even got the streaming SWF working as well. Thanks DPoole for the SWF info and big thanks again to trafix for all your hard work!!

Ricoche

[trafix]

if you dont mind...i would like to sign up to check it out

[trafix]

Today at 08:08 PM ricoche said this in Post #78 (https://vborg.vbsupport.ru/showthread.php?postid=375421#post375421)
Excellent work trafix!

This installed perfectly and I even got the streaming SWF working as well. Thanks DPoole for the SWF info and big thanks again to trafix for all your hard work!!

Ricoche


Nice job! Glad that you like the hack.

[DPoole]

not sure if u still readin this hack

but when playing an mp3

the top 10 aint correct

i have a song that been played 13 times and yet the number 1 trax is a song that only been played twice??

[trafix]

Today at 01:47 PM DPoole said this in Post #81 (https://vborg.vbsupport.ru/showthread.php?postid=375762#post375762)
not sure if u still readin this hack

but when playing an mp3

the top 10 aint correct

i have a song that been played 13 times and yet the number 1 trax is a song that only been played twice??


Im not completly sure why it is doing that, i actually noticed it on another site that i just visited.....hmmmm....check this line it appears twice

$mostplayed=$DB_site->query_first("SELECT songsid,sname,surl,splay FROM jukebox ORDER BY splay desc LIMIT 1");

or try the desc in caps....dont know if it is caps sencitive but

The most played works fine for me.....it should not mater what format you are playing from.

[Sebastian]

LoL. this must use tons of bandwidth :|

this will take down your server if you have 50 members listening to music :p

[trafix]

Yesterday at 07:10 PM Marzas said this in Post #76 (https://vborg.vbsupport.ru/showthread.php?postid=375406#post375406)
any idea?

I see that you still havnt got it working.

Another thought.......have you added the templates to the right / all template groups?

[trafix]

Today at 02:21 PM Sebastian said this in Post #83 (https://vborg.vbsupport.ru/showthread.php?postid=375776#post375776)
LoL. this must use tons of bandwidth :|

this will take down your server if you have 50 members listening to music :p

Sebastian....this is a request in the other forum

https://vborg.vbsupport.ru/showthread.php?s=&threadid=51014

[Areku]

Isn't it ilegal to hook up mp3 filez for public audition? ;)

[Areku]

Isn't it ilegal to hook up mp3 filez for public audition? ;)

[Areku]

Isn't it ilegal to hook up mp3 filez for public audition? ;)

[Marzas]

yeah, but as he mentioned on the first post, its not really made to play mp3s, its was mainly amde for midi's, but some times there are things in mp3 who dont give a crap if you take it, like personal stuff, well anyway, he didnt as you to put on mp3's, did he?

[Marzas]

yo trafix, man, i was looking in the jukebox.php, it looks alot similar to the buy a midi for your profile option in lesanes store hack, is it me or is some of it copyed and edited?

[DPoole]

Areku and Marzas you really need to learn to chill

One yes it is Illegal but not all mp3`s are illegal esp if u make your own (if u have the talent that is) and if it is based on the buy a midi then good as i dont care as this does the job i want it for.Maybe encouraging hackers and not putting em down is what is needed.If u can do better then lets see it.

[DPoole]

Areku and Marzas you really need to learn to chill

One yes it is Illegal but not all mp3`s are illegal esp if u make your own (if u have the talent that is) and if it is based on the buy a midi then good as i dont care as this does the job i want it for.Maybe encouraging hackers and not putting em down is what is needed.If u can do better then lets see it.

[DPoole]

Areku and Marzas you really need to learn to chill

One yes it is Illegal but not all mp3`s are illegal esp if u make your own (if u have the talent that is) and if it is based on the buy a midi then good as i dont care as this does the job i want it for.Maybe encouraging hackers and not putting em down is what is needed.If u can do better then lets see it.

[DPoole]

crap,mods can u delete all the repeat posts

real sorry about that - i hit submit and it seemed to lock hence all the repeat posts.

[auz1111]

03-28-03 at 10:33 PM NuclioN said this in Post #40 (https://vborg.vbsupport.ru/showthread.php?postid=374680#post374680)
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:

I'm not understanding. Is this a way to integrate .swf's with the jukebox or just for stand alone playing? If it is to work with the jukebox could you explain where to place the tags? thanks

[trafix]

im sorry, i cant help you with your question...i have built this hack for midi files for legal reasons.

[Jitway]

Ok heres one for ya. I got everything installed and all the templates. I uploaded a mp3 and loaded it into the jukebox. It shows up and when you click on it the number of times requested goes up as it should but it does not play. Why?

[DPoole]

Yesterday at 12:59 AM auz1111 said this in Post #95 (https://vborg.vbsupport.ru/showthread.php?postid=376899#post376899)
I'm not understanding. Is this a way to integrate .swf's with the jukebox or just for stand alone playing? If it is to work with the jukebox could you explain where to place the tags? thanks


my post for converting mp3`s to swf works fine and ive used it many times since that post.Also if u read though there is a tag to insert in one of the posts that allows you to play SWF files.

[Crazy Pete]

What I think would make this hack even better is if it would start out by playing whatever the person before them to use it is playing, if applicable. Kind of like a regular jukebox where you hear whatever songs are queued up to go next, and if you walk in the room in the middle of a song, that's what you hear.

[Kurayami]

An interesting idea for those of us that have a great deal of bandwidth to spare: Can this hack possibly be edited to become a theater of sorts?
I.E. A user can browse through a selection of clips instead of music, and 'tickets' can be purchased... then you view a movie complete with mini-player instead of the song coming on.

I know that I'd definitely be interested in such a system. My users are loving the jukebox! (Got almost 30 mp3s on there already. :))

[ricoche]

Yes, excellent idea! I'm into video production so this would be a useful modification.

Indeed the Jukebox addon works very well, especially with SWF as it streams very well.

[trafix]

I agree, however i dont have the knoledge required to build a video addon :(

Its great that this hack is getting a lot of use, perhaps you could post in the requests forum with your addon idea.

[Rusty_Boi]

i have read the whole thread.. and i still have problems playing swf files.. =/

[Gutspiller]

Can somebody explain to me why the heck you would ever want to serve MP3s? Just use Kazaa and save yourself and your users all sorts of trouble. Now if a user could use your forum as a "middle man" to share files with other users, that would be something, but to just have a list seems almost pointless with programs such as kazaa and many others.

[Mickie D]

i cant use your jukebox queries php script .. i dunno why :(

could you post the queries so i can use phpmyadmin ... i tried to get your queries from the php file but when i goto enter them i get an error :(

[Mickie D]

ok i managed to get the queries out from the php .. silly me lol

here they are if any one else needs them and cant get the jukeboxquerie.php script to work :)

CREATE TABLE jukebox (
songsid smallint(5) unsigned DEFAULT '0' NOT NULL auto_increment,
sname varchar(255) NOT NULL,
surl varchar(255) NOT NULL,
splay varchar(5) NOT NULL,
PRIMARY KEY (songsid)
)


CREATE TABLE jukeboxadmin (
event smallint(5) unsigned DEFAULT '0' NOT NULL auto_increment,
playtype smallint(5) DEFAULT '0',
defultsong varchar(255) NOT NULL,
defultdetail varchar(255) NOT NULL,
defultaudio smallint(5) DEFAULT '0',
storehack smallint(5) DEFAULT '0',
PRIMARY KEY (event)
)


INSERT INTO jukeboxadmin VALUES (NULL,'2', 'http://www.xxxx.xxx/midi/midi/xxxx.xxx', 'Description', '1', '0')


right that lot should sort you out ok :)

[Mickie D]

also a question about the jukebox :)

right as you have said b4 when i read posts the bandwidth will be very high for busy boards... i was wondering i have appache running a test vbulletin for me on my home machine and windows XP... could i point the url to my test site for the mp3's ????

so all bandwidth would be taken from my adsl connectin i mean it does nothing really lol so i would not be bothered about it ???

[trafix]

Rusty_Boi:

Sorry, I cant help you as I know nothing about swf files.

Gutspiller:

Your opionion! I saw a request for a jukebox hack, so I built one :) It was build to play midi files but I can only warn them regarding other music formats and I will not be help responsible if members loose their websites because they broke the law.

Mickie D:

Yeah sure, you should be able to link the music file url's to your local system :) let me know how you get on.

[Mickie D]

cheers m8 for the quick reply ... to be honest thats the fastest ever reply to hack i have posted on vbulletin.org lol

ok that is gr8 and yes it is running gr8 from my local machine :) to my main website

but now i have a more complicated question m8y :(

can it stream the audio instad of downloading the whole file to play it ????

[Mickie D]

and maybe it should work in a popup window so people can browse your site (anyones site) at the same time :)

just an idea as if you leave the page or put it down to the task bar it goes off :(

[trafix]

Yep, great to here, Some users have been streaming swf files... but as i said i wouldnt know how to go about it lol

as for the the other i have added a request tot the request forum if someone could build a force to close addon for it as again im not sure how to go about it....go bump the thread :)

[Mickie D]

post me the thread and away i go lol

but thanks it is a gr8 hack and when it takes the tunes from my machine i dont care about the bandwidth :)

thanks again .... ps with the swf thing how do i make my tunes swf .. do i change the .mpg to .swf sorry i dont have a clue what i am talking about :)

[trafix]

hmmmmm, swf is flash format the music files must be converted, see earlies pages of the thread. Glad you like the hack :)

[Mickie D]

yeah i got that programme to convert them m8y

i know you dont have much idea about the swf formats :( but for the guys that got it working ... please tell me why mine wont stream it still downloads the whole swf b4 it plays it :(

[Airs]

Everything is installed properly but none of my songs will play :( please help!

[trafix]

OK put it in freeplay mode and PM a link to me!

[NuclioN]

04-14-03 at 05:31 PM Mickie D said this in Post #114 (https://vborg.vbsupport.ru/showthread.php?postid=382100#post382100)
yeah i got that programme to convert them m8y

i know you dont have much idea about the swf formats :( but for the guys that got it working ... please tell me why mine wont stream it still downloads the whole swf b4 it plays it :(

If you mail me the fla file i can make it for you in the form of a mal, so all you have to do is import, adjust settings, export and don't save the original..then you can stream mp3 as much as you wish.

[Crazy Pete]

Ok I've got the streaming swf thing working well, but I just have one question. I've noticed that once a song stops ends, it then starts to play again. Is there an easy way to not make them loop?

[NuclioN]

Yes, at the end of the timeline on the last frame add a keyframe and in that put a stop action.

I've found also a handy script to stream mp3 without the whole procedure to stream it in swf. Url: http://www.moock.org/asdg/codedepot/preloaders/Sound/soundPreloader.zip

What it does is cut the loadtime seriously by streaming the mp3 in your browser.
Now, i've first tried to place the jukebox variable $playsong in that script but i realized that the swf can not read this. There must be another way. When i find it out i let you know, if you know how to do this i hope you can help. :)

[Lethal]

Well I think I got the Top 10 working the way its supposed to. In jukebox.php replace all occurances of:

$mostplayed=$DB_site->query_first("SELECT songsid,sname,surl,splay FROM jukebox ORDER BY splay desc LIMIT 1");


With:


$mostplayed=$DB_site->query_first('SELECT * FROM `jukebox` ORDER BY `splay` DESC LIMIT 0, 30');


Takes awhile to load the songs thou. Even on cable. Is that normal? Takes like 1-2 minutes. Will the songs be cached in ur browser after you play them a few times that way they will or should play right away?

[Lethal]

Does that preloader really worK?

[Lethal]

LOL I dont' know if anyone else has been getting this but when you minimize the jukebox window the song stops playing then it plays again when you maximize the actual jukebox window.

[Lethal]

If anyone else wants the jukebox to show up in a popup just do this:

[Crazy Pete]

04-23-03 at 08:14 AM Lethal said this in Post #120 (https://vborg.vbsupport.ru/showthread.php?postid=385888#post385888)
Well I think I got the Top 10 working the way its supposed to. In jukebox.php replace all occurances of:

$mostplayed=$DB_site->query_first("SELECT songsid,sname,surl,splay FROM jukebox ORDER BY splay desc LIMIT 1");


With:


$mostplayed=$DB_site->query_first('SELECT * FROM `jukebox` ORDER BY `splay` DESC LIMIT 0, 30');


Takes awhile to load the songs thou. Even on cable. Is that normal? Takes like 1-2 minutes. Will the songs be cached in ur browser after you play them a few times that way they will or should play right away?


Still doesn't work for me. Seems to want to choose the most played and top 10 at random. It didn't affect my song load time at all, though.

[Crazy Pete]

Just recently got a complaint from one of my moderators that everytime they try and access the jukebox (in either browser) they get logged off the forums? I don't see how that's even possible, but...anyone have any ideas? Also did you ever get the "most played" and top 10 sorted?

[gmarik]

Is it ok one 2.3.0 too?

[Crazy Pete]

I'm running 2.3.0 and it works fine for me.

[Koutaru]

04-23-03 at 07:14 AM Lethal said this in Post #120 (https://vborg.vbsupport.ru/showthread.php?postid=385888#post385888)
Well I think I got the Top 10 working the way its supposed to. In jukebox.php replace all occurances of:

$mostplayed=$DB_site->query_first("SELECT songsid,sname,surl,splay FROM jukebox ORDER BY splay desc LIMIT 1");


With:


$mostplayed=$DB_site->query_first('SELECT * FROM `jukebox` ORDER BY `splay` DESC LIMIT 0, 30');


Takes awhile to load the songs thou. Even on cable. Is that normal? Takes like 1-2 minutes. Will the songs be cached in ur browser after you play them a few times that way they will or should play right away?


I think you'd want to LIMIT 10, after all it is a top 10 right?

[-Sidekick-]

I must be blind, but where is the demo of this hack on those forums?

[trafix]

<a href="http://www.atmyparty.com/network/jukebox.php" target="_blank">http://www.atmyparty.com/network/jukebox.php</a>

[Ghetto]

looks great but could use link the files show different servers? I have a server with like 50 MP3's

[Intex]

Trafix - nice hack. Installed in 5 mins - works great. Need to play around with the format / colours a little for my site, but otherwise great !

/me clicks install.

[Dean C]

Trafix - i am finally going to install this hack on my forums but i want the ability for the songs to be played in lo-fi and hi-fi format. Is that possible? :)

- miSt

[Intex]

Trafix - The hack does work with the exception of displaying the most played and the top 10.

On the main page it shows 'The most played song is: xxx with xxx requests. On mine this is incorrect - it shows the song that has a lower number of requests. The top ten table also doesn't order them from most to least requests. I tried on of the alterations suggested here to fix it, but no joy.

Any ideas?

[WCW Fan]

Is this in beta testing still as it seems there are quite a few problems or is it just me I would love to have this hack just have a question can I have mp3's play on it I was confused on that part and or wav and midi's

[kevinnguyen]

how can u get mostplayed work properly?
im stuck on it
help please

[kevinnguyen]

how can u get mostplayed work properly?
im stuck on it
help please

[FlaHack]

For some reason when I am trying to run jukeboxquery.php, I keep getting error 404 page not found. After I get passed the log in, I than get to the page where you select YES for this question...This script will make the necessary database changes for the Jukebox Hack 1.0 hack.<br>
Do you want to continue?

Once I click yes it goes to page not found???

I have it uploaded to my forums/admin folder.

Thank You

[dstruct2k]

This damn thing doesn't know how to count. It's using old-school counting methods that Windows 98 or lower used. (2000+ includes "smart filename counting" for numbers.)

Fix that and I'll be happy. :)

[SavgeDusk]

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

[Roxie]

Hey thanks, savgeDusk for that. It worked beautifully. :)

[dstruct2k]

To get it to count correctly, change the 'splay' VARCHAR to INT. -- That corrects both Top 10 & Most Played song. =3Yep, 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]

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...:o Thank you!

[bandersen]

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

Found it...working great.

[Nam]

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

[Dean C]

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

[THE REAL BLAZE]

Installed it, it's a great hack, awasome, im impressed, www.rapblock.com/forums
for ur visual.

[Nam]

You made me jealous, I guess I have to go back to vb2 now :(.

[THE REAL BLAZE]

hey, is there a way that when people visit the board, a songs plays automatically???? is there a template i can add or somethin g, cuz i want this song to play atuomatically.

[trafix]

Firstly I would like to thank everyone who has installed this hack, and enjoyed it :)

This is my most popular hack, and i plan to re-code it for vb3 as soon as i can :)

I will keep you updated!

[LukeC]

Thanks a lot trafix for this hack, it works great! The only problem I am having is with the integration of the store hack, but it runs great without it. For now, I just have the add songs to profile/directory right now as turned off. This is the error I am getting.

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

I see that NOTE: in your signature, but any suggestions would be great. Thanks again for this great hack :D

[trafix]

It seems that many recent instalations are getting these errors :(

storename,pointname,ban FROM storeadmin

These are added to the database when you install the store hack.

there is two possibilities for getting the errors here ...

1) You have not installed the store hack properly.

2) I am aware that Leasane has updated the store hack since i created the jukebox hack, and in doing so he may have changed the database structure for the store hack. I dont have the store hack anymore so i cant varify that.

Trafix

[LukeC]

Thanks trafix for your help, its much appreciated. Yeah I tried redoing it, but to no avail, got stuck on the same spot. But either way, its working well without the store hack part. Thanks!

[subu1]

Works perfectly, Thank you for your Hack, from Eselsreiter Community http://www.eselsreiter.netcheckershosting.de/board/images/smilies/kuss.gif

i love this Hack, works on 2.2.8 *click install*

greetz subu1

[trafix]

w00t!

At long last the vB Jukebox has now been ported to vB3 :)

It is FREE and contains both HTL and TXT install instructions.

Demo Here http://www.petnshow.com/network/vb_jukebox.php

Download Here http://www.everythingvb.com/showthread.php?p=614#post614

Support Thread Here http://www.everythingvb.com/showthread.php?p=614#post614

Go get it!

[DarkJediKiller]

Hmmm...Songs don't want to seem to play for me...I uploaded it as an mp3 which is how i got it, just doesnt wanna seem to work? Any ideas why?

Edit: I'm using vB 2.3.4

[trafix]

all i can suggest is to download the new vb3 version and follow the instructions to change the bgsound tag to the new one. follow instructions for editing current instalations .. remember to make sure the $vars are the same and DONT copr the conditionals wither .. your jukebox should work with the new OBJECT tag.

[Nam]

The download link you gave us require user name and password, is there a place (link) where I can register for an account there to download this new vb3 jukebox version? Also, I tried out the demo link you gave, and it seems the songs you have on your sites only play without any vocal singing. This new version can play all mp3 format songs right? Not MIDI, am I correct? Thanks for your quick reply

[dodgeman]

Im Kinda A Newbie Ive Installed vb arcade vbadvanced
to mention a few but i am stuck with this one
on the first step : (

//################################
//## FILES TO EDIT ##
//################################


**********************************
OPEN ADMIN/index.php
**********************************

------------------
Find (around line 247):
------------------

makenavselect("Announcements");

i cannot find that line anywhere on that file
someone plz help

[wreck]

ok i installed it, and everything is fine... but as soon as i linked to a song, i got this error


Database error in vBulletin 2.3.3:

Invalid SQL: SELECT userid,username,jbplays FROM user WHERE userid='2'
mysql error: Unknown column 'jbplays' in 'field list'

mysql error number: 1054

Date: Wednesday 11th of August 2004 03:09:19 PM
Script: http://www.urban-disturbance.com/board/board/jukebox.php?s=&action=main
Referer: http://www.urban-disturbance.com/board/index.php?s=

[wreck]

ok nevermind fixed it

[wreck]

actually.... i have installed it

but nobody can hear in anything that i am linking.... any ideas?

[LOONdog]

I too would like to know how to access that page. I really need a jukebox hack, can someone please help?

[trafix]

hmmm, ok ... i cant release the vb3 version here cos im not allowed to :(

Ummm .... i will put it up on my forums, but i dont know when i will have time to do it ... but i will let you know once ive done it

[LOONdog]

It would be awesome if you could do it soon. It wouldn't really take that long, would it? I'm really excited to install this. My members have been begging for some music.

[ricoche]

Hi there,

Actually the jukebox file as is works perfectly fine with vb3.03. I installed it a couple of days ago manually and it has been running very well. The problem basically is that the data is both missing in some places and a bit unorganized.

I don't have the HTL hack or the store hack installed, so I can't comment about those.

Basically I juse opened ALL of the files for both manual and HTL sections. I then did a comparison and manually entered the data in all areas. By combining the data files you will have all the data you need if installing manually.

The main sections are as follows:

1. Manually insert the database queries. In some cases I had to manually insert new rows and individually populate the tables. ( Compare both HTL and manual info as both are needed to complete the database installation. )

2. Manually insert the vboption setting data to the settings table from the xml file.

3. Manually add the phrases from the xml file.

4. Manually add the templates from the xml file.

5. Complete edits for the two php files and upload them.

After that, everything worked perfectly!

Note: You also need to open the HTL installation file in order to verify your database settings and all the steps necessary to install this hack completely. Again, everything you need is there! It works!

If you are not comfortable with manually editing vbulletin or your database, then proceed with caution. It's a great way to learn though. Otherwise, you'll have to wait for Trafix to release a cleaned up install version.

Good Luck!

[SaN-DeeP]

I saw the jukebox hack on few forums running vb 3.0.3 and open to public
Are those using this hack (released for 3.0x) or some other hack ??

[LOONdog]

I really hope you find some time to do this soon. I can't wait to install it. You think you might be able to find some time to do it within the next few days?

[trafix]

<a href="http://www.ozezyhosting.com/network/showthread.php?p=29#post29" target="_blank">http://www.ozezyhosting.com/network/...hp?p=29#post29</a>

[bluesteel]

Hmmmm........ I followed all of the steps in the install file, but have a problem somewhere along the line.
I followed the instructions as best as I could, and everything works except... you guessed it..... no sign of the jukebox!
When I click on a tune to play, the screen just refreshes itself. The actual vb_JUKEBOX template is not being fetched for some reason I think.
Any ideas anyone?
(using vB 3.0.3)

[Lionel]

I wonder if that could be categorized like they did for the arcade hack?

[LOONdog]

Hmmmm........ I followed all of the steps in the install file, but have a problem somewhere along the line.
I followed the instructions as best as I could, and everything works except... you guessed it..... no sign of the jukebox!
When I click on a tune to play, the screen just refreshes itself. The actual vb_JUKEBOX template is not being fetched for some reason I think.
Any ideas anyone?
(using vB 3.0.3)I'm having a similar problem. Everything seems to work. I can add songs, and I see the link for the jukeobx, but when I click it it appears in the same window and the song does not play. Any ideas?

[Prodigal]

I have a major problem. One of my admins tried to install this on my forum (3.0.5). Of course, it didn't work. I've tried to trace his steps and delete all files. When I try to edit usergroup permissions, I get a mysql error. In the init.php I found the error it brings up, but even when i delete the part it refers to, I still get an error. Help?


_____
Database error in vBulletin 3.0.5:

Invalid SQL: UPDATE usergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
title = 'Administrators',
description = '',
usertitle = 'Administrator',
opentag = '',
closetag = '',
passwordexpires = '180',
passwordhistory = '360',
attachlimit = '0',
avatarmaxwidth = '500',
avatarmaxheight = '500',
avatarmaxsize = '999999999',
profilepicmaxwidth = '100',
profilepicmaxheight = '100',
profilepicmaxsize = '65535',
pmquota = '50',
pmsendmax = '5',
uttstore_discount = '100%',
jbcanlisten = '1',
jbcanrate = '1',
jbcanupload = '1',
forumpermissions = '393215',
pmpermissions = '3',
calendarpermissions = '31',
wolpermissions = '31',
adminpermissions = '3',
genericpermissions = '4194239',
genericoptions = '31',
arcadepermissions = '0'
WHERE usergroupid=6
mysql error: Unknown column 'jbcanlisten' in 'field list'

mysql error number: 1054

Date: Tuesday 01st of February 2005 11:10:05 PM
Script: http://www.dyna-micz.com/forums/admincp/usergroup.php
Referer: http://www.dyna-micz.com/forums/admincp/usergroup.php?s=&do=edit&usergroupid=6
Username: Prodigal

______

Any help will be GREATLY appreciated.

[xbaby]

oh, how can I watch movie with vb_jukebox
Help me , please .....

[Mastar]

I've upgraded from 3.09 to 3.51 and I would like to know how to remove this hack from the vbulletin options?