Latest Threads on Your Desktop

This hack will show the 30 latest threads on your desktop, ordered descending by the latest post. Somebody please post a screenshot; my screenshot program can't get my desktop.

There is no file editing and no template editing. It's very easy to install, even for a novice.

Click here for a screenshot!

Current Version: 3.0 (update recommended if you have 1.0)
Version 3.0 is not what I would call a "fix", but it adds an option to prevent threads in private forums from being viewed unless the viewer is allowed to access private forums (guests ARE allowed by default). It also allows you to change the number of latest threads to be viewed.

Have fun, and post your comments if you use this, please!

[TECK]

nick, try something like that to. let me know if it worked.

PHP Code:

<?php
error_reporting(7);

$templatesused = "home_newthreads,home_latestthreads";
require("./global.php");

$maxthreads=30;

$doforumperms=$DB_site->query("SELECT forumid FROM forum");
$forumslist="";
while ($forumperms=$DB_site->fetch_array($doforumperms)) {
  $forumid=$forumperms[forumid];
  $getperms=getpermissions($forumid);
  if ($getperms[canview]) {
    $forumslist.=",$forumid";
  }
}

$newsql=$DB_site->query("SELECT * FROM thread WHERE forumid IN (0$forumslist) AND visible=1 ORDER BY lastpost ASC LIMIT 0,$maxthreads");
while ($new=$DB_site->fetch_array($newsql)) {
  $getforumid=$new[forumid];
  $getnewsql=$DB_site->query_first("SELECT * FROM post WHERE forumid=$getforumid");
  $forumname=$DB_site->fetch_array($getnewsql);
  $geticonid=$new[iconid];

  if ($new[iconid]==0) {
    $newicon="<img src=\"{imagesfolder}/icons/icon1.gif\" border=\"0\">";
  } else {
    $newicon="<img src=\"{imagesfolder}/icons/icon$newconid.gif\" border=\"0\">";
  }

  $getthreadid=$new[threadid];
  $gettitle=$new[title];
  $getforumname=$forumname[title];
  $getreplycount=$new[replycount];
  $getusername=$new[postusername];
  $getuserid=$new[postuserid];
  $gettime=vbdate($timeformat,$new[dateline]);
  $getdate=vbdate($dateformat,$new[dateline]);

  eval("\$newthreads .= \"".gettemplate('home_newthreads')."\";");
}

eval("dooutput(\"".gettemplate('home_latestthreads')."\");");
?>

[mondaynightmike]

wow this is a good idea.

[N!ck]

nakkid,
i think i might have a solution looking at your code. i didn't even THINK about using the getpermissions() function!

MrLister,
the "special edition" is going to have a bunch of features that some might consider "bloatware" - so that's why it's not going to be an "ordinary" release.
expect it sometime this weekend, i'd say. it will include almost all the features of the Forum Display page, will show announcements, and will have some other options that i don't even know of yet!!!

so yeah, this weekend...thanks for the suggestion nakkid...

[cditty]

How would I go about adding a refresh button to force a refresh within the same window? I added a simple refresh and it opens a full sized window.

Also, how would I go about adding the current users on the very bottom? I looked at a few existing templates but couldn't figure it out.

Chris

[N!ck]

add target="_self" to the <a> tag.

[cditty]

Oh gesh.....I can't believe it was that. I'm gonna go crawl under my rock. Call me when the new version is ready.

Chris

[lordofgun]

AWESOME JOB!

Quick question: This might sound stupid, but is there any way to get this to auto-refresh every few minutes or so?

[lordofgun]

NEVER MIND! I am a retard...found it in the "latest" template.

[MrLister]

lol is it just me or is everybody pposting multiple threads in a row. first sayan guy, then another one, then in this topic two more people

[MrLister]

just like this