// dirty trick: 0 is false, but can still encode that the captcha is not yet validated

var $solved = 0;

/**

* @param int $type as per the CAPTCHA API docs, the type

*/

// we need all defined questions - shouldn't be too many, so we can just grab them

// try the user's lang first

$sql = 'SELECT question_id

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

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

$this->question_lang = $config['default_lang'];

$sql = 'SELECT question_id

WHERE lang_iso = '" . $db->sql_escape($config['default_lang']) . "'";

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

$db_tool = new \phpbb\db\tools($db);

}

/**

}

$sql = 'SELECT COUNT(question_id) AS question_count

WHERE lang_iso = '" . $db->sql_escape($config['default_lang']) . "'";

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

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

if ($this->is_available())

{

$sql = 'SELECT question_text

WHERE lang_iso = '" . $db->sql_escape($config['default_lang']) . "'";

$result = $db->sql_query_limit($sql, 1);

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

global $db, $config;

$sql = 'SELECT c.confirm_id

LEFT JOIN ' . SESSIONS_TABLE . ' s

ON (c.session_id = s.session_id)

WHERE s.session_id IS NULL' .

if (sizeof($sql_in))

{

WHERE ' . $db->sql_in_set('confirm_id', $sql_in);

$db->sql_query($sql);

}

$db_tool = new \phpbb\db\tools($db);

$schemas = array(

'COLUMNS' => array(

'question_id' => array('UINT', null, 'auto_increment'),

'strict' => array('BOOL', 0),

'lang' => array('INDEX', 'lang_iso'),

),

),

'COLUMNS' => array(

'question_id' => array('UINT', 0),

'answer_text' => array('STEXT_UNI', ''),

'qid' => array('INDEX', 'question_id'),

),

),

'COLUMNS' => array(

'session_id' => array('CHAR:32', ''),

'confirm_id' => array('CHAR:32', ''),

$this->confirm_id = md5(unique_id($user->ip));

$this->question = (int) array_rand($this->question_ids);

'confirm_id' => (string) $this->confirm_id,

'session_id' => (string) $user->session_id,

'lang_iso' => (string) $this->question_lang,

$this->question = (int) array_rand($this->question_ids);

$this->solved = 0;

SET question_id = ' . (int) $this->question . "

WHERE confirm_id = '" . $db->sql_escape($this->confirm_id) . "'

AND session_id = '" . $db->sql_escape($user->session_id) . "'";

$this->question = (int) array_rand($this->question_ids);

$this->solved = 0;

SET question_id = ' . (int) $this->question . ",

attempts = attempts + 1

WHERE confirm_id = '" . $db->sql_escape($this->confirm_id) . "'

global $db, $user;

$sql = 'SELECT confirm_id

WHERE

session_id = '" . $db->sql_escape($user->session_id) . "'

AND lang_iso = '" . $db->sql_escape($this->question_lang) . "'

}

$sql = 'SELECT con.question_id, attempts, question_text, strict

WHERE con.question_id = qes.question_id

AND confirm_id = '" . $db->sql_escape($this->confirm_id) . "'

AND session_id = '" . $db->sql_escape($user->session_id) . "'

$answer = ($this->question_strict) ? utf8_normalize_nfc(request_var('qa_answer', '', true)) : utf8_clean_string(utf8_normalize_nfc(request_var('qa_answer', '', true)));

$sql = 'SELECT answer_text

WHERE question_id = ' . (int) $this->question;

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

{

global $db, $user;

WHERE session_id = '" . $db->sql_escape($user->session_id) . "'

AND confirm_type = " . (int) $this->type;

$db->sql_query($sql);

global $db, $template, $table_prefix;

$sql = 'SELECT *

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

$template->assign_vars(array(

if ($question_id)

{

$sql = 'SELECT *

WHERE question_id = ' . $question_id;

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

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

$question['answers'] = array();

$sql = 'SELECT *

WHERE question_id = ' . $question_id;

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

global $db, $cache, $table_prefix;

// easier to delete all answers than to figure out which to update

$db->sql_query($sql);

$langs = $this->get_languages();

$question_ary['lang_id'] = $langs[$question_ary['lang_iso']]['id'];

unset($question_ary['answers']);

SET ' . $db->sql_build_array('UPDATE', $question_ary) . "

WHERE question_id = $question_id";

$db->sql_query($sql);

$this->acp_insert_answers($data, $question_id);

}

/**

$question_ary['lang_id'] = $langs[$data['lang_iso']]['id'];

unset($question_ary['answers']);

$db->sql_query($sql);

$question_id = $db->sql_nextid();

$this->acp_insert_answers($data, $question_id);

}

/**

'answer_text' => $answer,

);

$db->sql_query($sql);

}

}

/**

{

global $db, $cache, $table_prefix;

foreach ($tables as $table)

{

if ($question_id)

{

$sql = 'SELECT question_id

WHERE lang_iso = '" . $db->sql_escape($config['default_lang']) . "'

AND question_id <> " . (int) $question_id;

$result = $db->sql_query_limit($sql, 1);