A few mods

[MWE_001]

Yeah Teelk, thats what I was thinking too, UNFORTUNEATLY, the sql that comes with the KB downloads will not run.

I found and used one from phpBB and it worked BUT you couldnt create or delete any categories. If you did, it trashed the database everysingle time. The categories lines were in the database and as soon as you delete a category, all of them were gone and it wouldnt allow you to create any others and it would take you to index.php on submit of a new category.

KB sure would be nice, but as we all know me and sql just dont get along to good. Anything outside of inserting and dumping in the db admin, Im useless.

[Teelk]

Here's the sql for the KB MOD used in IM...

Code: Select all

CREATE TABLE phpbb_kb_articles (   article_id mediumint(8) unsigned NOT NULL auto_increment,   article_category_id mediumint(8) unsigned NOT NULL default '0',   article_title varchar(255) binary NOT NULL default '',   article_de.scription varchar(255) binary NOT NULL default '',   article_date varchar(255) binary NOT NULL default '',   article_author_id mediumint(8) unsigned NOT NULL default '0',   username varchar(255) default NULL,   bbcode_uid varchar(10) binary NOT NULL default '',   article_body text NOT NULL,   article_type mediumint(8) unsigned NOT NULL default '0',   approved tinyint(1) unsigned NOT NULL default '0',   topic_id mediumint(8) unsigned NOT NULL default '0',   views bigint(8) NOT NULL default '0',   article_rating double(6,4) NOT NULL default '0.0000',   article_totalvotes int(255) NOT NULL default '0',   KEY article_id (article_id)) TYPE=MyISAM;  CREATE TABLE phpbb_kb_categories (   category_id mediumint(8) unsigned NOT NULL auto_increment,   category_name varchar(255) binary NOT NULL default '',   category_details varchar(255) binary NOT NULL default '',   number_articles mediumint(8) unsigned NOT NULL default '0',   parent mediumint(8) unsigned default NULL,   cat_order mediumint(8) unsigned NOT NULL default '0',   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;  CREATE TABLE phpbb_kb_config (   config_name varchar(255) NOT NULL default '',   config_value varchar(255) default NULL,   PRIMARY KEY  (config_name)) TYPE=MyISAM;  CREATE TABLE phpbb_kb_results (   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;  CREATE TABLE phpbb_kb_types (   id mediumint(8) unsigned NOT NULL auto_increment,   type varchar(255) binary NOT NULL default '',   KEY id (id)) TYPE=MyISAM;  CREATE TABLE phpbb_kb_votes (   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;  CREATE TABLE phpbb_kb_wordlist (   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;  CREATE TABLE phpbb_kb_wordmatch (   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;  CREATE TABLE phpbb_kb_custom (   custom_id int(50) NOT NULL auto_increment,   custom_name text NOT NULL,   custom_de.scription 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;  CREATE TABLE phpbb_kb_customdata (   customdata_file int(50) NOT NULL default '0',   customdata_custom int(50) NOT NULL default '0',   data text NOT NULL) TYPE=MyISAM;        INSERT INTO phpbb_kb_config (config_name, config_value) VALUES ("allow_new", "1");INSERT INTO phpbb_kb_config (config_name, config_value) VALUES ("notify", "1");INSERT INTO phpbb_kb_config (config_name, config_value) VALUES ("admin_id", "2");INSERT INTO phpbb_kb_config (config_name, config_value) values("show_pretext",0);INSERT INTO phpbb_kb_config (config_name, config_value) values("pt_header","Article Submission Instructions");INSERT INTO phpbb_kb_config (config_name, config_value) values("pt_body","Please check your references and include as much information as you can.");INSERT INTO phpbb_kb_config (config_name, config_value) VALUES ("use_comments", "1");INSERT INTO phpbb_kb_config (config_name, config_value) VALUES ("del_topic", "1");INSERT INTO phpbb_kb_config (config_name, config_value) VALUES ("use_ratings", "0");INSERT INTO phpbb_kb_config (config_name, config_value) VALUES ("comments_show", "1");INSERT INTO phpbb_kb_config (config_name, config_value) VALUES ("bump_post", "1");INSERT INTO phpbb_kb_config (config_name, config_value) VALUES ("stats_list", "1");INSERT INTO phpbb_kb_config (config_name, config_value) VALUES ("header_banner", "1");  INSERT INTO phpbb_kb_config (config_name, config_value) VALUES ("votes_check_userid", "1");INSERT INTO phpbb_kb_config (config_name, config_value) VALUES ("votes_check_ip", "1");INSERT INTO phpbb_kb_config (config_name, config_value) VALUES ("art_pagination", "5");  INSERT INTO phpbb_kb_config (config_name, config_value) VALUES ("comments_pagination", "5");INSERT INTO phpbb_kb_config (config_name, config_value) VALUES ("news_sort", "Alphabetic");INSERT INTO phpbb_kb_config (config_name, config_value) VALUES ("news_sort_par", "ASC");  INSERT INTO phpbb_kb_config (config_name, config_value) VALUES ("wysiwyg", "0");INSERT INTO phpbb_kb_config (config_name, config_value) VALUES ("wysiwyg_path", "modules/");INSERT INTO phpbb_kb_config (config_name, config_value) VALUES ("allow_html", "1");INSERT INTO phpbb_kb_config (config_name, config_value) VALUES ("allow_bbcode", "1");INSERT INTO phpbb_kb_config (config_name, config_value) VALUES ("allow_smilies", "1");INSERT INTO phpbb_kb_config (config_name, config_value) VALUES ("formatting_fixup", "0");INSERT INTO phpbb_kb_config (config_name, config_value) VALUES ("allowed_html_tags", "b,i,u,a");  INSERT INTO phpbb_kb_types VALUES (1, 'Test Type 1');  

The categories issue has been resolved in the IM files.

[MWE_001]

Sweet. Im definately going to have a look at it. BUT i got another issue I want to solve first before I proceed any further. And its a MAJOR issue. Posted in IM Portal help.