Forums Statistics

[bomsey]

Hi all,

I have a question.
In witch tabel are the Forums Statistics.
In need to find the number of members like:
Threads: 1,853, Posts: 13,465, Members: 4,335
Because somthing went rong. ive got all the members but i cant see howmany.
Can someone help me?

[Senna]

make a query that counts the number of userid's in the table called users

for posts do a similar thing on postid's in table post and for threads the same in thread

[bomsey]

Originally Posted by Ike013

make a query that counts the number of userid's in the table called users

Can you tell me how to this this.
Iam a complete noob with this

[ShavedApe]

Try adding a new user. That will fix current count for you you can then delete the user again.

A query counting userids will count all users regardless of there status including users that have not confirmed there account and users that have been set to unregistered.

There is no table that holds these stats btw they are created by the php page your viewing or from functions found inside these files. I dont have specifics sorry so cant point you in the direction of them but I guess index.php is as good a place as any to start.

[bomsey]

Originally Posted by ShavedApe

Try adding a new user. That will fix current count for you you can then delete the user again.

A query counting userids will count all users regardless of there status including users that have not confirmed there account and users that have been set to unregistered.

There is no table that holds these stats btw they are created by the php page your viewing or from functions found inside these files. I dont have specifics sorry so cant point you in the direction of them but I guess index.php is as good a place as any to start.

ok it workt.
But now i have another problem.
If my members post thereuser titel is guest.
But iv'e set the user to moderator.
This problem is under all members.
Can someone help me with this?

They all can access the user cp and post
But in the forum post you cant see their avatar

[bomsey]

I checked my myqsl user table and averything is normqal can some one help

[Senna]

what is the users' nick?

[bomsey]

what do you mean it's with every user