+

+ $cache->destroy('extensions');

+ case 'mysqli':

+ <td class="<?php echo $row_class; ?>"><input class="post" type="text" name="emotion[<?php echo $img; ?>]" value="<?php echo (!empty($img_row['emotion'])) ? $img_row['emotion'] : '' ?>" size="10" /></td>

+ 'emotion' => $image_emotion[$image],

+ 'emotion' => $emotion

+ 'emotion' => $emotion

+ $pak .= "'" . addslashes($row['emotion']) . "', ";

+ <td class="<?php echo $row_class; ?>" align="center"><?php echo $row['emotion']; ?></td>

+ trigger_error('NO_ADMIN');

+$language_file_header = '<?php

+/**

+*

+* {FILENAME} [{LANG_NAME}]

+*

+* @package phpBB3

+* @version $Id$

+* @copyright (c) 2005 phpBB Group

+* @author {CHANGED} - {AUTHOR}

+* @license http://opensource.org/licenses/gpl-license.php GNU Public License

+*

+*/

+

+// DEVELOPERS PLEASE NOTE

+//

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

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

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

+//

+// You do not need this where single placeholders are used, e.g. \'Message %d\' is fine

+// equally where a string contains only two placeholders which are used to wrap text

+// in a url you again do not need to specify an order e.g., \'Click %sHERE%s\' is fine

+

+/**

+*/

+';

+

+ $header = str_replace(array('{FILENAME}', '{LANG_NAME}', '{CHANGED}', '{AUTHOR}'), array($cur_file, $row['lang_english_name'], date('Y-m-d', time()), $row['lang_author']), $language_file_header);

+ $header .= '$help = array(' . "\n";

+ $header = str_replace(array('{FILENAME}', '{LANG_NAME}', '{CHANGED}', '{AUTHOR}'), array($cur_file, $row['lang_english_name'], date('Y-m-d', time()), $row['lang_author']), $language_file_header);

+ $header .= '

+/**

+* DO NOT CHANGE

+*/

+ if (!file_exists(get_filename($lang_iso, "email/$file")))

+ $missing_files[] = get_filename($lang_iso, "email/$file");

+ $function = ($is_help_file) ? 'print_help_entries' : 'print_language_entries';

+ $function($missing_vars[$cur_file], '* ');

+ $function($lang);

+ <td class="row1" colspan="2" align="center"><textarea name="entry" cols="80" rows="20" class="post" style="width:90%"><?php echo $lang; ?></textarea></td>

+ // Output list of language packs

+/**

+* Compare two language files

+*/

+/**

+* Print language entries

+*/

+ <?php if ($input_field) { ?><input type="text" class="post" name="entry[<?php echo $key; ?>]" value="<?php echo htmlspecialchars($value); ?>" style="width:99%" /><?php } else { ?><b><?php echo htmlspecialchars($value); ?></b><?php } ?></td>

+/**

+* Print help entries

+*/

+function print_help_entries(&$lang_ary, $key_prefix = '', $text_field = true)

+{

+ foreach ($lang_ary as $key => $value)

+ {

+?>

+ <tr>

+ <td class="row1" width="10%" nowrap="nowrap"><?php echo $key_prefix; ?><b><?php echo $key; ?></b></td>

+ <td class="row2">

+<?php

+ if (is_array($value))

+ {

+?>

+ &nbsp;</td>

+ </tr>

+<?php

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

+ {

+?>

+ <tr>

+ <td class="row1" width="10%" nowrap="nowrap"><?php echo $key_prefix; ?><b><?php echo $key . ' :: ' . $_key; ?></b></td>

+ <td class="row2"><?php if ($text_field) { ?><textarea class="post" name="entry[<?php echo $key; ?>][<?php echo $_key; ?>]" cols="80" rows="5" class="post" style="width:90%"><?php echo htmlspecialchars($_value); ?></textarea><?php } else { ?><b><?php echo htmlspecialchars($_value); ?></b><?php } ?></td>

+ </tr>

+<?php

+ }

+ }

+ else

+ {

+?>

+ <?php if ($text_field) { ?><textarea type="text" class="post" name="entry[<?php echo $key; ?>]" cols="80" rows="5" style="width:90%"><?php echo htmlspecialchars($value); ?></textarea><?php } else { ?><b><?php echo htmlspecialchars($value); ?></b><?php } ?></td>

+ </tr>

+<?php

+ }

+ }

+}

+

+/**

+* Get filename/location of language/help/email file

+*/

+ trigger_error('NO_ADMIN');

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

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

+ trigger_error('NO_FIELD_ID');

+ trigger_error('FIELD_NOT_FOUND');

+ $lang_options = $field_row = array();

+ 'field_no_view' => 0,

+ // $exclude contains the data that we gather in each step

+ 2 => array('field_length', 'pf_preview', 'field_maxlen', 'field_minlen', 'field_validation', 'field_novalue', 'field_default_value', 'field_required', 'field_show_on_reg', 'field_hide', 'field_no_view'),

+ $cp->vars['field_ident'] = request_var('field_ident', $field_row['field_ident']);

+

+ // Changing the number of options? (We remove and re-create the option fields)

