- $line .= "BEGIN TRANSACTION;;\n\n";

- $line .= "\n);;\n\n";

- $line .= " {$table_name}_{$key_name} ON {$table_name} (" . implode(', ', $key_data[1]) . ");;\n";

- case 'firebird':

- $line = <<<EOF

-# Trigger for phpbb_forums bitfields

-CREATE TRIGGER t_phpbb_forums_desc_bitf FOR phpbb_forums

-ACTIVE BEFORE INSERT OR UPDATE POSITION 0

-AS

-BEGIN

- IF (NEW.forum_desc_bitfield is null) THEN

- NEW.forum_desc_bitfield = ASCII_CHAR(0);

-END;;

-

-CREATE TRIGGER t_phpbb_forums_rules_bitf FOR phpbb_forums

-ACTIVE BEFORE INSERT OR UPDATE POSITION 0

-AS

-BEGIN

- IF (NEW.forum_rules_bitfield is null) THEN

- NEW.forum_rules_bitfield = ASCII_CHAR(0);

-END;;

-

-# Trigger for phpbb_groups bitfields

-CREATE TRIGGER t_phpbb_groups_bitf FOR phpbb_groups

-ACTIVE BEFORE INSERT OR UPDATE POSITION 0

-AS

-BEGIN

- IF (NEW.group_desc_bitfield is null) THEN

- NEW.group_desc_bitfield = ASCII_CHAR(0);

-END;;

-

-# Trigger for phpbb_posts bitfields

-CREATE TRIGGER t_phpbb_posts_bitf FOR phpbb_posts

-ACTIVE BEFORE INSERT OR UPDATE POSITION 0

-AS

-BEGIN

- IF (NEW.bbcode_bitfield is null) THEN

- NEW.bbcode_bitfield = ASCII_CHAR(0);

-END;;

-

-# Trigger for phpbb_privmsgs bitfields

-CREATE TRIGGER t_phpbb_privmsgs_bitf FOR phpbb_privmsgs

-ACTIVE BEFORE INSERT OR UPDATE POSITION 0

-AS

-BEGIN

- IF (NEW.bbcode_bitfield is null) THEN

- NEW.bbcode_bitfield = ASCII_CHAR(0);

-END;;

-

-# Trigger for phpbb_styles_template bitfields

-CREATE TRIGGER t_phpbb_styles_template_bitf FOR phpbb_styles_template

-ACTIVE BEFORE INSERT OR UPDATE POSITION 0

-AS

-BEGIN

- IF (NEW.bbcode_bitfield is null) THEN

- NEW.bbcode_bitfield = ASCII_CHAR(144) || ASCII_CHAR(216);

-END;;

-

-# Trigger for phpbb_users bitfields

-CREATE TRIGGER t_phpbb_users_bitf FOR phpbb_users

-ACTIVE BEFORE INSERT OR UPDATE POSITION 0

-AS

-BEGIN

- IF (NEW.user_sig_bbcode_bitfield is null) THEN

- NEW.user_sig_bbcode_bitfield = ASCII_CHAR(0);

-END;;

-EOF;

- break;

-

- $line = '

-CREATE TRIGGER "t_phpbb_styles_template"

-AFTER INSERT ON "phpbb_styles_template"

-FOR EACH ROW WHEN NEW.bbcode_bitfield = \'\'

-BEGIN

- UPDATE phpbb_styles_template SET bbcode_bitfield = binary_insert(1) WHERE template_id = NEW.template_id;

-END;;

-

-COMMIT;;';

- 'forum_desc_bitfield' => array('VARBINARY', array('default' => '', 'mssql' => '0x', 'postgres' => '\000')),

- 'forum_rules_bitfield' => array('VARBINARY', array('default' => '', 'mssql' => '0x', 'postgres' => '\000')),

- 'group_desc_bitfield' => array('VARBINARY', array('default' => '', 'mssql' => '0x', 'postgres' => '\000')),

- 'bbcode_bitfield' => array('VARBINARY', array('default' => '', 'mssql' => '0x', 'postgres' => '\000')),

- 'bbcode_bitfield' => array('VARBINARY', array('default' => '', 'mssql' => '0x', 'postgres' => '\000')),

- 'bbcode_bitfield' => array('VARBINARY', array('default' => '', 'mysql' => '0x90D8', 'mssql' => '0x90D8', 'oracle' => '90D8', 'postgres' => '\220\330')),

- 'user_sig_bbcode_bitfield' => array('VARBINARY', array('default' => '', 'mssql' => '0x', 'postgres' => '\000')),

-// Disable browser check for downloads

-$config['browser_check'] = false;

-

- WHERE extension_id IN (' . implode(', ', $extension_id_list) . ')';

- WHERE extension_id IN (' . implode(', ', $extension_id_list) . ')';

- WHERE extension_id IN (" . implode(', ', $extension_list) . ")";

- WHERE post_id IN (' . implode(', ', array_keys($upload_list)) . ')';

- $unip_sql = implode(', ', array_map('intval', $_POST['unip']));

- if ($unip_sql != '')

-

- FROM ' . SITELIST_TABLE . "

- WHERE site_id IN ($unip_sql)";

- $sql = 'DELETE FROM ' . SITELIST_TABLE . "

- WHERE site_id IN ($unip_sql)";

- WHERE user_id IN (" . implode(', ', $user_id_ary) . ')';

- $usernames = implode(', ', preg_replace('#^[\s]*?(.*?)[\s]*?$#e', "\"'\" . \$db->sql_escape('\\1') . \"'\"", explode("\n", $usernames)));

-

- FROM ' . USERS_TABLE . "

- WHERE username IN ($usernames)

- ORDER BY user_lang, user_notify_type"; // , SUBSTRING(user_email FROM INSTR(user_email, '@'))

- AND forum_id NOT IN (' . implode(', ', $moved_ids) . ')';

- AND forum_id NOT IN (' . implode(', ', $moved_ids) . ')';

- WHERE forum_id NOT IN (' . implode(', ', $moved_ids) . ')';

- WHERE forum_id IN (" . implode(', ', $moved_ids) . ')';

- WHERE forum_id IN (' . implode(', ', $forum_ids) . ')';

- $id_list = implode(', ', $ids);

- $db->sql_query("DELETE FROM $table WHERE $field IN ($id_list)");

- if ($deletemark && $marked)

- $where_sql = ' AND log_id IN (' . implode(', ', $sql_in) . ')';

- $mark = (isset($_REQUEST['mark'])) ? implode(', ', request_var('mark', array(0))) : '';

- if ($mark)

- FROM ' . USERS_TABLE . "

- WHERE user_id IN ($mark)";

- $mark_ary = explode(', ', $mark);

- foreach ($mark_ary as $user_id)

- set_config('num_users', $config['num_users'] + sizeof($mark_ary), true);

- $sql = 'DELETE FROM ' . USER_GROUP_TABLE . " WHERE user_id IN ($mark)";

- $sql = 'DELETE FROM ' . USERS_TABLE . " WHERE user_id IN ($mark)";

- FROM ' . USERS_TABLE . "

- WHERE user_id IN ($mark)";

- AND module_id NOT IN (' . implode(', ', $moved_ids) . ')';

- AND module_id NOT IN (' . implode(', ', $moved_ids) . ')';

- AND module_id NOT IN (" . implode(', ', $moved_ids) . ')';

- AND module_id IN (" . implode(', ', $moved_ids) . ')';

- WHERE forum_id IN (' . implode(', ', $forum_id) . ')

- WHERE $sql_id IN (" . implode(', ', $ids) . ')';

- $sql = ($ug_type == 'group') ? 'SELECT group_name as name, group_type FROM ' . GROUPS_TABLE . ' WHERE group_id' : 'SELECT username as name FROM ' . USERS_TABLE . ' WHERE user_id';

- $sql .= ' IN (' . implode(', ', array_map('intval', $ug_id)) . ')';

- WHERE forum_id IN (' . implode(', ', $forum_id) . ')';

- WHERE zebra_id IN (' . implode(', ', array_unique($perms)) . ')

- $sql_forum_id = ($permission_scope == 'global') ? 'AND a.forum_id = 0' : ((sizeof($forum_id)) ? 'AND a.forum_id IN (' . implode(', ', $forum_id) . ')' : 'AND a.forum_id <> 0');

- $sql_forum = (sizeof($forum_id)) ? ' AND forum_id IN (' . implode(', ', $forum_id) . ')' : '';

- WHERE forum_id IN (' . implode(', ', $forum_id) . ')';

- $users = explode("\n", $users);

-

- $where_sql = '';

-

- foreach ($users as $username)

- {

- $where_sql .= (($where_sql != '') ? ', ' : '') . "'" . $db->sql_escape($username) . "'";

- }

- $where_sql = " AND username IN ($where_sql)";

- WHERE topic_id IN (' . implode(', ', array_keys($topic_id_ary)) . ')';

- WHERE topic_id IN (' . implode(', ', $del_topic_ary) . ')';

- WHERE topic_id IN (' . implode(', ', array_keys($topic_id_ary)) . ')';

- $where_sql = ' AND log_id IN (' . implode(', ', $sql_in) . ')';

- WHERE attach_id IN (' . implode(', ', $marked) . ')';

- ' . ((sizeof($id_ary)) ? 'WHERE group_id NOT IN (' . implode(', ', $id_ary) . ')' : '') . '

- WHERE user_id IN (' . implode(',', $ug_id) . ')';

- WHERE user_id IN (' . implode(', ', array_keys($hold_ary)) . ')

- WHERE group_id IN (' . implode(', ', array_keys($hold_ary)) . ')

- AND r.role_id IN (' . implode(', ', array_keys($roles)) . ')';

- WHERE forum_id IN (' . implode(', ', array_keys($hold_ary)) . ')';

- WHERE user_id IN (' . implode(', ', $auth_ary['users']) . ')

- WHERE group_id IN (' . implode(', ', $auth_ary['groups']) . ')

- $ug_id_sql = 'IN (' . implode(', ', array_map('intval', $ug_id)) . ')';

- $forum_sql = 'IN (' . implode(', ', array_map('intval', $forum_id)) . ') ';

- $id_field = $ug_type . '_id';

- WHERE forum_id $forum_sql

- AND $id_field $ug_id_sql

- WHERE forum_id $forum_sql

- AND $id_field $ug_id_sql

- AND auth_role_id IN (" . implode(', ', $role_ids) . ')';

- $where_sql[] = (!is_array($forum_id)) ? 'forum_id = ' . (int) $forum_id : 'forum_id IN (' . implode(', ', array_map('intval', $forum_id)) . ')';

- $where_sql[] = (!is_array($ug_id)) ? $id_field . ' = ' . (int) $ug_id : $id_field . ' IN (' . implode(', ', array_map('intval', $ug_id)) . ')';

- AND rd.role_id IN (' . implode(', ', array_keys($cur_role_auth)) . ')';

- $where_sql[] = 'auth_option_id IN (' . implode(', ', array_map('intval', $option_id_ary)) . ')';

- $sql .= ' WHERE forum_id NOT IN (' . implode(', ', array_keys($this->acl)) . ')';

- $where_sql = ($user_id !== false) ? ' WHERE user_id ' . ((is_array($user_id)) ? ' IN (' . implode(', ', array_map('intval', $user_id)) . ')' : " = $user_id") : '';

- $sql_ug = ($ug_id !== false) ? ((!is_array($ug_id)) ? "AND a.$sql_id = $ug_id" : "AND a.$sql_id IN (" . implode(', ', $ug_id) . ')') : '';

- $sql_forum = ($forum_id !== false) ? ((!is_array($forum_id)) ? "AND a.forum_id = $forum_id" : 'AND a.forum_id IN (' . implode(', ', $forum_id) . ')') : '';

- $sql_user = ($user_id !== false) ? ((!is_array($user_id)) ? "user_id = $user_id" : 'user_id IN (' . implode(', ', $user_id) . ')') : '';

- $sql_forum = ($forum_id !== false) ? ((!is_array($forum_id)) ? "AND a.forum_id = $forum_id" : 'AND a.forum_id IN (' . implode(', ', $forum_id) . ')') : '';

- $sql_opts = 'AND ao.auth_option IN (' . implode(', ', preg_replace('#^\s*(.*)\s*$#e', "\"'\" . \$db->sql_escape('\\1') . \"'\"", $opts)) . ')';

- $sql_user = ($user_id !== false) ? ((!is_array($user_id)) ? "user_id = $user_id" : 'user_id IN (' . implode(', ', $user_id) . ')') : '';

- $sql_forum = ($forum_id !== false) ? ((!is_array($forum_id)) ? "AND a.forum_id = $forum_id" : 'AND a.forum_id IN (' . implode(', ', $forum_id) . ')') : '';

- $sql_opts = 'AND ao.auth_option IN (' . implode(', ', preg_replace('#^\s*(.*)\s*$#e', "\"'\" . \$db->sql_escape('\\1') . \"'\"", $opts)) . ')';

- $sql_group = ($group_id !== false) ? ((!is_array($group_id)) ? "group_id = $group_id" : 'group_id IN (' . implode(', ', $group_id) . ')') : '';

- $sql_forum = ($forum_id !== false) ? ((!is_array($forum_id)) ? "AND a.forum_id = $forum_id" : 'AND a.forum_id IN (' . implode(', ', $forum_id) . ')') : '';

- $sql_opts = 'AND ao.auth_option IN (' . implode(', ', preg_replace('#^\s*(.*)\s*$#e', "\"'\" . \$db->sql_escape('\\1') . \"'\"", $opts)) . ')';

- $sql = '';

- $bbcode_ids = $rowset = array();

- $sql .= (($sql) ? ',' : '') . $bbcode_id;

- if ($sql)

- FROM ' . BBCODES_TABLE . "

- WHERE bbcode_id IN ($sql)";

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

- if (is_null($var))

- {

- $values[] = 'NULL';

- }

- else if (is_string($var))

- {

- $values[] = "'" . $this->sql_escape($var) . "'";

- }

- else if (is_array($var) && is_string($var[0]))

- $values[] = (is_bool($var)) ? intval($var) : $var;

- if (is_null($var))

- {

- $values[] = 'NULL';

- }

- else if (is_string($var))

- {

- if (strpos($key, 'bitfield') === false)

- {

- $values[] = "'" . $this->sql_escape($var) . "'";

- }

- else

- {

- $values[] = $this->sql_escape_binary($var);

- }

- }

- else

- {

- $values[] = (is_bool($var)) ? intval($var) : $var;

- }

- if (is_null($var))

- {

- $values[] = "$key = NULL";

- }

- else if (is_string($var))

- {

- if (strpos($key, 'bitfield') === false)

- {

- $values[] = "$key = '" . $this->sql_escape($var) . "'";

- }

- else

- {

- $values[] = "$key = " . $this->sql_escape_binary($var);

- }

- }

- else

- {

- $values[] = (is_bool($var)) ? "$key = " . intval($var) : "$key = $var";

- }

- $bitfield = (strpos($field, 'bitfield') !== false);

-

- if (is_null($var))

- {

- $values[] = 'NULL';

- }

- else if (is_string($var))

- {

- if (!$bitfield)

- {

- $values[] = "'" . $this->sql_escape($var) . "'";

- }

- else

- {

- $values[] = $this->sql_escape_binary($var);

- }

- }

- else

- {

- $values[] = (is_bool($var)) ? intval($var) : $var;

- }

- return $field . ($negate ? ' NOT IN ' : ' IN ' ) . '(' . implode(',', $values) . ')';

- function sql_escape_binary($msg)

- return "'" . $this->sql_escape($msg) . "'";

- AND forum_id IN (" . implode(', ', $forum_id) . ")";

- AND forum_id IN (" . implode(', ', $forum_id) . ')';

- AND forum_id IN (" . implode(', ', $sql_update) . ')';

- AND topic_id IN (" . implode(', ', $topic_ids) . ")";

- $sql_in[] = "'" . $db->sql_escape($row['session_id']) . "'";

- WHERE session_id NOT IN (' . implode(', ', $sql_in) . ')';

- $exclude_sql = ($exclude_ids !== false && sizeof($exclude_ids)) ? 'WHERE group_id NOT IN (' . implode(', ', array_map('intval', $exclude_ids)) . ')' : '';

- WHERE topic_moved_id IN (' . implode(', ', $topic_ids) . ')

- WHERE topic_id IN (' . implode(', ', $topic_ids) . ')';

- WHERE topic_id IN (" . implode(', ', $topic_ids) . ')';

- WHERE post_id IN (' . implode(', ', $post_ids) . ')';

- WHERE post_id IN (" . implode(', ', $post_ids) . ')';

- WHERE post_msg_id IN (" . implode(', ', $post_ids) . ')';

- FROM ' . TOPICS_TABLE . "

- WHERE $where_type " . ((!is_array($where_ids)) ? "= $where_ids" : 'IN (' . implode(', ', $where_ids) . ')');

- $sql_where = ' IN (' . implode(', ', $topic_ids) . ')';

-

- WHERE topic_id $sql_where";

- WHERE topic_moved_id' . $sql_where;

- if (empty($where_ids))

- FROM ' . POSTS_TABLE . "

- WHERE $where_type " . ((!is_array($where_ids)) ? '= ' . (int) $where_ids : 'IN (' . implode(', ', array_map('intval', $where_ids)) . ')');

- $sql_where = implode(', ', $post_ids);

-

- WHERE post_id IN ($sql_where)";

- WHERE ' . $sql_id . ' IN (' . implode(', ', $ids) . ')';

- WHERE post_msg_id IN (' . implode(', ', $ids) . ')

- WHERE ' . $sql_id . ' IN (' . implode(', ', $ids) . ')';

- WHERE post_id IN (' . implode(', ', $post_ids) . ')';

- WHERE post_msg_id IN (' . implode(', ', $post_ids) . ')

- WHERE post_id IN (' . implode(', ', $unset_ids) . ')';

- WHERE post_msg_id IN (' . implode(', ', $post_ids) . ')

- WHERE msg_id IN (' . implode(', ', $unset_ids) . ')';

- WHERE topic_id IN (' . implode(', ', $topic_ids) . ')';

- WHERE topic_id IN (' . implode(', ', $topic_ids) . ')';

- WHERE topic_id IN (' . implode(', ', $unset_ids) . ')';

- $where = (is_array($forum_id)) ? 'AND t.forum_id IN (' . implode(', ', array_map('intval', $forum_id)) . ')' : (($forum_id) ? 'AND t.forum_id = ' . (int) $forum_id : '');

- WHERE topic_id IN (' . implode(',', $topic_ids) . ')';

- WHERE topic_id IN (' . implode(', ', $topic_ids) . ')';

- WHERE topic_id IN (' . implode(', ', $topic_ids) . ')

- $where_sql = 'WHERE ' . $mode{0} . ".$where_type IN (" . implode(', ', $where_ids) . ')';

- $where_sql = 'WHERE ' . $mode{0} . ".$where_type IN (" . implode(', ', $where_ids) . ')';

- WHERE topic_id IN (' . implode(', ', $topic_id_ary) . ')';

- WHERE topic_id IN (' . implode(', ', $topic_ids) . ')';

- WHERE post_id IN (' . implode(', ', $post_ids) . ')

- WHERE post_id IN (' . implode(', ', $post_ids) . ')';

- WHERE topic_id IN (' . implode(', ', $topic_ids) . ')';

- WHERE post_msg_id IN (' . implode(', ', $post_ids) . ')

- WHERE post_id IN (' . implode(', ', $post_ids) . ')';

- WHERE topic_id IN (' . implode(', ', $topic_ids) . ')';

- WHERE forum_id IN (' . implode(', ', $forum_ids) . ')

- WHERE forum_id IN (' . implode(', ', $forum_ids) . ')

- WHERE p.post_id IN (' . implode(', ', $post_ids) . ')

- $topic_data = $post_ids = $approved_unapproved_ids = $resync_forums = $delete_topics = $delete_posts = array();

- $sql = 'SELECT t.topic_id, t.forum_id, t.topic_approved, ' . (($sync_extra) ? 't.topic_attachment, t.topic_reported, ' : '') . 't.topic_poster, t.topic_time, t.topic_replies, t.topic_replies_real, t.topic_first_post_id, t.topic_first_poster_name, t.topic_last_post_id, t.topic_last_poster_id, t.topic_last_poster_name, t.topic_last_post_time

- WHERE p.post_id IN (' . implode(',', $post_ids) . ')

- WHERE topic_id IN (' . implode(', ', $approved_unapproved_ids) . ')';

- $sql_forum = (is_array($forum_id)) ? ' IN (' . implode(', ', array_map('intval', $forum_id)) . ')' : ' = ' . (int) $forum_id;

- FROM ' . TOPICS_TABLE . "

- WHERE forum_id $sql_forum

- FROM ' . TOPICS_TABLE . "

- WHERE forum_id $sql_forum

- AND ug.user_id IN (' . implode(', ', $ug_id_ary) . ")

- WHERE user_id IN (' . implode(', ', array_keys($hold_ary)) . ')';

- WHERE group_id IN (' . implode(', ', $ug_id_ary) . ')';

- $sql_forum = 'AND l.forum_id IN (' . implode(', ', array_map('intval', $forum_id)) . ')';

- WHERE topic_id IN (' . implode(', ', array_map('intval', $topic_id_list)) . ')';

- $sql_where = ' IN (' . implode(', ', $warning_list) . ')';

- $sql = 'DELETE FROM ' . WARNINGS_TABLE . "

- WHERE warning_id $sql_where";

- if ($forum_id !== false && is_array($forum_id))

- $forum_sql = 'AND forum_id IN (' . implode(', ', $forum_id) . ')';

- }

- else

- {

- $forum_sql = ($forum_id !== false) ? 'AND forum_id = ' . $forum_id : '';

- $post_count_sql = (sizeof($forum_ary)) ? 'AND f.forum_id NOT IN (' . implode(', ', $forum_ary) . ')' : '';

- FROM ' . POSTS_TABLE . "

- AND {$type}_id IN (" . implode(', ', $ids) . ")

- AND p.post_id IN (' . implode(', ', $last_post_ids) . ')';

- WHERE topic_id IN (' . implode(',', array_unique($topic_ids)) . ')';

- AND user_id IN (" . implode(', ', $update_notification['topic']) . ")";

- AND user_id IN (" . implode(', ', $update_notification['forum']) . ")";

- AND user_id IN (" . implode(', ', $delete_ids['topic']) . ")";

- AND user_id IN (" . implode(', ', $delete_ids['forum']) . ")";

- WHERE user_id IN (' . implode(', ', $user_ids) . ')

- WHERE msg_id IN (' . implode(', ', $unread_ids) . ")

- AND msg_id IN (" . implode(', ', $important_ids) . ')';

- WHERE folder_id IN (' . implode(', ', array_keys($move_into_folder)) . (($full_folder_action >= 0) ? ', ' . $full_folder_action : '') . ")

- AND msg_id IN (" . implode(', ', $msg_ary) . ')';

- AND msg_id IN (" . implode(', ', $msg_ary) . ')';

- AND msg_id IN (' . implode(', ', array_keys($action_ary)) . ')';

- AND msg_id IN (" . implode(', ', $move_msg_ids) . ')';

- AND msg_id IN (" . implode(', ', $msg_ids) . ')';

- WHERE msg_id IN (' . implode(', ', array_map('intval', $msg_ids)) . ")

- AND msg_id IN (' . implode(', ', array_keys($delete_rows)) . ')';

- WHERE msg_id IN (" . implode(', ', array_keys($delete_rows)) . ')';

- WHERE msg_id IN (' . implode(', ', array_keys($delete_rows)) . ')';

- AND msg_id IN (" . implode(', ', array_keys($delete_rows)) . ')';

- WHERE msg_id IN (' . implode(', ', array_keys($delete_rows)) . ')';

- $delete_ids = implode(', ', array_keys($delete_rows));

- if ($delete_ids)

- WHERE msg_id IN (' . $delete_ids . ')';

- WHERE user_id IN (' . implode(', ', $u) . ')

- WHERE group_id IN (' . implode(', ', $g) . ')';

- WHERE g.group_id IN (' . implode(', ', $g) . ')

- WHERE group_id IN (' . implode(', ', array_keys($data['address_list']['g'])) . ')

- WHERE user_id IN (' . implode(', ', array_keys($recipients)) . ')';

- WHERE ban_userid IN (' . implode(', ', array_map('intval', array_keys($recipients))) . ')

- $recipient_list = implode(', ', array_map('intval', array_keys($recipients)));

-

- FROM ' . USERS_TABLE . "

- WHERE user_id IN ($recipient_list)";

- if (!implode(', ', $user_id))

- WHERE user_id IN (' . implode(', ', array_map('intval', $user_id)) . ')';

- if (strncmp($key, '_', 1) === 0)

- {

- $sql_not_in[] = "'" . $db->sql_escape(substr($key, 1)) . "'";

- }

- else

- {

- $sql_not_in[] = "'" . $db->sql_escape($key) . "'";

- }

- ' . ((sizeof($sql_not_in)) ? ' AND f.field_ident NOT IN (' . implode(', ', $sql_not_in) . ')' : '') . '

- $sql_in = ($which_ary == 'user_id_ary') ? array_map('intval', $$which_ary) : preg_replace('#^\s*(.*)\s*$#e', "\"'\" . \$db->sql_escape('\\1') . \"'\"", $$which_ary);

- FROM ' . USERS_TABLE . "

- WHERE $sql_where IN (" . implode(', ', $sql_in) . ')';

- WHERE topic_id IN (' . implode(', ', array_keys($topic_id_ary)) . ')';

- WHERE topic_id IN (' . implode(', ', $del_topic_ary) . ')';

- $sql_usernames[] = "'" . $db->sql_escape($username) . "'";

- $sql_usernames = implode(', ', $sql_usernames);

- if (empty($sql_usernames))

- WHERE username IN (' . $sql_usernames . ')';

- $sql .= ' AND user_id NOT IN (' . implode(', ', array_keys($founder)) . ')';

- $sql_where = (in_array('*', $banlist_ary)) ? '' : 'WHERE session_user_id IN (' . implode(', ', $banlist_ary) . ')';

- $banlist_ary_sql = array();

-

- foreach ($banlist_ary as $ban_entry)

- {

- $banlist_ary_sql[] = "'" . $db->sql_escape($ban_entry) . "'";

- }

- $sql_where = 'WHERE session_ip IN (' . implode(', ', $banlist_ary_sql) . ')';

- $banlist_ary_sql[] = "'" . $db->sql_escape(str_replace('*', '%', $ban_entry)) . "'";

- WHERE user_email IN (' . implode(', ', $banlist_ary_sql) . ')';

- $sql_where = 'WHERE session_user_id IN (' . implode(', ', $sql_in) . ")";

- $sql = 'DELETE FROM ' . SESSIONS_KEYS_TABLE . ' ' . ((in_array('*', $banlist_ary)) ? '' : 'WHERE user_id IN (' . implode(', ', $banlist_ary) . ')');

- $unban_sql = implode(', ', array_map('intval', $ban));

- if ($unban_sql)

- FROM ' . USERS_TABLE . ' u, ' . BANLIST_TABLE . " b

- WHERE b.ban_id IN ($unban_sql)

- AND u.user_id = b.ban_userid";

- FROM ' . BANLIST_TABLE . "

- WHERE ban_id IN ($unban_sql)";

- FROM ' . BANLIST_TABLE . "

- WHERE ban_id IN ($unban_sql)";

- $sql = 'DELETE FROM ' . BANLIST_TABLE . "

- WHERE ban_id IN ($unban_sql)";

- WHERE user_id IN (' . implode(', ', $user_id_ary) . ")

- WHERE user_id IN (' . implode(', ', $update_id_ary) . ")

- WHERE group_name IN (' . implode(', ', preg_replace('#^(.*)$#', "'\\1'", $group_order)) . ')';

- WHERE user_id IN (' . implode(', ', $user_id_ary) . ")";

- WHERE ug.user_id IN (' . implode(', ', $user_id_ary) . ")

- WHERE user_id IN (' . implode(', ', $sql_where_ary[$gid]) . ')

- WHERE user_id IN (' . implode(', ', $sql_where_ary[$gid]) . ')';

- AND user_id IN (" . implode(', ', $user_id_ary) . ')';

- AND user_id IN (" . implode(', ', $user_id_ary) . ')';

- AND ug.user_id IN (' . implode(', ', $user_id_ary) . ')';

- AND user_id IN (" . implode(', ', $user_id_ary) . ')';

- WHERE user_id IN (' . implode(', ', $user_id_ary) . ')

- WHERE user_id IN (' . implode(', ', $user_id_ary) . ')';

- if ($group_id_ary && $user_id_ary)

- {

- $sql .= " ug.group_id " . ((is_array($group_id_ary)) ? ' IN (' . implode(', ', $group_id_ary) . ')' : " = $group_id_ary") . "

- AND ug.user_id " . ((is_array($user_id_ary)) ? ' IN (' . implode(', ', $user_id_ary) . ')' : " = $user_id_ary");

- }

- else if ($group_id_ary)

- $sql .= " ug.group_id " . ((is_array($group_id_ary)) ? ' IN (' . implode(', ', $group_id_ary) . ')' : " = $group_id_ary");

- else if ($user_id_ary)

- $sql .= " ug.user_id " . ((is_array($user_id_ary)) ? ' IN (' . implode(', ', $user_id_ary) . ')' : " = $user_id_ary");

- WHERE topic_id IN (' . implode(', ', $topic_ids) . ')';

- WHERE forum_id IN (' . implode(', ', $forum_list) . ')';

- WHERE p.post_id IN (' . implode(', ', $post_list) . ')

- $where_sql = ' AND log_id IN (' . implode(', ', $sql_in) . ')';

- SET $set_id = " . (($action == 'lock' || $action == 'lock_post') ? ITEM_LOCKED : ITEM_UNLOCKED) . "

- WHERE $sql_id IN (" . implode(', ', $ids) . ")";

- WHERE topic_id IN (" . implode(', ', $topic_ids) . ')

- WHERE topic_id IN (" . implode(', ', $topic_ids) . ')

- WHERE topic_id IN (" . implode(', ', $topic_ids) . ')

- WHERE topic_id IN (' . implode(', ', $topic_ids) . ')

- WHERE topic_moved_id IN (' . implode(', ', $topic_ids) . ')';

- WHERE topic_id IN (" . implode(', ', $topic_ids) . ')';

- WHERE topic_id IN (' . implode(', ', $topic_ids) . ')';

- WHERE post_id IN (' . implode(', ', $post_ids) . ')';

- WHERE topic_id IN (' . implode(', ', $topic_id_list) . ')';

- $where_sql = ' AND log_id IN (' . implode(', ', $sql_in) . ')';

- FROM ' . POSTS_TABLE . ' p, ' . TOPICS_TABLE . ' t, ' . USERS_TABLE . " u

- WHERE p.post_id IN (" . implode(', ', $post_ids) . ")

- AND u.user_id = p.poster_id";

- WHERE forum_id IN (' . implode(',', $forum_names) . ')';

- WHERE topic_id IN (' . implode(', ', $topic_approve_sql) . ')';

- WHERE post_id IN (' . implode(', ', $post_approve_sql) . ')';

- $forum_list = array();

- if (!($forum_list = implode(', ', $forum_list)))

- FROM ' . FORUMS_TABLE . "

- WHERE forum_id IN ($forum_list)";

- $forum_list = $forum_id;

- $forum_list .= ', 0';

- FROM ' . POSTS_TABLE . ' p, ' . TOPICS_TABLE . ' t, ' . REPORTS_TABLE . ' r ' . (($sort_order_sql[0] == 'u') ? ', ' . USERS_TABLE . ' u' : '') . (($sort_order_sql[0] == 'r') ? ', ' . USERS_TABLE . ' ru' : '') . "

- WHERE p.forum_id IN ($forum_list)

- FROM ' . REPORTS_TABLE . ' r, ' . POSTS_TABLE . ' p, ' . TOPICS_TABLE . ' t, ' . USERS_TABLE . ' u, ' . USERS_TABLE . " ru

- WHERE r.report_id IN (" . implode(', ', $report_ids) . ")

- AND ru.user_id = r.user_id";

- WHERE r.post_id IN (' . implode(',', array_keys($post_info)) . ')

- WHERE topic_id IN (' . implode(', ', $close_report_topics) . ')

- AND post_id NOT IN (' . implode(', ', $close_report_posts) . ')';

- WHERE post_id IN (' . implode(', ', $close_report_posts) . ')';

- WHERE post_id IN (' . implode(', ', $close_report_posts) . ')';

- WHERE post_id IN (' . implode(', ', $close_report_posts) . ')';

- WHERE topic_id IN (' . implode(', ', $close_report_topics) . ')';

- $code = trim($code);

- if (!preg_match('/^\<\?.*?\?\>/is', $code))

- $str_from[] = '<span class="syntaxdefault">&lt;?php ';

- WHERE attach_id IN (' . implode(', ', array_keys($attach_ids)) . ')

- FROM ' . ATTACHMENTS_TABLE . "

- WHERE LOWER(physical_filename) IN ('" . implode("', '", array_map('strtolower', $filenames)) . "')";

- $m_approve_fid_sql = ' AND (p.post_approved = 1 OR p.forum_id NOT IN (' . implode(', ', $m_approve_fid_ary) . '))';

- $sql_author = (sizeof($author_ary) == 1) ? ' = ' . $author_ary[0] : 'IN (' . implode(',', $author_ary) . ')';

- $sql_where_options .= (sizeof($ex_fid_ary)) ? ' AND p.forum_id NOT IN (' . implode(',', $ex_fid_ary) . ')' : '';

- $sql_author = 'p.poster_id ' . ((sizeof($author_ary) > 1) ? 'IN (' . implode(',', $author_ary) . ')' : '= ' . $author_ary[0]);

- $sql_fora = (sizeof($ex_fid_ary)) ? ' AND p.forum_id NOT IN (' . implode(',', $ex_fid_ary) . ')' : '';

- $m_approve_fid_sql = ' AND (p.post_approved = 1 OR p.forum_id IN (' . implode($m_approve_fid_ary) . '))';

- // we can match exact words with one IN

- foreach ($exact_words as $i => $word)

- {

- $exact_words[$i] = '\'' . $db->sql_escape($word) . '\'';

- }

-

- WHERE word_text ' . ((sizeof($exact_words) > 1) ? 'IN (' . implode(', ', $exact_words) . ')' : '= ' . $exact_words[0]);

- $sql_where[] = (sizeof($word_ids) > 1) ? "m$m_num.word_id IN (" . implode(', ', $word_ids) . ')' : "m$m_num.word_id = {$word_ids[0]}";

- 'ON' => ((sizeof($this->must_not_contain_ids) > 1) ? "m$m_num.word_id IN (" . implode(', ', $this->must_not_contain_ids) . ')' : "m$m_num.word_id = " . $this->must_not_contain_ids[0]) . (($title_match) ? "m$m_num.$title_match" : '') . " AND m$m_num.post_id = m0.post_id"

- $sql_where[] = '(p.post_approved = 1 OR p.forum_id ' . ((sizeof($m_approve_fid_ary) == 1) ? '= ' . $m_approve_fid_ary[0] : 'NOT IN (' . implode(', ', $m_approve_fid_ary) . ')' ) . ')';

- $sql_where[] = 'p.poster_id ' . ((sizeof($author_ary) == 1) ? ' = ' . $author_ary[0] : 'IN (' . implode(',', $author_ary) . ')');

- $sql_where[] = 'p.forum_id ' . ((sizeof($ex_fid_ary) == 1) ? '<> ' . $ex_fid_ary[0] : 'NOT IN (' . implode(',', $ex_fid_ary) . ')');

- $sql_author = 'p.poster_id ' . ((sizeof($author_ary) > 1) ? 'IN (' . implode(',', $author_ary) . ')' : '= ' . $author_ary[0]);

- $sql_fora = (sizeof($ex_fid_ary)) ? ' AND p.forum_id ' . ((sizeof($ex_fid_ary) == 1) ? '<> ' . $ex_fid_ary[0] : 'NOT IN (' . implode(',', $ex_fid_ary) . ')') : '';

- $m_approve_fid_sql = ' AND (p.post_approved = 1 OR p.forum_id ' . ((sizeof($m_approve_fid_ary) == 1) ? '= ' . $m_approve_fid_ary[0] : 'IN (' . implode($m_approve_fid_ary) . ')' ) . ')';

- FROM ' . SEARCH_WORDLIST_TABLE . "

- WHERE word_text IN ('" . implode("','", array_map(array(&$db, 'sql_escape'), $unique_add_words)) . "')";

- $new_words = array_map(array(&$db, 'sql_escape'), array_diff($unique_add_words, array_keys($word_ids)));

- WHERE word_id IN (' . implode(', ', $sql_in) . ')

- FROM " . SEARCH_WORDLIST_TABLE . "

- WHERE word_text IN ('" . implode("','", array_map(array(&$db, 'sql_escape'), $word_ary)) . "')";

- $sql = 'DELETE FROM ' . SEARCH_WORDMATCH_TABLE . '

- WHERE post_id IN (' . implode(', ', $post_ids) . ')';

- $db->sql_query($sql);

-

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

- $sql_in = array();

- do

- {

- $sql_in[] = $row['word_id'];

- }

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

-

- $sql_in = implode(', ', $sql_in);

- FROM ' . SEARCH_WORDLIST_TABLE . "

- WHERE word_id IN ($sql_in)";

- $sql = 'UPDATE ' . SEARCH_WORDLIST_TABLE . "

- WHERE word_id IN ($sql_in)";

- $sql = 'DELETE FROM ' . SEARCH_WORDMATCH_TABLE . "

- WHERE word_id IN ($sql_in)";

-

- unset($sql_in);

- $db->sql_freeresult($result);

- function session_begin($update_session_page = true, $loose_validation = false)

- $del_user_id = '';

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

- do

- if ($row['session_user_id'] != ANONYMOUS)

- {

- $sql = 'UPDATE ' . USERS_TABLE . '

- SET user_lastvisit = ' . $row['recent_time'] . ", user_lastpage = '" . $db->sql_escape($row['session_page']) . "'

- WHERE user_id = " . $row['session_user_id'];

- $db->sql_query($sql);

- }

-

- $del_user_id .= (($del_user_id != '') ? ', ' : '') . (int) $row['session_user_id'];

- $del_sessions++;

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

- if ($del_user_id)

- $sql = 'DELETE FROM ' . SESSIONS_TABLE . "

- WHERE session_user_id IN ($del_user_id)

- AND session_time < " . ($this->time_now - $config['session_length']);

- WHERE group_id NOT IN (' . implode(', ', $group_id_ary) . ")

- $sql .= ' AND forum_id NOT IN ( ' . implode(', ', $forum_ary) . ')';

- $forums = (isset($_POST['f'])) ? implode(', ', array_map('intval', array_keys($_POST['f']))) : false;

- $topics = (isset($_POST['t'])) ? implode(', ', array_map('intval', array_keys($_POST['t']))) : false;

- if ($forums || $topics)

- if ($forums)

- $sql = 'DELETE FROM ' . FORUMS_WATCH_TABLE . "

- WHERE forum_id IN ($forums)

- AND user_id = " . $user->data['user_id'];

- if ($topics)

- $sql = 'DELETE FROM ' . TOPICS_WATCH_TABLE . "

- WHERE topic_id IN ($topics)

- AND user_id = " . $user->data['user_id'];

- AND topic_id IN (' . implode(', ', $topics) . ')';

- $drafts = (isset($_POST['d'])) ? implode(', ', array_map('intval', array_keys($_POST['d']))) : '';

- if ($drafts)

- $sql = 'DELETE FROM ' . DRAFTS_TABLE . "

- WHERE draft_id IN ($drafts)

- AND user_id = " .$user->data['user_id'];

- WHERE topic_id IN (' . implode(',', array_unique($topic_ids)) . ')';

- WHERE user_id IN (' . implode(', ', array_map('intval', array_keys($address_list['u']))) . ')';

- AND group_id IN (' . implode(', ', array_map('intval', array_keys($address_list['g']))) . ')';

- WHERE user_id IN (' . implode(', ', $user_id_ary) . ')

- WHERE user_id';

- WHERE group_id';

- $sql .= ' IN (' . implode(', ', array_map('intval', array_keys($recipient_list[$ug_type]))) . ')';

- WHERE user_id';

- WHERE group_id';

- $sql .= ' IN (' . implode(', ', array_map('intval', array_keys($address[$message_id][$ug_type]))) . ')';

- WHERE attach_id IN (' . implode(', ', array_unique($update_count)) . ')';

- WHERE user_id IN (' . implode(', ', $admin_ary[0]['a_user']) .')';

- avatar_delete($user->data['user_avatar']);

- WHERE user_id IN (' . implode(', ', $admin_ary[0]['a_user']) .')';

- $sql_in[] = "'" . $db->sql_escape($row['session_id']) . "'";

- WHERE session_id NOT IN (' . implode(', ', $sql_in) . ')

- WHERE user_id IN (' . implode(', ', $admin_ary[0]['a_user']) .')';

- $data['add'] = implode(', ', preg_replace('#^(.*?)$#', "'$1'", array_map(array(&$db, 'sql_escape'), $data['add'])));

-

- if ($data['add'])

- WHERE LOWER(username) IN (' . $data['add'] . ')

- AND zebra_id IN (' . implode(', ', $data['usernames']) . ')';

- 'OVERVIEW_BODY' => 'Welcome to our first public beta of the next-generation of phpBB after 2.0.x, phpBB 3.0! This beta release is intended for advanced users to try out on dedicated development enviroments to help us finish creating the best Opensource Bulletin Board solution available.</p><p><strong style="text-transform: uppercase;">Note:</strong> This release is <strong style="text-transform: uppercase;">not final</strong> and made available for testing purposes <strong style="text-transform: uppercase;">only</strong>.</p><p>This installation system will guide you through the process of installing phpBB, converting from a different software package or updating to the latest version of phpBB. For more information on each option, select it from the menu above.',

- WHERE t.topic_id IN (' . implode(', ', $topic_ids) . ')';

- 'WHERE' => 'p.post_id IN (' . implode(', ', $post_ids) . ')

- WHERE forum_id ' . ((is_array($forum_id)) ? 'IN (' . implode(', ', $forum_id) . ')' : "= $forum_id");

- $where_sql forum_id IN (" . (($forum_id) ? $forum_id : implode(', ', get_forum_list('m_approve'))) . ')

- $where_sql forum_id IN (" . (($forum_id) ? $forum_id : implode(', ', get_forum_list('m_approve'))) . ')

- $where_sql .= ' p.forum_id IN (' . implode(', ', get_forum_list('m_report')) . ')';

- $where_sql forum_id IN (" . (($forum_id) ? $forum_id : implode(', ', get_forum_list('m_'))) . ')

- $sql .= ' AND forum_id NOT IN ( ' . implode(', ', $forum_ary) . ')';

- WHERE $sql_id IN (" . implode(', ', $ids) . ")

- 'WHERE' => 'u.user_id IN (' . implode(', ', array_unique(array_merge($admin_id_ary, $mod_id_ary))) . ')

- $sql_where .= " AND u.user_id IN ('-1')";

- $sql_where .= ' AND u.user_id IN (' . implode(', ', $ip_sql) . ')';

- $sql_where .= " AND u.user_id IN ('-1')";

- $not_in_fid = (sizeof($ex_fid_ary)) ? 'WHERE f.forum_id NOT IN (' . implode(', ', $ex_fid_ary) . ") OR (f.forum_password <> '' AND fa.user_id <> " . (int) $user->data['user_id'] . ')' : "";

- $m_approve_fid_sql = ' AND (p.post_approved = 1' . ((sizeof($m_approve_fid_ary)) ? ' OR p.forum_id NOT IN (' . implode(', ', $m_approve_fid_ary) . ')' : '') . ')';

- " . ((sizeof($ex_fid_ary)) ? ' AND p.forum_id NOT IN (' . implode(',', $ex_fid_ary) . ')' : '') . '

- " . ((sizeof($ex_fid_ary)) ? ' AND p.forum_id NOT IN (' . implode(',', $ex_fid_ary) . ')' : '') . "

- " . ((sizeof($ex_fid_ary)) ? ' AND p.forum_id NOT IN (' . implode(',', $ex_fid_ary) . ')' : '') . "

- " . ((sizeof($ex_fid_ary)) ? ' AND p.forum_id NOT IN (' . implode(',', $ex_fid_ary) . ')' : '') . "

- ' . ((sizeof($ex_fid_ary)) ? 'AND t.forum_id NOT IN (' . implode(',', $ex_fid_ary) . ')' : '') . "

- $sql_where = (($show_results == 'posts') ? 'p.post_id' : 't.topic_id') . ' IN (' . implode(', ', $id_ary) . ')';

- $sql_where .= (sizeof($ex_fid_ary)) ? ' AND (f.forum_id NOT IN (' . implode(',', $ex_fid_ary) . ') OR f.forum_id IS NULL)' : '';

- $sql .= ' AND forum_id NOT IN ( ' . implode(', ', $forum_ary) . ')';

- 'WHERE' => (($forum_data['forum_type'] == FORUM_POST || !sizeof($active_forum_ary)) ? 't.forum_id = ' . $forum_id : 't.forum_id IN (' . implode(', ', $active_forum_ary['forum_id']) . ')') . '

- WHERE topic_id IN (' . implode(', ', array_keys($shadow_topic_list)) . ')';

- 'WHERE' => 'p.post_id IN (' . implode(', ', $post_list) . ')

- WHERE session_user_id IN (' . implode(', ', $id_cache) . ')

- WHERE post_msg_id IN (' . implode(', ', $attach_list) . ')

- WHERE post_id IN (' . implode(', ', $attach_list) . ')';

- WHERE p.post_id IN (' . implode(', ', $post_storage_list) . ")

- AND p.post_edit_user = u.user_id";

- WHERE attach_id IN (' . implode(', ', array_unique($update_count)) . ')';