[mxbb-commits] mx_kb db_install.php, 1.44, 1.45 db_uninstall.php, 1.18, 1.19 db_upgrade.php, 1.37,

SourceForge Headquarters 1320 Columbia Street Suite 310 San Diego, CA 92101 +1 (858) 422-6466

Update of /cvsroot/mxbb/mx_kb
In directory sc8-pr-cvs7.sourceforge.net:/tmp/cvs-serv18197/modules/mx_kb

Modified Files:
	db_install.php db_uninstall.php db_upgrade.php 
	install_kb_tables.php kb.php kb_article_reader.php 
	kb_last_article.php kb_lists.php kb_mini.php 
	upgrade_kb_tables.php 
Log Message:
Updated copyrights file header

Index: kb.php
===================================================================
RCS file: /cvsroot/mxbb/mx_kb/kb.php,v
retrieving revision 1.40
retrieving revision 1.41
diff -C2 -d -r1.40 -r1.41
*** kb.php	4 Aug 2006 20:10:43 -0000	1.40
--- kb.php	13 Aug 2006 19:43:07 -0000	1.41
***************
*** 4,8 ****
  * @package mxBB Portal Module - mx_kb
  * @version $Id$
! * @copyright (c) 2002-2006 [wGEric, Jon Ohlsson] mxBB Project Team
  * @license http://opensource.org/licenses/gpl-license.php GNU General Public License v2
  *
--- 4,8 ----
  * @package mxBB Portal Module - mx_kb
  * @version $Id$
! * @copyright (c) 2002-2006 [Jon Ohlsson, Mohd Basri, wGEric, PHP Arena, pafileDB, CRLin] mxBB Project Team
  * @license http://opensource.org/licenses/gpl-license.php GNU General Public License v2
  *

Index: upgrade_kb_tables.php
===================================================================
RCS file: /cvsroot/mxbb/mx_kb/upgrade_kb_tables.php,v
retrieving revision 1.5
retrieving revision 1.6
diff -C2 -d -r1.5 -r1.6
*** upgrade_kb_tables.php	5 Apr 2006 22:34:48 -0000	1.5
--- upgrade_kb_tables.php	13 Aug 2006 19:43:07 -0000	1.6
***************
*** 4,8 ****
  * @package mxBB Portal Module - mx_kb
  * @version $Id$
! * @copyright (c) 2002-2006 [wGEric, Jon Ohlsson] mxBB Project Team
  * @license http://opensource.org/licenses/gpl-license.php GNU General Public License v2
  *
--- 4,8 ----
  * @package mxBB Portal Module - mx_kb
  * @version $Id$
! * @copyright (c) 2002-2006 [Jon Ohlsson, Mohd Basri, wGEric, PHP Arena, pafileDB, CRLin] mxBB Project Team
  * @license http://opensource.org/licenses/gpl-license.php GNU General Public License v2
  *
***************
*** 16,20 ****
  include($phpbb_root_path . 'config.'.$phpEx);
  include($phpbb_root_path . 'includes/constants.'.$phpEx);
! include($phpbb_root_path . 'common.'.$phpEx);	
  include($phpbb_root_path . 'includes/db.'.$phpEx);
  include($phpbb_root_path . 'includes/kb_constants.'.$phpEx);
--- 16,20 ----
  include($phpbb_root_path . 'config.'.$phpEx);
  include($phpbb_root_path . 'includes/constants.'.$phpEx);
! include($phpbb_root_path . 'common.'.$phpEx);
  include($phpbb_root_path . 'includes/db.'.$phpEx);
  include($phpbb_root_path . 'includes/kb_constants.'.$phpEx);
***************
*** 24,33 ****
  define( 'kbconstants_ok', defined( 'KB_CUSTOM_TABLE' ) );
  
! if ( !phpBBroot_ok ) 
  {
  	message_die(GENERAL_ERROR, "This install/upgrade script should be uploaded to the phpBB root.");
  }
  
! if ( !kbconstants_ok ) 
  {
  	message_die(GENERAL_ERROR, "You haven't uploaded latest kb_constants.php.");
--- 24,33 ----
  define( 'kbconstants_ok', defined( 'KB_CUSTOM_TABLE' ) );
  
! if ( !phpBBroot_ok )
  {
  	message_die(GENERAL_ERROR, "This install/upgrade script should be uploaded to the phpBB root.");
  }
  
! if ( !kbconstants_ok )
  {
  	message_die(GENERAL_ERROR, "You haven't uploaded latest kb_constants.php.");
***************
*** 57,61 ****
  <body bgcolor="#FFFFFF" text="#000000" link="#006699" vlink="#5584AA">
  
! <table width="100%" border="0" cellspacing="0" cellpadding="10" align="center"> 
  	<tr>
  		<td><table width="100%" border="0" cellspacing="0" cellpadding="0">
--- 57,61 ----
  <body bgcolor="#FFFFFF" text="#000000" link="#006699" vlink="#5584AA">
  
! <table width="100%" border="0" cellspacing="0" cellpadding="10" align="center">
  	<tr>
  		<td><table width="100%" border="0" cellspacing="0" cellpadding="0">
***************
*** 75,80 ****
  
  // get the phpBB version
! $sql = "SELECT config_value  
! 	FROM " . CONFIG_TABLE . " 
  	WHERE config_name = 'version'";
  if ( !($result = $db->sql_query($sql)) )
--- 75,80 ----
  
  // get the phpBB version
! $sql = "SELECT config_value
! 	FROM " . CONFIG_TABLE . "
  	WHERE config_name = 'version'";
  if ( !($result = $db->sql_query($sql)) )
***************
*** 121,125 ****
  	$upgrade_201 = 0;
  	$upgrade_202 = 0;
! 	
  // validate before 1.01
  if( !$result = $db->sql_query("SELECT article_rating from ".KB_ARTICLES_TABLE))
--- 121,125 ----
  	$upgrade_201 = 0;
  	$upgrade_202 = 0;
! 
  // validate before 1.01
  if( !$result = $db->sql_query("SELECT article_rating from ".KB_ARTICLES_TABLE))
***************
*** 182,189 ****
  	$upgrade_202 = 1;
  	$res_message .= "Upgrading to v. 2.02...<br />";
! 	
  if ( $submit )
  {
! 	
  	switch ( SQL_LAYER )
  	{
--- 182,189 ----
  	$upgrade_202 = 1;
  	$res_message .= "Upgrading to v. 2.02...<br />";
! 
  if ( $submit )
  {
! 
  	switch ( SQL_LAYER )
  	{
***************
*** 194,198 ****
  		    	$sql[] = 'ALTER TABLE ' . KB_ARTICLES_TABLE . ' ADD article_rating double(6,4) NOT NULL default "0.0000" ;';
  		    	$sql[] = 'ALTER TABLE ' . KB_ARTICLES_TABLE . ' ADD article_totalvotes int(255) NOT NULL default "0" ;';
! 		    	
  				$sql[] = 'INSERT INTO '.KB_CONFIG_TABLE.' (config_name, config_value) VALUES ("allow_rating", "0") ;';
  				$sql[] = 'INSERT INTO '.KB_CONFIG_TABLE.' (config_name, config_value) VALUES ("allow_anonymos_rating", "0") ;';
--- 194,198 ----
  		    	$sql[] = 'ALTER TABLE ' . KB_ARTICLES_TABLE . ' ADD article_rating double(6,4) NOT NULL default "0.0000" ;';
  		    	$sql[] = 'ALTER TABLE ' . KB_ARTICLES_TABLE . ' ADD article_totalvotes int(255) NOT NULL default "0" ;';
! 
  				$sql[] = 'INSERT INTO '.KB_CONFIG_TABLE.' (config_name, config_value) VALUES ("allow_rating", "0") ;';
  				$sql[] = 'INSERT INTO '.KB_CONFIG_TABLE.' (config_name, config_value) VALUES ("allow_anonymos_rating", "0") ;';
***************
*** 202,206 ****
  				$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[] = 'CREATE TABLE '.KB_VOTES_TABLE.' (
    					votes_ip varchar(50) NOT NULL default "0",
--- 202,206 ----
  				$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[] = 'CREATE TABLE '.KB_VOTES_TABLE.' (
    					votes_ip varchar(50) NOT NULL default "0",
***************
*** 209,213 ****
  					  ) TYPE=MyISAM';
  			}
! 			
  			if ( $upgrade_102 == 1 )
  			{
--- 209,213 ----
  					  ) TYPE=MyISAM';
  			}
! 
  			if ( $upgrade_102 == 1 )
  			{
***************
*** 225,231 ****
  				$sql[] = 'INSERT INTO '.KB_CONFIG_TABLE.' (config_name, config_value) VALUES ("news_sort_par", "ASC");';
  			}
! 			
  			if ( $upgrade_200 == 1 )
! 			{	
  				$sql[] = 'ALTER TABLE ' . KB_CATEGORIES_TABLE . ' ADD auth_view tinyint(3) NOT NULL DEFAULT "0" ;';
  				$sql[] = 'ALTER TABLE ' . KB_CATEGORIES_TABLE . ' ADD auth_post tinyint(3) NOT NULL DEFAULT "0" ;';
--- 225,231 ----
  				$sql[] = 'INSERT INTO '.KB_CONFIG_TABLE.' (config_name, config_value) VALUES ("news_sort_par", "ASC");';
  			}
! 
  			if ( $upgrade_200 == 1 )
! 			{
  				$sql[] = 'ALTER TABLE ' . KB_CATEGORIES_TABLE . ' ADD auth_view tinyint(3) NOT NULL DEFAULT "0" ;';
  				$sql[] = 'ALTER TABLE ' . KB_CATEGORIES_TABLE . ' ADD auth_post tinyint(3) NOT NULL DEFAULT "0" ;';
***************
*** 246,260 ****
  				$sql[] = 'ALTER TABLE ' . KB_CATEGORIES_TABLE . ' ADD auth_moderator_groups varchar(255) ;';
  				$sql[] = 'ALTER TABLE ' . KB_CATEGORIES_TABLE . ' ADD comments_forum_id tinyint(3) NOT NULL DEFAULT "-1" ;';
! 		
  				$sql[] = 'UPDATE ' . KB_CONFIG_TABLE . '
  		        				SET config_name  = "use_comments",
  				 					config_value = "1"
  		        				WHERE config_name = "comments" ;';
! 								
  				$sql[] = 'UPDATE ' . KB_CONFIG_TABLE . '
  		        				SET config_name  = "use_ratings",
  				 					config_value = "1"
! 		        				WHERE config_name = "allow_rating" ;';	
! 									
  				$sql[] = 'INSERT INTO '.KB_CONFIG_TABLE.' (config_name, config_value) VALUES ("wysiwyg", "0");';
  				$sql[] = 'INSERT INTO '.KB_CONFIG_TABLE.' (config_name, config_value) VALUES ("allow_html", "1");';
--- 246,260 ----
  				$sql[] = 'ALTER TABLE ' . KB_CATEGORIES_TABLE . ' ADD auth_moderator_groups varchar(255) ;';
  				$sql[] = 'ALTER TABLE ' . KB_CATEGORIES_TABLE . ' ADD comments_forum_id tinyint(3) NOT NULL DEFAULT "-1" ;';
! 
  				$sql[] = 'UPDATE ' . KB_CONFIG_TABLE . '
  		        				SET config_name  = "use_comments",
  				 					config_value = "1"
  		        				WHERE config_name = "comments" ;';
! 
  				$sql[] = 'UPDATE ' . KB_CONFIG_TABLE . '
  		        				SET config_name  = "use_ratings",
  				 					config_value = "1"
! 		        				WHERE config_name = "allow_rating" ;';
! 
  				$sql[] = 'INSERT INTO '.KB_CONFIG_TABLE.' (config_name, config_value) VALUES ("wysiwyg", "0");';
  				$sql[] = 'INSERT INTO '.KB_CONFIG_TABLE.' (config_name, config_value) VALUES ("allow_html", "1");';
***************
*** 262,266 ****
  				$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 ("allowed_html_tags", "b,i,u,a");';
! 				
  				$sql[] = 'CREATE TABLE ' . KB_CUSTOM_TABLE . ' (
  								  custom_id int(50) NOT NULL auto_increment,
--- 262,266 ----
  				$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 ("allowed_html_tags", "b,i,u,a");';
! 
  				$sql[] = 'CREATE TABLE ' . KB_CUSTOM_TABLE . ' (
  								  custom_id int(50) NOT NULL auto_increment,
***************
*** 272,277 ****
  								  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",
--- 272,277 ----
  								  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",
***************
*** 279,285 ****
  								  data text NOT NULL
  				) TYPE=MyISAM;';
! 				
  			}
! 			
  			if ( $upgrade_201 == 1 )
  			{
--- 279,285 ----
  								  data text NOT NULL
  				) TYPE=MyISAM;';
! 
  			}
! 
  			if ( $upgrade_201 == 1 )
  			{
***************
*** 288,292 ****
  				$sql[] = 'ALTER TABLE ' . KB_ARTICLES_TABLE . ' MODIFY article_author_id mediumint(8) NOT NULL ;';
  			}
! 			
  			if ( $upgrade_202 == 1 ) // Old fix for those upgraded from old old version
  			{
--- 288,292 ----
  				$sql[] = 'ALTER TABLE ' . KB_ARTICLES_TABLE . ' MODIFY article_author_id mediumint(8) NOT NULL ;';
  			}
! 
  			if ( $upgrade_202 == 1 ) // Old fix for those upgraded from old old version
  			{
***************
*** 296,305 ****
  				$sql[] = 'ALTER TABLE '. KB_CONFIG_TABLE.' DROP PRIMARY KEY, ADD PRIMARY KEY (config_name) ;';
  			}
! 			
  			break;
! 		
  		case 'mssql':
  		case 'mssql-odbc':
! 			
  		default:
  			die("/!\ No Database Abstraction Layer (DBAL) found /!\\");
--- 296,305 ----
  				$sql[] = 'ALTER TABLE '. KB_CONFIG_TABLE.' DROP PRIMARY KEY, ADD PRIMARY KEY (config_name) ;';
  			}
