original_string: public static function updateBrowserArchives($table)
      {
          // rename old UserSettings archives where no DeviceDetection archives exists
          Db::exec(sprintf("UPDATE IGNORE %s SET name='DevicesDetection_browserVersions' WHERE name = 'UserSettings_browser'", $table));
  
          /*
           * check dates of remaining (non-day) archives with calculated safe date
           * archives before or within that week/month/year of that date will be replaced
           */
          $oldBrowserBlobs = Db::get()->fetchAll(sprintf("SELECT * FROM %s WHERE name = 'UserSettings_browser' AND `period` > 1", $table));
          foreach ($oldBrowserBlobs as $blob) {
  
              // if start date of blob is before calculated date us old usersettings archive instead of already existing DevicesDetection archive
              if (strtotime($blob['date1']) < self::getFirstDayOfArchivedDeviceDetectorData()) {
                  Db::get()->query(sprintf("DELETE FROM %s WHERE idarchive = ? AND name = ?", $table), array($blob['idarchive'], 'DevicesDetection_browserVersions'));
                  Db::get()->query(sprintf("UPDATE %s SET name = ? WHERE idarchive = ? AND name = ?", $table), array('DevicesDetection_browserVersions', $blob['idarchive'], 'UserSettings_browser'));
              }
          }
      }
code: public static function updateBrowserArchives($table)
      {
          // rename old UserSettings archives where no DeviceDetection archives exists
          Db::exec(sprintf("UPDATE IGNORE %s SET name='DevicesDetection_browserVersions' WHERE name = 'UserSettings_browser'", $table));
  
          /*
           * check dates of remaining (non-day) archives with calculated safe date
           * archives before or within that week/month/year of that date will be replaced
           */
          $oldBrowserBlobs = Db::get()->fetchAll(sprintf("SELECT * FROM %s WHERE name = 'UserSettings_browser' AND `period` > 1", $table));
          foreach ($oldBrowserBlobs as $blob) {
  
              // if start date of blob is before calculated date us old usersettings archive instead of already existing DevicesDetection archive
              if (strtotime($blob['date1']) < self::getFirstDayOfArchivedDeviceDetectorData()) {
                  Db::get()->query(sprintf("DELETE FROM %s WHERE idarchive = ? AND name = ?", $table), array($blob['idarchive'], 'DevicesDetection_browserVersions'));
                  Db::get()->query(sprintf("UPDATE %s SET name = ? WHERE idarchive = ? AND name = ?", $table), array('DevicesDetection_browserVersions', $blob['idarchive'], 'UserSettings_browser'));
              }
          }
      }
code_tokens: public static function updateBrowserArchives ( $ table ) { // rename old UserSettings archives where no DeviceDetection archives exists Db :: exec ( sprintf ( "UPDATE IGNORE %s SET name='DevicesDetection_browserVersions' WHERE name = 'UserSettings_browser'" , $ table ) ) ; /*
           * check dates of remaining (non-day) archives with calculated safe date
           * archives before or within that week/month/year of that date will be replaced
           */ $ oldBrowserBlobs = Db :: get ( ) -> fetchAll ( sprintf ( "SELECT * FROM %s WHERE name = 'UserSettings_browser' AND `period` > 1" , $ table ) ) ; foreach ( $ oldBrowserBlobs as $ blob ) { // if start date of blob is before calculated date us old usersettings archive instead of already existing DevicesDetection archive if ( strtotime ( $ blob [ 'date1' ] ) < self :: getFirstDayOfArchivedDeviceDetectorData ( ) ) { Db :: get ( ) -> query ( sprintf ( "DELETE FROM %s WHERE idarchive = ? AND name = ?" , $ table ) , array ( $ blob [ 'idarchive' ] , 'DevicesDetection_browserVersions' ) ) ; Db :: get ( ) -> query ( sprintf ( "UPDATE %s SET name = ? WHERE idarchive = ? AND name = ?" , $ table ) , array ( 'DevicesDetection_browserVersions' , $ blob [ 'idarchive' ] , 'UserSettings_browser' ) ) ; } } }
docstring: Updates all browser archives to new structure
  @param string $table
  @throws \Exception
docstring_tokens: Updates all browser archives to new structure