public function selectUserById($userId)
{
$connector = new DBConnector();
$connection = $connector->createConnection();
$query = 'SELECT name, lastname, password, alive FROM users u WHERE u.alive=1 AND u.id=' . $userId;
$result = mysql_query($query) or die("Error in query: {$query}. " . mysql_error());
if (!$result || mysql_num_rows($result) == 0) {
return false;
}
$data = mysql_fetch_assoc($result);
$name = $data['name'];
$lastname = $data['lastname'];
$password = $data['password'];
$alive = $data['alive'];
mysql_free_result($result);
$id = intval($userId);
$query = 'SELECT * FROM userinfo u WHERE u.FK_users=' . $userId;
$result = mysql_query($query) or die("Error in query: {$query}. " . mysql_error());
$data = mysql_fetch_row($result);
$user = new User($name, $lastname, $password, $data[2], $data[3], $data[4], $data[5], $data[6], $data[7], $data[8], $data[9], $alive);
$user->setId($id);
mysql_free_result($result);
mysql_close($connection);
return $user;
}
public static function filterQueries($queries, $user)
{
$result = array();
foreach ($queries as $qid => $title) {
$qdao = new QueryDAO();
$segments = $qdao->getSegmentsByQueryId($qid);
$tristate = User::createPropertyMap(0);
foreach (array_values($segments) as $segment) {
$prop = $segment[0];
$value = $segment[1];
if ($tristate[$prop] != 1) {
$tristate[$prop] = User::indexOfUserValue($prop, $user) == $value ? 1 : -1;
}
}
$applies = true;
foreach (array_values($tristate) as $value) {
if ($value == -1) {
$applies = false;
break;
}
}
if ($applies) {
$result[$qid] = $title;
}
}
return $result;
}
public function modifyUser()
{
$username = $_POST['userName'];
$userLastName = $_POST['userLastName'];
$userPassword = $_POST['password'];
$passwordAgain = $_POST['rePassword'];
$userDao = new UserDao();
$userInfoDao = new UserInfoDao();
$uid = getUID();
$user = $userDao->selectUserById($uid);
$user->lastName = $userLastName;
$user->password = $userPassword;
$user->name = $username;
User::readProperties($user, $_POST);
$user->setInstitutionName($_POST['InstitutionName']);
$userDao->updateUser($user, $uid);
$userInfoDao->modifyUserInfo($id, $user);
}
$dao->initTransaction();
$dao->persistNewQuery($queryName, $uid);
for ($i = 0; $i < $qlength; $i++) {
$dao->persistQuestion($_POST['questionname' . $i]);
switch ($_POST['answers' . $i]) {
case 'yesno':
$dao->persistAnswer("Yes", 0);
$dao->persistAnswer("No", 1);
break;
case 'lml':
$dao->persistAnswer("A lot", 0);
$dao->persistAnswer("Medium", 1);
$dao->persistAnswer("Low", 2);
break;
case 'mf':
$dao->persistAnswer("Male", 0);
$dao->persistAnswer("Female", 1);
break;
case 'please':
$dao->persistAnswer("Yes please!", 0);
$dao->persistAnswer("No thanks!", 1);
break;
}
}
for ($i = 0; $i < $filterslength; $i++) {
$cat = $_POST['filtercat' . $i];
$pop = User::indexOfSelectValue($cat, $_POST['filterpop' . $i]);
$dao->persistSegment($cat, $pop);
}
$dao->endTransaction();
header("Location: /Qnet/target/classes/php/qnet/ui/newquery.php?commit=ok");
value="<?php
echo $DefaultInstitutionName;
?>
"/>
</div>
</fieldset>
<fieldset>
<legend>Other information</legend>
<div>
<?php
User::printOptionsFor(User::$LOCATION, $default_country);
?>
</div>
<div>
<?php
User::printOptionsFor(User::$RELIGION, $default_religion);
?>
</div>
</fieldset>
<fieldset id="termsArea">
<legend>Term and Conditions</legend>
<div id="terms" class="terms">
<h3>Statement of Rights and Responsibilities</h3>
<p>
This Statement of Rights and Responsibilities (Statement) derives from the Qnet Principles, and
governs our relationship with users and others who interact with Qnet. By using or accessing
Qnet, you agree to this Statement.
</p>
<h3>1.Privacy</h3>
echo $i;
?>
" id="var<?php
echo $i;
?>
">
<?php
if ($i != 1) {
echo '<option value="NONE">--------</option>';
}
while ($controller->hasMoreQuestions()) {
$controller->moveNext();
echo '<option value="' . $controller->getQuestionId() . '">' . $controller->getQuestionName() . '</option>';
}
$controller->backToStart();
User::printPropertiesOptions();
?>
</select>
<br/>
<?php
}
?>
</fieldset>
<input type="submit" class="button2" value="Publicar"/>
</form>
</div>
</div>
</div>
<?php
include "fragment/sidebar.php";
?>
public function legendFor($var)
{
if ($this->sdao->getVarType($var) == "uVar") {
return User::propertyValues($this->sdao->getVarValue($var));
} else {
if ($this->sdao->getVarType($var) == "qVar") {
return $this->adao->getOptionNames($this->sdao->getVarValue($var));
}
}
}
use Qnet\Dao\UserDAO;
use Qnet\Model\User;
use Qnet\Controller\LoginController;
//check_logged();
session_start();
$c = new LoginController();
$dao = new UserDAO();
$validator = new Validator();
$fieldErrors = $validator->validate();
$validateCaptcha = $validator->validateCaptcha();
if ($dao->getUserIdByMail($_POST['mail']) > 0) {
array_push($fieldErrors, "mail:Mail Already Exits");
}
if ($validateCaptcha && empty($fieldErrors)) {
$user = new User($_POST['userName'], $_POST['userLastName'], $_POST['mail'], $_POST['password'], $_POST['day'] . '-' . $_POST['month'] . '-' . $_POST['year'], null, null, null, $_POST['institutionName'], null, null);
User::readProperties($user, $_POST);
$dao->registerUser($user);
$c->login($_POST['userName'], $_POST['password']);
cleanSessionAfterLogin();
header("Location: viewprofile.php");
// header("Location: /Qnet/target/classes/php/qnet/ui/viewprofile.php");
} else {
$_SESSION["completeForm"] = true;
$_SESSION["userName"] = $_POST["userName"];
$_SESSION["userLastName"] = $_POST["userLastName"];
$_SESSION["mail"] = $_POST["mail"];
$_SESSION["day"] = $_POST["day"];
$_SESSION["month"] = $_POST["month"];
$_SESSION["year"] = $_POST['year'];
$_SESSION["institutionName"] = $_POST['institutionName'];
$_SESSION[User::$GENDER] = $_POST[User::$GENDER];
<input type="text" name="InstitutionName" id="InstitutionName" value="<?php
echo $institutionName;
?>
" />
</div>
</fieldset>
<fieldset>
<legend>Other information</legend>
<div>
<?php
User::printOptionsFor(User::$LOCATION, $country);
?>
</div>
<div>
<?php
User::printOptionsFor(User::$RELIGION, $religion);
?>
</div>
</fieldset>
<div><input id="submitSignUpButton" type="submit"></div>
</form>
</div>
</div>
</div>
<?php
include "fragment/sidebar.php";
?>
<div style="clear: both;"> </div>
</div>
<?php
include "fragment/footer.php";
<div id="filter" class="qbox" style="display: none;">
<fieldset>
<div>
<label class="mylabelstyle" for="filtercatX">Category:</label>
<select name="filtercatX" id="filtercatX">
<?php
User::printPropertiesOptions();
?>
</select>
</div>
<div>
<label class="mylabelstyle" for="filterpopX">Population:</label>
<select name="filterpopX" id="filterpopX">
<?php
User::printSimpleOptionsFor(User::$FIRST_PROPERTY);
?>
</select>
</div>
</fieldset>
</div>
<div id="page">
<div id="content">
<div class="post">
<h2 class="title">Make your very own online query!</h2>
<div class="entry">
<?php
if ($_GET['commit'] == 'ok') {
echo '<p>Congratulations! Your query has been published.</p>';
value="<?php
echo $DefaultInstitutionName;
?>
"/>
</div>
</fieldset>
<fieldset>
<legend>Other information</legend>
<div>
<?php
User::printOptionsFor(User::$LOCATION);
?>
</div>
<div>
<?php
User::printOptionsFor(User::$RELIGION);
?>
</div>
</fieldset>
<fieldset id="termsArea">
<legend>Term and Conditions</legend>
<div id="terms" class="terms">
<h3>Statement of Rights and Responsibilities</h3>
<p>
This Statement of Rights and Responsibilities (Statement) derives from the Qnet Principles, and
governs our relationship with users and others who interact with Qnet. By using or accessing
Qnet, you agree to this Statement.
</p>
<h3>1.Privacy</h3>
<?php
require_once dirname(__FILE__) . '\\..\\util.php';
require_model("User");
use Qnet\Model\User;
$category = $_GET["category"];
User::printSimpleOptionsFor($category);
