📄 surveymanager.lib.php
字号:
$introduction=addslashes($obj->introduction);
$sql_insert = "INSERT INTO $curr_dbname.survey_group(group_id,survey_id,groupname,introduction) values('','$newsurveyid','$groupname','$introduction')";
$resnext = api_sql_query($sql_insert,__FILE__,__LINE__);
$groupid = mysql_insert_id();
$sql_q = "SELECT * FROM $db_name.questions WHERE gid = '$obj->group_id'";
$res_q = api_sql_query($sql_q,__FILE__,__LINE__);
while($obj_q = mysql_fetch_object($res_q))
{
$caption1=addslashes($obj_q->caption);
$a1=addslashes($obj_q->a1);
$a2=addslashes($obj_q->a2);
$a3=addslashes($obj_q->a3);
$a4=addslashes($obj_q->a4);
$a5=addslashes($obj_q->a5);
$a6=addslashes($obj_q->a6);
$a7=addslashes($obj_q->a7);
$a8=addslashes($obj_q->a8);
$a9=addslashes($obj_q->a9);
$a10=addslashes($obj_q->a10);
$at=addslashes($obj_q->at);
$ad=addslashes($obj_q->ad);
$r1=addslashes($obj_q->r1);
$r2=addslashes($obj_q->r2);
$r3=addslashes($obj_q->r3);
$r4=addslashes($obj_q->r4);
$r5=addslashes($obj_q->r5);
$r6=addslashes($obj_q->r6);
$r7=addslashes($obj_q->r7);
$r8=addslashes($obj_q->r8);
$r9=addslashes($obj_q->r9);
$r10=addslashes($obj_q->r10);
$sql_sort = "SELECT max(sortby) AS sortby FROM $curr_dbname.questions ";
$res_sort=api_sql_query($sql_sort);
$rs=mysql_fetch_object($res_sort);
$sortby=$rs->sortby;
if(empty($sortby))
{$sortby=1;}
else{$sortby=$sortby+1;}
$sql_q_insert = "INSERT INTO $curr_dbname.questions (qid,gid,survey_id,qtype,caption,alignment,sortby,a1,a2,a3,a4,a5,a6,a7,a8,a9,a10,at,ad,r1,r2,r3,r4,r5,r6,r7,r8,r9,r10) values('','$groupid','$newsurveyid','$obj_q->qtype','$caption1','$obj_q->alignment','$sortby','$a1','$a2','$a3','$a4','$a5','$a6','$a7','$a8','$a9','$a10','$at','$ad','$r1','$r2','$r3','$r4','$r5','$r6','$r7','$r8','$r9','$r10')";
api_sql_query($sql_q_insert,__FILE__,__LINE__);
}
}
}
function update_group($groupid,$surveyid,$groupnamme,$introduction,$curr_dbname)
{
$sql = "UPDATE $curr_dbname.survey_group SET group_id='$groupid', survey_id='$surveyid', groupname='$groupnamme', introduction='$introduction' WHERE group_id='$groupid'";
api_sql_query($sql, __FILE__, __LINE__);
}
/*
function insert_old_groups($sid,$gids,$table_group,$table_question)
{
$gid_arr = explode(",",$gids);
$index = count($gid_arr);
($gid_arr);
for($p=0;$p<$index;$p++)
{
$sql = "SELECT * FROM $table_group WHERE group_id = '$gid_arr[$p]'";
$res = api_sql_query($sql);
$obj = mysql_fetch_object($res);
$gname = $obj->groupname;
if($gname=='Default')
{
$query = "SELECT * FROM $table_group WHERE survey_id = '$sid' AND groupname = 'Default'";
$result = api_sql_query($query);
$object = mysql_fetch_object($result);
$gid = $object->group_id;
$sql_def_check = "SELECT * FROM $table_question WHERE gid = '$gid'";
$res_def_check = api_sql_query($sql_def_check);
$count_def_check = mysql_num_rows($res_def_check);
for($ctr=0;$ctr<$count_def_check;$ctr++)
{
$imp[]=mysql_result($res_def_check,$ctr,"imported_group");
}
$imp = @array_unique($imp);
if(!@in_array($gid_arr[$p],$imp))
{
$sql_ques = "SELECT * FROM $table_question WHERE gid= '$gid_arr[$p]'";
$res_ques = api_sql_query($sql_ques);
$num = mysql_num_rows($res_ques);
while($obj_ques = mysql_fetch_object($res_ques))
{
$temp_qtype = $obj_ques->qtype;
$temp_caption = $obj_ques->caption;
$anst = $obj_ques->at;
$ansd = $obj_ques->ad;
$y="";
$x="";
for($i=1;$i<=10;$i++)
{
$temp = "a".$i;
$x.= "'".$obj_ques->$temp."',";
}
for($j=1;$j<=10;$j++)
{
if($j==10)
{
$temps = "r".$j;
$y.= "'".$obj_ques->$temps."'";
}
else
{
$temps = "r".$j;
$y.= "'".$obj_ques->$temps."',";
}
}
$sql_ques_insert = "INSERT INTO $table_question (qid,gid,qtype,caption,a1,a2,a3,a4,a5,a6,a7,a8,a9,a10,at,ad,r1,r2,r3,r4,r5,r6,r7,r8,r9,r10,imported_group) values('','$gid','$temp_qtype','$temp_caption',$x'$anst','$ansd',$y,'$gid_arr[$p]')";
$res_ques_insert = api_sql_query($sql_ques_insert);
}
}
else
{
$flag = 1;
}
}
else
{
$intro = $obj->introduction;
$sql_check = "SELECT * FROM $table_group WHERE survey_id = '$sid'";
$res_check = api_sql_query($sql_check);
$num_check = mysql_num_rows($res_check);
for($k=0;$k<$num_check;$k++)
{
$imp[]=mysql_result($res_check,$k,"imported_group");
}
$imp = @array_unique($imp);
if(!@in_array($gid_arr[$p],$imp))
{
$sql_insert = "INSERT INTO $table_group(group_id,survey_id,groupname,introduction,imported_group) values('','$sid','$gname','$intro','$gid_arr[$p]')";
$res_insert = api_sql_query($sql_insert);
$new_gid = mysql_insert_id();
$sql_ques = "SELECT * FROM $table_question WHERE gid= '$gid_arr[$p]'";
$res_ques = api_sql_query($sql_ques);
$num = mysql_num_rows($res_ques);
while($obj_ques = mysql_fetch_object($res_ques))
{
$temp_qtype = $obj_ques->qtype;
$temp_caption = $obj_ques->caption;
$anst = $obj_ques->at;
$ansd = $obj_ques->ad;
$y="";
$x="";
for($i=1;$i<=10;$i++)
{
$temp = "a".$i;
$x.= "'".$obj_ques->$temp."',";
}
for($j=1;$j<=10;$j++)
{
if($j==10)
{
$temps = "r".$j;
$y.= "'".$obj_ques->$temps."'";
}
else
{
$temps = "r".$j;
$y.= "'".$obj_ques->$temps."',";
}
}
$sql_ques_insert = "INSERT INTO $table_question (qid,gid,qtype,caption,a1,a2,a3,a4,a5,a6,a7,a8,a9,a10,at,ad,r1,r2,r3,r4,r5,r6,r7,r8,r9,r10,imported_group) values('','$new_gid','$temp_qtype','$temp_caption',$x'$anst','$ansd',$y,'$gid_arr[$p]')";
$res_ques_insert = api_sql_query($sql_ques_insert);
}
}
else
{
$flag = 1;
}
}
}
return ($flag);
}
*/
function insert_old_groups($sid,$gids,$table_group,$table_question,$db_name,$cidReq)
{
$table_course = Database :: get_main_table(TABLE_MAIN_COURSE);
$sql = "SELECT * FROM $table_course WHERE code = '$cidReq'";
$res = api_sql_query($sql,__FILE__,__LINE__);
$obj_name=@mysql_fetch_object($res);
$current_db_name = $obj_name->db_name ;
$gid_arr = explode(",",$gids);
$index = count($gid_arr);
($gid_arr);
for($p=0;$p<$index;$p++)
{
$sql = "SELECT * FROM $db_name.survey_group WHERE group_id = '$gid_arr[$p]'";
$res = api_sql_query($sql);
$obj = mysql_fetch_object($res);
$gname = $obj->groupname;
if($gname=='No Group')
{
$query = "SELECT * FROM $db_name.survey_group WHERE survey_id = '$sid' AND groupname = 'No Group'";
$result = api_sql_query($query);
$object = mysql_fetch_object($result);
$gid = $object->group_id;
$sql_def_check = "SELECT * FROM $db_name.questions WHERE gid = '$gid'";
$res_def_check = api_sql_query($sql_def_check);
$count_def_check = mysql_num_rows($res_def_check);
for($ctr=0;$ctr<$count_def_check;$ctr++)
{
$imp[]=mysql_result($res_def_check,$ctr,"imported_group");
}
$imp = @array_unique($imp);
$gid_arr[$p];
if(!@in_array($gid_arr[$p],$imp))
{
$sql_ques = "SELECT * FROM $db_name.questions WHERE gid= '$gid_arr[$p]'";
$res_ques = api_sql_query($sql_ques);
$num = mysql_num_rows($res_ques);
while($obj_ques = mysql_fetch_object($res_ques))
{
$temp_qtype = $obj_ques->qtype;
$temp_caption = $obj_ques->caption;
$anst = $obj_ques->at;
$ansd = $obj_ques->ad;
$y="";
$x="";
for($i=1;$i<=10;$i++)
{
$temp = "a".$i;
$x.= "'".$obj_ques->$temp."',"; /*this variable contains concatenated values and need to be refreshed each time before the loop starts!*/
}
for($j=1;$j<=10;$j++)
{
if($j==10)
{
$temps = "r".$j;
$y.= "'".$obj_ques->$temps."'";
}
else
{
$temps = "r".$j;
$y.= "'".$obj_ques->$temps."',";
}
}
$sql_ques_insert = "INSERT INTO $current_db_name.questions (qid,gid,qtype,caption,a1,a2,a3,a4,a5,a6,a7,a8,a9,a10,at,ad,r1,r2,r3,r4,r5,r6,r7,r8,r9,r10,imported_group) values('','$gid','$temp_qtype','$temp_caption',$x'$anst','$ansd',$y,'$gid_arr[$p]')";
$res_ques_insert = api_sql_query($sql_ques_insert);
}
}
else
{
$flag = 1;
}
}
else
{
$intro = $obj->introduction;
$sql_check = "SELECT * FROM $db_name.survey_group WHERE survey_id = '$sid'";
$res_check = api_sql_query($sql_check);
$num_check = mysql_num_rows($res_check);
for($k=0;$k<$num_check;$k++)
{
$imp[]=mysql_result($res_check,$k,"imported_group");
}
$imp = @array_unique($imp);
if(!@in_array($gid_arr[$p],$imp))
{
$sql_insert = "INSERT INTO $current_db_name.survey_group(group_id,survey_id,groupname,introduction,imported_group) values('','$sid','$gname','$intro','$gid_arr[$p]')";
$res_insert = api_sql_query($sql_insert);
$new_gid = mysql_insert_id();
$sql_ques = "SELECT * FROM $db_name.questions WHERE gid= '$gid_arr[$p]'";
$res_ques = api_sql_query($sql_ques);
$num = mysql_num_rows($res_ques);
while($obj_ques = mysql_fetch_object($res_ques))
{
$temp_qtype = $obj_ques->qtype;
$temp_caption = $obj_ques->caption;
$anst = $obj_ques->at;
$ansd = $obj_ques->ad;
$y="";
$x="";
for($i=1;$i<=10;$i++)
{
$temp = "a".$i;
$x.= "'".$obj_ques->$temp."',"; /*this variable contains concatenated values and need to be refreshed each time before the loop starts!*/
}
for($j=1;$j<=10;$j++)
{
if($j==10)
{
$temps = "r".$j;
$y.= "'".$obj_ques->$temps."'";
}
else
{
$temps = "r".$j;
$y.= "'".$obj_ques->$temps."',";
}
}
$sql_ques_insert = "INSERT INTO $current_db_name.questions (qid,gid,qtype,caption,a1,a2,a3,a4,a5,a6,a7,a8,a9,a10,at,ad,r1,r2,r3,r4,r5,r6,r7,r8,r9,r10,imported_group) values('','$new_gid','$temp_qtype','$temp_caption',$x'$anst','$ansd',$y,'$gid_arr[$p]')";
$res_ques_insert = api_sql_query($sql_ques_insert);
}
}
else
{
$flag = 1;
}
}
}
return ($flag);
}
function import_question($surveyid,$qids,$table_group,$table_question,$db_name,$cidReq,$yes)
{
$table_course = Database :: get_main_table(TABLE_MAIN_COURSE);
$sql_course = "SELECT * FROM $table_course WHERE code = '$cidReq'";
$res_course = api_sql_query($sql_course,__FILE__,__LINE__);
$obj_name=@mysql_fetch_object($res_course);
$current_db_name = $obj_name->db_name ;
$qid=explode(",",$qids);
$count = count($qid);
for($i=0; $i<$count; $i++)
{
$sql_q = "SELECT * FROM $table_question WHERE qid = '$qid[$i]'";
$res_q = api_sql_query($sql_q,__FILE__,__LINE__);
$obj=@mysql_fetch_object($res_q);
$oldgid=$obj->gid;
$sql = "SELECT * FROM $table_group WHERE group_id = '$oldgid'";
$res = api_sql_query($sql,__FILE__,__LINE__);
$obj_gr = @mysql_fetch_object($res);
$gname = $obj_gr->groupname;
$gintro = $obj_gr->introduction;
$sql_gid = "SELECT * FROM $table_group WHERE survey_id = '$surveyid' AND groupname = '$gname'";
$res_gid = api_sql_query($sql_gid,__FILE__,__LINE__);
$num=mysql_num_rows($res_gid);
$obj_gid=@mysql_fetch_object($res_gid);
$sql_quesid = "SELECT * FROM $table_question WHERE gid = '$obj_gid->group_id' AND caption = '$obj->caption'";
$res_quesid = api_sql_query($sql_quesid,__FILE__,__LINE__);
$num_ques=mysql_num_rows($res_quesid);
if($num_ques>0)
{
$message=1;
//echo "<div align=\"center\"><strong><font color=\"#FF0000\">Already Imported !</font></strong></div>" ;
}
else
{
if($num>0 && $yes=="yes")
{
$sql_q_insert = "INSERT INTO $current_db_name.questions (qid,gid,qtype,caption,a1,a2,a3,a4,a5,a6,a7,a8,a9,a10,at,ad,r1,r2,r3,r4,r5,r6,r7,r8,r9,r10) values('','$obj_gid->group_id','$obj->qtype','$obj->caption','$obj->a1','$obj->a2','$obj->a3','$obj->a4','$obj->a5','$obj->a6','$obj->a7','$obj->a8','$obj->a9','$obj->a10','$obj->at','$obj->ad','$obj->r1','$obj->r2','$obj->r3','$obj->r4','$obj->r5','$obj->r6','$obj->r7','$obj->r8','$obj->r9','$obj->r10')";
api_sql_query($sql_q_insert,__FILE__,__LINE__);
}
else
{
$sql_ginsert="INSERT INTO $current_db_name.survey_group(group_id,survey_id,groupname,introduction) values('','$surveyid','$gname','$gintro')";
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -