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....


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]

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]

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...


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!