One more tiny add on... "Welcome last member"

One more item knocked off from my list of hacks I need to complete before I can actually use vB.

Here it is ....

http://www.gandmasti.net/forum/last.php

text at

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

John, if you read this could you verify that the syntax of the sql statement is correct.

I am using the userid field to pick the last user, since the joindate does not have minute / second detail in it.

it already does that on the main page...

Thank you shri, that is just what we needed to fix another member problem of ours:)

Our member count is 2 less than our last member's userid, so our welome to our newest member username was always two behind, aggravating! Now it works perfectly!

Thank you, thank you, thank you! :D

What about a tiny script that shows the total number of posts, and vB members? ;)

From my test board.

mysql> select count(*) from post;
+----------+
| count(*) |
+----------+
| 3379 |
+----------+
1 row in set (0.00 sec)

mysql> select count(*) from user;
+----------+
| count(*) |
+----------+
| 1544 |
+----------+
1 row in set (0.00 sec)

Martin,

I know it does that in the main page. But thats quite frequently not the index page of a site.

output the stats as an image ?

output the stats as an SSI include ?

output the stats for the last x days ?

how do you want it done ?

[amykhar]

hack and site gone.

Amy

[Xenon]

amy, you don't need to comment every old thread you move into deleted ;)

justnewer ones where it could be unclear why they were deleted need comments ;)

[amykhar]

ok. I only commented ones that looked like hacks in case you had a question. ;) I hope to clear out 20-50 junk threads a day in there which should have the forum under control in a month.

Amy

[Xenon]

hmm i'm thinking of creating a new archive Pre vb.org where all threads which don't have an real first poster should be move into by a query?

should i do so?

[amykhar]

I wouldn't do it for all forums. There are some legit hacks in released hacks like that, aren't there?

But for GHD, requests, etc, it's a great idea.

Amy