| Author |
 Topic  |
|
|
Chris Yew
Junior Member
134 Posts |
 Posted - 21 August 2002 : 03:08:43
|
I've just downloaded the new ver 3.4. Everything is fine and the database was transferred from my old ver 3.3.03.
When I (administrator) delete a member (say CY) off the member list, this CY cannot re-register again. When CY register again, it says that the email is used by another one.
If I delete a member off the list, do I delete the user name as well as the respective email address in the database, so that he can re-register again?
My forum site is;
http://www.bettaclub.org.sg/forum/
Pls help. Thank you.
Chris Yew
|
Edited by - Chris Yew on 21 August 2002 03:11:47 |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
davemaxwell
Access 2000 Support Moderator
USA
3020 Posts |
Posted - 21 August 2002 : 08:39:30
|
If the member has made posts, then his member record is not really deleted. The userid is removed(changed to n/a), but the record remains. If you require unique email addresses, he will not be able to re-register unless you edit the "deleted" record and remove the email address.
Why would you want to allow someone who has been deleted from your members list to re-register. Kinda defeats the purpose of deleting him, doesn't it? |
Dave Maxwell
Barbershop Harmony Freak |
 |
|
|
Chris Yew
Junior Member
134 Posts |
Posted - 21 August 2002 : 09:21:24
|
Thanks for the reply.
In my case it's that I've loggon as Admin and deleted my own name (who has already made posts)to test whether if I'll receive an email notification when I register. Having deleted my own name, I realised that I cannot re-register again as it shows the email address has been used.
There may be chances where the Admin accidentally deleted a wrong member thus have to allow him to re-register.
Is there any 'fix' for this? Is it possible that before deleting a member who had made post, I have to go to that member profile to change his User Name and password to any other User Name and password so that he can re-register again using the same.
Chris Yew
|
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 21 August 2002 : 09:42:23
|
| when you delete a member that still has posts, then the record is not deleted, but their username is changed to n/a and the e-mail address is set to ' '. So, there must be another user with the same e-mail address. |
|
|
|
davemaxwell
Access 2000 Support Moderator
USA
3020 Posts |
Posted - 21 August 2002 : 09:51:49
|
If you want to see one's that are deleted, then change this code in members.asp (on line 150 in v3.4) from this:
if mlev = 4 then
strSql3 = " WHERE M_NAME <> 'n/a' "
else
strSql3 = " WHERE M_STATUS = " & 1
end if
to this:
if mlev <> 4 then
strSql3 = " WHERE M_STATUS = " & 1
end if
Now this will ALWAYS show you deleted members, so you might want to make an alternate version of members.asp so you can only use this in certain situations.... |
Dave Maxwell
Barbershop Harmony Freak |
|
|
|
Chris Yew
Junior Member
134 Posts |
Posted - 21 August 2002 : 10:04:57
|
Thanks, will try that mod proposed by Dave.
But before I do that, I realised that my members.asp script doesn't look quite right.
Line 150 to 158;
if mlev = 4 then
strSql3 = " WHERE M_NAME <> 'n/a' "
else
strSql3 = " WHERE M_STATUS = " & 1
end if
end if
select case SortMethod
case "nameasc"
strSql4 = " ORDER BY M_NAME ASC"
Why am I having two end if on Line 154 and Line 155? Is there some insertion on line 155 that I've left out?
Chris Yew |
Edited by - Chris Yew on 21 August 2002 10:26:29 |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
| |
Topic |
|
Topic Locked
