return $node->to_sql($hasvals, $not, @joins) if($node->type() eq "boolean");
my $sql;
my $cnt=scalar(@joins)+1;
- if(defined($node->{parents_id}))
- {
- $sql= "(t" . scalar(@joins) . ".parents_id='$node->{parents_id}'";
- $sql .= " AND t" . scalar(@joins) . ".id='" . $node->{id} . "'";
- }
- else
- {
- $sql= "(t" . scalar(@joins) .".parents_id=''";
- $sql .= " AND t" . scalar(@joins) . ".id='" . $node->{id} . "'";
- }
+ $sql .= "t" . scalar(@joins) . ".id='" . $node->{id} . "'";
if($not && !$hasvals)
{
$sql .= " AND fxt" . scalar(@joins) . ".files_id IS NULL";
}
- $sql .= ")";
return ($sql, ());
}
push(@used, $self->right()->used_tags()) if($self->right());
return(grep { defined; } @used);
}
- elsif($self->parents_id())
- {
- return([ $self->parents_id(), $self->id() ]);
- }
return $self->id();
}