! 
  			break;
! 
  		case 'mssql':
  		case 'mssql-odbc':
! 
  		default:
  			die("/!\ No Database Abstraction Layer (DBAL) found /!\\");

Index: install_kb_tables.php
===================================================================
RCS file: /cvsroot/mxbb/mx_kb/install_kb_tables.php,v
retrieving revision 1.5
retrieving revision 1.6
diff -C2 -d -r1.5 -r1.6
*** install_kb_tables.php	5 Apr 2006 22:34:48 -0000	1.5
--- install_kb_tables.php	13 Aug 2006 19:43:06 -0000	1.6
***************
*** 4,8 ****
  * @package mxBB Portal Module - mx_kb
  * @version $Id$
! * @copyright (c) 2002-2006 [wGEric, Jon Ohlsson] mxBB Project Team
  * @license http://opensource.org/licenses/gpl-license.php GNU General Public License v2
  *
--- 4,8 ----
  * @package mxBB Portal Module - mx_kb
  * @version $Id$
! * @copyright (c) 2002-2006 [Jon Ohlsson, Mohd Basri, wGEric, PHP Arena, pafileDB, CRLin] mxBB Project Team
  * @license http://opensource.org/licenses/gpl-license.php GNU General Public License v2
  *
***************
*** 16,20 ****
  include($phpbb_root_path . 'config.'.$phpEx);
  include($phpbb_root_path . 'includes/constants.'.$phpEx);
