Thread Getter/News code help (bbcode help) [Archive]

View Full Version : Thread Getter/News code help (bbcode help)

GuppyWithAGun

01-25-2005, 11:11 PM

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?

<?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 "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><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 "Could not get record in second statement.";

}

while ($row2 = mysql_fetch_array($sql_result2)) {

$pagetext = $row2["pagetext"];

$pagetext = nl2br (strip_tags ($row['pagetext'], '<a><img><center>'));

$dateposted = date("j M Y",$dateline);

$pagetext = nl2br (strip_tags ($row2['pagetext'], '<a><img><center>'));

if ($replycount==1) {

$commenttext = "Comment";

}

else {

$commenttext = "Comments";

}

$bericht = nl2br(strip_tags ($row2['pagetext'], '<a><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\"> ? $title</td>

</tr>

<tr>

<td width=\"100%\" bgcolor=\"#8E8E8E\" colspan=2><div align=\"center\">$bericht</div></td>

</tr></table> ";

}

}

echo "";

mysql_free_result($sql_result);

mysql_close($connection);

?>

Andreas

01-25-2005, 11:22 PM

Take a look at functions_bbcodeparse.php, especially the functions parse_bbcode() and parse_bbcode2().

GuppyWithAGun

01-25-2005, 11:36 PM

i did , but i am still al ittle confused

GuppyWithAGun

02-05-2005, 04:41 AM

Will this work? or am i way off?

<?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 "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><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\]/", "$1", $bericht );
$bericht = preg_replace ( "/\[i\](.+?)\[\/i\]/", "$1", $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 "Could not get record in second statement.";

}

while ($row2 = mysql_fetch_array($sql_result2)) {

$pagetext = $row2["pagetext"];
$pagetext = nl2br (strip_tags ($row['pagetext'], '<a><img><center>'));
$dateposted = date("j M Y",$dateline);
$pagetext = nl2br (strip_tags ($row2['pagetext'], '<a><img><center>'));

if ($replycount==1) {

$commenttext = "Comment";

}

else {

$commenttext = "Comments";

}

$bericht = nl2br(strip_tags ($row2['pagetext'], '<a><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\"> ? $title -- $dateposted</td>
</tr>
<tr>
<td width=\"100%\" bgcolor=\"#8E8E8E\" colspan=2>$bericht</td>
</tr>
<tr>
<td bgcolor=\"#004F7D\" cellspacing=\"1\" height=\"19\"><div align=\"right\"> $replycount Comments. Last comment by $lastposter</div></td>
</tr></table> ";

}

}

echo "";

?>

GuppyWithAGun

02-08-2005, 02:53 AM

This is what i have now and still no luck... any ideas?

<?php
chdir("./forums/");
include('./global.php');
include('./includes/functions_user.php');
chdir("../");
?>

<?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 "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><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(" ", $bericht);
// $bericht=$trimmed[0];
// $trimmed = explode("", $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>,,,,, , ,');

$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 "Could not get record in second statement.";

}

while ($row2 = mysql_fetch_array($sql_result2)) {

$pagetext = $row2["pagetext"];

$pagetext = nl2br (strip_tags ($row['pagetext'], '<a><img><center>'));

$dateposted = date("j M Y",$dateline);

$pagetext = nl2br (strip_tags ($row2['pagetext'], '<a><img><center>'));

if ($replycount==1) {

$commenttext = "Comment";

}

else {

$commenttext = "Comments";

}

$bericht = nl2br(strip_tags ($row2['pagetext'], '<a><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\"> ? $title -- $dateposted</td>
</tr>
<tr>
<td width=\"100%\" bgcolor=\"#8E8E8E\" colspan=2>$bericht</td>
</tr>
<tr>
<td bgcolor=\"#004F7D\" cellspacing=\"1\" height=\"19\"><div align=\"right\"> $replycount Comments. Last comment by $lastposter</div></td></tr></table> ";

}

}

echo "";

mysql_free_result($sql_result);

mysql_close($connection);

?>

GuppyWithAGun

02-09-2005, 11:27 PM

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.

<?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 "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 "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\"> ? $title -- $dateposted</td>
</tr>
<tr>
<td width=\"100%\" bgcolor=\"#8E8E8E\" colspan=2>$newscode</td>
</tr>
<tr>
<td bgcolor=\"#004F7D\" cellspacing=\"1\" height=\"19\"><div align=\"right\"> $replycount Comments. Last comment by $lastposter</div></td></tr></table> ";

}

}

echo "";

mysql_free_result($sql_result);

mysql_close($connection);

?>

Andreas

02-09-2005, 11:43 PM

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

define('NO_REGISTER_GLOBALS', 1);
define('LOCATION_BYPASS', 1);
define('SESSION_BYPASS', 1);

before requiring lobal.php to reduce overhead.

GuppyWithAGun

02-10-2005, 10:33 PM

ok but any idea how to make it so that the right title will go with the right content and not post one down?

GuppyWithAGun

02-12-2005, 04:05 PM

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:

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

And here is the code i am using now

<?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 "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 "Could not get record in second statement.";

}

while ($row2 = mysql_fetch_array($sql_result2)) {

$ptext = $row2["pagetext"];

$ptext = nl2br (strip_tags ($row['pagetext'], '<a><img><center>'));

$dateposted = date("j M Y",$dateline);
$ptext = nl2br (strip_tags ($row2['pagetext'], '<a><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\"> ? $title -- $dateposted</td>
</tr>
<tr>
<td width=\"100%\" bgcolor=\"#8E8E8E\" colspan=2>$newscode</td>
</tr>
<tr>
<td bgcolor=\"#EFC99C\" cellspacing=\"1\" height=\"19\"><div align=\"right\"><a href=\"\forums/showthread.php?threadid=$threadid\"> $replycount Comments</a>. Last comment by $lastposter</div></td></tr></table> ";

}

}

echo "";

mysql_free_result($sql_result);
mysql_close($connection);

?>