[Stack-cvs] stack-dev/install/update/updates TwoPointTwo.php, 1.1.2.1, 1.1.2.2

[Simon H. <sim...@us...>]

Update of /cvsroot/stack/stack-dev/install/update/updates
In directory sfp-cvsdas-3.v30.ch3.sourceforge.com:/tmp/cvs-serv11860/install/update/updates

Modified Files:
      Tag: STACK2_2
	TwoPointTwo.php 
Log Message:
Fixes for latest updating step.

Index: TwoPointTwo.php
===================================================================
RCS file: /cvsroot/stack/stack-dev/install/update/updates/Attic/TwoPointTwo.php,v
retrieving revision 1.1.2.1
retrieving revision 1.1.2.2
diff -C2 -d -r1.1.2.1 -r1.1.2.2
*** TwoPointTwo.php	29 Sep 2010 15:08:34 -0000	1.1.2.1
--- TwoPointTwo.php	29 Sep 2010 16:37:48 -0000	1.1.2.2
***************
*** 43,46 ****
--- 43,47 ----
      {
  	    // Add the new 'question_lines' table
+ 	    global $config;
  	    // below from adodbinit.php - expecting to be safer than simple mySQL query:
  	    $db = NewADOConnection($config->getDB('dbType'));
***************
*** 64,68 ****
  		$conn->connect();
  		// hoping this is a platform-agnostic way to modify tables - more knowlegable opinions welcome!
! 		$conn->query('ALTER TABLE stackquestion ADD COLUMN line I(11) UNSIGNED');
  
  	    // Create new line for each question, i.e. create row in question_lines and set line with that id.
--- 65,74 ----
  		$conn->connect();
  		// hoping this is a platform-agnostic way to modify tables - more knowlegable opinions welcome!
! 		//$conn->query('ALTER TABLE stackquestion ADD COLUMN line I(11) UNSIGNED'); // CANNOT DO THIS!
! 		$sqlarray = $dict->AddColumnSQL('stackquestion', 'line I(11) UNSIGNED');
! 		if(!$dict->ExecuteSQLArray($sqlarray))
! 	    {
! 	    	$toReturn = $dict->ErrorMsg().'<br /><br />';
! 	    }
  
  	    // Create new line for each question, i.e. create row in question_lines and set line with that id.