Index: admin/remotecontrol/lsrc.helper.php
===================================================================
--- admin/remotecontrol/lsrc.helper.php	(revision 8408)
+++ admin/remotecontrol/lsrc.helper.php	(working copy)
@@ -2052,7 +2052,7 @@
 	}
 
 	/**
-	 * function to activate surveys based on new activate.php 5771 2008-10-13 02:28:40Z jcleeland $
+	 * function to activate surveys based on activate.php 8089 2009-12-06 22:03:44Z c_schmitz $
 	 *
 	 * @param unknown_type $surveyid
 	 * @return boolean
@@ -2335,6 +2335,7 @@
 			//Create the survey responses table
 			$createsurvey = "id I NOTNULL AUTO PRIMARY,\n";
 			$createsurvey .= " submitdate T,\n";
+			$createsurvey .= " lastpage I,\n";
 			$createsurvey .= " startlanguage C(20) NOTNULL ,\n";
 			//Check for any additional fields for this survey and create necessary fields (token and datestamp)
 			$pquery = "SELECT private, allowregister, datestamp, ipaddr, refurl FROM {$dbprefix}surveys WHERE sid={$surveyid}";
@@ -2371,7 +2372,7 @@
 			." AND ".db_table_name('questions').".sid={$surveyid} "
 			." AND ".db_table_name('groups').".language='".GetbaseLanguageFromSurveyid($surveyid). "' "
 			." AND ".db_table_name('questions').".language='".GetbaseLanguageFromSurveyid($surveyid). "' "
-			." ORDER BY ".db_table_name('groups').".group_order, title";
+			." ORDER BY group_order, question_order";
 			$aresult = db_execute_assoc($aquery);
 			while ($arow=$aresult->FetchRow()) //With each question, create the appropriate field(s)
 			{
@@ -2449,7 +2450,7 @@
 					}
 					if ((isset($alsoother) && $alsoother=="Y") && ($arow['type']=="M" || $arow['type']=="P"  || $arow['type']=="1")) //Sc: check!
 					{
-						$createsurvey .= " `{$arow['sid']}X{$arow['gid']}X{$arow['qid']}other` C(255),\n";
+						$createsurvey .= " `{$arow['sid']}X{$arow['gid']}X{$arow['qid']}other` X,\n";
 						if ($arow['type']=="P")
 						{
 							$createsurvey .= " `{$arow['sid']}X{$arow['gid']}X{$arow['qid']}othercomment` X,\n";
@@ -2517,7 +2518,7 @@
 					$abresult=db_execute_assoc($abquery) or $this->debugLsrc ("Couldn't get perform answers query$abquery".$connect->ErrorMsg());
 					while ($abrow = $abresult->FetchRow())
 					{
-						$createsurvey .= "  `{$arow['sid']}X{$arow['gid']}X{$arow['qid']}{$abrow['code']}` C(20),\n";
+						$createsurvey .= "  `{$arow['sid']}X{$arow['gid']}X{$arow['qid']}{$abrow['code']}` F,\n";
 					}
 				} //End if ($arow['type'] == "K")
 				/*		elseif ($arow['type'] == "J")
@@ -4332,4 +4333,4 @@
 		}
 		return "".$iCountParticipants."Datasets given, ".$iInsertedParticipants." rows inserted. ";
 	}
-}
\ No newline at end of file
+}

# LimeSurvey Survey Dump
# DBVersion 142
# This is a dumped survey from the LimeSurvey Script
# http://www.limesurvey.org/
# Do not change this header!

#
# SURVEYS TABLE
#
"sid","owner_id","admin","active","expires","startdate","adminemail","private","faxto","format","template","language","additional_languages","datestamp","usecookie","notification","allowregister","allowsave","autonumber_start","autoredirect","allowprev","printanswers","ipaddr","refurl","datecreated","publicstatistics","publicgraphs","listpublic","htmlemail","tokenanswerspersistence","assessments","usecaptcha","usetokens","bounce_email","attributedescriptions","emailresponseto","tokenlength"
"33214","1","David Wolff","N","","","davidwolff@letu.edu","Y","","G","default","en","","N","N","0","N","Y","0","N","Y","N","N","N","2010-02-22","N","N","N","Y","N","N","D","N","davidwolff@letu.edu","","","15"

#
# GROUPS TABLE
#
"gid","sid","group_name","group_order","description","language"
"702","33214","Group 1","0","You will be able to fill out this group of questions, but Lime will crash when you move to the second group and all your responses will be lost.<br />","en"
"703","33214","Group 2","1","You won't be able to get to this group if this survey was activated using LSRC.<br />","en"

#
# QUESTIONS TABLE
#
"qid","sid","gid","type","title","question","preg","help","other","mandatory","lid","lid1","question_order","language"
"9927","33214","702","C","1","Do you feel well today?<br />","","","N","Y","0","0","0","en"
"9928","33214","703","C","2","Were you able to reach this question?<br />","","","N","Y","0","0","0","en"

#
# ANSWERS TABLE
#
"qid","code","answer","default_value","assessment_value","sortorder","language"
"9927","1","","N","0","1","en"
"9928","1","","N","0","1","en"

#
# CONDITIONS TABLE
#

#
# LABELSETS TABLE
#

#
# LABELS TABLE
#

#
# QUESTION_ATTRIBUTES TABLE
#
"qaid","qid","attribute","value"
"85958","9927","answer_width",""
"85959","9927","array_filter",""
"85960","9927","array_filter_exclude",""
"85961","9927","hidden","0"
"85962","9927","page_break","0"
"85963","9927","public_statistics","0"
"85964","9927","random_order","0"
"85965","9927","scale_export","0"
"85966","9928","answer_width",""
"85967","9928","array_filter",""
"85968","9928","array_filter_exclude",""
"85969","9928","hidden","0"
"85970","9928","page_break","0"
"85971","9928","public_statistics","0"
"85972","9928","random_order","0"
"85973","9928","scale_export","0"

#
# ASSESSMENTS TABLE
#

#
# SURVEYS_LANGUAGESETTINGS TABLE
#
"surveyls_survey_id","surveyls_language","surveyls_title","surveyls_description","surveyls_welcometext","surveyls_endtext","surveyls_url","surveyls_urldescription","surveyls_email_invite_subj","surveyls_email_invite","surveyls_email_remind_subj","surveyls_email_remind","surveyls_email_register_subj","surveyls_email_register","surveyls_email_confirm_subj","surveyls_email_confirm","surveyls_dateformat"
"33214","en","Survey Can't Be Finished Bug ","If this survey is activated via the Lime Survey Remote Control it will not be able to be finished.&nbsp; It will crash when moving from the first question group to the second.<br />","Welcome<br />","Thanks<br />","","","Invitation to participate in survey","Dear {FIRSTNAME},<br /><br />You have been invited to participate in a survey.<br /><br />The survey is titled:<br />""{SURVEYNAME}""<br /><br />""{SURVEYDESCRIPTION}""<br /><br />To participate, please click on the link below.<br /><br />Sincerely,<br /><br />{ADMINNAME} ({ADMINEMAIL})<br /><br />----------------------------------------------<br />Click here to do the survey:<br />{SURVEYURL}","Reminder to participate in survey","Dear {FIRSTNAME},<br /><br />Recently we invited you to participate in a survey.<br /><br />We note that you have not yet completed the survey, and wish to remind you that the survey is still available should you wish to take part.<br /><br />The survey is titled:<br />""{SURVEYNAME}""<br /><br />""{SURVEYDESCRIPTION}""<br /><br />To participate, please click on the link below.<br /><br />Sincerely,<br /><br />{ADMINNAME} ({ADMINEMAIL})<br /><br />----------------------------------------------<br />Click here to do the survey:<br />{SURVEYURL}","Survey registration confirmation","Dear {FIRSTNAME},<br /><br />You, or someone using your email address, have registered to participate in an online survey titled {SURVEYNAME}.<br /><br />To complete this survey, click on the following URL:<br /><br />{SURVEYURL}<br /><br />If you have any questions about this survey, or if you did not register to participate and believe this email is in error, please contact {ADMINNAME} at {ADMINEMAIL}.","Confirmation of completed survey","Dear {FIRSTNAME},<br /><br />This email is to confirm that you have completed the survey titled {SURVEYNAME} and your response has been saved. Thank you for participating.<br /><br />If you have any further questions about this email, please contact {ADMINNAME} at {ADMINEMAIL}.<br /><br />Sincerely,<br /><br />{ADMINNAME}","1"

#
# QUOTA TABLE
#

#
# QUOTA_MEMBERS TABLE
#

#
# QUOTA_LANGUAGESETTINGS TABLE
#