The Arcive of Official vBulletin Modifications Site.

error_22 · #1 09-10-2006, 04:46 AM

Hi,

I have this script which calls html codes from a database:

PHP Code:


			
$sql = "SELECT * FROM `plugin_frontpage`";

$result = mysql_query($sql) or die(mysql_error());

while ($row = mysql_fetch_object($result))

{    

    $pf_content = $row->pf_content;

}

The above is stored in a file called plugins.php. Now, theres only one row in that table, and it contains the following html code:

HTML Code:

<html>
<head>
<title>En Testsida</title>
</head>
<body><h1>En Testsida</h1><hr>
Nyheter:<br />
<br />
<b>$pfn_title</b><br />
$pfn_content<br />
<br />
</body>
</html>

As you see, there are 2 variables in that html code, and they come from the following mysql query, which is placed in the same file as the first query, i should also add that its placed above the first query:

PHP Code:


			
$sql = "SELECT * FROM `plugin_frontpage_news` ORDER BY `pfn_id` DESC";

$result = mysql_query($sql) or die(mysql_error());

while ($row = mysql_fetch_object($result))

{

    $pfn_title = $row->pfn_title;

    $pfn_content = $row->pfn_content;

}

plugins.php is called by a file called index.php and the variable "$pf_content" is being printed there.

Now to the problem: The two variables that are stored in the plugin_frontpage table wont be replaced with the content in the plugin_frontpage_news table. The html codes work just fine, but the varibles are just being printed as they are, not with its content. What am I doing wrong? I know its possible, vBulletin works the same way. All templates contains variables.

Thanks in advance!

Niklas

Adrian Schneider · #2 09-10-2006, 07:00 AM

Hi,

You will probably want to use some vBulletin's database object as well as template system - it will make things much easier. You are actually looking to append the data, rather than replace it each time. In my below example I use .= instead of = to add it to the end of the variable.

PHP Code:


			
$result = $db->query_read("

    SELECT *

    FROM plugin_frontpage_news

    ORDER BY pfn_id DESC

");



$newsbits = '';

while ($item = $db->fetch_array($result))

{

    $newsbits .= "<strong>$item[pfn_title]</strong><br />$pfn_content<br /><br />";

    

    // or below, and have your HTML as it is above in a template

    eval('$newsbits .= "' . fetch_template('your_newsbit_template') . '";');

}



eval('print_output("' . fetch_template('your_news_template') . '");');

error_22 · #3 09-10-2006, 01:58 PM

actually, this isnt for vBulletin. Thanks a lot for replying.

Niklas

Adrian Schneider · #4 09-10-2006, 06:27 PM

PHP Code:


			
result = mysql_query("
    SELECT *
    FROM plugin_frontpage_news
    ORDER BY pfn_id DESC
") or die(mysql_error());

$newsbits = '';
while ($item = mysql_fetch_assoc($result))
{
    $newsbits .= "<strong>$item[pfn_title]</strong><br />$pfn_content<br /><br />";
}

// now $newsbits contains the database data displayed how you want

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.04529 seconds Memory Usage 2,203KB Queries Executed 11 (?)
More Information
Template Usage: (1)SHOWTHREAD (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)ad_showthread_beforeqr (1)ad_showthread_firstpost (1)ad_showthread_firstpost_sig (1)ad_showthread_firstpost_start (1)bbcode_html (4)bbcode_php (1)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)navbar (3)navbar_link (120)option (4)post_thanks_box (4)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (4)post_thanks_postbit_info (4)postbit (4)postbit_onlinestatus (4)postbit_wrapper (1)spacer_close (1)spacer_open (1)tagbit_wrapper Phrase Groups Available: global inlinemod postbit posting reputationlevel showthread	Included Files: ./showthread.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/functions_bigthree.php ./includes/class_postbit.php ./includes/class_bbcode.php ./includes/functions_reputation.php ./includes/functions_post_thanks.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 showthread_start showthread_getinfo forumjump showthread_post_start showthread_query_postids showthread_query bbcode_fetch_tags bbcode_create showthread_postbit_create postbit_factory postbit_display_start post_thanks_function_post_thanks_off_start post_thanks_function_post_thanks_off_end post_thanks_function_fetch_thanks_start post_thanks_function_fetch_thanks_end post_thanks_function_thanked_already_start post_thanks_function_thanked_already_end fetch_musername postbit_imicons bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete postbit_display_complete post_thanks_function_can_thank_this_post_start tag_fetchbit_complete forumrules navbits navbits_complete showthread_complete
Messages:

The Arcive of Official vBulletin Modifications Site.

It is not a VB3 engine, just a parsed copy!