test_user_permissions.inc

<?php
class Test_User_Permissions
{


    public static function getName()
    {
        return 'User Permissions Test';

    }//end getName()


    public static function getDescription()
    {
        return 'A test to check for invalid users on the permission table in Matrix';

    }//end getDescription()


    public static function test(&$messages, &$errors)
    {
        $status = TRUE;
        $count = 0;
        $am = $GLOBALS['SQ_SYSTEM']->am;
        $sql = 'SELECT DISTINCT userid FROM sq_ast_perm ORDER BY userid';
        $GLOBALS['SQ_SYSTEM']->changeDatabaseConnection('db');
        $assetids = MatrixDAL::executeSqlAssoc($sql, 0);

        foreach ($assetids as $assetid) {
            // Does the user exist?
            $asset = $am->getAsset($assetid, '', TRUE);
            if (is_null($asset)) {
                $status=FALSE;
                $count++;
                $errors[] = 'User #'.$assetid.' does not exist';
            } else {
                $am->forgetAsset($asset, TRUE);
            }//end if
            unset($asset);
        }//end foreach

        if (!$status && !empty($count)) {
            $messages[] = 'There are '.$count.' users on the permissions table that do not exist';
        }//end if

        return $status;

    }//end test()

}//end class
?>