<?php session_start(); include 'constants.php'; include 'account_utils.php'; require_once 'mysqli_connect.php'; if (!isset($_SESSION['login'])) { header("Location: index.php"); exit; } if (isset($_POST['logout'])) { logout(); header("Location: index.php"); } elseif (!$_POST['submit']) { header("Location: index.php"); } else { //return; $query = "select id FROM games where week=" . WEEK . " ORDER BY id"; $response = mysqli_query($dbc, $query); foreach ($_POST as $value) { if ($value == 'Send') { continue; } $row = mysqli_fetch_array($response); make_pick($dbc, $row['id'], $value, get_user_id($dbc)); } header("Location: picks_table.php"); } mysqli_close($dbc);
function which3($lang, $spart, $key, $N = NULL, $given = NULL, $rand = NULL, $name = NULL) { global $OP_MULTIPLE_CHOICE; global $OP_PARAGRAPH; global $OP_LPAREN; global $OP_RPAREN; global $OP_LQUOTE; global $OP_RQUOTE; $selections = []; $path = []; $mgr = defaultDB()->get_mgr($lang, $spart); $given = PATH($mgr, $given); $_gender = null; if ($N === NULL) { $N = count($mgr->key2values[$key]); } $selections["answers"] = PICK($N, $key, safe_get($key, $rand))->l($lang); $recurse = function ($mgr) use(&$_gender, $spart, $given, &$recurse, &$path, $rand, &$selections, $lang) { foreach ($mgr->simple_keys as $k) { if ($given->key_exists($k)) { $path[] = $given->key_value($k); } else { if ($k === "gender" and $spart === "verb") { $_gender = make_pick(PICK($k, safe_get($k, $rand))->l($lang), $k); } else { $path[] = make_pick(PICK($k, safe_get($k, $rand))->l($lang), $k); } } } foreach ($mgr->recursive_keys as $k) { if ($given->key_exists($k)) { $path[] = $given->key_value($k); $recurse($mgr->level[$k][$given->key_value($k)]); } } }; $recurse($mgr); $answers = []; $selections[$key] = function ($pick_db) { error_log(var_export($pick_db, 1)); return $pick_db["answers"][0]; }; for ($v = 0; $v < $N; $v++) { $answers[] = ["correct" => function ($pick_db) use($v) { return safe_get($pick_db["answers"][$v], $pick_db); }, "value" => function ($pick_db) use($v) { return $pick_db["answers"][$v]; }]; } $ret = ["help" => "What {$key} is this word?", "selections" => $selections, "sentence" => [["lang" => $lang, "speechpart" => $spart, "path" => $path, "attr" => ["!template" => NULL, "!hidden" => NULL], "store_word" => "word", "store" => "result"], function (&$pick_db) use($key) { global $mysqli; $query = $mysqli->prepare("\n\t\t\t\t\tSELECT form_tag FROM forms\n\t\t\t\t\tWHERE word_id = (?)\n\t\t\t\t\tAND form_value = (?)\n\t\t\t\t"); $res = NULL; sql_getmany($query, $res, ["is", $pick_db["word"]->id(), $pick_db["result"]]); $query->close(); foreach ($res as $tag) { $p = PATH($pick_db["word"], $tag); $v = $p->key_value($key); $pick_db[$v] = TRUE; } return FALSE; // No word }, $OP_PARAGRAPH, $OP_MULTIPLE_CHOICE], "choices0" => $answers, "choices0-tooltip" => "What {$key}?", "choices0-language" => "en"]; if ($name !== null) { $ret["sentence"][0]["name"] = $name; } if ($_gender !== null) { $ret["sentence"][0]["verb-gender"] = $_gender; } return $ret; }
$art = "[the|some]"; } else { $art = "[a[n]|the]"; } if (!$def_expr) { $def_expr = make_expr($defs); } $correct = [capitalize(implode(" ", [$pron[0], $have[0], "(the)", $defs[0]]))]; $expr = "{*" . implode("} {", array_map("make_expr", [$pron, $have, $art])) . " {$def_expr}}"; error_log($expr); return ["correct" => $correct, "expr" => $expr]; }, "answer0-tooltip" => "English translation", "answer0-language" => "en"], ["help" => "Translate this into English.", "selections" => ["person" => PICK("person")->l("la"), "number" => PICK("number")->l("la"), "gender" => PICK("gender")->l("la"), "type" => PICK(["location", "location/room", "location/building", "location/city"]), "word" => NULL, "obj_gender" => NULL, "obj_number" => NULL, "ablative" => function ($pick_db) { return $pick_db["type"] !== "location/city"; }, "case" => function ($pick_db) { return $pick_db["ablative"] ? "ablative" : "locative"; }], "sentence" => [["condition" => make_pick(PICK([0, 1]), "pronoun"), "spart" => "pronoun", "attr" => ["person" => get_pick("person")], "path" => ["nominative", get_pick("number"), get_pick("gender")]], ["spart" => "verb", "language" => "la", "name" => "sum", "path" => ["indicative/present/active", get_pick("number"), get_pick("person")]], ["spart" => "preposition", "language" => "la", "name" => "in", "condition" => get_pick("ablative")], ["spart" => "noun", "language" => "la", "attr" => array_merge($df_exclude, ["type" => get_pick("type")]), "store_word" => "word", "path" => [get_pick("case"), make_pick(PICK("gender"), "obj_gender"), make_pick(PICK(["singular"]), "obj_number")]], $OP_COLON, $OP_PARAGRAPH, $OP_USER_INPUT], "answer0" => function ($pick_db, $db) { $person = $pick_db["person"]; $number = $pick_db["number"]; $gender = $pick_db["gender"]; $word = $pick_db["word"]; $pron = ["person-1" => ["singular" => ["I"], "plural" => ["we"]], "person-2" => ["singular" => ["you (sg)", "thou"], "plural" => ["you (pl)", "ye"]], "person-3" => ["singular" => ["masculine" => ["he", "it"], "feminine" => ["she", "it"], "neuter" => ["it"], "one"], "plural" => ["they"]]]; $pron = $pron[$person][$number]; if ($person === "person-3" and $number === "singular") { $pron = $pron[$gender]; } else { $pron = array_unique(flatten($pron)); } $be = ["person-1" => ["singular" => ["am"], "plural" => ["are"]], "person-2" => ["singular" => ["are", "art"], "plural" => ["are"]], "person-3" => ["singular" => ["is"], "plural" => ["are"]]]; $be = $be[$person][$number]; $path = PATH($word, "{$pick_db['case']}/{$pick_db['obj_number']}/{$pick_db['obj_gender']}"); $defs = [];
return which("la", "pronoun", "gender", NULL, ["case" => ["dative" => 0, "ablative" => 1, "accusative" => 3, "nominative" => 3, "genitive" => 1]], "qui"); }, ["help" => "Choose the pronoun that correctly \n\t\t\t\t fills in the blank.\n\t\t\t\t ", "selections" => [0 => NULL, 1 => NULL, 2 => PICK(2, ["dative", "genitive", "ablative"])->l("la")], "sentence" => [["spart" => "noun", "attr" => $df_exclude, "lang" => "la", "path" => [make_picks(PICK(2, "number")->l("la"), 1, 0, 0), make_picks(PICK(2, "gender")->l("la"), 1, 1, 0), "nominative"]], $OP_COMMA, $OP_MULTIPLE_CHOICE, ["spart" => "verb", "attr" => ["transitive" => "true", "!template" => NULL, "!hidden" => NULL], "lang" => "la", "path" => ["indicative", "active", "person-1", PICK("tense")->l("la"), PICK("number")->l("la")], "verb-gender" => get_pick(1, 0)], $OP_COMMA, ["name" => "sum", "spart" => "verb", "lang" => "la", "path" => [get_pick(0, 0), "person-3", "indicative", "active", PICK("tense")]], ["spart" => "adjective", "attr" => $df_exclude, "lang" => "la", "path" => [get_pick(0, 0), get_pick(1, 0), "nominative/positive"]]], "choices0" => ["correct" => ["name" => "qui", "spart" => "pronoun", "lang" => "la", "path" => [get_pick(0, 0), get_pick(1, 0), "accusative"]], ["name" => "qui", "spart" => "pronoun", "lang" => "la", "path" => [get_pick(0, 1), get_pick(1, 0), "accusative"]], ["name" => "qui", "spart" => "pronoun", "lang" => "la", "path" => [get_pick(0, 0), get_pick(1, 1), "accusative"]], ["name" => "qui", "spart" => "pronoun", "lang" => "la", "path" => [get_pick(0, 0), get_pick(1, 1), get_pick(2, 0)]], ["name" => "qui", "spart" => "pronoun", "lang" => "la", "path" => [get_pick(0, 1), get_pick(1, 0), get_pick(2, 1)]]], "choices0-tooltip" => ""]]], "008" => ["category" => "Grammar", "lang" => "la", "options" => [["help" => "Choose the pronoun that correctly \n\t\t\t fills in the blank.\n\t\t\t ", "selections" => [0 => NULL, 1 => NULL, 2 => PICK(2, ["dative", "genitive", "ablative"])->l("la")], "sentence" => [["spart" => "noun", "lang" => "la", "attr" => $df_exclude, "path" => [make_picks(PICK(2, "number")->l("la"), 1, 0, 0), make_picks(PICK(2, "gender")->l("la"), 1, 1, 0), "nominative"]], $OP_COMMA, $OP_MULTIPLE_CHOICE, ["spart" => "verb", "lang" => "la", "attr" => array_merge($df_exclude, ["transitive" => "true"]), "path" => ["indicative", "active", "person-1", PICK("tense")->l("la"), PICK("number")->l("la")], "verb-gender" => get_pick(1, 0)], $OP_COMMA, ["name" => "sum", "lang" => "la", "spart" => "verb", "path" => [get_pick(0, 0), "person-3", "indicative", "active", PICK("tense")->l("la")]], ["spart" => "adjective", "lang" => "la", "attr" => $df_exclude, "path" => [get_pick(0, 0), get_pick(1, 0), "nominative/positive"]]], "choices0" => ["correct" => ["name" => "qui", "lang" => "la", "spart" => "pronoun", "path" => [get_pick(0, 0), get_pick(1, 0), "accusative"]], ["name" => "qui", "lang" => "la", "spart" => "pronoun", "path" => [get_pick(0, 1), get_pick(1, 0), "accusative"]], ["name" => "qui", "lang" => "la", "spart" => "pronoun", "path" => [get_pick(0, 0), get_pick(1, 1), "accusative"]], ["name" => "qui", "lang" => "la", "spart" => "pronoun", "path" => [get_pick(0, 0), get_pick(1, 1), get_pick(2, 0)]], ["name" => "qui", "lang" => "la", "spart" => "pronoun", "path" => [get_pick(0, 1), get_pick(1, 0), get_pick(2, 1)]]], "choices0-tooltip" => ""], ["help" => "Choose the pronoun that correctly \n\t\t\t fills in the blank.\n\t\t\t ", "selections" => [0 => NULL, 1 => NULL, 2 => PICK(2, ["dative", "genitive", "ablative"])->l("la")], "sentence" => [["spart" => "noun", "lang" => "la", "attr" => $df_exclude, "path" => [make_picks(PICK(2, "number")->l("la"), 1, 0, 0), make_picks(PICK(2, "gender")->l("la"), 1, 1, 0), "nominative"]], $OP_COMMA, $OP_MULTIPLE_CHOICE, ["spart" => "verb", "lang" => "la", "attr" => array_merge($df_exclude, ["transitive" => "false"]), "path" => ["indicative/active/person-3", PICK("tense")->l("la"), get_pick(0, 0)], "verb-gender" => get_pick(1, 0)], $OP_COMMA, ["name" => "sum", "lang" => "la", "spart" => "verb", "path" => [get_pick(0, 0), "person-3/indicative/active", PICK("tense")]], ["spart" => "adjective", "lang" => "la", "attr" => $df_exclude, "path" => [get_pick(0, 0), get_pick(1, 0), "nominative/positive"]]], "choices0" => ["correct" => function (&$_, $db, $path) { $w = $db->searcher()->name("qui")->spart("pronoun")->rand(); $w->read_paths(); $qui = PATH($w, "masculine/nominative/singular")->get(); $quae = PATH($w, "feminine/nominative/singular")->get(); $quod = PATH($w, "neuter/nominative/singular")->get(); if ($_[1][0] == "masculine") { $_[10] = [$qui, $quae, $quod]; } elseif ($_[1][0] == "feminine" or $_[1][0] == "neuter" and $_[0][0] == "plural") { $_[10] = [$quae, $qui, $quod]; } else { $_[10] = [$quod, $qui, $quae]; } return $_[10][0]; }, get_pick(10, 1), get_pick(10, 2), ["name" => "qui", "lang" => "la", "spart" => "pronoun", "path" => [get_pick(0, 0), get_pick(1, 1), get_pick(2, 0)]], ["name" => "qui", "lang" => "la", "spart" => "pronoun", "path" => [get_pick(0, 1), get_pick(1, 0), get_pick(2, 1)]]], "choices0-tooltip" => ""], ["help" => "Choose the pronoun that correctly \n\t\t\t fills in the blank.\n\t\t\t ", "selections" => [0 => NULL, 1 => NULL, 2 => PICK(2, ["dative", "genitive", "ablative"])->l("la")], "sentence" => [["spart" => "noun", "lang" => "la", "attr" => $df_exclude, "path" => [make_picks(PICK(2, "number")->l("la"), 1, 0, 0), make_picks(PICK(2, "gender")->l("la"), 1, 1, 0), "nominative"]], $OP_COMMA, $OP_USER_INPUT, ["spart" => "verb", "lang" => "la", "attr" => array_merge($df_exclude, ["transitive" => "true"]), "path" => ["indicative/active/person-3", PICK("tense")->l("la"), get_pick(0, 0)], "verb-gender" => get_pick(1, 0)], $OP_COMMA, ["name" => "sum", "lang" => "la", "spart" => "verb", "path" => [get_pick(0, 0), "person-3/indicative/active", PICK("tense")->l("la")]], ["spart" => "adjective", "lang" => "la", "attr" => $df_exclude, "path" => [get_pick(0, 0), get_pick(1, 0), "nominative/positive"]]], "answer0" => ["name" => "qui", "lang" => "la", "spart" => "pronoun", "path" => [get_pick(0, 0), get_pick(1, 0), "nominative"]], "answer0-tooltip" => "relative pronoun form"]]], "007" => ["name" => "Noun–verb agreement", "category" => "Grammar", "lang" => "la", "options" => [["help" => "Choose the pronoun that correctly \n\t\t\t restates the subject of the verb.\n\t\t\t (Note: for third-person pronouns,\n\t\t\t assume both options are of the same\n\t\t\t gender and thus only differ in number.)", "selections" => [0 => "true", 1 => PICK(3, "person")->l("la"), 2 => PICK(2, "number")->l("la"), 3 => PICK("gender")->l("la"), 4 => NULL, 5 => "active", 6 => NULL, "+adj" => FALSE], "sentence" => [$OP_MULTIPLE_CHOICE, " ", ["condition" => eq_pick("+adj", TRUE), "lang" => "la", "attr" => $df_exclude, "speechpart" => "adjective", "path" => ["nominative", "positive", get_pick(2, 0), get_pick(3)]], ["condition" => fn_and(eq_pick(0, "true"), eq_pick(5, "active")), "lang" => "la", "attr" => $df_exclude, "speechpart" => "noun", "path" => ["accusative", PICK("number")->l("la"), PICK("gender")->l("la")]], ["lang" => "la", "speechpart" => "verb", "attr" => ["transitive" => get_pick(0), "!template" => NULL, "!hidden" => NULL, "!irregular" => NULL], "path" => ["indicative", get_pick(1, 0), get_pick(2, 0), make_pick(PICK(["present", "imperfect", "perfect"]), 4), get_pick(5)], "verb-gender" => get_pick(3)]], "choices0" => ["correct" => ["lang" => "la", "speechpart" => "pronoun", "attr" => ["person" => get_pick(1, 0)], "path" => ["number" => get_pick(2, 0), "nominative", get_pick(3)]], ["lang" => "la", "speechpart" => "pronoun", "attr" => ["person" => get_pick(1, 1)], "path" => ["number" => get_pick(2, 0), "nominative", get_pick(3)]], ["lang" => "la", "speechpart" => "pronoun", "attr" => ["person" => get_pick(1, 2)], "path" => ["number" => get_pick(2, 0), "nominative", get_pick(3)]], ["lang" => "la", "speechpart" => "pronoun", "attr" => ["person" => get_pick(1, 0)], "path" => ["number" => get_pick(2, 1), "nominative", get_pick(3)]], ["lang" => "la", "speechpart" => "pronoun", "attr" => ["person" => get_pick(1, 1)], "path" => ["number" => get_pick(2, 1), "nominative", get_pick(3)]], ["lang" => "la", "speechpart" => "pronoun", "attr" => ["person" => get_pick(1, 2)], "path" => ["number" => get_pick(2, 1), "nominative", get_pick(3)]]], "choices0-tooltip" => "Quis/qui"]]], "subj01" => ["name" => "Subjunctive or Indicative?", "category" => "Grammar", "lang" => "la", "options" => [["help" => "What is the mood of this verb?", "selections" => ["path" => PICK([["indicative", "present", "singular", "person-3", "active"], ["indicative", "imperfect", "singular", "person-3", "active"], ["indicative", "pluperfect", "singular", "person-3", "active"], ["indicative", "perfect", "singular", "person-3", "active"], ["subjunctive", "imperfect", "singular", "person-3", "active"], ["subjunctive", "pluperfect", "singular", "person-3", "active"], ["subjunctive", "imperfect", "singular", "person-3", "active"], ["subjunctive", "pluperfect", "singular", "person-3", "active"]])], "sentence" => [["spart" => "verb", "attr" => $df_exclude, "lang" => "la", "path" => get_pick("path")], $OP_MULTIPLE_CHOICE], "choices0" => ["correct" => get_pick("path", 0), function ($pick_db) { if ($pick_db["path"][0] == "indicative") { return "subjunctive"; } return "indicative"; }], "choices0-tooltip" => "Which mood?", "choices0-language" => "en"]]], "subjunctive-infinitives" => ["name" => "Subjunctive practice", "category" => "Grammar", "lang" => "la", "stage" => 24, "options" => function () { global $OP_USER_INPUT; return [["help" => function (&$pick_db, $db) { $word = $pick_db["word"]; $pick_db["word"]->read_paths(); $path = $pick_db["path"] = PATH($word); foreach ($pick_db as $k => $v) { if ($k === "word" or $k === "path") { continue; } #error_log("$k = $v".var_export($v,true));