Foros del Web - Ver Mensaje Individual - Problema de integración phpBB a sistema de noticias.

mtzcfreddy · #1 (**permalink**) 20/09/2006, 16:46

Hola que tal, tengo un problema al agregar el codigo de integración del foro phpBB al codigo que me genera la noticia desde MySQL pues me manda el error:

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in archivo.php in line XX

Esto solo al poner el codigo de integración del foro, se lo quito y todo bien, me interesa, para que solo usuarios registrados puedan comentar la noticia.

Código:

//**********CODIGO DE INTEGRACION phpBB

<?
$volver="..$_SERVER[PHP_SELF]"; 
define('IN_PHPBB', true);
$phpbb_root_path = '../comunidad/';
include($phpbb_root_path . 'extension.inc');
include($phpbb_root_path . 'common.'.$phpEx);
$userdata = session_pagestart($user_ip, PAGE_INDEX);
init_userprefs($userdata);
global $db, $board_config;
global $HTTP_COOKIE_VARS, $HTTP_GET_VARS, $SID;
$cookiename = $board_config['cookie_name'];
$cookiepath = $board_config['cookie_path'];
$cookiedomain = $board_config['cookie_domain'];
$cookiesecure = $board_config['cookie_secure'];
 if ( !(isset($HTTP_COOKIE_VARS[$cookiename . '_sid']) || isset($HTTP_COOKIE_VARS[$cookiename . '_data'])) )
    {
    output_add_rewrite_var('sid', $userdata['session_id']);
    }
 $log_in_out=( $userdata['session_logged_in'] ) ? ('<a href="'.$phpbb_root_path.'login.'.$phpEx.'?logout=true&sid=' . $userdata['session_id'].'&redirect='.$volver.'" class="ink_menu">Logout ['.$userdata['username'].']</a>') : ('');
?>

//*********  CODIGO PARA MOSTRAR LA NOTICIA

<? if (!$skip AND !$print) { include "header.php"; } ?>
<?
if ($print)
{
echo "<body onLoad=\"window.print()\">";
}
include ("admin/db.php");
include ("admin/set_inc.php");
include ("admin/language/$lang");
settype($artid,"integer");
$sql = "SELECT * FROM article_news,author_news where author_news.userid = article_news.authorid AND id = '$artid'";
$result = mysql_query($sql);
$num_res = mysql_num_rows($result);
for ($i=0; $i<$num_res; $i++)
{
    $myrow = mysql_fetch_array($result);
    $id = $myrow["id"];
    $catid = $myrow["catid"];
    $title = $myrow["title"];
    $date = $myrow["date"];
    $date_changed = $myrow["date"];
    $authorid = $myrow["authorid"];
    $intro = $myrow["intro"];
    $body = $myrow["body"];
    $status = $myrow["status"];
    $count = $myrow["count"];
    $votes = $myrow["votes"];
    $grade = $myrow["grade"];
    $fname = $myrow["fname"];
    $lname = $myrow["lname"];
    $userid = $myrow["userid"];
    $email = $myrow["email"];
    $show_html = $myrow["show_html"];
    $year=substr($myrow[date],0,4);
    $month=substr($myrow[date],4,2);
    $day=substr($myrow[date],6,2);
    $tid1 = "$day.$month.$year";
    $year2=substr($myrow[date_changed],0,4);
    $month2=substr($myrow[date_changed],4,2);
    $day2=substr($myrow[date_changed],6,2);
    $tid2 = "$day2.$month2.$year2";
    $code_table_start = "<table class=\"code\" borderColorDark=\"#000000\" 
cellPadding=\"2\" width=\"100%\" bgColor=\"#e4e4fc\" borderColorLight=\"#ffffff\" 
border=\"1\"><tr><td width=\"100%\">";
 $code_table_end = "</td></tr></table>";
 }
    $sql = "SELECT * FROM cat_news where id = $catid";
 $result = mysql_query($sql);

//********* AQUI ME MANDA EL ERROR

    $num_res = mysql_num_rows($result);

    for ($i=0; $i<$num_res; $i++)
    {
          $myrow = mysql_fetch_array($result);
          $catname = $myrow["catname"];
          $id = $myrow["id"];
 }
 print "<!-- TEMPLATE FILE -->";
 $filename = "admin/templates/art.html";
 $fd = fopen ($filename, "r");
 $file= fread ($fd, filesize ($filename));
 $file = str_replace("{ID}", "$id", $file);
 $file = str_replace("{CATNAME}", "$catname", $file);
 $file = str_replace("{TITLE}", "$title", $file);
 $file = str_replace("{EMAIL}", "$email", $file);
 $file = str_replace("{FNAME}", "$fname", $file);
 $file = str_replace("{LNAME}", "$lname", $file);
 $file = str_replace("{DATE_CHANGED}", "$date_changed", $file);
 $file = str_replace("{ARTID}", "$artid", $file);
 $file = str_replace("{INTRO}", "$intro", $file);
 $file = str_replace("{TID1}", "$tid1", $file);
 $file = str_replace("{TID2}", "$tid2", $file);
 $file = str_replace("{BODY}", "$body", $file);
 $file = str_replace("{LA_BY}", "$la_by", $file);
 $file = str_replace("{LA_CHANGED}", "$la_changed", $file);
 $file = str_replace("{LA_NEWS}", "$la_news", $file);
 $file = str_replace("{LA_PRINT}", "$la_print", $file);
 $file = str_replace("{LA_RATE_THIS}", "$la_rate_this", $file);
 $file = str_replace("{LA_TELLAFRIEND}", "$la_tellafriend", $file);
 echo $file;
 print "<!-- // TEMPLATE FILE -->";
 $sql = "UPDATE article_news set count = count+1 where id = $artid;";
 $result = mysql_query($sql);
?>  
<?php 
if( $userdata [ 'session_logged_in' ]) 
{ 
print "Registrado";
} 
else 
{ 
print "Visitante";
} 
?> 
<? if (!$skip AND !$print) { include "footer.php"; } ?>