+sub swap_sortkeys {
+ $main::lxdebug->enter_sub();
+
+ my ($self, $myconfig, $form, $table) = @_;
+
+ # connect to database
+ my $dbh = $form->dbconnect_noauto($myconfig);
+
+ my $query =
+ qq|SELECT
+ (SELECT sortkey FROM $table WHERE id = ?) AS sortkey1,
+ (SELECT sortkey FROM $table WHERE id = ?) AS sortkey2|;
+ my @values = ($form->{"id1"}, $form->{"id2"});
+ my @sortkeys = selectrow_query($form, $dbh, $query, @values);
+ $main::lxdebug->dump(0, "v", \@values);
+ $main::lxdebug->dump(0, "s", \@sortkeys);
+
+ $query = qq|UPDATE $table SET sortkey = ? WHERE id = ?|;
+ my $sth = $dbh->prepare($query);
+ $sth->execute($sortkeys[1], $form->{"id1"}) ||
+ $form->dberror($query . " ($sortkeys[1], $form->{id1})");
+ $sth->execute($sortkeys[0], $form->{"id2"}) ||
+ $form->dberror($query . " ($sortkeys[0], $form->{id2})");
+ $sth->finish();
+
+ $dbh->commit();
+ $dbh->disconnect;
+
+ $main::lxdebug->leave_sub();
+}
+