function views_handler_argument_comment_user_uid::query in Views (for Drupal 7) 6.2

Same name and namespace in other branches

1. 6.3 modules/comment/views_handler_argument_comment_user_uid.inc \views_handler_argument_comment_user_uid::query()
2. 7.3 modules/comment/views_handler_argument_comment_user_uid.inc \views_handler_argument_comment_user_uid::query()

Set up the query for this argument.

The argument sent may be found at $this->argument.

Overrides views_handler_argument::query

File

modules/comment/views_handler_argument_comment_user_uid.inc, line 36

Class

views_handler_argument_comment_user_uid

Argument handler to accept a user id to check for nodes that user posted or commented on.

Code

function query() {
  $this
    ->ensure_my_table();
  $this->query
    ->add_where(0, "{$this->table_alias}.uid = %d OR ((SELECT COUNT(*) FROM {comments} c WHERE c.uid = %d AND c.nid = {$this->table_alias}.nid) > 0)", $this->argument, $this->argument);
}