Search options (Page 1 of 2)

thanks, I know that was an amatuer question.

Well, thats just how it is when you have a successful foprums people want a piece of the pie, and when they get it they are most likely to abuse there power. So my advice is to only make mods out of people you know, or people who know something about you forum topic.

o yeah i can fix that.

Oh, ok man thats alot of stuff.

Here visit it and see the updates I made.

http://bluewinter.mybesthost.com

Yes, the forums are coming along great you, gotta tell me what i did wrong?

i know sorry.

Thank you so much man, i don't know how to rpay you.

oh ok oops, sorry

ok, lt me try it.

I can't get to it unless i go thourgh file manager.

Wait how did you upload it that fast?

Where do you see that?

here instead.'); // Make sure we are running at least PHP 4.1.0 if (intval(str_replace('.', '', phpversion())) < 410) exit('You are running PHP version '.phpversion().'. PunBB requires at least PHP 4.1.0 to run properly. You must upgrade your PHP installation before you can continue.'); // Disable error reporting for uninitialized variables error_reporting(E_ERROR | E_WARNING | E_PARSE); // Turn off PHP time limit @set_time_limit(0); if (!isset($_POST['form_sent'])) { ?> Instructions
Welcome to PunBB installation! You are about to install PunBB . Please make sure that the database that PunBB will be installed into is already created. If you are uncertain about what to enter in the fields below, consult your server administrator.
 

Configuration
Database type   The type of database this forum will be using.

  MySQL PostgreSQL 
Database server hostname   The address of the database server (example: localhost, db.myhost.com or 192.168.0.15). You can specify a custom port number if your database doesn't run on the default port (example: localhost:3580).

   
Database name   The name of the database that PunBB will be installed into.

   
Database username   The username with which you connect to the database.

   
Database password   The password with which you connect to the database.

   
Table prefix   If you like you can specify a table prefix. This way you can run multiple copies of PunBB in the same database (example: foo_).

   
Administrator username   The username of the forum administrator. You can later create more adminstrators and moderators. Usernames can be between 2 and 25 characters long.

   
Administrator password   Passwords can be between 4 and 16 characters long. Passwords are case sensitive.

   Re-enter password to confirm. 
