#
#----------[ RUN SQL ]----------------------------------
#
#  Run the following SQL statement to update your phpBB database.
#  You can use phpMyAdmin or a similar tool to run this update.
#
#  IMPORTANT: If you have changed the table prefix from the default of phpBB2,
#  please be sure to replace phpBB2 with your prefix BEFORE running this update.
#

CREATE TABLE `phpbb_quote` (
  `id` smallint(5) unsigned NOT NULL auto_increment,
  `quote` text NOT NULL,
  `author` varchar(150) NOT NULL default '',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=90 ;

INSERT INTO `phpbb_quote` VALUES (1, 'Um einen Liebesbrief zu schreiben, musst du anfangen, ohne zu wissen, was du sagen willst, und endigen, ohne zu wissen, was du gesagt hast.', 'Jean-Jacques Rousseau');
INSERT INTO `phpbb_quote` VALUES (2, 'Erfolg besteht darin, das man genau die Fhigkeit hat, die gerade gefragt ist!', 'Henry Ford');

#
#----------[ OPEN ]-------------------------------------
#

portal.php

#
#----------[ FIND ]-------------------------------------
#

// Generate the page

#
#----------[ BEFORE, ADD ]------------------------------
#

//Start Quote
srand((double)microtime()*1000000); 
$sql = "SELECT quote, author FROM " . QUOTE_TABLE . "  ORDER BY rand()";
$result = $db->sql_query($sql);
while ($row = mysql_fetch_array($result))
{
    $quote = $row['quote'];
    $author = $row['author'];
}
if ( $author !='' )
{
	$quote_author = '</span></td></tr><tr><td align="right" class="row2"><span class="gensmall"><font color="blue"><small><i>';
	$quote_author .= $author;
	$quote_author .= '</i></small></font>';
}

$template->assign_vars(array(
    'QUOTE' => $quote,
    'AUTHOR' => $quote_author)
    );
//End Quote

#
#----------[ OPEN ]-------------------------------------
#

templates/subSilver/portal_body.tpl

#
#----------[ PLACE WHEREEVER YOU WANT ]-----------------
#

		<table width="100%" cellpadding="2" cellspacing="1" border="0" class="forumline"> 
		 <tr> 
		    <td height="25" class="cat"><span class="genmed"><b>Schon Gewusst?</b></span></td> 
		 </tr> 
		 <tr> 
		    <td class="row1"><span class="gensmall">{QUOTE}{AUTHOR}</span></td>
		 </tr> 
		</table>

#
#----------[ SAVE AND CLOSE ALL FILES ]-----------------
#
# EoM