<?php
if (!defined('INSTALL_MODULES')) {
	die ("You can't access this file directly...");
}

if ((!is_god($admin)) && (!is_user($user)) && (!is_admin($admin))) { 
redirect_url("".$admin_file.".php?op=modules"); }



$result4 = $db2->sql_query("CREATE TABLE ".$prefix_install."_bbauth_access(
  `group_id` mediumint(8) NOT NULL default '0',
  `forum_id` smallint(5) unsigned NOT NULL default '0',
  `auth_view` tinyint(1) NOT NULL default '0',
  `auth_read` tinyint(1) NOT NULL default '0',
  `auth_post` tinyint(1) NOT NULL default '0',
  `auth_reply` tinyint(1) NOT NULL default '0',
  `auth_edit` tinyint(1) NOT NULL default '0',
  `auth_delete` tinyint(1) NOT NULL default '0',
  `auth_sticky` tinyint(1) NOT NULL default '0',
  `auth_announce` tinyint(1) NOT NULL default '0',
  `auth_vote` tinyint(1) NOT NULL default '0',
  `auth_pollcreate` tinyint(1) NOT NULL default '0',
  `auth_attachments` tinyint(1) NOT NULL default '0',
  `auth_mod` tinyint(1) NOT NULL default '0',
  KEY `group_id` (`group_id`),
  KEY `forum_id` (`forum_id`))");
################################################################################

$result1 = $db2->sql_query("CREATE TABLE ".$prefix_install."_bbbanlist(
  `ban_id` mediumint(8) unsigned NOT NULL auto_increment,
  `ban_userid` mediumint(8) NOT NULL default '0',
  `ban_ip` varchar(8) NOT NULL default '',
  `ban_email` varchar(255) default NULL,
  `ban_time` int(11) default NULL,
  `ban_expire_time` int(11) default NULL,
  `ban_by_userid` mediumint(8) default NULL,
  `ban_priv_reason` text,
  `ban_pub_reason_mode` tinyint(1) default NULL,
  `ban_pub_reason` text,
  PRIMARY KEY  (`ban_id`),
  KEY `ban_ip_user_id` (`ban_ip`,`ban_userid`))");
################################################################################

$result2 = $db2->sql_query("CREATE TABLE ".$prefix_install."_bbcategories(
  `cat_id` mediumint(8) unsigned NOT NULL auto_increment,
  `cat_title` varchar(100) default NULL,
  `cat_order` mediumint(8) unsigned NOT NULL default '0',
  PRIMARY KEY  (`cat_id`),
  KEY `cat_order` (`cat_order`))");
################################################################################

$result3 = $db2->sql_query("CREATE TABLE ".$prefix_install."_bbconfig(
  `config_name` varchar(255) NOT NULL default '',
  `config_value` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`config_name`))");

