}
$t->parse('catalog.paginator');
}
if ($pages >= $page) {
$offset = 4 * ($page - 1);
mysql_data_seek($ress, $offset);
}
$i = isset($offset) ? $offset + 1 : 1;
while ($row = $DB->fetch($ress)) {
$q = "SELECT V." . ($lang == 'rus' ? 'value_name_rus' : 'value_name_eng') . " AS value,\n\t\t\tK." . ($lang == 'rus' ? 'key_name_rus' : 'key_name_eng') . " AS keyname,\n\t\t\tK.key_show AS keyshow\n\t\t\tFROM " . PREF . "kvi_links AS L\n\t\t\tINNER JOIN " . PREF . "values AS V\n\t\t\t\tON L.link_value=V.value_id\n\t\t\tINNER JOIN " . PREF . "keys AS K\n\t\t\t\tON K.key_id=L.link_key\n\t\t\tWHERE L.link_img='" . $row['imid'] . "'\n\t\tORDER BY V.value_sort";
$params = $DB->query($q);
while ($param = $DB->fetch($params)) {
$t->assign('d', array('key' => $param['keyshow'] ? $param['keyname'] . ": " : '', 'value' => $param['value']));
$t->parse('catalog.row.thumb.description');
}
$t->assign('i', array('thumb' => $row['file'], 'width' => $row['width'], 'height' => $row['height'], 'bwidth' => $row['bwidth'], 'bheight' => $row['bheight'], 'project' => $row['pname'], 'imid' => $row['imid'], 'pid' => $row['PID']));
$t->parse('catalog.row.thumb');
if ($i % 2 == 0 or $i == $num) {
$t->parse('catalog.row');
}
++$i;
if ($i > 4 * ($page - 1) + 4) {
break;
}
}
$t->parse('catalog');
}
$t->assign('title', $title);
$t->parse();
echo $t->out();
<?php
$tpl = new e_Template('adm_links', ROOT . "/tpl/");
$tpl->parse('script');
$gt->assign('morehead', $tpl->out('script'));
$l = $DB->query("SELECT id, url, description_e e, description_r r\n\tFROM `" . PREF . "links`\n\tORDER BY `sort`");
while ($li = $DB->fetch($l)) {
$tpl->assign('l', array('id' => $li['id'], 'url' => $li['url'], 'eng' => $li['e'], 'rus' => $li['r']));
$tpl->parse('form.row.url');
$tpl->parse('form.row');
}
$tpl->parse('form');
$output .= $tpl->out('form');
$gt->assign('title', 'Links');
while ($row = $DB->fetch($res)) {
$ep->assign('i', array('id' => $row['img_id'], 'fname' => $row['img_filename']));
$ep->parse('form.images');
}
$ep->assign('pname_r', htmlspecialchars($r['p_name_r']));
$ep->assign('pname_e', htmlspecialchars($r['p_name_e']));
$ep->assign('pid', $r['p_id']);
$ep->parse('form');
$output .= $ep->out('form');
$gt->assign('title', 'Editing project');
break;
case "list":
default:
$list = new e_Template('adm_projectlist', ROOT . "/tpl/");
$list->parse('script');
$gt->assign('morehead', $list->out('script'));
$res = $DB->query("SELECT `pr`.`p_id`, `pr`.`p_name_e`, `pr`.`p_name_r`, `cat`.`cat_name_eng`, `cat`.`cat_name_rus`, `cat`.`cat_id`, (SELECT COUNT(*) FROM `" . PREF . "img` AS img WHERE img.img_project_id=pr.p_id) AS cnt\n\t\t\tFROM `" . PREF . "projects` AS pr, `" . PREF . "category` AS cat\n\t\t\tWHERE pr.p_cat_id=cat.cat_id\n\t\t\tORDER BY pr.p_cat_id, pr.p_order ASC");
if (mysql_num_rows($res)) {
$projects = array();
while ($row = $DB->fetch($res)) {
$projects[$row['cat_id']][$row['p_id']] = $row;
}
foreach ($projects as $category => $project) {
foreach ($project as $row) {
$list->assign('p', array('id' => $row['p_id'], 'name_eng' => $row['p_name_e'], 'name_rus' => $row['p_name_r'], 'cat_name_eng' => $row['cat_name_eng'], 'cat_name_rus' => $row['cat_name_rus'], 'count' => $row['cnt']));
$list->parse('projects.plist.row', 1);
}
$list->parse('projects.plist', 1);
}
}
$list->parse('projects');
break;
case "links":
require_once ROOT . "/admin/links.php";
break;
case "exhibitions":
require_once ROOT . "/admin/exh.php";
break;
case "about":
require_once ROOT . "/admin/about.php";
break;
case "keys":
require_once ROOT . "/admin/keys.php";
break;
case "pr":
require_once ROOT . "/admin/project.php";
break;
// uploading files
// uploading files
case "upi":
require_once ROOT . "/admin/upload.php";
break;
case "home":
default:
$gt->assign('title', 'Welcome to administrator interface');
break;
}
//$gt->assign('title', $title);
$gt->assign('content', $output);
$gt->parse();
echo $gt->out();
ob_flush();
