Suggestion - New User Applications

Posted: Thu Apr 02, 2009 7:49 am

On my support site, I get 100's of new applications daily, most of which are advertising bandits that register and THEN post to the forums, etc. I tried "admin approval" but that is just too much to keep up with and really no indication that the applicant is not welcomed.

Suggestion, will help immensely in my situation:

"Waiting Users" shows not only those that have not yet replied to the registration email but also those that have been "Approved". When new applications come in they are grouped together with those that have been approved already and waiting to make the final registration move.

What I would like to see:

1. Waiting Users separated by New and Approved
2. IP address and IP2C icon associated with new applicants
3. Delete rather than "deacivate" an unwelcomed applicant

"Deactivate" does not remove the user from the DB, I have to delete a user from PHPMYAdmin. Too much for a 40hr full-timer to handle sometimes.

Thanks for ANY consideration and maybe some suggestions. Wink

Cheers

registered · Posted: Fri Apr 03, 2009 7:07 am

dad7732, I think this should be in the RN enhancements/feedback forum? You are really talking more about the new RNYA module I think. I'll move it if you agree.

You do not have to use phpMyAdmin to remove users, in fact, you really never want to do that. Once a user is Deactivated, then the option to Remove opens up. That gets rid of them completely.

I just started this last month getting a handful of "Data Recovery" type spammer sign-ups. They are definitely a PITA. I keep adding their domains in the RNYA Limits tab to not allow their domains to sign up. At least they haven't been using the free-bie email domains strangely enough.

Posted: Fri Apr 03, 2009 7:22 am

Yes, by all means, move the topic. And in the future, please take it upon yourself to move 'em if necessary, don't need my "permission" but thanks for asking anyways.

When I deactivate a user, I don't see a "remove" that pops up anywhere. If this is a true "popup" then maybe popup blocking affects this?? Silly question maybe, dunno. Smile

Using IE-6 forcibly at work here, I'll see what happens if I deactivate a user. I'm sure there will be plenty opportunities today ... bah !!

The domains are gmail and yahoo mostly - 99% anyways, bummer.

Cheers

Posted: Fri Apr 03, 2009 7:42 am

Couple quick comments:

- There is no pop-up, but when you go to Deactivated users there is now an option in the drop down for "Remove".

- Guardian long back made it a rule to not allow the fee email domains. His logic is if you are on the web, you must have a domain, therefore, use it. [Well, yes, I put my spin on the logic.] You may want to consider that.

Posted: Fri Apr 03, 2009 7:51 am

Problem is, the emails are coming from "gmail.com" and "yahoo.com". Can't limit those as I have support users applying from those.

Anyway .. I don't have a "Deactivated Users" dialog anywhere that I can find. There must be a RNYA upgrade?

Using at present: [RN Your Account 2.30.01]

Cheers

Posted: Fri Apr 03, 2009 10:00 am

Once you have deactivated a user by selecting deactivate in the box adjacent to their name, you can then go to the deactivate users tab and they should appear there. You should then be able to select remove next to their name to remove them.

Posted: Fri Apr 03, 2009 10:05 am

That's the problem, no TAB.

Cheers

Posted: Fri Apr 03, 2009 10:32 am

Update:

I have a Deactivated Users TAB on another domain. However, in the domain in question with no TAB, I have a Users Waiting tab with a couple waiting even after approval. There is no Deactivated TAB in this instance. I would suppose that once the waiting user activates, the DU Tab will appear, yes? This "may" be a bug if the DU Tab is not showing when the waiting users tab is displayed.

Cheers

Posted: Fri Apr 03, 2009 10:36 am

So much for that theory, deactivated several "active" users and the DU Tab never appeared and NO users waiting tab. Only on this one domain, theme - RavenIce

Posted: Fri Apr 03, 2009 5:04 pm

Could this be a DB problem? Just noticed that the deactivated users still show up in the Regular and Active Users lists.

Posted: Fri Apr 03, 2009 5:15 pm

dad7732, I can't replicate this issue, so not sure. To see if you are getting a DB error, turn the db logging level up in rnconfig.php (to '1') and see if an error shows up in /rnlogs/dblog (make sure that file is writeable)

something is definitely amiss.

Posted: Fri Apr 03, 2009 5:51 pm

Here is the log entry after deactivating a user, looks ok to me:

Quote:

April 3, 2009, 6:48 pm 1054 : Unknown column 'points' in 'field list'
SQL was: UPDATE nuke_users SET name='Member Deactivated', user_password='', user_website='', user_sig='', user_level='-1', user_active='0', user_allow_pm='0', points='0' WHERE user_id='16303'

Hmm, except for the "Unknown column ....." I'll have to check that in the domain that IS working.

Posted: Fri Apr 03, 2009 5:52 pm

Sorry to jump in, I have not read this thread fully but just wanted to mention that Deactivated Users tab only becomes 'visible' if a user is actually de-activated to limit the number of tabs that are displayed.

'Waiting' users is in essence, any user that has not activated their account but good point, we should maybe look at being able to identify which of those has already been 'authorised' if admin approval is on.
Personally I just 'deny' if they have not activated them within 2 days.

Posted: Fri Apr 03, 2009 5:54 pm

Guardian ..

The TAB doesn't show up at all under any circumstances.

Posted: Fri Apr 03, 2009 5:59 pm

Ok, compared the nuke_users tables in both domains. In the one that works there is a field "points" and in the one that doesn't work it's missing. So, how do I get "points" in the nuke_users field. That "may" do the trick.

Posted: Fri Apr 03, 2009 6:16 pm

SOLVED

My Son the *NIX and MySQL guru fixed it by adding the field "points" to nuke_users. Went back in and deactivated a user and hoop dee doo .. it works, I have a deactivated users tab now ... Groovy

Looking at the dblog and noting "points" is what led to the fix, thanks to Montego for suggesting that!!

Cheers, another one down, onward we trudge.

Worker Joined: Oct 26, 2004 Posts: 134 Location: Boston

God bless the children Wave

Involved Joined: Jul 03, 2006 Posts: 273

To follow the first request about the issue is there a special reason "REMOVE" is not an option in the first place? I mean why must one deactivate first then remove? Can't remove be added as well just so you can fell swoop an action? Of course deactivating has its advantages by blocking the user I suppose so it should be kept as an option.

Posted: Sat Apr 04, 2009 7:48 am

Guardian:

Just noticed that if you have "Waiting Users", the "Deactivated Users" tab shows up before the WU tab, so all is well in that respect.

Cheers

Posted: Sat Apr 04, 2009 8:22 am

duck, not sure. Most likely a CNBYA carry-over and I suspect it might have something to do with the old "Are you sure you want to delete?" concept. Gives you a "cooling off period". lol. I cannot imagine why it couldn't be added.

Posted: Sat Apr 04, 2009 8:22 am

Turning the tables .. Very Happy

Just thought I'd pass ths along for grins and giggles. I approved a user with a strong suspicion that it was one of those ad-link gremlins that would soon be posting a link in the forum. I saw him activate and immediately changed his "website" link to my site. Sure 'nuff he posted and my site link was beautifully displayed .... har har ... deactivated and removed.

Cheers