<?php
require_once INCLUDE_DIR.'class.migrater.php';

// Replaced in v1.10 for STAFF_DEPT_TABLE
define('GROUP_TABLE', TABLE_PREFIX.'groups');
define('GROUP_DEPT_TABLE', TABLE_PREFIX.'group_dept_access');

class MigrateGroupDeptAccess extends MigrationTask {
    var $description = "Migrate department access for groups from v1.6";

    function run($max_time) {
        $this->setStatus("Migrating department access");

        $res = db_query('SELECT group_id, dept_access FROM '.GROUP_TABLE);
        if(!$res || !db_num_rows($res))
            return false;  //No groups??

        while(list($groupId, $access) = db_fetch_row($res)) {
            $depts=array_filter(array_map('trim', explode(',', $access)));
            foreach($depts as $deptId) {
                $sql='INSERT INTO '.GROUP_DEPT_TABLE
                    .' SET dept_id='.db_input($deptId).', group_id='.db_input($groupId);
                db_query($sql);
            }
        }
    }
}

return 'MigrateGroupDeptAccess';
?>