");
//allow for either $_GET or $_POST methods
//the link from question_list.php passes question_id and subquestion as $_GET
//while file submission happens via $_POST
$form_id = (isset($_GET['form_id']))? $_GET['form_id'] : $_POST['form_id'];
$section = (isset($_GET['section']))? $_GET['section'] : $_POST['section'];
$audio_path_field = sprintf("%s_audio_path",$section);
if(isset($_POST['section_text'])) {
$sql_update_section = sprintf("update form set %s='%s' where form_id = %d",$section,$_POST['section_text'],$form_id);
mysql_update($sql_update_section);
}
if(isset($_POST['submit_audio'])) {
$tmp_filename = $_FILES['audio_file']['tmp_name'];
$orig_name = $_FILES['audio_file']['name'];
$dotloc = strrpos($orig_name,".");
if(!$dotloc)
printf("Please submit a file with a valid filename extension.");
$extension = substr($orig_name,$dotloc+1);
$dest_fname = sprintf("formID_%d_%s.%s",$form_id,$section,$extension);
$dest_fullpath = $form_head_foot_audio_path. "/" . $dest_fname;
if(!is_uploaded_file($tmp_filename))
die("Error with file upload.");
$move_succeeded = move_uploaded_file($tmp_filename,$dest_fullpath);
if(!$move_succeeded)
die("Error moving file to destination");
chmod($dest_fullpath,0755);
$sql_add_audio_path = sprintf("update form set %s = \"%s\" where form_id=%d",
$audio_path_field,$dest_fname,$form_id);
mysql_update($sql_add_audio_path);
}
$sql_get_form_info = sprintf("select %s,%s,locked from form where form_id = %d",
$section,$audio_path_field,$form_id);
$row_form_info = mysql_select($sql_get_form_info);
printf("Form ID: %d",$form_id);
if($row_form_info['locked'] != 'T') {
printf("%s text:",ucfirst($section));
printf("\n\n");
}
else {
print "form locked ";
}
print " ";
printf("");
print "Audio Assigned:";
if(!empty($row_form_info[$audio_path_field])) {
printf(" Yes ");
printf("Click button to review: ");
$quest_audio_url= $form_head_foot_url_dir . "/" . $row_form_info[$audio_path_field];
$flashOptions['audio_player'] = "play_audio_button.swf";
$flashOptions['urls'][0] = $quest_audio_url;
$flashOptions['width'] = 75;
$flashOptions['height'] = 75;
play_audio_stimuli_flash($flashOptions);
}
else {
printf(" No");
}
print " |