Moderator Statistics

[Julie]

Very nice, thank you :)

[Polo]

this thing is going to kill my server...

Page generated in 0.30997 seconds with 700 queries

/me uninstalls..

[bashy]

700, and page generated in 0.3 seconds...me thinks if it was 700 queries it would take an hour to load...

Mine says 26 queries, where did you get 700 from please?

[Polo]

well, that is what my forum says :rolleyes:

[Abe1]

well, that is what my forum says :rolleyes:
That 700 must be a mistake. Can you go into debug mode and click 'Explain', Let me know what comes up there.

[bashy]

yeah, sommat strange is going on here lol...
I have 3 times the staff you have and mines still at 26 queries :)

[Polo]

mmm.... that is strange, I will check that out....

[redlabour]

@Abe1 - what about moving this Thread to 3.6 Section ? ;)

[Svenna]

it works in 3.6.0 :)


ty

[Eagle Creek]

Great!!!

[Abe1]

@Abe1 - what about moving this Thread to 3.6 Section ? ;)
I'm in the middle on working on a major update for this hack.

[forzablues]

Nice hack comes in very handy :)

[VBUsers]

heres my issue. it does work for 3.6 but i have recently removed staff members and theyre still showing up on the page. how can i fix this?

[Mysticales]

Very nice. Thanks. Helps to see if mods are doing anything.

[RMS-Chef]

Odd Abe.
I added the in post beta attachment.
I uninstalled the initial one, then imported the new XML.
The stats seem to be correct but nothing is happening when I click the "View" link to view the advanced stats?

[Abe1]

Odd Abe.
I added the in post beta attachment.
I uninstalled the initial one, then imported the new XML.
The stats seem to be correct but nothing is happening when I click the "View" link to view the advanced stats?
I'm still working on the beta. I'll go check it out though.

[zeroality]

Hi, any plans to port this to 3.6?

Edit: Nevermind, just saw the latest posts. Great. Look forward to it.

[brvheart]

cant wait for this on 3.6.1 :)

[Abe1]

cant wait for this on 3.6.1 :)
me toooo :D

But I've got work to do on it.

[Eagle Creek]

Can't wait either!

[brvheart]

me toooo :D

But I've got work to do on it.

let me know if I can do anything to help ;) your hard work is appreciated

[PinkDaisy]

Installed! Great work.. :)

[jluerken]

I am waiting for a version for 3.6.x and I have a question.

Is it possible to exclude single forums from this check?
Currently I use the hack to check the activity of my mods but I want to exclude a spam forum from this check.
Spamming is not what I call activity and I do not want my mods to spam nonsense to have posts in the activity check :D

[Abe1]

I am waiting for a version for 3.6.x and I have a question.

Is it possible to exclude single forums from this check?
Currently I use the hack to check the activity of my mods but I want to exclude a spam forum from this check.
Spamming is not what I call activity and I do not want my mods to spam nonsense to have posts in the activity check :D
I'll see.

[GrabAssGirl]

Has this been done so it can be used with 3.6.X yet?

[Abe1]

Has this been done so it can be used with 3.6.X yet?
This version can be used in vb3.6. I hope to come out with an official vb3.6 soon.

[trigon]

This version can be used in vb3.6. I hope to come out with an official vb3.6 soon.
yes you can, but it shows me the statictics for all (mod admin, co admin, smod etc.) in the field "Additional usergroups to show in stats." i set only to mods, but like sayed before it shos the statictics from all of our "team". Why??

[4yBak]

Hi. I have two questions about this hack:
1) this hack can do next: I has private forum only for moderators and I want to see statistic how often each moderator read this forum. But perfect was as I can see statistic how much each moderator read each thread in this moderator forum. It's need to control their activity and understand who read threads at this forum and who just sign in this forum
2) is this hack can install on vb3.6.3 or it will be good if we can wait while you publish an official version for vb 3.6.x ?

[Abe1]

Hi. I have two questions about this hack:
1) this hack can do next: I has private forum only for moderators and I want to see statistic how often each moderator read this forum. But perfect was as I can see statistic how much each moderator read each thread in this moderator forum. It's need to control their activity and understand who read threads at this forum and who just sign in this forum
2) is this hack can install on vb3.6.3 or it will be good if we can wait while you publish an official version for vb 3.6.x ?
No to questin 1 and what ever you want for question 2.

[4yBak]

I mean that could I install this hack on vb3.6.3 and it will work or I need wait while you did port of this hack for vb 3.6.x and post new thread in forum vB3.6 Add-ons ?

[Abe1]

I mean that could I install this hack on vb3.6.3 and it will work or I need wait while you did port of this hack for vb 3.6.x and post new thread in forum vB3.6 Add-ons ?
Correct.

[Mecho]

thanks . its great mod . i install it on 3.6.4 . everything works fine . but that doesnt show correctly User ID that i set on it ! it mix 3 user id together ! but i just set one !!

any idea ?

Thanks

[Abe1]

thanks . its great mod . i install it on 3.6.4 . everything works fine . but that doesnt show correctly User ID that i set on it ! it mix 3 user id together ! but i just set one !!

any idea ?

Thanks
Screenshot? can you explain more?

[Mecho]

i set options like this :

Usergroups that can view the stats : 6
Additional usergroups to show in stats : 7

6 = Admin
7 = moderators ( Color = Blue )

but u can see in Screenshot that it shows 3 other usergorups too !

thats it , Thanks in advance

[YabbaDabba]

I am releasing a beta version of this hack. I made the advanced stats AJAX and added a ton of new stats regarding the moderator actions. I only did the moderator actions right now, I will work on adding the admin actions soon.

The beta will work on BOTH vb3.5 AND vb3.6.Beta installed on vB 3.6.0. I much prefer it over ModStats 1.3! VERY NICE!

Minor tweaks I made:
1 - removed all NOWRAP's from xml because I have styles with fixed table widths
2 - tightened Total Mod Action display: $moderatorstats[modlog]<br />($moderatorstats[modlog_average]/day)

Needs:
1 - Methods for adding an access link (to QuickLinks?) if the stats display is restricted to particular users
2 - Display "Days in Stats" on stats page somewhere (or make period selectable from stats display page).

[Abe1]

i set options like this :

Usergroups that can view the stats : 6
Additional usergroups to show in stats : 7

6 = Admin
7 = moderators ( Color = Blue )

but u can see in Screenshot that it shows 3 other usergorups too !

thats it , Thanks in advance
1) Do you have the option set to add moderators?

2) The hack pulls usergroup info from additional usergroups for a user also.

Any of these apply?

[lazytown]

I am releasing a beta version of this hack. I made the advanced stats AJAX and added a ton of new stats regarding the moderator actions. I only did the moderator actions right now, I will work on adding the admin actions soon.

The beta will work on BOTH vb3.5 AND vb3.6.

To install, you have to upload moderator_stats.php to your main forum dir. Then import the product. It will overwrite your current version. You will also need to go to moderator_stats.php to view the stats.

I’m posting this here now so I can get feedback now already with ideas!

ENJOY!
I installed the beta 2.x version in post #240. With VB 3.6.4 and IE7, I don't see any Ajax controls and only the most basic stats are available (not the super detailed ones I've seen before). Also I get errors if I click the column headings because they appear to be linking to misc.php instead of the new moderator_statistics.php (with the exception of sort by name). I know it's beta -- just wanted to update you on my experience with it.


EDIT: It appears at least two templates need reverting. VB will not notify you these templates need reverting, and when you install the product they are not overwritten. When I reverted the two templates by hand -- it appears to be working now!

-vissa

[cmcadmin]

**Clicked Install**

**Voted for MOTM**

[tonyph33r]

does anyone know where can i get this one for 3.6.4 version for this mod

[Abe1]

does anyone know where can i get this one for 3.6.4 version for this mod
Not yet released. When I have a few min I'll try to release it.

[brvheart]

Not yet released. When I have a few min I'll try to release it.

This is fantastic news!!!!! I have been waiting on this for a while!!! This is one of the most useful admins :)

Thanks Abe1 :D

[Mecho]

yea . that would be great if u release this mod for 3.6.4 too .

Thanks ...

[rareclownfish]

yea . that would be great if u release this mod for 3.6.4 too .

Thanks ...

It works fine on 3.6.4

[vbreal]

It works fine on 3.6.4


i installed it and it took me to a smiley page. it doesn't sow the moderator stats.

[Terminatoronly]

I HAVE vb 3.6.4 and this hack i installed it in my forum but it shows that there is some members are moderators and i checked it but they are not moderators :O

[brvheart]

