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

- <td class="row1" width="50%"><?php echo $user->lang['ADMIN_EMAIL']; ?>: </td>

- <td class="row1" width="50%"><?php echo $user->lang['CONTACT_EMAIL']; ?>: <br /><span class="gensmall"><?php echo $user->lang['CONTACT_EMAIL_EXPLAIN']; ?></span></td>

- <td class="row2"><input type="text" size="25" maxlength="100" name="board_contact" value="<?php echo $new['board_contact']; ?>" /></td>

- </tr>

- <tr>

-$mode = (isset($_REQUEST['mode'])) ? $_REQUEST['mode'] : '';

- if (!$auth->acl_get('a_forumadd'))

- {

- trigger_error($user->lang['NO_ADMIN']);

- }

- case 'del':

- if (!$auth->acl_get('a_forumdel'))

- {

- trigger_error($user->lang['NO_ADMIN']);

- }

-

- if (!$auth->acl_get('a_forum'))

- {

- trigger_error($user->lang['NO_ADMIN']);

- }

-// Major routines

-switch ($mode)

- case 'move_up':

- case 'move_down':

- $show_index = TRUE;

- $forum_id = intval($_GET['this_f']);

-

- $sql = 'SELECT parent_id, left_id, right_id

- FROM ' . FORUMS_TABLE . "

- WHERE forum_id = $forum_id";

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

-

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

- {

- trigger_error($user->lang['NO_FORUM']);

- }

- $db->sql_freeresult($result);

-

- extract($row);

-

- $forum_info = array($forum_id => $row);

-

- // Get the adjacent forum

- $sql = 'SELECT forum_id, left_id, right_id

- FROM ' . FORUMS_TABLE . "

- WHERE parent_id = $parent_id";

- $sql .= ($mode == 'move_up') ? " AND right_id < $right_id ORDER BY right_id DESC" : " AND left_id > $left_id ORDER BY left_id ASC";

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

-

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

- {

- // already on top or at bottom

- break;

- }

- $db->sql_freeresult($result);

-

- if ($mode == 'move_up')

- {

- $up_id = $forum_id;

- $down_id = $row['forum_id'];

- }

- else

- {

- $up_id = $row['forum_id'];

- $down_id = $forum_id;

- }

-

- $forum_info[$row['forum_id']] = $row;

- $diff_up = $forum_info[$up_id]['right_id'] - $forum_info[$up_id]['left_id'];

- $diff_down = $forum_info[$down_id]['right_id'] - $forum_info[$down_id]['left_id'];

-

- $forum_ids = array();

- $sql = 'SELECT forum_id

- FROM ' . FORUMS_TABLE . '

- WHERE left_id > ' . $forum_info[$up_id]['left_id'] . '

- AND right_id < ' . $forum_info[$up_id]['right_id'];

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

-

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

- {

- $forum_ids[] = $row['forum_id'];

- }

- $db->sql_freeresult($result);

-

- // Start transaction

- $db->sql_transaction();

-

- $sql = 'UPDATE ' . FORUMS_TABLE . '

- SET left_id = left_id + ' . ($diff_up + 1) . ', right_id = right_id + ' . ($diff_up + 1) . '

- WHERE left_id > ' . $forum_info[$down_id]['left_id'] . '

- AND right_id < ' . $forum_info[$down_id]['right_id'];

- $db->sql_query($sql);

-

- if (count($forum_ids))

- {

- $sql = 'UPDATE ' . FORUMS_TABLE . '

- SET left_id = left_id - ' . ($diff_down + 1) . ', right_id = right_id - ' . ($diff_down + 1) . '

- WHERE forum_id IN (' . implode(', ', $forum_ids) . ')';

- $db->sql_query($sql);

- }

-

- $sql = 'UPDATE ' . FORUMS_TABLE . '

- SET left_id = ' . $forum_info[$down_id]['left_id'] . ', right_id = ' . ($forum_info[$down_id]['left_id'] + $diff_up) . '

- WHERE forum_id = ' . $up_id;

- $db->sql_query($sql);

-

- $sql = 'UPDATE ' . FORUMS_TABLE . '

- SET left_id = ' . ($forum_info[$up_id]['right_id'] - $diff_down) . ', right_id = ' . $forum_info[$up_id]['right_id'] . '

- WHERE forum_id = ' . $down_id;

- $db->sql_query($sql);

-

- $db->sql_transaction('commit');

- break;

- case 'create':

- if (!trim($_POST['forum_name']))

- {

- trigger_error('Cannot create a forum without a name'); // Needs to be a lang string

- }

- $parent_id = (!empty($_POST['parent_id'])) ? intval($_POST['parent_id']) : 0;

- if ($parent_id)

- $sql = 'SELECT left_id, right_id

- FROM ' . FORUMS_TABLE . "

- WHERE forum_id = $parent_id";

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

-

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

- trigger_error('Parent does not exist', E_USER_ERROR);

- $db->sql_freeresult($result);

- extract($row);

-

- $db->sql_query('UPDATE ' . FORUMS_TABLE . "

- SET left_id = left_id + 2, right_id = right_id + 2

- WHERE left_id > $right_id");

-

- $db->sql_query('UPDATE ' . FORUMS_TABLE . "

- SET right_id = right_id + 2

- WHERE $left_id BETWEEN left_id AND right_id");

- $left_id = $right_id;

- ++$right_id;

- }

- else

- {

- $sql = 'SELECT MAX(right_id) AS right_id

- FROM ' . FORUMS_TABLE;

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

- $left_id = $db->sql_fetchfield('right_id', 0, $result) + 1;

- $db->sql_freeresult($result);

- $right_id = $left_id + 1;

- }

- $sql = array(

- 'parent_id' => $parent_id,

- 'left_id' => $left_id,

- 'right_id' => $right_id,

- 'forum_status' => intval($_POST['forum_status']),

- 'forum_postable' => (!empty($_POST['forum_postable'])) ? 1 : 0,

- 'forum_name' => $_POST['forum_name'],

- 'forum_desc' => $_POST['forum_desc'],

- 'forum_style' => (!empty($_POST['forum_style'])) ? intval($_POST['forum_style']) : 'NULL',

- 'enable_icons' => (!empty($_POST['enable_icons'])) ? 1 : 0,

- 'enable_prune' => (!empty($_POST['prune_enable'])) ? 1 : 0,

- 'prune_days' => intval($_POST['prune_days']),

- 'prune_freq' => intval($_POST['prune_freq'])

- );

- $db->sql_query('INSERT INTO ' . FORUMS_TABLE . ' ' . $db->sql_build_array('INSERT', $sql));

-

- $forum_id = $db->sql_nextid();

- // Redirect to permissions

- redirect('adm/admin_permissions.' . $phpEx . $SID . '&mode=forums&f=' . $forum_id);

- break;

- case 'modify':

- if (!($forum_id = intval($_POST['f'])))

- {

- trigger_error('No forum specified'); // lang string

- }

- $row = get_forum_info($forum_id);

- $parent_id = intval($_POST['parent_id']);

- $action = (!empty($_POST['action'])) ? $_POST['action'] : '';

- if (($row['parent_id'] != $parent_id) && ($parent_id != -1))

- {

- move_forum($forum_id, $parent_id);

- }

- elseif ($row['forum_name'] != $_POST['forum_name'])

- {

- $sql = 'UPDATE ' . FORUMS_TABLE . "

- SET forum_parents = ''

- WHERE left_id > " . $row['left_id'] . '

- AND right_id < ' . $row['right_id'];

- $db->sql_query($sql);

- $sql = array(

- 'parent_id' => $parent_id,

- 'forum_name' => (!empty($_POST['forum_name'])) ? $_POST['forum_name'] : $row['forum_name'],

- 'forum_desc' => (!empty($_POST['forum_desc'])) ? $_POST['forum_desc'] : $row['forum_desc'],

- 'forum_status' => intval($_POST['forum_status']),

- 'forum_postable' => (!empty($_POST['is_postable'])) ? 1 : 0,

- 'forum_style' => (!empty($_POST['forum_style'])) ? $_POST['forum_style'] : NULL,

- 'forum_image' => (!empty($_POST['forum_image'])) ? $_POST['forum_image'] : '',

- 'display_on_index' => (!empty($_POST['display_on_index'])) ? 1 : 0,

- 'enable_icons' => (!empty($_POST['enable_icons'])) ? 1 : 0,

- 'enable_prune' => (!empty($_POST['prune_enable'])) ? 1 : 0,

- 'prune_days' => intval($_POST['prune_days']),

- 'prune_freq' => intval($_POST['prune_freq']),

- );

-

- if (!empty($_POST['set_nonpostable']) && $action)

- if ($action == 'move' && $_POST['to_forum_id'])

- move_forum_content($forum_id, $_POST['to_forum_id']);

- elseif ($action == 'delete')

- delete_forum_content($forum_id);

- $sql['forum_posts'] = 0;

- $sql['forum_topics'] = 0;

- }

-

- $db->sql_query('UPDATE ' . FORUMS_TABLE . '

- SET ' . $db->sql_build_array('UPDATE', $sql) . "

- WHERE forum_id = $forum_id");

-

- trigger_error($user->lang['FORUM_UPDATED']);

-

- break;

-

- case 'remove':

-

- $action_subforums = (!empty($_POST['action_subforums'])) ? $_POST['action_subforums'] : '';

- $action_posts = (!empty($_POST['action_posts'])) ? $_POST['action_posts'] : '';

-

- $row = get_forum_info(intval($_GET['f']));

- extract($row);

-

- if ($action_posts == 'delete')

- {

- delete_forum_content($forum_id);

- elseif ($action_posts == 'move')

- if (empty($_POST['posts_to_id']))

- {

- trigger_error($user->lang['No_destination_forum']);

- }

- move_forum_content($forum_id, $_POST['posts_to_id']);

- if ($action_subforums == 'delete')

- $forum_ids = array($forum_id);

- $rows = get_forum_branch($forum_id, 'children', 'descending', FALSE);

- foreach ($rows as $row)

- {

- $forum_ids[] = $row['forum_id'];

- delete_forum_content($row['forum_id']);

- }

- $diff = count($forum_ids) * 2;

- $sql = 'DELETE FROM ' . FORUMS_TABLE . '

- WHERE forum_id IN (' . implode(', ', $forum_ids) . ')';

- $db->sql_query($sql);

- }

- elseif ($action_subforums == 'move')

- {

- if (empty($_POST['subforums_to_id']))

- {

- trigger_error($user->lang['No_destination_forum']);

- }

- $sql = 'SELECT forum_id

- FROM ' . FORUMS_TABLE . "

- WHERE parent_id = $forum_id";

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

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

- {

- move_forum($row['forum_id'], $_POST['subforums_to_id']);

- }

- $db->sql_freeresult($result);

- $sql = 'UPDATE ' . FORUMS_TABLE . '

- SET parent_id = ' . $_POST['subforums_to_id'] . "

- WHERE parent_id = $forum_id";

- $db->sql_query($sql);

- $diff = 2;

- $sql = 'DELETE FROM ' . FORUMS_TABLE . "

- WHERE forum_id = $forum_id";

- $db->sql_query($sql);

- }

- else

- $diff = 2;

- $db->sql_query('DELETE FROM ' . FORUMS_TABLE . " WHERE forum_id = $forum_id");

- // Resync tree

- $sql = 'UPDATE ' . FORUMS_TABLE . "

- SET right_id = right_id - $diff

- WHERE left_id < $right_id AND right_id > $right_id";

- $db->sql_query($sql);

-

- $sql = 'UPDATE ' . FORUMS_TABLE . "

- SET left_id = left_id - $diff, right_id = right_id - $diff

- WHERE left_id > $right_id";

- $db->sql_query($sql);

-

- trigger_error($user->lang['Forum_deleted']);

- break;

- case 'sync':

- sync('forum', 'forum_id', intval($_GET['this_f']));

- break;

- case 'add':

- case 'edit':

- // Show form to create/modify a forum

- if ($mode == 'edit')

- {

- $forum_id = intval($_GET['this_f']);

- $row = get_forum_info($forum_id);

- extract($row);

- $subforums_id = array();

- $subforums = get_forum_branch($forum_id, 'children');

- foreach ($subforums as $row)

- {

- $subforums_id[] = $row['forum_id'];

- }

- $parents_list = make_forums_list('all', $parent_id, $subforums_id);

- $l_title = $user->lang['Edit_forum'];

- $newmode = 'modify';

- $buttonvalue = $user->lang['Update'];

- $prune_enabled = ($prune_enable) ? 'checked="checked" ' : '';

- $forums_list = make_forums_list('forums', 0, $forum_id);

- }

- else

- $parent_id = (!empty($_POST['parent_id'])) ? $_POST['parent_id'] : 0;

- $parents_list = make_forums_list('all', $parent_id);

-

- $l_title = $user->lang['Create_forum'];

- $newmode = 'create';

- $buttonvalue = $user->lang['Create_forum'];

- $forum_id = $parent_id;

- $forum_desc = '';

- $forum_style = '';

- $forum_status = ITEM_UNLOCKED;

- $forum_name = (!empty($_POST['forum_name'])) ? htmlspecialchars($_POST['forum_name']) : '';

-

- $enable_icons = TRUE;

- $prune_enabled = '';

- $prune_days = 7;

- $prune_freq = 1;

- $styles_list = make_styles_list($forum_style);

- $forumlocked = ($forum_status == ITEM_LOCKED) ? ' selected="selected"' : '';

- $forumunlocked = ($forum_status == ITEM_UNLOCKED) ? ' selected="selected"' : '';

- $postable_checked = ($forum_postable) ? 'checked="checked" ' : '';

- $nonpostable_checked = (!$forum_postable) ? 'checked="checked" ' : '';

- $statuslist = '<option value="' . ITEM_UNLOCKED . '"' . $forumunlocked . '>' . $user->lang['Unlocked'] . "</option>\n";

- $statuslist .= '<option value="' . ITEM_LOCKED . '"' . $forumlocked . '>' . $user->lang['Locked'] . "</option>\n";

- page_header($l_title);

-<h1><?php echo $l_title ?></h1>

-

-<p><?php echo $user->lang['Forum_edit_delete_explain'] ?></p>

-

-<form action="<?php echo "admin_forums.$phpEx$SID" ?>" method="post"><table class="bg" width="100%" cellpadding="4" cellspacing="1" border="0" align="center">

- <tr>

- <th colspan="2"><?php echo $user->lang['General_settings'] ?></th>

- </tr>

- <tr>

- <td class="row1"><?php echo $user->lang['Parent'] ?></td>

- <td class="row2"><select name="parent_id"><option value="0"><?php echo $user->lang['No_parent'] ?></option><?php echo $parents_list ?></select></td>

- </tr>

- <tr>

- <td class="row1"><?php echo $user->lang['Forum_name']; ?></td>

- <td class="row2"><input class="post" type="text" size="25" name="forum_name" value="<?php echo $forum_name ?>" /></td>

- </tr>

- <td class="row1"><?php echo $user->lang['Forum_desc'] ?></td>

- <td class="row2"><textarea class="post" rows="5" cols="45" wrap="virtual" name="forum_desc"><?php echo $forum_desc ?></textarea></td>

- if ($forum_postable && $mode == 'edit')

- {

- <td class="row1"><?php echo $user->lang['FORUM_TYPE'] ?></td>

- <td class="row2"><table width="100%" cellspacing="0" cellpadding="0" border="0">

- <tr>

- <td><input type="checkbox" name="set_nonpostable" /> <?php echo $user->lang['SET_NON_POSTABLE'] ?></td>

- </tr>

- <tr>

- <td>&nbsp; &nbsp; &nbsp;<input type="radio" name="action" value="delete" checked="checked" /> <?php echo $user->lang['Delete_all_posts'] ?></td>

- </tr>

- <tr>

- <td>&nbsp; &nbsp; &nbsp;<input type="radio" name="action" value="move" /> <?php echo $user->lang['Move_posts_to'] ?> <select name="to_forum_id"><?php echo $forums_list ?></select></td>

- </tr>

- </table></td>

- }

- else

- {

- <td class="row1"><?php echo $user->lang['FORUM_TYPE'] ?></td>

- <td class="row2"><input type="radio" name="is_postable" value="1" <?php echo $postable_checked ?>/><?php echo $user->lang['IS_POSTABLE'] ?> &nbsp; <input type="radio" name="is_postable" value="0" <?php echo $nonpostable_checked ?>/><?php echo $user->lang['NOT_POSTABLE'] ?></td>

- }

- <th colspan="2"><?php echo $user->lang['Forum_settings'] ?></th>

- if ($forum_postable || $mode == 'add')

- {

- <td class="row1"><?php echo $user->lang['FORUM_STATUS'] ?></td>

- <td class="row2"><select name="forum_status"><?php echo $statuslist ?></select></td>

- <td class="row1"><?php echo $user->lang['FORUM_STYLE'] ?></td>

- <td class="row2"><select name="forum_style"><option value="0"><?php echo $user->lang['Default_style'] ?></option><?php echo $styles_list ?></select></td>

- <tr>

- <td class="row1"><?php echo $user->lang['OPTIONS'] ?></td>

- <td class="row2"><table width="100%" cellspacing="0" cellpadding="0" border="0">

- <tr>

- <td><input type="checkbox" name="enable_icons"<?php echo ((!empty($enable_icons)) ? 'checked="checked" ' : ' ') ?>/> <?php echo $user->lang['ENABLE_TOPIC_ICONS']; ?></td>

- </tr>

- if ($mode == 'edit' && $parent_id > 0)

- {

- // if this forum is a subforum put the "display on index" checkbox

- if ($parent_info = get_forum_info($parent_id))

- if ($parent_info['parent_id'] > 0 || !$parent_info['forum_postable'])

- <tr>

- <td><input type="checkbox" name="display_on_index"<?php echo ((!empty($display_on_index)) ? 'checked="checked" ' : ' ') ?>/> <?php echo $user->lang['Display_on_index'] ?></td>

- </tr>

- }

- </td></table>

- <td class="row1"><?php echo $user->lang['Forum_pruning'] ?></td>

- <td class="row2"><table cellspacing="0" cellpadding="1" border="0">

- <tr>

- <td align="right" valign="middle"><?php echo $user->lang['Enabled'] ?></td>

- <td align="left" valign="middle"><input type="checkbox" name="prune_enable" value="1" <?php echo $prune_enabled ?>/></td>

- </tr>

- <tr>

- <td align="right" valign="middle"><?php echo $user->lang['prune_days'] ?></td>

- <td align="left" valign="middle">&nbsp;<input class="post" type="text" name="prune_days" value="<?php echo $prune_days ?>" size="5" />&nbsp;<?php echo $user->lang['Days'] ?></td>

- </tr>

- <tr>

- <td align="right" valign="middle"><?php echo $user->lang['prune_freq'] ?></td>

- <td align="left" valign="middle">&nbsp;<input class="post" type="text" name="prune_freq" value="<?php echo $prune_freq ?>" size="5" />&nbsp;<?php echo $user->lang['Days'] ?></td>

- </tr>

- </table></td>

-<?php

-

- }

- else

- {

-

-?>

- <td class="row1"><?php echo $user->lang['FORUM_IMAGE']; ?></td>

- <td class="row2"><input class="post" type="text" size="25" name="forum_image" value="<?php echo $forum_image ?>" /></td>

- }

- <td class="cat" colspan="2" align="center"><input type="hidden" name="mode" value="<?php echo $newmode ?>" /><input type="hidden" name="f" value="<?php echo $forum_id ?>" /><input class="mainoption" type="submit" name="submit" value="<?php echo $buttonvalue ?>" /></td>

- break;

- page_header($user->lang['Forum_delete']);

- extract(get_forum_info(intval($_GET['this_f'])));

- $forums_list = make_forums_list('all', $parent_id, $subforums_id);

- $move_posts_list = make_forums_list('forums', $parent_id, $subforums_id);

-<h1><?php echo $user->lang['Forum_delete'] ?></h1>

-<p><?php echo $user->lang['Forum_delete_explain'] ?></p>

-<form action="admin_forums.<?php echo $phpEx . $SID ?>&mode=remove&amp;f=<?php echo $forum_id ?>" method="post"><table class="bg" cellspacing="1" cellpadding="4" border="0" align="center">

- <th colspan="2"><?php echo $user->lang['Forum_delete'] ?></th>

- </tr>

- <td class="row1"><?php echo $user->lang['Forum_name']; ?></td>

- <td class="row1"><span class="row1"><?php echo $forum_name ?></span></td>

- if ($forum_postable)

- <td class="row1"><?php echo $user->lang['Action'] ?></td>

- <td class="row1"><input type="radio" name="action_posts" value="delete" checked="checked" /> <?php echo $user->lang['Delete_all_posts'] ?></td>

- </tr>

- <tr>

- <td class="row1"></td>

- <td class="row1"><input type="radio" name="action_posts" value="move" /> <?php echo $user->lang['Move_posts_to'] ?> <select name="posts_to_id" ?><option value="0"></option><?php echo $move_posts_list ?></select></td>

- <td class="row1"><?php echo $user->lang['Action'] ?></td>

- <td class="row1"><input type="radio" name="action_subforums" value="delete" checked="checked" /> <?php echo $user->lang['Delete_subforums'] ?></td>

- </tr>

- <tr>

- <td class="row1"></td>

- <td class="row1"><input type="radio" name="action_subforums" value="move" /> <?php echo $user->lang['Move_subforums_to'] ?> <select name="subforums_to_id" ?><option value="0"></option><?php echo $forums_list ?></select></td>

- <td class="cat" colspan="2" align="center"><input type="submit" name="submit" value="<?php echo $user->lang['Move_and_Delete'] ?>" class="mainoption" /></td>

- </table>

-</form>

- break;

- $navigation = $user->lang['INDEX'];

- $navigation = '<a href="admin_forums.' . $phpEx . $SID . '">' . $user->lang['INDEX'] . '</a>';

-<p><?php echo $user->lang['Forum_admin_explain']; ?></p>

-<form method="post" action="<?php echo "admin_forums.$phpEx$SID&amp;mode=add" ?>"><table width="100%" cellspacing="2" cellpadding="2" border="0" align="center">

- <td><?php echo $navigation ?></td>

-<table class="bg" width="100%" cellspacing="1" cellpadding="3" border="0" align="center">

- <th colspan="6"><?php echo $user->lang['Forum_admin'] ?></th>

-$result = $db->sql_query('SELECT * FROM ' . FORUMS_TABLE . " WHERE parent_id = $forum_id ORDER BY left_id");

- // DEBUG

- $parent_id = $row['parent_id'];

- $forum_title = $row['forum_name'];

- $forum_desc = $row['forum_desc'];

- if ($row['forum_status'] != ITEM_LOCKED)

- if ($row['left_id'] + 1 != $row['right_id'])

- {

- $folder_image = '<img src="images/icon_subfolder.gif" width="46" height="25" alt="' . $user->lang['SUBFORUM'] . '" alt="' . $user->lang['SUBFORUM'] . '" />';

- }

- else

- {

- $folder_image = '<img src="images/icon_folder.gif" width="46" height="25" alt="' . $user->lang['FOLDER'] . '" alt="' . $user->lang['FOLDER'] . '" />';

- }

- $folder_image = '<img src="images/icon_folder_lock.gif" width="46" height="25" alt="' . $user->lang['LOCKED'] . '" alt="' . $user->lang['LOCKED'] . '" />';

- }

- $url = $phpEx . $SID . '&amp;f=' . $forum_id . '&amp;this_f=' . $row['forum_id'];

- $forum_title = '<a href="admin_forums.' . $phpEx . $SID . '&amp;f=' . $row['forum_id'] . '">' . $forum_title . '</a>';

- <td class="row2" width="50%"><span class="gen"><?php echo $forum_title ?></span><br /><span class="gensmall"><?php echo $forum_desc ?></span></td>

- <td class="row1" width="5%" align="center" valign="middle" title="<?php echo $user->lang['TOPICS']; ?>"><span class="gen"><?php echo $row['forum_topics'] ?></span></td>

- <td class="row2" width="5%" align="center" valign="middle" title="<?php echo $user->lang['POSTS']; ?>"><span class="gen"><?php echo $row['forum_posts'] ?></span></td>

- <td class="row2" width="15%" align="center" valign="middle" nowrap="nowrap"><span class="gen"><a href="admin_forums.<?php echo $url ?>&amp;mode=move_up"><?php echo $user->lang['MOVE_UP'] ?></a> <br /> <a href="admin_forums.<?php echo $url ?>&amp;mode=move_down"><?php echo $user->lang['MOVE_DOWN'] ?></a></span></td>

- <td class="row2" width="20%" align="center" valign="middle" nowrap="nowrap">&nbsp;<span class="gen"><a href="admin_forums.<?php echo $url ?>&amp;mode=edit"><?php echo $user->lang['EDIT'] ?></a> | <a href="admin_forums.<?php echo $url ?>&amp;mode=delete"><?php echo $user->lang['DELETE'] ?></a> | <a href="admin_forums.<?php echo $url ?>&amp;mode=sync"><?php echo $user->lang['Resync'] ?></a></span>&nbsp;</td>

- <td width="100%" colspan="6" class="cat"><input type="hidden" name="mode" value="add" /><input type="hidden" name="parent_id" value="<? echo $forum_id ?>" /><input type="text" name="forum_name" /> <input class="liteoption" type="submit" name="submit" value="<?php echo $user->lang['Create_forum'] ?>" /></td>

- <td align="right"><?php echo $user->lang['Select_forum']; ?>: <select name="f" onchange="if(this.options[this.selectedIndex].value != -1){ this.form.submit() }"><?php echo $forum_box; ?></select> <input class="liteoption" type="submit" value="<?php echo $user->lang['Go']; ?>" /><input type="hidden" name="sid" value="<?php echo $user->session_id; ?>" /></td>

-

-// ------------------

-// Begin function block

-//

-function get_forum_info($forum_id)

-{

- global $db;

- $sql = 'SELECT *

- FROM ' . FORUMS_TABLE . "

- WHERE forum_id = $forum_id";

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

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

- {

- trigger_error("Forum #$forum_id does not exist", E_USER_ERROR);

- }

- return $row;

-}

-function make_forums_list($mode = 'all', $selected_id = 0, $exclude_id = array())

-{

- global $db;

- if (!is_array($exclude_id))

- {

- $exclude_id = array($exclude_id);

- }

- $sql = 'SELECT f2.*

- FROM ' . FORUMS_TABLE . ' f1, ' . FORUMS_TABLE . ' f2

- WHERE f1.parent_id = 0

- AND f2.left_id BETWEEN f1.left_id AND f1.right_id

- ORDER BY f2.left_id';

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

- $list = '';

- $indent = array();

- $current_indent = 0;

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

- {

- if ($row['parent_id'] == 0)

- {

- $current_indent = 0;

- }

- elseif (!isset($indent[$row['parent_id']]))

- {

- ++$current_indent;

- $indent[$row['parent_id']] = $current_indent;

- }

- else

- {

- $current_indent = $indent[$row['parent_id']];

- }

- if (($mode == 'forums' && !$row['forum_postable'])

- || ($mode == 'categories' && $row['forum_postable'])

- || (in_array($row['forum_id'], $exclude_id)))

- {

- continue;

- }

- if ($mode == 'all' && !$row['parent_id'])

- {

- $list .= "<option value=\"-1\">&nbsp;</option>\n";

- }

- $list .= '<option value="' . $row['forum_id'] . '"';

- $list .= ($row['forum_id'] == $selected_id) ? ' selected="selected">' : '>';

- $list .= str_repeat('--', $current_indent) . (($indent) ? ' ' : '') . $row['forum_name'] . "</option>\n";

- }

- return $list;

-}

-function make_styles_list($selected_id = 0)

- $list = '';

- $result = $db->sql_query('SELECT style_id, style_name FROM ' . STYLES_TABLE . ' ORDER BY style_name');

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

- $list .= '<option value="' . $row['style_id'] . '"' . (($row['style_id'] == $selected_id) ? ' selected="selected">' : '>') . htmlspecialchars($row['style_name']) . "</option>\n";

- return $list;

- $result = $db->sql_query('SELECT MAX(right_id) AS right_id FROM ' . FORUMS_TABLE . ' WHERE forum_id NOT IN (' . implode(', ', $moved_ids) . ')');

- $right_id = $db->sql_fetchfield('right_id', 0, $result);

- $diff = '+ ' . ($right_id - $from_data['left_id'] + 1);

- SET left_id = left_id $diff, right_id = right_id $diff, forum_parents = ''

- WHERE forum_id IN (" . implode(', ', $moved_ids) . ')';

- $db->sql_query('UPDATE ' . ACL_GROUPS_TABLE . " SET forum_id = $to_id WHERE forum_id = $from_id");

- $db->sql_query('UPDATE ' . MODERATOR_TABLE . " SET forum_id = $to_id WHERE forum_id = $from_id");

- $db->sql_query('UPDATE ' . LOG_MOD_TABLE . " SET forum_id = $to_id WHERE forum_id = $from_id");

- $db->sql_query('UPDATE ' . POSTS_TABLE . " SET forum_id = $to_id WHERE forum_id = $from_id");

- $db->sql_query('UPDATE ' . TOPICS_TABLE . " SET forum_id = $to_id WHERE forum_id = $from_id");

- //

- // TODO: untested yet

- //

- FROM ' .TOPICS_TABLE . ' t1

- LEFT JOIN ' . TOPICS_TABLE . " t2 ON t1.topic_moved_id = t2.topic_id AND t1.forum_id = t2.forum_id

- WHERE t1.forum_id = $to_id";

- $topic_ids = array();

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

- $topic_ids[] = $row['topic_id'];

- }

- if (count($topic_ids))

- {

- $db->sql_query('DELETE FROM ' . TOPICS_TABLE . ' WHERE topic_id IN (' . implode(', ', $topic_ids) . ')');

- sync('forum', 'forum_id', $to_id);

- //

- // TODO: there might be conflicts in ACL tables =\

- // make sure that the query that retrieves shadow topics uses the correct index (topic_type or topic_moved_id)

- //

- $db->sql_query('DELETE FROM ' . ACL_GROUPS_TABLE . " WHERE forum_id = $forum_id");

- $db->sql_query('DELETE FROM ' . MODERATOR_TABLE . " WHERE forum_id = $forum_id");

- $db->sql_query('DELETE FROM ' . LOG_MOD_TABLE . " WHERE forum_id = $forum_id");

- $db->sql_query('DELETE FROM ' . FORUMS_WATCH_TABLE . " WHERE forum_id = $forum_id");

- $ids = array();

- $result = $db->sql_query('SELECT post_id FROM ' . POSTS_TABLE . " WHERE forum_id = $forum_id");

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

- $ids[] = $row['post_id'];

- $ids = implode(',', $ids);

- if ($ids)

- $db->sql_query('DELETE FROM ' . SEARCH_MATCH_TABLE . " WHERE post_id IN ($ids)");

- $db->sql_query('DELETE FROM ' . POSTS_TABLE . " WHERE forum_id = $forum_id");

- $db->sql_query('DELETE FROM ' . POSTS_TEXT_TABLE . " WHERE post_id IN ($ids)");

- }

- $ids = array();

- $result = $db->sql_query('SELECT topic_id FROM ' . TOPICS_TABLE . " WHERE forum_id = $forum_id");

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

- {

- $ids[] = $row['topic_id'];

- $ids = implode(',', $ids);

- if ($ids)

- $db->sql_query('DELETE FROM ' . TOPICS_WATCH_TABLE . " WHERE topic_id IN ($ids)");

- $db->sql_query('DELETE FROM ' . TOPICS_TABLE . " WHERE forum_id = $forum_id");

- $db->sql_query('DELETE FROM ' . TOPICS_TABLE . " WHERE topic_moved_id IN ($ids)");

- // delete polls

- // OPTIMIZE / VACUUM table ?

-$submit = array_values(preg_grep('#^submit_(.*)$#i', array_keys($_POST)));

- WHERE forum_postable = 1' . (($forum_id) ? ' AND forum_id = ' . $forum_id : '') . '

-/*

-$dp = opendir($phpbb_root_path . 'templates/cache/');

-while ($file = readdir($dp))

-{

- if (!is_file($phpbb_root_path . 'templates/cache/' . $file) && !is_link($phpbb_root_path . 'templates/cache/' . $file) && $file != '.' && $file != '..')

- {

- $selected = ($tplroot == $file) ? ' selected="selected"' : '';

- $tplroot_options .= '<option name="' . $file . '"' . $selected . '>' . $file . '</option>';

- }

-}

-closedir($dp);

-*/

-

- $fp = fopen($phpbb_root_path . 'templates/cache/' . $tplroot . '/' . $tplname . '.html.' . $phpEx, 'w+');

- $fp = fopen($phpbb_root_path . 'templates/cache/' . $tplroot . '/' . $tplname . '.html.' . $phpEx, 'r');

- $template->decompile($str);

- $dp = @opendir($phpbb_root_path . 'templates/cache/' . $tplroot . '/');

- if (strstr($file, '.html.' . $phpEx) && is_file($phpbb_root_path . 'templates/cache/' . $tplroot . '/' . $file))

- $forum_box = '<option value="0">' . $user->lang['ALL_FORUMS'] . '</option>' . make_forum_select($forum_id, false, false);

- <td class="cat" colspan="5" height="28" align="center"><span class="gensmall"><?php echo $user->lang['DISPLAY_LOG']; ?>: &nbsp;<?php echo $s_limit_days; ?>&nbsp;<?php echo $user->lang['SORT_BY']; ?> <?php echo $s_sort_key; ?> <?php echo $s_sort_dir; ?>&nbsp;<input class="liteoption" type="submit" value="<?php echo $user->lang['GO']; ?>" name="sort" /></span></td>

- <td align="right" valign="top" nowrap="nowrap"><?php

-?><b><span class="gensmall"><a href="javascript:marklist(true);" class="gensmall"><?php echo $user->lang['MARK_ALL']; ?></a> :: <a href="javascript:marklist(false);" class="gensmall"><?php echo $user->lang['UNMARK_ALL']; ?></a></span></b>&nbsp;<br /><br /><?php

- $pagination = generate_pagination("admin_viewlogs.$phpEx$SID&amp;mode=$mode&amp;sort_days=$sort_days&amp;sort_key=$sort_key&amp;sort_dir=$sort_dir", $log_count, $config['topics_per_page'], $start);

-

- ?><span class="nav"><?php echo $pagination; ?></span></td>

- $dbsize = $user->lang['Not_available'];

-<div align="center"><span class="copyright">Powered by phpBB <?php echo $config['version']; ?> &copy; 2002 <a href="http://www.phpbb.com/" target="_phpbb" class="copyright">phpBB Group</a></span></div>

- if (!empty($cache))

- {

- $cache->unload();

- }

-

-}

-a.gen, a.genmed, a.gensmall {

- color: #006699;

- text-decoration: none;

-}

-a.nav {

- color: #006699;

-a.copyright {

- color: #444444;

- text-decoration: none;

-}

-

-a.gen:hover, a.genmed:hover, a.gensmall:hover {

- color: #DD6900;

- text-decoration: underline;

-}

-a.nav:hover {

- text-decoration: underline;

-a.copyright:hover {

- color: #DD6900;

- 'U_VIEW_FORUM' => 'viewforum.' . $phpEx . $SID . '&amp;f=' . $parent_forum_id)

- 'U_VIEW_FORUM' => 'viewforum.' . $phpEx . $SID . '&amp;f=' . $forum_data['forum_id'])

-function gen_sort_selects(&$limit_days, &$sort_by_text, &$sort_days, &$sort_key, &$sort_dir, &$s_limit_days, &$s_sort_key, &$s_sort_dir)

- $sql = 'SELECT forum_id, forum_name, forum_postable, left_id, right_id

- if (!$row['forum_postable'] && ($row['left_id'] + 1 == $row['right_id']))

- $template->assign_vars(array(

- 'META' => '<meta http-equiv="refresh" content="3;url=' . "view$mode.$phpEx$SID&amp;" . $u_url . "=$match_id&amp;start=$start" . '">')

- );

-

- $template->assign_vars(array(

- 'META' => '<meta http-equiv="refresh" content="3;url=' . "view$mode.$phpEx$SID&amp;" . $u_url . "=$match_id&amp;start=$start" . '">')

- );

-

- $s_watching = ($is_watching) ? '<a href="' . "view$mode." . $phpEx . $SID . '&amp;' . $u_url . "=$match_id&amp;unwatch=$mode&amp;start=$start" . '">' . $user->lang['STOP_WATCHING_' . strtoupper($mode)] . '</a>' : '<a href="' . "view$mode." . $phpEx . $SID . '&amp;' . $u_url . "=$match_id&amp;watch=$mode&amp;start=$start" . '">' . $user->lang['START_WATCHING_' . strtoupper($mode)] . '</a>';

-function markread($mode, $forum_id = 0, $topic_id = 0, $post_id = 0)

- $current_time = time();

- global $db, $cache, $config;

- $url = generate_board_url() . preg_replace('#^/?(.*?)/?$#', '/\1', trim($url));

- echo '<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"><html><head><meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"><meta http-equiv="refresh" content="0; url=' . $url . '"><title>Redirect</title></head><body><div align="center">If your browser does not support meta redirection please click <a href="' . $url . '">HERE</a> to be redirected</div></body></html>';

-// This needs altering to allow for ignoring acl checks ... they aren't needed

-// everywhere ...

-function make_forum_select($select_id = false, $ignore_id = false, $ignore_acl = false)

- $acl = ($ignore_acl) ? '' : 'f_list';

- $rowset = get_forum_list($acl, FALSE, FALSE, TRUE);

- if ($row['forum_id'] == $ignore_id)

- if ($row['right_id'] - $row['left_id'] > 1)

- $holding .= '<option class="sep" value="' . $row['forum_id'] . '"' . $selected . '>' . $padding . '+ ' . $row['forum_name'] . '</option>';

- $forum_list .= $holding . '<option value="' . $row['forum_id'] . '"' . $selected . '>' . $padding . '- ' . $row['forum_name'] . '</option>';

- $sql = 'SELECT forum_id, forum_name, forum_postable, left_id, right_id

- if ($postable_only && !$row['forum_postable'])

- $where_sql = (is_array($topic_ids)) ? 'IN (' . implode(', ', $topic_ids) . ')' : '= ' . $topic_ids;

- WHERE topic_id ' . $where_sql;

- }

-

- $sql = 'DELETE FROM ' . TOPICS_TABLE . "

- WHERE topic_moved_id $where_sql

- AND forum_id = " . $forum_id;

- $db->sql_query($sql);

-

- $sql = 'UPDATE ' . TOPICS_TABLE . "

- SET forum_id = $forum_id

- WHERE topic_id " . $where_sql;

- $db->sql_query($sql);

-

- $sql = 'UPDATE ' . POSTS_TABLE . "

- SET forum_id = $forum_id

- WHERE topic_id " . $where_sql;

- $db->sql_query($sql);

-

- $sql = 'UPDATE ' . LOG_MOD_TABLE . "

- SET forum_id = $forum_id

- WHERE topic_id " . $where_sql;

- $db->sql_query($sql);

- if ($auto_sync)

- {

- $sql = 'SELECT * FROM ' . TOPICS_TABLE . ' WHERE topic_id = ' . $topic_id;

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

- trigger_error('Topic_post_not_exist');

- $where_sql = "WHERE $where_type " . ((!is_array($where_ids)) ? "= $where_ids" : 'IN (' . implode(', ', $where_ids) . ')');

-

- // TODO: clean up topics cache if any, last read marking, probably some other stuff too

- $where_sql = ' IN (' . implode(', ', $topic_ids) . ')';

- $db->sql_query('DELETE FROM ' . LASTREAD_TABLE . ' WHERE topic_id' . $where_sql);

- $db->sql_query('DELETE FROM ' . POLL_VOTES_TABLE . ' WHERE topic_id' . $where_sql);

- $db->sql_query('DELETE FROM ' . POLL_OPTIONS_TABLE . ' WHERE topic_id' . $where_sql);

- $db->sql_query('DELETE FROM ' . TOPICS_WATCH_TABLE . ' WHERE topic_id' . $where_sql);

- $db->sql_query('DELETE FROM ' . TOPICS_TABLE . ' WHERE topic_moved_id' . $where_sql);

- $db->sql_query('DELETE FROM ' . TOPICS_TABLE . ' WHERE topic_id' . $where_sql);

- $where_sql = ' WHERE post_id IN (' . implode(', ', $post_ids) . ')';

- $db->sql_query('DELETE FROM ' . POSTS_TABLE . $where_sql);

- $db->sql_query('DELETE FROM ' . RATINGS_TABLE . $where_sql);

- $db->sql_query('DELETE FROM ' . REPORTS_TABLE . $where_sql);

- $db->sql_query('DELETE FROM ' . SEARCH_MATCH_TABLE . $where_sql);

-//

- global $db, $dbms;

- $where_sql_and = $where_sql . "\n\tAND";

- $where_sql_and = $where_sql . "\n\tAND";

-

- break;

- switch ($dbms)

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

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

- {

- if (($row['post_attachment'] && !$row['attachments']) || ($row['attachments'] && !$row['post_attachment']))

- {

- $post_ids[] = $row['post_id'];

- }

- }

- break;

- $topic_ids = array();

- switch ($dbms)

- OR (t.topic_attachment = 0 AND attachments > 0))

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

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

- {

- if (($row['topic_attachment'] && !$row['attachments'])

- || ($row['attachments'] && !$row['topic_attachment']))

- {

- $topic_ids[] = $row['topic_id'];

- }

- }

- break;

- // NOTE: untested

- $sql = 'SELECT p.post_id

- FROM ' . POSTS_TABLE . ' t

- LEFT JOIN ' . REPORTS_TABLE . " r ON r.post_id = t.post_id

- $where_sql

- AND ((t.post_reported = 1 AND r.post_id IS NULL)

- OR (t.post_reported = 0 AND r.post_id > 0))

- GROUP p.post_id";

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

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

- $post_ids[] = $row['post_id'];

- $db->sql_freeresult();

- if (count($post_ids))

- // NOTE: untested

- $sql = 'SELECT t.topic_id, t.topic_reported, p.post_reported

- FROM ' . TOPICS_TABLE . ' t

- LEFT JOIN ' . POSTS_TABLE . " p ON p.topic_id = t.topic_id

- $where_sql

- GROUP BY p.topic_id, p.post_reported";

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

- if (!isset($topic_data[$row['topic_id']]))

- {

- $topic_data[$row['topic_id']] = array(

- 'topic_reported' => $row['topic_reported'],

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

- );

- }

- else

- $topic_data[$row['topic_id']]['post_reported'] |= $row['post_reported'];

- }

- foreach ($topic_data as $topic_id => $row)

- {

- if ($row['post_reported'] != $row['topic_reported'])

- $topic_ids[] = $topic_id;

- }

- if (count($topic_ids))

- {

- break;

- $forum_ids = array();

-

-

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

- {

- $forum_ids[] = $row['forum_id'];

- }

- if (count($forum_ids))

-

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

- if (isset($row[$fieldname]))

- {

- $sql['forum_' . $fieldname] = (string) $row[$fieldname];

- }

- else

- {

- $sql['forum_' . $fieldname] = '';

- }

- if (isset($row[$fieldname]))

- {

- $sql['forum_' . $fieldname] = (int) $row[$fieldname];

- }

- else

- {

- $sql['forum_' . $fieldname] = 0;

- }

- $sql = 'UPDATE ' . FORUMS_TABLE . '

- break;

-

-

-

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

- $fieldnames[] = 'reported';

-

- $fieldnames[] = 'attachment';

-

- SET ' . $db->sql_build_array('UPDATE', $sql) . '

- WHERE topic_id = ' . $topic_id;

- $forum_ids = array();

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

- {

- $forum_ids[] = $row['forum_id'];

- }

- if (count($forum_ids))

- break;

- $p_result = delete_topics('topic_id', $topic_list, $auto_sync);

- return $p_result;

- if (preg_match('/^\/\*/', preg_quote($lines[$i])))

- if (preg_match('/\*\/$/', preg_quote($lines[$i])))

- $total_quotes = preg_match_all("/'/", $tokens[$i], $matches);

- $escaped_quotes = preg_match_all("/(?<!\\\\)(\\\\\\\\)*\\\\'/", $tokens[$i], $matches);

- $total_quotes = preg_match_all("/'/", $tokens[$j], $matches);

- $escaped_quotes = preg_match_all("/(?<!\\\\)(\\\\\\\\)*\\\\'/", $tokens[$j], $matches);

-// Cache moderators, called whenever permissions are

-// changed via admin_permissions. Changes of username

-// and group names must be carried through for the

-// moderators table

- if (!$row['forum_postable'] && ($row['left_id'] + 1 == $row['right_id']))

- if (!$row['forum_postable'] && $row['parent_id'] == $root_data['forum_id'])

- elseif ($row['forum_postable'])

- if (!$row['forum_postable'])

- $folder_image = ($forum_unread[$forum_id]) ? 'forum_new' : 'forum';

- 'S_IS_CAT' => FALSE,

- 'POSTS' => $row['forum_posts'],

-

- 'U_VIEWFORUM' => 'viewforum.' . $phpEx . $SID . '&amp;f=' . $row['forum_id'])

- 'S_HAS_SUBFORUM' => ($visible_forums) ? TRUE : FALSE,

-

- if (preg_match('/^[a-z0-9\.\-_\+]+@[a-z0-9\-_]+\.([a-z0-9\-_]+\.)*?[a-z]+$/is', $email))

- preg_match_all('/\b([\w]+)\b/', $text, $split_entries);

- $sql = '';

- $sql .= (($sql != '') ? ', ' : '') . $cur_words[$word_in][$word];

- $sql = "DELETE FROM " . SEARCH_MATCH_TABLE . " WHERE word_id IN ($sql) AND post_id = " . intval($post_id) . " AND title_match = $title_match";

- $title_match = ( $word_in == 'title' ) ? 1 : 0;

- $sql = "INSERT INTO " . SEARCH_MATCH_TABLE . " (post_id, word_id, title_match) SELECT $post_id, word_id, $title_match FROM " . SEARCH_WORD_TABLE . " WHERE word_text IN (" . implode(', ', preg_replace('#^(.*)$#', '\'\1\'', $word_ary)) . ")";

- $result = $db->sql_query("SELECT SUM(forum_posts) AS total_posts FROM " . FORUMS_TABLE);

- $sql = "SELECT word_id

- FROM " . SEARCH_MATCH_TABLE . "

- HAVING COUNT(word_id) > " . floor($row['total_posts'] * 0.6);

- $in_sql = '';

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

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

- }

- $db->sql_freeresult($result);

- if ($in_sql)

- {

- $sql = "UPDATE " . SEARCH_WORD_TABLE . "

- SET word_common = " . TRUE . "

- WHERE word_id IN ($in_sql)";

- $sql = "DELETE FROM " . SEARCH_MATCH_TABLE . "

- WHERE word_id IN ($in_sql)";

- $sql = "SELECT w.word_id

- FROM ( " . SEARCH_WORD_TABLE . " w

- LEFT JOIN " . SEARCH_MATCH_TABLE . " m ON w.word_id = m.word_id

- GROUP BY m.word_id";

- $in_sql = '';

- $in_sql .= ', ' . $row['word_id'];

- WHERE word_id IN (' . substr($in_sql, 2) . ')';

-// Changes for 2.2:

-//

-// * Allow use of Smarty plug-ins?

-// * Reduce number of methods and variables

-

-// End session management

- 'body' => 'index_body.html'

-));

-INSERT INTO phpbb_styles_imageset (imageset_id, imageset_name, imageset_path, btn_post, btn_post_pm, btn_reply, btn_reply_pm, btn_locked, btn_profile, btn_pm, btn_delete, btn_ip, btn_quote, btn_search, btn_edit, btn_report, btn_email, btn_www, btn_icq, btn_aim, btn_yim, btn_msnm, btn_no_email, btn_no_www, btn_no_icq, btn_no_aim, btn_no_yim, btn_no_msnm, btn_online, btn_offline, btn_topic_watch, btn_topic_unwatch, icon_unapproved, icon_reported, icon_attach, icon_post, icon_post_new, icon_post_latest, icon_post_newest, forum, forum_new, forum_locked, sub_forum, sub_forum_new, folder, folder_posted, folder_new, folder_new_posted, folder_hot, folder_hot_posted, folder_hot_new, folder_hot_new_posted, folder_locked, folder_locked_posted, folder_locked_new, folder_locked_new_posted, folder_sticky, folder_sticky_posted, folder_sticky_new, folder_sticky_new_posted, folder_announce, folder_announce_posted, folder_announce_new, folder_announce_new_posted, poll_left, poll_center, poll_right) VALUES (1, 'subSilver &copy; phpBB Group', 'subSilver', '"imagesets/subSilver/{LANG}/btn_post.gif" width="82" height="25" border="0"', '"imagesets/subSilver/{LANG}/btn_post_pm.gif" width="82" height="25" border="0"', '"imagesets/subSilver/{LANG}/btn_reply.gif" width="88" height="25" border="0"', '"imagesets/subSilver/{LANG}/reply.gif" width="88" height="25" border="0"', '"imagesets/subSilver/{LANG}/btn_locked.gif" width="82" height="25" border="0"', '"imagesets/subSilver/{LANG}/btn_profile.gif" width="59" height="18" border="0"', '"imagesets/subSilver/{LANG}/btn_pm.gif" width="59" height="18" border="0"', '"imagesets/subSilver/{LANG}/btn_delete.gif" width="16" height="18" border="0"', '"imagesets/subSilver/{LANG}/btn_ip.gif" width="16" height="18" border="0"', '"imagesets/subSilver/{LANG}/btn_quote.gif" width="59" height="18" border="0"', '"imagesets/subSilver/{LANG}/btn_search.gif" width="59" height="18" border="0"', '"imagesets/subSilver/{LANG}/btn_edit.gif" width="59" height="18" border="0"', '"imagesets/subSilver/{LANG}/btn_report.gif" width="59" height="18" border="0"', '"imagesets/subSilver/{LANG}/btn_email.gif" width="59" height="18" border="0"', '"imagesets/subSilver/{LANG}/btn_www.gif" width="59" height="18" border="0"', '"imagesets/subSilver/{LANG}/btn_icq.gif" width="59" height="18" border="0"', '"imagesets/subSilver/{LANG}/btn_aim.gif" width="59" height="18" border="0"', '"imagesets/subSilver/{LANG}/btn_yim.gif" width="59" height="18" border="0"', '"imagesets/subSilver/{LANG}/btn_msnm.gif" width="59" height="18" border="0"', '', '', '', '', '', '', '"imagesets/subSilver/{LANG}/btn_online.gif" width="59" height="18" border="0"', '"imagesets/subSilver/{LANG}/btn_offline.gif" width="59" height="18" border="0"', NULL, NULL, '"imagesets/subSilver/icon_unapproved.gif" width="19" height="18" border="0"', '"imagesets/subSilver/icon_reported.gif" width="19" height="18" border="0"', '"imagesets/subSilver/icon_attach.gif" width="14" height="18" border="0"', '"imagesets/subSilver/icon_minipost.gif" width="12" height="9" border="0"', '"imagesets/subSilver/icon_minipost_new.gif" width="12" height="9" border="0"', '"imagesets/subSilver/icon_latest_reply.gif" width="18" height="9" border="0"', '"imagesets/subSilver/icon_newest_reply.gif" width="18" height="9" border="0"', '"imagesets/subSilver/folder_big.gif" width="46" height="25" border="0"', '"imagesets/subSilver/folder_new_big.gif" width="46" height="25" border="0"', '"imagesets/subSilver/folder_locked_big.gif" width="46" height="25" border="0"', '"imagesets/subSilver/subfolder_big.gif" width="46" height="25" border="0"', '"imagesets/subSilver/subfolder_new_big.gif" width="46" height="25" border="0"', '"imagesets/subSilver/folder.gif" width="19" height="18" border="0"', '"imagesets/subSilver/folder_posted.gif" width="19" height="18" border="0"', '"imagesets/subSilver/folder_new.gif" width="19" height="18" border="0"', '"imagesets/subSilver/folder_new_posted.gif" width="19" height="18" border="0"', '"imagesets/subSilver/folder_hot.gif" width="19" height="18" border="0"', '"imagesets/subSilver/folder_hot_posted.gif" width="19" height="18" border="0"', '"imagesets/subSilver/folder_new_hot.gif" width="19" height="18" border="0"', '"imagesets/subSilver/folder_new_hot_posted.gif" width="19" height="18" border="0"', '"imagesets/subSilver/folder_lock.gif" width="19" height="18" border="0"', '"imagesets/subSilver/folder_lock_posted.gif" width="19" height="18" border="0"', '"imagesets/subSilver/folder_lock_new.gif" width="19" height="18" border="0"', '"imagesets/subSilver/folder_lock_new_posted.gif" width="19" height="18" border="0"', '"imagesets/subSilver/folder_sticky.gif" width="19" height="18" border="0"', '"imagesets/subSilver/folder_sticky_posted.gif" width="19" height="18" border="0"', '"imagesets/subSilver/folder_sticky_new.gif" width="19" height="18" border="0"', '"imagesets/subSilver/folder_sticky_new_posted.gif" width="19" height="18" border="0"', '"imagesets/subSilver/folder_announce.gif" width="19" height="18" border="0"', '"imagesets/subSilver/folder_announce_posted.gif" width="19" height="18" border="0"', '"imagesets/subSilver/folder_announce_new.gif" width="19" height="18" border="0"', '"imagesets/subSilver/folder_announce_new_posted.gif" width="19" height="18" border="0"', '"imagesets/subSilver/vote_lcap.gif" width="4" height="12" border="0"', '"imagesets/subSilver/voting_bar.gif" height="12" border="0"', '"imagesets/subSilver/vote_rcap.gif" width="4" height="12" border="0"');

-INSERT INTO phpbb_forums (forum_id, forum_name, forum_desc, left_id, right_id, parent_id, forum_postable, forum_posts, forum_topics, forum_topics_real, forum_last_post_id, forum_last_poster_id, forum_last_poster_name, forum_last_post_time) VALUES (1, 'My first Category', '', 1, 4, 0, 0, 1, 1, 1, 1, 2, 'Admin', 972086460);

-INSERT INTO phpbb_forums (forum_id, forum_name, forum_desc, left_id, right_id, parent_id, forum_postable, forum_posts, forum_topics, forum_topics_real, forum_last_post_id, forum_last_poster_id, forum_last_poster_name, forum_last_post_time) VALUES (2, 'Test Forum 1', 'This is just a test forum.', 2, 3, 1, 1, 1, 1, 1, 1, 2, 'Admin', 972086460);

- forum_image varchar(50),

- forum_postable tinyint(4) DEFAULT '0' NOT NULL,

-

- 'RUN_HOW' => 'When to run',

- 'RUN_AS_NOW'=> 'Run now',

- 'RUN_AS_EVT'=> 'Run as Event',

- 'RUN_AS_CRN'=> 'Run as Cron',

- 'ADMIN_EMAIL' => 'Admin Email Address',

- 'EMAIL_SIG_EXPLAIN' => 'This text will be attached to all emails the board sends',

- 'CONTACT_EMAIL' => 'Abuse email address',

- 'CONTACT_EMAIL_EXPLAIN' => 'This address will be used whenever a specific contact point is needed, e.g. spam, failures, etc.',

- 'USE_SMTP_EXPLAIN' => 'Say yes if you want or have to send email via a named server instead of the local mail function',

- 'SMTP_PORT_EXPLAIN' => 'Only change this if you know your SMTP server is on a different port',

- 'SMTP_USERNAME_EXPLAIN' => 'Only enter a username if your smtp server requires it',

- 'SMTP_PASSWORD_EXPLAIN' => 'Only enter a password if your smtp server requires it',

- 'Forum_admin_explain' => 'In phpBB 2.2 there are no categories, everything is forum based. Each forum can have an unlimited number of sub-forums and you can determine whether each may be posted to or not (i.e. whether it acts like an old category). Here you can add, edit, delete, lock, unlock individual forums as well as set certain additional controls. If your posts and topics have got out of sync you can also resynchronise a forum.',

- 'Edit_forum' => 'Edit forum',

- 'Edit_category' => 'Edit category',

- 'Create_forum' => 'Create new forum',

- 'Remove' => 'Remove',

- 'Config_updated' => 'Forum configuration updated successfully',

- 'EDIT' => 'Edit',

- 'MOVE_UP' => 'Move up',

- 'MOVE_DOWN' => 'Move down',

- 'Resync' => 'Sync',

- 'Category_name' => 'Category name',

- 'FORUM_TYPE' => 'Forum Type',

- 'FORUM_STATUS' => 'Forum Status',

- 'FORUM_STYLE' => 'Forum Style',

- 'FORUM_IMAGE' => 'Forum Image',

- 'Parent' => 'Parent',

- 'No_parent' => 'No parent',

- 'Locked' => 'Locked',

- 'Unlocked' => 'Unlocked',

- 'General_settings' => 'General settings',

- 'Forum_settings' => 'Forum settings',

- 'IS_POSTABLE' => 'Can Post',

- 'NOT_POSTABLE' => 'Cannot Post',

- 'ENABLE_TOPIC_ICONS' => 'Enable topic icons',

- 'DISABLE_POST_COUNT' => 'Disable user post count incrementing',

- 'FORUM_MODERATED' => 'Enable moderation queue',

- 'Display_on_index' => 'Display link to forum on index',

- 'Forum_edit_delete_explain' => 'The form below will allow you to customize all the general board options. For User and Forum configurations use the related links on the left hand side',

- 'Forum_general' => 'General Forum Settings',

- 'Forum_name' => 'Forum name',

- 'Forum_desc' => 'Description',

- 'Forum_pruning' => 'Auto-pruning',

- 'prune_freq' => 'Check for topic age every',

- 'prune_days' => 'Remove topics that have not been posted to in',

- 'SET_NON_POSTABLE' => 'Set this forum as non-postable and',

- 'Forum_delete' => 'Delete Forum',

-

- 'UPDATE' => 'Update',

-

- 'Forum_delete_explain' => 'The form below will allow you to delete a forum and decide where you want to put all topics (or forums) it contained.',

- 'Move_and_Delete' => 'Move and Delete',

- 'Move_posts_to' => 'Move posts to',

- 'Move_subforums_to' => 'Move subforums to',

- 'Delete_all_posts' => 'Delete all posts',

- 'Delete_subforums' => 'Delete subforums and associated posts',

- 'No_destination_forum' => 'You have not specified a forum to move content to',

- 'FORUM_UPDATED' => 'Forum informations updated successfully',

- 'Forum_deleted' => 'Forum successfully deleted',

- 'Click_return_forumadmin' => 'Click %sHere%s to return to Forum Administration',

-

-

- 'ICONS_EXPLAIN' => 'From this page you can add, remove and edit the icons users may add to their topics or posts. These icons are generally displayed next to topic titles on the forum listing, or the post subjects in topic listings. You can also install and create new packages of icons.',

- 'IMPORT_SMILE' => 'Install smilies pak',

- 'EXPORT_SMILE' => 'Create smilies pak',

- 'IMPORT_ICONS' => 'Install icons pak',

- 'EXPORT_ICONS' => 'Create icons pak',

- 'ADD_SMILE' => 'Add smilie',

- 'ADD_ICONS' => 'Add icon',

- 'EMOTION' => 'Emotion',

- 'REORDER' => 'Reorder',

- 'FIRST' => 'First',

- 'AFTER_SMILE' => 'After %s',

- 'AFTER_ICONS' => 'After %s',

- 'SMILE_CONFIG' => 'Smilie configuration',

- 'SMILE_CODE' => 'Smilie code',

- 'SMILE_URL' => 'Smilie image file',

- 'SMILE_HEIGHT' => 'Smilie height',

- 'SMILE_WIDTH' => 'Smilie width',

- 'SMILE_ORDER' => 'Smilie order',

- 'SMILE_ADD' => 'Add a new Smilie',

- 'SMILE_EDIT' => 'Edit Smilie',

- 'ICONS_CONFIG' => 'Icon configuration',

- 'ICONS_URL' => 'Icon image file',

- 'ICONS_HEIGHT' => 'Icon height',

- 'ICONS_WIDTH' => 'Icon width',

- 'ICONS_ORDER' => 'Icon order',

- 'ICONS_ADD' => 'Add a new Icon',

- 'ICONS_EDIT' => 'Edit Icon',

- 'NO_SMILE_EXPORT' => 'You have no smilies with which to create a package.',

- 'NO_ICONS_EXPORT' => 'You have no icons with which to create a package.',

- 'WRONG_PAK_TYPE' => 'The specified package does not contain the appropriate data.',

- 'SELECT_PACKAGE' => 'Select a package file',

- 'DELETE_ALL' => 'Delete all',

- 'KEEP_ALL' => 'Keep all',

- 'REPLACE_MATCHES' => 'Replace matches',

- 'NO_SMILE_PAK' => 'No smilie packages found.',

- 'CURRENT_SMILE' => 'Current smilies',

-

- 'INFORMATION' => 'Information',

-

- 'NO_NEW_POSTS' => 'No new posts',

- 'NEW_POSTS' => 'New posts',

- 'NEW_POST' => 'New post',

- 'NO_NEW_POSTS_HOT' => 'No new posts [ Popular ]',

- 'NEW_POSTS_HOT' => 'New posts [ Popular ]',

- 'NEW_POSTS_LOCKED' => 'New posts [ Locked ]',

- 'FORUM_LOCKED' => 'Forum Locked',

- 'LIST_USERS' => '%d Users',

- 'NO_POSTS' => 'No Posts were found.',

- 'VIEW_UNREAD_POST' => 'View first unread topic',

-// End session management

-//

-//

-//

-//

- break;

- break;

- break;

- break;

- break;

- break;

- $acl_src = array('m_', 'a_general');

- break;

- $result = $db->sql_query('SELECT * FROM ' . TOPICS_TABLE . ' WHERE topic_id = ' . $to_topic_id);

- $result = $db->sql_query('SELECT * FROM ' . FORUMS_TABLE . ' WHERE forum_id = ' . $to_forum_id);

-if ($forum_id && $forum_data[$forum_id]['forum_postable'] && $auth->acl_get('m_', $forum_id))

- elseif ($forum_id && $forum_data[$forum_id]['forum_postable'])

- 'U_LINK' => $tab['url']

- ));

- if (!$forum_data[$to_forum_id]['forum_postable'])

- if (!$forum_data[$to_forum_id]['forum_postable'])

- $return_forum = sprintf($user->lang['RETURN_FORUM'], "<a href=\"viewforum.$phpEx$SID&amp;f=$forum_id\">", '</a>');

- $return_topic = sprintf($user->lang['RETURN_TOPIC'], "<a href=\"viewtopic.$phpEx$SID&amp;f=$forum_id&amp;t=$topic_id&amp;start=$start\">", '</a>');

-

- $template->assign_vars(array(

- 'META' => "<meta http-equiv=\"refresh\" content=\"3;url=viewtopic.$phpEx$SID&amp;f=$forum_id&amp;t=$topic_id&amp;start=$start\">"

- ));

-

- trigger_error($user->lang['TOPIC_TYPE_CHANGED'] . '<br /><br />' . $return_topic . '<br /><br />' . $return_forum);

- break;

- // NOTE: what happens if the user disapproves the first post of the topic? Answer: the topic is deleted

- $l_redirect = sprintf($user->lang['RETURN_MCP'], '<a href="mcp.' . $phpEx . $SID . '&amp;f=' . $forum_id . '">', '</a>');

- $template->assign_vars(array(

- 'META' => '<meta http-equiv="refresh" content="3;url=' . $redirect_page . '">')

- );

-

- 'MESSAGE_TITLE' => $user->lang['CONFIRM'],

- 'MESSAGE_TEXT' => (count($post_id_list) == 1) ? $user->lang['CONFIRM_DELETE_POST'] : $user->lang['CONFIRM_DELETE_POSTS'],

- 'S_CONFIRM_ACTION' => "mcp.$phpEx$SID&amp;mode=disapprove",

- 'S_HIDDEN_FIELDS' => $hidden_fields

- ));

- break;

-//NOTE: hey, who removed the enable_post_count field?! lol ^ ^

- if (!$forum_data[$to_forum_id]['forum_postable'])

- $sql = 'SELECT forum_id, forum_name, forum_postable, left_id, right_id

- if (!$row['forum_postable'] && ($row['left_id'] + 1 == $row['right_id']))

- if (!$auth->acl_gets('f_list', $row['forum_id']))

- if (!$row['forum_postable'] || !$auth->acl_gets($acl_list, $row['forum_id']))

-$forum_fields = array('forum_name' => 's', 'parent_id' => 'i', 'forum_parents' => 's', 'forum_status' => 'i', 'forum_postable' => 'i', 'enable_icons' => 'i');

-

