function get($res, $name = 'clouds')
{
$nums_clouds = array();
if (db::rows() > 0) {
while ($row = mysql_fetch_array($res)) {
$nums_clouds[$row['tag_name']] = $row['num'];
}
ksort($nums_clouds);
$max_size = 200;
// max font size in %
$min_size = 100;
// min font size in %
$max_qty = max(array_values($nums_clouds));
$min_qty = min(array_values($nums_clouds));
$spread = $max_qty - $min_qty;
if (0 == $spread) {
$spread = 1;
}
$step = ($max_size - $min_size) / $spread;
foreach ($nums_clouds as $k => $v) {
$size = $min_size + ($v - $min_qty) * $step;
s::roll($name, array('name' => $k, 'size' => $size, 'value' => $v));
}
}
}
public function rows()
{
$escape = !empty($this->query['escape']);
$query = $this->__build_a_query();
$this->query = array();
return db::rows(self::Q_GET_BY_ATTR, $query, $escape);
}
function checkDuplicate()
{
db::table('mails');
if (params::get('mail_id')) {
db::where('mail_id', params::get('mail_id'), '!=');
}
db::where('mail_name', params::get('value'));
db::select('mail_id');
if (db::rows() != 0) {
buffer::set('error');
}
}
function checkDuplicate()
{
db::table('admin_users');
if (params::get('user_id') !== false) {
db::where('user_id', params::get('user_id'), '!=');
}
db::where('user_login', params::get('user_login'));
db::select();
if (db::rows() != 0) {
buffer::set('error');
}
}
function show()
{
$dir = IMAGES_PATH . 'index/';
db::table('images');
db::where('img_set', '1');
db::orderByRand();
$img = db::assoc();
if (db::rows() != 0) {
$file = $dir . $img['img_id'] . '.jpg';
buffer::set('<img src="' . $file . '" width="700" height="360" alt="" />');
}
}
function download()
{
$file_id = params::get('file');
db::table('files');
db::where('file_id', $file_id);
$file = db::assoc();
if (db::rows() == 0) {
web::error404();
}
$file_link = FILES_ROOT . 'all/' . $file_id . '.' . $file['file_type'];
files::downloadFile($file_link);
}
function show()
{
$event = web::getEvent();
if ($event === false) {
$year = date('Y');
} else {
$year = $event;
}
s::set('info_date_select', htmlspecialchars($year));
$sql = "SELECT `section_year` as date FROM `info_sections` WHERE `section_view`='0' GROUP BY `date` ORDER BY `date` DESC";
$res = db::query($sql);
$rows = mysql_num_rows($res);
if ($rows > 1) {
s::add('info_date_selector', '<ul class="years">');
while ($row = mysql_fetch_assoc($res)) {
if ($row['date'] == $year) {
$row['date'] = '<li><span>' . $row['date'] . '</span></li>';
} else {
$row['date'] = '<li><a href="' . web::get('page_folder') . '' . $row['date'] . '/">' . $row['date'] . '</a></li>';
}
s::add('info_date_selector', $row['date']);
}
s::add('info_date_selector', '</ul>');
}
$files = array();
db::table('info_files');
$r = db::select();
while ($a = mysql_fetch_assoc($r)) {
$files[$a['section_id']][] = $a;
}
db::table('info_sections');
db::order('section_order', 'DESC');
db::where('section_year', $year);
$r = db::select();
if (db::rows() == 0) {
web::error404();
}
while ($a = mysql_fetch_assoc($r)) {
if ($a['section_view'] == '0') {
s::roll('sections', $a);
} else {
s::roll('sections_view', $a);
}
if (isset($files[$a['section_id']])) {
foreach ($files[$a['section_id']] as $v) {
$v['file_icon'] = files::getFileIco($v['file_type']);
$v['file_size'] = files::parseSizeSmart($v['file_size']);
s::roll('items' . $a['section_id'], $v);
}
}
}
}
function showOne()
{
$news_id = web::getThis();
db::table('news');
db::where('news_pub', '1');
$news = db::assoc();
if (db::rows() == 0) {
web::error404();
}
$news['news_date'] = dt::date2print('%d %F %Y', $news['news_date']);
s::set('page_title', $news['news_title']);
s::set('page_header', $news['news_title']);
s::set($news);
}
function getTmpls($site_id = 1)
{
db::table('templates');
db::where('site_id', $site_id);
db::where('tmpl_pub', '1');
db::order('tmpl_name');
$res = db::select();
if (db::rows() == 0) {
s::section('no_data');
} else {
s::section('yes_data');
}
while ($row = mysql_fetch_assoc($res)) {
s::roll('tmpls', $row);
}
}
function loadPage($page_id = false, $page_folder = false)
{
db::table('pages');
db::join('templates', 'pages', 'tmpl_id');
if ($page_id) {
db::where('page_id', $page_id);
}
if ($page_folder) {
db::where('page_folder', $page_folder);
}
db::where('site_id', SITE_ID, '=', 'pages');
db::limit(1);
$res = db::select();
if (db::rows() == 1) {
$row = mysql_fetch_assoc($res);
$row = web::pageSettings($row);
web::$page = $row;
s::set($row);
}
}
function load($user_id)
{
if (self::$user) {
return true;
}
db::table('admin_users');
db::where('user_id', $user_id);
db::where('user_pub', 1);
db::limit(1);
self::$user = db::assoc();
if (db::rows() == 0) {
admin::logout();
}
define("ADMIN_USER_ID", $user_id);
define("ADMIN_USER_SITE_ID", self::get('site_id'));
define("ADMIN_USER_GROUP_ID", self::get('group_id'));
s::set('ADMIN_USER_LOGIN', self::get('user_login'));
s::set('ADMIN_USER_ID', $user_id);
return true;
}
function dump()
{
$tables = implode(', ', self::$tables);
$conf = implode(', ', self::$conf);
db::table('admin_log_trash');
db::order('log_id', 'DESC');
db::limit(31, 100);
$res = db::select('log_id');
if (db::rows() > 0) {
while ($row = mysql_fetch_assoc($res)) {
self::delete($row['log_id']);
}
}
if (self::$files) {
$log_tmpl = 1;
} else {
$log_tmpl = 0;
}
db::table('admin_log_trash');
db::insert('', 'NOW()', '', $tables, $conf, '', $log_tmpl, ADMIN_USER_ID);
$log_id = mysql_insert_id();
dump::tables(self::$tables);
dump::backup(SYS_ROOT . 'var/trash/' . $log_id . '_base.zip');
if (self::$conf) {
foreach (self::$conf as $v) {
zipfile::add(SYS_ROOT . 'conf/web/' . $v . '.ini');
}
zipfile::create(SYS_ROOT . 'var/trash/' . $log_id . '_conf.zip');
}
if (self::$files) {
foreach (self::$files as $v) {
zipfile::add($v);
}
zipfile::create(SYS_ROOT . 'var/trash/' . $log_id . '_files.zip');
}
}
public static function join($fields = array('*'), $join = array(), $where = array(), $single = false, $sort = array(), $order = "DESC", $offset = 0, $limit = 0)
{
if ($single) {
return parent::row(self::join_str($fields, $join, $where, $sort, $order, $offset, $limit));
} else {
return parent::rows(self::join_str($fields, $join, $where, $sort, $order, $offset, $limit));
}
}
function saveVersion($tmpl_id, $code)
{
db::table('templates_versions');
db::where('tmpl_id', $tmpl_id);
db::where('version_code', $code);
db::order('version_date', 'DESC');
db::limit(1);
db::select();
if (db::rows() == 0) {
/*
delete over 20
*/
db::table('templates_versions');
db::where('tmpl_id', $tmpl_id);
db::order('version_date', 'DESC');
db::limit(20, 100);
db::delete();
db::table('templates_versions');
db::insert('', 'NOW()', $code, '', '', $tmpl_id, ADMIN_USER_ID, ADMIN_SITE_ID);
}
}
function add()
{
events::observe('add', 'menus', '_save');
events::observer();
admin::components('tabs', 'validator');
appPages::getPagesSelect(ADMIN_SITE_ID);
appMenus::getMenus(ADMIN_SITE_ID);
// test reserved
db::table('admin_reserved');
db::where('`table`', 'menus');
db::where('user_id', ADMIN_USER_ID);
$menu_id = db::get('id');
if (db::rows() == 0) {
db::table('menus');
db::smartInsert(array('menu_pub' => '2', 'site_id' => ADMIN_SITE_ID));
$menu_id = mysql_insert_id();
db::table('admin_reserved');
db::insert('', 'menus', $menu_id, ADMIN_USER_ID);
}
f::set('menu_id', $menu_id);
}
private static function _check($u = "", $p = "")
{
//procession the session
$dt = time();
$dtS = date("Y-m-d H:i:s", $dt);
if (self::$user["id"]) {
if ($dt - (0 + self::$config["session-timeout"]) > self::$user["dlast"]) {
self::$user["id"] = 0;
db::q("UPDATE " . db::tnm(self::$class) . " SET `ses`='' WHERE `dlast`<('" . $dtS . "'-DATE_SUB('" . $dtS . "', INTERVAL " . self::$config["session-timeout"] . " SECOND))", false);
}
}
//processing the cookies
if (isset($_COOKIE[self::$class . "-user"])) {
$cookie = $_COOKIE[self::$class . "-user"];
} else {
$cookie = "";
}
if ($cookie) {
if (!self::$user["id"]) {
//trying to restore previous user session
$r = db::q("SELECT `id`,`stat`,`rights`,`dlog`,`dlast`,`dreg`,`name`,`email`,`display` FROM " . db::tnm(self::$class) . " WHERE `stat`=1 AND `ses`='" . db::esc($cookie) . "'", true);
$rows = db::rows($r);
if ($rows) {
if ($rows > 1) {
//system integrity error(!): deleting all sessions
db::q("UPDATE " . db::tnm(self::$class) . " SET `ses`='' WHERE `ses`='" . db::esc($cookie) . "'", false);
$cookie = "";
} else {
self::$user = db::fetch($r);
self::$user["admn"] = @substr(self::$user["rights"], 0, 1) === "1";
self::$user["id"] = 0 + self::$user["id"];
self::$user["dlast"] = 0 + self::$user["dlast"];
self::$user["dlog"] = 0 + self::$user["dlog"];
self::$user["dreg"] = 0 + self::$user["dreg"];
self::$user["stat"] = 0 + self::$user["stat"];
}
} else {
$cookie = "";
}
} else {
//de-authorizing the session on cookies not match
if ($cookie != self::$user["cookie"]) {
self::$user["id"] = 0;
}
}
}
//trying to start new user session
$log = false;
if ($u || $p) {
if (self::$user["id"]) {
msgr::add(_t("Ошибка: вход уже выполнен."), MSGR_TYPE_ERR);
} else {
$r = db::q("SELECT `id`,`stat`,`rights`,`dreg`,`dlog`,`dlast`,`name`,`email`,`display` FROM " . db::tnm(self::$class) . " WHERE `stat`=1 AND `name`='" . db::esc($name) . "' AND `pass`='" . @md5($name . $pass) . "'", true);
$row = db::fetch($r);
if (!$row) {
msgr::add(_t("Неверное имя пользователя или пароль") . "!", MSGR_TYPE_ERR);
$cookie = "";
} else {
$log = true;
self::$user = db::fetch($r);
self::$user["id"] = 0 + self::$user["id"];
self::$user["stat"] = 0 + self::$user["stat"];
self::$user["dreg"] = 0 + self::$user["dreg"];
self::$user["dlog"] = 0 + self::$user["dlog"];
self::$user["dlast"] = 0 + self::$user["dlast"];
self::$user["admn"] = @substr(self::$user["rights"], 0, 1) === "1";
$cookie = session_id();
}
}
}
//trying to connect to external user session
$srvs = self::$c->services(self::$class, self::$srvFuncs["user"]);
if (count($srvs)) {
//checking state of each external authorization system
//and searching for first which is authorized
$euser = false;
foreach ($srvs as $mod => $method) {
$user = @call_user_func_array(array(__NAMESPACE__ . "\\" . $mod, $method), array(self::$user["id"]));
if (!$euser && $user) {
$euser = $user;
}
if (self::$user["id"] && $user && $user["feid"] != self::$user["id"]) {
@call_user_func(array(__NAMESPACE__ . "\\" . $mod, self::$srvFuncs["logout"]));
if ($euser && $user["id"] == $euser["id"]) {
$euser = false;
}
}
}
//performing authorization, creating new user record if allowed
if ($euser) {
if (!self::$user["id"]) {
if (!$euser["feid"]) {
if (self::$config["external-autoreg"]) {
if (self::_insert($euser)) {
$id = 0 + db::iid();
if (!@call_user_func(array(__NAMESPACE__ . "\\" . $mod, self::$srvFuncs["register"]), $id)) {
self::_delete($id);
msgr::errorLog("Can't automatically register external user.", true, self::$class, "_check", __LINE__);
} else {
$euser["feid"] = $id;
}
} else {
msgr::errorLog("Can't automatically register the user: Error while creating the new record.", true, self::$class, "_check", __LINE__);
}
}
}
if ($euser["feid"]) {
$r = db::q("SELECT `id`,`stat`,`rights`,`dreg`,`dlog`,`dlast`,`name`,`email`,`display` FROM " . db::tnm(self::$class) . " WHERE `stat`=1 AND `id`='" . $euser["feid"], true);
$row = db::fetch($r);
if (!$row) {
$cookie = "";
}
$log = true;
self::$user = db::fetch($r);
self::$user["id"] = 0 + self::$user["id"];
self::$user["stat"] = 0 + self::$user["stat"];
self::$user["dreg"] = 0 + self::$user["dreg"];
self::$user["dlog"] = 0 + self::$user["dlog"];
self::$user["dlast"] = 0 + self::$user["dlast"];
self::$user["admn"] = @substr(self::$user["rights"], 0, 1) === "1";
$cookie = session_id();
}
}
}
}
//saving final data
self::_cookie($cookie);
if (self::$user["id"]) {
if ($log) {
self::$user["dlog"] = $dt;
}
self::$user["dlast"] = $dt;
self::$user["cookie"] = $cookie;
db::q("UPDATE " . db::tnm(self::$class) . " SET " . ($log ? "`ses`='" . $cookie . "'" : "") . ($u ? "`dtlog`='" . $dtS . "' AND " : "") . "`dtlast`='" . $dtS . "' WHERE `id`=" . self::$user["id"], false);
return true;
} else {
self::_userReset();
return false;
}
}
function observerMemory()
{
$cookie = cookie::get(md5(SERVER));
if ($cookie) {
$err = false;
list($username, $userid, $hash) = explode(',', $cookie);
$userid = intval($userid);
db::table('users');
db::where('user_id', $userid);
$row = db::assoc();
$word = 'legenda';
if (md5($row['user_login'] . $word) != $hash) {
$err = true;
}
if (db::rows() == 0) {
$err = true;
}
if ($err) {
unset($_SESSION['WEB_AUTH']);
$_SESSION['WEB_NO_AUTH'] = 1;
headers::self();
} else {
webUser::setAuth($userid);
headers::self();
}
} else {
$_SESSION['WEB_NO_AUTH'] = 1;
}
}
function observerMemory()
{
$cookie = cookie::get(self::$auth_cookie_name);
if ($cookie) {
$err = false;
list($username, $userid, $hash) = explode(',', $cookie);
$userid = intval($userid);
db::table('admin_users');
db::where('user_id', $userid);
$row = db::assoc();
$word = 'legenda';
if (md5($row['user_login'] . $word) != $hash) {
$err = true;
}
if (db::rows() == 0) {
$err = true;
}
if ($err) {
self::logout();
} else {
$_SESSION['ADMIN_AUTH'] = 1;
$_SESSION['ADMIN_USER_ID'] = $userid;
headers::self();
}
}
}
function add()
{
events::observe('add', 'pages', 'addPage');
events::observer();
if (events::detect('add')) {
return true;
}
if (events::detect('parent')) {
$parent = events::get('parent');
db::table('pages');
db::where('page_id', $parent);
db::update('page_child', '1');
f::set('page_parent', $parent);
}
admin::components('tabs', 'validator', 'upload');
if (settings::get('pages', 'redactor')) {
admin::components('redactor');
s::section('redactor');
}
appPages::getPagesSelect(ADMIN_SITE_ID);
appPages::getParentPages(ADMIN_SITE_ID, true);
appTemplates::getTmpls(ADMIN_SITE_ID);
// test reserved
db::table('admin_reserved');
db::where('`table`', 'pages');
db::where('user_id', ADMIN_USER_ID);
$page_id = db::get('id');
if (db::rows() == 0) {
db::table('pages');
$array = array('page_date' => 'NOW()', 'page_pub' => '2', 'page_handler' => '0', 'page_dynamic' => '0', 'page_cache' => '0', 'page_map' => '0', 'page_child' => '0', 'page_level' => 0, 'site_id' => ADMIN_SITE_ID);
db::smartInsert($array);
$page_id = mysql_insert_id();
db::table('admin_reserved');
db::insert('', 'pages', $page_id, ADMIN_USER_ID);
}
f::set('page_id', $page_id);
}
function saveVersion($app, $tmpl_file, $code)
{
db::table('templates_versions');
db::where('app', $app);
db::where('tmpl_file', $tmpl_file);
db::where('version_code', $code);
db::order('version_date', 'DESC');
db::limit(1);
db::select();
if (db::rows() == 0) {
/*
delete over 10
*/
db::table('templates_versions');
db::where('app', $app);
db::where('tmpl_file', $tmpl_file);
db::order('version_date', 'DESC');
db::limit(10, 100);
db::delete();
db::table('templates_versions');
db::insert('', 'NOW()', $code, $app, $tmpl_file, 0, ADMIN_SITE_ID);
}
}
function deleteFilesFile()
{
db::table('catalog_items_files');
db::where('file_id', params::get('file_id'));
$a = db::assoc();
if (db::rows() != 0) {
self::deleteFilesFileForce($a);
}
}
function showSection()
{
$section_id = web::getThis();
$item_id = web::getEvent();
if ($item_id !== false) {
buffer::setTmpl('card.html');
self::showCard($item_id, $section_id);
return false;
}
$dir = IMAGES_ROOT . 'sections/';
$dir_path = IMAGES_PATH . 'sections/';
db::table('catalog_sections');
db::where('section_id', $section_id);
$section = db::assoc();
if (db::rows() == 0) {
web::error404();
}
s::set($section);
s::set('page_title', $section['section_name']);
s::set('page_header', $section['section_name']);
$file = $dir . $section['section_id'] . '.jpg';
if (file_exists($file)) {
s::set('section_img', '<img src="' . $dir_path . $section['section_id'] . '.jpg' . '" />');
}
db::table('catalog_items');
db::where('section_id', $section_id);
$r = db::select('item_name', 'item_id', 'item_desc');
$i = 0;
while ($a = mysql_fetch_assoc($r)) {
$i++;
if ($i % 2) {
s::roll('items1', $a);
} else {
s::roll('items2', $a);
}
}
}
function getInfoByLogin($user_login, $name = false)
{
db::table('users');
db::where('user_pub', '1');
db::where('user_login', $user_login);
$user = db::assoc();
if (db::rows() == 0) {
return false;
} else {
if ($name === false) {
return $user;
} else {
if (isset($user[$name])) {
return $user[$name];
} else {
return false;
}
}
}
}
function displayTopRated()
{
global $qs, $lc, $rowl, $link_shortcodes, $from, $linkspage_pref;
global $LINK_RATED_RATING, $LINK_RATED_APPEND;
$db = e107::getDb();
$mes = e107::getMessage();
$template = e107::getTemplate('links_page', 'links_page');
$tp = e107::getParser();
$number = isset($linkspage_pref["link_nextprev_number"]) && $linkspage_pref["link_nextprev_number"] ? $linkspage_pref["link_nextprev_number"] : "20";
$np = $linkspage_pref["link_nextprev"] ? "LIMIT " . intval($from) . "," . intval($number) : "";
$catrate = isset($qs[1]) && is_numeric($qs[1]) ? " AND l.link_category='" . $qs[1] . "' " : "";
$ratemin = isset($linkspage_pref['link_rating_minimum']) && $linkspage_pref['link_rating_minimum'] ? $linkspage_pref['link_rating_minimum'] : "0";
$qry = "\n\tSELECT l.*, r.*, lc.link_category_id, lc.link_category_name, (r.rate_rating / r.rate_votes) as rate_avg\n\tFROM #rate AS r\n\tLEFT JOIN #links_page AS l ON l.link_id = r.rate_itemid\n\tLEFT JOIN #links_page_cat AS lc ON lc.link_category_id = l.link_category\n\tWHERE l.link_active = 1 AND l.link_class REGEXP '" . e_CLASS_REGEXP . "' " . $catrate . " AND lc.link_category_class REGEXP '" . e_CLASS_REGEXP . "' AND r.rate_table='links_page'\n\tORDER BY rate_avg DESC\n\t";
$qry2 = $qry . " " . $np;
if (!is_object($db)) {
$db = new db();
}
$linktotalrated = $db->gen($qry);
if (!($ratedlinks = $db->gen($qry2))) {
$navigator = displayNavigator();
$navigator .= displaySortOrder();
$var = array('ERROR_MESSAGE' => LAN_LINKS_33);
$error = $tp->simpleParse($template['LINK_ERROR_MESSAGE'], $var);
$text = $navigator . $error;
e107::getRender()->tablerender(LAN_LINKS_11, $text);
} else {
$link_rated_table_string = "";
$list = $db->rows();
foreach ($list as $rowl) {
if ($rowl['rate_avg'] > $ratemin) {
$cat = $rowl['link_category_name'];
$LINK_RATED_APPEND = $lc->parse_link_append($rowl);
$LINK_RATED_RATING = $tp->parseTemplate('{LINK_RATED_RATING}', FALSE, $link_shortcodes);
$link_rated_table_string .= $tp->parseTemplate($template['LINK_RATED_TABLE'], FALSE, $link_shortcodes);
}
}
$link_rated_table_start = $tp->parseTemplate($template['LINK_RATED_TABLE_START'], FALSE, $link_shortcodes);
$link_rated_table_end = $tp->parseTemplate($template['LINK_RATED_TABLE_END'], FALSE, $link_shortcodes);
if (isset($qs[1])) {
$captioncat = " : " . LAN_LINKS_40 . " : " . $cat;
}
$caption = LAN_LINKS_11 . " " . (isset($captioncat) ? $captioncat : "");
$text = $link_rated_table_start . $link_rated_table_string . $link_rated_table_end;
$navigator = displayNavigator();
$pagination = $lc->ShowNextPrev($from, $number, $linktotalrated);
$text = $navigator . $text . $pagination;
e107::getRender()->tablerender($caption, $text);
}
}
function sql($mode)
{
switch ($mode) {
case 'i':
self::$sql = "INSERT `" . self::$table . "` VALUES (" . self::$values . "); ";
self::query(self::$sql);
break;
case 's':
self::$res = self::query(self::selectSql());
if (!self::$res) {
return false;
}
self::$rows = mysql_num_rows(self::$res);
return self::$res;
break;
case 'assoc':
self::$res = self::query(self::selectSql());
if (!self::$res) {
return false;
}
self::$rows = mysql_num_rows(self::$res);
return mysql_fetch_assoc(self::$res);
break;
case 'get':
self::$res = self::query(self::selectSql());
if (!self::$res) {
return false;
}
self::$rows = mysql_num_rows(self::$res);
$row = mysql_fetch_assoc(self::$res);
return $row[self::$assoc_get];
break;
case 'u':
self::$sql = "UPDATE `" . self::$table . "` SET " . self::$values . " " . self::buildWhere() . "";
self::query(self::$sql);
break;
case 'd':
self::$sql = "DELETE FROM `" . self::$table . "` " . self::buildWhere() . " " . self::$order . " " . self::$limit . "";
self::query(self::$sql);
break;
case 'c':
self::$sql = "CREATE TABLE `" . self::$table . "` (\r\n\t\t\t\t" . self::$create_fields . "\r\n\t\t\t\t) CHARACTER SET " . self::$c_charset . " COLLATE " . self::$c_charset_col . ";";
self::query(self::$sql);
break;
case 'drop':
self::$sql = "DROP TABLE IF EXISTS `" . self::$table . "`";
self::query(self::$sql);
break;
case 'truncate':
self::$sql = "TRUNCATE TABLE `" . self::$table . "`";
self::query(self::$sql);
break;
}
}
