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); ?> |
#2
|
||||
|
||||
Take a look at functions_bbcodeparse.php, especially the functions parse_bbcode() and parse_bbcode2().
|
#3
|
|||
|
|||
i did , but i am still al ittle confused
|
#4
|
|||
|
|||
Will this work? or am i way off?
Code:
<?php $connection = mysql_connect("localhost","username","password") or die ("Cannot connect to server."); $db = mysql_select_db("db_name", $connection) or die ("Could not select database."); $sql = "SELECT * FROM thread WHERE forumid='8' ORDER BY threadid DESC LIMIT 7"; $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"]; if ("$bericht"); { $bericht = nl2br(strip_tags ($row['pagetext'], '<a><b><i><u><img><center>')); $bericht = preg_replace ( "/\[img\](.+?)\[\/img\]/", "<img src=\"$1\" />", $bericht ); $bericht = preg_replace ( "/\[url\=(.+?)\](.+?)\[\/url\]/", "<a href=\"$1\" target=\"_blank\">$2</a>", $bericht ); $bericht = preg_replace ( "/\[move\](.+?)\[\/move\]/", "<marquee>$1</marquee>", $bericht ); $bericht = preg_replace ( "/\[b\](.+?)\[\/b\]/", "<b>$1</b>", $bericht ); $bericht = preg_replace ( "/\[i\](.+?)\[\/i\]/", "<i>$1</i>", $bericht ); } $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>')); 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> -- $dateposted</td> </tr> <tr> <td width=\"100%\" bgcolor=\"#8E8E8E\" colspan=2><font color=\"#FFFFFF\" style=\"font-size: 10px\" face=\"Verdana\">$bericht</td> </tr> <tr> <td bgcolor=\"#004F7D\" cellspacing=\"1\" height=\"19\"><font face=\"verdana\" size=\"1\" color=\"#FFFFFF\"><div align=\"right\"><B> $replycount</B> Comments. Last comment by <B>$lastposter</B></div></td> </tr></table><br>"; } } echo ""; ?> |
#5
|
|||
|
|||
This is what i have now and still no luck... any ideas?
Code:
<?php chdir("./forums/"); include('./global.php'); include('./includes/functions_user.php'); chdir("../"); ?> 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='8' ORDER BY threadid DESC LIMIT 7"; $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>')); // This parses the bbcode require_once("forums/includes/functions_bbcodeparse.php"); $bericht=parse_bbcode2($ptext,"1","1","1","1","1"); // Uncomment next 4 lines if you want to limit the amount of text displayed to the first paragraph. // $trimmed = explode("<br />", $bericht); // $bericht=$trimmed[0]; // $trimmed = explode("</p>", $bericht); // $bericht=$trimmed[0]; // This is optional. It strips out unecessary tags if you wish and leaves those specified behind // $bericht = strip_tags($bericht, '<a>,<b>,<strong>,<i>,<em>,<br />,<br>,<p>'); $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> -- $dateposted</td> </tr> <tr> <td width=\"100%\" bgcolor=\"#8E8E8E\" colspan=2><font color=\"#FFFFFF\" style=\"font-size: 10px\" face=\"Verdana\">$bericht</td> </tr> <tr> <td bgcolor=\"#004F7D\" cellspacing=\"1\" height=\"19\"><font face=\"verdana\" size=\"1\" color=\"#FFFFFF\"><div align=\"right\"><B> $replycount</B> Comments. Last comment by <B>$lastposter</B></div></td></tr></table><br>"; } } echo ""; mysql_free_result($sql_result); mysql_close($connection); ?> |
#6
|
|||
|
|||
Ok I got it to show the bbcode but now the post won't show right meaning the title's are in the right spot but the actual content it is one down..... any ideas?
you can see what i mean at http://gamersassault.net here is what i am using now. Code:
<?php chdir("./forums/"); include('./global.php'); include('./includes/functions_user.php'); chdir("../"); ?> <?php $connection = mysql_connect("localhost","_______","_________") or die ("Cannot connect to server."); $db = mysql_select_db("________", $connection) or die ("Could not select database."); $sql = "SELECT * FROM thread WHERE forumid='8' ORDER BY threadid DESC LIMIT 7"; $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"]; require_once("forums/includes/functions_bbcodeparse.php"); $newscode=parse_bbcode2($ptext,"1","1","1","1","1"); $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)) { $ptext = $row2["pagetext"]; $dateposted = date("j M Y",$dateline); if ($replycount==1) { $commenttext = "Comment"; } else { $commenttext = "Comments"; } // ********************** 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> -- $dateposted</td> </tr> <tr> <td width=\"100%\" bgcolor=\"#8E8E8E\" colspan=2><font color=\"#FFFFFF\" style=\"font-size: 10px\" face=\"Verdana\">$newscode</td> </tr> <tr> <td bgcolor=\"#004F7D\" cellspacing=\"1\" height=\"19\"><font face=\"verdana\" size=\"1\" color=\"#FFFFFF\"><div align=\"right\"><B> $replycount</B> Comments. Last comment by <B>$lastposter</B></div></td></tr></table><br>"; } } echo ""; mysql_free_result($sql_result); mysql_close($connection); ?> |
#7
|
||||
|
||||
That does not make too much sense:
If you require global.php you can and should use vBs database class. You might also want to add PHP Code:
|
#8
|
|||
|
|||
ok but any idea how to make it so that the right title will go with the right content and not post one down?
|
#9
|
|||
|
|||
Ok i was able to fix the problem i was having above with the news not posting with the right title. you can see what i mean at this url http://gamersassault.net/bf2 Now i am getting errors that say this:
Code:
Warning: mysql_query(): 7 is not a valid MySQL-Link resource in homeguppypublic_htmlbf2forumsincludesdb_mysql.php on line 212 Warning: mysql_error(): 7 is not a valid MySQL-Link resource in homeguppypublic_htmlbf2forumsincludesdb_mysql.php on line 357 Warning: mysql_errno(): 7 is not a valid MySQL-Link resource in homeguppypublic_htmlbf2forumsincludesdb_mysql.php on line 358 Code:
<?php chdir("./forums/"); define('NO_REGISTER_GLOBALS', 1); define('LOCATION_BYPASS', 1); define('SESSION_BYPASS', 1); include('./global.php'); chdir("../"); ?> <?php $connection = mysql_connect("localhost","________","_______") or die ("Cannot connect to server."); $db = mysql_select_db("________", $connection) or die ("Could not select database."); $sql = "SELECT * FROM thread WHERE forumid='192' ORDER BY threadid DESC LIMIT 7"; $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"]; $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)) { $ptext = $row2["pagetext"]; $ptext = nl2br (strip_tags ($row['pagetext'], '<a><b><i><u><img><center>')); $dateposted = date("j M Y",$dateline); $ptext = nl2br (strip_tags ($row2['pagetext'], '<a><b><i><u><img><center>')); if ($replycount==1) { $commenttext = "Comment"; } else { $commenttext = "Comments"; } require_once("http://gamersassault.net/forums/includes/functions_bbcodeparse.php"); $newscode=parse_bbcode2($ptext,"1","1","1","1","1"); // ********************** echo "<table border=\"0\" width=\"100%\" bgcolor=\"#BFBFBF\" cellspacing=\"1\"> <tr> <td width=\"70%\" bgcolor=\"#EFC99C\"><a href=\"\forums/showthread.php?threadid=$threadid\"><font color=\"#333333\" style=\"font-size: 10px\" face=\"Verdana\"> ? <B>$title</B> -- $dateposted</td> </tr> <tr> <td width=\"100%\" bgcolor=\"#8E8E8E\" colspan=2><font color=\"#FFFFFF\" style=\"font-size: 10px\" face=\"Verdana\">$newscode</td> </tr> <tr> <td bgcolor=\"#EFC99C\" cellspacing=\"1\" height=\"19\"><font face=\"verdana\" size=\"1\" color=\"#333333\"><div align=\"right\"><a href=\"\forums/showthread.php?threadid=$threadid\"><B> $replycount</B> Comments</a>. Last comment by <B>$lastposter</B></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:
|