<project name="phpBB" description="The phpBB forum software" default="all" basedir="../">

<!-- a few settings for the build -->

<!-- no configuration should be needed beyond this point -->

<property name="oldversions" value="${olderversions}, ${prevversion}" />

<target name="create-package" depends="prepare-new-version,old-version-diffs">

<exec dir="build" command="php -f package.php '${versions}' > logs/package.log" escape="false" />

<exec dir="build" command="php -f build_diff.php '${prevversion}' '${newversion}' > logs/build_diff.log" escape="false" />

<exec dir="build" escape="false"

command="diff -crNEBwd old_versions/release-${prevversion}/language new_version/phpBB3/language >

save/save_${prevversion}_to_${newversion}/language/phpbb-${prevversion}_to_${newversion}_language.patch" />

<exec dir="build" escape="false"

command="diff -crNEBwd old_versions/release-${prevversion}/styles/subsilver2 new_version/phpBB3/styles/subsilver2 >

save/save_${prevversion}_to_${newversion}/subsilver2/phpbb-${prevversion}_to_${newversion}_subsilver2.patch" />

</target>

<!--

#

# ln -s ../../git-tools/hooks/commit-msg \\

# .git/hooks/commit-msg

config_ns="phpbb.hooks.commit-msg";

debug_level=$(git config --int $config_ns.debug || echo 0);

# Error codes

quit()

{

then

else

fi

}

if [ $? -eq 0 ]

then

quit $ERR_LENGTH;

fi

# Don't be too strict.

# Commits may be temporary, intended to be squashed later.

# Just issue a warning here.

fi

# restore exit code

(exit $result)

echo "$line" | grep -Eq "^#";

;;

*)

quit $err;

;;

esac

expecting="eof";

;;

*)

quit 254;

;;

esac

else

# None of the expected line formats matched

# Guess we'll call it a day here then

fi

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

# If EOF is expected exit cleanly

