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
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70

<?
require("inc/menu.php");
require("inc/html.php");
require("inc/common.php");

$config=getconfig();

$genres[]=array("", "All");
$users[]=array("", "All");
$years[]=array("", "All");
$regions[]=array(0=> "", 1=> "All");
$media[]=array(0 => "", 1=> "All");

$genreres=doquery("select id, name from genre order by name");
while ($row=mysql_fetch_row($genreres)) {
    $genres[]=array($row[0], $row[1]);
}

$userres=doquery("select id, concat(fname,\" \", lname) from user where enabled=1 order by fname");
while ($row=mysql_fetch_row($userres)) {
    $users[]=array($row[0], $row[1]);
}

for ($i=$config["lowdate"];$i<=date(Y);$i++) {
    $years[]=array($i,$i);
}

for ($i=0;$i<=6;$i++) {
    $regions[]=array(0 => "$i", 1=> "Region ".$i);
}

$mediares=doquery("select id, name from media order by name");
while ($row=mysql_fetch_row($mediares)) {
    $media[]=array($row[0], $row[1]);
}

$output.=form_begin("listmovies.php","GET");
$output.="Apply the following filters: <BR /><BR />\n";

$tr=tr(td("Genre:").td(input_select("genreid","",$genres)));
$tr.=tr(td("Region:").td(input_select("region","",$regions)));
$tr.=tr(td("Owner:").td(input_select("userid","",$users)));
$tr.=tr(td("Media:").td(input_select("media","",$media)));
$tr.=tr(td("Release year:&nbsp;&nbsp;").td(input_select("year","",$years)));

$output.=table($tr,0,0,4);

$output.=submit("Search");
$output.=form_end();

$output.="<BR />\n";

$output.=form_begin("listmovies.php","GET");
$output.="Search by director, author or soundtrack:<BR /><BR />\n";
$output.=input_text("spersons",40,255);
$output.=submit("Go");
$output.=form_end();

$output.=form_begin("listmovies.php","GET");
$output.="Search by keywords in title, comments or extra infos:<BR /><BR />\n";
$output.=input_text("skeywords",40,255);
$output.=submit("Go");
$output.=form_end();

$output.="NOTE: Search item must have at least 4 characters!<BR /><BR />\n";

$content["body"] =& $output;
dopage($content);

?>