vb.org Archive
Page 2 of 5 1 2 34 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)

trafix 03-28-2003 10:55 PM
Quote:
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 03-28-2003 11:04 PM
Quote:
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 :cool:

DPoole 03-29-2003 12:06 AM
$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 03-29-2003 12:16 AM
sorry just got out of bed when i posted that :)

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

Kurayami 03-29-2003 12:40 AM
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 03-29-2003 12:55 AM
$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 03-29-2003 01:04 AM
Quote:
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 03-29-2003 02:57 AM
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 03-29-2003 03:01 AM
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 03-29-2003 04:41 AM
Quote:
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

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.

DPoole 03-29-2003 03:47 PM
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 03-29-2003 03:52 PM
great news!

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

i will update zip to v1.2 soon

DPoole 03-29-2003 04:30 PM
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 03-29-2003 04:47 PM
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 03-29-2003 04:53 PM
Quote:
Today at 05:40 PM DPoole said this in Post #59
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 03-29-2003 05:19 PM
wow Dpoole! :D It would be great if the output can be implemented or embeded in the jukebox.

Marzas 03-30-2003 03:50 AM
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 03-30-2003 03:53 AM
Yep you will get this error of you have no songs loaded in the jukebox...you can do this from your admin panel

Marzas 03-30-2003 04:00 AM
cool, talk about quick support, i put it for 1 sec, refreshed and your here, thanks m8

Marzas 03-30-2003 04:01 AM
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 03-30-2003 04:12 AM
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 03-30-2003 04:15 AM
Quote:
Today at 05:53 AM trafix said this in Post #68
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 03-30-2003 06:14 AM
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 03-30-2003 06:24 AM
you are getting a blank screen on your store or jukebox?????????

Marzas 03-30-2003 06:26 AM
jukebox!, store is perfect.

Marzas 03-30-2003 07:10 AM
any idea?

trafix 03-30-2003 07:32 AM
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 03-30-2003 08:08 AM
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 03-30-2003 08:20 AM
if you dont mind...i would like to sign up to check it out

trafix 03-30-2003 08:56 AM
Quote:
Today at 08:08 PM ricoche said this in Post #78
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.


All times are GMT. The time now is 05:02 PM.
Page 2 of 5 1 2 34 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.01547 seconds
  • Memory Usage 1,857KB
  • 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
  • (9)bbcode_php_printable
  • (10)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (3)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (40)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