vb.org Archive - Thread Getter/News code help (bbcode help)

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- Modification Requests/Questions (Unpaid) (https://vborg.vbsupport.ru/forumdisplay.php?f=112)

- - Thread Getter/News code help (bbcode help) (https://vborg.vbsupport.ru/showthread.php?t=75122)

GuppyWithAGun

01-25-2005 11:11 PM

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\">&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

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?

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

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

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

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

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:

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);



?>

All times are GMT. The time now is 04:26 PM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.02942 seconds Memory Usage 1,808KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (7)bbcode_code_printable (1)bbcode_php_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (9)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.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/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: