$time = time();

$filename = 'backup_' . $time . '_' . unique_id();

{

case 'mysql':

$extractor = new mysql_extractor($download, $store, $format, $filename, $time);

break;

break;

case 'mssql':

$extractor = new mssql_extractor($download, $store, $format, $filename, $time);

break;

else

{

// We might wanna empty out all that junk :D

{

case 'sqlite':

case 'firebird':

break;

case 'mssql':

$extractor->flush('TRUNCATE TABLE ' . $table_name . "GO\n");

break;

break;

}

{

case 'mysql':

case 'sqlite':

while (($sql = $fgetd($fp, ";\n", $read, $seek, $eof)) !== false)

{

$db->sql_query($sql);

break;

case 'mssql':

while (($sql = $fgetd($fp, "GO\n", $read, $seek, $eof)) !== false)

{

$db->sql_query($sql);

{

$this->write_data_mssql($table_name);

}

{

$this->write_data_odbc($table_name);

}

}

function write_data_mssql($table_name)

}

$db->sql_freeresult($result);

{

case 'mysql':

// Delete everything else and thank MySQL for offering multi-table deletion

$tables_ary = array(

$db->sql_query('DELETE FROM ' . PROFILE_FIELDS_LANG_TABLE . " WHERE field_id = $field_id");

$db->sql_query('DELETE FROM ' . PROFILE_LANG_TABLE . " WHERE field_id = $field_id");

{

$sql = "SELECT sql

FROM sqlite_master

WHERE type = 'table'

$db->sql_query('CREATE TABLE ' . PROFILE_FIELDS_DATA_TABLE . ' (' . $new_table_cols . ');');

$db->sql_query('INSERT INTO ' . PROFILE_FIELDS_DATA_TABLE . ' (' . $columns . ') SELECT ' . $columns . ' FROM ' . PROFILE_FIELDS_DATA_TABLE . '_temp;');

$db->sql_query('DROP TABLE ' . PROFILE_FIELDS_DATA_TABLE . '_temp');

$db->sql_query('ALTER TABLE ' . PROFILE_FIELDS_DATA_TABLE . " DROP COLUMN pf_$field_ident");

}

{

global $db;

{

case 'mysql':

// We are defining the biggest common value, because of the possibility to edit the min/max values of each field.

$sql = 'ALTER TABLE ' . PROFILE_FIELDS_DATA_TABLE . " ADD `$field_ident` ";

break;

case 'mssql':

// We are defining the biggest common value, because of the possibility to edit the min/max values of each field.

$sql = 'ALTER TABLE [' . PROFILE_FIELDS_DATA_TABLE . "] ADD [$field_ident] ";

// Update Custom Fields

if (sizeof($cp_data))

{

{

case 'oracle':

case 'firebird':

case 'sqlite':

case 'mssql':

$right_delim = ']';

$left_delim = '[';

break;

case 'mysql':

$right_delim = $left_delim = '`';

break;

}

// can't truncate a table

var $truncate = false;

/**

* Connect to server

*/

{

$this->db = $db;

}

/**

// can't truncate a table

var $truncate = false;

/**

* Connect to server

*/

*/

class dbal_mssql extends dbal

{

/**

* Connect to server

*/

class dbal_mssql_odbc extends dbal

{

var $last_query_text = '';

/**

* Connect to server

// Supports multiple table deletion

var $multi_table_deletion = true;

/**

* Connect to server

* @access public

// Supports multiple table deletion

var $multi_table_deletion = true;

/**

* Connect to server

*/

{

var $last_query_text = '';

/**

* Connect to server

*/

var $last_query_text = '';

var $pgsql_version;

/**

* Connect to server

*/

// can't truncate a table

var $truncate = false;

/**

* Connect to server

*/

break;

case 'topic_approved':

{

}

break;

$database_size = false;

// This code is heavily influenced by a similar routine in phpMyAdmin 2.2.0

{

case 'mysql':

$sql = 'SELECT VERSION() AS mysql_version';

$result = $db->sql_query($sql);

$row = $db->sql_fetchrow($result);

break;

case 'mssql':

$sql = 'SELECT ((SUM(size) * 8.0) * 1024.0) as dbsize

FROM sysfiles';

$result = $db->sql_query($sql, 7200);

switch ($sql_type)

{

case 'insert':

{

case 'mysql':

$sql = 'VALUES ' . implode(', ', preg_replace('#^(.*?)$#', '(\1)', $sql_subary));

break;

{

global $db, $config;

{

}

// This can get really nasty... therefore we only do the last six months

'AVAILABLE' => true,

'2.0.x' => true,

),

'db2' => array(

'LABEL' => 'IBM DB2',

'SCHEMA' => 'db2',

*/

function get_tables($db)

{

{

case 'mysql':

$sql = 'SHOW TABLES';

break;

break;

case 'mssql':

$sql = "SELECT name

FROM sysobjects

WHERE type='U'";

case 'mssql':

case 'mssql_odbc':

$prefix_length = 90;

break;

{

global $db;

{

$this->stats = array();

return;

$sql = '';

$sql_array_count = $sql_array;

{

$sql_array_count['SELECT'] = ($type == 'posts') ? 'DISTINCT p.post_id' : 'DISTINCT p.topic_id';

$sql = 'SELECT COUNT(' . (($type == 'posts') ? 'post_id' : 'topic_id') . ') as total_results

FROM (' . $db->sql_build_query('SELECT', $sql_array_count) . ')';

}

unset($sql_array_count, $sql);

// If the cache was completely empty count the results

if (!$total_results)

{

{

$select = 'SQL_CALC_FOUND_ROWS ' . $select;

$is_mysql = true;

{

}

else

{

}

}

}

{

global $db;

{

}

}

$src_db->sql_query("SET NAMES 'utf8'");

}

{

}

$cats_added = array();

}

$src_db->sql_freeresult($result);

{

case 'postgres':

$db->sql_query("SELECT SETVAL('" . FORUMS_TABLE . "_seq',(select case when max(forum_id)>0 then max(forum_id)+1 else 1 end from " . FORUMS_TABLE . '));');

break;

case 'mssql':

$db->sql_query('SET IDENTITY_INSERT ' . FORUMS_TABLE . ' OFF');

break;

{

global $db, $src_db, $convert, $table_prefix, $user, $lang;

// create a temporary table in which we store the clean usernames

$drop_sql = 'DROP TABLE ' . $table_prefix . 'userconv';

{

case 'firebird':

$create_sql = 'CREATE TABLE ' . $table_prefix . 'userconv (

)';

break;

$create_sql = 'CREATE TABLE ' . $table_prefix . 'userconv (

user_id mediumint(8) NOT NULL,

username_clean varchar(255) DEFAULT \'\' NOT NULL

);

// Determine mapping database type

$error_ary = array();

$errored = false;

/* Optimize/vacuum analyze the tables where appropriate

// this should be done for each version in future along with

// the version number update

{

case 'mysql':

$sql = 'OPTIMIZE TABLE ' . $table_prefix . 'auth_access, ' . $table_prefix . 'banlist, ' . $table_prefix . 'categories, ' . $table_prefix . 'config, ' . $table_prefix . 'disallow, ' . $table_prefix . 'forum_prune, ' . $table_prefix . 'forums, ' . $table_prefix . 'groups, ' . $table_prefix . 'posts, ' . $table_prefix . 'posts_text, ' . $table_prefix . 'privmsgs, ' . $table_prefix . 'privmsgs_text, ' . $table_prefix . 'ranks, ' . $table_prefix . 'search_results, ' . $table_prefix . 'search_wordlist, ' . $table_prefix . 'search_wordmatch, ' . $table_prefix . 'sessions_keys' . $table_prefix . 'smilies, ' . $table_prefix . 'themes, ' . $table_prefix . 'themes_name, ' . $table_prefix . 'topics, ' . $table_prefix . 'topics_watch, ' . $table_prefix . 'user_group, ' . $table_prefix . 'users, ' . $table_prefix . 'vote_desc, ' . $table_prefix . 'vote_results, ' . $table_prefix . 'vote_voters, ' . $table_prefix . 'words';

_sql($sql, $errored, $error_ary);

break;

));

}

{

}

break;

// Thanks MySQL, for silently converting...

case 'mysql':

if (version_compare($src_db->mysql_version, '4.1.3', '>='))

{

$convert->mysql_convert = true;

$src_db->sql_query("SET NAMES 'binary'");

}

{

}

$get_info = false;

if (!empty($schema['autoincrement']))

{

{

case 'postgres':

$db->sql_query("SELECT SETVAL('" . $schema['target'] . "_seq',(select case when max(" . $schema['autoincrement'] . ")>0 then max(" . $schema['autoincrement'] . ")+1 else 1 end from " . $schema['target'] . '));');

if (!empty($schema['autoincrement']))

{

{

case 'mssql':

$db->sql_query('SET IDENTITY_INSERT ' . $schema['target'] . ' ON');

break;

}

if ($sql_flag === true)

{

{

// If MySQL, we'll wait to have num_wait_rows rows to submit at once

case 'mysql':

$waiting_rows[] = '(' . implode(', ', $insert_values) . ')';

if (sizeof($waiting_rows) >= $convert->num_wait_rows)

if (!empty($schema['autoincrement']))

{

{

case 'mssql':

$db->sql_query('SET IDENTITY_INSERT ' . $schema['target'] . ' OFF');

break;

global $convert;

// Can we use IGNORE with this DBMS?

$insert_query = 'INSERT ' . $sql_ignore . 'INTO ' . $schema['target'] . ' (';

$aliases = array();

{

case 'mssql':

case 'mssql_odbc':

$sql_query = preg_replace('#\# MSSQL IDENTITY (phpbb_[a-z_]+) (ON|OFF) \##s', 'SET IDENTITY_INSERT \1 \2;', $sql_query);

break;

'DLL_GD' => 'GD graphics support [ Visual Confirmation ]',

'DLL_MBSTRING' => 'Multi-byte character support',

'DLL_MSSQL' => 'MSSQL Server 2000+',

'DLL_MSSQL_ODBC' => 'MSSQL Server 2000+ via ODBC',

'DLL_MYSQL' => 'MySQL',

'DLL_MYSQLI' => 'MySQL with MySQLi Extension',