All pastes #546380 Raw Edit

Unnamed

public php v1 · immutable
·published 2007-06-07 01:43 UTC
rendered paste body
	function add_quiz($title, $uid) {			$db = QzDB::get(); $qzid = (int) $qzid;		$db->escape($title);		if(!Qz_Data::is_qz($qzid)) {			return $db->query("INSERT INTO qz_quizzes(title, uid) VALUES('$title', '$uid')");		}	}	function get_quizzes($uid) {	$db = QzDB::get(); $uid = (int) $uid;	return $db->get_results("SELECT qzid, title FROM qz_quizzes WHERE uid = '$uid'");}	function add_question($question, $quiz_id) {	$db = QzDB::get();	$db->escape($question); $qzid = (int) $quiz_id;	$db->query("INSERT INTO qz_questions(question, qzid) VALUES('$question', '$qzid')");}				function get_quiz_title($qzid) {			$db = QzDB::get(); if(!is_int($qzid)) return;			return $db->get_var("SELECT title FROM qz_quizzes WHERE qzid = '$qzid'");		}				function get_questions($qzid) {			$db = QzDB::get(); if(!is_int($qzid)) return;			return $db->get_results("SELECT qid, question FROM qz_questions WHERE qzid = '$qzid'");		}				function get_responses($qid) {			$db = QzDB::get();			return $db->get_results("SELECT cid, choice FROM qz_choices WHERE qid = '$qid'");		}function get_outcomes($qzid) {	$db = QzDB::get(); if(!is_int($qzid)) return;	return $db->get_results("SELECT oid, outcome, description FROM qz_outcomes WHERE qzid = '$qzid'");}				function add_choice($choice, $qid) {			$db = QzDB::get();			$db->escape($choice); $qid = (int) $qid;			$db->query("INSERT INTO qz_choices(choice, qid) VALUES('$choice', '$qid')");		}		function map_outcome($cid, $oid) {		$db = QzDB::get();		if(!$db->get_var("SELECT COUNT(*) oid FROM qz_choice2outcome WHERE cid = '$cid'")) {			$db->query("INSERT INTO qz_choice2outcome(cid, oid) VALUES('$cid', '$oid')");		} else {			$db->query("UPDATE qz_choice2outcome SET oid='$oid' WHERE cid='$cid'");		}	}		function get_choice_outcome($cid) {		$db = QzDB::get();		return $db->get_var("SELECT oid FROM qz_choice2outcome WHERE cid = '$cid'");	}		function get_outcome($oid) {		$db = QzDB::get();		return $db->get_row("SELECT outcome, description FROM qz_outcomes WHERE oid = '$oid'");	}		function set_qz_title($title, $qzid) {		$db = QzDB::get();		if(!(is_numeric($qzid) && Qz_Data::is_qz($qzid))) return false;		$db->escape($title);		return $db->query("UPDATE qz_quizzes SET title = '$title' WHERE qzid = '$qzid'");	}		function is_qz($qzid) {		$db = QzDB::get(); $qzid = (int) $qzid;		return $db->get_var("SELECT COUNT(*) FROM qz_quizzes WHERE qzid = '$qzid'") != 0;	}}