News Out - posts from forum(s) on any page

This script will let you pull the first posts from threads in a forum and display them on a non-vb page anywhere on your site.

For example you can use this to pull posts from a forum and display them as news. (Each post in the forum is a news item).

Currently it will pull them on the basis of thread start date.

This is very rough and ready. But maybe someone will find it useful.

If you read the code and comments you can do things like strip out tags, snip the post off after the first para etc etc.

You can choose to write out to a file or to write to screen. You can pull stuff from one or many forums.

I'll try and answer any questions that come up, but this is a beta so....

Rafe

[House_of_Crazed]

Well, it probably is the forumspath that has not been defined correctly.

Look for $forumspath

Smilies works fine on my site. It took me awhile to figure it out, lol ... *sigh* I'm happy I'm done with figuring it out. *laughs*

[hkvic]

Hmmm. the smilies are there if you view the newsout.php output, but disappear once the file is included into the .shtml page

[dfmafia]

having problems...i really want this to work properly...

here goes:

http://dfmafia.net/forums/newsout.php <-- works fine

http://dfmafia.net/network1.php <--- inop (its after the text "Need to fix the News script that when it grabs the articles out of the forums we don't loose right content ")

heres the code im using to include the newsout.php:

PHP Code:

<?php
include('/THE/DIRECTORY/TO/forums/newsout.php');
?>

(its after the text "Need to fix the News script that when it grabs the articles out of the forums we don't loose right content ")



that first NEWS block works fine but all it did was grab the titles...i want part of the text as well...


http://dfmafia.net/network.php

im using the below script and it gets what i want but i loose the right table and footer on the page...

PHP Code:

<?php
error_reporting(E_ALL & ~E_NOTICE);
define('NO_REGISTER_GLOBALS', 1);
define('THIS_SCRIPT', 'news');
require_once('global.php');
require_once('./forums/includes/functions_bbcodeparse.php');
$news = mysql_query("select thread.threadid,thread.title,thread.replycount,thread.postusername,thread.dateline,post.postid,post.pagetext from thread,post where thread.forumid=3 and post.postid=thread.firstpostid group by thread.firstpostid order by threadid desc limit 10;");
$n = 0;
while($newsitem = mysql_fetch_row($news)){
$n++;
$newstitle[$n]=$newsitem["1"];
$newsreply[$n]=$newsitem["2"];
$newsuser[$n]=$newsitem["3"];
$newsdate[$n]=vbdate("D j M Y, g:i A",$newsitem["4"]);
$newsthread[$n]=$newsitem["5"];
$limittext[$n] = substr($newsitem["6"], 0, 200) . "...";
$newstext[$n]=parse_bbcode($limittext[$n]);
$newsavatar[$n]=$newsitem["7"];
}
eval('$newstables = "' . fetch_template('news_table_s') . '";');
eval('$newstablem = "' . fetch_template('news_table_m') . '";');
eval('$newstablee = "' . fetch_template('news_table_e') . '";');
eval('print_output("' . fetch_template('news') . '");');
?>

heres how the page is suspose to look: http://dfmafia.net/network_A.php

minus the news...it has the right and footer content

[Sean S]

Thank you for this hack, but could you explain why I get this error by any chance?

Warning: mysql_query(): 6 is not a valid MySQL-Link resource in /home/static/public_html/forums/includes/db_mysql.php on line 212

Warning: mysql_error(): 6 is not a valid MySQL-Link resource in /home/static/public_html/forums/includes/db_mysql.php on line 357

Warning: mysql_errno(): 6 is not a valid MySQL-Link resource in /home/static/public_html/forums/includes/db_mysql.php on line 358

Warning: mysql_query(): 6 is not a valid MySQL-Link resource in /home/static/public_html/forums/includes/db_mysql.php on line 212

Warning: mysql_error(): 6 is not a valid MySQL-Link resource in /home/static/public_html/forums/includes/db_mysql.php on line 357

Warning: mysql_errno(): 6 is not a valid MySQL-Link resource in /home/static/public_html/forums/includes/db_mysql.php on line 358

everything else works fine, but at the bottom I get these errors.

[eLiTeGuRu]

Put a @ in front of the mysql queries.

[i-Symbian.Com]

eLITeGuRu,

I experienced the same as above. All working fine but I received these errors in the bottom of the page:

Warning: mysql_query(): 6 is not a valid MySQL-Link resource in usrlocalpsahomevhostsi-symbian.comhttpdocsforumincludesdb_mysql.php on line 212

Warning: mysql_error(): 6 is not a valid MySQL-Link resource in usrlocalpsahomevhostsi-symbian.comhttpdocsforumincludesdb_mysql.php on line 357

Warning: mysql_errno(): 6 is not a valid MySQL-Link resource in usrlocalpsahomevhostsi-symbian.comhttpdocsforumincludesdb_mysql.php on line 358

Warning: mysql_query(): 6 is not a valid MySQL-Link resource in usrlocalpsahomevhostsi-symbian.comhttpdocsforumincludesdb_mysql.php on line 212

Warning: mysql_error(): 6 is not a valid MySQL-Link resource in usrlocalpsahomevhostsi-symbian.comhttpdocsforumincludesdb_mysql.php on line 357

Warning: mysql_errno(): 6 is not a valid MySQL-Link resource in usrlocalpsahomevhostsi-symbian.comhttpdocsforumincludesdb_mysql.php on line 358

I have tried to put @ in front of mysql_query (there are 3 of them) like you suggested but still the same errors. It looks like this :

@mysql_query

Please advice. All appreciated.

Thanks and best regards

[EH-Jay]

Can anyone help me with this 1? I get the common 3 errors at the bottom of the page, and everything is setup as it should be.

Thanks

[rikku3978]

anyone getting the three lines of text at the bottom, remove:

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

From your newsout.php file and it should resolve it. ^^

[-=Sniper=-]

thaks dude it fixed it!

[greenhybrid]

Looks to be nice when it's finished. Thanks.