GEANT/CAT

<?php

/*
 * *****************************************************************************
 * Contributions to this work were made on behalf of the GÉANT project, a 
 * project that has received funding from the European Union’s Framework 
 * Programme 7 under Grant Agreements No. 238875 (GN3) and No. 605243 (GN3plus),
 * Horizon 2020 research and innovation programme under Grant Agreements No. 
 * 691567 (GN4-1) and No. 731122 (GN4-2).
 * On behalf of the aforementioned projects, GEANT Association is the sole owner
 * of the copyright in all material which was developed by a member of the GÉANT
 * project. GÉANT Vereniging (Association) is registered with the Chamber of 
 * Commerce in Amsterdam with registration number 40535155 and operates in the 
 * UK as a branch of GÉANT Vereniging.
 * 
 * Registered office: Hoekenrode 3, 1102BR Amsterdam, The Netherlands. 
 * UK branch address: City House, 126-130 Hills Road, Cambridge CB2 1PQ, UK
 *
 * License: see the web/copyright.inc.php file in the file structure or
 *          <base_url>/copyright.php after deploying the software
 */

/*
 * Run this script after the DB schema update is complete. It converts multilang
 * attributes from "serialize()" to proper DB columns and moves IdP-wide EAP
 * options to profile level.
 */

// treating serialize()

require_once "../config/_config.php";

$dbInstance = \core\DBConnection::handle('INST');


$affectedPayloads = $dbInstance->exec("SELECT profile_id,option_value FROM profile_option WHERE option_name = 'device-specific:geantlink'");
// SELECT -> returns resource, not a boolean
while ($oneAffectedPayload = mysqli_fetch_object(/** @scrutinizer ignore-type */ $affectedPayloads)) {
    $rewrittenPayload = $dbInstance->exec("INSERT IGNORE INTO profile_option (profile_id, option_name, option_value, device_id) VALUES ($oneAffectedPayload->profile_id, 'device-specific:geantlink', '$oneAffectedPayload->option_value', 'w10')");
    if ($rewrittenPayload !== FALSE) {
        echo "[ OK ] Added GeantLink for W10 in profile $oneAffectedPayload->profile_id.";
        continue;
    }
    echo "[WARN] INSERT for W10 GeantLink was not executed, probably already set.";
}