$db2->sql_query("INSERT INTO ".$prefix_install."_bbconfig VALUES ('config_id', '1')");
$db2->sql_query("INSERT INTO ".$prefix_install."_bbconfig VALUES ('board_disable', '0')");
$db2->sql_query("INSERT INTO ".$prefix_install."_bbconfig VALUES ('sitename', '$name_site')");
$db2->sql_query("INSERT INTO ".$prefix_install."_bbconfig VALUES ('site_desc', '')");
$db2->sql_query("INSERT INTO ".$prefix_install."_bbconfig VALUES ('cookie_name', 'phpbb2mysql')");
$db2->sql_query("INSERT INTO ".$prefix_install."_bbconfig VALUES ('cookie_path', '/')");
$db2->sql_query("INSERT INTO ".$prefix_install."_bbconfig VALUES ('cookie_domain', '$name_site')");
$db2->sql_query("INSERT INTO ".$prefix_install."_bbconfig VALUES ('cookie_secure', '0')");
$db2->sql_query("INSERT INTO ".$prefix_install."_bbconfig VALUES ('session_length', '3600')");
$db2->sql_query("INSERT INTO ".$prefix_install."_bbconfig VALUES ('allow_html', '1')");
$db2->sql_query("INSERT INTO ".$prefix_install."_bbconfig VALUES ('allow_html_tags', 'b,i,u,pre')");
$db2->sql_query("INSERT INTO ".$prefix_install."_bbconfig VALUES ('allow_bbcode', '1')");
$db2->sql_query("INSERT INTO ".$prefix_install."_bbconfig VALUES ('allow_smilies', '1')");
$db2->sql_query("INSERT INTO ".$prefix_install."_bbconfig VALUES ('allow_sig', '1')");
$db2->sql_query("INSERT INTO ".$prefix_install."_bbconfig VALUES ('allow_namechange', '0')");
$db2->sql_query("INSERT INTO ".$prefix_install."_bbconfig VALUES ('allow_theme_create', '0')");
$db2->sql_query("INSERT INTO ".$prefix_install."_bbconfig VALUES ('allow_avatar_local', '1')");
$db2->sql_query("INSERT INTO ".$prefix_install."_bbconfig VALUES ('allow_avatar_remote', '0')");
$db2->sql_query("INSERT INTO ".$prefix_install."_bbconfig VALUES ('allow_avatar_upload', '0')");
$db2->sql_query("INSERT INTO ".$prefix_install."_bbconfig VALUES ('override_user_style', '1')");
$db2->sql_query("INSERT INTO ".$prefix_install."_bbconfig VALUES ('posts_per_page', '15')");
$db2->sql_query("INSERT INTO ".$prefix_install."_bbconfig VALUES ('topics_per_page', '50')");
$db2->sql_query("INSERT INTO ".$prefix_install."_bbconfig VALUES ('hot_threshold', '25')");
$db2->sql_query("INSERT INTO ".$prefix_install."_bbconfig VALUES ('max_poll_options', '10')");
$db2->sql_query("INSERT INTO ".$prefix_install."_bbconfig VALUES ('max_sig_chars', '255')");
$db2->sql_query("INSERT INTO ".$prefix_install."_bbconfig VALUES ('max_inbox_privmsgs', '100')");
$db2->sql_query("INSERT INTO ".$prefix_install."_bbconfig VALUES ('max_sentbox_privmsgs', '100')");
$db2->sql_query("INSERT INTO ".$prefix_install."_bbconfig VALUES ('max_savebox_privmsgs', '100')");
$db2->sql_query("INSERT INTO ".$prefix_install."_bbconfig VALUES ('board_email_sig', 'Grazie, Webmaster@MySite.com')");
$db2->sql_query("INSERT INTO ".$prefix_install."_bbconfig VALUES ('board_email', '$mail_admin_site')");
$db2->sql_query("INSERT INTO ".$prefix_install."_bbconfig VALUES ('smtp_delivery', '0')");
$db2->sql_query("INSERT INTO ".$prefix_install."_bbconfig VALUES ('smtp_host', '')");
$db2->sql_query("INSERT INTO ".$prefix_install."_bbconfig VALUES ('require_activation', '0')");
$db2->sql_query("INSERT INTO ".$prefix_install."_bbconfig VALUES ('flood_interval', '15')");
$db2->sql_query("INSERT INTO ".$prefix_install."_bbconfig VALUES ('board_email_form', '0')");
$db2->sql_query("INSERT INTO ".$prefix_install."_bbconfig VALUES ('avatar_filesize', '6144')");
$db2->sql_query("INSERT INTO ".$prefix_install."_bbconfig VALUES ('avatar_max_width', '80')");
$db2->sql_query("INSERT INTO ".$prefix_install."_bbconfig VALUES ('avatar_max_height', '80')");
$db2->sql_query("INSERT INTO ".$prefix_install."_bbconfig VALUES ('avatar_path', 'modules/Forums/images/avatars')");
$db2->sql_query("INSERT INTO ".$prefix_install."_bbconfig VALUES ('avatar_gallery_path', 'modules/Forums/images/avatars')");
$db2->sql_query("INSERT INTO ".$prefix_install."_bbconfig VALUES ('smilies_path', 'modules/Forums/images/smiles')");
$db2->sql_query("INSERT INTO ".$prefix_install."_bbconfig VALUES ('default_style', '1')");
$db2->sql_query("INSERT INTO ".$prefix_install."_bbconfig VALUES ('default_dateformat', 'D M d, Y g:i a')");
$db2->sql_query("INSERT INTO ".$prefix_install."_bbconfig VALUES ('board_timezone', '1')");
$db2->sql_query("INSERT INTO ".$prefix_install."_bbconfig VALUES ('prune_enable', '0')");
$db2->sql_query("INSERT INTO ".$prefix_install."_bbconfig VALUES ('privmsg_disable', '0')");
$db2->sql_query("INSERT INTO ".$prefix_install."_bbconfig VALUES ('gzip_compress', '0')");
$db2->sql_query("INSERT INTO ".$prefix_install."_bbconfig VALUES ('coppa_fax', '')");
$db2->sql_query("INSERT INTO ".$prefix_install."_bbconfig VALUES ('coppa_mail', '')");
$db2->sql_query("INSERT INTO ".$prefix_install."_bbconfig VALUES ('board_startdate', '1147767010')");
$db2->sql_query("INSERT INTO ".$prefix_install."_bbconfig VALUES ('default_lang', '$lang')");
$db2->sql_query("INSERT INTO ".$prefix_install."_bbconfig VALUES ('smtp_username', '')");
$db2->sql_query("INSERT INTO ".$prefix_install."_bbconfig VALUES ('smtp_password', '')");
$db2->sql_query("INSERT INTO ".$prefix_install."_bbconfig VALUES ('record_online_users', '2')");
$db2->sql_query("INSERT INTO ".$prefix_install."_bbconfig VALUES ('record_online_date', '1034668530')");
$db2->sql_query("INSERT INTO ".$prefix_install."_bbconfig VALUES ('server_name', '$url_site')");
$db2->sql_query("INSERT INTO ".$prefix_install."_bbconfig VALUES ('server_port', '80')");
$db2->sql_query("INSERT INTO ".$prefix_install."_bbconfig VALUES ('script_path', '/modules/Forums/')");
$db2->sql_query("INSERT INTO ".$prefix_install."_bbconfig VALUES ('version', '.0.20')");
$db2->sql_query("INSERT INTO ".$prefix_install."_bbconfig VALUES ('enable_confirm', '0')");
$db2->sql_query("INSERT INTO ".$prefix_install."_bbconfig VALUES ('sendmail_fix', '0')");
$db2->sql_query("INSERT INTO ".$prefix_install."_bbconfig VALUES ('allow_autologin', '1')");
$db2->sql_query("INSERT INTO ".$prefix_install."_bbconfig VALUES ('max_autologin_time', '0')");
$db2->sql_query("INSERT INTO ".$prefix_install."_bbconfig VALUES ('max_login_attempts', '5')");
$db2->sql_query("INSERT INTO ".$prefix_install."_bbconfig VALUES ('login_reset_time', '30')");
$db2->sql_query("INSERT INTO ".$prefix_install."_bbconfig VALUES ('search_flood_interval', '15')");
$db2->sql_query("INSERT INTO ".$prefix_install."_bbconfig VALUES ('rand_seed', '0ebc750ac47c214ca666a08f4c64bfcf')");
################################################################################

