[moregroupware-cvs] mgw/modules/settings index.php,1.139,1.140

[<ema...@us...>]

Update of /cvsroot/moregroupware/mgw/modules/settings
In directory sc8-pr-cvs1:/tmp/cvs-serv11246

Modified Files:
	index.php 
Log Message:
adding complete inserts for mgw_config

Index: index.php
===================================================================
RCS file: /cvsroot/moregroupware/mgw/modules/settings/index.php,v
retrieving revision 1.139
retrieving revision 1.140
diff -C2 -d -r1.139 -r1.140
*** index.php	6 Nov 2003 14:43:56 -0000	1.139
--- index.php	7 Nov 2003 20:30:19 -0000	1.140
***************
*** 257,261 ****
  				  if (isset($option["dimensions"]) and is_numeric($option["dimensions"]) and $option["dimensions"] > 0) { $dimensions=$option["dimensions"]; }
  				  
! 				  $sql = "INSERT INTO mgw_config VALUES (0,".$conn->QMagic($key).",1,".$conn->QMagic($value_str).",".$value_int.",".$conn->QMagic($value_txt).",1,NOW())";
                    if(!$res = $conn->Execute($sql)) exit(showSQLerror($sql, $conn->ErrorMsg(), __LINE__, __FILE__));
  
--- 257,261 ----
  				  if (isset($option["dimensions"]) and is_numeric($option["dimensions"]) and $option["dimensions"] > 0) { $dimensions=$option["dimensions"]; }
  				  
! 				  $sql = "INSERT INTO mgw_config (userid,configtagname,serialnr,value_str,value_int,value_txt,lu_user,lu_date) VALUES (0,".$conn->QMagic($key).",1,".$conn->QMagic($value_str).",".$value_int.",".$conn->QMagic($value_txt).",1,NOW())";
                    if(!$res = $conn->Execute($sql)) exit(showSQLerror($sql, $conn->ErrorMsg(), __LINE__, __FILE__));
  
***************
*** 298,302 ****
  				    foreach ($value_int as $value_int2) {
  					  $i++;
! 				      $sql = "INSERT INTO mgw_config VALUES (0,".$conn->QMagic($key).",".$i.",".$conn->QMagic($value_str).",".$value_int2.",".$conn->QMagic($value_txt).",1,NOW())";
                        if(!$res = $conn->Execute($sql)) exit(showSQLerror($sql, $conn->ErrorMsg(), __LINE__, __FILE__));
  					}
--- 298,302 ----
  				    foreach ($value_int as $value_int2) {
  					  $i++;
! 				      $sql = "INSERT INTO mgw_config (userid,configtagname,serialnr,value_str,value_int,value_txt,lu_user,lu_date) VALUES (0,".$conn->QMagic($key).",".$i.",".$conn->QMagic($value_str).",".$value_int2.",".$conn->QMagic($value_txt).",1,NOW())";
                        if(!$res = $conn->Execute($sql)) exit(showSQLerror($sql, $conn->ErrorMsg(), __LINE__, __FILE__));
  					}
***************
*** 305,309 ****
  				    foreach ($value_str as $value_str2) {
  					  $i++;
! 				      $sql = "INSERT INTO mgw_config VALUES (0,".$conn->QMagic($key).",".$i.",".$conn->QMagic($value_str2).",".$value_int.",".$conn->QMagic($value_txt).",1,NOW())";
                        if(!$res = $conn->Execute($sql)) exit(showSQLerror($sql, $conn->ErrorMsg(), __LINE__, __FILE__));
  					}
--- 305,309 ----
  				    foreach ($value_str as $value_str2) {
  					  $i++;
! 				      $sql = "INSERT INTO mgw_config (userid,configtagname,serialnr,value_str,value_int,value_txt,lu_user,lu_date) VALUES (0,".$conn->QMagic($key).",".$i.",".$conn->QMagic($value_str2).",".$value_int.",".$conn->QMagic($value_txt).",1,NOW())";
                        if(!$res = $conn->Execute($sql)) exit(showSQLerror($sql, $conn->ErrorMsg(), __LINE__, __FILE__));
  					}
***************
*** 312,316 ****
  				    foreach ($value_txt as $value_txt2) {
  					  $i++;
! 				      $sql = "INSERT INTO mgw_config VALUES (0,".$conn->QMagic($key).",".$i.",".$conn->QMagic($value_str).",".$value_int.",".$conn->QMagic($value_txt2).",1,NOW())";
                        if(!$res = $conn->Execute($sql)) exit(showSQLerror($sql, $conn->ErrorMsg(), __LINE__, __FILE__));
  					}
--- 312,316 ----
  				    foreach ($value_txt as $value_txt2) {
  					  $i++;
! 				      $sql = "INSERT INTO mgw_config (userid,configtagname,serialnr,value_str,value_int,value_txt,lu_user,lu_date) VALUES (0,".$conn->QMagic($key).",".$i.",".$conn->QMagic($value_str).",".$value_int.",".$conn->QMagic($value_txt2).",1,NOW())";
                        if(!$res = $conn->Execute($sql)) exit(showSQLerror($sql, $conn->ErrorMsg(), __LINE__, __FILE__));
  					}