1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
|
<?php
/**
* Database configuration file
*
*
* This file is part of queXS
*
* queXS is free software; you can redistribute it and/or modify
* it under the terms of the GNU General Public License as published by
* the Free Software Foundation; either version 2 of the License, or
* (at your option) any later version.
*
* queXS is distributed in the hope that it will be useful,
* but WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
* GNU General Public License for more details.
*
* You should have received a copy of the GNU General Public License
* along with queXS; if not, write to the Free Software
* Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA 02110-1301 USA
*
*
* @author Adam Zammit <adam.zammit@deakin.edu.au>
* @copyright Deakin University 2007,2008
* @package queXS
* @subpackage configuration
* @link http://www.deakin.edu.au/dcarf/ queXS was writen for DCARF - Deakin Computer Assisted Research Facility
* @license http://opensource.org/licenses/gpl-2.0.php The GNU General Public License (GPL) Version 2
*
*/
/**
* Set locale
*/
include_once(dirname(__FILE__).'/lang.inc.php');
/**
* Include ADODB
*/
if (!(include_once(ADODB_PATH . 'adodb.inc.php')))
{
print "<p>ERROR: Please modify config.inc.php for ADODB_PATH to point to your ADODb installation</p>";
}
/**
* Include ADODB session handling functions
*/
//if (!(include_once(ADODB_PATH . 'session/adodb-session2.php')))
//{
// print "<p>ERROR: Please modify config.inc.php for ADODB_PATH to point to your ADODb installation</p>";
//}
define('ADODB_OUTP',"outputDebug");
/**
* Output for debugging
*/
function outputDebug($text,$newline)
{
error_log($text,0);
}
//if PEAR not installed:
set_include_path("."); //TEMP ONLY
set_include_path(get_include_path() . PATH_SEPARATOR . dirname(__FILE__).'/include/pear/');
//global database variable
$db = newADOConnection(DB_TYPE);
$db->Connect(DB_HOST, DB_USER, DB_PASS, DB_NAME);
$db->SetFetchMode(ADODB_FETCH_ASSOC);
if (DEBUG == true) $db->debug = true;
$db->Execute("set names 'utf8'");
//store session in database (see sessions2 table)
//ADOdb_Session::config(DB_TYPE, DB_HOST, DB_USER, DB_PASS, DB_NAME, array('table' => LIME_PREFIX . 'sessions'));
/**
* Get a setting from the database
*
* @param mixed $name The setting name
*
* @return mixed The setting value
* @author Adam Zammit <adam.zammit@acspri.org.au>
* @since 2011-01-17
*/
function get_setting($name)
{
global $db;
$qname = $db->qstr($name);
$sql = "SELECT value
FROM setting
WHERE field LIKE $qname";
$rs = $db->GetRow($sql);
if (!empty($rs))
return unserialize($rs['value']);
}
/**
* Update or create a new setting to store in the database
*
* @param mixed $name
* @param mixed $value An array or string to save
*
* @return bool Successful database insert/update?
* @author Adam Zammit <adam.zammit@acspri.org.au>
* @since 2011-01-17
*/
function set_setting($name,$value)
{
global $db;
$qname = $db->qstr($name);
$qvalue = serialize($value);
$sql = "INSERT INTO setting (setting_id,field,value)
VALUES (NULL,$qname,'$qvalue')
ON DUPLICATE KEY UPDATE value = '$qvalue'";
return $db->Execute($sql);
}
?>
|