|
From: Jon O. <jon...@us...> - 2005-03-30 09:54:03
|
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 |