$result5 = $db2->sql_query("CREATE TABLE ".$prefix_install."_bbconfirm(
  `confirm_id` char(32) NOT NULL default '',
  `session_id` char(32) NOT NULL default '',
  `code` char(6) NOT NULL default '',
  PRIMARY KEY  (`session_id`,`confirm_id`))");
################################################################################

$result6 = $db2->sql_query("CREATE TABLE ".$prefix_install."_bbdisallow(
  `disallow_id` mediumint(8) unsigned NOT NULL auto_increment,
  `disallow_username` varchar(25) default NULL,
  PRIMARY KEY  (`disallow_id`))");

################################################################################

$result7 = $db2->sql_query("CREATE TABLE ".$prefix_install."_bbforum_prune(
  `prune_id` mediumint(8) unsigned NOT NULL auto_increment,
  `forum_id` smallint(5) unsigned NOT NULL default '0',
  `prune_days` tinyint(4) unsigned NOT NULL default '0',
  `prune_freq` tinyint(4) unsigned NOT NULL default '0',
  PRIMARY KEY  (`prune_id`),
  KEY `forum_id` (`forum_id`))");

################################################################################

$result8 = $db2->sql_query("CREATE TABLE ".$prefix_install."_bbforums(
  `forum_id` smallint(5) unsigned NOT NULL auto_increment,
  `cat_id` mediumint(8) unsigned NOT NULL default '0',
  `forum_name` varchar(150) default NULL,
  `forum_desc` text,
  `forum_status` tinyint(4) NOT NULL default '0',
  `forum_order` mediumint(8) unsigned NOT NULL default '1',
  `forum_posts` mediumint(8) unsigned NOT NULL default '0',
  `forum_topics` mediumint(8) unsigned NOT NULL default '0',
  `forum_last_post_id` mediumint(8) unsigned NOT NULL default '0',
  `prune_next` int(11) default NULL,
  `prune_enable` tinyint(1) NOT NULL default '1',
  `auth_view` tinyint(2) NOT NULL default '0',
  `auth_read` tinyint(2) NOT NULL default '0',
  `auth_post` tinyint(2) NOT NULL default '0',
  `auth_reply` tinyint(2) NOT NULL default '0',
  `auth_edit` tinyint(2) NOT NULL default '0',
  `auth_delete` tinyint(2) NOT NULL default '0',
  `auth_sticky` tinyint(2) NOT NULL default '0',
  `auth_announce` tinyint(2) NOT NULL default '0',
  `auth_vote` tinyint(2) NOT NULL default '0',
  `auth_pollcreate` tinyint(2) NOT NULL default '0',
  `auth_attachments` tinyint(2) NOT NULL default '0',
  PRIMARY KEY  (`forum_id`),
  KEY `forums_order` (`forum_order`),
  KEY `cat_id` (`cat_id`),
  KEY `forum_last_post_id` (`forum_last_post_id`))");

################################################################################

$result9 = $db2->sql_query("CREATE TABLE ".$prefix_install."_bbgroups(
  `group_id` mediumint(8) NOT NULL auto_increment,
  `group_type` tinyint(4) NOT NULL default '1',
  `group_name` varchar(40) NOT NULL default '',
  `group_description` varchar(255) NOT NULL default '',
  `group_moderator` mediumint(8) NOT NULL default '0',
  `group_single_user` tinyint(1) NOT NULL default '1',
  PRIMARY KEY  (`group_id`),
  KEY `group_single_user` (`group_single_user`))");

