$db->Execute($sql);
unset($_SESSION['boxgroups']);
unset($_SESSION['pages']);
unset($_SESSION['boxes']);
session_unset();
$sql = "UPDATE verifiers\r\n\t\tSET currentfid = NULL\r\n\t\tWHERE vid = '{$vid}'";
//print "$sql</br>";
$db->Execute($sql);
$db->CompleteTrans();
//if XMLRPC is set - upload this form via XMLRPC
$sql = "SELECT rpc_server_url \r\n\t\tFROM questionnaires\r\n\t\tWHERE qid = '{$qid}'";
$rpc = $db->GetRow($sql);
if (isset($rpc['rpc_server_url']) && !empty($rpc['rpc_server_url'])) {
//upload form via RPC
include_once "functions/functions.output.php";
uploadrpc($fid);
}
$fid = false;
}
if (isset($_GET['review'])) {
foreach ($_SESSION['boxgroups'] as $key => $val) {
$_SESSION['boxgroups'][$key]['done'] = 0;
}
}
if (isset($_GET['clear'])) {
unset($_SESSION['boxgroups']);
unset($_SESSION['pages']);
unset($_SESSION['boxes']);
session_unset();
}
if (isset($_POST['assign'])) {
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
* GNU General Public License for more details.
*
* You should have received a copy of the GNU General Public License
* along with queXF; if not, write to the Free Software
* Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA 02110-1301 USA
*
*/
include_once "../config.inc.php";
include_once "../db.inc.php";
include "../functions/functions.database.php";
include "../functions/functions.xhtml.php";
xhtml_head(T_("queXS and Limesurvey integration"), true, array("../css/table.css"));
if (isset($_GET['fid'])) {
include_once "../functions/functions.output.php";
uploadrpc(intval($_GET['fid']));
}
if (isset($_GET['qid'])) {
print "<p><a href='?'>" . T_("Go back") . "</a></p>";
$qid = intval($_GET['qid']);
if (isset($_POST['submit'])) {
$sql = "UPDATE questionnaires\r\n\t\t\tSET \r\n\t\t\trpc_server_url = " . $db->quote($_POST['rpc_server_url']) . ",\r\n\t\t\trpc_username = "******",\r\n\t\t\trpc_password = "******",\r\n\t\t\tlimesurvey_sid = " . intval($_POST['limesurvey_sid']) . "\r\n\t\t\tWHERE qid = '{$qid}'";
$db->Execute($sql);
}
$sql = "SELECT description,rpc_server_url,rpc_username,rpc_password,limesurvey_sid\r\n\t\tFROM questionnaires\r\n\t\tWHERE qid = '{$qid}'";
$q = $db->GetRow($sql);
print "<h2>" . $q['description'] . "</h2>";
print "<form action='?qid={$qid}' method='post'>";
print "<p><label for='rpc_server_url'>" . T_("RPC Server URL (example: http://user:password@localhost/quexs/include/limesurvey/admin/remotecontrol.php)") . "</label> <input id='rpc_server_url' name='rpc_server_url' type='text' value='{$q['rpc_server_url']}' size='100'/></p>";
print "<p><label for='rpc_username'>" . T_("RPC Username") . "</label> <input id='rpc_username' name='rpc_username' type='text' value='{$q['rpc_username']}'/></p>";
print "<p><label for='rpc_password'>" . T_("RPC Password") . "</label> <input id='rpc_password' name='rpc_password' type='text' value='{$q['rpc_password']}'/></p>";
