BVShoutbox FULLL

Features:

• Displays vBCodes and other post code allowances.
• Admins can edit & delete shouts from the Admin CP.
• Built-in /me code.
• Archive page and IFrame on forumhome for shouting and reading.
• Archive page has multiple pages.
• Stats on archive page.
• Uses phrases for the Admin CP and shoutbox.
• Users can edit and delete their own shouts.
• Usergroup & Administrator permissions.
• Find shouts by specific users (in the admin cp)
• Seperate options for vBCodes allowances and what to display

If there's any features anyone wants added, I'll try and add them. I think I added everything people asked for in the previous version, apart from the upgrader, which will be added to the ZIP file when i've setup another test forum and added the previous version to it

There shouldn't be any problems, because I've tested the installer three times.
And I haven't had any problems with the actual shoutbox, or shout manager.

I'll attach some screenshots of all the custom scripts, if anyone asks for screenshots of the add ons for the permissions and stuff ill take them, dunno why anyone would want them tho...

This has only been tested on vB 3.0.0 GOLD

[Vman]

Originally Posted by Fking

the IE started crashing, may this hack be the reason?
the weird is that it crashes only when i load the url with www. in front

Weird you are saying this...Im using another shoutbox and I too have noticed that all shotboxes are crashing or just giving a black box whent hey are set to iFrame. Disable iFrame and your box with the posts will appear again...this is what I had to do on another shoutbox hack by Zero T!

[TruthElixirX]

I jsut downlaoded the installer. When I installed the first step iand click continue, nothing ever happens...

[Fking]

Originally Posted by BBCVman

Weird you are saying this...Im using another shoutbox and I too have noticed that all shotboxes are crashing or just giving a black box whent hey are set to iFrame. Disable iFrame and your box with the posts will appear again...this is what I had to do on another shoutbox hack by Zero T!

how to disable to iframe?
what i can use instaed of iframe?

[taffy056]

Hi,

I get the following when I install this hack, I know this error message has been posted before, but there has been no direct reply to the fix for the error message, does anyone know of a fix?

thanks

taffy



Database error in vBulletin 3.0.3:
Invalid SQL: UPDATE usergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
title = 'Administrators',
description = '',
usertitle = 'Administrator',
opentag = '',
closetag = '',
passwordexpires = '180',
passwordhistory = '360',
attachlimit = '0',
avatarmaxwidth = '80',
avatarmaxheight = '80',
avatarmaxsize = '20000',
profilepicmaxwidth = '100',
profilepicmaxheight = '100',
profilepicmaxsize = '65535',
pmquota = '200',
pmsendmax = '5',
canaddshout = '1',
candropshout = '1',
candropothershout = '1',
caneditshout = '1',
caneditothershout = '1',
canreadshouts = '1',
forumpermissions = '393215',
pmpermissions = '3',
calendarpermissions = '31',
wolpermissions = '31',
adminpermissions = '3',
genericpermissions = '4194239',
genericoptions = '31',
hivepermissions = '15',
petzpermissions = '1',
arcadepermissions = '31'
WHERE usergroupid=6
mysql error: Unknown column 'canaddshout' in 'field list'

mysql error number: 1054

Date: Tuesday 09th of November 2004 02:23:55 AM
Script: http://mydomain.uk/vbforum/admincp/usergroup.php
Referer: http://mydomain.uk/vbforum/admincp/u...&usergroupid=6
Username: admin
IP Address: 84.*.*.*

[Sooner95]

Originally Posted by Fking

how to disable to iframe?
what i can use instaed of iframe?

like to know this too... each shout i do , doesnt post completly. I have to either refresh the page myself or reload it manually then the shout is there..

[lange]

Thanks. I'll test it.

[taffy056]

Hi,

I was wondering if anyone has any answers to the above problem? It is effecting me making any changes in the usergroups, so I really need an answer if possible. otherwise I will attempt to uninstall it because it is not supported!

thanks

taffy

[Harley D]

I figured out why I can't see anything in the ADMINCP. Its due to a failed install.
So I'm having to manually install phrases, and MYSQL Queries.
Now I've managed to install the phrases, but am really lost when it comes to the Queries!
Would someone please be so kind as to take this text and make the queries in it a cut and paste for MYSQL?

