function vqi($btid, $kb, $qid)
{
global $db;
$sql = "INSERT INTO\n\t\tocrkbboxgroup (btid,kb,qid)\n\t\tVALUES('{$btid}','{$kb}','{$qid}')";
$db->Execute($sql);
}
if (isset($_GET['qid'])) {
$qid = intval($_GET['qid']);
if (isset($_GET['submit'])) {
$db->StartTrans();
$sql = "DELETE \n\t\t\tFROM ocrkbboxgroup\n\t\t\tWHERE qid = '{$qid}'";
$db->Execute($sql);
foreach ($_GET as $g => $v) {
$a = explode("_", $g);
if ($a[0] == "cb") {
vqi($a[2], $a[1], $qid);
}
}
$db->CompleteTrans();
}
$sql = "SELECT kb,description\n\t\tFROM ocrkb\n\t\tORDER by kb ASC";
$ocrkb = $db->GetAll($sql);
$sql = "SELECT btid,description\n\t\tFROM boxgrouptypes\n\t\tWHERE btid = 4 or btid = 3\n\t\tORDER by btid ASC";
$boxgrouptypes = $db->GetAll($sql);
xhtml_head(T_("Assign ICR KB to questionnaire"), false, array("../css/table.css"));
$sql = "SELECT description\n\t\tFROM questionnaires\n\t\tWHERE qid = '{$qid}'";
$rs = $db->GetRow($sql);
print "<p><a href='?'>" . T_("Go back") . "</a></p>";
print "<h1>" . $rs['description'] . "</h1>";
?>
<script type="text/javascript">
$db->Execute($sql);
}
function vqd($vid, $qid)
{
global $db;
$sql = "DELETE FROM\r\n\t\tverifierquestionnaire \r\n\t\tWHERE vid = '{$vid}' and qid = '{$qid}'";
$db->Execute($sql);
}
if (isset($_POST['submit'])) {
$db->StartTrans();
$sql = "DELETE \r\n\t\tFROM verifierquestionnaire\r\n\t\tWHERE 1";
$db->Execute($sql);
foreach ($_POST as $g => $v) {
$a = explode("_", $g);
if ($a[0] == "cb") {
vqi($a[2], $a[1]);
}
}
$db->CompleteTrans();
}
$sql = "SELECT qid,description\r\n\tFROM questionnaires\r\n\tORDER by qid DESC";
$questionnaires = $db->GetAll($sql);
$sql = "SELECT vid,description\r\n\tFROM verifiers\r\n\tORDER by vid ASC";
$verifiers = $db->GetAll($sql);
xhtml_head(T_("Assign verifier to questionnaire"), false, array("../css/table.css"));
?>
<script type="text/javascript">
<?php
print "qid = new Array(";
$s = "";
/*Currently disabled -> need to decide how to manage permissions set earlier*/
/* $questionnaires = $db->GetAll("SELECT lime_sid FROM questionnaire WHERE enabled = 1");
$clients = $db->GetAll("SELECT uid FROM client, " . LIME_PREFIX . "users WHERE `users_name` = `username`");
foreach($questionnaires as $q){
foreach($clients as $v){
$sql = "DELETE FROM " . LIME_PREFIX . "survey_permissions WHERE `uid` = {$v['uid']} AND `sid`={$q['lime_sid']} AND `uid` != 1";
$db->Execute($sql);
}
} */
/* - end - */
foreach ($_POST as $g => $v) {
$a = explode("_", $g);
if ($a[0] == "cb") {
vqi($a[2], $a[1], $a[3], $a[4]);
}
}
$db->CompleteTrans();
}
/* delete client from quexs and lime tables*/
//requires data-toggle-confirmation to finalize
if (isset($_GET['delete']) && isset($_GET['uid']) && isset($_GET['uname'])) {
$client_id = intval($_GET['delete']);
$uid = intval($_GET['uid']);
$uname = $_GET['uname'];
global $db;
if ($uid != 1) {
//double protect superadmin from being deleted
$db->StartTrans();
$sql = "DELETE FROM " . LIME_PREFIX . "templates_rights WHERE `uid` = '{$uid}' AND `uid` != 1";