Administrator e-mail   The e-mail address of the forum administrator.

   
Base URL   The URL (without trailing slash) of your PunBB forum (example: http://forum.myhost.com or http://myhost.com/~myuser). This must be correct or administrators and moderators will not be able to submit any forms.

   
Actions   
 

Go back.'); if (strlen($password1) < 4) exit('Passwords must be at least 4 characters long. Please go back and correct. Go back.'); if ($password1 != $password2) exit('Passwords do not match. Please go back and correct. Go back.'); if (!strcasecmp($username, 'Guest')) exit('The username guest is reserved. Please go back and correct. Go back.'); if (preg_match('/[0-9]{1,3}\.[0-9]{1,3}\.[0-9]{1,3}\.[0-9]{1,3}/', $username)) exit('Usernames may not be in the form of an IP address. Please go back and correct. Go back.'); if (preg_match('#\[b\]|\[/b\]|\[u\]|\[/u\]|\[i\]|\[/i\]|\[color|\[/color\]|\[quote\]|\[/quote\]|\[code\]|\[/code\]|\[img\]|\[/img\]|\[url|\[/url\]|\[email|\[/email\]#i', $username)) exit('Usernames may not contain any of the text formatting tags (BBCode) that the forum uses. Go back.'); if (!preg_match('/^[_a-z0-9-]+(\.[_a-z0-9-]+)*@[a-z0-9-]+(\.[a-z0-9-]+)*(\.[a-z]{2,4})$/', $email)) exit('The administrator e-mail address you entered is invalid. Please go back and correct. Go back.'); // Load the appropriate DB layer class switch ($db_type) { case 'mysql': require $pun_root.'include/dblayer/mysql.php'; break; case 'pgsql': require $pun_root.'include/dblayer/pgsql.php'; break; default: exit('\''.htmlspecialchars($db_type).'\' is not a valid database type. Go back.'); break; } // Create the database object (and connect/select db) $db = new DBLayer($db_host, $db_username, $db_password, $db_name, $db_prefix, false); // Detect PostgreSQL version (used later) if ($db_type == 'pgsql') { $result = $db->query('SELECT VERSION()') or error('Unable to fetch DB version.', __FILE__, __LINE__, $db->error()); $pgsql_version = $db->result($result, 0); $pgsql_version = floatval(substr($pgsql_version, 11, 3)); } // Create all tables switch ($db_type) { case 'mysql': $sql = 'CREATE TABLE '.$db_prefix."bans ( id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, username VARCHAR(200) DEFAULT NULL, ip VARCHAR(255) DEFAULT NULL, email VARCHAR(50) DEFAULT NULL, message VARCHAR(255) DEFAULT NULL, expire INT(10) UNSIGNED DEFAULT NULL, PRIMARY KEY (id) ) TYPE=MyISAM;"; break; case 'pgsql': // This is a good time to start a transaction $db->query('BEGIN') or exit('Unable to start transaction. Please check your settings and try again. Go back.'); $sql = 'CREATE TABLE '.$db_prefix."bans ( id SERIAL, username VARCHAR(200) DEFAULT NULL, ip VARCHAR(255) DEFAULT NULL, email VARCHAR(50) DEFAULT NULL, message VARCHAR(255) DEFAULT NULL, expire INT DEFAULT NULL, PRIMARY KEY (id) )"; break; } $db->query($sql) or exit('Unable to create table '.$db_prefix.'bans. Please check your settings and try again. Go back.'); switch ($db_type) { case 'mysql': $sql = 'CREATE TABLE '.$db_prefix."categories ( id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, cat_name VARCHAR(80) NOT NULL DEFAULT 'New Category', disp_position INT(10) NOT NULL DEFAULT '0', PRIMARY KEY (id) ) TYPE=MyISAM;"; break; case 'pgsql': $sql = 'CREATE TABLE '.$db_prefix."categories ( id SERIAL, cat_name VARCHAR(80) NOT NULL DEFAULT 'New Category', disp_position INT NOT NULL DEFAULT '0', PRIMARY KEY (id) )"; break; } $db->query($sql) or exit('Unable to create table '.$db_prefix.'categories. Please check your settings and try again. Go back.'); switch ($db_type) { case 'mysql': $sql = 'CREATE TABLE '.$db_prefix."censoring ( id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, search_for VARCHAR(60) NOT NULL DEFAULT '', replace_with VARCHAR(60) NOT NULL DEFAULT '', PRIMARY KEY (id) ) TYPE=MyISAM;"; break; case 'pgsql': $sql = 'CREATE TABLE '.$db_prefix."censoring ( id SERIAL, search_for VARCHAR(60) NOT NULL DEFAULT '', replace_with VARCHAR(60) NOT NULL DEFAULT '', PRIMARY KEY (id) )"; break; } $db->query($sql) or exit('Unable to create table '.$db_prefix.'censoring. Please check your settings and try again. Go back.'); switch ($db_type) { case 'mysql': $sql = 'CREATE TABLE '.$db_prefix."config ( conf_name VARCHAR(255) NOT NULL, conf_value TEXT DEFAULT NULL, PRIMARY KEY (conf_name) ) TYPE=MyISAM;"; break; case 'pgsql': $sql = 'CREATE TABLE '.$db_prefix."config ( conf_name VARCHAR(255) NOT NULL, conf_value TEXT DEFAULT NULL, PRIMARY KEY (conf_name) )"; break; } $db->query($sql) or exit('Unable to create table '.$db_prefix.'online. Please check your settings and try again. Go back.'); switch ($db_type) { case 'mysql': $sql = 'CREATE TABLE '.$db_prefix."forums ( id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, forum_name VARCHAR(80) NOT NULL DEFAULT 'New forum', forum_desc TEXT DEFAULT NULL, moderators TEXT DEFAULT NULL, num_topics MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0', num_posts MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0', last_post INT(10) UNSIGNED DEFAULT NULL, last_post_id INT(10) UNSIGNED DEFAULT NULL, last_poster VARCHAR(200) DEFAULT NULL, closed TINYINT(1) NOT NULL DEFAULT '0', admmod_only TINYINT(1) NOT NULL DEFAULT '0', disp_position INT(10) NOT NULL DEFAULT '0', cat_id INT(10) UNSIGNED NOT NULL DEFAULT '0', PRIMARY KEY (id) ) TYPE=MyISAM;"; break; case 'pgsql': $sql = 'CREATE TABLE '.$db_prefix."forums ( id SERIAL, forum_name VARCHAR(80) NOT NULL DEFAULT 'New forum', forum_desc TEXT DEFAULT NULL, moderators TEXT DEFAULT NULL, num_topics INT NOT NULL DEFAULT '0', num_posts INT NOT NULL DEFAULT '0', last_post INT DEFAULT NULL, last_post_id INT DEFAULT NULL, last_poster VARCHAR(200) DEFAULT NULL, closed SMALLINT NOT NULL DEFAULT '0', admmod_only SMALLINT NOT NULL DEFAULT '0', disp_position INT NOT NULL DEFAULT '0', cat_id INT NOT NULL DEFAULT '0', PRIMARY KEY (id) )"; break; } $db->query($sql) or exit('Unable to create table '.$db_prefix.'forums. Please check your settings and try again. Go back.'); switch ($db_type) { case 'mysql': $sql = 'CREATE TABLE '.$db_prefix."online ( user_id INT(10) UNSIGNED NOT NULL DEFAULT '0', ident VARCHAR(200) NOT NULL DEFAULT '', logged INT(10) UNSIGNED NOT NULL DEFAULT '0' ) TYPE=HEAP;"; break; case 'pgsql': $sql = 'CREATE TABLE '.$db_prefix."online ( user_id INT NOT NULL DEFAULT '0', ident VARCHAR(200) NOT NULL DEFAULT '', logged INT NOT NULL DEFAULT '0' )"; break; } $db->query($sql) or exit('Unable to create table '.$db_prefix.'online. Please check your settings and try again. Go back.'); switch ($db_type) { case 'mysql': $sql = 'CREATE TABLE '.$db_prefix."posts ( id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, poster VARCHAR(200) NOT NULL DEFAULT '', poster_id INT(10) UNSIGNED NOT NULL DEFAULT '1', poster_ip VARCHAR(15) DEFAULT NULL, poster_email VARCHAR(50) DEFAULT NULL, message TEXT NOT NULL DEFAULT '', smilies TINYINT(1) NOT NULL DEFAULT '1', posted INT(10) UNSIGNED NOT NULL DEFAULT '0', edited INT(10) UNSIGNED DEFAULT NULL, edited_by VARCHAR(200) DEFAULT NULL, topic_id INT(10) UNSIGNED NOT NULL DEFAULT '0', PRIMARY KEY (id) ) TYPE=MyISAM;"; break; case 'pgsql': $sql = 'CREATE TABLE '.$db_prefix."posts ( id SERIAL, poster VARCHAR(200) NOT NULL DEFAULT '', poster_id INT NOT NULL DEFAULT '1', poster_ip VARCHAR(15) DEFAULT NULL, poster_email VARCHAR(50) DEFAULT NULL, message TEXT NOT NULL DEFAULT '', smilies SMALLINT NOT NULL DEFAULT '1', posted INT NOT NULL DEFAULT '0', edited INT DEFAULT NULL, edited_by VARCHAR(200) DEFAULT NULL, topic_id INT NOT NULL DEFAULT '0', PRIMARY KEY (id) )"; break; } $db->query($sql) or exit('Unable to create table '.$db_prefix.'posts. Please check your settings and try again. Go back.'); switch ($db_type) { case 'mysql': $sql = 'CREATE TABLE '.$db_prefix."ranks ( id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, rank VARCHAR(50) NOT NULL DEFAULT '', min_posts MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0', PRIMARY KEY (id) ) TYPE=MyISAM;"; break; case 'pgsql': $sql = 'CREATE TABLE '.$db_prefix."ranks ( id SERIAL, rank VARCHAR(50) NOT NULL DEFAULT '', min_posts INT NOT NULL DEFAULT '0', PRIMARY KEY (id) )"; break; } $db->query($sql) or exit('Unable to create table '.$db_prefix.'titles. Please check your settings and try again. Go back.'); switch ($db_type) { case 'mysql': $sql = 'CREATE TABLE '.$db_prefix."reports ( id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, post_id int(10) UNSIGNED NOT NULL DEFAULT '0', topic_id int(10) UNSIGNED NOT NULL DEFAULT '0', forum_id int(10) UNSIGNED NOT NULL DEFAULT '0', reported_by int(10) UNSIGNED NOT NULL DEFAULT '0', created int(10) UNSIGNED NOT NULL DEFAULT '0', message text NOT NULL DEFAULT '', zapped int(10) UNSIGNED DEFAULT NULL, zapped_by int(10) UNSIGNED DEFAULT NULL, PRIMARY KEY (id) ) TYPE=MyISAM;"; break; case 'pgsql': $sql = 'CREATE TABLE '.$db_prefix."reports ( id SERIAL, post_id INT NOT NULL DEFAULT '0', topic_id INT NOT NULL DEFAULT '0', forum_id INT NOT NULL DEFAULT '0', reported_by INT NOT NULL DEFAULT '0', created INT NOT NULL DEFAULT '0', message TEXT NOT NULL DEFAULT '', zapped INT DEFAULT NULL, zapped_by INT DEFAULT NULL, PRIMARY KEY (id) )"; break; } $db->query($sql) or exit('Unable to create table '.$db_prefix.'reports. Please check your settings and try again. Go back.'); switch ($db_type) { case 'mysql': $sql = 'CREATE TABLE '.$db_prefix."search_matches ( post_id INT(10) UNSIGNED NOT NULL DEFAULT '0', word_id INT(10) UNSIGNED NOT NULL DEFAULT '0', subject_match TINYINT(1) NOT NULL DEFAULT '0' ) TYPE=MyISAM;"; break; case 'pgsql': $sql = 'CREATE TABLE '.$db_prefix."search_matches ( post_id INT NOT NULL DEFAULT '0', word_id INT NOT NULL DEFAULT '0', subject_match SMALLINT NOT NULL DEFAULT '0' )"; break; } $db->query($sql) or exit('Unable to create table '.$db_prefix.'search_matches. Please check your settings and try again. Go back.'); switch ($db_type) { case 'mysql': $sql = 'CREATE TABLE '.$db_prefix."search_results ( id INT(10) UNSIGNED NOT NULL DEFAULT '0', ident VARCHAR(200) NOT NULL DEFAULT '', search_data TEXT NOT NULL, PRIMARY KEY (id) ) TYPE=MyISAM;"; break; case 'pgsql': $sql = 'CREATE TABLE '.$db_prefix."search_results ( id INT NOT NULL DEFAULT '0', ident VARCHAR(200) NOT NULL DEFAULT '', search_data TEXT NOT NULL, PRIMARY KEY (id) )"; break; } $db->query($sql) or exit('Unable to create table '.$db_prefix.'search_results. Please check your settings and try again. Go back.'); switch ($db_type) { case 'mysql': $sql = 'CREATE TABLE '.$db_prefix."search_words ( id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, word VARCHAR(20) BINARY NOT NULL DEFAULT '', PRIMARY KEY (word), KEY ".$db_prefix."search_words_id_idx (id) ) TYPE=MyISAM;"; break; case 'pgsql': $sql = 'CREATE TABLE '.$db_prefix."search_words ( id SERIAL, word VARCHAR(20) NOT NULL DEFAULT '', PRIMARY KEY (word) )"; break; } $db->query($sql) or exit('Unable to create table '.$db_prefix.'search_words. Please check your settings and try again. Go back.'); switch ($db_type) { case 'mysql': $sql = 'CREATE TABLE '.$db_prefix."subscriptions ( user_id INT(10) UNSIGNED NOT NULL DEFAULT '0', topic_id INT(10) UNSIGNED NOT NULL DEFAULT '0' ) TYPE=MyISAM;"; break; case 'pgsql': $sql = 'CREATE TABLE '.$db_prefix."subscriptions ( user_id INT NOT NULL DEFAULT '0', topic_id INT NOT NULL DEFAULT '0' )"; break; } $db->query($sql) or exit('Unable to create table '.$db_prefix.'subscriptions. Please check your settings and try again. Go back.'); switch ($db_type) { case 'mysql': $sql = 'CREATE TABLE '.$db_prefix."topics ( id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, poster VARCHAR(200) NOT NULL DEFAULT '', subject VARCHAR(255) NOT NULL DEFAULT '', posted INT(10) UNSIGNED NOT NULL DEFAULT '0', last_post INT(10) UNSIGNED NOT NULL DEFAULT '0', last_post_id INT(10) UNSIGNED NOT NULL DEFAULT '0', last_poster VARCHAR(200) DEFAULT NULL, num_views MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0', num_replies MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0', closed TINYINT(1) NOT NULL DEFAULT '0', sticky TINYINT(1) NOT NULL DEFAULT '0', moved_to INT(10) UNSIGNED DEFAULT NULL, forum_id INT(10) UNSIGNED NOT NULL DEFAULT '0', PRIMARY KEY (id) ) TYPE=MyISAM;"; break; case 'pgsql': $sql = 'CREATE TABLE '.$db_prefix."topics ( id SERIAL, poster VARCHAR(200) NOT NULL DEFAULT '', subject VARCHAR(255) NOT NULL DEFAULT '', posted INT NOT NULL DEFAULT '0', last_post INT NOT NULL DEFAULT '0', last_post_id INT NOT NULL DEFAULT '0', last_poster VARCHAR(200) DEFAULT NULL, num_views INT NOT NULL DEFAULT '0', num_replies INT NOT NULL DEFAULT '0', closed SMALLINT NOT NULL DEFAULT '0', sticky SMALLINT NOT NULL DEFAULT '0', moved_to INT DEFAULT NULL, forum_id INT NOT NULL DEFAULT '0', PRIMARY KEY (id) )"; break; } $db->query($sql) or exit('Unable to create table '.$db_prefix.'topics. Please check your settings and try again. Go back.'); switch ($db_type) { case 'mysql': $sql = 'CREATE TABLE '.$db_prefix."users ( id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, username VARCHAR(200) NOT NULL DEFAULT '', password VARCHAR(40) NOT NULL DEFAULT '', email VARCHAR(50) NOT NULL DEFAULT '', title VARCHAR(50) DEFAULT NULL, realname VARCHAR(40) DEFAULT NULL, url VARCHAR(100) DEFAULT NULL, icq VARCHAR(12) DEFAULT NULL, msn VARCHAR(50) DEFAULT NULL, aim VARCHAR(20) DEFAULT NULL, yahoo VARCHAR(20) DEFAULT NULL, location VARCHAR(30) DEFAULT NULL, use_avatar TINYINT(1) NOT NULL DEFAULT '0', signature TEXT DEFAULT NULL, disp_topics TINYINT(3) UNSIGNED DEFAULT NULL, disp_posts TINYINT(3) UNSIGNED DEFAULT NULL, email_setting TINYINT(1) NOT NULL DEFAULT '1', save_pass TINYINT(1) NOT NULL DEFAULT '1', notify_with_post TINYINT(1) NOT NULL DEFAULT '0', smilies TINYINT(1) NOT NULL DEFAULT '1', show_img TINYINT(1) NOT NULL DEFAULT '1', show_avatars TINYINT(1) NOT NULL DEFAULT '1', show_sig TINYINT(1) NOT NULL DEFAULT '1', link_to_new_win TINYINT(1) NOT NULL DEFAULT '1', timezone TINYINT(2) NOT NULL DEFAULT '0', style VARCHAR(25) NOT NULL DEFAULT 'Oxygen', num_posts INT(10) UNSIGNED NOT NULL DEFAULT '0', status TINYINT(1) NOT NULL DEFAULT '-1', last_post INT(10) UNSIGNED DEFAULT NULL, registered INT(10) UNSIGNED NOT NULL DEFAULT '0', last_visit INT(10) UNSIGNED NOT NULL DEFAULT '0', last_action INT(10) UNSIGNED NOT NULL DEFAULT '0', admin_note VARCHAR(30) DEFAULT NULL, activate_string VARCHAR(50) DEFAULT NULL, activate_key VARCHAR(8) DEFAULT NULL, PRIMARY KEY (id) ) TYPE=MyISAM;"; break; case 'pgsql': $sql = 'CREATE TABLE '.$db_prefix."users ( id SERIAL, username VARCHAR(200) NOT NULL DEFAULT '', password VARCHAR(40) NOT NULL DEFAULT '', email VARCHAR(50) NOT NULL DEFAULT '', title VARCHAR(50) DEFAULT NULL, realname VARCHAR(40) DEFAULT NULL, url VARCHAR(100) DEFAULT NULL, icq VARCHAR(12) DEFAULT NULL, msn VARCHAR(50) DEFAULT NULL, aim VARCHAR(20) DEFAULT NULL, yahoo VARCHAR(20) DEFAULT NULL, location VARCHAR(30) DEFAULT NULL, use_avatar SMALLINT NOT NULL DEFAULT '0', signature TEXT DEFAULT NULL, disp_topics SMALLINT DEFAULT NULL, disp_posts SMALLINT DEFAULT NULL, email_setting SMALLINT NOT NULL DEFAULT '1', save_pass SMALLINT NOT NULL DEFAULT '1', notify_with_post SMALLINT NOT NULL DEFAULT '0', smilies SMALLINT NOT NULL DEFAULT '1', show_img SMALLINT NOT NULL DEFAULT '1', show_avatars SMALLINT NOT NULL DEFAULT '1', show_sig SMALLINT NOT NULL DEFAULT '1', link_to_new_win SMALLINT NOT NULL DEFAULT '1', timezone SMALLINT NOT NULL DEFAULT '0', style VARCHAR(25) NOT NULL DEFAULT 'Oxygen', num_posts INT NOT NULL DEFAULT '0', status SMALLINT NOT NULL DEFAULT '-1', last_post INT DEFAULT NULL, registered INT NOT NULL DEFAULT '0', last_visit INT NOT NULL DEFAULT '0', last_action INT NOT NULL DEFAULT '0', admin_note VARCHAR(30) DEFAULT NULL, activate_string VARCHAR(50) DEFAULT NULL, activate_key VARCHAR(8) DEFAULT NULL, PRIMARY KEY (id) )"; break; } $db->query($sql) or exit('Unable to create table '.$db_prefix.'users. Please check your settings and try again. Go back.'); // Add a few indexes $queries[] = 'CREATE INDEX '.$db_prefix.'posts_topic_id_idx ON '.$db_prefix.'posts(topic_id)'; $queries[] = 'CREATE INDEX '.$db_prefix.'posts_poster_id_idx ON '.$db_prefix.'posts(poster_id)'; $queries[] = 'CREATE INDEX '.$db_prefix.'reports_zapped_idx ON '.$db_prefix.'reports(zapped)'; $queries[] = 'CREATE INDEX '.$db_prefix.'search_matches_word_id_idx ON '.$db_prefix.'search_matches(word_id)'; $queries[] = 'CREATE INDEX '.$db_prefix.'search_matches_post_id_idx ON '.$db_prefix.'search_matches(post_id)'; $queries[] = 'CREATE INDEX '.$db_prefix.'search_results_ident_idx ON '.$db_prefix.'search_results(ident)'; $queries[] = 'CREATE INDEX '.$db_prefix.'subscriptions_user_id_idx ON '.$db_prefix.'subscriptions(user_id)'; $queries[] = 'CREATE INDEX '.$db_prefix.'subscriptions_topic_id_idx ON '.$db_prefix.'subscriptions(topic_id)'; $queries[] = 'CREATE INDEX '.$db_prefix.'topics_forum_id_idx ON '.$db_prefix.'topics(forum_id)'; $queries[] = 'CREATE INDEX '.$db_prefix.'users_registered_idx ON '.$db_prefix.'users(registered)'; // Special cases switch ($db_type) { case 'mysql': $queries[] = 'CREATE INDEX '.$db_prefix.'users_username_idx ON '.$db_prefix.'users(username(3))'; break; case 'pgsql': $queries[] = 'CREATE INDEX '.$db_prefix.'users_username_idx ON '.$db_prefix.'users(username)'; $queries[] = 'CREATE INDEX '.$db_prefix.'search_words_id_idx ON '.$db_prefix.'search_words(id)'; // In PostgreSQL 7.3 and later, an index is not automatically created for serial columns if ($pgsql_version >= 7.3) { $queries[] = 'CREATE INDEX '.$db_prefix.'bans_id_idx ON '.$db_prefix.'bans(id)'; $queries[] = 'CREATE INDEX '.$db_prefix.'categories_id_idx ON '.$db_prefix.'categories(id)'; $queries[] = 'CREATE INDEX '.$db_prefix.'censoring_id_idx ON '.$db_prefix.'censoring(id)'; $queries[] = 'CREATE INDEX '.$db_prefix.'forums_id_idx ON '.$db_prefix.'forums(id)'; $queries[] = 'CREATE INDEX '.$db_prefix.'posts_id_idx ON '.$db_prefix.'posts(id)'; $queries[] = 'CREATE INDEX '.$db_prefix.'ranks_id_idx ON '.$db_prefix.'ranks(id)'; $queries[] = 'CREATE INDEX '.$db_prefix.'reports_id_idx ON '.$db_prefix.'reports(id)'; $queries[] = 'CREATE INDEX '.$db_prefix.'search_results_id_idx ON '.$db_prefix.'search_results(id)'; $queries[] = 'CREATE INDEX '.$db_prefix.'topics_id_idx ON '.$db_prefix.'topics(id)'; $queries[] = 'CREATE INDEX '.$db_prefix.'users_id_idx ON '.$db_prefix.'users(id)'; } break; } @reset($queries); while (list(, $sql) = @each($queries)) $db->query($sql) or exit('Unable to create indexes. Please check your configuration and try again. Go back.'); $now = time(); // Insert guest and first admin user $db->query('INSERT INTO '.$db_prefix."users (username, password, email) VALUES('Guest', 'Guest', 'Guest')", 1) or exit('Unable to insert into table '.$db_prefix.'users. Please check your configuration and try again. Go back.'); $db->query('INSERT INTO '.$db_prefix."users (username, password, email, num_posts, status, last_post, registered, last_visit, last_action) VALUES('".addslashes($username)."', '".pun_hash($password1)."', '$email', 1, 2, ".$now.", ".$now.", ".$now.", ".$now.')') or exit('Unable to insert into table '.$db_prefix.'users. Please check your configuration and try again. Go back.'); // Insert config data $config = array( 'o_cur_version' => "'$punbb_version'", 'o_board_title' => "'My PunBB forum'", 'o_board_desc' => "'Unfortunately no one can be told what PunBB is - you have to see it for yourself.'", 'o_server_timezone' => "'0'", 'o_time_format' => "'H:i:s'", 'o_date_format' => "'Y-m-d'", 'o_timeout_visit' => "'600'", 'o_timeout_online' => "'300'", 'o_redirect_delay' => "'1'", 'o_flood_interval' => "'30'", 'o_smilies' => "'1'", 'o_smilies_sig' => "'1'", 'o_make_links' => "'1'", 'o_show_post_count' => "'1'", 'o_default_style' => "'Oxygen'", 'o_topic_review' => "'15'", 'o_disp_topics_default' => "'30'", 'o_disp_posts_default' => "'25'", 'o_indent_num_spaces' => "'4'", 'o_quickpost' => "'1'", 'o_users_online' => "'1'", 'o_censoring' => "'0'", 'o_ranks' => "'1'", 'o_show_dot' => "'0'", 'o_quickjump' => "'1'", 'o_gzip' => "'0'", 'o_report_method' => "'0'", 'o_mailing_list' => "'$email'", 'o_avatars' => "'1'", 'o_avatars_dir' => "'img/avatars'", 'o_avatars_width' => "'60'", 'o_avatars_height' => "'60'", 'o_avatars_size' => "'10240'", 'o_search' => "'1'", 'o_search_all_forums' => "'1'", 'o_base_url' => "'$base_url'", 'o_admin_email' => "'$email'", 'o_webmaster_email' => "'$email'", 'o_subscriptions' => "'1'", 'o_smtp_host' => "NULL", 'o_smtp_user' => "NULL", 'o_smtp_pass' => "NULL", 'o_regs_allow' => "'1'", 'o_regs_verify' => "'0'", 'o_announcement' => "'0'", 'o_announcement_message' => "'Enter your announcement here.'", 'o_rules' => "'0'", 'o_rules_message' => "'Enter your rules here.'", 'o_maintenance' => "'0'", 'o_maintenance_message' => "'The forums are temporarily down for maintenance. Please try again in a few minutes.
\\n
\\n/Administrator'", 'p_guests_read' => "'1'", 'p_guests_post' => "'1'", 'p_guests_post_topic' => "'1'", 'p_guests_search' => "'1'", 'p_users_post' => "'1'", 'p_users_post_topic' => "'1'", 'p_users_edit_post' => "'1'", 'p_users_del_post' => "'1'", 'p_users_del_topic' => "'1'", 'p_users_set_title' => "'0'", 'p_message_bbcode' => "'1'", 'p_message_img_tag' => "'1'", 'p_message_all_caps' => "'0'", 'p_subject_all_caps' => "'0'", 'p_sig_all_caps' => "'0'", 'p_sig_bbcode' => "'1'", 'p_sig_img_tag' => "'0'", 'p_sig_length' => "'400'", 'p_sig_lines' => "'4'", 'p_allow_banned_email' => "'1'", 'p_allow_dupe_email' => "'0'" ); while (list($conf_name, $conf_value) = @each($config)) { $db->query('INSERT INTO '.$db_prefix."config (conf_name, conf_value) VALUES('$conf_name', $conf_value)") or exit('Unable to insert into table '.$db_prefix.'config. Please check your configuration and try again. Go back.'); } // Insert some other default data $db->query('INSERT INTO '.$db_prefix."categories (cat_name, disp_position) VALUES('Test category', 1)") or exit('Unable to insert into table '.$db_prefix.'categories. Please check your configuration and try again. Go back.'); $db->query('INSERT INTO '.$db_prefix."forums (forum_name, forum_desc, num_topics, num_posts, last_post, last_post_id, last_poster, disp_position, cat_id) VALUES('Test forum', 'This is just a test forum', 1, 1, ".$now.", 1, '".addslashes($username)."', 1, 1)") or exit('Unable to insert into table '.$db_prefix.'forums. Please check your configuration and try again. Go back.'); $db->query('INSERT INTO '.$db_prefix."topics (poster, subject, posted, last_post, last_post_id, last_poster, forum_id) VALUES('".addslashes($username)."', 'Test post', ".$now.", ".$now.", 1, '".addslashes($username)."', 1)") or exit('Unable to insert into table '.$db_prefix.'topics. Please check your configuration and try again. Go back.'); $db->query('INSERT INTO '.$db_prefix."posts (poster, poster_id, poster_ip, message, posted, topic_id) VALUES('".addslashes($username)."', 2, '127.0.0.1', 'If you are looking at this (which I guess you are), the install of PunBB appears to have worked! Now log in and head over to the administration control panel to configure your forum.', ".$now.', 1)') or exit('Unable to insert into table '.$db_prefix.'posts. Please check your configuration and try again. Go back.'); $db->query('INSERT INTO '.$db_prefix."ranks (rank, min_posts) VALUES('New member', 0)") or exit('Unable to insert into table '.$db_prefix.'titles. Please check your configuration and try again. Go back.'); $db->query('INSERT INTO '.$db_prefix."ranks (rank, min_posts) VALUES('Member', 10)", 2) // end transaction or exit('Unable to insert into table '.$db_prefix.'titles. Please check your configuration and try again. Go back.'); // Check if default avatar directory is writable if (!@is_writable('img/avatars/')) $avatar_alert = '

The default directory for avatars (img/avatars) is currently not writable! If you want users to be able to upload their own avatar images you must see to it that the avatar directory is writable by PHP. You can later choose to save avatar images in a different directory (see Admin/Options).'; /// Display config.php and give further instructions $config = '"; ?> Final instructions
To finalize the installation all you need to do is to copy and paste the text in the text box below into a file called config.php and then upload this file to the root directory of your PunBB installation. You can later edit config.php if you reconfigure your setup (i.e. install a new language pack or change the database password).