gistfile1.php

<?php


/**
 * Implementation of hook_views_query_substitutions().
 */
function welcom_core_views_query_substitutions($view) {
  $roles = user_roles();
  $subs = array();
  foreach ($roles as $rid => $role) {
    $subs['***ROLE_' . strtoupper(str_replace(array('-',' '), '_', $role)) . '***'] = $rid;
  }
  return $subs;
}