vb.org Archive
Page 1 of 8 1 23 Last »
Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.5 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=113)
-   -   Moderator Statistics (https://vborg.vbsupport.ru/showthread.php?t=106329)

Abe1 01-25-2006 10:00 PM
Moderator Statistics
 
Moderator Statistics 1.3


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


About this hack:
This idea and part of this hack are a port over from a hack made for vb3.0 called Moderator Management System. I have changed the name since I did not include the weekly PMs about your mods in this hack. This hack only gives you a page you can go to view stats on your mods. Although I did not include the weekly email, I have improved the hack in many ways. I have also added detailed columns of each type of action there is for a moderator to do. You can see what type off actions your moderators do.

Features:
  • Uses vBulletin easy Product installer/updater/uninstaller
  • Full set of options
  • Setting to add other usergroups to the stats (eg. smods and admin)
  • Setting for who can view the stats
  • Only a plug-in. No FTP file uploading required.
  • Can sort by any category
  • Many more ...
List of Stats:
  • Last Activity
  • Posts
  • Posts in His Forums
  • Threads Started
  • Threads Started in His Forums
  • Total Moderator Actions
  • Average Per Day of Total Moderator Actions
  • Advanced stats drop down for split moderator actions types.
Installation information on hack:
  • Files edited: 0
  • Templates edited: 0
  • Files to upload: 1
  • Time to install: 5 seconds max
Updates:

Version 1.0 (01/25/06):
  • Release

Version 1.1 (01/27/06):
  • FIX Normal error if no mods come up.
  • FIX Fixed sql error if you have no mods and were just using this hack to capture usergroups.

Version 1.2 (01/31/06):
  • ADD Average Moderator Actions Per Day
  • ADD Advanced moderator action stats.

Version 1.3 (03/20/06):
  • CHANGED Changed how the Advanced moderator action stats show.

Please post your comments or suggestions for this hack. I read ALL posts.

MAKE SURE YOU CLICK INSTALL!
You will get an email when a new version is released.


This hack is created for your use free of charge. No payment is requested. However, if you would like to donate money for the work I put in to this hack, a donation would show your appreciation.
https://vborg.vbsupport.ru/external/2010/02/12.gif

Daniel 01-25-2006 11:08 PM
Yayyy - thank you!

Guest210212002 01-25-2006 11:24 PM
/me clicks install

GetGamer.com 01-25-2006 11:41 PM
Nice work! I've been waiting for this for a while.

Boofo 01-25-2006 11:46 PM
Can the periodic email be added back to this and with a setting for how often you want to receive it?

Snake 01-25-2006 11:47 PM
Niiiice! Thanks! :)

The Chief 01-26-2006 12:02 AM
thanks this is great :)

[high]* The Chief clicks install[/high]

agiacosa 01-26-2006 12:22 AM
Thank you!!!

nexialys 01-26-2006 12:51 AM
this is really good to know if the mods are doing a real job...

great hack!!!

Guest210212002 01-26-2006 01:06 AM
Yeah, fantastic addition. Now I can see when my team is slackin'.

Can you add a little christmas music to the background?

"He knows when you've been slackin'... He knows when you don't close posts... He knows who's a tot-tal for-um-nazi so close those posts for good-ness-sakes.."

/me dances

Abe1 01-26-2006 01:25 AM
Quote:
Originally Posted by Boofo
Can the periodic email be added back to this and with a setting for how often you want to receive it?
I was very close to adding it, but for some reason when the cron would run by it self, it would not send the PM. Only when I would click 'run now' would the email get sent. I have to do some more research into it. I do plan on adding the PM feature just when I figure it out the problem.

Kihon Kata 01-26-2006 02:38 AM
Installed!!! This is an admin's dream! I have 10 moderators

VBUsers 01-26-2006 02:52 AM
installed and working great

SoftWareRevue 01-26-2006 02:55 AM
/me clicks Install

Thanks!

uae 01-26-2006 03:38 AM
Great Job, I like it :)
Installed

evenmonkeys 01-26-2006 03:54 AM
Thank you. I really like this hack.

