Create Custom Phrase Types

[evenmonkeys]

I'd like to be able to add my own phrase groups... Could someone please come up with something that would make this possible? Adding it in manually via phpMyAdmin doesn't work. Gives errors in the admincp.

Please & thank you.

[Andreas]

It does work, if you are executing the correct queries

Take a look at add_phrase_type() in includes/adminfunctions_language.php.

Unfortunetely there is no GUI to add Phrase Types. There was a Hack for vB 3.0.X to do so, but AFAIK it has not been ported yet.

[evenmonkeys]

Well, I mean just entering it in directly to the rows. Not through queries or anything. I just inserted a new row. Didn't work. I also tried changing one of the rows that said reserved. Didn't work. >_<;

[Andreas]

As said, you must use the apropriate Queries.
Take a look at the function I mentioned.

[evenmonkeys]

Well, I don't know what any of that means... so that means someone needs to make something for me to use. =D

[Andreas]

This is most likely not gonna happen (too soon)
So if you want custom Phrase Types, you'll have to look at the code.

[Adrian Schneider]

newfilename.php

PHP Code:

<?php

require_once("./global.php");

// #############################################################################
// function to allow modifications to add a phrasetype easily
function add_phrase_type($phrasegroup_name, $phrasegroup_title)
{
    global $DB_site;

    // first lets check if it exists
    if ($check = $DB_site->query_first("SELECT * FROM " . TABLE_PREFIX . "phrasetype WHERE fieldname = '$phrasegroup_name'"))
    {
        return false;
    }
    else
    { // check max id
        $max_rows = $DB_site->query_first("SELECT MAX(phrasetypeid) + 1 AS max FROM " . TABLE_PREFIX . "phrasetype WHERE phrasetypeid < 1000");
        $phrasetypeid = $max_rows['max'];
        if ($phrasetypeid)
        {
            $DB_site->query("INSERT INTO " . TABLE_PREFIX . "phrasetype (phrasetypeid, fieldname, title, editrows) VALUES ($phrasetypeid, '" . addslashes($phrasegroup_name) . "', '" . addslashes($phrasegroup_title) . "', 3)");
            $DB_site->query("ALTER TABLE " . TABLE_PREFIX . "language ADD phrasegroup_" . addslashes($phrasegroup_name) . " MEDIUMTEXT NOT NULL");
            return $phrasetypeid;
        }
    }
    return false;
}

if ($_REQUEST['name'] AND $_REQUEST['title'])
{
    add_phrase_type($_REQUEST['name'], $_REQUEST['title');
}
?>

Run newfilename.php?name=(NEWPHRASENAME)&title=(NEWPHR ASETITLE)

[evenmonkeys]

It's not working...

Fatal error: Call to a member function on a non-object in /home/???/domains/???/public_html/pp/admincp/create_new_phrase.php on line 12

[Adrian Schneider]

Sorry I had a typo on the add_phrase_type line near the end

PHP Code:

add_phrase_type($_REQUEST['name'], $_REQUEST['title'); 


should be

PHP Code:

add_phrase_type($_REQUEST['name'], $_REQUEST['title']); 


But that wasn't the cause of your error message, you can't run it from the ACP. If you want security (beside just deleting it after) you can add

PHP Code:

if (!is_member_of($bbuserinfo, 6))
{
    print_no_permission();
} 


after

PHP Code:

require ("./global.php"); 


[Link14716]

No, the cause of the error is that your code is for 3.0.x, not 3.5.0.

Here's your code changed for 3.5.0:

PHP Code:

<?php

require_once("./global.php");

if (!is_member_of($vbulletin->userinfo, 6))
{
    print_no_permission();
} 

// #############################################################################
// function to allow modifications to add a phrasetype easily
function add_phrase_type($phrasegroup_name, $phrasegroup_title)
{
    global $db;

    // first lets check if it exists
    if ($check = $db->query_first("SELECT * FROM " . TABLE_PREFIX . "phrasetype WHERE fieldname = '$phrasegroup_name'"))
    {
        return false;
    }
    else
    { // check max id
        $max_rows = $db->query_first("SELECT MAX(phrasetypeid) + 1 AS max FROM " . TABLE_PREFIX . "phrasetype WHERE phrasetypeid < 1000");
        $phrasetypeid = $max_rows['max'];
        if ($phrasetypeid)
        {
            $db->query_write("INSERT INTO " . TABLE_PREFIX . "phrasetype (phrasetypeid, fieldname, title, editrows) VALUES ($phrasetypeid, '" . $db->escape_string($phrasegroup_name) . "', '" . $db->escape_string($phrasegroup_title) . "', 3)");
            $db->query_write("ALTER TABLE " . TABLE_PREFIX . "language ADD phrasegroup_" . addslashes($phrasegroup_name) . " MEDIUMTEXT NOT NULL");
            return $phrasetypeid;
        }
    }
    return false;
}

if ($_REQUEST['name'] AND $_REQUEST['title'])
{
    add_phrase_type($_REQUEST['name'], $_REQUEST['title']);
}

?>