vb.org Archive - News Out - posts from forum(s) on any page

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

- vBulletin 3.0 Beta Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=34)

- - News Out - posts from forum(s) on any page (https://vborg.vbsupport.ru/showthread.php?t=65114)

Here's what I was able to achieve with some creative modification of the code:
http://www.greenhybrid.com/

Quote:

Originally Posted by greenhybrid

Here's what I was able to achieve with some creative modification of the code:
http://www.greenhybrid.com/

Nice work on the greenhybrid site! Would you mind sharing your PHP parse code -- I'm guessing you used preg_replace() -- to format the source link on the front page?

i need to know the name of the table to extract the info.

How do i find out plz :]

I'm having a big bug with this hack.

Apparently calling global.php, as this hack does, is erasing all other variables in the php defined before it.

I've associated pages on my site with forums and have stored a forumid for each page in my db. I wanted to pull that forumid, pass it to this script, and have it print out topics.

However upon calling global.php the variable holding my forumid is erased. I don't know why, I can't explain it, but I tested it and its happening.

So, there is no way to dynamically feed this script information, for god knows what reason...

This is how global.php does work. It will reset all variables to protect against abuse.

Try to place global.php at the top of your script before you fill any other var's.

Quote:

Quote: Originally Posted by greenhybrid
Here's what I was able to achieve with some creative modification of the code:
http://www.greenhybrid.com/

Nice work on the greenhybrid site! Would you mind sharing your PHP parse code -- I'm guessing you used preg_replace() -- to format the source link on the front page?

I figured it out... in case anybody was curious. See PHP function parse_url.

Code:

<?php

$myDomain = parse_url("http://www.yahoo.com/index.php#examples");

echo "Scheme: " . $myDomain["scheme"] . "<br>";

echo "Domain: " . $myDomain["host"] . "<br>";

echo "Path: " . $myDomain["path"] . "<br>";

echo "Anchor: " . $myDomain["fragment"] . "<br>";

?>

RESULT:
Scheme: http
Domain: www.yahoo.com
Path: /index.php
Anchor: examples

You can tweak it from there. Have fun!

Quote:

Originally Posted by AlexSFBay

I figured it out... in case anybody was curious. See PHP function parse_url.

Code:

<?php

$myDomain = parse_url("http://www.yahoo.com/index.php#examples");

echo "Scheme: " . $myDomain["scheme"] . "<br>";

echo "Domain: " . $myDomain["host"] . "<br>";

echo "Path: " . $myDomain["path"] . "<br>";

echo "Anchor: " . $myDomain["fragment"] . "<br>";

?>

RESULT:
Scheme: http
Domain: www.yahoo.com
Path: /index.php
Anchor: examples

You can tweak it from there. Have fun!

I just realized there's more to the "Source" link function. Your script needs to be able to scan the text output and capture the URL. Anyone wanna take a stab on how to do that.

I was also wondering how one can have an excerpted post for news threads that links back to your custom CMS page. See example in action here. (I figured out that this site is using the vBulletin-WordPress Bridge hack)

can anyone please help me with that problem?

I just upgraded to 3.5 (this script worked without any problems in 3.0.9 - sorry I know that it is not written for 3.5)

I'm getting mad because of no idea / brain on the bbcode parser.

Original does not work (in 3.5):

PHP Code:


		
			
require_once("./includes/functions_bbcodeparse.php");

$outxt=parse_bbcode2($ptext,"1","1","1","1","1");

prints now following error after upgrade to vb3.5

Code:

Fatal error: Call to a member function on a non-object in D:\server\mobilejoe\joeforums\includes\functions_bbcodeparse.php on line 398

This one looks better using old bbcode function but far away from how it should be (see screenshot below) because it still shows ****** bbcode. How can I fix this?

PHP Code:


		
			
require_once("./includes/functions_bbcodeparse.php");      

$outxt=parse_bbcode2($ptext,"1","1","","","");

oOoops - This thing does not exist in 3.5 - https://vborg.vbsupport.ru/showthread.php?t=82693 This is way to much for me.

Oups?

Problem: You cannot use old parser, connect dies within script.

I finally got this to work. A friend of mine found out, that the db connect was broken and the new parser didn't work because of that issue. Here's what I did on my page to get this working in 3.5 including new Parser and Fix within db connect (including advertising after 3 news):

See this line:
$xdb = mysql_select_db("$dbname", $connection) or die ("Could not select database.");

PHP Code:


		
			
<?php

require_once("./global.php");

require_once('./includes/class_bbcode.php');



$splitval="lest mehr hier";

$cats="19"; //"2,3,4,5,6";

$newsitems=10;

$forumspath="http://www.tralala.de/tralala";



$servername="localhost";

$dbusername="tralala";

$dbpassword="tralala";

$dbname="tralalatabelle";



//**************************************************************************************************************//



$iidx = 0;



$bbparser =& new vB_BbCodeParser($vbulletin, fetch_tag_list()); 



$connection = mysql_connect("$servername","$dbusername","$dbpassword") or die ("Cannot connect to server.");

$xdb = mysql_select_db("$dbname", $connection) or die ("Could not select database.");



$sql = "SELECT threadid, title, forumid, replycount, postusername, postuserid, lastposter, dateline, iconid FROM thread WHERE forumid IN ($cats) AND sticky = '0' ORDER BY threadid DESC LIMIT $newsitems";

$sql_result = mysql_query($sql, $connection) or die ("Could not execute query.".mysql_error());



if (!$sql_result) 

echo "Could not get news.";

else

{

 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 postid, threadid, username, userid, title, dateline, pagetext, iconid 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.".mysql_error());



   if (!$sql_result2) 

     echo "Could not get news.";

   else

   {

     while ($row2 = mysql_fetch_array($sql_result2)) 

     {

       $ptext = $row2["pagetext"];

       $dateposted = date("j.n.Y G:i",$dateline);

       $commenttext = "Kommentar";

       

       if( $replycount!=1 )

        $commenttext .= "e";



       $outxt=$bbparser->do_parse($ptext, true, true, true, true, true, true);



       $trimmed = explode($splitval, $outxt);

       $outxt=$trimmed[0];



       $sql3 = "SELECT title FROM forum WHERE forumid = \"$forumid\" LIMIT 1";

       $sql_result3 = mysql_query($sql3, $connection) or die ("Could not execute query in second sql statement.");

       $row3 = mysql_fetch_array($sql_result3);

       $forumname = $row3["title"];

      

       $towrite .= "<div>$outxt</div>";



       $towrite .= "<hr size='1'>";

       

       $towrite .= "<div align='center'>";

       $towrite .= "Geschrieben von <a href=\"$forumspath/member.php?s=&amp;action=getinfo&amp;userid=$postuserid\"><b>$postusername</b></a> am <i>$dateposted</i><br>";

       $towrite .= "Kategorie: <a href=\"$forumspath/forumdisplay.php?s=&amp;forumid=$forumid\">$forumname</a><br>";

       $towrite .= "<a href=\"$forumspath/showthread.php?s=&amp;threadid=$threadid\">$replycount $commenttext</a>";

       $towrite .= "</div>";

       

       $towrite .= "<hr size='1'>";



       if( $iidx++ % 3 == 0 )

         $towrite .= "<table width='100%' border='0' align='center' cellpadding='0' cellspacing='0' bgcolor='#f7f7f7'><tr><td align='center'><iframe src='http://tralala.com/werbung.tralala' width='470' height='68' scrolling='no' marginheight='0' marginwidth='0' frameborder='0'></iframe></td></tr></table>";



       $towrite .= "<hr size='1'>";



       

     }

   }

 }

} 



echo $towrite;



?>

X vBulletin 3.8.12 by vBS Debug Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (3)bbcode_code_printable (3)bbcode_php_printable (3)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (3)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (10)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 pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages:

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01704 seconds Memory Usage 1,802KB 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 (3)bbcode_code_printable (3)bbcode_php_printable (3)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (3)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (10)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 pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: