Page 2 of 2

Re: phpbb Displaying topics from external pages

Posted: Sun Apr 25, 2010 5:48 am
by battye
I would try moving all of your HTML header info (which is at the top of your newsfeed.php file) into the newsfeed.html file. You may need to reinstate page_footer(); in the newsfeed.php come to think of it.

Ideally you want as little HTML as possible in your PHP file.

Re: phpbb Displaying topics from external pages

Posted: Sun Apr 25, 2010 9:04 pm
by frozensun
alright, but how do I integrate the information that comes from newsfeed.php into newsfeed.html, and still format it to streamline with the page?

Re: phpbb Displaying topics from external pages

Posted: Mon Apr 26, 2010 2:06 pm
by battye
Have a look at this page:

http://wiki.phpbb.com/Tutorial.Template_syntax

So if you were inside a loop (and I saw a few foreach loops in your php page) you would use:

Code: Select all

    $template->assign_block_vars('loopname', array(
        'EXAMPLE' => 'Some message or even a bit of HTML code here',
    ));
And then you can call that in your HTML file by including:

Code: Select all

<!-- BEGIN loopname -->
Output: {loopname.EXAMPLE}
<!-- END loopname -->
If you want to add a templating variable that is NOT in a loop, see http://wiki.phpbb.com/Tutorial.Template ... #Variables - you simply call that in the HTML page with {FOO} {BAR} and {BAZ}

At the top and bottom of your HTML page include overall_header.html and overall_footer.html respectively

Once you have transferred all of your HTML code from the PHP file into the HTML file, then you can add back page_header() and page_footer() [as it won't give errors once the HTML is removed] to your PHP file and you will have retained your layout so it is consistent with the forum.

I'm don't know how familiar you are with PHP so I am happy to help you further and walk you through it if you want - I just quickly wrote this now to start you off on the right foot as you might want to play around with the code between now and tomorrow (when I will be online next).

Re: phpbb Displaying topics from external pages

Posted: Tue Jul 27, 2010 3:26 pm
by Mary17
battye wrote:I still can't see any errors on http://www.7cr9.com/exp1.php. Can you tell me what the error is that you see on http://www.7cr9.com/exp1.php :?: :)

Hey there, so what's really going on is:

On the page there aren't errors from the code itself, but on 7cr9.com/exp1.php (which I manage through frontpage) I have other php codes as the one of cutenews, which doesn't appear, as well as many other stuff. The site should have this aspect: http://7cr9.com/Home.php but with the "last topics" thing on the same place as in 7cr9.com/exp1.php , do you understand?

The codes of these two pages are exatcly the same, the only difference is that in 7cr9.com/exp1.php it has the topics code which makes many other stuff just disappear...


I read somewhere that maybe I had to integrate this code into frontpage with css. ... Is it right? How is that done?


Thank you very much in advance,
Mary



Just in case I leave you here the full code of 7cr9.com/exp1.php:

<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns="http://www.w3.org/TR/REC-html40">
<?
define('IN_PHPBB', true);
$phpbb_root_path = './forum/'; // Path to phpbb folder
$phpEx = substr(strrchr(__FILE__, '.'), 1);
include($phpbb_root_path . 'common.' . $phpEx);
include($phpbb_root_path . 'includes/functions_display.' . $phpEx);

// Start session management
$user->session_begin();
$auth->acl($user->data);

// Grab user preferences
$user->setup();
?>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<meta name="verify-v1" content="rIWTFpQLuOArySY8IOB8fkfbi9xD7kCgfKc43/tC2xE=" />
<title>7CR9, site fãs de Cristiano Ronaldo CR9 /7 (Cristiano Ronaldo fansite)</title>
<script language="JavaScript">
<!--
// --><script type="text/javascript" src="http://www.haloscan.com/load/mariamsr"> </script>
</script>
<style>
<!--
.ms-simple1-main { border-left-style: none; border-right-style: none;
border-top: 1.5pt solid green; border-bottom: 1.5pt solid green }
.ms-simple1-tl { border-left-style: none; border-right-style: none; border-top-style: none;
border-bottom: .75pt solid green }
.ms-simple1-left { border-style: none }
.ms-simple1-top { border-left-style: none; border-right-style: none; border-top-style: none;
border-bottom: .75pt solid green }
.ms-simple1-even { border-style: none }
-->
</style>
</head>
<meta name="verify-v1" content="eFju5IN4adFN1ySnXJW/xJuer91o13rkr2qn3VmL7wY=" />
<body>

<div style="border:3px double #000000; position: absolute; width: 943px; height: 23px; z-index: 4; left: 25px; top: 577px; visibility:visible; background-color:#000000" id="camada4">
<div style="position: absolute; width: 227px; height: 964px; z-index: 1; left: 782px; top: 94px; background-color:#FFFFFF; background-image:url('../7cr9/Coluna%20Direita.jpeg')" id="camada17">
<div style="position: absolute; width: 111px; height: 100px; z-index: 9; left: 129px; top: -72px" id="camada51">
<div style="position: absolute; width: 100px; height: 99px; z-index: 1; left: -126px; top: 1458px" id="camada52">
&nbsp;<?
/*** phpBB3 - Last Active Topics System ***/
//Show last x topics
define('TOPICS_LIMIT',10);

// Create arrays
$topics = array();

// Get forums that current user has read rights to.
$forums = array_unique(array_keys($auth->acl_getf('f_read', true)));

// Get active topics.
$sql="SELECT *
FROM " . TOPICS_TABLE . "
WHERE topic_approved = '1' AND " . $db->sql_in_set('forum_id', $forums) . "
ORDER BY topic_last_post_time DESC";
$result = $db->sql_query_limit($sql,TOPICS_LIMIT);
while ($r = $db->sql_fetchrow($result))
{
$topics[] = $r;
}
$db->sql_freeresult($result);
?>
<div>
<?

foreach($topics as $t)
{
// Get folder img, topic status/type related information
$topic_tracking_info = get_complete_topic_tracking($t['forum_id'], $t['topic_id']);
$unread_topic = (isset($topic_tracking_info[$t['topic_id']]) && $t['topic_last_post_time'] > $topic_tracking_info[$t['topic_id']]) ? true : false;
$folder_img = $folder_alt = $topic_type = '';
topic_status($t, $t['topic_replies'], $unread_topic, $folder_img, $folder_alt, $topic_type);

// output the link
?>
<img style="vertical-align: text-bottom" src="<?=$user->img($folder_img, $folder_alt, false, '', 'src');?>" title="<?=$user->lang[$folder_alt];?>" alt="<?=$user->lang[$folder_alt];?>" />
<a href="<?=$phpbb_root_path . 'viewtopic.php?f=' . $t['forum_id'] . '&t=' . $t['topic_id'] . '&p=' . $t['topic_last_post_id'] . '#p' . $t['topic_last_post_id'];?>"><?=html_entity_decode($t['topic_title']);?></a><br />
<?
}
?>
</div></div>
<b><font color="#FF6600" face="Arial" size="2">Em reconstrução</font></b></div>
<p style="margin-top: 0; margin-bottom: 0">
&nbsp;</p>
<p style="margin-top: 0; margin-bottom: 0">
&nbsp;</p>
<p style="margin-top: 0; margin-bottom: 0">
&nbsp;</p>
<p style="margin-top: 0; margin-bottom: 0">
<b><i>
<font face="Arial" size="2" color="#FFFFFF">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </font></i></b>
</p>
<div style="position: absolute; width: 197px; height: 259px; z-index: 1; left: 18px; top: 50px" id="camada34">
<p style="margin-top: 0; margin-bottom: 0">
<b><span style="background-color: #000000"><i>
<font face="Arial" size="2" color="#FFFFFF">Vídeos </font></i></span>
<font face="Arial" color="#FFFFFF" size="2">
<span style="background-color: #000000">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
</span> </font></b></p>
<p style="margin-top: 0; margin-bottom: 0">
<b><font face="Arial" color="#800000">- </font>
<font face="Arial" size="2">Making of anúncio BES "I Gotta Feeling" TVI</font></b></p>
<p style="margin-top: 0; margin-bottom: 0">
<b><font face="Arial" color="#800000">- </font>
<font face="Arial" size="2">Entrevista exclusiva TVI 9/4/10</font></b></p>
<p style="margin-top: 0; margin-bottom: 0">
<b><font face="Arial" color="#800000">- </font>
<font face="Arial" size="2">Novo anúncio BES 9/4/10</font></b></p>
<p style="margin-top: 0; margin-bottom: 0">
<b><font face="Arial" color="#800000">- </font>
<font face="Arial" size="2">Conf.imprensa 8/4/10</font></b></p>
<p style="margin-top: 0; margin-bottom: 0">
<b><font face="Arial" color="#800000">- </font>
<font size="2" face="Arial">Racing Santander vs CR</font></b></p>
<p style="margin-top: 0; margin-bottom: 0">
<b><font face="Arial" color="#800000">- </font>
<font face="Arial" size="2">CR vs Atlético Madrid</font></b></p>
<p style="margin-top: 0; margin-bottom: 0">
<b><font face="Arial" color="#800000">- </font>
<font face="Arial" size="2">Getafe vs CR</font></b></p>
<p style="margin-top: 0; margin-bottom: 0">
<b><font face="Arial" color="#800000">- </font>
<font face="Arial" size="2">CR vs Sporting Gijón</font></b></p>
<p style="margin-top: 0; margin-bottom: 0">
&nbsp;</p>
<p style="margin-top: 0; margin-bottom: 0">
&nbsp;</p>
<p style="margin-top: 0; margin-bottom: 0">
&nbsp;</p>
<p style="margin-top: 0; margin-bottom: 0">
&nbsp;</p>
<p style="margin-top: 0; margin-bottom: 0">
&nbsp;</p>
<p style="margin-top: 0; margin-bottom: 0">
&nbsp;</p>
<p style="margin-top: 0; margin-bottom: 0">
&nbsp;</p>
<p style="margin-top: 0; margin-bottom: 0">
&nbsp;</p>
<p style="margin-top: 0; margin-bottom: 0">
&nbsp;</p>
<p style="margin-top: 0; margin-bottom: 0">
&nbsp;</p>
<p style="margin-top: 0; margin-bottom: 0">
&nbsp;</p>
<p style="margin-top: 0; margin-bottom: 0">
&nbsp;</p>
<p style="margin-top: 0; margin-bottom: 0">
&nbsp;</p>
<p style="margin-top: 0; margin-bottom: 0">
&nbsp;</p>
<p style="margin-top: 0; margin-bottom: 0">
&nbsp;</p>
<p style="margin-top: 0; margin-bottom: 0">
&nbsp;</p>
<p style="margin-top: 0; margin-bottom: 0">
&nbsp;</p>
<p style="margin-top: 0; margin-bottom: 0">
&nbsp;</p>
<p style="margin-top: 0; margin-bottom: 0">
&nbsp;</p>
<p style="margin-top: 0; margin-bottom: 0">
&nbsp;</p>
<p>&nbsp;</div>
<p style="margin-top: 0; margin-bottom: 0">
&nbsp;</p>
<p style="margin-top: 0; margin-bottom: 0">
&nbsp;</p>
<p style="margin-top: 0; margin-bottom: 0">
&nbsp;</p>
<p style="margin-top: 0; margin-bottom: 0">
&nbsp;</p>
<p style="margin-top: 0; margin-bottom: 0">
&nbsp;</p>
<p style="margin-top: 0; margin-bottom: 0">
&nbsp;</p>
<p style="margin-top: 0; margin-bottom: 0">
&nbsp;</p>
<p style="margin-top: 0; margin-bottom: 0">
&nbsp;</p>
<p style="margin-top: 0; margin-bottom: 0">
&nbsp;</p>
<p style="margin-top: 0; margin-bottom: 0">
&nbsp;</p>
<p style="margin-top: 0; margin-bottom: 0">
&nbsp;</p>
<p style="margin-top: 0; margin-bottom: 0">
&nbsp;</p>
<p style="margin-top: 0; margin-bottom: 0">
&nbsp;</p>
<p style="margin-top: 0; margin-bottom: 0">
&nbsp;</p>
<p style="margin-top: 0; margin-bottom: 0">
&nbsp;</p>
<p style="margin-top: 0; margin-bottom: 0">
&nbsp;</p>
<p style="margin-top: 0; margin-bottom: 0">
&nbsp;</p>
<p style="margin-top: 0; margin-bottom: 0">
&nbsp;</p>
<p style="margin-top: 0; margin-bottom: 0">
&nbsp;</p>
<p style="margin-top: 0; margin-bottom: 0">
&nbsp;</p>
<p style="margin-top: 0; margin-bottom: 0">
&nbsp;</p>
<p style="margin-top: 0; margin-bottom: 0">
&nbsp;</p>
<p style="margin-top: 0; margin-bottom: 0">
&nbsp;</p>
<p style="margin-top: 0; margin-bottom: 0">
&nbsp;</p>
<div style="position: absolute; width: 199px; height: 235px; z-index: 2; left: 16px; top: 277px" id="camada35">
<p style="margin-top: 0; margin-bottom: 0">
<span style="background-color: #000000"><b><i>
<font face="Arial" size="2" color="#FFFFFF">Galeria&nbsp; </font></i>
</b></span><b><span style="background-color: #000000"><i>
<font face="Arial" size="2" color="#FFFFFF">&nbsp;</font></i></span><font face="Arial" color="#FFFFFF" size="2"><span style="background-color: #000000">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp; </span></font></b></p>
<p style="margin-top: 0; margin-bottom: 0">
<b><font face="Arial" size="2" color="#800000"><i>- </i></font>
<font face="Arial" size="2">Real Madrid 1-0 Lyon </font></b>
<font face="Arial" size="2">(jogos Real Madrid 09/10)</font></p>
<p style="margin-top: 0; margin-bottom: 0">
<b><i><font face="Arial" size="2" color="#800000">- </font></i>
<font face="Arial" size="2">Treino 8, 9 e 12 Março </font></b>
<font face="Arial" size="2">(treinos Real Madrid 09/10)</font></p>
<p style="margin-top: 0; margin-bottom: 0">
<b><font face="Arial" size="2" color="#800000"><i>- </i></font>
<font face="Arial" size="2">Conf.imprensa 8-3-10 </font></b>
<font face="Arial" size="2">(conf.imprensa)</font></p>
<p style="margin-top: 0; margin-bottom: 0">
<b><i><font face="Arial" size="2" color="#800000">- </font></i>
<font face="Arial" size="2">Apresentação Bilhetes Final Champions League
</font></b><font face="Arial" size="2">(variados)</font></p>
<p style="margin-top: 0; margin-bottom: 0">
<b><i><font face="Arial" size="2" color="#800000">- </font></i>
<font face="Arial" size="2">Portugal 2-0 China </font></b>
<font face="Arial" size="2">(jogos Selecção Nacional Qualificação
Mundial2010)</font></p>
<p style="margin-top: 0; margin-bottom: 0">
<b><font face="Arial" size="2" color="#800000"><i>- </i></font>
<font face="Arial" size="2">Treino 2 Março (</font></b><font face="Arial" size="2">treinos
Selecção Nacional qualificação Mundial2010)</font></p>
<p style="margin-top: 0; margin-bottom: 0">
&nbsp;</p>
<p style="margin-top: 0; margin-bottom: 0">
&nbsp;</p>
<p style="margin-top: 0; margin-bottom: 0">
&nbsp;</p>
<p style="margin-top: 0; margin-bottom: 0">
&nbsp;</p>
<p style="margin-top: 0; margin-bottom: 0">
&nbsp;</p>
<p style="margin-top: 0; margin-bottom: 0">
&nbsp;</p>
<p style="margin-top: 0; margin-bottom: 0">
&nbsp;</p>
<p style="margin-top: 0; margin-bottom: 0">
&nbsp;</p>
<p style="margin-top: 0; margin-bottom: 0">
&nbsp;</p>
<p style="margin-top: 0; margin-bottom: 0">
&nbsp;</p>
<p style="margin-top: 0; margin-bottom: 0">
&nbsp;</p>
<p style="margin-top: 0; margin-bottom: 0">
&nbsp;</p>
<p style="margin-top: 0; margin-bottom: 0">
&nbsp;</p>
<p style="margin-top: 0; margin-bottom: 0">
&nbsp;</p>
<p style="margin-top: 0; margin-bottom: 0">
&nbsp;</p>
<p style="margin-top: 0; margin-bottom: 0">
&nbsp;</p>
<p style="margin-top: 0; margin-bottom: 0">
&nbsp;</p>
<p style="margin-top: 0; margin-bottom: 0">
&nbsp;</p>
<p style="margin-top: 0; margin-bottom: 0">
&nbsp;</p>
<p style="margin-top: 0; margin-bottom: 0">
&nbsp;</p>
<p style="margin-top: 0; margin-bottom: 0">
&nbsp;</p>
<p style="margin-top: 0; margin-bottom: 0">
&nbsp;</p>
<p style="margin-top: 0; margin-bottom: 0">
&nbsp;</p>
<p style="margin-top: 0; margin-bottom: 0">
&nbsp;</p>
<p style="margin-top: 0; margin-bottom: 0">
&nbsp;</p>
<p style="margin-top: 0; margin-bottom: 0">
&nbsp;</p>
<p style="margin-top: 0; margin-bottom: 0">
&nbsp;</p>
<p style="margin-top: 0; margin-bottom: 0">
&nbsp;</p>
<p style="margin-top: 0; margin-bottom: 0">
&nbsp;</p>
<p style="margin-top: 0; margin-bottom: 0">
&nbsp;</p>
<p style="margin-top: 0; margin-bottom: 0">
&nbsp;</p>
<p style="margin-top: 0; margin-bottom: 0">
&nbsp;</p>
<p style="margin-top: 0; margin-bottom: 0">
&nbsp;</p>
<p style="margin-top: 0; margin-bottom: 0">
&nbsp;</p>
<p style="margin-top: 0; margin-bottom: 0">
&nbsp;</p>
</div>
<div style="position: absolute; width: 194px; height: 100px; z-index: 4; left: 22px; top: 548px" id="camada37">
<table border="1" width="98%" id="table3">
<tr>
<td width="65" align="center">&nbsp;</td>
<td width="20" align="center"><b>
<font face="Arial" size="2">J</font></b></td>
<td width="22" align="center"><b>
<font face="Arial" size="2">G</font></b></td>
<td align="center" width="22"><b>
<font face="Arial" size="2">A</font></b></td>
<td align="center"><b><font size="2" face="Arial">Total
G</font></b></td>
</tr>
<tr>
<td width="65" align="left"><b>
<font face="Arial" size="2">La Liga</font></b></td>
<td width="20" align="center"><b><font face="Arial" size="2">21</font></b></td>
<td width="22" align="center"><b><font face="Arial" size="2">18</font></b></td>
<td align="center" width="22"><b><font face="Arial" size="2">4</font></b></td>
<td align="center"><b><font face="Arial" size="2">18</font></b></td>
</tr>
<tr>
<td width="65" align="left"><b><font face="Arial" size="2">Champions
League</font></b></td>
<td width="20" align="center"><b><font face="Arial" size="2">6</font></b></td>
<td width="22" align="center"><b><font face="Arial" size="2">7</font></b></td>
<td align="center" width="22"><font face="Arial" size="2"><b>0</b></font></td>
<td align="center"><b><font face="Arial" size="2">7</font></b></td>
</tr>
<tr>
<td width="65" align="left">
<b><font face="Arial" size="2">Copa del Rey</font></b></td>
<td width="20" align="center"><b>´0</b></td>
<td width="22" align="center"><b>0</b></td>
<td align="center" width="22"><b>0</b></td>
<td align="center"><b>0</b></td>
</tr>
<tr>
<td width="65" align="left"><b>
<font face="Arial" size="2">Portugal</font></b></td>
<td width="20" align="center"><b>4</b></td>
<td width="22" align="center"><b>0</b></td>
<td align="center" width="22"><b>2</b></td>
<td align="center"><b>0</b></td>
</tr>
<tr>
<td width="65" align="left"><b>
<font face="Arial" size="2">Pré-época RealMadrid</font></b></td>
<td width="20" align="center"><b><font face="Arial" size="2">9</font></b></td>
<td width="22" align="center"><b><font face="Arial" size="2">3</font></b></td>
<td align="center" width="22"><b>
<font face="Arial" size="2">0</font></b></td>
<td align="center"><b><font face="Arial" size="2">3</font></b></td>
</tr>
</table>
<p style="margin-top: 0; margin-bottom: 0">&nbsp;</p>
</div>
<p style="margin-top: 0; margin-bottom: 0">&nbsp;</p>
<p style="margin-top: 0; margin-bottom: 0"><b>
<font face="Arial" size="2" color="#FFFFFF">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
</font></b></p>
<div style="position: absolute; width: 197px; height: 100px; z-index: 3; left: 18px; top: 793px" id="camada36">
<table border="1" width="89%" id="table2">
<tr>
<td width="104" align="center">&nbsp;</td>
<td width="18" align="center"><b>
<font face="Arial" size="2">J</font></b></td>
<td width="27" align="center"><b>
<font face="Arial" size="2">Pts</font></b></td>
</tr>
<tr>
<td width="104" align="left"><font face="Arial" size="2"><b>1.</b></font><b><font face="Arial" size="2">REALMADRID</font></b></td>
<td width="18" align="center"><font size="2"><b>29</b></font></td>
<td width="27" align="center"><b><font face="Arial" size="2">74</font></b></td>
</tr>
<tr>
<td width="104" align="left" height="22"><b><font face="Arial" size="2">
2.BarcelonaFC</font></b></td>
<td width="18" align="center" height="22">
<font size="2"><b>29</b></font></td>
<td width="27" align="center" height="22">
<font size="2"><b>74</b></font></td>
</tr>
<tr>
<td width="104" align="left"><b><font face="Arial" size="2">3. Valencia
CF</font></b></td>
<td width="18" align="center"><font size="2"><b>29</b></font></td>
<td width="27" align="center"><font size="2"><b>53</b></font></td>
</tr>
<tr>
<td width="104" align="left"><b><font face="Arial" size="2">4.
RCD Mallorca</font></b></td>
<td width="18" align="center"><b><font face="Arial" size="2">29</font></b></td>
<td width="27" align="center"><b><font face="Arial" size="2">47</font></b></td>
</tr>
</table>
</div>
</div>
<marquee bgcolor="#FFFFFF" style="font-family: Arial">Prox Jogo: 10 Abril Real Madrid vs Barcelona FC (21:00 hora Portugal) -- Racing Santander 0-2 Real Madrid (1 golo de Ronaldo!) ---Videos para download: Making of anúncio BES "I Gotta Feeling" TVI; Entrevista exclusiva TVI 9/4/10; Novo anúncio BES 9/4/10; Conf.imprensa 8/4/10; Racing Santander vs CR: Getafe vs CR</marquee></div>

<div style="border-style:outset; border-color:#C0C0C0; position: absolute; width: 230px; height: 408px; z-index: 9; left: 811px; top: 1641px" id="camada19">
<!-- BEGIN CBOX - www.cbox.ws - v001 -->
<div id="cboxdiv" style="text-align: center; line-height: 0">
<div><iframe frameborder="0" width="200" height="305" src="http://www6.cbox.ws/box/?boxid=403066&b ... t&sec=main" marginheight="2" marginwidth="2" scrolling="auto" allowtransparency="yes" name="cboxmain" style="border:#DBE2ED 1px solid;" id="cboxmain"></iframe></div>
<div><iframe frameborder="0" width="200" height="75" src="http://www6.cbox.ws/box/?boxid=403066&b ... t&sec=form" marginheight="2" marginwidth="2" scrolling="no" allowtransparency="yes" name="cboxform" style="border:#DBE2ED 1px solid;border-top:0px" id="cboxform"></iframe></div>
</div>
<!-- END CBOX --></div></div>

<p align="center">
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
</p>

<div style="position: absolute; width: 845px; height: 100px; z-index: 11; left: 95px; top: 18px" id="camada23">
<img border="0" src="../7cr9/Principal.jpeg" width="851" height="546"></div>

<div style="position: absolute; width: 203px; height: 1416px; z-index: 2; left: 2px; top: 674px; padding-left: 4px; padding-right: 4px; padding-top: 1px; padding-bottom: 1px; background-color: #FFFFFF; visibility:visible; background-image:url('../7cr9/Barra%20Esquerda.jpeg')" id="camada2">
<p style="margin-top: 0; margin-bottom: 0" align="center">
<i><u>
<font face="Arial">&nbsp;</font></u></i></p>
<div style="position: absolute; width: 608px; height: 12715px; z-index: 3; left: 191px; top: 1417px; border-left-style: solid; border-left-width: 1px; border-right-style: outset; border-right-width: 1px; border-bottom-style: outset; border-bottom-width: 1px; padding-left: 4px; padding-right: 4px; padding-top: 1px; padding-bottom: 1px" id="camada50">
&nbsp;</div>
<div style="position: absolute; width: 601px; height: 14129px; z-index: 4; left: 197px; top: -1px; visibility:visible" id="camada26">
<div style="position: absolute; width: 1085px; height: 58px; z-index: 2; left: -191px; top: -72px" id="camada27">
<a href="http://7cr9.com/Home.php">
<img border="0" src="../7cr9/Home%20menu.jpeg" width="128" height="66"></a><a href="Sobre%20ele.htm"><img border="0" src="../7cr9/Sobre%20Ele%20menu.jpeg" width="125" height="64"></a><a href="Noticias.htm"><img border="0" src="../7cr9/Noticias%20menu.jpeg" width="128" height="67"></a><a href="Videos.htm"><img border="0" src="../7cr9/Videos%20menu.jpeg" width="134" height="69"></a><a href="http://7cr9gallery.co.cc/Gallery/index.php"><img border="0" src="../7cr9/Galeria%20menu.jpeg" width="139" height="72"></a><a href="Chat.htm"><img border="0" src="../7cr9/Chat%20menu.jpeg" width="137" height="73"></a><a href="Sobreosite.htm"><img border="0" src="../7cr9/Sobre%20o%20site.jpeg" width="128" height="71"></a><a href="http://7cr9.com/forum/"><img border="0" src="../7cr9/Forum.menu.jpeg" width="123" height="69"></a></div>
<p align="center">
<img border="0" src="../7cr9/Ultimas%20Noticias.JPG" width="328" height="68"><p align="center">
<font face="Arial">&nbsp;<?PHP
$number=12;
$only_active=TRUE;
include("/home/crcom/public_html/cutenews/show_news.php");
?></font><div style="position: absolute; width: 522px; height: 100px; z-index: 3; left: 43px; top: 14163px" id="camada32" align="center">
<font face="Arial" size="2"><font color="#666666"><u>7</u></font><a href="http://www.7cr9.com"><font color="#666666">CristianoRonaldo9
- 7cr9.com</font></a><font color="#666666"> © 2009 - Webhost:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
- </font><a href="mailto:mary17.7cr9@gmail.com"><font color="#666666">
Contactar 7CR9</font></a></font><div style="position: absolute; width: 91px; height: 47px; z-index: 1; left: 310px; top: -15px" id="camada33">
&nbsp;</div>
<p align="center"><font face="Arial" size="2" color="#666666">7CR9 não é
o site oficial do Cristiano Ronaldo, e não tenho qualquer contacto com o
jogador, familiares ou amigos. </font> </div>
</div>
<p style="margin-top: 0; margin-bottom: 0">
<font size="5" face="Pristina">
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </font>
</p>
<p style="margin-top: 0; margin-bottom: 0">
&nbsp;</p>
<p style="margin-top: 0; margin-bottom: 0">
&nbsp;</p>
<p style="margin-top: 0; margin-bottom: 0">
&nbsp;</p>
<p style="margin-top: 0; margin-bottom: 0">
&nbsp;</p>
<p style="margin-top: 0; margin-bottom: 0">
&nbsp;</p>
<p style="margin-top: 0; margin-bottom: 0">
<font face="Pristina" size="2">&nbsp;</font></p>
<p style="margin-top: 0; margin-bottom: 0" align="center">
<b>
<i><u>
<font face="Arial">XMaryX17X&nbsp;</font></u></i></b></p>
<p style="margin-top: 0; margin-bottom: 0">
&nbsp;&nbsp; ______________________</p>
<p style="margin-top: 0; margin-bottom: 0">
<font face="Arial" size="2"><b>&nbsp;&nbsp;&nbsp;&nbsp; </b> </font></p>
<div style="position: absolute; width: 101px; height: 23px; z-index: 12; left: 13px; top: 207px" id="camada49">
<b><font face="Arial" size="2">7CR9 promo!</font></b></div>
<div style="position: absolute; width: 100px; height: 100px; z-index: 5; left: 28px; top: 383px" id="camada38">
<object width="155" height="125"><param name="movie" value="http://www.youtube.com/v/v7hS3ryG4ak&hl ... ram><param name="allowFullScreen" value="true"></param><param name="allowscriptaccess" value="always"></param><embed src="http://www.youtube.com/v/v7hS3ryG4ak&hl=pt-br&fs=1" type="application/x-shockwave-flash" allowscriptaccess="always" allowfullscreen="true" width="155" height="125"></embed></object>
</div>
<p style="margin-top: 0; margin-bottom: 0">
&nbsp;</p>
<p style="margin-top: 0; margin-bottom: 0">
&nbsp;</p>
<p style="margin-top: 0; margin-bottom: 0">
&nbsp;</p>
<p style="margin-top: 0; margin-bottom: 0">
&nbsp;</p>
<p style="margin-top: 0; margin-bottom: 0">
<font face="Arial" size="2">&nbsp;&nbsp; </font></p>
<p style="margin-top: 0; margin-bottom: 0">
&nbsp;</p>
<div style="position: absolute; width: 101px; height: 23px; z-index: 12; left: 31px; top: 369px" id="camada47">
<b><font face="Arial" size="2">Everything</font></b></div>
<div style="position: absolute; width: 180px; height: 141px; z-index: 13; left: 5px; top: 223px" id="camada48">
<object width="183" height="145"><param name="movie" value="http://www.youtube.com/v/5-TjVYXfiRI&hl ... ram><param name="allowFullScreen" value="true"></param><param name="allowscriptaccess" value="always"></param><embed src="http://www.youtube.com/v/5-TjVYXfiRI&hl=pt-br&fs=1&" type="application/x-shockwave-flash" allowscriptaccess="always" allowfullscreen="true" width="183" height="145"></embed></object></div>
<p style="margin-top: 0; margin-bottom: 0">
&nbsp;</p>
<p style="margin-top: 0; margin-bottom: 0">
&nbsp;</p>
<p style="margin-top: 0; margin-bottom: 0">
&nbsp;</p>
<p style="margin-top: 0; margin-bottom: 0">
<font face="Arial" size="2"><b>&nbsp;&nbsp;&nbsp;</b></font></p>
<div style="position: absolute; width: 140px; height: 113px; z-index: 5; left: 28px; top: 522px" id="camada39">
<object width="155" height="125"><param name="movie" value="http://www.youtube.com/v/9dbWcSxIPxA&hl ... ram><param name="allowFullScreen" value="true"></param><param name="allowscriptaccess" value="always"></param><embed src="http://www.youtube.com/v/9dbWcSxIPxA&hl=en&fs=1" type="application/x-shockwave-flash" allowscriptaccess="always" allowfullscreen="true" width="155" height="125"></embed></object>
</div>
<div style="position: absolute; width: 100px; height: 19px; z-index: 11; left: 30px; top: 508px" id="camada46">
<b><font face="Arial" size="2">Best of 2008</font></b></div>
<p style="margin-top: 0; margin-bottom: 0">
&nbsp;</p>
<p style="margin-top: 0; margin-bottom: 0">
&nbsp;</p>
<p style="margin-top: 0; margin-bottom: 0">
&nbsp;</p>
<p style="margin-top: 0; margin-bottom: 0">
&nbsp;</p>
<p style="margin-top: 0; margin-bottom: 0">
&nbsp;</p>
<p style="margin-top: 0; margin-bottom: 0">
&nbsp;</p>
<p style="margin-top: 0; margin-bottom: 0">
&nbsp;</p>
<p style="margin-top: 0; margin-bottom: 0">
&nbsp;</p>
<p style="margin-top: 0; margin-bottom: 0">
&nbsp;</p>
<p style="margin-top: 0; margin-bottom: 0">
&nbsp;</p>
<p class="MsoNormal" style="margin-top: 3px; margin-bottom: 3px">
&nbsp;</p>
<p class="MsoNormal" style="margin-top: 3px; margin-bottom: 3px">
&nbsp;</p>
<p style="margin-top: 0; margin-bottom: 0" align="justify">
&nbsp;</p>
<p class="MsoNormal" style="margin-top: 3px; margin-bottom: 3px">
<span style="font-weight: 700" lang="en-gb">
<font face="Arial" size="2">&nbsp;&nbsp;&nbsp;&nbsp; </font>
</span></p>
<p class="MsoNormal" style="margin-top: 3px; margin-bottom: 3px">
<span style="font-weight: 700" lang="en-gb">
<font face="Arial" color="#800000">&nbsp;&nbsp; </font></span></p>
<div style="position: absolute; width: 181px; height: 100px; z-index: 10; left: 14px; top: 676px" id="camada45">
<span style="font-weight: 700" lang="en-gb">
<font face="Arial" color="#800000">-</font><font face="Arial" size="2"> </font>
<a href="mailto:mary17.7cristianoronaldo7@gmail.com">
<font face="Arial" size="2" color="#000000">mary17.7cr9@gmail.com</font></a></span></div>
<p class="MsoNormal" style="margin-top: 3px; margin-bottom: 3px">
&nbsp;</p>
<p style="margin-top: 0; margin-bottom: 0" align="justify">
&nbsp;</p>
<p style="margin-top: 0; margin-bottom: 0" align="justify">
&nbsp;&nbsp;&nbsp; </p>
<p style="margin-top: 0; margin-bottom: 0" align="justify">
<b><font face="Arial">&nbsp; </font></b></p>
<div style="position: absolute; width: 152px; height: 100px; z-index: 9; left: 16px; top: 765px" id="camada44">
<p style="margin-top: 0; margin-bottom: 0" align="justify">
<b><font face="Arial">&nbsp;</font></b><span style="font-weight: 700" lang="en-gb"><font face="Arial" color="#800000">- </font>
</span><b><font size="2" face="Arial">
<a href="http://7cristianoronaldo9.hi5.com"><font color="#000000">Hi5&nbsp;&nbsp;</font></a></font></b><font size="2">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
</font></p>
<p style="margin-top: 0; margin-bottom: 0" align="justify">
<font size="2">&nbsp;</font><span style="font-weight: 700" lang="en-gb"><font face="Arial" color="#800000">- </font>
</span><b>
<a href="http://www.facebook.com/home.php#/profi ... ef=profile">
<font size="2" color="#000000" face="Arial">Facebook</font></a></b></p>
<p style="margin-top: 0; margin-bottom: 0" align="justify">
<span style="font-weight: 700">
<font size="2" face="Arial">&nbsp;</font></span><span style="font-weight: 700" lang="en-gb"><font face="Arial" color="#800000">- </font>
</span><b><a href="http://twitter.com/7cronaldo9">
<font size="2" color="#000000" face="Arial">Twitter</font></a></b></p>
<p style="margin-top: 0; margin-bottom: 0" align="left">
<font size="2">&nbsp;</font><span style="font-weight: 700" lang="en-gb"><font face="Arial" color="#800000">- </font>
</span><b>
<a href="http://www.orkut.com/Main#Profile.aspx? ... 4822680467">
<font size="2" color="#000000" face="Arial">Orkut</font></a></b></p>
<p style="margin-top: 0; margin-bottom: 0" align="justify">
<font size="2">&nbsp;</font><span style="font-weight: 700" lang="en-gb"><font face="Arial" color="#800000">- </font>
</span><b><a href="http://www.myspace.com/492095675">
<font size="2" color="#000000" face="Arial">Myspace</font></a></b></p>
<p style="margin-top: 0; margin-bottom: 0" align="justify">
<font size="2">&nbsp;</font><span style="font-weight: 700" lang="en-gb"><font face="Arial" color="#800000">- </font>
</span><b><a href="http://www.tagged.com/7cristianoronaldo9">
<font size="2" color="#000000" face="Arial">Tagged</font></a></b></p>
<p>&nbsp;</div>
<p style="margin-top: 0; margin-bottom: 0" align="justify">
&nbsp; </p>
<p style="margin-top: 0; margin-bottom: 0" align="justify">
&nbsp; </p>
<p style="margin-top: 0; margin-bottom: 0" align="justify">&nbsp;</p>
<p style="margin-top: 0; margin-bottom: 0" align="justify">
</p>
<div style="position: absolute; width: 176px; height: 100px; z-index: 8; left: 16px; top: 938px" id="camada43">
<p align="left" style="margin-top: 0px; margin-bottom: 0px">
<span style="font-weight: 700" lang="en-gb">
<font face="Arial" color="#800000">- </font>
</span><b><font face="Arial" size="2" color="#FFFFFF">
<a href="http://cristianoronaldo7-17.blogspot.com/"><font color="#000000">
Cristiano Ronaldo7-17 Blog</font></a></font></b></p>
<p align="left" style="margin-top: 0px; margin-bottom: 0px">
<span style="font-weight: 700" lang="en-gb">
<font face="Arial" color="#800000">- </font>
</span><b><font face="Arial" size="2" color="#FFFFFF">
<a href="http://www.xmaryx17cristianoronaldovideos.blogspot.com/">
<font color="#000000">XMaryX17 Vídeos</font></a></font></b></p>
<p align="left" style="margin-top: 0px; margin-bottom: 0px">
<span style="font-weight: 700" lang="en-gb">
<font face="Arial" color="#800000">- </font>
</span><b><font color="#FFFFFF" size="2" face="Arial">
<a href="http://br.youtube.com/profile?user=XxXMaryX17XxX">
<font color="#000000">My channel on Youtube</font></a></font></b></p>
<p align="left" style="margin-top: 0px; margin-bottom: 0px">
<b><font face="Arial" size="2">-
<a href="http://www.facebook.com/Cristiano?v=wall"><font color="#000000">
Facebook C.Ronaldo</font></a></font></b></p>
<p align="left" style="margin-top: 0px; margin-bottom: 0px">
<font face="Arial" color="#800000">
<span style="font-weight: 700" lang="en-gb">
-</span></font><span lang="en-gb"> </span><b>
<font face="Arial" size="2" color="#FFFFFF">
<a href="http://www.gestifute.com/gestifute/index_mundial.html">
<font color="#000000">Gestifute</font></a></font></b></p>
<p align="left" style="margin-top: 0px; margin-bottom: 0px">
<span style="font-weight: 700" lang="en-gb">
<font face="Arial" color="#800000">- </font>
</span><b><font face="Arial" size="2" color="#FFFFFF">
<a href="http://www.fpf.pt/portal/page/portal/PORTAL_FUTEBOL">
<font color="#000000">FPF</font></a></font></b></p>
<p align="left" style="margin-top: 0px; margin-bottom: 0px">
<span style="font-weight: 700" lang="en-gb">
<font face="Arial" color="#800000">- </font>
</span><b><u>
<font face="Arial" size="2">
<a href="http://www.realmadrid.com/cs/Satellite/es/Home.htm">
<font color="#000000">Real MadridFC Official Site</font></a></font></u></b></p>
<p>&nbsp;</div>
<p align="left" style="margin-top: 0px; margin-bottom: 0px">
<font face="Arial" size="2">&nbsp;&nbsp; </font></p>
<p align="left" style="margin-top: 0px; margin-bottom: 0px">
&nbsp;</p>
<p align="left" style="margin-top: 0px; margin-bottom: 0px">
&nbsp;</p>
<p align="left" style="margin-top: 0; margin-bottom: 0">
<font color="#000000" face="Arial" size="2">&nbsp;&nbsp; </font></p>
<p align="left" style="margin-top: 0; margin-bottom: 0">
<span style="font-weight: 700" lang="en-gb">
<font face="Arial" color="#800000">&nbsp;&nbsp;</font></span></p>
<div style="position: absolute; width: 176px; height: 100px; z-index: 7; left: 13px; top: 1121px" id="camada42">
<p align="left" style="margin-top: 0; margin-bottom: 0">
<span style="font-weight: 700" lang="en-gb">
<font face="Arial" color="#800000">&nbsp;- </font>
</span><font face="Arial" size="2" color="#FFFFFF">
<b><a href="http://www.ronaldofan.com/"><font color="#000000">Ronaldo Você É Bonito</font></a></b></font></p>
<p align="left" style="margin-top: 0; margin-bottom: 0">
<b>
<font color="#000000" size="2" face="Arial">&nbsp;</font><font color="#800000" face="Arial">- </font>
<font color="#000000" size="2" face="Arial">
<a href="http://cristiano-ronaldo.us/"><font color="#000000">CristianoRonaldo.us</font></a></font></b></p>
<p align="left" style="margin-top: 0; margin-bottom: 0">
<span style="font-weight: 700" lang="en-gb">
<font face="Arial" color="#800000">&nbsp;- </font>
<a href="http://www.cr9brasil.blogspot.com/">
<font color="#000000" size="2" face="Arial">CR9 Brasil</font><font color="#000000" face="Arial">&nbsp;</font></a></span></p>
<p align="left" style="margin-top: 0; margin-bottom: 0">
<span style="font-weight: 700" lang="en-gb"><font face="Arial">
<font color="#800000">&nbsp;-</font> <font size="2">
<a href="http://everythingcr7.netne.net/"><font color="#000000">EverythingCR7</font></a></font></font></span></p>
<p align="left" style="margin-top: 0; margin-bottom: 0">
<span style="font-weight: 700" lang="en-gb">
<font face="Arial" color="#800000">&nbsp;- </font>
</span><b><font face="Arial" color="#FFFFFF">
<u>
<a href="http://davidluiz-23.blogspot.com/"><font color="#000000" size="2">David
Luiz 23*</font></a></u></font></b></p>
<p align="left" style="margin-top: 0; margin-bottom: 0">
<b>
<font color="#000000" size="2" face="Arial">&nbsp;</font></b><span style="font-weight: 700" lang="en-gb"><font face="Arial" color="#800000">- </font>
</span><b><font color="#FFFFFF" face="Arial">
<a href="http://lucascr7futebolmundial.blogspot.com/">
<font color="#000000" size="2">Futebol Mundial</font></a></font></b></p>
<p>&nbsp;</div>
<p align="left" style="margin-top: 0; margin-bottom: 0">
&nbsp;</p>
<p align="left" style="margin-top: 0; margin-bottom: 0">
&nbsp;<font color="#FFFFFF"><p align="left" style="margin-top: 0; margin-bottom: 0">
&nbsp;<p align="left" style="margin-top: 0; margin-bottom: 0">
&nbsp;<!-- INICIO DO CODIGO DO CONTADOR DE VISITAS 2W.COM.BR -->
<div style="position: absolute; width: 176px; height: 100px; z-index: 6; left: 9px; top: 1279px" id="camada41">
<div align=center>
<p style="margin-top: -4px; margin-bottom: -4px">
<a href="http://www.2w.com.br/contador-de-visita ... ratis.html">
<font color="#000000"><img src="http://contador.2w.com.br/imgcontador.php?p=ec637389" alt="" border=0></font></a></div>
<div align=center>
<p style="margin-top: -4px; margin-bottom: -4px">
<font face="Arial" size="2" color="#800000">
Obrigada pela visita!</font></div>
<p align="center" style="margin-top: -4px; margin-bottom: -4px"><!-- INICIO CONTADOR -->
<a href='http://cifradasweb.net/' id='lnolt_' target='_blank' style='font-family:Arial;font-size:11px;font-weight:bold;text-decoration:none;'>
<font color="#000000">
<script language='JavaScript' src='http://blogutils.net/olct/online.php?si ... '></script>
</font></a>
<a href='http://www.blogutils.net/' target='_blank' style='font-family:Arial;font-size:11px;font-weight:bold;text-decoration:none;'>
<font color="#000000">online</font></a>
<!-- FIM CONTADOR -->
&nbsp;<p>&nbsp;</div>
<p align="left" style="margin-top: -3px; margin-bottom: -3px">&nbsp;<div align=center>
<p style="margin-top: -4px; margin-bottom: -4px">
&nbsp;</div>
<p align="left">&nbsp;</div>


<script type="text/javascript">
var gaJsHost = (("https:" == document.location.protocol) ? "https://ssl." : "http://www.");
document.write(unescape("%3Cscript src='" + gaJsHost + "google-analytics.com/ga.js' type='text/javascript'%3E%3C/script%3E"));
</script>
<script type="text/javascript">
var pageTracker = _gat._getTracker("UA-5774876-1");
pageTracker._trackPageview();
</script>
</font>
</body>

</html>

Re: phpbb Displaying topics from external pages

Posted: Wed Aug 04, 2010 2:37 pm
by battye
I'm still having a lot of trouble understanding what you want.

On http://7cr9.com/exp1.php is this the latest topics list:
Picture 25.png
And if so, are you trying to get it to display on http://7cr9.com/Home.php?

I suspect Frontpage is actually the cause of the problem here. Frontpage is notoriously bad at handling PHP code. I wouldn't normally recommend this because I think it is a "quick fix" and a bit messy, but seeing you use Frontpage you might be able to integrate it in a visually pleasing fashion... what I am alluding to is using an iframe. That is, putting the "last topics" code on a page by itself and then including that page in an iframe. Then you can separate the PHP from the html and it should stop the problems from happening.

Re: phpbb Displaying topics from external pages

Posted: Thu Aug 05, 2010 1:58 pm
by Mary17
Thanks for the answer.

Yes, what I'm trying to do is to display what's on http://7cr9.com/exp1.php on http://7cr9.com/Home.php without errors, like you said.

About the iframes thing, I'm sorry but I dont know anything about it. If you say that it would delete the errors, the I wnat to try it ... Could you help step by step doing it?

Thanks again,
Mary

Re: phpbb Displaying topics from external pages

Posted: Sat Aug 07, 2010 1:10 pm
by Mary17
Hey there,

I thought I'd publish here that I think I solved the problem. And used a different code form yours, but published here so that other people can see to. I found this on http://www.hawkee.com/snippet/5344/ here it is:

Code: Select all

    <?php
        // How Many Topics you want to display?
        $topicnumber = 5;
        // Change this to your phpBB path
        $urlPath = "/phpbb";

        // Database Configuration (Where your phpBB config.php file is located)
        include 'phpbb/config.php';

        $table_topics = $table_prefix. "topics";
        $table_forums = $table_prefix. "forums";
        $table_posts = $table_prefix. "posts";
        $table_users = $table_prefix. "users";
        $link = mysql_connect("$dbhost", "$dbuser", "$dbpasswd") or die("Could not connect");
        mysql_select_db("$dbname") or die("Could not select database");

        $query = "SELECT t.topic_id, t.topic_title, t.topic_last_post_id, t.forum_id, p.post_id, p.poster_id, p.post_time, u.user_id, u.username
        FROM $table_topics t, $table_forums f, $table_posts p, $table_users u
        WHERE t.topic_id = p.topic_id AND
        f.forum_id = t.forum_id AND
        t.forum_id != 4 AND
        t.topic_status <> 2 AND
        p.post_id = t.topic_last_post_id AND
        p.poster_id = u.user_id
        ORDER BY p.post_id DESC LIMIT $topicnumber";
        $result = mysql_query($query) or die("Query failed");                           

        print "<table cellpadding='3' cellSpacing='2' width='640'>";
        while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {

        echo  "<tr valign='top'><td><font face=\"Verdana, Arial, Helvetica, sans-serif\" size=\"1\"><font color=\"#FFCC00\"><b><a href=\"$urlPath/viewtopic.php?f=$row[forum_id]&t=$row[topic_id]&p=$row[post_id]#p$row[post_id]\" TARGET=\"_blank\">" .
        $row["topic_title"] .
        "</a></td></font></b><td><font face=\"Verdana, Arial, Helvetica, sans-serif\" size=\"1\"><font color=\"#C0C0C0\"> by: <a href=\"$urlPath/memberlist.php?mode=viewprofile&u=$row[user_id]\" TARGET=\"_blank\">" .
        $row["username"] .
        "</td><td><font face=\"Verdana, Arial, Helvetica, sans-serif\" size=\"1\"><font color=\"#C0C0C0\">" .
        date('F j, Y, g:i a', $row["post_time"]) .
        "</td></tr></font>";
        }
        print "</table>";
        mysql_free_result($result);
        mysql_close($link);
        ?>


I thought to share it with so many others who are looking for it. It's extremly useful to apply. I use frontpage, I just created a new layer and copied this code in there, and it worked. Some images didn't appear but it was just a matter of adjusting "it's adress" (like on my documents...).


I have a doubt, which is:
On the page http://7cr9.com/2.php there are shown the latest topics, authors, and the date it was published.

I wanted to show only the topic title, and not the author or date. Could you tell me which part of the code should I delete or change to do so?


Thanks,
Mary