function project_find_alias($query, $table) { // See if {$table} is already in the query. $match = array(); // This regexp handles many cases: // - {node} can be either in FROM or in a JOIN clause // - Query might end immediately after {node} // - Might not have a table alias for {node} $pattern = "@.*(FROM|JOIN)\s+\{$table\}\s*(\S+)?@"; if (preg_match($pattern, $query, $match)) { $keywords = '@(ON|INNER|LEFT|RIGHT|WHERE|ORDER|GROUP|HAVING|LIMIT)@'; if (!isset($match[2]) || preg_match($keywords, $match[2])) { // No alias found, just use "node". $alias = $table; } else { $alias = $match[2]; } } else { $alias = FALSE; } return $alias;}