Ver Mensaje Individual
  #1 (permalink)  
Antiguo 18/12/2008, 18:58
Zer0bg
 
Fecha de Ingreso: julio-2008
Mensajes: 20
Antigüedad: 15 años, 9 meses
Puntos: 0
ultimos mensajes del foro (phpbb3)

hola gente.. yo tenia el recuadro de los ultimos mensajes del foro en phpbb3 y funcionaba perfecto pero resulta que puse el mod rewrite y dejo de funcionar seguramente habria q modificar algo para que funcione..yo no tengo idea haber si alguno me da una mano
pongo el codigo anterior..

Código:
<?php 

// Amount of active topics to show 
define("TOPIC_COUNT", 8); 

// Path to the phpBB 3.0 root directory 
define("PHPBB_PATH", ""); 

// URL to the phpBB 3.0 installation 
define("PHPBB_LOCATION", ""); 

// Time format to output the date/time (for format see PHP manual) 
define("TIME_FORMAT", "d/m/Y"); 

// php extension using
$phpEx = "php";

// No Editing unless you know what your doing
if ( !defined('IN_PHPBB') ) 
{
	define('IN_PHPBB', true);
}


// Get the needed phpbb files, thank you phpbb =]
include($phpbb_root_path  . 'common.' . $phpEx);
include($phpbb_root_path . 'includes/bbcode.' . $phpEx);

$user->session_begin();
$auth->acl($user->data);
$user->setup();

// HTML header start 

?> 
<style>
a:link, 
a:visited {
	font-family: Verdana, Arial, Helvetica, sans-serif;
	color: #496c9f;	
	text-decoration: none;	
}

a:hover {
	font-family: Verdana, Arial, Helvetica, sans-serif;
	color: #496c9f;	
	text-decoration: underline;
}

a:active {
	font-family: Verdana, Arial, Helvetica, sans-serif;
	color: #496c9f;	
	text-decoration: none; 	
}
</style>
<table border="0" cellpadding="1" cellspacing="1" width="100%"> 
<tr> 
<th align="center" bgcolor="#DFE6EF"><font color="#5F5757" size="2">Ultimos 8 mensajes del foro</font></th> 
<th align="center" bgcolor="#DFE6EF"><font color="#5F5757" size="2">Visitas</font></th> 
<th align="center" bgcolor="#DFE6EF"><font color="#5F5757" size="2">Respuestas</font></th> 
<th align="center" bgcolor="#DFE6EF"><font color="#5F5757" size="2">Por Usuario</font></th> 
<th align="center" bgcolor="#DFE6EF"><font color="#5F5757" size="2">Fecha</font></th> 
</tr> 
<?php 

// HTML header end 

$sql = "SELECT DISTINCT t.topic_title, t.topic_id,t.topic_views,t.topic_replies, t.topic_last_post_id, 

p.post_time,p.poster_id, f.forum_name, u.user_id, u.username 
FROM " . TOPICS_TABLE . " AS t, " . POSTS_TABLE . " AS p, " . FORUMS_TABLE . " AS f, " . USERS_TABLE . " AS u 
WHERE 
t.forum_id = f.forum_id

AND p.topic_id = t.topic_id 
AND p.poster_id = u.user_id 
AND p.post_id = t.topic_last_post_id 
ORDER BY p.post_time DESC LIMIT " . TOPIC_COUNT; 
$nt_result = $db->sql_query($sql); 

if(!$nt_result) 
{ 
die("Failed obtaining list of active topics".mysql_error()); 
} 
else 
{ 
$nt_data = $db->sql_fetchrowset(); 
} 

if ( count($nt_data) == 0 ) 
{ 
die("No topics found"); 
} 
else 
{ 
$cq = 1; 
$cc = FFFFFF; 
// $nt_data contains all interesting data 
for ($i = 0; $i < count($nt_data); $i++) 
{ 
$title = $nt_data[$i]['topic_title']; 
$Turl = PHPBB_LOCATION . 'viewtopic.' . $phpEx . "?t=" . $nt_data[$i]['topic_id']; 
$LPurl = PHPBB_LOCATION . 'viewtopic.' . $phpEx . "?p" . "=" . $nt_data[$i]['topic_last_post_id'] . "#p" . $nt_data[$i]['topic_last_post_id']; 

$on_forum = 'Forum ' . $nt_data[$i]['forum_name']; 
$post_time = date(TIME_FORMAT, $nt_data[$i]['post_time']); 
//Profile profile.php?mode=viewprofile&u=23 
$profile = PHPBB_LOCATION . 'memberlist.' . $phpEx . "?mode=viewprofile&u=" . $nt_data[$i]['poster_id'] ; 
$usrname = $nt_data[$i]['username']; 
// Item HTML start 

if($cq%2 == 0){$cc = E8EFF4;$cq++;} else{$cc = E8EFF4;$cq++;}?> 
<tr> 
<td bgcolor="#<?php echo $cc;?>" align="left"><a href="<?php echo $LPurl; ?>" title="<?php echo $on_forum; ?>" 

target="_parent"><font face="verdana" color="#496C9F" size="1"><B><?php echo $title; ?></B></font></a></td> 
<td bgcolor="#<?php echo $cc;?>" align="left"><div align="center"><font face="verdana" color="#5B5B5B" size="1"><?php echo 

$nt_data[$i]['topic_views'] ?></div></td> 
<td bgcolor="#<?php echo $cc;?>" align="left"><font face="verdana" color="#5B5B5B" size="1"><div align="center"><?php echo 

$nt_data[$i]['topic_replies'] ?></div></td> 
<td align="center" bgcolor="#<?php echo $cc;?>" align="left"><font face="verdana" color="#666666" size="1"><a href="<?php 

echo $profile; ?>" target="_parent"><font face="verdana" color="#496C9F" size="1"><B><?php echo $usrname?></B></a></td>
<td bgcolor="#<?php echo $cc;?>" align="left"><font face="verdana" color="#5B5B5B" size="1"><div align="center"><?php echo 

$post_time ?></div></td> 
</tr> 
<?php 

// Item HTML end 

} 
} 

// Footer HTML start 

?>

espero su ayuda gracias