Calling all code junkies and webmasters. [Archive]

Volvagia70364

07-03-2004, 10:09 AM

Im putting together a website, and I was wondering exactly how you get posts from the message board into your home page like what EQEMU does with their news postings. I am completely new to phpBB and have only medicore HTML skills so go easy on me. :lol:

Thanks in advance for any help.

x-scythe

07-03-2004, 10:22 AM

i dont know if this is how EQEmu does it but this is how i did it on my website.

just create a table on your main page and write your news post in it and put a header on the top saying the subject, and whatever else you want on it. and just add a link to the same thread on your forum.

Volvagia70364

07-03-2004, 02:13 PM

Yeah, I suppose that could work, but I was hoping for the more elegant solution of simply being able to post instead of delving into the code at every update. I'll see what I can come up with over at the phpBB support pages.

In the meantime, can anyone tell me if phpBB and phpNuke can be used side by side? I heard that phpBB has the better forum coding while Nuke has the better website side intergration. Is the bit about the coding true or not? Etc. A listing of the differences between the two would be extremely helpful.

dragonflz

07-04-2004, 04:37 AM

check out this CMS...
I have built a lot of websites with it, and it works very well

http://www.xoops.org/

Drag

Spike

07-04-2004, 05:53 PM

Or, we could just use this LOL!!!

This is a simple news page, which you can put on your phpBB. It uses your template and is very easy to use. It has 3 pre-made HTML Tables that you can add your news in. Just copy and paste for more news.

CLICK HERE TO DOWNLOAD NOW! (http://www.phpbbhacks.com/downloads/922.zip)

BTW - What do I get for doing this?

If this webpage works, use it cause this one is better... (http://www.snation.co.uk)

news.php
<?php
define ('IN_PHPBB', true);

$phpbb_root_path = str_replace('\\', '/', dirname(__FILE__)) . '/';
include($phpbb_root_path . 'extension.inc');
include_once ($phpbb_root_path . 'includes/news_header.'.$phpEx);

$template = new Template($news_template);

$template->set_filenames(array(
'body' => 'news.tpl'
));

$template->assign_vars(tpl_vars());

// Get the news posts

$news_sort = false;

$news_display['announcement'] = news_id_array('2');
$news_display['sticky'] = news_id_array('1');
$news_display['normal'] = news_id_array('0');

//
// Announcements
//

if( $news_display['announcement'] )
{
$template->assign_block_vars('announcement',array());
for($i = 0; $i < count($news_display['announcement']); $i++)
{
$news_post = get_post($news_display['announcement'][$i]);

$template->assign_block_vars('announcement.news',post_vars($n ews_post, $news_user));
if( $news_post['vote_text'] )
{
$template->assign_block_vars('announcement.news.switch_poll', array());
}
if( $news_post['avatar'] )
{
$template->assign_block_vars('announcement.news.switch_avatar ',array());
}
else
{
$template->assign_block_vars('announcement.news.switch_no_ava tar',array());
}
}
}

//
// Sticky News
//

if( $news_display['sticky'] )
{
$template->assign_block_vars('sticky',array());
for($i = 0; $i < count($news_display['sticky']); $i++)
{
$news_post = get_post($news_display['sticky'][$i]);

$template->assign_block_vars('sticky.news',post_vars($news_po st, $news_user));

if( $news_post['vote_text'] )
{
$template->assign_block_vars('sticky.news.switch_poll',array( ));
}

if( $news_post['avatar'] )
{
$template->assign_block_vars('sticky.news.switch_avatar',arra y());
}
else
{
$template->assign_block_vars('sticky.news.switch_no_avatar',a rray());
}
}
}

//
// Normal News
//

if( $news_display['normal'] )
{
$template->assign_block_vars('normal',array());
for($i = 0; $i < count($news_display['normal']); $i++)
{
$news_post = get_post($news_display['normal'][$i]);

$template->assign_block_vars('normal.news',post_vars($news_po st, $news_user));
if( $news_post['vote_text'] )
{
$template->assign_block_vars('normal.news.switch_poll',array( ));
}

if( $news_post['avatar'] )
{
$template->assign_block_vars('normal.news.switch_avatar',arra y());
}
else
{
$template->assign_block_vars('normal.news.switch_no_avatar',a rray());
}
}
}

//
// Finalise Outputs
//

if( ( !$news_display['announcement'] && !$news_display['sticky'] && !$news_display['normal'] ) || ( !$HTTP_GET_VARS[POST_NEWS_URL] && !$news_display['normal'] ) )
{
$template->assign_block_vars('no_news',array());
}

$template->pparse('body');

?>&nbsp;</th>
</tr>
</table>

news_install.php
<?php
$tablename = 'news';

// ******************* NO EDITING BELOW THIS LINE *******************

$eipver = '6.1.0';

// connect to phpbb
include('./config.php');

$cnx = mysql_connect($dbhost, $dbuser, $dbpasswd)
or die("Unable to connect to database server.");
mysql_select_db($dbname, $cnx)
or die("Unable to select database.");

$sql1 = "CREATE TABLE ". $table_prefix.$tablename ." (
config_name varchar(255) NOT NULL default '',
config_value varchar(255) NOT NULL default '',
PRIMARY KEY (config_name)
) TYPE=MyISAM";

$result = mysql_query($sql1);

echo "<HTML><HEAD><TITLE>Installing: NEWS BLOCK ".$eipver."</TITLE></HEAD>";
echo "<BODY>";

if(!$result)
echo "Install failed ";
if (mysql_error()) { echo "Error Report: ".mysql_error()." "; }
else {
echo "Install complete, new values added. Please remember to delete this file ASAP.";

}
echo "<BODY></HTML>";

$sql2 = 'INSERT INTO ' . $table_prefix.$tablename . "(config_name, config_value)
VALUES ('news_block', ''),
('news_title', ''),
('news_color', ''),
('news_style', ''),
('news_bold', ''),
('news_ital', ''),
('news_under', ''),
('news_size', ''),
('scroll_speed', ''),
('scroll_action', ''),
('scroll_behavior', ''),
('scroll_size', '')";
$result = mysql_query($sql2);

echo "<HTML><HEAD><TITLE>Installing: NEWS BLOCK ".$eipver."</TITLE></HEAD>";
echo "<BODY>";

if(!$result)
echo "Install failed ";
if (mysql_error()) { echo "Error Report: ".mysql_error()." "; }
else {
echo "Install complete, new values added. Please remember to delete this file ASAP.";

}
echo "<BODY></HTML>";
exit;
?>

language/lang_english/lang_news.php
<?php

$lang['Announcement'] = 'Announcements';
$lang['Closed'] = 'Closed';
$lang['Code'] = 'Code';
$lang['Comment'] = 'Comment';
$lang['Comments'] = 'Comments';
$lang['Email'] = 'Email';
$lang['Guest'] = 'Guest';
$lang['Hidden'] = 'Hidden';
$lang['No'] = 'No';
$lang['No_News'] = 'There is currently no news to display.';
$lang['Normal_News'] = 'Normal News';
$lang['Offline'] = 'Offline';
$lang['Online'] = 'Online';
$lang['PM'] = 'PM';
$lang['Poll'] = 'Poll';
$lang['Poll_results'] = 'Results';
$lang['Profile'] = 'Profile';
$lang['Quote'] = 'Quote';
$lang['Reply'] = 'Reply';
$lang['Sticky'] = 'Sticky News';
$lang['Time_zone'] = 'All times are GMT';
$lang['View_full_news'] = 'View Full Article';
$lang['View_text'] = 'View All News';
$lang['Vote'] = 'Vote';
$lang['Web'] = 'Website';
$lang['wrote'] = 'wrote';

// Errors
$lang['Denied'] = 'Error Loading forum information: The forum this script is trying to access is not viewable to guests.';
$lang['Error_performing'] = 'Error Performing';
$lang['Extension'] = 'The extension.inc file of your phpbb installation cannot be found. It is possible the news files have been placed in a mis-named folder. This script is looking for the file';
$lang['Message_die'] = 'Error Processing message_die(): A message_die() was called with an undefined type.';
$lang['Moved'] = 'The topic beging shown has been moved, therefore there is an error in the SQL for get_query.';
$lang['News_forum_uninstalled'] = 'The news table has not been Installed. Please install it via the News Configuration page in the Admin Control Panel';
$lang['Occured'] = 'This error occured in';
$lang['on_line'] = 'on line';
$lang['Query'] = 'Query';
$lang['News_no_forum_id'] = 'Error: There is no forum ID set in your settings or an invalid forum ID has been entered where guests cannot read the forum.';
$lang['tpl_error'] = 'Unable to locate template files. bbcode.tpl, headlines.tpl and news.tpl all should be in a folder called `news` in the default template of the forum or subSilver';

?>

admin/admin_news.php
<?php

define('IN_PHPBB', 1);

if( !empty($setmodules) )
{
$file = basename(__FILE__);
$module['News']['Configuration'] = "$file";
return;
}

//
// Let's set the root dir for phpBB
//
$phpbb_root_path = "./../";
require($phpbb_root_path . 'extension.inc');
require('./pagestart.' . $phpEx);
include($phpbb_root_path . 'includes/functions_selects.'.$phpEx);

function install_config($config_name, $config_value = '')
{
global $db, $dbms;

$sql = "SELECT config_name FROM " . CONFIG_TABLE . " WHERE config_name='" . $config_name . "'";

$result = $db->sql_query($sql);

if ($db->sql_numrows($result) != 0)
{
return;
}

// Write new config variable

$sql = "INSERT INTO " . CONFIG_TABLE . " (config_name, config_value) VALUES ('" . $config_name . "', '" . $config_value . "');";

if ( ($dbms == 'mssql') || ($dbms == 'mssql-odbc') )
{
$sql .= "GO;";
}

// Execute the new variable

if( !($result = $db->sql_query($sql)) )
{
message_die(GENERAL_ERROR, "Failed to install news configuration setting", "", __LINE__, __FILE__, $sql);
}

return;
}

//
// Install the table when prompted
//
if( !empty($_GET['install']) && empty($board_config['news_installed']) )
{
install_config("news_installed", "1");
install_config("news_no", "1");
install_config("news_acro", "24");
install_config("news_forum_id", "1");
install_config("news_dateformat", "");
install_config("news_limit", "");
install_config("news_date_limit", "");
install_config("headline_dateformat", "");
install_config("headline_limit", "");
install_config("headline_date_limit", "");
install_config("news_view_full_url", "index.php?newsid={ID}");
install_config("news_links", "<a href=\'{URL}\' target=\'_blank\'>{TEXT}</a>");
install_config("news_announcements", "2");
install_config("news_sticky", "2");
install_config("headline_announcements", "2");
install_config("headline_sticky", "2");

$message = $lang['News_updated'] . " " . sprintf($lang['Click_return_news'], "<a href=\"" . append_sid("admin_news.$phpEx") . "\">", "</a>") . " " . sprintf($lang['Click_return_admin_index'], "<a href=\"" . append_sid("index.$phpEx?pane=right") . "\">", "</a>");
message_die(GENERAL_MESSAGE, $message);
}

//
// If its not installed, and we've not prompted it, prompt!
//

if( empty($board_config['news_installed']) )
{
$message = $lang['Table_unpopulated'] . " " . sprintf($lang['Click_install_news'], "<a href=\"" . append_sid("admin_news.$phpEx?install=1") . "\">", "</a>") . " " . sprintf($lang['Click_return_admin_index'], "<a href=\"" . append_sid("index.$phpEx?pane=right") . "\">", "</a>");
message_die(GENERAL_MESSAGE, $message);
}

//
// Stop the user from setting a forum_id of nothing and check if its valid
//

if( empty($HTTP_POST_VARS['news_forum_id']) )
{
unset($HTTP_POST_VARS['news_forum_id']);
}
else
{
$sql = "SELECT * FROM " . USERS_TABLE . " WHERE user_id = " . ANONYMOUS;
if ( !($user_result = $db->sql_query($sql)) )
{
message_die(CRITICAL_ERROR, 'Could not obtain user data from user table', '', __LINE__, __FILE__, $sql);
}
$userdataguest = $db->sql_fetchrow($user_result);
$db->sql_freeresult($user_result);

$auth_ary = auth(AUTH_READ, $HTTP_POST_VARS['news_forum_id'], $userdataguest);

if ( empty($auth_ary['auth_read']) )
{
unset($HTTP_POST_VARS['news_forum_id']);
}
}

//
// Pull all config data
//
$sql = "SELECT *
FROM " . CONFIG_TABLE;
if(!$result = $db->sql_query($sql))
{
message_die(CRITICAL_ERROR, "Could not query config information in admin_news", "", __LINE__, __FILE__, $sql);
}
else
{
while( $row = $db->sql_fetchrow($result) )
{
$config_name = $row['config_name'];
$config_value = $row['config_value'];
$default_config[$config_name] = $config_value;

$new[$config_name] = ( isset($HTTP_POST_VARS[$config_name]) ) ? $HTTP_POST_VARS[$config_name] : $default_config[$config_name];

if( isset($HTTP_POST_VARS['submit']) )
{
$sql = "UPDATE " . CONFIG_TABLE . " SET
config_value = '" . str_replace("\'", "''", $new[$config_name]) . "'
WHERE config_name = '$config_name'";
if( !$db->sql_query($sql) )
{
message_die(GENERAL_ERROR, "Failed to update news configuration for $config_name", "", __LINE__, __FILE__, $sql);
}
}
}

if( isset($HTTP_POST_VARS['submit']) )
{
$message = $lang['News_updated'] . " " . sprintf($lang['Click_return_news'], "<a href=\"" . append_sid("admin_news.$phpEx") . "\">", "</a>") . " " . sprintf($lang['Click_return_admin_index'], "<a href=\"" . append_sid("index.$phpEx?pane=right") . "\">", "</a>");

message_die(GENERAL_MESSAGE, $message);
}
}

$template->set_filenames(array(
"body" => "admin/news_body.tpl")
);

//
// Escape any quotes in the site description for proper display in the text
// box on the admin page
//
$no_yes = ( $new['news_no'] ) ? "checked=\"checked\"" : "";
$no_no = ( !$new['news_no'] ) ? "checked=\"checked\"" : "";

$na_2 = ( $new['news_announcements'] == '2' ) ? "selected" : "";
$na_1 = ( $new['news_announcements'] == '1' ) ? "selected" : "";
$na_0 = ( !$new['news_announcements'] ) ? "selected" : "";

$ns_2 = ( $new['news_sticky'] == '2' ) ? "selected" : "";
$ns_1 = ( $new['news_sticky'] == '1' ) ? "selected" : "";
$ns_0 = ( !$new['news_sticky'] ) ? "selected" : "";

$ha_2 = ( $new['headline_announcements'] == '2' ) ? "selected" : "";
$ha_1 = ( $new['headline_announcements'] == '1' ) ? "selected" : "";
$ha_0 = ( !$new['headline_announcements'] ) ? "selected" : "";

$hs_2 = ( $new['headline_sticky'] == '2' ) ? "selected" : "";
$hs_1 = ( $new['headline_sticky'] == '1' ) ? "selected" : "";
$hs_0 = ( !$new['headline_sticky'] ) ? "selected" : "";

$new['links'] = str_replace('"', '&quot;', $new['links']);
$template->assign_vars(array(
"S_CONFIG_ACTION" => append_sid("admin_news.$phpEx"),

"L_NEWS_CONFIG_TITLE" => $lang['News_Config'],
"L_NEWS_EXPLAIN" => $lang['News_explain'],
"L_NEWS_SETTINGS" => $lang['News_settings'],
"L_FULL_ARTICLE_SETTINGS" => $lang['Full_article_settings'],
"L_HEADLINE_SETTINGS" => $lang['Headline_settings'],

"S_NO_YES" => $no_yes,
"S_NO_NO" => $no_no,

"S_NA_2" => $na_2,
"S_NA_1" => $na_1,
"S_NA_0" => $na_0,

"S_NS_2" => $ns_2,
"S_NS_1" => $ns_1,
"S_NS_0" => $ns_0,

"S_HA_2" => $ha_2,
"S_HA_1" => $ha_1,
"S_HA_0" => $ha_0,

"S_HS_2" => $hs_2,
"S_HS_1" => $hs_1,
"S_HS_0" => $hs_0,

"L_SUBMIT" => $lang['Submit'],
"L_RESET" => $lang['Reset'],
"L_NEWS_FORUM" => $lang['news_forum'],
"L_NEWS_FORUM_MORE" => $lang['news_forum_more'],
"L_NEWS_FORUM_MORE_2" => $lang['news_forum_more_error'],
"L_NEWS_DATE" => $lang['Date_format'],
"L_NEWS_DATE_MORE" => $lang['Date_format_explain'],
"L_NEWS_DATE_MORE_2" => $lang['news_dateformat_more'],
"L_NEWS_LIMIT" => $lang['news_limit'],
"L_NEWS_LIMIT_MORE" => $lang['news_limit_more'],
"L_NEWS_DATE_LIMIT" => $lang['news_date_limit'],
"L_NEWS_DATE_LIMIT_MORE" => $lang['news_date_limit_more'],
"L_ACRO" => $lang['acro'],
"L_ACRO_MORE" => $lang['acro_more'],
"L_VIEW_FULL_URL" => $lang['view_full_url'],
"L_VIEW_FULL_URL_MORE" => $lang['view_full_url_more'],
"L_LINK_FORMAT" => $lang['link_format'],
"L_LINK_FORMAT_MORE" => $lang['link_format_more'],
"L_NO" => $lang['news_no'],
"L_NO_MORE" => $lang['news_no_more'],
"L_NEWS_STICKY" => $lang['news_sticky'],
"L_NEWS_STICKY_MORE" => $lang['news_sticky_more'],
"L_NEWS_ANNOUNCE" => $lang['news_announce'],
"L_NEWS_ANNOUNCE_MORE" => $lang['news_announce_more'],
"L_DISPLAY_2" => $lang['display_2'],
"L_DISPLAY_1" => $lang['display_1'],
"L_DISPLAY_0" => $lang['display_0'],

"NEWS_FORUM" => $new['news_forum_id'],
"NEWS_DATE_FORMAT" => $new['news_dateformat'],
"NEWS_LIMIT" => $new['news_limit'],
"NEWS_DATE_LIMIT" => $new['news_date_limit'],
"HEADLINE_DATE_FORMAT" => $new['headline_dateformat'],
"HEADLINE_LIMIT" => $new['headline_limit'],
"HEADLINE_DATE_LIMIT" => $new['headline_date_limit'],
"ACRO" => $new['news_acro'],
"VIEW_FULL" => $new['news_view_full_url'],
"LINK_FORMAT" => $new['news_links'],
)

);

$template->pparse("body");

include('./page_footer_admin.'.$phpEx);

?>

templates/subSilver/news/news.tpl
 
<h4 align="center">{L_ANNOUNCEMENT}</h4>



<table width='100%' border='0' cellspacing='2' cellpadding='4'>
<tr>
<td width='0'><img src='images/news/bulliten.gif' width='9' height='9'></td>
<td width='100%'><a name='{announcement.news.NEWS_ID}'>{announcement.news.TITLE}</a></td>
</tr>
<tr>
<td width='0' height="0">&nbsp;</td>
<td width='100%' height="0">&nbsp;{announcement.news.TIME}</td>
</tr>
<tr>
<td width='0' height="113">&nbsp;</td>
<td width='100%'><table width="100%" border="0" align="right" cellpadding="4" cellspacing="2">
<tr valign="top">
<td rowspan="2" align="center" nowrap>{announcement.news.POSTER} 
{announcement.news.POSTER_RANK} 
 

<img src="{announcement.news.AVATAR}">

</td>
<td width="100%" height="100%">{announcement.news.TEXT}</td>

<td rowspan="2" nowrap><div align="center"> {L_POLL} 
 
{announcement.news.POLL_DESC} 
 
{announcement.news.VOTE} 
 
{announcement.news.RESULTS} 
<img src="http://forums.snation.co.uk/snn/images/70x1.gif" height="1" width="100" border="0">
</div></td>

</tr>
<tr valign="top">
<td width="100%" height="44" valign="bottom">
{announcement.news.POSTER_ONLINE} {announcement.news.POSTER_PROFILE}
{announcement.news.POSTER_EMAIL} {announcement.news.POSTER_PM} {announcement.news.POSTER_WEB}
{announcement.news.ADD_COMMENT} </td>
</tr>
</table>
 </td>
</tr>
<tr>
<td colspan='2'> <div align='right'>
[ <a href="{announcement.news.U_COMMENTS}"> {announcement.news.L_COMMENT_COUNT}
{announcement.news.L_COMMENT}</a> ] </div></td>
</tr>
<tr>
<td height='27' colspan='2'>&nbsp;</td>
</tr>
</table>




 

<h4 align="center">{L_STICKY}</h4>



<table width='100%' border='0' cellspacing='2' cellpadding='4'>
<tr>
<td width='0'><img src='images/news/bulliten.gif' width='9' height='9'></td>
<td width='100%'><a name='{sticky.news.NEWS_ID}'>{sticky.news.TITLE}</a></td>
</tr>
<tr>
<td width='0' height="0">&nbsp;</td>
<td width='100%' height="0">&nbsp;{sticky.news.TIME}</td>
</tr>
<tr>
<td width='0' height="113">&nbsp;</td>
<td width='100%'><table width="100%" border="0" align="right" cellpadding="4" cellspacing="2">
<tr valign="top">
<td rowspan="2" align="center" nowrap>{sticky.news.POSTER} 
{sticky.news.POSTER_RANK} 
 

<img src="{sticky.news.AVATAR}">

</td>
<td width="100%" height="100%">{sticky.news.TEXT}</td>

<td rowspan="2" nowrap><div align="center"> {L_POLL} 
 
{sticky.news.POLL_DESC} 
 
{sticky.news.VOTE} 
 
{sticky.news.RESULTS} 
<img src="http://forums.snation.co.uk/snn/images/70x1.gif" height="1" width="100" border="0">
</div></td>

</tr>
<tr valign="top">
<td width="100%" height="44" valign="bottom">
{sticky.news.POSTER_ONLINE} {sticky.news.POSTER_PROFILE} {sticky.news.POSTER_EMAIL}
{sticky.news.POSTER_PM} {sticky.news.POSTER_WEB} {sticky.news.ADD_COMMENT}
</td>
</tr>
</table>
 </td>
</tr>
<tr>
<td colspan='2'> <div align='right'>
[ <a href="{sticky.news.U_COMMENTS}"> {sticky.news.L_COMMENT_COUNT} {sticky.news.L_COMMENT}</a>
] </div></td>
</tr>
<tr>
<td height='27' colspan='2'>&nbsp;</td>
</tr>
</table>




 

<h4 align="center">{L_NORMAL}</h4>



<table width='100%' border='0' cellspacing='2' cellpadding='4'>
<tr>
<td width='0'><img src='images/news/bulliten.gif' width='9' height='9'></td>
<td width='100%'><a name='{normal.news.NEWS_ID}'>{normal.news.TITLE}</a></td>
</tr>
<tr>
<td width='0' height="0">&nbsp;</td>
<td width='100%' height="0">&nbsp;{normal.news.TIME}</td>
</tr>
<tr>
<td width='0' height="113">&nbsp;</td>
<td width='100%'><table width="100%" border="0" align="right" cellpadding="4" cellspacing="2">
<tr valign="top">
<td rowspan="2" align="center" nowrap>{normal.news.POSTER} 
{normal.news.POSTER_RANK} 
 

<img src="{normal.news.AVATAR}">

</td>
<td width="100%" height="100%">{normal.news.TEXT}</td>

<td rowspan="2" nowrap><div align="center"> {L_POLL} 
 
{normal.news.POLL_DESC} 
 
{normal.news.VOTE} 
 
{normal.news.RESULTS} 
<img src="http://forums.snation.co.uk/snn/images/70x1.gif" height="1" width="100" border="0">
</div></td>

</tr>
<tr valign="top">
<td width="100%" height="44" valign="bottom">
{normal.news.POSTER_ONLINE} {normal.news.POSTER_PROFILE} {normal.news.POSTER_EMAIL}
{normal.news.POSTER_PM} {normal.news.POSTER_WEB} {normal.news.ADD_COMMENT}
</td>
</tr>
</table>
 </td>
</tr>
<tr>
<td colspan='2'> <div align='right'>
[ <a href="{normal.news.U_COMMENTS}"> {normal.news.L_COMMENT_COUNT} {normal.news.L_COMMENT}</a>
] </div></td>
</tr>
<tr>
<td height='27' colspan='2'>&nbsp;</td>
</tr>
</table>




 

<h4 align="center">{L_NORMAL} 
 
{L_NO_NEWS}</h4>



<table width="100%" border="0" cellspacing="3" cellpadding="3">
<tr>
<td><a href="{U_BOARD}">{L_VIEW_TEXT}</a></td>
<td><div align="right">{L_TIME_ZONE}
{S_TD}</div></td>
</tr>
</table>
 


templates/subSilver/news/headlines.tpl




<a href="{announcement.news.U_VIEW_FULL}" title="{announcement.news.TITLE}">{announcement.news.ACRO}</a> 
&nbsp;&nbsp;&nbsp; - {announcement.news.TIME} [{announcement.news.POSTER}] 







<a href="{sticky.news.U_VIEW_FULL}" title="{sticky.news.TITLE}">{sticky.news.ACRO}</a> 
&nbsp;&nbsp;&nbsp; - {sticky.news.TIME} [{sticky.news.POSTER}] 







<a href="{normal.news.U_VIEW_FULL}" title="{normal.news.TITLE}">{normal.news.ACRO}</a> 
&nbsp;&nbsp;&nbsp; - {normal.news.TIME} [{normal.news.POSTER}] 





{L_NO_NEWS}


 
&nbsp; [ <a href="{U_BOARD}">{L_VIEW_TEXT}</a> ]

templates/subSilver/news/bbcode.tpl

<ul>
</ul>

<ol type="{LIST_TYPE}">
</ol>

<li>


<table width="90%" cellspacing="1" cellpadding="3" border="0" align="center">
<tr>
<td>{USERNAME} {L_WROTE}:</td>
</tr>
<tr>
<td class="quote">

<table width="90%" cellspacing="1" cellpadding="3" border="0" align="center">
<tr>
<td>{L_QUOTE}:</td>
</tr>
<tr>
<td class="quote">
</td>
</tr>
</table>



<table width="90%" cellspacing="1" cellpadding="3" border="0" align="center">
<tr>
<td>{L_CODE}:</td>
</tr>
<tr>
<td class="code">
</td>
</tr>
</table>

















<img src="{URL}" border="0" />

<a href="{URL}" target="_blank" class="postlink">{DESCRIPTION}</a>

<a href="mailto:{EMAIL}">{EMAIL}</A>

A good example of another webpage that automatically takes the post information and automatically puts it on the homepage would be www.roar.5u.com (webpage I built)

Volvagia70364

07-05-2004, 08:39 AM

Thanks, thats pretty much what I was looking for

Rogean

07-05-2004, 09:59 AM

Wow Spike, that was so unnecessary.

Heres what I coded for the eqemulator site.

<?
// Main.php by Rogean
require('forums/config.php');
mysql_connect($dbhost, $dbuser, $dbpasswd);
@mysql_select_db("$dbname")or die(mysql_error());

//GET FORUM NEWS
$getnews=mysql_query("SELECT topic_id,forum_id,topic_title,topic_poster,topic_t ime,topic_views,topic_replies,topic_first_post_id FROM phpbb_topics WHERE forum_id='11' ORDER by topic_time DESC LIMIT 4");
while(list($topic[id],$forum[id],$topic[title],$to pic[poster],$topic[time],$topic[views],$topic[repl ies],$topic[firstpostid])=mysql_fetch_row($getnews )){

$newsbody=mysql_query("SELECT * FROM phpbb_posts_text WHERE post_id=$topic[firstpostid]");
$text=mysql_fetch_array($newsbody);

$userinfo=mysql_query("SELECT * FROM phpbb_users WHERE user_id=$topic[poster]");
$user=mysql_fetch_array($userinfo);

$text[post_text]=str_replace("\n", " ", $text[post_text]);
$text[post_text]=str_replace("[b]", "", $text[post_text]);
$text[post_text]=str_replace("[/b]", "", $text[post_text]);
$text[post_text]=str_replace("[i]", "", $text[post_text]);
$text[post_text]=str_replace("[/i]", "", $text[post_text]);
$text[post_text]=str_replace("&lt;", "<", $text[post_text]);
$text[post_text]=str_replace("&gt;", ">", $text[post_text]);

echo "<div class=\"content\">
$text[post_subject] 
Posted by: $user[username] :: $topic[replies] Replies :: $topic[views] Views 
$text[post_text]
</div>
<hr width=80% color=darkblue align=left>";
}
?>

Modified it to use an echo instead of what we use on the eqemu site.

Replace 11 in the first query with the forum id your pulling news from.

hlf

08-18-2004, 05:35 PM

thanks for sharing that Rogean.

i have a question though, how do you make the display truncated like on the eqemu's main page?

"Newest Topics
- where did it go..."

mattmeck

08-18-2004, 06:40 PM

WOOT lets bump old posts!!!