public function __construct($mysql_location, $name, $extension)
{
$host = $mysql_location->get_host();
if (stripos($host, 'unix(') === 0 && substr($host, -1) === ')') {
$server = ':' . substr($host, 5, -1);
} else {
$server = $host;
if ($mysql_location->get_port() !== null) {
$server .= ':' . $mysql_location->get_port();
}
}
if (strpos($mysql_location->get_userinfo(), ':') !== false) {
list($username, $password) = explode(':', $mysql_location->get_userinfo(), 2);
} else {
$username = $mysql_location->get_userinfo();
$password = null;
}
if ($this->mysql = mysql_connect($server, $username, $password)) {
$this->id = $name . $extension;
$this->options = SimplePie_Misc::parse_str($mysql_location->get_query());
if (!isset($this->options['prefix'][0])) {
$this->options['prefix'][0] = '';
}
if (mysql_select_db(ltrim($mysql_location->get_path(), '/')) && mysql_query('SET NAMES utf8') && ($query = mysql_unbuffered_query('SHOW TABLES'))) {
$db = array();
while ($row = mysql_fetch_row($query)) {
$db[] = $row[0];
}
if (!in_array($this->options['prefix'][0] . 'cache_data', $db)) {
if (!mysql_query('CREATE TABLE `' . $this->options['prefix'][0] . 'cache_data` (`id` TEXT CHARACTER SET utf8 NOT NULL, `items` SMALLINT NOT NULL DEFAULT 0, `data` BLOB NOT NULL, `mtime` INT UNSIGNED NOT NULL, UNIQUE (`id`(125)))')) {
$this->mysql = null;
}
}
if (!in_array($this->options['prefix'][0] . 'items', $db)) {
if (!mysql_query('CREATE TABLE `' . $this->options['prefix'][0] . 'items` (`feed_id` TEXT CHARACTER SET utf8 NOT NULL, `id` TEXT CHARACTER SET utf8 NOT NULL, `data` TEXT CHARACTER SET utf8 NOT NULL, `posted` INT UNSIGNED NOT NULL, INDEX `feed_id` (`feed_id`(125)))')) {
$this->mysql = null;
}
}
} else {
$this->mysql = null;
}
}
}