- * email : supportphpbb.com

-// drop table schema

-//

-$sql_array = array();

-

-$sql_array['drop_schema'][] = "DROP TABLE phpbb_auth_access";

-$sql_array['drop_schema'][] = "DROP TABLE phpbb_banlist";

-$sql_array['drop_schema'][] = "DROP TABLE phpbb_categories";

-$sql_array['drop_schema'][] = "DROP TABLE phpbb_config";

-$sql_array['drop_schema'][] = "DROP TABLE phpbb_disallow";

-$sql_array['drop_schema'][] = "DROP TABLE phpbb_forum_prune";

-$sql_array['drop_schema'][] = "DROP TABLE phpbb_forums";

-$sql_array['drop_schema'][] = "DROP TABLE phpbb_groups";

-$sql_array['drop_schema'][] = "DROP TABLE phpbb_posts";

-$sql_array['drop_schema'][] = "DROP TABLE phpbb_posts_text";

-$sql_array['drop_schema'][] = "DROP TABLE phpbb_privmsgs";

-$sql_array['drop_schema'][] = "DROP TABLE phpbb_privmsgs_text";

-$sql_array['drop_schema'][] = "DROP TABLE phpbb_ranks";

-$sql_array['drop_schema'][] = "DROP TABLE phpbb_search_results";

-$sql_array['drop_schema'][] = "DROP TABLE phpbb_search_wordlist";

-$sql_array['drop_schema'][] = "DROP TABLE phpbb_search_wordmatch";

-$sql_array['drop_schema'][] = "DROP TABLE phpbb_sessions";

-$sql_array['drop_schema'][] = "DROP TABLE phpbb_smilies";

-$sql_array['drop_schema'][] = "DROP TABLE phpbb_themes";

-$sql_array['drop_schema'][] = "DROP TABLE phpbb_themes_name";

-$sql_array['drop_schema'][] = "DROP TABLE phpbb_topics";

-$sql_array['drop_schema'][] = "DROP TABLE phpbb_topics_watch";

-$sql_array['drop_schema'][] = "DROP TABLE phpbb_user_group";

-$sql_array['drop_schema'][] = "DROP TABLE phpbb_users";

-$sql_array['drop_schema'][] = "DROP TABLE phpbb_vote_desc";

-$sql_array['drop_schema'][] = "DROP TABLE phpbb_vote_results";

-$sql_array['drop_schema'][] = "DROP TABLE phpbb_vote_voters";

-$sql_array['drop_schema'][] = "DROP TABLE phpbb_words";

-

-//

-if( isset($HTTP_POST_VARS['install_step']) || isset($HTTP_GET_VARS['install_step']) )

-//

-//

-if ( @file_exists('../config.'.$phpEx) )

-{

- include('../config.'.$phpEx);

-}

-

-//

-//

- //

- // Ok for the time being I'm commenting this out whilst I'm working on

- // better integration of the install with upgrade as per Bart's request

- // JLH

- //

- // require('upgrade.'.$phpEx);

-//

- header("Content-Type: text/x-delimtext; name=\"config.$phpEx\"");

- header("Content-disposition: attachment; filename=config.$phpEx");

-

-

- if( $upgrade == 1 )

- if( $upgrade == 1 )

- $template->assign_block_vars("switch_common_install", array());

-

- $template->assign_vars(array(

- "L_INSTRUCTION_TEXT" => $lang['NoFTP_config'],

- "L_SUBMIT" => $lang['Download_config'],

-

- "S_HIDDEN_FIELDS" => $s_hidden_fields,

- "S_FORM_ACTION" => "install.$phpEx")

- );

- $template->pparse('body');

- $res = ftp_put($conn_id, 'config.'.$phpEx, $tmpfname, FTP_ASCII);

- // Ok we are basically done with the install process let's go on

- // and let the user configure their board now.

- //

- // We are going to do this by calling the admin_board.php from the

- // normal board admin section.

- $template->assign_block_vars("switch_common_install", array());

-

- $template->assign_vars(array(

- "L_INSTRUCTION_TEXT" => $lang['Inst_Step_2'],

- "L_SUBMIT" => $lang['Finish_Install'],

-

- "S_HIDDEN_FIELDS" => $s_hidden_fields,

- "S_FORM_ACTION" => "login.$phpEx")

- );

-

- $template->pparse('body');

- page_header($instruction_text);

- <tr>

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

- </tr>

- <tr>

- <td class="row1" align="right" width="40%"><span class="gen"><?php echo $lang['Default_lang']; ?>: </span></td>

- <td class="row2"><?php echo $lang_options; ?></select></td>

- </tr>

- <tr>

- <td class="row1" align="right"><span class="gen"><?php echo $lang['dbms']; ?>: </span></td>

- <td class="row2"><select name="dbms" onchange="if(document.install_form.upgrade.options[upgrade.selectedIndex].value == 1) { document.install_form.dbms.selectedIndex=0}"><?php echo $dbms_options; ?></select></td>

- </tr>

- <tr>

- <td class="row1" align="right"><span class="gen"><?php echo $lang['Install_Method']; ?>: </span></td>

- <td class="row2"><select name="upgrade" onchange="if( this.options[this.selectedIndex].value == 1 ) { document.install_form.dbms.selectedIndex=0; }"><?php echo $upgrade_option; ?></select></td>

- </tr>

- <tr>

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

- </tr>

- <tr>

- <td class="row1" align="right"><span class="gen"><?php echo $lang['DB_Host']; ?>: </span></td>

- <td class="row2"><input type="text" name="dbhost" value="<?php echo ( $dbhost != '' ) ? $dbhost : ''; ?>" /></td>

- </tr>

- <tr>

- <td class="row1" align="right"><span class="gen"><?php echo $lang['DB_Name']; ?>: </span></td>

- <td class="row2"><input type="text" name="dbname" value="<?php echo ( $dbname != '' ) ? $dbname : ''; ?>" /></td>

- </tr>

- <tr>

- <td class="row1" align="right"><span class="gen"><?php echo $lang['DB_Username']; ?>: </span></td>

- <td class="row2"><input type="text" name="dbuser" value="<?php echo ( $dbuser != '' ) ? $dbuser : ''; ?>" /></td>

- </tr>

- <tr>

- <td class="row1" align="right"><span class="gen"><?php echo $lang['DB_Password']; ?>: </span></td>

- <td class="row2"><input type="password" name="dbpasswd" value="<?php echo ( $dbpasswd != '' ) ? $dbpasswd : ''; ?>" /></td>

- </tr>

- <tr>

- <td class="row1" align="right"><span class="gen"><?php echo $lang['Table_Prefix']; ?>: </span></td>

- <td class="row2"><input type="text" name="prefix" value="<?php echo ( !empty($table_prefix) ) ? $table_prefix : 'phpbb_'; ?>" /></td>

- </tr>

- <tr>

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

- </tr>

- <tr>

- <td class="row1" align="right"><span class="gen"><?php echo $lang['Server_name']; ?>: </span></td>

- <td class="row2"><input type="text" name="server_name" value="<?php echo $server_name; ?>" /></td>

- </tr>

- <tr>

- <td class="row1" align="right"><span class="gen"><?php echo $lang['Server_port']; ?>: </span></td>

- <td class="row2"><input type="text" name="server_port" value="<?php echo $server_port; ?>" /></td>

- </tr>

- <tr>

- <td class="row1" align="right"><span class="gen"><?php echo $lang['Script_path']; ?>: </span></td>

- <td class="row2"><input type="text" name="script_path" value="<?php echo $script_path; ?>" /></td>

- </tr>

- <tr>

- <td class="row1" align="right"><span class="gen"><?php echo $lang['Admin_Username']; ?>: </span></td>

- <td class="row2"><input type="text" name="admin_name" value="<?php echo ( $admin_name != '' ) ? $admin_name : ''; ?>" /></td>

- </tr>

- <tr>

- <td class="row1" align="right"><span class="gen"><?php echo $lang['Admin_email']; ?>: </span></td>

- <td class="row2"><input type="text" name="board_email" value="<?php echo ( $admin_email != '' ) ? $admin_email : ''; ?>" /></td>

- </tr>

- <tr>

- <td class="row1" align="right"><span class="gen"><?php echo $lang['Admin_Password']; ?>: </span></td>

- <td class="row2"><input type="password" name="admin_pass1" value="<?php echo ( $admin_pass1 != '' ) ? $admin_pass1 : ''; ?>" /></td>

