global $db;

// one transaction, we can now garuntee that atomicity of insertions

$user_id = (int) $data['user_id'];

$forum_id = (int) $data['forum_id'];

FROM ' . USERS_TABLE . '

WHERE user_id = ' . $user_id;

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

$db->sql_freeresult($result);

}

'topic_posts' => 1,

'topic_moved_posts' => 0,

'topic_deleted_posts' => 0,

'topic_first_poster_name' => $username,

'topic_poster' => $user_id,

'topic_last_username' => $username,

$db->sql_handle_data('UPDATE', FORUMS_TABLE, $forum_data, "forum_id = $forum_id");

// we are consistant, victory is ours

}

public function insert_post($data)

{

global $db;

// one transaction, we can now garuntee that atomicity of insertions

$user_id = (int) $data['user_id'];

$topic_id = (int) $data['topic_id'];

FROM ' . TOPICS_TABLE . '

WHERE topic_id = ' . $topic_id;

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

$db->sql_freeresult($result);

}

FROM ' . USERS_TABLE . '

WHERE user_id = ' . $user_id;

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

$db->sql_freeresult($result);

}

$db->sql_handle_data('UPDATE', FORUMS_TABLE, $forum_data, "forum_id = $forum_id");

// we are consistant, victory is ours

}

function move_topic($data)

global $db;

// lets get this party started

$topic_id = (int) $data['topic_id'];

$to_forum_id = (int) $data['forum_id'];

WHERE topic_id = ' . $topic_id;

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

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

$topic_status = (int) $row['topic_status'];

$from_forum_id = (int) $row['from_forum_id'];

$topic_row['topic_deleted_posts'] = (int) $row['topic_deleted_posts'];

$topic_row['topic_unapproved_posts'] = (int) $row['topic_unapproved_posts'];

// let us first determine how many items we are removing from the pool

$sql = 'SELECT forum_posts, forum_moved_posts, forum_deleted_posts, forum_unapproved_posts, forum_id, forum_topics, forum_deleted_topics, forum_unapproved_topics

FROM ' . FORUMS_TABLE. '

// in hundreds of fewer lines of code, we have now moved a topic

// (this totally ignores the shadow topic thingy, I do not care for now)

}

}

<ol>

<li><a href="#changelog">Changelog</a>

<ol style="list-style-type: lower-roman;">

<li><a href="#v300">Changes since 3.0.0</a></li>

<li><a href="#v30rc8">Changes since RC-8</a></li>

<li><a href="#v30rc7">Changes since RC-7</a></li>

<div class="content">

<ul>

<li>[Change] Validate birthdays (Bug #15004)</li>

<li>[Fix] Allow correct avatar caching for CGI installations. (thanks wildbill)</li>

<li>[Fix] Fix disabling of word censor, now possible again</li>

<li>[Sec] Check for non-empty config.php within style.php (Report #s24575) - reported by bantu</li>

</ul>

</ul>

<a name="v30rc8"></a><h3>1.i. Changes since 3.0.RC8</h3>

<ul>

<li>[Fix] Cleaned usernames contain only single spaces, so &quot;a_name&quot; and &quot;a__name&quot; are treated as the same name (Bug #15634)</li>

<li>[Fix] Call garbage_collection() within database updater to correctly close connections (affects Oracle for example)</li>

</ul>

<ul>

<li>[Fix] Fixed MSSQL related bug in the update system</li>

<li>[Fix] No duplication of active topics (Bug #15474)</li>

</ul>

<ul>

<li>[Fix] Submitting language changes using acp_language (Bug #14736)</li>

<li>[Fix] Able to request new password (Bug #14743)</li>

</ul>

<ul>

<li>[Feature] Removing constant PHPBB_EMBEDDED in favor of using an exit_handler(); the constant was meant to achive this more or less.</li>

<li>[Sec] New password hashing mechanism for storing passwords (#i42)</li>

</ul>

<ul>

<li>[Fix] MySQL, PostgreSQL and SQLite related database fixes (Bug #13862)</li>

<li>[Fix] odbc_autocommit causing existing result sets to be dropped (Bug #14182)</li>

</ul>

<ul>

<li>[Fix] Fixing some subsilver2 and prosilver style issues</li>

</ul>

<ul>

<li>[Fix] Re-allow searching within the memberlist</li>

</ul>

<ul>

<li>[Fix] (X)HTML issues within the templates (Bug #11255, #11255)</li>

{

$l_explain = (isset($user->lang[$vars['lang'] . '_EXPLAIN'])) ? $user->lang[$vars['lang'] . '_EXPLAIN'] : '';

}

$template->assign_block_vars('options', array(

'KEY' => $config_key,

'TITLE' => $user->lang[$vars['lang']],

'S_EXPLAIN' => $vars['explain'],

'TITLE_EXPLAIN' => $l_explain,

)

);

'TITLE' => (isset($user->lang[$vars['lang']])) ? $user->lang[$vars['lang']] : $vars['lang'],

'S_EXPLAIN' => $vars['explain'],

'TITLE_EXPLAIN' => $l_explain,

)

);

}

// Not ideal, due to the filesort, non-use of indexes, etc.

FROM ' . USERS_TABLE . ' u, ' . ACL_USERS_TABLE . " a

WHERE u.user_id = a.user_id

$sql_forum_id

{

$this->_set_group_hold_ary($hold_ary[$row['forum_id']], $row['auth_option_id'], $row['auth_setting']);

}

{

foreach (unserialize($this->role_cache[$row['auth_role_id']]) as $option_id => $setting)

{

require($phpbb_root_path . 'config.' . $phpEx);

{

exit;

}

// server a little

if ($id)

{

// Include files

require($phpbb_root_path . 'includes/acm/acm_' . $acm_type . '.' . $phpEx);

require($phpbb_root_path . 'includes/cache.' . $phpEx);