| Author |
 Topic  |
|
|
Reinsnitz
Snitz Forums Admin
USA
3545 Posts |
 Posted - 16 April 2004 : 12:19:32
|
I'm seeing a real need to increase the split in the tables to allow multiple forums to use the same member tables.
Currently, the same member table has to keep the same MODERATORS and ADMINISTRATORS as the other... which is a HUGE security risk if the forums are for use by different groups entirely.
SOOOOOOOOOOOOOOO.... this MOD will need to basicaly make a reference table that mirrors the MEMBERS table and has entries for members who are MODERATORS or ADMINISTRATORS... thus allowing fully unique forums on the same network to reference the same member tables and keep their unique identity and above all else... security.
If someone else doesn't pick this one up... I think I will!  |
Reinsnitz (Mike) |
|
|
Reinsnitz
Snitz Forums Admin
USA
3545 Posts |
Posted - 19 April 2004 : 12:50:30
|
| Anyone else find this concept particularly usefull or anoying? |
Reinsnitz (Mike) |
 |
|
|
MarcelG
Retired Support Moderator
Netherlands
2625 Posts |
Posted - 19 April 2004 : 13:31:10
|
I would find this concept very usefull, splitting it up that it.
However, i wouldn't have a clue on how to tackle it... |
portfolio - linkshrinker - oxle - twitter |
|
|
|
HuwR
Forum Admin
United Kingdom
20593 Posts |
Posted - 19 April 2004 : 14:04:35
|
| could be done with a simple additional table which stores the moderators id and the board to which they are moderator, you could then add a small check to the current auth code so that if a user is a mod or admin, you then check which actual board they are moderator for |
|
|
|
Etymon
Advanced Member
United States
2391 Posts |
Posted - 20 April 2004 : 23:54:42
|
Hi Mike,
I also have an impending need coming soon for this type of MOD. Please remember me if you learn more - (admin@carolinaequine.com). Thank you. 
Etymon
|
|
|
|
lilaccrafts
Starting Member
18 Posts |
Posted - 21 April 2004 : 14:50:06
|
Heres the way to do it.
1. Since the snitz database has not relationships at all it make this task all so easy.
2. Find the tables Forum_members, Forum_members_Pending, Forum_Moderator, and any others you do not want to change. Now make duplicates of the other files and name those the same with the exception of adding a 1 to it so you would have Forum_Forum and a table called Forum_Forum1(this is for your other forum). You can have more just by changing the numbers.
3. now make a duplicate forums folder with all the snitz folders and files. So your new one would be forum1
4. Now you need a program that can find and replace. a very good program is dreamweaver versions 3 and above.
5. GO into dreamweaver and start replacing each table in your new forum with the new tables.Use the find and replace feature. You can find all the code with Forum_Forum and replace it with Forum_Forum1 site wide.Works really nice. Do this for each table you want to change over. Takes about 1/2 to do all tables.
6. Now what you have to do is change the site path in some of the snitz files if any. You can use dreamweavers find and replace to do that. I just had a few to do not many.
With access your limited to I think 2 giga on the database itself.
And you would have to different admin sections which is nice.
Hope this helps. Be nice if there was a mod for this.
|
Edited by - lilaccrafts on 21 April 2004 14:52:38 |
|
|
|
Jezmeister
Senior Member
United Kingdom
1141 Posts |
Posted - 21 April 2004 : 16:38:31
|
| hey this mod idea has given me an idea... i hav a use for it - (using the same members table etc for all 123 Chat forums - letting me easily having an idea of the number of non-admin users...) ill test it if u want... |
|
|
|
lilaccrafts
Starting Member
18 Posts |
Posted - 21 April 2004 : 18:01:44
|
quote:
Originally posted by Jezmeister
hey this mod idea has given me an idea... i hav a use for it - (using the same members table etc for all 123 Chat forums - letting me easily having an idea of the number of non-admin users...) ill test it if u want...
The way i showed has been working for me. |
|
|
| |
Topic |
|
Topic Locked
