Changeset 14 for veekun/script/base.sql

Timestamp:

02/20/07 23:43:38 (3 years ago)

Author:

eevee

Message:

Split forum flags into flags and accessibility; accessibility now controls, well, how accessible the forum is by default. 'Locked' means no new threads; 'archive' means no new threads or posts; 'hidden' means no new stuff and it's invisible. Permissions of 'override_forum_*' will (eventually) allow a user to bypass these restrictions per-forum.
This is only partially implemented; I will finish it up tomorrow or so.
Also started migrating from database slurping to iterators, one at a time. The changes are more related than they seem; I'm implementing some of the forum flags as extra search() calls, and if I slurp the results of the first search() immediately then I can't do another. Easiest way around this is to just make it an iterator and alter the templates slightly.
I also plan to do some general forum template refactoring, but that will come after this stuff actually works correctly.

Files:

• veekun/script/base.sql (modified) (1 diff)

veekun/script/base.sql

@@ -59 +59 @@
   threadct int(10) unsigned NOT NULL default '0',
   postct int(10) unsigned NOT NULL default '0',
-  flags set('locked','readonly','header','hidden') NOT NULL default '',
+  flags set('header') default NULL,
+  accessibility enum('normal','locked','archive','hidden') NOT NULL default 'normal',
   blurb varchar(255) NOT NULL default '',
   PRIMARY KEY  (id)