PHP Code:

 if ($_REQUEST['step'] == 6)
{
    require_once('./includes/adminfunctions_language.php');
    require_once('./includes/adminfunctions_options.php');

    print_install_table_header($steps[6]);

    $DB_site->reporterror = 0;
    $DB_site->query("ALTER TABLE " . TABLE_PREFIX . "language DROP phrasegroup_shoutbox, DROP phrasegroup_shoutmanager");
    $DB_site->reporterror = 1;

    $DB_site->query("DELETE FROM " . TABLE_PREFIX . "phrasetype WHERE fieldname = 'shoutbox' OR fieldname = 'shoutmanager'");
    $DB_site->query("DELETE FROM " . TABLE_PREFIX . "settinggroup WHERE grouptitle = 'shoutbox'");
    $DB_site->query("DELETE FROM " . TABLE_PREFIX . "phrase WHERE varname = 'settinggroup_shoutbox'");

    foreach ($phrases AS $phrasetype => $phrasebit)
    {
        foreach ($phrasebit AS $varname => $text)
        {
            if (!empty($phraselist))
            {
                $phraselist .= ',';
            }
            $phraselist .= "'$varname'";
        }
    }
    $DB_site->query("DELETE FROM " . TABLE_PREFIX . "phrase WHERE varname IN ($phraselist)");

    foreach ($settinggroups AS $settinggroup => $settings)
    {
        foreach ($settings AS $varname => $vars)
        {
            if (!empty($settinglist))
            {
                $settinglist .= ',';
            }
            $settinglist .= "'$varname'";
        }
    }
    $DB_site->query("DELETE FROM " . TABLE_PREFIX . "setting WHERE varname IN ($settinglist)");

    foreach ($phrases AS $phrasetype => $blabla)
    {
        if (!empty($fieldname))
        {
            $fieldname .= ", ";
        }
        $fieldname .= "'$phrasetype'";
    }

    $phrasetypeidQuery = $DB_site->query("SELECT fieldname, phrasetypeid FROM " . TABLE_PREFIX . "phrasetype WHERE fieldname IN ($fieldname)");
    while ($fetchedPhrasetypeID = $DB_site->fetch_array($phrasetypeidQuery))
    {
        $phrasetypeids[$fetchedPhrasetypeID['fieldname']] = $fetchedPhrasetypeID['phrasetypeid'];
    }

    print_install_description_row("Importing Shoutbox Phrase Types...");
    $phrasetypeids['shoutbox'] = add_phrase_type('shoutbox', 'Shoutbox');
    $phrasetypeids['shoutmanager'] = add_phrase_type('shoutmanager', 'Shout Manager');
    print_install_description_row('Done');

    $ordercheck = $DB_site->query_first("
        SELECT displayorder
        FROM " . TABLE_PREFIX . "settinggroup
        ORDER BY displayorder DESC
    ");

    $displayorder = $ordercheck['displayorder'] + 10;

    print_install_description_row("Importing Shoutbox Setting Groups...");
    $DB_site->query("INSERT INTO " . TABLE_PREFIX . "settinggroup (grouptitle, displayorder) VALUES ('shoutbox', $displayorder)");
    $DB_site->query("INSERT INTO " . TABLE_PREFIX . "phrase (languageid, phrasetypeid, varname, text) VALUES (-1, " . PHRASETYPEID_SETTING . ", 'settinggroup_shoutbox', 'Shoutbox')");
    print_install_description_row('Done');

    foreach ($phrasetypeids as $name => $phrasetypeid)
    {
        $phrasetypes[$phrasetypeid] = $name;
    }
    unset($phrasetypeids, $name, $phrasetypeid);

    print_install_description_row("Importing Shoutbox Phrases...");
    foreach ($phrasetypes as $phrasetypeid => $name)
    {
        foreach ($phrases[$name] as $varname => $text)
        {
            if (!empty($phrasequery))
            {
                $phrasequery .= ', ';
            }
            $phrasequery .= "('$varname', '$text', $phrasetypeid)";
        }
    }
    if (!empty($phrasequery))
    {
        $phrasequery = "INSERT INTO " . TABLE_PREFIX . "phrase (varname, text, phrasetypeid) VALUES " . $phrasequery;

        $DB_site->query($phrasequery);
    }
    print_install_description_row('Done');

    print_install_description_row("Importing Shoutbox Settings...");
    foreach ($settinggroups as $grouptitle => $settings)
    {
        foreach ($settings as $varname => $vars)
        {
            if (!empty($settingquery))
            {
                $settingquery .= ', ';
            }
            $settingquery .= "('$varname', '$grouptitle', '$vars[value]', '$vars[defaultvalue]', '" . addslashes($vars['optioncode']) . "', '$vars[displayorder]', 0, 0)";
        }
    }
    if (!empty($settingquery))
    {
        $settingquery = "INSERT INTO " . TABLE_PREFIX . "setting (varname, grouptitle, value, defaultvalue, optioncode, displayorder, advanced, volatile) VALUES " . $settingquery;

        $DB_site->query($settingquery);
    }
    print_install_description_row('Done');

    // build languages
    $class = fetch_row_bgclass();
    echo("<tr valign=\"top\">\n\t<td class=\"$class\" align=\"center\">\n");

    $languages = fetch_languages_array();
    echo("<ul>\n");
    foreach($languages as $languageid => $language)
    {
        echo("<li>Building Language: $language[title]</li>\n");
        build_language($languageid);
        flush();
    }
    echo("</ul>\n");
    echo("<p><strong>Language imported sucessfully!</strong></p>\n");

    echo("</td>\n</tr>\n");

    // build settings
    print_install_description_row('Building settings...');
    build_options();
    print_install_description_row('Done');

    print_install_submit_row('Continue');
} 


Thanks in advance.

[taffy056]

Hi,

It looks as if I will have uninstll this hack! Are the steps bitg mentions all the steps you have to take to uninstall? I am very wary about going into my database deleting items, if I delete everything else will it matter that these are still in the database? I plan to install a different shoutbox, am I going to get a problem by leaving the previous shout table there?

Thanks

taffy

Originally Posted by bitg

To uninstall, you need to

Delete the following files
shoutbox.php = forum root directory
shout.php = admincp directory
shout_install.php = admincp directory

Execute these three MySQL commands

ALTER TABLE language drop phrasegroup_shoutbox
ALTER TABLE language drop phrasegroup_shoutmanager
ALTER TABLE usergroup drop shoutboxpermissions

Remove the "shout" table" in your database.

Remove everything in your database referring to the word "shoutbox". (They are pretty much in the "phrase, phrasetype & template" tables.

Remove all the shoutbox templates and phrases. Youc an do this in the database with the above step or do them one at a time in the vb ACP.

Modify you FORUMHOME template and remove the shoutbox code. It is easily identifiable. It begins right after the line that says "$navbar" and ends when you see the <!--/shoutbox code.

[Harley D]

Originally Posted by Harley D

I figured out why I can't see anything in the ADMINCP. Its due to a failed install.
So I'm having to manually install phrases, and MYSQL Queries.
Now I've managed to install the phrases, but am really lost when it comes to the Queries!
Would someone please be so kind as to take this text and make the queries in it a cut and paste for MYSQL?

PHP Code:

 if ($_REQUEST['step'] == 6)
{
    require_once('./includes/adminfunctions_language.php');
    require_once('./includes/adminfunctions_options.php');

    print_install_table_header($steps[6]);

    $DB_site->reporterror = 0;
    $DB_site->query("ALTER TABLE " . TABLE_PREFIX . "language DROP phrasegroup_shoutbox, DROP phrasegroup_shoutmanager");
    $DB_site->reporterror = 1;

    $DB_site->query("DELETE FROM " . TABLE_PREFIX . "phrasetype WHERE fieldname = 'shoutbox' OR fieldname = 'shoutmanager'");
    $DB_site->query("DELETE FROM " . TABLE_PREFIX . "settinggroup WHERE grouptitle = 'shoutbox'");
    $DB_site->query("DELETE FROM " . TABLE_PREFIX . "phrase WHERE varname = 'settinggroup_shoutbox'");

    foreach ($phrases AS $phrasetype => $phrasebit)
    {
        foreach ($phrasebit AS $varname => $text)
        {
            if (!empty($phraselist))
            {
                $phraselist .= ',';
            }
            $phraselist .= "'$varname'";
        }
    }
    $DB_site->query("DELETE FROM " . TABLE_PREFIX . "phrase WHERE varname IN ($phraselist)");

    foreach ($settinggroups AS $settinggroup => $settings)
    {
        foreach ($settings AS $varname => $vars)
        {
            if (!empty($settinglist))
            {
                $settinglist .= ',';
            }
            $settinglist .= "'$varname'";
        }
    }
    $DB_site->query("DELETE FROM " . TABLE_PREFIX . "setting WHERE varname IN ($settinglist)");

    foreach ($phrases AS $phrasetype => $blabla)
    {
        if (!empty($fieldname))
        {
            $fieldname .= ", ";
        }
        $fieldname .= "'$phrasetype'";
    }

    $phrasetypeidQuery = $DB_site->query("SELECT fieldname, phrasetypeid FROM " . TABLE_PREFIX . "phrasetype WHERE fieldname IN ($fieldname)");
    while ($fetchedPhrasetypeID = $DB_site->fetch_array($phrasetypeidQuery))
    {
        $phrasetypeids[$fetchedPhrasetypeID['fieldname']] = $fetchedPhrasetypeID['phrasetypeid'];
    }

    print_install_description_row("Importing Shoutbox Phrase Types...");
    $phrasetypeids['shoutbox'] = add_phrase_type('shoutbox', 'Shoutbox');
    $phrasetypeids['shoutmanager'] = add_phrase_type('shoutmanager', 'Shout Manager');
    print_install_description_row('Done');

    $ordercheck = $DB_site->query_first("
        SELECT displayorder
        FROM " . TABLE_PREFIX . "settinggroup
        ORDER BY displayorder DESC
    ");

    $displayorder = $ordercheck['displayorder'] + 10;

    print_install_description_row("Importing Shoutbox Setting Groups...");
    $DB_site->query("INSERT INTO " . TABLE_PREFIX . "settinggroup (grouptitle, displayorder) VALUES ('shoutbox', $displayorder)");
    $DB_site->query("INSERT INTO " . TABLE_PREFIX . "phrase (languageid, phrasetypeid, varname, text) VALUES (-1, " . PHRASETYPEID_SETTING . ", 'settinggroup_shoutbox', 'Shoutbox')");
    print_install_description_row('Done');

    foreach ($phrasetypeids as $name => $phrasetypeid)
    {
        $phrasetypes[$phrasetypeid] = $name;
    }
    unset($phrasetypeids, $name, $phrasetypeid);

    print_install_description_row("Importing Shoutbox Phrases...");
    foreach ($phrasetypes as $phrasetypeid => $name)
    {
        foreach ($phrases[$name] as $varname => $text)
        {
            if (!empty($phrasequery))
            {
                $phrasequery .= ', ';
            }
            $phrasequery .= "('$varname', '$text', $phrasetypeid)";
        }
    }
    if (!empty($phrasequery))
    {
        $phrasequery = "INSERT INTO " . TABLE_PREFIX . "phrase (varname, text, phrasetypeid) VALUES " . $phrasequery;

        $DB_site->query($phrasequery);
    }
    print_install_description_row('Done');

    print_install_description_row("Importing Shoutbox Settings...");
    foreach ($settinggroups as $grouptitle => $settings)
    {
        foreach ($settings as $varname => $vars)
        {
            if (!empty($settingquery))
            {
                $settingquery .= ', ';
            }
            $settingquery .= "('$varname', '$grouptitle', '$vars[value]', '$vars[defaultvalue]', '" . addslashes($vars['optioncode']) . "', '$vars[displayorder]', 0, 0)";
        }
    }
    if (!empty($settingquery))
    {
        $settingquery = "INSERT INTO " . TABLE_PREFIX . "setting (varname, grouptitle, value, defaultvalue, optioncode, displayorder, advanced, volatile) VALUES " . $settingquery;

        $DB_site->query($settingquery);
    }
    print_install_description_row('Done');

    // build languages
    $class = fetch_row_bgclass();
    echo("<tr valign=\"top\">\n\t<td class=\"$class\" align=\"center\">\n");

    $languages = fetch_languages_array();
    echo("<ul>\n");
    foreach($languages as $languageid => $language)
    {
        echo("<li>Building Language: $language[title]</li>\n");
        build_language($languageid);
        flush();
    }
    echo("</ul>\n");
    echo("<p><strong>Language imported sucessfully!</strong></p>\n");

    echo("</td>\n</tr>\n");

    // build settings
    print_install_description_row('Building settings...');
    build_options();
    print_install_description_row('Done');

    print_install_submit_row('Continue');
} 


Thanks in advance.

Can someone make a txt file for a manual install???
Please

[taffy056]

Hi,

I have uninstalled this hack, but I am left with a number of templates (below) how can I delete them? Revert is greyed out!

shoutbox_archive
shoutbox_archive_message
shoutbox_archive_message_me
shoutbox_archive_topbit
shoutbox_editmessage
shoutbox_iframe
shoutbox_main
shoutbox_main_message
shoutbox_main_message_me
shoutbox_newmessage
shoutbox_newmessage_refresh
shoutbox_shouterror

[Tru Smiles]

I've properly installed this okay, cept for one thing. It's not a problem as such, but any help would be appreciated

You know the iFrame where the text appears? Because of the skin I use, the background for the iFrame uses the background for the skin, which is dark and unreadable. Does anyone know where it is that I can change the background colour to white?

[Harley D]

Originally Posted by Tru Smiles

I've properly installed this okay, cept for one thing. It's not a problem as such, but any help would be appreciated

You know the iFrame where the text appears? Because of the skin I use, the background for the iFrame uses the background for the skin, which is dark and unreadable. Does anyone know where it is that I can change the background colour to white?

I' don't know off hand, I was trying to reinstall the ShoutBox on my clients site because it just dissappeared yesterday for no reason I can find. And while removing all instances of ShoutBox from my database, I now have a blank forums/index.php page! and I can't get my backup to load!

I'm really at a loss, I hit a deer tonight with my brand new car, I have the family's thing to do tomorrow, so getting my clients site up again soon is going to be tought to say the least. Specially since I havn't a clue what to do now.

But If some nice coder who knows databases, could PM me I would Gladly let some of my PayPal money slide out of my account to theirs. and then I will find the answer your looking for and post it here.

[Harley D]

True Smiles,
I have managed to get the board back up by updating VB, I will have to reinstall all the Mods. When I get to the ShoutBox, I'll see if I can't answer your question.

[Harley D]

Sorry, I can't get this mod to install properly, I will not be able to help you on this one.