+ $captchas = phpbb_captcha_factory::get_captcha_types();

+ $selected = (isset($captchas['available'][$selected]) || isset($captchas['unavailable'][$selected])) ? $selected : $config['captcha_plugin'];

+

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

+ $sql_data .= "DROP TABLE $table_name\n/\n";

+ if ($row['data_type'] !== 'VARCHAR2' && $row['data_type'] !== 'CHAR')

+ $primary_key = array();

+ $contraint_name = '';

+ $constraint_name = '"' . $row['constraint_name'] . '"';

+ $primary_key[] = '"' . $row['column_name'] . '"';

+ if (sizeof($primary_key))

+ {

+ $rows[] = " CONSTRAINT {$constraint_name} PRIMARY KEY (" . implode(', ', $primary_key) . ')';

+ }

+

+ $unique = array();

+ $contraint_name = '';

+ $constraint_name = '"' . $row['constraint_name'] . '"';

+ $unique[] = '"' . $row['column_name'] . '"';

+ if (sizeof($unique))

+ {

+ $rows[] = " CONSTRAINT {$constraint_name} UNIQUE (" . implode(', ', $unique) . ')';

+ }

+

+ $sql_data .= "\n)\n/\n";

+ $sql = "SELECT A.REFERENCED_NAME, C.*

+ FROM USER_DEPENDENCIES A, USER_TRIGGERS B, USER_SEQUENCES C

+ AND B.TABLE_NAME = '{$table_name}'

+ AND C.SEQUENCE_NAME = A.REFERENCED_NAME";

+

+ $type = request_var('type', '');

+

+ $sql_data .= "\nDROP SEQUENCE \"{$row['referenced_name']}\"\n/\n";

+ $sql_data .= "\nCREATE SEQUENCE \"{$row['referenced_name']}\"";

+

+ if ($type == 'full')

+ {

+ $sql_data .= ' START WITH ' . $row['last_number'];

+ }

+

+ $sql_data .= "\n/\n";

+ $sql_data .= "\nCREATE OR REPLACE TRIGGER {$row['description']}WHEN ({$row['when_clause']})\n{$row['trigger_body']}\n/\n";

+ $sql_data .= "\nCREATE INDEX $index_name ON $table_name(" . implode(', ', $column_names) . ")\n/\n";

+ if (preg_match('#char|text|bool|raw|clob#i', $ary_type[$i]))

+ $sql_data = "INSERT INTO $table_name (" . implode(', ', $schema_fields) . ') VALUES (' . implode(', ', $schema_vals) . ")\n/\n";

+// $data = preg_split('/[\0\n\t\r\b\f\'"\/\\\]/', $text);

+// preg_match_all('/[\0\n\t\r\b\f\'"\/\\\]/', $text, $matches);

+ $data = preg_split('/[\0\b\f\'\/]/', $text);

+ preg_match_all('/[\0\r\b\f\'\/]/', $text, $matches);

+ $forum_data['show_active'] = ($forum_data['forum_type'] == FORUM_POST) ? request_var('display_recent', true) : request_var('display_active', true);

+ 'forum_flags' => FORUM_FLAG_POST_REVIEW + FORUM_FLAG_ACTIVE_TOPICS,

+ if (!empty($forum_data['forum_image']) && !file_exists($phpbb_root_path . $forum_data['forum_image']))

+ $announcement_url = (strpos($announcement_url, '&') === false) ? str_replace('&', '&', $announcement_url) : $announcement_url;

+ $where_sql = ' AND ' . $db->sql_in_set('warning_id', array_values($marked));

+ 'S_CAN_UPLOAD' => $can_upload,

+

+ $captcha =& phpbb_captcha_factory::get_instance($config['captcha_plugin']);

+ $captcha->init(CONFIRM_LOGIN);

+ $vc_response = $captcha->validate();

+ if ($vc_response)

+

+ global $phpbb_root_path, $template, $user;

+ if (isset($template->orig_tpl_inherits_id) && $template->orig_tpl_inherits_id)

+

+

+ add_log('admin', 'LOG_CONFIG_VISUAL');

+

+ $this->question_lang = $user->lang_name;

+ WHERE lang_iso = '" . $db->sql_escape($user->lang_name) . "'";

+ add_log('admin', 'LOG_CONFIG_VISUAL');

+

+ add_log('admin', 'LOG_CONFIG_VISUAL');

+define('PHPBB_VERSION', '3.0.6-RC2');

+ $return_array['default'] = 'DEFAULT (' . $column_data[1] . ') ';

+ $sql_default .= $return_array['default'];

+ $return_array['default'] = 'DEFAULT (' . ((is_numeric($column_data[1])) ? $column_data[1] : "'{$column_data[1]}'") . ') ';

+ $sql_default .= $return_array['default'];

+ WHERE RDB\$RELATION_NAME = '" . strtoupper($table_name) . "'

+ WHERE table_name = '" . strtoupper($table_name) . "'

+ AND generated = 'N'

+ AND uniqueness = 'NONUNIQUE'";

+

+ if (!empty($column_data['default']))

+ {

+ // Using TRANSACT-SQL for this statement because we do not want to have colliding data if statements are executed at a later stage

+ $statements[] = "DECLARE @drop_default_name VARCHAR(100), @cmd VARCHAR(1000)

+ SET @drop_default_name =

+ (SELECT so.name FROM sysobjects so

+ JOIN sysconstraints sc ON so.id = sc.constid

+ WHERE object_name(so.parent_obj) = '{$table_name}'

+ AND so.xtype = 'D'

+ AND sc.colid = (SELECT colid FROM syscolumns

+ WHERE id = object_id('{$table_name}')

+ AND name = '{$column_name}'))

+ IF @drop_default_name <> ''

+ BEGIN

+ SET @cmd = 'ALTER TABLE [{$table_name}] DROP CONSTRAINT [' + @drop_default_name + ']'

+ EXEC(@cmd)

+ END

+ SET @cmd = 'ALTER TABLE [{$table_name}] ADD CONSTRAINT [DF_{$table_name}_{$column_name}_1] {$column_data['default']} FOR [{$column_name}]'

+ EXEC(@cmd)";

+ }

+ if (preg_match('/^(INSERT INTO[^(]++)\\(([^()]+)\\) VALUES[^(]++\\((.*?)\\)$/sU', $query, $regs))

+

+ if (sizeof($cols) !== sizeof($vals))

+ {

+ // Try to replace some common data we know is from our restore script or from other sources

+ $regs[3] = str_replace("'||chr(47)||'", '/', $regs[3]);

+ $_vals = explode(', ', $regs[3]);

+

+ $vals = array();

+ $is_in_val = false;

+ $i = 0;

+ $string = '';

+

+ foreach ($_vals as $value)

+ {

+ if (strpos($value, "'") === false && !$is_in_val)

+ {

+ $vals[$i++] = $value;

+ continue;

+ }

+

+ if (substr($value, -1) === "'")

+ {

+ $vals[$i] = $string . (($is_in_val) ? ', ' : '') . $value;

+ $string = '';

+ $is_in_val = false;

+

+ if ($vals[$i][0] !== "'")

+ {

+ $vals[$i] = "''" . $vals[$i];

+ }

+ $i++;

+ continue;

+ }

+ else

+ {

+ $string .= (($is_in_val) ? ', ' : '') . $value;

+ $is_in_val = true;

+ }

+ }

+

+ if ($string)

+ {

+ // New value if cols != value

+ $vals[(sizeof($cols) !== sizeof($vals)) ? $i : $i - 1] .= $string;

+ }

+

+ $vals = array(0 => $vals);

+ }

+

+ for ($i = 0, $size = sizeof($this->_edits); $i < $size; $i++)

+ $edit = $this->_edits[$i];

+

+ for ($i = 0, $size = sizeof($this->_edits); $i < $size; $i++)

+ $edit = $this->_edits[$i];

+

+ for ($i = 0, $size = sizeof($this->_edits); $i < $size; $i++)

+ $edit = $this->_edits[$i];

+ for ($i = 0, $size = sizeof($this->_edits); $i < $size; $i++)

+ $edit = $this->_edits[$i];

+

+ // skip diff_op_copy

+ if (is_a($edit, 'diff_op_copy'))

+ {

+ continue;

+ }

+

+ if (is_a($edit, 'diff_op_delete') || is_a($edit, 'diff_op_add'))

+ $orig = $edit->orig;

+ $final = $edit->final;

+

+ // We can simplify one case where the array is usually supposed to be empty...

+ if (sizeof($orig) == 1 && trim($orig[0]) === '') $orig = array();

+ if (sizeof($final) == 1 && trim($final[0]) === '') $final = array();

+

+ if (!$orig && !$final)

+ {

+ continue;

+ }

+

+

+ return false;

+

+ for ($i = 0, $size = sizeof($this->_edits); $i < $size; $i++)

+ $edit = $this->_edits[$i];

+

+ for ($i = 0, $size = sizeof($this->_edits); $i < $size; $i++)

+ $edit = $this->_edits[$i];

+

+ for ($i = 0, $size = sizeof($this->_edits); $i < $size; $i++)

+ $edit = $this->_edits[$i];

+

+ for ($i = 0, $size = sizeof($this->_edits); $i < $size; $i++)

+ $edit = $this->_edits[$i];

+

+ function diff3(&$orig, &$final1, &$final2, $preserve_cr = true)

+ $diff_1 = $diff_engine->diff($orig, $final1, $preserve_cr);

+ $diff_2 = $diff_engine->diff($orig, $final2, $preserve_cr);

+ unset($diff_engine);

+ for ($i = 0, $size = sizeof($this->_edits); $i < $size; $i++)

+ $edit = $this->_edits[$i];

+

+ for ($i = 0, $size = sizeof($this->_edits); $i < $size; $i++)

+ $edit = $this->_edits[$i];

+

+ for ($i = 0, $size = sizeof($this->_edits); $i < $size; $i++)

+ $edit = $this->_edits[$i];

+

+ for ($i = 0, $size = sizeof($this->_edits); $i < $size; $i++)

+ $edit = $this->_edits[$i];

+

+ for ($i = 0, $size = sizeof($this->_edits); $i < $size; $i++)

+ $edit = $this->_edits[$i];

+

+ // Prepare the arrays before we compare them. ;)

+ $this->solve_prepare();

+

+ // The following tries to aggressively solve conflicts...

+ $this->solve_conflict();

+

+ /**

+ * Function to prepare the arrays for comparing - we want to skip over newline changes

+ * @author acydburn

+ */

+ function solve_prepare()

+ {

+ // We can simplify one case where the array is usually supposed to be empty...

+ if (sizeof($this->orig) == 1 && trim($this->orig[0]) === '') $this->orig = array();

+ if (sizeof($this->final1) == 1 && trim($this->final1[0]) === '') $this->final1 = array();

+ if (sizeof($this->final2) == 1 && trim($this->final2[0]) === '') $this->final2 = array();

+

+ // Now we only can have the case where the only difference between arrays are newlines, so compare all cases

+

+ // First, some strings we can compare...

+ $orig = $final1 = $final2 = '';

+

+ foreach ($this->orig as $null => $line) $orig .= trim($line);

+ foreach ($this->final1 as $null => $line) $final1 .= trim($line);

+ foreach ($this->final2 as $null => $line) $final2 .= trim($line);

+

+ // final1 === final2

+ if ($final1 === $final2)

+ {

+ // We preserve the part which will be used in the merge later

+ $this->final2 = $this->final1;

+ }

+ // final1 === orig

+ else if ($final1 === $orig)

+ {

+ // Here it does not really matter what we choose, but we will use the new code

+ $this->orig = $this->final1;

+ }

+ // final2 === orig

+ else if ($final2 === $orig)

+ {

+ // Here it does not really matter too (final1 will be used), but we will use the new code

+ $this->orig = $this->final2;

+ }

+ }

+

+ /**

+ * Find code portions from $orig in $final1 and use $final2 as merged instance if provided

+ * @author acydburn

+ */

+ function _compare_conflict_seq($orig, $final1, $final2 = false)

+ {

+ $result = array('merge_found' => false, 'merge' => array());

+

+ $_orig = &$this->$orig;

+ $_final1 = &$this->$final1;

+

+ // Ok, we basically search for $orig in $final1

+ $compare_seq = sizeof($_orig);

+

+ // Go through the conflict code

+ for ($i = 0, $j = 0, $size = sizeof($_final1); $i < $size; $i++, $j = $i)

+ {

+ $line = $_final1[$i];

+ $skip = 0;

+

+ for ($x = 0; $x < $compare_seq; $x++)

+ {

+ // Try to skip all matching lines

+ if (trim($line) === trim($_orig[$x]))

+ {

+ $line = (++$j < $size) ? $_final1[$j] : $line;

+ $skip++;

+ }

+ }

+

+ if ($skip === $compare_seq)

+ {

+ $result['merge_found'] = true;

+

+ if ($final2 !== false)

+ {

+ $result['merge'] = array_merge($result['merge'], $this->$final2);

+ }

+ $i += ($skip - 1);

+ }

+ else if ($final2 !== false)

+ {

+ $result['merge'][] = $line;

+ }

+ }

+

+ return $result;

+ }

+

+ /**

+ * Tries to solve conflicts aggressively based on typical "assumptions"

+ * @author acydburn

+ */

+ function solve_conflict()

