- // Initial selection

- $sql = 'SELECT group_id, group_type, group_name

- FROM ' . GROUPS_TABLE . '

- ORDER BY group_type DESC, group_name ASC';

- $select_list .= group_select_options($group_id);

- $perms += $user_ary;

- WHERE zebra_id IN (' . implode(', ', $perms) . ')

- $sql = 'SELECT username

- $username = (string) $db->sql_fetchfield('username');

- if (!$username)

- 'PERMISSION_USERNAME' => $username)

-

- 'WHO' => $username,

-// Table names - do not set if in installation

-if (defined('IN_INSTALL'))

- return;

-// Table names

-define('ACL_GROUPS_TABLE', $table_prefix.'auth_groups');

-define('ACL_OPTIONS_TABLE', $table_prefix.'auth_options');

-define('ACL_ROLES_TABLE', $table_prefix.'auth_roles');

-define('ACL_ROLES_DATA_TABLE', $table_prefix.'auth_roles_data');

-define('ACL_USERS_TABLE', $table_prefix.'auth_users');

-define('ATTACHMENTS_TABLE', $table_prefix.'attachments');

-define('BANLIST_TABLE', $table_prefix.'banlist');

-define('BBCODES_TABLE', $table_prefix.'bbcodes');

-define('BOOKMARKS_TABLE', $table_prefix.'bookmarks');

-define('BOTS_TABLE', $table_prefix.'bots');

-define('CACHE_TABLE', $table_prefix.'cache');

-define('CONFIG_TABLE', $table_prefix.'config');

-define('CONFIRM_TABLE', $table_prefix.'confirm');

-define('PROFILE_FIELDS_TABLE', $table_prefix.'profile_fields');

-define('PROFILE_LANG_TABLE', $table_prefix.'profile_lang');

-define('PROFILE_DATA_TABLE', $table_prefix.'profile_fields_data');

-define('PROFILE_FIELDS_LANG_TABLE', $table_prefix.'profile_fields_lang');

-define('DISALLOW_TABLE', $table_prefix.'disallow'); //

-define('DRAFTS_TABLE', $table_prefix.'drafts');

-define('EXTENSIONS_TABLE', $table_prefix.'extensions');

-define('EXTENSION_GROUPS_TABLE', $table_prefix.'extension_groups');

-define('FORUMS_TABLE', $table_prefix.'forums');

-define('FORUMS_ACCESS_TABLE', $table_prefix.'forum_access');

-define('FORUMS_TRACK_TABLE', $table_prefix.'forums_marking');

-define('FORUMS_WATCH_TABLE', $table_prefix.'forums_watch');

-define('GROUPS_TABLE', $table_prefix.'groups');

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

-define('LANG_TABLE', $table_prefix.'lang');

-define('LOG_TABLE', $table_prefix.'log');

-define('MODERATOR_TABLE', $table_prefix.'moderator_cache');

-define('MODULES_TABLE', $table_prefix . 'modules');

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

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

-define('PRIVMSGS_TO_TABLE', $table_prefix.'privmsgs_to');

-define('PRIVMSGS_FOLDER_TABLE', $table_prefix.'privmsgs_folder');

-define('PRIVMSGS_RULES_TABLE', $table_prefix.'privmsgs_rules');

-define('RANKS_TABLE', $table_prefix.'ranks');

-define('RATINGS_TABLE', $table_prefix.'ratings');

-define('REPORTS_TABLE', $table_prefix.'reports');

-define('REASONS_TABLE', $table_prefix.'reports_reasons');

-define('SEARCH_TABLE', $table_prefix.'search_results');

-define('SEARCH_WORD_TABLE', $table_prefix.'search_wordlist');

-define('SEARCH_MATCH_TABLE', $table_prefix.'search_wordmatch');

-define('SESSIONS_TABLE', $table_prefix.'sessions');

-define('SESSIONS_KEYS_TABLE', $table_prefix.'sessions_keys');

-define('SITELIST_TABLE', $table_prefix.'sitelist');

-define('SMILIES_TABLE', $table_prefix.'smilies');

-define('STYLES_TABLE', $table_prefix.'styles');

-define('STYLES_TPL_TABLE', $table_prefix.'styles_template');

