<?php
define('IN_PHPBB', true);
$phpbb_root_path = './';
include($phpbb_root_path . 'extension.inc');
include($phpbb_root_path . 'common.'.$phpEx);
//
// Start session management
//
$userdata = session_pagestart($user_ip, PAGE_VIEWMEMBERS);
init_userprefs($userdata);
//
// End session management
//
$sql = "SELECT column_name FROM " . CONSTANT_WITH_THE_NAME_OF_THE_TABLE . " WHERE column_operator_value";
//the constants with table names are stored in includes/constants.php
//i.e.: " . POSTS_TABLE . "
if( !($result = $db->sql_query($sql)) )
//if the query fails it shows the error
{
message_die(GENERAL_ERROR, 'Could not query posts table', '', __LINE__, __FILE__, $sql);
}
//otherwise
$result = $db->sql_query($sql);
//YOUR SCRPT ($var = ... $var1 = ...)
//this frees the used and useless resources
$db->sql_freeresult($result);
//
// Generate page
//
$page_title = "Page Title";
include($phpbb_root_path . 'includes/page_header.'.$phpEx);
//here we set the tpl file name where parsing the page
$template->set_filenames(array(
'body' => 'new_page.tpl')
);
$template->assign_vars(array(
'VAR' => $var,
'VAR1' => $var1
));
$template->pparse('body');
include($phpbb_root_path . 'includes/page_tail.'.$phpEx);
?>
define('IN_PHPBB', true);
$phpbb_root_path = './';
include($phpbb_root_path . 'extension.inc');
include($phpbb_root_path . 'common.'.$phpEx);
//
// Start session management
//
$userdata = session_pagestart($user_ip, PAGE_VIEWMEMBERS);
init_userprefs($userdata);
//
// End session management
//
$sql = "SELECT column_name FROM " . CONSTANT_WITH_THE_NAME_OF_THE_TABLE . " WHERE column_operator_value";
//the constants with table names are stored in includes/constants.php
//i.e.: " . POSTS_TABLE . "
if( !($result = $db->sql_query($sql)) )
//if the query fails it shows the error
{
message_die(GENERAL_ERROR, 'Could not query posts table', '', __LINE__, __FILE__, $sql);
}
//otherwise
$result = $db->sql_query($sql);
//YOUR SCRPT ($var = ... $var1 = ...)
//this frees the used and useless resources
$db->sql_freeresult($result);
//
// Generate page
//
$page_title = "Page Title";
include($phpbb_root_path . 'includes/page_header.'.$phpEx);
//here we set the tpl file name where parsing the page
$template->set_filenames(array(
'body' => 'new_page.tpl')
);
$template->assign_vars(array(
'VAR' => $var,
'VAR1' => $var1
));
$template->pparse('body');
include($phpbb_root_path . 'includes/page_tail.'.$phpEx);
?>
Then must create the tpl file (new_page.tpl in this case)
- <table width="100%" border="0" class="forumline">
- <tr>
- <td><b>{VAR}</b></td>
- </tr>
- </table>
And how can I show the Icy Phoenix Main Links menù?
Using this in your template: