list-unvisitied-nodes.php


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18

<?php

define('DRUPAL_ROOT', getcwd());

include_once DRUPAL_ROOT . '/includes/bootstrap.inc';
drupal_bootstrap(DRUPAL_BOOTSTRAP_DATABASE);

$query = db_select('og_membership', 'og')
  ->fields('og', array('etid'))
  ->where("og.entity_type = 'node' AND `field_name` = 'blog_ref' AND og.etid NOT IN (SELECT `entity_id` FROM {flagging} WHERE `fid` = :fid AND `uid` = :uid) AND og.etid IN (SELECT `etid` FROM {og_membership} WHERE `gid` = :gid AND `entity_type` = 'node')", array(':fid' => 3, ':uid' => 1, ':gid' => 192));
$result = $query->execute();

$i = 0;
foreach ($result as $record) {
  print $record->etid . PHP_EOL;
  $i++;
}
print $i;