[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



Code:
---------------
Code is only visible to licensed users, and only when logged into the forums.
---------------



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:


Code:
---------------
Code is only visible to licensed users, and only when logged into the forums.
---------------



"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
How can I exclude more then one forum?

Just use:
[B]$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]




Code:
---------------
Code is only visible to licensed users, and only when logged into the forums.
---------------



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

what's the method to include the code (display the dead topics) on a non vb page via .shtml at another webhost.
i'm hosting my vb entry page on a separate hosting account (www.entrypagehost.com/index.shtml), away from the forum (www.forumhost.com/index.php)!!

can you help me with the code, including the dead topic list on my entry page. the include("/full/path/to/deadtopics.inc.php"); method doesn't work!

thx a lot!
yours vanessa

well i got this to work at http://animeboards.net

to include the php file i did



Code:
---------------
Code is only visible to licensed users, and only when logged into the forums.
---------------


and here's my deadtopics.root.php3 file


Code:
---------------
Code is only visible to licensed users, and only when logged into the forums.
---------------


and i believe you can't put this php code in a .shtml file unless you set your server to parse php in .shtml

you need to use .php, .php3 file for it to work... what i did was create index.php3 which includes all of the above and then include index.php3 into a index.shtml file

in the index.php3 file i had at the very top before <html> tag the following


Code:
---------------
Code is only visible to licensed users, and only when logged into the forums.
---------------

I want to post the top X most popular posts for the last X days. Not the most popular ever, but just for the last X days, so that the recent popular ones stay popular.

Thoughts as to how to do it?

This script seems to be very server intensive. I am using:


Code:
---------------
Code is only visible to licensed users, and only when logged into the forums.
---------------



Any one have ideas on how to make it not so server intensive.

Change SELECT * FROM

to

SELECT threadid, title FROM

Ok. What about this Active topics hack from EVA2000. Can you give me any ideas on how to optimize it:


Code:
---------------
Code is only visible to licensed users, and only when logged into the forums.
---------------



Thanks. :)

Rangersfan: That change makes it a bit faster, but its still pretty slow.