| Author |
 Topic  |
|
|
RedLeader
New Member
USA
85 Posts |
 Posted - 20 April 2001 : 09:58:40
|
The 1 thing I see lacking with Snitz is the documentation of the tables and fields.
As I'm trying to make modifications etc I feel like I'm banging my head against the wall b/c I don't know why, where or when certain fields are being updated, if they are being used and what MOD is using them.
Is there any compiled documentation out there? I know that it could be a massive evolving document. Does one exist? If not, here's an idea.
What if we built a subsite, that was database driven that allowed for people to define the tables, fields, uses etc. This way there would be 1 living document that people could reference and everyone could added to.
Any takers? If so, I could try to get it started. Although, I don't know much about the current database structue for Snitz.
RL< |
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 20 April 2001 : 10:38:34
|
No not that I am aware of, what particular issues do you need resolving
< |
 |
|
|
RedLeader
New Member
USA
85 Posts |
Posted - 20 April 2001 : 12:04:49
|
Well, I'm looking at restricting the total # of posts that a forum can have. So I started looking into the FORUM_TOTALS table.
I wasn't sure what the fields where(Although I have guesses) when they were updated and where. etc. Just in general what were valid field values for things.
< |
|
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 20 April 2001 : 12:24:55
|
The TOTALS fields are updayed in post_info.asp and admin_count, your best bet would be to put a query in inc_top which checked the totals table and gave you the post count, you could then set the status of a forum to locked if the post count is too high.
< |
|
|
|
Levteck
Starting Member
USA
15 Posts |
Posted - 23 April 2001 : 14:50:06
|
Hi,
I generated the ERD (list of table with field names and type) for the access database inluded with the Forum program.
You can see it at:
http://www.levteck.com/ForumErd.htm
Congratulations to all the programmers on this project :)
M. Levesque
< |
|
|
| |
Topic |
|
Forum Locked
