more robust sql scripts adding IF EXISTS to DROP TABLE statementes

[brisk.git] / TODO.txt

diff --git a/TODO.txt b/TODO.txt
index 577cfe4..a84c3e9 100644 (file)
--- a/TODO.txt
+++ b/TODO.txt
@@ -3,6 +3,45 @@
 
   FEATURES |
  ----------+
+   - APPRENTICE
+     Phase1
+     DONE - ip check and time limit
+       DONE . sql
+         DONE . temporary table limitation
+       DONE . message
+     DONE - usermgmt extension
+     DONE - add close button
+     DONE - add apprentice icon
+     - match counters
+       . sql for match counters
+       . migration script for old users
+
+     Phase2
+     - new info system
+     - guarantee for apprentice
+   
+    - MENTORS
+     - listen all
+
+   - BUDDY LIST
+     - white list
+     - black list
+     - delegate
+
+   - DEANONYMIZER
+      . study how to move login delta injection
+
+   - CERTIFICATIONS
+      DONE . Guarantes for certified-only (buttons choice managed)
+      DONE . Tables for certified-only
+      . Term Of Use
+      . Placing for certified-only
+
+   - IP CLASSES BAN
+      DONE . BAN and BLACK lists added
+      DONE . update method to SIGHUP manager
+      DONE . create constructor refactored
+
    - PLACEMENT-NORMALIZATION
       DONE . Normalize previous points
       DONE . Denormalize "Info" view
@@ -31,38 +70,52 @@
        DONE . command documentation
        DONE . manage disagreeding users investigation
        DONE . self guaranteed
+     . DONE New Users Guarantee Procedure
+       . DONE Change guarantee workflow
+       . DONE Db update
 
-     DONE . userauth command works
-     DONE . use it by the usermgmt page
-     . finish to implement the user management system
-     . email validation
-     . account expiration
-     . New Users Guarantee Procedure
-       . Change guarantee workflow
-       . Db update
-       . Send email with appropriate headers
+         UserA                 UserB                      Admin
+-------------------------------------------------------------------------
+      guarante UserB
            |
-           V
-         brisk   ->      mail-table
-           |                 |
-           V
-          user               |
-           |
-           V                 |
-      click-link -> check with mail-table
-                             |
-                             V
-                         and update DB
-                      (needs ad-hoc page)
-
-       . Admin panel
-       . Write automatic procmail filter
-         . Procmail configuration
-         . Mail-recipient-side
-         . Server-side
-     . Email validation
+           v
+      Save on mail
+         table,
+      email to UserB
+    (Disabled, MAILED)
+-------------------------------------------------------------------------
+                           Receive email
+                           to check address
+                                 |
+                                 v
+                           Click on link
+                                 |
+                                 v
+                           Check on mail
+                               table,
+                           update user status,
+                           delete mail rec
+                          (Disabled, TOBECHK)
+-------------------------------------------------------------------------
+                                                       admin panel
+                                                       accept user
+                                                            |
+                                                            v
+                                                     send email with
+                                                     password,
+                                                     update user status
+                                                      (Normal, NONE)
+-------------------------------------------------------------------------
+                           Receive email
+                           with password
+-------------------------------------------------------------------------
+
+     DONE . More user info in the list
+     DONE . Manage date to display when a user was required
+     . Email-address expiration check
      . Account expiration
 
+
    DONE - CONTINUE FEATURE
      DONE . replace explicit strings with multilanguage array
      DONE . add a php downloader with filtering on allowed requests
@@ -233,7 +286,6 @@
      - sistema di inserimento nuovi utenti (riversatore da form di inserimento)
 
      STEP 2
-     - aggiornare le funz di gestione db in modo che prevedano anche il flag SUSPEND
      - modifica password   
      - ripristino password