Trying to use parse_bbcode2

[Lancelow Dowell]

Hi, I'm trying to parse a bit of code using the bbcode2 function. Whenever I run my code, I'm getting this error....

Database error in vBulletin :

Invalid SQL:
SELECT bbcodetag, bbcodereplacement, twoparams
FROM TABLE_PREFIXbbcode

mysql error: Table 'crucib1.TABLE_PREFIXbbcode' doesn't exist

mysql error number: 1146

Date: Sunday 19th of December 2004 11:49:31 AM
Script: http://www.bane-online.comSCRIPTPATH
Referer: REFERRER
IP Address: IPADDRESS

So my question is, why is table_prefix showing up instead of my real table prefix? Here is my code that's trying to do all of this....

PHP Code:

        require_once('/u/htdocs/crucib1/vbulletin/includes/config.php');    
    require_once('/u/htdocs/crucib1/vbulletin/includes/db_mysql.php');

    $DB_site = new DB_Sql_vb;
    
    $DB_site->appname = 'vBulletin';
    $DB_site->appshortname = 'vBulletin (' . VB_AREA . ')';
    $DB_site->database = $dbname;
    
    $DB_site->connect($servername, $dbusername, $dbpassword, $usepconnect);

    require_once("/u/htdocs/crucib1/vbulletin/includes/functions.php");
    require_once("/u/htdocs/crucib1/vbulletin/includes/functions_bbcodeparse.php");

    echo parse_bbcode2($row["pagetext"], 0, 0, 0, 1, 0, 1); 


Thanks!

[filburt1]

You need to define the constant TABLE_PREFIX, which (I believe) is in config.php.

[Lancelow Dowell]

Originally Posted by filburt1

You need to define the constant TABLE_PREFIX, which (I believe) is in config.php.

it is defined in config.php, which is included on the first line of code i posted....

[Paul M]

Originally Posted by Lancelow Dowell

it is defined in config.php, which is included on the first line of code i posted....

Not exactly it isn't, the variable is defined in config.php - the constant is defined, using this variable, in init.php.

[Lancelow Dowell]

hmmm, ok... so what do I need to do to get this working then? Thanks for the help!

[Link14716]

define('TABLE_PREFIX', $tableprefix);

[Lancelow Dowell]

Ok, that fixed it so that it's not erroring out anymore.... but now it's not changing all the bbcode to html. It's still outputting tags, like [ b] and [ /b] instead of < b> and < /b>. You can see what it's doing at http://www.bane-online.com/new. Here's the latest version of the code...

PHP Code:

require('/u/htdocs/crucib1/vbulletin/includes/config.php');    
    require('/u/htdocs/crucib1/vbulletin/includes/db_mysql.php');
    
    define('TABLE_PREFIX', $tableprefix);
    $DB_site = new DB_Sql_vb;
    
    $DB_site->appname = 'vBulletin';
    $DB_site->appshortname = 'vBulletin (' . VB_AREA . ')';
    $DB_site->database = $dbname;    
        
    $DB_site->connect($servername, $dbusername, $dbpassword, $usepconnect);
            
    require_once("/u/htdocs/crucib1/vbulletin/includes/functions.php");
    require_once("/u/htdocs/crucib1/vbulletin/includes/functions_bbcodeparse.php");
    
    echo parse_bbcode2($row["pagetext"], 0, 0, 0, 1, 0, 1); 


'

Thanks for the help!