test_invalid_link_tree.inc

<?php
class Test_Invalid_Link_Tree
{


    public static function getName()
    {
        return 'Invalid Links on Link Tree Test';

    }//end getName()


    public static function getDescription()
    {
        return 'A test to check for invalid links on the link tree in Matrix';

    }//end getDescription()


    public static function test(&$messages, &$errors)
    {
        $status = TRUE;
        $sql = 'SELECT linkid FROM sq_ast_lnk_tree WHERE linkid NOT IN (SELECT linkid FROM sq_ast_lnk WHERE link_type <= 4)';
        $results = MatrixDAL::executeSqlAssoc($sql);
        if (!empty($results)) {
            $status = FALSE;

            foreach ($results as $index => $result) {
                $results[$index] = $result['linkid'];
            }
            $results = array_unique($results);

            $messages[] = 'There are '.count($results).' invalid link(s) in the link tree on the system';
            foreach ($results as $entry) {
                $errors[] = 'Link #'.$entry.' on the link tree does not exist on the system';
            }//end foreach
        }//end if

        return $status;

    }//end test()

}//end class
?>