|
User Control v1.23
|
| HobbyMan |
Posted on 18-03-2011 19:10
|

Super Admin

Posts: 1501
Joined: 24/03/2007
|
What it does:
This is a powerful Administrators tool for the bulk banning or deletion of user accounts. It will display up to 100 users per page depending on access level and setting chosen giving an Admin with Ban privileges the ability to ban or delete multiple selection of user accounts. With built in Spam Rate, it give a site admin a quick glance at the member accounts and any content all in one place.
User Control - This is a list of all members with a lower post count than post threshold (see settings).
Group by IP - This will display all IP addresses that have 2 or more members using that IP.
IP Lookup - Enter an individual IP address to view any members using that IP.
Members IP - Enter User ID to view all IP addresses used by that member since they joined.
User ID Lookup - Enter a Users ID to view all content posted by that member.
Inactive User - Lists all users who never logged in by default. Use dropdown to view different timescales.
Admin Rights - View all Rights attributed to Administrators *
Month Stats - Displays a registration statistics by month
Changelog:
v1.23
Added setting to turn off nav icons for narrow themes.
Various bug fixes
v1.22
Auto detection of installed Shoutbox
Various bug fixes
v1.20 - Major Upgrade
Added Admin Password requirement as extra precauiton.
Added Members IPs Search.
Cleaned up "GROUP columns" errors.
Added landing page with latest members and visits stats.
Update Settings
Added Version Server.
Added prevention of accidentally blacklisting Admins IP.
Added logging of last Admin to use it.
-- View this Addon --
Edited by HobbyMan on 25-10-2012 20:29
|
| |
|
|
| Rolf Mayer |
Posted on 18-03-2011 19:20
|

Senior Member

Posts: 413
Joined: 01/11/2010
|
Thank you, Philip for this great Addon. I already downloaded it from your website.
Ex
|
| |
|
|
| Stewart-G0LGS |
Posted on 18-03-2011 23:47
|

Member

Posts: 77
Joined: 28/11/2010
|
I installed it on my test site (which have never had a version of this installed before) and it looks ok.
However on my active site I failed to defuse the older version (1.13) before infusing this one which seems to have resulted in some missing index errors on line 136 of inc/functions_include.php .
Now having defused it I cannot get either 1.13 or 1.20 to infuse - I click Infuse the screen refreshes, but it still shows as not infused !!
Stewart G0LGS
I DO NOT response to PM's regarding any posts on this Forum !
|
| |
|
|
| Goldenhawk |
Posted on 18-03-2011 23:52
|

Member

Posts: 57
Joined: 04/01/2011
|
Hi,
i've same problem as Stewart-GOLGS.
I've already translated the locale and i've posted Italian.php there.
When you teach, teaches at the same time to doubt what you teach...
|
| |
|
|
| Stewart-G0LGS |
Posted on 19-03-2011 00:20
|

Member

Posts: 77
Joined: 28/11/2010
|
I've fixed being able to infuse it on mine:
In the _admin Table (via phpmyadmin) I removed the Entry for 'USCT' and then it infused OK.
However the Spam Rating code still seems suspect to me. Users with just 2 forum posts (that look fine to me) are showing as high spam rate.
(See my Previous post at http://www.php-fu...st_150148)
Edited by Stewart-G0LGS on 19-03-2011 09:25
Stewart G0LGS
I DO NOT response to PM's regarding any posts on this Forum !
|
| |
|
|
| Goldenhawk |
Posted on 19-03-2011 08:15
|

Member

Posts: 57
Joined: 04/01/2011
|
Hi,
the table _ADMINS does not exists in my DB, but the table _ADMIN exists and i not find USCT entry. How can i fix the problem?
When you teach, teaches at the same time to doubt what you teach...
|
| |
|
|
| HobbyMan |
Posted on 19-03-2011 08:57
|

Super Admin

Posts: 1501
Joined: 24/03/2007
|
If you have problems defusing the old version copy this into a custom page and click Preview
Code<?php
$remove_ar = dbquery("DELETE FROM ".DB_ADMIN." WHERE admin_rights = 'USCT'");
$remove_inf = dbquery("DELETE FROM ".DB_INFUSIONS." WHERE inf_title = 'User Control'");
?>
Once done, infuse the new version.
@SG, the spam rate has nothing to do with forum posts, it runs off the users profile. This is to catch spam accounts that are just using your site to increase their google ranking.
@ GH, thanx for the locale :)
|
| |
|
|
| Stewart-G0LGS |
Posted on 19-03-2011 09:24
|

Member

Posts: 77
Joined: 28/11/2010
|
Philip wrote:
@SG, the spam rate has nothing to do with forum posts, it runs off the users profile. This is to catch spam accounts that are just using your site to increase their google ranking.
On my site users that have no Sig and no Web URL entered in their profile get a Spam Rating of 2 with the original code (seems to count each of those empty items as 1).
I have at least one user who's Signature (about 20 words) appears to have NONE of the words in the word list in either his Sig or Web URL that has shows as High Spam Rate.
Something is surely wrong with the spam_rating code, my limited testing using my changes from the other thread seem to make it work and count only the words in the built-in and site bad_words lists.
Stewart G0LGS
I DO NOT response to PM's regarding any posts on this Forum !
|
| |
|
|
| Goldenhawk |
Posted on 19-03-2011 09:56
|

Member

