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

[Hamma]

Alright I am on roll today.. first of all attached to this post is my modified global.php that works with my news. Just require it, instead of global.php (I have had no problems doing this) this will address stripslash errors

Second I have resolved the issue with including multiple news, and headlines on one page. The problem seems to be the script trying to do everything on one SQL connection. This is easily fixed:

Find this

PHP Code:

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


And change it to

PHP Code:

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


Now, after you do this you will have to find every instance of $connection and change it to what you set on that line. You can call it whatever.. $connectionilikecheese for example Put any further questions here, all these things worked for me

Check it all out here: http://www.dragonwolves.com

[sccr410]

I get the following error:

Warning: Cannot add header information - headers already sent by (output started at /home/sandieg/public_html/index.php:3) in /home/sandieg/public_html/forum/admin/functions.php on line 1530

I just uploaded and required only your global2.php (making sure to change all the path info to my own paths)

[Hamma]

Ok, did you put the include lines at the top of your index page? (the page your including the news on)

<?
require("/path/to/global2.php");
require("/path/to/admin/config.php");
require("/path/to/PluhConfig.php");
?>

The only require line in the phuhnews.php should be

require("PluhConfig.php");

Rename and update to your paths of course.

[Gutspiller]

Hamma, did you ever get this error:

Warning: 1 is not a valid MySQL-Link resource in /my/path/forumz/admin/db_mysql.php on line 93

There seems to have been a slight problem with the database. Please try again by pressing the refresh button in your browser.

An E-Mail has been dispatched to our Technical Staff, who you can also contact if the problem persists.

We apologise for any inconvenience.


Database error in vBulletin: Invalid SQL: UPDATE session SET lastactivity=1014310822,location='/forumz/testpage.php',styleid=1 WHERE sessionhash='864316a4ee913aaef151a03edd678015'
mysql error:
mysql error number:
Date: Thursday 21st of February 2002 09:00:24 AM
Script: /forumz/testpage.php
Referer:

and If you did, how did you fix it? I keep getting it at the bottom of my page. I only have 1 headlines and 1 news on the page, but it gives that error, and I have no idea how to get rid of it.

Any help from anybody would be appreciated.

Thanks.

[Hamma]

My post above entitled "2 for 2" explains how i fixed that. Its trying to do all those DB queries on one connection and dying out. I made it so it does the query on a different connection for each script

[Gutspiller]

Hamma, so if I have say 2 different news things on one page, both headlines and news, I would rename all the $connection in one headline file to $connection1, and in one news file $connection2 and in the other news file $connection3?

So that in one headline it called $connection (the default), the 2nd headlines it called $connection1, in one of the news in called $connection2 and in the 2nd news it called $connection3.

Is that correct?

[Hamma]

Yes, thats pretty much it.. each script needs its own connection name. So each headline/news script would have a seperate one.. make sure you rename every instance of $connection (im pretty sure it shows in only the script, and not the config file)

This worked like a charm for me And you were getting pretty much the same errors.

Example:

Ive incuded 1 news, and 2 headlines on my index.php

News
$connection in the mainnews.php was renamed to

$connectionnews

Headlines
$connection in the t2headlines.php script was renamed to

$connectiont2

$connectoin in my daocheadlines.php was renamed to

$connectiondaoc

Let me know how it works out..

[Gutspiller]

Seems to work. Got rid of the error and everything. Great work. After how many times and people have been to this thread, it's surprizing it was something soo simple... Although I had a feeling that it would be something simple.

Many thanks.

Also for anybody using a lot of different connections you may want to double check your config.php file in your admin directory and make sure that you DON'T have persistant connection on, because if you have a lot of different news scripts each taking a spot on your mysql connections to the database, it could limit the access to your site.

Thanks Hamma, we finally traced down that pesky bug. I doubt everybody else that replied in those earlier pages knows that we fixed it. Maybe you should post something on one of the main forum pages and let everybody know that the PluhNews script is working again.

Good job.

[sccr410]

In my index.php file:

PHP Code:

<?php 
        require("/home/sandieg/public_html/forum/global2.php"); 
        require("/home/sandieg/public_html/forum/admin/config.php"); 
        include('/home/sandieg/public_html/forum/PluhNews.php'); 
?>

I don't have PluhConfig.php because all the config options were moved into the PluhNews.php. I have multiple pages that access different news forums, so I had to do this.

I still get the following error:

Warning: Cannot add header information - headers already sent by (output started at /home/sandieg/public_html/index.php:3) in /home/sandieg/public_html/forum/admin/functions.php on line 1530

[Gutspiller]

Check your other files sccr410 and make sure they aren't "requiring" the same files that you are requiring in the index.php file. I know I had that problem before too, and I think that was the cause, is that there were multiple files requiring the same files.

Let me know.