esc($key); $query = "SELECT `value` FROM `setting` WHERE `key` = '" . $escdKey . "'"; $res = $db->query($query); if (count($res) == 0) return false; return $res[0]['value']; } /* * Helper function for setting setting values on the database */ static function setValue($key, $value) { $db = parent::getDbConnection(); $escdKey = $db->esc($key); $escdValue = $db->esc($value); if (self::getValue($key) === false) $query = "INSERT INTO setting (`key`, value) VALUES('" . $escdKey . "', '" . $escdValue . "')"; else $query = "UPDATE setting SET value = '" . $escdValue . "' WHERE `key` = '" . $escdKey . "'"; $db->query($query); } /* * Force or forbid SSL connections? */ static function settSSL($value = null) { $opt = "settSSL"; if ($value != null) self::setValue($opt, $value); $value = self::getValue($opt); if ($value === false) return "neither"; return $value; } /* * Should the app allow the public to signup their own accounts with Scrott? */ static function allowPublicSignup($value = null) { $opt = "allowPublicSignup"; if ($value != null) self::setValue($opt, $value); return self::getValue($opt); } } ?>