public function __construct($userid, $connection, $dbPrefix)
{
$GLOBALS["dbPrefix"] = $dbPrefix;
$set = null;
$setid = -1;
$questionid = -1;
$answerid = -1;
foreach ($connection->query('SELECT * FROM ' . $GLOBALS["dbPrefix"] . 'question_set WHERE ownerid="' . $userid . '"') as $setRow) {
$set = new cardSet(s);
$set->setSetId($setRow['setid']);
$setid = $setRow['setid'];
$set->setSetName($setRow['setname']);
$set->setSetDescription($setRow['setdescription']);
foreach ($connection->query('SELECT * FROM ' . $GLOBALS["dbPrefix"] . 'question_question WHERE ' . $GLOBALS["dbPrefix"] . 'question_question.set="' . $setid . '";') as $questionRow) {
$question = new question();
$question->setId($questionRow['questionid']);
$question->setQuestion($questionRow['question']);
$question->setMode($questionRow['mode']);
$question->setRightAnswered($questionRow['rightAnswered']);
$question->setWrongAnswered($questionRow['wrongAnswered']);
$questionid = $questionRow['questionid'];
foreach ($connection->query('SELECT * FROM ' . $GLOBALS["dbPrefix"] . 'question_answer WHERE ' . $GLOBALS["dbPrefix"] . 'question_answer.ownerquestion=' . $questionid) as $answerRow) {
$answerobj = new answer();
$answerobj->setAnswer($answerRow['answertext']);
$answerobj->setAnswerId($answerRow['answerid']);
$question->addAnswer($answerobj);
}
$set->addQuestion($question);
}
array_push($this->sets, $set);
}
}
public function __construct($userid, $connection)
{
$set = null;
$setid = -1;
$questionid = -1;
$answerid = -1;
foreach ($connection->query('SELECT * FROM fullQuestionSet WHERE ownerid="' . $userid . '"') as $row) {
if ($row['setid'] != $setid) {
$set = new cardSet();
$set->setSetId($row['setid']);
$set->setSetName($row['setname']);
$set->setSetDescription($row['setdescription']);
}
if ($questionid != $row['questionid'] && $row['questionid'] != null) {
$question = new question();
$question->setId($row['questionid']);
$question->setQuestion($row['question']);
$question->setMode($row['mode']);
$question->setRightAnswered($row['rightAnswered']);
$question->setWrongAnswered($row['wrongAnswered']);
}
if ($answerid != $row['answerid'] && $row['answerid'] != null) {
$answerobj = new answer();
$answerobj->setAnswer($row['answertext']);
$answerobj->setAnswerId($row['answerid']);
}
if ($answerid != $row['answerid'] && $row['answerid'] != null) {
$question->addAnswer($answerobj);
$answerid = $row['answerid'];
}
if ($questionid != $row['questionid'] && $row['questionid'] != null) {
$set->addQuestion($question);
$questionid = $row['questionid'];
}
if ($set != null && $row['setid'] != $setid) {
$setid = $row['setid'];
array_push($this->sets, $set);
}
}
}
