'ICON_SYNC_DISABLED' => '<img src="' . $phpbb_admin_path . 'images/icon_sync_disabled.gif" alt="' . $user->lang['RESYNC'] . '" title="' . $user->lang['RESYNC'] . '" />',

'S_CONTENT_DIRECTION' => $user->lang['DIRECTION'],

'S_CONTENT_DIR_LEFT' => $user->lang['LEFT'],

'S_CONTENT_DIR_RIGHT' => $user->lang['RIGHT'])

);

{

}

header('Cache-Control: private, no-cache="set-cookie"');

header('Expires: 0');

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

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

require($phpbb_root_path . 'includes/db/' . $dbms . '.' . $phpEx);

// Set PHP error handler to ours

set_error_handler('msg_handler');

'post_subject' => array('XSTEXT_UNI', ''),

'post_text' => array('MTEXT_UNI', ''),

'post_checksum' => array('VCHAR:32', ''),

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

'bbcode_bitfield' => array('VCHAR:252', ''),

'bbcode_uid' => array('VCHAR:5', ''),

'message_text' => array('MTEXT_UNI', ''),

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

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

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

'bbcode_bitfield' => array('VCHAR:252', ''),

'bbcode_uid' => array('VCHAR:5', ''),

}

else

{

FROM ' . POSTS_TABLE . '

WHERE post_id >= ' . (int) ($post_counter + 1) . '

AND post_id < ' . (int) ($post_counter + $this->batch_size);

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

{

}

$db->sql_freeresult($result);

*/

function sql_escape($msg)

{

}

/**

if ($type == 'string')

{

{

}

}

}

// find the starting indizes of all words

foreach ($words as $word)

{

{

$pos = strpos($text, $match[1]);

if ($pos !== false)

{

global $config, $user;

$attachments = display_attachments($forum_id, NULL, $attachments, $update_count, false, true);

$tpl_size = sizeof($attachments);

'S_USER_BROWSER' => (isset($user->data['session_browser'])) ? $user->data['session_browser'] : $user->lang['UNKNOWN_BROWSER'],

'S_USERNAME' => $user->data['username'],

'S_CONTENT_DIRECTION' => $user->lang['DIRECTION'],

'S_CONTENT_DIR_LEFT' => $user->lang['LEFT'],

'S_CONTENT_DIR_RIGHT' => $user->lang['RIGHT'],

'S_TIMEZONE' => ($user->data['user_dst'] || ($user->data['user_id'] == ANONYMOUS && $config['board_dst'])) ? sprintf($user->lang['ALL_TIMES'], $user->lang['tz'][$tz], $user->lang['tz']['dst']) : sprintf($user->lang['ALL_TIMES'], $user->lang['tz'][$tz], ''),

'T_ICONS_PATH' => "{$phpbb_root_path}{$config['icons_path']}/",

'T_RANKS_PATH' => "{$phpbb_root_path}{$config['ranks_path']}/",

'T_UPLOAD_PATH' => "{$phpbb_root_path}{$config['upload_path']}/",

'T_STYLESHEET_NAME' => $user->theme['theme_name'],

'T_THEME_DATA' => (!$user->theme['theme_storedb']) ? '' : $user->theme['theme_data'],

if ($config['send_encoding'])

{

}

header('Cache-Control: private, no-cache="set-cookie"');

header('Expires: 0');

*/

class jabber

{

var $server;

var $port;

var $username;

$this->packet_queue = $this->subscription_queue = array();

$this->iq_sleep_timer = $this->delay_disconnect = 1;

$this->returned_keep_alive = true;

$this->txnid = 0;

}

$this->_array_xmlspecialchars($content);

$xml = "<message to='$to' type='$type' id='$id'>\n";

$string = str_replace(array('&', '>', '<', '"', '\''), array('&amp;', '&gt;', '&lt;', '&quot;', '&apos;'), $string);

}

// ======================================================================

// <message/> parsers

// ======================================================================

*/

class messenger

{

var $addresses = array();

var $mail_priority = MAIL_NORMAL_PRIORITY;

function reset()

{

$this->addresses = array();

$this->mail_priority = MAIL_NORMAL_PRIORITY;

}

$this->subject = (($this->subject != '') ? $this->subject : $user->lang['NO_SUBJECT']);

}

if ($drop_header)

