public static function singleton(SpotDb $db, array $phpSettings) { if (self::$_instance === null) { self::$_instance = new SpotSettings($db); # maak de array met PHP settings beschikbaar in de klasse self::$_phpSettings = $phpSettings; # haal alle settings op, en prepareer die self::$_dbSettings = $db->getAllSettings(); # en merge de settings met degene die we door krijgen self::$_settings = array_merge(self::$_dbSettings, self::$_phpSettings); # Override NNTP header/comments settings, als er geen aparte NNTP header/comments server is opgegeven, gebruik die van # de NZB server if (empty(self::$_settings['nntp_hdr']['host']) && !empty(self::$_settings['nntp_nzb'])) { self::$_settings['nntp_hdr'] = self::$_settings['nntp_nzb']; } # if # Hetzelfde voor de NNTP upload server if (empty(self::$_settings['nntp_post']['host']) && !empty(self::$_settings['nntp_nzb'])) { self::$_settings['nntp_post'] = self::$_settings['nntp_nzb']; } # if } # if return self::$_instance; }
function users() { include "settings.php"; # Creer het settings object $settings = SpotSettings::singleton($this->_db, $settings); $spotUserUpgrader = new SpotUserUpgrader($this->_db, $settings); $spotUserUpgrader->update(); } # users
public static function singleton(SpotDb $db, array $settings) { if (self::$_instance === null) { self::$_instance = new SpotSettings($db); # haal alle settings op, en prepareer die $dbSettings = $db->getAllSettings(); # en merge de settings met degene die we door krijgen self::$_settings = array_merge($settings, $dbSettings); } # if return self::$_instance; } # singleton
public static function singleton(SpotDb $db, array $phpSettings) { if (self::$_instance === null) { self::$_instance = new SpotSettings($db); # maak de array met PHP settings beschikbaar in de klasse self::$_phpSettings = $phpSettings; # haal alle settings op, en prepareer die self::$_dbSettings = $db->getAllSettings(); # en merge de settings met degene die we door krijgen self::$_settings = array_merge(self::$_phpSettings, self::$_dbSettings); } # if return self::$_instance; }
function createSystem() { global $settings; global $_testInstall_Ok; try { /* * The settings system is used to create a lot of output, * we swallow it all */ ob_start(); /* * Now create the database ... */ $settings['db'] = $_SESSION['spotsettings']['db']; $spotUpgrader = new SpotUpgrader($settings['db'], $settings); $spotUpgrader->database(); /* * and create all the different settings (only the default) ones */ $spotUpgrader->settings(); /* * Create the users */ $spotUpgrader->users(); /* * print all the output as HTML comment for debugging */ $dbCreateOutput = ob_get_contents(); ob_end_clean(); /* * Now it is time to do something with * the information the user has given to us */ $db = new SpotDb($_SESSION['spotsettings']['db']); $db->connect(); /* * add the database settings to the main settings array for now */ $settings['db'] = $_SESSION['spotsettings']['db']; /* and create the database settings */ $spotSettings = SpotSettings::singleton($db, $settings); /* * Update the NNTP settings in the databas */ $spotSettings->set('nntp_nzb', $_SESSION['spotsettings']['nntp']['nzb']); $spotSettings->set('nntp_hdr', $_SESSION['spotsettings']['nntp']['hdr']); $spotSettings->set('nntp_post', $_SESSION['spotsettings']['nntp']['post']); /* * Create the given user */ $spotUserSystem = new SpotUserSystem($db, $spotSettings); $spotUser = $_SESSION['spotsettings']['adminuser']; /* * Create a private/public key pair for this user */ $spotSigning = Services_Signing_Base::newServiceSigning(); $userKey = $spotSigning->createPrivateKey($spotSettings->get('openssl_cnf_path')); $spotUser['publickey'] = $userKey['public']; $spotUser['privatekey'] = $userKey['private']; /* * and actually add the user */ $userId = $spotUserSystem->addUser($spotUser); # Change the administrators' account password to that of this created user $adminUser = $spotUserSystem->getUser(SPOTWEB_ADMIN_USERID); $adminUser['newpassword1'] = $spotUser['newpassword1']; $spotUserSystem->setUserPassword($adminUser); # update the settings with our system type and our admin id $spotSettings->set('custom_admin_userid', $userId); $spotSettings->set('systemtype', $spotUser['systemtype']); # Set the system type $spotUpgrader->resetSystemType($spotUser['systemtype']); /* * Create the necessary database connection information */ $dbConnectionString = ''; switch ($_SESSION['spotsettings']['db']['engine']) { case 'mysql': $dbConnectionString .= "\$dbsettings['engine'] = 'mysql';" . PHP_EOL; $dbConnectionString .= "\$dbsettings['host'] = '" . $_SESSION['spotsettings']['db']['host'] . "';" . PHP_EOL; $dbConnectionString .= "\$dbsettings['dbname'] = '" . $_SESSION['spotsettings']['db']['dbname'] . "';" . PHP_EOL; $dbConnectionString .= "\$dbsettings['user'] = '******'spotsettings']['db']['user'] . "';" . PHP_EOL; $dbConnectionString .= "\$dbsettings['pass'] = '******'spotsettings']['db']['pass'] . "';" . PHP_EOL; break; # mysql # mysql case 'postgresql': $dbConnectionString .= "\$dbsettings['engine'] = 'pdo_pgsql';" . PHP_EOL; $dbConnectionString .= "\$dbsettings['host'] = '" . $_SESSION['spotsettings']['db']['host'] . "';" . PHP_EOL; $dbConnectionString .= "\$dbsettings['dbname'] = '" . $_SESSION['spotsettings']['db']['dbname'] . "';" . PHP_EOL; $dbConnectionString .= "\$dbsettings['user'] = '******'spotsettings']['db']['user'] . "';" . PHP_EOL; $dbConnectionString .= "\$dbsettings['pass'] = '******'spotsettings']['db']['pass'] . "';" . PHP_EOL; break; # postgresql } # switch # Try to create the dbsettings.inc.php file for the user @file_put_contents("dbsettings.inc.php", "<?php" . PHP_EOL . $dbConnectionString); $createdDbSettings = file_exists("dbsettings.inc.php"); ?> <table summary="PHP settings"> <tr> <th colspan='2'> Installation succesful </th> </tr> <tr> <td colspan='2'> Spotweb has been installed succesfuly! </td> </tr> <tr> <td colspan='2'> </td> </tr> <?php if (!$createdDbSettings) { ?> <tr> <td> → </td> <td> You need to create a textfile with the database settings in it. Please copy & paste the below exactly in a file called <i>dbsettings.inc.php</i>. <pre><?php echo "<?php " . PHP_EOL . $dbConnectionString; ?> </pre> </td> </tr> <?php } ?> <tr> <td> → </td> <td> Spotweb retrieves its information from the newsservers, this is called "retrieving" or retrieval of Spots. You need to schedule a retrieval job to run <i>retrieve.php</i> on a regular basis. The first time retrieval is run this can take up to several hours before completion. </td> </tr> </table> <?php echo '<!-- ' . $dbCreateOutput . ' -->'; } catch (Exception $x) { ?> <div id='error'><?php echo $x->getMessage(); ?> <?php echo $x->getTraceAsString(); ?> <br /><br /> </div> <?php } # exception }
} # if try { $db = new SpotDb($settings['db']); $db->connect(); } catch (Exception $x) { die("Unable to connect to database: " . $x->getMessage() . PHP_EOL); } # catch # Controleer dat we niet een schema upgrade verwachten if (!$db->schemaValid()) { die("Database schema is gewijzigd, draai upgrade-db.php aub" . PHP_EOL); } # if # Creer het settings object $settings = SpotSettings::singleton($db, $settings); # Controleer eerst of de settings versie nog wel geldig zijn if (!$settings->settingsValid()) { die("Globale settings zijn gewijzigd, draai upgrade-db.php aub" . PHP_EOL); } # if $req = new SpotReq(); $req->initialize($settings); # We willen alleen uitgevoerd worden door een user die dat mag als # we via de browser aangeroepen worden. Via console halen we altijd # het admin-account op $spotUserSystem = new SpotUserSystem($db, $settings); if (isset($_SERVER['SERVER_PROTOCOL'])) { # Vraag de API key op die de gebruiker opgegeven heeft $apiKey = $req->getDef('apikey', ''); $userSession = $spotUserSystem->verifyApi($apiKey);
function __construct(SpotDb $db, SpotSettings $settings) { $this->_db = $db; $this->_settings = $settings; $this->_nntp_post = new SpotNntp($settings->get('nntp_post')); }
function resetPassword($username) { # Create the settings object $settings = SpotSettings::singleton($this->_db, $this->_phpSettings); $spotUserUpgrader = new SpotUserUpgrader($this->_db, $settings); # retrieve the userid $spotUserUpgrader->resetUserPassword($username, 'spotweb'); }
function __construct(SpotDb $db, SpotSettings $settings, array $user, $ipaddr) { $this->_db = $db; $this->_user = $user; $this->_settings = $settings; $this->_failAudit = $settings->get('auditlevel') == SpotSecurity::spot_secaudit_failure; $this->_allAudit = $settings->get('auditlevel') == SpotSecurity::spot_secaudit_all; if ($this->_failAudit || $this->_allAudit) { $this->_spotAudit = new SpotAudit($db, $settings, $user, $ipaddr); } # if $this->_permissions = $db->getPermissions($user['userid']); }