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]

First post reserved.

[cynthetiq]

You are trying to kill me with your awesome mods!!!! I love your mods, they are so useful.

Thank you for your hard work and dedication.

I'll be installing shortly.

[Lea Verou]

Originally Posted by cynthetiq

You are trying to kill me with your awesome mods!!!! I love your mods, they are so useful.

Thank you for your hard work and dedication.

I'll be installing shortly.

Thank you so much, its always nice to hear some kind words
In fact, I need them for my site, and I decided to release most of those that are about vBulletin itself.
Inform me if you find any bugs.

[iogames]

You have a strange case of 'double-brain' I found your Mods so tempting

[Lea Verou]

Originally Posted by iogames

You have a strange case of 'double-brain' I found your Mods so tempting

If that's a good thing, thanks, but what's a double-brain?

[goblues]

Database error in vBulletin 3.6.8:

Invalid SQL:

		SELECT
			user.userid as userid,
			options,
			birthday,
			showbirthday,
			email,
			timezoneoffset,
			autosubscribe,
			maxposts
			,
		FROM vb3_userfield
		INNER JOIN vb3_user as user USING (userid);

MySQL Error  : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM vb3_userfield
		INNER JOIN vb3_user as user USING (userid)' at line 11
Error Number : 1064
Date         : Saturday, August 18th 2007 @ 07:00:43 PM
Script       : http://www.xxxxxxxxxxx.com/forum/profilestats.php
Referrer     : http://www.xxxxxxx.com/forum/
IP Address   : 
Username     :
Classname    : vb_database

Any suggestions? By the way, love your mods as well!

[Lea Verou]

Originally Posted by goblues

Database error in vBulletin 3.6.8:

Invalid SQL:

        SELECT
            user.userid as userid,
            options,
            birthday,
            showbirthday,
            email,
            timezoneoffset,
            autosubscribe,
            maxposts
            ,
        FROM vb3_userfield
        INNER JOIN vb3_user as user USING (userid);

MySQL Error  : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM vb3_userfield
        INNER JOIN vb3_user as user USING (userid)' at line 11
Error Number : 1064
Date         : Saturday, August 18th 2007 @ 07:00:43 PM
Script       : http://www.xxxxxxxxxxx.com/forum/profilestats.php
Referrer     : http://www.xxxxxxx.com/forum/
IP Address   : 
Username     :
Classname    : vb_database

Any suggestions? By the way, love your mods as well!

Its something with the custom fields.
What are your settings?

PS: Also, I just noticed a small bug with the mail: If the setting "Minimum frequency for an email domain to appear on its own" is set to a quite high number (eg you have six members only and its set to 4) nothing appears on the email table.

I'll look into these issues in ~2 hours (my bf will start yelling if I take longer, I have promised that we watch a movie right after I release this )

PS2: Thanks for loving my mods!

[goblues]

All of the settings are default. Go spend some quality time with your man, you deserve it

I'll check into this on my end and report back.

[Sulaiti]

great ..

Thanks ..