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.
Anyhoo, see the first post, I released version 2 of the Newsportal hack, the new .php file is in the (new) attachment in the first post of this thread, you can just overwrite your online newsportal.php with that one (mind you, you'll have to check the variables at the start of the file for your personal forum id settings etc.
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
I got this message when i went to it.... so I know its somthing to do with running querys... but how and what querys?
what are the two querys every keeps saying Im must run.
I have sombody on the side ready to run them so just post
what querys I must run. Ive uploaded my newsportal to the
server and Ive added the templets in the zip file... but I havent
ran any querys because I SEE NONE. but I see people in this
thread saying they ran querys and it works great. Sombody HELP!
Simple newsportal / thread overview to add to your board... Details »»
). ^_^
About Developer
Visit Web Site
No support by the author.
04-28-2003, 01:39 PM
