Parse BBCode

[mrTip]

Hello,

I am currently trying to syndicate news from a certain forum. Take a look at my script (yes, I do have my own db class):

PHP Code:

include './functions.php';

            // start connection
            $db_host = "localhost";
            $db_user = "haha";
            $db_pass = "haha";
            $db_name = "haha";
            
            $db = new db;
            
            $db->connect($db_host, $db_user, $db_pass, $db_name);

            // which forum id should news be displayed from?
            define("FORUMID", "2");
            // enter prefix of your tables here (blank by default)
            define("PREFIX", "", true);
            // define how many number of articles you wish to display
            define("AMOUNT", "10");

            // run the query
            $query_sel_news = $db->query("select t.*,p.pagetext from ".PREFIX."thread t left join ".PREFIX."post p on(p.postid=t.firstpostid) where t.forumid = ".FORUMID." order by dateline desc limit 0,".AMOUNT."");

            // display the results and replace a few things... err.
            while($r = $db->fetch_array($query_sel_news)) {
    
                // our (simple) bbcode
                $bbcode = array("[B]", "[/B]", "[b]", "[/b]", "[I]", "[/I]", "[i]", "[/i]", "[U]", "[/U]", "[u]", "[/u]", "[img]https://vborg.vbsupport.ru/[/img]", "[img]https://vborg.vbsupport.ru/[/img]", "[center]", "[/center]", "[CENTER]", "[/CENTER]");
                // our html code :D
                $htmlcode = array("<B>", "</B>", "<b>", "</b>", "<I>", "</I>", "<i>", "</i>", "<U>", "</U>", "<U>", "</U>", "<img src=\"", "\">", "<img src=\"", "\">", "</p><p align=center>", "</p><p>", "</p><p align=center>", "</p><p>");
                // do the replacing
                $pagetext = str_replace($bbcode, $htmlcode, $r[pagetext]);
                // make it so there are LINE BREAKS ;o
                $pagetext = nl2br($pagetext);
                
                echo "<h2>".$r[title]."</h2><h3>".date("F jS, g:i A, Y", $r[dateline])."</h3><p>".$pagetext."</p><div id=\"content_left_news\">posted by ".$r[postusername]." | <a href=/forums/showthread.php?t=".$r[threadid].">comments (".$r[replycount].")</a> | <a href=/forums/showthread.php?t=".$r[threadid].">permalink</a></div>";
            }

            $db->close(); 


Ergh, but it's absolutely insane working with the freakin' bbcode. I've looked at this tutorial, but you see, I am selecting news from an "out-of-vbulletin" page (my main site index page). So, how can I get vB's bbcode parser on my index page to parse this text ($row[pagetext]).

[calorie]

You basically need to make a vB page out of your non-vB page. Here is an outline. Hope it helps.

<?php

error_reporting(E_ALL & ~E_NOTICE);

define('THIS_SCRIPT', 'whatever'); // SET ME
define('FWD', '/full/server/path/to/forum'); // SET ME
define('BWD', (($getcwd = getcwd()) ? $getcwd : '.'));

$phrasegroups = array();
$specialtemplates = array();
$globaltemplates = array();
$actiontemplates = array();

chdir(FWD);
require_once('./global.php');
chdir(BWD);

require_once(DIR . '/includes/class_bbcode.php');
$parser =& new vB_BbCodeParser($vbulletin, fetch_tag_list());

$do_html = false; $do_smilies = true; $do_bbcode = true;
$do_imgcode = true; $do_nl2br = true; $cachable = false;

$query_sel_news = $db->query_read("QUERY HERE"); // SET ME

while ($r = $db->fetch_array($query_sel_news))
{
	$pagetext = $parser->do_parse(
		$r['pagetext'],
		$do_html, $do_smilies, $do_bbcode,
		$do_imgcode, $do_nl2br, $cachable
	);

	echo $pagetext . '<br /><br />'; // SET ME
}

$db->free_result($query_sel_news);
$db->close();

?>

[mrTip]

Thanks so much!

However, the vBulletin template is pulled up and the 'pagetext' still isn't outputted. How do I get it so it just... a page, with the news pulled up (without the vB template).

I defined THIS_SCRIPT as 'news_index' so, do I need to set up a template or file for news_index somewhere? Sorry, never done anything like this with vB!

Thanks so much, I truly do appreciate it.

EDIT: Wait, the "vB template" that I am referring to is the "board offline" page. Whenever I login as admin (so I can view the forums and don't get the nasty offline error), I can view the page, but it spits an error out:

Fatal error: Call to undefined function: query_read() in /home/virtual/site13/fst/var/www/html/forums/includes/class_bbcode.php on line 472

Any ideas?

[calorie]

Try the following:

replace: $db->
with: $vbulletin->db->

[mrTip]

Didn't do anything... I suspected that I shouldn't because I have my own DB class.

[calorie]

Agreed, try replacing the vB query_read with your class equivalent.

[mrTip]

In class_bbcode.php? Where?

[calorie]

If your DB class is for the same database where vB is located, it might just be easier to be rid of your class. Otherwise you can try a class_bbcode.php file edit, replacing query_read with just query, but if you are going to file edit, then maybe set a constant in your script, and then file edit the vB script, so that for your script $db->query is used and for vB, it uses what it uses.

[mrTip]

Okay, I edit line 472... it READ (past tense):

PHP Code:

            $smilies = $this->registry->db->query_read("
                SELECT *, LENGTH(smilietext) AS smilielen
                FROM " . TABLE_PREFIX . "smilie
                ORDER BY smilielen DESC
            "); 


Now it says as follows...

PHP Code:

            $smilies = $this->registry->db->query("
                SELECT *, LENGTH(smilietext) AS smilielen
                FROM " . TABLE_PREFIX . "smilie
                ORDER BY smilielen DESC
            "); 


The my news script works now. But will editing the class_bbcode.php file screw up my forums? Topics and bbcode still display properly as far as I can see. What concerns should I take?

[calorie]

If that's the only file edit you made, then it should be fine as vB also can do a $db->query that acts like a $db->query_read when SELECT is in the query.