Installed on 3.6.4 problem is that when you remove someone from being a moderator it still thinks that they are moderators....does this make sense?

[2fast4ya]

question, I would like to link this in my and my others admins CP, under the moderation drop down; how would i do that? I would like the full code with where to put it and stuff

[2fast4ya]

nump

[stinger2]

when you remove some one from moderator rank....his name keeps on showing in the states....how do you remove it from there??

[Abe1]

when you remove some one from moderator rank....his name keeps on showing in the states....how do you remove it from there??
What do you mean? Still showing as a mod?

[stinger2]

hi Abe...thanks for your respond...

they still show up in the statistic.............even though when they are NOT moderators any more......

lets say some one left...so i transfeer him to registered members.............he still keeps showing in the statistic...

and i dont know how to get them out of there

[Abe1]

hi Abe...thanks for your respond...

they still show up in the statistic.............even though when they are NOT moderators any more......

lets say some one left...so i transfeer him to registered members.............he still keeps showing in the statistic...

and i dont know how to get them out of there
Is he still considered a mod on the forum? This hack may pull any user that has logs. I have to check.

[stinger2]

No he is not considerd a mod........and i pruned (deleted) all his log enteries also........i thought it might be the problem...but it is not helping....he keeps on showing in the states...

[Abe1]

No he is not considerd a mod........and i pruned (deleted) all his log enteries also........i thought it might be the problem...but it is not helping....he keeps on showing in the statistics...
All I can say is wait until next version comes out. I'm not really trying to fix this one up. I hope to release it in the coming days.

[stinger2]

thanks Abe1 and i am not in a hurry..please take your time......i love your work....waiting for the next release

[brvheart]

All I can say is wait until next version comes out. I'm not really trying to fix this one up. I hope to release it in the coming days.

Sweet :) this is a essential hack cant wait :)

[yeguiren]

Thanks
I want to translate it
chinese version

[mrahul]

will this work in 3.6.x ??

[stinger2]

it works on 3.6.4 but when you remove a moderator...his states stay registered........Abe1 has promised on working on an update..

[mrahul]

@stinger : thanks for the info, will wait for the full release :D

[maple_cc]

Thank you !!! Let me try~

[phpdevrus]

waiting on the 3.6.4 update ;-)

[Abe1]

it works on 3.6.4 but when you remove a moderator...his states stay registered........Abe1 has promised on working on an update..
I think it stays until the are no longer have any logs in the last x days.

[stinger2]

hi Abe1
as i said before........they are even not active ...and i deleted all the logs older than 30 days.....and removed any mention to their modereation....their name remains there.........

i mean .they even sho zero zero in everything in the stats....and they are elite group now...

[Abe1]

vb3.6 version released here: https://vborg.vbsupport.ru/showthread.php?t=139248

[Ryloth]

i read threw a few pages, anyone realize this shows past moderators who are no longer mods due to joinng for the users on the moderator table.


the poor man's way to do this is to change this:

SELECT user.*
FROM " . TABLE_PREFIX . "user AS user
LEFT JOIN ".TABLE_PREFIX."moderator AS moderator USING (userid)
WHERE moderator.userid = user.userid $additional_usergroups
ORDER BY user.username


to


SELECT user.*
FROM " . TABLE_PREFIX . "user AS user
LEFT JOIN ".TABLE_PREFIX."moderator AS moderator USING (userid)
WHERE moderator.userid = '' $additional_usergroups
ORDER BY user.username







Then change around a few lines of text for the options so that you now MUST SPECIFY which groups you want to show.




I realize this is a poor way to do it, however, it is a very simple way that 99% of people can understand. the right way would be to re-write the query not joining on the moderator table. i think the intentions were right w/ joining, however, right join by the way your query is setup would be the join you were after and even then the query is not right. i am out of time for looking at this.

[Vman]

This is what Im getting when I attempt to use the misc.php?do=moderator_stats

you do not have permission to access this page. This could be due to one of several reasons:

1. Your user account may not have sufficient privileges to access this page. Are you trying to edit someone else's post, access administrative features or some other privileged system?
2. If you are trying to post, the administrator may have disabled your account, or it may be awaiting activation.

Im the SuperAdmin. What do I need to do to see the stats..

Thanks

[bartek24m]

Then change around a few lines of text for the options so that you now MUST SPECIFY which groups you want to show.

could you explain which lines i need to change ?