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!

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