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