e-steki Profile Stats v1.0.1

[Lea Verou]

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
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.
Fully phrased.
You can turn on/off every single statistic, so that the hack fits your needs 100%.
A nice, usable and extensive manual instead of an ugly readme.txt ;-)Types of statistics displayed (in order of appearance)
Custom fields (you can enable/disable all custom fields or specify which custom fields you want the script to show).
Age statistics (you can enable/disable this and also specify the classes that the ages are sorted into)
Age privacy statistics (you can enable/disable this)
Email domain statistics (you can enable/disable this and also set the frequency it takes for a domain to appear separately)
Timezone statistics (you can enable/disable this)
Subscription statistics (you can enable/disable this)
Number of posts per page statistics (you can enable/disable this)Notes
Supported for only a few days after each release.
Please Mark as Installed if you use this (ehmm...you can also nominate it if you like it a lot :o ).
Please do not request vBadvanced modules for its statistics.
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

[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]

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]

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

[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]

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_databaseAny 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! :) :)

[goblues]

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.

[Sulaiti]

great ..

Thanks ..

[cynthetiq]

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

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

[puertoblack2003]

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

[Scandal]

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


:up::up::up:

[johnrizz]

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

[Hornstar]

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

[yaoren]

**Installed**
Works just peachy on 3.6.7

Thanks :)

[Axel Foley]

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.

[EnIgMa1234]

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

[Lea Verou]

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)

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


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

[Lea Verou]

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

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

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

[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 (https://vborg.vbsupport.ru/showpost.php?p=1320581&postcount=7) when no custom fields did exist and the setting to display custom fields was set to Yes.
3. A variable name (https://vborg.vbsupport.ru/showpost.php?p=1320647&postcount=17) 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]

* projectego clicks install :)

[Konstantinos]

looks cool. how many extra queries ?

[Lea Verou]

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?

[Paul M]

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

[Lea Verou]

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

[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]

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

[MikeHolohan]

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.

[Lea Verou]

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

[Deepdog009]

Beauts... Michelle

Keep the ball rolling...;)

[ssslippy]

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

[MikeHolohan]

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

[Lea Verou]

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

[MikeHolohan]

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.

[Lea Verou]

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.

[MikeHolohan]

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

[Lea Verou]

Try this.

[Lea Verou]

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...
It will only show radio/select/checkbox/menu custom fields.
It will not show textbox custom fields.
What custom fields do you have and what is their type?

[Axel Foley]

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

Lea, the problem seems to be that $selectsql is empty, so the query is not complete, you have to debug why.

Let me know if you want to test it before releasing...:)

[MikeHolohan]

fields are... age, age privacy, email, timezone, Default Thread Subscription Mode and Number of Posts to Show Per Page..

that's all... Mike.

[Axel Foley]

Ok, the last profilestats.php you posted is working.

I have the 4 default custom fields and they're all textboxes, note that this is the default for vB.

[Lea Verou]

Lea, the problem seems to be that $selectsql is empty, so the query is not complete, you have to debug why.

Let me know if you want to test it before releasing...:)

Yeah, I figured it out afterwards (after I said its insane :p It looked really weird though at first). Its so nice that there are people here that look at the code as well, you helped me fix a bug before :)

fields are... age, age privacy, email, timezone, Default Thread Subscription Mode and Number of Posts to Show Per Page..

that's all... Mike.
No I meant the custom profile fields. What are the custom profile fields you have in your board? Try posting a screenshot of http://www.yoursite.com/forum/admincp/profilefield.php?do=modify

[Lea Verou]

Ok, the last profilestats.php you posted is working.

I have the 4 default custom fields and they're all textboxes, note that this is the default for vB.
There are forums without at least a gender field added? :eek: :p

[Lea Verou]

I just updated the zip with the new profilestats.php.

I apologize, I didn't consider while writing the code, of the case that someone could have that setting to yes and have no custom fields that the script could use.

[MikeHolohan]

