[mxbb-commits] mx_kb db_install.php,1.23,1.24 db_upgrade.php,1.16,1.17

[Jon O. <jon...@us...>]

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

Modified Files:
	db_install.php db_upgrade.php 
Log Message:
db fix

Index: db_install.php
===================================================================
RCS file: /cvsroot/mxbb/mx_kb/db_install.php,v
retrieving revision 1.23
retrieving revision 1.24
diff -C2 -d -r1.23 -r1.24
*** db_install.php	28 Mar 2005 20:22:45 -0000	1.23
--- db_install.php	30 Mar 2005 09:53:54 -0000	1.24
***************
*** 66,70 ****
    						article_description 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),
    						bbcode_uid varchar(10) binary NOT NULL default '',
--- 66,70 ----
    						article_description varchar(255) binary NOT NULL default '',
    						article_date varchar(255) binary NOT NULL default '',
!   						article_author_id mediumint(8) NOT NULL,
  						username VARCHAR(255),
    						bbcode_uid varchar(10) binary NOT NULL default '',

Index: db_upgrade.php
===================================================================
RCS file: /cvsroot/mxbb/mx_kb/db_upgrade.php,v
retrieving revision 1.16
retrieving revision 1.17
diff -C2 -d -r1.16 -r1.17
*** db_upgrade.php	28 Mar 2005 20:22:45 -0000	1.16
--- db_upgrade.php	30 Mar 2005 09:53:54 -0000	1.17
***************
*** 171,211 ****
  		$sql[] = "INSERT INTO " . $mx_table_prefix . "kb_config VALUES ('news_sort_par', 'ASC')"; 
  		
- 		/*
- 		// Now add some new parameters
- 		// First get function_id
- 		$sqltmp = "SELECT function_id
- 			FROM " . $mx_table_prefix . "function" . "
- 			WHERE function_file = 'kb.php'
- 			LIMIT 1";
- 		if ( !( $result = $db->sql_query( $sqltmp ) ) )
- 		{
- 			message_die( CRITICAL_ERROR, "Could not query portal version", "", __LINE__, __FILE__, $sql );
- 		}
- 
- 		$row = $db->sql_fetchrow( $result ) ;
- 		$function_id = $row['function_id']; 
- 		// Then get block_id(s)
- 		$sqltmp2 = "SELECT block_id
- 			FROM " . $mx_table_prefix . "block" . "
- 			WHERE function_id = '$function_id'
- 			LIMIT 1";
- 		if ( !( $result = $db->sql_query( $sqltmp2 ) ) )
- 		{
- 			message_die( CRITICAL_ERROR, "Could not query portal version", "", __LINE__, __FILE__, $sql );
- 		}
- 
- 		$parameter_id = getMaxId( PARAMETER_TABLE, 'parameter_id' );
- 		$parameter_id1 = $parameter_id + 1;
- 		$sql[] = "REPLACE INTO " . $mx_table_prefix . "parameter VALUES('" . $parameter_id1 . "', '" . $function_id . "', 'kb_type_select', 'Text', 'array(\"init\"=>\"1\")', '')";
- 
- 		while ( $row = $db->sql_fetchrow( $result ) )
- 		{
- 			$block_id = $row['block_id'];
- 			$sql[] = "REPLACE INTO " . $mx_table_prefix . "block_system_parameter VALUES('" . $block_id . "', '" . $parameter_id1 . "', 'array(\"init\"=>\"1\")', NULL)";
- 		} 
- 		// Also, enable function admin file
- 		$sql[] = "UPDATE " . $mx_table_prefix . "function SET function_admin = 'modules/mx_kb/admin/kb_config.php'
-         WHERE function_id = '" . $function_id . "' OR function_file = 'kb.php'";
-         */
  	}
  	
--- 171,174 ----
***************
*** 270,274 ****
  						  customdata_custom int(50) NOT NULL default '0',
  						  data text NOT NULL
! 		)";		
  	}
  	else
--- 233,239 ----
  						  customdata_custom int(50) NOT NULL default '0',
  						  data text NOT NULL
! 		)";
! 
! 		$sql[] = "ALTER TABLE " . $mx_table_prefix . "kb_articles MODIFY article_author_id mediumint(8) NOT NULL ";
  	}
  	else