// Some oft used variables

$safe_mode = (@ini_get('safe_mode') || @strtolower(ini_get('safe_mode')) == 'on') ? true : false;

$module_id = request_var('i', '');

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

$template->assign_vars(array(

'DEBUG_OUTPUT' => (defined('DEBUG')) ? $debug_output : '',

'S_COPYRIGHT_HTML' => $copyright_html,

'VERSION' => $config['version'])

);

</fieldset>

<fieldset class="submit-buttons">

<input class="button1" type="submit" id="submit" name="submit" value="{L_SUBMIT}" />&nbsp;

<input class="button2" type="reset" id="reset" name="reset" value="{L_RESET}" />

</fieldset>

<dt><label for="exclude">{L_IP_EXCLUDE}:</label><br /><span>{L_EXCLUDE_ENTERED_IP}</span></dt>

<dd><input type="radio" id="exclude" name="ipexclude" value="1" class="radio" /> {L_YES} &nbsp; <input type="radio" name="ipexclude" value="0" checked="checked" class="radio" /> {L_NO}</dd>

</dl>

<input class="button1" type="submit" id="securesubmit" name="securesubmit" value="{L_SUBMIT}" />

</fieldset>

<fieldset>

<dt><label for="remove_ip_hostname">{L_IP_HOSTNAME}:</label></dt>

<dd><select name="unip[]" id="remove_ip_hostname" multiple="multiple" size="10">{DEFINED_IPS}</select></dd>

</dl>

<input class="button1" type="submit" id="unsecuresubmit" name="unsecuresubmit" value="{L_SUBMIT}" />

</fieldset>

<!-- ELSE -->

<dd><input type="radio" id="allowed_forums" class="radio" name="forum_select" value="0"<!-- IF not S_FORUM_IDS --> checked="checked"<!-- ENDIF --> />&nbsp;{L_ALLOW_ALL_FORUMS}&nbsp;&nbsp;<input type="radio" class="radio" name="forum_select" value="1"<!-- IF S_FORUM_IDS --> checked="checked"<!-- ENDIF --> />&nbsp;{L_ALLOW_SELECTED_FORUMS}</dd>

<dd><select name="allowed_forums[]" multiple="multiple" size="8">{S_FORUM_ID_OPTIONS}</select></dd>

</dl>

<input class="button1" type="submit" id="submit" name="submit" value="{L_SUBMIT}" />&nbsp;

<input class="button2" type="reset" id="reset" name="reset" value="{L_RESET}" />

</fieldset>

</form>

<!-- ELSE -->

<table cellspacing="1">

<col class="row1" /><col class="row1" /><col class="row2" />

<thead>

<!-- END groups -->

</tbody>

</table>

{L_CREATE_GROUP}: <input type="text" name="group_name" maxlength="30" />

<input class="button2" name="add" type="submit" value="{L_SUBMIT}" />

</form>

<!-- ENDIF -->

<dt><label for="extension_group">{L_EXTENSION_GROUP}</label></dt>

<dd>{GROUP_SELECT_OPTIONS}</dd>

</dl>

<input type="submit" id="add_extension_check" name="add_extension_check" class="button2" value="{L_SUBMIT}" />

</fieldset>

</form>

<form id="change_ext" method="post" action="{U_ACTION}">

<table cellspacing="1">

<col class="row1" /><col class="row1" /><col class="row2" />

<thead>

</tbody>

</table>

<input class="button1" type="submit" id="submit" name="submit" value="{L_SUBMIT}" />&nbsp;

<input class="button2" type="reset" id="reset" name="reset" value="{L_RESET}" />

</fieldset>

</form>

<form id="orphan" method="post" action="{U_ACTION}">

<table cellspacing="1">

<thead>

<tr>

<br />

<input class="button1" type="submit" id="submit" name="submit" value="{L_SUBMIT}" />&nbsp;

<input class="button2" type="reset" id="reset" name="reset" value="{L_RESET}" />

</fieldset>

</form>

<!-- ENDIF -->

<dt><label for="bangivereason">{L_BAN_GIVE_REASON}:</label></dt>

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

</dl>

<input class="button1" type="submit" id="bansubmit" name="bansubmit" value="{L_SUBMIT}" />&nbsp;

<input class="button2" type="reset" id="banreset" name="banreset" value="{L_RESET}" />

</fieldset>

<br /><br />

<dt><label for="unbangivereason">{L_BAN_GIVE_REASON}:</label></dt>

<dd><input style="border: 0px;" type="text" name="unbangivereason" id="unbangivereason" class="full" disabled="disabled" /></dd>

</dl>

<input class="button1" type="submit" id="unbansubmit" name="unbansubmit" value="{L_SUBMIT}" />&nbsp;

<input class="button2" type="reset" id="unbanreset" name="unbanreset" value="{L_RESET}" />

</fieldset>

<!-- ELSE -->

</form>

</fieldset>

<fieldset class="submit-buttons">

<input class="button1" type="submit" id="submit" name="submit" value="{L_SUBMIT}" />&nbsp;

<input class="button2" type="reset" id="reset" name="reset" value="{L_RESET}" />

</fieldset>

<p>{L_ACP_BBCODES_EXPLAIN}</p>

<table cellspacing="1" id="down">

<thead>

<tr>

</tbody>

</table>

<input class="button2" name="submit" type="submit" value="{L_ADD_BBCODE}" />

</fieldset>

</form>

<!-- ENDIF -->

</fieldset>

<fieldset class="submit-buttons">

<input class="button1" type="submit" id="submit" name="submit" value="{L_SUBMIT}" />&nbsp;

<input class="button2" type="reset" id="reset" name="reset" value="{L_RESET}" />

</fieldset>

</form>

<dt><label for="bot_ip">{L_BOT_IP}:</label><br /><span>{L_BOT_IP_EXPLAIN}</span></dt>

<dd><input name="bot_ip" type="text" id="bot_ip" value="{BOT_IP}" /></dd>

</dl>

<input class="button1" type="submit" id="submit" name="submit" value="{L_SUBMIT}" />&nbsp;

<input class="button2" type="reset" id="reset" name="reset" value="{L_RESET}" />

</fieldset>

</form>

<!-- ENDIF -->

<dd><input id="captcha_gd_noise" name="captcha_gd_noise" value="1" class="radio" type="radio"<!-- IF CAPTCHA_GD_NOISE --> checked="checked"<!-- ENDIF --> />&nbsp;{L_YES}&nbsp;&nbsp;<input name="captcha_gd_noise" value="0" class="radio" type="radio"<!-- IF not CAPTCHA_GD_NOISE --> checked="checked"<!-- ENDIF --> />&nbsp;{L_NO}</dd>

</dl>

<!-- ENDIF -->

<input class="button1" type="submit" id="submit" name="submit" value="{L_SUBMIT}" />&nbsp;

<input class="button2" type="reset" id="reset" name="reset" value="{L_RESET}" />

</fieldset>

</form>

<dt><label for="user">{L_SELECT_FILE}:</label></dt>

<dd><select id="file" name="file" size="10"><!-- BEGIN files --><option value="{files.FILE}"<!-- IF files.S_LAST_ROW --> selected="selected"<!-- ENDIF -->>{files.NAME}</option><!-- END files --></select></dd>

</dl>

<!-- IF EXISTS -->

<input class="button1" type="submit" id="submit" name="submit" value="{L_START_RESTORE}" />&nbsp;

<input class="button2" type="submit" id="delete" name="delete" value="{L_DELETE_BACKUP}" />&nbsp;

<input class="button2" type="submit" id="download" name="download" value="{L_DOWNLOAD_BACKUP}" />

<!-- ENDIF -->

</form>

<!-- ELSE -->

<!-- END tables -->

</select><br /><br /><div align="right"><a href="#" onclick="selector(true)">{L_SELECT_ALL}</a><br /><a href="#" onclick="selector(false)">{L_DESELECT_ALL}</a></div></dd>

</dl>

<input class="button1" type="submit" id="submit" name="submit" value="{L_SUBMIT}" />&nbsp;

<input class="button2" type="reset" id="reset" name="reset" value="{L_RESET}" />

</fieldset>

</form>

<!-- ENDIF -->

<dt><label for="user">{L_USERNAME}:</label><br /><span>{L_ADD_DISALLOW_EXPLAIN}</span></dt>

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

</dl>

<input class="button1" type="submit" name="disallow" value="{L_SUBMIT}" />

</fieldset>

<h1>{L_DELETE_DISALLOW_TITLE}</h1>

<dt><label for="disallowed">{L_USERNAME}:</label></dt>

<dd><select name="disallowed_id" id="disallowed">{S_DISALLOWED_NAMES}</select></dd>

</dl>

<input class="button1" type="submit" name="allow" value="{L_SUBMIT}" />

<!-- ELSE -->

<p>{L_NO_DISALLOWED}</p>

<!-- ENDIF -->

</form>

<dl>

<dt><label for="usernames">{L_SEND_TO_USERS}:</label><br /><span>{L_SEND_TO_USERS_EXPLAIN}</span></dt>

<dd><textarea name="usernames" id="usernames" rows="5" cols="40">{USERNAMES}</textarea></dd>

</dl>

<dl>

<dt><label for="subject">{L_SUBJECT}:</label></dt>

<dt><label for="send">{L_SEND_IMMEDIATLY}:</label></dt>

<dd><input id="send" type="checkbox" class="radio" name="send_immediatly" checked="checked" /></dd>

</dl>

<input class="button1" type="submit" id="submit" name="submit" value="{L_EMAIL}" />&nbsp;

<input class="button2" type="reset" id="reset" name="reset" value="{L_RESET}" />

</fieldset>

</form>

<script type="text/javascript">

<!--

function display_options(value)

{

<!-- IF not S_ADD_ACTION and S_FORUM_ORIG_POST -->

}

<!-- ENDIF -->

if (value == {FORUM_POST})

{

dE('forum_post_options', 1);

}

}

//-->

</script>

<dd><select id="forum_type" name="forum_type" onchange="display_options(this.options[this.selectedIndex].value);">{S_FORUM_TYPE_OPTIONS}</select></dd>

</dl>

<!-- IF not S_ADD_ACTION and S_FORUM_ORIG_POST -->

<dl>

<dt><label for="type_action">{L_DECIDE_MOVE_DELETE_CONTENT}:</label></dt>

<dd><input type="radio" class="radio" id="type_action" name="type_action" value="delete" checked="checked" /> {L_DELETE_ALL_POSTS}</dd>

</dl>

</div>

<!-- ENDIF -->

<dl>

<dt><label for="parent">{L_FORUM_PARENT}:</label></dt>

<dd><select id="parent" name="forum_parent_id"><option value="0"<!-- IF not S_FORUM_PARENT_ID --> selected="selected"<!-- ENDIF -->>{L_NO_PARENT}</option>{S_PARENT_OPTIONS}</select></dd>

</dl>

</fieldset>

<fieldset>

<legend>{L_GENERAL_FORUM_SETTINGS}</legend>

<dl>

<dt><label for="display_active">{L_DISPLAY_ACTIVE_TOPICS}:</label><br /><span>{L_DISPLAY_ACTIVE_TOPICS_EXPLAIN}</span></dt>

<dd><input type="radio" class="radio" name="display_active" value="1"<!-- IF S_DISPLAY_ACTIVE_TOPICS --> id="display_active" checked="checked"<!-- ENDIF --> /> {L_YES} &nbsp; <input type="radio" class="radio" name="display_active" value="0"<!-- IF not S_DISPLAY_ACTIVE_TOPICS --> id="display_active" checked="checked"<!-- ENDIF --> /> {L_NO}</dd>

</dl>

</div>

<fieldset>

<legend>{L_GENERAL_FORUM_SETTINGS}</legend>

<dl>

</fieldset>

</div>

<fieldset>

<legend>{L_GENERAL_FORUM_SETTINGS}</legend>

<dl>

</fieldset>

</div>

<fieldset>

<legend>{L_FORUM_RULES}</legend>

<dl>

</div>

<fieldset class="submit-buttons">

<input class="button1" type="submit" id="submit" name="update" value="{L_SUBMIT}" />&nbsp;

<input class="button2" type="reset" id="reset" name="reset" value="{L_RESET}" />

</fieldset>

<!-- ENDIF -->

</dl>

<!-- ENDIF -->

<input class="button1" type="submit" name="update" value="{L_SUBMIT}" />

</fieldset>

</form>

<!-- ENDIF -->

<!-- IF S_RESYNCED -->

<!--

var close_waitscreen = 1;

//-->

<tr>

<td style="width: 5%;">{forums.FOLDER_IMAGE}</td>

<td>

<strong><!-- IF forums.S_FORUM_LINK -->{forums.FORUM_NAME}<!-- ELSE --><a href="{forums.U_FORUM}">{forums.FORUM_NAME}</a><!-- ENDIF --></strong>

<!-- IF forums.FORUM_DESCRIPTION --><br /><span>{forums.FORUM_DESCRIPTION}</span><!-- ENDIF -->

<!-- IF forums.S_FORUM_POST --><br /><br /><span>{L_TOPICS}: <b>{forums.FORUM_TOPICS}</b> / {L_POSTS}: <b>{forums.FORUM_POSTS}</b></span><!-- ENDIF -->

{ICON_MOVE_UP_DISABLED}

<a href="{forums.U_MOVE_DOWN}">{ICON_MOVE_DOWN}</a>

<!-- ELSEIF not forums.S_FIRST_ROW && not forums.S_LAST_ROW-->

<!-- ELSEIF forums.S_LAST_ROW && not forums.S_FIRST_ROW -->

{ICON_MOVE_DOWN_DISABLED}

<!-- ELSE -->

{ICON_MOVE_UP_DISABLED}

{ICON_MOVE_DOWN_DISABLED}

<!-- IF not forums.S_FORUM_LINK -->

<!-- ELSE -->

{ICON_SYNC_DISABLED}

<!-- ENDIF -->

<form id="fselect" method="post" action="{U_SEL_ACTION}">

<fieldset class="quick">

<input class="button2" type="submit" value="{L_GO}" />

</fieldset>

</form>

<form id="forums" method="post" action="{U_ACTION}">

<fieldset class="quick">

<input type="hidden" name="action" value="add" />

<input class="button2" name="addforum" type="submit" value="{L_CREATE_FORUM}" />

</fieldset>

<fieldset>

<legend>{L_GROUP_SETTINGS_SAVE}</legend>

<dl>

<dt><label for="group_legend">{L_GROUP_LEGEND}:</label></dt>

<dd><input name="group_legend" type="checkbox" class="radio" id="group_legend"{GROUP_LEGEND} /></dd>

</fieldset>

<fieldset class="submit-buttons">

<input class="button1" type="submit" id="submit" name="update" value="{L_SUBMIT}" />&nbsp;

<input class="button2" type="reset" id="reset" name="reset" value="{L_RESET}" />

</fieldset>

<dl>

<dt><label for="usernames">{L_USERNAME}:</label><br /><span>{L_USERNAMES_EXPLAIN}</span></dt>

<dd><textarea id="usernames" name="usernames" cols="40" rows="5"></textarea></dd>

</dl>

<input class="button2" type="submit" name="addusers" value="{L_SUBMIT}" />

</fieldset>

</form>

<tbody>

<!-- BEGIN groups -->

<!-- IF groups.S_SPECIAL -->

</tbody>

</table>

<!-- ENDIF -->

<form id="acp_icons" method="post" action="{U_ACTION}">

<table cellspacing="1">

<thead>

<tr>

</tbody>

</table>

<input class="button1" type="submit" id="submit" name="submit" value="{L_SUBMIT}" />&nbsp;

<input class="button2" type="reset" id="reset" name="reset" value="{L_RESET}" />

</fieldset>

</form>

<!-- IF not S_PAK_OPTIONS -->

<p>{L_NO_PAK_OPTIONS}</p>

<!-- ELSE -->

<dl>

<dt><label for="current">{L_CURRENT}</label><br /><span>{L_CURRENT_EXPLAIN}</span></dt>

<dd><input type="radio" class="radio" id="current" name="current" value="keep" checked="checked" /> {L_KEEP_ALL}&nbsp; &nbsp;<input type="radio" class="radio" name="current" value="replace" /> {L_REPLACE_MATCHES}&nbsp; &nbsp;<input type="radio" class="radio" name="current" value="delete" /> {L_DELETE_ALL}&nbsp;</dd>

</dl>

<input class="button1" type="submit" id="import" name="import" value="{L_IMPORT_SUBMIT}" />

<!-- ENDIF -->

</form>

</div>

<!-- ENDIF -->

<div style="text-align: right;"><a href="{U_IMPORT}">{L_IMPORT}</a> | <a href="{U_EXPORT}">{L_EXPORT}</a></div>

<table cellspacing="1">

</tbody>

</table>

<input class="button2" name="add" type="submit" value="{L_ICON_ADD}" />&nbsp; &nbsp;<input class="button2" type="submit" name="edit" value="{L_ICON_EDIT}" />

</fieldset>

</form>

<!-- ENDIF -->

<dt><label for="jab_package_size">{L_JAB_PACKAGE_SIZE}:</label><br /><span>{L_JAB_PACKAGE_SIZE_EXPLAIN}</span></dt>

<dd><input type="text" id="jab_package_size" name="jab_package_size" value="{JAB_PACKAGE_SIZE}" /></dd>

</dl>

<input class="button1" type="submit" id="submit" name="submit" value="{L_SUBMIT}" />&nbsp;

<input class="button2" type="reset" id="reset" name="reset" value="{L_RESET}" />

</fieldset>

</form>

<dt><label for="use_method">{L_DOWNLOAD_AS}:</label></dt>

<dd>{RADIO_BUTTONS}</dd>

</dl>

<input type="submit" class="button2" value="{L_DOWNLOAD}" name="download" />

</fieldset>

</form>

<dt><label for="lang_author">{L_LANG_AUTHOR}:</label></dt>

<dd><input type="text" id="lang_author" name="lang_author" value="{LANG_AUTHOR}" /></dd>

</dl>

<input type="submit" name="update_details" class="button2" value="{L_SUBMIT}" />

</fieldset>

</form>

<!-- ENDIF -->

<dd><select name="module_mode" id="module_mode">{S_MODULE_MODES}</select></dd>

</dl>

</div>

<input type="hidden" name="action" value="{ACTION}" />

<input type="hidden" name="m" value="{MODULE_ID}" />

<input class="button1" type="submit" id="submit" name="submit" value="{L_SUBMIT}" />&nbsp;

<input class="button2" type="reset" id="reset" name="reset" value="{L_RESET}" />

</fieldset>

</form>

<!-- ENDIF -->

<dt><label for="role_description">{L_ROLE_DESCRIPTION}:</label><br /><span>{L_ROLE_DESCRIPTION_EXPLAIN}</span></dt>

<dd><textarea id="role_description" name="role_description" rows="3" cols="45">{ROLE_DESCRIPTION}</textarea></dd>

</dl>

<input type="submit" class="button1" name="submit" value="{L_SUBMIT}" />

</fieldset>

<!-- IF S_DISPLAY_ROLE_MASK -->

<!-- ENDIF -->

</form>

<!-- ENDIF -->

<!-- ELSEIF S_SELECT_USER and S_CAN_SELECT_USER -->

<dl>

<dt><label for="username">{L_FIND_USERNAME}:</label></dt>

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

<dd class="full" style="text-align: left;"><input type="checkbox" class="radio" id="anonymous" name="user_id[]" value="{ANONYMOUS_USER_ID}" /> &nbsp;{L_SELECT_ANONYMOUS}</dd>

</dl>

</fieldset>

<p>{L_USERNAMES_EXPLAIN}</p>

<dl>

<dd class="full"><textarea id="username" name="usernames" rows="5" cols="5" style="width: 100%; height: 60px;"></textarea></dd>

</dl>

</fieldset>

<dl>

<dt><label for="username">{L_FIND_USERNAME}:</label></dt>

<dd><input type="text" id="username" name="username[]" /></dd>

<dd class="full" style="text-align: left;"><input type="checkbox" class="radio" id="anonymous" name="user_id[]" value="{ANONYMOUS_USER_ID}" /> &nbsp;{L_SELECT_ANONYMOUS}</dd>

</dl>

</fieldset>

<!-- ENDIF -->

<dl>

<dd class="full"><select name="f[]" multiple="multiple" size="5">{S_FORUM_OPTIONS}</select></dd>

</dl>

<input class="button1" type="submit" value="{L_LOOK_UP_FORUM}" />

</fieldset>

</form>

<dt><label for="sticky">{L_PRUNE_STICKY}:</label></dt>

<dd><input type="radio" class="radio" name="prune_sticky" value="1" /> {L_YES} &nbsp; <input type="radio" class="radio" id="sticky" name="prune_sticky" value="0" checked="checked" /> {L_NO}</dd>

</dl>

{S_HIDDEN_FIELDS}

<input class="button1" type="submit" id="submit" name="submit" value="{L_SUBMIT}" />

</fieldset>

</form>

<!-- ENDIF -->

<dt><label for="deactivate">{L_DEACTIVATE_DELETE}:</label><br /><span>{L_DEACTIVATE_DELETE_EXPLAIN}</span></dt>

<dd><input type="radio" class="radio" name="action" value="delete" /> {L_DELETE_USERS}&nbsp;&nbsp;<input type="radio" class="radio" id="deactivate" name="action" value="deactivate" checked="checked" /> {L_DEACTIVATE}</dd>

</dl>

<input type="hidden" name="prune" value="1" />

<input class="button1" type="submit" id="update" name="update" value="{L_SUBMIT}" />&nbsp;

<input class="button2" type="reset" id="reset" name="reset" value="{L_RESET}" />

</fieldset>

</form>

<dd><input name="min_posts" type="text" id="min_posts" maxlength="10" value="{MIN_POSTS}" /></dd>

</dl>

</div>

<input type="hidden" name="action" value="save" />

<input class="button1" type="submit" id="submit" name="submit" value="{L_SUBMIT}" />&nbsp;

<input class="button2" type="reset" id="reset" name="reset" value="{L_RESET}" />

</fieldset>

</form>

<p>{L_ACP_RANKS_EXPLAIN}</p>

<table cellspacing="1">

<thead>

<tr>

</tbody>

</table>

<input class="button2" name="add" type="submit" value="{L_ADD_RANK}" />

</fieldset>

</form>

<!-- ENDIF -->

<dd>{TRANSLATED_DESCRIPTION}</dd>

</dl>

<!-- ENDIF -->

<input class="button1" type="submit" id="submit" name="submit" value="{L_SUBMIT}" />&nbsp;

<input class="button2" type="reset" id="reset" name="reset" value="{L_RESET}" />

</fieldset>

</form>

<p>{L_ACP_REASONS_EXPLAIN}</p>

<!-- IF .reasons -->

<table cellspacing="1">

<col class="row1" /><col class="row1" /><col class="row2" />

<!-- ENDIF -->

<input type="hidden" name="action" value="add" />

<input type="text" name="reason_title" />

<input class="button2" name="addreason" type="submit" value="{L_ADD_NEW_REASON}" />

</fieldset>

</form>

<!-- ENDIF -->

<legend>{L_GENERAL_SEARCH_SETTINGS}</legend>

<dl>

<dt><label for="load_search">{L_YES_SEARCH}:</label><br /><span>{L_YES_SEARCH_EXPLAIN}</span></dt>

</dl>

<dl>

<dt><label for="search_interval">{L_SEARCH_INTERVAL}:</label><br /><span>{L_SEARCH_INTERVAL_EXPLAIN}</span></dt>

<!-- END backend -->

<fieldset class="submit-buttons">

<input class="button1" type="submit" id="submit" name="submit" value="{L_SUBMIT}" />&nbsp;

<input class="button2" type="reset" id="reset" name="reset" value="{L_RESET}" />

</fieldset>

<!-- IF backend.S_STATS -->

<table cellspacing="1">

<col class="col1" /><col class="col2" /><col class="col1" /><col class="col2" />

<thead>

<tr>

<!-- ENDIF -->

<!-- IF backend.S_INDEXED -->

<input class="button2" type="submit" name="action[delete]" value="{L_DELETE_INDEX}" onclick="popup_progress_bar('delete');" />

<!-- ELSE -->

<input class="button2" type="submit" name="action[create]" value="{L_CREATE_INDEX}" onclick="popup_progress_bar('create');" />

<!-- ENDIF -->

</fieldset>

</form>

<!-- ENDIF -->

<dt><label for="new_id">{L_REPLACE}:</label><br /><span>{L_REPLACE_EXPLAIN}</span></dt>

<dd><select name="new_id">{S_REPLACE_OPTIONS}</select></dd>

</dl>

<input class="button1" type="submit" name="update" value="{L_DELETE}" />

</fieldset>

</form>

<h1>{L_TITLE}</h1>

<p>{L_EXPLAIN}</p>

<!--

function update_image(newimage)

{

}

//-->

</script>

<form method="post" action="{U_ACTION}">

<!-- BEGIN category -->

<option class="sep" value="">{category.NAME}</option>

<!-- BEGIN images --><option value="{category.images.VALUE}"<!-- IF category.images.SELECTED--> selected="selected"<!-- ENDIF -->>{category.images.TEXT}</option>

<!-- END images -->

<!-- END category -->

</form>

<!-- ELSEIF S_EDIT_TEMPLATE or S_EDIT_THEME -->

<!--

function append_text_rows(form_name, value)

{

<legend>{L_SELECT_TEMPLATE}</legend>

<dl>

<dt><label for="template_file">{L_TEMPLATE_FILE}:</label></dt>

</dl>

</fieldset>

</form>

<!-- IF TEMPLATE_FILE -->

<!--

function change_editor_height(height)

</dl>

<dl>

<dt><label for="text_rows">{L_TEMPLATE_EDITOR_HEIGHT}:</label></dt>

</dl>

<textarea id="template_data" name="template_data" style="font-family:'Courier New', monospace;font-size:9pt;line-height:125%;width:100%;" cols="80" rows="{TEXT_ROWS}">{TEMPLATE_DATA}</textarea>

</fieldset>

<fieldset class="submit-buttons">

{S_HIDDEN_FIELDS}

<input class="button1" id="save" type="submit" name="save" value="{L_SUBMIT}" />

</fieldset>

<!-- ELSEIF S_EDIT_THEME -->

<!--

function change_editor_height(height)

{

editor = document.getElementById('css_data');

<p>{L_EDIT_THEME_EXPLAIN}</p>

<!-- IF S_SHOWCSS -->

<h3>{L_SHOW_CSS_NOTE}</h3>

<p>{L_SHOW_CSS_EXPLAIN}</p>

<!-- ENDIF -->

<form id="acp_styles" method="post" action="{U_ACTION}">

<fieldset>

<legend>{L_SELECT_CLASS}</legend>

<dl>

<dt><label for="css_class">{L_SELECT_CLASS}:</label></dt>

</dl>

<!-- IF S_CLASS -->

<dl>

<legend>{L_THEME_EDITOR}</legend>

<dl>

<dt><label for="text_rows">{L_THEME_EDITOR_HEIGHT}:</label></dt>

</dl>

<textarea id="css_data" name="css_data" style="font-family:'Courier New', monospace;font-size:9pt;line-height:125%;width:100%;" cols="80" rows="{TEXT_ROWS}">{CSS_DATA}</textarea>

</fieldset>

<dd><input id="background_color" name="background_color" type="text" value="{BACKGROUND_COLOR}" size="6" />&nbsp;&nbsp;<span>[ <a href="#" onclick="swatch('background_color'); return false">{L_COLOUR_SWATCH}</a> ]</span></dd>

</dl>

<dl>

<dd><select id="background_image" name="background_image">{S_BACKGROUND_IMAGE}</select></dd>

</dl>

<dl>

<!-- ENDIF -->

<fieldset class="submit-buttons">

{S_HIDDEN_FIELDS}

<input class="button1" type="submit" id="submit" name="submit" value="{L_SUBMIT}" />&nbsp;

<!-- IF S_SHOWCSS -->

<fieldset>

<legend>{L_CUSTOM_CLASS}</legend>

<dl>

<dd><input id="custom_class" name="custom_class" type="text" value="" maxlength="40" size="40" /></dd>

</dl>

<input class="button1" type="submit" id="add_custom" name="add_custom" value="{L_SUBMIT}" />

</fieldset>

</form>

<!-- ELSEIF S_CACHE -->

<!--

function viewsource(url)

<p>{L_TEMPLATE_CACHE_EXPLAIN}</p>

<form name="acp_styles" method="post" action="{U_ACTION}">

<table cellspacing="1">

<thead>

</tbody>

</table>

<span class="small"><a href="#" onclick="marklist('acp_styles', 'delete', true); return false;">{L_MARK_ALL}</a> :: <a href="#" onclick="marklist('acp_styles', 'delete', false); return false;">{L_UNMARK_ALL}</a></span><br />

<input class="button1" type="submit" id="submit" name="submit" value="{L_DELETE_MARKED}" />

</fieldset>

</form>

<dt><label for="format">{L_ARCHIVE_FORMAT}:</label></dt>

<dd>{FORMAT_BUTTONS}</dd>

</dl>

<input class="button1" type="submit" name="update" value="{L_SUBMIT}" />

</fieldset>

</form>

<form id="acp_styles" method="post" action="{U_ACTION}">

<fieldset class="quick">

{L_CREATE}: <input type="text" name="name" value="" /> {L_FROM} <select name="basis">{S_BASIS_OPTIONS}</select> <input class="button2" type="submit" name="add" value="{L_SUBMIT}" />

</fieldset>

<!-- ENDIF -->

</fieldset>

<input class="button1" type="submit" name="update" value="{L_SUBMIT}" />

</fieldset>

<!-- ENDIF -->

<dl>

<dt><label for="username">{L_FIND_USERNAME}:</label></dt>

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

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

</dl>

<input type="submit" name="submituser" value="{L_SUBMIT}" class="button1" />

</fieldset>

</form>

<legend>{L_ACP_USER_OVERVIEW}</legend>

<dl>

<dt><label for="user">{L_USERNAME}:</label><br /><span>{L_NAME_CHARS_EXPLAIN}</span></dt>

<!-- IF U_SWITCH_PERMISSIONS --><dd>[ <a href="{U_SWITCH_PERMISSIONS}">{L_USE_PERMISSIONS}</a> ]</dd><!-- ENDIF -->

</dl>

<dl>

<dt><label>{L_REGISTERED}:</label></dt>

<dd><strong>{USER_REGISTERED}</strong></dd>

<dl>

<dt><label>{L_REGISTERED_IP}:</label></dt>

<dd><a href="{U_SHOW_IP}">{REGISTERED_IP}</a></dd>

</dl>

<!-- ENDIF -->

<dl>

var text_name = 'signature';

// Define the bbCode tags

// Helpline messages

var help_line = {

o: '{LA_BBCODE_O_HELP}',

p: '{LA_BBCODE_P_HELP}',

w: '{LA_BBCODE_W_HELP}',

s: '{LA_BBCODE_S_HELP}',

f: '{LA_BBCODE_F_HELP}',

e: '{LA_BBCODE_E_HELP}',

<!-- BEGIN custom_tags -->

,cb_{custom_tags.BBCODE_ID}: '{custom_tags.BBCODE_HELPLINE}'

<!-- END custom_tags -->

<legend>{L_SIGNATURE}</legend>

<p>{L_SIGNATURE_EXPLAIN}</p>

<div id="format-buttons">

<!-- IF S_BBCODE_IMG -->

<!-- ENDIF -->

<!-- IF S_LINKS_ALLOWED -->

<!-- ENDIF -->

<!-- IF S_BBCODE_FLASH -->

<!-- ENDIF -->

<option value="7">{L_FONT_TINY}</option>

<option value="9">{L_FONT_SMALL}</option>

<option value="12" selected="selected">{L_FONT_NORMAL}</option>

<option value="18">{L_FONT_LARGE}</option>

<option value="24">{L_FONT_HUGE}</option>

</select>

<!-- IF .custom_tags -->

<br /><br />

<!-- BEGIN custom_tags -->

</div>

<p><input type="text" name="helpbox" value="{L_STYLES_TIP}" class="full" style="border: 0; background: none;" /></p>

<input type="checkbox" class="radio" name="disable_bbcode"{S_BBCODE_CHECKED} />&nbsp; {L_DISABLE_BBCODE} &nbsp;

<!-- ENDIF -->

<!-- IF S_SMILIES_ALLOWED -->

<input type="checkbox" class="radio" name="disable_magic_url"{S_MAGIC_URL_CHECKED} />&nbsp; {L_DISABLE_MAGIC_URL} &nbsp;

<!-- ENDIF -->

<br /><br /><strong>{L_OPTIONS}: </strong>{BBCODE_STATUS} :: {IMG_STATUS} :: {FLASH_STATUS} :: {URL_STATUS} :: {SMILIES_STATUS}

</fieldset>

<fieldset class="quick">

<!-- ENDIF -->

<dd><input id="replacement" type="text" name="replacement" value="{REPLACEMENT}" /></dd>

</dl>

{S_HIDDEN_FIELDS}

<input class="button1" type="submit" id="submit" name="save" value="{L_SUBMIT}" />&nbsp;

<input class="button2" type="reset" id="reset" name="reset" value="{L_RESET}" />

</fieldset>

</form>

<form id="acp_words" method="post" action="{U_ACTION}">

{S_HIDDEN_FIELDS}

<input class="button2" name="add" type="submit" value="{L_ADD_WORD}" />

<table cellspacing="1">

<thead>

</tbody>

</table>

<!-- ENDIF -->

body {

/* Text-Sizing with ems: http://www.clagnut.com/blog/348/ */

color: #536482;

background: #E4EDF0 url("../images/bg_header.gif") 0 0 repeat-x;

font-size: 62.5%; /* This sets the default font size to be equivalent to 10px */

}

h1 {

text-decoration: none;

color: #333333;

}

h2, caption {

text-decoration: none;

line-height: 120%;

text-align: left;

font-size: 1.1em;

}

hr {

border: 0 none;

border-top: 1px solid #999999;

}

#page-header h1 {

font-size: 1.5em;

font-weight: normal;

padding-top: 15px;

#menu ul {

list-style: none;

}

/* Default list state */

display: block;

padding: 5px;

font-size: 0.9em;

color: #FFA34F;

font-weight: bold;

background: #006699 url("../images/cellpic3.gif") 0 0 repeat-x;

}

th, td {

font-size: 1.1em;

text-align: left;

}

legend {

padding: 1px 0;

font-size: 1.1em;

font-weight: bold;

color: #006699;

}

input {

font-size: 100%;

font-weight: normal;

background-color: #FAFAFA;

}

select {

font-size: 100%;

font-weight: normal;

font-style: normal;

}

textarea {

font-size: 100%;

width: 60%;

padding: 2px;

vertical-align: middle;

}

margin: 0 0 5px 0;

padding: 5px 0 0 0;

border: none;

font-size: 1.1em;

}

fieldset.nobg {

margin: 15px 0 0 0;

padding: 0;

Other general def. list properties defined in prosilver_main.css

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

dl {

}

dt {

}

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

fieldset.submit-buttons {

text-align: center;

margin-top: -1px;

}

padding: 3px 2px;

}

/* Input field styles

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

a.button2, input.button2 {

width: auto !important;

padding: 1px 3px 0 3px;

color: #000;

background-color: #EFEFEF;

cursor: pointer;

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

.sourcenum {

color: gray;

font-size: 125%;

font-weight: bold;

line-height: 120%;

}

.source {

font-size: 125%;

line-height: 120%;

padding: 0px;

*/

function helpline(help)

{

}

/**

return retval;

}

/**

*/

{

}

}

function bbfontstyle(bbopen, bbclose)

{

theSelection = false;

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

{

return;

}

// Open tag

insert_text(bbopen + bbclose);

return;

}

/**

* Insert text at position

*/

{

{

}

{

}

else

{

}

}

/**

* Add inline attachment at position

*/

{

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

}

if (document.all)

{

}

else

{

}

// Get text selection - not only the post content :(

if (theSelection == '' || typeof theSelection == 'undefined' || theSelection == null)

{

{

theSelection = divarea.innerText;

}

}

/**

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

*/

function mozWrap(txtarea, open, close)

}

/**

* http://www.faqts.com/knowledge_base/view.phtml/aid/1052/fid/130

*/

function storeCaret(textEl)

numberList[3] = 'BF';

numberList[4] = 'FF';

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

{

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

{

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

document.writeln('</td>');

}

}

document.writeln('</table>');

}

<!-- ENDIF -->

<!-- IF S_SHOW_DOWNLOAD -->

<fieldset class="submit-buttons">

{S_HIDDEN}

<input class="button1" type="submit" id="dlconfig" name="dlconfig" value="{L_DL_DOWNLOAD}" />&nbsp;<input class="button1" type="submit" id="dldone" name="dldone" value="{L_DL_DONE}" />

</fieldset>

<!-- IF L_SUBMIT -->

<fieldset class="submit-buttons">

{S_HIDDEN}

<!-- IF L_SUBMIT --><input class="button1" type="submit" id="submit" name="submit" value="{L_SUBMIT}" /><!-- ENDIF -->

</fieldset>

</form>

<!-- INCLUDE install_header.html -->

<!-- IF S_ERROR -->

<h1>{L_NOTICE}</h1>

<p style="color: red;">{ERROR_MSG}</p>

<!-- ELSEIF S_FILE_CHECK -->

<!-- IF S_NO_UPDATE_FILES -->

<div class="errorbox">

<p>{files.EXPLAIN}</p>

<fieldset>

<legend><img src="{T_IMAGE_PATH}file_{files.STATUS}.gif" alt="{files.L_STATUS}" /></legend>

<!-- ELSE -->

<br /><span>{L_NUM_CONFLICTS}: {files.NUM_CONFLICTS}</span>

<!-- ENDIF -->

</dt>

<!-- IF files.S_CUSTOM -->

<dd><input type="checkbox" name="no_update[]" value="{files.FILENAME}" class="radio" />&nbsp; {L_DO_NOT_UPDATE}</dd>

<!-- ENDIF -->

<p>{L_DOWNLOAD_UPDATE_METHOD_EXPLAIN}</p>

<p>{L_MAPPING_FILE_STRUCTURE}</p>

<table cellspacing="1">

</tbody>

</table>

<!-- ELSEIF S_FTP_UPLOAD -->

<h1>{L_SELECT_FTP_SETTINGS}</h1>

<div id="page-footer">

<!-- IF S_COPYRIGHT_HTML -->

Powered by phpBB {VERSION} &copy; 2006 <a href="http://www.phpbb.com/">phpBB Group</a>

<!-- ENDIF -->

<!-- IF DEBUG_OUTPUT -->

*/

function trace(link)

{

return false;

}

//-->

</script>

<!-- ELSE -->

<td class="preset preset_custom">

<!-- ENDIF -->

<!-- END category -->

</tr>

<tr class="row3">

<!-- IF S_COPYRIGHT_HTML -->

<br />Powered by phpBB {VERSION} &copy; 2006 <a href="http://www.phpbb.com/">phpBB Group</a>

<!-- ENDIF -->

<!-- IF DEBUG_OUTPUT -->

}

}

//-->

</script>

$template->assign_vars(array(

'OPENER' => addslashes(request_var('form', '')),

'NAME' => request_var('name', ''),

$template->display('body');

// Grab global variables, re-cache if necessary

$config = $cache->obtain_config();

?> \ No newline at end of file

'COLUMNS' => array(

'bbcode_id' => array('TINT:3', 0),

'bbcode_tag' => array('VCHAR:16', ''),

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

'bbcode_match' => array('TEXT_UNI', ''),

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

$schema_data['phpbb_config'] = array(

'COLUMNS' => array(

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

),

'PRIMARY_KEY' => 'config_name',

'COLUMNS' => array(

'group_id' => array('UINT', NULL, 'auto_increment'),

'group_type' => array('TINT:4', 1),

'group_name' => array('VCHAR_CI', ''),

'group_desc' => array('TEXT_UNI', ''),

'group_desc_bitfield' => array('VCHAR:255', ''),

'username_clean' => array('VCHAR_CI', ''),

'user_password' => array('VCHAR_UNI:40', ''),

'user_passchg' => array('TIMESTAMP', 0),

'user_email' => array('VCHAR_UNI:100', ''),

'user_email_hash' => array('BINT', 0),

'user_birthday' => array('VCHAR:10', ''),

'user_msnm' => array('VCHAR_UNI', ''),

'user_jabber' => array('VCHAR_UNI', ''),

'user_website' => array('VCHAR_UNI:200', ''),

'user_interests' => array('TEXT_UNI', ''),

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

'user_newpasswd' => array('VCHAR_UNI:32', ''),

WHERE username = '" . $db-&gt;sql_escape($username) . "'";

</pre></blockquote>

<h3>sql_build_array():</h3>

<p>If you need to UPDATE or INSERT data, make use of the <code>$db-&gt;sql_build_array()</code> function. This function already escapes strings and checks other types, so there is no need to do this here. The data to be inserted should go into an array - <code>$sql_ary</code> - or directly within the statement if one one or two variables needs to be inserted/updated. An example of an insert statement would be:</p>

<p>If the given array is empty, an error will be produced.</p>

<h3>sql_build_query():</h3>

<p>The <code>$db-&gt;sql_build_query()</code> function is responsible for building sql statements for select and select distinct queries if you need to JOIN on more than one table or retrieving data from more than one table while doing a JOIN. This needs to be used to make sure the resulting statement is working on all supported db's. Instead of explaining every possible combination, i will give a short example:</p>

<blockquote><pre>

<a name="changes"></a><h1>5. Guidelines Changelog</h1>

<div class="paragraph">

<h2>Revision 1.8</h2>

<ul class="menu">

header("Content-Length: $size");

}

flush();

exit;

AND u.user_id = b.ban_userid

AND b.ban_userid <> 0

AND u.user_id <> ' . ANONYMOUS . '

break;

case 'ip':

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

$bbcode_tpl = htmlspecialchars_decode(request_var('bbcode_tpl', ''));

break;

}

$db->sql_freeresult($result);

// Grab the end, interrogate the last closing tag

{

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

}

}

$sql_ary = array(

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

'bbcode_match' => $bbcode_match,

$sql = 'SELECT *

FROM ' . BBCODES_TABLE . '

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

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

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

'legend2' => 'WARNINGS',

)

);

break;

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

'allow_avatar_upload' => array('lang' => 'ALLOW_UPLOAD', 'validate' => 'bool', 'type' => 'radio:yes_no', 'explain' => false),

'avatar_filesize' => array('lang' => 'MAX_FILESIZE', 'validate' => 'int', 'type' => 'text:4:10', 'explain' => true, 'append' => ' ' . $user->lang['BYTES']),

'avatar_path' => array('lang' => 'AVATAR_STORAGE_PATH', 'validate' => 'rwpath', 'type' => 'text:20:255', 'explain' => true),

'avatar_gallery_path' => array('lang' => 'AVATAR_GALLERY_PATH', 'validate' => 'rpath', 'type' => 'text:20:255', 'explain' => true)

)

'bump_type' => false,

'edit_time' => array('lang' => 'EDIT_TIME', 'validate' => 'int', 'type' => 'text:3:3', 'explain' => true, 'append' => ' ' . $user->lang['MINUTES']),

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

'bump_interval' => array('lang' => 'BUMP_INTERVAL', 'validate' => 'int', 'type' => 'custom', 'method' => 'bump_interval', 'explain' => true),

'topics_per_page' => array('lang' => 'TOPICS_PER_PAGE', 'validate' => 'int', 'type' => 'text:3:4', 'explain' => false),

'posts_per_page' => array('lang' => 'POSTS_PER_PAGE', 'validate' => 'int', 'type' => 'text:3:4', 'explain' => false),

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

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

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

'max_quote_depth' => array('lang' => 'QUOTE_DEPTH_LIMIT', 'validate' => 'int', 'type' => 'text:4:4', 'explain' => true),

)

);

break;

'legend2' => 'GENERAL_SETTINGS',

'max_sig_chars' => array('lang' => 'MAX_SIG_LENGTH', 'validate' => 'int', 'type' => 'text:5:4', 'explain' => true),

'max_sig_urls' => array('lang' => 'MAX_SIG_URLS', 'validate' => 'int', 'type' => 'text:5:4', 'explain' => true),

'max_sig_smilies' => array('lang' => 'MAX_SIG_SMILIES', 'validate' => 'int', 'type' => 'text:5:4', 'explain' => true),

)

);

break;

'min_pass_chars' => array('lang' => 'PASSWORD_LENGTH', 'validate' => 'int', 'type' => 'custom', 'method' => 'password_length', 'explain' => true),

'allow_name_chars' => array('lang' => 'USERNAME_CHARS', 'validate' => 'string', 'type' => 'select', 'method' => 'select_username_chars', 'explain' => true),

'pass_complex' => array('lang' => 'PASSWORD_TYPE', 'validate' => 'string', 'type' => 'select', 'method' => 'select_password_chars', 'explain' => true),

'legend2' => 'GENERAL_OPTIONS',

'allow_namechange' => array('lang' => 'ALLOW_NAME_CHANGE', 'validate' => 'bool', 'type' => 'radio:yes_no', 'explain' => false),

}

$this->new_config = $config;

$error = array();

// We validate the complete config if whished

}

$sql_data .= implode(",\n", $rows);

break;

$sql = 'INSERT INTO ' . DISALLOW_TABLE . ' ' . $db->sql_build_array('INSERT', array('disallow_username' => $disallowed_user));

$db->sql_query($sql);

$message = $user->lang['DISALLOW_SUCCESSFUL'];

add_log('admin', 'LOG_DISALLOW_ADD', str_replace('%', '*', $disallowed_user));

WHERE disallow_id = ' . $disallowed_id;

$db->sql_query($sql);

add_log('admin', 'LOG_DISALLOW_DELETE');

}

$db->sql_freeresult($result);

$s_show_display_on_index = false;

if ($forum_data['parent_id'] > 0)

'S_SHOW_DISPLAY_ON_INDEX' => $s_show_display_on_index,

'S_FORUM_POST' => ($forum_data['forum_type'] == FORUM_POST) ? true : false,

'S_FORUM_ORIG_POST' => (isset($old_forum_type) && $old_forum_type == FORUM_POST) ? true : false,

'S_FORUM_LINK' => ($forum_data['forum_type'] == FORUM_LINK) ? true : false,

'S_FORUM_CAT' => ($forum_data['forum_type'] == FORUM_CAT) ? true : false,

'S_ENABLE_INDEXING' => ($forum_data['enable_indexing']) ? true : false,

$forum_data = $this->get_forum_info($forum_id);

$subforums_id = array();

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

foreach ($subforums as $row)

{

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

'FORUM_NAME' => $forum_data['forum_name'],

'S_FORUM_POST' => ($forum_data['forum_type'] == FORUM_POST) ? true : false,

'S_HAS_SUBFORUMS' => ($forum_data['right_id'] - $forum_data['left_id'] > 1) ? true : false,

'S_FORUMS_LIST' => $forums_list,

'S_ERROR' => (sizeof($errors)) ? true : false,

*/

function update_forum_data(&$forum_data)

{

$errors = array();

$forum_data_sql['forum_posts'] = $forum_data_sql['forum_topics'] = $forum_data_sql['forum_topics_real'] = $forum_data_sql['forum_last_post_id'] = $forum_data_sql['forum_last_poster_id'] = $forum_data_sql['forum_last_post_time'] = 0;

$forum_data_sql['forum_last_poster_name'] = $forum_data_sql['forum_last_poster_colour'] = '';

}

if (sizeof($errors))

{

set_config('upload_dir_size', (int) $row['stat'], true);

return array();

}

{

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

}

}

// Which page?

}

$name_ary = array_unique(explode("\n", $name_ary));

// Add user/s to group

{

trigger_error($user->lang[$error] . adm_back_link($this->u_action . '&amp;action=list&amp;g=' . $group_id), E_USER_WARNING);

}

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

$submit_ary = array(

);

if (!empty($_FILES['uploadfile']['tmp_name']) || $data['uploadurl'] || $data['remotelink'])

{

$data['width'] = request_var('width', '');

// were made.

$group_attributes = array();

foreach ($test_variables as $test)

{

if (isset($submit_ary[$test]) && ($action == 'add' || $group_row['group_' . $test] != $submit_ary[$test]))

if (isset($group_row['group_avatar']) && $group_row['group_avatar'])

{

switch ($group_row['group_avatar_type'])

{

case AVATAR_UPLOAD:

$avatar_img = $phpbb_root_path . $config['avatar_gallery_path'] . '/';

break;

}

$avatar_img = '<img src="' . $avatar_img . '" width="' . $group_row['group_avatar_width'] . '" height="' . $group_row['group_avatar_height'] . '" alt="" />';

}

else

'S_SPECIAL_GROUP' => ($group_type == GROUP_SPECIAL) ? true : false,

'S_DISPLAY_GALLERY' => ($config['allow_avatar_local'] && !$display_gallery) ? true : false,

'S_IN_GALLERY' => ($config['allow_avatar_local'] && $display_gallery) ? true : false,

'ERROR_MSG' => (sizeof($error)) ? implode('<br />', $error) : '',

'GROUP_NAME' => ($group_type == GROUP_SPECIAL) ? $user->lang['G_' . $group_name] : $group_name,

'GROUP_INTERNAL_NAME' => $group_name,

'GROUP_DESC' => $group_desc_data['text'],

'GROUP_RECEIVE_PM' => (isset($group_row['group_receive_pm']) && $group_row['group_receive_pm']) ? ' checked="checked"' : '',

'GROUP_LEGEND' => (isset($group_row['group_legend']) && $group_row['group_legend']) ? ' checked="checked"' : '',

'GROUP_MESSAGE_LIMIT' => (isset($group_row['group_message_limit'])) ? $group_row['group_message_limit'] : 0,

'GROUP_COLOUR' => (isset($group_row['group_colour'])) ? $group_row['group_colour'] : '',

'S_DESC_BBCODE_CHECKED' => $group_desc_data['allow_bbcode'],

'S_DESC_URLS_CHECKED' => $group_desc_data['allow_urls'],

'S_DESC_SMILIES_CHECKED'=> $group_desc_data['allow_smilies'],

// Sorting

$limit_days = array(0 => $user->lang['ALL_ENTRIES'], 1 => $user->lang['1_DAY'], 7 => $user->lang['7_DAYS'], 14 => $user->lang['2_WEEKS'], 30 => $user->lang['1_MONTH'], 90 => $user->lang['3_MONTHS'], 180 => $user->lang['6_MONTHS'], 365 => $user->lang['1_YEAR']);

$sort_by_text = array('i' => $user->lang['SORT_INACTIVE'], 'j' => $user->lang['SORT_REG_DATE'], 'l' => $user->lang['SORT_LAST_VISIT'], 'r' => $user->lang['SORT_REASON'], 'u' => $user->lang['SORT_USERNAME']);

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

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

$template->assign_vars(array(

'U_ACTION' => $this->u_action,

'JAB_ENABLE' => $new['jab_enable'],

'JAB_HOST' => $new['jab_host'],

'JAB_PORT' => $new['jab_port'],

'JAB_USERNAME' => $new['jab_username'],

$hidden_data = build_hidden_fields(array(

'file' => $this->language_file,

'dir' => $this->language_directory,

);

$template->assign_vars(array(

'S_UPLOAD' => true,

'NAME' => $method,

// Sorting

$limit_days = array(0 => $user->lang['ALL_ENTRIES'], 1 => $user->lang['1_DAY'], 7 => $user->lang['7_DAYS'], 14 => $user->lang['2_WEEKS'], 30 => $user->lang['1_MONTH'], 90 => $user->lang['3_MONTHS'], 180 => $user->lang['6_MONTHS'], 365 => $user->lang['1_YEAR']);

$sort_by_text = array('u' => $user->lang['SORT_USERNAME'], 't' => $user->lang['SORT_DATE'], 'i' => $user->lang['SORT_IP'], 'o' => $user->lang['SORT_ACTION']);

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

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

}

$template->assign_block_vars('log', array(

'IP' => $row['ip'],

'DATE' => $user->format_date($row['time']),

foreach ($log_data as $row)

{

$template->assign_block_vars('log', array(

'IP' => $row['ip'],

'DATE' => $user->format_date($row['time']),

'ACTION' => $row['action'])

// Category/not category?

$is_cat = (!$module_data['module_basename']) ? true : false;

$module_infos = $this->get_module_infos();

// Build name options

}

/**

*/

function get_module_infos($module = '', $module_class = false)

{

$right = $row['right_id'];

if (!$ignore_acl && $row['module_auth'])

{

{

continue;

}

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

$profile_sql = $profile_lang = $empty_lang = $profile_lang_fields = array();

$default_lang_id = $lang_defs['iso'][$config['default_lang']];

/**

* @todo remove Javascript

*/

<!--

close_waitscreen = 1;

//-->

foreach ($classes as $class)

{

$selected = ($class == $edit_class) ? ' selected="selected"' : '';

}

$template->assign_vars(array(

// Prevent normal users/admins change/view founders if they are not a founder by themselves

if ($user->data['user_type'] != USER_FOUNDER && $user_row['user_type'] == USER_FOUNDER)

{

}

switch ($mode)

$data = array(

'username' => request_var('user', $user_row['username'], true),

'user_founder' => request_var('user_founder', ($user_row['user_type'] == USER_FOUNDER) ? 1 : 0),

'user_password' => request_var('user_password', '', true),

'password_confirm' => request_var('password_confirm', '', true),

'warnings' => request_var('warnings', $user_row['user_warnings']),

$last_visit = (!empty($user_row['session_time'])) ? $user_row['session_time'] : $user_row['user_lastvisit'];

$template->assign_vars(array(

'L_NAME_CHARS_EXPLAIN' => sprintf($user->lang[$user_char_ary[str_replace('\\\\', '\\', $config['allow_name_chars'])] . '_EXPLAIN'], $config['min_name_chars'], $config['max_name_chars']),

'L_CHANGE_PASSWORD_EXPLAIN' => sprintf($user->lang[$pass_char_ary[str_replace('\\\\', '\\', $config['pass_complex'])] . '_EXPLAIN'], $config['min_pass_chars'], $config['max_pass_chars']),

'USER_EMAIL' => $user_row['user_email'],

'USER_WARNINGS' => $user_row['user_warnings'],

'USER_POSTS' => $user_row['user_posts'],

)

);

// Sorting

$limit_days = array(0 => $user->lang['ALL_ENTRIES'], 1 => $user->lang['1_DAY'], 7 => $user->lang['7_DAYS'], 14 => $user->lang['2_WEEKS'], 30 => $user->lang['1_MONTH'], 90 => $user->lang['3_MONTHS'], 180 => $user->lang['6_MONTHS'], 365 => $user->lang['1_YEAR']);

$sort_by_text = array('u' => $user->lang['SORT_USERNAME'], 't' => $user->lang['SORT_DATE'], 'i' => $user->lang['SORT_IP'], 'o' => $user->lang['SORT_ACTION']);

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

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

foreach ($log_data as $row)

{

$template->assign_block_vars('log', array(

'IP' => $row['ip'],

'DATE' => $user->format_date($row['time']),

'ACTION' => nl2br($row['action']),

'yim' => request_var('yim', $user_row['user_yim']),

'jabber' => request_var('jabber', $user_row['user_jabber']),

'website' => request_var('website', $user_row['user_website']),

'bday_day' => 0,

'bday_month' => 0,

'bday_year' => 0,

);

if ($user_row['user_birthday'])

{

case 'prefs':

$data = array(

'lang' => request_var('lang', $user_row['user_lang']),

'tz' => request_var('tz', (float) $user_row['user_timezone']),

'style' => request_var('style', $user_row['user_style']),

$enable_bbcode = ($config['allow_sig_bbcode']) ? request_var('enable_bbcode', $this->optionget($user_row, 'bbcode')) : false;

$enable_smilies = ($config['allow_sig_smilies']) ? request_var('enable_smilies', $this->optionget($user_row, 'smilies')) : false;

$enable_urls = request_var('enable_urls', true);

$preview = (isset($_POST['preview'])) ? true : false;

if ($submit || $preview)

trigger_error($user->lang['NO_GROUP'] . adm_back_link($this->u_action . '&amp;u=' . $user_id), E_USER_WARNING);

}

// Add user/s to group

if ($error = group_user_add($group_id, $user_id))

{

$db->sql_freeresult($result);

// Select box for other groups

FROM ' . GROUPS_TABLE . '

' . ((sizeof($id_ary)) ? 'WHERE ' . $db->sql_in_set('group_id', $id_ary, true) : '') . '

ORDER BY group_type DESC, group_name ASC';

continue;

}

$s_group_options .= '<option' . (($row['group_type'] == GROUP_SPECIAL) ? ' class="sep"' : '') . ' value="' . $row['group_id'] . '">' . (($row['group_type'] == GROUP_SPECIAL) ? $user->lang['G_' . $row['group_name']] : $row['group_name']) . '</option>';

}

$db->sql_freeresult($result);

if ($db->sql_layer == 'mssql' || $db->sql_layer == 'mssql_odbc')

{

}

$sql .= 'AND is_global = 1

if ($db->sql_layer == 'mssql' || $db->sql_layer == 'mssql_odbc')

{

}

$sql .= 'AND is_local = 1

break;

case 'save':

if (!$word || !$replacement)

{

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

$sql = 'SELECT user_id as ug_id, username as ug_name

FROM ' . USERS_TABLE . '

WHERE ' . $db->sql_in_set('user_id', array_keys($hold_ary)) . '

}

else

{

$sql = 'SELECT user_id, username

FROM ' . USERS_TABLE . '

WHERE ' . $db->sql_in_set('user_id', $auth_ary['users']) . '

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

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

'S_FIELD_NAME' => 'setting[' . $ug_id . '][' . $forum_id . '][' . $permission . ']',

'U_TRACE' => ($show_trace) ? append_sid("{$phpbb_admin_path}index.$phpEx", "i=permissions&amp;mode=trace&amp;u=$ug_id&amp;f=$forum_id&amp;auth=$permission") : '',

'PERMISSION' => $user->lang['acl_' . $permission]['lang'])

);

$sql_user = ($user_id !== false) ? ((!is_array($user_id)) ? "user_id = $user_id" : $db->sql_in_set('user_id', $user_id)) : '';

$sql_forum = ($forum_id !== false) ? ((!is_array($forum_id)) ? "AND a.forum_id = $forum_id" : 'AND ' . $db->sql_in_set('a.forum_id', $forum_id)) : '';

if ($opts !== false)

{

}

$hold_ary = array();

'ORDER_BY' => 'a.forum_id, ao.auth_option'

));

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

{

$sql_user = ($user_id !== false) ? ((!is_array($user_id)) ? "user_id = $user_id" : $db->sql_in_set('user_id', $user_id)) : '';

$sql_forum = ($forum_id !== false) ? ((!is_array($forum_id)) ? "AND a.forum_id = $forum_id" : 'AND ' . $db->sql_in_set('a.forum_id', $forum_id)) : '';

if ($opts !== false)

{

}

$hold_ary = array();

'ORDER_BY' => 'a.forum_id, ao.auth_option'

));

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

{

$sql_group = ($group_id !== false) ? ((!is_array($group_id)) ? "group_id = $group_id" : $db->sql_in_set('group_id', $group_id)) : '';

$sql_forum = ($forum_id !== false) ? ((!is_array($forum_id)) ? "AND a.forum_id = $forum_id" : 'AND ' . $db->sql_in_set('a.forum_id', $forum_id)) : '';

if ($opts !== false)

{

}

$hold_ary = array();

'ORDER_BY' => 'a.forum_id, ao.auth_option'

));

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

{

/**

* Fill auth_option statement for later querying based on the supplied options

*/

{

global $db;

if (strpos($auth_options, '_') !== false)

{

$sql_opts = "AND $key LIKE '" . $db->sql_escape(str_replace('_', "\_", $auth_options)) . "'";

}

else

{

}

else

{

foreach ($auth_options as $option)

{

{

$is_like_expression = true;

}

}

if (!$is_like_expression)

foreach ($auth_options as $option)

{

}

$sql_opts = 'AND (' . implode(' OR ', $sql) . ')';

}

}

}

{

global $db, $config;

FROM ' . USERS_TABLE . "

WHERE username_clean = '" . $db->sql_escape(utf8_clean_string($username)) . "'";

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

}

}

{

// Successful, reset login attempts (the user passed all stages)

$sql = 'UPDATE ' . USERS_TABLE . '

<dd><input type="text" id="ldap_uid" size="40" name="config[ldap_uid]" value="' . $new['ldap_uid'] . '" /></dd>

</dl>

<dl>

</dl>

';

{

$this->bbcode_cache[$bbcode_id] = array(

'preg' => array(

)

);

}

{

$this->bbcode_cache[$bbcode_id] = array(

'preg' => array(

)

);

}

/**

* Return bbcode template

*/

{

if (empty($bbcode_hardtpl))

{

$template_bitfield = new bitfield($this->template_bitfield);

}

{

return (isset($bbcode_hardtpl[$tpl_name])) ? $bbcode_hardtpl[$tpl_name] : false;

}

*/

class captcha

{

function execute($code)

{

global $config;

$stats = gd_info();

preg_match('/[\\d.]+/', $stats['GD Version'], $version);

// create the image, stay compat with older versions of GD

if ($gd_version === 2)

$func2 = 'imagecolorclosest';

}

if ($bundled)

{

// set background color

$back = imagecolorallocate($image, mt_rand(224, 255), mt_rand(224, 255), mt_rand(224, 255));

// allocates the 216 websafe color palette to the image

if ($gd_version === 1)

}

}

// fill with noise or grid

if ($config['captcha_gd_noise'])

{

$size = mt_rand(8, 23);

$angle = mt_rand(0, 360);

$x = mt_rand(0, 360);

$color = $func2($image, mt_rand(160, 224), mt_rand(160, 224), mt_rand(160, 224));

$text = chr(mt_rand(45, 250));

imagettftext($image, $size, $angle, $x, $y, $color, $this->get_font(), $text);

else

{

// generate grid

{

$color = $func2($image, mt_rand(160, 224), mt_rand(160, 224), mt_rand(160, 224));

}

{

$color = $func2($image, mt_rand(160, 224), mt_rand(160, 224), mt_rand(160, 224));

}

}

$text = strtoupper($code[$i]);

$angle = mt_rand(-30, 30);

$size = mt_rand(20, 40);

$color = $func2($image, mt_rand(0, 127), mt_rand(0, 127), mt_rand(0, 127));

$shadow = $func2($image, mt_rand(127, 254), mt_rand(127, 254), mt_rand(127, 254));

class captcha

{

var $filtered_pngs;

/**

* Define filtered pngs on init

*/

function execute($code)

{

$img_width = 0;

list($usec, $sec) = explode(' ', microtime());

for ($i = 0; $i < $code_len; $i++)

{

$width = mt_rand(0, 4);

$raw_width = $this->filtered_pngs[$char]['width'];

}

}

$image = '';

{

$image .= chr(0);

$image .= $this->randomise(substr($hold_chars[$code{$j}][$i - $offset_y - 1], 1), $char_widths[$j]);

}

{

$image .= chr(mt_rand(140, 255));

}

}

else

{

{

$image .= chr(mt_rand(140, 255));

}

}

unset($hold_chars);

// Output image

header('Content-Type: image/png');

}

else

{

}

}

/**

* Run more than one insert statement.

*

*

* @return bool false if no statements were executed.

* @access public

case 'mysql':

case 'mysql4':

case 'mysqli':

$this->sql_query('INSERT INTO ' . $table . ' ' . $this->sql_build_array('MULTI_INSERT', $sql_ary));

break;

$this->sql_report('start', $query);

}

$this->query_result = ($cache_ttl && method_exists($cache, 'sql_load')) ? $cache->sql_load($query) : false;

$this->sql_add_num_queries($this->query_result);

$this->sql_report('start', $query);

}

$this->last_query_text = $query;

$this->query_result = ($cache_ttl && method_exists($cache, 'sql_load')) ? $cache->sql_load($query) : false;

$this->sql_add_num_queries($this->query_result);

{

$this->query_result = false;

$query = 'SELECT * FROM (SELECT /*+ FIRST_ROWS */ rownum AS xrownum, a.* FROM (' . $query . ') a WHERE rownum <= ' . ($offset + $total) . ') WHERE xrownum >= ' . $offset;

return $this->sql_query($query, $cache_ttl);

* Code from pear.php.net, Text_Diff-0.2.1 (beta) package

* http://pear.php.net/package/Text_Diff/

*

* and being able to integrate into phpBB

* General API for generating and formatting diffs - the differences between

* two sequences of strings.

*

* @package phpBB3

* @author Geoffrey T. Dairiki <dairiki@dairiki.org>

*/

/**

* Removes trailing newlines from a line of text. This is meant to be used with array_walk().

*

* @param integer $key The index of the line in the array. Not used.

*/

function trim_newlines(&$line, $key)

* Code from pear.php.net, Text_Diff-0.2.1 (beta) package

* http://pear.php.net/package/Text_Diff/

*

* and being able to integrate into phpBB

* Class used internally by Diff to actually compute the diffs. This class is

* implemented using native PHP code.

*

* Code from pear.php.net, Text_Diff-0.2.1 (beta) package

* http://pear.php.net/package/Text_Diff/

*

* and being able to integrate into phpBB

* A class to render Diffs in different formats.

*

* This class renders the diff in classic diff format. It is intended that

/**

* Renders a diff.

*

*

* @return string The formatted output.

*/

/**

* Return unique id

*/

function unique_id($extra = 'c')

{

*/

function make_jumpbox($action, $forum_id = false, $select_all = false, $acl_list = false)

{

if (!$config['load_jumpbox'])

{

* Find position of first occurrence of a case-insensitive string

*

* @param string $haystack is the string to search in

*

* Note that the needle may be a string of one or more characters.

* If needle is not found, stripos() will return boolean FALSE.

*/

else if (isset($_SERVER['SCRIPT_FILENAME']) && !empty($_SERVER['SCRIPT_FILENAME']))

{

// Warning: If chdir() has been used this will lie!

$path = str_replace(DIRECTORY_SEPARATOR, '/', dirname($_SERVER['SCRIPT_FILENAME'])) . '/' . $path;

$absolute = true;

$path_prefix = '';

if (!function_exists('htmlspecialchars_decode'))

{

function htmlspecialchars_decode($string, $quote_style = ENT_COMPAT)

{

return strtr($string, array_flip(get_html_translation_table(HTML_SPECIALCHARS, $quote_style)));

*/

function tz_select($default = '', $truncate = false)

{

$tz_select = '';

foreach ($user->lang['tz_zones'] as $offset => $zone)

{

if ($truncate)

{

}

if (is_numeric($offset))

{

$selected = ($offset == $default) ? ' selected="selected"' : '';

}

}

}

}

if ($result['status'] == LOGIN_SUCCESS)

{

$redirect = request_var('redirect', "{$phpbb_root_path}index.$phpEx");

function get_context($text, $words, $length = 400)

{

// first replace all whitespaces with single spaces

$word_indizes = array();

if (sizeof($words))

// Be sure to not let the matches cross over. ;)

// relative urls for this board

$magic_url_replace[] = "'\$1<!-- l --><a href=\"\$2/' . preg_replace('/(&amp;|\?)sid=[0-9a-f]{32}/', '\\1', '\$3') . '\">' . preg_replace('/(&amp;|\?)sid=[0-9a-f]{32}/', '\\1', '\$3') . '</a><!-- l -->'";

// matches a xxxx://aaaaa.bbb.cccc. ...

$magic_url_replace[] = "'\$1<!-- m --><a href=\"\$2\">' . ((strlen('\$2') > 55) ? substr(str_replace('&amp;', '&', '\$2'), 0, 39) . ' ... ' . substr(str_replace('&amp;', '&', '\$2'), -10) : '\$2') . '</a><!-- m -->'";

// matches a "www.xxxx.yyyy[/zzzz]" kinda lazy URL thing

$magic_url_replace[] = "'\$1<!-- w --><a href=\"http://\$2\">' . ((strlen('\$2') > 55) ? substr(str_replace('&amp;', '&', '\$2'), 0, 39) . ' ... ' . substr(str_replace('&amp;', '&', '\$2'), -10) : '\$2') . '</a><!-- w -->'";

// matches an email@domain type address at the start of a line, or after a space or after what might be a BBCode.

$magic_url_replace[] = "'\$1<!-- e --><a href=\"mailto:\$2\">' . ((strlen('\$2') > 55) ? substr('\$2', 0, 39) . ' ... ' . substr('\$2', -10) : '\$2') . '</a><!-- e -->'";

}

/**

* Little helper for the build_hidden_fields function

*/

{

$hidden_fields = '';

if (!is_array($value))

{

$hidden_fields .= '<input type="hidden" name="' . $key . '" value="' . $value . '" />' . "\n";

}

{

foreach ($value as $_key => $_value)

{

}

}

/**

* Build simple hidden fields from array

*/

{

$s_hidden_fields = '';

foreach ($field_ary as $name => $vars)

{

}

return $s_hidden_fields;

$trace['file'] = substr($trace['file'], 1);

$args = array();

if (!in_array($trace['function'], array('include', 'require', 'include_once')))

{

unset($trace['args']);

* Truncates string while retaining special characters if going over the max length

* The default max length is 60 at the moment

*/

{

$chars = array();

$strip_reply = false;

if ($allow_reply && strpos($string, 'Re: ') === 0)

{

$strip_reply = true;

{

// Cut off the last elements from the array

$string = implode('', array_slice($chars, 0, $max_length));

}

if ($strip_reply)

{

$string = 'Re: ' . $string;

}

return $string;

}

/**

* Wrapper for php's checkdnsrr function.

@exec('nslookup -type=' . escapeshellarg($type) . ' ' . escapeshellarg($host), $output);

foreach ($output as $line)

{

if (!trim($line))

// Check the error reporting level and return if the error level does not match

// Additionally do not display notices if we suppress them via @

{

return;

}

{

}

break;

case E_USER_ERROR:

// Specify escape character for MSSQL

if ($db->sql_layer == 'mssql' || $db->sql_layer == 'mssql_odbc')

{

}

}

$reading_sql .

((!$config['load_online_guests']) ? ' AND s.session_user_id <> ' . ANONYMOUS : '') . '

AND u.user_id = s.session_user_id

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

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

}

$template->assign_vars(array(

'U_ACP' => ($auth->acl_get('a_') && $user->data['is_registered']) ? append_sid("{$phpbb_root_path}adm/index.$phpEx", '', true, $user->session_id) : '')

);

if ($cron_type)

{

}

}

if ($return_array)

{

$selected = (is_array($select_id)) ? ((in_array($row['forum_id'], $select_id)) ? true : false) : (($row['forum_id'] == $select_id) ? true : false);

$forum_list[$row['forum_id']] = array_merge(array('padding' => $padding, 'selected' => $selected), $row);

}

sync('forum', 'forum_id', $forum_ids, true);

}

update_posted_info($topic_ids);

}

{

global $db, $config;

$forum_ids = $topic_ids = array();

if (is_array($where_ids))

'posts' => delete_posts($where_type, $where_ids, false, true)

);

FROM ' . TOPICS_TABLE . '

WHERE ' . $db->sql_in_set($where_type, $where_ids);

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

{

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

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

}

$db->sql_freeresult($result);

sync('topic_reported', $where_type, $where_ids);

}

return $return;

}

return false;

}

$post_ids = $topic_ids = $forum_ids = $post_counts = array();

FROM ' . POSTS_TABLE . '

WHERE ' . $db->sql_in_set($where_type, array_map('intval', $where_ids));

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

{

$post_counts[$row['poster_id']] = (!empty($post_counts[$row['poster_id']])) ? $post_counts[$row['poster_id']] + 1 : 1;

}

}

$db->sql_freeresult($result);

sync('forum', 'forum_id', $forum_ids, true);

}

return sizeof($post_ids);

}

}

/**

*/

function update_posted_info(&$topic_ids)

{

/**

* Cache moderators, called whenever permissions are changed via admin_permissions. Changes of username

* and group names must be carried through for the moderators table

*/

function cache_moderators()

{

case 'user':

$log_type = LOG_USERS;

break;

case 'users':

return;

}

FROM " . LOG_TABLE . " l, " . USERS_TABLE . " u

WHERE l.log_type = $log_type

AND u.user_id = l.user_id

$log[$i] = array(

'id' => $row['log_id'],

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

'ip' => $row['log_ip'],

'time' => $row['log_time'],

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

}

}

{

$reportee_id_list = array_unique($reportee_id_list);

$reportee_names_list = array();

{