vb.org Archive
Page 1 of 2 1 2
Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   Modification Requests/Questions (Unpaid) (https://vborg.vbsupport.ru/forumdisplay.php?f=112)
-   -   Create Custom Phrase Types (https://vborg.vbsupport.ru/showthread.php?t=92297)

evenmonkeys 07-16-2005 01:43 AM
Create Custom Phrase Types
 
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 07-16-2005 01:49 AM
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 07-16-2005 01:52 AM
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 07-16-2005 01:54 AM
As said, you must use the apropriate Queries.
Take a look at the function I mentioned.

evenmonkeys 07-16-2005 01:59 AM
Well, I don't know what any of that means... so that means someone needs to make something for me to use. =D

Andreas 07-16-2005 02:01 AM
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 07-16-2005 02:51 AM
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 07-16-2005 05:53 PM
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 07-16-2005 07:36 PM
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 07-16-2005 07:41 PM
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']);
}

?>


All times are GMT. The time now is 07:26 AM.
Page 1 of 2 1 2
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.02381 seconds
  • Memory Usage 1,762KB
  • 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_php_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (1)pagenav_pagelink
  • (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