vb.org Archive
Page 11 of 27 « First 910 11 121321 Last »
Show 40 post(s) from this thread on one page

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)

beishe8 12-14-2006 06:49 PM
Quote:
Originally Posted by JRite (Post 1138240)
what is my ftp?
File Transfer Protocol

A program used to upload/download files to/from your webspace.

"FileZilla" is one of them.

Cheers, beishe8

stinger2 12-14-2006 07:55 PM
Code:
Database error in vBulletin 3.6.4:

Invalid SQL:

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

MySQL Error  : Unknown column 'approvemp3' in 'where clause'
Error Number : 1054
Date        : Thursday, December 14th 2006 @ 10:53:49 PM
Script      : http://localhost/forums/mp3playerindex.php?do=viewmp3playerpopup
Referrer    :
IP Address  : 127.0.0.1
Username    : stinger2
Classname    : vb_database


getting the same error as the guys before.....any fix yet?

nice hack though.....thx

Kidswap 12-14-2006 08:05 PM
I'm getting the same error. Subscribing to see the solution.

seabiscuit 12-14-2006 08:38 PM
Quote:
Originally Posted by micheal332001 (Post 1138556)
I will have alook at this for you and get back to you here.
thank you so much Michael. I will be waiting.

seabiscuit 12-15-2006 01:06 AM
i happened to have the previous version, so i tried that again, and it worked like a charm.

R-n-R 12-15-2006 02:41 AM
For what it is worth I am getting this error as well.

Quote:
Originally Posted by stinger2 (Post 1138694)
Code:
Database error in vBulletin 3.6.4:

Invalid SQL:

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

MySQL Error  : Unknown column 'approvemp3' in 'where clause'
Error Number : 1054
Date        : Thursday, December 14th 2006 @ 10:53:49 PM
Script      : http://localhost/forums/mp3playerindex.php?do=viewmp3playerpopup
Referrer    :
IP Address  : 127.0.0.1
Username    : stinger2
Classname    : vb_database


getting the same error as the guys before.....any fix yet?

nice hack though.....thx

96TSi 12-15-2006 08:17 PM
I have the same error also. Installed as instructed. all the files are there

trd167 12-16-2006 02:34 AM
is the XML file being worked on?

DAdiguzeL 12-16-2006 11:34 AM
I have the same problem :(

Cireus 12-16-2006 03:28 PM
Absolutely awesome product! Running it on my 3.6.4 board w/o any trouble installing! Thanks!

teyron 12-16-2006 04:26 PM
why does norton pick this up as a virus?

syrus.xl 12-17-2006 03:58 AM
Quote:
Originally Posted by teyron (Post 1139806)
why does norton pick this up as a virus?
Norton AV is well known for 'false-positives'. I have had this package scanned by numerous other antivirus programs, and it always comes back virus free. It doesn't take much to trigger Norton (as little as a few characters).

Product XML:
The product XML is being worked on - I'm just running a few more tests before releasing it. An error sneaked in if the installation was new, upgrades seemed to work fine.

Sorry about the delay, but I am quite busy this time of year.

basilrath 12-17-2006 05:44 PM
any ideas ive uploaded the folder contents to the forum root ie .........

admincp contents into admincp

includes contents into the includes folder

the other 3 php to root

and the swf to root too and get this any ideas

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'

Diana Notacat 12-19-2006 08:55 PM
Looking forward to seeing the fix for that new install program. My members will reall like this addition!

soletrader 12-22-2006 03:28 AM
So I guess this hack is not working for all? Looking forward to it :)

basilrath 12-22-2006 11:29 AM
The earlier version is good anyway ive actually got it in the navbar etc aswell as in the postbit ...................5 playlists etc

screenshot..........

http://www.recommenditall.com/thebig/forums/lgtbfs.gif

Allan 12-25-2006 06:09 AM
Thanks for this hack :)

Edit: Don't work with vB3.6.4 :(

Code:
Database error in vBulletin 3.6.4:

Invalid SQL:

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

MySQL Error  : Champ 'approvemp3' inconnu dans where clause
Error Number : 1054
Date        : Monday, December 25th 2006 @ 09:08:45 AM
Script      : http://www.vbulletin-ressources.com/forum/mp3playerindex.php?do=viewmp3playerpopup
Referrer    : http://www.vbulletin-ressources.com/forum/index.php
IP Address  : 195.36.194.90
Username    : Allan
Classname    : vb_database

richTV 12-25-2006 10:14 AM
been using it on my forum [3.6.4] for a few days now with 30 tracks of those ol' standards Xmas music.

many thanks for designing this gem!

