Version: 1.00, by KuraFire
Developer Last Online: Nov 2023
Version: 2.2.x
Rating:
Released: 05-05-2002
Last Update: Never
Installs: 54
No support by the author.
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.
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! ^_^
Show Your Support
This modification may not be copied, reproduced or published elsewhere without author's permission.
UPDATE PROCEDURE / BUG FIX:
Open newsportal.php from the attached zip-file, and use this query at the start (instead of the one that you can already find there):
PHP Code:
SELECT thread.threadid as tid, thread.title as ttitle,
thread.replycount as treply, thread.postusername as user,
thread.postuserid as userid, thread.dateline as dateline,
post.pagetext as pagetext, MIN(p.postid) as postid
FROM thread
LEFT JOIN post USING (threadid)
WHERE forumid=$newsforum
GROUP BY thread.threadid
ORDER BY thread.threadid DESC
LIMIT $newslimit
First I got a DB error, saying no such table called 'p'.
I changed p to post, then it works, but the error is still there.
:cry: :cry: :cry: :cry: