define('ICONS_TABLE', $table_prefix.'icons');

define('LOG_ADMIN_TABLE', $table_prefix.'log_admin');

define('LOG_MOD_TABLE', $table_prefix.'log_moderator');

define('POSTS_TABLE', $table_prefix.'posts');

define('POSTS_TEXT_TABLE', $table_prefix.'posts_text');

define('PRIVMSGS_TABLE', $table_prefix.'privmsgs');

$sql = "SELECT *

FROM " . USERS_TABLE . "

WHERE ";

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

}

function get_forum_branch($forum_id, $type = 'all', $order = 'descending', $include_forum = TRUE)

$rows = array();

$sql = 'SELECT f2.*

WHERE f1.forum_id = $forum_id

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

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

}

// Obtain list of moderators of each forum

function get_moderators(&$forum_moderators, $forum_id = false)

{

global $SID, $db, $acl_options, $phpEx;

{

}

else

{

}

$forum_sql";

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

{

$sql = "SELECT a.forum_id, u.user_id, u.username

FROM " . ACL_OPTIONS_TABLE . " o, " . ACL_USERS_TABLE . " a, " . USERS_TABLE . " u

WHERE a.auth_option_id = o.auth_option_id

$forum_sql";

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

{

$forum_moderators[$row['forum_id']][] = '<a href="profile.' . $phpEx . $SID . '&amp;mode=viewprofile&amp;u=' . $row['user_id'] . '">' . $row['username'] . '</a>';

}

$sql = "SELECT a.forum_id, g.group_name, g.group_id

FROM " . ACL_OPTIONS_TABLE . " o, " . ACL_GROUPS_TABLE . " a, " . GROUPS_TABLE . " g

$forum_sql";

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

{

$forum_moderators[$row['forum_id']][] = '<a href="groupcp.' . $phpEx . $SID . '&amp;g=' . $row['group_id'] . '">' . $row['group_name'] . '</a>';

}

return;

}

{

global $SID, $auth, $user;

return;

}

$cat_right = 0;

$padding = '';

$forum_list = '';

{

{

$padding .= '&nbsp; &nbsp;';

}

{

}

$right = $row['right_id'];

$linefeed = FALSE;

{

if ($row['left_id'] > $cat_right)

{

$dir = @opendir($dirname);

$user = array();

{

if (!is_dir($dirname . '/' . $file))

{

continue;

}

{

list($displayname) = file($dirname . '/' . $file . '/iso.txt');

$lang[$displayname] = $file;

@reset($lang);

$user_select = '<select name="' . $select_name . '">';

{

$user_select .= '<option value="' . $filename . '"' . $selected . '>' . ucwords($displayname) . '</option>';

}

$user_select .= '</select>';

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

$style_select = '<select name="' . $select_name . '">';

{

$style_select .= '<option value="' . $row['style_id'] . '"' . $selected . '>' . $row['style_name'] . '</option>';

}

global $sys_timezone, $user;

$tz_select = '<select name="' . $select_name . '">';

{

$tz_select .= '<option value="' . $offset . '"' . $selected . '>' . $zone . '</option>';

}

$tz_select .= '</select>';

{

global $template, $db, $user, $phpEx, $SID, $start;

// Is user watching this thread?

{

$can_watch = TRUE;

if (!is_null($notify_status))

{

{

{

$is_watching = 0;

}

else

{

{

{

$is_watching = TRUE;

}

else

{

{

{

redirect("login.$phpEx$SID&redirect=view$mode.$phpEx&" . $u_url . "=$match_id&unwatch=forum");

}

}

}

{

}

return;

$total_pages = ceil($num_items/$per_page);

{

return '';

}

$on_page = floor($start_item / $per_page) + 1;

{

$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++)

{

{

$page_string .= ', ';

}

}

}

else

{

for($i = 2; $i < $total_pages; $i++)

{

{

$page_string .= ', ';

}

}

}

$page_string = $user->lang['Goto_page'] . ' ' . $page_string;

{

global $user;

}

// Obtain list of naughty words and build preg style replacement arrays for use by the

FROM " . WORDS_TABLE;

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

{

$orig_word[] = '#\b(' . str_replace('\*', '\w*?', preg_quote($row['word'], '#')) . ')\b#i';

$replacement_word[] = $row['replacement'];

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

{

{

$$check_var_length[$i] = '';

}

}

// ICQ number has to be only numbers.

{

$icq = '';

}

// website has to start with http://, followed by something with length at least 3 that

// contains at least one dot.

{

{

$website = 'http://' . $website;

}

{

$website = '';

}

global $db, $auth, $template, $config, $user, $nav_links;

global $phpEx, $phpbb_root_path, $starttime;

{

case MESSAGE:

{

{

echo '<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"><html><meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"><meta http-equiv="Content-Style-Type" content="text/css"><link rel="stylesheet" href="admin/subSilver.css" type="text/css"><style type="text/css">th { background-image: url(\'admin/images/cellpic3.gif\') } td.cat { background-image: url(\'admin/images/cellpic1.gif\') }</style><title>' . $msg_title . '</title></html>' . "\n";

echo '<body><table width="100%" height="100%" border="0"><tr><td align="center" valign="middle"><table class="bg" width="80%" cellspacing="1" cellpadding="4" border="0"><tr><th>' . $msg_title . '</th></tr><tr><td class="row1" align="center">' . $msg_text . '</td></tr></table></td></tr></table></body></html>';

$db->sql_close();

exit;

}

{

page_header('', '', false);

}

}

}

{

page_message($msg_title, $msg_text, $display_header);

page_footer();

# --------------------------------------------------------

#

# Table structure for table 'phpbb_vote_results'

#

CREATE TABLE phpbb_poll_results (

session_time int(11) DEFAULT '0' NOT NULL,

session_ip varchar(40) DEFAULT '0' NOT NULL,

session_browser varchar(100) DEFAULT '' NULL,

PRIMARY KEY (session_id),

KEY session_time (session_time)

);