The Arcive of Official vBulletin Modifications Site.

vBRadio v1.0 · **Released**: 06-14-2005

Port of: https://vborg.vbsupport.ru/showthrea...threadid=72227

Pretty simply, enjoy

- Zero Tolerance

Eric · #**322** 08-15-2006, 08:58 AM

Quote:

Originally Posted by Shazz

The radio does not work on 3.6.0.

Quite a few changes in vB's database structure. Note, i've not tested this, but in 'install_vbradio.php' replace all of step 2 with:

PHP Code:


			
if ($_POST['do'] == "steptwo")
{
    $install_phrases = array(
        'radio_cat_added' => 'Radio Category Added',
        'radio_cat_edited' => 'Radio Category Edited',
        'radio_cat_deleted' => 'Radio Category Deleted',
        'radio_cat_ndeleted' => 'Radio Category Not Deleted',
        'radio_channel_added' => 'Radio Channel Added',
        'radio_channel_edited' => 'Radio Channel Edited',
        'radio_channel_deleted' => 'Radio Channel Deleted',
        'radio_channel_ndeleted' => 'Radio Channel Not Deleted'
    );

    foreach ($install_phrases AS $p_varname => $p_text)
    {
        $DB->query_write("
            INSERT INTO " . TABLE_PREFIX . "phrase VALUES (-1, '$p_varname', '$p_text', 'error' ,'vbulletin', '" . $db->escape_string($vbulletin->userinfo['username']) . "', " . TIMENOW . ", '1.0.0')
        ");
    }

    $DB->query_write("
        CREATE TABLE " . TABLE_PREFIX . "radio (
            rid int(11) NOT NULL auto_increment,
            r_iscat varchar(5) NOT NULL default 'no',
            r_name varchar(255) NOT NULL,
            r_location varchar(255) NOT NULL,
            r_forcat int(15) NOT NULL default '0',
            PRIMARY KEY (rid)
        )
    ");

    $DB->query_write("
        INSERT INTO " . TABLE_PREFIX . "radio (rid, r_iscat, r_name, r_location, r_forcat)
        VALUES (1, 'yes', 'Alternative Rock', '', 0), (12, 'no', 'KNAC', 'http://release.theplatform.com/content.select?pid=_Vx9pkxpFxxCRGWMQ2FKCqW70iuLi6Mn&UserName=knaclive', 1), (9, 'no', 'A.I.R. Radio', 'http://130.49.24.169:1015/listen.pls', 1), (7, 'no', 'Idobi', 'http://www.idobi.com/radio/iradio.rm', 1), (8, 'no', 'American Radio Network', 'http://www.myamericanradio.net/audio/heavymetalhigh/preload.asx', 1)
    ");
        
    print_form_header('', '');
    print_table_header("vBRadio 1.0 Installation");
    print_description_row("Database modifications complete. DELETE 'install_vbradio.php' AND 'vbradio.xml' FROM 'admincp' DIRECTORY NOW!");
}

TroyF2000 · #**323** 08-15-2006, 05:36 PM

I'm an idiot now, so forgive me but replacing some script in the noted php, will allow a person to potentially use the radio in version 3.6.0, right?

I get an error message inside a database error page, that looks similar to those above, too.

KevNJ · #**324** 08-17-2006, 02:40 AM

Error on line 111... Should read

Currently reads

PHP Code:

";

Should read

PHP Code:

");

Then I get this error.

PHP Code:


			
Database error in vBulletin 3.6.0:



Invalid SQL:



            INSERT INTO jelsoft_phrase VALUES (-1, 'radio_cat_added', 'Radio Category Added', 'error' ,'vbulletin', 'Kevin', , '1.0.0');



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

Error Number : 1136

Date         : Wednesday, August 16th 2006 @ 08:32:28 PM

Script       : http://www.jerseyparties.com/forums/admincp/install_vbradio.php?do=steptwo

Referrer     : http://www.jerseyparties.com/forums/admincp/install_vbradio.php?do=stepone

IP Address   : 

Username     : 

Classname    : vb_database

Quote:

Originally Posted by SecondV

Quite a few changes in vB's database structure. Note, i've not tested this, but in 'install_vbradio.php' replace all of step 2 with:

PHP Code:


			
if ($_POST['do'] == "steptwo")

{

    $install_phrases = array(

        'radio_cat_added' => 'Radio Category Added',

        'radio_cat_edited' => 'Radio Category Edited',

        'radio_cat_deleted' => 'Radio Category Deleted',

        'radio_cat_ndeleted' => 'Radio Category Not Deleted',

        'radio_channel_added' => 'Radio Channel Added',

        'radio_channel_edited' => 'Radio Channel Edited',

        'radio_channel_deleted' => 'Radio Channel Deleted',

        'radio_channel_ndeleted' => 'Radio Channel Not Deleted'

    );



    foreach ($install_phrases AS $p_varname => $p_text)

    {

        $DB->query_write("

            INSERT INTO " . TABLE_PREFIX . "phrase VALUES (-1, '$p_varname', '$p_text', 'error' ,'vbulletin', '" . $db->escape_string($vbulletin->userinfo['username']) . "', " . TIMENOW . ", '1.0.0')

        ");

    }



    $DB->query_write("

        CREATE TABLE " . TABLE_PREFIX . "radio (

            rid int(11) NOT NULL auto_increment,

            r_iscat varchar(5) NOT NULL default 'no',

            r_name varchar(255) NOT NULL,

            r_location varchar(255) NOT NULL,

            r_forcat int(15) NOT NULL default '0',

            PRIMARY KEY (rid)

        )

    ");



    $DB->query_write("

        INSERT INTO " . TABLE_PREFIX . "radio (rid, r_iscat, r_name, r_location, r_forcat)

        VALUES (1, 'yes', 'Alternative Rock', '', 0), (12, 'no', 'KNAC', 'http://release.theplatform.com/content.select?pid=_Vx9pkxpFxxCRGWMQ2FKCqW70iuLi6Mn&UserName=knaclive', 1), (9, 'no', 'A.I.R. Radio', 'http://130.49.24.169:1015/listen.pls', 1), (7, 'no', 'Idobi', 'http://www.idobi.com/radio/iradio.rm', 1), (8, 'no', 'American Radio Network', 'http://www.myamericanradio.net/audio/heavymetalhigh/preload.asx', 1)

    ";

        

    print_form_header('', '');

    print_table_header("vBRadio 1.0 Installation");

    print_description_row("Database modifications complete. DELETE 'install_vbradio.php' AND 'vbradio.xml' FROM 'admincp' DIRECTORY NOW!");



}

KevNJ · #**325** 08-21-2006, 10:46 PM

bump... anyone get this to work with 3.6 ?

Ragnarok · #**326** 08-22-2006, 12:33 AM

I installed it on a 3.5.2 and have since upgraded to 3.6.0... it has no sql problems but the stations don't seem to play anymore. This related at all?

KevNJ · #**327** 08-22-2006, 01:12 PM

nope doesnt work with 3.6 i get this error when trying to install

PHP Code:


			
Database error in vBulletin 3.6.0:



Invalid SQL:

INSERT INTO jelsoft_phrase VALUES ('', -1, 'radio_cat_added', 'Radio Category Added', 1000,'vbulletin');;



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

Error Number : 1136

Date         : Tuesday, August 22nd 2006 @ 07:10:57 AM

Script       : http://www.MYSITE.com/forums/admincp/install_vbradio.php?do=steptwo

Referrer     : http://www.MYSITE.com/forums/admincp/install_vbradio.php?do=stepone

IP Address   : edited

Username     : kevin

Classname    : vb_database

Ragnarok · #**328** 08-22-2006, 01:32 PM

Quote:

Originally Posted by KevNJ

nope doesnt work with 3.6 i get this error when trying to install

Except I'm not trying to install- I installed vBradio before I upgraded to 3.6.0

Then again, given how none of my members have been whining about it not working, either it's just me or it's not being used at all.

KevNJ · #**329** 08-22-2006, 02:12 PM

I had it installed on 3.5.1 but when before i upgraded i uninstalled all the mods as to start fresh in a sense went to install it and no go.. i have the wimpy bundle from www.wimpyplayer.com but i would like everything be based of of vb instead. guess ill continue to wait for a port.

Exitilus · #**330** 08-22-2006, 04:52 PM

Work's fine for me on 3.6

da420 · #**331** 08-22-2006, 05:02 PM

Works for me no problemo on 3.6

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.06199 seconds Memory Usage 2,355KB Queries Executed 25 (?)
More Information
Template Usage: (1)SHOWTHREAD (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)ad_showthread_beforeqr (6)bbcode_php (3)bbcode_quote (1)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)modsystem_post (1)navbar (6)navbar_link (120)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (2)pagenav_pagelinkrel (11)post_thanks_box (11)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (11)post_thanks_postbit_info (10)postbit (11)postbit_onlinestatus (11)postbit_wrapper (1)spacer_close (1)spacer_open (1)tagbit_wrapper Phrase Groups Available: global inlinemod postbit posting reputationlevel showthread	Included Files: ./showthread.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/functions_bigthree.php ./includes/class_postbit.php ./includes/class_bbcode.php ./includes/functions_reputation.php ./includes/functions_post_thanks.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 showthread_start showthread_getinfo forumjump showthread_post_start showthread_query_postids showthread_query bbcode_fetch_tags bbcode_create showthread_postbit_create postbit_factory postbit_display_start post_thanks_function_post_thanks_off_start post_thanks_function_post_thanks_off_end post_thanks_function_fetch_thanks_start post_thanks_function_fetch_thanks_end post_thanks_function_thanked_already_start post_thanks_function_thanked_already_end fetch_musername postbit_imicons bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete postbit_display_complete post_thanks_function_can_thank_this_post_start pagenav_page pagenav_complete tag_fetchbit_complete forumrules navbits navbits_complete showthread_complete
Messages:

The Arcive of Official vBulletin Modifications Site.

It is not a VB3 engine, just a parsed copy!