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)

Dluzion 01-05-2007 03:48 PM

Hey allan, thanks for the hack
i tried it and it gave me an error on line 379 when i tried to upload it

syrus.xl 01-06-2007 06:05 PM

Quote:

Originally Posted by SportsZone (Post 1151182)
Any chance more file formats than MP3 can be used to work with this player?

*clicks install*

I will be releasing a similar modification that uses the same technology that YouTube and Google utilize. Also compatible with with a few other sites like blip.tv etc. However, this will probably be a commercial modification.

revmitchell 01-06-2007 06:34 PM

I installed it and it os on the tool bar. when you click it you get a pop up with this message:

The page cannot be found
The page you are looking for might have been removed, had its name changed, or is temporarily unavailable.

What did I do wrong?

syrus.xl 01-06-2007 06:40 PM

Quote:

Originally Posted by revmitchell (Post 1152105)
I installed it and it os on the tool bar. when you click it you get a pop up with this message:

The page cannot be found
The page you are looking for might have been removed, had its name changed, or is temporarily unavailable.


What did I do wrong?

There shouldn't be a page not found error on the popup, it uses a custom vbulletin template to display the player. I'm currently updating the product XML file for a few database errors, but none are related to the popup.

This was not an issue, do you have javascript enabled?

revmitchell 01-06-2007 07:10 PM

Apparently I dont. when I tried to install it in a mod box this is the error that appeared.

Warning!!! To view this vbMp3 Player please enable JavaScript and Flash!

But I am new to this how do you do that?

syrus.xl 01-06-2007 07:20 PM

Quote:

Originally Posted by revmitchell (Post 1152121)
apparently I dont. when I tried to install it in a mod box this is the error that appeared.

Warning!!! To view this vbMp3 Player please enable JavaScript and Flash!

But I am so knew to this that I know just enough to mes it up I do not know how to do that.

That message is built-in to the coding of the popup window to display the player, its a message so troubleshooting can be done easier. It will only show if any of the following conditions are not met:
  • The player swf file is not in the root of your forum.
  • The flashobject.js file is missing from you forum root directory.
  • You don't have the latest version of Flash installed in your browser.

If you do not have flash installed or up-to-date then you will need to visit Adobe to get the latest version for your browser, to display a flash object embedded in a page. You can get it from here.

HTH.

revmitchell 01-06-2007 07:28 PM

Quote:

The player swf file is not in the root of your forum.
The flashobject.js file is missing from you forum root directory.
Is there a difference between being in the root of your forum and missing from your root directory?

syrus.xl 01-06-2007 07:40 PM

Quote:

Originally Posted by revmitchell (Post 1152130)
Is there a difference between being in the root of your forum and missing from your root directory?

It depends on how you have your actual website setup.

A website root would be:
www.yourdomain.com

However, if you created your forums in a sub-directory like this:
www.youdomainl.com/forum

Then you would place the player swf and flashobject.js files in the forum folder. The installer assumes you have placed these files inside the forum directory in order to function with the playlist PHP file and the main popup code.

revmitchell 01-06-2007 07:47 PM

I understand that. I have it placed in www.website.com/vb

But do i need to place it in any sub folders of vb? or just in the main part of the vb folder?

And is there a yahoo tool bar associated with the download of this mod?

revmitchell 01-06-2007 07:59 PM

I deleted the other down load so as not to take up space on my hard drive and in downloading the file again my norton antivirus blocks the php. file. any thoughts. Lists it as high risk.

revmitchell 01-06-2007 08:26 PM

I got working thanks.

syrus.xl 01-06-2007 09:21 PM

Quote:

Originally Posted by revmitchell (Post 1152145)
I understand that. I have it placed in www.website.com/vb

But do i need to place it in any sub folders of vb? or just in the main part of the vb folder?

And is there a yahoo tool bar associated with the download of this mod?

No, this mod does not install the Yahoo Toolbar - that is part of the Flash Player Installer on Adobe's website. It should be 'unticked' before you preceed to install the latest Flash Player in to your browser.

revmitchell 01-06-2007 09:43 PM

I got it visable. I loaded mp3's to it but fail to hear any music. The play button is flashing but it appears there is a progress bar? at the top and it isnt moving forward. What else might I be doing wrong?

sorry to be such a pest.

syrus.xl 01-06-2007 09:58 PM

Quote:

Originally Posted by revmitchell (Post 1152210)
I got it visable. I loaded mp3's to it but fail to hear any music. The play button is flashing but it appears there is a progress bar? at the top and it isnt moving forward. What else might I be doing wrong?

sorry to be such a pest.

Reasons for songs not loading could be any of the following:

If the mp3 track name contains any abnormal characters, e.g =+.(/ etc. or if the tracks have spaces like this example:

I believe in miracles.mp3 <-- this title would not be read incorrectly by the player. You would need to change it to this.

i_believe_in_miracles.mp3 <-- note no spaces in the title. Underscores and the minus signs are acceptable.

Flash can be funny when reading external file names. I tend to keep all my files without any capital letters in file names, this avoids problems.

revmitchell 01-06-2007 10:05 PM

what should the buffer be set on?

syrus.xl 01-06-2007 10:43 PM

Quote:

Originally Posted by revmitchell (Post 1152227)
what should the buffer be set on?

The player has a default buffer value of 5 so the buffer value you set in vbulletin just overrides this setting.

The buffer is measured in seconds... so it can buffer upto 10 seconds of data before playing, in most cases it will work with a value of 0 - 2 max - depends on server and network speeds.

You need to enable Streaming for the buffer value to work.

revmitchell 01-06-2007 10:46 PM

I want to thank you for your timely replies and your patience. God Bless.

syrus.xl 01-06-2007 10:50 PM

Quote:

Originally Posted by revmitchell (Post 1152244)
I want to thank you for your timely replies and your patience. God Bless.

No problem!:) It's what support is for! Eventhough I've been very busy lately with other projects.

revmitchell 01-06-2007 11:08 PM

Could my problem be my hosting account? I host the mp3's at wikiupload and they give me a big long code rather than just a url.

example:

http://www.wikiupload.com/get_rss.ph...ag2_files_numb

syrus.xl 01-06-2007 11:17 PM

Quote:

Originally Posted by revmitchell (Post 1152262)
Could my problem be my hosting account? I host the mp3's at wikiupload and they give me a big long code rather than just a url.

example:

http://www.wikiupload.com/get_rss.ph...ag2_files_numb

That is a rss output url - and far too long for the player to process. Any url should be processed with the .mp3 extension at the end, nothing else as this would then be read by flash as a flashvar which the player will not recognize.

revmitchell 01-06-2007 11:46 PM

Hence my problem. Gotchya!

admin0 01-09-2007 03:01 AM

what is the difference between this and the other one with vbMp3 and xeon ?
are both the same products? then why 2 plugins ?

syrus.xl 01-09-2007 10:37 AM

Quote:

Originally Posted by admin0 (Post 1154240)
what is the difference between this and the other one with vbMp3 and xeon ?
are both the same products? then why 2 plugins ?

There's a big difference between the two versions. The first one is XML driven and only uses one IF conditional to hide the launch link. Hence, it uses no SQL queries.

This version is fully integrated into vBulletin - and managed via the ACP -> Mp3 Player Management. It is not XML driven, and all track data is held in the database. For other features read the first post.

Dluzion 01-09-2007 04:02 PM

syrus im still getting this can you please help???

Quote:

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 : Friday, January 5th 2007 @ 11:25:11 AM
Script : http://blazextreme.com/forum/mp3play...mp3playerpopup
Referrer : http://blazextreme.com/forum/
Username : Dluzion
Classname : vb_database

trd167 01-10-2007 10:25 PM

so is the plugin all working now or still a no go?

SuperDank 01-11-2007 02:28 AM

nice....

im almost there.. can someone please tell me how to get it to play??? i have three songs... seems to be reading them.. 50cent is 5mb.. the other ar 50mb (mp3s)..

thanks!!!!!
http://420kill.com/forums

Click on 420TUNES

JVCode 01-11-2007 08:27 AM

Just installed, but getting this error when trying to open the player;

Unknown column 'approvemp3' in 'where clause'

Allan 01-11-2007 08:42 AM

Read all posts to thread please ^^

https://vborg.vbsupport.ru/showpost....&postcount=422

JVCode 01-11-2007 08:55 AM

