Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 Help Groups for Snitz Forums 2000 Users
 Help: General / Classic ASP versions(v3.4.XX)
 cleaning up the DB		  New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

tcadieux
Junior Member

153 Posts
Posted - 28 July 2004 :  17:42:39  Show Profile
I noticed i have a Tonne of DELETED users, how can i clean them out of the DB?? Thier Usernames are making it so that new users cannot choose those names.

ruirib
Snitz Forums Admin

Portugal
26364 Posts
Posted - 28 July 2004 :  20:49:36  Show Profile  Send ruirib a Yahoo! Message
You may try a search for a mod to do that, though I really can't tell you whether there is a mod for that or not. Anyway deleted users usually have their names replaced by n/a, so I don't see how that can be a problem?!

Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

HuwR
Forum Admin

United Kingdom
20595 Posts
Posted - 28 July 2004 :  21:10:19  Show Profile  Visit HuwR's Homepage
when you delete a user their name is set to n/a, so should not affect the re-use of the username at all, deleted users only remain in the database if they have posts associated to their userid, but the name is junked.
Go to Top of Page

tcadieux
Junior Member

153 Posts
Posted - 28 July 2004 :  22:02:15  Show Profile
aha, it was N/A that this user was trying to use.

EDIT:

What about if they were trying to re-register, thier e-mail would not be accepted?
Edited by - tcadieux on 28 July 2004 22:03:12
Go to Top of Page

OneWayMule
Dev. Team Member & Support Moderator

Austria
4969 Posts
Posted - 28 July 2004 :  22:45:15  Show Profile  Visit OneWayMule's Homepage  Send OneWayMule an ICQ Message
quote:
What about if they were trying to re-register, thier e-mail would not be accepted?

You can choose whether you want each user to use an unique email address in
Admin Options -> E-mail Server Configuration -> Require Unique E-mail.
My MODs:
Birthdays - Custom Policy - F.A.Q. Administration - Forum Rules - Guestbook
Links Manager - MyOwnGoogle - Profile Views - Search Log - WebSearch

Useful stuff:
Forum and MOD Installation - MOD Installation Guide - Snitz v3.4.05 Readme - Free ASP Hosts - Support Snitz
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts
Posted - 29 July 2004 :  13:11:00  Show Profile  Send ruirib a Yahoo! Message
I don't know whether the email is kept. I would think not, but I'm not sure.

Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

Davio
Development Team Member

Jamaica
12217 Posts
Posted - 29 July 2004 :  13:28:24  Show Profile
The email is also removed.
'## Forum_SQL - disable account - Member has posts, cannot delete just disable account
strSql = "UPDATE " & strMemberTablePrefix & "MEMBERS "
strSql = strSql & " SET M_STATUS = " & 0
strSql = strSql & ",    M_EMAIL = ' '"
strSql = strSql & ",    M_LEVEL = " & 1
strSql = strSql & ",    M_NAME = 'n/a'"
strSql = strSql & ",    M_COUNTRY = ' '"
strSql = strSql & ",    M_TITLE = 'deleted'"
strSql = strSql & ",    M_HOMEPAGE = ' '"
strSql = strSql & ",    M_AIM = ' '"
strSql = strSql & ",    M_ICQ = ' '"
strSql = strSql & ",    M_MSN = ' '"
strSql = strSql & ",    M_YAHOO = ' '"
strSql = strSql & " WHERE MEMBER_ID = " & cLng(delAr(i))
Support Snitz Forums
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.44 seconds. Powered By: Snitz Forums 2000 Version 3.4.07