! include($phpbb_root_path . 'common.'.$phpEx);	
  include($phpbb_root_path . 'includes/db.'.$phpEx);
  include($phpbb_root_path . 'includes/kb_constants.'.$phpEx);
--- 16,20 ----
  include($phpbb_root_path . 'config.'.$phpEx);
  include($phpbb_root_path . 'includes/constants.'.$phpEx);
! include($phpbb_root_path . 'common.'.$phpEx);
  include($phpbb_root_path . 'includes/db.'.$phpEx);
  include($phpbb_root_path . 'includes/kb_constants.'.$phpEx);
***************
*** 24,33 ****
  define( 'kbconstants_ok', defined( 'KB_CUSTOM_TABLE' ) );
  
! if ( !phpBBroot_ok ) 
  {
  	message_die(GENERAL_ERROR, "This install/upgrade script should be uploaded to the phpBB root.");
  }
  
! if ( !kbconstants_ok ) 
  {
  	message_die(GENERAL_ERROR, "You haven't uploaded latest kb_constants.php.");
--- 24,33 ----
  define( 'kbconstants_ok', defined( 'KB_CUSTOM_TABLE' ) );
  
! if ( !phpBBroot_ok )
  {
  	message_die(GENERAL_ERROR, "This install/upgrade script should be uploaded to the phpBB root.");
  }
  
! if ( !kbconstants_ok )
  {
  	message_die(GENERAL_ERROR, "You haven't uploaded latest kb_constants.php.");
***************
*** 57,61 ****
  <body bgcolor="#FFFFFF" text="#000000" link="#006699" vlink="#5584AA">
  
! <table width="100%" border="0" cellspacing="0" cellpadding="10" align="center"> 
  	<tr>
  		<td><table width="100%" border="0" cellspacing="0" cellpadding="0">
--- 57,61 ----
  <body bgcolor="#FFFFFF" text="#000000" link="#006699" vlink="#5584AA">
  
! <table width="100%" border="0" cellspacing="0" cellpadding="10" align="center">
  	<tr>
  		<td><table width="100%" border="0" cellspacing="0" cellpadding="0">
***************
*** 75,80 ****
  
  // get the phpBB version
! $sql = "SELECT config_value  
! 	FROM " . CONFIG_TABLE . " 
  	WHERE config_name = 'version'";
  if ( !($result = $db->sql_query($sql)) )
--- 75,80 ----
  
  // get the phpBB version
! $sql = "SELECT config_value
! 	FROM " . CONFIG_TABLE . "
  	WHERE config_name = 'version'";
  if ( !($result = $db->sql_query($sql)) )
***************
*** 137,141 ****
    						KEY article_id (article_id)
  				    ) TYPE=MyISAM;';
! 					
  			$sql[] = 'INSERT INTO '. KB_ARTICLES_TABLE .' VALUES (
  				   	      1, 1, "Test Article", "This is a test article for your KB", "1057708235", 2, "", "93074f48a9", "This is a test article for your Knowledge Base. This MOD is based on code written by wGEric &lt; er...@eg... &gt; (Eric Faerber) - http://eric.best-1.biz/, now supervised by _Haplo &lt; jon...@ho... &gt; (Jon Ohlsson) - http://www.mx-system.com/ \r\n\r\nBe sure you add categories and article types in the ACP and also change the Configuration to your liking.\r\n\r\nHave fun and enjoy your new Knowledge Base!  :D", 1, 1, 0, 0,0,0
--- 137,141 ----
    						KEY article_id (article_id)
  				    ) TYPE=MyISAM;';
