#! /usr/bin/php 1', array()) ; $res=db_query_params ('SELECT group_id FROM groups WHERE status != $1', array('P')) ; $arr = util_result_column_to_array($res); for ($i=0; $idefaults); for ($c=0; $ccreateDefault($todo[$c])) { echo $role->getErrorMessage(); db_rollback(); echo "Could Not Create Default Roles: ".$arr[$i]; exit(2); } } $roleid = db_query_params ('SELECT role_id FROM role WHERE group_id=$1 AND role_name=$2', array ($arr[$i], 'Admin')); $admin_roleid=db_result($roleid,0,0); $roleid = db_query_params ('SELECT role_id FROM role WHERE group_id=$1 AND role_name=$2', array ($arr[$i], 'Junior Developer')) ; $junior_roleid=db_result($roleid,0,0); $rrole = db_query_params ('SELECT user_id,admin_flags FROM user_group WHERE group_id=$1', array ($arr[$i])) ; while ($arrole = db_fetch_array($rrole)) { $role_id= (( trim($arrole['admin_flags']) == 'A' ) ? $admin_roleid : $junior_roleid ); $user_id=$arrole['user_id']; $role = new Role($g,$role_id); if (!$role || !is_object($role)) { echo 'Error Getting Role Object'; db_rollback(); exit(3); } elseif ($role->isError()) { echo $role->getErrorMessage(); db_rollback(); exit(4); } if (!$role->setUser($user_id)) { echo $role->getErrorMessage(); db_rollback(); exit(5); } } } db_commit(); echo "SUCCESS\n"; exit(0); // Local Variables: // mode: php // c-file-style: "bsd" // End: ?>