[RELEASE v2.x] OPNews v1.2 << More features!

Well, after very little effort on my behalf, i have released version 1.2.

Not much new, however-

I have added a headlines system, which is basically it

Anyway, it works exactly the same way as the original, just setup a news forum(you can set its display order to 0, if you wish for noone to actually see it. i also recomend only allowing normal members to reply, not post

Just create a template, headlinebit and add the following

<smallfont>-></smallfont> <normalfont><a href="$forumspath/showthread.php?s=&threadid=$newsarray[threadid]">$newsarray[title]</a> by <a href=\"$forumspath/member.php?s=&action=getinfo&userid=$newsarray[postuserid]\">$newsarray[postusername]</a></normalfont><smallfont> ($dateposted)</smallfont><br>

You can customise it, and you have access to all field names in the thread table. (check out the ERD in the members area, Keir )

As easy as it is, to access the headlines(or include them) add

?action=headlines

or to include

PHP Code:

<? include('/path/to/news.php?action=headlines'); ?>

Not much else i can rant about, im a bit lonely tonight

Anyway, heres the script:

(attached)

PS. like most scripts, just place this into your /forum/ directory, where its with its buddies(like index.php and global.php)

I just thought of another feature to add, which will come later tonight hopefully!(most commented news items, of course which would expire after a certain date offset of the current date)

[merk]

Ill need the $newsquery lines please.

[IanMFT]

$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";
$newsquery .= " LIMIT $newsitems";


sorry bout' that

[merk]

Originally posted by IanMFT
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";
$newsquery .= " LIMIT $newsitems";

$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";
$newsquery .= " LIMIT $newsitems";
^^ Hrm, thats the one i use, and it works fine.

Might just want to try reuploading the file.

[merk]

No problem about that either, just the newsbit template doesnt tell you much.

I've a problem with the query showing ups thread titles & post text.

OpNEWS doesn't display the right pagetext if there're more than 1 post in the thread.

am I the only one with problems like this ?

thanks
pier

[IanMFT]

ok, something is REALLY screwey, i changed the 0 back to a 1(actually, i re copied the script) and its still displating the last comment instead of the news...this is quite odd. Any ideas?

[merk]

I dont get this problem.

Ill look into it, give me a day.

Originally posted by IanMFT
ok, something is REALLY screwey, i changed the 0 back to a 1(actually, i re copied the script) and its still displating the last comment instead of the news...this is quite odd. Any ideas?

Yes... same problem there

[merk]

That is REALLY strange.

I have this script running, here and it works fine.

Really weird.

Im actually working on another problem atm, so could you pls post a copy of the news.php file in here(just use [php] tags)

Thanks!

[IanMFT]

PHP Code:

<? 
error_reporting(7);
$templatesused='header,newsbit,shownews,headerbit,newsheaders';

//What is the ID of your News forum?

$newsforums = 48;

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

//Path to your forums directory (leave out trailing slash), i recomend using [url]http://www.domain.com/forumpath[/url]
$forumspath = "/forums";

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";
$newsquery .= " LIMIT $newsitems";

$headlinequery = "SELECT thread.*";
$headlinequery .= " FROM thread";
$headlinequery .= " WHERE forumid = $newsforums";
$headlinequery .= " ORDER BY threadid";
$headlinequery .= " DESC LIMIT $newsitems";

if ($action == "headlines") {$query = $headlinequery;} else {$query = $newsquery;}

$passthruquery=$DB_site->query($query);

while ($newsarray=$DB_site->fetch_array($passthruquery)) {
    //Get date in their timezone
    $dateposted = vbdate("jS F Y, H:i",$newsarray[dateline]);
    //If they select anything but 'headlines' as their action, assume they want news.
    if ($action != "headlines") {
        //You may remove this, and replace any reference to $commenttext in the templates to Coments, or use replacment variables
        //Make it plural if there is more than one comment
        if ($newsarray[replycount]==1) {
            $commenttext = "Comment";
        }
        else {
            $commenttext = "Comments";
        }
            //Process the thread, and make it parse vBcode, and stuff
            $cookedthread=bbcodeparse2($newsarray[pagetext],"1","1","1","1");
            //Call the template 'newsbit' for each news entry it finds in the database
            eval("\$newsbits .= \"".gettemplate("newsbit")."\";");
    }
    //They want headlines, so they get headlines
    if ($action == "headlines") {
        eval("\$newsbits .= \"".gettemplate("headlinebit")."\";");
    }
}

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

?>