Active Topics 0.1 done

I've got a very rough copy of the vB compatible active topics done.

The file is on

http://www.gandmasti.net/forum/active.txt

The result is on

http://www.gandmasti.net/index2.shtml
or
http://www.gandmasti.net/forum/active.php

Mind you my board is a humor board and there might be offensive jokes on the active list, consider yourself warned!

This copy has several things I want to add, in the following priorities....

a) Template support
b) User defined number of topics / topics since last logon
c) RDF support (to allow others to take the list from your site dynamically)
d) WML support (to allow mobile phone users to get their humor fix via phones... also to allow me to admin / delete the forums via a mobile phone)
e) Clean up of the code / comments
f) Offline (low overhead) generation via cron

I'v install the Active topic 0.1 ,and I works fine, but I don't wanna display any topic of my private and limited forums,what can I do?

Thanks in advance.

Really good job...

#Wanderer... your Link(zip) is down or im unable loading it. Could u check it ?

THX:_A_LOT

Try again. Very high load on system has since died down...

Thx Now it works

I have absolutely no luck getting this script. Seems I just get you main page always when trying to see the script. Is it still up?

Email me if you have problems getting the script and I will email it back to you.

I love this hack, and actually got it to work with my limited knowledge of php, but I'm wondering- how do I get active topics to display the text of the last post instead of the first? I'm sure it's something easy, so I figure I must be missing it!
Thanks,
TigerLily

I got it, and it was easy!

Go to line 144 in Active.php and change asc to desc:

$querythread="select * from post where threadid='$latest_array[threadid]' order by dateline asc limit 1";

so it looks like:

$querythread="select * from post where threadid='$latest_array[threadid]' order by dateline desc limit 1";

Works fine!! Wow! There may be hope for me yet!
TigerLily