i was wondering, however, if there r any laws i should be worried about whilst my users play these songs at my forum? ie, copyright issues?

TIA :)

basilrath 12-25-2006 12:59 PM
as long as your not a commercial site etc

not selling

richTV 12-25-2006 08:37 PM
our site is 100% fed on donations by the members to which ALL of those euros ? goes to the server fees and any extra money for the month is stored until the following month's server bill.

tnx for the clarification. :)

winpro19 12-27-2006 10:26 AM
same error for me mate
SELECT COUNT(*) AS id
FROM mp3playlist AS mp3playlist WHERE approvemp3=1;

Allan 12-27-2006 10:32 AM
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 ^^

winpro19 12-28-2006 02:45 AM
thanks it worked!

blogtorank 12-28-2006 03:18 AM
Edit, will try the above as I didn't want to read 29 pages to see of this ERR.

Will update this post if that fixes it.

++++++++++++++++++++++++++++++++++++++++++++++++++ ++++++++++++++

Edit: After doing what Allan above suggested:

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
Here's my MySQL version:

5.0.27

++++++++++++++++++++++++++++++++++++++++++++++++++ ++++++++

When in doubt, drop the damned product and reinstall fresh ;), Allan you are a genius man, Thanks!!!!

loonytune15 12-28-2006 01:32 PM
Great hack, installed though i had to do the fix a couple of posts above..

TTG 12-28-2006 11:04 PM
Thanks for the fix Alan .. un-installed -- made the xml edit and re-installed and now working well .. :)

StuntFactoryX 12-29-2006 10:18 PM
im trying to map this out and wanted to get some input... i was thinking of importing my songs from the download folder from the downloads2 hack... that way users can listen and download if they like and users can upload there and i can import... how do u think that will work and if other file extensions in there like zip or jpgs?

imk 12-29-2006 10:33 PM
Database error in vBulletin 3.6.4:

i did the fix but im getin

XML Error: mismatched tag at Line 378

Khawar 12-31-2006 04:52 AM
Does it work as a pop up or no?
all i want to ask is that while listening to the songs, r my users gone be able to browse the forums aswell or no????

TTG 12-31-2006 08:39 AM
Quote:
Originally Posted by Khawar (Post 1147894)
Does it work as a pop up or no?
all i want to ask is that while listening to the songs, r my users gone be able to browse the forums aswell or no????
It does in Firefox and IE

loonytune15 01-02-2007 01:13 AM
Quote:
Originally Posted by Khawar (Post 1147894)
Does it work as a pop up or no?
all i want to ask is that while listening to the songs, r my users gone be able to browse the forums aswell or no????
it runs in a seperate window :)

imk 01-02-2007 07:49 PM
Quote:
Originally Posted by imk (Post 1147222)
Database error in vBulletin 3.6.4:

i did the fix but im getin

XML Error: mismatched tag at Line 378
???????????

Greek76 01-02-2007 08:29 PM
For some reason none of my songs play on the player. I did no changes and all the urls are correct? Any ideas? All the buttons work except for the play button you cant press it.

MythoLogy 01-03-2007 03:51 AM
I had the same error that many has had lately:

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
And thanks to Allan's fix - I uninstalled the mod, dropped the table and made the changes - installed and now I too can now enjoy this mod. Nice Job Allan for the fix and syrus for the mod.

mojahudba 01-03-2007 08:54 AM
i getting this error :

Code:
Database error in vBulletin 3.6.4:

Invalid SQL:

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

MySQL Error  : Unknown column 'approvemp3' in 'where clause'
Error Number : 1054
Date        : Wednesday, January 3rd 2007 @ 10:53:08 AM
Script      : http://www.mojahudba.com/forums/mp3playerindex.php?do=viewmp3playerpopup
Referrer    :
IP Address  : xxxxxxxxx
Username    : Jeinko
Classname    : vb_database
and allan change didnt help :S

stinger2 01-03-2007 03:03 PM
thx alan....your fix has corrected it..

revmitchell 01-04-2007 11:30 AM
When i tried to download the player my norton antivirus denied the file. Said it had a virus in it.

SportsZone 01-05-2007 05:41 AM
Any chance more file formats than MP3 can be used to work with this player?

*clicks install*

Dluzion 01-05-2007 03:27 PM
im getting this:
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

Allan 01-05-2007 03:45 PM
Quote:
Originally Posted by Dluzion (Post 1151388)
im getting this:
Check this ^^

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


All times are GMT. The time now is 05:55 PM.
Page 11 of 27 « First 910 11 121321 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.01892 seconds
  • Memory Usage 1,860KB
  • 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
  • (6)bbcode_code_printable
  • (12)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
  • (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