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.
Well, I don't allow users to select styles on my board. Each category ties into a site with its own layout, thus each category has its own layout that blends it into the site.
www.lmalla.com and click on the Everquest logo for an example (It's the only one I have public atm). Click on forums and you'll see what I mean. When you click on forums, you're looking at a category under forumdisplay, not forumhome.
Also the news on that page is with your hack, though I have the style hardcoded in the templates atm.
hmkay, well, it's quite easy to get a page to use a different style.
1) install freddie's User's Style in Post hack;
2) set the variable $changestyle with a styleid of choice _before_ including global.php in the file
you can pass the variable through the URL also...
So then you can send people from each category to see it in that cat's style. But note that each of them will still see the exact same _content_, just not in the same style
Actually, you can do it without the newthread.php modification and the mysql database modification. Instead, you can use this hack WITHOUT MODIFYING ANYTHING to your site. Just open newsportal.php from the hack, and use this query at the start:
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
That should work fine, and you don't have to modify any files or your database anymore, with that query.
04-14-03 at 10:05 AM KuraFire said this in Post #84 Actually, you can do it without the newthread.php modification and the mysql database modification. Instead, you can use this hack WITHOUT MODIFYING ANYTHING to your site. Just open newsportal.php from the hack, and use this query at the start:
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
That should work fine, and you don't have to modify any files or your database anymore, with that query.
Hello, what do you mean exactly when you say to run this query at the start of the file ? Should we siply copy past this, and where ?
Simple newsportal / thread overview to add to your board... Details »»
). ^_^
About Developer
Visit Web Site
No support by the author.
01-07-2003, 05:21 PM