{

$this->msg = trim(preg_replace('#' . $drop_header . '#s', '', $this->msg));

foreach ($address_ary as $which_ary)

{

}

}

$headers .= "MIME-Version: 1.0\n";

$headers .= 'Message-ID: <' . md5(unique_id(time())) . "@" . $config['server_name'] . ">\n";

$headers .= 'Date: ' . gmdate('D, d M Y H:i:s T', time()) . "\n";

$headers .= "Content-transfer-encoding: 8bit\n";

$headers .= "X-Priority: {$this->mail_priority}\n";

$headers .= 'X-MSMail-Priority: ' . (($this->mail_priority == MAIL_LOW_PRIORITY) ? 'Low' : (($this->mail_priority == MAIL_NORMAL_PRIORITY) ? 'Normal' : 'High')) . "\n";

$headers .= "X-phpBB-Origin: phpbb://" . str_replace(array('http://', 'https://'), array('', ''), generate_board_url()) . "\n";

$headers .= ($this->extra_headers != '') ? $this->extra_headers : '';

if (!$use_queue)

{

$mail_to = ($to == '') ? 'Undisclosed-Recipient:;' : $to;

if ($config['smtp_delivery'])

{

}

else

{

'addresses' => $this->addresses,

'subject' => $this->subject,

'msg' => $this->msg,

'headers' => $headers)

);

}

$this->jabber->username = $config['jab_username'];

$this->jabber->password = $config['jab_password'];

$this->jabber->resource = ($config['jab_resource']) ? $config['jab_resource'] : '';

if (!$this->jabber->connect())

{

$err_msg = '';

$to = (!$to) ? 'Undisclosed-Recipient:;' : $to;

if (!$result)

{

/**

* Replacement or substitute for PHP's mail command

*/

{

global $config, $user;

{

foreach ($addresses['to'] as $which_ary)

{

$mail_rcpt['to'][] = '<' . trim($which_ary['email']) . '>';

}

}

{

foreach ($addresses['cc'] as $which_ary)

{

$mail_rcpt['cc'][] = '<' . trim($which_ary['email']) . '>';

}

}

}

/**

* from php.net and modified. There is an alternative encoding method which

* may produce less output but it's questionable as to its worth in this

*/

{

if ($encoding == '')

{

// define start delimimter, end delimiter and spacer

$end = "?=";

$spacer = "$end\r\n $start";

// determine length of encoded text within chunks and ensure length is even

'post_subject' => $subject,

'post_text' => $data['message'],

'post_checksum' => $data['message_md5'],

'post_attachment' => (sizeof($data['attachment_data'])) ? 1 : 0,

'bbcode_bitfield' => $data['bbcode_bitfield'],

'bbcode_uid' => $data['bbcode_uid'],

'post_edit_reason' => $data['post_edit_reason'],

'post_edit_user' => (int) $data['post_edit_user'],

'post_checksum' => $data['message_md5'],

'post_attachment' => (sizeof($data['attachment_data'])) ? 1 : 0,

'bbcode_bitfield' => $data['bbcode_bitfield'],

'bbcode_uid' => $data['bbcode_uid'],

trigger_error($error);

}

}

$db->sql_transaction('commit');

'enable_sig' => $data['enable_sig'],

'message_subject' => $subject,

'message_text' => $data['message'],

'message_attachment'=> (sizeof($data['attachment_data'])) ? 1 : 0,

'bbcode_bitfield' => $data['bbcode_bitfield'],

'bbcode_uid' => $data['bbcode_uid'],

'enable_sig' => $data['enable_sig'],

'message_subject' => $subject,

'message_text' => $data['message'],

'message_attachment'=> (sizeof($data['attachment_data'])) ? 1 : 0,

'bbcode_bitfield' => $data['bbcode_bitfield'],

'bbcode_uid' => $data['bbcode_uid']

'post_edit_reason' => (string) $row['post_edit_reason'],

'post_edit_user' => (int) $row['post_edit_user'],

'post_checksum' => (string) $row['post_checksum'],

'post_attachment' => (int) $row['post_attachment'],

'bbcode_bitfield' => $row['bbcode_bitfield'],

'bbcode_uid' => (string) $row['bbcode_uid'],

*

* @param string $mode contains the post mode: edit, post, reply, quote ...

*/

{

global $db;

{

include($phpbb_root_path . 'includes/utf/utf_normalizer.' . $phpEx);

}

$error = false;

{

global $db, $config, $user;

);

$replace = array(

' ',

'$1',

);

// $keywords input format: each word seperated by a space, words in a bracket are not seperated

}

// set the search_query which is shown to the user

$exact_words = array();

preg_match_all('#([^\\s+\\-|*()]+)(?:$|[\\s+\\-|()])#', $keywords, $exact_words);

$mode = 'must_contain';

}

// if this is an array of words then retrieve an id for each

if (is_array($word))

{

// throw an error if we shall not ignore unexistant words

else if (!$ignore_no_id)

{

}

}

// else we only need one id

// throw an error if we shall not ignore unexistant words

else if (!$ignore_no_id)

{

}

}

case 'mysql':

case 'mysql4':

case 'mysqli':

case 'sqlite':

$sql_array_count['SELECT'] = ($type == 'posts') ? 'DISTINCT p.post_id' : 'DISTINCT p.topic_id';

*

* NOTE: duplicates are NOT removed from the return array

*

* @return array Array of UTF-8 words

*

* @access private

/**

* Clean up the string, remove HTML tags, remove BBCodes

*/

while (isset($word[0]))

{

* @param int $post_id The id of the post which is modified/created

* @param string $message New or updated post content

* @param string $subject New or updated post subject

* @param int $poster_id Post author's user id

* @param int $forum_id The id of the forum in which the post is located

*

* @access public

*/

{

global $config, $db, $user;

}

/**

* Removes entries from the wordmatch table for the specified post_ids

*/

function index_remove($post_ids, $author_ids, $forum_ids)

* @param string $encoding Text encoding

* @return string Cleaned up text, only alphanumeric chars are left

*/

{

global $phpbb_root_path, $phpEx;

static $conv = array(), $conv_loaded = array();

// These are fields required in the config table

return array(

'tpl' => $tpl,

);

}

}

$var_ary = array(

'dateformat' => array('string', false, 3, 30),

'tz' => array('num', false, -14, 14),

);

*/

function utf8_encode_ncr($text)

{

}

/**

$birthday_list = '';

if ($config['load_birthdays'])

{

$sql = 'SELECT user_id, username, user_colour, user_birthday

FROM ' . USERS_TABLE . "

WHERE user_birthday LIKE '" . $db->sql_escape(sprintf('%2d-%2d-', $now['mday'], $now['mon'])) . "%'

'T_IMAGE_PATH' => $phpbb_root_path . 'adm/images/',

'S_CONTENT_DIRECTION' => $lang['DIRECTION'],

'S_CONTENT_DIR_LEFT' => $lang['LEFT'],

'S_CONTENT_DIR_RIGHT' => $lang['RIGHT'],

)

);

header('Cache-Control: private, no-cache="set-cookie"');

header('Expires: 0');

header('Pragma: no-cache');

post_subject BLOB SUB_TYPE TEXT DEFAULT '' NOT NULL,

post_text BLOB SUB_TYPE TEXT DEFAULT '' NOT NULL,

post_checksum VARCHAR(32) DEFAULT '' NOT NULL,

post_attachment INTEGER DEFAULT 0 NOT NULL,

bbcode_bitfield VARCHAR(252) DEFAULT '' NOT NULL,

bbcode_uid VARCHAR(5) DEFAULT '' NOT NULL,

message_text BLOB SUB_TYPE TEXT DEFAULT '' NOT NULL,

message_edit_reason BLOB SUB_TYPE TEXT DEFAULT '' NOT NULL,

message_edit_user INTEGER DEFAULT 0 NOT NULL,

message_attachment INTEGER DEFAULT 0 NOT NULL,

bbcode_bitfield VARCHAR(252) DEFAULT '' NOT NULL,

bbcode_uid VARCHAR(5) DEFAULT '' NOT NULL,

[post_subject] [nvarchar] (1000) DEFAULT ('') NOT NULL ,

[post_text] [ntext] DEFAULT ('') NOT NULL ,

[post_checksum] [varchar] (32) DEFAULT ('') NOT NULL ,

[post_attachment] [int] DEFAULT (0) NOT NULL ,

[bbcode_bitfield] [varchar] (252) DEFAULT ('') NOT NULL ,

[bbcode_uid] [varchar] (5) DEFAULT ('') NOT NULL ,

[message_text] [ntext] DEFAULT ('') NOT NULL ,

[message_edit_reason] [nvarchar] (3000) DEFAULT ('') NOT NULL ,

[message_edit_user] [int] DEFAULT (0) NOT NULL ,

[message_attachment] [int] DEFAULT (0) NOT NULL ,

[bbcode_bitfield] [varchar] (252) DEFAULT ('') NOT NULL ,

[bbcode_uid] [varchar] (5) DEFAULT ('') NOT NULL ,

post_subject text DEFAULT '' NOT NULL,

post_text mediumtext DEFAULT '' NOT NULL,

post_checksum varchar(32) DEFAULT '' NOT NULL,

post_attachment tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,

bbcode_bitfield varchar(252) DEFAULT '' NOT NULL,

bbcode_uid varchar(5) DEFAULT '' NOT NULL,

message_text mediumtext DEFAULT '' NOT NULL,

message_edit_reason text DEFAULT '' NOT NULL,

message_edit_user mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,

message_attachment tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,

bbcode_bitfield varchar(252) DEFAULT '' NOT NULL,

bbcode_uid varchar(5) DEFAULT '' NOT NULL,

post_subject text DEFAULT '' NOT NULL,

post_text mediumtext DEFAULT '' NOT NULL,

post_checksum varchar(32) DEFAULT '' NOT NULL,

post_attachment tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,

bbcode_bitfield varchar(252) DEFAULT '' NOT NULL,

bbcode_uid varchar(5) DEFAULT '' NOT NULL,

message_text mediumtext DEFAULT '' NOT NULL,

message_edit_reason text DEFAULT '' NOT NULL,

message_edit_user mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,

message_attachment tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,

bbcode_bitfield varchar(252) DEFAULT '' NOT NULL,

bbcode_uid varchar(5) DEFAULT '' NOT NULL,

post_subject varchar2(1000) DEFAULT '' ,

post_text clob DEFAULT '' ,

post_checksum varchar2(32) DEFAULT '' ,

post_attachment number(1) DEFAULT '0' NOT NULL,

bbcode_bitfield varchar2(252) DEFAULT '' ,

bbcode_uid varchar2(5) DEFAULT '' ,

message_text clob DEFAULT '' ,

message_edit_reason varchar2(3000) DEFAULT '' ,

message_edit_user number(8) DEFAULT '0' NOT NULL,

message_attachment number(1) DEFAULT '0' NOT NULL,

bbcode_bitfield varchar2(252) DEFAULT '' ,

bbcode_uid varchar2(5) DEFAULT '' ,

post_subject varchar(1000) DEFAULT '' NOT NULL,

post_text TEXT DEFAULT '' NOT NULL,

post_checksum varchar(32) DEFAULT '' NOT NULL,

post_attachment INT2 DEFAULT '0' NOT NULL CHECK (post_attachment >= 0),

bbcode_bitfield varchar(252) DEFAULT '' NOT NULL,

bbcode_uid varchar(5) DEFAULT '' NOT NULL,

message_text TEXT DEFAULT '' NOT NULL,

message_edit_reason varchar(3000) DEFAULT '' NOT NULL,

message_edit_user INT4 DEFAULT '0' NOT NULL CHECK (message_edit_user >= 0),

message_attachment INT2 DEFAULT '0' NOT NULL CHECK (message_attachment >= 0),

bbcode_bitfield varchar(252) DEFAULT '' NOT NULL,

bbcode_uid varchar(5) DEFAULT '' NOT NULL,

post_subject text(65535) NOT NULL DEFAULT '',

post_text mediumtext(16777215) NOT NULL DEFAULT '',

post_checksum varchar(32) NOT NULL DEFAULT '',

post_attachment INTEGER UNSIGNED NOT NULL DEFAULT '0',

bbcode_bitfield varchar(252) NOT NULL DEFAULT '',

bbcode_uid varchar(5) NOT NULL DEFAULT '',

message_text mediumtext(16777215) NOT NULL DEFAULT '',

message_edit_reason text(65535) NOT NULL DEFAULT '',

message_edit_user INTEGER UNSIGNED NOT NULL DEFAULT '0',

message_attachment INTEGER UNSIGNED NOT NULL DEFAULT '0',

bbcode_bitfield varchar(252) NOT NULL DEFAULT '',

bbcode_uid varchar(5) NOT NULL DEFAULT '',

$lang = array();

}

//

// Placeholders can now contain order information, e.g. instead of

// 'Page %s of %s' you can (and should) write 'Page %1$s of %2$s', this allows

$lang = array();

}

//

// Placeholders can now contain order information, e.g. instead of

// 'Page %s of %s' you can (and should) write 'Page %1$s of %2$s', this allows

$lang = array();

}

//

// Placeholders can now contain order information, e.g. instead of

// 'Page %s of %s' you can (and should) write 'Page %1$s of %2$s', this allows

$lang = array();

}

//

// Placeholders can now contain order information, e.g. instead of

// 'Page %s of %s' you can (and should) write 'Page %1$s of %2$s', this allows

$lang = array();

}

//

// Placeholders can now contain order information, e.g. instead of

// 'Page %s of %s' you can (and should) write 'Page %1$s of %2$s', this allows

$lang = array();

}

//

// Placeholders can now contain order information, e.g. instead of

// 'Page %s of %s' you can (and should) write 'Page %1$s of %2$s', this allows

$lang = array();

}

//

// Placeholders can now contain order information, e.g. instead of

// 'Page %s of %s' you can (and should) write 'Page %1$s of %2$s', this allows

$lang = array();

}

//

// Placeholders can now contain order information, e.g. instead of

// 'Page %s of %s' you can (and should) write 'Page %1$s of %2$s', this allows

$lang = array();

}

//

// Placeholders can now contain order information, e.g. instead of

// 'Page %s of %s' you can (and should) write 'Page %1$s of %2$s', this allows

$lang = array();

}

//

// Placeholders can now contain order information, e.g. instead of

// 'Page %s of %s' you can (and should) write 'Page %1$s of %2$s', this allows

$lang = array();

}

//

// Placeholders can now contain order information, e.g. instead of

// 'Page %s of %s' you can (and should) write 'Page %1$s of %2$s', this allows

$lang = array();

}

//

// Placeholders can now contain order information, e.g. instead of

// 'Page %s of %s' you can (and should) write 'Page %1$s of %2$s', this allows

$lang = array();

}

//

// Placeholders can now contain order information, e.g. instead of

// 'Page %s of %s' you can (and should) write 'Page %1$s of %2$s', this allows

$lang = array();

}

//

// Placeholders can now contain order information, e.g. instead of

// 'Page %s of %s' you can (and should) write 'Page %1$s of %2$s', this allows

$lang = array();

}

//

// Placeholders can now contain order information, e.g. instead of

// 'Page %s of %s' you can (and should) write 'Page %1$s of %2$s', this allows

// DEVELOPERS PLEASE NOTE

//

// Placeholders can now contain order information, e.g. instead of

// 'Page %s of %s' you can (and should) write 'Page %1$s of %2$s', this allows

// translators to re-order the output of data while ensuring it remains correct

$lang = array_merge($lang, array(

'TRANSLATION_INFO' => '',

'DIRECTION' => 'ltr',

'LEFT' => 'left',

'RIGHT' => 'right',

Subject: New user account

Hello,

The following is an email sent to you by an administrator of "{SITENAME}". If this message is spam, contains abusive or other comments you find offensive please contact the webmaster of the board at the following address:

Subject: Account Activated

Hello {USERNAME},

Subject: Welcome to {SITENAME} Forums

{WELCOME_MSG}

Subject: Welcome to {SITENAME} Forums

{WELCOME_MSG}

Subject: Welcome to {SITENAME} Forums

{WELCOME_MSG}

Subject: {SITENAME} - Email a friend

Hello {TO_USERNAME},

Subject: Forum Post Notification - {FORUM_NAME}

Hello {USERNAME},

Subject: You have been added to this usergroup

Congratulations,

Subject: Your request has been approved

Congratulations,

Subject: A request to join your group has been made

Dear {USERNAME},

Subject: phpBB Installed

Congratulations,

Subject: New Topic Notification - {FORUM_NAME}

Hello {USERNAME},

Subject: Post Approved - {POST_SUBJECT}

Hello {USERNAME},

Subject: Post Disapproved - {POST_SUBJECT}

Hello {USERNAME},

Subject: New Private Message has arrived

Hello {USERNAME},

Hello {TO_USERNAME},

Hello {TO_USERNAME},

Subject: Report Closed - {POST_SUBJECT}

Hello {USERNAME},

Subject: Report Closed - {POST_SUBJECT}

Hello {USERNAME},

Subject: Topic Approved - {TOPIC_TITLE}

Hello {USERNAME},

Subject: Topic Disapproved - {TOPIC_TITLE}

Hello {USERNAME},

Subject: Topic Reply Notification - {TOPIC_TITLE}

Hello {USERNAME},

Subject: Reactivate your account

Hello {USERNAME},

Subject: Your account has been deactivated

Hello {USERNAME},

Subject: New password activation

Hello {USERNAME}

Subject: Inactive account reminder

Hello {USERNAME},

Subject: Welcome to {SITENAME} Forums

{WELCOME_MSG}

Subject: Welcome to {SITENAME} Forums

{WELCOME_MSG}

Subject: Welcome to {SITENAME} Forums

{WELCOME_MSG}

$lang = array();

}

//

// Placeholders can now contain order information, e.g. instead of

// 'Page %s of %s' you can (and should) write 'Page %1$s of %2$s', this allows

/**

*/

