[RELEASE] Show dead topics on non vb page

This is something I like to do on my homepage. If a post has no replies it needs attention right? I agree so I threw this little hack together that will list your dead topics.

Demo:
http://www.extremeforums.com/include/deadtopics.inc.php

<?php
// Set this to the max number of dead topics you want to display
$maxthreads = 100;

require("config.php");
$db=mysql_connect($servername,$dbusername,$dbpassword);
mysql_select_db($dbname);
$query = "SELECT * FROM thread WHERE replycount < 1 ORDER BY dateline DESC LIMIT $maxthreads";
$resultlatest = mysql_query($query,$db);
while ($latest_array = mysql_fetch_array($resultlatest)) {
echo "<FONT SIZE=\"1\" FACE=\"Verdana, Arial, Helvetica, sans-serif\">&nbsp;°
<A HREF=\"http://www.extremeforums.com/forums/showthread.php?threadid=$latest_array[threadid]\">$latest_array[title]</A></FONT><BR>";
}
 
?>

Edit the echo statement and the $maxthreads variable as you see fit

~Chris

Most people dont want to display threads from private forums so you can do something like this:

$query = "SELECT * FROM thread WHERE replycount < 1 AND forumid != 34 ORDER BY dateline DESC LIMIT $maxthreads";

"34" would just be the forum id of your private forum

Once again Im not familar enough with the structure of vb right now so if anyone knows a better way please let me know

~Chris
P.S The != doesnt work on win32 systems (so ive been told) so you might want to use NOT= if your on win32

Instead of !=, just use <>

That will clear that issue up.

How did you make it so that it appears on your homepage? Did you use ssi? If so, what is the ssi code?

I put the above code in a file named "deadtopics.inc.php"

and then on my homepage (where I wanted the list to appear)i put:
include("/full/path/to/deadtopics.inc.php");

Hope this helps,
~Chris

Originally posted by TechTalk
I put the above code in a file named "deadtopics.inc.php"

and then on my homepage (where I wanted the list to appear)i put:
include("/full/path/to/deadtopics.inc.php");

Hope this helps,
~Chris

Thanks for sharing the code! It's really nice. Do people respond to this list--I mean does it do what it intends to do?

Sure no problem

And yes it has really helped my users get the answers they need because every visitor to my homepage sees this list and they want to be the one to answer a question first....

~Chris

How can I exclude more then one forum?

Just use:
$query = "SELECT * FROM thread WHERE replycount < 1 AND forumid <> 21 22 23 ORDER BY dateline DESC LIMIT $maxthreads";

Forum ID 21 22 23 or how do I do it?

Another Problem:
Got some old topics in the list! But they are allready deleted? Why do the y show up an d how kann I delete them?

http://std.krawall.de/vbb/dead.php

[Edited by The_Sisko on 08-22-2000 at 06:45 PM]

[QUOTE]Originally posted by The_Sisko
[B]How can I exclude more then one forum?

Just use:
$query = "SELECT * FROM thread WHERE replycount < 1 AND forumid <> 21 22 23 ORDER BY dateline DESC LIMIT $maxthreads";

Forum ID 21 22 23 or how do I do it?

Another Problem:
Got some old topics in the list! But they are allready deleted? Why do the y show up an d how kann I delete them?

http://std.krawall.de/vbb/dead.php

[Edited by TechTalk on 08-22-2000 at 08:22 PM]

Well I tried to edit the above thread 10 times but it never would change so here we go again:

Originally posted by The_Sisko
How can I exclude more then one forum?

Just use:
$query = "SELECT * FROM thread WHERE replycount < 1 AND forumid <> 21 22 23 ORDER BY dateline DESC LIMIT $maxthreads";

Forum ID 21 22 23 or how do I do it?

Another Problem:
Got some old topics in the list! But they are allready deleted? Why do the y show up an d how kann I delete them?

http://std.krawall.de/vbb/dead.php

[Edited by The_Sisko on 08-22-2000 at 06:45 PM]

[B]$query = "SELECT * FROM thread WHERE replycount < 1 AND forumid <> 21 AND forumid <> 22 AND forumid <> 23 ORDER BY dateline DESC LIMIT $maxthreads";

Your other problem you are having is (im guessing) a problem with your database. It only selects records that exist in the database so if you deleted it then their would be no way that it would appear (because it querys the db each time and is always up to date)

Maybe someone else can shine some light on this problem?

~Chris