$res = $db->select( 'oathauth_users', [ 'id', 'data' ], [ 'module' => 'totp' ] );

foreach ( $res as $row ) { $data = FormatJson::decode( $row->data, true ); var_dump( $data ); foreach ( $data['keys'] as &$k ) { if ( is_string( $k['scratch_tokens'] ) ) { $k['scratch_tokens'] = explode( ',', $k['scratch_tokens'] ); } } var_dump( $data ); }

/var/www/wiki/mediawiki/core/maintenance/eval.php(78) : eval()'d code:1:
array(1) {
  'keys' =>
  array(1) {
    [0] =>
    array(2) {
      'secret' =>
      string(16) "4CX6VOMYXQ3NFTCB"
      'scratch_tokens' =>
      string(169) "ZJCXGXLUDZAO64CW,3DT2R4C4ARK6W4UG,VNB5Z57OV5L5PIZP,O4DKBII7GXV2YH6C,TXKBYKDAHFM4U5AL,3WNWUG2RTZUK3HNC,T2QT4DBIZM7OYRGK,TUWJQ4HOWMW3PRLG,THIPW37Z5DR3UVTE,K6P475UCJFKYICZR"
    }
  }
}
/var/www/wiki/mediawiki/core/maintenance/eval.php(78) : eval()'d code:1:
array(1) {
  'keys' =>
  array(1) {
    [0] =>
    array(2) {
      'secret' =>
      string(16) "4CX6VOMYXQ3NFTCB"
      'scratch_tokens' =>
      array(10) {
        ...
      }
    }
  }
}