[cvs] commit: agora/lib Messages.php agora/lib/Messages split_sql.php sql.php agora/scripts/upgrades 2007-09-22_mdb2.sql 2007-09-23_last_message.sql agora/templates/forums forums.html

[Duck]

duck        2007-09-23 05:03:44 EDT

  Modified files:
    lib                  Messages.php 
    lib/Messages         split_sql.php sql.php 
    templates/forums     forums.html 
  Added files:
    scripts/upgrades     2007-09-22_mdb2.sql 
                         2007-09-23_last_message.sql 
  Log:
  - DB to MDB2. Seems to work. The only problem is the thread list. Seems that MDB2 has problems where parents are empty. I must debug this, as I guess is only an usage problem combined empty to null conversion.
  
  - Start working on moving the last message in the thread data to reduce queries on thread and forums list.
  
  Revision  Changes    Path
  1.267     +194 -223  agora/lib/Messages.php
  1.5       +18 -16    agora/lib/Messages/split_sql.php
  1.7       +14 -11    agora/lib/Messages/sql.php
  1.1       +3 -0      agora/scripts/upgrades/2007-09-22_mdb2.sql (new)
  1.1       +6 -0      agora/scripts/upgrades/2007-09-23_last_message.sql (new)
  1.36      +4 -4      agora/templates/forums/forums.html

  Chora Links:
  http://cvs.horde.org/diff.php/agora/lib/Messages.php?r1=1.266&r2=1.267&ty=u
  http://cvs.horde.org/diff.php/agora/lib/Messages/split_sql.php?r1=1.4&r2=1.5&ty=u
  http://cvs.horde.org/diff.php/agora/lib/Messages/sql.php?r1=1.6&r2=1.7&ty=u
  http://cvs.horde.org/co.php/agora/scripts/upgrades/2007-09-22_mdb2.sql?r=1.1
  http://cvs.horde.org/co.php/agora/scripts/upgrades/2007-09-23_last_message.sql?r=1.1
  http://cvs.horde.org/diff.php/agora/templates/forums/forums.html?r1=1.35&r2=1.36&ty=u