Posts: 57
Joined: 04/01/2011
|
Philip wrote:
If you have problems defusing the old version copy this into a custom page and click Preview
Code<?php
$remove_ar = dbquery("DELETE FROM ".DB_ADMIN." WHERE admin_rights = 'USCT'");
$remove_inf = dbquery("DELETE FROM ".DB_INFUSIONS." WHERE inf_title = 'User Control'");
?>
Once done, infuse the new version.
@SG, the spam rate has nothing to do with forum posts, it runs off the users profile. This is to catch spam accounts that are just using your site to increase their google ranking.
@ GH, thanx for the locale :)
Why not a control inside in infusion_db.php ? [just for professional mentality]
When you teach, teaches at the same time to doubt what you teach...
|
| |
|
|
| HobbyMan |
Posted on 19-03-2011 10:07
|

Super Admin

Posts: 1501
Joined: 24/03/2007
|
@ SG, Well, whatever works for you is fine.
I've been running UC with the spam rate function here and elsewhere for 7 months now and it works as it should on all sites.
User Control was originally developed to help combat the spam wave we had last July when our new registrations per day went from 10-15 to nearly 200. Spam Rate is just a guide, it's not definitive. It's to be used in conjunction with other information to get an overall picture of an account.
Example; If "Joined" and "Last Visit" are only seconds apart, it's most likely a bot even if there's no sig.
Example;
Name: user12345
Email:
Joined: 8/03/2011 02:58
Last Visit: 18/03/2011 03:08
Web URL: http://mybigfatseosite.com/seo
Even though it generates a spam rate of only 1, I would still regard this as a spam account and kill it.
It'll also catch multi accounts using the one IP, sometimes it's a genuine reason like a school or university but generally it's not.
It's a judgement call as to whether it's a genuine signup or not. If you're not sure, leave it for a while and use the "Inactive Users" page at a later date to see if any suspects return. The bot writers are getting cleverer all the time, some bots will just sign up and return at a later date to populate the profile. Some will post a generic forum post to make it look like a genuine person.
UC was written for a standard install, there was no way I could foresee all the various modifications and other Addons that some members have. I realise it's a "reactive" system, not a "proactive" one. But, so far no one has invented the perfect spam/bot killer.
Ref:
http://www.youtub...1NV1QFrHso
http://www.youtub...lgZhGEuVfg
Edit:
@ GH, I've no idea why it wouldn't defuse. It's been thoroughly tested that problem never arose. It looks like SG tried to infuse without first defusing the old version. The settings field names have changed, that's why an update infuse won't work.
Edited by HobbyMan on 19-03-2011 10:13
|
| |
|
|
| Goldenhawk |
Posted on 19-03-2011 10:30
|

Member

Posts: 57
Joined: 04/01/2011
|
[update]: all done, Philip, all OK, Great addon, as always. Regards
When you teach, teaches at the same time to doubt what you teach...
|
| |
|
|
| Stewart-G0LGS |
Posted on 20-03-2011 00:27
|

Member

Posts: 77
Joined: 28/11/2010
|
Philip wrote:
@ SG, Well, whatever works for you is fine.
I've been running UC with the spam rate function here and elsewhere for 7 months now and it works as it should on all sites.
Perhaps it works as you you feel it should, however for me marking (and thus auto selecting accounts for blacklisting / deletion) based on what appears to me is a broken SPAM Rating system is just annoying.
I like other features of the Infusion.
It seems that we will just have to live with dis-agreeing on this aspect.
Stewart G0LGS
I DO NOT response to PM's regarding any posts on this Forum !
|
| |
|
|
| HobbyMan |
Posted on 31-03-2011 07:40
|

Super Admin

Posts: 1501
Joined: 24/03/2007
|
Error in multi_ip_lookup.php not allowing blacklisting of IP's
Now fixed, download updated.
|
| |
|
|
| NetriX |
Posted on 01-04-2011 19:32
|

Admin

Posts: 384
Joined: 22/09/2007
|
Nice infusion, works great.
I'd like to post a suggestion.
In multi_ip_lookup.php, when searching for an IP, have it work for dynamic IP's.
If you'd like I can update it for you.
|
| |
|
|
| gh0st2k |
Posted on 06-04-2011 21:41
|

Member

Posts: 134
Joined: 23/11/2008
|
Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clauseMixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause
Notice: Undefined variable: ipcount in XXXX/infusions/user_control/user_control.php on line 206 |
| |
|
|
| HobbyMan |
Posted on 07-04-2011 07:59
|

Super Admin

Posts: 1501
Joined: 24/03/2007
|
@Ntx, go right ahead
@ghost, I'll have a look when I get a chance.
|
| |
|
|
| HobbyMan |
Posted on 18-04-2011 07:46
|

Super Admin

Posts: 1501
Joined: 24/03/2007
|
Due to the changes in v7.02 if you don't have shoubox installed on your site, UC will generate errors
Will post fix asap
|
| |
|
|
| icb |
Posted on 01-05-2011 11:20
|

Member

Posts: 50
Joined: 01/11/2010
|
Philip wrote:
Due to the changes in v7.02 if you don't have shoubox installed on your site, UC will generate errors
Will post fix asap
Still get that error. I have shoutbox there after converting from 7.00.xx ver. but it still generates errors. Maybe I need to install some other shoutbox? If so, where to find it ? |
| |
|
|
| arat |
Posted on 01-05-2011 14:05
|

Member

Posts: 80
Joined: 05/01/2008
|
icb wrote:
I have shoutbox there after converting from 7.00.xx ver. but it still generates errors. Maybe I need to install some other shoutbox? If so, where to find it ?
I had shoutbox errors also and this solved the errors:
http://dev.php-fu...ad_id=1599 |
| |
|
|
| HobbyMan |
Posted on 01-05-2011 17:13
|

Super Admin

Posts: 1501
Joined: 24/03/2007
|
If you have a shoutbox installed..
open user_control/infusion_db.php
add..
Codeif (!defined("DB_SHOUTBOX")) {
define("DB_SHOUTBOX", DB_PREFIX."shoutbox");
}
Temporary fix for those with shoutbox installed.
|
| |
|