} $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();