vb.org Archive
Page 6 of 18 « First 45 6 7816 Last »
Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 2.x Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=4)
-   -   With optional store hack intergration (https://vborg.vbsupport.ru/showthread.php?t=50873)

DPoole 03-29-2003 05:17 AM
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 03-29-2003 05:36 AM
Quote:
Today at 05:17 PM DPoole said this in Post #51
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

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

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

NuclioN 03-29-2003 11:51 AM
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 03-29-2003 02:57 PM
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 03-29-2003 03:09 PM
Quote:
Today at 02:57 AM DPoole said this in Post #54
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
PHP Code:
<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 03-29-2003 03:17 PM
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 03-29-2003 03:29 PM
Quote:
Yesterday at 08:50 PM DPoole said this in Post #39
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.

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 03-29-2003 03:32 PM
in the jukebox.php the following appears 4 times.....make sure that this is correct

PHP Code:
$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 03-29-2003 03:40 PM
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 03-29-2003 03:44 PM
I persume that all is working now!

Yep I will update the zip soon :)

glad you like it.


All times are GMT. The time now is 03:55 PM.
Page 6 of 18 « First 45 6 7816 Last »
Show 40 post(s) from this thread on one page

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01305 seconds
  • Memory Usage 1,755KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (4)bbcode_php_printable
  • (3)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 
Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 
Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete