Admin Toolbox

[Spuds]

Link to Mod

Admin Toolbox Mod
By Spuds

License
o This Modifications Source Code is subject to the terms of the Mozilla Public License version 2.0 (the "License"). You can obtain a copy of the License at http://mozilla.org/MPL/2.0/.

Introduction
This modification adds several new admin maintenance functions including

• Recalculates user post counts
• Merge two users in to a single ID
• Mark inactive users as read all posts
• Recount forums daily statistics

This mod is compatible with SMF 2.0 Only.

Support
Please use the admin toolbox modification thread for support with this modification.

Changelog
1.0 - 14 Jan 2012
+ Initial Release

[4Kstore]

Merge 2 users !! FANTASTIC IDEA!!!
Congratulations  for this mod

[viulian]

Hello

I've been curios about the daily activity (since my forum is running from 2003 or something) but after a while - I get this error:

Code Select Expand

Column count doesn't match value count at row 123
File: H:\xampp\htdocs\community\Sources\AdminToolbox.php
Line: 840

The comment on top is great though )

Code Select Expand

// Purples may not want to look at what I'm doing here, just move along, its all good, nothing to see here :)

Indeed, nothing to see, its a bit too generic to spot immediatly what's the issue without some debug statements..

[Spuds]

I'm not sure what you are trying to say or ask to be honest ... lost 

What version of SQL are you running
Do you have any existing data in the log_activity table
Does the log_activity table exist at all
What option did you choose for the data rebuild
etc ....

[distante]

wow, really great mod!

[Game.ruler]

If i mark inactive users as read all post then will it reduce my database size?

[distante]

If i mark inactive users as read all post then will it reduce my database size?

yes

[Spuds]

If i mark inactive users as read all post then will it reduce my database size?

Short answer is generally yes ... if you are not using / converted those tables to innodb from myisam.   

Longer answer is this depends on how many users you have, if they were ever active,  number of boards and topics, how big the forum is, etc etc  ... Basically the function moves the multiple tracking entries from the log_topics table which stores the position that each member is in each topic  ....... to 'single' entries in the log_board and log_mark_read tables.  So one table will go down in size, two other may increase (but that increase is less than the reduction of the other).

[Nitesh Kunnath]

An Awesome mod ever...It helped me a lot

[Game.ruler]

Thanx for the reply guys.
I've 5,000 users but nearly 4,000 of them are inactive now. So i think it will reduce much database size na

[whatevah]

Would love this if I could get it to work

Keeps throwing up an error during Step 4 of merging two accounts.   Instead of showing the progress screen I get this error:

Code Select Expand

Database Error
Duplicate entry '27665-996' for key 1
File: /htdocs/forum/Sources/AdminToolbox.php
Line: 1127


Using the latest coding, downloaded an hour ago.   Any suggestions?  I'm going over the file now, but I haven't done any coding in a while and I'm pretty rusty.

[Sapozhnik]

Great mod, thanks
But it has small problem
It counts messages in boards where the counting of posts is disabled.

[Spuds]

In which function

[Sapozhnik]

In which function

Recount User Posts

[Spuds]

Well that is odd ...

The query specifically only loads boards that has post count enable and makes sure it does not count anything in the recycle board for those that have that enabled. 

I just did a quick test on my test forum and it did not count any user posts in a board with post count off .... so not sure why its not working for you. I'll do some more poking around but ATM there is nothing obvious.  Was it adding posts or not subtracting posts?  MySQL? PHP version? main board or a child board?  Just looking for clues.

[Sapozhnik]

Thanks a lot,
I'll check the mode some times yet and describe in this topic

[Sapozhnik]

User has:
Summary  70 messages
==================
1st board - 4 pcs (child board, count off)
2nd board - 5 pcs (child board, count off)
3rd board - 61 pcs (child board, count off)
After recounting, I see the quantity 32 messages in the his profile

PHP Version 5.3.10-pl0-gentoo
SQL    5.1.61-log



Updated:
Possibly... If user doesn't have any posts in the board with count, counter doesn't change.
Early, the counter in these boards was enable, then I disabled counter.

[Spuds]

I'm trying to understand what you are doing ...

So a user had 70 posts in 3 boards ... you went in and disabled the post count in those boards and it dropped to 32 and you were expecting it to be zero?  Are you sure they only had 70 posts in total to begin with?  ... You can try show users posts and see or do it via phpmyadmin.

One thing to try  .... in AdminToolbox.php, at around line 175

Code (find) Select Expand

SELECT m.id_member, COUNT(m.id_member) AS posts

Code (replace) Select Expand

SELECT /*!40001 SQL_NO_CACHE */ m.id_member, COUNT(m.id_member) AS posts

just in case its some cache problem going on with mysql.

[Sapozhnik]

sorry for my english. 

Yes, user has only 70 posts. (Maybe i disabled counter when he had 32 posts)
I've tried to move one post to boards where counter is enabled and after recounting quantity of posts was changed to 1.
If all posts of user are placed in boards where counter is disabled, the counter of posts doesn't changed after recounting.
Try on your forum: move all posts of test-user to board where posts don't count and re-count them.
I think the quantity of posts won't change.

Sorry, I'm can't try replace the code now. I'll try it tomorow. I don't have full access to the forum now

[Spuds]

OK ... I think I understand now!

Hummmm ... need to think about how to properly detect that case.  I do have some processing after the main recount to zero members who have no posts (in countable boards) but it must be getting tripped up by this case of only posts in non countable boards.   The cache thing above is not going to help (but it will not hurt either)

I'lll see what I can do over the next couple of days.