vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.6 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=194)
-   -   Major Additions - The XEON Mp3 Player for vBulletin 3.6.X Integrated (https://vborg.vbsupport.ru/showthread.php?t=129641)

Yvgeniy 02-04-2007 04:11 PM

Alright, I've got my first error so far. Looks like it's related to apostrophes in the names of songs:

Database error in vBulletin 3.6.4:

Invalid SQL:
update vB_mp3playlist set

id='10',

url_product='http://www.artdecade.us/AintTalkinboutLove.mp3',

url_product_stream='true',

url_product_buffer='2',

mp3name='Van Halen - Ain't Talkin' 'bout Love',

approvemp3='1'

where id='10';

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 't Talkin' 'bout Love',

approvemp3='1'

where id='10'' at line 11
Error Number : 1064
Date : Sunday, February 4th 2007 @ 10:01:32 AM
Script : http://www.sakstudios.net/forums/adm...edit_playlist1
Referrer : http://www.sakstudios.net/forums/adm...laylist1&id=10


Some other things that I'd like to note that could use improvement are:

- Ability to send mp3 notification PM to multiple users rather than just one.
- Ability to allow mods to approve mp3's rather than just admins (I haven't tried it, but I'm guessing only mods are able to approve mp3's so far).
- Perhaps ability to choose to use a different database for handling playing and play list information, in which case it would also be possible to increase the song limit and have no tax on the main forum database.

So far that's all I can think of at the moment.

trd167 02-04-2007 11:42 PM

I finally unstalled this mod, it never worked. :(

Distance 02-05-2007 07:24 AM

Product checking doesn't work for this?

I think you forgot to enter the product id

Sofia 02-05-2007 07:08 PM

Quote:

Originally Posted by Yvgeniy (Post 1174515)
Alright, I've got my first error so far. Looks like it's related to apostrophes in the names of songs:

Database error in vBulletin 3.6.4:

Invalid SQL:
update vB_mp3playlist set

id='10',

url_product='http://www.artdecade.us/AintTalkinboutLove.mp3',

url_product_stream='true',

url_product_buffer='2',

mp3name='Van Halen - Ain't Talkin' 'bout Love',

approvemp3='1'

where id='10';

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 't Talkin' 'bout Love',

approvemp3='1'

where id='10'' at line 11
Error Number : 1064
Date : Sunday, February 4th 2007 @ 10:01:32 AM
Script : http://www.sakstudios.net/forums/adm...edit_playlist1
Referrer : http://www.sakstudios.net/forums/adm...laylist1&id=10


Some other things that I'd like to note that could use improvement are:

- Ability to send mp3 notification PM to multiple users rather than just one.
- Ability to allow mods to approve mp3's rather than just admins (I haven't tried it, but I'm guessing only mods are able to approve mp3's so far).
- Perhaps ability to choose to use a different database for handling playing and play list information, in which case it would also be possible to increase the song limit and have no tax on the main forum database.

So far that's all I can think of at the moment.



For vb 3.6.4

Find in the product xml :

PHP Code:

`mp3namevarchar(155NOT NULL default ''

and add below :

PHP Code:

`approvemp3int(11NOT NULL default '0'


for tables : mp3playlist1, mp3playlist2, mp3playlist3, mp3playlist4 and mp3playersettings

Then you must to disable the product, and reinstall it.

Allan 02-05-2007 07:26 PM

But why this hack doen't upgrade with modifications to Sofia ??

hotmasala4u 02-05-2007 07:27 PM

<td class="vbmenu_control"><a href="calendar.php$session[sessionurl_q]">$vbphrase[calendar]</a></td>

cant find this template

$vbphrase[calendar]

not even this i am using blackice

Yvgeniy 02-05-2007 08:55 PM

Quote:

Originally Posted by hotmasala4u (Post 1175426)
<td class="vbmenu_control"><a href="calendar.php$session[sessionurl_q]">$vbphrase[calendar]</a></td>

cant find this template

$vbphrase[calendar]

not even this i am using blackice

That's because blackice uses image buttons instead of the regular navbar, so you have to actually look in the header to find that, I believe. Personally, I got rid of buttons and just use the standard system. That way I don't have to make a new button each time I want to add something (example: www.sakstudios.net/forums). Let me know if you want to do the same and I'll give you the code.

Quote:

Originally Posted by Sosos145 (Post 1175408)
For vb 3.6.4

Find in the product xml :

PHP Code:

`mp3namevarchar(155NOT NULL default ''

and add below :

PHP Code:

`approvemp3int(11NOT NULL default '0'


for tables : mp3playlist1, mp3playlist2, mp3playlist3, mp3playlist4 and mp3playersettings

Then you must to disable the product, and reinstall it.

Actually, that was already there to begin with. So that's not the problem.

syrus.xl 02-05-2007 10:07 PM

Quote:

Originally Posted by Yvgeniy (Post 1174136)
Just thought I'd mention a few bugs or things that could use improvement. The PM Admin Text To User type box has a fairly small character limit, which limits the amount of stuff you can write. Pretty annoying if you ask me. The message after you add an mp3 says "The MP3 has been added to are database" or something along those lines. My point is that it's "are" instead of "our." That's all I noticed so far.

Most of the features you've mentioned have either been fixed or added. However, since this is the free version some of these features are limited or do not exist. A Pro version was designed with many new features, including new players and skins and dynamic wording, if required.

TeknoSounds 02-05-2007 11:34 PM

Hiyas, getting this error when attempting to add a file to playlist 1 thru admincp:

Code:

Database error in vBulletin 3.6.4:

Invalid SQL:
insert into vb_mp3playlist values(

        '','http://teknosounds.com/download/mixes/dj3/drizzle.mp3','true','10','DJ^3 - Drizzle - Breaks',''

        );

MySQL Error  : Column count doesn't match value count at row 1
Error Number : 1136

Downloaded the most recent version. Tried some fixes listed but didn't seem to do anything. Anyone have suggestions on fixing this error?

Thanks in advance!

swiss 02-06-2007 03:56 AM

installed and get the following

Database error in vBulletin 3.6.4:

Invalid SQL:

SELECT COUNT(*) AS id
FROM mp3playlist AS mp3playlist WHERE approvemp3=1;

MySQL Error : Unknown column 'approvemp3' in 'where clause'
Error Number : 1054
Date : Tuesday, February 6th 2007 @ 05:54:39 AM
Script : http://<URL REMOVED>//mp3playerindex.php?do=viewmp3playerpopup
Referrer :
IP Address : 70.112.241.193
Username : <REMOVED FOR THIS POST>
Classname : vb_database

any idea's please as followed the install to a T


All times are GMT. The time now is 01:59 PM.

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.01974 seconds
  • Memory Usage 1,762KB
  • 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
  • (1)bbcode_code_printable
  • (4)bbcode_php_printable
  • (4)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (4)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