common::addSetting PHP Method

    function addSetting($name, $value)
    {
        require_once $_SERVER['DOCUMENT_ROOT'] . DIRECTORY_SEPARATOR . "classes" . DIRECTORY_SEPARATOR . "settings.class.php";
        $settings = new settings();
        if ($settings::db_driver == "xml") {
            // XML
            $xmlSettings = simplexml_load_file($_SERVER['DOCUMENT_ROOT'] . DIRECTORY_SEPARATOR . "data" . DIRECTORY_SEPARATOR . "settings.xml");
            $xmlSetting = $xmlSettings->addChild('setting');
            $xmlSetting->addChild('name', $name);
            $xmlSetting->addChild('value', $value);
            file_put_contents($_SERVER['DOCUMENT_ROOT'] . DIRECTORY_SEPARATOR . "data" . DIRECTORY_SEPARATOR . "settings.xml", $xmlSettings->asXML());
        } else {
            // PDO
            $dbh = $this->pdoOpen();
            $sql = "INSERT INTO " . $settings::db_prefix . "settings (name, value) VALUES (:name, :value)";
            $sth = $dbh->prepare($sql);
            $sth->bindParam(':name', $name, PDO::PARAM_STR, 50);
            $sth->bindParam(':value', $value, PDO::PARAM_STR, 100);
            $sth->execute();
            $sth = NULL;
            $dbh = NULL;
        }
    }

function upgrade()
{
    require_once $_SERVER['DOCUMENT_ROOT'] . DIRECTORY_SEPARATOR . "classes" . DIRECTORY_SEPARATOR . "common.class.php";
    require_once $_SERVER['DOCUMENT_ROOT'] . DIRECTORY_SEPARATOR . "classes" . DIRECTORY_SEPARATOR . "settings.class.php";
    $common = new common();
    $settings = new settings();
    try {
        // Change tables containing datetime data to datetime.
        if ($settings::db_driver != "mysql") {
            $dbh = $common->pdoOpen();
            $sql = "ALTER TABLE " . $settings::db_prefix . "aircraft MODIFY firstSeen DATETIME NOT NULL";
            $sth = $dbh->prepare($sql);
            $sth->execute();
            $sth = NULL;
            $sql = "ALTER TABLE adsb_aircraft MODIFY lastSeen DATETIME NOT NULL";
            $sth = $dbh->prepare($sql);
            $sth->execute();
            $sth = NULL;
            $sql = "ALTER TABLE adsb_blogPosts MODIFY date DATETIME NOT NULL";
            $sth = $dbh->prepare($sql);
            $sth->execute();
            $sth = NULL;
            $sql = "ALTER TABLE adsb_flights MODIFY firstSeen DATETIME NOT NULL";
            $sth = $dbh->prepare($sql);
            $sth->execute();
            $sth = NULL;
            $sql = "ALTER TABLE adsb_flights MODIFY firstSeen DATETIME NOT NULL";
            $sth = $dbh->prepare($sql);
            $sth->execute();
            $sth = NULL;
            $sql = "ALTER TABLE adsb_positions MODIFY time DATETIME NOT NULL";
            $sth = $dbh->prepare($sql);
            $sth->execute();
            $sth = NULL;
            $dbh = NULL;
        }
        // Add timezone setting.
        $common->addSetting("timeZone", date_default_timezone_get());
        // update the version and patch settings.
        $common->updateSetting("version", "2.0.1");
        $common->updateSetting("patch", "");
        // The upgrade process completed successfully.
        $results['success'] = TRUE;
        $results['message'] = "Upgrade to v2.0.1 successful.";
        return $results;
    } catch (Exception $e) {
        // Something went wrong during this upgrade process.
        $results['success'] = FALSE;
        $results['message'] = $e->getMessage();
        return $results;
    }
}