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 ?

hack and site gone.

Amy

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 ;)