Changeset 1660 in ExiteCMS for trunk/includes/dbsetup_include.php


Ignore:
Timestamp:
08/21/08 16:07:21 (4 years ago)
Author:
hverton
Message:

updated the members list with better filters, and a sort option on username, email, last visit date and country.
Rewritten the setup procedure to make it more fail-safe
Fixed getmxxrr() function, to return the lowest MX record first
Added the compiled locale files for Dutch (setup/global)

File:
1 edited

Legend:

Unmodified
Added
Removed

  • trunk/includes/dbsetup_include.php

    r1502 r1660  
    22//---------------------------------------------------------- 
    33// ExiteCMS file : dbsetup_include.php 
    4 // Date generated  : `02/07/2008 08:40` 
     4// Date generated  : `21/08/2008 15:52` 
    55//---------------------------------------------------------- 
    66 
    77define('CMS_VERSION', '7.10'); 
    8 define('CMS_REVISION', '1500'); 
     8define('CMS_REVISION', '1650'); 
    99 
    1010if ($step == 1) { 
    … …  
    5959    $fail = "1"; 
    6060    $failed[] = "admin : ".mysql_error(); 
     61} else { 
     62    $result = dbquery("INSERT INTO ".$db_prefix."admin (admin_rights, admin_image, admin_title, admin_link, admin_page) VALUES('NF', '404pages.gif', '227', '404pages.php', '1')"); 
     63    $result = dbquery("INSERT INTO ".$db_prefix."admin (admin_rights, admin_image, admin_title, admin_link, admin_page) VALUES('A', 'articles.gif', '203', 'articles.php', '1')"); 
     64    $result = dbquery("INSERT INTO ".$db_prefix."admin (admin_rights, admin_image, admin_title, admin_link, admin_page) VALUES('AC', 'article_cats.gif', '202', 'article_cats.php', '1')"); 
     65    $result = dbquery("INSERT INTO ".$db_prefix."admin (admin_rights, admin_image, admin_title, admin_link, admin_page) VALUES('BG', 'blogs.gif', '226', 'blogs.php', '1')"); 
     66    $result = dbquery("INSERT INTO ".$db_prefix."admin (admin_rights, admin_image, admin_title, admin_link, admin_page) VALUES('CP', 'c-pages.gif', '206', 'custom_pages.php', '1')"); 
     67    $result = dbquery("INSERT INTO ".$db_prefix."admin (admin_rights, admin_image, admin_title, admin_link, admin_page) VALUES('D', 'dl.gif', '209', 'downloads.php', '1')"); 
     68    $result = dbquery("INSERT INTO ".$db_prefix."admin (admin_rights, admin_image, admin_title, admin_link, admin_page) VALUES('DC', 'dl_cats.gif', '208', 'download_cats.php', '1')"); 
     69    $result = dbquery("INSERT INTO ".$db_prefix."admin (admin_rights, admin_image, admin_title, admin_link, admin_page) VALUES('FQ', 'faq.gif', '210', 'faq.php', '1')"); 
     70    $result = dbquery("INSERT INTO ".$db_prefix."admin (admin_rights, admin_image, admin_title, admin_link, admin_page) VALUES('F', 'forums.gif', '211', 'forums.php', '1')"); 
     71    $result = dbquery("INSERT INTO ".$db_prefix."admin (admin_rights, admin_image, admin_title, admin_link, admin_page) VALUES('PO', 'polls.gif', '220', 'forum_polls.php', '1')"); 
     72    $result = dbquery("INSERT INTO ".$db_prefix."admin (admin_rights, admin_image, admin_title, admin_link, admin_page) VALUES('N', 'frontpage.gif', '239', 'frontpage.php', '1')"); 
     73    $result = dbquery("INSERT INTO ".$db_prefix."admin (admin_rights, admin_image, admin_title, admin_link, admin_page) VALUES('IM', 'images.gif', '212', 'images.php', '1')"); 
     74    $result = dbquery("INSERT INTO ".$db_prefix."admin (admin_rights, admin_image, admin_title, admin_link, admin_page) VALUES('N', 'news.gif', '216', 'news.php', '1')"); 
     75    $result = dbquery("INSERT INTO ".$db_prefix."admin (admin_rights, admin_image, admin_title, admin_link, admin_page) VALUES('NC', 'news_cats.gif', '235', 'news_cats.php', '1')"); 
     76    $result = dbquery("INSERT INTO ".$db_prefix."admin (admin_rights, admin_image, admin_title, admin_link, admin_page) VALUES('FR', 'ranking.gif', '238', 'ranking.php', '1')"); 
     77    $result = dbquery("INSERT INTO ".$db_prefix."admin (admin_rights, admin_image, admin_title, admin_link, admin_page) VALUES('UR', 'submissions.gif', '218', 'redirects.php', '1')"); 
     78    $result = dbquery("INSERT INTO ".$db_prefix."admin (admin_rights, admin_image, admin_title, admin_link, admin_page) VALUES('UA', 'activation.gif', '221', 'activation.php', '2')"); 
     79    $result = dbquery("INSERT INTO ".$db_prefix."admin (admin_rights, admin_image, admin_title, admin_link, admin_page) VALUES('AD', 'admins.gif', '201', 'administrators.php', '2')"); 
     80    $result = dbquery("INSERT INTO ".$db_prefix."admin (admin_rights, admin_image, admin_title, admin_link, admin_page) VALUES('B', 'blacklist.gif', '204', 'blacklist.php', '2')"); 
     81    $result = dbquery("INSERT INTO ".$db_prefix."admin (admin_rights, admin_image, admin_title, admin_link, admin_page) VALUES('M', 'members.gif', '215', 'members.php', '2')"); 
     82    $result = dbquery("INSERT INTO ".$db_prefix."admin (admin_rights, admin_image, admin_title, admin_link, admin_page) VALUES('UG', 'user_groups.gif', '225', 'user_groups.php', '2')"); 
     83    $result = dbquery("INSERT INTO ".$db_prefix."admin (admin_rights, admin_image, admin_title, admin_link, admin_page) VALUES('DB', 'db_backup.gif', '207', 'db_backup.php', '3')"); 
     84    $result = dbquery("INSERT INTO ".$db_prefix."admin (admin_rights, admin_image, admin_title, admin_link, admin_page) VALUES('I', 'modules.gif', '213', 'modules.php', '3')"); 
     85    $result = dbquery("INSERT INTO ".$db_prefix."admin (admin_rights, admin_image, admin_title, admin_link, admin_page) VALUES('P', 'panels.gif', '217', 'panels.php', '3')"); 
     86    $result = dbquery("INSERT INTO ".$db_prefix."admin (admin_rights, admin_image, admin_title, admin_link, admin_page) VALUES('PI', 'phpinfo.gif', '219', 'phpinfo.php', '3')"); 
     87    $result = dbquery("INSERT INTO ".$db_prefix."admin (admin_rights, admin_image, admin_title, admin_link, admin_page) VALUES('R', 'reports.gif', '256', 'reports.php', '3')"); 
     88    $result = dbquery("INSERT INTO ".$db_prefix."admin (admin_rights, admin_image, admin_title, admin_link, admin_page) VALUES('S', 'searches.gif', '260', 'search.php', '3')"); 
     89    $result = dbquery("INSERT INTO ".$db_prefix."admin (admin_rights, admin_image, admin_title, admin_link, admin_page) VALUES('S3', 'settings_forum.gif', '230', 'settings_forum.php', '3')"); 
     90    $result = dbquery("INSERT INTO ".$db_prefix."admin (admin_rights, admin_image, admin_title, admin_link, admin_page) VALUES('S8', 'settings_lang.gif', '236', 'settings_languages.php', '3')"); 
     91    $result = dbquery("INSERT INTO ".$db_prefix."admin (admin_rights, admin_image, admin_title, admin_link, admin_page) VALUES('S1', 'settings.gif', '228', 'settings_main.php', '3')"); 
     92    $result = dbquery("INSERT INTO ".$db_prefix."admin (admin_rights, admin_image, admin_title, admin_link, admin_page) VALUES('S7', 'settings_pm.gif', '234', 'settings_messages.php', '3')"); 
     93    $result = dbquery("INSERT INTO ".$db_prefix."admin (admin_rights, admin_image, admin_title, admin_link, admin_page) VALUES('S6', 'settings_misc.gif', '233', 'settings_misc.php', '3')"); 
     94    $result = dbquery("INSERT INTO ".$db_prefix."admin (admin_rights, admin_image, admin_title, admin_link, admin_page) VALUES('S4', 'security.gif', '231', 'settings_security.php', '3')"); 
     95    $result = dbquery("INSERT INTO ".$db_prefix."admin (admin_rights, admin_image, admin_title, admin_link, admin_page) VALUES('S2', 'settings_time.gif', '229', 'settings_time.php', '3')"); 
     96    $result = dbquery("INSERT INTO ".$db_prefix."admin (admin_rights, admin_image, admin_title, admin_link, admin_page) VALUES('SL', 'site_links.gif', '222', 'site_links.php', '3')"); 
     97    $result = dbquery("INSERT INTO ".$db_prefix."admin (admin_rights, admin_image, admin_title, admin_link, admin_page) VALUES('T', 'tools.gif', '223', 'tools.php', '3')"); 
     98    $result = dbquery("INSERT INTO ".$db_prefix."admin (admin_rights, admin_image, admin_title, admin_link, admin_page) VALUES('U', 'upgrade.gif', '224', 'upgrade.php', '3')"); 
    6199} 
    62100 
    … …  
    195233} else { 
    196234    $result = dbquery("INSERT INTO ".$db_prefix."configuration (cfg_name, cfg_value) VALUES('admin_activation', '0')"); 
    197     $result = dbquery("INSERT INTO ".$db_prefix."configuration (cfg_name, cfg_value) VALUES('article_localisation', 'none')"); 
     235    $result = dbquery("INSERT INTO ".$db_prefix."configuration (cfg_name, cfg_value) VALUES('article_localisation', 'multiple')"); 
    198236    $result = dbquery("INSERT INTO ".$db_prefix."configuration (cfg_name, cfg_value) VALUES('attachmax', '10485760')"); 
    199237    $result = dbquery("INSERT INTO ".$db_prefix."configuration (cfg_name, cfg_value) VALUES('attachments', '1')"); 
    200     $result = dbquery("INSERT INTO ".$db_prefix."configuration (cfg_name, cfg_value) VALUES('attachtypes', '.exe,.com,.bat,.js,.htm,.html,.shtml,.php,.php3')"); 
     238    $result = dbquery("INSERT INTO ".$db_prefix."configuration (cfg_name, cfg_value) VALUES('attachtypes', '.exe,.com,.bat,.js,.htm,.html,.shtml,.php,.php3,.esml,.psd,.mvi')"); 
     239    $result = dbquery("INSERT INTO ".$db_prefix."configuration (cfg_name, cfg_value) VALUES('auth_ad_basedn', '')"); 
     240    $result = dbquery("INSERT INTO ".$db_prefix."configuration (cfg_name, cfg_value) VALUES('auth_ad_suffix', '')"); 
     241    $result = dbquery("INSERT INTO ".$db_prefix."configuration (cfg_name, cfg_value) VALUES('auth_ldap_basedn', '')"); 
     242    $result = dbquery("INSERT INTO ".$db_prefix."configuration (cfg_name, cfg_value) VALUES('auth_ldap_suffix', '')"); 
     243    $result = dbquery("INSERT INTO ".$db_prefix."configuration (cfg_name, cfg_value) VALUES('auth_type', 'local,openid')"); 
    201244    $result = dbquery("INSERT INTO ".$db_prefix."configuration (cfg_name, cfg_value) VALUES('bad_words', '')"); 
    202245    $result = dbquery("INSERT INTO ".$db_prefix."configuration (cfg_name, cfg_value) VALUES('bad_words_enabled', '0')"); 
    … …  
    204247    $result = dbquery("INSERT INTO ".$db_prefix."configuration (cfg_name, cfg_value) VALUES('blogs_indexage', '90')"); 
    205248    $result = dbquery("INSERT INTO ".$db_prefix."configuration (cfg_name, cfg_value) VALUES('blogs_indexsize', '5')"); 
    206     $result = dbquery("INSERT INTO ".$db_prefix."configuration (cfg_name, cfg_value) VALUES('counter', '0')"); 
    207     $result = dbquery("INSERT INTO ".$db_prefix."configuration (cfg_name, cfg_value) VALUES('country', 'us')"); 
     249    $result = dbquery("INSERT INTO ".$db_prefix."configuration (cfg_name, cfg_value) VALUES('browserlang', '1')"); 
     250    $result = dbquery("INSERT INTO ".$db_prefix."configuration (cfg_name, cfg_value) VALUES('counter', '895')"); 
     251    $result = dbquery("INSERT INTO ".$db_prefix."configuration (cfg_name, cfg_value) VALUES('country', 'nl')"); 
     252    $result = dbquery("INSERT INTO ".$db_prefix."configuration (cfg_name, cfg_value) VALUES('debug_php_errors', '1')"); 
    208253    $result = dbquery("INSERT INTO ".$db_prefix."configuration (cfg_name, cfg_value) VALUES('debug_querylog', '')"); 
    209254    $result = dbquery("INSERT INTO ".$db_prefix."configuration (cfg_name, cfg_value) VALUES('debug_sql_explain', '1')"); 
    210     $result = dbquery("INSERT INTO ".$db_prefix."configuration (cfg_name, cfg_value) VALUES('description', 'ExiteCMS, a light-weight CMS system, written in PHP, and using MySQL and the Smarty template engine')"); 
     255    $result = dbquery("INSERT INTO ".$db_prefix."configuration (cfg_name, cfg_value) VALUES('description', 'ExiteCMS, a light-weight CMS system, wriiten in PHP, and using MySQL and the Smarty template engine')"); 
    211256    $result = dbquery("INSERT INTO ".$db_prefix."configuration (cfg_name, cfg_value) VALUES('display_validation', '1')"); 
    212257    $result = dbquery("INSERT INTO ".$db_prefix."configuration (cfg_name, cfg_value) VALUES('download_columns', '1')"); 
    213     $result = dbquery("INSERT INTO ".$db_prefix."configuration (cfg_name, cfg_value) VALUES('download_localisation', 'none')"); 
     258    $result = dbquery("INSERT INTO ".$db_prefix."configuration (cfg_name, cfg_value) VALUES('download_localisation', 'multiple')"); 
    214259    $result = dbquery("INSERT INTO ".$db_prefix."configuration (cfg_name, cfg_value) VALUES('email_verification', '1')"); 
    215260    $result = dbquery("INSERT INTO ".$db_prefix."configuration (cfg_name, cfg_value) VALUES('enable_registration', '1')"); 
    … …  
    220265    $result = dbquery("INSERT INTO ".$db_prefix."configuration (cfg_name, cfg_value) VALUES('forum_edit_timeout', '1')"); 
    221266    $result = dbquery("INSERT INTO ".$db_prefix."configuration (cfg_name, cfg_value) VALUES('forum_flags', '1')"); 
     267    $result = dbquery("INSERT INTO ".$db_prefix."configuration (cfg_name, cfg_value) VALUES('forum_guest_limit', '30')"); 
    222268    $result = dbquery("INSERT INTO ".$db_prefix."configuration (cfg_name, cfg_value) VALUES('forum_max_h', '600')"); 
    223269    $result = dbquery("INSERT INTO ".$db_prefix."configuration (cfg_name, cfg_value) VALUES('forum_max_w', '600')"); 
    224270    $result = dbquery("INSERT INTO ".$db_prefix."configuration (cfg_name, cfg_value) VALUES('guestposts', '1')"); 
    225271    $result = dbquery("INSERT INTO ".$db_prefix."configuration (cfg_name, cfg_value) VALUES('hide_webmaster', '0')"); 
     272    $result = dbquery("INSERT INTO ".$db_prefix."configuration (cfg_name, cfg_value) VALUES('hoteditor_enabled', '1')"); 
    226273    $result = dbquery("INSERT INTO ".$db_prefix."configuration (cfg_name, cfg_value) VALUES('keywords', 'ExiteCMS, CMS, Smarty, MySQL, PHP, Open-Source')"); 
    227274    $result = dbquery("INSERT INTO ".$db_prefix."configuration (cfg_name, cfg_value) VALUES('locale', 'English')"); 
    228275    $result = dbquery("INSERT INTO ".$db_prefix."configuration (cfg_name, cfg_value) VALUES('login_expire', '7200')"); 
    229     $result = dbquery("INSERT INTO ".$db_prefix."configuration (cfg_name, cfg_value) VALUES('login_extended_expire', '84600')"); 
     276    $result = dbquery("INSERT INTO ".$db_prefix."configuration (cfg_name, cfg_value) VALUES('login_extended_expire', '604800')"); 
    230277    $result = dbquery("INSERT INTO ".$db_prefix."configuration (cfg_name, cfg_value) VALUES('longdate', '%m/%d/%Y %H:%M:%S')"); 
    231278    $result = dbquery("INSERT INTO ".$db_prefix."configuration (cfg_name, cfg_value) VALUES('maintenance', '0')"); 
    232279    $result = dbquery("INSERT INTO ".$db_prefix."configuration (cfg_name, cfg_value) VALUES('maintenance_color', '#83AF83')"); 
    233     $result = dbquery("INSERT INTO ".$db_prefix."configuration (cfg_name, cfg_value) VALUES('maintenance_message', '')"); 
    234     $result = dbquery("INSERT INTO ".$db_prefix."configuration (cfg_name, cfg_value) VALUES('max_users', '0')"); 
    235     $result = dbquery("INSERT INTO ".$db_prefix."configuration (cfg_name, cfg_value) VALUES('max_users_datestamp', '0')"); 
     280    $result = dbquery("INSERT INTO ".$db_prefix."configuration (cfg_name, cfg_value) VALUES('maintenance_message', 'Maintenance Mode Test')"); 
     281    $result = dbquery("INSERT INTO ".$db_prefix."configuration (cfg_name, cfg_value) VALUES('max_users', '5')"); 
     282    $result = dbquery("INSERT INTO ".$db_prefix."configuration (cfg_name, cfg_value) VALUES('max_users_datestamp', '1193029685')"); 
    236283    $result = dbquery("INSERT INTO ".$db_prefix."configuration (cfg_name, cfg_value) VALUES('navbar_range', '5')"); 
    237     $result = dbquery("INSERT INTO ".$db_prefix."configuration (cfg_name, cfg_value) VALUES('newsletter_email', 'noreply@example.com')"); 
     284    $result = dbquery("INSERT INTO ".$db_prefix."configuration (cfg_name, cfg_value) VALUES('newsletter_email', 'noreply@exite.eu')"); 
    238285    $result = dbquery("INSERT INTO ".$db_prefix."configuration (cfg_name, cfg_value) VALUES('news_columns', '1')"); 
    239     $result = dbquery("INSERT INTO ".$db_prefix."configuration (cfg_name, cfg_value) VALUES('news_headline', '1')"); 
    240     $result = dbquery("INSERT INTO ".$db_prefix."configuration (cfg_name, cfg_value) VALUES('news_items', '3')"); 
    241     $result = dbquery("INSERT INTO ".$db_prefix."configuration (cfg_name, cfg_value) VALUES('news_latest', '0')"); 
    242     $result = dbquery("INSERT INTO ".$db_prefix."configuration (cfg_name, cfg_value) VALUES('news_localisation', 'none')"); 
     286    $result = dbquery("INSERT INTO ".$db_prefix."configuration (cfg_name, cfg_value) VALUES('news_headline', '2')"); 
     287    $result = dbquery("INSERT INTO ".$db_prefix."configuration (cfg_name, cfg_value) VALUES('news_items', '6')"); 
     288    $result = dbquery("INSERT INTO ".$db_prefix."configuration (cfg_name, cfg_value) VALUES('news_latest', '1')"); 
     289    $result = dbquery("INSERT INTO ".$db_prefix."configuration (cfg_name, cfg_value) VALUES('news_localisation', 'multiple')"); 
    243290    $result = dbquery("INSERT INTO ".$db_prefix."configuration (cfg_name, cfg_value) VALUES('numofshouts', '5')"); 
    244291    $result = dbquery("INSERT INTO ".$db_prefix."configuration (cfg_name, cfg_value) VALUES('numofthreads', '20')"); 
    245292    $result = dbquery("INSERT INTO ".$db_prefix."configuration (cfg_name, cfg_value) VALUES('opening_page', 'news.php')"); 
    246     $result = dbquery("INSERT INTO ".$db_prefix."configuration (cfg_name, cfg_value) VALUES('panels_localisation', 'none')"); 
     293    $result = dbquery("INSERT INTO ".$db_prefix."configuration (cfg_name, cfg_value) VALUES('panels_localisation', 'multiple')"); 
    247294    $result = dbquery("INSERT INTO ".$db_prefix."configuration (cfg_name, cfg_value) VALUES('photo_h', '300')"); 
    248295    $result = dbquery("INSERT INTO ".$db_prefix."configuration (cfg_name, cfg_value) VALUES('photo_max_b', '150000')"); 
    … …  
    258305    $result = dbquery("INSERT INTO ".$db_prefix."configuration (cfg_name, cfg_value) VALUES('pm_sentbox', '25')"); 
    259306    $result = dbquery("INSERT INTO ".$db_prefix."configuration (cfg_name, cfg_value) VALUES('pm_sentbox_group', '103')"); 
    260     $result = dbquery("INSERT INTO ".$db_prefix."configuration (cfg_name, cfg_value) VALUES('revision', '1500')"); 
     307    $result = dbquery("INSERT INTO ".$db_prefix."configuration (cfg_name, cfg_value) VALUES('revision', '1650')"); 
    261308    $result = dbquery("INSERT INTO ".$db_prefix."configuration (cfg_name, cfg_value) VALUES('session_gc_divisor', '100')"); 
    262309    $result = dbquery("INSERT INTO ".$db_prefix."configuration (cfg_name, cfg_value) VALUES('session_gc_maxlifetime', '604800')"); 
    … …  
    264311    $result = dbquery("INSERT INTO ".$db_prefix."configuration (cfg_name, cfg_value) VALUES('session_name', 'ExiteCMSid')"); 
    265312    $result = dbquery("INSERT INTO ".$db_prefix."configuration (cfg_name, cfg_value) VALUES('shortdate', '%m/%d/%Y')"); 
    266     $result = dbquery("INSERT INTO ".$db_prefix."configuration (cfg_name, cfg_value) VALUES('siteemail', 'website@example.com')"); 
    267     $result = dbquery("INSERT INTO ".$db_prefix."configuration (cfg_name, cfg_value) VALUES('siteintro', '<center>\r\n<b>This website is under construction at the moment!</b><br /><br />\r\nExiteCMS v7.2 ©2008 Exite BV.</center>')"); 
    268     $result = dbquery("INSERT INTO ".$db_prefix."configuration (cfg_name, cfg_value) VALUES('sitelinks_localisation', 'none')"); 
    269     $result = dbquery("INSERT INTO ".$db_prefix."configuration (cfg_name, cfg_value) VALUES('sitename', 'ExiteCMS Website')"); 
     313    $result = dbquery("INSERT INTO ".$db_prefix."configuration (cfg_name, cfg_value) VALUES('siteemail', 'exitecms@exite.eu')"); 
     314    $result = dbquery("INSERT INTO ".$db_prefix."configuration (cfg_name, cfg_value) VALUES('siteintro', '<center>\r\n<b>This website is under construction at the moment!</b><br /><br />We are currently preparing the release of version 7.0. The release date has been set for October 27th, providing no last-minute showstoppers pop up.<br /><br />\r\nExiteCMS v7.0 ©2007 Exite BV.</center>')"); 
     315    $result = dbquery("INSERT INTO ".$db_prefix."configuration (cfg_name, cfg_value) VALUES('sitelinks_localisation', 'multiple')"); 
     316    $result = dbquery("INSERT INTO ".$db_prefix."configuration (cfg_name, cfg_value) VALUES('sitename', 'ExiteCMS Support Site')"); 
    270317    $result = dbquery("INSERT INTO ".$db_prefix."configuration (cfg_name, cfg_value) VALUES('siteurl', '/')"); 
    271318    $result = dbquery("INSERT INTO ".$db_prefix."configuration (cfg_name, cfg_value) VALUES('siteusername', 'webmaster')"); 
    … …  
    342389  `download_version` varchar(50) NOT NULL default '', 
    343390  `download_filesize` varchar(20) NOT NULL default '', 
    344   `download_bar` tinyint(1) unsigned NOT NULL default 0, 
    345391  `download_datestamp` int(10) unsigned NOT NULL default 0, 
    346392  `download_count` smallint(5) unsigned NOT NULL default 0, 
     393  `download_external` tinyint(1) NOT NULL default 0, 
    347394  PRIMARY KEY  (`download_id`) 
    348395) ENGINE=MyISAM;"); 
    … …  
    411458  `attach_count` mediumint(8) unsigned NOT NULL default 0, 
    412459  PRIMARY KEY  (`attach_id`), 
    413   KEY `post_id` (`post_id`) 
     460  KEY `post_id` (`post_id`), 
     461  FULLTEXT KEY `attach_realname` (`attach_realname`), 
     462  FULLTEXT KEY `attach_comment` (`attach_comment`) 
    414463) ENGINE=MyISAM;"); 
    415464if (!$result) { 
    … …  
    628677  `news_breaks` char(1) NOT NULL default 'n', 
    629678  `news_name` mediumint(8) unsigned NOT NULL default 1, 
     679  `news_locale` varchar(8) NOT NULL default '', 
    630680  `news_datestamp` int(10) unsigned NOT NULL default 0, 
    631681  `news_start` int(10) unsigned NOT NULL default 0, 
    … …  
    633683  `news_visibility` tinyint(3) unsigned NOT NULL default 0, 
    634684  `news_reads` smallint(5) unsigned NOT NULL default 0, 
    635   `news_headline` tinyint(1) unsigned NOT NULL default 0, 
    636   `news_latest_news` tinyint(3) unsigned NOT NULL default 0, 
    637685  `news_allow_comments` tinyint(1) unsigned NOT NULL default 1, 
    638686  `news_allow_ratings` tinyint(1) unsigned NOT NULL default 1, 
    639   PRIMARY KEY  (`news_id`) 
     687  PRIMARY KEY  (`news_id`), 
     688  FULLTEXT KEY `news_subject` (`news_subject`), 
     689  FULLTEXT KEY `news_news` (`news_news`), 
     690  FULLTEXT KEY `news_extended` (`news_extended`) 
    640691) ENGINE=MyISAM;"); 
    641692if (!$result) { 
    … …  
    657708    $fail = "1"; 
    658709    $failed[] = "news_cats : ".mysql_error(); 
     710} 
     711 
     712// 
     713// Code to create table `news_frontpage` 
     714// 
     715$result = dbquery("DROP TABLE IF EXISTS ".$db_prefix."news_frontpage"); 
     716$result = dbquery("CREATE TABLE IF NOT EXISTS ".$db_prefix."news_frontpage ( 
     717  `frontpage_id` smallint(5) unsigned NOT NULL auto_increment, 
     718  `frontpage_locale` varchar(8) NOT NULL default '', 
     719  `frontpage_headline` tinyint(1) unsigned NOT NULL default 0, 
     720  `frontpage_order` smallint(5) unsigned NOT NULL default 0, 
     721  `frontpage_news_id` smallint(5) unsigned NOT NULL default 0, 
     722  PRIMARY KEY  (`frontpage_id`) 
     723) ENGINE=MyISAM;"); 
     724if (!$result) { 
     725    $fail = "1"; 
     726    $failed[] = "news_frontpage : ".mysql_error(); 
    659727} 
    660728 
    … …  
    805873  KEY `thread_id` (`thread_id`), 
    806874  KEY `post_datestamp` (`post_datestamp`), 
    807   KEY `post_edittime` (`post_edittime`) 
     875  KEY `post_edittime` (`post_edittime`), 
     876  FULLTEXT KEY `subject_message` (`post_subject`,`post_message`) 
    808877) ENGINE=MyISAM;"); 
    809878if (!$result) { 
    … …  
    855924  `report_id` smallint(5) unsigned NOT NULL auto_increment, 
    856925  `report_mod_id` smallint(5) unsigned NOT NULL default 0, 
     926  `report_mod_core` tinyint(1) unsigned NOT NULL default 0, 
    857927  `report_name` varchar(100) NOT NULL default '', 
    858928  `report_title` varchar(100) NOT NULL default '', 
    … …  
    868938 
    869939// 
    870 // Code to create table `searches` 
    871 // 
    872 $result = dbquery("DROP TABLE IF EXISTS ".$db_prefix."searches"); 
    873 $result = dbquery("CREATE TABLE IF NOT EXISTS ".$db_prefix."searches ( 
     940// Code to create table `search` 
     941// 
     942$result = dbquery("DROP TABLE IF EXISTS ".$db_prefix."search"); 
     943$result = dbquery("CREATE TABLE IF NOT EXISTS ".$db_prefix."search ( 
    874944  `search_id` smallint(5) unsigned NOT NULL auto_increment, 
    875945  `search_mod_id` smallint(5) unsigned NOT NULL default 0, 
     946  `search_mod_core` tinyint(1) unsigned NOT NULL default 0, 
    876947  `search_name` varchar(100) NOT NULL default '', 
    877948  `search_title` varchar(100) NOT NULL default '', 
     949  `search_fulltext` tinyint(1) unsigned NOT NULL default 0, 
    878950  `search_version` varchar(10) NOT NULL default '0', 
     951  `search_active` tinyint(1) unsigned NOT NULL default 0, 
    879952  `search_visibility` tinyint(3) NOT NULL default 0, 
    880953  PRIMARY KEY  (`search_id`) 
    … …  
    882955if (!$result) { 
    883956    $fail = "1"; 
    884     $failed[] = "searches : ".mysql_error(); 
     957    $failed[] = "search : ".mysql_error(); 
    885958} 
    886959 
    … …  
    10171090  `user_location` varchar(50) NOT NULL default '', 
    10181091  `user_birthdate` date NOT NULL default '0000-00-00', 
     1092  `user_gender` enum('M','F','') NOT NULL default '', 
    10191093  `user_aim` varchar(16) NOT NULL default '', 
    10201094  `user_icq` varchar(15) NOT NULL default '', 
    … …  
    10431117  `user_posts_unread` tinyint(1) NOT NULL default 1, 
    10441118  `user_cc_code` char(2) NOT NULL default '', 
     1119  `user_openid_url` varchar(255) NOT NULL default '', 
     1120  `user_hoteditor` tinyint(1) unsigned NOT NULL default 1, 
    10451121  PRIMARY KEY  (`user_id`) 
    10461122) ENGINE=MyISAM;"); 
Note: See TracChangeset for help on using the changeset viewer.