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

[AlexSFBay]

Wow, you've read my mind. I've been piecing together a bunch of hacks to come up with something like this. I've downloaded it and I'll give you my thoughts on how the process went for me. In any case, excellent work, and it's very much appreciated!

[AlexSFBay]

The script works, but I'm getting errors at the end

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

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

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

Any thoughts on how I can resolve this?

[-=Sniper=-]

I get the same error! if someone can do me a similar hack! which allows me to use smilies, etc etc

then please contact me!

[Viruseater]

Wouldn't it be easier if you used

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

that way you wouldn't need to use all the hard codes.

[AlexSFBay]

I randomly get "Unable to add cookies, header already sent." Any ideas how can fix that?

[AlexSFBay]

I figured it out! After a couple hours of tweaking my script, I finally figured out that

chdir('forums/');
require_once('./global.php');

needs to be located right at the very top (before any other additional PHP code -- ie header.php) in order to avoid the cookie error message.

[eLiTeGuRu]

After messing around with this code, I realized that if you have a table prefix, it will not work. Therefore do this:

Find around line 45

PHP Code:

$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"; 


Change to:

PHP Code:

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


Find Line 67

PHP Code:

$sql2 = "SELECT postid, threadid, username, userid, title, dateline, pagetext, iconid FROM post WHERE threadid = \"$threadid\" ORDER BY postid ASC LIMIT 1"; 


Change to:

PHP Code:

$sql2 = "SELECT postid, threadid, username, userid, title, dateline, pagetext, iconid FROM YOURTABLEPREFIX_post WHERE threadid = \"$threadid\" ORDER BY postid ASC LIMIT 1"; 


and

Find around line 104

PHP Code:

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


Change to

PHP Code:

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


[-=Sniper=-]

Originally Posted by AlexSFBay

The script works, but I'm getting errors at the end

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

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

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

Any thoughts on how I can resolve this?

ok, I moved to a new server and its working fine! maybe its something to do with the server settings?

[Dan]

Hmm.... interesting mod. I could use this to work on a new custom portal. thanks for sharing it!

[lcryan]

<a href="http://www.liquid-core.net/forums/news.php" target="_blank">http://www.liquid-core.net/forums/news.php</a>

I'm getting 'Could not execute query.'