- </tr>

- <tr>

- <td class="row1" align="right"><span class="gen"><?php echo $lang['Admin_Password_confirm']; ?>: </span></td>

- <td class="row2"><input type="password" name="admin_pass2" value="<?php echo ( $admin_pass2 != '' ) ? $admin_pass2 : ''; ?>" /></td>

- </tr>

- page_footer($lang['Start_Install'], $s_hidden_fields);

- if( $reinstall )

- {

- $sql_query = preg_replace('/phpbb_/', $table_prefix, $sql_array['drop_schema']);

- $sql_count = count($sql_query);

-

- for($i = 0; $i < $sql_count; $i++)

- {

- $result = $db->sql_query($sql_query[$i]);

- if( !$result )

- {

- $error = $db->sql_error();

-

- $template->assign_block_vars("switch_error_install", array());

-

- $template->assign_vars(array(

- "L_ERROR_TITLE" => $lang['Installer_Error'],

- "L_ERROR" => $lang['Install_db_error'] . '<br /><br />' . $error)

- );

-

- $template->pparse('body');

-

- exit;

- }

- }

-

- $admin_name = $userdata['username'];

- $admin_pass1 = $userdata['user_password'];

- $language = $userdata['user_lang'];

- }

- else if( isset($dbms) )

- switch( $dbms )

- $template->assign_block_vars("switch_error_install", array());

- $template->pparse('body');

- include($phpbb_root_path.'includes/db.'.$phpEx);

- $dbms_schema = 'db/schemas/' . $available_dbms[$dbms]['SCHEMA'] . '_schema.sql';

- $dbms_basic = 'db/schemas/' . $available_dbms[$dbms]['SCHEMA'] . '_basic.sql';

- if( $install_step == 1 || $reinstall )

- if( $upgrade != 1 )

- if( $dbms != 'msaccess' )

- $sql_query = preg_replace('/phpbb_/', $table_prefix, $sql_query);

- $result = $db->sql_query($sql_query[$i]);

- if( !$result )

- {

- $error = $db->sql_error();

-

- $template->assign_block_vars("switch_error_install", array());

-

- $template->assign_vars(array(

- "L_ERROR_TITLE" => $lang['Installer_Error'],

- "L_ERROR" => $lang['Install_db_error'] . '<br />' . $error['message'])

- );

-

- $template->pparse('body');

-

- exit;

- }

- $result = $db->sql_query($sql_query[$i]);

- if( !$result )

- {

- $error = $db->sql_error();

-

- $template->assign_block_vars("switch_error_install", array());

-

- $template->assign_vars(array(

- "L_ERROR_TITLE" => $lang['Installer_Error'],

- "L_ERROR" => $lang['Install_db_error'] . "<br />" . $error["message"])

- );

-

- $template->pparse('body');

-

- exit;

- }

- $error = "";

- $admin_pass_md5 = ( $confirm && $userdata['user_level'] == ADMIN ) ? $admin_pass1 : md5($admin_pass1);

-

-

- if( preg_match("/^mysql/", $dbms) )

- if( $error != "" )

- }

- if( !$reinstall && !$upgrade_now )

- $template->assign_block_vars("switch_common_install", array());

- $fp = @fopen('config.'.$phpEx, 'w');

- if( !$fp )

- if( extension_loaded('ftp') && !defined('NO_FTP') )

- if( $upgrade == 1 )

- $template->assign_block_vars("switch_common_install", array());

- if( !$reinstall )

- $s_hidden_fields = "";

- $template->assign_vars(array(

- "L_INSTRUCTION_TEXT" => $lang['Inst_Step_2'],

- "L_SUBMIT" => $lang['Finish_Install'],

-

- "S_HIDDEN_FIELDS" => $s_hidden_fields,

- "S_FORM_ACTION" => ( $reinstall ) ? append_sid("login.$phpEx") : "login.$phpEx")

- );

-

- $template->pparse('body');

-function page_header($l_instructions)

- <td><br clear="all" />

-<form action="install.<?php echo $phpEx; ?>" name="install_form" method="post"><table class="bg" width="100%" cellspacing="1" cellpadding="2" border="0">

-INSERT INTO phpbb_config (config_name, config_value) VALUES ('posts_per_page','15');