echo "$expecting" | grep -q "eof" || (

# Unexpected EOF, error

quit $ERR_EOF;

) && (

# Do post scan checks

if [ ! -z "$dupes" ]

then

quit $ERR_FOOTER;

fi

fi

if [ $ticket -gt 0 ]

then

echo "$tickets" | grep -Eq "\bPHPBB3-$ticket\b" || (

quit $ERR_FOOTER;

) || exit $?;

fi

<fieldset class="tabulated">

<legend>{L_TITLE}</legend>

<thead>

<tr>

<th colspan="{COLSPAN}">{L_CONFIG}</th>

<td>{L_ORDER}</td>

<!-- ENDIF -->

<!-- IF S_ADD -->

<!-- ENDIF -->

</tr>

</thead>

</div>

<!-- ENDIF -->

<!-- IF S_WRITABLE_CONFIG -->

<div class="errorbox notice">

<p>{L_WRITABLE_CONFIG}</p>

<fieldset>

<legend>{L_SELECT_USER}</legend>

<dl>

<dd><input class="text medium" type="text" id="username" name="username" /></dd>

<dd>[ <a href="{U_FIND_USERNAME}" onclick="find_username(this.href); return false;">{L_FIND_USERNAME}</a> ]</dd>

<dd class="full" style="text-align: left;"><label><input type="checkbox" class="radio" id="anonymous" name="u" value="{ANONYMOUS_USER_ID}" /> {L_SELECT_ANONYMOUS}</label></dd>

dd input {

font-size: 1.00em;

max-width: 100%;

}

dd select {

font-size: 100%;

width: auto;

max-width: 100%;

}

dd textarea {

width: 90%;

}

fieldset dl {

margin-bottom: 10px;

font-size: 0.85em;

/**

* Fix a bug involving the TextRange object. From

* http://www.frostjedi.com/terra/scripts/demo/caretBug.html

{

var doc;

if(document.forms[form_name])

else

{

insert_text('[*]');

}

}

function bbfontstyle(bbopen, bbclose)

{

theSelection = false;

var textarea = document.forms[form_name].elements[text_name];

textarea.focus();

if ((clientVer >= 4) && is_ie && is_win)

{

// Get text selection

{

return;

}

}

theSelection = '';

return;

}

//The new position for the cursor after adding the bbcode

var caret_pos = getCaretPosition(textarea).start;

// Open tag

insert_text(bbopen + bbclose);

{

textarea.selectionStart = new_pos;

textarea.selectionEnd = new_pos;

// IE

else if (document.selection)

{

range.select();

storeCaret(textarea);

}

function insert_text(text, spaces, popup)

{

var textarea;

if (!popup)

{

textarea = document.forms[form_name].elements[text_name];

mozWrap(textarea, text, '');

textarea.selectionStart = sel_start + text.length;

textarea.selectionEnd = sel_end + text.length;

else if (textarea.createTextRange && textarea.caretPos)

{

{

textarea.focus();

storeCaret(textarea);

}

var caret_pos = textarea.caretPos;

caret_pos.text = caret_pos.text.charAt(caret_pos.text.length - 1) == ' ' ? caret_pos.text + text + ' ' : caret_pos.text + text;

}

else

{

theSelection = theSelection.replace(/<br\/>/ig, '\n');

theSelection = theSelection.replace(/&lt\;/ig, '<');

theSelection = theSelection.replace(/&gt\;/ig, '>');

theSelection = theSelection.replace(/&nbsp\;/ig, ' ');

}

else if (document.all)

var selEnd = txtarea.selectionEnd;

var scrollTop = txtarea.scrollTop;

{

selEnd = selLength;

}

*/

function storeCaret(textEl)

{

{

textEl.caretPos = document.selection.createRange().duplicate();

}

{

document.writeln('<tr>');

}

for (b = 0; b < 5; b++)

{

color = String(numberList[r]) + String(numberList[g]) + String(numberList[b]);

function getCaretPosition(txtarea)

{

var caretPos = new caretPosition();

// simple Gecko/Opera way

{

caretPos.start = txtarea.selectionStart;

caretPos.end = txtarea.selectionEnd;

// a new selection of the whole textarea

var range_all = document.body.createTextRange();

range_all.moveToElementText(txtarea);

// calculate selection start point by moving beginning of range_all to beginning of range

var sel_start;

for (sel_start = 0; range_all.compareEndPoints('StartToStart', range) < 0; sel_start++)

{

range_all.moveStart('character', 1);

}

txtarea.sel_start = sel_start;

// we ignore the end value for IE, this is already dirty enough and we don't need it

caretPos.start = txtarea.sel_start;

}

return caretPos;

* If you overwrite the original schema files please make sure you save the file with UNIX linefeeds.

*/

if (!is_writable($schema_path))

{

foreach ($supported_dbms as $dbms)

{

$line = '';

{

case 'mysql_40':

case 'mysql_41':

break;

case 'firebird':

$line .= custom_data('firebird') . "\n";

break;

case 'sqlite':

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

break;

case 'oracle':

$line .= custom_data('oracle') . "\n";

break;

case 'postgres':

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

$line .= custom_data('postgres') . "\n";

break;

<ol>

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

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

<li><a href="#v308">Changes since 3.0.8</a></li>

<li><a href="#v307-PL1">Changes since 3.0.7-PL1</a></li>

<li><a href="#v307">Changes since 3.0.7</a></li>

<div class="content">

<h4> Bug

</h4>

</ul>

<h4> Security

</h4>

<ul>

</ul>

<ul>

<li>[Sec] Do not expose forum content of forums with ACL entries but no actual permission in ATOM Feeds. (Bug #58595)</li>

</ul>

<ul>

<li>[Fix] Allow ban reason and length to be selected and copied in ACP and subsilver2 MCP. (Bug #51095)</li>

</ul>

<ul>

<li>[Fix] Allow whitespaces in avatar gallery names. (Bug #44955)</li>

<li>[Feature] Send anonymous statistical information to phpBB on installation and update (optional).</li>

</ul>

<ul>

<li>[Fix] Delete user entry from ban list table upon user deletion (Bug #40015 - Patch by TerraFrost)</li>

<li>[Sec] Only use forum id supplied for posting if global announcement detected. (Reported by nickvergessen)</li>

</ul>

<ul>

<li>[Fix] Allow mixed-case template directories to be inherited (Bug #36725)</li>

<li>[Sec] Ask for forum password if post within passworded forum quoted in private message. (Reported by nickvergessen)</li>

</ul>

<ul>

<li>[Fix] Correctly set topic starter if first post in topic removed (Bug #30575 - Patch by blueray2048)</li>

<li>[Sec Precaution] Stricter validation of the HTTP_HOST header (Thanks to Techie-Micheal et al for pointing out possible issues in derived code)</li>

</ul>

<ul>

<li>[Fix] Ability to set permissions on non-mysql dbms (Bug #24955)</li>

<li>[Sec] Only allow urls gone through redirect() being used within login_box(). (thanks nookieman)</li>

</ul>

<ul>

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

<li>[Fix] Find and display colliding usernames correctly when converting from one database to another (Bug #23925)</li>

</ul>

<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>

<p>This package is meant for those wanting to only replace changed files from a previous version to the latest version. This package normally contains the changed files from up to five previous versions.</p>

<p>The directory structure has been preserved enabling you (if you wish) to simply upload the contents of the archive to the appropriate location on your server, i.e. simply overwrite the existing files with the new versions. Do not forget that if you have installed any MODs these files will overwrite the originals possibly destroying them in the process. You will need to re-add MODs to any affected file before uploading.</p>

<p>The patch file is one solution for those with many Modifications (MODs) or other changes who do not want to re-add them back to all the changed files if they use the method explained above. To use this you will need command line access to a standard UNIX type <strong>patch</strong> application. If you do not have access to such an application but still want to use this update approach, we strongly recommend the <a href="#update_auto">Automatic update package</a> explained below. It is also the recommended update method.</p>

<p>If you do get failures you should look at using the <a href="#update_files">Changed files only</a> package to replace the files which failed to patch, please note that you will need to manually re-add any Modifications (MODs) to these particular files. Alternatively if you know how you can examine the .rej files to determine what failed where and make manual adjustments to the relevant source.</p>

<p>The relevant database type/version is listed within the administration control panel</p>

<p>Once a bug has been submitted you will be emailed any follow up comments added to it. <strong>Please</strong> if you are requested to supply additional information, do so! It is frustrating for us to receive bug reports, ask for additional information but get nothing. In these cases we have a policy of closing the bug, which may leave a very real problem in place. Obviously we would rather not have this situation arise.</p>

<li><a href="#writingstyle">Writing Style</a></li>

</ol>

</li>

<li><a href="#disclaimer">Copyright and disclaimer</a></li>

</ol>

$post_url = $phpbb_root_path . 'posting.' . $phpEx . '?mode=' . $mode . '&amp;amp;start=' . $start;

</pre></div>

<div class="codebox"><pre>

$post_url = "{$phpbb_root_path}posting.$phpEx?mode=$mode&amp;amp;start=$start";

</pre></div>

<h4>Associative array keys:</h4>

<p>In PHP, it's legal to use a literal string as a key to an associative array without quoting that string. We don't want to do this -- the string should always be quoted to avoid confusion. Note that this is only when we're using a literal, not when we're using a variable, examples:</p>

<p>Each complex function should be preceded by a comment that tells a programmer everything they need to know to use that function. The meaning of every parameter, the expected input, and the output are required as a minimal comment. The function's behaviour in error conditions (and what those error conditions are) should also be present - but mostly included within the comment about the output.<br /><br />Especially important to document are any assumptions the code makes, or preconditions for its proper operation. Any one of the developers should be able to look at any part of the application and figure out what's going on in a reasonable amount of time.<br /><br />Avoid using <code>/* */</code> comment blocks for one-line comments, <code>//</code> should be used for one/two-liners.</p>

<h4>Magic numbers:</h4>

<h4>Shortcut operators:</h4>

<p>The only shortcut operators that cause readability problems are the shortcut increment <code>$i++</code> and decrement <code>$j--</code> operators. These operators should not be used as part of an expression. They can, however, be used on their own line. Using them in expressions is just not worth the headaches when debugging, examples:</p>

</pre></div>

<h4>SQL Quotes: </h4>

<p class="bad">// These are wrong.</p>

<div class="codebox"><pre>

<h4>sql_build_query():</h4>

<div class="codebox"><pre>

$sql_array = array(

</pre></div>

<h4>Use of in_array(): </h4>

<a name="general"></a><h3>2.v. General Guidelines</h3>

<p>No attempt should be made to remove any copyright information (either contained within the source or displayed interactively when the source is run/compiled), neither should the copyright information be altered in any way (it may be added to).</p>

<h4>Variables: </h4>

<p>The request_var function determines the type to set from the second parameter (which determines the default value too). If you need to get a scalar variable type, you need to tell this the request_var function explicitly. Examples:</p>

<p class="bad">// Old method, do not use it</p>

<p>The <code>$user-&gt;setup()</code> call can be used to pass on additional language definition and a custom style (used in viewforum).</p>

<h4>Errors and messages: </h4>

<div class="codebox"><pre>

trigger_error('NO_FORUM');

<p>All urls pointing to internal files need to be prepended by the <code>$phpbb_root_path</code> variable. Within the administration control panel all urls pointing to internal files need to be prepended by the <code>$phpbb_admin_path</code> variable. This makes sure the path is always correct and users being able to just rename the admin folder and the acp still working as intended (though some links will fail and the code need to be slightly adjusted).</p>

<div class="codebox"><pre>

append_sid(&quot;{$phpbb_root_path}memberlist.$phpEx&quot;, 'mode=group&amp;amp;g=' . $row['group_id'])

<h4>General function usage: </h4>

<ul>

<li>

required_imageset = prosilver

</pre></div>

<a name="genstyling"></a><h3>3.2. General Styling Rules</h3>

<p>The outer table class <code>forumline</code> has gone and is replaced with <code>tablebg</code>.</p>

<p>When writing <code>&lt;table&gt;</code> the order <code>&lt;table class="" cellspacing="" cellpadding="" border="" align=""&gt;</code> creates consistency and allows everyone to easily see which table produces which "look". The same applies to most other tags for which additional parameters can be set, consistency is the major aim here.</p>

<p>Row colours/classes are now defined by the template, use an <code>IF S_ROW_COUNT</code> switch, see viewtopic or viewforum for an example.</p>

<p>Use a standard cellpadding of 2 and cellspacing of 0 on outer tables. Inner tables can vary from 0 to 3 or even 4 depending on the need.</p>

<a name="templates"></a><h3>4.i. General Templating</h3>

<h4>File naming</h4>

<h4>Variables</h4>

<p>All template variables should be named appropriately (using underscores for spaces), language entries should be prefixed with L_, system data with S_, urls with U_, javascript urls with UA_, language to be put in javascript statements with LA_, all other variables should be presented 'as is'.</p>

</p>

<h4>Blocks/Loops</h4>

<span class="comment">&lt;!-- END l_block1 --&gt;</span>

</pre></div>

<div class="codebox"><pre>

<span class="comment">&lt;!-- BEGIN l_block1 --&gt;</span>

&lt;/ul&gt; <span class="comment">&lt;!-- written on third iteration --&gt;</span>

</pre></div>

<h4>Forms</h4>

<p>If a form is used for a non-trivial operation (i.e. more than a jumpbox), then it should include the <code>{S_FORM_TOKEN}</code> template variable.</p>

</pre></div><br />

<a name="inheritance"></a><h3>4.ii. Template Inheritance</h3>

<p>We strongly encourage the use of inheritance for styles based on the bundled styles, as it will ease the update procedure.</p>

<h4>Encoding:</h4>

<p>The impact is that the language files for phpBB must now also be encoded as UTF-8, with a caveat that the files must <strong>not contain</strong> a <acronym title="Byte-Order-Mark">BOM</acronym> for compatibility reasons with non-Unicode aware versions of PHP. For those with forums using the Latin character set (ie: most European languages), this change is transparent since UTF-8 is superset to US-ASCII and ISO-8859-1.</p>

<hr />

<div class="paragraph">

<div class="inner"><span class="corners-top"><span></span></span>

}

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

$ban_length = $ban_reasons = $ban_give_reasons = array();

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

{

$time_length = ($row['ban_end']) ? ($row['ban_end'] - $row['ban_start']) / 60 : 0;

}

}

$template->assign_vars(array(

'S_BAN_END_OPTIONS' => $ban_end_options,

}

}

'hot_threshold' => array('lang' => 'HOT_THRESHOLD', 'validate' => 'int:0', 'type' => 'text:3:4', 'explain' => true),

'max_poll_options' => array('lang' => 'MAX_POLL_OPTIONS', 'validate' => 'int:2:127', 'type' => 'text:4:4', 'explain' => false),

'max_post_chars' => array('lang' => 'CHAR_LIMIT', 'validate' => 'int:0', 'type' => 'text:4:6', 'explain' => true),

'max_post_smilies' => array('lang' => 'SMILIES_LIMIT', 'validate' => 'int:0', 'type' => 'text:4:4', 'explain' => true),

'max_post_urls' => array('lang' => 'MAX_POST_URLS', 'validate' => 'int:0', 'type' => 'text:5:4', 'explain' => true),

'max_post_font_size' => array('lang' => 'MAX_POST_FONT_SIZE', 'validate' => 'int:0', 'type' => 'text:5:4', 'explain' => true, 'append' => ' %'),

'max_name_chars' => array('lang' => 'USERNAME_LENGTH', 'validate' => 'int:8:180', 'type' => false, 'method' => false, 'explain' => false,),

'max_pass_chars' => array('lang' => 'PASSWORD_LENGTH', 'validate' => 'int:8:255', 'type' => false, 'method' => false, 'explain' => false,),

'new_member_post_limit' => array('lang' => 'NEW_MEMBER_POST_LIMIT', 'validate' => 'int:0:255', 'type' => 'text:4:4', 'explain' => true, 'append' => ' ' . $user->lang['POSTS']),

'new_member_group_default'=> array('lang' => 'NEW_MEMBER_GROUP_DEFAULT', 'validate' => 'bool', 'type' => 'radio:yes_no', 'explain' => true),

'min_name_chars' => array('lang' => 'USERNAME_LENGTH', 'validate' => 'int:1', 'type' => 'custom:5:180', 'method' => 'username_length', 'explain' => true),

/**

* Select account activation method

*/

{

global $user, $config;

);

if ($config['email_enable'])

{

}

/**

case 'submit':

$delete = request_var('delete', '');

$file = request_var('file', '');

if (!preg_match('#^backup_\d{10,}_[a-z\d]{16}\.(sql(?:\.(?:gz|bz2))?)$#', $file, $matches))

{

confirm_box(false, $user->lang['DELETE_SELECTED_BACKUP'], build_hidden_fields(array('delete' => $delete, 'file' => $file)));

}

}

{

if ($download)

{

$name = $matches[0];

trigger_error($user->lang['RESTORE_SUCCESS'] . adm_back_link($this->u_action));

break;

}

default:

$methods = array('sql');

$i = $j = 0;

$email_list = array();

$old_lang = $row['user_lang'];

$old_notify_type = $row['user_notify_type'];

$messenger->template('admin_send_email', $used_lang);

$messenger->subject(htmlspecialchars_decode($subject));

$messenger->set_mail_priority($priority);

$message = ($action == 'add') ? $user->lang['FORUM_CREATED'] : $user->lang['FORUM_UPDATED'];

// redirect directly to permission settings screen if authed

if ($action == 'add' && !$copied_permissions && $auth->acl_get('a_fauth'))

{

meta_refresh(4, append_sid("{$phpbb_admin_path}index.$phpEx", 'i=permissions' . $acl_url));

}

$errors = array();

{

$errors[] = $user->lang['FORUM_NAME_EMPTY'];

}

$messenger->to($row['user_email'], $row['username']);

$messenger->assign_vars(array(

'USERNAME' => htmlspecialchars_decode($row['username']))

$messenger->to($row['user_email'], $row['username']);

$messenger->im($row['user_jabber'], $row['username']);

$messenger->assign_vars(array(

'USERNAME' => htmlspecialchars_decode($row['username']),

$default_lang_id = (int) $db->sql_fetchfield('lang_id');

$db->sql_freeresult($result);

// From the mysql documentation:

// Prior to MySQL 4.0.14, the target table of the INSERT statement cannot appear in the FROM clause of the SELECT part of the query. This limitation is lifted in 4.0.14.

// Due to this we stay on the safe side if we do the insertion "the manual way"

{

$row['lang_id'] = $lang_id;

$db->sql_query('INSERT INTO ' . PROFILE_LANG_TABLE . ' ' . $db->sql_build_array('INSERT', $row));

}

$db->sql_freeresult($result);

{

$row['lang_id'] = $lang_id;

$db->sql_query('INSERT INTO ' . PROFILE_FIELDS_LANG_TABLE . ' ' . $db->sql_build_array('INSERT', $row));

}

$db->sql_freeresult($result);

add_log('admin', 'LOG_LANGUAGE_PACK_INSTALLED', $lang_pack['name']);

break;

$template->assign_var('S_WRITABLE_CONFIG', (bool) (@fileperms($phpbb_root_path . 'config.' . $phpEx) & 0x0002));

}

// Fill dbms version if not yet filled

if (empty($config['dbms_version']))

{

'RANK_TITLE' => (isset($ranks['rank_title'])) ? $ranks['rank_title'] : '',

'S_FILENAME_LIST' => $filename_list,

'RANK_IMAGE' => ($edit_img) ? $phpbb_root_path . $config['ranks_path'] . '/' . $edit_img : $phpbb_admin_path . 'images/spacer.gif',

'MIN_POSTS' => (isset($ranks['rank_min']) && !$ranks['rank_special']) ? $ranks['rank_min'] : 0)

);

$errstr = '';

$errno = 0;

if ($info === false)

{

$messenger->to($user_row['user_email'], $user_row['username']);

$messenger->assign_vars(array(

'WELCOME_MSG' => htmlspecialchars_decode(sprintf($user->lang['WELCOME_SUBJECT'], $config['sitename'])),

$messenger->to($user_row['user_email'], $user_row['username']);

$messenger->assign_vars(array(

'USERNAME' => htmlspecialchars_decode($user_row['username']))

// Which updates do we need to do?

$update_username = ($user_row['username'] != $data['username']) ? $data['username'] : false;

$update_email = ($data['email'] != $user_row['user_email']) ? $data['email'] : false;

if (!sizeof($error))

if (!$row)

{

return array(

'status' => LOGIN_ERROR_USERNAME,

'error_msg' => 'LOGIN_ERROR_USERNAME',

);

}

*/

// phpBB Version

// QA-related

// define('PHPBB_QA', 1);

}

/**

* Check if table exists

*

*

}

/**

*

*

*/

{

switch ($this->sql_layer)

{

case 'mysql_40':

case 'mysql_41':

$sql = "SHOW COLUMNS FROM $table";

break;

// PostgreSQL has a way of doing this in a much simpler way but would

WHERE c.relname = '{$table}'

AND a.attnum > 0

AND a.attrelid = c.oid";

break;

// same deal with PostgreSQL, we must perform more complex operations than

FROM syscolumns c

LEFT JOIN sysobjects o ON c.id = o.id

WHERE o.name = '{$table}'";

break;

case 'oracle':

$sql = "SELECT column_name

FROM user_tab_columns

WHERE LOWER(table_name) = '" . strtolower($table) . "'";

break;

case 'firebird':

$sql = "SELECT RDB\$FIELD_NAME as FNAME

FROM RDB\$RELATION_FIELDS

WHERE RDB\$RELATION_NAME = '" . strtoupper($table) . "'";

break;

case 'sqlite':

$sql = "SELECT sql

FROM sqlite_master

WHERE type = 'table'

AND name = '{$table}'";

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

if (!$result)

continue;

}

}

break;

}

}

/**

break;

case 'oracle':

break;

case 'postgres':

$statements[] = "DROP SEQUENCE {$row['referenced_name']}";

}

$this->db->sql_freeresult($result);

case 'postgres':

// PGSQL does not "tightly" bind sequences and tables, we must guess...

case 'mysql_40':

case 'mysql_41':

break;

case 'mssql':

}

// no break

case 'mysql_41':

break;

case 'mssql':

}

}

if (!empty($array['LEFT_JOIN']))

{

*/

function sql_affectedrows()

{

}

/**

return $cache->sql_fetchrow($query_id);

}

}

/**

{

$text .= "<br />\n";

}

list($errno, $msg_text, $errfile, $errline) = $error;

}

return $text;

}

}

*/

function update_forum_tracking_info($forum_id, $forum_last_post_time, $f_mark_time = false, $mark_time_forum = false)

{

// Determine the users last forum mark time if not given.

if ($mark_time_forum === false)

}

}

// Check the forum for any left unread topics.

// If there are none, we mark the forum as read.

if ($config['load_db_lastread'] && $user->data['is_registered'])

LEFT JOIN ' . TOPICS_TRACK_TABLE . ' tt ON (tt.topic_id = t.topic_id AND tt.user_id = ' . $user->data['user_id'] . ')

WHERE t.forum_id = ' . $forum_id . '

AND t.topic_last_post_time > ' . $mark_time_forum . '

AND (tt.topic_id IS NULL OR tt.mark_time < t.topic_last_post_time)

GROUP BY t.forum_id';

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

}

else

{

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

$check_forum = $tracking_topics['tf'][$forum_id];

$start_cnt = min(max(1, $on_page - 4), $total_pages - 5);

$end_cnt = max(min($total_pages, $on_page + 4), 6);

for ($i = $start_cnt + 1; $i < $end_cnt; $i++)

{

}

}

}

else

{

{

global $_SID, $_EXTRA_URL, $phpbb_hook;

// Developers using the hook function need to globalise the $_SID and $_EXTRA_URL on their own and also handle it appropriately.

// They could mimic most of what is within this function

if (!empty($phpbb_hook) && $phpbb_hook->call_hook(__FUNCTION__, $url, $params, $is_amp, $session_id))

}

/**

*/

function get_backtrace()

{

$output = '<div style="font-family: monospace;">';

$backtrace = debug_backtrace();

// Strip the current directory from path

{

}

$trace['class'] = (!isset($trace['class'])) ? '' : $trace['class'];

$trace['type'] = (!isset($trace['type'])) ? '' : $trace['type'];

$output .= '<br />';

$output .= '<b>LINE:</b> ' . ((!empty($trace['line'])) ? $trace['line'] : '') . '<br />';

}

$output .= '</div>';

return $output;

$inline = ($mode == 'relative_url') ? ')' : '';

return "(?:[a-z0-9\-._~!$&'($inline*+,;=:@|]+|%[\dA-F]{2})*(?:/(?:[a-z0-9\-._~!$&'($inline*+,;=:@|]+|%[\dA-F]{2})*)*(?:\?(?:[a-z0-9\-._~!$&'($inline*+,;=:@/?|]+|%[\dA-F]{2})*)?(?:\#(?:[a-z0-9\-._~!$&'($inline*+,;=:@/?|]+|%[\dA-F]{2})*)?";

break;

}

return '';

if (strpos($errfile, 'cache') === false && strpos($errfile, 'template.') === false)

{

$error_name = ($errno === E_WARNING) ? 'PHP Warning' : 'PHP Notice';

echo '<b>[phpBB Debug] ' . $error_name . '</b>: in file <b>' . $errfile . '</b> on line <b>' . $errline . '</b>: <b>' . $msg_text . '</b><br />' . "\n";

}

/**

* Queries the session table to get information about online guests

* @param int $item_id Limits the search to the item with this id

* @param string $item The name of the item which is stored in the session table as session_{$item}_id

$db->sql_freeresult($result);

}

{

// Save the queries, because there are no logs to display

return 0;

/**

* Retrieve contents from remotely stored file

*/

{

global $user;

@fputs($fsock, "HOST: $host\r\n");

@fputs($fsock, "Connection: close\r\n\r\n");

$file_info = '';

$get_info = false;

return false;

}

}

}

@fclose($fsock);

}

'S_NO_CAT' => $catless && !$last_catless,

'S_IS_LINK' => ($row['forum_type'] == FORUM_LINK) ? true : false,

'S_UNREAD_FORUM' => $forum_unread,

'S_LOCKED_FORUM' => ($row['forum_status'] == ITEM_LOCKED) ? true : false,

'S_LIST_SUBFORUMS' => ($row['display_subforum_list']) ? true : false,

'S_SUBFORUMS' => (sizeof($subforums_list)) ? true : false,

$pagination .= '<a href="' . $url . ($j == 0 ? '' : '&amp;start=' . $j) . '">' . $times . '</a>';

if ($times == 1 && $total_pages > 5)

{

// Display the last three pages

$times = $total_pages - 3;

$match_id = ($mode == 'forum') ? $forum_id : $topic_id;

$u_url = "uid={$user->data['user_id']}";

$u_url .= ($mode == 'forum') ? '&amp;f' : '&amp;f=' . $forum_id . '&amp;t';

// Is user watching this thread?

if ($user_id != ANONYMOUS)

$uid = request_var('uid', 0);

$token = request_var('hash', '');

{

{

$redirect_url = append_sid("{$phpbb_root_path}view$mode.$phpEx", "$u_url=$match_id&amp;start=$start");

$message = $user->lang['ERR_UNWATCHING'] . '<br /><br />' . sprintf($user->lang['RETURN_' . strtoupper($mode)], '<a href="' . $redirect_url . '">', '</a>');

$db->sql_query($sql);

$redirect_url = append_sid("{$phpbb_root_path}view$mode.$phpEx", "$u_url=$match_id&amp;start=$start");

meta_refresh(3, $redirect_url);

trigger_error($message);

}

$s_hidden_fields['t'] = $topic_id;

}

confirm_box(false, $confirm_box_message, build_hidden_fields($s_hidden_fields));

}

}

$uid = request_var('uid', 0);

$token = request_var('hash', '');

{

{

$redirect_url = append_sid("{$phpbb_root_path}view$mode.$phpEx", "$u_url=$match_id&amp;start=$start");

$message = $user->lang['ERR_WATCHING'] . '<br /><br />' . sprintf($user->lang['RETURN_' . strtoupper($mode)], '<a href="' . $redirect_url . '">', '</a>');

/**

* Get tables of a database

*/

{

{

}

}

/**

}

/**

* Set the email priority

*/

function set_mail_priority($priority = MAIL_NORMAL_PRIORITY)

$smtp->add_backtrace('Connecting to ' . $config['smtp_host'] . ':' . $config['smtp_port']);

// Ok we have error checked as much as we can to this point let's get on it already.

$smtp->socket = fsockopen($config['smtp_host'], $config['smtp_port'], $errno, $errstr, 20);

if (!$smtp->socket)

{

*/

function phpbb_mail($to, $subject, $msg, $headers, $eol, &$err_msg)

{

// We use the EOL character for the OS here because the PHP mail function does not correctly transform line endings. On Windows SMTP is used (SMTP is \r\n), on UNIX a command is used...

// Reference: http://bugs.php.net/bug.php?id=15841

$headers = implode($eol, $headers);

// On some PHP Versions mail() *may* fail if there are newlines within the subject.

// Newlines are used as a delimiter for lines in mail_encode() according to RFC 2045 section 6.8.

// Because PHP can't decide what is wanted we revert back to the non-RFC-compliant way of separating by one space (Use '' as parameter to mail_encode() results in SPACE used)

$result = $config['email_function_name']($to, mail_encode($subject, ''), wordwrap(utf8_wordwrap($msg), 997, "\n", true), $headers);

return $result;

}

case 'edit_topic':

case 'edit_first_post':

{

$poll_length = $poll['poll_length'] * 86400;

if ($poll_length < 0)

{

}

// Update Poll Tables

{

$cur_poll_options = array();

{

$sql = 'SELECT *

FROM ' . POLL_OPTIONS_TABLE . '

// Send Notifications

if ($mode != 'edit')

{

}

return $data['msg_id'];

/**

* PM Notification

*/

{

global $db, $user, $config, $phpbb_root_path, $phpEx, $auth;

'AUTHOR_NAME' => htmlspecialchars_decode($author),

'USERNAME' => htmlspecialchars_decode($addr['name']),

$messenger->send($addr['method']);

}

{

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

switch ($action)

{

case 'make_announce':

default:

$new_topic_type = POST_NORMAL;

$l_new_type = (sizeof($topic_ids) == 1) ? 'MCP_MAKE_NORMAL' : 'MCP_MAKE_NORMALS';

break;

}

$redirect = request_var('redirect', build_url(array('action', 'quickmod')));

$s_hidden_fields = array(

}

// Get Reports

{

$sql = 'SELECT r.*, re.*, u.user_id, u.username

FROM ' . REPORTS_TABLE . ' r, ' . USERS_TABLE . ' u, ' . REPORTS_REASONS_TABLE . " re

'POST_IP' => $post_info['poster_ip'],

'POST_IPADDR' => ($auth->acl_get('m_info', $post_info['forum_id']) && request_var('lookup', '')) ? @gethostbyaddr($post_info['poster_ip']) : '',

'POST_ID' => $post_info['post_id'],

'U_LOOKUP_IP' => ($auth->acl_get('m_info', $post_info['forum_id'])) ? append_sid("{$phpbb_root_path}mcp.$phpEx", 'i=queue&amp;mode=approve_details&amp;f=' . $post_info['forum_id'] . '&amp;p=' . $post_id . '&amp;lookup=' . $post_info['poster_ip']) . '#ip' : '',

));

if (!$row || (!$reason && strtolower($row['reason_title']) == 'other'))

{

$additional_msg = $user->lang['NO_REASON_DISAPPROVAL'];

unset($_POST['confirm']);

}

else

$message = bbcode_nl2br($message);

$message = smiley_text($message);

if ($post_info['post_attachment'] && $auth->acl_get('u_download') && $auth->acl_get('f_download', $post_info['forum_id']))

{

'MINI_POST_IMG' => ($post_unread) ? $user->img('icon_post_target_unread', 'UNREAD_POST') : $user->img('icon_post_target', 'POST'),

'S_CHECKED' => (($submitted_id_list && !in_array(intval($row['post_id']), $submitted_id_list)) || in_array(intval($row['post_id']), $checked_ids)) ? true : false,

'S_HAS_ATTACHMENTS' => (!empty($attachments[$row['post_id']])) ? true : false,

unset($input);

}

{

/**

* @ignore

$messenger->to($user_row['user_email'], $user_row['username']);

$messenger->assign_vars(array(

'USERNAME' => htmlspecialchars_decode($user_row['username']))

if ($group_row[$group_id]['group_type'] == GROUP_FREE)

{

group_user_add($group_id, $user->data['user_id']);

}

else

{

group_user_add($group_id, $user->data['user_id'], false, false, false, 0, 1);

}

add_log('user', $user->data['user_id'], 'LOG_USER_GROUP_JOIN' . (($group_row[$group_id]['group_type'] == GROUP_FREE) ? '' : '_PENDING'), $group_row[$group_id]['group_name']);

$num_not_moved = $num_removed = 0;

$release = request_var('release', 0);

{

$return = place_pm_into_folder($global_privmsgs_rules, $release);

$num_not_moved = $return['not_moved'];

'U_PM' => ($config['allow_privmsg'] && $auth->acl_get('u_sendpm') && ($user_info['user_allow_pm'] || $auth->acl_gets('a_', 'm_') || $auth->acl_getf_global('m_'))) ? append_sid("{$phpbb_root_path}ucp.$phpEx", 'i=pm&amp;mode=compose&amp;u=' . $author_id) : '',

'U_WWW' => (!empty($user_info['user_website'])) ? $user_info['user_website'] : '',

'U_AIM' => ($user_info['user_aim'] && $auth->acl_get('u_sendim')) ? append_sid("{$phpbb_root_path}memberlist.$phpEx", 'mode=contact&amp;action=aim&amp;u=' . $author_id) : '',

'U_YIM' => ($user_info['user_yim']) ? 'http://edit.yahoo.com/config/send_webmesg?.target=' . urlencode($user_info['user_yim']) . '&amp;.src=pg' : '',

'U_MSN' => ($user_info['user_msnm'] && $auth->acl_get('u_sendim')) ? append_sid("{$phpbb_root_path}memberlist.$phpEx", 'mode=contact&amp;action=msnm&amp;u=' . $author_id) : '',

$error = validate_data($data, $check_ary);

{

}

{

}

// Only check the new password against the previous password if there have been no errors

$error[] = 'SAME_PASSWORD_ERROR';

}

{

}

if (!check_form_key('ucp_reg_details'))

$messenger->to($data['email'], $data['username']);

$messenger->assign_vars(array(

'USERNAME' => htmlspecialchars_decode($data['username']),

$this->tpl_name = 'ucp_agreement';

return;

}

// The CAPTCHA kicks in here. We can't help that the information gets lost on language change.

if ($config['enable_confirm'])

{

$messenger->to($data['email'], $data['username']);

$messenger->assign_vars(array(

'WELCOME_MSG' => htmlspecialchars_decode(sprintf($user->lang['WELCOME_SUBJECT'], $config['sitename'])),

$messenger->template(($coppa) ? 'coppa_resend_inactive' : 'user_resend_inactive', $user_row['user_lang']);

$messenger->to($user_row['user_email'], $user_row['username']);

$messenger->assign_vars(array(

'WELCOME_MSG' => htmlspecialchars_decode(sprintf($user->lang['WELCOME_SUBJECT'], $config['sitename'])),

$messenger->to($row['user_email'], $row['username']);

$messenger->im($row['user_jabber'], $row['username']);

$messenger->assign_vars(array(

'USERNAME' => htmlspecialchars_decode($user_row['username']),

$convertor_data = array(

'forum_name' => 'phpBB 2.0.x',

'version' => '1.0.3',

'author' => '<a href="http://www.phpbb.com/">phpBB Group</a>',

'dbms' => $dbms,

'dbhost' => $dbhost,

array('topic_type', 'topics.topic_type', 'phpbb_convert_topic_type'),

array('topic_first_post_id', 'topics.topic_first_post_id', ''),

array('topic_last_view_time', 'posts.post_time', 'intval'),

array('poll_start', 'vote_desc.vote_start', 'null_to_zero'),

array('poll_length', 'vote_desc.vote_length', 'null_to_zero'),

array('poll_max_options', 1, ''),

array('topic_type', 'topics.topic_type', 'phpbb_convert_topic_type'),

array('topic_first_post_id', 'topics.topic_first_post_id', ''),

array('poll_start', 'vote_desc.vote_start', 'null_to_zero'),

array('poll_length', 'vote_desc.vote_length', 'null_to_zero'),

array('poll_max_options', 1, ''),

array('poll_option_id', 'vote_results.vote_option_id', ''),

array('topic_id', 'vote_desc.topic_id', ''),

array('', 'topics.topic_poster AS poster_id', 'phpbb_user_id'),

array('poll_option_total', 'vote_results.vote_result', ''),

'where' => 'vote_results.vote_id = vote_desc.vote_id',

*

*/

// Enter any version to update from to test updates. The version within the db will not be updated.

define('DEBUG_FROM_VERSION', false);

// this column was removed from the database updater

// after 3.0.9-RC3 was released. It might still exist

// in 3.0.9-RCX installations and has to be dropped in

// removing a primary key.

// 'attempt_id' => array('UINT', NULL, 'auto_increment'),

'attempt_ip' => array('VCHAR:40', ''),

'3.0.9-RC3' => array(),

// No changes from 3.0.9-RC4 to 3.0.9

'3.0.9-RC4' => array(),

);

}

// No changes from 3.0.9-RC4 to 3.0.9

case '3.0.9-RC4':

break;

}

}

fix_empty_primary_groups();

}

update_dynamic_config();

$error[] = $lang['INST_ERR_NO_DB'];

$connect_test = false;

}

else

{

$connect_test = connect_check_db(true, $error, $available_dbms[$data['dbms']], $data['table_prefix'], $data['dbhost'], $data['dbuser'], htmlspecialchars_decode($data['dbpasswd']), $data['dbname'], $data['dbport']);

$messenger->to($data['board_email1'], $data['admin_name']);

$messenger->assign_vars(array(

'USERNAME' => htmlspecialchars_decode($data['admin_name']),

'dbname' => array('lang' => 'DB_NAME', 'type' => 'text:25:100', 'explain' => false),

'dbuser' => array('lang' => 'DB_USERNAME', 'type' => 'text:25:100', 'explain' => false),

'dbpasswd' => array('lang' => 'DB_PASSWORD', 'type' => 'password:25:100', 'explain' => false),

);

var $admin_config_options = array(

'legend1' => 'ADMIN_CONFIG',

#

# Table: 'phpbb_attachments'

CREATE TABLE phpbb_attachments (

/*

/*

Table: 'phpbb_attachments'

#

# Table: 'phpbb_attachments'

CREATE TABLE phpbb_attachments (

attach_id mediumint(8) UNSIGNED NOT NULL auto_increment,

#

# Table: 'phpbb_attachments'

CREATE TABLE phpbb_attachments (

attach_id mediumint(8) UNSIGNED NOT NULL auto_increment,

/*

/*

This first section is optional, however its probably the best method

/*

BEGIN;

INSERT INTO phpbb_config (config_name, config_value) VALUES ('email_check_mx', '1');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('email_enable', '1');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('email_function_name', 'mail');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('email_package_size', '20');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('enable_confirm', '1');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('enable_pm_icons', '1');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('tpl_allow_php', '0');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('upload_icons_path', 'images/upload_icons');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('upload_path', 'files');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('warnings_expire_days', '90');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('warnings_gc', '14400');

#

BEGIN TRANSACTION;

# Table: 'phpbb_attachments'

'LENGTH_BAN_INVALID' => 'The date has to be formatted <kbd>YYYY-MM-DD</kbd>.',

'PERMANENT' => 'Permanent',

'UNTIL' => 'Until',

'MAX_POST_URLS' => 'Maximum links per post',

'MAX_POST_URLS_EXPLAIN' => 'Maximum number of URLs in a post. Set to 0 for unlimited links.',

'MIN_CHAR_LIMIT' => 'Minimum characters per post/message',

'POSTING' => 'Posting',

'POSTS_PER_PAGE' => 'Posts per page',

'QUOTE_DEPTH_LIMIT' => 'Maximum nesting depth for quotes',

'DATABASE_SERVER_INFO' => 'Database server',

'DATABASE_SIZE' => 'Database size',

'FILES_PER_DAY' => 'Attachments per day',

'FORUM_STATS' => 'Board statistics',

'RESTORE_FAILURE' => 'The backup file may be corrupt.',

'RESTORE_OPTIONS' => 'Restore options',

'RESTORE_SUCCESS' => 'The database has been successfully restored.<br /><br />Your board should be back to the state it was when the backup was made.',

'SELECT_ALL' => 'Select all',

'ENABLE_TOPIC_ICONS' => 'Enable topic icons',

'FORUM_ADMIN' => 'Forum administration',

'FORUM_AUTO_PRUNE' => 'Enable auto-pruning',

'FORUM_AUTO_PRUNE_EXPLAIN' => 'Prunes the forum of topics, set the frequency/age parameters below.',

'FORUM_CREATED' => 'Forum created successfully.',

'LANGUAGE_PACK_DELETED' => 'The language pack <strong>%s</strong> has been removed successfully. All users using this language have been reset to the boards default language.',

'LANGUAGE_PACK_DETAILS' => 'Language pack details',

'LANGUAGE_PACK_INSTALLED' => 'The language pack <strong>%s</strong> has been successfully installed.',

'LANGUAGE_PACK_ISO' => 'ISO',

'LANGUAGE_PACK_LOCALNAME' => 'Local name',

'LANGUAGE_PACK_NAME' => 'Name',

'EMPTY_MESSAGE_SUBJECT' => 'You must specify a subject when composing a new message.',

'ENABLED' => 'Enabled',

'ENCLOSURE' => 'Enclosure',

'ERR_CHANGING_DIRECTORY' => 'Unable to change directory.',

'ERR_CONNECTING_SERVER' => 'Error connecting to the server.',

'ERR_JAB_AUTH' => 'Could not authorise on Jabber server.',

'FORUM_RULES_LINK' => 'Please click here to view the forum rules',

'FROM' => 'from',

'FSOCK_DISABLED' => 'The operation could not be completed because the <var>fsockopen</var> function has been disabled or the server being queried could not be found.',

'FTP_FSOCK_HOST' => 'FTP host',

'FTP_FSOCK_HOST_EXPLAIN' => 'FTP server used to connect your site.',

Hello {USERNAME},

Your password has been securely stored in our database and cannot be retrieved. In the event that it is forgotten, you will be able to reset it using the email address associated with your account.

You can view your new message by clicking on the following link:

You have requested that you be notified on this event, remember that you can always choose not to be notified of new messages by changing the appropriate setting in your profile.

),

array(

0 => 'I registered in the past but cannot login any more?!',

),

array(

0 => 'What is COPPA?',

'DLL_MYSQL' => 'MySQL',

'DLL_MYSQLI' => 'MySQL with MySQLi Extension',

'DLL_ORACLE' => 'Oracle',

'DLL_SQLITE' => 'SQLite',

'DLL_XML' => 'XML support [ Jabber ]',

'DLL_ZLIB' => 'zlib compression support [ gz, .tar.gz, .zip ]',

'INST_ERR' => 'Installation error',

'INST_ERR_DB_CONNECT' => 'Could not connect to the database, see error message below.',

'INST_ERR_DB_FORUM_PATH' => 'The database file specified is within your board directory tree. You should put this file in a non web-accessible location.',

'INST_ERR_DB_NO_ERROR' => 'No error message given.',

'INST_ERR_DB_NO_MYSQLI' => 'The version of MySQL installed on this machine is incompatible with the “MySQL with MySQLi Extension” option you have selected. Please try the “MySQL” option instead.',

'INST_ERR_DB_NO_SQLITE' => 'The version of the SQLite extension you have installed is too old, it must be upgraded to at least 2.8.2.',

'TABLES_MISSING' => 'Could not find these tables<br />» <strong>%s</strong>.',

'TABLE_PREFIX' => 'Prefix for tables in database',

'TABLE_PREFIX_SAME' => 'The table prefix needs to be the one used by the software you are converting from.<br />» Specified table prefix was %s.',

'TESTS_PASSED' => 'Tests passed',

'TESTS_FAILED' => 'Tests failed',

'CURRENT_IMAGE' => 'Current image',

'CURRENT_PASSWORD' => 'Current password',

'CURRENT_PASSWORD_EXPLAIN' => 'You must confirm your current password if you wish to change it, alter your e-mail address or username.',

'CUR_PASSWORD_ERROR' => 'The current password you entered is incorrect.',

'CUSTOM_DATEFORMAT' => 'Custom…',

'MOVE_TO_FOLDER' => 'Move to folder',

'MOVE_UP' => 'Move up',

'NEW_EMAIL_ERROR' => 'The e-mail addresses you entered do not match.',

'NEW_FOLDER_NAME' => 'New folder name',

'NEW_PASSWORD' => 'New password',

'NEW_PASSWORD_ERROR' => 'The passwords you entered do not match.',

'NOTIFY_METHOD' => 'Notification method',

'NOTIFY_METHOD_BOTH' => 'Both',

$notify_type = NOTIFY_EMAIL;

}

$messenger->assign_vars(array(

'BOARD_CONTACT' => $config['board_contact'],

$message_parser->parse_poll($poll);

$post_data['poll_title'] = (isset($poll['poll_title'])) ? $poll['poll_title'] : '';

/* We reset votes, therefore also allow removing options

$message_parser->warn_msg[] = $user->lang['NO_DELETE_POLL_OPTIONS'];

}*/

}

else if (!$auth->acl_get('f_poll', $forum_id) && ($mode == 'edit') && ($post_id == $post_data['topic_first_post_id']) && ($original_poll_data['poll_title'] != ''))

{

// We have a poll but the editing user is not permitted to create/edit it.

$message_parser->parse_poll($poll);

$post_data['poll_title'] = (isset($poll['poll_title'])) ? $poll['poll_title'] : '';

}

else

# General Information about this style

name = prosilver

copyright = &copy; phpBB Group, 2007

# Images

img_site_logo = site_logo.gif*52*139

# General Information about this style

name = prosilver

copyright = &copy; phpBB Group, 2007

/**

* Fix a bug involving the TextRange object. From

* http://www.frostjedi.com/terra/scripts/demo/caretBug.html

{

var doc;

{

doc = document;

}

{

doc = opener.document;

}

* bbstyle

*/

function bbstyle(bbnumber)

if (bbnumber != -1)

{

bbfontstyle(bbtags[bbnumber], bbtags[bbnumber+1]);

{

insert_text('[*]');

document.forms[form_name].elements[text_name].focus();

if ((clientVer >= 4) && is_ie && is_win)

{

// Get text selection

{

return;

}

}

theSelection = '';

return;

}

//The new position for the cursor after adding the bbcode

var caret_pos = getCaretPosition(textarea).start;

// Open tag

insert_text(bbopen + bbclose);

{

textarea.selectionStart = new_pos;

textarea.selectionEnd = new_pos;

// IE

else if (document.selection)

{

range.select();

storeCaret(textarea);

}

function insert_text(text, spaces, popup)

{

var textarea;

{

textarea = document.forms[form_name].elements[text_name];

{

textarea = opener.document.forms[form_name].elements[text_name];

}

{

text = ' ' + text + ' ';

}

}

else if (textarea.createTextRange && textarea.caretPos)

{

{

textarea.focus();

storeCaret(textarea);

{

textarea.value = textarea.value + text;

}

{

textarea.focus();

}

do

{

var splitAt = line.indexOf(' ', 80);

if (splitAt == -1)

{

splitLines[j] = line;

var selEnd = txtarea.selectionEnd;

var scrollTop = txtarea.scrollTop;

{

selEnd = selLength;

}

*/

function storeCaret(textEl)

{

{

textEl.caretPos = document.selection.createRange().duplicate();

}

{

document.writeln('<tr>');

}

for (b = 0; b < 5; b++)

{

color = String(numberList[r]) + String(numberList[g]) + String(numberList[b]);

function getCaretPosition(txtarea)

{

var caretPos = new caretPosition();

// simple Gecko/Opera way

{

caretPos.start = txtarea.selectionStart;

caretPos.end = txtarea.selectionEnd;

}

// dirty and slow IE way

{

// get current selection

var range = document.selection.createRange();

// a new selection of the whole textarea

var range_all = document.body.createTextRange();

range_all.moveToElementText(txtarea);

// calculate selection start point by moving beginning of range_all to beginning of range

var sel_start;

for (sel_start = 0; range_all.compareEndPoints('StartToStart', range) < 0; sel_start++)

range_all.moveStart('character', 1);

}

txtarea.sel_start = sel_start;

// we ignore the end value for IE, this is already dirty enough and we don't need it

caretPos.start = txtarea.sel_start;

}

return caretPos;

<div class="forabg">

<div class="inner"><span class="corners-top"><span></span></span>

<ul class="topiclist">

<dl class="icon">

<dd class="topics">{L_TOPICS}</dd>

<dd class="posts">{L_POSTS}</dd>

<dd class="lastpost"><span>{L_LAST_POST}</span></dd>

<!-- IF not forumrow.S_IS_CAT -->

<li class="row">

<!-- IF S_ENABLE_FEEDS and forumrow.S_FEED_ENABLED --><!-- <a class="feed-icon-forum" title="{L_FEED} - {forumrow.FORUM_NAME}" href="{U_FEED}?f={forumrow.FORUM_ID}"><img src="{T_THEME_PATH}/images/feed.gif" alt="{L_FEED} - {forumrow.FORUM_NAME}" /></a> --><!-- ENDIF -->

<!-- IF forumrow.FORUM_IMAGE --><span class="forum-image">{forumrow.FORUM_IMAGE}</span><!-- ENDIF -->

<br /><strong>{forumrow.L_MODERATOR_STR}:</strong> {forumrow.MODERATORS}

<!-- ENDIF -->

<!-- IF forumrow.SUBFORUMS and forumrow.S_LIST_SUBFORUMS --><br /><strong>{forumrow.L_SUBFORUM_STR}</strong> {forumrow.SUBFORUMS}<!-- ENDIF -->

<!-- IF forumrow.CLICKS -->

<dd class="redirect"><span>{L_REDIRECTS}: {forumrow.CLICKS}</span></dd>

<!-- ELSEIF not forumrow.S_IS_LINK -->

<div class="content">

<h2>{MESSAGE_TITLE}</h2>

<fieldset>

<!-- IF S_NOTIFY_POSTER -->

<td style="text-align: center">{usernotes.REPORT_AT}</td>

<td>{usernotes.ACTION}</td>

</tr>

<!-- BEGINELSE -->

<tr>

<p class="rules">

<input class="button2" type="submit" value="{L_DISAPPROVE}" name="action[disapprove]" /> &nbsp;

<input class="button1" type="submit" value="{L_APPROVE}" name="action[approve]" />

<input type="hidden" name="post_id_list[]" value="{POST_ID}" />

{S_FORM_TOKEN}

</p>

<div class="panel" id="message">

<div class="inner"><span class="corners-top"><span></span></span>

<span class="corners-bottom"><span></span></span></div>

</div>

<div class="inner"><span class="corners-top"><span></span></span>

<ul class="topiclist">

<li class="header">

<dd class="posts">{L_REPLIES}</dd>

<dd class="views">{L_VIEWS}</dd>

<dd class="lastpost"><span>{L_LAST_POST}</span></dd>

<!-- BEGIN searchresults -->

<li class="row<!-- IF searchresults.S_ROW_COUNT is even --> bg1<!-- ELSE --> bg2<!-- ENDIF -->">

<!-- IF searchresults.S_UNREAD_TOPIC --><a href="{searchresults.U_NEWEST_POST}">{NEWEST_POST_IMG}</a> <!-- ENDIF -->

<a href="{searchresults.U_VIEW_TOPIC}" class="topictitle">{searchresults.TOPIC_TITLE}</a> {searchresults.ATTACH_ICON_IMG}

<!-- IF searchresults.S_TOPIC_UNAPPROVED or searchresults.S_POSTS_UNAPPROVED --><a href="{searchresults.U_MCP_QUEUE}">{searchresults.UNAPPROVED_IMG}</a> <!-- ENDIF -->

<!-- IF searchresults.PAGINATION --><strong class="pagination"><span>{searchresults.PAGINATION}</span></strong><!-- ENDIF -->

{L_POST_BY_AUTHOR} {searchresults.TOPIC_AUTHOR_FULL} &raquo; {searchresults.FIRST_POST_TIME}

<!-- IF not searchresults.S_TOPIC_GLOBAL -->{L_IN} <a href="{searchresults.U_VIEW_FORUM}">{searchresults.FORUM_TITLE}</a><!-- ELSE --> ({L_GLOBAL})<!-- ENDIF -->

<dd class="posts">{searchresults.TOPIC_REPLIES}</dd>

<dd class="views">{searchresults.TOPIC_VIEWS}</dd>

<dd class="lastpost"><span>

# General Information about this template

name = prosilver

copyright = &copy; phpBB Group, 2007

# Defining a different template bitfield

template_bitfield = lNg=

<ul class="topiclist">

<li class="header">

<dl>

<dd class="extra"><a href="{U_SORT_DOWNLOADS}">{L_DOWNLOADS}</a></dd>

<dd class="time"><span><a href="{U_SORT_POST_TIME}">{L_POST_TIME}</a></span></dd>

<dd class="mark">{L_MARK}</dd>

<!-- BEGIN attachrow -->

<li class="row<!-- IF attachrow.S_ROW_COUNT is odd --> bg1<!-- ELSE --> bg2<!-- ENDIF -->">

<dl>

<!-- IF attachrow.S_IN_MESSAGE -->{L_PM}: <!-- ELSE -->{L_TOPIC}: <!-- ENDIF --><a href="{attachrow.U_VIEW_TOPIC}">{attachrow.TOPIC_TITLE}</a></dt>

<dd class="extra">{attachrow.DOWNLOAD_COUNT}</dd>

<dd class="time"><span>{attachrow.POST_TIME}</span></dd>

</tr>

<!-- ENDIF -->

<!-- BEGINELSE -->

<tr>

</tr>

<!-- END member -->

</tbody>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">

<html xmlns="http://www.w3.org/1999/xhtml" dir="{S_CONTENT_DIRECTION}" lang="{S_USER_LANG}" xml:lang="{S_USER_LANG}">

<head>

<meta http-equiv="content-type" content="text/html; charset={S_CONTENT_ENCODING}" />

<meta http-equiv="content-style-type" content="text/css" />

<meta http-equiv="content-language" content="{S_USER_LANG}" />

</head>

</body>

</html> \ No newline at end of file

<div class="inner"><span class="corners-top"><span></span></span>

<ul class="topiclist">

<li class="header">

<dd class="posts">{L_REPLIES}</dd>

<dd class="views">{L_VIEWS}</dd>

<dd class="lastpost"><span>{L_LAST_POST}</span></dd>

<!-- ENDIF -->

<li class="row<!-- IF topicrow.S_ROW_COUNT is even --> bg1<!-- ELSE --> bg2<!-- ENDIF --><!-- IF topicrow.S_POST_GLOBAL --> global-announce<!-- ENDIF --><!-- IF topicrow.S_POST_ANNOUNCE --> announce<!-- ENDIF --><!-- IF topicrow.S_POST_STICKY --> sticky<!-- ENDIF --><!-- IF topicrow.S_TOPIC_REPORTED --> reported<!-- ENDIF -->">

<!-- IF topicrow.S_TOPIC_UNAPPROVED or topicrow.S_POSTS_UNAPPROVED --><a href="{topicrow.U_MCP_QUEUE}">{topicrow.UNAPPROVED_IMG}</a> <!-- ENDIF -->

<!-- IF topicrow.S_TOPIC_REPORTED --><a href="{topicrow.U_MCP_REPORT}">{REPORTED_IMG}</a><!-- ENDIF --><br />

<!-- IF topicrow.PAGINATION --><strong class="pagination"><span>{topicrow.PAGINATION}</span></strong><!-- ENDIF -->

<!-- IF topicrow.ATTACH_ICON_IMG -->{topicrow.ATTACH_ICON_IMG} <!-- ENDIF -->{L_POST_BY_AUTHOR} {topicrow.TOPIC_AUTHOR_FULL} &raquo; {topicrow.FIRST_POST_TIME}

<dd class="posts">{topicrow.REPLIES} <dfn>{L_REPLIES}</dfn></dd>

<dd class="views">{topicrow.VIEWS} <dfn>{L_VIEWS}</dfn></dd>

<dd class="lastpost"><span><dfn>{L_LAST_POST} </dfn>{L_POST_BY_AUTHOR} {topicrow.LAST_POST_AUTHOR_FULL}

<!-- NOTE: remove the style="display: none" when you want to have the forum description on the topic body -->

<!-- IF FORUM_DESC --><div style="display: none !important;">{FORUM_DESC}<br /></div><!-- ENDIF -->

<!-- ENDIF -->

<!-- IF S_FORUM_RULES -->

---------------------------------------- */

/**

/**

* cp.css

*/

---------------------------------------- */

---------------------------------------- */

/* Rollover buttons

---------------------------------------- */

* {

---------------------------------------- */

ul.topiclist {

ul.topiclist dt {

display: block;

float: left;

font-size: 1.1em;

padding-left: 5px;

padding-right: 5px;

margin-right: -465px;

}

padding-right: 465px;

}

li.header dt {

font-weight: bold;

margin-right: -465px;

}

dd.mark {

float: right !important;

text-align: center;

line-height: 200%;

font-size: 1.2em;

---------------------------------------- */

---------------------------------------- */

/* General form styles

border: 1px solid #666666;

padding: 1px;

background-color: #FAFAFA;

}

option {

---------------------------------------- */

/* Links adjustment to correctly display an order of rtl/ltr mixed content */

/* Lots still TODO here! */

--------------------------------------------------------------

--------------------------------------------------------------

*/

# General Information about this theme

name = prosilver

copyright = &copy; phpBB Group, 2007

# Some configuration options

These style definitions are mainly IE specific

tweaks required due to its poor CSS support.

# General Information about this style

name = subsilver2

copyright = &copy; phpBB Group, 2003

# Images

img_site_logo = site_logo.gif*94*170

# General Information about this style

name = subsilver2

copyright = &copy; 2005 phpBB Group

// Startup variables

var imageTag = false;

var theSelection = false;

// Check for Browser & Platform for PC & IE specific bits

// More details from: http://www.mozilla.org/docs/web-developer/sniffer/browser_type.html

var clientPC = navigator.userAgent.toLowerCase(); // Get client info

var is_ie = ((clientPC.indexOf('msie') != -1) && (clientPC.indexOf('opera') == -1));

var is_win = ((clientPC.indexOf('win') != -1) || (clientPC.indexOf('16bit') != -1));

var baseHeight;

/**

/**

* Fix a bug involving the TextRange object. From

* http://www.frostjedi.com/terra/scripts/demo/caretBug.html

{

var doc;

{

doc = document;

}

{

doc = opener.document;

}

var textarea = doc.forms[form_name].elements[text_name];

if (is_ie && typeof(baseHeight) != 'number')

textarea.focus();

baseHeight = doc.selection.createRange().duplicate().boundingHeight;

* bbstyle

*/

function bbstyle(bbnumber)

if (bbnumber != -1)

{

bbfontstyle(bbtags[bbnumber], bbtags[bbnumber+1]);

{

insert_text('[*]');

document.forms[form_name].elements[text_name].focus();

function bbfontstyle(bbopen, bbclose)

{

theSelection = false;

var textarea = document.forms[form_name].elements[text_name];

textarea.focus();

if ((clientVer >= 4) && is_ie && is_win)

{

// Get text selection

{

return;

}

}

theSelection = '';

return;

}

//The new position for the cursor after adding the bbcode

var caret_pos = getCaretPosition(textarea).start;

var new_pos = caret_pos + bbopen.length;

{

textarea.selectionStart = new_pos;

textarea.selectionEnd = new_pos;

// IE

else if (document.selection)

{

range.select();

storeCaret(textarea);

}

function insert_text(text, spaces, popup)

{

var textarea;

{

textarea = document.forms[form_name].elements[text_name];

{

textarea = opener.document.forms[form_name].elements[text_name];

}

{

text = ' ' + text + ' ';

}

mozWrap(textarea, text, '');

textarea.selectionStart = sel_start + text.length;

textarea.selectionEnd = sel_end + text.length;

else if (textarea.createTextRange && textarea.caretPos)

{

{

textarea.focus();

storeCaret(textarea);

var caret_pos = textarea.caretPos;

caret_pos.text = caret_pos.text.charAt(caret_pos.text.length - 1) == ' ' ? caret_pos.text + text + ' ' : caret_pos.text + text;

}

else

{

textarea.value = textarea.value + text;

}

{

textarea.focus();

}

/**

return;

}

function split_lines(text)

{

var lines = text.split('\n');

do

{

var splitAt = line.indexOf(' ', 80);

if (splitAt == -1)

{

splitLines[j] = line;

}

return splitLines;

}

/**

* From http://www.massless.org/mozedit/

*/

var selEnd = txtarea.selectionEnd;

var scrollTop = txtarea.scrollTop;

{

selEnd = selLength;

}

*/

function storeCaret(textEl)

{

{

textEl.caretPos = document.selection.createRange().duplicate();

}

{

document.writeln('<tr>');

}

for (b = 0; b < 5; b++)

{

color = String(numberList[r]) + String(numberList[g]) + String(numberList[b]);

function getCaretPosition(txtarea)

{

var caretPos = new caretPosition();

// simple Gecko/Opera way

{

caretPos.start = txtarea.selectionStart;

caretPos.end = txtarea.selectionEnd;

}

// dirty and slow IE way

{

// get current selection

var range = document.selection.createRange();

// a new selection of the whole textarea

var range_all = document.body.createTextRange();

range_all.moveToElementText(txtarea);

// calculate selection start point by moving beginning of range_all to beginning of range

var sel_start;

for (sel_start = 0; range_all.compareEndPoints('StartToStart', range) < 0; sel_start++)

range_all.moveStart('character', 1);

}

txtarea.sel_start = sel_start;

// we ignore the end value for IE, this is already dirty enough and we don't need it

caretPos.start = txtarea.sel_start;

caretPos.end = txtarea.sel_start;

# General Information about this template

name = subsilver2

copyright = &copy; phpBB Group, 2003

<table width="85%" cellspacing="3" cellpadding="0" border="0" align="center">

<tr>

</tr>

<tr>

<td colspan="2"><br /></td>

--------------------------------------------------------------

--------------------------------------------------------------

*/

# General Information about this theme

name = subsilver2

copyright = &copy; phpBB Group, 2003

# Some configuration options

redirect(append_sid("{$phpbb_root_path}index.$phpEx"));

}

login_box('', $user->lang['LOGIN_EXPLAIN_UCP']);

}

'is_watching' => false,

);

{

$notify_status = (isset($forum_data['notify_status'])) ? $forum_data['notify_status'] : NULL;

watch_topic_forum('forum', $s_watching_forum, $user->data['user_id'], $forum_id, 0, $notify_status, $start, $forum_data['forum_name']);

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

{

$rowset[$row['topic_id']] = $row;

$announcement_list[] = $row['topic_id'];

$topics_count = 1;

}

$template->assign_vars(array(

'PAGINATION' => generate_pagination(append_sid("{$phpbb_root_path}viewforum.$phpEx", "f=$forum_id" . ((strlen($u_sort_param)) ? "&amp;$u_sort_param" : '')), $topics_count, $config['topics_per_page'], $start),

'PAGE_NUMBER' => on_page($topics_count, $config['topics_per_page'], $start),

);

$topic_list = ($store_reverse) ? array_merge($announcement_list, array_reverse($topic_list)) : array_merge($announcement_list, $topic_list);

'is_watching' => false,

);

{

// Reset forum notification if forum notify is set

if ($config['allow_forum_notify'] && $auth->acl_get('f_subscribe', $forum_id))

$this->assertEquals($row2, $row_actual);

}

public function test_column_exists()

{

$this->assertTrue($this->tools->sql_column_exists('prefix_table_name', 'c_id'));

$this->assertFalse($this->tools->sql_column_exists('prefix_table_name', 'c_id'));

}

public function test_table_exists()

{

$this->assertTrue($this->tools->sql_table_exists('prefix_table_name'));

),

));

}

}

<table name="phpbb_users">

<column>user_id</column>

<column>username_clean</column>

<row>

<value>1</value>

<value>barfoo</value>

</row>

<row>

<value>2</value>

<value>foobar</value>

</row>

<row>

<value>3</value>

<value>bertie</value>

</row>

</table>

</dataset>

$db->sql_freeresult($result);

}

{

$db = $this->new_dbal();

$this->assertEquals('1', $row['user_id']);

}

}

{

return $this->data['_bots'];

}

public function set_bots($bots)

{

{

public $host = "testhost";

public $page = array('root_script_path' => '/');

}

);

$cp = new custom_profile;

$this->assertEquals($expected, $result, $description);

}

<table name="phpbb_users">

<column>user_id</column>

<column>username_clean</column>

<row>

<value>1</value>

<value>anonymous</value>

</row>

<row>

<value>3</value>

<value>foo</value>

</row>

<row>

<value>4</value>

<value>bar</value>

</row>

</table>

<table name="phpbb_sessions">

<table name="phpbb_users">

<column>user_id</column>

<column>username_clean</column>

<row>

<value>1</value>

<value>anonymous</value>

</row>

<row>

<value>3</value>

<value>foo</value>

</row>

<row>

<value>4</value>

<value>bar</value>

</row>

</table>

<table name="phpbb_sessions">

// Test the engine can be used

$this->setup_engine();

{

}

foreach (glob($this->template->cachepath . '*') as $file)

default:

$dsn .= 'host=' . $this->config['dbhost'];

if ($use_db)

{

$dsn .= ';dbname=' . $this->config['dbname'];

foreach ($tests as $test)

{

$utf_result = $utf_expected;

$hex_result = $this->utf_to_hexseq($utf_result);

$this->assertEquals($utf_expected, $utf_result, "$expected == $form($test) ($hex_expected != $hex_result)");

foreach (array('nfc', 'nfkc', 'nfd', 'nfkd') as $form)

{

$utf_result = $utf_expected;

$hex_result = $this->utf_to_hexseq($utf_result);

$this->assertEquals($utf_expected, $utf_result, "$hex_expected == $form($hex_tested) ($hex_expected != $hex_result)");