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!
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
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.
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...
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...
Topic Locked
Posted - 16 April 2004 : 12:19:32