-define('STYLES_TPLDATA_TABLE', $table_prefix.'styles_template_data');

-define('STYLES_CSS_TABLE', $table_prefix.'styles_theme');

-define('STYLES_IMAGE_TABLE', $table_prefix.'styles_imageset');

-define('TOPICS_TABLE', $table_prefix.'topics');

-define('TOPICS_POSTED_TABLE', $table_prefix.'topics_posted');

-define('TOPICS_WATCH_TABLE', $table_prefix.'topics_watch');

-define('TOPICS_TRACK_TABLE', $table_prefix.'topics_marking');

-define('USER_GROUP_TABLE', $table_prefix.'user_group');

-define('USERS_TABLE', $table_prefix.'users');

-define('USERS_NOTES_TABLE', $table_prefix.'users_notes');

-define('WARNINGS_TABLE', $table_prefix.'warnings');

-define('WORDS_TABLE', $table_prefix.'words');

-define('POLL_OPTIONS_TABLE', $table_prefix.'poll_results');

-define('POLL_VOTES_TABLE', $table_prefix.'poll_voters');

-define('ZEBRA_TABLE', $table_prefix.'zebra');

-

-// Additional tables

-

-

- if($dss_seeded !== true)

- echo ' <p>Please notify the board administrator or webmaster : <a href="mailto:' . $config['board_contact'] . '">' . $config['board_contact'] . '</a></p>';

- $debug_output = sprintf('Time : %.3fs | ' . $db->sql_num_queries() . ' Queries | GZIP : ' . (($config['gzip_compress']) ? 'On' : 'Off' ) . ' | Load : ' . (($user->load) ? $user->load : 'N/A'), $totaltime);

- global $db, $user, $template, $phpEx, $SID, $phpbb_root_path;

- global $SID, $template, $auth, $user;

- ($auth->acl_get('f_attach', $forum_id) && $auth->acl_get('u_attach') && !$locked) ? $user->lang['RULES_ATTACH_CAN'] : $user->lang['RULES_ATTACH_CANNOT']

- if ($poster_id == ANONYMOUS && $row['post_username'])

- $poster = $row['post_username'];

- $poster_rank = $user->lang['GUEST'];

- 'U_VIEW_PROFILE' => "{$phpbb_root_path}memberlist.$phpEx$SID&amp;mode=viewprofile&amp;u=" . $post_info['user_id'],

- if (strlen($text[$i]) < $config['fulltext_mysql_min_word_len'] || strlen($text[$i]) > $this->config['fulltext_mysql_max_word_len'])

- if (@file_exists('/proc/loadavg') && @is_readable('/proc/loadavg'))

- if ($load = @file_get_contents('/proc/loadavg'))

- $this->load = floatval(array_slice(explode(' ', $load), 0, 1));

- if ($config['limit_load'] && $this->load > floatval($config['limit_load']))

- trigger_error('BOARD_UNAVAILABLE');

- if (strpos($this->page['page_query'], 'mode=reg_details') !== false && $this->page['page_name'] == "ucp.$phpEx")

- unset($friends);

- unset($foes);

- $perms += $user_ary;

- switch (SQL_LAYER)

- case 'mysql':

- $sql = 'INSERT INTO ' . ZEBRA_TABLE . " (user_id, zebra_id, $sql_mode)

- VALUES " . implode(', ', preg_replace('#^([0-9]+)$#', '(' . $user->data['user_id'] . ", \\1, 1)", $user_id_ary));

- $db->sql_query($sql);

- break;

- case 'mysql4':

- case 'mysqli':

- case 'mssql':

- case 'mssql_odbc':

- case 'sqlite':

- $sql = 'INSERT INTO ' . ZEBRA_TABLE . " (user_id, zebra_id, $sql_mode)

- VALUES " . implode(' UNION ALL ', preg_replace('#^([0-9]+)$#', '(' . $user->data['user_id'] . ", \\1, 1)", $user_id_ary));

- $db->sql_query($sql);

- default:

- foreach ($user_id_ary as $zebra_id)

- {

- $sql = 'INSERT INTO ' . ZEBRA_TABLE . " (user_id, zebra_id, $sql_mode)

- VALUES (" . $user->data['user_id'] . ", $zebra_id, 1)";

- $db->sql_query($sql);

- }