$sql_data .= "# DATE : " . gmdate("d-m-Y H:i:s", $time) . " GMT\n";

$sql_data .= "#\n";

{

case 'sqlite':

$sql_data .= "BEGIN TRANSACTION;\n";

break;

}

{

$sql = 'SELECT RDB$FUNCTION_NAME, RDB$DESCRIPTION

FROM RDB$FUNCTIONS

// Get the table structure

if ($structure)

{

{

case 'mysqli':

case 'mysql4':

}

$sql_data .= $this->get_table_structure($table_name);

}

else

{

}

// Now write the data for the first time. :)

if ($store == true)

{

{

$sql_data .= "\n";

{

case 'mysqli':

}

}

{

case 'sqlite':

case 'postgres':

default:

$tables = array();

{

case 'sqlite':

$sql = "SELECT name

remove_remarks($data);

// SQLite gets improved performance when you shove all of these disk write queries at once :D

{

$db->sql_query($data);

}

else

{

{

case 'firebird':

$delim = ';;';

$sql_data = '';

{

case 'mysqli':

case 'mysql4':

$db->sql_freeresult($result);

// Now insert the data

}

$auth->acl_clear_prefetch();

}

$db->sql_freeresult($result);

{

case 'mysql4':

case 'mysqli':

$db->sql_freeresult($result);

// Now insert the data

$auth->acl_clear_prefetch();

}

// The user has already selected a smilies_pak file

if ($current == 'delete')

{

switch ($mode)

{

break;

case 'db_track':

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

$get_from_time = time() - (6 * 4 * 7 * 24 * 60 * 60);

}

unset($posted);

}

add_log('admin', 'LOG_RESYNC_POST_MARKING');

$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");

{

case 'sqlite':

$sql = "SELECT sql

{

global $db;

{

case 'mysql':

case 'mysql4':

$other_reason_id = (int) $db->sql_fetchfield('reason_id');

$db->sql_freeresult($result);

{

// The ugly one!

case 'mysqli':

// Update Custom Fields

if (sizeof($cp_data))

{

{

case 'oracle':

case 'firebird':

FROM ' . ACL_OPTIONS_TABLE . "

WHERE auth_option LIKE '%\_'";

{

$sql .= " ESCAPE '\\'";

}

FROM ' . ACL_OPTIONS_TABLE . "

WHERE auth_option LIKE '%\_'";

{

$sql .= " ESCAPE '\\'";

}

}

}

$cache->destroy('acl_options');

$this->acl_clear_prefetch();

}

}

if ($clear_prefetch)

{

WHERE role_id = ' . $role_id;

$db->sql_query($sql);

$this->acl_clear_prefetch();

}

$sql = 'SELECT auth_option, auth_option_id

FROM ' . ACL_OPTIONS_TABLE . "

WHERE auth_option LIKE '" . $db->sql_escape(str_replace('_', "\_", $permission_type)) . "%'";

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

if (strpos($auth_options, '_') !== false)

{

$sql_opts = "AND $key LIKE '" . $db->sql_escape(str_replace('_', "\_", $auth_options)) . "'";

}

else

{

if ($is_underline)

{

}

}

}

{

global $db;

{

case 'mssql':

case 'mssql_odbc':

var $sql_error_sql = '';

/**

* Constructor

*/

function dbal()

'normal' => 0,

'total' => 0,

);

}

/**

$ary = array();

foreach ($assoc_ary as $id => $sql_ary)

{

$values = array();

foreach ($sql_ary as $key => $var)

{

return $query;

}

function sql_in_set($field, $array, $negate = false)

{

if (!sizeof($array))

}

/**

* Function for validating values

* @access private

*/

if (!$this->return_on_error)

{

// Show complete SQL error and path to administrators only

// Additionally show complete error on installation or if extended debug mode is enabled

<br />

<p><b>Page generated in ' . round($totaltime, 4) . " seconds with {$this->num_queries['normal']} queries" . (($this->num_queries['cached']) ? " + {$this->num_queries['cached']} " . (($this->num_queries['cached'] == 1) ? 'query' : 'queries') . ' returning data from cache' : '') . '</b></p>

<br /><br />

' . $this->sql_report . '

else

{

$error = $this->sql_error();

}

$this->sql_report .= '</p><br /><br />';

*/

/**

*/

if (!defined('IN_PHPBB'))

{

exit;

}

/**

* Firebird/Interbase Database Abstraction Layer

break;

}

}

}

?> \ No newline at end of file

*/

/**

*/

if (!defined('IN_PHPBB'))

{

exit;

}

/**

* MSSQL Database Abstraction Layer

break;

}

}

}

?> \ No newline at end of file

*/

/**

*/

if (!defined('IN_PHPBB'))

{

exit;

}

/**

* Unified ODBC functions

break;

}

}

}

?> \ No newline at end of file

*/

/**

*/

if (!defined('IN_PHPBB'))

{

exit;

}

/**

* MySQL4 Database Abstraction Layer

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

{

@mysql_query("SET NAMES 'utf8'", $this->db_connect_id);

}

{

}

return $this->db_connect_id;

break;

}

}

}

?> \ No newline at end of file

*/

/**

*/

if (!defined('IN_PHPBB'))

{

exit;

}

/**

* MySQLi Database Abstraction Layer

}

}

?> \ No newline at end of file

*/

/**

*/

if (!defined('IN_PHPBB'))

{

exit;

}

/**

* Oracle Database Abstraction Layer

break;

}

}

}

?> \ No newline at end of file

*/

/**

*/

if (!defined('IN_PHPBB'))

{

exit;

}

/**

* PostgreSQL Database Abstraction Layer

break;

}

}

}

?> \ No newline at end of file

*/

/**

*/

if (!defined('IN_PHPBB'))

{

exit;

}

/**

* Sqlite Database Abstraction Layer

break;

}

}

}

?> \ No newline at end of file

);

}

}

}

else if ($config['load_anon_lastread'] || $user->data['is_registered'])

$reading_sql = " AND s.session_page LIKE '%\_f\_={$f}x%'";

// Specify escape character for MSSQL

{

$reading_sql .= " ESCAPE '\\'";

}

{

$where = (is_array($forum_id)) ? 'AND ' . $db->sql_in_set('t.forum_id', array_map('intval', $forum_id)) : (($forum_id) ? 'AND t.forum_id = ' . (int) $forum_id : '');

{

case 'mysql4':

case 'mysqli':

}

unset($posted);

}

/**

switch ($mode)

{

case 'topic_moved':

{

case 'mysql4':

case 'mysqli':

break;

case 'topic_approved':

{

case 'mysql4':

case 'mysqli':

$cache->destroy('sql', MODERATOR_CACHE_TABLE);

// Clear table

// We add moderators who have forum moderator permissions without an explicit ACL_NEVER setting

$hold_ary = $ug_id_ary = $sql_ary = array();

AND ' . $db->sql_in_set('ug.user_id', $ug_id_ary) . "

AND ug.user_pending = 0

AND o.auth_option LIKE 'm\_%'" .

));

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

}

}

}

/**

$database_size = false;

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

{

case 'mysql':

case 'mysql4':

}

}

if (sizeof($poll['poll_options']) < sizeof($cur_poll_options))

{

);

}

$sql = 'UPDATE ' . USERS_TABLE . '

SET user_new_privmsg = user_new_privmsg + 1, user_unread_privmsg = user_unread_privmsg + 1, user_last_privmsg = ' . time() . '

);

}

// If we are banning we want to logout anyone matching the ban

if (!$ban_exclude)

$add_id_ary = $update_id_ary = array();

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

{

if ($leader && !$row['group_leader'])

{

}

}

$db->sql_freeresult($result);

$db->sql_transaction('begin');

if (sizeof($add_id_ary))

{

}

}

if (sizeof($update_id_ary))

// NOTE: obtain_* function? chaching the table contents?

// For now setting the ttl to 10 minutes

{

case 'mssql':

case 'mssql_odbc':

{

global $db, $user;

{

return $user->lang['FULLTEXT_MYSQL_INCOMPATIBLE_VERSION'];

}

{

global $db;

{

$this->stats = array();

return;

$sql = '';

$sql_array_count = $sql_array;

{

case 'mysql4':

case 'mysqli':

// 3.x does not support SQL_CALC_FOUND_ROWS

case 'sqlite':

$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) . ')';

// no break

default:

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

$sql = (!$sql) ? $db->sql_build_query('SELECT', $sql_array_count) : $sql;

// If the cache was completely empty count the results

if (!$total_results)

{

{

case 'mysql4':

case 'mysqli':

$select = 'SQL_CALC_FOUND_ROWS ' . $select;

}

else

{

{

$sql = 'SELECT COUNT(topic_id) as total_results

FROM (SELECT DISTINCT t.topic_id';

$m_approve_fid_sql

$sql_fora

AND t.topic_id = p.topic_id

}

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

if (sizeof($new_words))

{

}

}

}

// now update the search match table, remove links to removed words and add links to new words

{

global $db;

}

/**

);

}

$updated = true;

}