$db2->sql_query("INSERT INTO ".$prefix_install."_bbgroups VALUES (1, 1, 'Anonymous', 'Personal User', 0, 1)");
$db2->sql_query("INSERT INTO ".$prefix_install."_bbgroups VALUES (3, 2, 'Moderatori', 'Moderatori di questo Forum', 5, 0)");
$db2->sql_query("INSERT INTO ".$prefix_install."_bbgroups VALUES (4, 2, 'Gruppo Demo', 'Demo', 2, 0)");
################################################################################

$result10 = $db2->sql_query("CREATE TABLE ".$prefix_install."_bbposts(
  `post_id` mediumint(8) unsigned NOT NULL auto_increment,
  `topic_id` mediumint(8) unsigned NOT NULL default '0',
  `forum_id` smallint(5) unsigned NOT NULL default '0',
  `poster_id` mediumint(8) NOT NULL default '0',
  `post_time` int(11) NOT NULL default '0',
  `poster_ip` varchar(8) NOT NULL default '',
  `post_username` varchar(25) default NULL,
  `enable_bbcode` tinyint(1) NOT NULL default '1',
  `enable_html` tinyint(1) NOT NULL default '0',
  `enable_smilies` tinyint(1) NOT NULL default '1',
  `enable_sig` tinyint(1) NOT NULL default '1',
  `post_edit_time` int(11) default NULL,
  `post_edit_count` smallint(5) unsigned NOT NULL default '0',
  PRIMARY KEY  (`post_id`),
  KEY `forum_id` (`forum_id`),
  KEY `topic_id` (`topic_id`),
  KEY `poster_id` (`poster_id`),
  KEY `post_time` (`post_time`))");
################################################################################

$result11 = $db2->sql_query("CREATE TABLE ".$prefix_install."_bbposts_text(
  `post_id` mediumint(8) unsigned NOT NULL default '0',
  `bbcode_uid` varchar(10) NOT NULL default '',
  `post_subject` varchar(60) default NULL,
  `post_text` text,
  PRIMARY KEY  (`post_id`))");
################################################################################

$result12 = $db2->sql_query("CREATE TABLE ".$prefix_install."_bbprivmsgs(
  `privmsgs_id` mediumint(8) unsigned NOT NULL auto_increment,
  `privmsgs_type` tinyint(4) NOT NULL default '0',
  `privmsgs_subject` varchar(255) NOT NULL default '0',
  `privmsgs_from_userid` mediumint(8) NOT NULL default '0',
  `privmsgs_to_userid` mediumint(8) NOT NULL default '0',
  `privmsgs_date` int(11) NOT NULL default '0',
  `privmsgs_ip` varchar(8) NOT NULL default '',
  `privmsgs_enable_bbcode` tinyint(1) NOT NULL default '1',
  `privmsgs_enable_html` tinyint(1) NOT NULL default '0',
  `privmsgs_enable_smilies` tinyint(1) NOT NULL default '1',
  `privmsgs_attach_sig` tinyint(1) NOT NULL default '1',
  PRIMARY KEY  (`privmsgs_id`),
  KEY `privmsgs_from_userid` (`privmsgs_from_userid`),
  KEY `privmsgs_to_userid` (`privmsgs_to_userid`))");

################################################################################

$result13 = $db2->sql_query("CREATE TABLE ".$prefix_install."_bbprivmsgs_text(
  `privmsgs_text_id` mediumint(8) unsigned NOT NULL default '0',
  `privmsgs_bbcode_uid` varchar(10) NOT NULL default '0',
  `privmsgs_text` text,
  PRIMARY KEY  (`privmsgs_text_id`))");

################################################################################

$result14 = $db2->sql_query("CREATE TABLE ".$prefix_install."_bbranks(
  `rank_id` smallint(5) unsigned NOT NULL auto_increment,
  `rank_title` varchar(50) NOT NULL default '',
  `rank_min` mediumint(8) NOT NULL default '0',
  `rank_max` mediumint(8) NOT NULL default '0',
  `rank_special` tinyint(1) default '0',
  `rank_image` varchar(255) default NULL,
  PRIMARY KEY  (`rank_id`))");

$db2->sql_query("INSERT INTO ".$prefix_install."_bbranks VALUES (1, 'Admin', -1, -1, 1, 'modules/Forums/images/ranks/6stars.gif')");
$db2->sql_query("INSERT INTO ".$prefix_install."_bbranks VALUES (2, 'Nuovo', 1, 0, 0, 'modules/Forums/images/ranks/1star.gif')");

################################################################################

$result18 = $db2->sql_query("CREATE TABLE ".$prefix_install."_bbsearch_results(
  `search_id` int(11) unsigned NOT NULL default '0',
  `session_id` varchar(32) NOT NULL default '',
  `search_array` text NOT NULL,
  `search_time` int(11) NOT NULL default '0',
  PRIMARY KEY  (`search_id`),
  KEY `session_id` (`session_id`))");

