* @copyright 2009 Bartolomé Sintes Marco * @license http://www.gnu.org/licenses/agpl.txt AGPL 3 or later * @version 2009-05-21 * @link https://www.mclibre.org * * This program is free software: you can redistribute it and/or modify * it under the terms of the GNU Affero General Public License as published by * the Free Software Foundation, either version 3 of the License, or * any later version. * * This program is distributed in the hope that it will be useful, * but WITHOUT ANY WARRANTY; without even the implied warranty of * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the * GNU Affero General Public License for more details. * * You should have received a copy of the GNU Affero General Public License * along with this program. If not, see . */ include "biblioteca.php"; $db = conectaDb(); cabecera("Inicio", "menuPrincipal", ""); $consulta = "SELECT COUNT(*) FROM $dbDiscusiones"; $result = $db->query($consulta); if (!$result) { print "

Error en la consulta.

\n"; print "\n"; } elseif ($result->fetchColumn()>0) { $consulta = "SELECT * FROM $dbDiscusiones"; $result = $db->query($consulta); if (!$result) { print "

Error en la consulta.

\n"; print "\n"; } else { foreach ($result as $valor) { $consulta = "SELECT COUNT(*) FROM $dbIntervenciones WHERE id_discusion='$valor[id]'"; $result2 = $db->query($consulta); if (!$result2) { print "

Error en la consulta.

\n"; print "\n"; } else { $numInt = $result2->fetchColumn(); $consulta = "SELECT * FROM $dbIntervenciones WHERE id_discusion='$valor[id]'"; $result2 = $db->query($consulta); if (!$result2) { print "

Error en la consulta.

\n"; print "\n"; } else { print "
\n"; print "

" . "\"Ver$valor[titulo]

\n"; print "\n"; print "

Propuesta por " . "$valor[autor] el " . fechaDma($valor["fecha"]) . " - "; if ($numInt == 1) { print "1 intervención"; } else { print "$numInt intervenciones"; } print ".

\n"; print "\n"; print "

$valor[descripcion]

\n"; print "
\n"; print "\n"; } } } } } pie();