| Author |
 Topic  |
|
leatherlips
Senior Member
USA
1838 Posts |
|
|
Jezmeister
Senior Member
United Kingdom
1141 Posts |
 Posted - 27 August 2005 : 18:29:02
|
| deleting their row in the tables column would not delete posts. they would i suppose be able to register again under a different name... you could just as easily as the super admin change their name in profile though if that's all you're wanting to do. you could also edit the code to allow them to change it at any time, i think theres a mod for that somewhere. |
Edited by - Jezmeister on 27 August 2005 18:31:13 |
 |
|
|
leatherlips
Senior Member
USA
1838 Posts |
|
|
Jezmeister
Senior Member
United Kingdom
1141 Posts |
Posted - 27 August 2005 : 18:46:37
|
to be honest I don't know what it would say, i dont have access to a snitz db at the moment and while i know the code i dont know the db all that well... have a look - if it says under posted by or similar, a name (in the topic/post table) you're fine, if it says a number (member id) then it may throw an error at you. i'm not entirely certain what it would do - everytime i've dealt with a member who has done enough to be deleted and has posted ive simply locked them and changed their title.
would it be feasible to simpy install the mod for a certain amount of time, make sure noones screwing you around then return the code to what it used to be so they can no longer change it? |
Edited by - Jezmeister on 27 August 2005 18:48:38 |
|
|
|
leatherlips
Senior Member
USA
1838 Posts |
|
|
Jezmeister
Senior Member
United Kingdom
1141 Posts |
Posted - 27 August 2005 : 22:28:37
|
| im not sure... if it doesn't exist it wouldn't be all that hard to create it... have a around here- if you can't find anything, look for the mod tha allows members to change their own titles - following the way that changes things but editing it to your own needs should be enough. |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 28 August 2005 : 05:49:00
|
Do not delete them from the database, otherwise the forum code will stop working, since the posts will not have a corresponding record in the members table as post authors. Only if you use the forum member delete function will n/a be used instead of their user names.
|
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
Duby
Starting Member
9 Posts |
Posted - 22 September 2005 : 09:57:22
|
| How can I see if I have ever deleted any member from forum? |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
Shaggy
Support Moderator
Ireland
6780 Posts |
Posted - 22 September 2005 : 10:39:49
|
If you deleted any non-posting members then the sequence of MEMBER_ID will be broken where their record was removed.
|
 Search is your friend
“I was having a mildly paranoid day, mostly due to the
fact that the mad priest lady from over the river had
taken to nailing weasels to my front door again.” |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
MarcelG
Retired Support Moderator
Netherlands
2625 Posts |
Posted - 22 September 2005 : 13:48:36
|
quote:
Originally posted by ruirib
Unless you're using Access and you have compacted the DB after the deletion...
That's not entirely correct afaik.
Let's say you've got 10 members (1 to 10)
You delete member 7
So, now you've got members 1 to 10 excluding 7.
If you compact the db, I do not expect the next registering member to be number 7 again ? Or am I wrong?
not that it really matters anyway |
portfolio - linkshrinker - oxle - twitter |
Edited by - MarcelG on 22 September 2005 13:48:55 |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 22 September 2005 : 13:54:33
|
Yes, it won't fill in gaps among existing numbers. My point is that if the members have not posted, you cannot really be sure that members have not been deleted, if you are using Access. Some deletions will be obvious, agreed.
In the forum I used to administer, deleting the latest user was a common thing. Many users forgot their details and registered again. Curiously, just today I deleted the latest member, at his own request, at this very forum. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
waynem
Starting Member
13 Posts |
Posted - 26 October 2005 : 12:39:08
|
| I would like to remove the N/A's from the database, along with any posts they have made. Is there a cleanup mod or way to do this? I tried to delete them from the member listing - I have like 30 pages of them now - but although I do not get an error message, nothing is actually being deleted. |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
waynem
Starting Member
13 Posts |
Posted - 26 October 2005 : 14:38:56
|
| Thanks...there must be something in the code that prevents them from being deleted, but I wish there was a way. Too much excess baggage filling up the database, and I wanted to slim down as much as possible before converting Access to SQL. |
|
|
|
Topic |
|
Topic Locked
? You can have a look for members named n/a. If you deleted members without posts, there's no way to know about them.