Quote:

Originally Posted by Allan (Post 1156096)

Ah excellent, works like a charm now, thankyou! :D

TheBlackPoet 01-11-2007 09:08 AM

installing when i get home>>> damn come on 8a!!!

SuperDank 01-11-2007 05:01 PM

W00T!!!

works...

thanks guys!! you guys rock!

Dluzion 01-12-2007 03:47 AM

Nevermind figured it out

Vampyre 01-20-2007 06:27 PM

Many thanks, syrus.xl, for releasing this as a free version for vB licensees. :D

Quote:

Originally Posted by Allan (Post 1145732)
In xml file, find:
Code:

<codes>
        <code version="beta 1">
            <installcode><![CDATA[$db->reporterror = 0;
echo "Adding Tables<br /><br />";
$vbulletin->db->query_write("CREATE TABLE ". TABLE_PREFIX ."mp3playlist (
`id` int(11) NOT NULL auto_increment,
  `url_product` varchar(255) NOT NULL default '',
  `url_product_stream` varchar(100) NOT NULL default '',
  `url_product_buffer` int(1) NOT NULL default '0',
  `mp3name` varchar(155) NOT NULL default '',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM");
echo "<font size=\"1\">Added Table - mp3playlist1</font><br />";

$vbulletin->db->query_write("CREATE TABLE ". TABLE_PREFIX ."mp3playlist1 (
`id` int(11) NOT NULL auto_increment,
  `url_product` varchar(255) NOT NULL default '',
  `url_product_stream` varchar(100) NOT NULL default '',
  `url_product_buffer` int(1) NOT NULL default '0',
  `mp3name` varchar(155) NOT NULL default '',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM");
echo "<font size=\"1\">Added Table - mp3playlist2</font><br />";

$vbulletin->db->query_write("CREATE TABLE ". TABLE_PREFIX ."mp3playlist2 (
`id` int(11) NOT NULL auto_increment,
  `url_product` varchar(255) NOT NULL default '',
  `url_product_stream` varchar(100) NOT NULL default '',
  `url_product_buffer` int(1) NOT NULL default '0',
  `mp3name` varchar(155) NOT NULL default '',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM");
echo "<font size=\"1\">Added Table - mp3playlist3</font><br />";

$vbulletin->db->query_write("CREATE TABLE ". TABLE_PREFIX ."mp3playlist3 (
`id` int(11) NOT NULL auto_increment,
  `url_product` varchar(255) NOT NULL default '',
  `url_product_stream` varchar(100) NOT NULL default '',
  `url_product_buffer` int(1) NOT NULL default '0',
  `mp3name` varchar(155) NOT NULL default '',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM");
echo "<font size=\"1\">Added Table - mp3playlist4</font><br />";

$vbulletin->db->query_write("CREATE TABLE ". TABLE_PREFIX ."mp3playlist4 (
`id` int(11) NOT NULL auto_increment,
  `url_product` varchar(255) NOT NULL default '',
  `url_product_stream` varchar(100) NOT NULL default '',
  `url_product_buffer` int(1) NOT NULL default '0',
  `mp3name` varchar(155) NOT NULL default '',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM");
echo "<font size=\"1\">Added Table - mp3playlist5</font><br />";

$vbulletin->db->query_write("CREATE TABLE IF NOT EXISTS " . TABLE_PREFIX . "mp3player_settings (
    active int(11) NOT NULL default '0',
  pmadminid int(11) NOT NULL default '0',
  pmactive int(11) NOT NULL default '0',
  pmadminname varchar(150) NOT NULL default '',
  pmadmintitle varchar(150) NOT NULL default '',
  pmadmintext varchar(255) NOT NULL default '',
  approvemp3 int(11) NOT NULL default '0')");
echo "<font size=\"1\">Added Table - mp3player_settings</font><br />";

$vbulletin->db->query_write("INSERT INTO " . TABLE_PREFIX . "mp3player_settings VALUES (1, 1, 1, 'ADMIN NAME', 'New MP3 Added', 'This is a test to see if the pm system works', 0)");
echo "<font size=\"1\">Settings Added</font><br />";

$vbulletin->db->query_write("ALTER TABLE " . TABLE_PREFIX . "usergroup ADD COLUMN mp3playergrouppermissions INT(10) UNSIGNED NOT NULL DEFAULT '0'");
echo "<font size=\"1\">Added usergroup - Permissions</font><br />";

// Rebuild Bitfields
require_once(DIR . '/includes/class_bitfield_builder.php');
vB_Bitfield_Builder::save($db);
build_forum_permissions();
echo "<font size=\"1\">vB Bitfield Builder Done</font><br />";]]></installcode>
            <uninstallcode><![CDATA[$db->query("DELETE FROM " . TABLE_PREFIX . "template WHERE title LIKE 'mp3player_%'");
$db->query("DELETE FROM " . TABLE_PREFIX . "template WHERE title='mp3player'");
$db->query("DELETE FROM " . TABLE_PREFIX . "phrase WHERE varname LIKE 'mp3player_%'");

$db->query("
        DROP TABLE IF EXISTS " . TABLE_PREFIX . "mp3playlist
    ");
   
$db->query("
        DROP TABLE IF EXISTS " . TABLE_PREFIX . "mp3playlist1
    ");
   
$db->query("
        DROP TABLE IF EXISTS " . TABLE_PREFIX . "mp3playlist2
    ");
   
$db->query("
        DROP TABLE IF EXISTS " . TABLE_PREFIX . "mp3playlist3
    ");
   
$db->query("
        DROP TABLE IF EXISTS " . TABLE_PREFIX . "mp3playlist4
    ");]]></uninstallcode>
        </code>
    </codes>

Replace with:
Code:

<codes>
        <code version="beta 1">
            <installcode><![CDATA[$db->reporterror = 0;
echo "Adding Tables<br /><br />";
$vbulletin->db->query_write("CREATE TABLE ". TABLE_PREFIX ."mp3playlist (
`id` int(11) NOT NULL auto_increment,
  `url_product` varchar(255) NOT NULL default '',
  `url_product_stream` varchar(100) NOT NULL default '',
  `url_product_buffer` int(1) NOT NULL default '0',
  `mp3name` varchar(155) NOT NULL default '',
`approvemp3` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM");
echo "<font size=\"1\">Added Table - mp3playlist1</font><br />";

$vbulletin->db->query_write("CREATE TABLE ". TABLE_PREFIX ."mp3playlist1 (
`id` int(11) NOT NULL auto_increment,
  `url_product` varchar(255) NOT NULL default '',
  `url_product_stream` varchar(100) NOT NULL default '',
  `url_product_buffer` int(1) NOT NULL default '0',
  `mp3name` varchar(155) NOT NULL default '',
`approvemp3` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM");
echo "<font size=\"1\">Added Table - mp3playlist2</font><br />";

$vbulletin->db->query_write("CREATE TABLE ". TABLE_PREFIX ."mp3playlist2 (
`id` int(11) NOT NULL auto_increment,
  `url_product` varchar(255) NOT NULL default '',
  `url_product_stream` varchar(100) NOT NULL default '',
  `url_product_buffer` int(1) NOT NULL default '0',
  `mp3name` varchar(155) NOT NULL default '',
`approvemp3` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM");
echo "<font size=\"1\">Added Table - mp3playlist3</font><br />";

$vbulletin->db->query_write("CREATE TABLE ". TABLE_PREFIX ."mp3playlist3 (
`id` int(11) NOT NULL auto_increment,
  `url_product` varchar(255) NOT NULL default '',
  `url_product_stream` varchar(100) NOT NULL default '',
  `url_product_buffer` int(1) NOT NULL default '0',
  `mp3name` varchar(155) NOT NULL default '',
`approvemp3` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM");
echo "<font size=\"1\">Added Table - mp3playlist4</font><br />";

$vbulletin->db->query_write("CREATE TABLE ". TABLE_PREFIX ."mp3playlist4 (
`id` int(11) NOT NULL auto_increment,
  `url_product` varchar(255) NOT NULL default '',
  `url_product_stream` varchar(100) NOT NULL default '',
  `url_product_buffer` int(1) NOT NULL default '0',
  `mp3name` varchar(155) NOT NULL default '',
`approvemp3` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM");
echo "<font size=\"1\">Added Table - mp3playlist5</font><br />";

$vbulletin->db->query_write("CREATE TABLE IF NOT EXISTS " . TABLE_PREFIX . "mp3player_settings (
    active int(11) NOT NULL default '0',
  pmadminid int(11) NOT NULL default '0',
  pmactive int(11) NOT NULL default '0',
  pmadminname varchar(150) NOT NULL default '',
  pmadmintitle varchar(150) NOT NULL default '',
  pmadmintext varchar(255) NOT NULL default '',
  approvemp3 int(11) NOT NULL default '0')");
echo "<font size=\"1\">Added Table - mp3player_settings</font><br />";

$vbulletin->db->query_write("INSERT INTO " . TABLE_PREFIX . "mp3player_settings VALUES (1, 1, 1, 'ADMIN NAME', 'New MP3 Added', 'This is a test to see if the pm system works', 0)");
echo "<font size=\"1\">Settings Added</font><br />";

$vbulletin->db->query_write("ALTER TABLE " . TABLE_PREFIX . "usergroup ADD COLUMN mp3playergrouppermissions INT(10) UNSIGNED NOT NULL DEFAULT '0'");
echo "<font size=\"1\">Added usergroup - Permissions</font><br />";

// Rebuild Bitfields
require_once(DIR . '/includes/class_bitfield_builder.php');
vB_Bitfield_Builder::save($db);
build_forum_permissions();
echo "<font size=\"1\">vB Bitfield Builder Done</font><br />";]]></installcode>
            <uninstallcode><![CDATA[$db->query("DELETE FROM " . TABLE_PREFIX . "template WHERE title LIKE 'mp3player_%'");
$db->query("DELETE FROM " . TABLE_PREFIX . "template WHERE title='mp3player'");
$db->query("DELETE FROM " . TABLE_PREFIX . "phrase WHERE varname LIKE 'mp3player_%'");

$db->query("
        DROP TABLE IF EXISTS " . TABLE_PREFIX . "mp3playlist
    ");
   
$db->query("
        DROP TABLE IF EXISTS " . TABLE_PREFIX . "mp3playlist1
    ");
   
$db->query("
        DROP TABLE IF EXISTS " . TABLE_PREFIX . "mp3playlist2
    ");
   
$db->query("
        DROP TABLE IF EXISTS " . TABLE_PREFIX . "mp3playlist3
    ");
   
$db->query("
        DROP TABLE IF EXISTS " . TABLE_PREFIX . "mp3playlist4
    ");]]></uninstallcode>
        </code>
    </codes>

PS: Thanks Sofia ^^


Thanks for the update, Allan.:up:
It's installed like a charm. :p

Zowners 01-21-2007 06:49 PM

i installed it, saved the setting but when i try to add a file i get this:


PHP Code:

Database error in vBulletin 3.6.0:

Invalid SQL:
insert into mp3playlist values(

    
'','http://www.paramorefans.com/mp3sVbulletin/All We Know(9.24.06).mp3','true','1','test',''

    
);

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


Vampyre 01-21-2007 09:27 PM

In the MP3 URL, try replacing blank spaces with %20, and see if it makes any difference.

Zowners 01-21-2007 10:52 PM

thanks for replying
but i got the same message again, i even tried unninstallinf the plug in and installed it back

PHP Code:

Database error in vBulletin 3.6.0:

Invalid SQL:
insert into mp3playlist values(

    
'','http://www.paramorefans.com/mp3sVbulletin/All%20We%20Know(9.24.06).mp3','true','0','test',''

    
);

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


afmarko99 01-22-2007 02:33 PM

I am getting the same problem.

Searching everywhere for a fix.

GSPFAN 01-24-2007 02:41 AM

Quote:

Originally Posted by Allan (Post 1156096)


I have tried this several times but i still get the error


MySQL Error : Unknown column 'approvemp3' in 'where clause'

dholt 01-24-2007 01:24 PM

why has the download not been updated with this fix.
https://vborg.vbsupport.ru/showpost....&postcount=422

Just a Question

Xbizcafe 01-24-2007 06:43 PM

When I unzip my antivirus tell me problem with :

mp3player_admin.php

it's tell me this virus : http://www.symantec.com/security_res...101518-4323-99


All times are GMT. The time now is 04:50 AM.

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