-INSERT INTO phpbb_config (config_name, config_value) VALUES ('topics_per_page','50');

-INSERT INTO phpbb_config (config_name, config_value) VALUES ('max_inbox_privmsgs','50');

-INSERT INTO phpbb_config (config_name, config_value) VALUES ('avatar_max_width','80');

-INSERT INTO phpbb_config (config_name, config_value) VALUES ('avatar_max_height','80');

-INSERT INTO phpbb_config (config_name, config_value) VALUES ('server_name', 'www.myserver.tld');

-INSERT INTO phpbb_config (config_name, config_value) VALUES ('server_port', '80');

-INSERT INTO phpbb_config (config_name, config_value) VALUES ('script_path', '/phpBB2/');

-INSERT INTO phpbb_config (config_name, config_value) VALUES ('newest_username', 'Admin');

-INSERT INTO phpbb_config (config_name, config_value) VALUES ('limit_load', '1.0');

-INSERT INTO phpbb_styles (style_id, template_id, theme_id, imageset_id, style_name, style_default) VALUES (1, 1, 1, 1, 'subSilver', 1);

-INSERT INTO phpbb_styles_imageset (imageset_id, imageset_name, imageset_path, post_new, post_locked, post_pm, reply_new, reply_pm, reply_locked, icon_quote, icon_edit, icon_search, icon_profile, icon_pm, icon_email, icon_www, icon_icq, icon_aim, icon_yim, icon_msnm, icon_no_edit, icon_no_email, icon_no_www, icon_no_icq, icon_no_aim, icon_no_yim, icon_no_msnm, icon_delete, icon_ip, goto_post, goto_post_new, goto_post_latest, goto_post_newest, forum, forum_new, forum_locked, folder, folder_new, folder_hot, folder_hot_new, folder_locked, folder_locked_new, folder_sticky, folder_sticky_new, folder_announce, folder_announce_new, topic_watch, topic_unwatch, poll_left, poll_center, poll_right, rating) VALUES (1, 'subSilver &copy; phpBB Group', 'subSilver', '"imagesets/subSilver/{LANG}/post.gif" width="82" height="25" border="0"', '"imagesets/subSilver/{LANG}/reply-locked.gif" width="82" height="25" border="0"', '"imagesets/subSilver/{LANG}/post.gif" width="82" height="25" border="0"', '"imagesets/subSilver/{LANG}/reply.gif" width="88" height="27" border="0"', '"imagesets/subSilver/{LANG}/reply.gif" width="88" height="27" border="0"', '"imagesets/subSilver/{LANG}/reply-locked.gif" width="82" height="25" border="0"', '"imagesets/subSilver/{LANG}/icon_quote.gif" width="59" height="18" border="0"', '"imagesets/subSilver/{LANG}/icon_edit.gif" width="59" height="18" border="0"', '"imagesets/subSilver/{LANG}/icon_search.gif" width="59" height="18" border="0"', '"imagesets/subSilver/{LANG}/icon_profile.gif" width="59" height="18" border="0"', '"imagesets/subSilver/{LANG}/icon_pm.gif" width="59" height="18" border="0"', '"imagesets/subSilver/{LANG}/icon_email.gif" width="59" height="18" border="0"', '"imagesets/subSilver/{LANG}/icon_www.gif" width="59" height="18" border="0"', '"imagesets/subSilver/{LANG}/icon_icq_add.gif" width="59" height="18" border="0"', '"imagesets/subSilver/{LANG}/icon_aim.gif" width="59" height="18" border="0"', '"imagesets/subSilver/{LANG}/icon_yim.gif" width="59" height="18" border="0"', '"imagesets/subSilver/{LANG}/icon_msnm.gif" width="59" height="18" border="0"', '', '', '', '', '', '', '', '"imagesets/subSilver/icon_delete.gif" width="16" height="18" border="0"', '"imagesets/subSilver/{LANG}/icon_ip.gif" width="16" 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/folder.gif" width="19" height="18" border="0"', '"imagesets/subSilver/folder_new.gif" width="19" height="18" border="0"', '"imagesets/subSilver/folder_hot.gif" width="19" height="18" border="0"', '"imagesets/subSilver/folder_new_hot.gif" width="19" height="18" border="0"', '"imagesets/subSilver/folder_lock.gif" width="19" height="18" border="0"', '"imagesets/subSilver/folder_lock_new.gif" width="19" height="18" border="0"', '"imagesets/subSilver/folder_sticky.gif" width="19" height="18" border="0"', '"imagesets/subSilver/folder_sticky_new.gif" width="19" height="18" border="0"', '"imagesets/subSilver/folder_announce.gif" width="19" height="18" border="0"', '"imagesets/subSilver/folder_announce_new.gif" width="19" height="18" border="0"', '', '', '"imagesets/subSilver/voting_lcap.gif" width="4" height="12" border="0"', '"imagesets/subSilver/voting_rcap.gif" height="12" border="0"', '"imagesets/subSilver/voting_bar.gif" width="4" height="12" border="0"', '"imagesets/subSilver/ratings/{RATE}.gif" width="45" height="17" border="0"');

