function _next($table, $fields, $where = '1=1') { $sql = "SELECT {$fields} FROM {$table} WHERE {$where}"; logln('Query NEXT', $sql, get_class($this)); $stmt = $this->db->prepare($sql); $stmt->execute(); return $stmt->fetch(PDO::FETCH_ASSOC); }
/** * Update permissions according to what ECM says. */ function main() { $url = ECM_URL . '/api/bindings/' . ECM_EXTERNAL_APP . '/groups'; logln("Fetching data from {$url}..."); $groups = fetch_ecm_data($url); logln("Fetched " . sizeof($groups) . " groups"); foreach ($groups as $g) { $group_id = (int) $g['group']; logln("Updating group {$group_id}..."); $new_members = $g['members']; $old_members = get_group_members($group_id); $members_to_remove = array_diff($old_members, $new_members); $members_to_add = array_diff($new_members, $old_members); update_group($group_id, $members_to_remove, $members_to_add); } }