Update of /cvsroot/stack/stack-dev/install/update/updates
In directory sfp-cvsdas-3.v30.ch3.sourceforge.com:/tmp/cvs-serv17950/install/update/updates
Modified Files:
Tag: STACK2_2
TwoPointTwo.php
Log Message:
Fixed question_lines table index offset.
Index: TwoPointTwo.php
===================================================================
RCS file: /cvsroot/stack/stack-dev/install/update/updates/Attic/TwoPointTwo.php,v
retrieving revision 1.1.2.3
retrieving revision 1.1.2.4
diff -C2 -d -r1.1.2.3 -r1.1.2.4
*** TwoPointTwo.php 29 Sep 2010 17:02:46 -0000 1.1.2.3
--- TwoPointTwo.php 29 Sep 2010 17:10:14 -0000 1.1.2.4
***************
*** 83,87 ****
// shortcut: we know sequence of insert ids will be 1,2,3,... i.e. $i
// set line id in each question
! $conn->query("UPDATE stackquestion SET line=$i WHERE questionID=".$qid[$i]);
}
--- 83,87 ----
// shortcut: we know sequence of insert ids will be 1,2,3,... i.e. $i
// set line id in each question
! $conn->query("UPDATE stackquestion SET line=".($i+1)." WHERE questionID=".$qid[$i]); // row indices start at 1
}
|