//

// Placeholders can now contain order information, e.g. instead of

// 'Page %s of %s' you can (and should) write 'Page %1$s of %2$s', this allows

/**

*/

//

// Placeholders can now contain order information, e.g. instead of

// 'Page %s of %s' you can (and should) write 'Page %1$s of %2$s', this allows

// DEVELOPERS PLEASE NOTE

//

// Placeholders can now contain order information, e.g. instead of

// 'Page %s of %s' you can (and should) write 'Page %1$s of %2$s', this allows

// translators to re-order the output of data while ensuring it remains correct

// DEVELOPERS PLEASE NOTE

//

// Placeholders can now contain order information, e.g. instead of

// 'Page %s of %s' you can (and should) write 'Page %1$s of %2$s', this allows

// translators to re-order the output of data while ensuring it remains correct

$lang = array();

}

//

// Placeholders can now contain order information, e.g. instead of

// 'Page %s of %s' you can (and should) write 'Page %1$s of %2$s', this allows

$lang = array();

}

//

// Placeholders can now contain order information, e.g. instead of

// 'Page %s of %s' you can (and should) write 'Page %1$s of %2$s', this allows

$lang = array();

}

//

// Placeholders can now contain order information, e.g. instead of

// 'Page %s of %s' you can (and should) write 'Page %1$s of %2$s', this allows

