Simple newsportal / thread overview to add to your board...

Okay, this isn't really a hack, since you don't have to modify any vb-files really, but I figured this was the best place to make it public anyhow. I found it rather useful myself, so I figured others might, too.

Last update: April 28th, 2003!
** Update summary: **
The bug that could occur due to MySQL stupidity has been fixed. Version 2 of the Newsportal script is now attached in this post, you can simply overwrite the newsportal.php on your site with the one from the attached zipfile to upgrade.
From now on, no more vB files need to be adjusted nor do you have to make any database changes. If you've already done all that due to the mysql-bug in a previous stage of this hack, you can just leave it like that, it won't do any harm. If you're intent on 'cleaning' your files again, let me know if you can't get it done yourself.


Q&A:
What does this 'hack' do?

http://www.kurafire.com/newsportal.php

That's a live example of the fully functional version of the Hack (version 2). I think it speaks for itself.

The amount of newsposts & threads on the right is set in a variable at the beginning.


Is this hack hard to install?
Absolutely not. You upload the newsportal.php, you add the new templates (see zipfile), and you place a link to newsportal.php wherever you want it on your site. That's it.
You don't have to modify any vB files, nor your database.


Does this hack include my style and everything?
Yes, the newsportal page will use your headinclude, header, footer and style-colors (pagebgcolor, tableouterwidth, linkcolor, etc.) and all these settings are easily configureable. You just edit the templates like you're (hopefully) used to with all the normal vB Templates.


Version 2:
The newsportal script now uses 2 queries to get the necessary information for your News posts. One for all thread info and the postid's of the starting posts, and one for the pagetext (ie. post contents) of all those postid's. You can use 2, 20 or 200 newsposts, that won't matter, it'll always be 2 queries (though I discourage using more than 20 newsposts ). ^_^

That's it, you're all done. Have fun with the newsportal! ^_^

[KuraFire]

Originally Posted by soulviv3r.php

i am getting this error with it Database error in vBulletin 2.3.2:

Invalid SQL: SELECT pagetext,postid FROM post WHERE postid IN () ORDER BY postid DESC
mysql error: You have an error in your SQL syntax near ') ORDER BY postid DESC' at line 1

mysql error number: 1064

Date: Friday 07th of November 2003 05:42:42 AM
Script: http://nbk-gaming.net/lounge/lounge/newsportal.php
Referer:

Have you specified the right forumid ?

I think you're somehow getting 0 newsposts back...

[Rampag33]

Thi is definitely the thing I've been looking for for a long time. All the other news/portal haccs add way more then I needed this is perfect thx

install.

[KuraFire]

Originally Posted by Rampag33

Thi is definitely the thing I've been looking for for a long time. All the other news/portal haccs add way more then I needed this is perfect thx

install.

You'll like my vB3 version, then

[kuska]

I have the same problem as suvir3.php

Database error in vBulletin 2.3.0:

Invalid SQL: SELECT pagetext,postid FROM post WHERE postid IN () ORDER BY postid DESC
mysql error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ') ORDER BY postid DESC' at line 1

mysql error number: 1064

Date: Wednesday 07th of January 2004 06:09:13 AM
Script: http://www.nakazdytemat.com/newsportal.php
Referer:

It was working fine till now. I have not made any changes to my board what so ever And the forim ID is correct

[KuraFire]

You'll have to wait for the vB3 version of this hack, as I've stopped support for the vB2 one...

[tim|evo]

Absolutely brilliant hack. Have ripped it apart and put it on my homepage, hope you dont mind... www.uxfest.org

Cheers.

[KuraFire]

Not at all, thanks, glad you like it

[jojok]

Database error in vBulletin 2.3.4:

Invalid SQL: SELECT pagetext,postid FROM post WHERE postid IN () ORDER BY postid DESC
mysql error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ') ORDER BY postid DESC' at line 1

mysql error number: 1064

Date: Monday 12th of January 2004 09:53:19 PM
Script: http://www.treehillhigh.net/forum/forum/newsportal.php
Referer: http://treehillhigh.net/forum/newsportal.php

That script URL is wrong. How can I change it?

[KuraFire]

Originally Posted by jojok

Database error in vBulletin 2.3.4:

Invalid SQL: SELECT pagetext,postid FROM post WHERE postid IN () ORDER BY postid DESC
mysql error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ') ORDER BY postid DESC' at line 1

mysql error number: 1064

Date: Monday 12th of January 2004 09:53:19 PM
Script: http://www.treehillhigh.net/forum/forum/newsportal.php
Referer: http://treehillhigh.net/forum/newsportal.php

That script URL is wrong. How can I change it?

Idunno, that script error is not related to my newsportal though..

[jojok]

Yes it is.