################################################################################

$result16 = $db2->sql_query("CREATE TABLE ".$prefix_install."_bbsearch_wordlist(
  `word_text` varchar(50) NOT NULL default '',
  `word_id` mediumint(8) unsigned NOT NULL auto_increment,
  `word_common` tinyint(1) unsigned NOT NULL default '0',
  PRIMARY KEY  (`word_text`),
  KEY `word_id` (`word_id`))");

################################################################################

$result17 = $db2->sql_query("CREATE TABLE ".$prefix_install."_bbsearch_wordmatch(
  `post_id` mediumint(8) unsigned NOT NULL default '0',
  `word_id` mediumint(8) unsigned NOT NULL default '0',
  `title_match` tinyint(1) NOT NULL default '0',
  KEY `word_id` (`word_id`))");

################################################################################

$result18 = $db2->sql_query("CREATE TABLE ".$prefix_install."_bbsessions(
  `session_id` char(32) NOT NULL default '',
  `session_user_id` mediumint(8) NOT NULL default '0',
  `session_start` int(11) NOT NULL default '0',
  `session_time` int(11) NOT NULL default '0',
  `session_ip` char(8) NOT NULL default '0',
  `session_page` int(11) NOT NULL default '0',
  `session_logged_in` tinyint(1) NOT NULL default '0',
  `session_admin` tinyint(2) NOT NULL default '0',
  PRIMARY KEY  (`session_id`),
  KEY `session_user_id` (`session_user_id`),
  KEY `session_id_ip_user_id` (`session_id`,`session_ip`,`session_user_id`))");

################################################################################

$result18b = $db2->sql_query("CREATE TABLE ".$prefix_install."_bbsessions_keys(
  `key_id` varchar(32) NOT NULL default '0',
  `user_id` mediumint(8) NOT NULL default '0',
  `last_ip` varchar(8) NOT NULL default '0',
  `last_login` int(11) NOT NULL default '0',
  PRIMARY KEY  (`key_id`,`user_id`),
  KEY `last_login` (`last_login`))");

################################################################################

$result19 = $db2->sql_query("CREATE TABLE ".$prefix_install."_bbsmilies(
  `smilies_id` smallint(5) unsigned NOT NULL auto_increment,
  `code` varchar(50) default NULL,
  `smile_url` varchar(100) default NULL,
  `emoticon` varchar(75) default NULL,
  PRIMARY KEY  (`smilies_id`))");