// DEVELOPERS PLEASE NOTE

//

// Placeholders can now contain order information, e.g. instead of

// 'Page %s of %s' you can (and should) write 'Page %1$s of %2$s', this allows

// translators to re-order the output of data while ensuring it remains correct

$lang = array();

}

//

// Placeholders can now contain order information, e.g. instead of

// 'Page %s of %s' you can (and should) write 'Page %1$s of %2$s', this allows

// DEVELOPERS PLEASE NOTE

//

// Placeholders can now contain order information, e.g. instead of

// 'Page %s of %s' you can (and should) write 'Page %1$s of %2$s', this allows

// translators to re-order the output of data while ensuring it remains correct

'POLL_ENDED_AT' => 'Poll ended at %s',

'POLL_RUN_TILL' => 'Poll runs till %s',

'POLL_VOTED_OPTION' => 'You voted for this option',

'PRINT_TOPIC' => 'Print view',

'QUICK_MOD' => 'Quick-mod tools',

if ($bday_year)

{

$diff = $now['mon'] - $bday_month;

if ($diff == 0)

$sort_key = 't';

$sort_dir = 'd';

$sort_by_sql['t'] = 't.topic_last_post_time';

if (!$sort_days)

{

}

gen_sort_selects($limit_days, $sort_by_text, $sort_days, $sort_key, $sort_dir, $s_limit_days, $s_sort_key, $s_sort_dir, $u_sort_param);

$last_post_time = (time() - ($sort_days * 24 * 3600));

AND t.topic_moved_id = 0

ORDER BY t.topic_last_post_time DESC';

$field = 'topic_id';

break;

$sort_join = ($sort_key == 'f') ? FORUMS_TABLE . ' f, ' : '';

$sql_sort = ($sort_key == 'f') ? ' AND f.forum_id = p.forum_id ' . $sql_sort : $sql_sort;

if ($show_results == 'posts')

{

if ($sort_key == 'a')

FROM $sort_join" . POSTS_TABLE . ' p, ' . TOPICS_TABLE . " t

WHERE t.topic_replies = 0

AND p.topic_id = t.topic_id

$m_approve_fid_sql

" . ((sizeof($ex_fid_ary)) ? ' AND ' . $db->sql_in_set('p.forum_id', $ex_fid_ary, true) : '') . "

$sql_sort";

WHERE t.topic_replies = 0

AND t.topic_moved_id = 0

AND p.topic_id = t.topic_id

$m_approve_fid_sql

" . ((sizeof($ex_fid_ary)) ? ' AND ' . $db->sql_in_set('p.forum_id', $ex_fid_ary, true) : '') . "

$sql_sort";

$sort_by_sql['t'] = ($show_results == 'posts') ? 'p.post_time' : 't.topic_last_post_time';

$sql_sort = 'ORDER BY ' . $sort_by_sql[$sort_key] . (($sort_dir == 'a') ? ' ASC' : ' DESC');

gen_sort_selects($limit_days, $sort_by_text, $sort_days, $sort_key, $sort_dir, $s_limit_days, $s_sort_key, $s_sort_dir, $u_sort_param);

$s_sort_key = $s_sort_dir = $u_sort_param = $s_limit_days = '';

$db->sql_freeresult($result);

unset($pad_store);

// Number of chars returned

$s_characters = '<option value="-1">' . $user->lang['ALL_AVAILABLE'] . '</option>';

$s_characters .= '<option value="0">0</option>';

<td class="gensmall" colspan="2" height="25" align="center">{postrow.L_IGNORE_POST}</td>

<!-- ELSE -->

<td align="center" valign="middle"><!-- IF postrow.S_FIRST_UNREAD --><a name="unread"></a><!-- ENDIF --><a name="p{postrow.POST_ID}"></a><b class="postauthor">{postrow.POSTER_NAME}</b></td>

<td width="100%" height="25">

<table width="100%" cellspacing="0">

// Container for user details, only process once

$post_list = $user_cache = $id_cache = $attachments = $attach_list = $rowset = $update_count = $post_edit_list = array();

$has_attachments = $display_notice = false;

$i = $i_total = 0;

// Go ahead and pull all data for this topic

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

// Posts are stored in the $rowset array while $attach_list, $user_cache

// and the global bbcode_bitfield are built

'post_approved' => $row['post_approved'],

'post_reported' => $row['post_reported'],

'post_text' => $row['post_text'],

'bbcode_uid' => $row['bbcode_uid'],

'bbcode_bitfield' => $row['bbcode_bitfield'],

'enable_smilies' => $row['enable_smilies'],

continue;

}

// End signature parsing, only if needed

if ($user_cache[$poster_id]['sig'] && empty($user_cache[$poster_id]['sig_parsed']))

'ONLINE_IMG' => ($poster_id == ANONYMOUS || !$config['load_onlinetrack']) ? '' : (($user_cache[$poster_id]['online']) ? $user->img('icon_user_online', 'ONLINE') : $user->img('icon_user_offline', 'OFFLINE')),

'S_ONLINE' => ($poster_id == ANONYMOUS || !$config['load_onlinetrack']) ? false : (($user_cache[$poster_id]['online']) ? true : false),

'U_EDIT' => (($user->data['user_id'] == $poster_id && $auth->acl_get('f_edit', $forum_id) && ($row['post_time'] > time() - ($config['edit_time'] * 60) || !$config['edit_time'])) || $auth->acl_get('m_edit', $forum_id)) ? append_sid("{$phpbb_root_path}posting.$phpEx", "mode=edit&amp;f=$forum_id&amp;p={$row['post_id']}") : '',

'U_QUOTE' => ($auth->acl_get('f_reply', $forum_id)) ? append_sid("{$phpbb_root_path}posting.$phpEx", "mode=quote&amp;f=$forum_id&amp;p={$row['post_id']}") : '',

'U_INFO' => ($auth->acl_get('m_info', $forum_id)) ? append_sid("{$phpbb_root_path}mcp.$phpEx", "i=main&amp;mode=post_details&amp;f=$forum_id&amp;p=" . $row['post_id'], true, $user->session_id) : '',

}

}

// We overwrite $_REQUEST['f'] if there is no forum specified

// to be able to display the correct online list.

// One downside is that the user currently viewing this topic/post is not taken into account.