<div class="desc" style="margin-bottom:20px;">
<?php
echo nl2br($study_desc, false);
?>
</div>
<?php
if ($study_type == '360') {
?>
<ul class="studiu_360">
<li>
<?php
$liste = get_list_for_study($study_id);
while ($lista = mysql_fetch_array($liste)) {
$subjects = get_subj_for_list($lista['list_id']);
while ($subject = mysql_fetch_array($subjects)) {
$sel_subjects[] = $subject['subj_id'];
}
}
$sel_subjects = array_unique($sel_subjects);
$sub_neevaluati = array();
foreach ($sel_subjects as $rel_subject_id) {
$query = "SELECT rel_subj_id FROM multievaluator\n\t\t\t\t\t\t\t\t\tWHERE `subj_id` = '" . $subject_id . "' AND `rel_subj_id` = '" . $rel_subject_id . "' AND `study_id` = '" . $study_id . "'";
$tester = mysql_query($query, $dbconnect);
//
if (mysql_numrows($tester) == 0) {
$subj = mysql_fetch_array($tester);
$sub_neevaluati[] = $rel_subject_id;
}
}
} else {
$query = "REPLACE INTO mails (`study_id`, `subj_id`, `nume`, `email`, `titlu`, `body`)\n\t\t\t\t\t\t\t\t\tVALUES ('" . $study_id . "', '" . $subj_id . "', '" . $subj_name . "', '" . $subj_email . "', '" . $title . "', '" . $template_body . "');";
}
$result = mysql_query($query, $dbconnect);
confirm_query($result);
$sel_subjects[] = $subj_id;
}
}
}
$rel_list = get_sel_list_for_study($study_id);
foreach ($rel_list as $tester) {
if (!in_array((int) $tester, $sel_list)) {
$query = "DELETE FROM rel_list_study WHERE list_id = '" . $tester . "' AND study_id = '" . $study_id . "'";
$result = mysql_query($query, $dbconnect);
confirm_query($result);
$subjects = get_subj_for_list($tester);
while ($row = mysql_fetch_array($subjects)) {
$subj_id = $row['subj_id'];
if (!in_array((int) $subj_id, $sel_subjects)) {
$query = "DELETE FROM mails\n\t\t\t\t\t\t\t\tWHERE study_id = '" . $study_id . "' AND subj_id = '" . $subj_id . "' AND status = 0;\n\t\t\t\t\t\t\t\t";
$result = mysql_query($query, $dbconnect);
confirm_query($result);
echo $query . "<br />";
}
}
}
}
if ($sel_template != null) {
$rel_template = get_rel_template_id_for_study($study_id);
if ($sel_template != $rel_template) {
$query = "DELETE FROM rel_studies_email WHERE email_id = '" . $rel_template . "';\n\t\t\t\t";
:</strong>
<?php
if ($list_public == 1) {
__("public list");
} else {
__("private list");
}
?>
</p>
<p><strong><?php
__("Subjects");
?>
:</strong></p>
<ul>
<?php
$subjects = get_subj_for_list($list_id);
while ($row = mysql_fetch_array($subjects)) {
$subj_id = $row["subj_id"];
$subj_first_name = $row["first_name"];
$subj_last_name = $row["last_name"];
?>
<li><a href="view_subject.php?subj_id=<?php
echo $subj_id;
?>
"><?php
echo $subj_first_name . " " . $subj_last_name;
?>
</a></li>
<?php
}
?>