! 
  			$sql[] = 'INSERT INTO '. KB_ARTICLES_TABLE .' VALUES (
  				   	      1, 1, "Test Article", "This is a test article for your KB", "1057708235", 2, "", "93074f48a9", "This is a test article for your Knowledge Base. This MOD is based on code written by wGEric &lt; er...@eg... &gt; (Eric Faerber) - http://eric.best-1.biz/, now supervised by _Haplo &lt; jon...@ho... &gt; (Jon Ohlsson) - http://www.mx-system.com/ \r\n\r\nBe sure you add categories and article types in the ACP and also change the Configuration to your liking.\r\n\r\nHave fun and enjoy your new Knowledge Base!  :D", 1, 1, 0, 0,0,0
***************
*** 143,149 ****
  
  			$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,
--- 143,149 ----
  
  			$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,
***************
*** 169,182 ****
    						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")';
--- 169,182 ----
    						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")';
***************
*** 208,218 ****
  			$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")';
  
--- 208,218 ----
  			$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")';
  
***************
*** 245,249 ****
  		  					KEY post_id (article_id),
  		  					KEY word_id (word_id)
! 					  	) TYPE=MyISAM;';	
  
  			$sql[] = 'CREATE TABLE ' . KB_CUSTOM_TABLE . ' (
--- 245,249 ----
  		  					KEY post_id (article_id),
  		  					KEY word_id (word_id)
! 					  	) TYPE=MyISAM;';
  
  			$sql[] = 'CREATE TABLE ' . KB_CUSTOM_TABLE . ' (
***************
*** 256,272 ****
  							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 /!\\");
--- 256,272 ----
  							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 /!\\");

Index: db_upgrade.php
===================================================================
RCS file: /cvsroot/mxbb/mx_kb/db_upgrade.php,v
retrieving revision 1.37
retrieving revision 1.38
diff -C2 -d -r1.37 -r1.38
*** db_upgrade.php	1 Aug 2006 21:00:37 -0000	1.37
--- db_upgrade.php	13 Aug 2006 19:43:06 -0000	1.38
***************
*** 4,8 ****
  * @package mxBB Portal Module - mx_kb
  * @version $Id$
! * @copyright (c) 2002-2006 [wGEric, Jon Ohlsson] mxBB Project Team
  * @license http://opensource.org/licenses/gpl-license.php GNU General Public License v2
  *
--- 4,8 ----
  * @package mxBB Portal Module - mx_kb
  * @version $Id$
! * @copyright (c) 2002-2006 [Jon Ohlsson, Mohd Basri, wGEric, PHP Arena, pafileDB, CRLin] mxBB Project Team
  * @license http://opensource.org/licenses/gpl-license.php GNU General Public License v2
  *

Index: db_install.php
===================================================================
RCS file: /cvsroot/mxbb/mx_kb/db_install.php,v
retrieving revision 1.44
retrieving revision 1.45
diff -C2 -d -r1.44 -r1.45
*** db_install.php	1 Aug 2006 21:00:37 -0000	1.44
--- db_install.php	13 Aug 2006 19:43:06 -0000	1.45
***************
*** 4,8 ****
  * @package mxBB Portal Module - mx_kb
  * @version $Id$
! * @copyright (c) 2002-2006 [wGEric, Jon Ohlsson] mxBB Project Team
  * @license http://opensource.org/licenses/gpl-license.php GNU General Public License v2
  *
--- 4,8 ----
  * @package mxBB Portal Module - mx_kb
  * @version $Id$
! * @copyright (c) 2002-2006 [Jon Ohlsson, Mohd Basri, wGEric, PHP Arena, pafileDB, CRLin] mxBB Project Team
  * @license http://opensource.org/licenses/gpl-license.php GNU General Public License v2
  *

