The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
|||
|
|||
Thread Getter/News code help (bbcode help)
I have this code to display a news feature for my site. I want to know how i can fix this up so that it will show bbcode as well as the html it already shows. So does anyone know how to fix this code up so that it will also display bbcode on the page this is inserted in?
Code:
<?php $connection = mysql_connect("localhost","username","password") or die ("Cannot connect to server."); $db = mysql_select_db("dbname", $connection) or die ("Could not select database."); $sql = "SELECT * FROM thread WHERE forumid='86' ORDER BY threadid DESC LIMIT 1"; $sql_result = mysql_query($sql, $connection) or die ("Could not execute query 1."); if (!$sql_result) { echo "<p>Could not get record."; } 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"]; $bericht = nl2br(strip_tags ($row['pagetext'], '<a><b><i><u><img><center>')); $sql2 = "SELECT * 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."); if (!$sql_result2) { echo "<p>Could not get record in second statement."; } while ($row2 = mysql_fetch_array($sql_result2)) { $pagetext = $row2["pagetext"]; $pagetext = nl2br (strip_tags ($row['pagetext'], '<a><b><i><u><img><center>')); $dateposted = date("j M Y",$dateline); $pagetext = nl2br (strip_tags ($row2['pagetext'], '<a><b><i><u><img><center>')); if ($replycount==1) { $commenttext = "Comment"; } else { $commenttext = "Comments"; } $bericht = nl2br(strip_tags ($row2['pagetext'], '<a><b><i><u><img><center>')); // ********************** //Edit the HTML here (keep in mind that any double quote that is HTML requires a backslash in front of it) echo "<table border=\"0\" width=\"100%\" bgcolor=\"#BFBFBF\" cellspacing=\"1\"> <tr> <td width=\"70%\" bgcolor=\"#004F7D\"><a href=\"forums/showthread.php?threadid=$threadid\"><font color=\"#FFFFFF\" style=\"font-size: 10px\" face=\"Verdana\"> ? <B>$title</B></td> </tr> <tr> <td width=\"100%\" bgcolor=\"#8E8E8E\" colspan=2><font color=\"#FFFFFF\" style=\"font-size: 10px\" face=\"Verdana\"><div align=\"center\">$bericht</div></td> </tr></table><br>"; } } echo ""; mysql_free_result($sql_result); mysql_close($connection); ?> |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|