Yeah, I figured it out afterwards (after I said its insane :p It looked really weird though at first). Its so nice that there are people here that look at the code as well, you helped me fix a bug before :)


No I meant the custom profile fields. What are the custom profile fields you have in your board? Try posting a screenshot of http://www.yoursite.com/forum/admincp/profilefield.php?do=modify

That's all...

[Axel Foley]

Yeah, I figured it out afterwards (after I said its insane :p It looked really weird though at first). Its so nice that there are people here that look at the code as well, you helped me fix a bug before :)


Well I think that should be the spirit of a community like vb.org...;)

There are forums without at least a gender field added? :eek: :p

Yes, there are...never be surprised of such things....:)

Keep up the good work...I'll wait for your next hack...

[vitrag24]

Gr8 work.
installed.
But not getting button in quicklinks..
then i added $template_hook[navbar_quick_links_menu_pos3] in nav bar template at end then i can see button in each userprofile but not in quick links...

tell me plz how to add in navbar-quicklinks also?

[Lea Verou]

That's all...
Then it is expected that no custom fields show up, you only have textbox ones.
Well I think that should be the spirit of a community like vb.org...;)



Yes, there are...never be surprised of such things....:)

Keep up the good work...I'll wait for your next hack...
It should be, but its not, in most cases at least.
Thanks :)
Gr8 work.
installed.
But not getting button in quicklinks..
then i added $template_hook[navbar_quick_links_menu_pos3] in nav bar template at end then i can see button in each userprofile but not in quick links...

tell me plz how to add in navbar-quicklinks also?
I did not understand.
There is no button in the user profile to be shown :erm:
As for the navbar, take a look at the original navbar template and put the template hook in the right place (no time at the moment for more detailed instructions)

[vitrag24]

sorry.not in profile but on each page button for e-steki Profile Statistics is shown at left sight.
added $template_hook[navbar_quick_links_menu_pos3] in navigation templates\navbar at the end.

hope you'll take a while to look into and solve my problem.
thx again for such a wonderful hack.

[Konstantinos]

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?

i thought it was on memberlistbut after i installed it i noticed its on seperate page. yeah greek

[Lea Verou]

sorry.not in profile but on each page button for e-steki Profile Statistics is shown at left sight.
added $template_hook[navbar_quick_links_menu_pos3] in navigation templates\navbar at the end.


hope you'll take a while to look into and solve my problem.
thx again for such a wonderful hack.
It shouldn't be put at the end of the navbar but right after:
<if condition="$show['wollink']"><tr><td class="vbmenu_option"><a href="online.php$session[sessionurl_q]">$vbphrase[whos_online]</a></td></tr></if>

i thought it was on memberlistbut after i installed it i noticed its on seperate page. yeah greek
Ewww, it would be terrible in a separate page! :eek:

PS: Γειά σου συμπατριώτη! Χεχε! :D

[vitrag24]

you rock dude.
What a quick solution.
Sorry for trouble and thanks for cool add-on.
BTw are you planning to update this add-on further?

[Lea Verou]

you rock dude.
What a quick solution.
Sorry for trouble and thanks for cool add-on.
BTw are you planning to update this add-on further?
First of all, I'm not a dude :p
I can't promise anything, but if I come up with a good idea for it (or people here suggest one that I would like to make), I will. :)

[Ekshi]

Thank you man, nice mods.

[Lea Verou]

Thank you man, nice mods.
Thank you, but I'm not a man :p

[vitrag24]

First of all, I'm not a dude :p
I can't promise anything, but if I come up with a good idea for it (or people here suggest one that I would like to make), I will. :)

:D
sorry for misunderstanding dear.
suggesting you make advanced profile add-on ..which is inbuilt in new ipb software..vb has everything good but i like that thing in ipb.

BTW r u webmaster by proffesion?

[Lea Verou]

:D
sorry for misunderstanding dear.
suggesting you make advanced profile add-on ..which is inbuilt in new ipb software..vb has everything good but i like that thing in ipb.