-INSERT INTO phpbb_styles_theme (theme_id, css_data, css_external) VALUES (1, 'th { background-image: url(templates/subSilver/images/cellpic3.gif) }\r\ntd.cat { background-image: url(templates/subSilver/images/cellpic1.gif) }\r\ntd.rowpic { background-image: url(templates/subSilver/images/cellpic2.jpg); background-repeat: repeat-y }\r\ntd.icqback { background-image: url(templates/subSilver/images/icon_icq_add.gif); background-repeat: no-repeat }\r\ntd.catHead,td.catSides,td.catLeft,td.catRight,td.catBottom { background-image: url(templates/subSilver/images/cellpic1.gif) }\r\nTH.thTop { background-image: url(templates/subSilver/images/cellpic3.gif) }', 'subSilver/subSilver.css');

-INSERT INTO phpbb_users (user_id, username, user_level, user_regdate, user_password, user_email, user_icq, user_website, user_occ, user_from, user_interests, user_sig, user_viewemail, user_style, user_aim, user_yim, user_msnm, user_posts, user_attachsig, user_allowsmile, user_allowhtml, user_allowbbcode, user_allow_pm, user_notify_pm, user_allow_viewonline, user_rank, user_avatar, user_lang, user_timezone, user_dateformat, user_actkey, user_newpasswd, user_notify, user_active) VALUES ( 0, 'Anonymous', 0, 0, '', '', '', '', '', '', '', '', 0, NULL, '', '', '', 0, 0, 1, 0, 1, 0, 1, 1, NULL, '', '', '', '', '', '', 0, 0);

-INSERT INTO phpbb_users (user_id, username, user_level, user_regdate, user_password, user_email, user_icq, user_website, user_occ, user_from, user_interests, user_sig, user_viewemail, user_style, user_aim, user_yim, user_msnm, user_posts, user_attachsig, user_allowsmile, user_allowhtml, user_allowbbcode, user_allow_pm, user_notify_pm, user_popup_pm, user_allow_viewonline, user_rank, user_avatar, user_lang, user_timezone, user_dateformat, user_actkey, user_newpasswd, user_notify, user_active) VALUES ( 1, 'Admin', 1, 0, '21232f297a57a5a743894a0e4a801fc3', 'admin@yourdomain.com', '', '', '', '', '', '', 1, 1, '', '', '', 1, 0, 1, 0, 1, 1, 1, 1, 1, 1, '', 'english', 0, 'd M Y h:i a', '', '', 0, 1);

-INSERT INTO phpbb_groups (group_id, group_name, group_type) VALUES (1, 'ADMINISTRATOR', 0);

-INSERT INTO phpbb_user_group (group_id, user_id, user_pending) VALUES (1, 1, 0);

-INSERT INTO phpbb_user_group (group_id, user_id, user_pending) VALUES (2, 1, 0);

-INSERT INTO phpbb_topics (topic_id, topic_title, topic_poster, topic_time, topic_views, topic_replies, forum_id, topic_status, topic_type, topic_vote, topic_first_post_id, topic_last_post_id) VALUES (1, 'Welcome to phpBB 2', 2, '972086460', 0, 0, 1, 0, 0, 0, 1, 1);

- user_id mediumint(8) unsigned NOT NULL default '0',

- auth_allow_deny tinyint(4) NOT NULL default '1')

- user_id mediumint(8) unsigned NOT NULL default '0',