Leser: 13
1 2 3 4 5 6 7 8 9 10 11 12 13
foreach (@zuloeschende_box_ids) # Zum besseren Verständnis für euch umbenannt { my $sth_check = $dbh->prepare("SELECT sort_id FROM $config{'db_prefix'}navibox WHERE box_id=?") or die $dbh->errstr; $sth_check->execute($_) or die $dbh->errstr; my $aktuelle_sort_id = $sth_check->fetchrow_hashref(); $sth_check->finish(); my $sth_box = $dbh->prepare("DELETE FROM $config{'db_prefix'}navibox WHERE box_id=?") or die $dbh->errstr; $sth_box->execute($_) or die $dbh->errstr; $sth_box->finish(); }
1 2 3 4 5 6 7
$dbh->do( "UPDATE $config{'db_prefix'}navibox SET sort_id = sort_id - 1 WHERE sort_id > ?", undef, $aktuelle_sort_id, );
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
foreach (@zuloeschende_box_ids) { my $sth_check = $dbh->prepare("SELECT sort_id FROM $config{'db_prefix'}navibox WHERE box_id=?") or die $dbh->errstr; $sth_check->execute($_) or die $dbh->errstr; my $aktuelle_sort_id = $sth_check->fetchrow_hashref(); $sth_check->finish(); my $sth_box = $dbh->prepare("DELETE FROM $config{'db_prefix'}navibox WHERE box_id=?") or die $dbh->errstr; $sth_box->execute($_) or die $dbh->errstr; $sth_box->finish(); my $sth_check = $dbh->prepare("UPDATE $config{'db_prefix'}navibox SET sort_id = sort_id -1 WHERE sort_id > ?") or die $dbh->errstr; $sth_check->execute($aktuelle_sort_id->{sort_id}) or die $dbh->errstr; $sth_check->finish(); }