+ {

+ $this->_merged = false;

+

+ // CASE ONE: orig changed into final2, but modified/unknown code in final1.

+ // IF orig is found "as is" in final1 we replace the code directly in final1 and populate this as final2/merge

+ if (sizeof($this->orig) && sizeof($this->final2))

+ {

+ $result = $this->_compare_conflict_seq('orig', 'final1', 'final2');

+

+ if ($result['merge_found'])

+ {

+ $this->final2 = $result['merge'];

+ $this->_merged = &$this->final2;

+ return;

+ }

+

+ $result = $this->_compare_conflict_seq('final2', 'final1');

+

+ if ($result['merge_found'])

+ {

+ $this->_merged = &$this->final1;

+ return;

+ }

+

+ // Try to solve $Id$ issues. ;)

+ if (sizeof($this->orig) == 1 && sizeof($this->final1) == 1 && sizeof($this->final2) == 1)

+ {

+ $match = '#^' . preg_quote('* @version $Id: ', '#') . '[a-z\._\- ]+[0-9]+ [0-9]{4}-[0-9]{2}-[0-9]{2} [0-9\:Z]+ [a-z0-9_\- ]+\$$#';

+

+ if (preg_match($match, $this->orig[0]) && preg_match($match, $this->final1[0]) && preg_match($match, $this->final2[0]))

+ {

+ $this->_merged = &$this->final2;

+ return;

+ }

+ }

+

+ $second_run = false;

+

+ // Try to solve issues where the only reason why the above did not work is a newline being removed in the final1 code but exist in the orig/final2 code

+ if (trim($this->orig[0]) === '' && trim($this->final2[0]) === '')

+ {

+ unset($this->orig[0], $this->final2[0]);

+ $this->orig = array_values($this->orig);

+ $this->final2 = array_values($this->final2);

+

+ $second_run = true;

+ }

+

+ // The same is true for a line at the end. ;)

+ if (sizeof($this->orig) && sizeof($this->final2) && sizeof($this->orig) === sizeof($this->final2) && trim($this->orig[sizeof($this->orig)-1]) === '' && trim($this->final2[sizeof($this->final2)-1]) === '')

+ {

+ unset($this->orig[sizeof($this->orig)-1], $this->final2[sizeof($this->final2)-1]);

+ $this->orig = array_values($this->orig);

+ $this->final2 = array_values($this->final2);

+

+ $second_run = true;

+ }

+

+ if ($second_run)

+ {

+ $result = $this->_compare_conflict_seq('orig', 'final1', 'final2');

+

+ if ($result['merge_found'])

+ {

+ $this->final2 = $result['merge'];

+ $this->_merged = &$this->final2;

+ return;

+ }

+

+ $result = $this->_compare_conflict_seq('final2', 'final1');

+

+ if ($result['merge_found'])

+ {

+ $this->_merged = &$this->final1;

+ return;

+ }

+ }

+

+ return;

+ }

+

+ // CASE TWO: Added lines from orig to final2 but final1 had added lines too. Just merge them.

+ if (!sizeof($this->orig) && $this->final1 !== $this->final2 && sizeof($this->final1) && sizeof($this->final2))

+ {

+ $result = $this->_compare_conflict_seq('final2', 'final1');

+

+ if ($result['merge_found'])

+ {

+ $this->final2 = $this->final1;

+ $this->_merged = &$this->final1;

+ }

+ else

+ {

+ $result = $this->_compare_conflict_seq('final1', 'final2');

+

+ if (!$result['merge_found'])

+ {

+ $this->final2 = array_merge($this->final1, $this->final2);

+ $this->_merged = &$this->final2;

+ }

+ else

+ {

+ $this->final2 = $this->final1;

+ $this->_merged = &$this->final1;

+ }

+ }

+

+ return;

+ }

+

+ // CASE THREE: Removed lines (orig has the to-remove line(s), but final1 has additional lines which does not need to be removed). Just remove orig from final1 and then use final1 as final2/merge

+ if (!sizeof($this->final2) && sizeof($this->orig) && sizeof($this->final1) && $this->orig !== $this->final1)

+ {

+ $result = $this->_compare_conflict_seq('orig', 'final1');

+

+ if (!$result['merge_found'])

+ {

+ return;

+ }

+

+ // First of all, try to find the code in orig in final1. ;)

+ $compare_seq = sizeof($this->orig);

+ $begin = $end = -1;

+ $j = 0;

+

+ for ($i = 0, $size = sizeof($this->final1); $i < $size; $i++)

+ {

+ $line = $this->final1[$i];

+

+ if (trim($line) === trim($this->orig[$j]))

+ {

+ // Mark begin

+ if ($begin === -1)

+ {

+ $begin = $i;

+ }

+

+ // End is always $i, the last found line

+ $end = $i;

+

+ if (isset($this->orig[$j+1]))

+ {

+ $j++;

+ }

+ }

+ }

+

+ if ($begin !== -1 && $begin + ($compare_seq - 1) == $end)

+ {

+ foreach ($this->final1 as $i => $line)

+ {

+ if ($i < $begin || $i > $end)

+ {

+ $merged[] = $line;

+ }

+ }

+

+ $this->final2 = $merged;

+ $this->_merged = &$this->final2;

+ }

+

+ return;

+ }

+

+ return;

+ }

