[mxbb-commits] mx_kb db_install.php, 1.41, 1.42 db_upgrade.php, 1.34, 1.35

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

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

Modified Files:
	db_install.php db_upgrade.php 
Log Message:
lots of optimizations

Index: db_install.php
===================================================================
RCS file: /cvsroot/mxbb/mx_kb/db_install.php,v
retrieving revision 1.41
retrieving revision 1.42
diff -C2 -d -r1.41 -r1.42
*** db_install.php	3 Jul 2006 09:17:01 -0000	1.41
--- db_install.php	4 Jul 2006 22:33:31 -0000	1.42
***************
*** 121,126 ****
    						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',
  
    						PRIMARY KEY (article_id)
--- 121,124 ----
***************
*** 157,163 ****
  
  		"CREATE TABLE " . $mx_table_prefix . "kb_votes (
!   						votes_ip varchar(50) NOT NULL default '0',
!   						votes_userid varchar(50) NOT NULL default '0',
!   						votes_file int(50) NOT NULL default '0'
  		)",
  
--- 155,163 ----
  
  		"CREATE TABLE " . $mx_table_prefix . "kb_votes (
! 			user_id mediumint(8) NOT NULL default '0',
! 			votes_ip varchar(50) NOT NULL default '0',
! 			votes_article int(50) NOT NULL default '0',
! 			rate_point tinyint(3) unsigned NOT NULL default '0',
! 			KEY user_id (user_id)
  		)",
  

Index: db_upgrade.php
===================================================================
RCS file: /cvsroot/mxbb/mx_kb/db_upgrade.php,v
retrieving revision 1.34
retrieving revision 1.35
diff -C2 -d -r1.34 -r1.35
*** db_upgrade.php	3 Jul 2006 09:17:01 -0000	1.34
--- db_upgrade.php	4 Jul 2006 22:33:31 -0000	1.35
***************
*** 62,66 ****
  	$message = "<b>Upgrading!</b><br/><br/>";
  	// validate before 1.05
! 	if ( !$result = $db->sql_query( "SELECT article_rating from " . $mx_table_prefix . "kb_articles" ) )
  	{
  		$upgrade_105 = 1;
--- 62,67 ----
  	$message = "<b>Upgrading!</b><br/><br/>";
  	// validate before 1.05
! 	$result = $db->sql_query( "SELECT config_value from " . $mx_table_prefix . "kb_config WHERE config_name = 'header_banner'" );
! 	if ( $db->sql_numrows( $result ) == 0 )
  	{
  		$upgrade_105 = 1;
***************
*** 415,418 ****
--- 416,425 ----
  		$sql[] = "ALTER TABLE " . $mx_table_prefix . "kb_categories MODIFY cat_order int(50) default NULL ";
  
+ 		$sql[] = "ALTER TABLE " . $mx_table_prefix . "kb_votes ADD rate_point tinyint(3) unsigned NOT NULL default '0' ";
+ 		$sql[] = "ALTER TABLE " . $mx_table_prefix . "kb_votes CHANGE votes_userid user_id mediumint(8) NOT NULL default '0' ";
+ 		$sql[] = "ALTER TABLE " . $mx_table_prefix . "kb_votes CHANGE votes_file votes_article int(50) NOT NULL default '0' ";
+ 
+ 		// Delete kb_article table article_rating and article_totalvotes
+ 
  	}
  	else