is it correct code ? exceed memory limit :(

[roxxx]

require("global.php");
$getposts = $db->query_read("
SELECT post.postid AS postid, post.pagetext AS pagetext
FROM " . TABLE_PREFIX . "post AS post
WHERE postid='1111';");
$post = $db->fetch_array($getposts);
echo "<b>".$post['postid']."</b> - ".$post['pagetext']."<br /><br />";

is it correct code ? I want to add it as plugin, but when I do it - is error with memory limit (I have 16M in php.ini)

________
where are my before post on this subforum ?

[Dismounted]

PHP Code:

$postdata = $vbulletin->db->query_first("
    SELECT `pagetext`
    FROM `" . TABLE_PREFIX . "post`
    WHERE `postid` = 1111
"); 


You can't echo in a plugin, because it'd just appear at the very top of the page. Use $postdata[pagetext] in a template.

Also, there's no need to use aliases and grab the postid in your query, you already have the postid (1111).

[roxxx]

thanks,

Ok, post grabs, but how display this post with BBC code ?

[King Kovifor]

To use with BBCode, you must use the BBCode parser class. It's a very simplistic class to use, and you can read more about it here (class -> vB_BbCodeParser).

If you want to parse a variable called $var, you would use this php code:

PHP Code:

require('includes/class_bbcode.php');

$var = '[b][i][u]HA HA[/u][/i][/b]';

$bbcode = new vB_BbCodeParser($vbulletin,fetch_tag_list());

$template_var = $bbcode->do_parse($var); 


This will have a fully parse variable from $var into $template_var. You could change any of my variable names if needed.

[roxxx]

Originally Posted by King Kovifor

To use with BBCode, you must use the BBCode parser class. It's a very simplistic class to use, and you can read more about it here (class -> vB_BbCodeParser).

If you want to parse a variable called $var, you would use this php code:

PHP Code:

require('includes/class_bbcode.php');

[noparse]$var = '[b][i][u]HA HA[/u][/i][/b]'; [/noparse] 

$bbcode = new vB_BbCodeParser($vbulletin,fetch_tag_list());

$template_var = $bbcode->do_parse($var); 


This will have a fully parse variable from $var into $template_var. You could change any of my variable names if needed.

How add tempate to $template_var ?
My output template's name TEST.

This code I add at first srcipt:

require('includes/class_bbcode.php'); 
$var = '[b][i][u]HA HA[/u][/i][/b]'; 
$bbcode = new vB_BbCodeParser($vbulletin,fetch_tag_list()); 
$template_var = $bbcode->do_parse($var);

It is my last code line:

        while($post = $db->fetch_array($getposts))
                            {
eval('$mini .= "' . fetch_template('mini') . '";');

}

eval('$navbar = "' . fetch_template('navbar') . '";');
eval('print_output("' . fetch_template('TEST') . '");');

When I do:

$mini = $bbcode->do_parse($var);

on the screen display HA HA any other bbc code example [b][/b] no parse

[King Kovifor]

What you need to do is this:

PHP Code:

while($post = $db->fetch_array($getposts))
{
    $minis = $bbcode->do_parse($var);
    eval('$mini .= "' . fetch_template('mini') . '";');
} 


Then, in your "mini" template, you will need to place $minis. Since $bbcode->do_parse() doesn't parse templates, only strings of text.