nction properly. It is strongly recommended that you set $config[\'Database\'][\'force_sql_mode\'] to true in your includes/config.php file!'; $install_phrases['resetting_db'] = 'Resetting database...'; $install_phrases['succeeded'] = 'succeeded'; $install_phrases['script_reported_errors'] = 'The script reported errors in the installation of the tables. Only continue if you are sure that they are not serious.'; $install_phrases['errors_were'] = 'The errors were:'; $install_phrases['tables_setup'] = 'Tables set up successfully.'; $install_phrases['general_settings'] = 'General Settings'; $install_phrases['bbtitle'] = 'BB Title Title of board. Appears in the title of every page.'; $install_phrases['hometitle'] = 'Homepage Title Name of your homepage. Appears at the bottom of every page.'; $install_phrases['bburl'] = 'BB URL URL (with no final "/") of the BB. For example, http://www.example.com/forums'; $install_phrases['homeurl'] = 'Home URL URL of your home page. Appears at the bottom of every page.'; $install_phrases['webmasteremail'] = 'Webmaster email address Email address of the webmaster.'; $install_phrases['cookiepath'] = 'Cookie Path The path to which the cookie is saved. If you run more than one forum on the same domain, it will be necessary to set this to the individual directories of the forums. Otherwise, just leave it as / .

Suggested valid values for Cookie Path are available in the drop-down menu opposite. If you have a good reason to want a different setting, tick the checkbox and enter the desired value in the box provided.

Please note that your path should always end in a forward-slash; for example \'/forums/\', \'/vbulletin/\' etc.

Entering an invalid setting can leave you unable to login to your forum.
'; $install_phrases['cookiedomain'] = 'Cookie Domain This option sets the domain on which the cookie is active. The most common reason to change this setting is that you have two different urls to your forum, i.e. example.com and forums.example.com. To allow users to stay logged into the forum if they visit via either url, you would set this to .example.com (note the domain begins with a dot.

Suggested valid values for Cookie Path are available in the drop-down menu opposite. If you have a good reason to want a different setting, tick the checkbox and enter the desired value in the box provided.

You most likely want to leave this setting blank as entering an invalid setting can leave you unable to login to your forum.
'; $install_phrases['suggested_settings'] = 'Suggested Settings'; $install_phrases['custom_setting'] = 'Custom Setting'; $install_phrases['use_custom_setting'] = 'Use Custom Setting (Specify Below)'; $install_phrases['blank'] = '(blank)'; $install_phrases['fill_in_for_admin_account'] = 'Please fill in the form below to setup an administrator account'; $install_phrases['username'] = 'User Name'; $install_phrases['password'] = 'Password'; $install_phrases['confirm_password'] = 'Confirm Password'; $install_phrases['email_address'] = 'Email Address'; $install_phrases['complete_all_data'] = 'You failed to enter all data.

Please click the \'Next Step\' button to go back and enter the details.'; $install_phrases['password_not_match'] = 'The \'Password\' and \'Confirm Password\' fields do not match!

Please click the \'Next Step\' button to go back and correct this.'; $install_phrases['admin_added'] = 'Administrator Added'; $install_phrases['install_complete'] = '

You have now successfully installed vBulletin 3.

YOU MUST DELETE THE FOLLOWING FILES BEFORE CONTINUING:
install/install.php


When you have done this, You may now proceed to your control panel.
The control panel can be found here'; $install_phrases['alter_table_type_x'] = 'Changing ' . TABLE_PREFIX . '%1$s to a %2$s type'; $install_phrases['default_calendar'] = 'Default Calendar'; $install_phrases['category_title'] = 'Main Category'; $install_phrases['category_desc'] = 'Main Category Description'; $install_phrases['forum_title'] = 'Main Forum'; $install_phrases['forum_desc'] = 'Main Forum Description'; $install_phrases['posticon_1'] = 'Post'; $install_phrases['posticon_2'] = 'Arrow'; $install_phrases['posticon_3'] = 'Lightbulb'; $install_phrases['posticon_4'] = 'Exclamation'; $install_phrases['posticon_5'] = 'Question'; $install_phrases['posticon_6'] = 'Cool'; $install_phrases['posticon_7'] = 'Smile'; $install_phrases['posticon_8'] = 'Angry'; $install_phrases['posticon_9'] = 'Unhappy'; $install_phrases['posticon_10'] = 'Talking'; $install_phrases['posticon_11'] = 'Red face'; $install_phrases['posticon_12'] = 'Wink'; $install_phrases['posticon_13'] = 'Thumbs down'; $install_phrases['posticon_14'] = 'Thumbs up'; $install_phrases['generic_avatars'] = 'Generic Avatars'; $install_phrases['generic_smilies'] = 'Generic Smilies'; $install_phrases['generic_icons'] = 'Generic Icons'; // should be the values that vbulletin-language.xml contains $install_phrases['master_language_title'] = 'English (US)'; $install_phrases['master_language_langcode'] = 'en'; $install_phrases['master_language_charset'] = 'ISO-8859-1'; $install_phrases['master_language_decimalsep'] = '.'; $install_phrases['master_language_thousandsep'] = ','; $install_phrases['default_style'] = 'Default Style'; $install_phrases['smilie_smile'] = 'Smile'; $install_phrases['smilie_embarrass'] = 'Embarrassment'; $install_phrases['smilie_grin'] = 'Big Grin'; $install_phrases['smilie_wink'] = 'Wink'; $install_phrases['smilie_tongue'] = 'Stick Out Tongue'; $install_phrases['smilie_cool'] = 'Cool'; $install_phrases['smilie_roll'] = 'Roll Eyes (Sarcastic)'; $install_phrases['smilie_mad'] = 'Mad'; $install_phrases['smilie_eek'] = 'EEK!'; $install_phrases['smilie_confused'] = 'Confused'; $install_phrases['smilie_frown'] = 'Frown'; $install_phrases['socialgroups_uncategorized'] = 'Uncategorized'; $install_phrases['socialgroups_uncategorized_description'] = 'Uncategorized Social Groups'; $install_phrases['usergroup_guest_title'] = 'Unregistered / Not Logged In'; $install_phrases['usergroup_guest_usertitle'] = 'Guest'; $install_phrases['usergroup_registered_title'] = 'Registered Users'; $install_phrases['usergroup_activation_title'] = 'Users Awaiting Email Confirmation'; $install_phrases['usergroup_coppa_title'] = '(COPPA) Users Awaiting Moderation'; $install_phrases['usergroup_super_title'] = 'Super Moderators'; $install_phrases['usergroup_super_usertitle'] = 'Super Moderator'; $install_phrases['usergroup_admin_title'] = 'Administrators'; $install_phrases['usergroup_admin_usertitle'] = 'Administrator'; $install_phrases['usergroup_mod_title'] = 'Moderators'; $install_phrases['usergroup_mod_usertitle'] = 'Moderator'; $install_phrases['usergroup_banned_title'] = 'Banned Users'; $install_phrases['usergroup_banned_usertitle'] = 'Banned'; $install_phrases['usertitle_jnr'] = 'Junior Member'; $install_phrases['usertitle_mbr'] = 'Member'; $install_phrases['usertitle_snr'] = 'Senior Member'; /*======================================================================*\ || #################################################################### || # NulleD - FintMax || # CVS: $RCSfile$ - $Revision: 27822 $ || #################################################################### \*======================================================================*/ ?> fetch_config(); require_once(DIR . "/{$vbulletin->config['Misc']['admincpdir']}/global.php"); // ############################################################################# print_cp_header($vbphrase['vbulletin_table_prefix_rename_system']); // ############################################################################# if (empty($_REQUEST['do'])) { $_REQUEST['do'] = 'modify'; } // ############################################################################# if ($_POST['do'] == 'rename') { $vbulletin->input->clean_array_gpc('p', array( 'newprefix' => TYPE_STR, 'rename' => TYPE_ARRAY, )); if ($vbulletin->GPC['newprefix'] == TABLE_PREFIX) { print_cp_message(construct_phrase($vbphrase['new_prefix_same_as_old'], TABLE_PREFIX, $vbulletin->GPC['newprefix'])); } ?>

    query_write("SHOW TABLES"); while ($table = $db->fetch_array($tables, MYSQL_NUM)) { $valid["$table[0]"] = true; } unset($table); $db->free_result($tables); foreach(array_keys($vbulletin->GPC['rename']) as $table) { if (!isset($valid["$table"])) { echo '
  • ' . construct_phrase($vbphrase['table_x_does_not_exist'], $table) . "
  • \n"; flush(); } else { $name = fetch_renamed_table_name($table, TABLE_PREFIX, $vbulletin->GPC['newprefix']); echo '
  • ' . construct_phrase($vbphrase['renaming_x_to_y'], $name['old'], $name['new']) . "
  • \n"; flush(); $db->query_write("ALTER TABLE $name[old] RENAME $name[new]"); echo "$vbphrase[okey]\n"; } } ?>
GPC['newprefix'])); ?>
db->shutdownqueries = array(); $vbulletin->session = null; } // ############################################################################# if ($_POST['do'] == 'confirm') { $vbulletin->input->clean_array_gpc('p', array( 'newprefix' => TYPE_STR, 'rename' => TYPE_ARRAY, )); if (array_sum($vbulletin->GPC['rename']) == 0) { print_stop_message('sorry_no_tables_were_submitted_to_be_renamed'); } else { if ($vbulletin->GPC['newprefix'] == TABLE_PREFIX) { print_cp_message(construct_phrase($vbphrase['new_prefix_same_as_old'], TABLE_PREFIX, $vbulletin->GPC['newprefix'])); } $prefixlength = strlen(TABLE_PREFIX); $dorename = array(); $warn = array(); $dotables = ''; $warntables = ''; print_form_header('tableprefix', 'rename'); print_table_header(construct_phrase($vbphrase['confirm_prefix_change_x_to_y'], TABLE_PREFIX, $vbulletin->GPC['newprefix'])); construct_hidden_code('newprefix', $vbulletin->GPC['newprefix']); foreach($vbulletin->GPC['rename'] as $table => $yesno) { if ($yesno) { construct_hidden_code("rename[$table]", 1); $dorename[] = $table; $tablename = fetch_renamed_table_name($table, TABLE_PREFIX, $vbulletin->GPC['newprefix'], true); $dotables .= "$tablename[old]$tablename[new]"; if (substr($table, 0, $prefixlength) != TABLE_PREFIX) { $warn[] = $table; } } } if (!empty($warn)) { foreach($warn as $table) { $warntables .= "
  • $table
  • "; } print_description_row(construct_phrase($vbphrase['other_prefix_warning'], $warntables)); print_description_row('
    ', 0, 2, 'tfoot'); } else { $bgcounter++; } if (!empty($dorename)) { print_description_row("

    $vbphrase[you_have_chosen_to_rename_the_following_tables]:

    $dotables
    $vbphrase[original_table_name]$vbphrase[new_table_name]
    "); } print_description_row($vbphrase['prefix_change_confirm']); print_submit_row($vbphrase['rename_sql_tables'], 0, 2, $vbphrase['go_back']); } } // ############################################################################# if ($_REQUEST['do'] == 'choose') { print_form_header('tableprefix', 'confirm'); print_table_header($vbphrase['rename_sql_tables']); print_label_row($vbphrase['old_table_prefix'], '
    ' . TABLE_PREFIX . '
    '); print_input_row($vbphrase['new_table_prefix'], 'newprefix', TABLE_PREFIX); print_label_row($vbphrase['table_name'], ' ', 'tfoot'); print_description_row($vbphrase['list_of_tables_in_db_below']); $prefixlength = strlen(TABLE_PREFIX); $tables = $db->query_write("SHOW TABLES"); while($table = $db->fetch_array($tables, MYSQL_NUM)) { print_yes_no_row(construct_phrase($vbphrase['rename_table_x'], $table[0]), "rename[$table[0]]", iif(substr($table[0], 0, $prefixlength) == TABLE_PREFIX, 1, 0)); } print_submit_row($vbphrase['rename_tables']); } // ############################################################################# if ($_REQUEST['do'] == 'modify') { echo '

     

     

    '; print_form_header('tableprefix', 'choose'); print_table_header($vbphrase['vbulletin_table_prefix_rename_system']); print_description_row(construct_phrase($vbphrase['this_script_will_allow_you_to_rename_your_vb_tables'], TABLE_PREFIX)); print_submit_row($vbphrase['continue'], 0); } // ############################################################################# print_cp_footer(); // ############################################################################# function fetch_renamed_table_name($table, $oldprefix, $newprefix, $dobold = false) { static $prefixlength; if (!isset($prefixlength)) { $prefixlength = strlen($oldprefix); } $name = array('old' => $table); if (substr($table, 0, $prefixlength) == $oldprefix) { $table = substr($table, $prefixlength); if ($dobold) { $name['old'] = "$oldprefix$table"; } } $name['new'] = iif($dobold, "$newprefix", $newprefix) . $table; return $name; } /*======================================================================*\ || #################################################################### || # NulleD - FintMax || # CVS: $RCSfile$ - $Revision: 27952 $ || #################################################################### \*======================================================================*/ ?>