$lastname = $_REQUEST["lastname"]; $from = $_REQUEST["from"]; $verif_box = $_REQUEST["verif_box"]; // check to see if verificaton code was correct // if verification code was correct send the message and show this page $fullname = $name . " " . $lastname; $vals = array('UserID' => $from, 'Real_name' => $fullname, 'First_name' => $name, 'Last_name' => $lastname, 'Pending_approval' => 'Y', 'Email' => $from); // check email address' uniqueness $result = $DB->pselectOne("SELECT COUNT(*) FROM users WHERE Email = :VEmail", array('VEmail' => $from)); if (Utility::isErrorX($result)) { return PEAR::raiseError("DB Error: " . $result->getMessage()); } if ($result == 0) { // insert into db only if email address if it doesnt exist $success = $DB->insert('users', $vals); if (Utility::isErrorX($success)) { return PEAR::raiseError("DB Error: " . $success->getMessage()); } } unset($_SESSION['tntcon']); //redirect to a new page header("Location: thank-you.html", true, 301); exit; } } /** * Check that the user input for a field meets minimum length requirements * * @param string $str The request parameter to check * @param integer $len The minimum length for the parameter *
* @package Main * @author Justin Kat <*****@*****.**> * @license Loris license * @link https://www.github.com/Jkat/Loris-Trunk/ */ set_include_path(get_include_path() . ":../../project/libraries:../../php/libraries:"); require_once "NDB_Client.class.inc"; $client = new NDB_Client(); $client->initialize("../../project/config.xml"); // create Database object $DB =& Database::singleton(); if (Utility::isErrorX($DB)) { print "Could not connect to database: " . $DB->getMessage() . "<br>\n"; die; } if (get_magic_quotes_gpc()) { // Magic quotes adds \ to description, get rid of it. $comments = stripslashes($_REQUEST['comments']); } else { // Magic quotes is off, so we can just directly use the description // since insert() will use a prepared statement. $comments = $_REQUEST['comments']; } $user =& User::singleton(); if (Utility::isErrorX($user)) { return PEAR::raiseError("User Error: " . $user->getMessage()); } //if user has document repository permission if ($user->hasPermission('document_repository_view') || $user->hasPermission('document_repository_delete')) { $DB->update('document_repository_categories', array('comments' => $comments), array('id' => $_REQUEST['id'])); }
* page via AJAX to update the email template with the current page * * PHP Version 5 * * @category Survey * @package Loris * @author Dave MacFarlane <*****@*****.**> * @license Loris license * @link https://www.github.com/aces/Loris-Trunk/ */ $user =& User::singleton(); if (!$user->hasPermission('user_accounts')) { header("HTTP/1.1 403 Forbidden"); exit; } set_include_path(get_include_path() . ":../project/libraries:../php/libraries:"); ini_set('default_charset', 'utf-8'); require_once "Database.class.inc"; require_once 'NDB_Config.class.inc'; require_once 'NDB_Client.class.inc'; $config =& NDB_Config::singleton(); $client = new NDB_Client(); $client->makeCommandLine(); $client->initialize(); $DB = Database::singleton(); $result = $DB->pselectOne("SELECT DefaultEmail FROM participant_emails WHERE Test_name=:TN", array('TN' => $_REQUEST['test_name'])); if (Utility::isErrorX($result) || empty($result)) { print ""; } else { print $result; }
} set_include_path(get_include_path() . ":../../project/libraries:../../php/libraries:"); require_once "NDB_Client.class.inc"; require_once "NDB_Config.class.inc"; require_once "Email.class.inc"; $client = new NDB_Client(); $client->initialize("../../project/config.xml"); $config = NDB_Config::singleton(); // create Database object $DB =& Database::singleton(); if (Utility::isErrorX($DB)) { print "Could not connect to database: " . $DB->getMessage() . "<br>\n"; die; } $action = $_POST['action']; if (Utility::isErrorX($userSingleton)) { return PEAR::raiseError("User Error: " . $userSingleton->getMessage()); } //if user has document repository permission if ($userSingleton->hasPermission('document_repository_view') || $userSingleton->hasPermission('document_repository_delete')) { if ($action == 'upload') { $user = $_POST['user']; $category = $_POST['category']; $site = $_POST['site']; $instrument = $_POST['instrument']; $pscid = $_POST['pscid']; $visit = $_POST['visit']; $comments = $_POST['comments']; $version = $_POST['version']; $fileSize = $_FILES["file"]["size"]; $fileName = $_FILES["file"]["name"];
$Fields[$field_name['SourceField']] = $field_name['SourceField']; } $tpl_data['FieldNames'] = $Fields; } } /* * create feedback object */ if (!empty($_REQUEST['commentID'])) { $feedback = NDB_BVL_Feedback::singleton($user->getUsername(), null, null, $_REQUEST['commentID']); } elseif (!empty($_REQUEST['sessionID'])) { $feedback = NDB_BVL_Feedback::singleton($user->getUsername(), null, $_REQUEST['sessionID']); } elseif (!empty($_REQUEST['candID'])) { $feedback = NDB_BVL_Feedback::singleton($user->getUsername(), $_REQUEST['candID']); } if (isset($feedback) && Utility::isErrorX($feedback)) { // if feedback object return an error $tpl_data['error_message'][] = $feedback->getMessage(); } elseif (isset($feedback) && !is_object($feedback)) { } elseif (isset($feedback)) { // define feedback level $tpl_data['feedbackLevel'] = $feedback->getFeedbackLevel(); // get list of types $feedbackTypes = NDB_BVL_Feedback::getFeedbackTypes(); if (PEAR::isError($feedbackTypes)) { $tpl_data['error_message'][] = $feedbackTypes->getMessage(); } else { $z = 0; foreach ($feedbackTypes as $val) { // Following are used for the "Add Feedback" Form $tpl_data['threadTypes'][$z]['Type'] = $val['Type'];
* @category Main * @package Loris * @author Rathi Sekaran <*****@*****.**> * @license Loris license * @link https://www.github.com/aces/Loris-Trunk/ */ set_include_path(get_include_path() . ":../project/libraries:../php/libraries:"); ini_set('default_charset', 'utf-8'); ob_start('ob_gzhandler'); require_once "NDB_Client.class.inc"; $client = new NDB_Client(); $client->initialize(); require_once "HelpFile.class.inc"; // create DB object $DB =& Database::singleton(); if (Utility::isErrorX($DB)) { return PEAR::raiseError("Could not connect to database: " . $DB->getMessage()); } // store some request information if (!empty($_REQUEST['helpID'])) { $helpID = $_REQUEST['helpID']; } else { if (!empty($_REQUEST['test_name'])) { $helpID = HelpFile::hashToID(md5($_REQUEST['test_name'])); } if (!empty($_REQUEST['test_name']) && !empty($_REQUEST['subtest'])) { $helpID = HelpFile::hashToID(md5($_REQUEST['subtest'])); } } $help_file = HelpFile::factory($helpID); $data = $help_file->toArray();
/** * Updates the status of the current key * * @param string $status The status to be updated to * * @return True on success, false on failure */ function updateStatus($status) { $DB = Database::singleton(); $currentStatus = $DB->pselectOne('SELECT Status FROM participant_accounts WHERE OneTimePassword=:key', array('key' => $this->key)); if (Utility::isErrorX($currentStatus)) { return false; } if ($currentStatus === 'Complete') { // Already completed, don't want to accidentally change it back to // started or some other status.. return false; } $DB->update("participant_accounts", array('Status' => $status), array('OneTimePassword' => $this->key)); return true; }
} /** * Get cmd-line arguments */ // get $action argument $action = $argv[1]; $ddeInstruments = $config->getSetting('DoubleDataEntryInstruments'); if ($action == 'all') { $allInstruments = Utility::getAllInstruments(); } else { $allInstruments = array($action => $action); } // clear the unresolved conflicts for all the instruments foreach ($allInstruments as $instrument => $Full_name) { $clear_conflicts = $db->pselect("SELECT CommentID, Test_name,\n CONCAT('DDE_', CommentID)\n AS DDECommentID\n FROM flag\n JOIN session s ON (s.ID=flag.SessionID)\n JOIN candidate c ON (c.CandID=s.CandID)\n WHERE Test_name=:testname AND CommentID\n NOT LIKE 'DDE%' AND s.Active='Y'\n AND c.Active='Y'", array('testname' => $instrument)); if (Utility::isErrorX($clear_conflicts)) { return PEAR::raiseError("Error, failed to clear conflicts: " . $clear_conflicts->getMessage()); } foreach ($clear_conflicts as $conflict) { ConflictDetector::clearConflictsForInstance($conflict['CommentID']); } } foreach ($ddeInstruments as $test) { $instruments = $db->pselect("SELECT CommentID, Test_name, CONCAT('DDE_',\n CommentID) AS DDECommentID\n FROM flag sde\n JOIN session s ON (s.ID=sde.SessionID)\n JOIN candidate c ON (c.CandID=s.CandID)\n WHERE sde.Test_name=:testname AND sde.CommentID\n NOT LIKE 'DDE%' AND sde.Data_entry='Complete'\n AND s.Active='Y' AND c.Active='Y'\n AND EXISTS (SELECT 'x' FROM flag dde WHERE\n dde.CommentID=CONCAT('DDE_',sde.CommentID)\n AND Data_entry='Complete')", array('testname' => $test)); foreach ($instruments as $instrument) { // If the instrument requires double data entry, check that DDE is also done if (in_array($instrument['Test_name'], $ddeInstruments)) { print "Recreating conflicts for " . $instrument['Test_name'] . ':' . $instrument['CommentID'] . "\n"; $diff = ConflictDetector::detectConflictsForCommentIds($instrument['Test_name'], $instrument['CommentID'], $instrument['DDECommentID']); ConflictDetector::recordUnresolvedConflicts($diff); }