sql query in/as condition

Add a condition to your rule and select "execute custom PHP code".
Insert something like

  $result = db_query("SELECT * FROM {your_wanted_table}");
  if (db_fetch_array($result)) {
    return TRUE;
  }
  else {
    return FALSE;
  }

@mansspams: Please describe "view as condition" in #508550: Integration with Views module.

apart from using views for that I think having it as a separate condition where user could hand-write SQL would be nice too.

@fago: Would this be an additional condition or could some help text with the PHP condition suffice?

A separate condition, but it should help the user with using the usual placeholders %s %d.

uhm no, that would allow sql injection.. This should only be possible for the placeholders... Thus forcing the user to go with placeholders for dynamic stuff is important.

@fago: If there's no longer a php action in rules, and there's pdo support in core, then this feature probably doesn't make sense. Do you agree?

It would still make sense, but I'm unsure whether this is something that should ship with rules itself.

Closed since no further information has been provided. Reopen if still an issue.