[RELEASE v2.x] OPNews v1.0 << Not just another 'news' script.

Well, after finding 'PluhNews', i thought to myself, why not create something that uses templates, and the $DB_site class?

Well, after a bit of twiddling, i reduced the querys to just one, and Got it working, took a while tho D:

First off, youll need to create 2 templates.

newsbit:

Posted By <a href="$forumspath/member.php?s=&action=getinfo&userid=$newsarray[postuserid]"><b>$newsarray[postusername]</b></a> at  <i>$dateposted</i>
</center>

<blockquote></a>$cookedthread</blockquote><center><a href="$forumspath/showthread.php?s=&threadid=$newsarray[threadid]"><b>$newsarray[replycount]</b> $commenttext</a> Last comment was by <b>$newsarray[lastposter]</b></a></center>

<hr noshade height="1" width="60%">

This is just example code, basically the same as PluhNews' Code, i dont have time to make it a bit mroe spicey, but im sure you can work it out.

shownews:

Your Header Code Here

$newsbits

Your Footercode here.

And finally, create news.php in the forum root directory, and put this in it:

PHP Code:

<? 
error_reporting(7);
$templatesused='header,headinclude,phpheader,newsbit,shownews';
$loadbirthdays=1;
$loadmaxusers=1;

//Configuration Options
//What is the ID of your News forum?
$newsforums = 107;

//How many news items should be displayed?
$newsitems = 10;

//Path to your forums directory (leave out trailing slash)
$forumspath = "/forum";

require('./global.php');

$newsquery = "SELECT thread.*, post.*";
$newsquery .= " FROM thread,post";
$newsquery .= " WHERE post.threadid=thread.threadid";
$newsquery .= " AND thread.forumid=$newsforums";
$newsquery .= " GROUP BY thread.threadid";
$newsquery .= " ORDER BY thread.dateline DESC";

$news=$DB_site->query($newsquery);

while ($newsarray=$DB_site->fetch_array($news)) {

        $dateposted = vbdate("jS F Y, H:i",$newsarray[dateline]);

if ($newsarray[replycount]==1) {
    $commenttext = "Comment";
}
else {
    $commenttext = "Comments";
}

    $cookedthread=bbcodeparse2($newsarray[pagetext],"1","1","1","1");
    $test1 .= "test";
    eval("\$newsbits .= \"".gettemplate("newsbit")."\";");

}

eval("dooutput(\"".gettemplate("shownews")."\");");

?>

Thats basically it really!.

Im sure there are a few little errors in my coding, im a bit rusty with PHP

Next i plan on making a 'column' system(ie http://fortress.challenge-au.com) And actually, its for that site

<edit>
Im not sure if this supports multiple forums. Some feedback maybe?

Also- maybe there may be some point in using replacment variables in this, but hey, i couldnt be bothered
</edit>

Thank you! This is perfect. Installs in 1 minute and works well. Exactly what I needed.

[JJR512]

Can we see a demo site?

very nice hack, it works perfectly

[merk]

Excuse the content of the actual posts..

(Nothing bad, but nothing thats really useful


http://www.opticpower.net/forum/news.php

[JJR512]

OK, how can I make it so the newest thread is at the top, rather than the bottom?

Hey just wondering about one thing, i added the threads title to the newspage, but i'm wondering if its possible to make the title capital letters only, like some kind of line of code that replaces all letters in the title to capitals.

[merk]

Originally posted by JJR512
OK, how can I make it so the newest thread is at the top, rather than the bottom?

I get this already-

However, i think i forgot to add a touch of code.

To change it, you need to modify the code block:

$newsquery = "SELECT thread.*, post.*";
$newsquery .= " FROM thread,post";
$newsquery .= " WHERE post.threadid=thread.threadid";
$newsquery .= " AND thread.forumid=107";
$newsquery .= " GROUP BY thread.threadid";

to

$newsquery = "SELECT thread.*, post.*";
$newsquery .= " FROM thread,post";
$newsquery .= " WHERE post.threadid=thread.threadid";
$newsquery .= " AND thread.forumid=107";
$newsquery .= " GROUP BY thread.threadid";
$newsquery .= " ORDER BY thread.dateline DESC";

[merk]

Originally posted by DjSao
Hey just wondering about one thing, i added the threads title to the newspage, but i'm wondering if its possible to make the title capital letters only, like some kind of line of code that replaces all letters in the title to capitals.

In the While statment,

Add BEFORE (about line 41)

PHP Code:

eval("\$newsbits .= \"".gettemplate("newsbit")."\";"); 


PHP Code:

$uppercasenews = strtoupper($newsarray[title]); 


Then, to reference the uppercase title, instead of using $newsarray[title] in the newsbit template, change it to $uppercasenews.

Btw, i havent tested this, but it should work in theory

thanks, worked great.