3 # Copyright (C) 2006-2011 Tobias Leupold <tobias.leupold@web.de>
5 # This file is part of the b8 package
7 # This program is free software; you can redistribute it and/or modify it
8 # under the terms of the GNU Lesser General Public License as published by
9 # the Free Software Foundation in version 2.1 of the License.
11 # This program is distributed in the hope that it will be useful, but
12 # WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY
13 # or FITNESS FOR A PARTICULAR PURPOSE. See the GNU Lesser General Public
14 # License for more details.
16 # You should have received a copy of the GNU Lesser General Public License
17 # along with this program; if not, write to the Free Software Foundation,
18 # Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307, USA.
21 * The MySQL abstraction layer for communicating with the database.
22 * Copyright (C) 2009 Oliver Lillie (aka buggedcom)
23 * Copyright (C) 2010-2011 Tobias Leupold <tobias.leupold@web.de>
28 * @author Oliver Lillie (aka buggedcom) (original PHP 5 port and optimizations)
29 * @author Tobias Leupold
32 class b8_storage_frndc extends b8_storage_base
35 public $config = array(
36 'database' => 'b8_wordlist',
37 'table_name' => 'b8_wordlist',
38 'host' => 'localhost',
44 public $b8_config = array(
45 'degenerator' => NULL,
49 private $_connection = NULL;
50 private $_deletes = array();
51 private $_puts = array();
52 private $_updates = array();
55 const DATABASE_CONNECTION_FAIL = 'DATABASE_CONNECTION_FAIL';
56 const DATABASE_CONNECTION_ERROR = 'DATABASE_CONNECTION_ERROR';
57 const DATABASE_CONNECTION_BAD_RESOURCE = 'DATABASE_CONNECTION_BAD_RESOURCE';
58 const DATABASE_SELECT_ERROR = 'DATABASE_SELECT_ERROR';
59 const DATABASE_TABLE_ACCESS_FAIL = 'DATABASE_TABLE_ACCESS_FAIL';
60 const DATABASE_WRONG_VERSION = 'DATABASE_WRONG_VERSION';
63 * Constructs the database layer.
66 * @param string $config
69 function __construct($config, $degenerator, $today)
72 # Pass some variables of the main b8 config to this class
73 $this->b8_config['degenerator'] = $degenerator;
74 $this->b8_config['today'] = $today;
76 # Validate the config items
78 if(count($config) > 0) {
80 foreach ($config as $name => $value) {
89 $this->config[$name] = (string) $value;
96 if(is_resource($value) === TRUE) {
97 $resource_type = get_resource_type($value);
98 $this->config['connection'] = $resource_type !== 'mysql link' && $resource_type !== 'mysql link persistent' ? FALSE : $value;
102 $this->config['connection'] = FALSE;
117 * Closes the database connection.
123 function __destruct()
126 if($this->_connection === NULL)
129 # Commit any changes before closing
132 # Just close the connection if no link-resource was passed and b8 created it's own connection
133 if($this->config['connection'] === NULL)
134 mysql_close($this->_connection);
136 $this->connected = FALSE;
141 * Connect to the database and do some checks.
144 * @return mixed Returns TRUE on a successful database connection, otherwise returns a constant from b8.
147 public function connect()
152 # Are we already connected?
153 if($this->connected === TRUE)
156 # Are we using an existing passed resource?
157 if($this->config['connection'] === FALSE) {
158 # ... yes we are, but the connection is not a resource, so return an error
159 $this->connected = FALSE;
160 return self::DATABASE_CONNECTION_BAD_RESOURCE;
163 elseif($this->config['connection'] === NULL) {
165 # ... no we aren't so we have to connect.
167 if($this->_connection = mysql_connect($this->config['host'], $this->config['user'], $this->config['pass'])) {
168 if(mysql_select_db($this->config['database'], $this->_connection) === FALSE) {
169 $this->connected = FALSE;
170 return self::DATABASE_SELECT_ERROR . ": " . mysql_error();
174 $this->connected = FALSE;
175 return self::DATABASE_CONNECTION_ERROR;
182 $this->_connection = $this->config['connection'];
186 if($this->_connection === NULL) {
187 $this->connected = FALSE;
188 return self::DATABASE_CONNECTION_FAIL;
191 # Check to see if the wordlist table exists
192 if(mysql_query('DESCRIBE ' . $this->config['table_name'], $this->_connection) === FALSE) {
193 $this->connected = FALSE;
194 return self::DATABASE_TABLE_ACCESS_FAIL . ": " . mysql_error();
197 # Everything is okay and connected
198 $this->connected = TRUE;
200 # Let's see if this is a b8 database and the version is okay
201 return $this->check_database();
206 * Does the actual interaction with the database when fetching data.
209 * @param array $tokens
210 * @return mixed Returns an array of the returned data in the format array(token => data) or an empty array if there was no data.
213 protected function _get_query($tokens, $uid)
216 # Construct the query ...
218 if(count($tokens) > 0) {
222 foreach ($tokens as $token) {
223 $token = dbesc($token);
224 array_push($where, $token);
227 $where = 'token IN ("' . implode('", "', $where) . '")';
231 $token = dbesc($token);
232 $where = 'token = "' . $token . '"';
235 # ... and fetch the data
239 FROM ' . $this->config['table_name'] . '
240 WHERE ' . $where . ' AND uid = ' . $uid );
247 * Store a token to the database.
250 * @param string $token
251 * @param string $count
255 protected function _put($token, $count, $uid) {
256 $token = dbesc($token);
257 $count = dbesc($count);
259 array_push($this->_puts, '("' . $token . '", "' . $count . '", "' . $uid .'")');
263 * Update an existing token.
266 * @param string $token
267 * @param string $count
271 protected function _update($token, $count, $uid)
273 $token = dbesc($token);
274 $count = dbesc($count);
276 array_push($this->_puts, '("' . $token . '", "' . $count . '", "' . $uid .'")');
280 * Remove a token from the database.
283 * @param string $token
287 protected function _del($token, $uid)
289 $token = dbesc($token);
292 array_push($this->_deletes, $token);
296 * Commits any modification queries.
302 protected function _commit($uid)
305 if(count($this->_deletes) > 0) {
308 DELETE FROM ' . $this->config['table_name'] . '
309 WHERE token IN ("' . implode('", "', $this->_deletes) . '") AND uid = ' . $this->uid);
311 $this->_deletes = array();
315 if(count($this->_puts) > 0) {
318 INSERT INTO ' . $this->config['table_name'] . '(token, count, uid)
319 VALUES ' . implode(', ', $this->_puts));
321 $this->_puts = array();
325 if(count($this->_updates) > 0) {
327 // this still needs work
328 $result = q("select * from " . $this->config['table_name'] . ' where token = ');
332 INSERT INTO ' . $this->config['table_name'] . '(token, count, uid)
333 VALUES ' . implode(', ', $this->_updates) . ', ' . $uid . '
334 ON DUPLICATE KEY UPDATE ' . $this->config['table_name'] . '.count = VALUES(count);', $this->_connection);
336 $this->_updates = array();