1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
|
<?php
assert_redir(count($args) == 3, 'deck');
$deckid = intval($args[2]);
$deck = mysql_fetch_assoc(sql(
"SELECT decks.id AS id, decks.name AS name, decks.comment_html AS comment, account.login AS owner, account.id AS owner_id ".
"FROM decks LEFT JOIN account ON account.id = decks.owner ".
"WHERE decks.id = $deckid"));
assert_error($deck, "This deck does not exist.");
$can_edit = false;
if ($deck["owner_id"] == $user['id']) $can_edit = true;
$filters = array (
"order" => array (
"name" => "card name",
"number" => "card number",
),
"way" => $ord_ways,
);
$fdefaults = array (
"order" => "number",
"way" => ($can_edit ? "DESC" : "ASC"),
);
$cards = array();
$n = sql(
"SELECT id, number, name, text_html AS text FROM cards WHERE deck = $deckid ".
"ORDER BY " . get_filter("order") . " " . get_filter("way")
);
while ($nn = mysql_fetch_assoc($n)) $cards[] = $nn;
$can_start_study = false;
if ($user['id'] != 0) {
if (!mysql_fetch_assoc(sql("SELECT id FROM deck_study WHERE deck = $deckid AND user = " . $user['id'])))
$can_start_study = true;
} else {
$message = "You should create an account in order to study this deck.";
}
require("tpl/deck/view.php");
|