$db2->sql_query("INSERT INTO ".$prefix_install."_bbsmilies VALUES (1, ':D', 'icon_biggrin.gif', 'Very Happy')");
$db2->sql_query("INSERT INTO ".$prefix_install."_bbsmilies VALUES (2, ':-D', 'icon_biggrin.gif', 'Very Happy')");
$db2->sql_query("INSERT INTO ".$prefix_install."_bbsmilies VALUES (3, ':grin:', 'icon_biggrin.gif', 'Very Happy')");
$db2->sql_query("INSERT INTO ".$prefix_install."_bbsmilies VALUES (4, ':)', 'icon_smile.gif', 'Smile')");
$db2->sql_query("INSERT INTO ".$prefix_install."_bbsmilies VALUES (5, ':-)', 'icon_smile.gif', 'Smile')");
$db2->sql_query("INSERT INTO ".$prefix_install."_bbsmilies VALUES (6, ':smile:', 'icon_smile.gif', 'Smile')");
$db2->sql_query("INSERT INTO ".$prefix_install."_bbsmilies VALUES (7, ':(', 'icon_sad.gif', 'Sad')");
$db2->sql_query("INSERT INTO ".$prefix_install."_bbsmilies VALUES (8, ':-(', 'icon_sad.gif', 'Sad')");
$db2->sql_query("INSERT INTO ".$prefix_install."_bbsmilies VALUES (9, ':sad:', 'icon_sad.gif', 'Sad')");
$db2->sql_query("INSERT INTO ".$prefix_install."_bbsmilies VALUES (10, ':o', 'icon_surprised.gif', 'Surprised')");
$db2->sql_query("INSERT INTO ".$prefix_install."_bbsmilies VALUES (11, ':-o', 'icon_surprised.gif', 'Surprised')");
$db2->sql_query("INSERT INTO ".$prefix_install."_bbsmilies VALUES (12, ':eek:', 'icon_surprised.gif', 'Surprised')");
$db2->sql_query("INSERT INTO ".$prefix_install."_bbsmilies VALUES (13, '8O', 'icon_eek.gif', 'Shocked')");
$db2->sql_query("INSERT INTO ".$prefix_install."_bbsmilies VALUES (14, '8-O', 'icon_eek.gif', 'Shocked')");
$db2->sql_query("INSERT INTO ".$prefix_install."_bbsmilies VALUES (15, ':shock:', 'icon_eek.gif', 'Shocked')");
$db2->sql_query("INSERT INTO ".$prefix_install."_bbsmilies VALUES (16, ':?', 'icon_confused.gif', 'Confused')");
$db2->sql_query("INSERT INTO ".$prefix_install."_bbsmilies VALUES (17, ':-?', 'icon_confused.gif', 'Confused')");
$db2->sql_query("INSERT INTO ".$prefix_install."_bbsmilies VALUES (18, ':???:', 'icon_confused.gif', 'Confused')");
$db2->sql_query("INSERT INTO ".$prefix_install."_bbsmilies VALUES (19, '8)', 'icon_cool.gif', 'Cool')");
$db2->sql_query("INSERT INTO ".$prefix_install."_bbsmilies VALUES (20, '8-)', 'icon_cool.gif', 'Cool')");
$db2->sql_query("INSERT INTO ".$prefix_install."_bbsmilies VALUES (21, ':cool:', 'icon_cool.gif', 'Cool')");
$db2->sql_query("INSERT INTO ".$prefix_install."_bbsmilies VALUES (22, ':lol:', 'icon_lol.gif', 'Laughing')");
$db2->sql_query("INSERT INTO ".$prefix_install."_bbsmilies VALUES (23, ':x', 'icon_mad.gif', 'Mad')");
$db2->sql_query("INSERT INTO ".$prefix_install."_bbsmilies VALUES (24, ':-x', 'icon_mad.gif', 'Mad')");
$db2->sql_query("INSERT INTO ".$prefix_install."_bbsmilies VALUES (25, ':mad:', 'icon_mad.gif', 'Mad')");
$db2->sql_query("INSERT INTO ".$prefix_install."_bbsmilies VALUES (26, ':P', 'icon_razz.gif', 'Razz')");
$db2->sql_query("INSERT INTO ".$prefix_install."_bbsmilies VALUES (27, ':-P', 'icon_razz.gif', 'Razz')");
$db2->sql_query("INSERT INTO ".$prefix_install."_bbsmilies VALUES (28, ':razz:', 'icon_razz.gif', 'Razz')");
$db2->sql_query("INSERT INTO ".$prefix_install."_bbsmilies VALUES (29, ':oops:', 'icon_redface.gif', 'Embarassed')");
$db2->sql_query("INSERT INTO ".$prefix_install."_bbsmilies VALUES (30, ':cry:', 'icon_cry.gif', 'Crying or Very sad')");
$db2->sql_query("INSERT INTO ".$prefix_install."_bbsmilies VALUES (31, ':evil:', 'icon_evil.gif', 'Evil or Very Mad')");
$db2->sql_query("INSERT INTO ".$prefix_install."_bbsmilies VALUES (32, ':twisted:', 'icon_twisted.gif', 'Twisted Evil')");
$db2->sql_query("INSERT INTO ".$prefix_install."_bbsmilies VALUES (33, ':roll:', 'icon_rolleyes.gif', 'Rolling Eyes')");
$db2->sql_query("INSERT INTO ".$prefix_install."_bbsmilies VALUES (34, ':wink:', 'icon_wink.gif', 'Wink')");
$db2->sql_query("INSERT INTO ".$prefix_install."_bbsmilies VALUES (35, ';)', 'icon_wink.gif', 'Wink')");
$db2->sql_query("INSERT INTO ".$prefix_install."_bbsmilies VALUES (36, ';-)', 'icon_wink.gif', 'Wink')");
$db2->sql_query("INSERT INTO ".$prefix_install."_bbsmilies VALUES (37, ':!:', 'icon_exclaim.gif', 'Exclamation')");
$db2->sql_query("INSERT INTO ".$prefix_install."_bbsmilies VALUES (38, ':?:', 'icon_question.gif', 'Question')");
$db2->sql_query("INSERT INTO ".$prefix_install."_bbsmilies VALUES (39, ':idea:', 'icon_idea.gif', 'Idea')");
$db2->sql_query("INSERT INTO ".$prefix_install."_bbsmilies VALUES (40, ':arrow:', 'icon_arrow.gif', 'Arrow')");
$db2->sql_query("INSERT INTO ".$prefix_install."_bbsmilies VALUES (41, ':|', 'icon_neutral.gif', 'Neutral')");
$db2->sql_query("INSERT INTO ".$prefix_install."_bbsmilies VALUES (42, ':-|', 'icon_neutral.gif', 'Neutral')");
$db2->sql_query("INSERT INTO ".$prefix_install."_bbsmilies VALUES (43, ':neutral:', 'icon_neutral.gif', 'Neutral')");
$db2->sql_query("INSERT INTO ".$prefix_install."_bbsmilies VALUES (44, ':mrgreen:', 'icon_mrgreen.gif', 'Mr. Green')");

################################################################################

$result20 = $db2->sql_query("CREATE TABLE ".$prefix_install."_bbthemes(
  `themes_id` mediumint(8) unsigned NOT NULL auto_increment,
  `template_name` varchar(30) NOT NULL default '',
  `style_name` varchar(30) NOT NULL default '',
  `head_stylesheet` varchar(100) default NULL,
  `body_background` varchar(100) default NULL,
  `body_bgcolor` varchar(6) default NULL,
  `body_text` varchar(6) default NULL,
  `body_link` varchar(6) default NULL,
  `body_vlink` varchar(6) default NULL,
  `body_alink` varchar(6) default NULL,
  `body_hlink` varchar(6) default NULL,
  `tr_color1` varchar(6) default NULL,
  `tr_color2` varchar(6) default NULL,
  `tr_color3` varchar(6) default NULL,
  `tr_class1` varchar(25) default NULL,
  `tr_class2` varchar(25) default NULL,
  `tr_class3` varchar(25) default NULL,
  `th_color1` varchar(6) default NULL,
  `th_color2` varchar(6) default NULL,
  `th_color3` varchar(6) default NULL,
  `th_class1` varchar(25) default NULL,
  `th_class2` varchar(25) default NULL,
  `th_class3` varchar(25) default NULL,
  `td_color1` varchar(6) default NULL,
  `td_color2` varchar(6) default NULL,
  `td_color3` varchar(6) default NULL,
  `td_class1` varchar(25) default NULL,
  `td_class2` varchar(25) default NULL,
  `td_class3` varchar(25) default NULL,
  `fontface1` varchar(50) default NULL,
  `fontface2` varchar(50) default NULL,
  `fontface3` varchar(50) default NULL,
  `fontsize1` tinyint(4) default NULL,
  `fontsize2` tinyint(4) default NULL,
  `fontsize3` tinyint(4) default NULL,
  `fontcolor1` varchar(6) default NULL,
  `fontcolor2` varchar(6) default NULL,
  `fontcolor3` varchar(6) default NULL,
  `span_class1` varchar(25) default NULL,
  `span_class2` varchar(25) default NULL,
  `span_class3` varchar(25) default NULL,
  `img_size_poll` smallint(5) unsigned default NULL,
  `img_size_privmsg` smallint(5) unsigned default NULL,
  PRIMARY KEY  (`themes_id`))");

$db2->sql_query("INSERT INTO ".$prefix_install."_bbthemes VALUES (1, 'subSilver', 'subSilver', 'subSilver.css', '', '0E3259', '000000', '006699', '5493B4', '', 'DD6900', 'EFEFEF', 'DEE3E7', 'D1D7DC', '', '', '', '98AAB1', '006699', 'FFFFFF', 'cellpic1.gif', 'cellpic3.gif', 'cellpic2.jpg', 'FAFAFA', 'FFFFFF', '', 'row1', 'row2', '', 'Verdana, Arial, Helvetica, sans-serif', 'Trebuchet MS', 'Courier, ''Courier New'', sans-serif', 10, 11, 12, '444444', '006600', 'FFA34F', '', '', '', NULL, NULL)");

################################################################################

$result21 = $db2->sql_query("CREATE TABLE ".$prefix_install."_bbthemes_name(
  `themes_id` smallint(5) unsigned NOT NULL default '0',
  `tr_color1_name` char(50) default NULL,
  `tr_color2_name` char(50) default NULL,
  `tr_color3_name` char(50) default NULL,
  `tr_class1_name` char(50) default NULL,
  `tr_class2_name` char(50) default NULL,
  `tr_class3_name` char(50) default NULL,
  `th_color1_name` char(50) default NULL,
  `th_color2_name` char(50) default NULL,
  `th_color3_name` char(50) default NULL,
  `th_class1_name` char(50) default NULL,
  `th_class2_name` char(50) default NULL,
  `th_class3_name` char(50) default NULL,
  `td_color1_name` char(50) default NULL,
  `td_color2_name` char(50) default NULL,
  `td_color3_name` char(50) default NULL,
  `td_class1_name` char(50) default NULL,
  `td_class2_name` char(50) default NULL,
  `td_class3_name` char(50) default NULL,
  `fontface1_name` char(50) default NULL,
  `fontface2_name` char(50) default NULL,
  `fontface3_name` char(50) default NULL,
  `fontsize1_name` char(50) default NULL,
  `fontsize2_name` char(50) default NULL,
  `fontsize3_name` char(50) default NULL,
  `fontcolor1_name` char(50) default NULL,
  `fontcolor2_name` char(50) default NULL,
  `fontcolor3_name` char(50) default NULL,
  `span_class1_name` char(50) default NULL,
  `span_class2_name` char(50) default NULL,
  `span_class3_name` char(50) default NULL,
  PRIMARY KEY  (`themes_id`))");

