Is there a getThreads NOT IN thread.node_id

[Brent W]

I am looking to exclude nodes from the getThreads method but this is the only Condition I see related to nodes. Is there not a way to do this using the getThreads method? I imagine I can work around it by getting a complete list of node ids and then removing the ones that I wish to include and then adding them to this... but that seems like overkill. Am I over looking something?

        if (!empty($conditions['node_id']))
        {
            if (is_array($conditions['node_id']))
            {
                $sqlConditions[] = 'thread.node_id IN (' . $db->quote($conditions['node_id']) . ')';
            }
            else
            {
                $sqlConditions[] = 'thread.node_id = ' . $db->quote($conditions['node_id']);
            }
        }

 

[Chris D]

I think your workaround is a reasonable approach to be honest.

It's also probably less effort than adding additional conditions which can sometimes be difficult to extend.

It will probably cost an additional query to fetch all nose IDs first, but that shouldn't be a big problem.

 

[Brent W]

I think your workaround is a reasonable approach to be honest.

It's also probably less effort than adding additional conditions which can sometimes be difficult to extend.

It will probably cost an additional query to fetch all nose IDs first, but that shouldn't be a big problem.

Thanks Chris. Still navigating my way through XenForo code and wanted to make sure I wasn't overlooking something.

 

[Chris D]

Great auto correct in my post there... nose IDs...

 

[Brent W]

Great auto correct in my post there... nose IDs...

Haha didn't even see that until you pointed it out.

 

[Brent W]

Might not be the prettiest way but it works

            $nodeModel = $this->_getNodeModel();
            $nodes = $nodeModel->getAllNodes();
           
            $cleanNodeIds = '';
            foreach ($nodes AS $node)
            {
                $cleanNodeIds .= $node['node_id'] . ',';
            }
            $cleanNodeIds = substr($cleanNodeIds, 0 , -1);
            $cleanNodeIds = explode(',', $cleanNodeIds);
            $cleanNodeIds = array_diff($cleanNodeIds, $excludeNodes);