Statistics Modifications - e-steki Profile Stats v1.0.1

What does this do?
This unique statistics mod, displays various user-oriented statistics, even from custom fields! Refer to the features & the statistics section for more information.

Admin Features

1. No template modifications. If you don't want to place the link in the Quick Links menu, there is an option to disable the automatic template edit and perform it yourself.
2. Fully phrased.
3. You can turn on/off every single statistic, so that the hack fits your needs 100%.
4. A nice, usable and extensive manual instead of an ugly readme.txt ;-)

Types of statistics displayed (in order of appearance)

1. Custom fields (you can enable/disable all custom fields or specify which custom fields you want the script to show).
2. Age statistics (you can enable/disable this and also specify the classes that the ages are sorted into)
3. Age privacy statistics (you can enable/disable this)
4. Email domain statistics (you can enable/disable this and also set the frequency it takes for a domain to appear separately)
5. Timezone statistics (you can enable/disable this)
6. Subscription statistics (you can enable/disable this)
7. Number of posts per page statistics (you can enable/disable this)

Notes

1. Supported for only a few days after each release.
2. Please Mark as Installed if you use this (ehmm...you can also nominate it if you like it a lot ).
3. Please do not request vBadvanced modules for its statistics.
4. Be polite, its free, I don't owe you anything. Support issues with smilies and impolite wording will be ignored.

Screenshots
I wasn't able to upload the main screenshot via the attachment system due to its long size, and the other one was badly resized, so here they are from my server:
Main:

Settings:

[Lea Verou]

Update: version 1.0.1
-----------------------
Bugs fixed:
1. Nothing showed in the email section when only 'Other' should be displayed
2. Database error when no custom fields did exist and the setting to display custom fields was set to Yes.
3. A variable name was different in the vbulletin settings and in the php code, which resulted to that setting not working (the profile field ids setting)
4. When the age was equal to an age class boundary, that person's age was counted in the last class (which was 50+ if you had left the age classes setting to the default)
5. The 'Other' category of the email stats was not being counted correctly, resulting in a smaller number than it should.

I'm now going to sleep.

[gforce75]

Very nice!

[Zagis]

Wow! Another great one!!!
Marked as Installed / MOTM

Thank you

[projectego]

[high]* projectego clicks install [/high]

[Konstantinos]

looks cool. how many extra queries ?

[Lea Verou]

Originally Posted by Konstantinos

looks cool. how many extra queries ?

The term "extra queries" doesn't really make sense in this case as the hack is an extra page
Anyway, my code makes 1-3 queries, depending on the settings.

PS: Are you greek?

[Paul M]

Probably not something I will use, but certainly a nice idea.

[Lea Verou]

Originally Posted by Paul M

Probably not something I will use, but certainly a nice idea.

Thanks Paul M, your opinion really counts


PS: Although you didn't change the attachment limits

[MikeHolohan]

I am getting this database error...

Database error in vBulletin 3.6.8:

Invalid SQL:

SELECT
user.userid as userid,
options,
birthday,
showbirthday,
email,
timezoneoffset,
autosubscribe,
maxposts;

MySQL Error : Unknown table 'user' in field list
Error Number : 1109

My forum is called FaithForum.eu and my tables are prefixed with ff, so for example user is actually ffuser etc, is there a way to change this to ffuser... thanks, Mike.

[Lea Verou]

Is this the whole database error?
I don't need the IPs etc but is this the whole query??

Btw, I use TABLE_PREFIX in all my queries, so its not that (I also use a table prefix in my forum).