$dicts = array();
@($res = mysql_query("select * from dicts"));
while (@($row = mysql_fetch_array($res))) {
$dicts[$row['d_id']] = $row['d_name'];
}
asort($dicts);
if (is_numeric($dict)) {
$tab = new TABLE();
if (!is_numeric($offset) or $offset < 0) {
$offset = 0;
}
if (!is_numeric($limit) or $limit < 1) {
$limit = 20;
}
@($res = mysql_query("select count(*) as cnt from vocab where v_d_id={$dict}"));
@($row = mysql_fetch_array($res));
$cnt = $row['cnt'];
$tab->add_row(array(array('attr' => 'colspan=5', 'cont' => pnav($cnt, $offset, $limit, "?dict={$dict}&") . "<br><br>")));
@($res = mysql_query("select * from vocab where v_d_id={$dict} order by v_english limit {$offset},{$limit}"));
while (@($row = mysql_fetch_array($res))) {
$tab->add_row(array($row['v_english'], "<i>" . $row['v_latin'] . "</i>", $row['v_czech'], $row['v_slovak'], $row['v_german']));
}
$page->add_to_middle($tab->prepare());
} else {
$menu = new VMENU();
while (list($k, $v) = each($dicts)) {
$menu->add_item($v, "?dict={$k}");
}
$page->add_to_middle($menu->prepare());
}
$page->display();
@($res = mysql_query("select count(ex_id) as cnt from exercises where {$cond}"));
@($row = mysql_fetch_array($res));
$cnt = $row['cnt'];
$rtab = new BOXEDTABLE();
$rtab->set_parameters(array('style' => 'subtable'));
$rtab->add_row(array(array('attr' => 'colspan=4', 'cont' => "\n <input type=\"submit\" value=\" Show \" name=\"show\" class=\"buttoninbox\"><input type=\"text\" name=\"limit\" value=\"{$limit}\" size=5 maxlength=5 class=\"boxedfield\"> exercises.")));
$rtab->add_row(array(array('attr' => 'colspan=4 align="center"', 'cont' => '<strong>Search filters</strong>')));
$rtab->add_row(array(array('attr' => 'colspan=1', 'cont' => "Type"), array('attr' => 'colspan=3', 'cont' => $types->prepare())));
$rtab->add_row(array("Categories", array('attr' => 'colspan=3', 'cont' => $cbox->how_many() ? $cbox->prepare() : '<small>(none)</small>')));
$rtab->add_row(array('Name contains', array('attr' => 'colspan=3', 'cont' => "<input type=\"text\" name=\"name_re\" value=\"{$name_re}\" size=40 maxlength=40 class=\"boxedfield\"> (\"Not\" <input type=\"checkbox\" name=\"not_name_re\" value=\"not\"" . ($not_name_re ? ' checked' : '') . " class=\"checkbox\">)")));
$rtab->add_row(array('Description contains', array('attr' => 'colspan=3', 'cont' => "<input type=\"text\" name=\"desc_re\" value=\"{$desc_re}\" size=40 maxlength=40 class=\"boxedfield\"> (\"Not\" <input type=\"checkbox\" name=\"not_desc_re\" value=\"not\"" . ($not_desc_re ? ' checked' : '') . " class=\"checkbox\">)")));
$ltab = new BOXEDTABLE();
$ltab->set_parameters(array('style' => 'subtable'));
$ltab->add_row(array(array('attr' => 'align="center"', 'cont' => "<h3>Exercises</h3>")));
if ($limit < $cnt) {
$ltab->add_row(array(array('attr' => 'align="center"', 'cont' => pnav($cnt, $offset, $limit, "?{$href_cond}&") . "<br><br>\n")));
}
@($res = mysql_query("select ex_id as id,ex_type as type,ex_name as name,ex_description as description, ex_creator as creator,ec_et_id from exercises left join exercise_categories on ex_id=ec_ex_id where {$cond} group by ex_type,ex_id order by ex_type,ex_name {$desc} limit {$offset},{$limit}"));
$t = 0;
if (@mysql_num_rows($res)) {
$menu = new VMENU();
$menu->set_itemized(0);
while (@($row = mysql_fetch_array($res))) {
if ($row['description']) {
$descr = "({$row['description']})";
} else {
$descr = '';
}
$menu->add_item("<a href=\"?exercise={$row['id']}\"><strong>{$row['name']}</strong></a> <small>{$descr}</small>", $row['id']);
}
$ltab->add_row(array($menu->prepare() . "<br>"));