}
?>

global $xoopsDB;
$sql="select texto,autor from ".$xoopsDB->prefix("xoops_citas")." ORDER BY RAND() LIMIT 10";
$result = $xoopsDB->query($sql) ;
$i = 0;
while(list($texto,$autor)=$xoopsDB->fetchRow($result)){
$arr_quotes[$i]['text'] = $texto;
$arr_quotes[$i]['author'] = $autor;
$i++;
}
$xoopsTpl->assign('arr_quotes',$arr_quotes);

<div id="randomquote">
<{foreach item=quote from=$arr_quotes}>
<p><{$quote.text}></p>
<p><{$quote.author}></p>
<br />
<{/foreach}>
</div>

<?php
// $Id: header.php 185 2006-01-22 23:49:01Z skalpa $
// ------------------------------------------------------------------------ //
// XOOPS - PHP Content Management System //
// Copyright (c) 2000 XOOPS.org //
// <https://xoops.org/> //
// ------------------------------------------------------------------------ //
// This program is free software; you can redistribute it and/or modify //
// it under the terms of the GNU General Public License as published by //
// the Free Software Foundation; either version 2 of the License, or //
// (at your option) any later version. //
// //
// You may not change or alter any portion of this comment or credits //
// of supporting developers from this source code or any supporting //
// source code which is considered copyrighted (c) material of the //
// original comment or credit authors. //
// //
// 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 General Public License for more details. //
// //
// You should have received a copy of the GNU General Public License //
// along with this program; if not, write to the Free Software //
// Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA //
// ------------------------------------------------------------------------ //
if (!defined("XOOPS_ROOT_PATH")) {
die("XOOPS root path not defined");
}

// Ensure charset setting
if (!headers_sent()) {
header('Content-Type:text/html; charset='._CHARSET);
}

$GLOBALS['xoopsLogger']->context = "core";

// Get blocks
$block_handler =& xoops_gethandler('block');
$block_handler->assignBlocks();

$GLOBALS['xTheme']->checkCache();

if (!isset($GLOBALS['xoopsOption']['template_main'])) {
// new themes using Smarty does not have old functions that are required in old modules, so include them now
include XOOPS_ROOT_PATH.'/include/old_theme_functions.php';
// need this also
$xoopsTheme['thename'] = $GLOBALS['xoopsConfig']['theme_set'];


}
$GLOBALS['xoopsLogger']->context = "module";
/*
*Hack by rplima to show random quotes in the theme
*/
global $xoopsDB;
$sql="select texto,autor from ".$xoopsDB->prefix("xoops_citas")." ORDER BY RAND() LIMIT 10";
$result = $xoopsDB->query($sql) ;
$i = 0;
while(list($texto,$autor)=$xoopsDB->fetchRow($result)){
$arr_quotes[$i]['text'] = $texto;
$arr_quotes[$i]['author'] = $autor;
$i++;
}
$xoopsTpl->assign('arr_quotes',$arr_quotes);
/*
*End of hack
*/
?>