public function edit_item()
{
$sql = new MySQLObject();
if ($sql->query("\r\nSELECT `header`,`link`,`show`\r\nFROM " . $sql->table('menu') . "\r\nWHERE (`iid` = " . intval($_GET['iid']) . ")") && $sql->num() > 0) {
$item = $sql->fetch_one();
global $tpl, $cfg;
$tpl->assign(array('ITEM.HEADER' => $item->header, 'ITEM.LINK' => $item->link, 'ITEM.SHOW_TRUE' => $item->show == 1 ? $cfg['tpl']['checked'] : '', 'ITEM.SHOW_FALSE' => $item->show == 0 ? $cfg['tpl']['checked'] : ''));
}
}
public function tree_get($parent, $selectbox = false, $addpage = false)
{
$items = array();
global $q;
$sql = new MySQLObject();
if ($sql->query("SELECT `pid`,`header` FROM " . $q->table('pages') . " WHERE (`parent` = " . intval($parent) . ") ORDER BY `header` ASC")) {
if ($parent == -1 && $sql->num() == 0) {
global $tpl;
$tpl->assign('INFOBAR', true, 'if');
$tpl->assign('INFOBAR', '{L_PAGES_NO_PAGES}');
}
$i = 0;
foreach ($sql->fetch() as $item) {
if (!$selectbox || $addpage || $item->pid != intval($_GET['pid'])) {
$items[$i]['this'] = $item;
$items[$i]['childs'] = $this->tree_get($item->pid, $selectbox, $addpage ? true : false);
$i++;
}
}
}
return $items;
}
if ($count > 0) {
$sql = new MySQLObject();
$query = "\r\nSELECT `code`,`type`,`date`,`name`,`modules`\r\nFROM " . $sql->table('updates_global') . "\r\nWHERE\r\n(";
$i = 0;
foreach ($modules as $module) {
$query .= "\r\n\t`modules` LIKE '%" . $module . "%'";
if ($i < $count - 1) {
$query .= " OR ";
}
$i++;
}
$query .= "\r\n)\r\nORDER BY `date` ASC";
if (!$sql->query($query)) {
echo 'ERROR';
} else {
if (!$sql->num()) {
echo 'NO_UPDATES';
} else {
$installed = array();
foreach ($xml->installed->children() as $update) {
$update = $update->getAttributesArray(array('code'));
$installed[] = $update['code'];
}
$xml = '<?xml version="1.0" encoding="utf-8"?>
<root>' . '<updates>';
$updates = 0;
foreach ($sql->fetch() as $update) {
if (!in_array($update->code, $installed)) {
$xml .= '<update type="' . $update->type . '">' . '<code>' . $update->code . '</code>' . '<name>' . $update->name . '</name>' . '<modules>' . $update->modules . '</modules>' . '</update>';
$updates++;
}
function mainmenu_getorder()
{
$sql = new MySQLObject();
if ($sql->query("SELECT `order` FROM " . $sql->table('menu') . " ORDER BY `order` DESC LIMIT 0,1")) {
if ($sql->num() > 0) {
$order = $sql->fetch_one();
return $order->order;
} else {
return 0;
}
} else {
return false;
}
}
public function counts()
{
global $q, $tpl;
$sql = new MySQLObject();
if ($sql->query("SELECT `uid` FROM " . $q->table('users'))) {
if (!$sql->num()) {
$tpl->assign('USERS_COUNT', '0');
} else {
$tpl->assign('USERS_COUNT', $sql->num());
}
}
if ($sql->query("SELECT `gid` FROM " . $q->table('users_groups'))) {
if (!$sql->num()) {
$tpl->assign('GROUPS_COUNT', '0');
} else {
$tpl->assign('GROUPS_COUNT', $sql->num());
}
}
}
public function acp_tag_edit()
{
if (isset($_GET['tag'])) {
$sql = new MySQLObject();
if ($sql->query("SELECT `header`,`tag` FROM " . $sql->table('blog_tags') . " WHERE (`tag` = '" . $sql->escape($_GET['tag']) . "')") && $sql->num() > 0) {
$tag = $sql->fetch_one();
global $tpl;
$tpl->assign(array('TAG.HEADER' => $tag->header, 'TAG.TAG' => $tag->tag));
}
}
}
