Changeset 1084 for trunk/common

Timestamp:

12/21/09 17:09:07 (2 years ago)

Author:

bogdan2412

Message:

Script to add author tags to tasks.

Tries and determine each author correctly for tasks with multiple ones and groups together different spellings of names (for example Baltescu Paul and Paul-Dan Baltescu) :P

Also makes task_edit controller update author in ia_task to reflect the tags.

File:

• trunk/common/db/tags.php (modified) (2 diffs)

trunk/common/db/tags.php

@@ -25 +25 @@
         $query .= sprintf(" WHERE %s", implode(" AND ", $where));
     }
+    $query .= " ORDER BY name";
     return db_fetch_all($query);
 }
@@ -47 +48 @@
         FROM ia_%s_tags AS obj_tags
         LEFT JOIN ia_tags AS tags ON obj_tags.tag_id = tags.id
-        WHERE %s_id = %s%s%s",
+        WHERE %s_id = %s%s%s
+        ORDER BY tag_name",
         db_escape($obj), db_escape($obj), db_escape($obj),
         db_quote($obj_id), $where_type, $where_parent