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...*

[sianews]

Originally posted by usbnuts

I think you just have to change one line to grab any thread titles forum catergoies you want.

// create sql statement
$sql = "SELECT threadid, title, forumid, replycount, postusername, postuserid, lastposter, dateline, iconid FROM thread WHERE forumid = "1" AND forumid = "2" AND forumid = "3" ORDER BY dateline DESC LIMIT $newsitems";

That's not working for me either. I'm getting no news displayed, but the "search for news" and "view all news" as well as the footer are all displayed.

If a delete both AND statements, the code works fine. Any way around this?

[Brian Cruz]

I have a question...

Whenever I need to close my board, my main page (which displays headlines) becomes a broken mess, with the "forum closed" message appearing somewhere in the middle. Is there a way to make it display something like "Headlines are temporarily unavailable" whenever the board is closed?

[Sean]

Sorry, can't help there, anyone else? :\

God, this script ROCKS! It is SOOO Easy to modify!!! http://g-designs.electron-designs.com/

I made that site for someone I host, that main page, and all the member's pages are news loaded off the boards. That is all inside a huge template. I also made the script say "Last Comment By: N/A" when there were no comments...AND I made it so if there is no news, it says so... I am so proud!!!! Now I just need to figure out where I will put the headlines...

If anyone wants my code, just ask.

[sianews]

I agree, the script is great - but someone must make a category addon .

[Sean]

Yes, a Category addon would be awesome.

[sianews]

So, anyone want to try and help with this category add-on?

[Sean]

Jeez... Now I am getting an error... It's from the smily parse thing...:

Database error in vBulletin 2.2.1:

Invalid SQL: SELECT smilietext,smiliepath FROM smilie
mysql error:

mysql error number: 0

Date: Saturday 29th of December 2001 10:04:57 AM
Script: http://forums.electron-designs.com/
Referer:

The weird thing: It works 100% on MY computer, but once on my server, it gives me this error...What could it be?

-Sean

[sianews]

Doesn't anyone use this anymore?

If categories aren't possible, is there anyway to make the script draw headlines frommultiple forum?

[Sean]

Yeah. I did.

What I did:

I used isset($variable) in an if statement. Then, whatever that variable was, it loaded: conf_$variable. Hence, loading a different configuration file for a different name...

I only had about 4-5 forums to do that with..

[sianews]

Can you post the code here? I'm to new to PHP to figure it out .

[Sean]

Sure.. Ok, now just change the path and stuff to the path to whatever PHP file you put this on:

<?
require("/path/to/global.php");
require("/path/to/admin/config.php");
//first load global.php & the vB config file

//use this if you want two variables at the top /?var1=blah&var2=blah

if (isset($var1) && isset($var2))  {include ("/path/to/var1.php");}
//You can also use var2 in the path, or use it to determine what conf file you want to load...

//Use this if you want one variable /?var1=blah
if (isset($var1))  {include ("/path/to/var1.php");}


//Ok, now on the page load the conf_$var1 file (specified above) than include the news.php file

include("/path/to/news/conf_$var1");
include("/path/to/PluhNews.php");

?>

Now, if their are any errors, let me relook the code, I sorta wrote the whole thing in here.. BTW: I am no PHP pro. i just know this stuff.

[sianews]

I must be dumbed then I thought .

What/Where is "path/to/var1.php" and "path/to/news/conf_$var1"?

And I was replacing </path to pluhnews.php> with this script. Was that correct?

[Sean]

Oops, that was suppose to be a variable..

Alright..that "path.to/varl" is suppose to be "/path/to/$var1" This is determined by whatever the variable is... HOWEVER, you are not doing the same thing I am doing..let me re-write this for what you want to do.

Give me a few minutes.

[Sean]

<?
require("/path/to/global.php");
require("/path/to/admin/config.php");
//first load global.php & the vB config file

//Use this if you want one variable /?var1=blah
//conf_$var1.php is the different Configuration file for PluhNews...So, if you put this code in file.php, 
//and loaded file.php like this: file.php?var1=news, it 
//would load the configuration file called: conf_news.php 
//(this would have the contents of PluhConfig.pgp in it.

if (isset($var1))  {include("/path/to/news/conf_$var1.php");
}  else  {}


//than include the news.php file

include("/path/to/PluhNews.php");

?>

BTW: You can $var1 to ANYTHING you want.. to load for example, or file, or news, or forums, or absolutly anything, as long as I starts with a letter and doesn't end with a _..

Make sure you change them both if you do.

[Sean]

ALSO. After loading the different config file, you can load PluhHeadlines.php, and it will be different depending on your config file..

include this before or after the news.php include, or just replace it with this:

include("/path/to/PluhHeadlines.php");

I hope this all works for you.