+ /**

+ * If set to true we trim all lines before we compare them. This ensures that sole space/tab changes do not trigger diffs.

+ */

+ if (trim($from_lines[$skip]) !== trim($to_lines[$skip]))

+ if (trim($from_lines[$xi]) !== trim($to_lines[$yi]))

+ if ($this->skip_whitespace_changes) $xhash[trim($from_lines[$xi])] = 1; else $xhash[$from_lines[$xi]] = 1;

+ $line = ($this->skip_whitespace_changes) ? trim($to_lines[$yi]) : $to_lines[$yi];

+ $line = ($this->skip_whitespace_changes) ? trim($from_lines[$xi]) : $from_lines[$xi];

+ if ($this->skip_whitespace_changes)

+ {

+ $from_lines_clean = array_map('trim', $from_lines);

+ $to_lines_clean = array_map('trim', $to_lines);

+

+ $this->_shift_boundaries($from_lines_clean, $this->xchanged, $this->ychanged);

+ $this->_shift_boundaries($to_lines_clean, $this->ychanged, $this->xchanged);

+

+ unset($from_lines_clean, $to_lines_clean);

+ }

+ else

+ {

+ $this->_shift_boundaries($from_lines, $this->xchanged, $this->ychanged);

+ $this->_shift_boundaries($to_lines, $this->ychanged, $this->xchanged);

+ }

+ 'ON' => "tt.user_id = $user_id AND t.topic_id = tt.topic_id",

+ 'ON' => "ft.user_id = $user_id AND t.forum_id = ft.forum_id",

+ (tt.mark_time IS NULL AND ft.mark_time IS NULL AND t.topic_last_post_time > $last_mark)

+ 'S_LOGIN_ACTION' => build_url(array('f')),

+ // Which timezone?

+ $tz = ($user->data['user_id'] != ANONYMOUS) ? strval(doubleval($user->data['user_timezone'])) : strval(doubleval($config['board_timezone']));

+

+ // Send a proper content-language to the output

+ $user_lang = $user->lang['USER_LANG'];

+ if (strpos($user_lang, '-x-') !== false)

+ {

+ $user_lang = substr($user_lang, 0, strpos($user_lang, '-x-'));

+ }

+

+ $rowset[] = ($id_only) ? (int) $row['forum_id'] : $row;

+ $sql_forum = '';

+ $tpl->set_custom_template($template_path, $template_lang . '_email', 'email');

+

+ // Here we try to determine the *real* hostname (reverse DNS entry preferrably)

+ $local_host = $user->host;

+

+ if (function_exists('php_uname'))

+ {

+ $local_host = php_uname('n');

+

+ // Able to resolve name to IP

+ if (($addr = @gethostbyname($local_host)) !== $local_host)

+ {

+ // Able to resolve IP back to name

+ if (($name = @gethostbyaddr($addr)) !== $addr)

+ {

+ $local_host = $name;

+ }

+ }

+ }

+ global $db, $phpbb_root_path, $phpEx, $user;

+ {

+ if ($auth->acl_gets('m_split', 'm_merge', (int) $topic_info['forum_id']))

+ function parse_attachments($form_name, $mode, $forum_id, $submit, $preview, $refresh, $is_message = false)

+ 'is_orphan' => 1,

+ 'is_orphan' => 1,

+ $host = (function_exists('php_uname')) ? php_uname('n') : 'localhost';

+ function set_custom_template($template_path, $template_name, $template_mode = 'template')

+

+ // As the template-engine is used for more than the template (emails, etc.), we should not set $user->theme in all cases, but only on the real template.

+ if ($template_mode == 'template')

+ {

+ $user->theme['template_storedb'] = false;

+ $user->theme['template_inherits_id'] = false;

+ }

+ $message_parser->parse_attachments('fileupload', $action, 0, $submit, $preview, $refresh, true);