- my $query = qq|SELECT u.id, cfg.cfg_key, cfg.cfg_value
+ my $query = qq|SELECT u.id, u.login, cfg.cfg_key, cfg.cfg_value
$sth = prepare_query($form, $dbh, $query);
foreach $group (values %{$groups}) {
$sth = prepare_query($form, $dbh, $query);
foreach $group (values %{$groups}) {
do_statement($form, $sth, $query, $group->{id});
while ($row = $sth->fetchrow_hashref()) {
do_statement($form, $sth, $query, $group->{id});
while ($row = $sth->fetchrow_hashref()) {
$query = qq|INSERT INTO auth.user_group (user_id, group_id) VALUES (?, ?)|;
$sth = prepare_query($form, $dbh, $query);
$query = qq|INSERT INTO auth.user_group (user_id, group_id) VALUES (?, ?)|;
$sth = prepare_query($form, $dbh, $query);
do_statement($form, $sth, $query, $user_id, $group->{id});
}
$sth->finish();
do_statement($form, $sth, $query, $user_id, $group->{id});
}
$sth->finish();