Azhrialilu 01-26-2006 07:16 AM
sweet, thank you!

PHPGeek2k3 01-26-2006 07:31 AM
nice thank you

/me clicks install

another thing i was looking for

Thanks
- James

tmcyouth 01-26-2006 01:03 PM
my first install - thanks! it looks great, it'll be really useful.

just one (real picky) thing: is there any way to change 'posts in his forums' to 'posts in his/her forums' easily?

pipin 01-26-2006 01:34 PM
Quote:
Originally Posted by tmcyouth
my first install - thanks! it looks great, it'll be really useful.

just one (real picky) thing: is there any way to change 'posts in his forums' to 'posts in his/her forums' easily?
Change that Phrase: $vbphrase[posts_his_forums]

darksoulz 01-26-2006 03:53 PM
getting a sql error on this. anyone have an idea how to fix?

Code:
Database error in vBulletin 3.5.3:

Invalid SQL:

        SELECT userid, count(*) AS total
        FROM moderatorlog AS moderatorlog
        WHERE dateline >= 1135705843 AND userid IN ()
        GROUP BY 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 ')
        GROUP BY userid' at line 3
Error Number : 1064
Date        : Thursday, January 26th 2006 @ 11:50:43 AM
Script      : http://xxxxxx/board/misc.php?do=moderator_stats
Referrer    :
IP Address  : xxxxx
Username    : xxxxx
Classname    : vB_Database_MySQLi
also getting
Warning: array_unique() [function.array-unique]: The argument should be an array in /misc.php(86) : eval()'d code on line 161

a bunch of
Warning: Invalid argument supplied for foreach() in /misc.php(86) : eval()'d code on line 168

and a
Warning: implode() [function.implode]: Bad arguments. in /misc.php(86) : eval()'d code on line 181

Martin 01-26-2006 04:07 PM
I installed, but it just hangs when I try to access it. How does it retrieve the data? If it's searching for raw info in the database, this may not be suitable for large forums like mine.

This is what I get when I run it:

Server Load Averages 20.74 7.92 5.21 | 737 Users Online

kall 01-26-2006 04:10 PM
Posts in "His" forum?

What about people who have female moderators?

Abe1 01-26-2006 04:12 PM
Quote:
Originally Posted by darksoulz
getting a sql error on this. anyone have an idea how to fix?

Code:
Database error in vBulletin 3.5.3:

Invalid SQL:

        SELECT userid, count(*) AS total
        FROM moderatorlog AS moderatorlog
        WHERE dateline >= 1135705843 AND userid IN ()
        GROUP BY 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 ')
        GROUP BY userid' at line 3
Error Number : 1064
Date        : Thursday, January 26th 2006 @ 11:50:43 AM
Script      : http://xxxxxx/board/misc.php?do=moderator_stats
Referrer    :
IP Address  : xxxxx
Username    : xxxxx
Classname    : vB_Database_MySQLi
also getting
Warning: array_unique() [function.array-unique]: The argument should be an array in /misc.php(86) : eval()'d code on line 161

a bunch of
Warning: Invalid argument supplied for foreach() in /misc.php(86) : eval()'d code on line 168

and a
Warning: implode() [function.implode]: Bad arguments. in /misc.php(86) : eval()'d code on line 181
I see you are using MySQLi, I didn't do any test on it. I will look at the code tonight to see what I can come up with.

Abe1 01-26-2006 04:14 PM
Quote:
Originally Posted by Martin
I installed, but it just hangs when I try to access it. How does it retrieve the data? If it's searching for raw info in the database, this may not be suitable for large forums like mine.

This is what I get when I run it:

Server Load Averages 20.74 7.92 5.21 | 737 Users Online
It only uses about 4 queries besides the standard queries that run on every click. No queries just pull all info. They all have limits as far as I remember.

Abe1 01-26-2006 04:16 PM
Quote:
Originally Posted by kall
Posts in "His" forum?

What about people who have female moderators?
When we talk about God, we refer to 'him' as 'him'. 'Him' is normal for languge when it can be either or. If you dont like it, you can edit the phrase. The hack is fully phrased.

Martin 01-26-2006 04:33 PM
Here are my loads without it running:

2.95 2.55 3.30 | 799 Users Online

I have 94 forums, 44 mods, 4.6mil posts, ~274,000 threads.

I think it's the size of my forum that's causing problems. Pity, because this is a great hack idea.

Abe1 01-26-2006 04:35 PM
Quote:
Originally Posted by Martin
Here are my loads without it running:

2.95 2.55 3.30 | 799 Users Online

I have 94 forums, 44 mods, 4.6mil posts, ~274,000 threads.

I think it's the size of my forum that's causing problems. Pity, because this is a great hack idea.
That's alot of mods. I'll have to look into it.

JsnakeJ 01-26-2006 04:38 PM
/me installs.

Very useful hack.

antialiasis 01-26-2006 04:41 PM
What statistics does this hack show exactly?

Martin 01-26-2006 04:41 PM
Quote:
Originally Posted by Abe1
That's alot of mods.
It's a big and somewhat active forum :)

Abe1 01-26-2006 04:50 PM
Quote:
Originally Posted by antialiasis
What statistics does this hack show exactly?
Look at the screenshot.

Abe1 01-26-2006 04:51 PM
Quote:
Originally Posted by Martin
It's a big and somewhat active forum :)
I just checked, my forum has 27 admin/smod/mod that show on stats. I have no problems. I will look into this though.

Daniel 01-26-2006 05:12 PM
Code:
Database error in vBulletin 3.5.3:
 
Invalid SQL:
 
SELECT userid, count(*) AS total
FROM moderatorlog AS moderatorlog
WHERE dateline >= 1135710669 AND userid IN ()
GROUP BY 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 ')
GROUP BY userid' at line 3
Error Number : 1064
Date : Thursday, January 26th 2006 @ 07:11:09 PM
Script : http://www.jabbatown.com/forum/misc....oderator_stats
Referrer :
IP Address : xxxxxxxx
Username :  xxxxxxxx
Classname : vb_database
Any ideas? Could it be another hack causing this?

Abe1 01-26-2006 05:16 PM
Quote:
Originally Posted by Daniel
Code:
Database error in vBulletin 3.5.3:
 
Invalid SQL:
 
SELECT userid, count(*) AS total
FROM moderatorlog AS moderatorlog
WHERE dateline >= 1135710669 AND userid IN ()
GROUP BY 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 ')
GROUP BY userid' at line 3
Error Number : 1064
Date : Thursday, January 26th 2006 @ 07:11:09 PM
Script : http://www.jabbatown.com/forum/misc....oderator_stats
Referrer :
IP Address : xxxxxxxx
Username :  xxxxxxxx
Classname : vb_database
Any ideas? Could it be another hack causing this?
Some one else got this same error. I will look into it.

Daniel 01-26-2006 05:18 PM
I wonder if it will be the same if you used the extension (I believe you just had to upload the file in the initial release), and not the plugin.

Abe1 01-26-2006 05:24 PM
Quote:
Originally Posted by Daniel
I wonder if it will be the same if you used the extension (I believe you just had to upload the file in the initial release), and not the plugin.
That would have nothing to do with it.

Abe1 01-26-2006 05:28 PM
Quote:
Originally Posted by Daniel
I wonder if it will be the same if you used the extension (I believe you just had to upload the file in the initial release), and not the plugin.
I just found something. Can you make sue you have moderators? Add in the settings that usergroup 6 should show in the stats. Do you still get the same error?

(This suggestion goes for the other user who also got the database error.)

Daniel 01-26-2006 05:41 PM
Yes, I still get the same error.

bashy 01-26-2006 06:15 PM
Great m8 thanks, Clicked install


All times are GMT. The time now is 04:14 PM.
Page 1 of 8 1 23 Last »
Show 40 post(s) from this thread on one page

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01511 seconds
  • Memory Usage 1,829KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (4)bbcode_code_printable
  • (12)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (2)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (40)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 
Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 
Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete