[mxbb-commits] core/includes mx_functions_admincp.php,1.56,1.57

[FlorinCB <ory...@us...>]

Update of /cvsroot/mxbb/core/includes
In directory sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv11831

Modified Files:
	mx_functions_admincp.php 
Log Message:
fix for mysql 5.0.2 and later

Index: mx_functions_admincp.php
===================================================================
RCS file: /cvsroot/mxbb/core/includes/mx_functions_admincp.php,v
retrieving revision 1.56
retrieving revision 1.57
diff -C2 -d -r1.56 -r1.57
*** mx_functions_admincp.php	15 Jul 2008 22:02:44 -0000	1.56
--- mx_functions_admincp.php	20 Jul 2008 03:50:05 -0000	1.57
***************
*** 2754,2760 ****
  					$fldkey = 'parameter_id';
  					$key = $module_data[2];
! 
! 					$sql_add = "INSERT INTO " . PARAMETER_TABLE . " (function_id, parameter_id, parameter_name, parameter_type, parameter_default, parameter_function, parameter_auth, parameter_order)
! 						VALUES ( '" . intval($module_data[1]) . "', '" . intval($module_data[2]) . "', '" . str_replace("\'", "''", $module_data[3]) . "', '" . str_replace("\'", "''",$module_data[4]) . "', '" . str_replace("\'", "''", $module_data[5]) . "', '" . str_replace("\'", "''", $module_data[6]) . "', '" . str_replace("\'", "''", $module_data[7]) . "', '" . str_replace("\'", "''", $module_data[8]) . "' ) ";
  
  					$sql_update = "UPDATE " . PARAMETER_TABLE . "
--- 2754,2769 ----
  					$fldkey = 'parameter_id';
  					$key = $module_data[2];
! 					
! 					$sql = array(
! 						'function_id'        	=> (int) $module_data[1],
! 						'parameter_id'  		=> (int) $module_data[2],						
! 						'parameter_name'     	=> str_replace("\'", "''",$module_data[3]),
! 						'parameter_type'     	=> str_replace("\'", "''",$module_data[4]),
! 						'parameter_default'  	=> str_replace("\'", "''", $module_data[5]),
! 						'parameter_function' 	=> str_replace("\'", "''",$module_data[6]),
! 						'parameter_auth' 		=> str_replace("\'", "''",$module_data[7]),
! 						'parameter_order' 		=> (int)  $module_data[8],
! 					);
! 					$sql_add = "INSERT INTO $table " . $db->sql_build_array('INSERT', $sql);					
  
  					$sql_update = "UPDATE " . PARAMETER_TABLE . "