vb.org Archive
Page 48 of 107 « First 384647 48 49505898 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)

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 11:02 PM.
Page 48 of 107 « First 384647 48 49505898 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.01623 seconds
  • Memory Usage 1,796KB
  • 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
  • (2)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (3)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