function test_pairs()
{
$cmp = new StdClass();
$cmp->foo = 'asdf';
DB::execute('create table test2 (foo char(12), bar char(12))');
DB::execute('insert into test2 (foo, bar) values (?, ?)', 'one', 'joe');
DB::execute('insert into test2 (foo, bar) values (?, ?)', 'two', 'sam');
$res = DB::pairs('select * from test2 order by foo asc');
$cmp = array('one' => 'joe', 'two' => 'sam');
$this->assertEquals($cmp, $res);
}
* exposes them.
*/
function admin_head_links_sort($a, $b)
{
if ($a['name'] == $b['name']) {
return 0;
}
return $a['name'] < $b['name'] ? -1 : 1;
}
$page->layout = false;
if (!User::require_admin()) {
return;
}
$tools = array('admin/pages' => array('handler' => 'admin/pages', 'name' => i18n_get('All Pages'), 'class' => false));
$res = glob('apps/*/conf/config.php');
$apps = DB::pairs('select * from apps');
foreach ($res as $file) {
$app = preg_replace('/^apps\\/(.*)\\/conf\\/config\\.php$/i', '\\1', $file);
$appconf = parse_ini_file($file, true);
if (isset($appconf['Admin']['handler'])) {
if (isset($appconf['Admin']['install'])) {
$ver = $this->installed($app, $appconf['Admin']['version']);
if ($ver === true) {
// installed
$tools[$appconf['Admin']['handler']] = $appconf['Admin'];
$tools[$appconf['Admin']['handler']]['class'] = false;
} elseif ($ver === false) {
// not installed
$appconf['Admin']['name'] .= ' (' . i18n_get('click to install') . ')';
$tools[$appconf['Admin']['install']] = $appconf['Admin'];
$tools[$appconf['Admin']['install']]['class'] = 'not-installed';
/**
* Get or set a property for the specified file.
* Can also retrieve an array of a property for a
* list of files if `$file` is an array.
*/
public static function prop($file, $prop, $value = null)
{
if ($value !== null) {
// takes an extra select query, but works cross-database
$res = self::prop($file, $prop);
if ($res === $value) {
return $value;
} elseif (!$res) {
// doesn't exist yet
if (!DB::execute('insert into filemanager_prop (file, prop, value) values (?, ?, ?)', $file, $prop, $value)) {
self::$error = DB::error();
return false;
}
} else {
// already exists, update
if (!DB::execute('update filemanager_prop set value = ? where file = ? and prop = ?', $value, $file, $prop)) {
self::$error = DB::error();
return false;
}
}
return $value;
}
if (is_array($file)) {
// get as a list
$qmarks = array_fill(0, count($file), '?');
$file[] = $prop;
return DB::pairs('select file, value from filemanager_prop where file in(' . join(', ', $qmarks) . ') and prop = ?', $file);
}
// get a single value
return DB::shift('select value from filemanager_prop where file = ? and prop = ?', $file, $prop);
}
/**
* Get a list of tags and the number of posts they've been used on.
*/
public static function tags () {
return \DB::pairs ('select tag_id, count(*) as posts from #prefix#blog_post_tag group by tag_id order by tag_id asc');
}
$spectrogram_palette=query_one("SELECT Value from PumilioSettings WHERE Settings='spectrogram_palette'", $connection);
$default_qf=query_one("SELECT Value from PumilioSettings WHERE Settings='default_qf'", $connection);
$AudioPreviewFormat=query_one("SELECT Value from PumilioSettings WHERE Settings='AudioPreviewFormat'", $connection);
*/
#Get variables from db - new way
# using
# https://github.com/Xeoncross/DByte
// We need this!
require 'db/DB.php';
// Create a new PDO connection to MySQL
$pdo = new PDO("mysql:dbname={$database};host={$host}", "{$user}", "{$password}", array(PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES utf8", PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_OBJ, PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION));
DB::$c = $pdo;
$settings = DB::pairs('SELECT `Settings`, `Value` FROM `PumilioSettings`');
extract($settings, EXTR_OVERWRITE);
#Test settings variables
if ($app_custom_name == "") {
$app_custom_name = "Pumilio";
}
if (!isset($googlemaps_ver)) {
$googlemaps_ver = "";
}
if ($googlemaps_ver == "") {
if ($use_googlemaps == "3") {
$googlemaps_ver = "3";
}
}
if ($app_custom_text == "") {
$app_custom_text = "Pumilio is a free and open source sound archive manager for the visualization and manipulation of sound files.";
