| Author |
 Topic  |
|
tcadieux
Junior Member
153 Posts |
 Posted - 02 March 2005 : 14:50:47
|
My boss wants me to wipe the database clean and start with some different parameters for Registration. I have some customisation though and i would rather just clean out the Members table than start with a new DB and have to customise again.
I tried just wiping out all non-admins from the DB but i got an error when trying to load it up the first time. Is there any easy way to do this? |
|
|
Podge
Support Moderator
Ireland
3776 Posts |
|
|
tcadieux
Junior Member
153 Posts |
Posted - 02 March 2005 : 14:57:29
|
| Absolutely, so long as the Forums remain? |
 |
|
|
tcadieux
Junior Member
153 Posts |
Posted - 02 March 2005 : 15:07:24
|
| actually, i treid that ands the users and Topics are all still there? |
|
|
|
Podge
Support Moderator
Ireland
3776 Posts |
Posted - 02 March 2005 : 16:44:50
|
When you say "forums remain" do you mean that you want all categories & seperate forums on the board to remain.
or do you want to start entirely from scratch?
If you want to delete users, topics, forums you could execute these sql queries (untested)
delete from FORUM_MEMBERS where MEMBER_ID <> 1
delete from FORUM_FORUM
delete from FORUM_TOPICS
delete from FORUM_REPLY
If you want to keep topics, etc. you know that you can just enable the extra member profile fields and have your userbase enter the extra details. |
Podge.
The Hunger Site - Click to donate free food | My Blog | Snitz 3.4.05 AutoInstall (Beta!)
My Mods: CAPTCHA Mod | GateKeeper Mod
Tutorial: Enable subscriptions on your board
Warning: The post above or below may contain nuts. |
Edited by - Podge on 02 March 2005 16:46:40 |
|
|
|
tcadieux
Junior Member
153 Posts |
Posted - 03 March 2005 : 08:20:50
|
I would like to keep the Forums, but remove all topics and all Members except those that are Admins. i'll try messing around with the Sql statement, thx
|
Edited by - tcadieux on 03 March 2005 08:32:42 |
|
|
|
Podge
Support Moderator
Ireland
3776 Posts |
|
|
tcadieux
Junior Member
153 Posts |
Posted - 03 March 2005 : 08:55:10
|
| What about all the Topics? The forums shoudl stay, along with who is the moderator. |
|
|
|
tcadieux
Junior Member
153 Posts |
Posted - 03 March 2005 : 08:56:19
|
The response i get is "there were 0 Lines of code"?
|
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 03 March 2005 : 09:11:12
|
How can you delete users and then keep the posts? Who should be shown as author of each post? How to keep a moderator, if you plan to delete the users? Have you considered all of this?
Wouldn't it be wiser to develop code to restrict access to all members until they provide all the (new) required info? |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
Podge
Support Moderator
Ireland
3776 Posts |
|
|
tcadieux
Junior Member
153 Posts |
Posted - 03 March 2005 : 09:19:42
|
| Topics and Replies can go, just the forums and Admins should stay... |
Edited by - tcadieux on 03 March 2005 09:20:08 |
|
|
|
Podge
Support Moderator
Ireland
3776 Posts |
|
|
tcadieux
Junior Member
153 Posts |
Posted - 03 March 2005 : 09:49:35
|
I get this response "There were 0 lines of code"
I should mention i am using Access 2000 |
Edited by - tcadieux on 03 March 2005 09:49:55 |
|
|
|
Podge
Support Moderator
Ireland
3776 Posts |
|
|
tcadieux
Junior Member
153 Posts |
Posted - 03 March 2005 : 09:53:35
|
| that's what i was doing, but i then get an error on my Active Users mod...I just want to avoid rebuilding the Forums and the Mods i had added. |
|
|
|
Topic |
|
Topic Locked
