<?php /*************************************************************************** * install_kb_tables.php * ------------------- * begin ]eric@egcnetwork.com[/url] > (Eric Faerber) - [url=http://eric.best-1.biz/]http://eric.best-1.biz/[/url], now supervised by _Haplo < [url=http://www.mx-system.com/]http://www.mx-system.com/[/url] rnrnBe sure you add categories and article types in the ACP and also change the Configuration to your liking.rnrnHave fun and enjoy your new Knowledge Base! :D", 1, 1, 0, 0,0,0 );'; $sql[] = 'CREATE TABLE '.KB_CATEGORIES_TABLE.' ( category_id mediumint(8) unsigned NOT NULL auto_increment, category_name VARCHAR(255) binary NOT NULL, category_details VARCHAR(255) binary NOT NULL, number_articles mediumint(8) unsigned NOT NULL, parent mediumint(8) unsigned, cat_order mediumint(8) unsigned NOT NULL, auth_view tinyint(3) NOT NULL DEFAULT "0", auth_post tinyint(3) NOT NULL DEFAULT "0", auth_rate tinyint(3) NOT NULL DEFAULT "0", auth_comment tinyint(3) NOT NULL DEFAULT "0", auth_edit tinyint(3) NOT NULL DEFAULT "0", auth_delete tinyint(3) NOT NULL DEFAULT "2", auth_approval tinyint(3) NOT NULL DEFAULT "0", auth_approval_edit tinyint(3) NOT NULL DEFAULT "0", auth_view_groups varchar(255), auth_post_groups varchar(255), auth_rate_groups varchar(255), auth_comment_groups varchar(255), auth_edit_groups varchar(255), auth_delete_groups varchar(255), auth_approval_groups varchar(255), auth_approval_edit_groups varchar(255), auth_moderator_groups varchar(255), comments_forum_id tinyint(3) NOT NULL DEFAULT "-1", KEY category_id (category_id) ) TYPE=MyISAM'; $sql[] = 'INSERT INTO '.KB_CATEGORIES_TABLE.' VALUES (1, "Test Category 1", "This is a test category", "0", "0", "10", "0", "0", "0", "0", "0", "2", "0", "0", "", "", "", "", "", "", "", "", "", "0" );'; $sql[] = 'CREATE TABLE '.KB_CONFIG_TABLE.' ( config_name VARCHAR(255) NOT NULL default "", config_value varchar(255) NOT NULL default "", PRIMARY KEY (config_name) ) TYPE=MyISAM'; $sql[] = 'INSERT INTO '.KB_CONFIG_TABLE.' (config_name, config_value) VALUES ("allow_new", "1")'; $sql[] = 'INSERT INTO '.KB_CONFIG_TABLE.' (config_name, config_value) VALUES ("notify", "1")'; $sql[] = 'INSERT INTO '.KB_CONFIG_TABLE.' (config_name, config_value) VALUES ("admin_id", "2")'; $sql[] = 'INSERT INTO '.KB_CONFIG_TABLE.' (config_name, config_value) values("show_pretext",0);'; $sql[] = 'INSERT INTO '.KB_CONFIG_TABLE.' (config_name, config_value) values("pt_header","Article Submission Instructions");'; $sql[] = 'INSERT INTO '.KB_CONFIG_TABLE.' (config_name, config_value) values("pt_body","Please check your references and include as much information as you can.");'; $sql[] = 'INSERT INTO '.KB_CONFIG_TABLE.' (config_name, config_value) VALUES ("use_comments", "1");'; $sql[] = 'INSERT INTO '.KB_CONFIG_TABLE.' (config_name, config_value) VALUES ("del_topic", "1");'; $sql[] = 'INSERT INTO '.KB_CONFIG_TABLE.' (config_name, config_value) VALUES ("use_ratings", "0");'; $sql[] = 'INSERT INTO '.KB_CONFIG_TABLE.' (config_name, config_value) VALUES ("comments_show", "1");'; $sql[] = 'INSERT INTO '.KB_CONFIG_TABLE.' (config_name, config_value) VALUES ("bump_post", "1");'; $sql[] = 'INSERT INTO '.KB_CONFIG_TABLE.' (config_name, config_value) VALUES ("stats_list", "1");'; $sql[] = 'INSERT INTO '.KB_CONFIG_TABLE.' (config_name, config_value) VALUES ("header_banner", "1");'; $sql[] = 'INSERT INTO '.KB_CONFIG_TABLE.' (config_name, config_value) VALUES ("votes_check_userid", "1");'; $sql[] = 'INSERT INTO '.KB_CONFIG_TABLE.' (config_name, config_value) VALUES ("votes_check_ip", "1");'; $sql[] = 'INSERT INTO '.KB_CONFIG_TABLE.' (config_name, config_value) VALUES ("art_pagination", "5");'; $sql[] = 'INSERT INTO '.KB_CONFIG_TABLE.' (config_name, config_value) VALUES ("comments_pagination", "5");'; $sql[] = 'INSERT INTO '.KB_CONFIG_TABLE.' (config_name, config_value) VALUES ("news_sort", "Alphabetic");'; $sql[] = 'INSERT INTO '.KB_CONFIG_TABLE.' (config_name, config_value) VALUES ("news_sort_par", "ASC");'; $sql[] = 'INSERT INTO '.KB_CONFIG_TABLE.' (config_name, config_value) VALUES ("wysiwyg", "0");'; $sql[] = 'INSERT INTO '.KB_CONFIG_TABLE.' (config_name, config_value) VALUES ("wysiwyg_path", "modules/");'; $sql[] = 'INSERT INTO '.KB_CONFIG_TABLE.' (config_name, config_value) VALUES ("allow_html", "1");'; $sql[] = 'INSERT INTO '.KB_CONFIG_TABLE.' (config_name, config_value) VALUES ("allow_bbcode", "1");'; $sql[] = 'INSERT INTO '.KB_CONFIG_TABLE.' (config_name, config_value) VALUES ("allow_smilies", "1");'; $sql[] = 'INSERT INTO '.KB_CONFIG_TABLE.' (config_name, config_value) VALUES ("formatting_fixup", "0");'; $sql[] = 'INSERT INTO '.KB_CONFIG_TABLE.' (config_name, config_value) VALUES ("allowed_html_tags", "b,i,u,a");'; $sql[] = 'CREATE TABLE ' . KB_TYPES_TABLE . ' ( id mediumint(8) unsigned NOT NULL auto_increment, type varchar(255) binary DEFAULT "" NOT NULL, KEY id (id) ) TYPE=MyISAM'; $sql[] = 'INSERT INTO '. KB_TYPES_TABLE . ' VALUES (1, "Test Type 1")'; $sql[] = 'CREATE TABLE '. KB_VOTES_TABLE . ' ( votes_ip varchar(50) NOT NULL default "0", votes_userid int(50) NOT NULL default "0", votes_file int(50) NOT NULL default "0" ) TYPE=MyISAM'; $sql[] = 'CREATE TABLE ' . KB_SEARCH_TABLE . ' ( search_id int(11) unsigned NOT NULL default "0", session_id varchar(32) NOT NULL default "", search_array text NOT NULL, PRIMARY KEY (search_id), KEY session_id (session_id) ) TYPE=MyISAM;'; $sql[] = 'CREATE TABLE ' . KB_WORD_TABLE . ' ( word_text varchar(50) binary 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) ) TYPE=MyISAM;'; $sql[] = 'CREATE TABLE ' . KB_MATCH_TABLE . ' ( article_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 post_id (article_id), KEY word_id (word_id) ) TYPE=MyISAM;'; $sql[] = 'CREATE TABLE ' . KB_CUSTOM_TABLE . ' ( custom_id int(50) NOT NULL auto_increment, custom_name text NOT NULL, custom_description text NOT NULL, data text NOT NULL, field_order int(20) NOT NULL default "0", field_type tinyint(2) NOT NULL default "0", regex varchar(255) NOT NULL default "", PRIMARY KEY (custom_id) ) TYPE=MyISAM;'; $sql[] = 'CREATE TABLE ' . KB_CUSTOM_DATA_TABLE . ' ( customdata_file int(50) NOT NULL default "0", customdata_custom int(50) NOT NULL default "0", data text NOT NULL ) TYPE=MyISAM;'; break; case 'mssql': case 'mssql-odbc': default: die("/! No Database Abstraction Layer (DBAL) found /!\"); break; } echo("<h2>Adding/modifying tables to your database</h2>n"); for ($i=0; $i <count>sql_query($sql[$i])) ) { $error_code = TRUE; $error = $db->sql_error(); echo(" -> <b><span>ERROR - QUERY FAILED</span></b> ----> <u>" . $error['message'] . "</u><br><br>nn"); } else { echo(" -> <b><span>GOOD - QUERY OK</span></b><br><br>nn"); } } $error_message = ""; if ( $error_code ) { $error_message .= "<br>At least one query failed : check the error message and contact me if you need help to resolve the problem. <br>"; } else { $error_message .= "<br>All the queries have been successfully done - Enjoy. <br>"; } echo("n<br>n<b>COMPLETE - INSTALLATION IS ENDED</b><br>n"); echo($error_message . "<br>"); echo("<br><b>NOW, DELETE THIS FILE FROM YOUR SERVER</b><br>n"); } ?> </body> </html>