phpBB.de

Code: Alles auswählen

<style type="text/css">
#General_arabic {
   font-family: Verdana, Arial, Helvetica, sans-serif;
   font-size: xx-small;
   font-weight: normal;
   height: 100%;
   width: 100%;
   direction: ltr;
   background-color:#FDD16F;
}

a:hover {
   text-decoration: underline overline;
}
a:link {
   text-decoration: none;
}

a {
   text-decoration: none;
   color: black;
}

a:visited {
   text-decoration: none;
}

</style>
    
<?php
    /**
    *
    * @package phpBB3
    * @copyright (c) 2005 phpBB.bz Group
    * @license http://opensource.org/licenses/gpl-license.php GNU Public License
    * 
    */

    /**
    * @ignore
    */
    define('IN_PHPBB', true);
    $phpbb_root_path = './';
    $phpEx = substr(strrchr(__FILE__, '.'), 1);
    include($phpbb_root_path . 'common.'.$phpEx);

//forums you do not want to show

$forums =',';

// topics limit
$limit ='5';

   $sql = "SELECT topic_id,topic_title
          FROM phpbb3_topics
          WHERE forum_id    NOT IN ('$forums')
          AND topic_approved = 1 ORDER BY topic_id DESC";
    //$result = $db->sql_query($sql);
    $result = $db->sql_query_limit($sql, $limit);
    //echo $sql;


    // show out put

    echo "<div id='General_arabic'><ul>";
    while (($row = $db->sql_fetchrow($result)) ) {
	echo "<li>";
        echo "<a  target='_blank' href='viewtopic.php?t=";
        echo $row[topic_id];
       echo"'>";
       echo $row[topic_title];
        echo "</a></li>";
        }
        echo "<ul></div>";



// Free resultset
mysql_free_result($result);
    

?>

Code: Alles auswählen

echo "<a  title='".$row[topic_title]."' target='_blank' href='viewtopic.php?t="; 
        echo $row[topic_id]; 
       echo"'>"; 
       echo (strlen($row[topic_title]>20))?substr($row[topic_title],0,20)."...":$row[topic_title]; 
        echo "</a></li>";