$db2->sql_query("INSERT INTO ".$prefix_install."_bbthemes_name VALUES (1, 'The lightest row colour', 'The medium row color', 'The darkest row colour', '', '', '', 'Border round the whole page', 'Outer table border', 'Inner table border', 'Silver gradient picture', 'Blue gradient picture', 'Fade-out gradient on index', 'Background for quote boxes', 'All white areas', '', 'Background for topic posts', '2nd background for topic posts', '', 'Main fonts', 'Additional topic title font', 'Form fonts', 'Smallest font size', 'Medium font size', 'Normal font size (post body etc)', 'Quote & copyright text', 'Code text colour', 'Main table header text colour', '', '', '')");

################################################################################

$result22 = $db2->sql_query("CREATE TABLE ".$prefix_install."_bbtopics(
  `topic_id` mediumint(8) unsigned NOT NULL auto_increment,
  `forum_id` smallint(8) unsigned NOT NULL default '0',
  `topic_title` char(60) NOT NULL default '',
  `topic_poster` mediumint(8) NOT NULL default '0',
  `topic_time` int(11) NOT NULL default '0',
  `topic_views` mediumint(8) unsigned NOT NULL default '0',
  `topic_replies` mediumint(8) unsigned NOT NULL default '0',
  `topic_status` tinyint(3) NOT NULL default '0',
  `topic_vote` tinyint(1) NOT NULL default '0',
  `topic_type` tinyint(3) NOT NULL default '0',
  `topic_last_post_id` mediumint(8) unsigned NOT NULL default '0',
  `topic_first_post_id` mediumint(8) unsigned NOT NULL default '0',
  `topic_moved_id` mediumint(8) unsigned NOT NULL default '0',
  PRIMARY KEY  (`topic_id`),
  KEY `forum_id` (`forum_id`),
  KEY `topic_moved_id` (`topic_moved_id`),
  KEY `topic_status` (`topic_status`),
  KEY `topic_type` (`topic_type`))");

################################################################################

$result23 = $db2->sql_query("CREATE TABLE ".$prefix_install."_bbtopics_watch(
  `topic_id` mediumint(8) unsigned NOT NULL default '0',
  `user_id` mediumint(8) NOT NULL default '0',
  `notify_status` tinyint(1) NOT NULL default '0',
  KEY `topic_id` (`topic_id`),
  KEY `user_id` (`user_id`),
  KEY `notify_status` (`notify_status`))");

################################################################################

$result24 = $db2->sql_query("CREATE TABLE ".$prefix_install."_bbuser_group(
  `group_id` mediumint(8) NOT NULL default '0',
  `user_id` mediumint(8) NOT NULL default '0',
  `user_pending` tinyint(1) default NULL,
  KEY `group_id` (`group_id`),
  KEY `user_id` (`user_id`))");

$db2->sql_query("INSERT INTO ".$prefix_install."_bbuser_group VALUES (1, -1, 0)");
$db2->sql_query("INSERT INTO ".$prefix_install."_bbuser_group VALUES (3, 5, 0)");
$db2->sql_query("INSERT INTO ".$prefix_install."_bbuser_group VALUES (4, 2, 0)");

################################################################################

$result25 = $db2->sql_query("CREATE TABLE ".$prefix_install."_bbvote_desc(
  `vote_id` mediumint(8) unsigned NOT NULL auto_increment,
  `topic_id` mediumint(8) unsigned NOT NULL default '0',
  `vote_text` text NOT NULL,
  `vote_start` int(11) NOT NULL default '0',
  `vote_length` int(11) NOT NULL default '0',
  PRIMARY KEY  (`vote_id`),
  KEY `topic_id` (`topic_id`))");

################################################################################

$result26 = $db2->sql_query("CREATE TABLE ".$prefix_install."_bbvote_results(
  `vote_id` mediumint(8) unsigned NOT NULL default '0',
  `vote_option_id` tinyint(4) unsigned NOT NULL default '0',
  `vote_option_text` varchar(255) NOT NULL default '',
  `vote_result` int(11) NOT NULL default '0',
  KEY `vote_option_id` (`vote_option_id`),
  KEY `vote_id` (`vote_id`))");

################################################################################

$result27 = $db2->sql_query("CREATE TABLE ".$prefix_install."_bbvote_voters(
  `vote_id` mediumint(8) unsigned NOT NULL default '0',
  `vote_user_id` mediumint(8) NOT NULL default '0',
  `vote_user_ip` char(8) NOT NULL default '',
  KEY `vote_id` (`vote_id`),
  KEY `vote_user_id` (`vote_user_id`),
  KEY `vote_user_ip` (`vote_user_ip`))");

################################################################################

$result28 = $db2->sql_query("CREATE TABLE ".$prefix_install."_bbwords(
  `word_id` mediumint(8) unsigned NOT NULL auto_increment,
  `word` char(100) NOT NULL default '',
  `replacement` char(100) NOT NULL default '',
  PRIMARY KEY  (`word_id`))");
################################################################################
