PluhNews 1.5

UPDATED! Woohoo!

I just fixed/added stuff from version 1.0!

Download the new version 1.5 if you have the old 1.0 - lots of better features.

From the readme.txt:

This script isn't really a hack, just an external script that pulls information out of the VBulletin Database for news
or whatever reason you see fit. It's easy to install and configure, and has tons of the same features that many other
news scripts have, except you don't have to modify any Vbulletin source code (which I'm never comfortable doing
for some reason, but that's just me .

I had a really rough time finding a good, EASY news script that did what this does. I searched and found some, but
it really came down to easy installation. I didn't want to modify MySql tables or mess with the advanced Vbulletin
source (well, to me anyway). So I wrote this script. Yer.

This script was intended for VBulletin 2.0 only (I don't know if it will work with previous releases) and PHP4.

Working Demos can be found in use at http://pluh.com/forums/PluhNews.php and for headlines,
http://pluh.com/forums/PluhHeadlines.php

After you install, if at all possible, I would appreciate some credit to my script. A link to http://pluh.com
on your page before or after your news would be great. Let me know when you have it installed too - I love
seeing my stuff working on other websites!

You can check out the raw demo here for PluhNews: http://pluh.com/forums/PluhNews.php

And Headlines! http://pluh.com/forums/PluhHeadlines.php


Let me know if you like it! (Thanks Dark Wizard and Bane)

*NOTE: I will not be able to provide support for this hack, as I am extremely busy. Sorry...*

[DarkReaper]

Does this work with 2.2.0?

[Hamma]

Yes.

[Mac Write]

if I go to /forums/Pluhcomments.php (I named it that for a differrent use on my site) it works fine, but if I include it in a php file in a /folder/ as

<?php Include ("/forums/Pluhcomments.php"); ?>

I get the following

Fatal error: Failed opening required 'global.php' (include_path='.:/usr/lib/php') in /pathnamedeletedl/forums/Pluhcomments.php on line 5

So what do I change so that I don't get this error?

I also included the pluhconfig in the comments.php script I am changing since I want it to display the info for a certain thread (I will hard code the thread ID into each article and include the comments.php)

This is a great Hack Perfect. Or better yet, if you could post the code to do this

X Comments last post by user" line only and then set it so that I can have a var $threadid= that I have in the article that it grabs to tie the above to the thread for the article?

thanks

[Mac Write]

Ok I moved the require global/admin to the test page, and now I am getting

Warning: Access denied for user: 'root@localhost' (Using password: NO) in /pathdeleted/forums/Pluhcomments.php on line 17

Warning: MySQL Connection Failed: Access denied for user: 'root@localhost' (Using password: NO) in pathdeleted/forums/Pluhcomments.php on line 17
Cannot connect to server.

??? what am I doing wrong?

I added .mydomain.mydomain.org to the cookies this (changed name of real domain).

So what am I doing wrong? I am still completely new to PHP.

HELP!!!!!!!!!!!!!

[Mac Write]

Back to square one.

I want to Include PluhHeadlines.php on each article page. All articles are in a /folder off main site.

So I do

PHP Code:

Virtual ("/forums/PluhHeadlines.php") 


So then I remove the

PHP Code:

require("./global.php") require("./admin/config.php"); 


and put them @ the top of my test page which is in

www.mysite.com/critcalmass/some-article.php

Now I get the Error

Fatal error: Failed opening required './global.php' (include_path='.:/usr/lib/php') in /path/to/site/html/criticalmass/airport-made-for-mac-os-x.php on line 1

I also tried it with /forums/global.php and still no go

What am I missing? I am still completely new to PHP.


As I was writing this, I tried using Absolute paths, and it works. I have implemented the headlines.php to replace my "This Week @Mac Write" at the top of all pages.

Now to try out the Pluhnews.php but This afternoon it's 3AM and I need to get sleep (or finish watching TRUE LIES?)

[amykhar]

Here's a minor improvement to the hack that will allow you to use more than one forum as your source for news.

In PluhNews.php Find:

PHP Code:

$sql = "SELECT threadid, title, forumid, replycount, postusername, postuserid, lastposter, dateline, iconid FROM thread WHERE forumid = "$newsforums" ORDER BY threadid DESC LIMIT $newsitems"; 


Replace with:

PHP Code:

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


in PluhConfig.php you can now add multiple forums, surrounded by quotes and separated by commas:

example:

PHP Code:

$newsforums = "72,76"; 


I haven't tested the headlines script, but it goes like this:

In PluhHeadlines.php Find:

PHP Code:

$sql = "SELECT threadid, title, forumid, replycount, postusername, postuserid, lastposter, dateline, iconid FROM thread WHERE forumid = "$newsforums" ORDER BY threadid DESC LIMIT $newsitems"; 


Replace with:

PHP Code:

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


Amy

[amykhar]

This "tweak" is for people who installed fastforward's spider friendly urls.

In PluhNews.php Find:
//gotta convert that damn unix time crap

Add BEFORE:

PHP Code:

$linkcode = "$forumspath/t".$threadid .".html"; 


Find:

PHP Code:

echo "

<a href="$forumspath/showthread.php?s=&threadid=$threadid"><b>$title</b></a> - <a href="$forumspath/showthread.php?s=&threadid=$threadid"><b>$replycount</b> $commenttext</a><br>
Posted By <a href="$forumspath/member.php?s=&action=getinfo&userid=$postuserid"><b>$postusername</b></a> at  <i>$dateposted</i>
</center>

<blockquote></a>$bericht</blockquote><center><a href="$forumspath/showthread.php?s=&threadid=$threadid"><b>$replycount</b> $commenttext</a> Last comment was by <b>$lastposter</b></center><hr noshade height="1" width="60%"><p>
"; 


Replace with:

PHP Code:

echo "

<a href="$linkcode"><b>$title</b></a> - <a href="$linkcode"><b>$replycount</b> $commenttext</a><br>
Posted By <a href="$forumspath/member.php?s=&action=getinfo&userid=$postuserid"><b>$postusername</b></a> at  <i>$dateposted</i>
</center>

<blockquote></a>$bericht</blockquote><center><a href="$linkcode"><b>$replycount</b> $commenttext</a> Last comment was by <b>$lastposter</b></center><hr noshade height="1" width="60%"><p>
"; 


[DarkReaper]

Cool additions. I've got an idea though:

What about allowing a paramater to be passed. For example, pluhnews.php?site=site1 would give news for the forum designated as "site1."

[amykhar]

I THINK you can do that by removing the variable $newsforums from the config file and then passing it in as the parameter.

newsforums=1 for example.

Amy

[Mac Write]

I have

"X Comments posted by XXXX" I want to manually enter the thread ID that this link, and the thrad it pulls the info from.

So what do I change to fix it?