BTW r u webmaster by proffesion?
What is that advanced profile add-on? Haven't heard of it.

Also what means "webmaster by proffesion"? Sorry I'm greek :o

[vitrag24]

It's ok :)
Simply i asked what do you do?


and about advanced profiles -- suggested name for your future add-on if you are interested to make..check any ipb forum[latest version] and see profile page..even you can make more improvements in that and make a decent one for vb. :D

[htscpl]

Great Mod, madam... or is it Miss? :rolleyes: Thanks for the hard work! ** installs **

[Lea Verou]

It's ok :)
Simply i asked what do you do?


and about advanced profiles -- suggested name for your future add-on if you are interested to make..check any ipb forum[latest version] and see profile page..even you can make more improvements in that and make a decent one for vb. :D
Hmm what do I do? Its quite complicated at the moment to answer that. In a few months I will probably be able to give an answer to this question :p

I'll have a look at IPB when I have time.
I don't think I'll be making something like that though(as I imagine it from what you said), since something similar will be included in vB 3.7.

Great Mod, madam... or is it Miss? :rolleyes: Thanks for the hard work! ** installs **
Lol, its Miss, thanks.

[asj]

Thanks

[Konstantinos]

can u add style stats like which styles are used and who uses it

[alfa2]

:up::up:Thanks

[yoyoyoyo]

I really like this - can I restrict usergroupps that are able to view the stats?

[Lea Verou]

I really like this - can I restrict usergroupps that are able to view the stats?
In the current version, no.
Its not very hard to modify it to do so, since you're a coder ;)

[yoyoyoyo]

In the current version, no.
Its not very hard to modify it to do so, since you're a coder ;)I understand that - just offering a suggestion. Thanks

[Snake]

Thanks for the release. I'll install this when I get back to home.

[kiFF]

I just installed this, and it's great.

A couple things:

1) Can it only show active users? For example, only users who have been active in the last 60 days? That way the stats better reflect the current state of the forum. :)

2) When someone is viewing the stats, on "Who's Online" it says "Unknown Location
/profilestats.php"

[inciarco]

Good Mod!! :up:

Very Useful Information!! :up:

Thank You Very Much For Sharing This Great Mod, Michelle!! ;)

My Best Regards!! ;)

:)

[inciarco]

One Detail To Consider: The Stats are Being Shown to All Usergroups; perhaps this Should be Limited Only to Admins (Usergroup 6), because all the Statistics Information is Private Information of the Owners of the Community (Administrators)!! :confused: :(

I Hope You Can Set an Option to Specify Which Usergroups Can See and Use this Mod, to Restrict Access to it!! ;)

Also Allows the View of the Statistics Even if I've Disabled the Mod, I think the Permissions Should be Restricted in the File "profilestats.php". I needed to Change the name of this File to Avoid any Access to it!! :confused: :(

For Now, I've Disabled the Mod, and Only Will Activate It when I'd like to Analyze the Statistics, and I've also Changed the Name of the File and will Change it when I need to Generate the Information!! :confused: :(

My Best Regards!! ;)

:)

[kiFF]

I just realized you only support this for a few days after each release...still, I'd like someone to help me out here.

A couple things:

1) Can it only show active users? For example, only users who have been active in the last 60 days? That way the stats better reflect the current state of the forum.

2) When someone is viewing the stats, on "Who's Online" it says "Unknown Location
/profilestats.php"

[Axel Foley]

It's still working in v3.7.1, just tested it. :)

Thanks Lea...;)

[vitrag24]

it was nice mod.
can i have same for vb 3.7?

[dxflw]

Super stats!!
I find this addon very helpfull for my stats about to have something to tell to my advertisters.
Any way ::INSTALLED & NOMINATED::
(i hope is not to late...)
Many thanks!

[SorentoUltimate]

Very Good,

any one install at 3.8.x ???

[trotskid]

Nice stats, and works well on 3.8x! but only if there is an option for groups to admin group view, so uninstalled :(