function defaultAction()
{
$db = new sql();
$db->connect();
$chid = $this->chid;
include "lib/pagination.class.php";
include "lib/orderby.class.php";
$adminConfig = admin::adminConfig();
for ($i = 1; $i < 4; $i++) {
$voteTR = "";
$orderBy = new orderBy("?chid=" . $this->chid . "&", array("id" => "№", "time" => "Дата", "name" => "Заголовок", "company" => "Компания", "gsum" => "Средний бал", "gcount" => "Проголосовало"), array("gsum" => "desc"), $this->field[$i], $this->order[$i], array("field[{$i}]", "order[{$i}]"));
$pagination = new pagination($orderBy->urlForPage(), $this->page, $adminConfig["recPerPage"], '', "projects", "id");
$res = $db->query("select projects.id, name, company, category_name, date, sum(IF(grade is null,0, grade))/count(IF(grade is null,0, grade)) as gsum, count(grade) as gcount FROM (projects LEFT JOIN categories ON projects.category = categories.category_id) left join votes on projects.id=votes.id where category={$i} group by projects.id, name, company, category_name, date " . $orderBy->orderByQuery() . " " . $pagination->limit());
$page = $this->page ? "&page=" . $this->page : "";
while ($data = $db->fetch_array($res)) {
$data["date"] = date("d.m.Y", $data["date"]);
eval('$voteTR.="' . admin::template("voteTR") . '";');
}
$pageBar = $pagination->bar();
$th = $orderBy->bar();
eval('$content.="' . admin::template("voteMain") . '";');
$content .= "<br>";
}
$this->elements["content"] = $content;
}
function defaultAction()
{
global $HTTP_SERVER_VARS;
include "./lib/config.inc.php";
$db = new sql();
$db->connect();
$result = $db->query('SELECT VERSION() AS version');
if ($result != FALSE && $db->num_rows($result) > 0) {
$row = $db->fetch_array($result);
$match = $row['version'];
} else {
$result = $db->query('SHOW VARIABLES LIKE \'version\'');
if ($result != FALSE && $db->num_rows($result) > 0) {
$row = $db->fetch_array($result);
$match = $row[1];
}
}
$this->MYSQL_VER = $match;
$this->PHP_OS = PHP_OS;
$this->PHP_VERSION = PHP_VERSION;
$this->CMS = $admin_config["name"] . " " . $admin_config["version"];
$this->AUTHOR = $admin_config["author"];
$this->HOME_PAGE = $admin_config["home_page"];
$content = admin::template("info", $this);
$this->elements["content"] = $content;
}
function addParam()
{
$chid = $this->chid;
extract($this->POST);
eval('$conf="' . admin::template("confNew", "param", array("name" => "EXISTS", "descr" => "EXISTS")) . '";');
$this->elements["content"] = $conf;
}
function defaultAction()
{
$dirs = explode("/", $this->dir);
if ($this->dir) {
$localBreadCrumbs = "<a href=\"?chid=" . $this->chid . "\">" . $this->root . "</a>";
} else {
$localBreadCrumbs = $this->root;
}
for ($i = 1; $i < sizeof($dirs); $i++) {
$path .= "/" . $dirs[$i];
if ($i == sizeof($dirs) - 1) {
$localBreadCrumbs .= "/<b>" . $dirs[$i] . "</b>";
} else {
$localBreadCrumbs .= "/<a href=\"?chid=" . $this->chid . "&dir=" . $path . "\">" . $dirs[$i] . "</a>";
}
}
if ($handle = opendir($this->global_dir)) {
while (false !== ($file = readdir($handle))) {
if (is_dir($this->global_dir . "/{$file}")) {
$file = "/" . $file;
}
$fa[] = $file;
}
natcasesort($fa);
clearstatcache();
foreach ($fa as $key => $value) {
$pi = pathinfo($value);
$ext = $pi["extension"];
$stat = stat($this->global_dir . "/" . $value);
if ($value !== "/.") {
$ii++;
if (substr($value, 0, 1) == "/") {
if ($value == "/..") {
$va = explode("/", $this->dir);
array_pop($va);
$dir1 = implode("/", $va);
$value1 = "";
$folder_tr .= "<tr id=\"tr" . $ii . "\" class=\"default\"><td></td><td><a href=\"?chid=" . $this->chid . "&dir={$dir1}\">{$value}</a></td><td>Папка</td><td></td><td></td></tr>\n";
} else {
$dir1 = $dir;
$value1 = $value;
$folder_tr .= "<tr id=\"tr" . $ii . "\" class=\"default\" onclick=\"return CheckTR(this);\"><td align=\"center\"><input type=\"Checkbox\" value=\"{$value}\" id=\"cb" . $ii . "\" onclick=\"return CheckCB(this);\" name=ids class=\"check\"></td><td><a href=\"?chid=" . $this->chid . "&dir={$this->dir}{$value1}\">{$value}</a></td><td>Папка</td><td></td><td></td></tr>\n";
}
} else {
$files_tr .= "<tr id=\"tr" . $ii . "\" class=\"default\" onclick=\"return CheckTR(this);\"><td align=\"center\"><input type=\"Checkbox\" id=\"cb" . $ii . "\" value=\"{$value}\" onclick=\"return CheckCB(this);\" name=ids class=\"check\"></td><td><a href=\"" . $this->root . $this->dir . "/{$value}\" target=\"_blank\">{$value}</a></td><td>" . $this->_getType($this->global_dir . "/" . $value, $ext) . "</td><td>" . number_format($stat[7] / 1000, 2, ',', ' ') . " КБ</td><td>" . date("d.m.Y H:i", $stat[9]) . "</td></tr>\n";
}
}
}
$files_tr = $folder_tr . $files_tr;
closedir($handle);
eval('$content="' . admin::template("files") . '";');
}
$this->elements["content"] = $content;
}
function edit()
{
$db = new sql();
$db->connect();
$res = $db->query("select * from news where id=" . $this->id);
$data = $db->fetch_array($res);
$data["text"] = htmlspecialchars($data["text"]);
$select = admin::getDateSelectOptions($data["time"]);
$chid = $this->chid;
$action = "appendEdit";
$header = "Редактирование";
eval("\$content=\"" . admin::template("newsAdd", "FORMPOST", array("fields[title]" => "EXISTS")) . "\";");
$this->elements["content"] = $content;
}
function edit()
{
$db = new sql();
$db->connect();
$res = $db->query("select * from projects where id=" . $this->id);
$data = $db->fetch_array($res);
$data["date"] = date("d.m.Y", $data["date"]);
//$data["end"]=date("d.m.Y", $data["end"]);
$category_selected[$data["category"]] = " selected";
$chid = $this->chid;
$action = "appendEdit";
$header = "Редактирование";
eval("\$content=\"" . admin::template("projectsAdd", "FORMPOST", array("fields[url]" => "EXISTS", "fields[title]" => "EXISTS")) . "\";");
$this->elements["content"] = $content;
}
function edit()
{
$db = new sql();
$db->connect();
$res = $db->query("select * from users where id=" . $this->id);
$data = $db->fetch_array($res);
$data["description"] = htmlspecialchars($data["description"]);
$chid = $this->chid;
$action = "appendEdit";
$id = '<tr>
<td>№</td>
<td><input maxlength="14" name="fields[id]" size="14" value="' . $this->id . '" readonly="readonly" style="width: auto;" value="' . $this->id . '"></td>
</tr>';
$header = "Редактирование";
eval("\$content=\"" . admin::template("usersEdit", "FORMPOST", array("fields[login]" => "EXISTS", "fields[name]" => "EXISTS", "confirm" => "EQUAL fields[pass]", "fields[email]" => "EMAIL")) . "\";");
$this->elements["content"] = $content;
}
function wrongAdd()
{
session_start();
if ($_SESSION["fields"]) {
foreach ($_SESSION["wrongFields"] as $key => $value) {
$message .= "<p class=\"error\">" . $value . "</p>";
}
$data = $_SESSION["fields"];
$select = admin::getDateSelectOptions($data["time"]);
$chid = $this->chid;
$action = "appendAdd";
$db = new sql();
$db->connect();
$res = $db->query("select * from types order by id");
while ($data1 = $db->fetch_array($res)) {
$i++;
$types .= "<option" . ($data["type"] == $data1["id"] ? " selected" : "") . " value=\"{$data1['id']}\">{$data1['title']}</option>";
}
$ts[$data["type"]] = " selected";
$true = $data["type"] == 4 ? " && true" : " && false";
$data = $_SESSION["fields"];
$header = "Добавление";
$lid = $this->lid;
$library["chid"] = admin::getTypeID("library");
eval("\$content=\"" . admin::template("itemAdd", "FORMPOST", array("fields[title]" => "EXISTS", "fields[url]" => "EXISTS")) . "\";");
$this->elements["content"] = $content;
}
}
function showAuthorSelectJS()
{
$db = new sql();
$db->connect();
$res = $db->query("select id, firstname, secondname, lastname from authors order by lastname, firstname, secondname");
while ($data = $db->fetch_array($res)) {
$i++;
$chid = $this->chid;
$data["fio"] = $data["lastname"] . ($data["firstname"] ? " " . $data["firstname"] : "") . ($data["secondname"] ? " " . $data["secondname"] : "");
eval('$authorsJSline.="' . admin::template("authorsJSline") . '";');
}
eval('$content="' . admin::template("authorsJS") . '";');
echo $content;
}
} else {
$dir1 = $dir;
$value1 = $value;
}
$image_manager_tr .= "<tr><td><b><a href=\"im.php?dir={$dir1}{$value1}&fake=" . time() . "\" onClick=\"javascript:parent.UPLOAD.document.NEWIMAGE.path.value='{$dir1}{$value1}';\">{$value}</a></td><td>" . $lang["Folder"] . "</b></td></tr>\n";
} else {
$size = getimagesize("{$d}/" . urldecode($value));
$fs = stat("{$d}/" . urldecode($value));
$a = print_copy_link("{$d}/" . $value, urldecode($value));
$image_manager_tr .= "<tr><td>" . $a . "</td><td align=\"right\">" . $fs[7] / 1000 . "K</td></tr>\n";
}
}
}
closedir($handle);
chdir("../");
eval('$image_manager="' . admin::template("im") . '";');
echo $image_manager;
}
function print_copy_link($path, $name)
{
global $server_path, $HTTP_SERVER_VARS;
$imgsize = GetImageSize(urldecode($path));
$width = $imgsize[0];
$height = $imgsize[1];
$path = ereg_replace("/+", "/", $path);
$path = ereg_replace(admin::getDocumentRoot(), "http://" . $HTTP_SERVER_VARS["HTTP_HOST"] . "", $path);
//$name=ereg_replace("\....$","",$name); // remove the extension in the name
//$name=ucfirst(ereg_replace("_"," ",$name)); // replace underscores by spaces and capitalize
$str .= "<a href=\"#\" onClick=\"top.document.forms[0].elements['ImgUrl'].value='{$path}';";
$str .= "top.document.forms[0].elements['ImgWidth'].value={$width};";
$str .= "top.document.forms[0].elements['ImgHeight'].value={$height};";
function librarySelectI()
{
if (!$this->page) {
$this->page = 1;
}
$db = new sql();
$db->connect();
include "lib/orderby.class.php";
$orderBy = new orderBy("?chid=" . $this->chid . "&", array("library" => "№", "time" => "Дата", "name" => "Заголовок", "short_text" => "Подзаголовок", "author" => "Автор"), array("library" => "desc"), $this->field, $this->order);
$adminConfig = admin::adminConfig();
//echo "select library.id as library, name, short_text, time, authors.lastname as author FROM (library LEFT JOIN library_authors ON library.id = library_authors.library) LEFT JOIN authors ON library_authors.author = authors.id GROUP BY library.id".$orderBy->orderByQuery()." limit ".(($this->page-1)*$adminConfig["recPerPage"]).", ".$adminConfig["recPerPage"];
$res = $db->query("select library.id as library, name, short_text, time, authors.lastname as author FROM (library LEFT JOIN library_authors ON library.id = library_authors.library) LEFT JOIN authors ON library_authors.author = authors.id GROUP BY library.id" . $orderBy->orderByQuery() . " limit " . ($this->page - 1) * $adminConfig["recPerPage"] . ", " . $adminConfig["recPerPage"]);
while ($data = $db->fetch_array($res)) {
$i++;
$data["date"] = date("d.m.Y", $data["time"]);
$data["name"] = admin::null2nbsp($data["name"]);
$data["short_text"] = admin::null2nbsp($data["short_text"]);
$res1 = $db->query("select id, firstname, secondname, lastname from library_authors left join authors on library_authors.author = authors.id where library_authors.library=" . $data["library"] . " order by lastname, firstname, secondname");
while ($data1 = $db->fetch_array($res1)) {
$data["fio"] .= "<li>" . $data1["lastname"] . ($data1["firstname"] ? " " . $data1["firstname"] : "") . ($data1["secondname"] ? " " . $data1["secondname"] : "") . "</li>";
}
$data["fio"] = admin::null2nbsp($data["fio"]);
$checked = $data["library"] == $this->id || !$this->id && $i == 1 ? " checked" : "";
eval("\$librarySelectITR.=\"" . admin::template("librarySelectITR") . "\";");
}
eval("\$content=\"" . admin::template("librarySelectI") . "\";");
$this->elements["content"] = $content;
}
function show_Users()
{
$db = new sql();
$db->connect();
$res = $db->query("select * from subs_lists where id={$this->id}");
$data = $db->fetch_array($res);
$listName = $data["title"];
$res = $db->query("select * from subs_users left join subs_subscribed on subs_users.id=subs_subscribed.sid where lid={$this->id}");
if ($this->field) {
$page = "&field={$this->field}";
}
if ($this->order) {
$page .= "&order={$this->order}";
}
if ($this->page) {
$page .= "&page={$this->page}";
}
while ($data = $db->fetch_array($res)) {
$i++;
eval('$subscribeUsersTR.="' . admin::template("subscribeUsersTR") . '";');
}
eval('$content="' . admin::template("subscribeUsersMain") . '";');
$this->elements["content"] = $content;
}
<?php
header("Content-type: text/html; charset=windows-1251");
include_once "lib/adm.class.php";
$field = urldecode($_GET["f"]);
eval("\$content=\"" . admin::template("ve") . "\";");
echo $content;
break;
case 'select':
$db->connect();
$res = $db->query("show columns from {$table}");
$caption = "Выбор свойств полей";
$action = "create";
$content = "<input type=\"hidden\" name=\"table\" value=\"{$table}\">";
$content .= "<table cellspacing=\"0\" cellpadding=\"5\">\n";
$content .= "<th>Поле</th><th>Описание</th><th>Выводить в общем списке</th><th>Выводить в свойствах</th><th>Обязательное</th><th><nobr>E-mail</nobr></th><th>Дата</th>\n";
$res = $db->query("show columns from {$table}");
while ($data = $db->fetch_array($res)) {
$content .= "<tr><td><strong>" . $data["Field"] . "</strong></td><td><input type=\"text\" name=\"name[" . $data["Field"] . "]\"></td>" . ($data["Extra"] == "auto_increment" ? "\n" : "<td><input type=\"checkbox\" name=\"list[" . $data["Field"] . "]\" value=\"1\"></td><td><input type=\"checkbox\" name=\"prop[" . $data["Field"] . "]\" value=\"1\" checked></td><td><input type=\"checkbox\" name=\"req[" . $data["Field"] . "]\" value=\"1\"></td><td><input type=\"checkbox\" name=\"email[" . $data["Field"] . "]\" value=\"1\"></td><td><input type=\"checkbox\" name=\"date[" . $data["Field"] . "]\" value=\"1\"></td></tr>\n");
}
$content .= "</table>";
eval('$content="' . admin::template("wizard") . '";');
echo $content;
break;
default:
$db->connect();
$res = $db->query("show tables");
$action = "select";
$caption = "Вас приветствует мастер создания классов!";
$content = "Выберите таблицу <select name=\"table\">";
while ($data = $db->fetch_array($res)) {
$content .= "<option value=\"" . $data["Tables_in_" . $DB["dbName"]] . "\">" . $data["Tables_in_" . $DB["dbName"]] . "</option>";
}
$content .= "</select>";
eval('$content="' . admin::template("wizard") . '";');
echo $content;
break;
}
// rfc2616 - Section 14.21
header('Last-Modified: ' . $GLOBALS['now']);
header('Cache-Control: no-store, no-cache, must-revalidate, pre-check=0, post-check=0, max-age=0');
// HTTP/1.1
header('Pragma: no-cache');
// HTTP/1.0
include_once "../lib/adm.class.php";
define("_QUERY", "select id, pid, title, url from chapters");
define("_LANG", "{$lng}");
$db = new sql();
$db->connect();
$form_action = "add.php?pid={$pid}&lid={$lid}";
$cid = $id;
$open_nodes = get_open_nodes($id);
$options = get_tree(0, $open_nodes);
eval("\$content=\"" . admin::template("links", "", "", "../") . "\";");
//eval('$item="'.$tpl->get("main").'";');
echo $content;
function get_open_nodes($id)
{
$db = new sql();
$db->connect();
if ($id) {
$res = $db->query(_QUERY . " where id={$id} order by sortorder");
while ($db->num_rows($res) > 0) {
$data = $db->fetch_array($res);
$open_nodes[$data["id"]] = true;
$res = $db->query(_QUERY . " where id=" . $data["pid"]);
}
}
return $open_nodes;