Index: kb_mini.php
===================================================================
RCS file: /cvsroot/mxbb/mx_kb/kb_mini.php,v
retrieving revision 1.1
retrieving revision 1.2
diff -C2 -d -r1.1 -r1.2
*** kb_mini.php	13 Aug 2006 18:51:37 -0000	1.1
--- kb_mini.php	13 Aug 2006 19:43:07 -0000	1.2
***************
*** 2,8 ****
  /**
  *
! * @package mxBB Portal Module - mx_pafiledb
  * @version $Id$
! * @copyright (c) 2002-2006 [Mohd Basri, PHP Arena, pafileDB, Jon Ohlsson] mxBB Project Team
  * @license http://opensource.org/licenses/gpl-license.php GNU General Public License v2
  *
--- 2,8 ----
  /**
  *
! * @package mxBB Portal Module - mx_kb
  * @version $Id$
! * @copyright (c) 2002-2006 [Jon Ohlsson, Mohd Basri, wGEric, PHP Arena, pafileDB, CRLin] mxBB Project Team
  * @license http://opensource.org/licenses/gpl-license.php GNU General Public License v2
  *

Index: kb_article_reader.php
===================================================================
RCS file: /cvsroot/mxbb/mx_kb/kb_article_reader.php,v
retrieving revision 1.19
retrieving revision 1.20
diff -C2 -d -r1.19 -r1.20
*** kb_article_reader.php	5 Jul 2006 22:48:25 -0000	1.19
--- kb_article_reader.php	13 Aug 2006 19:43:07 -0000	1.20
***************
*** 4,8 ****
  * @package mxBB Portal Module - mx_kb
  * @version $Id$
! * @copyright (c) 2002-2006 [wGEric, Jon Ohlsson] mxBB Project Team
  * @license http://opensource.org/licenses/gpl-license.php GNU General Public License v2
  *
--- 4,8 ----
  * @package mxBB Portal Module - mx_kb
  * @version $Id$
! * @copyright (c) 2002-2006 [Jon Ohlsson, Mohd Basri, wGEric, PHP Arena, pafileDB, CRLin] mxBB Project Team
  * @license http://opensource.org/licenses/gpl-license.php GNU General Public License v2
  *

Index: kb_lists.php
===================================================================
RCS file: /cvsroot/mxbb/mx_kb/kb_lists.php,v
retrieving revision 1.3
retrieving revision 1.4
diff -C2 -d -r1.3 -r1.4
*** kb_lists.php	13 Aug 2006 18:51:37 -0000	1.3
--- kb_lists.php	13 Aug 2006 19:43:07 -0000	1.4
***************
*** 2,8 ****
  /**
  *
! * @package mxBB Portal Module - mx_pafiledb
  * @version $Id$
! * @copyright (c) 2002-2006 [Mohd Basri, PHP Arena, pafileDB, Jon Ohlsson] mxBB Project Team
  * @license http://opensource.org/licenses/gpl-license.php GNU General Public License v2
  *
--- 2,8 ----
  /**
  *
! * @package mxBB Portal Module - mx_kb
  * @version $Id$
! * @copyright (c) 2002-2006 [Jon Ohlsson, Mohd Basri, wGEric, PHP Arena, pafileDB, CRLin] mxBB Project Team
  * @license http://opensource.org/licenses/gpl-license.php GNU General Public License v2
  *

Index: kb_last_article.php
===================================================================
RCS file: /cvsroot/mxbb/mx_kb/kb_last_article.php,v
retrieving revision 1.2
retrieving revision 1.3
diff -C2 -d -r1.2 -r1.3
*** kb_last_article.php	28 Jun 2006 20:52:30 -0000	1.2
--- kb_last_article.php	13 Aug 2006 19:43:07 -0000	1.3
***************
*** 4,8 ****
  * @package mxBB Portal Module - mx_kb
  * @version $Id$
! * @copyright (c) 2002-2006 mxBB Project Team
  * @license http://opensource.org/licenses/gpl-license.php GNU General Public License v2
  *
--- 4,8 ----
  * @package mxBB Portal Module - mx_kb
  * @version $Id$
! * @copyright (c) 2002-2006 [Jon Ohlsson, Mohd Basri, wGEric, PHP Arena, pafileDB, CRLin] mxBB Project Team
  * @license http://opensource.org/licenses/gpl-license.php GNU General Public License v2
  *

Index: db_uninstall.php
===================================================================
RCS file: /cvsroot/mxbb/mx_kb/db_uninstall.php,v
retrieving revision 1.18
retrieving revision 1.19
diff -C2 -d -r1.18 -r1.19
*** db_uninstall.php	27 Jun 2006 18:13:45 -0000	1.18
--- db_uninstall.php	13 Aug 2006 19:43:06 -0000	1.19
***************
*** 4,8 ****
  * @package mxBB Portal Module - mx_kb
  * @version $Id$
! * @copyright (c) 2002-2006 [wGEric, Jon Ohlsson] mxBB Project Team
  * @license http://opensource.org/licenses/gpl-license.php GNU General Public License v2
  *
--- 4,8 ----
  * @package mxBB Portal Module - mx_kb
  * @version $Id$
! * @copyright (c) 2002-2006 [Jon Ohlsson, Mohd Basri, wGEric, PHP Arena, pafileDB, CRLin] mxBB Project Team
  * @license http://opensource.org/licenses/gpl-license.php GNU General Public License v2
  *

[mxbb-commits] mx_kb db_install.php, 1.44, 1.45 db_uninstall.php, 1.18, 1.19 db_upgrade.php, 1.37,

[mxbb-commits] mx_kb db_install.php, 1.44, 1.45 db_uninstall.php, 1.18, 1.19 db_upgrade.php, 1.37, 1.38 install_kb_tables.php, 1.5, 1.6 kb.php, 1.40, 1.41 kb_article_reader.php, 1.19, 1.20 kb_last_article.php, 1.2, 1.3 kb_lists.php, 1.3, 1.4 kb_mini.php, 1.1, 1.2 upgrade_kb_tables.php, 1.5, 1.6