[joeMJ]

Oups?

Problem: You cannot use old parser, connect dies within script.

I finally got this to work. A friend of mine found out, that the db connect was broken and the new parser didn't work because of that issue. Here's what I did on my page to get this working in 3.5 including new Parser and Fix within db connect (including advertising after 3 news):

See this line:
$xdb = mysql_select_db("$dbname", $connection) or die ("Could not select database.");

PHP Code:

<?php
require_once("./global.php");
require_once('./includes/class_bbcode.php');

$splitval="lest mehr hier";
$cats="19"; //"2,3,4,5,6";
$newsitems=10;
$forumspath="http://www.tralala.de/tralala";

$servername="localhost";
$dbusername="tralala";
$dbpassword="tralala";
$dbname="tralalatabelle";

//**************************************************************************************************************//

$iidx = 0;

$bbparser =& new vB_BbCodeParser($vbulletin, fetch_tag_list()); 

$connection = mysql_connect("$servername","$dbusername","$dbpassword") or die ("Cannot connect to server.");
$xdb = mysql_select_db("$dbname", $connection) or die ("Could not select database.");

$sql = "SELECT threadid, title, forumid, replycount, postusername, postuserid, lastposter, dateline, iconid FROM thread WHERE forumid IN ($cats) AND sticky = '0' ORDER BY threadid DESC LIMIT $newsitems";
$sql_result = mysql_query($sql, $connection) or die ("Could not execute query.".mysql_error());

if (!$sql_result) 
echo "Could not get news.";
else
{
 while ($row = mysql_fetch_array($sql_result)) 
 {
   $threadid = $row["threadid"];
   $title = $row["title"];
   $forumid = $row["forumid"];
   $replycount = $row["replycount"];
   $postusername = $row["postusername"];
   $postuserid = $row["postuserid"];
   $lastposter = $row["lastposter"];
   $iconid = $row["iconid"];
   $dateline = $row["dateline"];

   $sql2 = "SELECT postid, threadid, username, userid, title, dateline, pagetext, iconid FROM post WHERE threadid = \"$threadid\" ORDER BY postid ASC LIMIT 1";
   $sql_result2 = mysql_query($sql2, $connection) or die ("Could not execute query in second sql statement.".mysql_error());

   if (!$sql_result2) 
     echo "Could not get news.";
   else
   {
     while ($row2 = mysql_fetch_array($sql_result2)) 
     {
       $ptext = $row2["pagetext"];
       $dateposted = date("j.n.Y G:i",$dateline);
       $commenttext = "Kommentar";
       
       if( $replycount!=1 )
        $commenttext .= "e";

       $outxt=$bbparser->do_parse($ptext, true, true, true, true, true, true);

       $trimmed = explode($splitval, $outxt);
       $outxt=$trimmed[0];

       $sql3 = "SELECT title FROM forum WHERE forumid = \"$forumid\" LIMIT 1";
       $sql_result3 = mysql_query($sql3, $connection) or die ("Could not execute query in second sql statement.");
       $row3 = mysql_fetch_array($sql_result3);
       $forumname = $row3["title"];
      
       $towrite .= "<div>$outxt</div>";

       $towrite .= "<hr size='1'>";
       
       $towrite .= "<div align='center'>";
       $towrite .= "Geschrieben von <a href=\"$forumspath/member.php?s=&amp;action=getinfo&amp;userid=$postuserid\"><b>$postusername</b></a> am <i>$dateposted</i><br>";
       $towrite .= "Kategorie: <a href=\"$forumspath/forumdisplay.php?s=&amp;forumid=$forumid\">$forumname</a><br>";
       $towrite .= "<a href=\"$forumspath/showthread.php?s=&amp;threadid=$threadid\">$replycount $commenttext</a>";
       $towrite .= "</div>";
       
       $towrite .= "<hr size='1'>";

       if( $iidx++ % 3 == 0 )
         $towrite .= "<table width='100%' border='0' align='center' cellpadding='0' cellspacing='0' bgcolor='#f7f7f7'><tr><td align='center'><iframe src='http://tralala.com/werbung.tralala' width='470' height='68' scrolling='no' marginheight='0' marginwidth='0' frameborder='0'></iframe></td></tr></table>";

       $towrite .= "<hr size='1'>";

       
     }
   }
 }
} 

echo $towrite;

?>