+ $cp->vars['lang_options'] = explode("\n", $options);

+ if ($key == 'field_required' || $key == 'field_show_on_reg' || $key == 'field_hide' || $key == 'field_no_view')

+ $error[] = $user->lang['NO_FIELD_ENTRIES'];

+ <tr>

+ <td class="row1"><b><?php echo $user->lang['EXCLUDE_FROM_VIEW']; ?></b><br /><span class="gensmall"><?php echo $user->lang['EXCLUDE_FROM_VIEW_EXPLAIN']; ?></span></td>

+ <td class="row2"><input type="checkbox" name="field_no_view" value="1"<?php echo (($cp->vars['field_no_view']) ? ' checked="checked"' : ''); ?> /></td>

+ </tr>

+ $sql = 'UPDATE ' . PROFILE_FIELDS_TABLE . "

+ add_log('admin', 'LOG_REMOVED_PROFILE_FIELD', $field_ident);

+ trigger_error('REMOVED_PROFILE_FIELD');

+ $sql = 'SELECT field_ident

+ FROM ' . PROFILE_FIELDS_TABLE . "

+ WHERE field_id = $field_id";

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

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

+ $db->sql_freeresult($result);

+

+ add_log('admin', 'LOG_ACTIVATE_PROFILE_FIELD', $field_ident);

+ $sql = 'SELECT field_ident

+ FROM ' . PROFILE_FIELDS_TABLE . "

+ WHERE field_id = $field_id";

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

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

+ $db->sql_freeresult($result);

+

+ add_log('admin', 'LOG_DEACTIVATE_PROFILE_FIELD', $field_ident);

+ <th nowrap="nowrap"><?php echo $user->lang['FIELD_IDENT']; ?></th>

+ <th nowrap="nowrap"><?php echo $user->lang['FIELD_TYPE']; ?></th>

+ <th colspan="3" nowrap="nowrap"><?php echo $user->lang['OPTIONS']; ?></th>

+ <th nowrap="nowrap"><?php echo $user->lang['REORDER']; ?></th>

+

+ $var = ($mode == 'create' || !is_array($cp->vars['lang_options'][$lang_id])) ? $cp->vars['lang_options'] : $cp->vars['lang_options'][$lang_id];

+ $var = ($mode == 'create' || !is_array($cp->vars[$field])) ? $cp->vars[$field] : $cp->vars[$field][$lang_id];

+ 'field_hide' => $cp->vars['field_hide'],

+ 'field_no_view' => $cp->vars['field_no_view']

+

+ 'lang_explain' => (isset($cp->vars['l_lang_explain'][$lang_id])) ? $cp->vars['l_lang_explain'][$lang_id] : '',

+ 'lang_default_value' => (isset($cp->vars['l_lang_default_value'][$lang_id])) ? $cp->vars['l_lang_default_value'][$lang_id] : ''

+

+ foreach ($empty_lang as $lang_id => $NULL)

+ {

+ $sql = 'DELETE FROM ' . PROFILE_LANG_TABLE . "

+ WHERE field_id = $field_id

+ AND lang_id = " . (int) $lang_id;

+ $db->sql_query($sql);

+ }

+ if ($mode != 'create')

+ {

+ $sql = 'DELETE FROM ' . PROFILE_FIELDS_LANG_TABLE . "

+ WHERE field_id = $field_id

+ AND lang_id = " . (int) $default_lang_id;

+ $db->sql_query($sql);

+ }

+

+ if (is_array($cp->vars['l_lang_options']) && sizeof($cp->vars['l_lang_options']))

+ $empty_lang = array();

+

+ if ($mode != 'create')

+ {

+ $sql = 'DELETE FROM ' . PROFILE_FIELDS_LANG_TABLE . "

+ WHERE field_id = $field_id

+ AND lang_id = " . (int) $lang_id;

+ $db->sql_query($sql);

+ }

+

+

+ foreach ($empty_lang as $lang_id => $NULL)

+ {

+ $sql = 'DELETE FROM ' . PROFILE_FIELDS_LANG_TABLE . "

+ WHERE field_id = $field_id

+ AND lang_id = " . (int) $lang_id;

+ $db->sql_query($sql);

+ }

+ $db->sql_transaction();

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

+ if ($mode == 'edit')

+ {

+ add_log('admin', 'LOG_EDIT_PROFILE_FIELD', $cp->vars['field_ident'] . ':' . $cp->vars['lang_name']);

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

+ }

+ else

+ {

+ add_log('admin', 'LOG_CREATE_PROFILE_FIELD', $field_ident . ':' . $cp->vars['lang_name']);

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

+ }

+ $check_key = '';

+ $check_key = (!$check_key) ? $key : $check_key;

+ $sql = "SELECT $check_key

+ FROM $table

+ WHERE " . implode(' AND ', $where_sql);

+ if (!$db->sql_fetchrow($result))

+ $db->sql_freeresult($result);

+

+ else

+ {

+ $db->sql_freeresult($result);

+

+ $sql = "UPDATE $table SET " . $db->sql_build_array('UPDATE', $sql_ary) . '

+ WHERE ' . implode(' AND ', $where_sql);

+ $db->sql_query($sql);

+ }