The Arcive of Official vBulletin Modifications Site.

GuppyWithAGun · #1 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?

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\">&nbsp;? <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);

?>

Andreas · #2 01-25-2005, 11:22 PM

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

GuppyWithAGun · #3 01-25-2005, 11:36 PM

i did , but i am still al ittle confused

GuppyWithAGun · #4 02-05-2005, 04:41 AM

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\">&nbsp;? <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 "";


?>

GuppyWithAGun · #5 02-08-2005, 02:53 AM

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\">&nbsp;? <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);

?>

GuppyWithAGun · #6 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.

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\">&nbsp;? <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);

?>

Andreas · #7 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

PHP Code:


			
define('NO_REGISTER_GLOBALS', 1);

define('LOCATION_BYPASS', 1);

define('SESSION_BYPASS', 1);

before requiring lobal.php to reduce overhead.

GuppyWithAGun · #8 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 · #9 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:

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

And here is the code i am using now

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\">&nbsp;? <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);

?>

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.04173 seconds Memory Usage 2,283KB Queries Executed 13 (?)
More Information
Template Usage: (1)SHOWTHREAD (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)ad_showthread_beforeqr (1)ad_showthread_firstpost (1)ad_showthread_firstpost_sig (1)ad_showthread_firstpost_start (7)bbcode_code (1)bbcode_php (1)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)navbar (3)navbar_link (120)option (9)post_thanks_box (9)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (9)post_thanks_postbit_info (9)postbit (9)postbit_onlinestatus (9)postbit_wrapper (1)spacer_close (1)spacer_open (1)tagbit_wrapper Phrase Groups Available: global inlinemod postbit posting reputationlevel showthread	Included Files: ./showthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/functions_bigthree.php ./includes/class_postbit.php ./includes/class_bbcode.php ./includes/functions_reputation.php ./includes/functions_post_thanks.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_postinfo_query fetch_postinfo fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete showthread_start showthread_getinfo forumjump showthread_post_start showthread_query_postids showthread_query bbcode_fetch_tags bbcode_create showthread_postbit_create postbit_factory postbit_display_start post_thanks_function_post_thanks_off_start post_thanks_function_post_thanks_off_end post_thanks_function_fetch_thanks_start post_thanks_function_fetch_thanks_end post_thanks_function_thanked_already_start post_thanks_function_thanked_already_end fetch_musername postbit_imicons bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete postbit_display_complete post_thanks_function_can_thank_this_post_start tag_fetchbit_complete forumrules navbits navbits_complete showthread_complete
Messages:

The Arcive of Official vBulletin Modifications Site.

It is not a VB3 engine, just a parsed copy!