IP : 3.144.235.159Hostname : host45.registrar-servers.comKernel : Linux host45.registrar-servers.com 4.18.0-513.18.1.lve.2.el8.x86_64 #1 SMP Sat Mar 30 15:36:11 UTC 2024 x86_64Disable Function : None :) OS : Linux
PATH:
/
home/
../
var/
softaculous/
vanilla/
../
wp60/
../
twg/
../
pie/
../
aef/
mysql.php/
/
<?php
////////////////////////////////////////////////////////////// //=========================================================== // mysql.php(Setup) //=========================================================== // AEF : Advanced Electron Forum // Version : 1.0.8 // Inspired by Pulkit and taken over by Electron // ---------------------------------------------------------- // Started by: Electron, Ronak Gupta, Pulkit Gupta // Date: 23rd Jan 2006 // Time: 15:00 hrs // Site: http://www.anelectron.com/ (Anelectron) // ---------------------------------------------------------- // Please Read the Terms of use at http://www.anelectron.com // ---------------------------------------------------------- //=========================================================== // (c)Electron Inc. //=========================================================== //////////////////////////////////////////////////////////////
$queries = array();
//$queries[] = "";
if(!empty($__settings['utf8'])){
$queries[] = "ALTER DATABASE ".$__settings['softdb']." CHARACTER SET utf8 DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT COLLATE utf8_general_ci";
}
//Apps - Applications $queries[] = "CREATE TABLE ".$__settings['dbprefix']."apps ( `apid` mediumint(8) NOT NULL auto_increment, `ap_name` varchar(100) NOT NULL default '', `ap_version` varchar(15) NOT NULL default '', `installed_time` int(10) NOT NULL default '0', `ap_info` varchar(255) NOT NULL default '', PRIMARY KEY (`apid`) ) TYPE=MyISAM".(empty($__settings['utf8']) ? '' : " DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci");
//Apps Registry - Applications Registry $queries[] = "CREATE TABLE ".$__settings['dbprefix']."apps_registry ( `apid` mediumint(8) NOT NULL default '0', `uid` mediumint(8) NOT NULL default '0', `apps_registry` text NOT NULL, UNIQUE KEY `apid` (`apid`,`uid`) ) TYPE=MyISAM".(empty($__settings['utf8']) ? '' : " DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci");
//Attachment Mimetypes $queries[] = "CREATE TABLE ".$__settings['dbprefix']."attachment_mimetypes ( atmtid smallint(5) NOT NULL auto_increment, atmt_ext varchar(20) NOT NULL default '', atmt_mimetype varchar(255) NOT NULL default '', atmt_icon tinytext NOT NULL, atmt_posts tinyint(2) NOT NULL default '0', atmt_avatar tinyint(2) NOT NULL default '0', atmt_isimage tinyint(2) NOT NULL default '0', PRIMARY KEY (atmtid) ) TYPE=MyISAM".(empty($__settings['utf8']) ? '' : " DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci");
//Polls $queries[] = "CREATE TABLE ".$__settings['dbprefix']."polls ( poid mediumint(8) NOT NULL auto_increment, poll_qt tinytext NOT NULL, poll_mid mediumint(8) NOT NULL default '0', poll_locked tinyint(2) NOT NULL default '0', poll_tid mediumint(8) NOT NULL default '0', poll_expiry int(10) NOT NULL default '0', poll_change_vote tinyint(2) NOT NULL default '0', poll_started int(10) NOT NULL default '0', poll_show_when tinyint(2) NOT NULL default '0', PRIMARY KEY (poid) ) TYPE=MyISAM".(empty($__settings['utf8']) ? '' : " DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci");
//Posts $queries[] = "CREATE TABLE ".$__settings['dbprefix']."posts ( `pid` int(10) NOT NULL auto_increment, `post_tid` mediumint(8) NOT NULL default '0', `p_top_sticky` tinyint(2) NOT NULL default '0', `post_fid` smallint(5) NOT NULL default '0', `ptime` int(10) NOT NULL default '0', `poster_id` mediumint(8) NOT NULL default '0', `poster_ip` varchar(20) NOT NULL default '', `modtime` int(10) NOT NULL default '0', `modifiers_id` mediumint(8) NOT NULL default '0', `post` text NOT NULL, `use_smileys` tinyint(2) NOT NULL default '1', `gposter_name` varchar(80) NOT NULL default '', `gposter_email` varchar(80) NOT NULL default '', `post_title` varchar(255) NOT NULL default '', `num_attachments` tinyint(4) NOT NULL default '0', `par_id` int(10) NOT NULL default '0', `p_approved` tinyint(2) NOT NULL default '0', PRIMARY KEY (`pid`) ) TYPE=MyISAM".(empty($__settings['utf8']) ? '' : " DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci");
$queries[] = "INSERT INTO ".$__settings['dbprefix']."posts VALUES (1, 1, 0, 1, ".time().", -1, '', 0, 0, 'Hi,\r\n\r\n We would like to thank you for using AEF.\r\nIf you need any assistance :??: , feel free to ask us for help at the [url=http://www.anelectron.com/board/]support board[/url].\r\n\r\nThanks and enjoy AEF!!! ;-D \r\n\r\n', 1, 'AEF Team', 'aef@anelectron.com', '', 0, 0, 1)";
//AEF Registry $queries[] = "CREATE TABLE ".$__settings['dbprefix']."registry ( name varchar(255) NOT NULL default '', regval text NOT NULL, UNIQUE KEY name (name) ) TYPE=MyISAM".(empty($__settings['utf8']) ? '' : " DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci");
$queries[] = "INSERT INTO ".$__settings['dbprefix']."registry VALUES ('reserved_names', 'admin\r\nwebmaster\r\nmaster\r\nuser\r\nlocalhost\r\nlord')"; $queries[] = "INSERT INTO ".$__settings['dbprefix']."registry VALUES ('latest_mem', '".$__settings['admin_username']."|1')"; $queries[] = "INSERT INTO ".$__settings['dbprefix']."registry VALUES ('num_mem', '1')"; $queries[] = "INSERT INTO ".$__settings['dbprefix']."registry VALUES ('recyclebin', '0')"; $queries[] = "INSERT INTO ".$__settings['dbprefix']."registry VALUES ('mostactive', '1|".time()."')"; $queries[] = "INSERT INTO ".$__settings['dbprefix']."registry VALUES ('maxtopics', '30')"; $queries[] = "INSERT INTO ".$__settings['dbprefix']."registry VALUES ('maxpostsintopics', '15')"; $queries[] = "INSERT INTO ".$__settings['dbprefix']."registry VALUES ('maxreplyhot', '15')"; $queries[] = "INSERT INTO ".$__settings['dbprefix']."registry VALUES ('maxreplyveryhot', '25')"; $queries[] = "INSERT INTO ".$__settings['dbprefix']."registry VALUES ('disableshoutingtopics', '0')"; $queries[] = "INSERT INTO ".$__settings['dbprefix']."registry VALUES ('disableshoutingdesc', '0')"; $queries[] = "INSERT INTO ".$__settings['dbprefix']."registry VALUES ('prenextopic', '1')"; $queries[] = "INSERT INTO ".$__settings['dbprefix']."registry VALUES ('warnoldtopic', '120')"; $queries[] = "INSERT INTO ".$__settings['dbprefix']."registry VALUES ('prefixsticky', 'Sticky:')"; $queries[] = "INSERT INTO ".$__settings['dbprefix']."registry VALUES ('prefixmoved', 'Moved:')"; $queries[] = "INSERT INTO ".$__settings['dbprefix']."registry VALUES ('prefixpolls', 'Poll:')"; $queries[] = "INSERT INTO ".$__settings['dbprefix']."registry VALUES ('maxtitlechars', '0')"; $queries[] = "INSERT INTO ".$__settings['dbprefix']."registry VALUES ('mintitlechars', '0')"; $queries[] = "INSERT INTO ".$__settings['dbprefix']."registry VALUES ('maxdescchars', '0')"; $queries[] = "INSERT INTO ".$__settings['dbprefix']."registry VALUES ('mindescchars', '0')"; $queries[] = "INSERT INTO ".$__settings['dbprefix']."registry VALUES ('allow_taf', '1')"; $queries[] = "INSERT INTO ".$__settings['dbprefix']."registry VALUES ('maxcharposts', '20000')"; $queries[] = "INSERT INTO ".$__settings['dbprefix']."registry VALUES ('mincharposts', '0')"; $queries[] = "INSERT INTO ".$__settings['dbprefix']."registry VALUES ('timepostfromuser', '10')"; $queries[] = "INSERT INTO ".$__settings['dbprefix']."registry VALUES ('maxemotpost', '15')"; $queries[] = "INSERT INTO ".$__settings['dbprefix']."registry VALUES ('maximgspost', '15')"; $queries[] = "INSERT INTO ".$__settings['dbprefix']."registry VALUES ('allowdynimg', '0')"; $queries[] = "INSERT INTO ".$__settings['dbprefix']."registry VALUES ('maximgwidthpost', '300')"; $queries[] = "INSERT INTO ".$__settings['dbprefix']."registry VALUES ('maximgheightpost', '300')"; $queries[] = "INSERT INTO ".$__settings['dbprefix']."registry VALUES ('removenestedquotes', '0')"; $queries[] = "INSERT INTO ".$__settings['dbprefix']."registry VALUES ('attachsigtopost', '1')"; $queries[] = "INSERT INTO ".$__settings['dbprefix']."registry VALUES ('embedflashinpost', '0')"; $queries[] = "INSERT INTO ".$__settings['dbprefix']."registry VALUES ('maxflashpost', '5')"; $queries[] = "INSERT INTO ".$__settings['dbprefix']."registry VALUES ('maxflashwidthinpost', '300')"; $queries[] = "INSERT INTO ".$__settings['dbprefix']."registry VALUES ('maxflashheightinpost', '300')"; $queries[] = "INSERT INTO ".$__settings['dbprefix']."registry VALUES ('enablepolls', '1')"; $queries[] = "INSERT INTO ".$__settings['dbprefix']."registry VALUES ('maxpollsintopic', '3')"; $queries[] = "INSERT INTO ".$__settings['dbprefix']."registry VALUES ('maxoptionspoll', '10')"; $queries[] = "INSERT INTO ".$__settings['dbprefix']."registry VALUES ('maxpollqtlen', '100')"; $queries[] = "INSERT INTO ".$__settings['dbprefix']."registry VALUES ('censor_words_from', '')"; $queries[] = "INSERT INTO ".$__settings['dbprefix']."registry VALUES ('censor_words_to', '')"; $queries[] = "INSERT INTO ".$__settings['dbprefix']."registry VALUES ('maintenance', '0')"; $queries[] = "INSERT INTO ".$__settings['dbprefix']."registry VALUES ('censor_words_case', '0')"; $queries[] = "INSERT INTO ".$__settings['dbprefix']."registry VALUES ('parsebbc', '1')"; $queries[] = "INSERT INTO ".$__settings['dbprefix']."registry VALUES ('autolink', '1')"; $queries[] = "INSERT INTO ".$__settings['dbprefix']."registry VALUES ('bbc_hr', '1')"; $queries[] = "INSERT INTO ".$__settings['dbprefix']."registry VALUES ('bbc_b', '1')"; $queries[] = "INSERT INTO ".$__settings['dbprefix']."registry VALUES ('bbc_i', '1')"; $queries[] = "INSERT INTO ".$__settings['dbprefix']."registry VALUES ('bbc_u', '1')"; $queries[] = "INSERT INTO ".$__settings['dbprefix']."registry VALUES ('bbc_s', '1')"; $queries[] = "INSERT INTO ".$__settings['dbprefix']."registry VALUES ('bbc_left', '1')"; $queries[] = "INSERT INTO ".$__settings['dbprefix']."registry VALUES ('bbc_right', '1')"; $queries[] = "INSERT INTO ".$__settings['dbprefix']."registry VALUES ('bbc_center', '1')"; $queries[] = "INSERT INTO ".$__settings['dbprefix']."registry VALUES ('bbc_size', '1')"; $queries[] = "INSERT INTO ".$__settings['dbprefix']."registry VALUES ('bbc_font', '1')"; $queries[] = "INSERT INTO ".$__settings['dbprefix']."registry VALUES ('bbc_sup', '1')"; $queries[] = "INSERT INTO ".$__settings['dbprefix']."registry VALUES ('bbc_sub', '1')"; $queries[] = "INSERT INTO ".$__settings['dbprefix']."registry VALUES ('bbc_color', '1')"; $queries[] = "INSERT INTO ".$__settings['dbprefix']."registry VALUES ('bbc_url', '1')"; $queries[] = "INSERT INTO ".$__settings['dbprefix']."registry VALUES ('bbc_ftp', '1')"; $queries[] = "INSERT INTO ".$__settings['dbprefix']."registry VALUES ('bbc_email', '1')"; $queries[] = "INSERT INTO ".$__settings['dbprefix']."registry VALUES ('bbc_img', '1')"; $queries[] = "INSERT INTO ".$__settings['dbprefix']."registry VALUES ('bbc_flash', '1')"; $queries[] = "INSERT INTO ".$__settings['dbprefix']."registry VALUES ('bbc_code', '1')"; $queries[] = "INSERT INTO ".$__settings['dbprefix']."registry VALUES ('bbc_quote', '1')"; $queries[] = "INSERT INTO ".$__settings['dbprefix']."registry VALUES ('bbc_php', '1')"; $queries[] = "INSERT INTO ".$__settings['dbprefix']."registry VALUES ('bbc_ul', '1')"; $queries[] = "INSERT INTO ".$__settings['dbprefix']."registry VALUES ('bbc_ol', '1')"; $queries[] = "INSERT INTO ".$__settings['dbprefix']."registry VALUES ('bbc_parseHTML', '1')"; $queries[] = "INSERT INTO ".$__settings['dbprefix']."registry VALUES ('reg_method', '1')"; $queries[] = "INSERT INTO ".$__settings['dbprefix']."registry VALUES ('allow_reg', '1')"; $queries[] = "INSERT INTO ".$__settings['dbprefix']."registry VALUES ('wel_email', '1')"; $queries[] = "INSERT INTO ".$__settings['dbprefix']."registry VALUES ('reg_notify', '0')"; $queries[] = "INSERT INTO ".$__settings['dbprefix']."registry VALUES ('max_pass', '20')"; $queries[] = "INSERT INTO ".$__settings['dbprefix']."registry VALUES ('max_uname', '20')"; $queries[] = "INSERT INTO ".$__settings['dbprefix']."registry VALUES ('min_pass', '4')"; $queries[] = "INSERT INTO ".$__settings['dbprefix']."registry VALUES ('min_uname', '4')"; $queries[] = "INSERT INTO ".$__settings['dbprefix']."registry VALUES ('sec_conf', '1')"; $queries[] = "INSERT INTO ".$__settings['dbprefix']."registry VALUES ('samepc_reg', '0')"; $queries[] = "INSERT INTO ".$__settings['dbprefix']."registry VALUES ('age_limit', '0')"; $queries[] = "INSERT INTO ".$__settings['dbprefix']."registry VALUES ('age_rest_act', '1')"; $queries[] = "INSERT INTO ".$__settings['dbprefix']."registry VALUES ('age_rest_act_address', '')"; $queries[] = "INSERT INTO ".$__settings['dbprefix']."registry VALUES ('age_rest_act_fax', '')"; $queries[] = "INSERT INTO ".$__settings['dbprefix']."registry VALUES ('age_rest_act_tele', '')"; $queries[] = "INSERT INTO ".$__settings['dbprefix']."registry VALUES ('reserved_match_whole', '0')"; $queries[] = "INSERT INTO ".$__settings['dbprefix']."registry VALUES ('reserved_match_insensitive', '1')"; $queries[] = "INSERT INTO ".$__settings['dbprefix']."registry VALUES ('login_failed', '5')"; $queries[] = "INSERT INTO ".$__settings['dbprefix']."registry VALUES ('anon_login', '1')"; $queries[] = "INSERT INTO ".$__settings['dbprefix']."registry VALUES ('fpass_sec_conf', '1')"; $queries[] = "INSERT INTO ".$__settings['dbprefix']."registry VALUES ('userstextlen', '100')"; $queries[] = "INSERT INTO ".$__settings['dbprefix']."registry VALUES ('wwwlen', '150')"; $queries[] = "INSERT INTO ".$__settings['dbprefix']."registry VALUES ('customtitlelen', '30')"; $queries[] = "INSERT INTO ".$__settings['dbprefix']."registry VALUES ('locationlen', '100')"; $queries[] = "INSERT INTO ".$__settings['dbprefix']."registry VALUES ('realnamelen', '100')"; $queries[] = "INSERT INTO ".$__settings['dbprefix']."registry VALUES ('secretqtlen', '200')"; $queries[] = "INSERT INTO ".$__settings['dbprefix']."registry VALUES ('secretansmaxlen', '20')"; $queries[] = "INSERT INTO ".$__settings['dbprefix']."registry VALUES ('secretansminlen', '4')"; $queries[] = "INSERT INTO ".$__settings['dbprefix']."registry VALUES ('usersiglen', '200')"; $queries[] = "INSERT INTO ".$__settings['dbprefix']."registry VALUES ('showavatars', '1')"; $queries[] = "INSERT INTO ".$__settings['dbprefix']."registry VALUES ('avatardir', '[[softpath]]/avatars')"; $queries[] = "INSERT INTO ".$__settings['dbprefix']."registry VALUES ('avatarurl', '".$__settings['softurl']."/avatars')"; $queries[] = "INSERT INTO ".$__settings['dbprefix']."registry VALUES ('uploadavatardir', '[[softpath]]/uploads/avatars')"; $queries[] = "INSERT INTO ".$__settings['dbprefix']."registry VALUES ('uploadavatarurl', '".$__settings['softurl']."/uploads/avatars')"; $queries[] = "INSERT INTO ".$__settings['dbprefix']."registry VALUES ('uploadavatarmaxsize', '5000')"; $queries[] = "INSERT INTO ".$__settings['dbprefix']."registry VALUES ('avatartypes', 'gif,jpg,png')"; $queries[] = "INSERT INTO ".$__settings['dbprefix']."registry VALUES ('uploadppicdir', '[[softpath]]/uploads/personalpic')"; $queries[] = "INSERT INTO ".$__settings['dbprefix']."registry VALUES ('uploadppicurl', '".$__settings['softurl']."/uploads/personalpic')"; $queries[] = "INSERT INTO ".$__settings['dbprefix']."registry VALUES ('uploadppicmaxsize', '5000')"; $queries[] = "INSERT INTO ".$__settings['dbprefix']."registry VALUES ('ppictypes', 'gif,jpg,png,tiff')"; $queries[] = "INSERT INTO ".$__settings['dbprefix']."registry VALUES ('pmon', '1')"; $queries[] = "INSERT INTO ".$__settings['dbprefix']."registry VALUES ('notifynewpm', '1')"; $queries[] = "INSERT INTO ".$__settings['dbprefix']."registry VALUES ('pmusesmileys', '1')"; $queries[] = "INSERT INTO ".$__settings['dbprefix']."registry VALUES ('pmnumshowinfolders', '50')"; $queries[] = "INSERT INTO ".$__settings['dbprefix']."registry VALUES ('pmsaveinsentitems', '1')"; $queries[] = "INSERT INTO ".$__settings['dbprefix']."registry VALUES ('attachmentmode', '1')"; $queries[] = "INSERT INTO ".$__settings['dbprefix']."registry VALUES ('allownewattachment', '1')"; $queries[] = "INSERT INTO ".$__settings['dbprefix']."registry VALUES ('attachmentdir', '[[softpath]]/uploads/attachments')"; $queries[] = "INSERT INTO ".$__settings['dbprefix']."registry VALUES ('maxattachmentpost', '3')"; $queries[] = "INSERT INTO ".$__settings['dbprefix']."registry VALUES ('maxattachsize', '150')"; $queries[] = "INSERT INTO ".$__settings['dbprefix']."registry VALUES ('maxattachsizepost', '250')"; $queries[] = "INSERT INTO ".$__settings['dbprefix']."registry VALUES ('attachmentshowimage', '1')"; $queries[] = "INSERT INTO ".$__settings['dbprefix']."registry VALUES ('attachmentshowimagemaxwidth', '200')"; $queries[] = "INSERT INTO ".$__settings['dbprefix']."registry VALUES ('attachmentshowimagemaxheight', '200')"; $queries[] = "INSERT INTO ".$__settings['dbprefix']."registry VALUES ('attachmenturl', '".$__settings['softurl']."/uploads/attachments')"; $queries[] = "INSERT INTO ".$__settings['dbprefix']."registry VALUES ('usesmileys', '1')"; $queries[] = "INSERT INTO ".$__settings['dbprefix']."registry VALUES ('maintenance_subject', '')"; $queries[] = "INSERT INTO ".$__settings['dbprefix']."registry VALUES ('maintenance_message', '')"; $queries[] = "INSERT INTO ".$__settings['dbprefix']."registry VALUES ('mail', '1')"; $queries[] = "INSERT INTO ".$__settings['dbprefix']."registry VALUES ('mail_user', '')"; $queries[] = "INSERT INTO ".$__settings['dbprefix']."registry VALUES ('mail_pass', '')"; $queries[] = "INSERT INTO ".$__settings['dbprefix']."registry VALUES ('mail_server', '')"; $queries[] = "INSERT INTO ".$__settings['dbprefix']."registry VALUES ('mail_port', '')"; $queries[] = "INSERT INTO ".$__settings['dbprefix']."registry VALUES ('notifications', '1')"; $queries[] = "INSERT INTO ".$__settings['dbprefix']."registry VALUES ('numsubinpage', '30')"; $queries[] = "INSERT INTO ".$__settings['dbprefix']."registry VALUES ('session_timeout', '3600')"; $queries[] = "INSERT INTO ".$__settings['dbprefix']."registry VALUES ('last_active_span', '15')"; $queries[] = "INSERT INTO ".$__settings['dbprefix']."registry VALUES ('only_users', '0')"; $queries[] = "INSERT INTO ".$__settings['dbprefix']."registry VALUES ('stats', '1')"; $queries[] = "INSERT INTO ".$__settings['dbprefix']."registry VALUES ('memhideemail', '1')"; $queries[] = "INSERT INTO ".$__settings['dbprefix']."registry VALUES ('showmemdetails', '0')"; $queries[] = "INSERT INTO ".$__settings['dbprefix']."registry VALUES ('maxactivelist', '50')"; $queries[] = "INSERT INTO ".$__settings['dbprefix']."registry VALUES ('maxmemberlist', '50')"; $queries[] = "INSERT INTO ".$__settings['dbprefix']."registry VALUES ('theme', 'default')"; $queries[] = "INSERT INTO ".$__settings['dbprefix']."registry VALUES ('theme_id', '1')"; $queries[] = "INSERT INTO ".$__settings['dbprefix']."registry VALUES ('choose_theme', '1')"; $queries[] = "INSERT INTO ".$__settings['dbprefix']."registry VALUES ('version', '1.0.8')"; $queries[] = "INSERT INTO ".$__settings['dbprefix']."registry VALUES ('enablenews', '1')"; $queries[] = "INSERT INTO ".$__settings['dbprefix']."registry VALUES ('enableshoutbox', '0')"; $queries[] = "INSERT INTO ".$__settings['dbprefix']."registry VALUES ('shouts', '10')"; $queries[] = "INSERT INTO ".$__settings['dbprefix']."registry VALUES ('shoutboxtime', '1440')"; $queries[] = "INSERT INTO ".$__settings['dbprefix']."registry VALUES ('countinboardposts', '0')"; $queries[] = "INSERT INTO ".$__settings['dbprefix']."registry VALUES ('subscribeauto', '1')"; $queries[] = "INSERT INTO ".$__settings['dbprefix']."registry VALUES ('enablesig', '1')"; $queries[] = "INSERT INTO ".$__settings['dbprefix']."registry VALUES ('showimgs', '1')"; $queries[] = "INSERT INTO ".$__settings['dbprefix']."registry VALUES ('shoutbox_emot', '1')"; $queries[] = "INSERT INTO ".$__settings['dbprefix']."registry VALUES ('shoutbox_nbbc', '1')"; $queries[] = "INSERT INTO ".$__settings['dbprefix']."registry VALUES ('shoutbox_sbbc', '0')"; $queries[] = "INSERT INTO ".$__settings['dbprefix']."registry VALUES ('language', 'english')"; $queries[] = "INSERT INTO ".$__settings['dbprefix']."registry VALUES ('choose_language', '1')"; $queries[] = "INSERT INTO ".$__settings['dbprefix']."registry VALUES ('smiley_space_boundary', '1')"; $queries[] = "INSERT INTO ".$__settings['dbprefix']."registry VALUES ('users_visited_today', '0')"; $queries[] = "INSERT INTO ".$__settings['dbprefix']."registry VALUES ('av_width', '90')"; $queries[] = "INSERT INTO ".$__settings['dbprefix']."registry VALUES ('av_height', '90')"; $queries[] = "INSERT INTO ".$__settings['dbprefix']."registry VALUES ('ppic_width', '90')"; $queries[] = "INSERT INTO ".$__settings['dbprefix']."registry VALUES ('ppic_height', '90')"; $queries[] = "INSERT INTO ".$__settings['dbprefix']."registry VALUES ('last_posts_reply', '10')"; $queries[] = "INSERT INTO ".$__settings['dbprefix']."registry VALUES ('recent_posts', '8')"; $queries[] = "INSERT INTO ".$__settings['dbprefix']."registry VALUES ('who_read_topic', '0')"; $queries[] = "INSERT INTO ".$__settings['dbprefix']."registry VALUES ('show_groups', '0')"; $queries[] = "INSERT INTO ".$__settings['dbprefix']."registry VALUES ('change_username', '1')"; $queries[] = "INSERT INTO ".$__settings['dbprefix']."registry VALUES ('rss_recent', '10')"; $queries[] = "INSERT INTO ".$__settings['dbprefix']."registry VALUES ('smart_redirect', '1')"; $queries[] = "INSERT INTO ".$__settings['dbprefix']."registry VALUES ('report_posts', '1')";
$queries[] = "INSERT INTO ".$__settings['dbprefix']."registry VALUES ('charset', '".(empty($__settings['utf8']) ? 'ISO-8859-1' : 'UTF-8')."')"; $queries[] = "INSERT INTO ".$__settings['dbprefix']."registry VALUES ('title_in_link', '0')"; $queries[] = "INSERT INTO ".$__settings['dbprefix']."registry VALUES ('seo', '0')"; $queries[] = "INSERT INTO ".$__settings['dbprefix']."registry VALUES ('timezone', '0')"; $queries[] = "INSERT INTO ".$__settings['dbprefix']."registry VALUES ('tickednews', '1')"; $queries[] = "INSERT INTO ".$__settings['dbprefix']."registry VALUES ('todaysnews', '1')"; $queries[] = "INSERT INTO ".$__settings['dbprefix']."registry VALUES ('newsperpage', '12')"; $queries[] = "INSERT INTO ".$__settings['dbprefix']."registry VALUES ('bannedip', '')"; $queries[] = "INSERT INTO ".$__settings['dbprefix']."registry VALUES ('keywords', '')";
//Sessions $queries[] = "CREATE TABLE ".$__settings['dbprefix']."sessions ( sid varchar(32) NOT NULL default '', uid mediumint(8) NOT NULL default '0', time int(12) NOT NULL default '0', data text NOT NULL, ip varchar(20) NOT NULL default '', last_activity tinytext NOT NULL, activity text NOT NULL, viewing_board smallint(5) NOT NULL default '0', viewing_topic mediumint(8) NOT NULL default '0', anonymous tinyint(2) NOT NULL default '0', UNIQUE KEY sid (sid) ) TYPE=MyISAM".(empty($__settings['utf8']) ? '' : " DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci");
//Shouts $queries[] = "CREATE TABLE ".$__settings['dbprefix']."shouts ( shid int(10) NOT NULL auto_increment, shtime int(10) NOT NULL default '0', shuid mediumint(8) NOT NULL default '0', shtext text NOT NULL, PRIMARY KEY (shid) ) TYPE=MyISAM".(empty($__settings['utf8']) ? '' : " DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci");
//Smileys $queries[] = "CREATE TABLE ".$__settings['dbprefix']."smileys ( smid smallint(5) NOT NULL auto_increment, smcode varchar(40) NOT NULL default '', smfile varchar(40) NOT NULL default '', smtitle varchar(40) NOT NULL default '', smorder smallint(5) NOT NULL default '0', smstatus tinyint(2) NOT NULL default '0', smfolder varchar(70) NOT NULL default '', PRIMARY KEY (smid), UNIQUE KEY smcode (smcode), UNIQUE KEY smcode_2 (smcode) ) TYPE=MyISAM".(empty($__settings['utf8']) ? '' : " DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci");