return ( $row = $db->sql_fetchrow($result) ) ? $row : false;

}

{

$sql = "SELECT c.cat_id, c.cat_title, c.cat_order

FROM " . CATEGORIES_TABLE . " c, " . FORUMS_TABLE . " f

$boxstring .= '<input type="hidden" name="sid" value="' . $SID . '" />';

}

}

//

function clean_words($mode, &$entry, &$stopword_list, &$synonym_list)

{

// Weird, $init_match doesn't work with static when double quotes (") are used...

$entry = ' ' . strip_tags(strtolower($entry)) . ' ';

{

// Replace line endings by a space

$entry = preg_replace('/[\n\r]/is', ' ', $entry);

$entry = preg_replace('/\[\/?url(=.*?)?\]/', ' ', $entry);

$entry = preg_replace('/\[\/?[a-z\*=\+\-]+(\:?[0-9a-z]+)?:[a-z0-9]{10,}(\:[a-z0-9]+)?=?.*?\]/', ' ', $entry);

}

{

$entry = str_replace('+', ' and ', $entry);

$entry = str_replace('-', ' not ', $entry);

$entry = str_replace($drop_char_match[$i], $drop_char_replace[$i], $entry);

}

{

$entry = str_replace('*', ' ', $entry);

// 'words' that consist of <=3 or >=25 characters are removed.

}

{

for ($j = 0; $j < count($stopword_list); $j++)

{

}

}

{

for ($j = 0; $j < count($synonym_list); $j++)

{

function split_words(&$entry, $mode = 'post')

{

{

preg_match_all("/\b(\w[\w']*\w+|\w+?)\b/", $entry, $split_entries);

}

$word = array();

$word_insert_sql = array();

{

$word_insert_sql[$word_in] = '';

{

for ($i = 0; $i < count($search_matches); $i++)

{

}

}

{

sort($word);

$sql = "SELECT word_id, word_text

FROM " . SEARCH_WORD_TABLE . "

WHERE word_text IN ($word_text_sql)";

{

message_die(GENERAL_ERROR, 'Could not select words', '', __LINE__, __FILE__, $sql);

}

{

$check_words[$row['word_text']] = $row['word_id'];

}

for ($i = 0; $i < count($word); $i++)

{

$new_match = true;

{

$new_match = false;

}

{

switch( SQL_LAYER )

{

case 'mysql':

case 'mysql4':

break;

case 'mssql':

$value_sql .= ( ( $value_sql != '' ) ? ' UNION ALL ' : '' ) . "SELECT '" . $word[$i] . "'";

break;

}

{

message_die(GENERAL_ERROR, 'Could not insert new word', '', __LINE__, __FILE__, $sql);

}

SELECT $post_id, word_id, $title_match

FROM " . SEARCH_WORD_TABLE . "

WHERE word_text IN ($match_sql)";

{

message_die(GENERAL_ERROR, 'Could not insert new word matches', '', __LINE__, __FILE__, $sql);

}

global $db;

$sql = ( $mode == 'global' ) ? "SELECT COUNT(post_id) AS total_posts FROM " . SEARCH_MATCH_TABLE . " GROUP BY post_id" : "SELECT SUM(forum_posts) AS total_posts FROM " . FORUMS_TABLE;

{

message_die(GENERAL_ERROR, 'Could not obtain post count', '', __LINE__, __FILE__, $sql);

}

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

{

$common_threshold = floor($row['total_posts'] * $fraction);

{

$word_id_sql = '';

for($i = 0; $i < count($word_id_list); $i++)

HAVING COUNT(word_id) > $common_threshold";

}

{

message_die(GENERAL_ERROR, 'Could not obtain common word list', '', __LINE__, __FILE__, $sql);

}

$common_word_id = '';

{

$common_word_id .= ( ( $common_word_id != '' ) ? ', ' : '' ) . $row['word_id'];

}

$db->sql_freeresult($result);

{

$sql = "UPDATE " . SEARCH_WORD_TABLE . "

SET word_common = " . TRUE . "

WHERE word_id IN ($common_word_id)";

{

message_die(GENERAL_ERROR, 'Could not delete word list entry', '', __LINE__, __FILE__, $sql);

}

$sql = "DELETE FROM " . SEARCH_MATCH_TABLE . "

WHERE word_id IN ($common_word_id)";

{

message_die(GENERAL_ERROR, 'Could not delete word match entry', '', __LINE__, __FILE__, $sql);

}

$words_removed = false;

{

case 'mysql':

case 'mysql4':

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

{

$word_id_sql = '';

{

$word_id_sql .= ( $word_id_sql != '' ) ? ', ' . $row['word_id'] : $row['word_id'];

}

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

{

$word_id_sql = '';

{

$word_id_sql .= ( $word_id_sql != '' ) ? ', ' . $row['word_id'] : $row['word_id'];

}

//

// Username search

//

{

global $db, $board_config, $template, $lang, $images, $theme, $phpEx, $phpbb_root_path;

global $starttime;

if ( !empty($search_match) )

{

$username_search = preg_replace('/\*/', '%', trim(strip_tags($search_match)));

{

do

{

}

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

}

else

{

}

}

}

}

?> \ No newline at end of file

// gzip_compression

//

$do_gzip_compress = FALSE;

{

$phpver = phpversion();

{

{

ob_start('ob_gzhandler');

}

}

{

{

{

$do_gzip_compress = TRUE;

ob_start();

//

// Generate logged in/logged out status

//

{

}

else

{

$l_login_logout = $lang['Login'];

}

//

$user_forum_sql = ( !empty($forum_id) ) ? "AND ( u.user_session_page = $forum_id

OR s.session_page = $forum_id)" : '';

$sql = "SELECT u.username, u.user_id, u.user_allow_viewonline, u.user_level, s.session_logged_in, s.session_ip

FROM ".USERS_TABLE." u, ".SESSIONS_TABLE." s

WHERE u.user_id = s.session_user_id

OR u.user_session_time >= " . ( time() - 300 ) . " )

$user_forum_sql

ORDER BY u.username ASC, s.session_ip ASC";

{

message_die(GENERAL_ERROR, 'Could not obtain user/online information', '', __LINE__, __FILE__, $sql);

}

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

{

// User is logged in and therefor not a guest

{

// Skip multiple sessions for one user

{

$style_color = '';

{

$row['username'] = '<b>' . $row['username'] . '</b>';

$style_color = 'style="color:#' . $theme['fontcolor3'] . '"';

}

{

$row['username'] = '<b>' . $row['username'] . '</b>';

$style_color = 'style="color:#' . $theme['fontcolor2'] . '"';

}

{

$user_online_link = '<a href="' . append_sid("profile.$phpEx?mode=viewprofile&amp;" . POST_USERS_URL . "=" . $row['user_id']) . '"' . $style_color .'>' . $row['username'] . '</a>';

$logged_visible_online++;

$logged_hidden_online++;

}

{

}

}

}

else

{

// Skip multiple sessions for one user

{

$guests_online++;

}

}

$prev_session_ip = $row['session_ip'];

}

{

$online_userlist = $lang['None'];

}

if ( $total_online_users > $board_config['record_online_users'])

{

$sql = "UPDATE " . CONFIG_TABLE . "

SET config_value = '$total_online_users'

WHERE config_name = 'record_online_users'";

{

message_die(GENERAL_ERROR, 'Could not update online user record (nr of users)', '', __LINE__, __FILE__, $sql);

}

$sql = "UPDATE " . CONFIG_TABLE . "

WHERE config_name = 'record_online_date'";

{

message_die(GENERAL_ERROR, 'Could not update online user record (date)', '', __LINE__, __FILE__, $sql);

}

}

{

$l_t_user_s = $lang['Online_users_zero_total'];

}

{

$l_t_user_s = $lang['Online_user_total'];

}

$l_t_user_s = $lang['Online_users_total'];

}

{

$l_r_user_s = $lang['Reg_users_zero_total'];

}

{

$l_r_user_s = $lang['Reg_user_total'];

}

$l_r_user_s = $lang['Reg_users_total'];

}

{

$l_h_user_s = $lang['Hidden_users_zero_total'];

}

{

$l_h_user_s = $lang['Hidden_user_total'];

}

$l_h_user_s = $lang['Hidden_users_total'];

}

{

$l_g_user_s = $lang['Guest_users_zero_total'];

}

{

$l_g_user_s = $lang['Guest_user_total'];

}

// Obtain number of new private messages

// if user is logged in

//

{

{

$l_message_new = ( $userdata['user_new_privmsg'] == 1 ) ? $lang['New_pm'] : $lang['New_pms'];

$l_privmsgs_text = sprintf($l_message_new, $userdata['user_new_privmsg']);

{

$sql = "UPDATE " . USERS_TABLE . "

SET user_last_privmsg = " . $userdata['user_lastvisit'] . "

WHERE user_id = " . $userdata['user_id'];

{

message_die(GENERAL_ERROR, 'Could not update private message new/read time for user', '', __LINE__, __FILE__, $sql);

}

$icon_pm = $images['pm_no_new_msg'];

}

{

$l_message_unread = ( $userdata['user_unread_privmsg'] == 1 ) ? $lang['Unread_pm'] : $lang['Unread_pms'];

$l_privmsgs_text_unread = sprintf($l_message_unread, $userdata['user_unread_privmsg']);

{

$icon_pm = $images['pm_no_new_msg'];

$l_privmsgs_text = $lang['Login_check_pm'];

$s_privmsg_new = 0;

}

//

$nav_links_html = '';

$nav_link_proto = '<link rel="%s" href="%s" title="%s" />' . "\n";

{

{

$nav_links_html .= sprintf($nav_link_proto, $nav_item, $nav_array['url'], $nav_array['title']);

}

else

{

// We have a nested array, used for items like <link rel='chapter'> that can occur more than once.

{

$nav_links_html .= sprintf($nav_link_proto, $nav_item, $nested_array['url'], $nested_array['title']);

}

//

// The following assigns all _common_ variables that may be used at any point

//

$template->assign_vars(array(

'SITENAME' => $board_config['sitename'],

'SITE_DESCRIPTION' => $board_config['site_desc'],

'PAGE_TITLE' => $page_title,

'TOTAL_USERS_ONLINE' => $l_online_users,

'PRIVATE_MESSAGE_INFO' => $l_privmsgs_text,

'PRIVATE_MESSAGE_INFO_UNREAD' => $l_privmsgs_text_unread,

'PRIVATE_MESSAGE_NEW_FLAG' => $s_privmsg_new,

'PRIVMSG_IMG' => $icon_pm,

'L_SEARCH_NEW' => $lang['Search_new'],

'L_SEARCH_SELF' => $lang['Search_your_posts'],

'L_WHOSONLINE_ADMIN' => sprintf($lang['Admin_online_color'], '<span style="color:#' . $theme['fontcolor3'] . '">', '</span>'),

'L_WHOSONLINE_MOD' => sprintf($lang['Mod_online_color'], '<span style="color:#' . $theme['fontcolor2'] . '">', '</span>'),

'U_SEARCH_UNANSWERED' => append_sid('search.'.$phpEx.'?search_id=unanswered'),

'U_SEARCH_SELF' => append_sid('search.'.$phpEx.'?search_id=egosearch'),

//

// Login box?

//

{

$template->assign_block_vars('switch_user_logged_out', array());

}

{

$template->assign_block_vars('switch_user_logged_in', array());

{

$template->assign_block_vars('switch_enable_pm_popup', array());

}

}

{

header ('Cache-Control: private, no-cache, must-revalidate, pre-check=2, post-check=2, max-age=25');

header ('Pragma: no-cache');

}

header ('Last-Modified: ' . gmdate('D, d M Y H:i:s') . ' GMT');

$template->pparse('overall_header');

global $orig_word, $replacement_word;

global $starttime;

{

{

message_die(GENERAL_MESSAGE, 'Topic_not_exist');

}

FROM " . TOPICS_TABLE . " t, " . FORUMS_TABLE . " f

WHERE t.topic_id = $topic_id

AND f.forum_id = t.forum_id";

{

}

{

message_die(GENERAL_MESSAGE, 'Topic_post_not_exist');

}

//

// Define censored word matches

//

{

$orig_word = array();

$replacement_word = array();

//

// Dump out the page header and load viewtopic body template

//

{

$gen_simple_header = TRUE;

include($phpbb_root_path . 'includes/page_header.'.$phpEx);

$template->set_filenames(array(

);

}

AND p.post_id = pt.post_id

ORDER BY p.post_time DESC

LIMIT " . $board_config['posts_per_page'];

{

}

//

//

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

{

$i = 0;

do

{

$post_date = create_date($board_config['default_dateformat'], $row['post_time'], $board_config['board_timezone']);

//

// Handle anon users posting with usernames

//

$poster_rank = $lang['Guest'];

}

$message = $row['post_text'];

$bbcode_uid = $row['bbcode_uid'];

//

if ( !$board_config['allow_html'] && $row['enable_html'] )

{

}

if ( $bbcode_uid != "" )

{

}

$message = make_clickable($message);

$message = smilies_pass($message);

}

//

// Again this will be handled by the templating

$row_color = ( !($i % 2) ) ? $theme['td_color1'] : $theme['td_color2'];

$row_class = ( !($i % 2) ) ? $theme['td_class1'] : $theme['td_class2'];

);

$i++;

}

else

{

}

$template->assign_vars(array(

);

if ( !$is_inline_review )

{

include($phpbb_root_path . 'includes/page_tail.'.$phpEx);

}

}

}

@reset($avatar_images);

while( list($key) = each($avatar_images) )

{

$selected = ( $key == $category ) ? ' selected="selected"' : '';

$s_categories .= '<option value="' . $key . '"' . $selected . '>' . ucfirst($key) . '</option>';

}

}

$s_colspan = 0;

for($i = 0; $i < count($avatar_images[$category]); $i++)

'L_RETURN_PROFILE' => $lang['Return_profile'],

'L_CATEGORY' => $lang['Select_category'],

'S_COLSPAN' => $s_colspan,

'S_PROFILE_ACTION' => append_sid("profile.$phpEx?mode=$mode"),

'S_HIDDEN_FIELDS' => $s_hidden_vars)

include($phpbb_root_path . 'includes/emailer.'.$phpEx);

$emailer = new emailer($board_config['smtp_delivery']);

if ( !empty($HTTP_POST_VARS['cc_email']) )

{

$email_headers .= "Cc: " . $userdata['user_email'] . "\n";

}

$emailer->use_template('profile_send_email', $user_lang);

$emailer->email_address($user_email);

include($phpbb_root_path . 'includes/page_header.'.$phpEx);

$template->set_filenames(array(

);

if ( $error )

{

$template->assign_var_from_handle('ERROR_BOX', 'reg_header');

}

$template->assign_vars(array(

'USERNAME' => $username,

'S_POST_ACTION' => append_sid("profile.$phpEx?&amp;mode=email&amp;" . POST_USERS_URL . "=$user_id"),

'L_SEND_EMAIL_MSG' => $lang['Send_email_msg'],

'L_EMPTY_MESSAGE_EMAIL' => $lang['Empty_message_email'],

'L_OPTIONS' => $lang['Options'],

'L_CC_EMAIL' => $lang['CC_email'],

'L_SPELLCHECK' => $lang['Spellcheck'],

'L_SEND_EMAIL' => $lang['Send_email'])

);

message_die(GENERAL_MESSAGE, $lang['User_not_exist']);

}

//

include($phpbb_root_path . 'includes/page_header.'.$phpEx);

if ( $mode == 'editprofile' )

{

$avatar_category = ( !empty($HTTP_POST_VARS['avatarcategory']) ) ? $HTTP_POST_VARS['avatarcategory'] : '';

$template->set_filenames(array(

);

display_avatar_gallery($mode, $avatar_category, $user_id, $email, $current_email, $coppa, $username, $email, $icq, $aim, $msn, $yim, $website, $location, $occupation, $interests, $signature, $viewemail, $notifypm, $popuppm, $notifyreply, $attachsig, $allowhtml, $allowbbcode, $allowsmilies, $allowviewonline, $user_style, $user_lang, $user_timezone, $user_dateformat);

if ( $mode == 'editprofile' )

{

}

//

//

if ( $userdata['user_allowavatar'] && ( $board_config['allow_avatar_upload'] || $board_config['allow_avatar_local'] || $board_config['allow_avatar_remote'] ) )

{

if ( $board_config['allow_avatar_upload'] && file_exists('./' . $board_config['avatar_path']) )

{

if ( $form_enctype != '' )

{

}

}

if ( $board_config['allow_avatar_remote'] )

{

}

if ( $board_config['allow_avatar_local'] && file_exists('./' . $board_config['avatar_gallery_path']) )

{

}

}

}

include($phpbb_root_path . 'includes/page_tail.'.$phpEx);

if ( !defined('IN_PHPBB') )

{

exit;

}

if ( isset($HTTP_POST_VARS['submit']) )

{

$sql = "SELECT user_id, username, user_email, user_active, user_lang

FROM " . USERS_TABLE . "

{

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

{

{

message_die(GENERAL_MESSAGE, $lang['No_send_account_inactive']);

}

$sql = "UPDATE " . USERS_TABLE . "

SET user_newpasswd = '" .md5($user_password) . "', user_actkey = '$user_actkey'

WHERE user_id = " . $row['user_id'];

{

}

include($phpbb_root_path . 'includes/emailer.'.$phpEx);

$emailer = new emailer($board_config['smtp_delivery']);

$emailer->email_address($row['user_email']);

$emailer->set_subject();//$lang['New_password_activation']

$emailer->extra_headers($email_headers);

$emailer->assign_vars(array(

);

$emailer->send();

$emailer->reset();

$template->assign_vars(array(

);

message_die(GENERAL_MESSAGE, $message);

}

}

else

{

}

}

else

{

}

//

include($phpbb_root_path . 'includes/page_header.'.$phpEx);

$template->set_filenames(array(

);

$template->assign_vars(array(

);

include($phpbb_root_path . 'includes/page_tail.'.$phpEx);

// Output page header and profile_view template

//

$template->set_filenames(array(

);

//

// Calculate the number of days this user has been a member ($memberdays)

$percentage = 0;

}

$avatar_img = '';

if ( $profiledata['user_avatar_type'] && $profiledata['user_allowavatar'] )

{

}

}

{

}

else

{

}

//

// Generate page

'PERCENTAGE' => $percentage . '%',

'POST_DAY_STATS' => sprintf($lang['User_post_day_stats'], $posts_per_day),

'POST_PERCENT_STATS' => sprintf($lang['User_post_pct_stats'], $percentage),

'SEARCH_IMG' => $search_img,

'ICQ_STATUS_IMG' => $icq_status_img,

'AIM_IMG' => $aim_img,

'YIM_IMG' => $yim_img,

'LOCATION' => ( $profiledata['user_from'] ) ? $profiledata['user_from'] : '&nbsp;',

'OCCUPATION' => ( $profiledata['user_occ'] ) ? $profiledata['user_occ'] : '&nbsp;',

'INTERESTS' => ( $profiledata['user_interests'] ) ? $profiledata['user_interests'] : '&nbsp;',

'L_ABOUT_USER' => sprintf($lang['About_user'], $profiledata['username']),

'L_AVATAR' => $lang['Avatar'],

'L_POSTER_RANK' => $lang['Poster_rank'],

'L_TOTAL_POSTS' => $lang['Total_posts'],

'L_SEARCH_USER_POSTS' => sprintf($lang['Search_user_posts'], $profiledata['username']),

'L_CONTACT' => $lang['Contact'],

include($phpbb_root_path . 'includes/page_tail.'.$phpEx);