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 :o ).
3. Please do not request vBadvanced modules for its statistics.
4. Be polite, its free, I don't owe you anything. Support issues with :mad: 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:
http://www.e-steki.com/myfiles/Michelle/eps_main.gif
Settings:
http://www.e-steki.com/myfiles/Michelle/eps_admincp.gif

First post reserved. :)

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. :)

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? :o

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 :p)

PS2: Thanks for loving my mods! :) :)

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

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

great ..

Thanks ..

I was just about to post this SQL error myself. Ironically it errors out on my dev forum, but not my production one. very odd

Quote:

Warning: implode() [function.implode]: Bad arguments. in /profilestats.php on line 72

lol...i don't want to be damed to hell :eek:..i clicked install another great mod to my board thanks michelle.:up:

Awesome mod! :eek:
It is very useful for my site!
Installed! :D


:up::up::up:

Nice job! I had to install the $template_hook[navbar_quick_links_menu_pos3] in navbar to get it to show up in quick links, but it was no big deal. Works fine! Thanks...

Looks like this will be very popular, thanks for sharing, I will install this when I get home. thanks.

**Installed**
Works just peachy on 3.6.7

Thanks :)

Hi Lea,

another good hack...I just tried it: it gives me the same db error as the one above if I enable the "Show custom fields stats?" and put no value in the "Custom profile fields to display".

The other strange thing I noticed is that in the profilestats.php code, you refer to $vbulletin->options['eps_customfields'] in the code, but after importing the .xml, that field is called $vbulletin->options['eft_customfields'], is this ok for you?

I'll wait for the fixed version...and thanks again for another one...;)

Keep up the good work.

Yet another great mod.
*Enigma nominates Lea as coder of the month :p

Sorry for the delay, I really liked the movie and got carried away afterwards reading threads in its imdb message board (Its called "The Illusionist", watch it, it was really good)

Its not odd at all. Probably in the dev forum you do not have any custom fields, whereas in the production one you do. This error is caused when trying to fetch custom profile fields when none exist. Of course it will be fixed shortly.
I probably confused the prefixes with my previous mod (eft_ was for featured threads). I'll fix that as well, thanks a lot.

Oh boy, I really suck at debugging my mods :(:p

Thank you everyone!!! :):):):)

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.

Very nice!

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

Thank you :)

[high]* projectego clicks install :)[/high]

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 :p
Anyway, my code makes 1-3 queries, depending on the settings.

PS: Are you greek?

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 :mad: :p :p

I am getting this database error... 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.

:confused:
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).

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
Date : Sunday, August 19th 2007 @ 10:33:10 AM
Script : http://www.xxxx.xxx/xxxxx/profilestats.php
Referrer : http://www.xxx.xxx/
IP Address : xxxxxxxxx
Username : Mike
Classname : vb_database

this is the whole query...

Mike.

:confused: That's insane...
Can you post a screenshot of your settings?
Do you have any custom profile fields?

Does anyone else have this weird issue?

Beauts... Michelle

Keep the ball rolling...;)

I have this issue also, i have the 4 default profile fields.

Here is the screenshot although I didn't change anything...

Try this profilestats.php and tell me if it was fixed so that I update the zip.

Warning: Invalid argument supplied for foreach() in /profilestats.php on line 108

I would like to get this working, this looks like an excellent mod... Mike.

The problem is that you don't have any radio/select/checkbox custom profile fields, where the setting is set to yes for them.
I'll try to fix it though, so that even in this case it doesn't give any error.

You are correct, I set it to no and it works fine... but the output is limited now... Mike.

BTW thanks for all the help... clicks installed...

Try this.