- if (($post_attachment) && (!$submit) && (!$refresh) && (!$preview) && ($mode == 'edit'))

- if (($poster_id == ANONYMOUS) || (!$poster_id))

- 'm_lock' => $auth->acl_get('m_lock', $forum_id),

- 'm_edit' => $auth->acl_get('m_edit', $forum_id),

- 'm_delete' => $auth->acl_get('m_delete', $forum_id),

- 'u_delete' => $auth->acl_get('f_delete', $forum_id),

- 'f_attach' => $auth->acl_get('f_attach', $forum_id),

- 'f_news' => $auth->acl_get('f_news', $forum_id),

- 'f_announce' => $auth->acl_get('f_announce', $forum_id),

- 'f_sticky' => $auth->acl_get('f_sticky', $forum_id),

- 'f_sigs' => $auth->acl_get('f_sigs', $forum_id),

- 'f_save' => $auth->acl_get('f_save', $forum_id)

-if ( (!$auth->acl_get('f_' . $mode, $forum_id)) && ($forum_postable) )

-if ( ($forum_status == ITEM_LOCKED || $topic_status == ITEM_LOCKED) && !$perm['m_edit'])

-if ( ($mode == 'edit' || $mode == 'delete') && !empty($config['edit_time']) && $post_time < time() - intval($config['edit_time']) && !$perm['m_edit'])

-if ( ($mode == 'edit') && (!$perm['m_edit']) && ($user->data['user_id'] != $poster_id))

-if ( ($mode == 'edit') && ($post_edit_locked) && (!$auth->acl_gets('m_', 'a_', $forum_id)) )

-if ( ($mode == 'delete') && ((($poster_id == $user->data['user_id']) && ($user->data['user_id'] != ANONYMOUS) && ($perm['u_delete']) && ($post_id == $topic_last_post_id)) || ($perm['m_delete'])) )

- // TODO: delete common words... maybe just call search_tidy ?

-// $search->del_words($post_id);

- if (($post_data['topic_first_post_id'] != $post_data['topic_last_post_id']) && ($post_id == $post_data['topic_first_post_id']))

- 'topic_first_post_id' => intval($row['post_id']),

- 'topic_first_poster_name' => ( intval($row['poster_id']) == ANONYMOUS) ? trim($row['post_username']) : trim($row['username'])

- $template->assign_vars(array(

- 'META' => $meta_info)

- );

-

- 'MESSAGE_TITLE' => $user->lang['DELETE_MESSAGE'],

- 'MESSAGE_TEXT' => $user->lang['CONFIRM_DELETE'],

- 'S_CONFIRM_ACTION' => $phpbb_root_path . 'posting.' . $phpEx . $SID,

- 'S_HIDDEN_FIELDS' => $s_hidden_fields)

-if ( ($mode == 'delete') && ( ($poster_id != $user->data['user_id']) && (!$perm['u_delete'])) )

-if ( ($mode == 'delete') && ( ($poster_id == $user->data['user_id']) && ($perm['u_delete'])) && ($post_id != $topic_last_post_id))

-if (($submit) || ($preview) || ($refresh))

- if ( ($poll_delete) && ($mode == 'edit' && !empty($poll_options) && ((empty($poll_last_vote) && $poster_id == $user->data['user_id'] && $perm['u_delete']) || $perm['m_delete'])) )

- $sql = 'UPDATE ' . TOPICS_TABLE . ' SET ' . $db->sql_build_array('UPDATE', $topic_sql) . ' WHERE topic_id = ' . $topic_id;

- if ( ($mode == 'reply' || $mode == 'quote') && ($topic_cur_post_id != $topic_last_post_id) )

- if (($mode != 'edit') && (!$preview) && (!$refresh) && (!$perm['f_ignoreflood']))

- if ( ($subject == '') && ($mode == 'post' || ($mode == 'edit' && $topic_first_post_id == $post_id)))

- <td class="row1" width="100%" height="50" valign="top"><a class="forumlink" href="{forumrow.U_VIEWFORUM}">{forumrow.FORUM_NAME}</a><br />

- bbstyle(-1);

- <td class="cat" colspan="5" height="28"><a class="cattitle" href="{forumrow.U_VIEWFORUM}">{forumrow.FORUM_NAME}</a></td>

- <td class="row2" align="center" valign="middle" height="50" nowrap="nowrap"><!-- IF forumrow.LAST_POST_TIME --><span class="gensmall">{forumrow.LAST_POST_TIME}<br /><!-- IF forumrow.U_LAST_POSTER --><a href="{forumrow.U_LAST_POSTER}">{forumrow.LAST_POSTER}</a><!-- ELSE -->{forumrow.LAST_POSTER}<!-- ENDIF --> <a href="{forumrow.U_LAST_POST}">{forumrow.LAST_POST_IMG}</a></span><!-- ELSE -->{L_NO_POSTS}<!-- ENDIF --></td>

- <td align="right"><span class="nav"><a href="{U_VIEW_OLDER_TOPIC}">{L_VIEW_PREVIOUS_TOPIC}</a> :: <a href="{U_VIEW_NEWER_TOPIC}">{L_VIEW_NEXT_TOPIC}</a>&nbsp;</span></td>

-if (!$forum_data = $db->sql_fetchrow($result))

- trigger_error('SORRY_AUTH_READ');

-if ($forum_data['forum_postable'])

- 'S_IS_POSTABLE' => TRUE,

- 'S_SELECT_SORT_DIR' => $s_sort_dir,

- 'S_SELECT_SORT_KEY' => $s_sort_key,

- 'S_SELECT_SORT_DAYS' => $s_limit_days,

- 'S_USER_POSTED' => ($row['lastread_type'] == LASTREAD_POSTED) ? true : false,

-

-

-$s_limit_days = $s_sort_key = $s_sort_dir = '';

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

-$pagination_url = "viewtopic.$phpEx$SID&amp;t=$topic_id&amp;st=$sort_days&amp;sk=$sort_key&amp;sd=$sort_dir" . (($highlight_match) ? "&amp;hilit=$highlight" : '');

- 'MCP' => ($auth->acl_get('m_', $forum_id)) ? sprintf($user->lang['MCP'], "<a href=\"mcp.$phpEx?sid=" . $user->session_id . "&amp;f=$forum_id&amp;t=$topic_id&amp;start=$start&amp;st=$sort_days&amp;sk=$sort_key&amp;sd=$sort_dir&amp;posts_per_page=" . $config['posts_per_page'] . '">', '</a>') : '',

-

- 'U_VIEW_TOPIC' => "viewtopic.$phpEx$SID&amp;f=$forum_id&amp;t=$topic_id&amp;start=$start&amp;st=$sort_days&amp;sk=$sort_key&amp;sd=$sort_dir&amp;hilit=$highlight",

- 'U_PRINT_TOPIC' => "viewtopic.$phpEx$SID&amp;f=$forum_id&amp;t=$topic_id&amp;st=$sort_days&amp;sk=$sort_key&amp;sd=$sort_dir&amp;view=print",

- 'S_POLL_ACTION' => "viewtopic.$phpEx$SID&amp;t=$topic_id&amp;sk=$sort_key&amp;sd=$sort_dir",

- 'U_VIEW_RESULTS' => "viewtopic.$phpEx$SID&amp;t=$topic_id&amp;st=$sort_days&amp;sk=$sort_key&amp;sd=$sort_dir&amp;vote=viewresult")

- if (($user->data['user_id'] == $poster_id && $auth->acl_get('f_edit', $forum_id)) || $auth->acl_get('m_edit', $forum_id))

- $message = (empty($row['enable_smilies']) || empty($config['allow_smilies'])) ? preg_replace('#<!\-\- s(.*?) \-\-><img src="\{SMILE_PATH\}\/.*? \/><!\-\- s\1 \-\->#', '\1', $message) : str_replace('<img src="{SMILE_PATH}', '<img src="' . $config['smilies_path'], $message);

- 'IS_DENIED' => true,

- 'L_DENIED' => sprintf($user->lang['EXTENSION_DISABLED_AFTER_POSTING'], $attachment['extension']))

- //

- // BEGIN

- $img_source = $phpbb_root_path . 'download.' . $phpEx . $SID . '&amp;id=' . $attachment['attach_id'];

- // END

- //

- // BEGIN

- $thumb_source = $phpbb_root_path . 'download.' . $phpEx . $SID . '&amp;id=' . $attachment['attach_id'] . '&thumb=1';

- // END

- $download_link = $phpbb_root_path . 'download.' . $phpEx . $SID . '&amp;id=' . $attachment['attach_id'];

- 'IMG_THUMB_SRC' => $thumb_source

- if (!preg_match("#&t=$topic_id#", $user->data['session_page']))

- {

- $update_count[] = $attachment['attach_id'];

- }

- 'FORUM_URL' => generate_board_url(),

- if (!preg_match("#&t=$topic_id#", $user->data['session_page']))

- {

- $update_count[] = $attachment['attach_id'];

- }

-// Udate the attachment download counts

-if (count($update_count))

-{

- $sql = "UPDATE " . ATTACHMENTS_DESC_TABLE . "

- SET download_count = download_count + 1

- WHERE attach_id IN (" . implode(', ', array_unique($update_count)) . ")";

- $db->sql_query($sql);

-}

-// Update the topic view counter, excepted when the user was already reading it

-

-markread('topic', $forum_id, $topic_id, $topic_data['topic_last_post_id']);

-$page_title = $user->lang['View_topic'] .' - ' . $topic_title;